{"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":1},"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":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Исходные данные",null,null,null,null,"Свод",null,null,null,"На выходе"]
["Группа","Коды","Кол-во",null,null,"Названия строк","Сумма по полю Кол-во"]
["Группа 1","10.1 цйу",16,null,null,"Группа 1",102,{"$f":"IF(a(F3)=1,H2,F3)","v":"Группа 1"},null,"Коды","Всего","Группа 1","Группа 2","Группа 3"]
["Группа 1","10.2 фыв",15,null,null,"10.1 цйу",16,{"$f":"IF(a(F4)=1,H3,F4)","v":"Группа 1"},null,"10.1",{"$f":"SUMIF($F$2:$F$15,\"*\"&J4&\"*\",$G$2:$G$15)","v":66},{"$f":"SUMIFS($G$2:$G$15,$F$2:$F$15,\"*\"&$J4&\"*\",$H$2:$H$15,L$3)","v":36},{"$f":"SUMIFS($G$2:$G$15,$F$2:$F$15,\"*\"&$J4&\"*\",$H$2:$H$15,M$3)","v":15},15]
["Группа 1","10.3 вав",11,null,null,"10.2 фыв",35,{"$f":"IF(a(F5)=1,H4,F5)","v":"Группа 1"},null,"10.2",{"$f":"SUMIF($F$2:$F$15,\"*\"&J5&\"*\",$G$2:$G$15)","v":89},{"$f":"SUMIFS($G$2:$G$15,$F$2:$F$15,\"*\"&$J5&\"*\",$H$2:$H$15,L$3)","v":55},20,14]
["Группа 2","10.1 цйу",15,null,null,"10.3 вав",31,{"$f":"IF(a(F6)=1,H5,F6)","v":"Группа 1"},null,"10.3",66,31,20,15]
["Группа 2","10.3 вав",20,null,null,"10.1 йцу 10.2 фыв",20,{"$f":"IF(a(F7)=1,H6,F7)","v":"Группа 1"}]
["Группа 3","10.3 вав",15,null,null,"Группа 2",55,{"$f":"IF(a(F8)=1,H7,F8)","v":"Группа 2"}]
["Группа 3","10.2 фыв",14,null,null,"10.1 цйу",15,{"$f":"IF(a(F9)=1,H8,F9)","v":"Группа 2"}]
["Группа 1","10.3 вав",20,null,null,"10.2 фыв",20,{"$f":"IF(a(F10)=1,H9,F10)","v":"Группа 2"}]
["Группа 1","10.2 фыв",20,null,null,"10.3 вав",20,{"$f":"IF(a(F11)=1,H10,F11)","v":"Группа 2"}]
["Группа 2","10.2 фыв",20,null,null,"Группа 3",44,{"$f":"IF(a(F12)=1,H11,F12)","v":"Группа 3"}]
["Группа 3","10.1 цйу",15,null,null,"10.1 цйу",15,{"$f":"IF(a(F13)=1,H12,F13)","v":"Группа 3"}]
["Группа 1","10.1 йцу 10.2 фыв",20,null,null,"10.2 фыв",14,{"$f":"IF(a(F14)=1,H13,F14)","v":"Группа 3"}]
[null,null,null,null,null,"10.3 вав",15,{"$f":"IF(a(F15)=1,H14,F15)","v":"Группа 3"}]
[null,null,null,null,null,"Общий итог",201,{"$f":"IF(a(F16)=1,H15,F16)","v":"Общий итог"}]

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

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