{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ЦАОП (итог)","ЦАОП (0)","Вопрос"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":2,"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":98,"n_cols":19,"rows_kept":98,"cut":false,"hidden":false,"merged":[[80,18,82,18],[83,18,85,18],[0,17,0,18],[1,18,9,18],[11,18,13,18],[14,18,18,18],[19,18,22,18],[24,18,26,18],[27,18,34,18],[35,18,37,18],[38,18,40,18],[75,18,79,18]]}
["№ этапа","Цена этапа","№\nакта",null,"Дата акта i","Сумма акта 1","Остаток \nпо этапу","дата получения заказчиком акта приемки выполненных работ","Срок по контракту","Рабочий\n+1","Просрочено дней","Неустойка по 1му акту","Ставка\nпо актам","2020-11-16","На остаток/\nпериод просрочки","Ставка по просрочке, новый вариант\nИ(A2<=A3;O2>0;H2<>0)","Сумма","Праздники"]
[1,53547,"1","от","2020-05-15",53547,{"$f":"ROUND(IF(B2>0,B2-F2,G1-F2),2)","v":0},"2020-05-22","2020-01-31",{"$f":"WORKDAY.INTL(I2,1,1,$R$2:$R$88)","v":"2020-02-03"},{"$f":"IF(AND(H2>J2,B2>0),H2-J2+1,0)","v":110},{"$f":"IF(B2>0,ROUND((B2*K2*1/300*M2),2),0)","v":1079.8599999999999},{"$f":"IF(K2=0,0,Get_KeyRate(H2))","v":5.5E-2},{"$f":"IF(AND(E2=0,F2=0,H2=0),\"+\",\"\")","v":""},{"$f":"IF(N2=\"+\",IF(I2>$N$1,\"0\",IF(N2=\"+\",VALUE($N$1)-VALUE(J2),$N$1-H2))+IF(G2=0,0,IF(AND(A2>=A3,H2>0,H3-H2),H3-H2)),IF(I2>$N$1,\"0\",IF(G2=0,0,IF(AND(A2>=A3,H2>0,H3-H2),H3-H2,IF(AND(A2<>A3,B2=\"\",B3<>0),VALUE($N$1)-VALUE(H2),IF(A2<>A3,H2-J2,IF(N2=\"+\",VALUE($N$1)-VALUE(J2),$N$1-H2)))))))","v":0},{"$f":"IF(G2=0,0,IF(AND(A2<=A3,O2>0,H2<>0),Get_KeyRate(H3),Get_KeyRate($N$1)))","v":0},{"$f":"IF(G2=0,0,IF(O2>0,ROUND((G2*O2*1/300*P2),2),0))","v":0},"2019-01-01","каникулы"]
[2,629125,"2/1","от","2020-05-15",619378,9747,"2020-05-22","2020-02-29",{"$f":"WORKDAY.INTL(I3,1,1,$R$2:$R$88)","v":"2020-03-02"},{"$f":"IF(AND(H3>J3,B3>0),H3-J3+1,0)","v":82},9457.85,5.5E-2,"",81,{"$f":"IF(G3=0,0,IF(AND(A3<=A4,O3>0,H3<>0),Get_KeyRate(H4),Get_KeyRate($N$1)))","v":5.5E-2},{"$f":"IF(G3=0,0,IF(O3>0,ROUND((G3*O3*1/300*P3),2),0))","v":144.74},"2019-01-02"]
[3,82910,"3","от","2020-05-15",82907,3,"2020-05-22","2020-02-29",{"$f":"WORKDAY.INTL(I4,1,1,$R$2:$R$88)","v":"2020-03-02"},82,1246.4100000000001,5.5E-2,"",81,{"$f":"IF(G4=0,0,IF(AND(A4<=A5,O4>0,H4<>0),Get_KeyRate(H5),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0.03,"2019-01-03"]
[4,849598,null,null,0,0,849598,0,"2020-02-29",{"$f":"WORKDAY.INTL(I5,1,1,$R$2:$R$88)","v":"2020-03-02"},0,0,0,{"$f":"IF(OR(E5=0,F5=0,H5=0),\"+\",\"\")","v":"+"},{"$f":"IF(N5=\"+\",IF(I5>$N$1,\"0\",IF(N5=\"+\",VALUE($N$1)-VALUE(J5),$N$1-H5))+IF(G5=0,0,IF(AND(A5>=A6,H5>0,H6-H5),H6-H5)),IF(I5>$N$1,\"0\",IF(G5=0,0,IF(AND(A5>=A6,H5>0,H6-H5),H6-H5,IF(AND(A5<>A6,B5=\"\",B6<>0),VALUE($N$1)-VALUE(H5),IF(A5<>A6,H5-J5,IF(N5=\"+\",VALUE($N$1)-VALUE(J5),$N$1-H5)))))))","v":259},{"$f":"IF(G5=0,0,IF(AND(A5<=A6,O5>0,H5<>0),Get_KeyRate(H6),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},31173.17,"2019-01-04"]
[5,2262215,"5/1","от","2020-05-15",1543724,718491,"2019-12-20","2019-12-24",{"$f":"WORKDAY.INTL(I6,1,1,$R$2:$R$88)","v":"2019-12-25"},0,{"$f":"IF(B6>0,ROUND((B6*K6*1/300*M6),2),0)","v":0},0,{"$f":"IF(OR(E6=0,F6=0,H6=0),\"+\",\"\")","v":""},332,{"$f":"IF(G6=0,0,IF(AND(A6<=A7,O6>0,H6<>0),Get_KeyRate(H7),Get_KeyRate($N$1)))","v":6.25E-2},49695.63,"2019-01-05"]
[5,null,"5/2","от","2020-06-11",358923.6,359567.4,"2019-12-20","2019-12-24","2019-12-25",0,{"$f":"IF(B7>0,ROUND((B7*K7*1/300*M7),2),0)","v":0},0,"",{"$f":"IF(N7=\"+\",IF(I7>$N$1,\"0\",IF(N7=\"+\",VALUE($N$1)-VALUE(J7),$N$1-H7))+IF(G7=0,0,IF(AND(A7>=A9,H7>0,H9-H7),H9-H7)),IF(I7>$N$1,\"0\",IF(G7=0,0,IF(AND(A7>=A9,H7>0,H9-H7),H9-H7,IF(AND(A7<>A9,B7=\"\",B9<>0),VALUE($N$1)-VALUE(H7),IF(A7<>A9,H7-J7,IF(N7=\"+\",VALUE($N$1)-VALUE(J7),$N$1-H7)))))))","v":332},{"$f":"IF(G7=0,0,IF(AND(A7<=A8,O7>0,H7<>0),Get_KeyRate(H8),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},16911.650000000001,"2019-01-06"]
[5,null,"5/3","от","2020-11-13",194773.98,164793.42000000001,"2020-11-13","2019-12-24","2019-12-25",0,0,{"$f":"IF(K8=0,0,Get_KeyRate(H8))","v":0},{"$f":"IF(AND(E8=0,F8=0,H8=0),\"+\",\"\")","v":""},{"$f":"IF(N8=\"+\",IF(I8>$N$1,\"0\",IF(N8=\"+\",VALUE($N$1)-VALUE(J8),$N$1-H8))+IF(G8=0,0,IF(AND(A8>=A9,H8>0,H9-H8),H9-H8)),IF(I8>$N$1,\"0\",IF(G8=0,0,IF(AND(A8>=A9,H8>0,H9-H8),H9-H8,IF(AND(A8<>A9,B8=\"\",B9<>0),VALUE($N$1)-VALUE(H8),IF(A8<>A9,H8-J8,IF(N8=\"+\",VALUE($N$1)-VALUE(J8),$N$1-H8)))))))","v":3},{"$f":"IF(G8=0,0,IF(AND(A8<=A9,O8>0,H8<>0),Get_KeyRate(H9),Get_KeyRate($N$1)))","v":5.5E-2},90.64]
[6,4264318,"6","от","2020-05-15",4264318,{"$f":"ROUND(IF(B9>0,B9-F9,G7-F9),2)","v":0},"2020-05-22","2020-03-31",{"$f":"WORKDAY.INTL(I9,1,1,$R$2:$R$88)","v":"2020-04-01"},52,40653.160000000003,5.5E-2,"",0,{"$f":"IF(G9=0,0,IF(AND(A9<=A10,O9>0,H9<>0),Get_KeyRate(H10),Get_KeyRate($N$1)))","v":0},0,"2019-01-07"]
[7,447601,"7/1","от","2020-09-25",175416,272185,"2020-09-25","2020-04-30","2020-05-06",143,9067.65,4.2500000000000003E-2,"",42,{"$f":"IF(G10=0,0,IF(AND(A10<=A11,O10>0,H10<>0),Get_KeyRate(H11),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1619.5,"2019-01-08"]
[7,null,"7/2","от","2020-11-06",224442.44,47742.559999999998,"2020-11-06","2020-04-30","2020-05-06",0,0,0,"",10,{"$f":"IF(G11=0,0,IF(AND(A11<=A12,O11>0,H11<>0),Get_KeyRate(H12),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},67.64,"2019-02-23","День защитника отеч."]
[8,9488.9999999999982,null,null,null,null,9489,null,"2020-04-30","2020-05-06",0,0,0,"+",194,{"$f":"IF(G12=0,0,IF(AND(A12<=A13,O12>0,H12<>0),Get_KeyRate(H13),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},260.79000000000002,"2019-03-08","Международный женский день"]
[9,3399442,"9/1","от","2020-06-11",1674162,1725280,"2020-06-15","2020-06-30","2020-07-01",0,0,0,"",42,{"$f":"IF(G13=0,0,IF(AND(A13<=A14,O13>0,H13<>0),Get_KeyRate(H14),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},10265.42,"2019-03-09"]
[9,null,"9/2","от","2020-07-27",1222496.3999999999,502783.6,"2020-07-27","2020-06-30","2020-07-01",0,0,0,"",{"$f":"IF(N14=\"+\",IF(I14>$N$1,\"0\",IF(N14=\"+\",VALUE($N$1)-VALUE(J14),$N$1-H14))+IF(G14=0,0,IF(AND(A14>=A15,H14>0,H15-H14),H15-H14)),IF(I14>$N$1,\"0\",IF(G14=0,0,IF(AND(A14>=A15,H14>0,H15-H14),H15-H14,IF(AND(A14<>A15,B14=\"\",B15<>0),VALUE($N$1)-VALUE(H14),IF(A14<>A15,H14-J14,IF(N14=\"+\",VALUE($N$1)-VALUE(J14),$N$1-H14)))))))","v":29},{"$f":"IF(G14=0,0,IF(AND(A14<=A15,O14>0,H14<>0),Get_KeyRate(H15),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},2065.6,"2019-03-10"]
[9,null,"9/3","от","2020-08-20",75850.59,426933.01,"2020-08-25","2020-06-30","2020-07-01",0,0,0,{"$f":"IF(AND(E15=0,F15=0,H15=0),\"+\",\"\")","v":""},31,{"$f":"IF(G15=0,0,IF(AND(A15<=A16,O15>0,H15<>0),Get_KeyRate(H16),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1874.95,"2019-05-01","Праздник весны и труда"]
[9,null,"9/4","от","2020-09-25",257509.2,169423.81,"2020-09-25","2020-06-30","2020-07-01",0,0,0,"",52,{"$f":"IF(G16=0,0,IF(AND(A16<=A17,O16>0,H16<>0),Get_KeyRate(H17),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1248.0899999999999,"2019-05-02"]
[10,1133000,"10/1","от","2020-07-27",411991.2,721008.8,"2020-07-27","2020-06-30","2020-07-01",27,4333.7299999999996,4.2500000000000003E-2,"",29,{"$f":"IF(G17=0,0,IF(AND(A17<=A18,O17>0,H17<>0),Get_KeyRate(H18),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},2962.14,"2019-05-03"]
[10,null,"10/2","от","2020-08-20",367264.8,353744,"2020-08-25","2020-06-30","2020-07-01",0,0,0,"",31,{"$f":"IF(G18=0,0,IF(AND(A18<=A19,O18>0,H18<>0),Get_KeyRate(H19),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1553.53,"2019-05-04"]
[10,null,"10/3","от","2020-09-25",353744,0,"2020-09-25","2020-06-30","2020-07-01",0,0,0,"",0,{"$f":"IF(G19=0,0,IF(AND(A19<=A20,O19>0,H19<>0),Get_KeyRate(H20),Get_KeyRate($N$1)))","v":0},0,"2019-05-05"]
[11,3004223,"11/1","от","2020-05-15",842136,2162087,"2020-05-22","2020-06-30","2020-07-01",0,0,0,"",24,{"$f":"IF(G20=0,0,IF(AND(A20<=A21,O20>0,H20<>0),Get_KeyRate(H21),Get_KeyRate($N$1)))","v":5.5E-2},9513.18,"2019-05-09","День победы"]
[11,null,"11/2","от","2020-06-11",663872.4,1498214.6,"2020-06-15","2020-06-30","2020-07-01",0,0,0,"",42,{"$f":"IF(G21=0,0,IF(AND(A21<=A22,O21>0,H21<>0),Get_KeyRate(H22),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},8914.3799999999992,"2019-05-10"]
[11,null,"11/3","от","2020-07-27",1112151.6000000001,386063,"2020-07-27","2020-06-30","2020-07-01",0,0,0,"",29,{"$f":"IF(G22=0,0,IF(AND(A22<=A23,O22>0,H22<>0),Get_KeyRate(H23),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1586.08,"2019-05-11"]
[11,null,"11/4","от","2020-08-20",308734.8,77328.2,"2020-08-25","2020-06-30","2020-07-01",0,0,0,"",31,{"$f":"IF(G23=0,0,IF(AND(A23<=A24,O23>0,H23<>0),Get_KeyRate(H24),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},339.6,"2019-05-12"]
[11,null,"11/4","от","2020-09-25",75927.600000000006,1400.6,"2020-09-25","2020-06-30","2020-07-01",0,0,0,"",52,{"$f":"IF(G24=0,0,IF(AND(A24<=A25,O24>0,H24<>0),Get_KeyRate(H25),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},10.32,"2019-06-12","День России"]
[12,428264.00000000006,"12/1","от","2020-08-20",78234,350030,"2020-08-25","2020-06-30","2020-07-01",56,3397.56,4.2500000000000003E-2,"",31,{"$f":"IF(G25=0,0,IF(AND(A25<=A26,O25>0,H25<>0),Get_KeyRate(H26),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1537.22,"2019-11-02","День народного единства"]
[12,null,"12/2","от","2020-09-25",350030,0,"2020-09-25","2020-06-30","2020-07-01",0,0,0,"",0,{"$f":"IF(G26=0,0,IF(AND(A26<=A27,O26>0,H26<>0),Get_KeyRate(H27),Get_KeyRate($N$1)))","v":0},0,"2019-11-03"]
[13,728400,null,null,null,null,728400,null,"2020-06-30","2020-07-01",0,0,0,"+",138,{"$f":"IF(G27=0,0,IF(AND(A27<=A28,O27>0,H27<>0),Get_KeyRate(H28),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},14240.22,"2019-11-04"]
[14,278614,null,null,null,null,278614,null,"2020-06-30","2020-07-01",0,0,0,"+",138,{"$f":"IF(G28=0,0,IF(AND(A28<=A29,O28>0,H28<>0),Get_KeyRate(H29),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5446.9,"2020-01-01","каникулы"]
[15,1158016.9999999998,"15/1","от","2020-06-11",172428,985589,"2020-06-15","2020-06-30","2020-07-01",0,0,0,"",144,{"$f":"IF(G29=0,0,IF(AND(A29<=A30,O29>0,H29<>0),Get_KeyRate(H30),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},20106.02,"2020-01-02"]
[15,null,"15/2","от","2020-11-06",829850.76,155738.23999999999,"2020-11-06","2020-06-30","2020-07-01",0,0,0,"",10,{"$f":"IF(G30=0,0,IF(AND(A30<=A31,O30>0,H30<>0),Get_KeyRate(H31),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},220.63,"2020-01-03"]
[16,732344,"16/1","от","2020-09-25",657691.19999999995,74652.800000000003,"2020-09-25","2020-06-30","2020-07-01",87,9026.14,4.2500000000000003E-2,"",86,{"$f":"IF(G31=0,0,IF(AND(A31<=A32,O31>0,H31<>0),Get_KeyRate(H32),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},909.52,"2020-01-04"]
[17,321117,null,null,null,null,321117,null,"2020-06-30","2020-07-01",0,0,0,"+",138,{"$f":"IF(G32=0,0,IF(AND(A32<=A33,O32>0,H32<>0),Get_KeyRate(H33),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},6277.84,"2020-01-05"]
[18,3575511,"18/1","от","2020-09-25",25263.599999999999,3550247.4,"2020-09-25","2020-07-31","2020-08-03",54,27352.66,4.2500000000000003E-2,"",53,{"$f":"IF(G33=0,0,IF(AND(A33<=A34,O33>0,H33<>0),Get_KeyRate(H34),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},26656.44,"2020-01-06"]
[19,1939736,null,null,null,null,1939736,null,"2020-07-31","2020-08-03",0,0,0,"+",105,{"$f":"IF(G34=0,0,IF(AND(A34<=A35,O34>0,H34<>0),Get_KeyRate(H35),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},28853.57,"2020-01-07"]
[20,53707.000000000007,null,null,null,null,53707,null,"2020-07-31","2020-08-03",0,0,0,"+",105,{"$f":"IF(G35=0,0,IF(AND(A35<=A36,O35>0,H35<>0),Get_KeyRate(H36),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},798.89,"2020-01-08"]
[21,1089795,null,null,null,null,1089795,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G36=0,0,IF(AND(A36<=A37,O36>0,H36<>0),Get_KeyRate(H37),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},11733.46,"2020-02-22","День защитника отеч."]
[22,726119,null,null,null,null,726119,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G37=0,0,IF(AND(A37<=A38,O37>0,H37<>0),Get_KeyRate(H38),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},7817.88,"2020-02-23"]
[23,1386200,null,null,null,null,1386200,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G38=0,0,IF(AND(A38<=A39,O38>0,H38<>0),Get_KeyRate(H39),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},14924.75,"2020-02-24"]
[24,961895.00000000012,"24/1","от","2020-08-20",163862.39999999999,798032.6,"2020-08-25","2020-08-31","2020-09-01",0,0,0,"",31,{"$f":"IF(G39=0,0,IF(AND(A39<=A40,O39>0,H39<>0),Get_KeyRate(H40),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},3504.69,"2020-03-07","Международный женский день"]
[24,null,"24/2","от","2020-09-25",94658.4,703374.2,"2020-09-25","2020-08-31","2020-09-01",0,0,0,"",52,{"$f":"IF(G40=0,0,IF(AND(A40<=A41,O40>0,H40<>0),Get_KeyRate(H41),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5181.5200000000004,"2020-03-08"]
[25,2863205,"25/1","от","2020-09-25",2751631.2,111573.8,"2020-09-25","2020-08-31",{"$f":"WORKDAY.INTL(I41,1,1,$R$2:$R$88)","v":"2020-09-01"},25,10140.52,4.2500000000000003E-2,"",24,{"$f":"IF(G41=0,0,IF(AND(A41<=A42,O41>0,H41<>0),Get_KeyRate(H42),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},379.35,"2020-03-09"]
[26,132598,null,null,null,null,132598,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G42=0,0,IF(AND(A42<=A43,O42>0,H42<>0),Get_KeyRate(H43),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1427.64,null,"2020-03-28"]
[27,520685.99999999994,null,null,null,null,520686,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G43=0,0,IF(AND(A43<=A44,O43>0,H43<>0),Get_KeyRate(H44),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5606.05,null,"2020-03-29"]
[28,488182.00000000006,null,null,null,null,488182,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G44=0,0,IF(AND(A44<=A45,O44>0,H44<>0),Get_KeyRate(H45),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5256.09,null,"2020-03-30"]
[29,249138,"29/1","от","2020-08-20",227139.6,21998.400000000001,"2020-08-25","2020-08-31","2020-09-01",0,0,0,"",73,{"$f":"IF(G45=0,0,IF(AND(A45<=A46,O45>0,H45<>0),Get_KeyRate(H46),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},227.5,null,"2020-03-31"]
[29,null,"29/2","от","2020-11-06",17653.5,4344.8999999999996,"2020-11-06","2020-08-31","2020-09-01",0,0,0,"",10,{"$f":"IF(G46=0,0,IF(AND(A46<=A47,O46>0,H46<>0),Get_KeyRate(H47),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},6.16,null,"2020-04-01"]
[30,46809,null,null,null,null,46809,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G47=0,0,IF(AND(A47<=A48,O47>0,H47<>0),Get_KeyRate(H48),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},503.98,null,"2020-04-02"]
[31,3905532,null,null,null,null,3905532,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G48=0,0,IF(AND(A48<=A49,O48>0,H48<>0),Get_KeyRate(H49),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},25451.05,null,"2020-04-03"]
[32,2742453.9999999995,null,null,null,null,2742454,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G49=0,0,IF(AND(A49<=A50,O49>0,H49<>0),Get_KeyRate(H50),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},17871.66,null,"2020-04-04"]
[33,92166,"33/1","от","2020-11-06",92166,0,"2020-11-06","2020-09-30","2020-10-01",37,483.1,4.2500000000000003E-2,"",0,{"$f":"IF(G50=0,0,IF(AND(A50<=A51,O50>0,H50<>0),Get_KeyRate(H51),Get_KeyRate($N$1)))","v":0},0,null,"2020-04-05"]
[34,1239826.9999999998,"34/1","от","2020-11-06",918350.84,321476.15999999997,"2020-11-06","2020-09-30","2020-10-01",37,6498.76,4.2500000000000003E-2,"",36,{"$f":"IF(G51=0,0,IF(AND(A51<=A52,O51>0,H51<>0),Get_KeyRate(H52),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1639.53,null,"2020-04-06"]
[35,1268541,null,null,null,null,1268541,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G52=0,0,IF(AND(A52<=A53,O52>0,H52<>0),Get_KeyRate(H53),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},8266.66,null,"2020-04-07"]
[36,565450,"36/1","от","2020-08-20",248911.2,316538.8,"2020-08-25","2020-09-30","2020-10-01",0,0,0,"",73,{"$f":"IF(G53=0,0,IF(AND(A53<=A54,O53>0,H53<>0),Get_KeyRate(H54),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},3273.54,null,"2020-04-08"]
[36,null,"36/2","от","2020-11-06",314161.68,2377.12,"2020-11-06","2020-09-30","2020-10-01",0,0,0,"",10,{"$f":"IF(G54=0,0,IF(AND(A54<=A55,O54>0,H54<>0),Get_KeyRate(H55),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},3.37,null,"2020-04-09"]
[37,2349763,null,null,null,null,2349763,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G55=0,0,IF(AND(A55<=A56,O55>0,H55<>0),Get_KeyRate(H56),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},15312.62,null,"2020-04-10"]
[38,249273.99999999997,null,null,null,null,249274,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G56=0,0,IF(AND(A56<=A57,O56>0,H56<>0),Get_KeyRate(H57),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1624.44,null,"2020-04-11"]
[39,220754,null,null,null,null,220754,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G57=0,0,IF(AND(A57<=A58,O57>0,H57<>0),Get_KeyRate(H58),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1438.58,null,"2020-04-12"]
[40,130039.00000000001,null,null,null,null,130039,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G58=0,0,IF(AND(A58<=A59,O58>0,H58<>0),Get_KeyRate(H59),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},847.42,null,"2020-04-13"]
[41,2692844,null,null,null,null,2692844,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G59=0,0,IF(AND(A59<=A60,O59>0,H59<>0),Get_KeyRate(H60),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},17548.37,null,"2020-04-14"]
[42,2947091.0000000005,null,null,null,null,2947091,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G60=0,0,IF(AND(A60<=A61,O60>0,H60<>0),Get_KeyRate(H61),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5845.06,null,"2020-04-15"]
[43,151713,null,null,null,null,151713,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G61=0,0,IF(AND(A61<=A62,O61>0,H61<>0),Get_KeyRate(H62),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},300.89999999999998,null,"2020-04-16"]
[44,709075.99999999988,null,null,null,null,709076,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G62=0,0,IF(AND(A62<=A63,O62>0,H62<>0),Get_KeyRate(H63),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1406.33,null,"2020-04-17"]
[45,2642410,null,null,null,null,2642410,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G63=0,0,IF(AND(A63<=A64,O63>0,H63<>0),Get_KeyRate(H64),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5240.78,null,"2020-04-18"]
[46,151661,null,null,null,null,151661,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G64=0,0,IF(AND(A64<=A65,O64>0,H64<>0),Get_KeyRate(H65),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},300.79000000000002,null,"2020-04-19"]
[47,77993,null,null,null,null,77993,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G65=0,0,IF(AND(A65<=A66,O65>0,H65<>0),Get_KeyRate(H66),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},154.69,null,"2020-04-20"]
[48,1290301.9999999998,null,null,null,null,1290302,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G66=0,0,IF(AND(A66<=A67,O66>0,H66<>0),Get_KeyRate(H67),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},2559.1,null,"2020-04-21"]
[49,613132.00000000012,null,null,null,null,{"$f":"ROUND(IF(B67>0,B67-F67,G66-F67),2)","v":613132},null,"2020-10-31","2020-11-02",0,0,{"$f":"IF(K67=0,0,Get_KeyRate(H67))","v":0},"+",14,{"$f":"IF(G67=0,0,IF(AND(A67<=A68,O67>0,H67<>0),Get_KeyRate(H68),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1216.05,null,"2020-04-22"]
[50,304143,null,null,null,null,304143,null,"2020-10-31","2020-11-02",{"$f":"IF(AND(H68>J68,B68>0),H68-J68+1,0)","v":0},0,0,"+",14,{"$f":"IF(G68=0,0,IF(AND(A68<=A69,O68>0,H68<>0),Get_KeyRate(H69),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},{"$f":"IF(G68=0,0,IF(O68>0,ROUND((G68*O68*1/300*P68),2),0))","v":603.22},null,"2020-04-23"]
[51,733234,null,null,null,null,733234,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G69=0,0,IF(AND(A69<=A70,O69>0,H69<>0),Get_KeyRate(H70),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1454.25,null,"2020-04-24"]
[52,2126970,null,null,null,null,2126970,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G70=0,0,IF(AND(A70<=A71,O70>0,H70<>0),Get_KeyRate(H71),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},4218.49,null,"2020-04-25"]
[53,1067534,null,null,null,null,1067534,null,"2020-11-30","2020-12-01",0,0,0,{"$f":"IF(AND(E71=0,F71=0,H71=0),\"+\",\"\")","v":"+"},0,{"$f":"IF(G71=0,0,IF(AND(A71<=A72,O71>0,H71<>0),Get_KeyRate(H72),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-26"]
[54,5044770,null,null,null,null,5044770,null,"2020-11-30","2020-12-01",0,{"$f":"IF(B72>0,ROUND((B72*K72*1/300*M72),2),0)","v":0},0,"+",0,{"$f":"IF(G72=0,0,IF(AND(A72<=A73,O72>0,H72<>0),Get_KeyRate(H73),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-27"]
[55,427621,null,null,null,null,427621,null,"2020-11-30",{"$f":"WORKDAY.INTL(I73,1,1,$R$2:$R$88)","v":"2020-12-01"},0,0,0,"+",0,{"$f":"IF(G73=0,0,IF(AND(A73<=A74,O73>0,H73<>0),Get_KeyRate(H74),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-28"]
[56,134723,null,null,null,null,134723,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G74=0,0,IF(AND(A74<=A75,O74>0,H74<>0),Get_KeyRate(H75),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-29"]
[57,23508,null,null,null,null,23508,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G75=0,0,IF(AND(A75<=A76,O75>0,H75<>0),Get_KeyRate(H76),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-30"]
[58,1563550,"58/1","от","2020-06-11",515787.6,1047762.4,"2020-06-15","2020-11-30","2020-12-01",0,0,0,"","0",{"$f":"IF(G76=0,0,IF(AND(A76<=A77,O76>0,H76<>0),Get_KeyRate(H77),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-01","День труда"]
[59,422081.00000000006,null,null,null,null,422081,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G77=0,0,IF(AND(A77<=A78,O77>0,H77<>0),Get_KeyRate(H78),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-02"]
[60,137670,null,null,null,null,137670,null,"2020-11-30","2020-12-01",0,0,0,"+",{"$f":"IF(N78=\"+\",IF(I78>$N$1,\"0\",IF(N78=\"+\",VALUE($N$1)-VALUE(J78),$N$1-H78))+IF(G78=0,0,IF(AND(A78>=A79,H78>0,H79-H78),H79-H78)),IF(I78>$N$1,\"0\",IF(G78=0,0,IF(AND(A78>=A79,H78>0,H79-H78),H79-H78,IF(AND(A78<>A79,B78=\"\",B79<>0),VALUE($N$1)-VALUE(H78),IF(A78<>A79,H78-J78,IF(N78=\"+\",VALUE($N$1)-VALUE(J78),$N$1-H78)))))))","v":0},{"$f":"IF(G78=0,0,IF(AND(A78<=A79,O78>0,H78<>0),Get_KeyRate(H79),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-03"]
[61,1834890.0000000002,null,null,null,null,1834890,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G79=0,0,IF(AND(A79<=A80,O79>0,H79<>0),Get_KeyRate(H80),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-04"]
[62,1470679,null,null,null,null,1470679,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G80=0,0,IF(AND(A80<=A81,O80>0,H80<>0),Get_KeyRate(H81),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-05"]
[63,723560,null,null,null,null,723560,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G81=0,0,IF(AND(A81<=A82,O81>0,H81<>0),Get_KeyRate(H82),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-09","День победы"]
[64,1527208.0000000002,null,null,null,null,1527208,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G82=0,0,IF(AND(A82<=A83,O82>0,H82<>0),Get_KeyRate(H83),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-10"]
[65,192440,null,null,null,null,192440,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G83=0,0,IF(AND(A83<=A84,O83>0,H83<>0),Get_KeyRate(H84),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-11"]
[66,6497143.9999999991,null,null,null,null,6497144,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G84=0,0,IF(AND(A84<=A85,O84>0,H84<>0),Get_KeyRate(H85),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-06-12","День России"]
[67,52577,null,null,null,null,52577,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G85=0,0,IF(AND(A85<=A86,O85>0,H85<>0),Get_KeyRate(H86),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-06-13"]
[68,60854.000000000007,null,null,null,null,60854,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G86=0,0,IF(AND(A86<=A87,O86>0,H86<>0),Get_KeyRate(H87),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-06-14"]
[69,34774,null,null,null,null,34774,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G87=0,0,IF(AND(A87<=A88,O87>0,H87<>0),Get_KeyRate(H88),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-06-24","День победы"]
[70,226911,null,null,null,null,226911,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G88=0,0,IF(AND(A88<=A89,O88>0,H88<>0),Get_KeyRate(H89),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-11-04","День нар. един-ва"]
[71,67167,null,null,null,null,67167,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G89=0,0,IF(AND(A89<=A90,O89>0,H89<>0),Get_KeyRate(H90),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
[72,78575,null,null,null,null,78575,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G90=0,0,IF(AND(A90<=A91,O90>0,H90<>0),Get_KeyRate(H91),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
[73,160659,null,null,null,null,160659,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G91=0,0,IF(AND(A91<=A92,O91>0,H91<>0),Get_KeyRate(H92),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
[74,97763.000000000015,null,null,null,null,97763,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G92=0,0,IF(AND(A92<=A93,O92>0,H92<>0),Get_KeyRate(H93),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
[75,282390,null,null,null,null,282390,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G93=0,0,IF(AND(A93<=A94,O93>0,H93<>0),Get_KeyRate(H94),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
[76,369078,null,null,null,null,369078,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G94=0,0,IF(AND(A94<=A95,O94>0,H94<>0),Get_KeyRate(H95),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
[77,58822,null,null,null,null,58822,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G95=0,0,IF(AND(A95<=A96,O95>0,H95<>0),Get_KeyRate(H96),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
[78,1579821,null,null,null,null,1579821,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G96=0,0,IF(AND(A96<=A97,O96>0,H96<>0),Get_KeyRate(H97),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
[79,3461161,"79/1","от","2020-05-15",2132190.8199999998,1328970.18,"2020-05-22","2021-01-31","2021-02-01",0,0,0,"","0",{"$f":"IF(G97=0,0,IF(AND(A97<=A98,O97>0,H97<>0),Get_KeyRate(H98),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0]
["ИТОГО",{"$f":"_xlfn.AGGREGATE(9,5,B2:B97)","v":88618104},null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,F2:F97)","v":24473281.41},null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,Q2:Q97)","v":418490.29999999987}]

{"sheet":"ЦАОП (0)","index":1,"n_rows":97,"n_cols":20,"rows_kept":97,"cut":false,"hidden":false,"merged":[[82,18,84,18],[0,17,0,18],[1,18,8,18],[10,18,12,18],[13,18,17,18],[18,18,21,18],[23,18,25,18],[26,18,33,18],[34,18,36,18],[37,18,39,18],[74,18,78,18],[79,18,81,18]]}
["№ этапа","Цена этапа","№\nакта",null,"Дата акта i","Сумма акта 1","Остаток \nпо этапу","дата получения заказчиком акта приемки выполненных работ","Срок по контракту","Рабочий\n+1","Просрочено дней","Неустойка по 1му акту","Ставка\nпо актам","2020-11-16","На остаток/\nпериод просрочки","Ставка по просрочке, старый вариант\nИ(A2<=A3;O2>0)","Сумма","Праздники",null,"Разность [P ЦАОП(итог)] -\n[Р ЦАОП(0)]"]
[1,53547,"1","от","2020-05-15",53547,{"$f":"ROUND(IF(B2>0,B2-F2,G1-F2),2)","v":0},"2020-05-22","2020-01-31",{"$f":"WORKDAY.INTL(I2,1,1,$R$2:$R$87)","v":"2020-02-03"},{"$f":"IF(AND(H2>J2,B2>0),H2-J2+1,0)","v":110},{"$f":"IF(B2>0,ROUND((B2*K2*1/300*M2),2),0)","v":1079.8599999999999},{"$f":"IF(K2=0,0,Get_KeyRate(H2))","v":5.5E-2},{"$f":"IF(AND(E2=0,F2=0,H2=0),\"+\",\"\")","v":""},{"$f":"IF(N2=\"+\",IF(I2>$N$1,\"0\",IF(N2=\"+\",VALUE($N$1)-VALUE(J2),$N$1-H2))+IF(G2=0,0,IF(AND(A2>=A3,H2>0,H3-H2),H3-H2)),IF(I2>$N$1,\"0\",IF(G2=0,0,IF(AND(A2>=A3,H2>0,H3-H2),H3-H2,IF(AND(A2<>A3,B2=\"\",B3<>0),VALUE($N$1)-VALUE(H2),IF(A2<>A3,H2-J2,IF(N2=\"+\",VALUE($N$1)-VALUE(J2),$N$1-H2)))))))","v":0},{"$f":"IF(G2=0,0,IF(AND(A2<=A3,O2>0),Get_KeyRate(H3),Get_KeyRate($N$1)))","v":0},{"$f":"IF(G2=0,0,IF(O2>0,ROUND((G2*O2*1/300*P2),2),0))","v":0},"2019-01-01","каникулы",{"$f":"'ЦАОП (итог)'!P2-'ЦАОП (0)'!P2","v":0}]
[2,629125,"2/1","от","2020-05-15",619378,9747,"2020-05-22","2020-02-29",{"$f":"WORKDAY.INTL(I3,1,1,$R$2:$R$87)","v":"2020-03-02"},{"$f":"IF(AND(H3>J3,B3>0),H3-J3+1,0)","v":82},9457.85,5.5E-2,"",81,{"$f":"IF(G3=0,0,IF(AND(A3<=A4,O3>0),Get_KeyRate(H4),Get_KeyRate($N$1)))","v":5.5E-2},{"$f":"IF(G3=0,0,IF(O3>0,ROUND((G3*O3*1/300*P3),2),0))","v":144.74},"2019-01-02",null,{"$f":"'ЦАОП (итог)'!P3-'ЦАОП (0)'!P3","v":0}]
[3,82910,"3","от","2020-05-15",82907,3,"2020-05-22","2020-02-29","2020-03-02",82,1246.4100000000001,5.5E-2,"",81,{"$f":"IF(G4=0,0,IF(AND(A4<=A5,O4>0),Get_KeyRate(H5),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0.03,"2019-01-03",null,{"$f":"'ЦАОП (итог)'!P4-'ЦАОП (0)'!P4","v":0}]
[4,849598,null,null,0,0,849598,0,"2020-02-29","2020-03-02",0,0,0,{"$f":"IF(OR(E5=0,F5=0,H5=0),\"+\",\"\")","v":"+"},259,{"$f":"IF(G5=0,0,IF(AND(A5<=A6,O5>0),Get_KeyRate(H6),Get_KeyRate($N$1)))","v":5.5E-2},40341.75,"2019-01-04",null,{"$f":"'ЦАОП (итог)'!P5-'ЦАОП (0)'!P5","v":-1.2499999999999997E-2}]
[5,2262215,"5/1","от","2020-05-15",1543724,718491,"2020-05-22","2020-03-31","2020-04-01",52,{"$f":"IF(B6>0,ROUND((B6*K6*1/300*M6),2),0)","v":21566.45},5.5E-2,{"$f":"IF(OR(E6=0,F6=0,H6=0),\"+\",\"\")","v":""},24,{"$f":"IF(G6=0,0,IF(AND(A6<=A7,O6>0),Get_KeyRate(H7),Get_KeyRate($N$1)))","v":5.5E-2},3161.36,"2019-01-05",null,{"$f":"'ЦАОП (итог)'!P6-'ЦАОП (0)'!P6","v":7.4999999999999997E-3}]
[5,null,"5/2","от","2020-06-11",358923.6,359567.4,"2020-06-15","2020-03-31","2020-04-01",0,{"$f":"IF(B7>0,ROUND((B7*K7*1/300*M7),2),0)","v":0},0,"",154,{"$f":"IF(G7=0,0,IF(AND(A7<=A8,O7>0),Get_KeyRate(H8),Get_KeyRate($N$1)))","v":5.5E-2},10151.790000000001,"2019-01-06",null,{"$f":"'ЦАОП (итог)'!P7-'ЦАОП (0)'!P7","v":-1.2499999999999997E-2}]
[6,4264318,"6","от","2020-05-15",4264318,0,"2020-05-22","2020-03-31","2020-04-01",52,40653.160000000003,5.5E-2,"",0,{"$f":"IF(G8=0,0,IF(AND(A8<=A9,O8>0),Get_KeyRate(H9),Get_KeyRate($N$1)))","v":0},0,"2019-01-07",null,{"$f":"'ЦАОП (итог)'!P9-'ЦАОП (0)'!P8","v":0}]
[7,447601,"7/1","от","2020-09-25",175416,272185,"2020-09-25","2020-04-30","2020-05-06",143,9067.65,4.2500000000000003E-2,"",42,{"$f":"IF(G9=0,0,IF(AND(A9<=A10,O9>0),Get_KeyRate(H10),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1619.5,"2019-01-08",null,{"$f":"'ЦАОП (итог)'!P10-'ЦАОП (0)'!P9","v":0}]
[7,null,"7/2","от","2020-11-06",224442.44,47742.559999999998,"2020-11-06","2020-04-30","2020-05-06",0,0,0,"",10,{"$f":"IF(G10=0,0,IF(AND(A10<=A11,O10>0),Get_KeyRate(H11),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},67.64,"2019-02-23","День защитника отеч.",{"$f":"'ЦАОП (итог)'!P11-'ЦАОП (0)'!P10","v":0}]
[8,9488.9999999999982,null,null,null,null,9489,null,"2020-04-30","2020-05-06",0,0,0,"+",194,{"$f":"IF(G11=0,0,IF(AND(A11<=A12,O11>0),Get_KeyRate(H12),Get_KeyRate($N$1)))","v":5.5E-2},337.49,"2019-03-08","Международный женский день",{"$f":"'ЦАОП (итог)'!P12-'ЦАОП (0)'!P11","v":-1.2499999999999997E-2}]
[9,3399442,"9/1","от","2020-06-11",1674162,1725280,"2020-06-15","2020-06-30","2020-07-01",0,0,0,"",42,{"$f":"IF(G12=0,0,IF(AND(A12<=A13,O12>0),Get_KeyRate(H13),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},10265.42,"2019-03-09",null,{"$f":"'ЦАОП (итог)'!P13-'ЦАОП (0)'!P12","v":0}]
[9,null,"9/2","от","2020-07-27",1222496.3999999999,502783.6,"2020-07-27","2020-06-30","2020-07-01",0,0,0,"",29,{"$f":"IF(G13=0,0,IF(AND(A13<=A14,O13>0),Get_KeyRate(H14),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},2065.6,"2019-03-10",null,{"$f":"'ЦАОП (итог)'!P14-'ЦАОП (0)'!P13","v":0}]
[9,null,"9/3","от","2020-08-20",75850.59,426933.01,"2020-08-25","2020-06-30","2020-07-01",0,0,0,{"$f":"IF(AND(E14=0,F14=0,H14=0),\"+\",\"\")","v":""},31,{"$f":"IF(G14=0,0,IF(AND(A14<=A15,O14>0),Get_KeyRate(H15),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1874.95,"2019-05-01","Праздник весны и труда",{"$f":"'ЦАОП (итог)'!P15-'ЦАОП (0)'!P14","v":0}]
[9,null,"9/4","от","2020-09-25",257509.2,169423.81,"2020-09-25","2020-06-30","2020-07-01",0,0,0,"",52,{"$f":"IF(G15=0,0,IF(AND(A15<=A16,O15>0),Get_KeyRate(H16),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1248.0899999999999,"2019-05-02",null,{"$f":"'ЦАОП (итог)'!P16-'ЦАОП (0)'!P15","v":0}]
[10,1133000,"10/1","от","2020-07-27",411991.2,721008.8,"2020-07-27","2020-06-30","2020-07-01",27,4333.7299999999996,4.2500000000000003E-2,"",29,{"$f":"IF(G16=0,0,IF(AND(A16<=A17,O16>0),Get_KeyRate(H17),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},2962.14,"2019-05-03",null,{"$f":"'ЦАОП (итог)'!P17-'ЦАОП (0)'!P16","v":0}]
[10,null,"10/2","от","2020-08-20",367264.8,353744,"2020-08-25","2020-06-30","2020-07-01",0,0,0,"",31,{"$f":"IF(G17=0,0,IF(AND(A17<=A18,O17>0),Get_KeyRate(H18),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1553.53,"2019-05-04",null,{"$f":"'ЦАОП (итог)'!P18-'ЦАОП (0)'!P17","v":0}]
[10,null,"10/3","от","2020-09-25",353744,0,"2020-09-25","2020-06-30","2020-07-01",0,0,0,"",0,{"$f":"IF(G18=0,0,IF(AND(A18<=A19,O18>0),Get_KeyRate(H19),Get_KeyRate($N$1)))","v":0},0,"2019-05-05",null,{"$f":"'ЦАОП (итог)'!P19-'ЦАОП (0)'!P18","v":0}]
[11,3004223,"11/1","от","2020-05-15",842136,2162087,"2020-05-22","2020-06-30","2020-07-01",0,0,0,"",24,{"$f":"IF(G19=0,0,IF(AND(A19<=A20,O19>0),Get_KeyRate(H20),Get_KeyRate($N$1)))","v":5.5E-2},9513.18,"2019-05-09","День победы",{"$f":"'ЦАОП (итог)'!P20-'ЦАОП (0)'!P19","v":0}]
[11,null,"11/2","от","2020-06-11",663872.4,1498214.6,"2020-06-15","2020-06-30","2020-07-01",0,0,0,"",42,{"$f":"IF(G20=0,0,IF(AND(A20<=A21,O20>0),Get_KeyRate(H21),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},8914.3799999999992,"2019-05-10",null,{"$f":"'ЦАОП (итог)'!P21-'ЦАОП (0)'!P20","v":0}]
[11,null,"11/3","от","2020-07-27",1112151.6000000001,386063,"2020-07-27","2020-06-30","2020-07-01",0,0,0,"",29,{"$f":"IF(G21=0,0,IF(AND(A21<=A22,O21>0),Get_KeyRate(H22),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1586.08,"2019-05-11",null,{"$f":"'ЦАОП (итог)'!P22-'ЦАОП (0)'!P21","v":0}]
[11,null,"11/4","от","2020-08-20",308734.8,77328.2,"2020-08-25","2020-06-30","2020-07-01",0,0,0,"",31,{"$f":"IF(G22=0,0,IF(AND(A22<=A23,O22>0),Get_KeyRate(H23),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},339.6,"2019-05-12",null,{"$f":"'ЦАОП (итог)'!P23-'ЦАОП (0)'!P22","v":0}]
[11,null,"11/4","от","2020-09-25",75927.600000000006,1400.6,"2020-09-25","2020-06-30","2020-07-01",0,0,0,"",52,{"$f":"IF(G23=0,0,IF(AND(A23<=A24,O23>0),Get_KeyRate(H24),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},10.32,"2019-06-12","День России",{"$f":"'ЦАОП (итог)'!P24-'ЦАОП (0)'!P23","v":0}]
[12,428264.00000000006,"12/1","от","2020-08-20",78234,350030,"2020-08-25","2020-06-30","2020-07-01",56,3397.56,4.2500000000000003E-2,"",31,{"$f":"IF(G24=0,0,IF(AND(A24<=A25,O24>0),Get_KeyRate(H25),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1537.22,"2019-11-02","День народного единства",{"$f":"'ЦАОП (итог)'!P25-'ЦАОП (0)'!P24","v":0}]
[12,null,"12/2","от","2020-09-25",350030,0,"2020-09-25","2020-06-30","2020-07-01",0,0,0,"",0,{"$f":"IF(G25=0,0,IF(AND(A25<=A26,O25>0),Get_KeyRate(H26),Get_KeyRate($N$1)))","v":0},0,"2019-11-03",null,{"$f":"'ЦАОП (итог)'!P26-'ЦАОП (0)'!P25","v":0}]
[13,728400,null,null,null,null,728400,null,"2020-06-30","2020-07-01",0,0,0,"+",138,{"$f":"IF(G26=0,0,IF(AND(A26<=A27,O26>0),Get_KeyRate(H27),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},14240.22,"2019-11-04",null,{"$f":"'ЦАОП (итог)'!P27-'ЦАОП (0)'!P26","v":0}]
[14,278614,null,null,null,null,278614,null,"2020-06-30","2020-07-01",0,0,0,"+",138,{"$f":"IF(G27=0,0,IF(AND(A27<=A28,O27>0),Get_KeyRate(H28),Get_KeyRate($N$1)))","v":5.5E-2},7048.93,"2020-01-01","каникулы",{"$f":"'ЦАОП (итог)'!P28-'ЦАОП (0)'!P27","v":-1.2499999999999997E-2}]
[15,1158016.9999999998,"15/1","от","2020-06-11",172428,985589,"2020-06-15","2020-06-30","2020-07-01",0,0,0,"",144,{"$f":"IF(G28=0,0,IF(AND(A28<=A29,O28>0),Get_KeyRate(H29),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},20106.02,"2020-01-02",null,{"$f":"'ЦАОП (итог)'!P29-'ЦАОП (0)'!P28","v":0}]
[15,null,"15/2","от","2020-11-06",829850.76,155738.23999999999,"2020-11-06","2020-06-30","2020-07-01",0,0,0,"",10,{"$f":"IF(G29=0,0,IF(AND(A29<=A30,O29>0),Get_KeyRate(H30),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},220.63,"2020-01-03",null,{"$f":"'ЦАОП (итог)'!P30-'ЦАОП (0)'!P29","v":0}]
[16,732344,"16/1","от","2020-09-25",657691.19999999995,74652.800000000003,"2020-09-25","2020-06-30","2020-07-01",87,9026.14,4.2500000000000003E-2,"",86,{"$f":"IF(G30=0,0,IF(AND(A30<=A31,O30>0),Get_KeyRate(H31),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},909.52,"2020-01-04",null,{"$f":"'ЦАОП (итог)'!P31-'ЦАОП (0)'!P30","v":0}]
[17,321117,null,null,null,null,321117,null,"2020-06-30","2020-07-01",0,0,0,"+",138,{"$f":"IF(G31=0,0,IF(AND(A31<=A32,O31>0),Get_KeyRate(H32),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},6277.84,"2020-01-05",null,{"$f":"'ЦАОП (итог)'!P32-'ЦАОП (0)'!P31","v":0}]
[18,3575511,"18/1","от","2020-09-25",25263.599999999999,3550247.4,"2020-09-25","2020-07-31","2020-08-03",54,27352.66,4.2500000000000003E-2,"",53,{"$f":"IF(G32=0,0,IF(AND(A32<=A33,O32>0),Get_KeyRate(H33),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},26656.44,"2020-01-06",null,{"$f":"'ЦАОП (итог)'!P33-'ЦАОП (0)'!P32","v":0}]
[19,1939736,null,null,null,null,1939736,null,"2020-07-31","2020-08-03",0,0,0,"+",105,{"$f":"IF(G33=0,0,IF(AND(A33<=A34,O33>0),Get_KeyRate(H34),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},28853.57,"2020-01-07",null,{"$f":"'ЦАОП (итог)'!P34-'ЦАОП (0)'!P33","v":0}]
[20,53707.000000000007,null,null,null,null,53707,null,"2020-07-31","2020-08-03",0,0,0,"+",105,{"$f":"IF(G34=0,0,IF(AND(A34<=A35,O34>0),Get_KeyRate(H35),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},798.89,"2020-01-08",null,{"$f":"'ЦАОП (итог)'!P35-'ЦАОП (0)'!P34","v":0}]
[21,1089795,null,null,null,null,1089795,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G35=0,0,IF(AND(A35<=A36,O35>0),Get_KeyRate(H36),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},11733.46,"2020-02-22","День защитника отеч.",{"$f":"'ЦАОП (итог)'!P36-'ЦАОП (0)'!P35","v":0}]
[22,726119,null,null,null,null,726119,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G36=0,0,IF(AND(A36<=A37,O36>0),Get_KeyRate(H37),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},7817.88,"2020-02-23",null,{"$f":"'ЦАОП (итог)'!P37-'ЦАОП (0)'!P36","v":0}]
[23,1386200,null,null,null,null,1386200,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G37=0,0,IF(AND(A37<=A38,O37>0),Get_KeyRate(H38),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},14924.75,"2020-02-24",null,{"$f":"'ЦАОП (итог)'!P38-'ЦАОП (0)'!P37","v":0}]
[24,961895.00000000012,"24/1","от","2020-08-20",163862.39999999999,798032.6,"2020-08-25","2020-08-31","2020-09-01",0,0,0,"",31,{"$f":"IF(G38=0,0,IF(AND(A38<=A39,O38>0),Get_KeyRate(H39),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},3504.69,"2020-03-07","Международный женский день",{"$f":"'ЦАОП (итог)'!P39-'ЦАОП (0)'!P38","v":0}]
[24,null,"24/2","от","2020-09-25",94658.4,703374.2,"2020-09-25","2020-08-31","2020-09-01",0,0,0,"",52,{"$f":"IF(G39=0,0,IF(AND(A39<=A40,O39>0),Get_KeyRate(H40),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5181.5200000000004,"2020-03-08",null,{"$f":"'ЦАОП (итог)'!P40-'ЦАОП (0)'!P39","v":0}]
[25,2863205,"25/1","от","2020-09-25",2751631.2,111573.8,"2020-09-25","2020-08-31","2020-09-01",25,10140.52,4.2500000000000003E-2,"",24,{"$f":"IF(G40=0,0,IF(AND(A40<=A41,O40>0),Get_KeyRate(H41),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},379.35,"2020-03-09",null,{"$f":"'ЦАОП (итог)'!P41-'ЦАОП (0)'!P40","v":0}]
[26,132598,null,null,null,null,132598,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G41=0,0,IF(AND(A41<=A42,O41>0),Get_KeyRate(H42),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1427.64,null,"2020-03-28",{"$f":"'ЦАОП (итог)'!P42-'ЦАОП (0)'!P41","v":0}]
[27,520685.99999999994,null,null,null,null,520686,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G42=0,0,IF(AND(A42<=A43,O42>0),Get_KeyRate(H43),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5606.05,null,"2020-03-29",{"$f":"'ЦАОП (итог)'!P43-'ЦАОП (0)'!P42","v":0}]
[28,488182.00000000006,null,null,null,null,488182,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G43=0,0,IF(AND(A43<=A44,O43>0),Get_KeyRate(H44),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5256.09,null,"2020-03-30",{"$f":"'ЦАОП (итог)'!P44-'ЦАОП (0)'!P43","v":0}]
[29,249138,"29/1","от","2020-08-20",227139.6,21998.400000000001,"2020-08-25","2020-08-31","2020-09-01",0,0,0,"",73,{"$f":"IF(G44=0,0,IF(AND(A44<=A45,O44>0),Get_KeyRate(H45),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},227.5,null,"2020-03-31",{"$f":"'ЦАОП (итог)'!P45-'ЦАОП (0)'!P44","v":0}]
[29,null,"29/2","от","2020-11-06",17653.5,4344.8999999999996,"2020-11-06","2020-08-31","2020-09-01",0,0,0,"",10,{"$f":"IF(G45=0,0,IF(AND(A45<=A46,O45>0),Get_KeyRate(H46),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},6.16,null,"2020-04-01",{"$f":"'ЦАОП (итог)'!P46-'ЦАОП (0)'!P45","v":0}]
[30,46809,null,null,null,null,46809,null,"2020-08-31","2020-09-01",0,0,0,"+",76,{"$f":"IF(G46=0,0,IF(AND(A46<=A47,O46>0),Get_KeyRate(H47),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},503.98,null,"2020-04-02",{"$f":"'ЦАОП (итог)'!P47-'ЦАОП (0)'!P46","v":0}]
[31,3905532,null,null,null,null,3905532,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G47=0,0,IF(AND(A47<=A48,O47>0),Get_KeyRate(H48),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},25451.05,null,"2020-04-03",{"$f":"'ЦАОП (итог)'!P48-'ЦАОП (0)'!P47","v":0}]
[32,2742453.9999999995,null,null,null,null,2742454,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G48=0,0,IF(AND(A48<=A49,O48>0),Get_KeyRate(H49),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},17871.66,null,"2020-04-04",{"$f":"'ЦАОП (итог)'!P49-'ЦАОП (0)'!P48","v":0}]
[33,92166,"33/1","от","2020-11-06",92166,0,"2020-11-06","2020-09-30","2020-10-01",37,483.1,4.2500000000000003E-2,"",0,{"$f":"IF(G49=0,0,IF(AND(A49<=A50,O49>0),Get_KeyRate(H50),Get_KeyRate($N$1)))","v":0},0,null,"2020-04-05",{"$f":"'ЦАОП (итог)'!P50-'ЦАОП (0)'!P49","v":0}]
[34,1239826.9999999998,"34/1","от","2020-11-06",918350.84,321476.15999999997,"2020-11-06","2020-09-30","2020-10-01",37,6498.76,4.2500000000000003E-2,"",36,{"$f":"IF(G50=0,0,IF(AND(A50<=A51,O50>0),Get_KeyRate(H51),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1639.53,null,"2020-04-06",{"$f":"'ЦАОП (итог)'!P51-'ЦАОП (0)'!P50","v":0}]
[35,1268541,null,null,null,null,1268541,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G51=0,0,IF(AND(A51<=A52,O51>0),Get_KeyRate(H52),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},8266.66,null,"2020-04-07",{"$f":"'ЦАОП (итог)'!P52-'ЦАОП (0)'!P51","v":0}]
[36,565450,"36/1","от","2020-08-20",248911.2,316538.8,"2020-08-25","2020-09-30","2020-10-01",0,0,0,"",73,{"$f":"IF(G52=0,0,IF(AND(A52<=A53,O52>0),Get_KeyRate(H53),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},3273.54,null,"2020-04-08",{"$f":"'ЦАОП (итог)'!P53-'ЦАОП (0)'!P52","v":0}]
[36,null,"36/2","от","2020-11-06",314161.68,2377.12,"2020-11-06","2020-09-30","2020-10-01",0,0,0,"",10,{"$f":"IF(G53=0,0,IF(AND(A53<=A54,O53>0),Get_KeyRate(H54),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},3.37,null,"2020-04-09",{"$f":"'ЦАОП (итог)'!P54-'ЦАОП (0)'!P53","v":0}]
[37,2349763,null,null,null,null,2349763,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G54=0,0,IF(AND(A54<=A55,O54>0),Get_KeyRate(H55),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},15312.62,null,"2020-04-10",{"$f":"'ЦАОП (итог)'!P55-'ЦАОП (0)'!P54","v":0}]
[38,249273.99999999997,null,null,null,null,249274,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G55=0,0,IF(AND(A55<=A56,O55>0),Get_KeyRate(H56),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1624.44,null,"2020-04-11",{"$f":"'ЦАОП (итог)'!P56-'ЦАОП (0)'!P55","v":0}]
[39,220754,null,null,null,null,220754,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G56=0,0,IF(AND(A56<=A57,O56>0),Get_KeyRate(H57),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1438.58,null,"2020-04-12",{"$f":"'ЦАОП (итог)'!P57-'ЦАОП (0)'!P56","v":0}]
[40,130039.00000000001,null,null,null,null,130039,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G57=0,0,IF(AND(A57<=A58,O57>0),Get_KeyRate(H58),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},847.42,null,"2020-04-13",{"$f":"'ЦАОП (итог)'!P58-'ЦАОП (0)'!P57","v":0}]
[41,2692844,null,null,null,null,2692844,null,"2020-09-30","2020-10-01",0,0,0,"+",46,{"$f":"IF(G58=0,0,IF(AND(A58<=A59,O58>0),Get_KeyRate(H59),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},17548.37,null,"2020-04-14",{"$f":"'ЦАОП (итог)'!P59-'ЦАОП (0)'!P58","v":0}]
[42,2947091.0000000005,null,null,null,null,2947091,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G59=0,0,IF(AND(A59<=A60,O59>0),Get_KeyRate(H60),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5845.06,null,"2020-04-15",{"$f":"'ЦАОП (итог)'!P60-'ЦАОП (0)'!P59","v":0}]
[43,151713,null,null,null,null,151713,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G60=0,0,IF(AND(A60<=A61,O60>0),Get_KeyRate(H61),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},300.89999999999998,null,"2020-04-16",{"$f":"'ЦАОП (итог)'!P61-'ЦАОП (0)'!P60","v":0}]
[44,709075.99999999988,null,null,null,null,709076,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G61=0,0,IF(AND(A61<=A62,O61>0),Get_KeyRate(H62),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1406.33,null,"2020-04-17",{"$f":"'ЦАОП (итог)'!P62-'ЦАОП (0)'!P61","v":0}]
[45,2642410,null,null,null,null,2642410,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G62=0,0,IF(AND(A62<=A63,O62>0),Get_KeyRate(H63),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},5240.78,null,"2020-04-18",{"$f":"'ЦАОП (итог)'!P63-'ЦАОП (0)'!P62","v":0}]
[46,151661,null,null,null,null,151661,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G63=0,0,IF(AND(A63<=A64,O63>0),Get_KeyRate(H64),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},300.79000000000002,null,"2020-04-19",{"$f":"'ЦАОП (итог)'!P64-'ЦАОП (0)'!P63","v":0}]
[47,77993,null,null,null,null,77993,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G64=0,0,IF(AND(A64<=A65,O64>0),Get_KeyRate(H65),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},154.69,null,"2020-04-20",{"$f":"'ЦАОП (итог)'!P65-'ЦАОП (0)'!P64","v":0}]
[48,1290301.9999999998,null,null,null,null,1290302,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G65=0,0,IF(AND(A65<=A66,O65>0),Get_KeyRate(H66),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},2559.1,null,"2020-04-21",{"$f":"'ЦАОП (итог)'!P66-'ЦАОП (0)'!P65","v":0}]
[49,613132.00000000012,null,null,null,null,{"$f":"ROUND(IF(B66>0,B66-F66,G65-F66),2)","v":613132},null,"2020-10-31","2020-11-02",0,0,{"$f":"IF(K66=0,0,Get_KeyRate(H66))","v":0},"+",{"$f":"IF(N66=\"+\",IF(I66>$N$1,\"0\",IF(N66=\"+\",VALUE($N$1)-VALUE(J66),$N$1-H66))+IF(G66=0,0,IF(AND(A66>=A67,H66>0,H67-H66),H67-H66)),IF(I66>$N$1,\"0\",IF(G66=0,0,IF(AND(A66>=A67,H66>0,H67-H66),H67-H66,IF(AND(A66<>A67,B66=\"\",B67<>0),VALUE($N$1)-VALUE(H66),IF(A66<>A67,H66-J66,IF(N66=\"+\",VALUE($N$1)-VALUE(J66),$N$1-H66)))))))","v":14},{"$f":"IF(G66=0,0,IF(AND(A66<=A67,O66>0),Get_KeyRate(H67),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1216.05,null,"2020-04-22",{"$f":"'ЦАОП (итог)'!P67-'ЦАОП (0)'!P66","v":0}]
[50,304143,null,null,null,null,304143,null,"2020-10-31",{"$f":"WORKDAY.INTL(I67,1,1,$R$2:$R$87)","v":"2020-11-02"},{"$f":"IF(AND(H67>J67,B67>0),H67-J67+1,0)","v":0},0,0,"+",14,{"$f":"IF(G67=0,0,IF(AND(A67<=A68,O67>0),Get_KeyRate(H68),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},{"$f":"IF(G67=0,0,IF(O67>0,ROUND((G67*O67*1/300*P67),2),0))","v":603.22},null,"2020-04-23",{"$f":"'ЦАОП (итог)'!P68-'ЦАОП (0)'!P67","v":0}]
[51,733234,null,null,null,null,733234,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G68=0,0,IF(AND(A68<=A69,O68>0),Get_KeyRate(H69),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},1454.25,null,"2020-04-24",{"$f":"'ЦАОП (итог)'!P69-'ЦАОП (0)'!P68","v":0}]
[52,2126970,null,null,null,null,2126970,null,"2020-10-31","2020-11-02",0,0,0,"+",14,{"$f":"IF(G69=0,0,IF(AND(A69<=A70,O69>0),Get_KeyRate(H70),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},4218.49,null,"2020-04-25",{"$f":"'ЦАОП (итог)'!P70-'ЦАОП (0)'!P69","v":0}]
[53,1067534,null,null,null,null,1067534,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G70=0,0,IF(AND(A70<=A71,O70>0),Get_KeyRate(H71),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-26",{"$f":"'ЦАОП (итог)'!P71-'ЦАОП (0)'!P70","v":0}]
[54,5044770,null,null,null,null,5044770,null,"2020-11-30","2020-12-01",0,{"$f":"IF(B71>0,ROUND((B71*K71*1/300*M71),2),0)","v":0},0,"+",0,{"$f":"IF(G71=0,0,IF(AND(A71<=A72,O71>0),Get_KeyRate(H72),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-27",{"$f":"'ЦАОП (итог)'!P72-'ЦАОП (0)'!P71","v":0}]
[55,427621,null,null,null,null,427621,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G72=0,0,IF(AND(A72<=A73,O72>0),Get_KeyRate(H73),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-28",{"$f":"'ЦАОП (итог)'!P73-'ЦАОП (0)'!P72","v":0}]
[56,134723,null,null,null,null,134723,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G73=0,0,IF(AND(A73<=A74,O73>0),Get_KeyRate(H74),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-29",{"$f":"'ЦАОП (итог)'!P74-'ЦАОП (0)'!P73","v":0}]
[57,23508,null,null,null,null,23508,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G74=0,0,IF(AND(A74<=A75,O74>0),Get_KeyRate(H75),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,"2020-04-30",{"$f":"'ЦАОП (итог)'!P75-'ЦАОП (0)'!P74","v":0}]
[58,1563550,"58/1","от","2020-06-11",515787.6,1047762.4,"2020-06-15","2020-11-30","2020-12-01",0,0,0,"","0",{"$f":"IF(G75=0,0,IF(AND(A75<=A76,O75>0),Get_KeyRate(H76),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-01","День труда",{"$f":"'ЦАОП (итог)'!P76-'ЦАОП (0)'!P75","v":0}]
[59,422081.00000000006,null,null,null,null,422081,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G76=0,0,IF(AND(A76<=A77,O76>0),Get_KeyRate(H77),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-02",null,{"$f":"'ЦАОП (итог)'!P77-'ЦАОП (0)'!P76","v":0}]
[60,137670,null,null,null,null,137670,null,"2020-11-30","2020-12-01",0,0,0,"+",0,{"$f":"IF(G77=0,0,IF(AND(A77<=A78,O77>0),Get_KeyRate(H78),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-03",null,{"$f":"'ЦАОП (итог)'!P78-'ЦАОП (0)'!P77","v":0}]
[61,1834890.0000000002,null,null,null,null,1834890,null,"2020-12-31","2021-01-01",0,0,0,{"$f":"IF(AND(E78=0,F78=0,H78=0),\"+\",\"\")","v":"+"},0,{"$f":"IF(G78=0,0,IF(AND(A78<=A79,O78>0),Get_KeyRate(H79),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-04",null,{"$f":"'ЦАОП (итог)'!P79-'ЦАОП (0)'!P78","v":0}]
[62,1470679,null,null,null,null,1470679,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G79=0,0,IF(AND(A79<=A80,O79>0),Get_KeyRate(H80),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-05",null,{"$f":"'ЦАОП (итог)'!P80-'ЦАОП (0)'!P79","v":0}]
[63,723560,null,null,null,null,723560,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G80=0,0,IF(AND(A80<=A81,O80>0),Get_KeyRate(H81),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-09","День победы",{"$f":"'ЦАОП (итог)'!P81-'ЦАОП (0)'!P80","v":0}]
[64,1527208.0000000002,null,null,null,null,1527208,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G81=0,0,IF(AND(A81<=A82,O81>0),Get_KeyRate(H82),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-10",null,{"$f":"'ЦАОП (итог)'!P82-'ЦАОП (0)'!P81","v":0}]
[65,192440,null,null,null,null,192440,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G82=0,0,IF(AND(A82<=A83,O82>0),Get_KeyRate(H83),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-05-11",null,{"$f":"'ЦАОП (итог)'!P83-'ЦАОП (0)'!P82","v":0}]
[66,6497143.9999999991,null,null,null,null,6497144,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G83=0,0,IF(AND(A83<=A84,O83>0),Get_KeyRate(H84),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-06-12","День России",{"$f":"'ЦАОП (итог)'!P84-'ЦАОП (0)'!P83","v":0}]
[67,52577,null,null,null,null,52577,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G84=0,0,IF(AND(A84<=A85,O84>0),Get_KeyRate(H85),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-06-13",null,{"$f":"'ЦАОП (итог)'!P85-'ЦАОП (0)'!P84","v":0}]
[68,60854.000000000007,null,null,null,null,60854,null,"2020-12-31","2021-01-01",0,0,0,"+",0,{"$f":"IF(G85=0,0,IF(AND(A85<=A86,O85>0),Get_KeyRate(H86),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-06-14",null,{"$f":"'ЦАОП (итог)'!P86-'ЦАОП (0)'!P85","v":0}]
[69,34774,null,null,null,null,34774,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G86=0,0,IF(AND(A86<=A87,O86>0),Get_KeyRate(H87),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-06-24","День победы",{"$f":"'ЦАОП (итог)'!P87-'ЦАОП (0)'!P86","v":0}]
[70,226911,null,null,null,null,226911,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G87=0,0,IF(AND(A87<=A88,O87>0),Get_KeyRate(H88),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,"2020-11-04","День нар. един-ва",{"$f":"'ЦАОП (итог)'!P88-'ЦАОП (0)'!P87","v":0}]
[71,67167,null,null,null,null,67167,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G88=0,0,IF(AND(A88<=A89,O88>0),Get_KeyRate(H89),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P89-'ЦАОП (0)'!P88","v":0}]
[72,78575,null,null,null,null,78575,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G89=0,0,IF(AND(A89<=A90,O89>0),Get_KeyRate(H90),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P90-'ЦАОП (0)'!P89","v":0}]
[73,160659,null,null,null,null,160659,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G90=0,0,IF(AND(A90<=A91,O90>0),Get_KeyRate(H91),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P91-'ЦАОП (0)'!P90","v":0}]
[74,97763.000000000015,null,null,null,null,97763,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G91=0,0,IF(AND(A91<=A92,O91>0),Get_KeyRate(H92),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P92-'ЦАОП (0)'!P91","v":0}]
[75,282390,null,null,null,null,282390,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G92=0,0,IF(AND(A92<=A93,O92>0),Get_KeyRate(H93),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P93-'ЦАОП (0)'!P92","v":0}]
[76,369078,null,null,null,null,369078,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G93=0,0,IF(AND(A93<=A94,O93>0),Get_KeyRate(H94),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P94-'ЦАОП (0)'!P93","v":0}]
[77,58822,null,null,null,null,58822,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G94=0,0,IF(AND(A94<=A95,O94>0),Get_KeyRate(H95),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P95-'ЦАОП (0)'!P94","v":0}]
[78,1579821,null,null,null,null,1579821,null,"2021-01-31","2021-02-01",0,0,0,"+",0,{"$f":"IF(G95=0,0,IF(AND(A95<=A96,O95>0),Get_KeyRate(H96),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P96-'ЦАОП (0)'!P95","v":0}]
[79,3461161,"79/1","от","2020-05-15",2132190.8199999998,1328970.18,"2020-05-22","2021-01-31","2021-02-01",0,0,0,"","0",{"$f":"IF(G96=0,0,IF(AND(A96<=A97,O96>0),Get_KeyRate(H97),Get_KeyRate($N$1)))","v":4.2500000000000003E-2},0,null,null,{"$f":"'ЦАОП (итог)'!P97-'ЦАОП (0)'!P96","v":0}]
["ИТОГО",{"$f":"_xlfn.AGGREGATE(9,5,B2:B96)","v":88618104},null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,F2:F96)","v":24278507.429999996},null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,Q2:Q96)","v":375952.83999999997}]

{"sheet":"Вопрос","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}