{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Заявка","Иванов","Петров","Сидоров"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Общая заявка"]
[null,"Наименов",null,"Иванов","Петров","Сидоров","Итого"]
[1,"Яблоки","кг",{"$f":"Иванов!D2","v":5},{"$f":"Петров!D2","v":9},{"$f":"Сидоров!D2","v":0},{"$f":"SUM(D3:F3)","v":14}]
[2,"Помидоры","кг",{"$f":"Иванов!D3","v":2},{"$f":"Петров!D3","v":0},{"$f":"Сидоров!D3","v":80},{"$f":"SUM(D4:F4)","v":82}]
[3,"Огурцы","кг",{"$f":"Иванов!D4","v":0},{"$f":"Петров!D4","v":20},{"$f":"Сидоров!D4","v":0},20]
[4,"Картофель","кг",{"$f":"Иванов!D5","v":0},{"$f":"Петров!D5","v":0},{"$f":"Сидоров!D5","v":40},40]
[5,"Огурцы","кг",{"$f":"Иванов!D6","v":0},{"$f":"Петров!D6","v":12},{"$f":"Сидоров!D6","v":0},12]
[6,"Огурцы","кг",{"$f":"Иванов!D7","v":6},{"$f":"Петров!D7","v":0},{"$f":"Сидоров!D7","v":15},21]
[]
[]
[]
[]
[null,"При корректир(вручную) общей заявки формула сбивается (лучше использовать макрос копирования с листов и вставки значений по своим колонкам)"]
[null,"Таблица очень большая для примера сделал 3 листа и 3 колонки в общей заявке"]

{"sheet":"Иванов","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Наименов","ед.изм","Кол-во"]
[1,"Яблоки","кг",5]
[2,"Помидоры","кг",2]
[3,"Огурцы","кг"]
[4,"Картофель","кг"]
[5,"Огурцы","кг"]
[6,"Огурцы","кг",6]

{"sheet":"Петров","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Наименов","ед.изм","Кол-во"]
[1,"Яблоки","кг",9]
[2,"Помидоры","кг"]
[3,"Огурцы","кг",20]
[4,"Картофель","кг"]
[5,"Огурцы","кг",12]
[6,"Огурцы","кг"]

{"sheet":"Сидоров","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Наименов","ед.изм","Кол-во"]
[1,"Яблоки","кг"]
[2,"Помидоры","кг",80]
[3,"Огурцы","кг"]
[4,"Картофель","кг",40]
[5,"Огурцы","кг"]
[6,"Огурцы","кг",15]