{"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":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Данные для отчета"]
["Дата ","№ документа","Клиент","Наименование ТМЦ","Кол-во,кг","Квартал"]
["2020-01-01","КБ-17","Клиент 1","ТМЦ 2",122.23,{"$f":"CONCATENATE(INT((MONTH(A4)+2)/3),\" квартал \",YEAR(A4))","v":"1 квартал 2020"}]
["2020-01-02","КБ-83","Клиент 2","ТМЦ 3",327.81599999999997,{"$f":"CONCATENATE(INT((MONTH(A5)+2)/3),\" квартал \",YEAR(A5))","v":"1 квартал 2020"}]
["2020-03-03","КБ-88","Клиент 8","ТМЦ 4",445.32,"1 квартал 2020"]
["2020-03-04","КБ-89","Клиент 10","ТМЦ 5",388.57499999999999,"1 квартал 2020"]
["2020-05-05","КБ-94","Клиент 5","ТМЦ 6",120.9,"2 квартал 2020"]
["2020-05-06","КБ-99","Клиент 2","ТМЦ 7",1213.22,"2 квартал 2020"]

{"sheet":"отчет","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"При формированиии отчета получается результат"]
[null,"Отчет за "]
[null,null,null,null,null,null,null,"Результат: если выбран:  1 квартал 2020,то должна отобразиться таблица"]
["Дата ","№ документа","Клиент","Наименование ТМЦ","Кол-во,кг",null,"Дата ","№ документа","Клиент","Наименование ТМЦ","Кол-во,кг"]
["Итого:",null,null,null,0,null,"2020-01-01","КБ-17","Клиент 1","ТМЦ 2",122.23]
[null,null,null,null,null,null,"2020-01-02","КБ-83","Клиент 2","ТМЦ 3",327.81599999999997]
[null,null,null,null,null,null,"2020-03-03","КБ-88","Клиент 8","ТМЦ 4",445.32]
[null,null,null,null,null,null,"2020-03-04","КБ-89","Клиент 10","ТМЦ 5",388.57499999999999]
[null,null,null,null,null,null,"Итого :",null,null,null,{"$f":"SUM(K5:K8)","v":1283.941}]