{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист2","Лист1","Должно быть так"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":3},"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":"Лист2","index":0,"n_rows":260,"n_cols":9,"rows_kept":260,"cut":false,"hidden":false,"merged":[]}
["Месяц","Наименование","Код"]
[7,"Костюм",21120707]
[7,"Футболка",21133384,null,null,"Наименование","Код","Месяц","Количество по полю Код"]
[7,"Белье нат",21129070,null,null,"Белье нат",21129070,2,1]
[7,"Гол убор ",21129673,null,null,null,null,7,2]
[7,"Ботинки кож",21126544,null,null,null,null,"++",1]
[7,"Каска",21129660,null,null,null,21129071,1,3]
[7,"Подшлемник",21129678,null,null,null,null,2,4]
[7,"Костюм",21120707,null,null,null,null,7,2]
[7,"Футболка",21133384,null,null,null,null,12,1]
[7,"Белье нат",21129070,null,null,null,21129072,7,1]
[7,"Гол убор ",21129673,null,null,null,21129075,1,8]
[7,"Ботинки кож",21126542,null,null,null,null,2,3]
[7,"Каска",21129660,null,null,null,null,3,5]
[7,"Подшлемник",21129678,null,null,null,null,4,2]
[2,"Костюм",21120707,null,null,null,null,7,1]
[2,"Футболка",21133384,null,null,null,21129076,3,1]
[2,"Белье нат",21129070,null,null,null,21129078,3,1]
[2,"Гол убор ",21129673,null,null,null,21129079,7,1]
[2,"Ботинки кож",21126544,null,null,"Белье нат Итог",null,null,37]
[2,"Каска",1.1499999999999999,null,null,"Ботинки кож",21126542,7,1]
[2,"Подшлемник",21129678,null,null,null,21126543,2,1]
[3,"Костюм",21120707,null,null,null,null,3,2]
[3,"Футболка",21133384,null,null,null,null,"++",1]
[3,"Белье нат",21129075,null,null,null,21126544,1,5]
[3,"Гол убор ",21129674,null,null,null,null,2,4]
[3,"Ботинки кож",21126544,null,null,null,null,3,3]
[3,"Каска",21129660,null,null,null,null,4,2]
[3,"Подшлемник",21129678,null,null,null,null,7,3]
[1,"Костюм",21120708,null,null,null,21126545,1,6]
[1,"Футболка",21133385,null,null,null,null,2,2]
[1,"Белье нат",21129071,null,null,null,null,3,2]
[1,"Гол убор ",21129672,null,null,null,null,7,2]
[1,"Ботинки кож",21126544,null,null,null,21126546,7,1]
[1,"Каска",1.1499999999999999,null,null,null,21126643,12,1]
[1,"Подшлемник",21129677,null,null,null,21126644,2,1]
[1,"Костюм",21120708,null,null,"Ботинки кож Итог",null,null,37]
[1,"Футболка",21133384,null,null,"Гол убор ",21129672,1,1]
[1,"Белье нат",21129071,null,null,null,null,2,1]
[1,"Гол убор ",21129675,null,null,null,21129673,1,2]
[1,"Ботинки кож",21126544,null,null,null,null,2,1]
[1,"Каска",1.1499999999999999,null,null,null,null,3,1]
[1,"Подшлемник",21129679,null,null,null,null,4,2]
[7,"Костюм",21120708,null,null,null,null,7,2]
[7,"Футболка",21133384,null,null,null,21129674,1,5]
[7,"Белье нат",21129071,null,null,null,null,2,4]
[7,"Гол убор ",21129674,null,null,null,null,3,6]
[7,"Ботинки кож",21126544,null,null,null,null,7,5]
[7,"Каска",21129660,null,null,null,null,12,1]
[7,"Подшлемник",21129678,null,null,null,21129675,1,3]
[2,"Костюм",21120708,null,null,null,null,2,2]
[2,"Футболка",21133384,null,null,null,null,"++",1]
[2,"Белье нат",21129071,null,null,"Гол убор  Итог",null,null,37]
[2,"Гол убор ",21129674,null,null,"Каска",1.1499999999999999,1,3]
[2,"Ботинки кож",21126543,null,null,null,null,2,1]
[2,"Каска",21129660,null,null,null,null,"++",1]
[2,"Подшлемник",21129678,null,null,null,2.15,2,1]
[7,"Костюм",21120708,null,null,null,3.15,3,1]
[7,"Футболка",21133385,null,null,null,4.1500000000000004,4,1]
[7,"Белье нат",21129071,null,null,null,21129660,1,8]
[7,"Гол убор ",21129674,null,null,null,null,2,6]
[7,"Ботинки кож",21126545,null,null,null,null,3,6]
[7,"Каска",21129660,null,null,null,null,4,1]
[7,"Подшлемник",21129678,null,null,null,null,7,7]
[1,"Костюм",21120708,null,null,null,null,12,1]
[1,"Футболка",21133385,null,null,"Каска Итог",null,null,37]
[1,"Белье нат",21129071,null,null,"Костюм",21120707,2,1]
[1,"Гол убор ",21129674,null,null,null,null,3,1]
[1,"Ботинки кож",21126545,null,null,null,null,7,2]
[1,"Каска",21129660,null,null,null,21120708,1,3]
[1,"Подшлемник",21129678,null,null,null,null,2,2]
["++","Костюм",21120708,null,null,null,null,7,2]
["++","Футболка",21133384,null,null,null,null,"++",1]
["++","Белье нат",21129070,null,null,null,21120709,3,1]
["++","Гол убор ",21129675,null,null,null,null,7,1]
["++","Ботинки кож",21126543,null,null,null,21120713,1,2]
["++","Каска",1.1499999999999999,null,null,null,null,3,3]
["++","Подшлемник",21129679,null,null,null,21120714,1,6]
[2,"Костюм",21120708,null,null,null,null,2,4]
[2,"Футболка",21133385,null,null,null,null,3,1]
[2,"Белье нат",21129071,null,null,null,null,4,2]
[2,"Гол убор ",21129675,null,null,null,null,7,1]
[2,"Ботинки кож",21126544,null,null,null,21120719,3,1]
[2,"Каска",2.15,null,null,null,21120720,7,1]
[2,"Подшлемник",21129679,null,null,null,21121536,2,1]
[7,"Костюм",21120709,null,null,null,null,12,1]
[7,"Футболка",21133386,null,null,"Костюм Итог",null,null,37]
[7,"Белье нат",21129072,null,null,"Подшлемник",21129677,1,1]
[7,"Гол убор ",21129674,null,null,null,null,2,1]
[7,"Ботинки кож",21126545,null,null,null,21129678,1,7]
[7,"Каска",21129660,null,null,null,null,2,5]
[7,"Подшлемник",21129678,null,null,null,null,3,7]
[3,"Костюм",21120709,null,null,null,null,4,2]
[3,"Футболка",21133389,null,null,null,null,7,7]
[3,"Белье нат",21129076,null,null,null,null,12,1]
[3,"Гол убор ",21129674,null,null,null,21129679,1,3]
[3,"Ботинки кож",21126545,null,null,null,null,2,2]
[3,"Каска",3.15,null,null,null,null,"++",1]
[3,"Подшлемник",21129678,null,null,"Подшлемник Итог",null,null,37]
[3,"Костюм",21120713,null,null,"Футболка",5.15,1,1]
[3,"Футболка",21133388,null,null,null,null,7,2]
[3,"Белье нат",21129075,null,null,null,21133384,1,1]
[3,"Гол убор ",21129674,null,null,null,null,2,2]
[3,"Ботинки кож",21126543,null,null,null,null,3,1]
[3,"Каска",21129660,null,null,null,null,7,3]
[3,"Подшлемник",21129678,null,null,null,null,"++",1]
[3,"Костюм",21120713,null,null,null,21133385,1,2]
[3,"Футболка",21133388,null,null,null,null,2,3]
[3,"Белье нат",21129075,null,null,null,null,7,1]
[3,"Гол убор ",21129674,null,null,null,null,12,1]
[3,"Ботинки кож",21126544,null,null,null,21133386,7,1]
[3,"Каска",21129660,null,null,null,21133388,1,2]
[3,"Подшлемник",21129678,null,null,null,null,3,3]
[1,"Костюм",21120713,null,null,null,21133389,1,5]
[1,"Футболка",21133388,null,null,null,null,2,3]
[1,"Белье нат",21129075,null,null,null,null,3,2]
[1,"Гол убор ",21129675,null,null,null,null,4,2]
[1,"Ботинки кож",21126544,null,null,null,21133392,3,1]
[1,"Каска",21129660,null,null,"Футболка Итог",null,null,37]
[1,"Подшлемник",21129679,null,null,"Общий итог",null,null,259]
[1,"Костюм",21120713]
[1,"Футболка",21133388]
[1,"Белье нат",21129075]
[1,"Гол убор ",21129674]
[1,"Ботинки кож",21126544]
[1,"Каска",21129660]
[1,"Подшлемник",21129678]
[3,"Костюм",21120713]
[3,"Футболка",21133388]
[3,"Белье нат",21129075]
[3,"Гол убор ",21129674]
[3,"Ботинки кож",21126543]
[3,"Каска",21129660]
[3,"Подшлемник",21129678]
[4,"Костюм",21120714]
[4,"Футболка",21133389]
[4,"Белье нат",21129075]
[4,"Гол убор ",21129673]
[4,"Ботинки кож",21126544]
[4,"Каска",4.1500000000000004]
[4,"Подшлемник",21129678]
[7,"Костюм",21120714]
[7,"Футболка",5.15]
[7,"Белье нат",21129075]
[7,"Гол убор ",21129674]
[7,"Ботинки кож",21126544]
[7,"Каска",21129660]
[7,"Подшлемник",21129678]
[3,"Костюм",21120714]
[3,"Футболка",21133389]
[3,"Белье нат",21129075]
[3,"Гол убор ",21129674]
[3,"Ботинки кож",21126545]
[3,"Каска",21129660]
[3,"Подшлемник",21129678]
[2,"Костюм",21120714]
[2,"Футболка",21133385]
[2,"Белье нат",21129071]
[2,"Гол убор ",21129674]
[2,"Ботинки кож",21126544]
[2,"Каска",21129660]
[2,"Подшлемник",21129678]
[1,"Костюм",21120714]
[1,"Футболка",5.15]
[1,"Белье нат",21129075]
[1,"Гол убор ",21129674]
[1,"Ботинки кож",21126545]
[1,"Каска",21129660]
[1,"Подшлемник",21129678]
[2,"Костюм",21120714]
[2,"Футболка",21133389]
[2,"Белье нат",21129075]
[2,"Гол убор ",21129674]
[2,"Ботинки кож",21126545]
[2,"Каска",21129660]
[2,"Подшлемник",21129678]
[1,"Костюм",21120714]
[1,"Футболка",21133389]
[1,"Белье нат",21129075]
[1,"Гол убор ",21129673]
[1,"Ботинки кож",21126545]
[1,"Каска",21129660]
[1,"Подшлемник",21129678]
[4,"Костюм",21120714]
[4,"Футболка",21133389]
[4,"Белье нат",21129075]
[4,"Гол убор ",21129673]
[4,"Ботинки кож",21126544]
[4,"Каска",21129660]
[4,"Подшлемник",21129678]
[2,"Костюм",21120714]
[2,"Футболка",21133389]
[2,"Белье нат",21129075]
[2,"Гол убор ",21129674]
[2,"Ботинки кож",21126544]
[2,"Каска",21129660]
[2,"Подшлемник",21129678]
[1,"Костюм",21120714]
[1,"Футболка",21133389]
[1,"Белье нат",21129075]
[1,"Гол убор ",21129674]
[1,"Ботинки кож",21126545]
[1,"Каска",21129660]
[1,"Подшлемник",21129678]
[2,"Костюм",21120714]
[2,"Футболка",21133389]
[2,"Белье нат",21129075]
[2,"Гол убор ",21129675]
[2,"Ботинки кож",21126545]
[2,"Каска",21129660]
[2,"Подшлемник",21129679]
[1,"Костюм",21120714]
[1,"Футболка",21133389]
[1,"Белье нат",21129075]
[1,"Гол убор ",21129673]
[1,"Ботинки кож",21126545]
[1,"Каска",1.1499999999999999]
[1,"Подшлемник",21129678]
[1,"Костюм",21120714]
[1,"Футболка",21133389]
[1,"Белье нат",21129075]
[1,"Гол убор ",21129675]
[1,"Ботинки кож",21126544]
[1,"Каска",21129660]
[1,"Подшлемник",21129679]
[1,"Костюм",21120714]
[1,"Футболка",21133389]
[1,"Белье нат",21129075]
[1,"Гол убор ",21129674]
[1,"Ботинки кож",21126545]
[1,"Каска",21129660]
[1,"Подшлемник",21129678]
[3,"Костюм",21120719]
[3,"Футболка",21133392]
[3,"Белье нат",21129078]
[3,"Гол убор ",21129673]
[3,"Ботинки кож",21126544]
[3,"Каска",21129660]
[3,"Подшлемник",21129678]
[7,"Костюм",21120720]
[7,"Футболка",5.15]
[7,"Белье нат",21129079]
[7,"Гол убор ",21129674]
[7,"Ботинки кож",21126546]
[7,"Каска",21129660]
[7,"Подшлемник",21129678]
[12,"Костюм",21121536]
[12,"Футболка",21133385]
[12,"Белье нат",21129071]
[12,"Гол убор ",21129674]
[12,"Ботинки кож",21126643]
[12,"Каска",21129660]
[12,"Подшлемник",21129678]
[2,"Костюм",21121536]
[2,"Футболка",21133385]
[2,"Белье нат",21129071]
[2,"Гол убор ",21129672]
[2,"Ботинки кож",21126644]
[2,"Каска",21129660]
[2,"Подшлемник",21129677]

{"sheet":"Лист1","index":1,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Месяц","Костюм","Футболка","Белье нат","Гол убор ","Ботинки кож","Каска","Подшлемник"]
[7,21120707,21133384,21129070,21129673,21126544,21129660,21129678]
[7,21120707,21133384,21129070,21129673,21126542,21129660,21129678]
[2,21120707,21133384,21129070,21129673,21126544,1.1499999999999999,21129678]
[3,21120707,21133384,21129075,21129674,21126544,21129660,21129678]
[1,21120708,21133385,21129071,21129672,21126544,1.1499999999999999,21129677]
[1,21120708,21133384,21129071,21129675,21126544,1.1499999999999999,21129679]
[7,21120708,21133384,21129071,21129674,21126544,21129660,21129678]
[2,21120708,21133384,21129071,21129674,21126543,21129660,21129678]
[7,21120708,21133385,21129071,21129674,21126545,21129660,21129678]
[1,21120708,21133385,21129071,21129674,21126545,21129660,21129678]
["++",21120708,21133384,21129070,21129675,21126543,1.1499999999999999,21129679]
[2,21120708,21133385,21129071,21129675,21126544,2.15,21129679]
[7,21120709,21133386,21129072,21129674,21126545,21129660,21129678]
[3,21120709,21133389,21129076,21129674,21126545,3.15,21129678]
[3,21120713,21133388,21129075,21129674,21126543,21129660,21129678]
[3,21120713,21133388,21129075,21129674,21126544,21129660,21129678]
[1,21120713,21133388,21129075,21129675,21126544,21129660,21129679]
[1,21120713,21133388,21129075,21129674,21126544,21129660,21129678]
[3,21120713,21133388,21129075,21129674,21126543,21129660,21129678]
[4,21120714,21133389,21129075,21129673,21126544,4.1500000000000004,21129678]
[7,21120714,5.15,21129075,21129674,21126544,21129660,21129678]
[3,21120714,21133389,21129075,21129674,21126545,21129660,21129678]
[2,21120714,21133385,21129071,21129674,21126544,21129660,21129678]
[1,21120714,5.15,21129075,21129674,21126545,21129660,21129678]
[2,21120714,21133389,21129075,21129674,21126545,21129660,21129678]
[1,21120714,21133389,21129075,21129673,21126545,21129660,21129678]
[4,21120714,21133389,21129075,21129673,21126544,21129660,21129678]
[2,21120714,21133389,21129075,21129674,21126544,21129660,21129678]
[1,21120714,21133389,21129075,21129674,21126545,21129660,21129678]
[2,21120714,21133389,21129075,21129675,21126545,21129660,21129679]
[1,21120714,21133389,21129075,21129673,21126545,1.1499999999999999,21129678]
[1,21120714,21133389,21129075,21129675,21126544,21129660,21129679]
[1,21120714,21133389,21129075,21129674,21126545,21129660,21129678]
[3,21120719,21133392,21129078,21129673,21126544,21129660,21129678]
[7,21120720,5.15,21129079,21129674,21126546,21129660,21129678]
[12,21121536,21133385,21129071,21129674,21126643,21129660,21129678]
[2,21121536,21133385,21129071,21129672,21126644,21129660,21129677]

{"sheet":"Должно быть так","index":2,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,"сумма по полю берётся из счёт количества посторений значений в колонке Костюм'"]
["Костюм","Месяц","Сумма по полю rd",null,"Футболка","Месяц","Сумма по полю rd",null,"и т.д."]
[21120707,2,1,null,5.15,1,1]
[null,3,1,null,null,7,2]
[null,7,2,null,21133384,1,1]
[21120708,1,3,null,null,2,2]
[null,2,2,null,null,3,1]
[null,7,2,null,null,7,3]
[null,"++",1,null,null,"++",1]
[21120709,3,1,null,21133385,1,2]
[null,7,1,null,null,2,3]
[21120713,1,2,null,null,7,1]
[null,3,3,null,null,12,1]
[21120714,1,6,null,21133386,7,1]
[null,2,4,null,21133388,1,2]
[null,3,1,null,null,3,3]
[null,4,2,null,21133389,1,5]
[null,7,1,null,null,2,3]
[21120719,3,1,null,null,3,2]
[21120720,7,1,null,null,4,2]
[21121536,2,1,null,21133392,3,1]
[null,12,1]