{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Книга 1","Книга 2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Книга 1","index":0,"n_rows":82,"n_cols":32,"rows_kept":82,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,4,13],[4,14,4,26],[4,31,5,31]]}
["Для примера поместил в один файл"]
["Книга 1 - донор",null,null,"Необходимо перенести данные начиная с Янв.20 по показателям из диапазона в книге 2(Ячейки A2:A3) друг за другом по условию, описанному в сообщении темы"]
["Книга 2 - рецепиент"]
[]
["Продукт",2020,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,2022,2023,2024,null,"Показатель"]
[null,"2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","всего 2020","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","всего 2021","всего 2022","всего 2023","всего 2024"]
["Продукт 1",59,21,39,24,42,19,41,58,1,36,46,15,401,28,48,99,99,43,30,31,63,77,80,96,20,714,87,6,92,null,"Показатель 1"]
["Продукт 2",40,28,82,68,9,100,94,76,52,92,53,37,731,82,20,81,55,62,16,46,54,92,2,77,52,639,9,90,56,null,"Показатель 1"]
["Продукт 3",83,37,81,62,61,50,10,7,4,93,89,50,627,80,58,20,21,94,74,49,19,20,59,16,30,540,65,63,57,null,"Показатель 1"]
["Продукт 4",71,6,59,32,94,19,64,87,89,15,62,93,691,1,61,38,7,13,98,69,97,89,15,12,22,522,98,9,11,null,"Показатель 1"]
["Продукт 5",28,62,24,27,5,27,81,23,89,23,33,75,497,13,46,48,51,2,68,18,79,85,42,54,35,541,89,85,95,null,"Показатель 1"]
["Продукт 6",44,84,13,55,74,86,62,41,77,30,68,65,699,94,11,95,20,44,93,98,75,20,88,33,66,737,99,10,62,null,"Показатель 1"]
["Продукт 7",93,54,15,38,3,58,83,1,33,7,5,1,391,42,95,99,97,64,90,98,100,44,28,69,66,892,1,85,37,null,"Показатель 1"]
["Продукт 8",99,97,19,53,5,44,54,46,49,23,43,84,616,12,9,60,97,79,96,2,99,13,53,62,63,645,83,32,21,null,"Показатель 1"]
["Продукт 9",13,91,93,79,11,34,76,27,15,59,32,70,600,70,3,41,92,22,100,53,77,12,40,20,70,600,19,93,14,null,"Показатель 1"]
["Продукт 10",83,38,61,56,38,48,3,3,78,12,23,56,499,12,62,1,47,19,26,22,10,1,41,26,31,298,6,97,59,null,"Показатель 1"]
[]
["Продукт 1",8,10,67,56,11,82,4,13,40,45,48,38,422,81,26,67,32,35,36,9,82,30,9,50,72,529,100,34,34,null,"Показатель 2"]
["Продукт 2",26,12,13,97,73,8,61,85,5,19,61,93,553,91,48,64,8,51,66,22,90,44,5,99,77,665,35,49,61,null,"Показатель 2"]
["Продукт 3",100,52,30,11,20,80,56,37,8,17,91,92,594,68,98,79,42,71,2,16,78,20,89,72,36,671,57,97,4,null,"Показатель 2"]
["Продукт 4",74,50,4,56,30,42,4,66,35,18,60,54,493,94,75,78,66,42,16,14,32,20,13,14,68,532,99,21,70,null,"Показатель 2"]
["Продукт 5",50,33,77,61,49,85,99,94,6,97,32,26,709,7,62,63,50,97,51,38,95,49,28,47,64,651,27,99,68,null,"Показатель 2"]
["Продукт 6",39,22,4,96,54,88,6,9,79,63,65,27,552,3,22,100,31,47,48,4,93,81,22,62,68,581,67,41,87,null,"Показатель 2"]
["Продукт 7",32,11,29,26,83,41,15,74,75,72,26,25,509,69,95,57,89,48,25,4,68,72,84,7,43,661,46,91,15,null,"Показатель 2"]
["Продукт 8",40,66,23,39,62,15,52,1,62,7,87,73,527,38,37,23,8,84,56,5,8,66,21,62,3,411,54,33,11,null,"Показатель 2"]
["Продукт 9",34,63,18,29,61,14,5,55,59,15,35,76,464,6,35,19,91,72,50,52,2,85,76,50,45,583,73,46,94,null,"Показатель 2"]
["Продукт 10",17,34,91,59,57,31,75,80,89,55,56,66,710,40,100,68,48,48,58,67,11,27,2,85,28,582,76,62,39,null,"Показатель 2"]
[]
["Продукт 1",51,26,15,28,63,80,37,28,31,98,35,5,497,6,63,33,42,72,22,9,38,38,12,100,34,469,7,52,1,null,"Показатель 3"]
["Продукт 2",31,41,20,20,47,98,73,91,75,47,18,93,654,74,78,73,16,98,5,44,11,38,2,60,85,584,4,42,41,null,"Показатель 3"]
["Продукт 3",96,34,53,7,15,63,28,92,99,14,61,88,650,77,49,16,17,46,76,55,78,66,30,24,27,561,21,2,79,null,"Показатель 3"]
["Продукт 4",79,73,73,50,3,31,3,4,6,26,53,82,483,96,1,99,34,1,47,71,25,34,71,33,3,515,45,98,93,null,"Показатель 3"]
["Продукт 5",98,74,47,26,76,49,79,31,12,46,98,75,711,100,91,87,32,17,3,12,79,49,25,75,93,663,96,78,83,null,"Показатель 3"]
["Продукт 6",66,21,81,73,56,65,91,74,17,75,72,49,740,55,4,96,45,32,45,34,42,11,69,2,52,487,68,22,47,null,"Показатель 3"]
["Продукт 7",15,25,98,95,52,11,36,29,11,48,95,25,540,6,20,42,59,54,47,28,11,61,76,11,50,465,2,19,42,null,"Показатель 3"]
["Продукт 8",46,46,52,23,73,55,36,21,40,46,21,40,499,15,70,17,36,99,42,64,63,71,26,63,32,598,73,4,59,null,"Показатель 3"]
["Продукт 9",33,39,76,27,63,48,26,81,16,48,9,56,522,56,96,76,58,99,33,19,71,5,45,92,47,697,27,36,60,null,"Показатель 3"]
["Продукт 10",1,78,49,25,33,16,2,35,98,35,35,100,507,10,4,36,86,51,46,15,20,99,55,16,37,475,23,88,93,null,"Показатель 3"]
[]
["Продукт 1",23,93,66,9,91,10,1,36,70,6,19,93,517,18,36,69,100,100,13,33,91,74,23,81,68,706,43,58,90,null,"Показатель 4"]
["Продукт 2",87,54,22,17,2,11,92,30,26,27,67,80,515,90,93,29,75,80,80,29,66,51,47,83,69,792,89,47,43,null,"Показатель 4"]
["Продукт 3",11,62,4,67,60,73,82,50,31,33,46,86,605,59,22,78,99,70,77,92,61,59,94,82,16,809,98,69,47,null,"Показатель 4"]
["Продукт 4",24,34,22,29,100,76,56,36,87,36,14,55,569,100,1,61,13,10,96,96,44,73,31,47,38,610,35,71,33,null,"Показатель 4"]
["Продукт 5",34,13,64,30,82,4,73,98,64,66,91,47,666,55,21,88,51,3,59,69,33,10,20,90,83,582,41,48,62,null,"Показатель 4"]
["Продукт 6",8,48,91,51,57,44,85,29,27,66,21,18,545,76,88,8,45,67,99,61,73,71,95,86,86,855,27,92,29,null,"Показатель 4"]
["Продукт 7",20,97,57,7,27,50,16,25,96,86,36,89,606,6,92,62,35,45,31,93,38,89,74,72,68,705,61,58,96,null,"Показатель 4"]
["Продукт 8",5,42,2,69,83,18,1,61,41,57,3,37,419,68,90,19,39,46,78,35,50,21,14,62,55,577,59,52,28,null,"Показатель 4"]
["Продукт 9",74,18,54,43,51,97,100,44,55,8,55,97,696,12,39,52,41,74,33,89,72,67,5,88,47,619,100,16,11,null,"Показатель 4"]
["Продукт 10",78,81,36,24,34,1,42,16,69,98,17,85,581,18,44,36,42,6,2,89,50,73,5,82,11,458,25,71,6,null,"Показатель 4"]
[]
["Продукт 1",78,65,30,86,29,72,22,25,4,13,79,48,551,22,49,8,98,89,48,76,51,46,19,43,17,566,2,43,22,null,"Показатель 5"]
["Продукт 2",93,94,50,87,71,32,93,19,66,86,96,91,878,39,42,92,31,67,64,18,78,56,97,38,61,683,42,71,12,null,"Показатель 5"]
["Продукт 3",91,32,78,32,13,78,92,72,57,69,21,20,655,28,60,46,22,79,68,10,22,7,83,75,78,578,94,27,82,null,"Показатель 5"]
["Продукт 4",89,18,68,83,15,19,20,33,6,95,23,62,531,82,22,72,35,79,64,100,22,69,41,29,72,687,39,98,69,null,"Показатель 5"]
["Продукт 5",60,11,58,31,19,24,38,40,15,95,72,64,527,70,21,4,42,75,52,40,73,6,37,76,13,509,39,26,17,null,"Показатель 5"]
["Продукт 6",66,28,63,30,43,63,86,73,7,36,10,36,541,58,79,61,52,64,4,44,67,54,1,34,14,532,22,14,79,null,"Показатель 5"]
["Продукт 7",76,5,23,18,4,44,52,95,93,43,45,83,581,76,57,21,33,49,22,2,10,100,100,93,55,618,54,58,85,null,"Показатель 5"]
["Продукт 8",14,79,82,48,21,97,69,95,25,39,45,7,621,59,51,65,33,34,98,41,33,49,38,54,41,596,50,90,73,null,"Показатель 5"]
["Продукт 9",73,32,92,10,39,38,61,83,45,97,76,78,724,67,45,84,36,14,1,28,78,4,53,41,86,537,58,90,11,null,"Показатель 5"]
["Продукт 10",51,87,53,8,87,43,26,29,6,95,18,90,593,55,16,91,15,35,95,8,15,75,11,28,12,456,82,49,15,null,"Показатель 5"]
[]
["Продукт 1",91,69,75,5,45,84,34,93,39,37,26,52,650,41,27,51,25,66,30,53,15,16,77,20,49,470,21,6,43,null,"Показатель 6"]
["Продукт 2",50,35,60,98,55,29,39,8,45,15,70,97,601,34,33,96,34,29,40,49,17,59,22,78,4,495,89,11,34,null,"Показатель 6"]
["Продукт 3",27,98,60,84,67,60,80,23,9,94,22,20,644,1,96,84,62,78,6,31,51,74,17,89,80,669,100,14,26,null,"Показатель 6"]
["Продукт 4",66,40,29,23,33,36,84,90,4,14,100,69,588,37,35,64,30,71,85,54,90,51,24,35,68,644,48,93,16,null,"Показатель 6"]
["Продукт 5",58,55,27,62,87,33,49,67,88,19,89,57,691,77,24,28,27,51,83,95,86,26,9,59,8,573,25,63,43,null,"Показатель 6"]
["Продукт 6",34,77,97,81,52,33,91,81,45,95,92,89,867,49,48,35,77,85,86,49,91,56,10,59,47,692,41,35,80,null,"Показатель 6"]
["Продукт 7",89,83,19,43,55,44,96,54,100,42,22,35,682,29,47,91,9,56,48,44,8,37,9,67,77,522,60,14,68,null,"Показатель 6"]
["Продукт 8",92,42,49,22,14,94,20,27,19,23,49,48,499,55,34,98,25,41,87,21,64,8,64,93,83,673,30,24,99,null,"Показатель 6"]
["Продукт 9",8,78,7,41,18,30,94,27,95,79,7,87,571,1,74,100,32,37,34,83,44,94,32,63,41,635,7,5,79,null,"Показатель 6"]
["Продукт 10",11,31,84,46,29,65,30,59,20,62,39,28,504,49,53,42,79,73,53,55,69,68,82,44,15,682,12,53,53,null,"Показатель 6"]
[]
["Продукт 1",36,47,100,79,33,96,62,68,51,46,3,58,679,58,21,84,30,32,37,83,26,31,68,88,68,626,24,54,30,null,"Показатель 7"]
["Продукт 2",39,40,85,100,63,96,14,73,20,77,57,31,695,62,57,69,31,51,54,43,37,96,86,52,49,687,89,82,2,null,"Показатель 7"]
["Продукт 3",74,55,10,12,5,24,63,59,27,45,26,61,461,90,60,57,92,55,50,8,67,8,48,42,9,586,22,32,17,null,"Показатель 7"]
["Продукт 4",17,80,22,52,57,16,96,13,57,38,91,90,629,63,49,58,15,76,41,66,36,95,53,12,4,568,37,51,22,null,"Показатель 7"]
["Продукт 5",27,35,8,51,32,100,92,61,5,75,74,80,640,68,87,24,5,33,8,34,31,36,97,83,38,544,17,59,49,null,"Показатель 7"]
["Продукт 6",70,20,73,19,50,75,88,92,60,36,72,44,699,94,45,35,5,77,61,26,29,42,68,10,6,498,60,10,78,null,"Показатель 7"]
["Продукт 7",61,84,7,67,91,62,4,97,63,95,30,7,668,22,87,68,8,70,83,27,81,94,71,72,66,749,15,64,46,null,"Показатель 7"]
["Продукт 8",18,82,66,57,8,2,20,38,28,26,77,17,439,41,15,20,21,59,41,48,70,31,36,68,97,547,14,23,79,null,"Показатель 7"]
["Продукт 9",58,92,54,84,84,18,27,59,76,80,36,70,738,54,91,80,100,53,49,88,45,9,36,46,61,712,47,90,66,null,"Показатель 7"]
["Продукт 10",46,36,1,42,78,68,40,55,37,20,79,90,592,10,20,9,31,39,39,53,63,54,78,5,23,424,82,87,21,null,"Показатель 7"]

{"sheet":"Книга 2","index":1,"n_rows":7,"n_cols":32,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,0,6,0],[5,1,5,13],[5,14,5,26],[5,31,6,31]]}
["Необходимые показатели"]
["Показатель 2"]
["Показатель 4"]
[]
[]
["Продукт",2020,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,2022,2023,2024,null,"Показатель"]
[null,"2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","всего 2020","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","всего 2021","всего 2022","всего 2023","всего 2024"]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}