{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Розрахунок на купівлю житла"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":294,"n_cols":32,"rows_kept":294,"cut":false,"hidden":false,"merged":[[293,3,293,22],[291,3,291,22],[7,3,7,5],[12,3,12,9],[13,3,13,9],[13,12,13,13],[290,3,290,22],[287,3,287,15],[36,10,38,10],[36,11,36,20],[37,11,37,14],[37,15,37,16],[37,17,37,20],[284,3,284,4],[292,3,292,22],[35,22,38,22],[36,9,38,9],[14,3,14,9],[15,3,15,9],[286,3,286,15],[288,3,288,15],[284,14,284,21],[35,3,38,3],[35,4,38,4],[35,5,38,5],[35,8,38,8],[35,9,35,20],[35,21,38,21],[33,3,33,22],[285,3,285,15]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Калькулятор"]
[null,null,null,null,null,null,null,null,null,null,null,"«МОЄ ЖИТЛО» – на придбання житла"]
[]
[null,null,null,null,"ячейки блакитногого кольору заповнюються Клієнтом виходячи з обраних умов кредитування"]
[]
[null,null,null,"Умови кредитування, обрані споживачем:"]
[null,null,null,"Дата видачі кредиту: ",null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-11-12"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(K13)","v":2041},{"$f":"YEAR(K8)","v":2021},{"$f":"MONTH(K13)","v":11},{"$f":"MONTH(K8)","v":11}]
[null,null,null,"Вартість предмету іпотеки, грн.:",null,null,null,null,null,null,1200000]
[null,null,null,"Перший внесок*:",null,null,null,null,null,null,0.3,"*не менш як 30%  вартості предмета іпотеки"]
[null,null,null,"Сума кредиту, грн.: ",null,null,null,null,null,null,{"$f":"K9*(100%-K10)","v":840000}]
[null,null,null,"Срок кредитування, місяців",null,null,null,null,null,null,240,"до 240 місяців"]
[null,null,null,"Кінцева дата повернення кредиту:",null,null,null,null,null,null,{"$f":"K8+((K12/12)*365)","v":"2041-11-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC8-AD8","v":20},null,{"$f":"AE8-AF8","v":0}]
[null,null,null,"Порядок погашення кредиту, грн.: ",null,null,null,null,null,null,"щомісяця по",{"$f":"CEILING(K11/K12,1)","v":3500},"останній платіж",null,{"$f":"K11-(L14*(K12-1))","v":3500}]
[null,null,null,"Дата погашення кредиту та процентів: ",null,null,null,null,null,null,"щомісяця",{"$f":"DAY(K8)","v":12},"числа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"12+AE13","v":12}]
[null,null,null,"Процентна ставка (фіксована) перші 2 роки: ",null,null,null,null,null,null,0.109,"річних",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"24+AE13","v":24}]
[null,null,null,"Індекс UIRD (12 міс. у гривні) станом на 31.05.2021 р.:",null,null,null,null,null,null,8.14E-2]
[null,null,null,"Маржа:",null,null,null,null,null,null,0.04]
[null,null,null,"Процентна ставка (плаваюча): ",null,null,null,null,null,null,{"$f":"K17+K18","v":0.12140000000000001},"річних"]
[]
[null,null,null,"Платежі за додаткові та сукупні послуги:"]
[null,null,null,"Разова комісія за видачу готівкових коштів:",null,null,null,null,null,null,7.0000000000000001E-3,"від суми наданого кредиту",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC13=0,AE13,IF(AC13=1,AE15,IF(AC13=2,AE16,#REF!)))","v":{"$error":"#REF!"}}]
[null,null,null,"Щомісячна комісія за проведення розрахунків:",null,null,null,null,null,null,0,"від суми наданого кредиту",null,null,{"$f":"K11*K23","v":0}]
[null,null,null,"Щорічна комісія за проведення розрахунків:",null,null,null,null,null,null,0,"від суми наданого кредиту"]
[null,null,null,"Послуги нотаріуса",null,null,null,null,null,null,11100,"грн."]
[null,null,null,"Послуги оцінювача",null,null,null,null,null,null,1000,"грн."]
[null,null,null,"Страхування предмета іпотеки (щороку)",null,null,null,null,null,null,3.0000000000000001E-3,"від вартості предмету іпотеки"]
[null,null,null,"Страхування позичальника від нещасних випадків (щороку)",null,null,null,null,null,null,6.0000000000000001E-3,"від  залишку кредитної заборгованості"]
[null,null,null,"Державне мито",null,null,null,null,null,null,1.0999999999999999E-2,"від вартості предмету іпотеки"]
[null,null,null,"Пенсійний збір",null,null,null,null,null,null,0.01,"від вартості предмету іпотеки"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Дата розрахунку:",{"$f":"TEXT(K8,\"DD.MM.YYYY\")&\" р.\"","v":"12.11.2021 р."}]
[null,null,null,"ТАБЛИЦЯ\nобчислення загальної вартості кредиту для споживача та реальної річної процентної ставки за договором про споживчий кредит"]
[]
[null,null,null," № з/п","Дата видачі кредиту/ дата платежу","Кількість днів у розрахун- ковому періоді",null,null,"Чиста сума кредиту/ сума платежу за розрахунковий період, грн.","Види платежів за кредитом",null,null,null,null,null,null,null,null,null,null,null,"Реальна річна процентна ставка, %","Загальна вартість кредиту, грн"]
[null,null,null,null,null,null,null,null,null,"сума кредиту за договором","проценти за користування кредитом","платежі за додаткові та супутні послуги"]
[null,null,null,null,null,null,null,null,null,null,null,"банку",null,null,null,"кредитного посередника (за наявності)",null,"третіх осіб"]
["фільтр",null,null,null,null,null,null,null,null,null,null,"щомісячна комісія за проведення розрахунків","розрахунково-касове обслуговування","комісія за видачу готівкових коштів","інші послуги банку","комісійний збір","інша плата за послуги кредитного посередника","послуги нотаріуса","послуги оцінювача","послуги страховика","інші послуги \nтретіх осіб"]
[null,null,null,1,2,3,4,5,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[{"$f":"IF(B41<=$K$13,1,0)","v":1},null,null,1,{"$f":"K8","v":"2021-11-12"},"х",null,null,{"$f":"SUM(J41:U41)","v":-788180},{"$f":"-K11","v":-840000},"х",null,null,{"$f":"K11*K22","v":5880},{"$f":"K11*K24","v":0},null,null,{"$f":"K25+(K29*K9)+(K30*K9)","v":36300},{"$f":"K26","v":1000},{"$f":"K9*K27+(-J41*K28)","v":8640},null,"х","х"]
[0,null,null,null,{"$f":"EOMONTH(K8,0)","v":"2021-11-30"},{"$f":"IF(A42=1,E42-E41,0)","v":0},null,null,{"$f":"SUM(J42:O42)","v":0}]
[{"$f":"IF(B43<=$K$12,1,0)","v":1},1,null,{"$f":"D41+1","v":2},{"$f":"MIN(DATE(YEAR(E41),MONTH(E41)+1,DAY($L$15)),$K$13)","v":"2021-12-12"},{"$f":"E43-E41","v":30},{"$f":"EOMONTH(E41,0)-E41","v":18},{"$f":"E43-EOMONTH(E41,0)","v":12},{"$f":"SUM(J43:U43)","v":11025.48},{"$f":"L14","v":3500},{"$f":"ROUND($K$11*(($K$16/(IF(ROUND(YEAR(E41)/4,0)-YEAR(E41)/4=0,366,365)))*G43)+$K$11*(($K$16/(IF(ROUND(YEAR(E43)/4,0)-YEAR(E43)/4=0,366,365)))*H43),2)","v":7525.48},{"$f":"IF(A43=1,IF(AND(YEAR($K$13)=YEAR(EDATE(E42,1)),MONTH($K$13)=MONTH(EDATE(E42,1))),$O$23-$O$46,$O$23),0)","v":0},null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B43+1","v":2},null,3,{"$f":"IF(AND(YEAR($K$13)=YEAR(EDATE(E43,1)),MONTH($K$13)=MONTH(EDATE(E43,1))),$K$13,EDATE(E43,1))","v":"2022-01-12"},{"$f":"IF(A44=1,E44-E43,0)","v":31},{"$f":"EOMONTH(E43,0)-E43","v":19},{"$f":"E44-EOMONTH(E43,0)","v":12},{"$f":"SUM(J44:U44)","v":11243.93},{"$f":"IF(B44<$K$12,$L$14,-$J$41-SUM($J$43:J43))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J43))*(($K$16/(IF(ROUND(YEAR(E43)/4,0)-YEAR(E43)/4=0,366,365)))*G44)+($K$11-SUM($J$43:J43))*(($K$16/(IF(ROUND(YEAR(E44)/4,0)-YEAR(E44)/4=0,366,365)))*H44),2)","v":7743.93},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,3,null,4,{"$f":"IF(AND(YEAR($K$13)=YEAR(EDATE(E44,1)),MONTH($K$13)=MONTH(EDATE(E44,1))),$K$13,EDATE(E44,1))","v":"2022-02-12"},31,{"$f":"EOMONTH(E44,0)-E44","v":19},{"$f":"E45-EOMONTH(E44,0)","v":12},11211.529999999999,{"$f":"IF(B45<$K$12,$L$14,-$J$41-SUM($J$43:J44))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J44))*(($K$16/(IF(ROUND(YEAR(E44)/4,0)-YEAR(E44)/4=0,366,365)))*G45)+($K$11-SUM($J$43:J44))*(($K$16/(IF(ROUND(YEAR(E45)/4,0)-YEAR(E45)/4=0,366,365)))*H45),2)","v":7711.53},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,4,null,5,"2022-03-12",28,16,12,10435.98,{"$f":"IF(B46<$K$12,$L$14,-$J$41-SUM($J$43:J45))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J45))*(($K$16/(IF(ROUND(YEAR(E45)/4,0)-YEAR(E45)/4=0,366,365)))*G46)+($K$11-SUM($J$43:J45))*(($K$16/(IF(ROUND(YEAR(E46)/4,0)-YEAR(E46)/4=0,366,365)))*H46),2)","v":6935.98},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,5,null,6,"2022-04-12",31,19,12,11146.720000000001,{"$f":"IF(B47<$K$12,$L$14,-$J$41-SUM($J$43:J46))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J46))*(($K$16/(IF(ROUND(YEAR(E46)/4,0)-YEAR(E46)/4=0,366,365)))*G47)+($K$11-SUM($J$43:J46))*(($K$16/(IF(ROUND(YEAR(E47)/4,0)-YEAR(E47)/4=0,366,365)))*H47),2)","v":7646.72},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,6,null,7,"2022-05-12",30,18,12,10868.7,{"$f":"IF(B48<$K$12,$L$14,-$J$41-SUM($J$43:J47))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J47))*(($K$16/(IF(ROUND(YEAR(E47)/4,0)-YEAR(E47)/4=0,366,365)))*G48)+($K$11-SUM($J$43:J47))*(($K$16/(IF(ROUND(YEAR(E48)/4,0)-YEAR(E48)/4=0,366,365)))*H48),2)","v":7368.7},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,7,null,8,"2022-06-12",31,19,12,11081.92,{"$f":"IF(B49<$K$12,$L$14,-$J$41-SUM($J$43:J48))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J48))*(($K$16/(IF(ROUND(YEAR(E48)/4,0)-YEAR(E48)/4=0,366,365)))*G49)+($K$11-SUM($J$43:J48))*(($K$16/(IF(ROUND(YEAR(E49)/4,0)-YEAR(E49)/4=0,366,365)))*H49),2)","v":7581.92},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,8,null,9,"2022-07-12",30,18,12,10805.99,{"$f":"IF(B50<$K$12,$L$14,-$J$41-SUM($J$43:J49))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J49))*(($K$16/(IF(ROUND(YEAR(E49)/4,0)-YEAR(E49)/4=0,366,365)))*G50)+($K$11-SUM($J$43:J49))*(($K$16/(IF(ROUND(YEAR(E50)/4,0)-YEAR(E50)/4=0,366,365)))*H50),2)","v":7305.99},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,9,null,10,"2022-08-12",31,19,12,11017.119999999999,{"$f":"IF(B51<$K$12,$L$14,-$J$41-SUM($J$43:J50))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J50))*(($K$16/(IF(ROUND(YEAR(E50)/4,0)-YEAR(E50)/4=0,366,365)))*G51)+($K$11-SUM($J$43:J50))*(($K$16/(IF(ROUND(YEAR(E51)/4,0)-YEAR(E51)/4=0,366,365)))*H51),2)","v":7517.12},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,10,null,11,"2022-09-12",31,19,12,10984.720000000001,{"$f":"IF(B52<$K$12,$L$14,-$J$41-SUM($J$43:J51))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J51))*(($K$16/(IF(ROUND(YEAR(E51)/4,0)-YEAR(E51)/4=0,366,365)))*G52)+($K$11-SUM($J$43:J51))*(($K$16/(IF(ROUND(YEAR(E52)/4,0)-YEAR(E52)/4=0,366,365)))*H52),2)","v":7484.72},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,11,null,12,"2022-10-12",30,18,12,10711.92,{"$f":"IF(B53<$K$12,$L$14,-$J$41-SUM($J$43:J52))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J52))*(($K$16/(IF(ROUND(YEAR(E52)/4,0)-YEAR(E52)/4=0,366,365)))*G53)+($K$11-SUM($J$43:J52))*(($K$16/(IF(ROUND(YEAR(E53)/4,0)-YEAR(E53)/4=0,366,365)))*H53),2)","v":7211.92},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,12,null,13,"2022-11-12",31,19,12,{"$f":"SUM(J54:U54)","v":19328.91},{"$f":"IF(B54<$K$12,$L$14,-$J$41-SUM($J$43:J53))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J53))*(($K$16/(IF(ROUND(YEAR(E53)/4,0)-YEAR(E53)/4=0,366,365)))*G54)+($K$11-SUM($J$43:J53))*(($K$16/(IF(ROUND(YEAR(E54)/4,0)-YEAR(E54)/4=0,366,365)))*H54),2)","v":7419.91},0,null,null,{"$f":"IF(B54<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B54<$K$12,$K$9*$K$27,0)+(-SUM(J41:J53)*K28)","v":8409},null,"х","х"]
[1,13,null,14,"2022-12-12",30,18,12,{"$f":"SUM(J55:U55)","v":10649.21},{"$f":"IF(B55<$K$12,$L$14,-$J$41-SUM($J$43:J54))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J54))*(($K$16/(IF(ROUND(YEAR(E54)/4,0)-YEAR(E54)/4=0,366,365)))*G55)+($K$11-SUM($J$43:J54))*(($K$16/(IF(ROUND(YEAR(E55)/4,0)-YEAR(E55)/4=0,366,365)))*H55),2)","v":7149.21},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,14,null,15,"2023-01-12",31,19,12,10855.11,{"$f":"IF(B56<$K$12,$L$14,-$J$41-SUM($J$43:J55))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J55))*(($K$16/(IF(ROUND(YEAR(E55)/4,0)-YEAR(E55)/4=0,366,365)))*G56)+($K$11-SUM($J$43:J55))*(($K$16/(IF(ROUND(YEAR(E56)/4,0)-YEAR(E56)/4=0,366,365)))*H56),2)","v":7355.11},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,15,null,16,"2023-02-12",31,19,12,10822.71,{"$f":"IF(B57<$K$12,$L$14,-$J$41-SUM($J$43:J56))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J56))*(($K$16/(IF(ROUND(YEAR(E56)/4,0)-YEAR(E56)/4=0,366,365)))*G57)+($K$11-SUM($J$43:J56))*(($K$16/(IF(ROUND(YEAR(E57)/4,0)-YEAR(E57)/4=0,366,365)))*H57),2)","v":7322.71},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,16,null,17,"2023-03-12",28,16,12,10084.790000000001,{"$f":"IF(B58<$K$12,$L$14,-$J$41-SUM($J$43:J57))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J57))*(($K$16/(IF(ROUND(YEAR(E57)/4,0)-YEAR(E57)/4=0,366,365)))*G58)+($K$11-SUM($J$43:J57))*(($K$16/(IF(ROUND(YEAR(E58)/4,0)-YEAR(E58)/4=0,366,365)))*H58),2)","v":6584.79},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,17,null,18,"2023-04-12",31,19,12,10757.91,{"$f":"IF(B59<$K$12,$L$14,-$J$41-SUM($J$43:J58))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J58))*(($K$16/(IF(ROUND(YEAR(E58)/4,0)-YEAR(E58)/4=0,366,365)))*G59)+($K$11-SUM($J$43:J58))*(($K$16/(IF(ROUND(YEAR(E59)/4,0)-YEAR(E59)/4=0,366,365)))*H59),2)","v":7257.91},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B59+1","v":18},null,19,"2023-05-12",30,18,12,10492.42,{"$f":"IF(B60<$K$12,$L$14,-$J$41-SUM($J$43:J59))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J59))*(($K$16/(IF(ROUND(YEAR(E59)/4,0)-YEAR(E59)/4=0,366,365)))*G60)+($K$11-SUM($J$43:J59))*(($K$16/(IF(ROUND(YEAR(E60)/4,0)-YEAR(E60)/4=0,366,365)))*H60),2)","v":6992.42},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,19,null,20,"2023-06-12",31,19,12,10693.1,{"$f":"IF(B61<$K$12,$L$14,-$J$41-SUM($J$43:J60))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J60))*(($K$16/(IF(ROUND(YEAR(E60)/4,0)-YEAR(E60)/4=0,366,365)))*G61)+($K$11-SUM($J$43:J60))*(($K$16/(IF(ROUND(YEAR(E61)/4,0)-YEAR(E61)/4=0,366,365)))*H61),2)","v":7193.1},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,20,null,21,"2023-07-12",30,18,12,10429.709999999999,{"$f":"IF(B62<$K$12,$L$14,-$J$41-SUM($J$43:J61))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J61))*(($K$16/(IF(ROUND(YEAR(E61)/4,0)-YEAR(E61)/4=0,366,365)))*G62)+($K$11-SUM($J$43:J61))*(($K$16/(IF(ROUND(YEAR(E62)/4,0)-YEAR(E62)/4=0,366,365)))*H62),2)","v":6929.71},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,21,null,22,"2023-08-12",31,19,12,10628.3,{"$f":"IF(B63<$K$12,$L$14,-$J$41-SUM($J$43:J62))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J62))*(($K$16/(IF(ROUND(YEAR(E62)/4,0)-YEAR(E62)/4=0,366,365)))*G63)+($K$11-SUM($J$43:J62))*(($K$16/(IF(ROUND(YEAR(E63)/4,0)-YEAR(E63)/4=0,366,365)))*H63),2)","v":7128.3},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,22,null,23,"2023-09-12",31,19,12,10595.9,{"$f":"IF(B64<$K$12,$L$14,-$J$41-SUM($J$43:J63))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J63))*(($K$16/(IF(ROUND(YEAR(E63)/4,0)-YEAR(E63)/4=0,366,365)))*G64)+($K$11-SUM($J$43:J63))*(($K$16/(IF(ROUND(YEAR(E64)/4,0)-YEAR(E64)/4=0,366,365)))*H64),2)","v":7095.9},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,23,null,24,"2023-10-12",30,18,12,10335.64,{"$f":"IF(B65<$K$12,$L$14,-$J$41-SUM($J$43:J64))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J64))*(($K$16/(IF(ROUND(YEAR(E64)/4,0)-YEAR(E64)/4=0,366,365)))*G65)+($K$11-SUM($J$43:J64))*(($K$16/(IF(ROUND(YEAR(E65)/4,0)-YEAR(E65)/4=0,366,365)))*H65),2)","v":6835.64},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,24,null,25,"2023-11-12",31,19,12,{"$f":"SUM(J66:U66)","v":18688.099999999999},{"$f":"IF(B66<$K$12,$L$14,-$J$41-SUM($J$43:J65))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J65))*(($K$16/(IF(ROUND(YEAR(E65)/4,0)-YEAR(E65)/4=0,366,365)))*G66)+($K$11-SUM($J$43:J65))*(($K$16/(IF(ROUND(YEAR(E66)/4,0)-YEAR(E66)/4=0,366,365)))*H66),2)","v":7031.1},0,null,null,{"$f":"IF(B66<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B66<$K$12,$K$9*$K$27,0)+(-SUM(J41:J65)*K28)","v":8157},null,"х","х"]
[1,25,null,26,"2023-12-12",30,18,12,11043.43,{"$f":"IF(B67<$K$12,$L$14,-$J$41-SUM($J$43:J66))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J66))*(($K$19/(IF(ROUND(YEAR(E66)/4,0)-YEAR(E66)/4=0,366,365)))*G67)+($K$11-SUM($J$43:J66))*(($K$19/(IF(ROUND(YEAR(E67)/4,0)-YEAR(E67)/4=0,366,365)))*H67),2)","v":7543.43},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,26,null,27,"2024-01-12",31,19,12,11250.58,{"$f":"IF(B68<$K$12,$L$14,-$J$41-SUM($J$43:J67))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J67))*(($K$19/(IF(ROUND(YEAR(E67)/4,0)-YEAR(E67)/4=0,366,365)))*G68)+($K$11-SUM($J$43:J67))*(($K$19/(IF(ROUND(YEAR(E68)/4,0)-YEAR(E68)/4=0,366,365)))*H68),2)","v":7750.58},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,27,null,28,"2024-02-12",31,19,12,11201.6,{"$f":"IF(B69<$K$12,$L$14,-$J$41-SUM($J$43:J68))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J68))*(($K$19/(IF(ROUND(YEAR(E68)/4,0)-YEAR(E68)/4=0,366,365)))*G69)+($K$11-SUM($J$43:J68))*(($K$19/(IF(ROUND(YEAR(E69)/4,0)-YEAR(E69)/4=0,366,365)))*H69),2)","v":7701.6},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,28,null,29,"2024-03-12",29,17,12,10671.060000000001,{"$f":"IF(B70<$K$12,$L$14,-$J$41-SUM($J$43:J69))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J69))*(($K$19/(IF(ROUND(YEAR(E69)/4,0)-YEAR(E69)/4=0,366,365)))*G70)+($K$11-SUM($J$43:J69))*(($K$19/(IF(ROUND(YEAR(E70)/4,0)-YEAR(E70)/4=0,366,365)))*H70),2)","v":7171.06},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,29,null,30,"2024-04-12",31,19,12,11129.630000000001,{"$f":"IF(B71<$K$12,$L$14,-$J$41-SUM($J$43:J70))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J70))*(($K$19/(IF(ROUND(YEAR(E70)/4,0)-YEAR(E70)/4=0,366,365)))*G71)+($K$11-SUM($J$43:J70))*(($K$19/(IF(ROUND(YEAR(E71)/4,0)-YEAR(E71)/4=0,366,365)))*H71),2)","v":7629.63},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,30,null,31,"2024-05-12",30,18,12,10848.68,{"$f":"IF(B72<$K$12,$L$14,-$J$41-SUM($J$43:J71))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J71))*(($K$19/(IF(ROUND(YEAR(E71)/4,0)-YEAR(E71)/4=0,366,365)))*G72)+($K$11-SUM($J$43:J71))*(($K$19/(IF(ROUND(YEAR(E72)/4,0)-YEAR(E72)/4=0,366,365)))*H72),2)","v":7348.68},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,31,null,32,"2024-06-12",31,19,12,11057.65,{"$f":"IF(B73<$K$12,$L$14,-$J$41-SUM($J$43:J72))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J72))*(($K$19/(IF(ROUND(YEAR(E72)/4,0)-YEAR(E72)/4=0,366,365)))*G73)+($K$11-SUM($J$43:J72))*(($K$19/(IF(ROUND(YEAR(E73)/4,0)-YEAR(E73)/4=0,366,365)))*H73),2)","v":7557.65},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,32,null,33,"2024-07-12",30,18,12,10779.02,{"$f":"IF(B74<$K$12,$L$14,-$J$41-SUM($J$43:J73))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J73))*(($K$19/(IF(ROUND(YEAR(E73)/4,0)-YEAR(E73)/4=0,366,365)))*G74)+($K$11-SUM($J$43:J73))*(($K$19/(IF(ROUND(YEAR(E74)/4,0)-YEAR(E74)/4=0,366,365)))*H74),2)","v":7279.02},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,33,null,34,"2024-08-12",31,19,12,10985.67,{"$f":"IF(B75<$K$12,$L$14,-$J$41-SUM($J$43:J74))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J74))*(($K$19/(IF(ROUND(YEAR(E74)/4,0)-YEAR(E74)/4=0,366,365)))*G75)+($K$11-SUM($J$43:J74))*(($K$19/(IF(ROUND(YEAR(E75)/4,0)-YEAR(E75)/4=0,366,365)))*H75),2)","v":7485.67},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B75+1","v":34},null,35,"2024-09-12",{"$f":"IF(A76=1,E76-E75,0)","v":31},19,12,10949.68,{"$f":"IF(B76<$K$12,$L$14,-$J$41-SUM($J$43:J75))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J75))*(($K$19/(IF(ROUND(YEAR(E75)/4,0)-YEAR(E75)/4=0,366,365)))*G76)+($K$11-SUM($J$43:J75))*(($K$19/(IF(ROUND(YEAR(E76)/4,0)-YEAR(E76)/4=0,366,365)))*H76),2)","v":7449.68},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,35,null,36,"2024-10-12",30,18,12,10674.54,{"$f":"IF(B77<$K$12,$L$14,-$J$41-SUM($J$43:J76))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J76))*(($K$19/(IF(ROUND(YEAR(E76)/4,0)-YEAR(E76)/4=0,366,365)))*G77)+($K$11-SUM($J$43:J76))*(($K$19/(IF(ROUND(YEAR(E77)/4,0)-YEAR(E77)/4=0,366,365)))*H77),2)","v":7174.54},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,36,null,37,"2024-11-12",31,19,12,18782.7,{"$f":"IF(B78<$K$12,$L$14,-$J$41-SUM($J$43:J77))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J77))*(($K$19/(IF(ROUND(YEAR(E77)/4,0)-YEAR(E77)/4=0,366,365)))*G78)+($K$11-SUM($J$43:J77))*(($K$19/(IF(ROUND(YEAR(E78)/4,0)-YEAR(E78)/4=0,366,365)))*H78),2)","v":7377.7},0,null,null,{"$f":"IF(B78<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B78<$K$12,$K$9*$K$27,0)+(-SUM(J41:J77)*K28)","v":7905},null,"х","х"]
[1,37,null,38,"2024-12-12",30,{"$f":"EOMONTH(E78,0)-E78","v":18},{"$f":"E79-EOMONTH(E78,0)","v":12},10604.89,{"$f":"IF(B79<$K$12,$L$14,-$J$41-SUM($J$43:J78))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J78))*(($K$19/(IF(ROUND(YEAR(E78)/4,0)-YEAR(E78)/4=0,366,365)))*G79)+($K$11-SUM($J$43:J78))*(($K$19/(IF(ROUND(YEAR(E79)/4,0)-YEAR(E79)/4=0,366,365)))*H79),2)","v":7104.89},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,38,null,39,"2025-01-12",31,19,12,10813.470000000001,{"$f":"IF(B80<$K$12,$L$14,-$J$41-SUM($J$43:J79))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J79))*(($K$19/(IF(ROUND(YEAR(E79)/4,0)-YEAR(E79)/4=0,366,365)))*G80)+($K$11-SUM($J$43:J79))*(($K$19/(IF(ROUND(YEAR(E80)/4,0)-YEAR(E80)/4=0,366,365)))*H80),2)","v":7313.47},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,39,null,40,"2025-02-12",31,19,12,10789.65,{"$f":"IF(B81<$K$12,$L$14,-$J$41-SUM($J$43:J80))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J80))*(($K$19/(IF(ROUND(YEAR(E80)/4,0)-YEAR(E80)/4=0,366,365)))*G81)+($K$11-SUM($J$43:J80))*(($K$19/(IF(ROUND(YEAR(E81)/4,0)-YEAR(E81)/4=0,366,365)))*H81),2)","v":7289.65},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,40,null,41,"2025-03-12",28,16,12,10051.61,{"$f":"IF(B82<$K$12,$L$14,-$J$41-SUM($J$43:J81))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J81))*(($K$19/(IF(ROUND(YEAR(E81)/4,0)-YEAR(E81)/4=0,366,365)))*G82)+($K$11-SUM($J$43:J81))*(($K$19/(IF(ROUND(YEAR(E82)/4,0)-YEAR(E82)/4=0,366,365)))*H82),2)","v":6551.61},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,41,null,42,"2025-04-12",31,19,12,10717.48,{"$f":"IF(B83<$K$12,$L$14,-$J$41-SUM($J$43:J82))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J82))*(($K$19/(IF(ROUND(YEAR(E82)/4,0)-YEAR(E82)/4=0,366,365)))*G83)+($K$11-SUM($J$43:J82))*(($K$19/(IF(ROUND(YEAR(E83)/4,0)-YEAR(E83)/4=0,366,365)))*H83),2)","v":7217.48},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,42,null,43,"2025-05-12",30,18,12,10449.73,{"$f":"IF(B84<$K$12,$L$14,-$J$41-SUM($J$43:J83))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J83))*(($K$19/(IF(ROUND(YEAR(E83)/4,0)-YEAR(E83)/4=0,366,365)))*G84)+($K$11-SUM($J$43:J83))*(($K$19/(IF(ROUND(YEAR(E84)/4,0)-YEAR(E84)/4=0,366,365)))*H84),2)","v":6949.73},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,43,null,44,"2025-06-12",31,19,12,10645.3,{"$f":"IF(B85<$K$12,$L$14,-$J$41-SUM($J$43:J84))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J84))*(($K$19/(IF(ROUND(YEAR(E84)/4,0)-YEAR(E84)/4=0,366,365)))*G85)+($K$11-SUM($J$43:J84))*(($K$19/(IF(ROUND(YEAR(E85)/4,0)-YEAR(E85)/4=0,366,365)))*H85),2)","v":7145.3},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,44,null,45,"2025-07-12",30,18,12,10379.89,{"$f":"IF(B86<$K$12,$L$14,-$J$41-SUM($J$43:J85))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J85))*(($K$19/(IF(ROUND(YEAR(E85)/4,0)-YEAR(E85)/4=0,366,365)))*G86)+($K$11-SUM($J$43:J85))*(($K$19/(IF(ROUND(YEAR(E86)/4,0)-YEAR(E86)/4=0,366,365)))*H86),2)","v":6879.89},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,45,null,46,"2025-08-12",31,19,12,10573.130000000001,{"$f":"IF(B87<$K$12,$L$14,-$J$41-SUM($J$43:J86))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J86))*(($K$19/(IF(ROUND(YEAR(E86)/4,0)-YEAR(E86)/4=0,366,365)))*G87)+($K$11-SUM($J$43:J86))*(($K$19/(IF(ROUND(YEAR(E87)/4,0)-YEAR(E87)/4=0,366,365)))*H87),2)","v":7073.13},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,46,null,47,"2025-09-12",31,19,12,10537.04,{"$f":"IF(B88<$K$12,$L$14,-$J$41-SUM($J$43:J87))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J87))*(($K$19/(IF(ROUND(YEAR(E87)/4,0)-YEAR(E87)/4=0,366,365)))*G88)+($K$11-SUM($J$43:J87))*(($K$19/(IF(ROUND(YEAR(E88)/4,0)-YEAR(E88)/4=0,366,365)))*H88),2)","v":7037.04},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,47,null,48,"2025-10-12",30,18,12,10275.119999999999,{"$f":"IF(B89<$K$12,$L$14,-$J$41-SUM($J$43:J88))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J88))*(($K$19/(IF(ROUND(YEAR(E88)/4,0)-YEAR(E88)/4=0,366,365)))*G89)+($K$11-SUM($J$43:J88))*(($K$19/(IF(ROUND(YEAR(E89)/4,0)-YEAR(E89)/4=0,366,365)))*H89),2)","v":6775.12},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,48,null,{"$f":"D89+1","v":49},"2025-11-12",{"$f":"IF(A90=1,E90-E89,0)","v":31},{"$f":"EOMONTH(E89,0)-E89","v":19},{"$f":"E90-EOMONTH(E89,0)","v":12},{"$f":"SUM(J90:U90)","v":18117.87},{"$f":"IF(B90<$K$12,$L$14,-$J$41-SUM($J$43:J89))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J89))*(($K$19/(IF(ROUND(YEAR(E89)/4,0)-YEAR(E89)/4=0,366,365)))*G90)+($K$11-SUM($J$43:J89))*(($K$19/(IF(ROUND(YEAR(E90)/4,0)-YEAR(E90)/4=0,366,365)))*H90),2)","v":6964.87},0,null,null,{"$f":"IF(B90<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B90<$K$12,$K$9*$K$27,0)+(-SUM(J41:J89)*K28)","v":7653},null,"х","х"]
[1,49,null,{"$f":"D90+1","v":50},"2025-12-12",30,18,12,10205.27,{"$f":"IF(B91<$K$12,$L$14,-$J$41-SUM($J$43:J90))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J90))*(($K$19/(IF(ROUND(YEAR(E90)/4,0)-YEAR(E90)/4=0,366,365)))*G91)+($K$11-SUM($J$43:J90))*(($K$19/(IF(ROUND(YEAR(E91)/4,0)-YEAR(E91)/4=0,366,365)))*H91),2)","v":6705.27},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B91+1","v":50},null,{"$f":"D91+1","v":51},"2026-01-12",31,19,12,10392.689999999999,{"$f":"IF(B92<$K$12,$L$14,-$J$41-SUM($J$43:J91))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J91))*(($K$19/(IF(ROUND(YEAR(E91)/4,0)-YEAR(E91)/4=0,366,365)))*G92)+($K$11-SUM($J$43:J91))*(($K$19/(IF(ROUND(YEAR(E92)/4,0)-YEAR(E92)/4=0,366,365)))*H92),2)","v":6892.69},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,51,null,{"$f":"D92+1","v":52},"2026-02-12",31,19,12,10356.61,{"$f":"IF(B93<$K$12,$L$14,-$J$41-SUM($J$43:J92))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J92))*(($K$19/(IF(ROUND(YEAR(E92)/4,0)-YEAR(E92)/4=0,366,365)))*G93)+($K$11-SUM($J$43:J92))*(($K$19/(IF(ROUND(YEAR(E93)/4,0)-YEAR(E93)/4=0,366,365)))*H93),2)","v":6856.61},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,52,null,{"$f":"D93+1","v":53},"2026-03-12",28,16,12,9660.4700000000012,{"$f":"IF(B94<$K$12,$L$14,-$J$41-SUM($J$43:J93))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J93))*(($K$19/(IF(ROUND(YEAR(E93)/4,0)-YEAR(E93)/4=0,366,365)))*G94)+($K$11-SUM($J$43:J93))*(($K$19/(IF(ROUND(YEAR(E94)/4,0)-YEAR(E94)/4=0,366,365)))*H94),2)","v":6160.47},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,53,null,{"$f":"D94+1","v":54},"2026-04-12",31,19,12,10284.43,{"$f":"IF(B95<$K$12,$L$14,-$J$41-SUM($J$43:J94))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J94))*(($K$19/(IF(ROUND(YEAR(E94)/4,0)-YEAR(E94)/4=0,366,365)))*G95)+($K$11-SUM($J$43:J94))*(($K$19/(IF(ROUND(YEAR(E95)/4,0)-YEAR(E95)/4=0,366,365)))*H95),2)","v":6784.43},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,54,null,{"$f":"D95+1","v":55},"2026-05-12",30,18,12,10030.65,{"$f":"IF(B96<$K$12,$L$14,-$J$41-SUM($J$43:J95))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J95))*(($K$19/(IF(ROUND(YEAR(E95)/4,0)-YEAR(E95)/4=0,366,365)))*G96)+($K$11-SUM($J$43:J95))*(($K$19/(IF(ROUND(YEAR(E96)/4,0)-YEAR(E96)/4=0,366,365)))*H96),2)","v":6530.65},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,55,null,{"$f":"D96+1","v":56},"2026-06-12",31,19,12,10212.26,{"$f":"IF(B97<$K$12,$L$14,-$J$41-SUM($J$43:J96))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J96))*(($K$19/(IF(ROUND(YEAR(E96)/4,0)-YEAR(E96)/4=0,366,365)))*G97)+($K$11-SUM($J$43:J96))*(($K$19/(IF(ROUND(YEAR(E97)/4,0)-YEAR(E97)/4=0,366,365)))*H97),2)","v":6712.26},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,56,null,{"$f":"D97+1","v":57},"2026-07-12",30,18,12,9960.8100000000013,{"$f":"IF(B98<$K$12,$L$14,-$J$41-SUM($J$43:J97))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J97))*(($K$19/(IF(ROUND(YEAR(E97)/4,0)-YEAR(E97)/4=0,366,365)))*G98)+($K$11-SUM($J$43:J97))*(($K$19/(IF(ROUND(YEAR(E98)/4,0)-YEAR(E98)/4=0,366,365)))*H98),2)","v":6460.81},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,57,null,{"$f":"D98+1","v":58},"2026-08-12",31,19,12,10140.08,{"$f":"IF(B99<$K$12,$L$14,-$J$41-SUM($J$43:J98))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J98))*(($K$19/(IF(ROUND(YEAR(E98)/4,0)-YEAR(E98)/4=0,366,365)))*G99)+($K$11-SUM($J$43:J98))*(($K$19/(IF(ROUND(YEAR(E99)/4,0)-YEAR(E99)/4=0,366,365)))*H99),2)","v":6640.08},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,58,null,{"$f":"D99+1","v":59},"2026-09-12",31,19,12,10103.99,{"$f":"IF(B100<$K$12,$L$14,-$J$41-SUM($J$43:J99))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J99))*(($K$19/(IF(ROUND(YEAR(E99)/4,0)-YEAR(E99)/4=0,366,365)))*G100)+($K$11-SUM($J$43:J99))*(($K$19/(IF(ROUND(YEAR(E100)/4,0)-YEAR(E100)/4=0,366,365)))*H100),2)","v":6603.99},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,59,null,{"$f":"D100+1","v":60},"2026-10-12",30,18,12,9856.0400000000009,{"$f":"IF(B101<$K$12,$L$14,-$J$41-SUM($J$43:J100))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J100))*(($K$19/(IF(ROUND(YEAR(E100)/4,0)-YEAR(E100)/4=0,366,365)))*G101)+($K$11-SUM($J$43:J100))*(($K$19/(IF(ROUND(YEAR(E101)/4,0)-YEAR(E101)/4=0,366,365)))*H101),2)","v":6356.04},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,60,null,{"$f":"D101+1","v":61},"2026-11-12",31,19,12,17432.82,{"$f":"IF(B102<$K$12,$L$14,-$J$41-SUM($J$43:J101))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J101))*(($K$19/(IF(ROUND(YEAR(E101)/4,0)-YEAR(E101)/4=0,366,365)))*G102)+($K$11-SUM($J$43:J101))*(($K$19/(IF(ROUND(YEAR(E102)/4,0)-YEAR(E102)/4=0,366,365)))*H102),2)","v":6531.82},0,null,null,{"$f":"IF(B102<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B102<$K$12,$K$9*$K$27,0)+(-SUM(J41:J101)*K28)","v":7401},null,"х","х"]
[1,61,null,{"$f":"D102+1","v":62},"2026-12-12",30,18,12,9786.1899999999987,{"$f":"IF(B103<$K$12,$L$14,-$J$41-SUM($J$43:J102))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J102))*(($K$19/(IF(ROUND(YEAR(E102)/4,0)-YEAR(E102)/4=0,366,365)))*G103)+($K$11-SUM($J$43:J102))*(($K$19/(IF(ROUND(YEAR(E103)/4,0)-YEAR(E103)/4=0,366,365)))*H103),2)","v":6286.19},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,62,null,{"$f":"D103+1","v":63},"2027-01-12",31,19,12,9959.64,{"$f":"IF(B104<$K$12,$L$14,-$J$41-SUM($J$43:J103))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J103))*(($K$19/(IF(ROUND(YEAR(E103)/4,0)-YEAR(E103)/4=0,366,365)))*G104)+($K$11-SUM($J$43:J103))*(($K$19/(IF(ROUND(YEAR(E104)/4,0)-YEAR(E104)/4=0,366,365)))*H104),2)","v":6459.64},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,63,null,{"$f":"D104+1","v":64},"2027-02-12",31,19,12,9923.5600000000013,{"$f":"IF(B105<$K$12,$L$14,-$J$41-SUM($J$43:J104))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J104))*(($K$19/(IF(ROUND(YEAR(E104)/4,0)-YEAR(E104)/4=0,366,365)))*G105)+($K$11-SUM($J$43:J104))*(($K$19/(IF(ROUND(YEAR(E105)/4,0)-YEAR(E105)/4=0,366,365)))*H105),2)","v":6423.56},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,64,null,{"$f":"D105+1","v":65},"2027-03-12",28,16,12,9269.33,{"$f":"IF(B106<$K$12,$L$14,-$J$41-SUM($J$43:J105))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J105))*(($K$19/(IF(ROUND(YEAR(E105)/4,0)-YEAR(E105)/4=0,366,365)))*G106)+($K$11-SUM($J$43:J105))*(($K$19/(IF(ROUND(YEAR(E106)/4,0)-YEAR(E106)/4=0,366,365)))*H106),2)","v":5769.33},0,null,null,null,null,null,null,null,null,null,"х","х"]
[{"$f":"IF(B107<=$K$12,1,0)","v":1},65,null,{"$f":"D106+1","v":66},"2027-04-12",31,19,12,9851.380000000001,{"$f":"IF(B107<$K$12,$L$14,-$J$41-SUM($J$43:J106))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J106))*(($K$19/(IF(ROUND(YEAR(E106)/4,0)-YEAR(E106)/4=0,366,365)))*G107)+($K$11-SUM($J$43:J106))*(($K$19/(IF(ROUND(YEAR(E107)/4,0)-YEAR(E107)/4=0,366,365)))*H107),2)","v":6351.38},{"$f":"IF(A107=1,IF(AND(YEAR($K$13)=YEAR(EDATE(E106,1)),MONTH($K$13)=MONTH(EDATE(E106,1))),$O$23-$O$46,$O$23),0)","v":0},null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B107+1","v":66},null,{"$f":"D107+1","v":67},"2027-05-12",30,18,12,9611.58,{"$f":"IF(B108<$K$12,$L$14,-$J$41-SUM($J$43:J107))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J107))*(($K$19/(IF(ROUND(YEAR(E107)/4,0)-YEAR(E107)/4=0,366,365)))*G108)+($K$11-SUM($J$43:J107))*(($K$19/(IF(ROUND(YEAR(E108)/4,0)-YEAR(E108)/4=0,366,365)))*H108),2)","v":6111.58},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,67,null,{"$f":"D108+1","v":68},{"$f":"IF(AND(YEAR($K$13)=YEAR(EDATE(E108,1)),MONTH($K$13)=MONTH(EDATE(E108,1))),$K$13,EDATE(E108,1))","v":"2027-06-12"},31,19,12,9779.2099999999991,{"$f":"IF(B109<$K$12,$L$14,-$J$41-SUM($J$43:J108))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J108))*(($K$19/(IF(ROUND(YEAR(E108)/4,0)-YEAR(E108)/4=0,366,365)))*G109)+($K$11-SUM($J$43:J108))*(($K$19/(IF(ROUND(YEAR(E109)/4,0)-YEAR(E109)/4=0,366,365)))*H109),2)","v":6279.21},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,68,null,{"$f":"D109+1","v":69},"2027-07-12",30,18,12,9541.73,{"$f":"IF(B110<$K$12,$L$14,-$J$41-SUM($J$43:J109))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J109))*(($K$19/(IF(ROUND(YEAR(E109)/4,0)-YEAR(E109)/4=0,366,365)))*G110)+($K$11-SUM($J$43:J109))*(($K$19/(IF(ROUND(YEAR(E110)/4,0)-YEAR(E110)/4=0,366,365)))*H110),2)","v":6041.73},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,69,null,{"$f":"D110+1","v":70},"2027-08-12",31,19,12,9707.0299999999988,{"$f":"IF(B111<$K$12,$L$14,-$J$41-SUM($J$43:J110))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J110))*(($K$19/(IF(ROUND(YEAR(E110)/4,0)-YEAR(E110)/4=0,366,365)))*G111)+($K$11-SUM($J$43:J110))*(($K$19/(IF(ROUND(YEAR(E111)/4,0)-YEAR(E111)/4=0,366,365)))*H111),2)","v":6207.03},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,70,null,{"$f":"D111+1","v":71},"2027-09-12",31,19,12,9670.9399999999987,{"$f":"IF(B112<$K$12,$L$14,-$J$41-SUM($J$43:J111))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J111))*(($K$19/(IF(ROUND(YEAR(E111)/4,0)-YEAR(E111)/4=0,366,365)))*G112)+($K$11-SUM($J$43:J111))*(($K$19/(IF(ROUND(YEAR(E112)/4,0)-YEAR(E112)/4=0,366,365)))*H112),2)","v":6170.94},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,71,null,{"$f":"D112+1","v":72},"2027-10-12",30,18,12,9436.9599999999991,{"$f":"IF(B113<$K$12,$L$14,-$J$41-SUM($J$43:J112))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J112))*(($K$19/(IF(ROUND(YEAR(E112)/4,0)-YEAR(E112)/4=0,366,365)))*G113)+($K$11-SUM($J$43:J112))*(($K$19/(IF(ROUND(YEAR(E113)/4,0)-YEAR(E113)/4=0,366,365)))*H113),2)","v":5936.96},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,72,null,{"$f":"D113+1","v":73},"2027-11-12",31,19,12,16747.77,{"$f":"IF(B114<$K$12,$L$14,-$J$41-SUM($J$43:J113))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J113))*(($K$19/(IF(ROUND(YEAR(E113)/4,0)-YEAR(E113)/4=0,366,365)))*G114)+($K$11-SUM($J$43:J113))*(($K$19/(IF(ROUND(YEAR(E114)/4,0)-YEAR(E114)/4=0,366,365)))*H114),2)","v":6098.77},0,null,null,{"$f":"IF(B114<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B114<$K$12,$K$9*$K$27,0)+(-SUM(J41:J113)*K28)","v":7149},null,"х","х"]
[1,{"$f":"B114+1","v":73},null,{"$f":"D114+1","v":74},"2027-12-12",30,18,12,9367.11,{"$f":"IF(B115<$K$12,$L$14,-$J$41-SUM($J$43:J114))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J114))*(($K$19/(IF(ROUND(YEAR(E114)/4,0)-YEAR(E114)/4=0,366,365)))*G115)+($K$11-SUM($J$43:J114))*(($K$19/(IF(ROUND(YEAR(E115)/4,0)-YEAR(E115)/4=0,366,365)))*H115),2)","v":5867.11},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B115+1","v":74},null,{"$f":"D115+1","v":75},"2028-01-12",31,19,12,9520.2200000000012,{"$f":"IF(B116<$K$12,$L$14,-$J$41-SUM($J$43:J115))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J115))*(($K$19/(IF(ROUND(YEAR(E115)/4,0)-YEAR(E115)/4=0,366,365)))*G116)+($K$11-SUM($J$43:J115))*(($K$19/(IF(ROUND(YEAR(E116)/4,0)-YEAR(E116)/4=0,366,365)))*H116),2)","v":6020.22},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B116+1","v":75},null,{"$f":"D116+1","v":76},"2028-02-12",31,19,12,9474.14,{"$f":"IF(B117<$K$12,$L$14,-$J$41-SUM($J$43:J116))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J116))*(($K$19/(IF(ROUND(YEAR(E116)/4,0)-YEAR(E116)/4=0,366,365)))*G117)+($K$11-SUM($J$43:J116))*(($K$19/(IF(ROUND(YEAR(E117)/4,0)-YEAR(E117)/4=0,366,365)))*H117),2)","v":5974.14},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B117+1","v":76},null,{"$f":"D117+1","v":77},"2028-03-12",29,17,12,9055.0499999999993,{"$f":"IF(B118<$K$12,$L$14,-$J$41-SUM($J$43:J117))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J117))*(($K$19/(IF(ROUND(YEAR(E117)/4,0)-YEAR(E117)/4=0,366,365)))*G118)+($K$11-SUM($J$43:J117))*(($K$19/(IF(ROUND(YEAR(E118)/4,0)-YEAR(E118)/4=0,366,365)))*H118),2)","v":5555.05},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B118+1","v":77},null,{"$f":"D118+1","v":78},"2028-04-12",31,19,12,9402.16,{"$f":"IF(B119<$K$12,$L$14,-$J$41-SUM($J$43:J118))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J118))*(($K$19/(IF(ROUND(YEAR(E118)/4,0)-YEAR(E118)/4=0,366,365)))*G119)+($K$11-SUM($J$43:J118))*(($K$19/(IF(ROUND(YEAR(E119)/4,0)-YEAR(E119)/4=0,366,365)))*H119),2)","v":5902.16},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B119+1","v":78},null,{"$f":"D119+1","v":79},"2028-05-12",30,18,12,9176.9399999999987,{"$f":"IF(B120<$K$12,$L$14,-$J$41-SUM($J$43:J119))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J119))*(($K$19/(IF(ROUND(YEAR(E119)/4,0)-YEAR(E119)/4=0,366,365)))*G120)+($K$11-SUM($J$43:J119))*(($K$19/(IF(ROUND(YEAR(E120)/4,0)-YEAR(E120)/4=0,366,365)))*H120),2)","v":5676.94},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B120+1","v":79},null,{"$f":"D120+1","v":80},"2028-06-12",31,19,12,9330.1899999999987,{"$f":"IF(B121<$K$12,$L$14,-$J$41-SUM($J$43:J120))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J120))*(($K$19/(IF(ROUND(YEAR(E120)/4,0)-YEAR(E120)/4=0,366,365)))*G121)+($K$11-SUM($J$43:J120))*(($K$19/(IF(ROUND(YEAR(E121)/4,0)-YEAR(E121)/4=0,366,365)))*H121),2)","v":5830.19},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B121+1","v":80},null,{"$f":"D121+1","v":81},"2028-07-12",30,18,12,9107.2900000000009,{"$f":"IF(B122<$K$12,$L$14,-$J$41-SUM($J$43:J121))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J121))*(($K$19/(IF(ROUND(YEAR(E121)/4,0)-YEAR(E121)/4=0,366,365)))*G122)+($K$11-SUM($J$43:J121))*(($K$19/(IF(ROUND(YEAR(E122)/4,0)-YEAR(E122)/4=0,366,365)))*H122),2)","v":5607.29},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B122+1","v":81},null,{"$f":"D122+1","v":82},"2028-08-12",31,19,12,9258.2099999999991,{"$f":"IF(B123<$K$12,$L$14,-$J$41-SUM($J$43:J122))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J122))*(($K$19/(IF(ROUND(YEAR(E122)/4,0)-YEAR(E122)/4=0,366,365)))*G123)+($K$11-SUM($J$43:J122))*(($K$19/(IF(ROUND(YEAR(E123)/4,0)-YEAR(E123)/4=0,366,365)))*H123),2)","v":5758.21},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B123+1","v":82},null,{"$f":"D123+1","v":83},"2028-09-12",31,19,12,9222.2200000000012,{"$f":"IF(B124<$K$12,$L$14,-$J$41-SUM($J$43:J123))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J123))*(($K$19/(IF(ROUND(YEAR(E123)/4,0)-YEAR(E123)/4=0,366,365)))*G124)+($K$11-SUM($J$43:J123))*(($K$19/(IF(ROUND(YEAR(E124)/4,0)-YEAR(E124)/4=0,366,365)))*H124),2)","v":5722.22},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B124+1","v":83},null,{"$f":"D124+1","v":84},"2028-10-12",30,18,12,9002.7999999999993,{"$f":"IF(B125<$K$12,$L$14,-$J$41-SUM($J$43:J124))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J124))*(($K$19/(IF(ROUND(YEAR(E124)/4,0)-YEAR(E124)/4=0,366,365)))*G125)+($K$11-SUM($J$43:J124))*(($K$19/(IF(ROUND(YEAR(E125)/4,0)-YEAR(E125)/4=0,366,365)))*H125),2)","v":5502.8},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B125+1","v":84},null,{"$f":"D125+1","v":85},"2028-11-12",31,19,12,16047.24,{"$f":"IF(B126<$K$12,$L$14,-$J$41-SUM($J$43:J125))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J125))*(($K$19/(IF(ROUND(YEAR(E125)/4,0)-YEAR(E125)/4=0,366,365)))*G126)+($K$11-SUM($J$43:J125))*(($K$19/(IF(ROUND(YEAR(E126)/4,0)-YEAR(E126)/4=0,366,365)))*H126),2)","v":5650.24},0,null,null,{"$f":"IF(B126<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B126<$K$12,$K$9*$K$27,0)+(-SUM(J41:J125)*K28)","v":6897},null,"х","х"]
[1,{"$f":"B126+1","v":85},null,{"$f":"D126+1","v":86},"2028-12-12",30,18,12,8933.15,{"$f":"IF(B127<$K$12,$L$14,-$J$41-SUM($J$43:J126))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J126))*(($K$19/(IF(ROUND(YEAR(E126)/4,0)-YEAR(E126)/4=0,366,365)))*G127)+($K$11-SUM($J$43:J126))*(($K$19/(IF(ROUND(YEAR(E127)/4,0)-YEAR(E127)/4=0,366,365)))*H127),2)","v":5433.15},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B127+1","v":86},null,{"$f":"D127+1","v":87},"2029-01-12",31,19,12,9084.18,{"$f":"IF(B128<$K$12,$L$14,-$J$41-SUM($J$43:J127))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J127))*(($K$19/(IF(ROUND(YEAR(E127)/4,0)-YEAR(E127)/4=0,366,365)))*G128)+($K$11-SUM($J$43:J127))*(($K$19/(IF(ROUND(YEAR(E128)/4,0)-YEAR(E128)/4=0,366,365)))*H128),2)","v":5584.18},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B128+1","v":87},null,{"$f":"D128+1","v":88},"2029-02-12",31,19,12,9057.4599999999991,{"$f":"IF(B129<$K$12,$L$14,-$J$41-SUM($J$43:J128))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J128))*(($K$19/(IF(ROUND(YEAR(E128)/4,0)-YEAR(E128)/4=0,366,365)))*G129)+($K$11-SUM($J$43:J128))*(($K$19/(IF(ROUND(YEAR(E129)/4,0)-YEAR(E129)/4=0,366,365)))*H129),2)","v":5557.46},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B129+1","v":88},null,{"$f":"D129+1","v":89},"2029-03-12",28,16,12,8487.0499999999993,{"$f":"IF(B130<$K$12,$L$14,-$J$41-SUM($J$43:J129))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J129))*(($K$19/(IF(ROUND(YEAR(E129)/4,0)-YEAR(E129)/4=0,366,365)))*G130)+($K$11-SUM($J$43:J129))*(($K$19/(IF(ROUND(YEAR(E130)/4,0)-YEAR(E130)/4=0,366,365)))*H130),2)","v":4987.05},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B130+1","v":89},null,{"$f":"D130+1","v":90},"2029-04-12",31,19,12,8985.2799999999988,{"$f":"IF(B131<$K$12,$L$14,-$J$41-SUM($J$43:J130))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J130))*(($K$19/(IF(ROUND(YEAR(E130)/4,0)-YEAR(E130)/4=0,366,365)))*G131)+($K$11-SUM($J$43:J130))*(($K$19/(IF(ROUND(YEAR(E131)/4,0)-YEAR(E131)/4=0,366,365)))*H131),2)","v":5485.28},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B131+1","v":90},null,{"$f":"D131+1","v":91},"2029-05-12",30,18,12,8773.42,{"$f":"IF(B132<$K$12,$L$14,-$J$41-SUM($J$43:J131))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J131))*(($K$19/(IF(ROUND(YEAR(E131)/4,0)-YEAR(E131)/4=0,366,365)))*G132)+($K$11-SUM($J$43:J131))*(($K$19/(IF(ROUND(YEAR(E132)/4,0)-YEAR(E132)/4=0,366,365)))*H132),2)","v":5273.42},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B132+1","v":91},null,{"$f":"D132+1","v":92},"2029-06-12",31,19,12,8913.11,{"$f":"IF(B133<$K$12,$L$14,-$J$41-SUM($J$43:J132))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J132))*(($K$19/(IF(ROUND(YEAR(E132)/4,0)-YEAR(E132)/4=0,366,365)))*G133)+($K$11-SUM($J$43:J132))*(($K$19/(IF(ROUND(YEAR(E133)/4,0)-YEAR(E133)/4=0,366,365)))*H133),2)","v":5413.11},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B133+1","v":92},null,{"$f":"D133+1","v":93},"2029-07-12",30,18,12,8703.57,{"$f":"IF(B134<$K$12,$L$14,-$J$41-SUM($J$43:J133))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J133))*(($K$19/(IF(ROUND(YEAR(E133)/4,0)-YEAR(E133)/4=0,366,365)))*G134)+($K$11-SUM($J$43:J133))*(($K$19/(IF(ROUND(YEAR(E134)/4,0)-YEAR(E134)/4=0,366,365)))*H134),2)","v":5203.57},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B134+1","v":93},null,{"$f":"D134+1","v":94},"2029-08-12",31,19,12,8840.93,{"$f":"IF(B135<$K$12,$L$14,-$J$41-SUM($J$43:J134))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J134))*(($K$19/(IF(ROUND(YEAR(E134)/4,0)-YEAR(E134)/4=0,366,365)))*G135)+($K$11-SUM($J$43:J134))*(($K$19/(IF(ROUND(YEAR(E135)/4,0)-YEAR(E135)/4=0,366,365)))*H135),2)","v":5340.93},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B135+1","v":94},null,{"$f":"D135+1","v":95},"2029-09-12",31,19,12,8804.85,{"$f":"IF(B136<$K$12,$L$14,-$J$41-SUM($J$43:J135))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J135))*(($K$19/(IF(ROUND(YEAR(E135)/4,0)-YEAR(E135)/4=0,366,365)))*G136)+($K$11-SUM($J$43:J135))*(($K$19/(IF(ROUND(YEAR(E136)/4,0)-YEAR(E136)/4=0,366,365)))*H136),2)","v":5304.85},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B136+1","v":95},null,{"$f":"D136+1","v":96},"2029-10-12",30,18,12,8598.7999999999993,{"$f":"IF(B137<$K$12,$L$14,-$J$41-SUM($J$43:J136))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J136))*(($K$19/(IF(ROUND(YEAR(E136)/4,0)-YEAR(E136)/4=0,366,365)))*G137)+($K$11-SUM($J$43:J136))*(($K$19/(IF(ROUND(YEAR(E137)/4,0)-YEAR(E137)/4=0,366,365)))*H137),2)","v":5098.8},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B137+1","v":96},null,{"$f":"D137+1","v":97},"2029-11-12",31,19,12,15377.67,{"$f":"IF(B138<$K$12,$L$14,-$J$41-SUM($J$43:J137))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J137))*(($K$19/(IF(ROUND(YEAR(E137)/4,0)-YEAR(E137)/4=0,366,365)))*G138)+($K$11-SUM($J$43:J137))*(($K$19/(IF(ROUND(YEAR(E138)/4,0)-YEAR(E138)/4=0,366,365)))*H138),2)","v":5232.67},0,null,null,{"$f":"IF(B138<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B138<$K$12,$K$9*$K$27,0)+(-SUM(J41:J137)*K28)","v":6645},null,"х","х"]
[1,{"$f":"B138+1","v":97},null,{"$f":"D138+1","v":98},"2029-12-12",30,18,12,8528.9500000000007,{"$f":"IF(B139<$K$12,$L$14,-$J$41-SUM($J$43:J138))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J138))*(($K$19/(IF(ROUND(YEAR(E138)/4,0)-YEAR(E138)/4=0,366,365)))*G139)+($K$11-SUM($J$43:J138))*(($K$19/(IF(ROUND(YEAR(E139)/4,0)-YEAR(E139)/4=0,366,365)))*H139),2)","v":5028.95},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B139+1","v":98},null,{"$f":"D139+1","v":99},"2030-01-12",31,19,12,8660.5,{"$f":"IF(B140<$K$12,$L$14,-$J$41-SUM($J$43:J139))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J139))*(($K$19/(IF(ROUND(YEAR(E139)/4,0)-YEAR(E139)/4=0,366,365)))*G140)+($K$11-SUM($J$43:J139))*(($K$19/(IF(ROUND(YEAR(E140)/4,0)-YEAR(E140)/4=0,366,365)))*H140),2)","v":5160.5},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B140+1","v":99},null,{"$f":"D140+1","v":100},"2030-02-12",31,19,12,8624.41,{"$f":"IF(B141<$K$12,$L$14,-$J$41-SUM($J$43:J140))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J140))*(($K$19/(IF(ROUND(YEAR(E140)/4,0)-YEAR(E140)/4=0,366,365)))*G141)+($K$11-SUM($J$43:J140))*(($K$19/(IF(ROUND(YEAR(E141)/4,0)-YEAR(E141)/4=0,366,365)))*H141),2)","v":5124.41},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B141+1","v":100},null,{"$f":"D141+1","v":101},"2030-03-12",28,16,12,8095.9,{"$f":"IF(B142<$K$12,$L$14,-$J$41-SUM($J$43:J141))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J141))*(($K$19/(IF(ROUND(YEAR(E141)/4,0)-YEAR(E141)/4=0,366,365)))*G142)+($K$11-SUM($J$43:J141))*(($K$19/(IF(ROUND(YEAR(E142)/4,0)-YEAR(E142)/4=0,366,365)))*H142),2)","v":4595.8999999999996},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B142+1","v":101},null,{"$f":"D142+1","v":102},"2030-04-12",31,19,12,8552.24,{"$f":"IF(B143<$K$12,$L$14,-$J$41-SUM($J$43:J142))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J142))*(($K$19/(IF(ROUND(YEAR(E142)/4,0)-YEAR(E142)/4=0,366,365)))*G143)+($K$11-SUM($J$43:J142))*(($K$19/(IF(ROUND(YEAR(E143)/4,0)-YEAR(E143)/4=0,366,365)))*H143),2)","v":5052.24},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B143+1","v":102},null,{"$f":"D143+1","v":103},"2030-05-12",30,18,12,8354.34,{"$f":"IF(B144<$K$12,$L$14,-$J$41-SUM($J$43:J143))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J143))*(($K$19/(IF(ROUND(YEAR(E143)/4,0)-YEAR(E143)/4=0,366,365)))*G144)+($K$11-SUM($J$43:J143))*(($K$19/(IF(ROUND(YEAR(E144)/4,0)-YEAR(E144)/4=0,366,365)))*H144),2)","v":4854.34},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B144+1","v":103},null,{"$f":"D144+1","v":104},"2030-06-12",31,19,12,8480.0600000000013,{"$f":"IF(B145<$K$12,$L$14,-$J$41-SUM($J$43:J144))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J144))*(($K$19/(IF(ROUND(YEAR(E144)/4,0)-YEAR(E144)/4=0,366,365)))*G145)+($K$11-SUM($J$43:J144))*(($K$19/(IF(ROUND(YEAR(E145)/4,0)-YEAR(E145)/4=0,366,365)))*H145),2)","v":4980.0600000000004},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B145+1","v":104},null,{"$f":"D145+1","v":105},"2030-07-12",30,18,12,8284.49,{"$f":"IF(B146<$K$12,$L$14,-$J$41-SUM($J$43:J145))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J145))*(($K$19/(IF(ROUND(YEAR(E145)/4,0)-YEAR(E145)/4=0,366,365)))*G146)+($K$11-SUM($J$43:J145))*(($K$19/(IF(ROUND(YEAR(E146)/4,0)-YEAR(E146)/4=0,366,365)))*H146),2)","v":4784.49},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B146+1","v":105},null,{"$f":"D146+1","v":106},"2030-08-12",31,19,12,8407.89,{"$f":"IF(B147<$K$12,$L$14,-$J$41-SUM($J$43:J146))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J146))*(($K$19/(IF(ROUND(YEAR(E146)/4,0)-YEAR(E146)/4=0,366,365)))*G147)+($K$11-SUM($J$43:J146))*(($K$19/(IF(ROUND(YEAR(E147)/4,0)-YEAR(E147)/4=0,366,365)))*H147),2)","v":4907.8900000000003},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B147+1","v":106},null,{"$f":"D147+1","v":107},"2030-09-12",31,19,12,8371.7999999999993,{"$f":"IF(B148<$K$12,$L$14,-$J$41-SUM($J$43:J147))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J147))*(($K$19/(IF(ROUND(YEAR(E147)/4,0)-YEAR(E147)/4=0,366,365)))*G148)+($K$11-SUM($J$43:J147))*(($K$19/(IF(ROUND(YEAR(E148)/4,0)-YEAR(E148)/4=0,366,365)))*H148),2)","v":4871.8},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B148+1","v":107},null,{"$f":"D148+1","v":108},"2030-10-12",30,18,12,8179.72,{"$f":"IF(B149<$K$12,$L$14,-$J$41-SUM($J$43:J148))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J148))*(($K$19/(IF(ROUND(YEAR(E148)/4,0)-YEAR(E148)/4=0,366,365)))*G149)+($K$11-SUM($J$43:J148))*(($K$19/(IF(ROUND(YEAR(E149)/4,0)-YEAR(E149)/4=0,366,365)))*H149),2)","v":4679.72},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B149+1","v":108},null,{"$f":"D149+1","v":109},"2030-11-12",31,19,12,14692.619999999999,{"$f":"IF(B150<$K$12,$L$14,-$J$41-SUM($J$43:J149))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J149))*(($K$19/(IF(ROUND(YEAR(E149)/4,0)-YEAR(E149)/4=0,366,365)))*G150)+($K$11-SUM($J$43:J149))*(($K$19/(IF(ROUND(YEAR(E150)/4,0)-YEAR(E150)/4=0,366,365)))*H150),2)","v":4799.62},0,null,null,{"$f":"IF(B150<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B150<$K$12,$K$9*$K$27,0)+(-SUM(J41:J149)*K28)","v":6393},null,"х","х"]
[1,{"$f":"B150+1","v":109},null,{"$f":"D150+1","v":110},"2030-12-12",30,18,12,8109.87,{"$f":"IF(B151<$K$12,$L$14,-$J$41-SUM($J$43:J150))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J150))*(($K$19/(IF(ROUND(YEAR(E150)/4,0)-YEAR(E150)/4=0,366,365)))*G151)+($K$11-SUM($J$43:J150))*(($K$19/(IF(ROUND(YEAR(E151)/4,0)-YEAR(E151)/4=0,366,365)))*H151),2)","v":4609.87},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B151+1","v":110},null,{"$f":"D151+1","v":111},"2031-01-12",31,19,12,8227.4500000000007,{"$f":"IF(B152<$K$12,$L$14,-$J$41-SUM($J$43:J151))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J151))*(($K$19/(IF(ROUND(YEAR(E151)/4,0)-YEAR(E151)/4=0,366,365)))*G152)+($K$11-SUM($J$43:J151))*(($K$19/(IF(ROUND(YEAR(E152)/4,0)-YEAR(E152)/4=0,366,365)))*H152),2)","v":4727.45},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B152+1","v":111},null,{"$f":"D152+1","v":112},"2031-02-12",31,19,12,8191.36,{"$f":"IF(B153<$K$12,$L$14,-$J$41-SUM($J$43:J152))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J152))*(($K$19/(IF(ROUND(YEAR(E152)/4,0)-YEAR(E152)/4=0,366,365)))*G153)+($K$11-SUM($J$43:J152))*(($K$19/(IF(ROUND(YEAR(E153)/4,0)-YEAR(E153)/4=0,366,365)))*H153),2)","v":4691.3599999999997},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B153+1","v":112},null,{"$f":"D153+1","v":113},"2031-03-12",{"$f":"IF(A154=1,E154-E153,0)","v":28},{"$f":"EOMONTH(E153,0)-E153","v":16},{"$f":"E154-EOMONTH(E153,0)","v":12},{"$f":"SUM(J154:U154)","v":7704.76},{"$f":"IF(B154<$K$12,$L$14,-$J$41-SUM($J$43:J153))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J153))*(($K$19/(IF(ROUND(YEAR(E153)/4,0)-YEAR(E153)/4=0,366,365)))*G154)+($K$11-SUM($J$43:J153))*(($K$19/(IF(ROUND(YEAR(E154)/4,0)-YEAR(E154)/4=0,366,365)))*H154),2)","v":4204.76},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B154+1","v":113},null,{"$f":"D154+1","v":114},"2031-04-12",31,19,12,8119.19,{"$f":"IF(B155<$K$12,$L$14,-$J$41-SUM($J$43:J154))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J154))*(($K$19/(IF(ROUND(YEAR(E154)/4,0)-YEAR(E154)/4=0,366,365)))*G155)+($K$11-SUM($J$43:J154))*(($K$19/(IF(ROUND(YEAR(E155)/4,0)-YEAR(E155)/4=0,366,365)))*H155),2)","v":4619.1899999999996},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B155+1","v":114},null,{"$f":"D155+1","v":115},"2031-05-12",30,18,12,7935.26,{"$f":"IF(B156<$K$12,$L$14,-$J$41-SUM($J$43:J155))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J155))*(($K$19/(IF(ROUND(YEAR(E155)/4,0)-YEAR(E155)/4=0,366,365)))*G156)+($K$11-SUM($J$43:J155))*(($K$19/(IF(ROUND(YEAR(E156)/4,0)-YEAR(E156)/4=0,366,365)))*H156),2)","v":4435.26},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B156+1","v":115},null,{"$f":"D156+1","v":116},"2031-06-12",31,19,12,8047.01,{"$f":"IF(B157<$K$12,$L$14,-$J$41-SUM($J$43:J156))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J156))*(($K$19/(IF(ROUND(YEAR(E156)/4,0)-YEAR(E156)/4=0,366,365)))*G157)+($K$11-SUM($J$43:J156))*(($K$19/(IF(ROUND(YEAR(E157)/4,0)-YEAR(E157)/4=0,366,365)))*H157),2)","v":4547.01},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B157+1","v":116},null,{"$f":"D157+1","v":117},"2031-07-12",30,18,12,7865.41,{"$f":"IF(B158<$K$12,$L$14,-$J$41-SUM($J$43:J157))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J157))*(($K$19/(IF(ROUND(YEAR(E157)/4,0)-YEAR(E157)/4=0,366,365)))*G158)+($K$11-SUM($J$43:J157))*(($K$19/(IF(ROUND(YEAR(E158)/4,0)-YEAR(E158)/4=0,366,365)))*H158),2)","v":4365.41},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B158+1","v":117},null,{"$f":"D158+1","v":118},"2031-08-12",31,19,12,7974.84,{"$f":"IF(B159<$K$12,$L$14,-$J$41-SUM($J$43:J158))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J158))*(($K$19/(IF(ROUND(YEAR(E158)/4,0)-YEAR(E158)/4=0,366,365)))*G159)+($K$11-SUM($J$43:J158))*(($K$19/(IF(ROUND(YEAR(E159)/4,0)-YEAR(E159)/4=0,366,365)))*H159),2)","v":4474.84},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B159+1","v":118},null,{"$f":"D159+1","v":119},"2031-09-12",31,19,12,7938.75,{"$f":"IF(B160<$K$12,$L$14,-$J$41-SUM($J$43:J159))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J159))*(($K$19/(IF(ROUND(YEAR(E159)/4,0)-YEAR(E159)/4=0,366,365)))*G160)+($K$11-SUM($J$43:J159))*(($K$19/(IF(ROUND(YEAR(E160)/4,0)-YEAR(E160)/4=0,366,365)))*H160),2)","v":4438.75},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B160+1","v":119},null,{"$f":"D160+1","v":120},"2031-10-12",30,18,12,7760.64,{"$f":"IF(B161<$K$12,$L$14,-$J$41-SUM($J$43:J160))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J160))*(($K$19/(IF(ROUND(YEAR(E160)/4,0)-YEAR(E160)/4=0,366,365)))*G161)+($K$11-SUM($J$43:J160))*(($K$19/(IF(ROUND(YEAR(E161)/4,0)-YEAR(E161)/4=0,366,365)))*H161),2)","v":4260.6400000000003},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B161+1","v":120},null,{"$f":"D161+1","v":121},"2031-11-12",31,19,12,14007.58,{"$f":"IF(B162<$K$12,$L$14,-$J$41-SUM($J$43:J161))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J161))*(($K$19/(IF(ROUND(YEAR(E161)/4,0)-YEAR(E161)/4=0,366,365)))*G162)+($K$11-SUM($J$43:J161))*(($K$19/(IF(ROUND(YEAR(E162)/4,0)-YEAR(E162)/4=0,366,365)))*H162),2)","v":4366.58},0,null,null,{"$f":"IF(B162<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B162<$K$12,$K$9*$K$27,0)+(-SUM(J41:J161)*K28)","v":6141},null,"х","х"]
[1,{"$f":"B162+1","v":121},null,{"$f":"D162+1","v":122},"2031-12-12",30,18,12,7690.79,{"$f":"IF(B163<$K$12,$L$14,-$J$41-SUM($J$43:J162))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J162))*(($K$19/(IF(ROUND(YEAR(E162)/4,0)-YEAR(E162)/4=0,366,365)))*G163)+($K$11-SUM($J$43:J162))*(($K$19/(IF(ROUND(YEAR(E163)/4,0)-YEAR(E163)/4=0,366,365)))*H163),2)","v":4190.79},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B163+1","v":122},null,{"$f":"D163+1","v":123},"2032-01-12",31,19,12,7789.86,{"$f":"IF(B164<$K$12,$L$14,-$J$41-SUM($J$43:J163))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J163))*(($K$19/(IF(ROUND(YEAR(E163)/4,0)-YEAR(E163)/4=0,366,365)))*G164)+($K$11-SUM($J$43:J163))*(($K$19/(IF(ROUND(YEAR(E164)/4,0)-YEAR(E164)/4=0,366,365)))*H164),2)","v":4289.8599999999997},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B164+1","v":123},null,{"$f":"D164+1","v":124},"2032-02-12",31,19,12,7746.68,{"$f":"IF(B165<$K$12,$L$14,-$J$41-SUM($J$43:J164))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J164))*(($K$19/(IF(ROUND(YEAR(E164)/4,0)-YEAR(E164)/4=0,366,365)))*G165)+($K$11-SUM($J$43:J164))*(($K$19/(IF(ROUND(YEAR(E165)/4,0)-YEAR(E165)/4=0,366,365)))*H165),2)","v":4246.68},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B165+1","v":124},null,{"$f":"D165+1","v":125},"2032-03-12",29,17,12,7439.0300000000007,{"$f":"IF(B166<$K$12,$L$14,-$J$41-SUM($J$43:J165))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J165))*(($K$19/(IF(ROUND(YEAR(E165)/4,0)-YEAR(E165)/4=0,366,365)))*G166)+($K$11-SUM($J$43:J165))*(($K$19/(IF(ROUND(YEAR(E166)/4,0)-YEAR(E166)/4=0,366,365)))*H166),2)","v":3939.03},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B166+1","v":125},null,{"$f":"D166+1","v":126},"2032-04-12",31,19,12,7674.7,{"$f":"IF(B167<$K$12,$L$14,-$J$41-SUM($J$43:J166))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J166))*(($K$19/(IF(ROUND(YEAR(E166)/4,0)-YEAR(E166)/4=0,366,365)))*G167)+($K$11-SUM($J$43:J166))*(($K$19/(IF(ROUND(YEAR(E167)/4,0)-YEAR(E167)/4=0,366,365)))*H167),2)","v":4174.7},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B167+1","v":126},null,{"$f":"D167+1","v":127},"2032-05-12",30,18,12,7505.2,{"$f":"IF(B168<$K$12,$L$14,-$J$41-SUM($J$43:J167))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J167))*(($K$19/(IF(ROUND(YEAR(E167)/4,0)-YEAR(E167)/4=0,366,365)))*G168)+($K$11-SUM($J$43:J167))*(($K$19/(IF(ROUND(YEAR(E168)/4,0)-YEAR(E168)/4=0,366,365)))*H168),2)","v":4005.2},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B168+1","v":127},null,{"$f":"D168+1","v":128},"2032-06-12",31,19,12,7602.72,{"$f":"IF(B169<$K$12,$L$14,-$J$41-SUM($J$43:J168))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J168))*(($K$19/(IF(ROUND(YEAR(E168)/4,0)-YEAR(E168)/4=0,366,365)))*G169)+($K$11-SUM($J$43:J168))*(($K$19/(IF(ROUND(YEAR(E169)/4,0)-YEAR(E169)/4=0,366,365)))*H169),2)","v":4102.72},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B169+1","v":128},null,{"$f":"D169+1","v":129},"2032-07-12",30,18,12,7435.55,{"$f":"IF(B170<$K$12,$L$14,-$J$41-SUM($J$43:J169))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J169))*(($K$19/(IF(ROUND(YEAR(E169)/4,0)-YEAR(E169)/4=0,366,365)))*G170)+($K$11-SUM($J$43:J169))*(($K$19/(IF(ROUND(YEAR(E170)/4,0)-YEAR(E170)/4=0,366,365)))*H170),2)","v":3935.55},0,null,null,null,null,null,null,null,null,null,"х","х"]
[{"$f":"IF(B171<=$K$12,1,0)","v":1},{"$f":"B170+1","v":129},null,{"$f":"D170+1","v":130},"2032-08-12",31,19,12,7530.75,{"$f":"IF(B171<$K$12,$L$14,-$J$41-SUM($J$43:J170))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J170))*(($K$19/(IF(ROUND(YEAR(E170)/4,0)-YEAR(E170)/4=0,366,365)))*G171)+($K$11-SUM($J$43:J170))*(($K$19/(IF(ROUND(YEAR(E171)/4,0)-YEAR(E171)/4=0,366,365)))*H171),2)","v":4030.75},{"$f":"IF(A171=1,IF(AND(YEAR($K$13)=YEAR(EDATE(E170,1)),MONTH($K$13)=MONTH(EDATE(E170,1))),$O$23-$O$46,$O$23),0)","v":0},null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B171+1","v":130},null,{"$f":"D171+1","v":131},"2032-09-12",31,19,12,7494.76,{"$f":"IF(B172<$K$12,$L$14,-$J$41-SUM($J$43:J171))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J171))*(($K$19/(IF(ROUND(YEAR(E171)/4,0)-YEAR(E171)/4=0,366,365)))*G172)+($K$11-SUM($J$43:J171))*(($K$19/(IF(ROUND(YEAR(E172)/4,0)-YEAR(E172)/4=0,366,365)))*H172),2)","v":3994.76},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B172+1","v":131},null,{"$f":"D172+1","v":132},{"$f":"IF(AND(YEAR($K$13)=YEAR(EDATE(E172,1)),MONTH($K$13)=MONTH(EDATE(E172,1))),$K$13,EDATE(E172,1))","v":"2032-10-12"},30,18,12,7331.07,{"$f":"IF(B173<$K$12,$L$14,-$J$41-SUM($J$43:J172))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J172))*(($K$19/(IF(ROUND(YEAR(E172)/4,0)-YEAR(E172)/4=0,366,365)))*G173)+($K$11-SUM($J$43:J172))*(($K$19/(IF(ROUND(YEAR(E173)/4,0)-YEAR(E173)/4=0,366,365)))*H173),2)","v":3831.07},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B173+1","v":132},null,{"$f":"D173+1","v":133},"2032-11-12",31,19,12,13311.78,{"$f":"IF(B174<$K$12,$L$14,-$J$41-SUM($J$43:J173))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J173))*(($K$19/(IF(ROUND(YEAR(E173)/4,0)-YEAR(E173)/4=0,366,365)))*G174)+($K$11-SUM($J$43:J173))*(($K$19/(IF(ROUND(YEAR(E174)/4,0)-YEAR(E174)/4=0,366,365)))*H174),2)","v":3922.78},0,null,null,{"$f":"IF(B174<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B174<$K$12,$K$9*$K$27,0)+(-SUM(J41:J173)*K28)","v":5889},null,"х","х"]
[1,{"$f":"B174+1","v":133},null,{"$f":"D174+1","v":134},"2032-12-12",30,18,12,7261.41,{"$f":"IF(B175<$K$12,$L$14,-$J$41-SUM($J$43:J174))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J174))*(($K$19/(IF(ROUND(YEAR(E174)/4,0)-YEAR(E174)/4=0,366,365)))*G175)+($K$11-SUM($J$43:J174))*(($K$19/(IF(ROUND(YEAR(E175)/4,0)-YEAR(E175)/4=0,366,365)))*H175),2)","v":3761.41},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B175+1","v":134},null,{"$f":"D175+1","v":135},"2033-01-12",31,19,12,7354.8899999999994,{"$f":"IF(B176<$K$12,$L$14,-$J$41-SUM($J$43:J175))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J175))*(($K$19/(IF(ROUND(YEAR(E175)/4,0)-YEAR(E175)/4=0,366,365)))*G176)+($K$11-SUM($J$43:J175))*(($K$19/(IF(ROUND(YEAR(E176)/4,0)-YEAR(E176)/4=0,366,365)))*H176),2)","v":3854.89},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B176+1","v":135},null,{"$f":"D176+1","v":136},"2033-02-12",31,19,12,7325.26,{"$f":"IF(B177<$K$12,$L$14,-$J$41-SUM($J$43:J176))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J176))*(($K$19/(IF(ROUND(YEAR(E176)/4,0)-YEAR(E176)/4=0,366,365)))*G177)+($K$11-SUM($J$43:J176))*(($K$19/(IF(ROUND(YEAR(E177)/4,0)-YEAR(E177)/4=0,366,365)))*H177),2)","v":3825.26},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B177+1","v":136},null,{"$f":"D177+1","v":137},"2033-03-12",28,16,12,6922.48,{"$f":"IF(B178<$K$12,$L$14,-$J$41-SUM($J$43:J177))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J177))*(($K$19/(IF(ROUND(YEAR(E177)/4,0)-YEAR(E177)/4=0,366,365)))*G178)+($K$11-SUM($J$43:J177))*(($K$19/(IF(ROUND(YEAR(E178)/4,0)-YEAR(E178)/4=0,366,365)))*H178),2)","v":3422.48},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B178+1","v":137},null,{"$f":"D178+1","v":138},"2033-04-12",31,19,12,7253.09,{"$f":"IF(B179<$K$12,$L$14,-$J$41-SUM($J$43:J178))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J178))*(($K$19/(IF(ROUND(YEAR(E178)/4,0)-YEAR(E178)/4=0,366,365)))*G179)+($K$11-SUM($J$43:J178))*(($K$19/(IF(ROUND(YEAR(E179)/4,0)-YEAR(E179)/4=0,366,365)))*H179),2)","v":3753.09},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B179+1","v":138},null,{"$f":"D179+1","v":139},"2033-05-12",30,18,12,7097.1,{"$f":"IF(B180<$K$12,$L$14,-$J$41-SUM($J$43:J179))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J179))*(($K$19/(IF(ROUND(YEAR(E179)/4,0)-YEAR(E179)/4=0,366,365)))*G180)+($K$11-SUM($J$43:J179))*(($K$19/(IF(ROUND(YEAR(E180)/4,0)-YEAR(E180)/4=0,366,365)))*H180),2)","v":3597.1},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B180+1","v":139},null,{"$f":"D180+1","v":140},"2033-06-12",31,19,12,7180.91,{"$f":"IF(B181<$K$12,$L$14,-$J$41-SUM($J$43:J180))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J180))*(($K$19/(IF(ROUND(YEAR(E180)/4,0)-YEAR(E180)/4=0,366,365)))*G181)+($K$11-SUM($J$43:J180))*(($K$19/(IF(ROUND(YEAR(E181)/4,0)-YEAR(E181)/4=0,366,365)))*H181),2)","v":3680.91},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B181+1","v":140},null,{"$f":"D181+1","v":141},"2033-07-12",30,18,12,7027.25,{"$f":"IF(B182<$K$12,$L$14,-$J$41-SUM($J$43:J181))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J181))*(($K$19/(IF(ROUND(YEAR(E181)/4,0)-YEAR(E181)/4=0,366,365)))*G182)+($K$11-SUM($J$43:J181))*(($K$19/(IF(ROUND(YEAR(E182)/4,0)-YEAR(E182)/4=0,366,365)))*H182),2)","v":3527.25},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B182+1","v":141},null,{"$f":"D182+1","v":142},"2033-08-12",31,19,12,7108.74,{"$f":"IF(B183<$K$12,$L$14,-$J$41-SUM($J$43:J182))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J182))*(($K$19/(IF(ROUND(YEAR(E182)/4,0)-YEAR(E182)/4=0,366,365)))*G183)+($K$11-SUM($J$43:J182))*(($K$19/(IF(ROUND(YEAR(E183)/4,0)-YEAR(E183)/4=0,366,365)))*H183),2)","v":3608.74},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B183+1","v":142},null,{"$f":"D183+1","v":143},"2033-09-12",31,19,12,7072.65,{"$f":"IF(B184<$K$12,$L$14,-$J$41-SUM($J$43:J183))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J183))*(($K$19/(IF(ROUND(YEAR(E183)/4,0)-YEAR(E183)/4=0,366,365)))*G184)+($K$11-SUM($J$43:J183))*(($K$19/(IF(ROUND(YEAR(E184)/4,0)-YEAR(E184)/4=0,366,365)))*H184),2)","v":3572.65},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B184+1","v":143},null,{"$f":"D184+1","v":144},"2033-10-12",30,18,12,6922.48,{"$f":"IF(B185<$K$12,$L$14,-$J$41-SUM($J$43:J184))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J184))*(($K$19/(IF(ROUND(YEAR(E184)/4,0)-YEAR(E184)/4=0,366,365)))*G185)+($K$11-SUM($J$43:J184))*(($K$19/(IF(ROUND(YEAR(E185)/4,0)-YEAR(E185)/4=0,366,365)))*H185),2)","v":3422.48},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B185+1","v":144},null,{"$f":"D185+1","v":145},"2033-11-12",31,19,12,12637.48,{"$f":"IF(B186<$K$12,$L$14,-$J$41-SUM($J$43:J185))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J185))*(($K$19/(IF(ROUND(YEAR(E185)/4,0)-YEAR(E185)/4=0,366,365)))*G186)+($K$11-SUM($J$43:J185))*(($K$19/(IF(ROUND(YEAR(E186)/4,0)-YEAR(E186)/4=0,366,365)))*H186),2)","v":3500.48},0,null,null,{"$f":"IF(B186<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B186<$K$12,$K$9*$K$27,0)+(-SUM(J41:J185)*K28)","v":5637},null,"х","х"]
[1,{"$f":"B186+1","v":145},null,{"$f":"D186+1","v":146},"2033-12-12",30,18,12,6852.6399999999994,{"$f":"IF(B187<$K$12,$L$14,-$J$41-SUM($J$43:J186))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J186))*(($K$19/(IF(ROUND(YEAR(E186)/4,0)-YEAR(E186)/4=0,366,365)))*G187)+($K$11-SUM($J$43:J186))*(($K$19/(IF(ROUND(YEAR(E187)/4,0)-YEAR(E187)/4=0,366,365)))*H187),2)","v":3352.64},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B187+1","v":146},null,{"$f":"D187+1","v":147},"2034-01-12",31,19,12,6928.3,{"$f":"IF(B188<$K$12,$L$14,-$J$41-SUM($J$43:J187))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J187))*(($K$19/(IF(ROUND(YEAR(E187)/4,0)-YEAR(E187)/4=0,366,365)))*G188)+($K$11-SUM($J$43:J187))*(($K$19/(IF(ROUND(YEAR(E188)/4,0)-YEAR(E188)/4=0,366,365)))*H188),2)","v":3428.3},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B188+1","v":147},null,{"$f":"D188+1","v":148},"2034-02-12",31,19,12,6892.2199999999993,{"$f":"IF(B189<$K$12,$L$14,-$J$41-SUM($J$43:J188))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J188))*(($K$19/(IF(ROUND(YEAR(E188)/4,0)-YEAR(E188)/4=0,366,365)))*G189)+($K$11-SUM($J$43:J188))*(($K$19/(IF(ROUND(YEAR(E189)/4,0)-YEAR(E189)/4=0,366,365)))*H189),2)","v":3392.22},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B189+1","v":148},null,{"$f":"D189+1","v":149},"2034-03-12",28,16,12,6531.34,{"$f":"IF(B190<$K$12,$L$14,-$J$41-SUM($J$43:J189))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J189))*(($K$19/(IF(ROUND(YEAR(E189)/4,0)-YEAR(E189)/4=0,366,365)))*G190)+($K$11-SUM($J$43:J189))*(($K$19/(IF(ROUND(YEAR(E190)/4,0)-YEAR(E190)/4=0,366,365)))*H190),2)","v":3031.34},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B190+1","v":149},null,{"$f":"D190+1","v":150},"2034-04-12",31,19,12,6820.04,{"$f":"IF(B191<$K$12,$L$14,-$J$41-SUM($J$43:J190))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J190))*(($K$19/(IF(ROUND(YEAR(E190)/4,0)-YEAR(E190)/4=0,366,365)))*G191)+($K$11-SUM($J$43:J190))*(($K$19/(IF(ROUND(YEAR(E191)/4,0)-YEAR(E191)/4=0,366,365)))*H191),2)","v":3320.04},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B191+1","v":150},null,{"$f":"D191+1","v":151},"2034-05-12",30,18,12,6678.02,{"$f":"IF(B192<$K$12,$L$14,-$J$41-SUM($J$43:J191))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J191))*(($K$19/(IF(ROUND(YEAR(E191)/4,0)-YEAR(E191)/4=0,366,365)))*G192)+($K$11-SUM($J$43:J191))*(($K$19/(IF(ROUND(YEAR(E192)/4,0)-YEAR(E192)/4=0,366,365)))*H192),2)","v":3178.02},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B192+1","v":151},null,{"$f":"D192+1","v":152},"2034-06-12",31,19,12,6747.87,{"$f":"IF(B193<$K$12,$L$14,-$J$41-SUM($J$43:J192))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J192))*(($K$19/(IF(ROUND(YEAR(E192)/4,0)-YEAR(E192)/4=0,366,365)))*G193)+($K$11-SUM($J$43:J192))*(($K$19/(IF(ROUND(YEAR(E193)/4,0)-YEAR(E193)/4=0,366,365)))*H193),2)","v":3247.87},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B193+1","v":152},null,{"$f":"D193+1","v":153},"2034-07-12",30,18,12,6608.17,{"$f":"IF(B194<$K$12,$L$14,-$J$41-SUM($J$43:J193))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J193))*(($K$19/(IF(ROUND(YEAR(E193)/4,0)-YEAR(E193)/4=0,366,365)))*G194)+($K$11-SUM($J$43:J193))*(($K$19/(IF(ROUND(YEAR(E194)/4,0)-YEAR(E194)/4=0,366,365)))*H194),2)","v":3108.17},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B194+1","v":153},null,{"$f":"D194+1","v":154},"2034-08-12",31,19,12,6675.6900000000005,{"$f":"IF(B195<$K$12,$L$14,-$J$41-SUM($J$43:J194))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J194))*(($K$19/(IF(ROUND(YEAR(E194)/4,0)-YEAR(E194)/4=0,366,365)))*G195)+($K$11-SUM($J$43:J194))*(($K$19/(IF(ROUND(YEAR(E195)/4,0)-YEAR(E195)/4=0,366,365)))*H195),2)","v":3175.69},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B195+1","v":154},null,{"$f":"D195+1","v":155},"2034-09-12",31,19,12,6639.6,{"$f":"IF(B196<$K$12,$L$14,-$J$41-SUM($J$43:J195))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J195))*(($K$19/(IF(ROUND(YEAR(E195)/4,0)-YEAR(E195)/4=0,366,365)))*G196)+($K$11-SUM($J$43:J195))*(($K$19/(IF(ROUND(YEAR(E196)/4,0)-YEAR(E196)/4=0,366,365)))*H196),2)","v":3139.6},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B196+1","v":155},null,{"$f":"D196+1","v":156},"2034-10-12",30,18,12,6503.4,{"$f":"IF(B197<$K$12,$L$14,-$J$41-SUM($J$43:J196))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J196))*(($K$19/(IF(ROUND(YEAR(E196)/4,0)-YEAR(E196)/4=0,366,365)))*G197)+($K$11-SUM($J$43:J196))*(($K$19/(IF(ROUND(YEAR(E197)/4,0)-YEAR(E197)/4=0,366,365)))*H197),2)","v":3003.4},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B197+1","v":156},null,{"$f":"D197+1","v":157},"2034-11-12",31,19,12,11952.43,{"$f":"IF(B198<$K$12,$L$14,-$J$41-SUM($J$43:J197))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J197))*(($K$19/(IF(ROUND(YEAR(E197)/4,0)-YEAR(E197)/4=0,366,365)))*G198)+($K$11-SUM($J$43:J197))*(($K$19/(IF(ROUND(YEAR(E198)/4,0)-YEAR(E198)/4=0,366,365)))*H198),2)","v":3067.43},0,null,null,{"$f":"IF(B198<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B198<$K$12,$K$9*$K$27,0)+(-SUM(J41:J197)*K28)","v":5385},null,"х","х"]
[1,{"$f":"B198+1","v":157},null,{"$f":"D198+1","v":158},"2034-12-12",30,18,12,6433.5599999999995,{"$f":"IF(B199<$K$12,$L$14,-$J$41-SUM($J$43:J198))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J198))*(($K$19/(IF(ROUND(YEAR(E198)/4,0)-YEAR(E198)/4=0,366,365)))*G199)+($K$11-SUM($J$43:J198))*(($K$19/(IF(ROUND(YEAR(E199)/4,0)-YEAR(E199)/4=0,366,365)))*H199),2)","v":2933.56},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B199+1","v":158},null,{"$f":"D199+1","v":159},"2035-01-12",31,19,12,6495.25,{"$f":"IF(B200<$K$12,$L$14,-$J$41-SUM($J$43:J199))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J199))*(($K$19/(IF(ROUND(YEAR(E199)/4,0)-YEAR(E199)/4=0,366,365)))*G200)+($K$11-SUM($J$43:J199))*(($K$19/(IF(ROUND(YEAR(E200)/4,0)-YEAR(E200)/4=0,366,365)))*H200),2)","v":2995.25},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B200+1","v":159},null,{"$f":"D200+1","v":160},"2035-02-12",31,19,12,6459.17,{"$f":"IF(B201<$K$12,$L$14,-$J$41-SUM($J$43:J200))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J200))*(($K$19/(IF(ROUND(YEAR(E200)/4,0)-YEAR(E200)/4=0,366,365)))*G201)+($K$11-SUM($J$43:J200))*(($K$19/(IF(ROUND(YEAR(E201)/4,0)-YEAR(E201)/4=0,366,365)))*H201),2)","v":2959.17},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B201+1","v":160},null,{"$f":"D201+1","v":161},"2035-03-12",28,16,12,6140.2,{"$f":"IF(B202<$K$12,$L$14,-$J$41-SUM($J$43:J201))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J201))*(($K$19/(IF(ROUND(YEAR(E201)/4,0)-YEAR(E201)/4=0,366,365)))*G202)+($K$11-SUM($J$43:J201))*(($K$19/(IF(ROUND(YEAR(E202)/4,0)-YEAR(E202)/4=0,366,365)))*H202),2)","v":2640.2},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B202+1","v":161},null,{"$f":"D202+1","v":162},"2035-04-12",31,19,12,6386.99,{"$f":"IF(B203<$K$12,$L$14,-$J$41-SUM($J$43:J202))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J202))*(($K$19/(IF(ROUND(YEAR(E202)/4,0)-YEAR(E202)/4=0,366,365)))*G203)+($K$11-SUM($J$43:J202))*(($K$19/(IF(ROUND(YEAR(E203)/4,0)-YEAR(E203)/4=0,366,365)))*H203),2)","v":2886.99},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B203+1","v":162},null,{"$f":"D203+1","v":163},"2035-05-12",30,18,12,6258.9400000000005,{"$f":"IF(B204<$K$12,$L$14,-$J$41-SUM($J$43:J203))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J203))*(($K$19/(IF(ROUND(YEAR(E203)/4,0)-YEAR(E203)/4=0,366,365)))*G204)+($K$11-SUM($J$43:J203))*(($K$19/(IF(ROUND(YEAR(E204)/4,0)-YEAR(E204)/4=0,366,365)))*H204),2)","v":2758.94},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B204+1","v":163},null,{"$f":"D204+1","v":164},"2035-06-12",31,19,12,6314.82,{"$f":"IF(B205<$K$12,$L$14,-$J$41-SUM($J$43:J204))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J204))*(($K$19/(IF(ROUND(YEAR(E204)/4,0)-YEAR(E204)/4=0,366,365)))*G205)+($K$11-SUM($J$43:J204))*(($K$19/(IF(ROUND(YEAR(E205)/4,0)-YEAR(E205)/4=0,366,365)))*H205),2)","v":2814.82},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B205+1","v":164},null,{"$f":"D205+1","v":165},"2035-07-12",30,18,12,6189.09,{"$f":"IF(B206<$K$12,$L$14,-$J$41-SUM($J$43:J205))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J205))*(($K$19/(IF(ROUND(YEAR(E205)/4,0)-YEAR(E205)/4=0,366,365)))*G206)+($K$11-SUM($J$43:J205))*(($K$19/(IF(ROUND(YEAR(E206)/4,0)-YEAR(E206)/4=0,366,365)))*H206),2)","v":2689.09},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B206+1","v":165},null,{"$f":"D206+1","v":166},"2035-08-12",31,19,12,6242.6399999999994,{"$f":"IF(B207<$K$12,$L$14,-$J$41-SUM($J$43:J206))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J206))*(($K$19/(IF(ROUND(YEAR(E206)/4,0)-YEAR(E206)/4=0,366,365)))*G207)+($K$11-SUM($J$43:J206))*(($K$19/(IF(ROUND(YEAR(E207)/4,0)-YEAR(E207)/4=0,366,365)))*H207),2)","v":2742.64},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B207+1","v":166},null,{"$f":"D207+1","v":167},"2035-09-12",31,19,12,6206.55,{"$f":"IF(B208<$K$12,$L$14,-$J$41-SUM($J$43:J207))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J207))*(($K$19/(IF(ROUND(YEAR(E207)/4,0)-YEAR(E207)/4=0,366,365)))*G208)+($K$11-SUM($J$43:J207))*(($K$19/(IF(ROUND(YEAR(E208)/4,0)-YEAR(E208)/4=0,366,365)))*H208),2)","v":2706.55},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B208+1","v":167},null,{"$f":"D208+1","v":168},"2035-10-12",30,18,12,6084.32,{"$f":"IF(B209<$K$12,$L$14,-$J$41-SUM($J$43:J208))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J208))*(($K$19/(IF(ROUND(YEAR(E208)/4,0)-YEAR(E208)/4=0,366,365)))*G209)+($K$11-SUM($J$43:J208))*(($K$19/(IF(ROUND(YEAR(E209)/4,0)-YEAR(E209)/4=0,366,365)))*H209),2)","v":2584.3200000000002},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B209+1","v":168},null,{"$f":"D209+1","v":169},"2035-11-12",{"$f":"IF(A210=1,E210-E209,0)","v":31},{"$f":"EOMONTH(E209,0)-E209","v":19},{"$f":"E210-EOMONTH(E209,0)","v":12},{"$f":"SUM(J210:U210)","v":11267.380000000001},{"$f":"IF(B210<$K$12,$L$14,-$J$41-SUM($J$43:J209))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J209))*(($K$19/(IF(ROUND(YEAR(E209)/4,0)-YEAR(E209)/4=0,366,365)))*G210)+($K$11-SUM($J$43:J209))*(($K$19/(IF(ROUND(YEAR(E210)/4,0)-YEAR(E210)/4=0,366,365)))*H210),2)","v":2634.38},0,null,null,{"$f":"IF(B210<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B210<$K$12,$K$9*$K$27,0)+(-SUM(J41:J209)*K28)","v":5133},null,"х","х"]
[1,{"$f":"B210+1","v":169},null,{"$f":"D210+1","v":170},"2035-12-12",30,18,12,6014.48,{"$f":"IF(B211<$K$12,$L$14,-$J$41-SUM($J$43:J210))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J210))*(($K$19/(IF(ROUND(YEAR(E210)/4,0)-YEAR(E210)/4=0,366,365)))*G211)+($K$11-SUM($J$43:J210))*(($K$19/(IF(ROUND(YEAR(E211)/4,0)-YEAR(E211)/4=0,366,365)))*H211),2)","v":2514.48},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B211+1","v":170},null,{"$f":"D211+1","v":171},"2036-01-12",31,19,12,6059.5,{"$f":"IF(B212<$K$12,$L$14,-$J$41-SUM($J$43:J211))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J211))*(($K$19/(IF(ROUND(YEAR(E211)/4,0)-YEAR(E211)/4=0,366,365)))*G212)+($K$11-SUM($J$43:J211))*(($K$19/(IF(ROUND(YEAR(E212)/4,0)-YEAR(E212)/4=0,366,365)))*H212),2)","v":2559.5},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B212+1","v":171},null,{"$f":"D212+1","v":172},"2036-02-12",31,19,12,6019.2199999999993,{"$f":"IF(B213<$K$12,$L$14,-$J$41-SUM($J$43:J212))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J212))*(($K$19/(IF(ROUND(YEAR(E212)/4,0)-YEAR(E212)/4=0,366,365)))*G213)+($K$11-SUM($J$43:J212))*(($K$19/(IF(ROUND(YEAR(E213)/4,0)-YEAR(E213)/4=0,366,365)))*H213),2)","v":2519.2199999999998},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B213+1","v":172},null,{"$f":"D213+1","v":173},"2036-03-12",29,17,12,5823.02,{"$f":"IF(B214<$K$12,$L$14,-$J$41-SUM($J$43:J213))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J213))*(($K$19/(IF(ROUND(YEAR(E213)/4,0)-YEAR(E213)/4=0,366,365)))*G214)+($K$11-SUM($J$43:J213))*(($K$19/(IF(ROUND(YEAR(E214)/4,0)-YEAR(E214)/4=0,366,365)))*H214),2)","v":2323.02},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B214+1","v":173},null,{"$f":"D214+1","v":174},"2036-04-12",31,19,12,5947.24,{"$f":"IF(B215<$K$12,$L$14,-$J$41-SUM($J$43:J214))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J214))*(($K$19/(IF(ROUND(YEAR(E214)/4,0)-YEAR(E214)/4=0,366,365)))*G215)+($K$11-SUM($J$43:J214))*(($K$19/(IF(ROUND(YEAR(E215)/4,0)-YEAR(E215)/4=0,366,365)))*H215),2)","v":2447.2399999999998},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B215+1","v":174},null,{"$f":"D215+1","v":175},"2036-05-12",30,18,12,5833.4699999999993,{"$f":"IF(B216<$K$12,$L$14,-$J$41-SUM($J$43:J215))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J215))*(($K$19/(IF(ROUND(YEAR(E215)/4,0)-YEAR(E215)/4=0,366,365)))*G216)+($K$11-SUM($J$43:J215))*(($K$19/(IF(ROUND(YEAR(E216)/4,0)-YEAR(E216)/4=0,366,365)))*H216),2)","v":2333.4699999999998},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B216+1","v":175},null,{"$f":"D216+1","v":176},"2036-06-12",31,19,12,5875.26,{"$f":"IF(B217<$K$12,$L$14,-$J$41-SUM($J$43:J216))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J216))*(($K$19/(IF(ROUND(YEAR(E216)/4,0)-YEAR(E216)/4=0,366,365)))*G217)+($K$11-SUM($J$43:J216))*(($K$19/(IF(ROUND(YEAR(E217)/4,0)-YEAR(E217)/4=0,366,365)))*H217),2)","v":2375.2600000000002},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B217+1","v":176},null,{"$f":"D217+1","v":177},"2036-07-12",30,18,12,5763.8099999999995,{"$f":"IF(B218<$K$12,$L$14,-$J$41-SUM($J$43:J217))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J217))*(($K$19/(IF(ROUND(YEAR(E217)/4,0)-YEAR(E217)/4=0,366,365)))*G218)+($K$11-SUM($J$43:J217))*(($K$19/(IF(ROUND(YEAR(E218)/4,0)-YEAR(E218)/4=0,366,365)))*H218),2)","v":2263.81},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B218+1","v":177},null,{"$f":"D218+1","v":178},"2036-08-12",31,19,12,5803.2800000000007,{"$f":"IF(B219<$K$12,$L$14,-$J$41-SUM($J$43:J218))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J218))*(($K$19/(IF(ROUND(YEAR(E218)/4,0)-YEAR(E218)/4=0,366,365)))*G219)+($K$11-SUM($J$43:J218))*(($K$19/(IF(ROUND(YEAR(E219)/4,0)-YEAR(E219)/4=0,366,365)))*H219),2)","v":2303.2800000000002},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B219+1","v":178},null,{"$f":"D219+1","v":179},"2036-09-12",31,19,12,5767.29,{"$f":"IF(B220<$K$12,$L$14,-$J$41-SUM($J$43:J219))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J219))*(($K$19/(IF(ROUND(YEAR(E219)/4,0)-YEAR(E219)/4=0,366,365)))*G220)+($K$11-SUM($J$43:J219))*(($K$19/(IF(ROUND(YEAR(E220)/4,0)-YEAR(E220)/4=0,366,365)))*H220),2)","v":2267.29},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B220+1","v":179},null,{"$f":"D220+1","v":180},"2036-10-12",30,18,12,5659.33,{"$f":"IF(B221<$K$12,$L$14,-$J$41-SUM($J$43:J220))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J220))*(($K$19/(IF(ROUND(YEAR(E220)/4,0)-YEAR(E220)/4=0,366,365)))*G221)+($K$11-SUM($J$43:J220))*(($K$19/(IF(ROUND(YEAR(E221)/4,0)-YEAR(E221)/4=0,366,365)))*H221),2)","v":2159.33},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B221+1","v":180},null,{"$f":"D221+1","v":181},"2036-11-12",31,19,12,10576.32,{"$f":"IF(B222<$K$12,$L$14,-$J$41-SUM($J$43:J221))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J221))*(($K$19/(IF(ROUND(YEAR(E221)/4,0)-YEAR(E221)/4=0,366,365)))*G222)+($K$11-SUM($J$43:J221))*(($K$19/(IF(ROUND(YEAR(E222)/4,0)-YEAR(E222)/4=0,366,365)))*H222),2)","v":2195.3200000000002},0,null,null,{"$f":"IF(B222<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B222<$K$12,$K$9*$K$27,0)+(-SUM(J41:J221)*K28)","v":4881},null,"х","х"]
[1,{"$f":"B222+1","v":181},null,{"$f":"D222+1","v":182},"2036-12-12",30,18,12,5589.67,{"$f":"IF(B223<$K$12,$L$14,-$J$41-SUM($J$43:J222))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J222))*(($K$19/(IF(ROUND(YEAR(E222)/4,0)-YEAR(E222)/4=0,366,365)))*G223)+($K$11-SUM($J$43:J222))*(($K$19/(IF(ROUND(YEAR(E223)/4,0)-YEAR(E223)/4=0,366,365)))*H223),2)","v":2089.67},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B223+1","v":182},null,{"$f":"D223+1","v":183},"2037-01-12",31,19,12,5625.59,{"$f":"IF(B224<$K$12,$L$14,-$J$41-SUM($J$43:J223))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J223))*(($K$19/(IF(ROUND(YEAR(E223)/4,0)-YEAR(E223)/4=0,366,365)))*G224)+($K$11-SUM($J$43:J223))*(($K$19/(IF(ROUND(YEAR(E224)/4,0)-YEAR(E224)/4=0,366,365)))*H224),2)","v":2125.59},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B224+1","v":183},null,{"$f":"D224+1","v":184},"2037-02-12",31,19,12,5593.07,{"$f":"IF(B225<$K$12,$L$14,-$J$41-SUM($J$43:J224))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J224))*(($K$19/(IF(ROUND(YEAR(E224)/4,0)-YEAR(E224)/4=0,366,365)))*G225)+($K$11-SUM($J$43:J224))*(($K$19/(IF(ROUND(YEAR(E225)/4,0)-YEAR(E225)/4=0,366,365)))*H225),2)","v":2093.0700000000002},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B225+1","v":184},null,{"$f":"D225+1","v":185},"2037-03-12",28,16,12,5357.92,{"$f":"IF(B226<$K$12,$L$14,-$J$41-SUM($J$43:J225))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J225))*(($K$19/(IF(ROUND(YEAR(E225)/4,0)-YEAR(E225)/4=0,366,365)))*G226)+($K$11-SUM($J$43:J225))*(($K$19/(IF(ROUND(YEAR(E226)/4,0)-YEAR(E226)/4=0,366,365)))*H226),2)","v":1857.92},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B226+1","v":185},null,{"$f":"D226+1","v":186},"2037-04-12",31,19,12,5520.89,{"$f":"IF(B227<$K$12,$L$14,-$J$41-SUM($J$43:J226))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J226))*(($K$19/(IF(ROUND(YEAR(E226)/4,0)-YEAR(E226)/4=0,366,365)))*G227)+($K$11-SUM($J$43:J226))*(($K$19/(IF(ROUND(YEAR(E227)/4,0)-YEAR(E227)/4=0,366,365)))*H227),2)","v":2020.89},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B227+1","v":186},null,{"$f":"D227+1","v":187},"2037-05-12",30,18,12,5420.78,{"$f":"IF(B228<$K$12,$L$14,-$J$41-SUM($J$43:J227))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J227))*(($K$19/(IF(ROUND(YEAR(E227)/4,0)-YEAR(E227)/4=0,366,365)))*G228)+($K$11-SUM($J$43:J227))*(($K$19/(IF(ROUND(YEAR(E228)/4,0)-YEAR(E228)/4=0,366,365)))*H228),2)","v":1920.78},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B228+1","v":187},null,{"$f":"D228+1","v":188},"2037-06-12",31,19,12,5448.72,{"$f":"IF(B229<$K$12,$L$14,-$J$41-SUM($J$43:J228))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J228))*(($K$19/(IF(ROUND(YEAR(E228)/4,0)-YEAR(E228)/4=0,366,365)))*G229)+($K$11-SUM($J$43:J228))*(($K$19/(IF(ROUND(YEAR(E229)/4,0)-YEAR(E229)/4=0,366,365)))*H229),2)","v":1948.72},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B229+1","v":188},null,{"$f":"D229+1","v":189},"2037-07-12",30,18,12,5350.93,{"$f":"IF(B230<$K$12,$L$14,-$J$41-SUM($J$43:J229))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J229))*(($K$19/(IF(ROUND(YEAR(E229)/4,0)-YEAR(E229)/4=0,366,365)))*G230)+($K$11-SUM($J$43:J229))*(($K$19/(IF(ROUND(YEAR(E230)/4,0)-YEAR(E230)/4=0,366,365)))*H230),2)","v":1850.93},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B230+1","v":189},null,{"$f":"D230+1","v":190},"2037-08-12",31,19,12,5376.54,{"$f":"IF(B231<$K$12,$L$14,-$J$41-SUM($J$43:J230))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J230))*(($K$19/(IF(ROUND(YEAR(E230)/4,0)-YEAR(E230)/4=0,366,365)))*G231)+($K$11-SUM($J$43:J230))*(($K$19/(IF(ROUND(YEAR(E231)/4,0)-YEAR(E231)/4=0,366,365)))*H231),2)","v":1876.54},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B231+1","v":190},null,{"$f":"D231+1","v":191},"2037-09-12",31,19,12,5340.46,{"$f":"IF(B232<$K$12,$L$14,-$J$41-SUM($J$43:J231))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J231))*(($K$19/(IF(ROUND(YEAR(E231)/4,0)-YEAR(E231)/4=0,366,365)))*G232)+($K$11-SUM($J$43:J231))*(($K$19/(IF(ROUND(YEAR(E232)/4,0)-YEAR(E232)/4=0,366,365)))*H232),2)","v":1840.46},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B232+1","v":191},null,{"$f":"D232+1","v":192},"2037-10-12",30,18,12,5246.16,{"$f":"IF(B233<$K$12,$L$14,-$J$41-SUM($J$43:J232))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J232))*(($K$19/(IF(ROUND(YEAR(E232)/4,0)-YEAR(E232)/4=0,366,365)))*G233)+($K$11-SUM($J$43:J232))*(($K$19/(IF(ROUND(YEAR(E233)/4,0)-YEAR(E233)/4=0,366,365)))*H233),2)","v":1746.16},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B233+1","v":192},null,{"$f":"D233+1","v":193},"2037-11-12",31,19,12,9897.2799999999988,{"$f":"IF(B234<$K$12,$L$14,-$J$41-SUM($J$43:J233))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J233))*(($K$19/(IF(ROUND(YEAR(E233)/4,0)-YEAR(E233)/4=0,366,365)))*G234)+($K$11-SUM($J$43:J233))*(($K$19/(IF(ROUND(YEAR(E234)/4,0)-YEAR(E234)/4=0,366,365)))*H234),2)","v":1768.28},0,null,null,{"$f":"IF(B234<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B234<$K$12,$K$9*$K$27,0)+(-SUM(J41:J233)*K28)","v":4629},null,"х","х"]
[{"$f":"IF(B235<=$K$12,1,0)","v":1},{"$f":"B234+1","v":193},null,{"$f":"D234+1","v":194},"2037-12-12",30,18,12,5176.32,{"$f":"IF(B235<$K$12,$L$14,-$J$41-SUM($J$43:J234))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J234))*(($K$19/(IF(ROUND(YEAR(E234)/4,0)-YEAR(E234)/4=0,366,365)))*G235)+($K$11-SUM($J$43:J234))*(($K$19/(IF(ROUND(YEAR(E235)/4,0)-YEAR(E235)/4=0,366,365)))*H235),2)","v":1676.32},{"$f":"IF(A235=1,IF(AND(YEAR($K$13)=YEAR(EDATE(E234,1)),MONTH($K$13)=MONTH(EDATE(E234,1))),$O$23-$O$46,$O$23),0)","v":0},null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B235+1","v":194},null,{"$f":"D235+1","v":195},"2038-01-12",31,19,12,5196.1099999999997,{"$f":"IF(B236<$K$12,$L$14,-$J$41-SUM($J$43:J235))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J235))*(($K$19/(IF(ROUND(YEAR(E235)/4,0)-YEAR(E235)/4=0,366,365)))*G236)+($K$11-SUM($J$43:J235))*(($K$19/(IF(ROUND(YEAR(E236)/4,0)-YEAR(E236)/4=0,366,365)))*H236),2)","v":1696.11},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B236+1","v":195},null,{"$f":"D236+1","v":196},"2038-02-12",31,19,12,5160.0200000000004,{"$f":"IF(B237<$K$12,$L$14,-$J$41-SUM($J$43:J236))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J236))*(($K$19/(IF(ROUND(YEAR(E236)/4,0)-YEAR(E236)/4=0,366,365)))*G237)+($K$11-SUM($J$43:J236))*(($K$19/(IF(ROUND(YEAR(E237)/4,0)-YEAR(E237)/4=0,366,365)))*H237),2)","v":1660.02},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B237+1","v":196},null,{"$f":"D237+1","v":197},"2038-03-12",28,16,12,4966.78,{"$f":"IF(B238<$K$12,$L$14,-$J$41-SUM($J$43:J237))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J237))*(($K$19/(IF(ROUND(YEAR(E237)/4,0)-YEAR(E237)/4=0,366,365)))*G238)+($K$11-SUM($J$43:J237))*(($K$19/(IF(ROUND(YEAR(E238)/4,0)-YEAR(E238)/4=0,366,365)))*H238),2)","v":1466.78},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B238+1","v":197},null,{"$f":"D238+1","v":198},"2038-04-12",31,19,12,5087.8500000000004,{"$f":"IF(B239<$K$12,$L$14,-$J$41-SUM($J$43:J238))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J238))*(($K$19/(IF(ROUND(YEAR(E238)/4,0)-YEAR(E238)/4=0,366,365)))*G239)+($K$11-SUM($J$43:J238))*(($K$19/(IF(ROUND(YEAR(E239)/4,0)-YEAR(E239)/4=0,366,365)))*H239),2)","v":1587.85},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B239+1","v":198},null,{"$f":"D239+1","v":199},"2038-05-12",30,18,12,5001.7,{"$f":"IF(B240<$K$12,$L$14,-$J$41-SUM($J$43:J239))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J239))*(($K$19/(IF(ROUND(YEAR(E239)/4,0)-YEAR(E239)/4=0,366,365)))*G240)+($K$11-SUM($J$43:J239))*(($K$19/(IF(ROUND(YEAR(E240)/4,0)-YEAR(E240)/4=0,366,365)))*H240),2)","v":1501.7},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B240+1","v":199},null,{"$f":"D240+1","v":200},"2038-06-12",31,19,12,5015.67,{"$f":"IF(B241<$K$12,$L$14,-$J$41-SUM($J$43:J240))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J240))*(($K$19/(IF(ROUND(YEAR(E240)/4,0)-YEAR(E240)/4=0,366,365)))*G241)+($K$11-SUM($J$43:J240))*(($K$19/(IF(ROUND(YEAR(E241)/4,0)-YEAR(E241)/4=0,366,365)))*H241),2)","v":1515.67},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B241+1","v":200},null,{"$f":"D241+1","v":201},"2038-07-12",30,18,12,4931.8500000000004,{"$f":"IF(B242<$K$12,$L$14,-$J$41-SUM($J$43:J241))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J241))*(($K$19/(IF(ROUND(YEAR(E241)/4,0)-YEAR(E241)/4=0,366,365)))*G242)+($K$11-SUM($J$43:J241))*(($K$19/(IF(ROUND(YEAR(E242)/4,0)-YEAR(E242)/4=0,366,365)))*H242),2)","v":1431.85},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B242+1","v":201},null,{"$f":"D242+1","v":202},"2038-08-12",31,19,12,4943.5,{"$f":"IF(B243<$K$12,$L$14,-$J$41-SUM($J$43:J242))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J242))*(($K$19/(IF(ROUND(YEAR(E242)/4,0)-YEAR(E242)/4=0,366,365)))*G243)+($K$11-SUM($J$43:J242))*(($K$19/(IF(ROUND(YEAR(E243)/4,0)-YEAR(E243)/4=0,366,365)))*H243),2)","v":1443.5},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B243+1","v":202},null,{"$f":"D243+1","v":203},"2038-09-12",31,19,12,4907.41,{"$f":"IF(B244<$K$12,$L$14,-$J$41-SUM($J$43:J243))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J243))*(($K$19/(IF(ROUND(YEAR(E243)/4,0)-YEAR(E243)/4=0,366,365)))*G244)+($K$11-SUM($J$43:J243))*(($K$19/(IF(ROUND(YEAR(E244)/4,0)-YEAR(E244)/4=0,366,365)))*H244),2)","v":1407.41},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B244+1","v":203},null,{"$f":"D244+1","v":204},"2038-10-12",30,18,12,4827.08,{"$f":"IF(B245<$K$12,$L$14,-$J$41-SUM($J$43:J244))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J244))*(($K$19/(IF(ROUND(YEAR(E244)/4,0)-YEAR(E244)/4=0,366,365)))*G245)+($K$11-SUM($J$43:J244))*(($K$19/(IF(ROUND(YEAR(E245)/4,0)-YEAR(E245)/4=0,366,365)))*H245),2)","v":1327.08},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B245+1","v":204},null,{"$f":"D245+1","v":205},"2038-11-12",31,19,12,9212.23,{"$f":"IF(B246<$K$12,$L$14,-$J$41-SUM($J$43:J245))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J245))*(($K$19/(IF(ROUND(YEAR(E245)/4,0)-YEAR(E245)/4=0,366,365)))*G246)+($K$11-SUM($J$43:J245))*(($K$19/(IF(ROUND(YEAR(E246)/4,0)-YEAR(E246)/4=0,366,365)))*H246),2)","v":1335.23},0,null,null,{"$f":"IF(B246<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B246<$K$12,$K$9*$K$27,0)+(-SUM(J41:J245)*K28)","v":4377},null,"х","х"]
[1,{"$f":"B246+1","v":205},null,{"$f":"D246+1","v":206},"2038-12-12",30,18,12,4757.24,{"$f":"IF(B247<$K$12,$L$14,-$J$41-SUM($J$43:J246))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J246))*(($K$19/(IF(ROUND(YEAR(E246)/4,0)-YEAR(E246)/4=0,366,365)))*G247)+($K$11-SUM($J$43:J246))*(($K$19/(IF(ROUND(YEAR(E247)/4,0)-YEAR(E247)/4=0,366,365)))*H247),2)","v":1257.24},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B247+1","v":206},null,{"$f":"D247+1","v":207},"2039-01-12",31,19,12,4763.0599999999995,{"$f":"IF(B248<$K$12,$L$14,-$J$41-SUM($J$43:J247))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J247))*(($K$19/(IF(ROUND(YEAR(E247)/4,0)-YEAR(E247)/4=0,366,365)))*G248)+($K$11-SUM($J$43:J247))*(($K$19/(IF(ROUND(YEAR(E248)/4,0)-YEAR(E248)/4=0,366,365)))*H248),2)","v":1263.06},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B248+1","v":207},null,{"$f":"D248+1","v":208},"2039-02-12",31,19,12,4726.97,{"$f":"IF(B249<$K$12,$L$14,-$J$41-SUM($J$43:J248))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J248))*(($K$19/(IF(ROUND(YEAR(E248)/4,0)-YEAR(E248)/4=0,366,365)))*G249)+($K$11-SUM($J$43:J248))*(($K$19/(IF(ROUND(YEAR(E249)/4,0)-YEAR(E249)/4=0,366,365)))*H249),2)","v":1226.97},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B249+1","v":208},null,{"$f":"D249+1","v":209},"2039-03-12",28,16,12,4575.6400000000003,{"$f":"IF(B250<$K$12,$L$14,-$J$41-SUM($J$43:J249))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J249))*(($K$19/(IF(ROUND(YEAR(E249)/4,0)-YEAR(E249)/4=0,366,365)))*G250)+($K$11-SUM($J$43:J249))*(($K$19/(IF(ROUND(YEAR(E250)/4,0)-YEAR(E250)/4=0,366,365)))*H250),2)","v":1075.6400000000001},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B250+1","v":209},null,{"$f":"D250+1","v":210},"2039-04-12",31,19,12,4654.8,{"$f":"IF(B251<$K$12,$L$14,-$J$41-SUM($J$43:J250))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J250))*(($K$19/(IF(ROUND(YEAR(E250)/4,0)-YEAR(E250)/4=0,366,365)))*G251)+($K$11-SUM($J$43:J250))*(($K$19/(IF(ROUND(YEAR(E251)/4,0)-YEAR(E251)/4=0,366,365)))*H251),2)","v":1154.8},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B251+1","v":210},null,{"$f":"D251+1","v":211},"2039-05-12",30,18,12,4582.62,{"$f":"IF(B252<$K$12,$L$14,-$J$41-SUM($J$43:J251))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J251))*(($K$19/(IF(ROUND(YEAR(E251)/4,0)-YEAR(E251)/4=0,366,365)))*G252)+($K$11-SUM($J$43:J251))*(($K$19/(IF(ROUND(YEAR(E252)/4,0)-YEAR(E252)/4=0,366,365)))*H252),2)","v":1082.6199999999999},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B252+1","v":211},null,{"$f":"D252+1","v":212},"2039-06-12",31,19,12,4582.62,{"$f":"IF(B253<$K$12,$L$14,-$J$41-SUM($J$43:J252))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J252))*(($K$19/(IF(ROUND(YEAR(E252)/4,0)-YEAR(E252)/4=0,366,365)))*G253)+($K$11-SUM($J$43:J252))*(($K$19/(IF(ROUND(YEAR(E253)/4,0)-YEAR(E253)/4=0,366,365)))*H253),2)","v":1082.6199999999999},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B253+1","v":212},null,{"$f":"D253+1","v":213},"2039-07-12",30,18,12,4512.78,{"$f":"IF(B254<$K$12,$L$14,-$J$41-SUM($J$43:J253))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J253))*(($K$19/(IF(ROUND(YEAR(E253)/4,0)-YEAR(E253)/4=0,366,365)))*G254)+($K$11-SUM($J$43:J253))*(($K$19/(IF(ROUND(YEAR(E254)/4,0)-YEAR(E254)/4=0,366,365)))*H254),2)","v":1012.78},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B254+1","v":213},null,{"$f":"D254+1","v":214},"2039-08-12",31,19,12,4510.45,{"$f":"IF(B255<$K$12,$L$14,-$J$41-SUM($J$43:J254))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J254))*(($K$19/(IF(ROUND(YEAR(E254)/4,0)-YEAR(E254)/4=0,366,365)))*G255)+($K$11-SUM($J$43:J254))*(($K$19/(IF(ROUND(YEAR(E255)/4,0)-YEAR(E255)/4=0,366,365)))*H255),2)","v":1010.45},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B255+1","v":214},null,{"$f":"D255+1","v":215},"2039-09-12",31,19,12,4474.3599999999997,{"$f":"IF(B256<$K$12,$L$14,-$J$41-SUM($J$43:J255))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J255))*(($K$19/(IF(ROUND(YEAR(E255)/4,0)-YEAR(E255)/4=0,366,365)))*G256)+($K$11-SUM($J$43:J255))*(($K$19/(IF(ROUND(YEAR(E256)/4,0)-YEAR(E256)/4=0,366,365)))*H256),2)","v":974.36},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B256+1","v":215},null,{"$f":"D256+1","v":216},"2039-10-12",30,18,12,4408.01,{"$f":"IF(B257<$K$12,$L$14,-$J$41-SUM($J$43:J256))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J256))*(($K$19/(IF(ROUND(YEAR(E256)/4,0)-YEAR(E256)/4=0,366,365)))*G257)+($K$11-SUM($J$43:J256))*(($K$19/(IF(ROUND(YEAR(E257)/4,0)-YEAR(E257)/4=0,366,365)))*H257),2)","v":908.01},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B257+1","v":216},null,{"$f":"D257+1","v":217},"2039-11-12",31,19,12,8527.18,{"$f":"IF(B258<$K$12,$L$14,-$J$41-SUM($J$43:J257))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J257))*(($K$19/(IF(ROUND(YEAR(E257)/4,0)-YEAR(E257)/4=0,366,365)))*G258)+($K$11-SUM($J$43:J257))*(($K$19/(IF(ROUND(YEAR(E258)/4,0)-YEAR(E258)/4=0,366,365)))*H258),2)","v":902.18},0,null,null,{"$f":"IF(B258<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B258<$K$12,$K$9*$K$27,0)+(-SUM(J41:J257)*K28)","v":4125},null,"х","х"]
[1,{"$f":"B258+1","v":217},null,{"$f":"D258+1","v":218},"2039-12-12",30,18,12,4338.16,{"$f":"IF(B259<$K$12,$L$14,-$J$41-SUM($J$43:J258))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J258))*(($K$19/(IF(ROUND(YEAR(E258)/4,0)-YEAR(E258)/4=0,366,365)))*G259)+($K$11-SUM($J$43:J258))*(($K$19/(IF(ROUND(YEAR(E259)/4,0)-YEAR(E259)/4=0,366,365)))*H259),2)","v":838.16},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B259+1","v":218},null,{"$f":"D259+1","v":219},"2040-01-12",31,19,12,4329.13,{"$f":"IF(B260<$K$12,$L$14,-$J$41-SUM($J$43:J259))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J259))*(($K$19/(IF(ROUND(YEAR(E259)/4,0)-YEAR(E259)/4=0,366,365)))*G260)+($K$11-SUM($J$43:J259))*(($K$19/(IF(ROUND(YEAR(E260)/4,0)-YEAR(E260)/4=0,366,365)))*H260),2)","v":829.13},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B260+1","v":219},null,{"$f":"D260+1","v":220},"2040-02-12",31,19,12,4291.75,{"$f":"IF(B261<$K$12,$L$14,-$J$41-SUM($J$43:J260))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J260))*(($K$19/(IF(ROUND(YEAR(E260)/4,0)-YEAR(E260)/4=0,366,365)))*G261)+($K$11-SUM($J$43:J260))*(($K$19/(IF(ROUND(YEAR(E261)/4,0)-YEAR(E261)/4=0,366,365)))*H261),2)","v":791.75},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B261+1","v":220},null,{"$f":"D261+1","v":221},"2040-03-12",29,17,12,4207.01,{"$f":"IF(B262<$K$12,$L$14,-$J$41-SUM($J$43:J261))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J261))*(($K$19/(IF(ROUND(YEAR(E261)/4,0)-YEAR(E261)/4=0,366,365)))*G262)+($K$11-SUM($J$43:J261))*(($K$19/(IF(ROUND(YEAR(E262)/4,0)-YEAR(E262)/4=0,366,365)))*H262),2)","v":707.01},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B262+1","v":221},null,{"$f":"D262+1","v":222},"2040-04-12",31,19,12,4219.78,{"$f":"IF(B263<$K$12,$L$14,-$J$41-SUM($J$43:J262))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J262))*(($K$19/(IF(ROUND(YEAR(E262)/4,0)-YEAR(E262)/4=0,366,365)))*G263)+($K$11-SUM($J$43:J262))*(($K$19/(IF(ROUND(YEAR(E263)/4,0)-YEAR(E263)/4=0,366,365)))*H263),2)","v":719.78},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B263+1","v":222},null,{"$f":"D263+1","v":223},"2040-05-12",30,18,12,4161.7299999999996,{"$f":"IF(B264<$K$12,$L$14,-$J$41-SUM($J$43:J263))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J263))*(($K$19/(IF(ROUND(YEAR(E263)/4,0)-YEAR(E263)/4=0,366,365)))*G264)+($K$11-SUM($J$43:J263))*(($K$19/(IF(ROUND(YEAR(E264)/4,0)-YEAR(E264)/4=0,366,365)))*H264),2)","v":661.73},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B264+1","v":223},null,{"$f":"D264+1","v":224},"2040-06-12",31,19,12,4147.8,{"$f":"IF(B265<$K$12,$L$14,-$J$41-SUM($J$43:J264))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J264))*(($K$19/(IF(ROUND(YEAR(E264)/4,0)-YEAR(E264)/4=0,366,365)))*G265)+($K$11-SUM($J$43:J264))*(($K$19/(IF(ROUND(YEAR(E265)/4,0)-YEAR(E265)/4=0,366,365)))*H265),2)","v":647.79999999999995},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B265+1","v":224},null,{"$f":"D265+1","v":225},"2040-07-12",30,18,12,4092.07,{"$f":"IF(B266<$K$12,$L$14,-$J$41-SUM($J$43:J265))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J265))*(($K$19/(IF(ROUND(YEAR(E265)/4,0)-YEAR(E265)/4=0,366,365)))*G266)+($K$11-SUM($J$43:J265))*(($K$19/(IF(ROUND(YEAR(E266)/4,0)-YEAR(E266)/4=0,366,365)))*H266),2)","v":592.07000000000005},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B266+1","v":225},null,{"$f":"D266+1","v":226},"2040-08-12",31,19,12,4075.82,{"$f":"IF(B267<$K$12,$L$14,-$J$41-SUM($J$43:J266))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J266))*(($K$19/(IF(ROUND(YEAR(E266)/4,0)-YEAR(E266)/4=0,366,365)))*G267)+($K$11-SUM($J$43:J266))*(($K$19/(IF(ROUND(YEAR(E267)/4,0)-YEAR(E267)/4=0,366,365)))*H267),2)","v":575.82000000000005},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B267+1","v":226},null,{"$f":"D267+1","v":227},"2040-09-12",31,19,12,4039.83,{"$f":"IF(B268<$K$12,$L$14,-$J$41-SUM($J$43:J267))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J267))*(($K$19/(IF(ROUND(YEAR(E267)/4,0)-YEAR(E267)/4=0,366,365)))*G268)+($K$11-SUM($J$43:J267))*(($K$19/(IF(ROUND(YEAR(E268)/4,0)-YEAR(E268)/4=0,366,365)))*H268),2)","v":539.83000000000004},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B268+1","v":227},null,{"$f":"D268+1","v":228},"2040-10-12",30,18,12,3987.59,{"$f":"IF(B269<$K$12,$L$14,-$J$41-SUM($J$43:J268))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J268))*(($K$19/(IF(ROUND(YEAR(E268)/4,0)-YEAR(E268)/4=0,366,365)))*G269)+($K$11-SUM($J$43:J268))*(($K$19/(IF(ROUND(YEAR(E269)/4,0)-YEAR(E269)/4=0,366,365)))*H269),2)","v":487.59},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B269+1","v":228},null,{"$f":"D269+1","v":229},"2040-11-12",31,19,12,7840.85,{"$f":"IF(B270<$K$12,$L$14,-$J$41-SUM($J$43:J269))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J269))*(($K$19/(IF(ROUND(YEAR(E269)/4,0)-YEAR(E269)/4=0,366,365)))*G270)+($K$11-SUM($J$43:J269))*(($K$19/(IF(ROUND(YEAR(E270)/4,0)-YEAR(E270)/4=0,366,365)))*H270),2)","v":467.85},0,null,null,{"$f":"IF(B270<$K$12,$K$11*$K$24,0)","v":0},null,null,null,null,{"$f":"IF(B270<$K$12,$K$9*$K$27,0)+(-SUM(J41:J269)*K28)","v":3873},null,"х","х"]
[1,{"$f":"B270+1","v":229},null,{"$f":"D270+1","v":230},"2040-12-12",30,18,12,3917.93,{"$f":"IF(B271<$K$12,$L$14,-$J$41-SUM($J$43:J270))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J270))*(($K$19/(IF(ROUND(YEAR(E270)/4,0)-YEAR(E270)/4=0,366,365)))*G271)+($K$11-SUM($J$43:J270))*(($K$19/(IF(ROUND(YEAR(E271)/4,0)-YEAR(E271)/4=0,366,365)))*H271),2)","v":417.93},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B271+1","v":230},null,{"$f":"D271+1","v":231},"2041-01-12",31,19,12,3896.3,{"$f":"IF(B272<$K$12,$L$14,-$J$41-SUM($J$43:J271))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J271))*(($K$19/(IF(ROUND(YEAR(E271)/4,0)-YEAR(E271)/4=0,366,365)))*G272)+($K$11-SUM($J$43:J271))*(($K$19/(IF(ROUND(YEAR(E272)/4,0)-YEAR(E272)/4=0,366,365)))*H272),2)","v":396.3},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B272+1","v":231},null,{"$f":"D272+1","v":232},"2041-02-12",31,19,12,3860.87,{"$f":"IF(B273<$K$12,$L$14,-$J$41-SUM($J$43:J272))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J272))*(($K$19/(IF(ROUND(YEAR(E272)/4,0)-YEAR(E272)/4=0,366,365)))*G273)+($K$11-SUM($J$43:J272))*(($K$19/(IF(ROUND(YEAR(E273)/4,0)-YEAR(E273)/4=0,366,365)))*H273),2)","v":360.87},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B273+1","v":232},null,{"$f":"D273+1","v":233},"2041-03-12",{"$f":"IF(A274=1,E274-E273,0)","v":28},{"$f":"EOMONTH(E273,0)-E273","v":16},{"$f":"E274-EOMONTH(E273,0)","v":12},{"$f":"SUM(J274:U274)","v":3793.36},{"$f":"IF(B274<$K$12,$L$14,-$J$41-SUM($J$43:J273))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J273))*(($K$19/(IF(ROUND(YEAR(E273)/4,0)-YEAR(E273)/4=0,366,365)))*G274)+($K$11-SUM($J$43:J273))*(($K$19/(IF(ROUND(YEAR(E274)/4,0)-YEAR(E274)/4=0,366,365)))*H274),2)","v":293.36},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B274+1","v":233},null,{"$f":"D274+1","v":234},"2041-04-12",31,19,12,3788.7,{"$f":"IF(B275<$K$12,$L$14,-$J$41-SUM($J$43:J274))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J274))*(($K$19/(IF(ROUND(YEAR(E274)/4,0)-YEAR(E274)/4=0,366,365)))*G275)+($K$11-SUM($J$43:J274))*(($K$19/(IF(ROUND(YEAR(E275)/4,0)-YEAR(E275)/4=0,366,365)))*H275),2)","v":288.7},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B275+1","v":234},null,{"$f":"D275+1","v":235},"2041-05-12",30,18,12,3744.46,{"$f":"IF(B276<$K$12,$L$14,-$J$41-SUM($J$43:J275))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J275))*(($K$19/(IF(ROUND(YEAR(E275)/4,0)-YEAR(E275)/4=0,366,365)))*G276)+($K$11-SUM($J$43:J275))*(($K$19/(IF(ROUND(YEAR(E276)/4,0)-YEAR(E276)/4=0,366,365)))*H276),2)","v":244.46},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B276+1","v":235},null,{"$f":"D276+1","v":236},"2041-06-12",31,19,12,3716.52,{"$f":"IF(B277<$K$12,$L$14,-$J$41-SUM($J$43:J276))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J276))*(($K$19/(IF(ROUND(YEAR(E276)/4,0)-YEAR(E276)/4=0,366,365)))*G277)+($K$11-SUM($J$43:J276))*(($K$19/(IF(ROUND(YEAR(E277)/4,0)-YEAR(E277)/4=0,366,365)))*H277),2)","v":216.52},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B277+1","v":236},null,{"$f":"D277+1","v":237},"2041-07-12",30,18,12,3674.62,{"$f":"IF(B278<$K$12,$L$14,-$J$41-SUM($J$43:J277))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J277))*(($K$19/(IF(ROUND(YEAR(E277)/4,0)-YEAR(E277)/4=0,366,365)))*G278)+($K$11-SUM($J$43:J277))*(($K$19/(IF(ROUND(YEAR(E278)/4,0)-YEAR(E278)/4=0,366,365)))*H278),2)","v":174.62},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B278+1","v":237},null,{"$f":"D278+1","v":238},"2041-08-12",31,19,12,3644.35,{"$f":"IF(B279<$K$12,$L$14,-$J$41-SUM($J$43:J278))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J278))*(($K$19/(IF(ROUND(YEAR(E278)/4,0)-YEAR(E278)/4=0,366,365)))*G279)+($K$11-SUM($J$43:J278))*(($K$19/(IF(ROUND(YEAR(E279)/4,0)-YEAR(E279)/4=0,366,365)))*H279),2)","v":144.35},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B279+1","v":238},null,{"$f":"D279+1","v":239},"2041-09-12",31,19,12,3608.26,{"$f":"IF(B280<$K$12,$L$14,-$J$41-SUM($J$43:J279))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J279))*(($K$19/(IF(ROUND(YEAR(E279)/4,0)-YEAR(E279)/4=0,366,365)))*G280)+($K$11-SUM($J$43:J279))*(($K$19/(IF(ROUND(YEAR(E280)/4,0)-YEAR(E280)/4=0,366,365)))*H280),2)","v":108.26},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B280+1","v":239},null,{"$f":"D280+1","v":240},"2041-10-12",30,18,12,3569.85,{"$f":"IF(B281<$K$12,$L$14,-$J$41-SUM($J$43:J280))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J280))*(($K$19/(IF(ROUND(YEAR(E280)/4,0)-YEAR(E280)/4=0,366,365)))*G281)+($K$11-SUM($J$43:J280))*(($K$19/(IF(ROUND(YEAR(E281)/4,0)-YEAR(E281)/4=0,366,365)))*H281),2)","v":69.849999999999994},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B281+1","v":240},null,{"$f":"D281+1","v":241},"2041-11-07",26,19,7,3530.27,{"$f":"IF(B282<$K$12,$L$14,-$J$41-SUM($J$43:J281))","v":3500},{"$f":"ROUND(($K$11-SUM($J$43:J281))*(($K$19/(IF(ROUND(YEAR(E281)/4,0)-YEAR(E281)/4=0,366,365)))*G282)+($K$11-SUM($J$43:J281))*(($K$19/(IF(ROUND(YEAR(E282)/4,0)-YEAR(E282)/4=0,366,365)))*H282),2)","v":30.27},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,null,null,"Усього","х",{"$f":"SUM(F43:F282)","v":7300},null,null,{"$f":"SUM(I43:I282)","v":1960699.5100000009},{"$f":"SUM(J43:J282)","v":840000},{"$f":"SUM(K43:K282)","v":1004020.5100000001},0,{"$f":"SUM(M41:M282)","v":0},5880,0,0,0,36300,{"$f":"SUM(S41:S282)","v":1000},{"$f":"SUM(T41:T282)","v":125319},0,{"$f":"XIRR(I41:I282,E41:E282)","v":0.15055249333381657},{"$f":"SUM(J283:U283)","v":2012519.5100000002}]
[1]
[1]
[1,null,null,"Загальні витрати за кредитом (проценти за користуваннґ кредитом, комісії та інші обов'язкові платежі за додаткові та супутні послуги кредитодавця,кредитного посередника (за наявності) та третії осіб, пов'язані з отриманням, обслуговуванням та поверненням кредиту), грн.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K283:U283)","v":1172519.5100000002}]
[1,null,null,"Орієнтовна загальна вартість кредиту для споживача за весь строк користування кредитом (у т.ч. тіло кредиту, відсотки, комісії та інші платежі), грн.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W283","v":2012519.5100000002}]
[1,null,null,"Сума платежу за розрахунковий період, грн.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I43","v":11025.48}]
[1,null,null,"Орієнтовна реальна річна процентна ставка, % річних",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V283","v":0.15055249333381657}]
[1]
[1,null,null,"Застереження: наведені обчислення орієнтовної реальної річної процентної ставки та орієнтовної загальної вартості кредиту для споживача є репрезентативними та базуються на обраних споживачем умовах кредитування, викладених вище, і на припущенні, що договір про споживчий кредит залишатиметься дійсним протягом погодженого строку, а кредитодавець і споживач виконають свої обов’язки на умовах та у строки, визначені в договорі. "]
[1,null,null,"Орієнтовна реальна річна процентна ставка обчислена на основі припущення, що процентна ставка та інші платежі за послуги кредитодавця залишатимуться незмінними та застосовуватимуться протягом строку дії договору про споживчий кредит. \nОрієнтовна реальна річна процентна ставка обчислена з використанням фінансової функції ЧИСТВНДОХ програмного продукту Microsoft Excel."]
[1,null,null,"Застереження: використання інших способів надання кредиту та/або зміна інших вищезазначених умов кредитування можуть мати наслідком застосування іншої орієнтовної реальної річної процентної ставки та орієнтовної загальної вартості кредиту для споживача."]
[1,null,null,"Застереження: вартість послуг нотаріуста та  страховика розраховуються виходячи із вартості предмету іпотеки."]