{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ЦАОП"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":1,"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":109,"n_cols":20,"rows_kept":109,"cut":false,"hidden":false,"merged":[[87,19,92,19],[93,19,95,19],[96,19,98,19],[102,19,108,19],[0,18,0,19],[1,19,11,19],[13,19,15,19],[16,19,20,19],[21,19,24,19],[26,19,28,19],[29,19,38,19],[39,19,42,19],[43,19,46,19]]}
["№ этапа","Цена этапа","№\nакта",null,"Дата акта","Сумма акта","Остаток \nпо этапу","Дата вх.","Дата приемки\n(подписания акта)","Срок по контракту","Рабочий\n+1","Просрочено дней","По 1му акту","Ставка\nпо актам","2021-03-19","На остаток","Ставка по просрочке","Сумма","Праздники"]
[1,53547,"1","от","2020-05-15",53547,{"$f":"ROUND(IF(B2>0,B2-F2,G1-F2),2)","v":0},"2020-05-22","2020-05-22","2020-01-31",{"$f":"WORKDAY.INTL(J2,1,1,$S$2:$S$109)","v":"2020-02-03"},{"$f":"IF(H2>K2,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,IF(AND(A2<>A3,B2=\"\",B3<>0),VALUE($O$1)-VALUE(H2),IF(A2<>A3,ABS(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","2020-05-22","2020-02-29","2020-03-02",{"$f":"IF(H3>K3,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":""},{"$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,H3>0),H4-H3,IF(AND(A3<>A4,B3=\"\",B4<>0),VALUE($O$1)-VALUE(H3),IF(A3<>A4,ABS(H3-K3),IF(O3=\"+\",VALUE($O$1)-VALUE(K3),$O$1-H3)))))))","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","2020-05-22","2020-02-29","2020-03-02",82,1246.4100000000001,5.5E-2,"",{"$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,H4>0),H5-H4,IF(AND(A4<>A5,B4=\"\",B5<>0),VALUE($O$1)-VALUE(H4),IF(A4<>A5,ABS(H4-K4),IF(O4=\"+\",VALUE($O$1)-VALUE(K4),$O$1-H4)))))))","v":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},{"$f":"IF(G4=0,0,IF(P4>0,ROUND((G4*P4*1/300*Q4),2),0))","v":0.03},"2019-01-03"]
[4,849598,"4/1","от","2020-12-08",340228.86,509369.14,"2020-12-09","2020-12-11","2020-02-29","2020-03-02",283,34061.800000000003,4.2500000000000003E-2,"",57,{"$f":"IF(G5=0,0,IF(AND(A5<=A7,P5>0,H5<>0),Get_KeyRate(H7),Get_KeyRate($O$1)))","v":5.5E-2},5322.91,"2019-01-04"]
[4,null,"4/2","от","2021-02-02",509369.14,0,"2021-02-04","2021-02-12","2020-02-29","2020-03-02",340,{"$f":"IF(B6>0,ROUND((B6*L6*1/300*N6),2),0)","v":0},{"$f":"IF(L6=0,0,Get_KeyRate(H6))","v":4.2500000000000003E-2},{"$f":"IF(AND(E6=0,F6=0,H6=0),\"+\",\"\")","v":""},{"$f":"IF(O6=\"+\",IF(J6>$O$1,\"0\",IF(O6=\"+\",VALUE($O$1)-VALUE(K6),$O$1-H6))+IF(G6=0,0,IF(AND(A6>=A7,H6>0,H7-H6),H7-H6)),IF(J6>$O$1,\"0\",IF(G6=0,0,IF(AND(A6>=A7,H6>0),H7-H6,IF(AND(A6<>A7,B6=\"\",B7<>0),VALUE($O$1)-VALUE(H6),IF(A6<>A7,ABS(H6-K6),IF(O6=\"+\",VALUE($O$1)-VALUE(K6),$O$1-H6)))))))","v":0},{"$f":"IF(G6=0,0,IF(AND(A6<=A8,P6>0,H6<>0),Get_KeyRate(H8),Get_KeyRate($O$1)))","v":0},{"$f":"IF(G6=0,0,IF(P6>0,ROUND((G6*P6*1/300*Q6),2),0))","v":0}]
[5,2262215,"5/1","от","2020-05-15",1543724,{"$f":"ROUND(IF(B7>0,B7-F7,G5-F7),2)","v":718491},"2020-05-22","2020-05-22","2020-03-31","2020-04-01",52,21566.45,5.5E-2,"",-43973,{"$f":"IF(G7=0,0,IF(AND(A7<=A8,P7>0,H7<>0),Get_KeyRate(H8),Get_KeyRate($O$1)))","v":4.2500000000000003E-2},0,"2019-01-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-06"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-23","День защитника отеч."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-08","Международный женский день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01","Праздник весны и труда"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-09","День победы"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-12","День России"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-02","День народного единства"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01","каникулы"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-04"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-06"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-22","День защитника отеч."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-23"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-07","Международный женский день"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-08"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-03"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-09"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-13"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-21"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-22"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01","День труда"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-04"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-09","День победы"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-12","День России"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-24","День победы"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-04","День нар. един-ва"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01","каникулы"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-04"]
["ИТОГО",{"$f":"_xlfn.AGGREGATE(9,5,B2:B106)","v":3877395},null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,F2:F106)","v":3149154},null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,M2:M106)","v":67412.37000000001},null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,R2:R106)","v":5467.68},"2021-01-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-08"]