{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лизинг vs. Кредит"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лизинг vs. Кредит","index":0,"n_rows":263,"n_cols":11,"rows_kept":263,"cut":false,"hidden":false,"merged":[[0,2,0,9],[1,4,1,7],[2,2,2,5],[3,2,3,4],[8,2,8,4],[4,2,4,4],[5,2,5,4],[2,7,2,9],[3,8,3,9],[13,8,13,9],[14,8,14,9],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[10,8,10,9],[11,8,11,9],[12,8,12,9],[16,2,16,3],[8,7,8,8],[139,2,139,9],[140,2,140,3],[140,5,140,6],[9,2,9,9],[3,6,8,6],[14,6,14,7],[7,2,7,4],[7,7,7,8],[5,7,5,8],[4,7,4,8],[6,7,6,8],[16,5,16,6],[6,2,6,4],[15,2,15,9]]}
[null,null,"Калькулятор приобретения имущества в кредит и по договору лизинга для организации"]
[null,null,null,null,"© www.calculator24.ru"]
[null,null,"Исходные данные (заполнить информацию):",null,null,null,null,"Налоговые условия у компании:"]
["Общая",null,"Стоимость имущества с НДС",null,null,5000000,"Внесите в\nжелтые ячейки\nсвои данные.\nРасчет обновляется онлайн.","Общая","система налогообложения"]
["Упрощенная",0.15,"Сопутствующие расходы с НДС",null,null,100000,null,"Налог на прибыль:",null,0.2]
[null,null,"Срок кредита или лизинга, мес.",null,null,36,null,"Ставка НДС:",null,0.18]
[null,null,"% собственных средств в сделке",null,null,0.2,null,"Ставка УСН:",null,0.15]
["аннуитет",null,"Схема погашения задолженности",null,null,"дифференц.",null,"Налог на имущество",null,2.1999999999999999E-2]
["дифференц.",null,"Срок амортизации имущ-ва, мес.",null,null,48,null,"Транспортный налог",null,0]
[null,null,"Итоги сравнения двух схем приобретения:"]
[null,null,"ИТОГИ расчета:",null,null,null,"Кредит",null,"Лизинг"]
[null,null,"Общий отток денежных средств:",null,null,null,{"$f":"E17+F139+G139+I139","v":6511034.6045197723},null,{"$f":"$E$141+$D$263","v":6518333.3333333349}]
[null,null,"Экономия по налогу на прибыль",null,null,null,{"$f":"-J139","v":-917800.14124293812},null,{"$f":"-$J$263","v":-1283666.666666667}]
[null,null,"НДС к возмещению",null,null,null,{"$f":"-SUM(F4:F5)/(1+J6)*J6","v":-777966.10169491521},null,{"$f":"-$I$263","v":-979067.79661016958}]
[null,null,"Итоговые затраты по сценариям:",null,null,null,{"$f":"SUM(G12:H14)","v":4815268.3615819188},null,{"$f":"SUM(I12:J14)","v":4255598.8700564988}]
[null,null,"Расчет для схемы кредит:"]
[null,null,"Собств. средства:",null,{"$f":"$F$4*$F$7+$F$5","v":1100000},"Заемные средства:",null,{"$f":"$F$4*(1-$F$7)","v":4000000},"Ставка по\n кредиту, %",0.2,"Изменение расчетного срока, мес."]
["дней","год","№ ","Имущество на балансе","Амортизация","Погашение \nосн. долга ежемесячно","Погашение\nпроцентов ежемесячно","Остаток \nдолга по кредиту","Налог на имущество / транспорт","Экономия доходов / прибыли",{"$f":"$F$9","v":48}]
[365,1,1,{"$f":"F4/(1+$J$6)","v":4237288.1355932206},{"$f":"IF(C19=\"\",\"\",IF(SUM(E$18:E18)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G19)","v":111111.11111111111},{"$f":"$H$17*$J$17/12","v":66666.666666666672},{"$f":"$H$17-F19","v":3888888.888888889},null,{"$f":"IF($C19=\"\",\"\",(IF(E19=\"\",0,E19)+G19+I19)*IF($H$4=$A$4,$J$5,$J$7))","v":30988.700564971754},{"$f":"IF(#REF!=0,MIN(K$18:K18),$F$9-$C17)","v":{"$error":"#REF!"}}]
[365,1,{"$f":"IFERROR(IF(C19+1<=$F$6,C19+1,\"\"),\"\")","v":2},{"$f":"IF(OR(C19=\"\",E20=\"\"),\"\",D19-E19)","v":4149011.2994350283},{"$f":"IF(C20=\"\",\"\",IF(SUM(E$19:E19)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F19)=$H$17,$H19=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G20))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F19)=$H$17,$H19=\"\"),\"\",$H19*$J$17/12)","v":64814.814814814825},{"$f":"IFERROR($H19-F20,\"\")","v":3777777.777777778},null,30618.330194601382,{"$f":"IF($J19=0,MIN(K$18:K19),$F$9-$C19)","v":47}]
[365,1,{"$f":"IFERROR(IF(C20+1<=$F$6,C20+1,\"\"),\"\")","v":3},{"$f":"IF(OR(C20=\"\",E21=\"\"),\"\",D20-E20)","v":4060734.4632768361},{"$f":"IF(C21=\"\",\"\",IF(SUM(E$19:E20)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F20)=$H$17,$H20=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G21))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F20)=$H$17,$H20=\"\"),\"\",$H20*$J$17/12)","v":62962.962962962971},3666666.666666667,null,30247.959824231013,{"$f":"IF($J20=0,MIN(K$18:K20),$F$9-$C20)","v":46}]
[365,1,4,3972457.6271186438,{"$f":"IF(C22=\"\",\"\",IF(SUM(E$19:E21)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F21)=$H$17,$H21=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G22))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F21)=$H$17,$H21=\"\"),\"\",$H21*$J$17/12)","v":61111.111111111124},3555555.555555556,null,29877.589453860641,{"$f":"IF($J21=0,MIN(K$18:K21),$F$9-$C21)","v":45}]
[365,1,5,3884180.7909604516,{"$f":"IF(C23=\"\",\"\",IF(SUM(E$19:E22)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F22)=$H$17,$H22=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G23))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F22)=$H$17,$H22=\"\"),\"\",$H22*$J$17/12)","v":59259.25925925927},3444444.444444445,null,29507.219083490272,{"$f":"IF($J22=0,MIN(K$18:K22),$F$9-$C22)","v":44}]
[365,1,6,3795903.9548022593,{"$f":"IF(C24=\"\",\"\",IF(SUM(E$19:E23)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F23)=$H$17,$H23=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G24))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F23)=$H$17,$H23=\"\"),\"\",$H23*$J$17/12)","v":57407.407407407416},3333333.333333334,null,29136.8487131199,{"$f":"IF($J23=0,MIN(K$18:K23),$F$9-$C23)","v":43}]
[365,1,7,3707627.1186440671,{"$f":"IF(C25=\"\",\"\",IF(SUM(E$19:E24)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F24)=$H$17,$H24=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G25))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F24)=$H$17,$H24=\"\"),\"\",$H24*$J$17/12)","v":55555.555555555569},3222222.2222222229,null,28766.478342749535,{"$f":"IF($J24=0,MIN(K$18:K24),$F$9-$C24)","v":42}]
[365,1,8,3619350.2824858748,{"$f":"IF(C26=\"\",\"\",IF(SUM(E$19:E25)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F25)=$H$17,$H25=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G26))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F25)=$H$17,$H25=\"\"),\"\",$H25*$J$17/12)","v":53703.703703703715},3111111.1111111119,null,28396.107972379163,{"$f":"IF($J25=0,MIN(K$18:K25),$F$9-$C25)","v":41}]
[365,1,9,3531073.4463276826,{"$f":"IF(C27=\"\",\"\",IF(SUM(E$19:E26)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F26)=$H$17,$H26=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G27))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F26)=$H$17,$H26=\"\"),\"\",$H26*$J$17/12)","v":51851.851851851861},3000000.0000000009,null,28025.737602008794,{"$f":"IF($J26=0,MIN(K$18:K26),$F$9-$C26)","v":40}]
[365,1,10,3442796.6101694903,{"$f":"IF(C28=\"\",\"\",IF(SUM(E$19:E27)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F27)=$H$17,$H27=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G28))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F27)=$H$17,$H27=\"\"),\"\",$H27*$J$17/12)","v":50000.000000000022},2888888.8888888899,null,27655.367231638422,{"$f":"IF($J27=0,MIN(K$18:K27),$F$9-$C27)","v":39}]
[365,1,11,3354519.7740112981,{"$f":"IF(C29=\"\",\"\",IF(SUM(E$19:E28)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F28)=$H$17,$H28=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G29))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F28)=$H$17,$H28=\"\"),\"\",$H28*$J$17/12)","v":48148.148148148168},2777777.7777777789,null,27284.996861268053,{"$f":"IF($J28=0,MIN(K$18:K28),$F$9-$C28)","v":38}]
[365,1,12,3266242.9378531058,{"$f":"IF(C30=\"\",\"\",IF(SUM(E$19:E29)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F29)=$H$17,$H29=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G30))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F29)=$H$17,$H29=\"\"),\"\",$H29*$J$17/12)","v":46296.296296296321},2666666.6666666679,{"$f":"IF(OR(D30=\"\",E30=\"\"),\"\",IF($H$4=$A$4,(D30+D19)*50%*$J$8+$J$9,$J$9))","v":82538.841807909586},43422.394852479607,{"$f":"IF($J29=0,MIN(K$18:K29),$F$9-$C29)","v":37}]
[365,{"$f":"B19+1","v":2},13,3177966.1016949136,{"$f":"IF(C31=\"\",\"\",IF(SUM(E$19:E30)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F30)=$H$17,$H30=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G31))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F30)=$H$17,$H30=\"\"),\"\",$H30*$J$17/12)","v":44444.444444444467},2555555.5555555569,null,26544.256120527316,{"$f":"IF($J30=0,MIN(K$18:K30),$F$9-$C30)","v":36}]
[365,{"$f":"B20+1","v":2},14,3089689.2655367213,{"$f":"IF(C32=\"\",\"\",IF(SUM(E$19:E31)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F31)=$H$17,$H31=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G32))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F31)=$H$17,$H31=\"\"),\"\",$H31*$J$17/12)","v":42592.59259259262},2444444.4444444459,null,26173.885750156944,{"$f":"IF($J31=0,MIN(K$18:K31),$F$9-$C31)","v":35}]
[365,{"$f":"B21+1","v":2},15,3001412.4293785291,{"$f":"IF(C33=\"\",\"\",IF(SUM(E$19:E32)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F32)=$H$17,$H32=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G33))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F32)=$H$17,$H32=\"\"),\"\",$H32*$J$17/12)","v":40740.740740740766},2333333.3333333349,null,25803.515379786575,{"$f":"IF($J32=0,MIN(K$18:K32),$F$9-$C32)","v":34}]
[365,2,16,2913135.5932203368,{"$f":"IF(C34=\"\",\"\",IF(SUM(E$19:E33)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F33)=$H$17,$H33=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G34))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F33)=$H$17,$H33=\"\"),\"\",$H33*$J$17/12)","v":38888.888888888912},2222222.2222222239,null,25433.145009416203,{"$f":"IF($J33=0,MIN(K$18:K33),$F$9-$C33)","v":33}]
[365,2,17,2824858.7570621446,{"$f":"IF(C35=\"\",\"\",IF(SUM(E$19:E34)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F34)=$H$17,$H34=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G35))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F34)=$H$17,$H34=\"\"),\"\",$H34*$J$17/12)","v":37037.037037037066},2111111.1111111129,null,25062.774639045834,{"$f":"IF($J34=0,MIN(K$18:K34),$F$9-$C34)","v":32}]
[365,2,18,2736581.9209039523,{"$f":"IF(C36=\"\",\"\",IF(SUM(E$19:E35)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F35)=$H$17,$H35=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G36))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F35)=$H$17,$H35=\"\"),\"\",$H35*$J$17/12)","v":35185.185185185219},2000000.0000000019,null,24692.404268675462,{"$f":"IF($J35=0,MIN(K$18:K35),$F$9-$C35)","v":31}]
[365,2,19,2648305.0847457601,{"$f":"IF(C37=\"\",\"\",IF(SUM(E$19:E36)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F36)=$H$17,$H36=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G37))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F36)=$H$17,$H36=\"\"),\"\",$H36*$J$17/12)","v":33333.333333333365},1888888.8888888909,null,24322.03389830509,{"$f":"IF($J36=0,MIN(K$18:K36),$F$9-$C36)","v":30}]
[365,2,20,2560028.2485875678,{"$f":"IF(C38=\"\",\"\",IF(SUM(E$19:E37)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F37)=$H$17,$H37=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G38))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F37)=$H$17,$H37=\"\"),\"\",$H37*$J$17/12)","v":31481.481481481518},1777777.7777777798,null,23951.663527934725,{"$f":"IF($J37=0,MIN(K$18:K37),$F$9-$C37)","v":29}]
[365,2,21,2471751.4124293756,{"$f":"IF(C39=\"\",\"\",IF(SUM(E$19:E38)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F38)=$H$17,$H38=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G39))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F38)=$H$17,$H38=\"\"),\"\",$H38*$J$17/12)","v":29629.629629629664},1666666.6666666688,null,23581.293157564352,{"$f":"IF($J38=0,MIN(K$18:K38),$F$9-$C38)","v":28}]
[365,2,22,2383474.5762711833,{"$f":"IF(C40=\"\",\"\",IF(SUM(E$19:E39)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F39)=$H$17,$H39=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G40))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F39)=$H$17,$H39=\"\"),\"\",$H39*$J$17/12)","v":27777.777777777814},1555555.5555555578,null,23210.92278719398,{"$f":"IF($J39=0,MIN(K$18:K39),$F$9-$C39)","v":27}]
[365,2,23,2295197.7401129911,{"$f":"IF(C41=\"\",\"\",IF(SUM(E$19:E40)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F40)=$H$17,$H40=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G41))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F40)=$H$17,$H40=\"\"),\"\",$H40*$J$17/12)","v":25925.925925925967},1444444.4444444468,null,22840.552416823615,{"$f":"IF($J40=0,MIN(K$18:K40),$F$9-$C40)","v":26}]
[365,2,24,2206920.9039547988,{"$f":"IF(C42=\"\",\"\",IF(SUM(E$19:E41)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F41)=$H$17,$H41=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G42))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F41)=$H$17,$H41=\"\"),\"\",$H41*$J$17/12)","v":24074.074074074117},1333333.3333333358,{"$f":"IF(OR(D42=\"\",E42=\"\"),\"\",IF($H$4=$A$4,(D42+D31)*50%*$J$8+$J$9,$J$9))","v":59233.757062146826},34316.93345888261,{"$f":"IF($J41=0,MIN(K$18:K41),$F$9-$C41)","v":25}]
[365,{"$f":"B31+1","v":3},25,2118644.0677966066,{"$f":"IF(C43=\"\",\"\",IF(SUM(E$19:E42)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F42)=$H$17,$H42=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G43))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F42)=$H$17,$H42=\"\"),\"\",$H42*$J$17/12)","v":22222.222222222263},1222222.2222222248,null,22099.811676082871,{"$f":"IF($J42=0,MIN(K$18:K42),$F$9-$C42)","v":24}]
[365,3,26,2030367.2316384146,{"$f":"IF(C44=\"\",\"\",IF(SUM(E$19:E43)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F43)=$H$17,$H43=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G44))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F43)=$H$17,$H43=\"\"),\"\",$H43*$J$17/12)","v":20370.370370370412},1111111.1111111138,null,21729.441305712502,{"$f":"IF($J43=0,MIN(K$18:K43),$F$9-$C43)","v":23}]
[365,3,27,1942090.3954802225,{"$f":"IF(C45=\"\",\"\",IF(SUM(E$19:E44)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F44)=$H$17,$H44=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G45))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F44)=$H$17,$H44=\"\"),\"\",$H44*$J$17/12)","v":18518.518518518566},1000000.0000000027,null,21359.070935342133,{"$f":"IF($J44=0,MIN(K$18:K44),$F$9-$C44)","v":22}]
[365,3,28,1853813.5593220305,{"$f":"IF(C46=\"\",\"\",IF(SUM(E$19:E45)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F45)=$H$17,$H45=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G46))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F45)=$H$17,$H45=\"\"),\"\",$H45*$J$17/12)","v":16666.666666666712},888888.88888889155,null,20988.700564971761,{"$f":"IF($J45=0,MIN(K$18:K45),$F$9-$C45)","v":21}]
[365,3,29,1765536.7231638385,{"$f":"IF(C47=\"\",\"\",IF(SUM(E$19:E46)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F46)=$H$17,$H46=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G47))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F46)=$H$17,$H46=\"\"),\"\",$H46*$J$17/12)","v":14814.814814814861},777777.77777778043,null,20618.330194601393,{"$f":"IF($J46=0,MIN(K$18:K46),$F$9-$C46)","v":20}]
[365,3,30,1677259.8870056465,{"$f":"IF(C48=\"\",\"\",IF(SUM(E$19:E47)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F47)=$H$17,$H47=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G48))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F47)=$H$17,$H47=\"\"),\"\",$H47*$J$17/12)","v":12962.962962963007},666666.66666666931,null,20247.95982423102,{"$f":"IF($J47=0,MIN(K$18:K47),$F$9-$C47)","v":19}]
[365,3,31,1588983.0508474545,{"$f":"IF(C49=\"\",\"\",IF(SUM(E$19:E48)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F48)=$H$17,$H48=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G49))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F48)=$H$17,$H48=\"\"),\"\",$H48*$J$17/12)","v":11111.111111111155},555555.55555555818,null,19877.589453860652,{"$f":"IF($J48=0,MIN(K$18:K48),$F$9-$C48)","v":18}]
[365,3,32,1500706.2146892624,{"$f":"IF(C50=\"\",\"\",IF(SUM(E$19:E49)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F49)=$H$17,$H49=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G50))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F49)=$H$17,$H49=\"\"),\"\",$H49*$J$17/12)","v":9259.2592592593046},444444.44444444706,null,19507.219083490279,{"$f":"IF($J49=0,MIN(K$18:K49),$F$9-$C49)","v":17}]
[365,3,33,1412429.3785310704,{"$f":"IF(C51=\"\",\"\",IF(SUM(E$19:E50)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F50)=$H$17,$H50=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G51))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F50)=$H$17,$H50=\"\"),\"\",$H50*$J$17/12)","v":7407.4074074074515},333333.33333333593,null,19136.848713119907,{"$f":"IF($J50=0,MIN(K$18:K50),$F$9-$C50)","v":16}]
[365,3,34,1324152.5423728784,{"$f":"IF(C52=\"\",\"\",IF(SUM(E$19:E51)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F51)=$H$17,$H51=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G52))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F51)=$H$17,$H51=\"\"),\"\",$H51*$J$17/12)","v":5555.5555555555993},{"$f":"IFERROR($H51-F52,\"\")","v":222222.22222222481},null,18766.478342749539,{"$f":"IF($J51=0,MIN(K$18:K51),$F$9-$C51)","v":15}]
[365,3,35,1235875.7062146864,{"$f":"IF(C53=\"\",\"\",IF(SUM(E$19:E52)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F52)=$H$17,$H52=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G53))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F52)=$H$17,$H52=\"\"),\"\",$H52*$J$17/12)","v":3703.7037037037467},111111.1111111137,null,18396.10797237917,{"$f":"IF($J52=0,MIN(K$18:K52),$F$9-$C52)","v":14}]
[365,3,36,{"$f":"IF(OR(C53=\"\",E54=\"\"),\"\",D53-E53)","v":1147598.8700564944},{"$f":"IF(C54=\"\",\"\",IF(SUM(E$19:E53)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":88276.836158192091},{"$f":"IF(OR(SUM(F$19:F53)=$H$17,$H53=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G54))","v":111111.11111111111},{"$f":"IF(OR(SUM(F$19:F53)=$H$17,$H53=\"\"),\"\",$H53*$J$17/12)","v":1851.8518518518952},2.5902409106492996E-9,{"$f":"IF(OR(D54=\"\",E54=\"\"),\"\",IF($H$4=$A$4,(D54+D43)*50%*$J$8+$J$9,$J$9))","v":35928.672316384109},25211.472065285619,{"$f":"IF($J53=0,MIN(K$18:K53),$F$9-$C53)","v":13}]
[365,{"$f":"B43+1","v":4},"","",{"$f":"IF(C55=\"\",\"\",IF(SUM(E$19:E54)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F54)=$H$17,$H54=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G55))","v":""},{"$f":"IF(OR(SUM(F$19:F54)=$H$17,$H54=\"\"),\"\",$H54*$J$17/12)","v":""},{"$f":"IFERROR($H54-F55,\"\")","v":""},null,"",{"$f":"IF($J54=0,MIN(K$18:K54),$F$9-$C54)","v":12}]
[365,4,"","",{"$f":"IF(C56=\"\",\"\",IF(SUM(E$19:E55)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F55)=$H$17,$H55=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G56))","v":""},{"$f":"IF(OR(SUM(F$19:F55)=$H$17,$H55=\"\"),\"\",$H55*$J$17/12)","v":""},"",null,"",{"$f":"IF($J55=0,MIN(K$18:K55),$F$9-$C55)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C57=\"\",\"\",IF(SUM(E$19:E56)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F56)=$H$17,$H56=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G57))","v":""},{"$f":"IF(OR(SUM(F$19:F56)=$H$17,$H56=\"\"),\"\",$H56*$J$17/12)","v":""},"",null,"",{"$f":"IF($J56=0,MIN(K$18:K56),$F$9-$C56)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C58=\"\",\"\",IF(SUM(E$19:E57)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F57)=$H$17,$H57=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G58))","v":""},{"$f":"IF(OR(SUM(F$19:F57)=$H$17,$H57=\"\"),\"\",$H57*$J$17/12)","v":""},"",null,"",{"$f":"IF($J57=0,MIN(K$18:K57),$F$9-$C57)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C59=\"\",\"\",IF(SUM(E$19:E58)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F58)=$H$17,$H58=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G59))","v":""},{"$f":"IF(OR(SUM(F$19:F58)=$H$17,$H58=\"\"),\"\",$H58*$J$17/12)","v":""},"",null,"",{"$f":"IF($J58=0,MIN(K$18:K58),$F$9-$C58)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C60=\"\",\"\",IF(SUM(E$19:E59)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F59)=$H$17,$H59=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G60))","v":""},{"$f":"IF(OR(SUM(F$19:F59)=$H$17,$H59=\"\"),\"\",$H59*$J$17/12)","v":""},"",null,"",{"$f":"IF($J59=0,MIN(K$18:K59),$F$9-$C59)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C61=\"\",\"\",IF(SUM(E$19:E60)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F60)=$H$17,$H60=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G61))","v":""},{"$f":"IF(OR(SUM(F$19:F60)=$H$17,$H60=\"\"),\"\",$H60*$J$17/12)","v":""},"",null,"",{"$f":"IF($J60=0,MIN(K$18:K60),$F$9-$C60)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C62=\"\",\"\",IF(SUM(E$19:E61)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F61)=$H$17,$H61=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G62))","v":""},{"$f":"IF(OR(SUM(F$19:F61)=$H$17,$H61=\"\"),\"\",$H61*$J$17/12)","v":""},"",null,"",{"$f":"IF($J61=0,MIN(K$18:K61),$F$9-$C61)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C63=\"\",\"\",IF(SUM(E$19:E62)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F62)=$H$17,$H62=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G63))","v":""},{"$f":"IF(OR(SUM(F$19:F62)=$H$17,$H62=\"\"),\"\",$H62*$J$17/12)","v":""},"",null,"",{"$f":"IF($J62=0,MIN(K$18:K62),$F$9-$C62)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C64=\"\",\"\",IF(SUM(E$19:E63)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F63)=$H$17,$H63=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G64))","v":""},{"$f":"IF(OR(SUM(F$19:F63)=$H$17,$H63=\"\"),\"\",$H63*$J$17/12)","v":""},"",null,"",{"$f":"IF($J63=0,MIN(K$18:K63),$F$9-$C63)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C65=\"\",\"\",IF(SUM(E$19:E64)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F64)=$H$17,$H64=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G65))","v":""},{"$f":"IF(OR(SUM(F$19:F64)=$H$17,$H64=\"\"),\"\",$H64*$J$17/12)","v":""},"",null,"",{"$f":"IF($J64=0,MIN(K$18:K64),$F$9-$C64)","v":{"$error":"#VALUE!"}}]
[365,4,"","",{"$f":"IF(C66=\"\",\"\",IF(SUM(E$19:E65)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F65)=$H$17,$H65=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G66))","v":""},{"$f":"IF(OR(SUM(F$19:F65)=$H$17,$H65=\"\"),\"\",$H65*$J$17/12)","v":""},"",{"$f":"IF(OR(D66=\"\",E66=\"\"),0,IF($H$4=$A$4,(D66+D55)*50%*$J$8+$J$9,$J$9))","v":0},"",{"$f":"IF($J65=0,MIN(K$18:K65),$F$9-$C65)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B55+1","v":5},"","",{"$f":"IF(C67=\"\",\"\",IF(SUM(E$19:E66)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F66)=$H$17,$H66=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G67))","v":""},{"$f":"IF(OR(SUM(F$19:F66)=$H$17,$H66=\"\"),\"\",$H66*$J$17/12)","v":""},"",null,"",{"$f":"IF($J66=0,MIN(K$18:K66),$F$9-$C66)","v":{"$error":"#VALUE!"}}]
[365,5,"",{"$f":"IF(OR(C67=\"\",E68=\"\"),\"\",D67-E67)","v":""},{"$f":"IF(C68=\"\",\"\",IF(SUM(E$19:E67)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F67)=$H$17,$H67=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G68))","v":""},{"$f":"IF(OR(SUM(F$19:F67)=$H$17,$H67=\"\"),\"\",$H67*$J$17/12)","v":""},"",null,"",{"$f":"IF($J67=0,MIN(K$18:K67),$F$9-$C67)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C69=\"\",\"\",IF(SUM(E$19:E68)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F68)=$H$17,$H68=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G69))","v":""},{"$f":"IF(OR(SUM(F$19:F68)=$H$17,$H68=\"\"),\"\",$H68*$J$17/12)","v":""},"",null,"",{"$f":"IF($J68=0,MIN(K$18:K68),$F$9-$C68)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C70=\"\",\"\",IF(SUM(E$19:E69)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F69)=$H$17,$H69=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G70))","v":""},{"$f":"IF(OR(SUM(F$19:F69)=$H$17,$H69=\"\"),\"\",$H69*$J$17/12)","v":""},"",null,"",{"$f":"IF($J69=0,MIN(K$18:K69),$F$9-$C69)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C71=\"\",\"\",IF(SUM(E$19:E70)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F70)=$H$17,$H70=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G71))","v":""},{"$f":"IF(OR(SUM(F$19:F70)=$H$17,$H70=\"\"),\"\",$H70*$J$17/12)","v":""},"",null,"",{"$f":"IF($J70=0,MIN(K$18:K70),$F$9-$C70)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C72=\"\",\"\",IF(SUM(E$19:E71)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F71)=$H$17,$H71=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G72))","v":""},{"$f":"IF(OR(SUM(F$19:F71)=$H$17,$H71=\"\"),\"\",$H71*$J$17/12)","v":""},"",null,"",{"$f":"IF($J71=0,MIN(K$18:K71),$F$9-$C71)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C73=\"\",\"\",IF(SUM(E$19:E72)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F72)=$H$17,$H72=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G73))","v":""},{"$f":"IF(OR(SUM(F$19:F72)=$H$17,$H72=\"\"),\"\",$H72*$J$17/12)","v":""},"",null,"",{"$f":"IF($J72=0,MIN(K$18:K72),$F$9-$C72)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C74=\"\",\"\",IF(SUM(E$19:E73)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F73)=$H$17,$H73=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G74))","v":""},{"$f":"IF(OR(SUM(F$19:F73)=$H$17,$H73=\"\"),\"\",$H73*$J$17/12)","v":""},"",null,"",{"$f":"IF($J73=0,MIN(K$18:K73),$F$9-$C73)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C75=\"\",\"\",IF(SUM(E$19:E74)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F74)=$H$17,$H74=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G75))","v":""},{"$f":"IF(OR(SUM(F$19:F74)=$H$17,$H74=\"\"),\"\",$H74*$J$17/12)","v":""},"",null,"",{"$f":"IF($J74=0,MIN(K$18:K74),$F$9-$C74)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C76=\"\",\"\",IF(SUM(E$19:E75)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F75)=$H$17,$H75=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G76))","v":""},{"$f":"IF(OR(SUM(F$19:F75)=$H$17,$H75=\"\"),\"\",$H75*$J$17/12)","v":""},"",null,"",{"$f":"IF($J75=0,MIN(K$18:K75),$F$9-$C75)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C77=\"\",\"\",IF(SUM(E$19:E76)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F76)=$H$17,$H76=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G77))","v":""},{"$f":"IF(OR(SUM(F$19:F76)=$H$17,$H76=\"\"),\"\",$H76*$J$17/12)","v":""},"",null,"",{"$f":"IF($J76=0,MIN(K$18:K76),$F$9-$C76)","v":{"$error":"#VALUE!"}}]
[365,5,"","",{"$f":"IF(C78=\"\",\"\",IF(SUM(E$19:E77)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F77)=$H$17,$H77=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G78))","v":""},{"$f":"IF(OR(SUM(F$19:F77)=$H$17,$H77=\"\"),\"\",$H77*$J$17/12)","v":""},"",{"$f":"IF(OR(D78=\"\",E78=\"\"),0,IF($H$4=$A$4,(D78+D67)*50%*$J$8+$J$9,$J$9))","v":0},"",{"$f":"IF($J77=0,MIN(K$18:K77),$F$9-$C77)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B67+1","v":6},"","",{"$f":"IF(C79=\"\",\"\",IF(SUM(E$19:E78)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F78)=$H$17,$H78=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G79))","v":""},{"$f":"IF(OR(SUM(F$19:F78)=$H$17,$H78=\"\"),\"\",$H78*$J$17/12)","v":""},"",null,"",{"$f":"IF($J78=0,MIN(K$18:K78),$F$9-$C78)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C80=\"\",\"\",IF(SUM(E$19:E79)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F79)=$H$17,$H79=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G80))","v":""},{"$f":"IF(OR(SUM(F$19:F79)=$H$17,$H79=\"\"),\"\",$H79*$J$17/12)","v":""},"",null,"",{"$f":"IF($J79=0,MIN(K$18:K79),$F$9-$C79)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C81=\"\",\"\",IF(SUM(E$19:E80)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F80)=$H$17,$H80=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G81))","v":""},{"$f":"IF(OR(SUM(F$19:F80)=$H$17,$H80=\"\"),\"\",$H80*$J$17/12)","v":""},"",null,"",{"$f":"IF($J80=0,MIN(K$18:K80),$F$9-$C80)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C82=\"\",\"\",IF(SUM(E$19:E81)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F81)=$H$17,$H81=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G82))","v":""},{"$f":"IF(OR(SUM(F$19:F81)=$H$17,$H81=\"\"),\"\",$H81*$J$17/12)","v":""},"",null,"",{"$f":"IF($J81=0,MIN(K$18:K81),$F$9-$C81)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C83=\"\",\"\",IF(SUM(E$19:E82)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F82)=$H$17,$H82=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G83))","v":""},{"$f":"IF(OR(SUM(F$19:F82)=$H$17,$H82=\"\"),\"\",$H82*$J$17/12)","v":""},"",null,{"$f":"IF($C83=\"\",\"\",(IF(E83=\"\",0,E83)+G83+I83)*IF($H$4=$A$4,$J$5,$J$7))","v":""},{"$f":"IF($J82=0,MIN(K$18:K82),$F$9-$C82)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C84=\"\",\"\",IF(SUM(E$19:E83)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F83)=$H$17,$H83=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G84))","v":""},{"$f":"IF(OR(SUM(F$19:F83)=$H$17,$H83=\"\"),\"\",$H83*$J$17/12)","v":""},{"$f":"IFERROR($H83-F84,\"\")","v":""},null,"",{"$f":"IF($J83=0,MIN(K$18:K83),$F$9-$C83)","v":{"$error":"#VALUE!"}}]
[365,6,{"$f":"IFERROR(IF(C84+1<=$F$6,C84+1,\"\"),\"\")","v":""},"",{"$f":"IF(C85=\"\",\"\",IF(SUM(E$19:E84)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F84)=$H$17,$H84=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G85))","v":""},{"$f":"IF(OR(SUM(F$19:F84)=$H$17,$H84=\"\"),\"\",$H84*$J$17/12)","v":""},"",null,"",{"$f":"IF($J84=0,MIN(K$18:K84),$F$9-$C84)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C86=\"\",\"\",IF(SUM(E$19:E85)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F85)=$H$17,$H85=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G86))","v":""},{"$f":"IF(OR(SUM(F$19:F85)=$H$17,$H85=\"\"),\"\",$H85*$J$17/12)","v":""},"",null,"",{"$f":"IF($J85=0,MIN(K$18:K85),$F$9-$C85)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C87=\"\",\"\",IF(SUM(E$19:E86)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F86)=$H$17,$H86=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G87))","v":""},{"$f":"IF(OR(SUM(F$19:F86)=$H$17,$H86=\"\"),\"\",$H86*$J$17/12)","v":""},"",null,"",{"$f":"IF($J86=0,MIN(K$18:K86),$F$9-$C86)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C88=\"\",\"\",IF(SUM(E$19:E87)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F87)=$H$17,$H87=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G88))","v":""},{"$f":"IF(OR(SUM(F$19:F87)=$H$17,$H87=\"\"),\"\",$H87*$J$17/12)","v":""},"",null,"",{"$f":"IF($J87=0,MIN(K$18:K87),$F$9-$C87)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C89=\"\",\"\",IF(SUM(E$19:E88)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F88)=$H$17,$H88=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G89))","v":""},{"$f":"IF(OR(SUM(F$19:F88)=$H$17,$H88=\"\"),\"\",$H88*$J$17/12)","v":""},"",null,"",{"$f":"IF($J88=0,MIN(K$18:K88),$F$9-$C88)","v":{"$error":"#VALUE!"}}]
[365,6,"","",{"$f":"IF(C90=\"\",\"\",IF(SUM(E$19:E89)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F89)=$H$17,$H89=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G90))","v":""},{"$f":"IF(OR(SUM(F$19:F89)=$H$17,$H89=\"\"),\"\",$H89*$J$17/12)","v":""},"",{"$f":"IF(OR(D90=\"\",E90=\"\"),0,IF($H$4=$A$4,(D90+D79)*50%*$J$8+$J$9,$J$9))","v":0},"",{"$f":"IF($J89=0,MIN(K$18:K89),$F$9-$C89)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B79+1","v":7},"","",{"$f":"IF(C91=\"\",\"\",IF(SUM(E$19:E90)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F90)=$H$17,$H90=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G91))","v":""},{"$f":"IF(OR(SUM(F$19:F90)=$H$17,$H90=\"\"),\"\",$H90*$J$17/12)","v":""},"",null,"",{"$f":"IF($J90=0,MIN(K$18:K90),$F$9-$C90)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C92=\"\",\"\",IF(SUM(E$19:E91)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F91)=$H$17,$H91=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G92))","v":""},{"$f":"IF(OR(SUM(F$19:F91)=$H$17,$H91=\"\"),\"\",$H91*$J$17/12)","v":""},"",null,"",{"$f":"IF($J91=0,MIN(K$18:K91),$F$9-$C91)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C93=\"\",\"\",IF(SUM(E$19:E92)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F92)=$H$17,$H92=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G93))","v":""},{"$f":"IF(OR(SUM(F$19:F92)=$H$17,$H92=\"\"),\"\",$H92*$J$17/12)","v":""},"",null,"",{"$f":"IF($J92=0,MIN(K$18:K92),$F$9-$C92)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C94=\"\",\"\",IF(SUM(E$19:E93)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F93)=$H$17,$H93=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G94))","v":""},{"$f":"IF(OR(SUM(F$19:F93)=$H$17,$H93=\"\"),\"\",$H93*$J$17/12)","v":""},"",null,"",{"$f":"IF($J93=0,MIN(K$18:K93),$F$9-$C93)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C95=\"\",\"\",IF(SUM(E$19:E94)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F94)=$H$17,$H94=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G95))","v":""},{"$f":"IF(OR(SUM(F$19:F94)=$H$17,$H94=\"\"),\"\",$H94*$J$17/12)","v":""},"",null,"",{"$f":"IF($J94=0,MIN(K$18:K94),$F$9-$C94)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C96=\"\",\"\",IF(SUM(E$19:E95)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F95)=$H$17,$H95=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G96))","v":""},{"$f":"IF(OR(SUM(F$19:F95)=$H$17,$H95=\"\"),\"\",$H95*$J$17/12)","v":""},"",null,"",{"$f":"IF($J95=0,MIN(K$18:K95),$F$9-$C95)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B85+1","v":7},"","",{"$f":"IF(C97=\"\",\"\",IF(SUM(E$19:E96)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F96)=$H$17,$H96=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G97))","v":""},{"$f":"IF(OR(SUM(F$19:F96)=$H$17,$H96=\"\"),\"\",$H96*$J$17/12)","v":""},"",null,"",{"$f":"IF($J96=0,MIN(K$18:K96),$F$9-$C96)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C98=\"\",\"\",IF(SUM(E$19:E97)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F97)=$H$17,$H97=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G98))","v":""},{"$f":"IF(OR(SUM(F$19:F97)=$H$17,$H97=\"\"),\"\",$H97*$J$17/12)","v":""},"",null,"",{"$f":"IF($J97=0,MIN(K$18:K97),$F$9-$C97)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C99=\"\",\"\",IF(SUM(E$19:E98)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F98)=$H$17,$H98=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G99))","v":""},{"$f":"IF(OR(SUM(F$19:F98)=$H$17,$H98=\"\"),\"\",$H98*$J$17/12)","v":""},"",null,"",{"$f":"IF($J98=0,MIN(K$18:K98),$F$9-$C98)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C100=\"\",\"\",IF(SUM(E$19:E99)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F99)=$H$17,$H99=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G100))","v":""},{"$f":"IF(OR(SUM(F$19:F99)=$H$17,$H99=\"\"),\"\",$H99*$J$17/12)","v":""},"",null,"",{"$f":"IF($J99=0,MIN(K$18:K99),$F$9-$C99)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C101=\"\",\"\",IF(SUM(E$19:E100)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F100)=$H$17,$H100=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G101))","v":""},{"$f":"IF(OR(SUM(F$19:F100)=$H$17,$H100=\"\"),\"\",$H100*$J$17/12)","v":""},"",null,"",{"$f":"IF($J100=0,MIN(K$18:K100),$F$9-$C100)","v":{"$error":"#VALUE!"}}]
[365,7,"","",{"$f":"IF(C102=\"\",\"\",IF(SUM(E$19:E101)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F101)=$H$17,$H101=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G102))","v":""},{"$f":"IF(OR(SUM(F$19:F101)=$H$17,$H101=\"\"),\"\",$H101*$J$17/12)","v":""},"",{"$f":"IF(OR(D102=\"\",E102=\"\"),0,IF($H$4=$A$4,(D102+D91)*50%*$J$8+$J$9,$J$9))","v":0},"",{"$f":"IF($J101=0,MIN(K$18:K101),$F$9-$C101)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B91+1","v":8},"","",{"$f":"IF(C103=\"\",\"\",IF(SUM(E$19:E102)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F102)=$H$17,$H102=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G103))","v":""},{"$f":"IF(OR(SUM(F$19:F102)=$H$17,$H102=\"\"),\"\",$H102*$J$17/12)","v":""},"",null,"",{"$f":"IF($J102=0,MIN(K$18:K102),$F$9-$C102)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B92+1","v":8},"","",{"$f":"IF(C104=\"\",\"\",IF(SUM(E$19:E103)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F103)=$H$17,$H103=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G104))","v":""},{"$f":"IF(OR(SUM(F$19:F103)=$H$17,$H103=\"\"),\"\",$H103*$J$17/12)","v":""},"",null,"",{"$f":"IF($J103=0,MIN(K$18:K103),$F$9-$C103)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C105=\"\",\"\",IF(SUM(E$19:E104)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F104)=$H$17,$H104=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G105))","v":""},{"$f":"IF(OR(SUM(F$19:F104)=$H$17,$H104=\"\"),\"\",$H104*$J$17/12)","v":""},"",null,"",{"$f":"IF($J104=0,MIN(K$18:K104),$F$9-$C104)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C106=\"\",\"\",IF(SUM(E$19:E105)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F105)=$H$17,$H105=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G106))","v":""},{"$f":"IF(OR(SUM(F$19:F105)=$H$17,$H105=\"\"),\"\",$H105*$J$17/12)","v":""},"",null,"",{"$f":"IF($J105=0,MIN(K$18:K105),$F$9-$C105)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C107=\"\",\"\",IF(SUM(E$19:E106)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F106)=$H$17,$H106=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G107))","v":""},{"$f":"IF(OR(SUM(F$19:F106)=$H$17,$H106=\"\"),\"\",$H106*$J$17/12)","v":""},"",null,"",{"$f":"IF($J106=0,MIN(K$18:K106),$F$9-$C106)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C108=\"\",\"\",IF(SUM(E$19:E107)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F107)=$H$17,$H107=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G108))","v":""},{"$f":"IF(OR(SUM(F$19:F107)=$H$17,$H107=\"\"),\"\",$H107*$J$17/12)","v":""},"",null,"",{"$f":"IF($J107=0,MIN(K$18:K107),$F$9-$C107)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C109=\"\",\"\",IF(SUM(E$19:E108)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F108)=$H$17,$H108=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G109))","v":""},{"$f":"IF(OR(SUM(F$19:F108)=$H$17,$H108=\"\"),\"\",$H108*$J$17/12)","v":""},"",null,"",{"$f":"IF($J108=0,MIN(K$18:K108),$F$9-$C108)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C110=\"\",\"\",IF(SUM(E$19:E109)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F109)=$H$17,$H109=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G110))","v":""},{"$f":"IF(OR(SUM(F$19:F109)=$H$17,$H109=\"\"),\"\",$H109*$J$17/12)","v":""},"",null,"",{"$f":"IF($J109=0,MIN(K$18:K109),$F$9-$C109)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C111=\"\",\"\",IF(SUM(E$19:E110)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F110)=$H$17,$H110=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G111))","v":""},{"$f":"IF(OR(SUM(F$19:F110)=$H$17,$H110=\"\"),\"\",$H110*$J$17/12)","v":""},"",null,"",{"$f":"IF($J110=0,MIN(K$18:K110),$F$9-$C110)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C112=\"\",\"\",IF(SUM(E$19:E111)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F111)=$H$17,$H111=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G112))","v":""},{"$f":"IF(OR(SUM(F$19:F111)=$H$17,$H111=\"\"),\"\",$H111*$J$17/12)","v":""},"",null,"",{"$f":"IF($J111=0,MIN(K$18:K111),$F$9-$C111)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C113=\"\",\"\",IF(SUM(E$19:E112)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F112)=$H$17,$H112=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G113))","v":""},{"$f":"IF(OR(SUM(F$19:F112)=$H$17,$H112=\"\"),\"\",$H112*$J$17/12)","v":""},"",null,"",{"$f":"IF($J112=0,MIN(K$18:K112),$F$9-$C112)","v":{"$error":"#VALUE!"}}]
[365,8,"","",{"$f":"IF(C114=\"\",\"\",IF(SUM(E$19:E113)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F113)=$H$17,$H113=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G114))","v":""},{"$f":"IF(OR(SUM(F$19:F113)=$H$17,$H113=\"\"),\"\",$H113*$J$17/12)","v":""},"",{"$f":"IF(OR(D114=\"\",E114=\"\"),0,IF($H$4=$A$4,(D114+D103)*50%*$J$8+$J$9,$J$9))","v":0},"",{"$f":"IF($J113=0,MIN(K$18:K113),$F$9-$C113)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B103+1","v":9},"","",{"$f":"IF(C115=\"\",\"\",IF(SUM(E$19:E114)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F114)=$H$17,$H114=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G115))","v":""},{"$f":"IF(OR(SUM(F$19:F114)=$H$17,$H114=\"\"),\"\",$H114*$J$17/12)","v":""},"",null,"",{"$f":"IF($J114=0,MIN(K$18:K114),$F$9-$C114)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B104+1","v":9},"","",{"$f":"IF(C116=\"\",\"\",IF(SUM(E$19:E115)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F115)=$H$17,$H115=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G116))","v":""},{"$f":"IF(OR(SUM(F$19:F115)=$H$17,$H115=\"\"),\"\",$H115*$J$17/12)","v":""},{"$f":"IFERROR($H115-F116,\"\")","v":""},null,"",{"$f":"IF($J115=0,MIN(K$18:K115),$F$9-$C115)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C117=\"\",\"\",IF(SUM(E$19:E116)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F116)=$H$17,$H116=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G117))","v":""},{"$f":"IF(OR(SUM(F$19:F116)=$H$17,$H116=\"\"),\"\",$H116*$J$17/12)","v":""},"",null,"",{"$f":"IF($J116=0,MIN(K$18:K116),$F$9-$C116)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C118=\"\",\"\",IF(SUM(E$19:E117)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F117)=$H$17,$H117=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G118))","v":""},{"$f":"IF(OR(SUM(F$19:F117)=$H$17,$H117=\"\"),\"\",$H117*$J$17/12)","v":""},"",null,"",{"$f":"IF($J117=0,MIN(K$18:K117),$F$9-$C117)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C119=\"\",\"\",IF(SUM(E$19:E118)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F118)=$H$17,$H118=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G119))","v":""},{"$f":"IF(OR(SUM(F$19:F118)=$H$17,$H118=\"\"),\"\",$H118*$J$17/12)","v":""},"",null,"",{"$f":"IF($J118=0,MIN(K$18:K118),$F$9-$C118)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C120=\"\",\"\",IF(SUM(E$19:E119)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F119)=$H$17,$H119=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G120))","v":""},{"$f":"IF(OR(SUM(F$19:F119)=$H$17,$H119=\"\"),\"\",$H119*$J$17/12)","v":""},"",null,"",{"$f":"IF($J119=0,MIN(K$18:K119),$F$9-$C119)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C121=\"\",\"\",IF(SUM(E$19:E120)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F120)=$H$17,$H120=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G121))","v":""},{"$f":"IF(OR(SUM(F$19:F120)=$H$17,$H120=\"\"),\"\",$H120*$J$17/12)","v":""},"",null,"",{"$f":"IF($J120=0,MIN(K$18:K120),$F$9-$C120)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C122=\"\",\"\",IF(SUM(E$19:E121)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F121)=$H$17,$H121=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G122))","v":""},{"$f":"IF(OR(SUM(F$19:F121)=$H$17,$H121=\"\"),\"\",$H121*$J$17/12)","v":""},"",null,"",{"$f":"IF($J121=0,MIN(K$18:K121),$F$9-$C121)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C123=\"\",\"\",IF(SUM(E$19:E122)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F122)=$H$17,$H122=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G123))","v":""},{"$f":"IF(OR(SUM(F$19:F122)=$H$17,$H122=\"\"),\"\",$H122*$J$17/12)","v":""},"",null,"",{"$f":"IF($J122=0,MIN(K$18:K122),$F$9-$C122)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C124=\"\",\"\",IF(SUM(E$19:E123)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F123)=$H$17,$H123=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G124))","v":""},{"$f":"IF(OR(SUM(F$19:F123)=$H$17,$H123=\"\"),\"\",$H123*$J$17/12)","v":""},"",null,"",{"$f":"IF($J123=0,MIN(K$18:K123),$F$9-$C123)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C125=\"\",\"\",IF(SUM(E$19:E124)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F124)=$H$17,$H124=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G125))","v":""},{"$f":"IF(OR(SUM(F$19:F124)=$H$17,$H124=\"\"),\"\",$H124*$J$17/12)","v":""},"",null,"",{"$f":"IF($J124=0,MIN(K$18:K124),$F$9-$C124)","v":{"$error":"#VALUE!"}}]
[365,9,"","",{"$f":"IF(C126=\"\",\"\",IF(SUM(E$19:E125)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F125)=$H$17,$H125=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G126))","v":""},{"$f":"IF(OR(SUM(F$19:F125)=$H$17,$H125=\"\"),\"\",$H125*$J$17/12)","v":""},"",{"$f":"IF(OR(D126=\"\",E126=\"\"),0,IF($H$4=$A$4,(D126+D115)*50%*$J$8+$J$9,$J$9))","v":0},"",{"$f":"IF($J125=0,MIN(K$18:K125),$F$9-$C125)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B115+1","v":10},"","",{"$f":"IF(C127=\"\",\"\",IF(SUM(E$19:E126)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F126)=$H$17,$H126=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G127))","v":""},{"$f":"IF(OR(SUM(F$19:F126)=$H$17,$H126=\"\"),\"\",$H126*$J$17/12)","v":""},"",null,"",{"$f":"IF($J126=0,MIN(K$18:K126),$F$9-$C126)","v":{"$error":"#VALUE!"}}]
[365,{"$f":"B116+1","v":10},"","",{"$f":"IF(C128=\"\",\"\",IF(SUM(E$19:E127)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F127)=$H$17,$H127=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G128))","v":""},{"$f":"IF(OR(SUM(F$19:F127)=$H$17,$H127=\"\"),\"\",$H127*$J$17/12)","v":""},"",null,"",{"$f":"IF($J127=0,MIN(K$18:K127),$F$9-$C127)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C129=\"\",\"\",IF(SUM(E$19:E128)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F128)=$H$17,$H128=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G129))","v":""},{"$f":"IF(OR(SUM(F$19:F128)=$H$17,$H128=\"\"),\"\",$H128*$J$17/12)","v":""},"",null,"",{"$f":"IF($J128=0,MIN(K$18:K128),$F$9-$C128)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C130=\"\",\"\",IF(SUM(E$19:E129)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F129)=$H$17,$H129=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G130))","v":""},{"$f":"IF(OR(SUM(F$19:F129)=$H$17,$H129=\"\"),\"\",$H129*$J$17/12)","v":""},"",null,"",{"$f":"IF($J129=0,MIN(K$18:K129),$F$9-$C129)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C131=\"\",\"\",IF(SUM(E$19:E130)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F130)=$H$17,$H130=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G131))","v":""},{"$f":"IF(OR(SUM(F$19:F130)=$H$17,$H130=\"\"),\"\",$H130*$J$17/12)","v":""},"",null,"",{"$f":"IF($J130=0,MIN(K$18:K130),$F$9-$C130)","v":{"$error":"#VALUE!"}}]
[365,10,"",{"$f":"IF(OR(C131=\"\",E132=\"\"),\"\",D131-E131)","v":""},{"$f":"IF(C132=\"\",\"\",IF(SUM(E$19:E131)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F131)=$H$17,$H131=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G132))","v":""},{"$f":"IF(OR(SUM(F$19:F131)=$H$17,$H131=\"\"),\"\",$H131*$J$17/12)","v":""},"",null,"",{"$f":"IF($J131=0,MIN(K$18:K131),$F$9-$C131)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C133=\"\",\"\",IF(SUM(E$19:E132)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F132)=$H$17,$H132=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G133))","v":""},{"$f":"IF(OR(SUM(F$19:F132)=$H$17,$H132=\"\"),\"\",$H132*$J$17/12)","v":""},"",null,"",{"$f":"IF($J132=0,MIN(K$18:K132),$F$9-$C132)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C134=\"\",\"\",IF(SUM(E$19:E133)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F133)=$H$17,$H133=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G134))","v":""},{"$f":"IF(OR(SUM(F$19:F133)=$H$17,$H133=\"\"),\"\",$H133*$J$17/12)","v":""},"",null,"",{"$f":"IF($J133=0,MIN(K$18:K133),$F$9-$C133)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C135=\"\",\"\",IF(SUM(E$19:E134)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F134)=$H$17,$H134=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G135))","v":""},{"$f":"IF(OR(SUM(F$19:F134)=$H$17,$H134=\"\"),\"\",$H134*$J$17/12)","v":""},"",null,"",{"$f":"IF($J134=0,MIN(K$18:K134),$F$9-$C134)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C136=\"\",\"\",IF(SUM(E$19:E135)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F135)=$H$17,$H135=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G136))","v":""},{"$f":"IF(OR(SUM(F$19:F135)=$H$17,$H135=\"\"),\"\",$H135*$J$17/12)","v":""},"",null,"",{"$f":"IF($J135=0,MIN(K$18:K135),$F$9-$C135)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C137=\"\",\"\",IF(SUM(E$19:E136)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F136)=$H$17,$H136=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G137))","v":""},{"$f":"IF(OR(SUM(F$19:F136)=$H$17,$H136=\"\"),\"\",$H136*$J$17/12)","v":""},"",null,"",{"$f":"IF($J136=0,MIN(K$18:K136),$F$9-$C136)","v":{"$error":"#VALUE!"}}]
[365,10,"","",{"$f":"IF(C138=\"\",\"\",IF(SUM(E$19:E137)+($F$4/(1+$J$6)/$F$9)-1>$F$4/(1+$J$6),\"\",$F$4/(1+$J$6)/$F$9))","v":""},{"$f":"IF(OR(SUM(F$19:F137)=$H$17,$H137=\"\"),\"\",IF($F$8=$A$9,$H$17/$F$6,-PMT($J$17/12,$F$6,$H$17,0,0)-G138))","v":""},{"$f":"IF(OR(SUM(F$19:F137)=$H$17,$H137=\"\"),\"\",$H137*$J$17/12)","v":""},"",{"$f":"IF(OR(D138=\"\",E138=\"\"),0,IF($H$4=$A$4,(D138+D127)*50%*$J$8+$J$9,$J$9))","v":0},"",{"$f":"IF($J137=0,MIN(K$18:K137),$F$9-$C137)","v":{"$error":"#VALUE!"}}]
[null,null,"Итог",null,{"$f":"SUM(E19:E138)","v":3177966.1016949168},{"$f":"SUM(F19:F138)","v":3999999.9999999972},{"$f":"SUM(G19:G138)","v":1233333.3333333344},null,{"$f":"SUM(I19:I138)","v":177701.27118644054},{"$f":"SUM(J19:J138)","v":917800.14124293812},{"$f":"IF($J138=0,MIN(K$18:K138),$F$9-$C138)","v":{"$error":"#VALUE!"}}]
[null,null,"Расчет для схемы лизинг:",null,null,null,null,null,null,null,{"$f":"IF($J139=0,MIN(K$18:K139),$F$9-$C139)","v":{"$error":"#VALUE!"}}]
[null,null,"Собств. средства:",null,{"$f":"$F$4*$F$7+$F$5","v":1100000},"Заемные средства:",null,{"$f":"$F$4*(1-$F$7)","v":4000000},"Ставка по\nлизингу, %",{"$f":"J17+3%","v":0.23},{"$f":"IF($J140=0,MIN(K$18:K140),$F$9-$C140)","v":{"$error":"#REF!"}}]
["Осн.долг","год","№ ","Лизинговый платеж к уплате","в т.ч. НДС","Лизинговый платеж к начислению","в т.ч. НДС","в т.ч. выкупная стоимость","НДС к возмещению","Экономия доходов / прибыли",{"$f":"IF($J141=0,MIN(K$18:K141),$F$9-$C141)","v":{"$error":"#VALUE!"}}]
[{"$f":"$H$141","v":4000000},{"$f":"B19","v":1},1,{"$f":"IF(C143=\"\",\"\",IF($F$8=$A$9,A143*$J$141/12+$H$141/$F$6,-PMT($J$141/12,$F$6,$H$141,0,0)))","v":187777.77777777778},{"$f":"IF(C143=\"\",\"\",D143/(1+$J$6)*$J$6)","v":28644.067796610172},{"$f":"IF(C143=\"\",\"\",D143+($F$4*$F$7)/$F$6)","v":215555.55555555556},{"$f":"IF(C143=\"\",\"\",F143/(1+$J$6)*$J$6)","v":32881.355932203391},{"$f":"IF(C143=\"\",\"\",F143/$F$263*($F$4/(1+$J$6)))","v":142306.56942873442},{"$f":"IF(C143=\"\",\"\",IF($H$4=$A$4,G143,0))","v":32881.355932203391},{"$f":"IF(C143=\"\",\"\",(F143-H143)*IF($H$4=$A$4,$J$5,$J$7)+IF($C143=$F$6,SUM(H$143:H143)*IF($H$4=$A$4,$J$5,$J$7),0))","v":14649.797225364229},{"$f":"IF(#REF!=0,MIN(K$18:K142),$F$9-$C142)","v":{"$error":"#REF!"}}]
[{"$f":"IF(A143-$H$141/$F$6<0,0,A143-$H$141/$F$6)","v":3888888.888888889},{"$f":"B20","v":1},{"$f":"IFERROR(IF(C143+1<=$F$6,C143+1,\"\"),\"\")","v":2},{"$f":"IF(C144=\"\",\"\",IF($F$8=$A$9,A144*$J$141/12+$H$141/$F$6,-PMT($J$141/12,$F$6,$H$141,0,0)))","v":185648.14814814815},{"$f":"IF(C144=\"\",\"\",D144/(1+$J$6)*$J$6)","v":28319.209039548023},{"$f":"IF(C144=\"\",\"\",D144+($F$4*$F$7)/$F$6)","v":213425.92592592593},{"$f":"IF(C144=\"\",\"\",F144/(1+$J$6)*$J$6)","v":32556.497175141241},{"$f":"IF(C144=\"\",\"\",F144/$F$263*($F$4/(1+$J$6)))","v":140900.61964485949},32556.497175141241,{"$f":"IF(C144=\"\",\"\",(F144-H144)*IF($H$4=$A$4,$J$5,$J$7)+IF($C144=$F$6,SUM(H$143:H144)*IF($H$4=$A$4,$J$5,$J$7),0))","v":14505.061256213288},{"$f":"IF(#REF!=0,MIN(K$18:K143),$F$9-$C143)","v":{"$error":"#REF!"}}]
[{"$f":"IF(A144-$H$141/$F$6<0,0,A144-$H$141/$F$6)","v":3777777.777777778},{"$f":"B21","v":1},{"$f":"IFERROR(IF(C144+1<=$F$6,C144+1,\"\"),\"\")","v":3},183518.51851851854,27994.350282485881,211296.29629629632,32231.638418079099,139494.66986098452,32231.638418079099,{"$f":"IF(C145=\"\",\"\",(F145-H145)*IF($H$4=$A$4,$J$5,$J$7)+IF($C145=$F$6,SUM(H$143:H145)*IF($H$4=$A$4,$J$5,$J$7),0))","v":14360.325287062362},{"$f":"IF(#REF!=0,MIN(K$18:K144),$F$9-$C144)","v":{"$error":"#REF!"}}]
[3666666.666666667,{"$f":"B22","v":1},4,181388.88888888891,27669.491525423735,209166.66666666669,31906.779661016953,138088.72007710958,31906.779661016953,{"$f":"IF(C146=\"\",\"\",(F146-H146)*IF($H$4=$A$4,$J$5,$J$7)+IF($C146=$F$6,SUM(H$143:H146)*IF($H$4=$A$4,$J$5,$J$7),0))","v":14215.589317911421},{"$f":"IF(#REF!=0,MIN(K$18:K145),$F$9-$C145)","v":{"$error":"#REF!"}}]
[3555555.555555556,{"$f":"B23","v":1},5,179259.25925925927,27344.632768361585,207037.03703703705,31581.920903954804,136682.77029323461,31581.920903954804,{"$f":"IF(C147=\"\",\"\",(F147-H147)*IF($H$4=$A$4,$J$5,$J$7)+IF($C147=$F$6,SUM(H$143:H147)*IF($H$4=$A$4,$J$5,$J$7),0))","v":14070.853348760487},{"$f":"IF(#REF!=0,MIN(K$18:K146),$F$9-$C146)","v":{"$error":"#REF!"}}]
[3444444.444444445,{"$f":"B24","v":1},6,177129.62962962964,27019.774011299436,204907.40740740742,31257.062146892655,135276.82050935965,31257.062146892655,{"$f":"IF(C148=\"\",\"\",(F148-H148)*IF($H$4=$A$4,$J$5,$J$7)+IF($C148=$F$6,SUM(H$143:H148)*IF($H$4=$A$4,$J$5,$J$7),0))","v":13926.117379609554},{"$f":"IF(#REF!=0,MIN(K$18:K147),$F$9-$C147)","v":{"$error":"#REF!"}}]
[3333333.333333334,{"$f":"B25","v":1},7,175000,26694.91525423729,202777.77777777778,30932.203389830509,133870.87072548468,30932.203389830509,{"$f":"IF(C149=\"\",\"\",(F149-H149)*IF($H$4=$A$4,$J$5,$J$7)+IF($C149=$F$6,SUM(H$143:H149)*IF($H$4=$A$4,$J$5,$J$7),0))","v":13781.38141045862},{"$f":"IF(#REF!=0,MIN(K$18:K148),$F$9-$C148)","v":{"$error":"#REF!"}}]
[3222222.2222222229,{"$f":"B26","v":1},8,172870.37037037039,26370.056497175148,200648.14814814818,30607.344632768363,132464.92094160977,30607.344632768363,{"$f":"IF(C150=\"\",\"\",(F150-H150)*IF($H$4=$A$4,$J$5,$J$7)+IF($C150=$F$6,SUM(H$143:H150)*IF($H$4=$A$4,$J$5,$J$7),0))","v":13636.645441307681},{"$f":"IF(#REF!=0,MIN(K$18:K149),$F$9-$C149)","v":{"$error":"#REF!"}}]
[3111111.1111111119,{"$f":"B27","v":1},9,170740.74074074076,26045.197740112999,198518.51851851854,30282.485875706217,131058.97115773481,30282.485875706217,{"$f":"IF(C151=\"\",\"\",(F151-H151)*IF($H$4=$A$4,$J$5,$J$7)+IF($C151=$F$6,SUM(H$143:H151)*IF($H$4=$A$4,$J$5,$J$7),0))","v":13491.909472156747},{"$f":"IF(#REF!=0,MIN(K$18:K150),$F$9-$C150)","v":{"$error":"#REF!"}}]
[3000000.0000000009,{"$f":"B28","v":1},10,168611.11111111112,25720.338983050849,196388.88888888891,29957.627118644068,129653.02137385984,29957.627118644068,{"$f":"IF(C152=\"\",\"\",(F152-H152)*IF($H$4=$A$4,$J$5,$J$7)+IF($C152=$F$6,SUM(H$143:H152)*IF($H$4=$A$4,$J$5,$J$7),0))","v":13347.173503005813},{"$f":"IF(#REF!=0,MIN(K$18:K151),$F$9-$C151)","v":{"$error":"#REF!"}}]
[2888888.8888888899,{"$f":"B29","v":1},11,166481.48148148152,25395.480225988707,194259.2592592593,29632.768361581926,128247.0715899849,29632.768361581926,{"$f":"IF(C153=\"\",\"\",(F153-H153)*IF($H$4=$A$4,$J$5,$J$7)+IF($C153=$F$6,SUM(H$143:H153)*IF($H$4=$A$4,$J$5,$J$7),0))","v":13202.43753385488},{"$f":"IF(#REF!=0,MIN(K$18:K152),$F$9-$C152)","v":{"$error":"#REF!"}}]
[2777777.7777777789,{"$f":"B30","v":1},12,164351.85185185188,25070.621468926558,192129.62962962966,29307.909604519777,126841.12180610995,29307.909604519777,{"$f":"IF(C154=\"\",\"\",(F154-H154)*IF($H$4=$A$4,$J$5,$J$7)+IF($C154=$F$6,SUM(H$143:H154)*IF($H$4=$A$4,$J$5,$J$7),0))","v":13057.701564703944},{"$f":"IF(#REF!=0,MIN(K$18:K153),$F$9-$C153)","v":{"$error":"#REF!"}}]
[2666666.6666666679,{"$f":"B31","v":2},13,162222.22222222225,24745.762711864412,190000.00000000003,28983.050847457631,125435.17202223498,28983.050847457631,{"$f":"IF(C155=\"\",\"\",(F155-H155)*IF($H$4=$A$4,$J$5,$J$7)+IF($C155=$F$6,SUM(H$143:H155)*IF($H$4=$A$4,$J$5,$J$7),0))","v":12912.965595553011},{"$f":"IF(#REF!=0,MIN(K$18:K154),$F$9-$C154)","v":{"$error":"#REF!"}}]
[2555555.5555555569,{"$f":"B32","v":2},14,160092.59259259261,24420.903954802263,187870.37037037039,28658.192090395482,124029.22223836003,28658.192090395482,{"$f":"IF(C156=\"\",\"\",(F156-H156)*IF($H$4=$A$4,$J$5,$J$7)+IF($C156=$F$6,SUM(H$143:H156)*IF($H$4=$A$4,$J$5,$J$7),0))","v":12768.229626402073},{"$f":"IF(#REF!=0,MIN(K$18:K155),$F$9-$C155)","v":{"$error":"#REF!"}}]
[2444444.4444444459,{"$f":"B33","v":2},15,157962.96296296298,24096.045197740117,185740.74074074076,28333.333333333339,122623.27245448509,28333.333333333339,{"$f":"IF(C157=\"\",\"\",(F157-H157)*IF($H$4=$A$4,$J$5,$J$7)+IF($C157=$F$6,SUM(H$143:H157)*IF($H$4=$A$4,$J$5,$J$7),0))","v":12623.493657251134},{"$f":"IF(#REF!=0,MIN(K$18:K156),$F$9-$C156)","v":{"$error":"#REF!"}}]
[2333333.3333333349,{"$f":"B34","v":2},16,155833.33333333337,23771.186440677971,183611.11111111115,28008.47457627119,121217.32267061014,28008.47457627119,{"$f":"IF(C158=\"\",\"\",(F158-H158)*IF($H$4=$A$4,$J$5,$J$7)+IF($C158=$F$6,SUM(H$143:H158)*IF($H$4=$A$4,$J$5,$J$7),0))","v":12478.757688100202},{"$f":"IF(#REF!=0,MIN(K$18:K157),$F$9-$C157)","v":{"$error":"#REF!"}}]
[2222222.2222222239,{"$f":"B35","v":2},17,153703.70370370374,23446.327683615826,181481.48148148152,27683.615819209044,119811.37288673519,27683.615819209044,{"$f":"IF(C159=\"\",\"\",(F159-H159)*IF($H$4=$A$4,$J$5,$J$7)+IF($C159=$F$6,SUM(H$143:H159)*IF($H$4=$A$4,$J$5,$J$7),0))","v":12334.021718949267},{"$f":"IF(#REF!=0,MIN(K$18:K158),$F$9-$C158)","v":{"$error":"#REF!"}}]
[2111111.1111111129,{"$f":"B36","v":2},18,151574.0740740741,23121.468926553676,179351.85185185188,27358.757062146899,118405.42310286024,27358.757062146899,{"$f":"IF(C160=\"\",\"\",(F160-H160)*IF($H$4=$A$4,$J$5,$J$7)+IF($C160=$F$6,SUM(H$143:H160)*IF($H$4=$A$4,$J$5,$J$7),0))","v":12189.28574979833},{"$f":"IF(#REF!=0,MIN(K$18:K159),$F$9-$C159)","v":{"$error":"#REF!"}}]
[2000000.0000000019,{"$f":"B37","v":2},19,149444.4444444445,22796.610169491534,177222.22222222228,27033.898305084753,116999.4733189853,27033.898305084753,{"$f":"IF(C161=\"\",\"\",(F161-H161)*IF($H$4=$A$4,$J$5,$J$7)+IF($C161=$F$6,SUM(H$143:H161)*IF($H$4=$A$4,$J$5,$J$7),0))","v":12044.549780647396},{"$f":"IF(#REF!=0,MIN(K$18:K160),$F$9-$C160)","v":{"$error":"#REF!"}}]
[1888888.8888888909,{"$f":"B38","v":2},20,147314.81481481486,22471.751412429385,175092.59259259264,26709.039548022611,115593.52353511033,26709.039548022611,{"$f":"IF(C162=\"\",\"\",(F162-H162)*IF($H$4=$A$4,$J$5,$J$7)+IF($C162=$F$6,SUM(H$143:H162)*IF($H$4=$A$4,$J$5,$J$7),0))","v":11899.813811496462},{"$f":"IF(#REF!=0,MIN(K$18:K161),$F$9-$C161)","v":{"$error":"#REF!"}}]
[1777777.7777777798,{"$f":"B39","v":2},21,145185.18518518523,22146.892655367239,172962.96296296301,26384.180790960461,114187.57375123538,26384.180790960461,{"$f":"IF(C163=\"\",\"\",(F163-H163)*IF($H$4=$A$4,$J$5,$J$7)+IF($C163=$F$6,SUM(H$143:H163)*IF($H$4=$A$4,$J$5,$J$7),0))","v":11755.077842345527},{"$f":"IF(#REF!=0,MIN(K$18:K162),$F$9-$C162)","v":{"$error":"#REF!"}}]
[1666666.6666666688,{"$f":"B40","v":2},22,143055.55555555559,21822.03389830509,170833.33333333337,26059.322033898312,112781.62396736041,26059.322033898312,{"$f":"IF(C164=\"\",\"\",(F164-H164)*IF($H$4=$A$4,$J$5,$J$7)+IF($C164=$F$6,SUM(H$143:H164)*IF($H$4=$A$4,$J$5,$J$7),0))","v":11610.341873194593},{"$f":"IF(#REF!=0,MIN(K$18:K163),$F$9-$C163)","v":{"$error":"#REF!"}}]
[1555555.5555555578,{"$f":"B41","v":2},23,140925.92592592596,21497.175141242944,168703.70370370374,25734.463276836166,111375.67418348546,25734.463276836166,{"$f":"IF(C165=\"\",\"\",(F165-H165)*IF($H$4=$A$4,$J$5,$J$7)+IF($C165=$F$6,SUM(H$143:H165)*IF($H$4=$A$4,$J$5,$J$7),0))","v":11465.605904043656},{"$f":"IF(#REF!=0,MIN(K$18:K164),$F$9-$C164)","v":{"$error":"#REF!"}}]
[1444444.4444444468,{"$f":"B42","v":2},24,138796.29629629635,21172.316384180798,166574.07407407413,25409.604519774024,109969.72439961052,25409.604519774024,{"$f":"IF(C166=\"\",\"\",(F166-H166)*IF($H$4=$A$4,$J$5,$J$7)+IF($C166=$F$6,SUM(H$143:H166)*IF($H$4=$A$4,$J$5,$J$7),0))","v":11320.869934892722},{"$f":"IF(#REF!=0,MIN(K$18:K165),$F$9-$C165)","v":{"$error":"#REF!"}}]
[1333333.3333333358,{"$f":"B43","v":3},25,136666.66666666672,20847.457627118649,164444.4444444445,25084.745762711875,108563.77461573556,25084.745762711875,{"$f":"IF(C167=\"\",\"\",(F167-H167)*IF($H$4=$A$4,$J$5,$J$7)+IF($C167=$F$6,SUM(H$143:H167)*IF($H$4=$A$4,$J$5,$J$7),0))","v":11176.133965741788},{"$f":"IF(#REF!=0,MIN(K$18:K166),$F$9-$C166)","v":{"$error":"#REF!"}}]
[1222222.2222222248,{"$f":"B44","v":3},26,134537.03703703708,20522.598870056507,162314.81481481486,24759.887005649725,107157.82483186061,24759.887005649725,{"$f":"IF(C168=\"\",\"\",(F168-H168)*IF($H$4=$A$4,$J$5,$J$7)+IF($C168=$F$6,SUM(H$143:H168)*IF($H$4=$A$4,$J$5,$J$7),0))","v":11031.397996590851},{"$f":"IF(#REF!=0,MIN(K$18:K167),$F$9-$C167)","v":{"$error":"#REF!"}}]
[1111111.1111111138,{"$f":"B45","v":3},27,132407.40740740745,20197.740112994357,160185.18518518523,24435.02824858758,105751.87504798565,24435.02824858758,{"$f":"IF(C169=\"\",\"\",(F169-H169)*IF($H$4=$A$4,$J$5,$J$7)+IF($C169=$F$6,SUM(H$143:H169)*IF($H$4=$A$4,$J$5,$J$7),0))","v":10886.662027439916},{"$f":"IF(#REF!=0,MIN(K$18:K168),$F$9-$C168)","v":{"$error":"#REF!"}}]
[1000000.0000000027,{"$f":"B46","v":3},28,130277.77777777782,19872.881355932212,158055.55555555559,24110.16949152543,104345.9252641107,24110.16949152543,{"$f":"IF(C170=\"\",\"\",(F170-H170)*IF($H$4=$A$4,$J$5,$J$7)+IF($C170=$F$6,SUM(H$143:H170)*IF($H$4=$A$4,$J$5,$J$7),0))","v":10741.926058288978},{"$f":"IF(#REF!=0,MIN(K$18:K169),$F$9-$C169)","v":{"$error":"#REF!"}}]
[888888.88888889155,{"$f":"B47","v":3},29,128148.1481481482,19548.022598870066,155925.92592592599,23785.310734463288,102939.97548023576,23785.310734463288,{"$f":"IF(C171=\"\",\"\",(F171-H171)*IF($H$4=$A$4,$J$5,$J$7)+IF($C171=$F$6,SUM(H$143:H171)*IF($H$4=$A$4,$J$5,$J$7),0))","v":10597.190089138045},{"$f":"IF(#REF!=0,MIN(K$18:K170),$F$9-$C170)","v":{"$error":"#REF!"}}]
[777777.77777778043,{"$f":"B48","v":3},30,126018.51851851857,19223.163841807916,153796.29629629635,23460.451977401139,101534.02569636081,23460.451977401139,{"$f":"IF(C172=\"\",\"\",(F172-H172)*IF($H$4=$A$4,$J$5,$J$7)+IF($C172=$F$6,SUM(H$143:H172)*IF($H$4=$A$4,$J$5,$J$7),0))","v":10452.454119987109},{"$f":"IF(#REF!=0,MIN(K$18:K171),$F$9-$C171)","v":{"$error":"#REF!"}}]
[666666.66666666931,{"$f":"B49","v":3},31,123888.88888888893,18898.305084745771,151666.66666666672,23135.593220338989,100128.07591248585,23135.593220338989,{"$f":"IF(C173=\"\",\"\",(F173-H173)*IF($H$4=$A$4,$J$5,$J$7)+IF($C173=$F$6,SUM(H$143:H173)*IF($H$4=$A$4,$J$5,$J$7),0))","v":10307.718150836175},{"$f":"IF(#REF!=0,MIN(K$18:K172),$F$9-$C172)","v":{"$error":"#REF!"}}]
[555555.55555555818,{"$f":"B50","v":3},32,121759.25925925931,18573.446327683625,149537.03703703708,22810.734463276844,98722.126128610893,22810.734463276844,{"$f":"IF(C174=\"\",\"\",(F174-H174)*IF($H$4=$A$4,$J$5,$J$7)+IF($C174=$F$6,SUM(H$143:H174)*IF($H$4=$A$4,$J$5,$J$7),0))","v":10162.982181685238},{"$f":"IF(#REF!=0,MIN(K$18:K173),$F$9-$C173)","v":{"$error":"#REF!"}}]
[444444.44444444706,{"$f":"B51","v":3},33,119629.62962962968,18248.587570621476,147407.40740740745,22485.875706214694,97316.176344735926,{"$f":"IF(C175=\"\",\"\",IF($H$4=$A$4,G175,0))","v":22485.875706214694},{"$f":"IF(C175=\"\",\"\",(F175-H175)*IF($H$4=$A$4,$J$5,$J$7)+IF($C175=$F$6,SUM(H$143:H175)*IF($H$4=$A$4,$J$5,$J$7),0))","v":10018.246212534305},{"$f":"IF(#REF!=0,MIN(K$18:K174),$F$9-$C174)","v":{"$error":"#REF!"}}]
[333333.33333333593,{"$f":"B52","v":3},34,117500.00000000004,17923.72881355933,145277.77777777781,22161.016949152548,95910.226560860974,22161.016949152548,{"$f":"IF(C176=\"\",\"\",(F176-H176)*IF($H$4=$A$4,$J$5,$J$7)+IF($C176=$F$6,SUM(H$143:H176)*IF($H$4=$A$4,$J$5,$J$7),0))","v":9873.5102433833672},{"$f":"IF(#REF!=0,MIN(K$18:K175),$F$9-$C175)","v":{"$error":"#REF!"}}]
[222222.22222222481,{"$f":"B53","v":3},35,115370.37037037042,17598.870056497184,143148.1481481482,21836.158192090403,94504.276776986037,21836.158192090403,{"$f":"IF(C177=\"\",\"\",(F177-H177)*IF($H$4=$A$4,$J$5,$J$7)+IF($C177=$F$6,SUM(H$143:H177)*IF($H$4=$A$4,$J$5,$J$7),0))","v":9728.7742742324335},{"$f":"IF(#REF!=0,MIN(K$18:K176),$F$9-$C176)","v":{"$error":"#REF!"}}]
[111111.1111111137,{"$f":"B54","v":3},36,113240.74074074079,17274.011299435035,141018.51851851857,21511.299435028257,93098.32699311107,21511.299435028257,{"$f":"IF(C178=\"\",\"\",(F178-H178)*IF($H$4=$A$4,$J$5,$J$7)+IF($C178=$F$6,SUM(H$143:H178)*IF($H$4=$A$4,$J$5,$J$7),0))","v":857041.66542372538},{"$f":"IF(#REF!=0,MIN(K$18:K177),$F$9-$C177)","v":{"$error":"#REF!"}}]
[2.5902409106492996E-9,{"$f":"B55","v":4},"","","","","","","",{"$f":"IF(C179=\"\",\"\",(F179-H179)*IF($H$4=$A$4,$J$5,$J$7)+IF($C179=$F$6,SUM(H$143:H179)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K178),$F$9-$C178)","v":{"$error":"#REF!"}}]
[0,{"$f":"B56","v":4},"","","","","","","",{"$f":"IF(C180=\"\",\"\",(F180-H180)*IF($H$4=$A$4,$J$5,$J$7)+IF($C180=$F$6,SUM(H$143:H180)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K179),$F$9-$C179)","v":{"$error":"#REF!"}}]
[0,{"$f":"B57","v":4},"","","","","","","",{"$f":"IF(C181=\"\",\"\",(F181-H181)*IF($H$4=$A$4,$J$5,$J$7)+IF($C181=$F$6,SUM(H$143:H181)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K180),$F$9-$C180)","v":{"$error":"#REF!"}}]
[0,{"$f":"B58","v":4},"","","","","","","",{"$f":"IF(C182=\"\",\"\",(F182-H182)*IF($H$4=$A$4,$J$5,$J$7)+IF($C182=$F$6,SUM(H$143:H182)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K181),$F$9-$C181)","v":{"$error":"#REF!"}}]
[0,{"$f":"B59","v":4},"","","","","","","",{"$f":"IF(C183=\"\",\"\",(F183-H183)*IF($H$4=$A$4,$J$5,$J$7)+IF($C183=$F$6,SUM(H$143:H183)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K182),$F$9-$C182)","v":{"$error":"#REF!"}}]
[0,{"$f":"B60","v":4},"","","","","","","",{"$f":"IF(C184=\"\",\"\",(F184-H184)*IF($H$4=$A$4,$J$5,$J$7)+IF($C184=$F$6,SUM(H$143:H184)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K183),$F$9-$C183)","v":{"$error":"#REF!"}}]
[0,{"$f":"B61","v":4},"","","","","","","",{"$f":"IF(C185=\"\",\"\",(F185-H185)*IF($H$4=$A$4,$J$5,$J$7)+IF($C185=$F$6,SUM(H$143:H185)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K184),$F$9-$C184)","v":{"$error":"#REF!"}}]
[0,{"$f":"B62","v":4},"","","","","","","",{"$f":"IF(C186=\"\",\"\",(F186-H186)*IF($H$4=$A$4,$J$5,$J$7)+IF($C186=$F$6,SUM(H$143:H186)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K185),$F$9-$C185)","v":{"$error":"#REF!"}}]
[0,{"$f":"B63","v":4},"","","","","","","",{"$f":"IF(C187=\"\",\"\",(F187-H187)*IF($H$4=$A$4,$J$5,$J$7)+IF($C187=$F$6,SUM(H$143:H187)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K186),$F$9-$C186)","v":{"$error":"#REF!"}}]
[0,{"$f":"B64","v":4},"","","","","","","",{"$f":"IF(C188=\"\",\"\",(F188-H188)*IF($H$4=$A$4,$J$5,$J$7)+IF($C188=$F$6,SUM(H$143:H188)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K187),$F$9-$C187)","v":{"$error":"#REF!"}}]
[0,{"$f":"B65","v":4},"","","","","","","",{"$f":"IF(C189=\"\",\"\",(F189-H189)*IF($H$4=$A$4,$J$5,$J$7)+IF($C189=$F$6,SUM(H$143:H189)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K188),$F$9-$C188)","v":{"$error":"#REF!"}}]
[0,{"$f":"B66","v":4},"","","","","","","",{"$f":"IF(C190=\"\",\"\",(F190-H190)*IF($H$4=$A$4,$J$5,$J$7)+IF($C190=$F$6,SUM(H$143:H190)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K189),$F$9-$C189)","v":{"$error":"#REF!"}}]
[0,{"$f":"B67","v":5},"","","","","","","",{"$f":"IF(C191=\"\",\"\",(F191-H191)*IF($H$4=$A$4,$J$5,$J$7)+IF($C191=$F$6,SUM(H$143:H191)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K190),$F$9-$C190)","v":{"$error":"#REF!"}}]
[0,{"$f":"B68","v":5},"","","","","","","",{"$f":"IF(C192=\"\",\"\",(F192-H192)*IF($H$4=$A$4,$J$5,$J$7)+IF($C192=$F$6,SUM(H$143:H192)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K191),$F$9-$C191)","v":{"$error":"#REF!"}}]
[0,{"$f":"B69","v":5},"","","","","","","",{"$f":"IF(C193=\"\",\"\",(F193-H193)*IF($H$4=$A$4,$J$5,$J$7)+IF($C193=$F$6,SUM(H$143:H193)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K192),$F$9-$C192)","v":{"$error":"#REF!"}}]
[0,{"$f":"B70","v":5},"","","","","","","",{"$f":"IF(C194=\"\",\"\",(F194-H194)*IF($H$4=$A$4,$J$5,$J$7)+IF($C194=$F$6,SUM(H$143:H194)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K193),$F$9-$C193)","v":{"$error":"#REF!"}}]
[0,{"$f":"B71","v":5},"","","","","","","",{"$f":"IF(C195=\"\",\"\",(F195-H195)*IF($H$4=$A$4,$J$5,$J$7)+IF($C195=$F$6,SUM(H$143:H195)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K194),$F$9-$C194)","v":{"$error":"#REF!"}}]
[0,{"$f":"B72","v":5},"","","","","","","",{"$f":"IF(C196=\"\",\"\",(F196-H196)*IF($H$4=$A$4,$J$5,$J$7)+IF($C196=$F$6,SUM(H$143:H196)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K195),$F$9-$C195)","v":{"$error":"#REF!"}}]
[0,{"$f":"B73","v":5},"","","","","","","",{"$f":"IF(C197=\"\",\"\",(F197-H197)*IF($H$4=$A$4,$J$5,$J$7)+IF($C197=$F$6,SUM(H$143:H197)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K196),$F$9-$C196)","v":{"$error":"#REF!"}}]
[0,{"$f":"B74","v":5},"","","","","","","",{"$f":"IF(C198=\"\",\"\",(F198-H198)*IF($H$4=$A$4,$J$5,$J$7)+IF($C198=$F$6,SUM(H$143:H198)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K197),$F$9-$C197)","v":{"$error":"#REF!"}}]
[0,{"$f":"B75","v":5},"","","","","","","",{"$f":"IF(C199=\"\",\"\",(F199-H199)*IF($H$4=$A$4,$J$5,$J$7)+IF($C199=$F$6,SUM(H$143:H199)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K198),$F$9-$C198)","v":{"$error":"#REF!"}}]
[0,{"$f":"B76","v":5},"","","","","","","",{"$f":"IF(C200=\"\",\"\",(F200-H200)*IF($H$4=$A$4,$J$5,$J$7)+IF($C200=$F$6,SUM(H$143:H200)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K199),$F$9-$C199)","v":{"$error":"#REF!"}}]
[0,{"$f":"B77","v":5},"","","","","","","",{"$f":"IF(C201=\"\",\"\",(F201-H201)*IF($H$4=$A$4,$J$5,$J$7)+IF($C201=$F$6,SUM(H$143:H201)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K200),$F$9-$C200)","v":{"$error":"#REF!"}}]
[0,{"$f":"B78","v":5},"","","","","","","",{"$f":"IF(C202=\"\",\"\",(F202-H202)*IF($H$4=$A$4,$J$5,$J$7)+IF($C202=$F$6,SUM(H$143:H202)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K201),$F$9-$C201)","v":{"$error":"#REF!"}}]
[0,{"$f":"B79","v":6},"","","","","","","",{"$f":"IF(C203=\"\",\"\",(F203-H203)*IF($H$4=$A$4,$J$5,$J$7)+IF($C203=$F$6,SUM(H$143:H203)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K202),$F$9-$C202)","v":{"$error":"#REF!"}}]
[0,{"$f":"B80","v":6},"","","","","","","",{"$f":"IF(C204=\"\",\"\",(F204-H204)*IF($H$4=$A$4,$J$5,$J$7)+IF($C204=$F$6,SUM(H$143:H204)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K203),$F$9-$C203)","v":{"$error":"#REF!"}}]
[0,{"$f":"B81","v":6},"","","","","","","",{"$f":"IF(C205=\"\",\"\",(F205-H205)*IF($H$4=$A$4,$J$5,$J$7)+IF($C205=$F$6,SUM(H$143:H205)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K204),$F$9-$C204)","v":{"$error":"#REF!"}}]
[0,{"$f":"B82","v":6},"","","","","","","",{"$f":"IF(C206=\"\",\"\",(F206-H206)*IF($H$4=$A$4,$J$5,$J$7)+IF($C206=$F$6,SUM(H$143:H206)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K205),$F$9-$C205)","v":{"$error":"#REF!"}}]
[0,{"$f":"B83","v":6},"","","","","","",{"$f":"IF(C207=\"\",\"\",IF($H$4=$A$4,G207,0))","v":""},{"$f":"IF(C207=\"\",\"\",(F207-H207)*IF($H$4=$A$4,$J$5,$J$7)+IF($C207=$F$6,SUM(H$143:H207)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K206),$F$9-$C206)","v":{"$error":"#REF!"}}]
[0,{"$f":"B84","v":6},"",{"$f":"IF(C208=\"\",\"\",IF($F$8=$A$9,A208*$J$141/12+$H$141/$F$6,-PMT($J$141/12,$F$6,$H$141,0,0)))","v":""},{"$f":"IF(C208=\"\",\"\",D208/(1+$J$6)*$J$6)","v":""},{"$f":"IF(C208=\"\",\"\",D208+($F$4*$F$7)/$F$6)","v":""},{"$f":"IF(C208=\"\",\"\",F208/(1+$J$6)*$J$6)","v":""},{"$f":"IF(C208=\"\",\"\",F208/$F$263*($F$4/(1+$J$6)))","v":""},"",{"$f":"IF(C208=\"\",\"\",(F208-H208)*IF($H$4=$A$4,$J$5,$J$7)+IF($C208=$F$6,SUM(H$143:H208)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K207),$F$9-$C207)","v":{"$error":"#REF!"}}]
[{"$f":"IF(A208-$H$141/$F$6<0,0,A208-$H$141/$F$6)","v":0},{"$f":"B85","v":6},{"$f":"IFERROR(IF(C208+1<=$F$6,C208+1,\"\"),\"\")","v":""},"","","","","","",{"$f":"IF(C209=\"\",\"\",(F209-H209)*IF($H$4=$A$4,$J$5,$J$7)+IF($C209=$F$6,SUM(H$143:H209)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K208),$F$9-$C208)","v":{"$error":"#REF!"}}]
[0,{"$f":"B86","v":6},"","","","","","","",{"$f":"IF(C210=\"\",\"\",(F210-H210)*IF($H$4=$A$4,$J$5,$J$7)+IF($C210=$F$6,SUM(H$143:H210)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K209),$F$9-$C209)","v":{"$error":"#REF!"}}]
[0,{"$f":"B87","v":6},"","","","","","","",{"$f":"IF(C211=\"\",\"\",(F211-H211)*IF($H$4=$A$4,$J$5,$J$7)+IF($C211=$F$6,SUM(H$143:H211)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K210),$F$9-$C210)","v":{"$error":"#REF!"}}]
[0,{"$f":"B88","v":6},"","","","","","","",{"$f":"IF(C212=\"\",\"\",(F212-H212)*IF($H$4=$A$4,$J$5,$J$7)+IF($C212=$F$6,SUM(H$143:H212)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K211),$F$9-$C211)","v":{"$error":"#REF!"}}]
[0,{"$f":"B89","v":6},"","","","","","","",{"$f":"IF(C213=\"\",\"\",(F213-H213)*IF($H$4=$A$4,$J$5,$J$7)+IF($C213=$F$6,SUM(H$143:H213)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K212),$F$9-$C212)","v":{"$error":"#REF!"}}]
[0,{"$f":"B90","v":6},"","","","","","","",{"$f":"IF(C214=\"\",\"\",(F214-H214)*IF($H$4=$A$4,$J$5,$J$7)+IF($C214=$F$6,SUM(H$143:H214)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K213),$F$9-$C213)","v":{"$error":"#REF!"}}]
[0,{"$f":"B91","v":7},"","","","","","","",{"$f":"IF(C215=\"\",\"\",(F215-H215)*IF($H$4=$A$4,$J$5,$J$7)+IF($C215=$F$6,SUM(H$143:H215)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K214),$F$9-$C214)","v":{"$error":"#REF!"}}]
[0,{"$f":"B92","v":7},"","","","","","","",{"$f":"IF(C216=\"\",\"\",(F216-H216)*IF($H$4=$A$4,$J$5,$J$7)+IF($C216=$F$6,SUM(H$143:H216)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K215),$F$9-$C215)","v":{"$error":"#REF!"}}]
[0,{"$f":"B93","v":7},"","","","","","","",{"$f":"IF(C217=\"\",\"\",(F217-H217)*IF($H$4=$A$4,$J$5,$J$7)+IF($C217=$F$6,SUM(H$143:H217)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K216),$F$9-$C216)","v":{"$error":"#REF!"}}]
[0,{"$f":"B94","v":7},"","","","","","","",{"$f":"IF(C218=\"\",\"\",(F218-H218)*IF($H$4=$A$4,$J$5,$J$7)+IF($C218=$F$6,SUM(H$143:H218)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K217),$F$9-$C217)","v":{"$error":"#REF!"}}]
[0,{"$f":"B95","v":7},"","","","","","","",{"$f":"IF(C219=\"\",\"\",(F219-H219)*IF($H$4=$A$4,$J$5,$J$7)+IF($C219=$F$6,SUM(H$143:H219)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K218),$F$9-$C218)","v":{"$error":"#REF!"}}]
[0,{"$f":"B96","v":7},"","","","","","","",{"$f":"IF(C220=\"\",\"\",(F220-H220)*IF($H$4=$A$4,$J$5,$J$7)+IF($C220=$F$6,SUM(H$143:H220)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K219),$F$9-$C219)","v":{"$error":"#REF!"}}]
[0,{"$f":"B97","v":7},"","","","","","","",{"$f":"IF(C221=\"\",\"\",(F221-H221)*IF($H$4=$A$4,$J$5,$J$7)+IF($C221=$F$6,SUM(H$143:H221)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K220),$F$9-$C220)","v":{"$error":"#REF!"}}]
[0,{"$f":"B98","v":7},"","","","","","","",{"$f":"IF(C222=\"\",\"\",(F222-H222)*IF($H$4=$A$4,$J$5,$J$7)+IF($C222=$F$6,SUM(H$143:H222)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K221),$F$9-$C221)","v":{"$error":"#REF!"}}]
[0,{"$f":"B99","v":7},"","","","","","","",{"$f":"IF(C223=\"\",\"\",(F223-H223)*IF($H$4=$A$4,$J$5,$J$7)+IF($C223=$F$6,SUM(H$143:H223)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K222),$F$9-$C222)","v":{"$error":"#REF!"}}]
[0,{"$f":"B100","v":7},"","","","","","","",{"$f":"IF(C224=\"\",\"\",(F224-H224)*IF($H$4=$A$4,$J$5,$J$7)+IF($C224=$F$6,SUM(H$143:H224)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K223),$F$9-$C223)","v":{"$error":"#REF!"}}]
[0,{"$f":"B101","v":7},"","","","","","","",{"$f":"IF(C225=\"\",\"\",(F225-H225)*IF($H$4=$A$4,$J$5,$J$7)+IF($C225=$F$6,SUM(H$143:H225)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K224),$F$9-$C224)","v":{"$error":"#REF!"}}]
[0,{"$f":"B102","v":7},"","","","","","","",{"$f":"IF(C226=\"\",\"\",(F226-H226)*IF($H$4=$A$4,$J$5,$J$7)+IF($C226=$F$6,SUM(H$143:H226)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K225),$F$9-$C225)","v":{"$error":"#REF!"}}]
[0,{"$f":"B103","v":8},"","","","","","","",{"$f":"IF(C227=\"\",\"\",(F227-H227)*IF($H$4=$A$4,$J$5,$J$7)+IF($C227=$F$6,SUM(H$143:H227)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K226),$F$9-$C226)","v":{"$error":"#REF!"}}]
[0,{"$f":"B104","v":8},"","","","","","","",{"$f":"IF(C228=\"\",\"\",(F228-H228)*IF($H$4=$A$4,$J$5,$J$7)+IF($C228=$F$6,SUM(H$143:H228)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K227),$F$9-$C227)","v":{"$error":"#REF!"}}]
[0,{"$f":"B105","v":8},"","","","","","","",{"$f":"IF(C229=\"\",\"\",(F229-H229)*IF($H$4=$A$4,$J$5,$J$7)+IF($C229=$F$6,SUM(H$143:H229)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K228),$F$9-$C228)","v":{"$error":"#REF!"}}]
[0,{"$f":"B106","v":8},"","","","","","","",{"$f":"IF(C230=\"\",\"\",(F230-H230)*IF($H$4=$A$4,$J$5,$J$7)+IF($C230=$F$6,SUM(H$143:H230)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K229),$F$9-$C229)","v":{"$error":"#REF!"}}]
[0,{"$f":"B107","v":8},"","","","","","","",{"$f":"IF(C231=\"\",\"\",(F231-H231)*IF($H$4=$A$4,$J$5,$J$7)+IF($C231=$F$6,SUM(H$143:H231)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K230),$F$9-$C230)","v":{"$error":"#REF!"}}]
[0,{"$f":"B108","v":8},"","","","","","","",{"$f":"IF(C232=\"\",\"\",(F232-H232)*IF($H$4=$A$4,$J$5,$J$7)+IF($C232=$F$6,SUM(H$143:H232)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K231),$F$9-$C231)","v":{"$error":"#REF!"}}]
[0,{"$f":"B109","v":8},"","","","","","","",{"$f":"IF(C233=\"\",\"\",(F233-H233)*IF($H$4=$A$4,$J$5,$J$7)+IF($C233=$F$6,SUM(H$143:H233)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K232),$F$9-$C232)","v":{"$error":"#REF!"}}]
[0,{"$f":"B110","v":8},"","","","","","","",{"$f":"IF(C234=\"\",\"\",(F234-H234)*IF($H$4=$A$4,$J$5,$J$7)+IF($C234=$F$6,SUM(H$143:H234)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K233),$F$9-$C233)","v":{"$error":"#REF!"}}]
[0,{"$f":"B111","v":8},"","","","","","","",{"$f":"IF(C235=\"\",\"\",(F235-H235)*IF($H$4=$A$4,$J$5,$J$7)+IF($C235=$F$6,SUM(H$143:H235)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K234),$F$9-$C234)","v":{"$error":"#REF!"}}]
[0,{"$f":"B112","v":8},"","","","","","","",{"$f":"IF(C236=\"\",\"\",(F236-H236)*IF($H$4=$A$4,$J$5,$J$7)+IF($C236=$F$6,SUM(H$143:H236)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K235),$F$9-$C235)","v":{"$error":"#REF!"}}]
[0,{"$f":"B113","v":8},"","","","","","","",{"$f":"IF(C237=\"\",\"\",(F237-H237)*IF($H$4=$A$4,$J$5,$J$7)+IF($C237=$F$6,SUM(H$143:H237)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K236),$F$9-$C236)","v":{"$error":"#REF!"}}]
[0,{"$f":"B114","v":8},"","","","","","","",{"$f":"IF(C238=\"\",\"\",(F238-H238)*IF($H$4=$A$4,$J$5,$J$7)+IF($C238=$F$6,SUM(H$143:H238)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K237),$F$9-$C237)","v":{"$error":"#REF!"}}]
[0,{"$f":"B115","v":9},"","","","","","",{"$f":"IF(C239=\"\",\"\",IF($H$4=$A$4,G239,0))","v":""},{"$f":"IF(C239=\"\",\"\",(F239-H239)*IF($H$4=$A$4,$J$5,$J$7)+IF($C239=$F$6,SUM(H$143:H239)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K238),$F$9-$C238)","v":{"$error":"#REF!"}}]
[0,{"$f":"B116","v":9},"","","","","","","",{"$f":"IF(C240=\"\",\"\",(F240-H240)*IF($H$4=$A$4,$J$5,$J$7)+IF($C240=$F$6,SUM(H$143:H240)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K239),$F$9-$C239)","v":{"$error":"#REF!"}}]
[0,{"$f":"B117","v":9},"","","","","","","",{"$f":"IF(C241=\"\",\"\",(F241-H241)*IF($H$4=$A$4,$J$5,$J$7)+IF($C241=$F$6,SUM(H$143:H241)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K240),$F$9-$C240)","v":{"$error":"#REF!"}}]
[0,{"$f":"B118","v":9},"","","","","","","",{"$f":"IF(C242=\"\",\"\",(F242-H242)*IF($H$4=$A$4,$J$5,$J$7)+IF($C242=$F$6,SUM(H$143:H242)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K241),$F$9-$C241)","v":{"$error":"#REF!"}}]
[0,{"$f":"B119","v":9},"","","","","","","",{"$f":"IF(C243=\"\",\"\",(F243-H243)*IF($H$4=$A$4,$J$5,$J$7)+IF($C243=$F$6,SUM(H$143:H243)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K242),$F$9-$C242)","v":{"$error":"#REF!"}}]
[0,{"$f":"B120","v":9},"","","","","","","",{"$f":"IF(C244=\"\",\"\",(F244-H244)*IF($H$4=$A$4,$J$5,$J$7)+IF($C244=$F$6,SUM(H$143:H244)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K243),$F$9-$C243)","v":{"$error":"#REF!"}}]
[0,{"$f":"B121","v":9},"","","","","","","",{"$f":"IF(C245=\"\",\"\",(F245-H245)*IF($H$4=$A$4,$J$5,$J$7)+IF($C245=$F$6,SUM(H$143:H245)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K244),$F$9-$C244)","v":{"$error":"#REF!"}}]
[0,{"$f":"B122","v":9},"","","","","","","",{"$f":"IF(C246=\"\",\"\",(F246-H246)*IF($H$4=$A$4,$J$5,$J$7)+IF($C246=$F$6,SUM(H$143:H246)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K245),$F$9-$C245)","v":{"$error":"#REF!"}}]
[0,{"$f":"B123","v":9},"","","","","","","",{"$f":"IF(C247=\"\",\"\",(F247-H247)*IF($H$4=$A$4,$J$5,$J$7)+IF($C247=$F$6,SUM(H$143:H247)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K246),$F$9-$C246)","v":{"$error":"#REF!"}}]
[0,{"$f":"B124","v":9},"","","","","","","",{"$f":"IF(C248=\"\",\"\",(F248-H248)*IF($H$4=$A$4,$J$5,$J$7)+IF($C248=$F$6,SUM(H$143:H248)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K247),$F$9-$C247)","v":{"$error":"#REF!"}}]
[0,{"$f":"B125","v":9},"","","","","","","",{"$f":"IF(C249=\"\",\"\",(F249-H249)*IF($H$4=$A$4,$J$5,$J$7)+IF($C249=$F$6,SUM(H$143:H249)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K248),$F$9-$C248)","v":{"$error":"#REF!"}}]
[0,{"$f":"B126","v":9},"","","","","","","",{"$f":"IF(C250=\"\",\"\",(F250-H250)*IF($H$4=$A$4,$J$5,$J$7)+IF($C250=$F$6,SUM(H$143:H250)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K249),$F$9-$C249)","v":{"$error":"#REF!"}}]
[0,{"$f":"B127","v":10},"","","","","","","",{"$f":"IF(C251=\"\",\"\",(F251-H251)*IF($H$4=$A$4,$J$5,$J$7)+IF($C251=$F$6,SUM(H$143:H251)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K250),$F$9-$C250)","v":{"$error":"#REF!"}}]
[0,{"$f":"B128","v":10},"","","","","","","",{"$f":"IF(C252=\"\",\"\",(F252-H252)*IF($H$4=$A$4,$J$5,$J$7)+IF($C252=$F$6,SUM(H$143:H252)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K251),$F$9-$C251)","v":{"$error":"#REF!"}}]
[0,{"$f":"B129","v":10},"","","","","","","",{"$f":"IF(C253=\"\",\"\",(F253-H253)*IF($H$4=$A$4,$J$5,$J$7)+IF($C253=$F$6,SUM(H$143:H253)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K252),$F$9-$C252)","v":{"$error":"#REF!"}}]
[0,{"$f":"B130","v":10},"","","","","","","",{"$f":"IF(C254=\"\",\"\",(F254-H254)*IF($H$4=$A$4,$J$5,$J$7)+IF($C254=$F$6,SUM(H$143:H254)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K253),$F$9-$C253)","v":{"$error":"#REF!"}}]
[0,{"$f":"B131","v":10},"","","","","","","",{"$f":"IF(C255=\"\",\"\",(F255-H255)*IF($H$4=$A$4,$J$5,$J$7)+IF($C255=$F$6,SUM(H$143:H255)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K254),$F$9-$C254)","v":{"$error":"#REF!"}}]
[0,{"$f":"B132","v":10},"","","","","","","",{"$f":"IF(C256=\"\",\"\",(F256-H256)*IF($H$4=$A$4,$J$5,$J$7)+IF($C256=$F$6,SUM(H$143:H256)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K255),$F$9-$C255)","v":{"$error":"#REF!"}}]
[0,{"$f":"B133","v":10},"","","","","","","",{"$f":"IF(C257=\"\",\"\",(F257-H257)*IF($H$4=$A$4,$J$5,$J$7)+IF($C257=$F$6,SUM(H$143:H257)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K256),$F$9-$C256)","v":{"$error":"#REF!"}}]
[0,{"$f":"B134","v":10},"","","","","","","",{"$f":"IF(C258=\"\",\"\",(F258-H258)*IF($H$4=$A$4,$J$5,$J$7)+IF($C258=$F$6,SUM(H$143:H258)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""},{"$f":"IF(#REF!=0,MIN(K$18:K257),$F$9-$C257)","v":{"$error":"#REF!"}}]
[0,{"$f":"B135","v":10},"","","","","","","",{"$f":"IF(C259=\"\",\"\",(F259-H259)*IF($H$4=$A$4,$J$5,$J$7)+IF($C259=$F$6,SUM(H$143:H259)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""}]
[0,{"$f":"B136","v":10},"","","","","","","",{"$f":"IF(C260=\"\",\"\",(F260-H260)*IF($H$4=$A$4,$J$5,$J$7)+IF($C260=$F$6,SUM(H$143:H260)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""}]
[0,{"$f":"B137","v":10},"","","","","","","",{"$f":"IF(C261=\"\",\"\",(F261-H261)*IF($H$4=$A$4,$J$5,$J$7)+IF($C261=$F$6,SUM(H$143:H261)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""}]
[0,{"$f":"B138","v":10},"","","","","","","",{"$f":"IF(C262=\"\",\"\",(F262-H262)*IF($H$4=$A$4,$J$5,$J$7)+IF($C262=$F$6,SUM(H$143:H262)*IF($H$4=$A$4,$J$5,$J$7),0))","v":""}]
[null,null,"Итог",{"$f":"SUM(D143:D262)","v":5418333.3333333349},826525.42372881388,6418333.3333333367,979067.79661016958,4237288.1355932187,979067.79661016958,1283666.666666667]