{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист2"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Лист2","index":0,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["ДАТА","СУММА",null,null,null,null,null,null,"КВАРТАЛ","ГОД","сумма",null,"КВАРТАЛ","ГОД","сумма"]
["2017-03-25",null,null,null,null,null,null,null,{"$f":"IFERROR(TRUNC((MONTH(SMALL(A$2:A$99,1+IF(N(I1),SUMPRODUCT((A$2:A$99<EDATE(I1*3&-J1,1))-(A$2:A$99=0)))))+2)/3),-1)","v":1},{"$f":"IF(I2>0,YEAR(SMALL(A$2:A$99,1+IF(N(I1),SUMPRODUCT((A$2:A$99<EDATE(I1*3&-J1,1))-(A$2:A$99=0))))),)","v":2017},{"$f":"IF(J2,SUMIF(A:A,\"<\"&EDATE(I2*3&-J2,1),B:B)-SUM(K$1:K1),)","v":22},null,1,2017,"сумма всех значений из колоны B по условию квартала"]
["2017-02-10",22,null,null,null,null,null,null,{"$f":"IFERROR(TRUNC((MONTH(SMALL(A$2:A$99,1+IF(N(I2),SUMPRODUCT((A$2:A$99<EDATE(I2*3&-J2,1))-(A$2:A$99=0)))))+2)/3),-1)","v":3},{"$f":"IF(I3>0,YEAR(SMALL(A$2:A$99,1+IF(N(I2),SUMPRODUCT((A$2:A$99<EDATE(I2*3&-J2,1))-(A$2:A$99=0))))),)","v":2017},{"$f":"IF(J3,SUMIF(A:A,\"<\"&EDATE(I3*3&-J3,1),B:B)-SUM(K$1:K2),)","v":44},null,3,2017,"сумма всех значений из колоны B по условию квартала"]
["2017-07-15",null,null,null,null,null,null,null,4,2017,{"$f":"IF(J4,SUMIF(A:A,\"<\"&EDATE(I4*3&-J4,1),B:B)-SUM(K$1:K3),)","v":5726},null,4,2017,"сумма всех значений из колоны B по условию квартала"]
["2017-09-25",44,null,null,null,null,null,null,1,2018,{"$f":"IF(J5,SUMIF(A:A,\"<\"&EDATE(I5*3&-J5,1),B:B)-SUM(K$1:K4),)","v":67},null,1,2018,"сумма всех значений из колоны B по условию квартала"]
["2017-11-25",66,null,null,null,null,null,null,2,2018,{"$f":"IF(J6,SUMIF(A:A,\"<\"&EDATE(I6*3&-J6,1),B:B)-SUM(K$1:K5),)","v":732},null,2,2018,"сумма всех значений из колоны B по условию квартала"]
["2017-11-25",4444,null,null,null,null,null,null,4,2018,{"$f":"IF(J7,SUMIF(A:A,\"<\"&EDATE(I7*3&-J7,1),B:B)-SUM(K$1:K6),)","v":999},null,4,2018,"сумма всех значений из колоны B по условию квартала"]
["2018-03-25",67,null,null,null,null,null,null,-1,0,{"$f":"IF(J8,SUMIF(A:A,\"<\"&EDATE(I8*3&-J8,1),B:B)-SUM(K$1:K7),)","v":0}]
["2017-11-25",33,null,null,null,null,null,null,-1,0,{"$f":"IF(J9,SUMIF(A:A,\"<\"&EDATE(I9*3&-J9,1),B:B)-SUM(K$1:K8),)","v":0}]
["2017-11-25",22,null,null,null,null,null,null,-1,0,{"$f":"IF(J10,SUMIF(A:A,\"<\"&EDATE(I10*3&-J10,1),B:B)-SUM(K$1:K9),)","v":0}]
["2018-04-25",null,null,null,null,null,null,null,-1,0,{"$f":"IF(J11,SUMIF(A:A,\"<\"&EDATE(I11*3&-J11,1),B:B)-SUM(K$1:K10),)","v":0}]
["2018-05-25",null,null,null,null,null,null,null,-1,0,{"$f":"IF(J12,SUMIF(A:A,\"<\"&EDATE(I12*3&-J12,1),B:B)-SUM(K$1:K11),)","v":0}]
["2017-12-25",87,null,null,null,null,null,null,-1,0,{"$f":"IF(J13,SUMIF(A:A,\"<\"&EDATE(I13*3&-J13,1),B:B)-SUM(K$1:K12),)","v":0}]
["2017-12-25",55,null,null,null,null,null,null,-1,0,{"$f":"IF(J14,SUMIF(A:A,\"<\"&EDATE(I14*3&-J14,1),B:B)-SUM(K$1:K13),)","v":0}]
["2018-04-25",77,null,null,null,null,null,null,-1,0,{"$f":"IF(J15,SUMIF(A:A,\"<\"&EDATE(I15*3&-J15,1),B:B)-SUM(K$1:K14),)","v":0}]
["2017-12-25",120,null,null,null,null,null,null,-1,0,{"$f":"IF(J16,SUMIF(A:A,\"<\"&EDATE(I16*3&-J16,1),B:B)-SUM(K$1:K15),)","v":0}]
["2017-12-25",332,null,null,null,null,null,null,-1,0,{"$f":"IF(J17,SUMIF(A:A,\"<\"&EDATE(I17*3&-J17,1),B:B)-SUM(K$1:K16),)","v":0}]
["2017-12-25",567,null,null,null,null,null,null,-1,0,{"$f":"IF(J18,SUMIF(A:A,\"<\"&EDATE(I18*3&-J18,1),B:B)-SUM(K$1:K17),)","v":0}]
["2018-12-15",999,null,null,null,null,null,null,-1,0,{"$f":"IF(J19,SUMIF(A:A,\"<\"&EDATE(I19*3&-J19,1),B:B)-SUM(K$1:K18),)","v":0}]
["2018-04-25",655,null,null,null,null,null,null,-1,0,{"$f":"IF(J20,SUMIF(A:A,\"<\"&EDATE(I20*3&-J20,1),B:B)-SUM(K$1:K19),)","v":0}]
[null,null,null,null,null,null,null,null,-1,0,{"$f":"IF(J21,SUMIF(A:A,\"<\"&EDATE(I21*3&-J21,1),B:B)-SUM(K$1:K20),)","v":0}]