{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":3,"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":"Лист1","index":0,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"2016-01-01",{"$f":"EDATE(B1,1)","v":"2016-02-01"}]
["критерии",{"$f":"SUM(B3:B6)","v":156},{"$f":"SUM(C3:C6)","v":23}]
["тест1",{"$f":"SUMPRODUCT(([2]Лист1!$E$3:$E$18=$A3)*(TEXT([2]Лист1!$A$3:$A$18,\"ММГГГ\")=TEXT(B$1,\"ММГГГ\"))*[2]Лист1!$B$3:$D$18)","v":64},{"$f":"SUMPRODUCT(([2]Лист1!$E$3:$E$18=$A3)*(TEXT([2]Лист1!$A$3:$A$18,\"ММГГГ\")=TEXT(C$1,\"ММГГГ\"))*[2]Лист1!$B$3:$D$18)","v":-2}]
["тест2",{"$f":"SUMPRODUCT(([2]Лист1!$E$3:$E$18=$A4)*(TEXT([2]Лист1!$A$3:$A$18,\"ММГГГ\")=TEXT(B$1,\"ММГГГ\"))*[2]Лист1!$B$3:$D$18)","v":92},{"$f":"SUMPRODUCT(([2]Лист1!$E$3:$E$18=$A4)*(TEXT([2]Лист1!$A$3:$A$18,\"ММГГГ\")=TEXT(C$1,\"ММГГГ\"))*[2]Лист1!$B$3:$D$18)","v":0}]
["тест3",{"$f":"SUMPRODUCT(([2]Лист1!$E$3:$E$18=$A5)*(TEXT([2]Лист1!$A$3:$A$18,\"ММГГГ\")=TEXT(B$1,\"ММГГГ\"))*[2]Лист1!$B$3:$D$18)","v":0},{"$f":"SUMPRODUCT(([2]Лист1!$E$3:$E$18=$A5)*(TEXT([2]Лист1!$A$3:$A$18,\"ММГГГ\")=TEXT(C$1,\"ММГГГ\"))*[2]Лист1!$B$3:$D$18)","v":0}]
["тест4",{"$f":"SUMPRODUCT(([2]Лист1!$E$3:$E$18=$A6)*(TEXT([2]Лист1!$A$3:$A$18,\"ММГГГ\")=TEXT(B$1,\"ММГГГ\"))*[2]Лист1!$B$3:$D$18)","v":0},{"$f":"SUMPRODUCT(([2]Лист1!$E$3:$E$18=$A6)*(TEXT([2]Лист1!$A$3:$A$18,\"ММГГГ\")=TEXT(C$1,\"ММГГГ\"))*[2]Лист1!$B$3:$D$18)","v":25}]