{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Объект","Тропический фрукт","Ягода","Овощ"]
["Яблоко",0,0,0]
["Апельсин",0,0,0]
["Киви",1,0,0]
["Манго",1,0,0]
["Малина",0,1,0]
["Огурец",0,0,1]
["Редис",0,0,1]
["Картофель",0,0,1]
["Клубника",0,1,0]
["Дуриан",1,0,0]
["Напильник",0,0,0]
["Тыква",0,0,1]
["Ирга",0,1,0]
[]
["Всего"]
[{"$f":"INDEX($B$1:$Z$1,ROW(A1))","v":"Тропический фрукт"},null,{"$f":"SUM(B2:B14)","v":3},null,"а именно:",{"$f":"СцепитьЕсли(INDEX($B$2:$D$14,,ROW(A1)),1,$A$2:$A$14,\", \")","v":"Киви, Манго, Дуриан"}]
[{"$f":"INDEX($B$1:$Z$1,ROW(A2))","v":"Ягода"},null,{"$f":"SUM(C2:C14)","v":3},null,"а именно:",{"$f":"СцепитьЕсли(INDEX($B$2:$D$14,,ROW(A2)),1,$A$2:$A$14,\", \")","v":"Малина, Клубника, Ирга"}]
[{"$f":"INDEX($B$1:$Z$1,ROW(A3))","v":"Овощ"},null,{"$f":"SUM(D2:D14)","v":4},null,"а именно:",{"$f":"СцепитьЕсли(INDEX($B$2:$D$14,,ROW(A3)),1,$A$2:$A$14,\", \")","v":"Огурец, Редис, Картофель, Тыква"}]