{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ВВОД","ИТОГ","ПРИМЕР"],"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":"ВВОД","index":0,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["входные данные"]
["Название","Кол-во","Корзина"]
["Яблоко",13774,65000]
["Апельсин",13570]
["Авокадо",12887]
["Картофель",12474]
["Лук",12296]
["Морковь",13840]
["Чеснок",13707]
["Петрушка",13570]
["Свекла",12054]
["Капуста",11834]
["Груша",14222]
["Редис",13137]
["Томат",13088]
["Огурец",12294]
["Вишня",12269]
["Черешня",11243]
["Дыня",11243]
["Тыква",11243]
["Арбуз",14810]
["Хрен",15245]
["Укроп",15424]
["Слива",15245]
["Мандарин",16067]
["Перец",14777]
["Кабачек",14054]
["Баклажан",9408]
["Алыча",10586]
["Клубника",10881]
["Смородина",12228]
["Колубика",12887]
["Черника",13707]
["Клюква",13137]
["Брусника",14043]
["Ежевика",14151]
["Малина",14054]

{"sheet":"ИТОГ","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,6,1,7],[1,8,1,9],[1,10,1,11],[0,6,0,11],[0,3,0,4]]}
["Сортировка",null,null,"Сортировка с вычетом",null,null,"Корзины"]
["Название","Кол-во",null,"Название","Кол-во",null,"Блок 1",null,"Блок 2",null,"Блок 3"]
[null,null,null,null,null,null,"Название","Кол-во","Название","Кол-во","Название","Кол-во"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Сумма",{"$f":"SUM(H4:H8)","v":0},"Сумма",{"$f":"SUM(J4:J8)","v":0},"Сумма",{"$f":"SUM(L4:L8)","v":0}]

{"sheet":"ПРИМЕР","index":2,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4],[0,6,0,11],[1,6,1,7],[1,8,1,9],[1,10,1,11]]}
["Сортировка",null,null,"Сортировка с вычетом",null,null,"Корзины"]
["Название","Кол-во",null,"Название","Кол-во",null,"Блок 1",null,"Блок 2",null,"Блок 3"]
["Мандарин",16067,null,"Мандарин",16067,null,"Название","Кол-во","Название","Кол-во","Название","Кол-во"]
["Укроп",15424,null,"Укроп",15424,null,"Яблоко",13774,"Морковь",13840,"Груша",14222]
["Хрен",15245,null,"Хрен",15245,null,"Апельсин",13570,"Чеснок",13707,"Редис",13137]
["Слива",15245,null,"Слива",15245,null,"Авокадо",12887,"Петрушка",13570,"Томат",13088]
["Арбуз",14810,null,"Арбуз",14810,null,"Картофель",12474,"Свекла",12054,"Огурец",12294]
["Перец",14777,null,"Перец",14777,null,"Лук",12296,"Капуста",11834,"Вишня",12269]
["Груша",14222,null,"Ежевика",14151,null,"Сумма",{"$f":"SUM(H4:H8)","v":65001},"Сумма",{"$f":"SUM(J4:J8)","v":65005},"Сумма",{"$f":"SUM(L4:L8)","v":65010}]
["Ежевика",14151,null,"Кабачек",14054]
["Кабачек",14054,null,"Малина",14054]
["Малина",14054,null,"Брусника",14043]
["Брусника",14043,null,"Черника",13707]
["Морковь",13840,null,"Клюква",13137]
["Яблоко",13774,null,"Колубика",12887]
["Чеснок",13707,null,"Смородина",12228]
["Черника",13707,null,"Черешня",11243]
["Апельсин",13570,null,"Дыня",11243]
["Петрушка",13570,null,"Тыква",11243]
["Редис",13137,null,"Клубника",10881]
["Клюква",13137,null,"Алыча",10586]
["Томат",13088,null,"Баклажан",9408]
["Авокадо",12887]
["Колубика",12887]
["Картофель",12474]
["Лук",12296]
["Огурец",12294]
["Вишня",12269]
["Смородина",12228]
["Свекла",12054]
["Капуста",11834]
["Черешня",11243]
["Дыня",11243]
["Тыква",11243]
["Клубника",10881]
["Алыча",10586]
["Баклажан",9408]