{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ОНКО"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,18,0,19]]}
["№ этапа","Цена этапа","№\nакта",null,"Дата акта","Сумма акта","Остаток \nпо этапу","Дата вх.","Дата приемки\n(подписания акта)","Срок по контракту","Рабочий\n+1","Просрочено дней","По 1му акту","Ставка\nпо актам","2020-12-01","На остаток","Ставка по просрочке","Сумма","Праздники"]
[72,424250,null,"от",null,0,{"$f":"ROUND(IF(B2>0,B2-F2,#REF!-F2),2)","v":424250},null,null,"2020-11-30",{"$f":"WORKDAY.INTL(J2,1,1,$S$2:$S$99)","v":"2020-12-01"},{"$f":"IF(AND(H2>K2,B2>0),H2-K2+1,0)","v":0},{"$f":"IF(B2>0,ROUND((B2*L2*1/300*N2),2),0)","v":0},{"$f":"IF(L2=0,0,Get_KeyRate(H2))","v":0},{"$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),ABS(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),Get_KeyRate(H3),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},{"$f":"IF(G2=0,0,IF(P2>0,ROUND((G2*P2*1/300*Q2),2),0))","v":0}]
[73,2931972,"73","от","2019-12-17",2207520,{"$f":"ROUND(IF(B3>0,B3-F3,G2-F3),2)","v":724452},"2020-12-20","2019-12-23","2020-11-30",{"$f":"WORKDAY.INTL(J3,1,1,$S$2:$S$99)","v":"2020-12-01"},{"$f":"IF(AND(H3>K3,B3>0),H3-K3+1,0)","v":20},{"$f":"IF(B3>0,ROUND((B3*L3*1/300*N3),2),0)","v":8307.25},{"$f":"IF(L3=0,0,Get_KeyRate(H3))","v":4.2500000000000003E-2},{"$f":"IF(AND(E3=0,F3=0,H3=0),\"+\",\"\")","v":""},{"$f":"IF(O3=\"+\",IF(J3>$O$1,\"0\",IF(O3=\"+\",VALUE($O$1)-VALUE(K3),$O$1-H3))+IF(G3=0,0,IF(AND(A3>=A4,H3>0,H4-H3),H4-H3)),IF(J3>$O$1,\"0\",IF(G3=0,0,IF(AND(A3>=A4),ABS(H4-H3),IF(AND(A3<>A4,B3=\"\",B4<>0),VALUE($O$1)-VALUE(H3),IF(A3<>A4,H3-K3,IF(O3=\"+\",VALUE($O$1)-VALUE(K3),$O$1-H3)))))))","v":41},{"$f":"IF(G3=0,0,IF(AND(A3<=A4,P3>0),Get_KeyRate(H4),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},{"$f":"IF(G3=0,0,IF(P3>0,ROUND((G3*P3*1/300*Q3),2),0))","v":4207.8599999999997}]
[73,null,"73/2","от","2020-10-31",724452,0,"2020-11-09","2020-11-12","2020-11-30","2020-12-01",0,0,0,"",{"$f":"IF(O4=\"+\",IF(J4>$O$1,\"0\",IF(O4=\"+\",VALUE($O$1)-VALUE(K4),$O$1-H4))+IF(G4=0,0,IF(AND(A4>=A5,H4>0,H5-H4),H5-H4)),IF(J4>$O$1,\"0\",IF(G4=0,0,IF(AND(A4>=A5),ABS(H5-H4),IF(AND(A4<>A5,B4=\"\",B5<>0),VALUE($O$1)-VALUE(H4),IF(A4<>A5,H4-K4,IF(O4=\"+\",VALUE($O$1)-VALUE(K4),$O$1-H4)))))))","v":0},{"$f":"IF(G4=0,0,IF(AND(A4<=A5,P4>0),Get_KeyRate(H5),Get_KeyRate($O$1)))","v":0},0]
[74,50932035.93,"74/1","от","2020-03-31",7062289.8200000003,43869746.109999999,"2020-04-15","2020-04-29","2020-11-30","2020-12-01",0,0,0,"",64,{"$f":"IF(G5=0,0,IF(AND(A5<=A6,P5>0),Get_KeyRate(H6),Get_KeyRate($O$1)))","v":5.5E-2},514738.35]
[74,null,"74/2","от","2020-06-02",6597658.4100000001,37272087.700000003,"2020-06-18","2020-06-22","2020-11-30","2020-12-01",0,0,0,"",25,{"$f":"IF(G6=0,0,IF(AND(A6<=A7,P6>0),Get_KeyRate(H7),Get_KeyRate($O$1)))","v":4.4999999999999998E-2},139770.32999999999]
[74,null,"74/3","от","2020-06-30",371612.88,36900474.82,"2020-07-13","2020-07-20","2020-11-30","2020-12-01",0,0,0,"",31,{"$f":"IF(G7=0,0,IF(AND(A7<=A8,P7>0),Get_KeyRate(H8),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},162054.59]
[74,null,"74/4","от","2020-07-31",2730407.12,34170067.700000003,"2020-08-13","2020-08-19","2020-11-30","2020-12-01",0,0,0,"",21,{"$f":"IF(G8=0,0,IF(AND(A8<=A9,P8>0),Get_KeyRate(H9),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},101655.95]
[74,null,"74/5","от","2020-08-31",4463924.49,29706143.210000001,"2020-09-03","2020-09-11","2020-11-30","2020-12-01",0,0,0,"",33,{"$f":"IF(G9=0,0,IF(AND(A9<=A10,P9>0),Get_KeyRate(H10),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},138876.22]
[74,null,"74/6","от","2020-09-30",4125903.08,25580240.129999999,"2020-10-06","2020-10-13","2020-11-30","2020-12-01",0,0,0,"",34,{"$f":"IF(G10=0,0,IF(AND(A10<=A11,P10>0),Get_KeyRate(H11),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},123211.49]
[74,null,"74/7","от","2020-10-31",793826.24,24786413.890000001,"2020-11-09","2020-11-12","2020-11-30","2020-12-01",0,0,0,"",44144,{"$f":"IF(G11=0,0,IF(AND(A11<=A12,P11>0),Get_KeyRate(H12),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},155007622.75999999]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H4-H3","v":-41}]