{"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":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"ActiveCell.FormulaR1C1 = \"=EOMONTH(RC[-10],-1)+1\"","ActiveCell.FormulaR1C1 = \"=EOMONTH(R[3]C[-8],0)\""]
[null,null,"Данные для отчета",null,null,null,null,"КОНМЕСЯЦА(A4;-1)+1","КОНМЕСЯЦА(A4;0)"]
["Дата ","№ документа","Клиент","Наименование ТМЦ","Кол-во,тн",null,null,"начало месяца(формула)","конец месяца(формула)","начало месяца"]
["2020-01-11","КБ-17","Клиент 1","ТМЦ 2",1,null,null,{"$f":"EOMONTH(A4,-1)+1","v":"2020-01-01"},{"$f":"EOMONTH(A4,0)","v":"2020-01-31"},{"$f":"A4-DAY(A4)+1","v":"2020-01-01"}]
["2020-01-12","КБ-83","Клиент 2","ТМЦ 3",2,null,null,{"$f":"EOMONTH(A5,-1)+1","v":"2020-01-01"},{"$f":"EOMONTH(A5,0)","v":"2020-01-31"},{"$f":"A5-DAY(A5)+1","v":"2020-01-01"}]
["2020-01-13","КБ-84","Клиент 1","ТМЦ 4",4,null,null,"2020-01-01","2020-01-31","2020-01-01"]
["2020-01-30","КБ-85","Клиент 2","ТМЦ 5",5,null,null,"2020-01-01","2020-01-31","2020-01-01"]
["2020-03-03","КБ-88","Клиент 8","ТМЦ 4",5,null,null,"2020-03-01","2020-03-31","2020-03-01"]
["2020-03-04","КБ-89","Клиент 10","ТМЦ 5",6,null,null,"2020-03-01","2020-03-31","2020-03-01"]
["2020-04-05","КБ-90","Клиент 11","ТМЦ 6",8,null,null,"2020-04-01","2020-04-30","2020-04-01"]
["2020-04-06","КБ-91","Клиент 12","ТМЦ 7",9,null,null,"2020-04-01","2020-04-30","2020-04-01"]
["2020-05-05","КБ-94","Клиент 5","ТМЦ 6",10,null,null,"2020-05-01","2020-05-31","2020-05-01"]
["2020-05-06","КБ-99","Клиент 2","ТМЦ 7",22,null,null,"2020-05-01","2020-05-31","2020-05-01"]
["2020-06-05","КБ-100","Клиент 2","ТМЦ 5",34,null,null,"2020-06-01","2020-06-30","2020-06-01"]
["2020-06-06","КБ-101","Клиент 8","ТМЦ 4",46,null,null,"2020-06-01","2020-06-30","2020-06-01"]
["2020-06-07","КБ-102","Клиент 5","ТМЦ 6",58,null,null,"2020-06-01","2020-06-30","2020-06-01"]
[]
["Если выбрать по календарю  данные за текущий месяц , то должен сформироваться Отчет за июнь 2020 г."]

{"sheet":"отчет","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Отчет  за период с : 01.02.2020 по 30.04.2020",null,null,null,null,"Отчет  за июнь  2020 г.",null,null,"Результат"]
[null,null,null,null,null,null,null,null,"Должно получиться ТАК"]
["Дата ","№ документа","Клиент","Наименование ТМЦ","Кол-во,кг",null,"Дата ","№ документа","Клиент","Наименование ТМЦ","Кол-во,кг"]
["2020-03-03","КБ-88","Клиент 8","ТМЦ 4",5,null,"2020-06-05","КБ-100","Клиент 2","ТМЦ 5",34]
["2020-03-04","КБ-89","Клиент 10","ТМЦ 5",6,null,"2020-06-06","КБ-101","Клиент 8","ТМЦ 4",46]
["2020-04-05","КБ-90","Клиент 11","ТМЦ 6",8,null,"2020-06-07","КБ-102","Клиент 5","ТМЦ 6",58]
["2020-04-06","КБ-91","Клиент 12","ТМЦ 7",9,null,"Итого:",null,null,null,138]
["Итого:",null,null,null,28]