{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Иван Декабрь 2015","Алекс Декабрь 2015","Итоги"],"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":"Иван Декабрь 2015","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Дата","Код","Клиент","Экспедитор","Полная","Пустая"]
[null,"01,12,2015",856,"Магазин","Иван",10,9]
[null,"01,12,2015",300,"Банк","Иван",5,5]
[null,"02,12,2015",856,"Магазин","Иван",9,9]
[null,"02,12,2015",300,"Банк","Иван",5,2]
[null,"04,12,2015",900,"Бисмарт","Иван",10,8]

{"sheet":"Алекс Декабрь 2015","index":1,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Дата","Код","Клиент","Экспедитор","Полная","Пустая"]
[null,"01,12,2015",856,"Магазин","Алекс",10,9]
[null,"01,12,2015",300,"Банк","Алекс",5,5]
[null,"02,12,2015",856,"Магазин","Алекс",9,9]
[null,"02,12,2015",300,"Банк","Алекс",5,2]

{"sheet":"Итоги","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Полная ","Пустая","Полная ","Пустая","Полная ","Пустая","Полная ","Пустая","Полная ","Пустая","и т.д."]
[null,"Код","Клиент","Экспедитор","01,12,2015","01,12,2015","02,12,2015","02,12,2015","03,12,2015","03,12,2015","04,12,2015","04,12,2015","05,12,2015","05,12,2015"]
[]
[null,300,"Банк","Алекс",{"$f":"sIfAllSH(IF(E$1=$E$1,$F$1:$F$20,$G$1:$G$20),$C$1:$C$20,$B4,$D$1:$D$20,$C4,$B$1:$B$20,E$2)","v":10},{"$f":"sIfAllSH(IF(F$1=$E$1,$F$1:$F$20,$G$1:$G$20),$C$1:$C$20,$B4,$D$1:$D$20,$C4,$B$1:$B$20,F$2)","v":10},10,4,0,0,0,0,0,0]
[null,856,"Магазин","Алекс",{"$f":"sIfAllSH(IF(E$1=$E$1,$F$1:$F$20,$G$1:$G$20),$C$1:$C$20,$B5,$D$1:$D$20,$C5,$B$1:$B$20,E$2)","v":20},18,18,18,0,0,0,0,0,0]
[null,900,"Бисмарт","Иван",0,0,0,0,0,0,10,8,0,0]
[]
[]
[]
[]
[]
[]
["Нужно чтоб эта таблица забирала данные с остальных листов, (суммируя данные) по совпавшим уникальным кодам объектов, при этом учитывая дату и (пустая - полная) - числа 20 и 18 вбиты в ручную для примера, а нужно чтоб также автоматом было. "]
["И если на каком-то листе появилась строка с новым уникальным кодом, то и здесь она должна (появится) дополнится снизу. "]