{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ЦАОП"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"ЦАОП","index":0,"n_rows":10,"n_cols":20,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,18,0,19],[1,19,8,19]]}
["№ этапа","Цена этапа","№\nакта",null,"Дата акта","Сумма акта","Остаток \nпо этапу","Дата вх.",null,"Срок по контракту","Рабочий\n+1","Просрочено дней","По 1му акту","Ставка\nпо актам","2020-11-25","На остаток","Ставка по просрочке","Сумма","Праздники"]
[1,53547,"1","от","2020-05-15",53547,{"$f":"ROUND(IF(B2>0,B2-F2,G1-F2),2)","v":0},"2020-05-22",null,"2020-01-31",{"$f":"WORKDAY.INTL(J2,1,1,$S$2:$S$10)","v":"2020-02-03"},{"$f":"IF(AND(H2>K2,B2>0),H2-K2+1,0)","v":110},{"$f":"IF(B2>0,ROUND((B2*L2*1/300*N2),2),0)","v":1079.8599999999999},{"$f":"IF(L2=0,0,Get_KeyRate(H2))","v":5.5E-2},{"$f":"IF(AND(E2=0,F2=0,H2=0),\"+\",\"\")","v":""},{"$f":"IF(O2=\"+\",IF(J2>$O$1,\"0\",IF(O2=\"+\",VALUE($O$1)-VALUE(K2),$O$1-H2))+IF(G2=0,0,IF(AND(A2>=A3,H2>0,H3-H2),H3-H2)),IF(J2>$O$1,\"0\",IF(G2=0,0,IF(AND(A2>=A3,H2>0,H3-H2),H3-H2,IF(AND(A2<>A3,B2=\"\",B3<>0),VALUE($O$1)-VALUE(H2),IF(A2<>A3,H2-K2,IF(O2=\"+\",VALUE($O$1)-VALUE(K2),$O$1-H2)))))))","v":0},{"$f":"IF(G2=0,0,IF(AND(A2<=A3,P2>0,H2<>0),Get_KeyRate(H3),Get_KeyRate($O$1)))","v":0},{"$f":"IF(G2=0,0,IF(P2>0,ROUND((G2*P2*1/300*Q2),2),0))","v":0},"2019-01-01","каникулы"]
[2,629125,"2/1","от","2020-05-15",619378,9747,"2020-05-22",null,"2020-02-29","2020-03-02",{"$f":"IF(AND(H3>K3,B3>0),H3-K3+1,0)","v":82},{"$f":"IF(B3>0,ROUND((B3*L3*1/300*N3),2),0)","v":9457.85},{"$f":"IF(L3=0,0,Get_KeyRate(H3))","v":5.5E-2},{"$f":"IF(AND(E3=0,F3=0,H3=0),\"+\",\"\")","v":""},81,{"$f":"IF(G3=0,0,IF(AND(A3<=A4,P3>0,H3<>0),Get_KeyRate(H4),Get_KeyRate($O$1)))","v":5.5E-2},{"$f":"IF(G3=0,0,IF(P3>0,ROUND((G3*P3*1/300*Q3),2),0))","v":144.74},"2019-01-02"]
[3,82910,"3","от","2020-05-15",82907,3,"2020-05-22",null,"2020-02-29","2020-03-02",82,1246.4100000000001,5.5E-2,"",81,{"$f":"IF(G4=0,0,IF(AND(A4<=A5,P4>0,H4<>0),Get_KeyRate(H5),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},0.03,"2019-01-03"]
[4,849598,null,null,null,null,849598,null,null,"2020-02-29","2020-03-02",0,0,0,"+",268,{"$f":"IF(G5=0,0,IF(AND(A5<=A6,P5>0,H5<>0),Get_KeyRate(H6),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},32256.400000000001,"2019-01-04"]
[5,2262215,"5/1","от","2020-05-15",1543724,718491,"2020-05-22",null,"2020-03-31","2020-04-01",52,21566.45,5.5E-2,"",24,{"$f":"IF(G6=0,0,IF(AND(A6<=A7,P6>0,H6<>0),Get_KeyRate(H7),Get_KeyRate($O$1)))","v":5.5E-2},3161.36,"2019-01-05"]
[5,null,"5/2","от","2020-06-11",358923.6,359567.4,"2020-06-15",null,"2020-03-31","2020-04-01",0,0,0,"",151,{"$f":"IF(G7=0,0,IF(AND(A7<=A8,P7>0,H7<>0),Get_KeyRate(H8),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},7691.75,"2019-01-06"]
[5,null,"5/3","от","2020-11-13",194773.98,164793.42000000001,"2020-11-13",null,"2020-03-31","2020-04-01",0,{"$f":"IF(B8>0,ROUND((B8*L8*1/300*N8),2),0)","v":0},{"$f":"IF(L8=0,0,Get_KeyRate(H8))","v":0},{"$f":"IF(AND(E8=0,F8=0,H8=0),\"+\",\"\")","v":""},12,{"$f":"IF(G8=0,0,IF(AND(A8<=A9,P8>0,H8<>0),Get_KeyRate(H9),Get_KeyRate($O$1)))","v":5.5E-2},362.55]
[6,4264318,"6","от","2020-05-15",4264318,{"$f":"ROUND(IF(B9>0,B9-F9,G7-F9),2)","v":0},"2020-05-22",null,"2020-03-31","2020-04-01",52,40653.160000000003,5.5E-2,"",{"$f":"IF(O9=\"+\",IF(J9>$O$1,\"0\",IF(O9=\"+\",VALUE($O$1)-VALUE(K9),$O$1-H9))+IF(G9=0,0,IF(AND(A9>=#REF!,H9>0,#REF!-H9),#REF!-H9)),IF(J9>$O$1,\"0\",IF(G9=0,0,IF(AND(A9>=#REF!,H9>0,#REF!-H9),#REF!-H9,IF(AND(A9<>#REF!,B9=\"\",#REF!<>0),VALUE($O$1)-VALUE(H9),IF(A9<>#REF!,H9-K9,IF(O9=\"+\",VALUE($O$1)-VALUE(K9),$O$1-H9)))))))","v":0},{"$f":"IF(G9=0,0,IF(AND(A9<=#REF!,P9>0,H9<>0),Get_KeyRate(#REF!),Get_KeyRate($O$1)))","v":0},0,"2019-01-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-08"]