{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Реестр","Отчет"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Реестр отгрузок"]
[null,"Клиент","Товар","Количество"]
[null,"Клиент1","Товар1",5]
[null,"Клиент2","Товар2",10]
[null,"Клиент3","Товар3",15]
[null,"Клиент3","Товар4",25]
[null,"Клиент5","Товар2",14]
[null,"Клиент1","Товар1",23]
[null,"Клиент1","Товар2",25]
[null,"Клиент17","Товар4",27]
[null,"Клиент9","Товар3",68]
[null,"Клиент10","Товар1",36]
[]
["Добрый день. По нажатию на кнопку на \"Листе \"Отчет\" отображаются уникальные значения . А как отобразить по товару ?"]
["Количество строк  может меняться."]

{"sheet":"Отчет","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Сводный отчет"]
["Клиент","Товар1","Товар2","Товар3","Товар4"]
[null,{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,B$3,Реестр!$B$5:$B$14,$A4)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,C$3,Реестр!$B$5:$B$14,$A4)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,D$3,Реестр!$B$5:$B$14,$A4)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,E$3,Реестр!$B$5:$B$14,$A4)","v":0}]
[null,{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,B$3,Реестр!$B$5:$B$14,$A5)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,C$3,Реестр!$B$5:$B$14,$A5)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,D$3,Реестр!$B$5:$B$14,$A5)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,E$3,Реестр!$B$5:$B$14,$A5)","v":0}]
[null,{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,B$3,Реестр!$B$5:$B$14,$A6)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,C$3,Реестр!$B$5:$B$14,$A6)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,D$3,Реестр!$B$5:$B$14,$A6)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,E$3,Реестр!$B$5:$B$14,$A6)","v":0}]
[null,{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,B$3,Реестр!$B$5:$B$14,$A7)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,C$3,Реестр!$B$5:$B$14,$A7)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,D$3,Реестр!$B$5:$B$14,$A7)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,E$3,Реестр!$B$5:$B$14,$A7)","v":0}]
[null,{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,B$3,Реестр!$B$5:$B$14,$A8)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,C$3,Реестр!$B$5:$B$14,$A8)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,D$3,Реестр!$B$5:$B$14,$A8)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,E$3,Реестр!$B$5:$B$14,$A8)","v":0}]
[null,{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,B$3,Реестр!$B$5:$B$14,$A9)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,C$3,Реестр!$B$5:$B$14,$A9)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,D$3,Реестр!$B$5:$B$14,$A9)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,E$3,Реестр!$B$5:$B$14,$A9)","v":0}]
[null,{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,B$3,Реестр!$B$5:$B$14,$A10)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,C$3,Реестр!$B$5:$B$14,$A10)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,D$3,Реестр!$B$5:$B$14,$A10)","v":0},{"$f":"SUMIFS(Реестр!$D$5:$D$14,Реестр!$C$5:$C$14,E$3,Реестр!$B$5:$B$14,$A10)","v":0}]