{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Zag_shema","CASH","калькулятор платежів","окупность "],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":23,"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":"Zag_shema","index":0,"n_rows":255,"n_cols":5,"rows_kept":255,"cut":false,"hidden":true,"merged":[]}
["Власний внесок, %",{"$f":"'калькулятор платежів'!B7","v":0.5}]
["Сума кредиту",{"$f":"B3-B3*B1","v":265000}]
["Вартість ТЗ",{"$f":"'калькулятор платежів'!B6","v":530000}]
["Строк кредитування у місяцях",{"$f":"'калькулятор платежів'!B13","v":36}]
["Коміссія від вартості",0]
["Комісія від суми кредиту",0.02]
["Ставка кредитування",{"$f":"'калькулятор платежів'!B12","v":0.1799}]
[]
["Планова сума комісій",{"$f":"B2*B6+B3*B5","v":5300}]
["Планова сума відсотків",{"$f":"SUM(D16:D255)","v":73496.645833333241}]
["Середній залишок заборгованості",{"$f":"(SUM(B16:B255)+B2)/B4","v":136180.55555555539}]
["Сукупна дохідність за операцією",{"$f":"(B10+B9)/B11/(B4/12)","v":0.19287297297297298}]
[" в т.ч. без комісій від вартості ТЗ",{"$f":"((B2*B6+B10)/B11)/(B4/12)","v":0.19287297297297298}]
[]
["Місяць","Залишок заборгованості на кінець періоду","Погашення основної суми","Сума відсотків","Платіж"]
[1,{"$f":"IF((B2-C16)<=0,0,B2-C16)","v":257638.88888888888},{"$f":"IF(($B$2/$B$4)<=0,0,$B$2/$B$4)","v":7361.1111111111113},{"$f":"IF((B2*$B$7/12)<=0,0,B2*$B$7/12)","v":3972.7916666666665},{"$f":"IF((D16+C16)<=0,0,D16+C16)","v":11333.902777777777}]
[2,{"$f":"IF((B16-C17)<=0,0,B16-C17)","v":250277.77777777775},{"$f":"IF(($B$2/$B$4)<=0,0,$B$2/$B$4)","v":7361.1111111111113},{"$f":"IF((B16*$B$7/12)<=0,0,B16*$B$7/12)","v":3862.4363425925926},{"$f":"IF((D17+C17)<=0,0,D17+C17)","v":11223.547453703704}]
[3,{"$f":"IF((B17-C18)<=0,0,B17-C18)","v":242916.66666666663},{"$f":"IF(($B$2/$B$4)<=0,0,$B$2/$B$4)","v":7361.1111111111113},3752.0810185185182,11113.19212962963]
[4,235555.5555555555,7361.1111111111113,3641.7256944444439,11002.836805555555]
[5,228194.44444444438,7361.1111111111113,3531.37037037037,10892.481481481482]
[6,220833.33333333326,7361.1111111111113,3421.0150462962956,10782.126157407407]
[7,213472.22222222213,7361.1111111111113,3310.6597222222213,10671.770833333332]
[8,206111.11111111101,7361.1111111111113,3200.3043981481464,10561.415509259257]
[9,198749.99999999988,7361.1111111111113,3089.9490740740725,10451.060185185184]
[10,191388.88888888876,7361.1111111111113,2979.5937499999982,10340.704861111109]
[11,184027.77777777764,7361.1111111111113,2869.2384259259238,10230.349537037035]
[12,176666.66666666651,7361.1111111111113,2758.8831018518499,10119.994212962962]
[13,169305.55555555539,7361.1111111111113,2648.5277777777756,10009.638888888887]
[14,161944.44444444426,7361.1111111111113,2538.1724537037012,9899.2835648148121]
[15,154583.33333333314,7361.1111111111113,2427.8171296296268,9788.9282407407372]
[16,147222.22222222202,7361.1111111111113,2317.4618055555525,9678.5729166666642]
[17,139861.11111111089,7361.1111111111113,2207.1064814814786,9568.2175925925894]
[18,132499.99999999977,7361.1111111111113,2096.7511574074042,9457.8622685185146]
[19,125138.88888888866,7361.1111111111113,1986.3958333333301,9347.5069444444416]
[20,117777.77777777755,7361.1111111111113,1876.0405092592557,9237.1516203703668]
[21,110416.66666666644,7361.1111111111113,1765.6851851851818,9126.7962962962938]
[22,103055.55555555533,7361.1111111111113,1655.3298611111077,9016.440972222219]
[23,95694.44444444422,7361.1111111111113,1544.9745370370338,8906.085648148146]
[24,88333.33333333311,7361.1111111111113,1434.6192129629596,8795.7303240740712]
[25,80972.222222222001,7361.1111111111113,1324.2638888888855,8685.3749999999964]
[26,73611.111111110891,7361.1111111111113,1213.9085648148116,8575.0196759259234]
[27,66249.999999999782,7361.1111111111113,1103.5532407407375,8464.6643518518486]
[28,58888.888888888672,7361.1111111111113,993.19791666666345,8354.3090277777756]
[29,51527.777777777563,7361.1111111111113,882.84259259258943,8243.9537037037007]
[30,44166.666666666453,7361.1111111111113,772.48726851851541,8133.5983796296268]
[31,36805.555555555344,7361.1111111111113,662.13194444444127,8023.2430555555529]
[32,29444.444444444234,7361.1111111111113,551.77662037036714,7912.8877314814781]
[33,22083.333333333125,7361.1111111111113,441.42129629629312,7802.5324074074042]
[34,14722.222222222013,7361.1111111111113,331.0659722222191,7692.1770833333303]
[35,7361.1111111109021,7361.1111111111113,220.710648148145,7581.8217592592564]
[36,0,7361.1111111111113,110.35532407407095,7471.4664351851825]
[37,0,7361.1111111111113,0,7361.1111111111113]
[38,0,7361.1111111111113,0,7361.1111111111113]
[39,0,7361.1111111111113,0,7361.1111111111113]
[40,0,7361.1111111111113,0,7361.1111111111113]
[41,0,7361.1111111111113,0,7361.1111111111113]
[42,0,7361.1111111111113,0,7361.1111111111113]
[43,0,7361.1111111111113,0,7361.1111111111113]
[44,0,7361.1111111111113,0,7361.1111111111113]
[45,0,7361.1111111111113,0,7361.1111111111113]
[46,0,7361.1111111111113,0,7361.1111111111113]
[47,0,7361.1111111111113,0,7361.1111111111113]
[48,0,7361.1111111111113,0,7361.1111111111113]
[49,0,7361.1111111111113,0,7361.1111111111113]
[50,0,7361.1111111111113,0,7361.1111111111113]
[51,0,7361.1111111111113,0,7361.1111111111113]
[52,0,7361.1111111111113,0,7361.1111111111113]
[53,0,7361.1111111111113,0,7361.1111111111113]
[54,0,7361.1111111111113,0,7361.1111111111113]
[55,0,7361.1111111111113,0,7361.1111111111113]
[56,0,7361.1111111111113,0,7361.1111111111113]
[57,0,7361.1111111111113,0,7361.1111111111113]
[58,0,7361.1111111111113,0,7361.1111111111113]
[59,0,7361.1111111111113,0,7361.1111111111113]
[60,0,7361.1111111111113,0,7361.1111111111113]
[61,0,7361.1111111111113,0,7361.1111111111113]
[62,0,7361.1111111111113,0,7361.1111111111113]
[63,0,7361.1111111111113,0,7361.1111111111113]
[64,0,7361.1111111111113,0,7361.1111111111113]
[65,0,7361.1111111111113,0,7361.1111111111113]
[66,0,7361.1111111111113,{"$f":"IF((B80*$B$7/12)<=0,0,B80*$B$7/12)","v":0},{"$f":"IF((D81+C81)<=0,0,D81+C81)","v":7361.1111111111113}]
[67,{"$f":"IF((B81-C82)<=0,0,B81-C82)","v":0},{"$f":"IF(($B$2/$B$4)<=0,0,$B$2/$B$4)","v":7361.1111111111113},0,7361.1111111111113]
[68,0,7361.1111111111113,0,7361.1111111111113]
[69,0,7361.1111111111113,0,7361.1111111111113]
[70,0,7361.1111111111113,0,7361.1111111111113]
[71,0,7361.1111111111113,0,7361.1111111111113]
[72,0,7361.1111111111113,0,7361.1111111111113]
[73,0,7361.1111111111113,0,7361.1111111111113]
[74,0,7361.1111111111113,0,7361.1111111111113]
[75,0,7361.1111111111113,0,7361.1111111111113]
[76,0,7361.1111111111113,0,7361.1111111111113]
[77,0,7361.1111111111113,0,7361.1111111111113]
[78,0,7361.1111111111113,0,7361.1111111111113]
[79,0,7361.1111111111113,0,7361.1111111111113]
[80,0,7361.1111111111113,0,7361.1111111111113]
[81,0,7361.1111111111113,0,7361.1111111111113]
[82,0,7361.1111111111113,0,7361.1111111111113]
[83,0,7361.1111111111113,0,7361.1111111111113]
[84,0,7361.1111111111113,0,7361.1111111111113]
[85,0,7361.1111111111113,0,7361.1111111111113]
[86,0,7361.1111111111113,0,7361.1111111111113]
[87,0,7361.1111111111113,0,7361.1111111111113]
[88,0,7361.1111111111113,0,7361.1111111111113]
[89,0,7361.1111111111113,0,7361.1111111111113]
[90,0,7361.1111111111113,0,7361.1111111111113]
[91,0,7361.1111111111113,0,7361.1111111111113]
[92,0,7361.1111111111113,0,7361.1111111111113]
[93,0,7361.1111111111113,0,7361.1111111111113]
[94,0,7361.1111111111113,0,7361.1111111111113]
[95,0,7361.1111111111113,0,7361.1111111111113]
[96,0,7361.1111111111113,0,7361.1111111111113]
[97,0,7361.1111111111113,0,7361.1111111111113]
[98,0,7361.1111111111113,0,7361.1111111111113]
[99,0,7361.1111111111113,0,7361.1111111111113]
[100,0,7361.1111111111113,0,7361.1111111111113]
[101,0,7361.1111111111113,0,7361.1111111111113]
[102,0,7361.1111111111113,0,7361.1111111111113]
[103,0,7361.1111111111113,0,7361.1111111111113]
[104,0,7361.1111111111113,0,7361.1111111111113]
[105,0,7361.1111111111113,0,7361.1111111111113]
[106,0,7361.1111111111113,0,7361.1111111111113]
[107,0,7361.1111111111113,0,7361.1111111111113]
[108,0,7361.1111111111113,0,7361.1111111111113]
[109,0,7361.1111111111113,0,7361.1111111111113]
[110,0,7361.1111111111113,0,7361.1111111111113]
[111,0,7361.1111111111113,0,7361.1111111111113]
[112,0,7361.1111111111113,0,7361.1111111111113]
[113,0,7361.1111111111113,0,7361.1111111111113]
[114,0,7361.1111111111113,0,7361.1111111111113]
[115,0,7361.1111111111113,0,7361.1111111111113]
[116,0,7361.1111111111113,0,7361.1111111111113]
[117,0,7361.1111111111113,0,7361.1111111111113]
[118,0,7361.1111111111113,0,7361.1111111111113]
[119,0,7361.1111111111113,0,7361.1111111111113]
[120,0,7361.1111111111113,0,7361.1111111111113]
[121,0,7361.1111111111113,0,7361.1111111111113]
[122,0,7361.1111111111113,0,7361.1111111111113]
[123,0,7361.1111111111113,0,7361.1111111111113]
[124,0,7361.1111111111113,0,7361.1111111111113]
[125,0,7361.1111111111113,0,7361.1111111111113]
[126,0,7361.1111111111113,0,7361.1111111111113]
[127,0,7361.1111111111113,0,7361.1111111111113]
[128,0,7361.1111111111113,0,7361.1111111111113]
[129,0,7361.1111111111113,0,7361.1111111111113]
[130,0,7361.1111111111113,{"$f":"IF((B144*$B$7/12)<=0,0,B144*$B$7/12)","v":0},{"$f":"IF((D145+C145)<=0,0,D145+C145)","v":7361.1111111111113}]
[131,{"$f":"IF((B145-C146)<=0,0,B145-C146)","v":0},{"$f":"IF(($B$2/$B$4)<=0,0,$B$2/$B$4)","v":7361.1111111111113},0,7361.1111111111113]
[132,0,7361.1111111111113,0,7361.1111111111113]
[133,0,7361.1111111111113,0,7361.1111111111113]
[134,0,7361.1111111111113,0,7361.1111111111113]
[135,0,7361.1111111111113,0,7361.1111111111113]
[136,0,7361.1111111111113,0,7361.1111111111113]
[137,0,7361.1111111111113,0,7361.1111111111113]
[138,0,7361.1111111111113,0,7361.1111111111113]
[139,0,7361.1111111111113,0,7361.1111111111113]
[140,0,7361.1111111111113,0,7361.1111111111113]
[141,0,7361.1111111111113,0,7361.1111111111113]
[142,0,7361.1111111111113,0,7361.1111111111113]
[143,0,7361.1111111111113,0,7361.1111111111113]
[144,0,7361.1111111111113,0,7361.1111111111113]
[145,0,7361.1111111111113,0,7361.1111111111113]
[146,0,7361.1111111111113,0,7361.1111111111113]
[147,0,7361.1111111111113,0,7361.1111111111113]
[148,0,7361.1111111111113,0,7361.1111111111113]
[149,0,7361.1111111111113,0,7361.1111111111113]
[150,0,7361.1111111111113,0,7361.1111111111113]
[151,0,7361.1111111111113,0,7361.1111111111113]
[152,0,7361.1111111111113,0,7361.1111111111113]
[153,0,7361.1111111111113,0,7361.1111111111113]
[154,0,7361.1111111111113,0,7361.1111111111113]
[155,0,7361.1111111111113,0,7361.1111111111113]
[156,0,7361.1111111111113,0,7361.1111111111113]
[157,0,7361.1111111111113,0,7361.1111111111113]
[158,0,7361.1111111111113,0,7361.1111111111113]
[159,0,7361.1111111111113,0,7361.1111111111113]
[160,0,7361.1111111111113,0,7361.1111111111113]
[161,0,7361.1111111111113,0,7361.1111111111113]
[162,0,7361.1111111111113,0,7361.1111111111113]
[163,0,7361.1111111111113,0,7361.1111111111113]
[164,0,7361.1111111111113,0,7361.1111111111113]
[165,0,7361.1111111111113,0,7361.1111111111113]
[166,0,7361.1111111111113,0,7361.1111111111113]
[167,0,7361.1111111111113,0,7361.1111111111113]
[168,0,7361.1111111111113,0,7361.1111111111113]
[169,0,7361.1111111111113,0,7361.1111111111113]
[170,0,7361.1111111111113,0,7361.1111111111113]
[171,0,7361.1111111111113,0,7361.1111111111113]
[172,0,7361.1111111111113,0,7361.1111111111113]
[173,0,7361.1111111111113,0,7361.1111111111113]
[174,0,7361.1111111111113,0,7361.1111111111113]
[175,0,7361.1111111111113,0,7361.1111111111113]
[176,0,7361.1111111111113,0,7361.1111111111113]
[177,0,7361.1111111111113,0,7361.1111111111113]
[178,0,7361.1111111111113,0,7361.1111111111113]
[179,0,7361.1111111111113,0,7361.1111111111113]
[180,0,7361.1111111111113,0,7361.1111111111113]
[181,0,7361.1111111111113,0,7361.1111111111113]
[182,0,7361.1111111111113,0,7361.1111111111113]
[183,0,7361.1111111111113,0,7361.1111111111113]
[184,0,7361.1111111111113,0,7361.1111111111113]
[185,0,7361.1111111111113,0,7361.1111111111113]
[186,0,7361.1111111111113,0,7361.1111111111113]
[187,0,7361.1111111111113,0,7361.1111111111113]
[188,0,7361.1111111111113,0,7361.1111111111113]
[189,0,7361.1111111111113,0,7361.1111111111113]
[190,0,7361.1111111111113,0,7361.1111111111113]
[191,0,7361.1111111111113,0,7361.1111111111113]
[192,0,7361.1111111111113,0,7361.1111111111113]
[193,0,7361.1111111111113,0,7361.1111111111113]
[194,0,7361.1111111111113,{"$f":"IF((B208*$B$7/12)<=0,0,B208*$B$7/12)","v":0},{"$f":"IF((D209+C209)<=0,0,D209+C209)","v":7361.1111111111113}]
[195,{"$f":"IF((B209-C210)<=0,0,B209-C210)","v":0},{"$f":"IF(($B$2/$B$4)<=0,0,$B$2/$B$4)","v":7361.1111111111113},0,7361.1111111111113]
[196,0,7361.1111111111113,0,7361.1111111111113]
[197,0,7361.1111111111113,0,7361.1111111111113]
[198,0,7361.1111111111113,0,7361.1111111111113]
[199,0,7361.1111111111113,0,7361.1111111111113]
[200,0,7361.1111111111113,0,7361.1111111111113]
[201,0,7361.1111111111113,0,7361.1111111111113]
[202,0,7361.1111111111113,0,7361.1111111111113]
[203,0,7361.1111111111113,0,7361.1111111111113]
[204,0,7361.1111111111113,0,7361.1111111111113]
[205,0,7361.1111111111113,0,7361.1111111111113]
[206,0,7361.1111111111113,0,7361.1111111111113]
[207,0,7361.1111111111113,0,7361.1111111111113]
[208,0,7361.1111111111113,0,7361.1111111111113]
[209,0,7361.1111111111113,0,7361.1111111111113]
[210,0,7361.1111111111113,0,7361.1111111111113]
[211,0,7361.1111111111113,0,7361.1111111111113]
[212,0,7361.1111111111113,0,7361.1111111111113]
[213,0,7361.1111111111113,0,7361.1111111111113]
[214,0,7361.1111111111113,0,7361.1111111111113]
[215,0,7361.1111111111113,0,7361.1111111111113]
[216,0,7361.1111111111113,0,7361.1111111111113]
[217,0,7361.1111111111113,0,7361.1111111111113]
[218,0,7361.1111111111113,0,7361.1111111111113]
[219,0,7361.1111111111113,0,7361.1111111111113]
[220,0,7361.1111111111113,0,7361.1111111111113]
[221,0,7361.1111111111113,0,7361.1111111111113]
[222,0,7361.1111111111113,0,7361.1111111111113]
[223,0,7361.1111111111113,0,7361.1111111111113]
[224,0,7361.1111111111113,0,7361.1111111111113]
[225,0,7361.1111111111113,0,7361.1111111111113]
[226,0,7361.1111111111113,0,7361.1111111111113]
[227,0,7361.1111111111113,0,7361.1111111111113]
[228,0,7361.1111111111113,0,7361.1111111111113]
[229,0,7361.1111111111113,0,7361.1111111111113]
[230,0,7361.1111111111113,0,7361.1111111111113]
[231,0,7361.1111111111113,0,7361.1111111111113]
[232,0,7361.1111111111113,0,7361.1111111111113]
[233,0,7361.1111111111113,0,7361.1111111111113]
[234,0,7361.1111111111113,0,7361.1111111111113]
[235,0,7361.1111111111113,0,7361.1111111111113]
[236,0,7361.1111111111113,0,7361.1111111111113]
[237,0,7361.1111111111113,0,7361.1111111111113]
[238,0,7361.1111111111113,0,7361.1111111111113]
[239,0,7361.1111111111113,0,7361.1111111111113]
[240,0,7361.1111111111113,0,7361.1111111111113]

{"sheet":"CASH","index":1,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["3","DATA","COEFF","#","SOLITERS","MINEXPENSES","Столбец1","ОБРАНЕМІСТО","СОЛІТЕРИ"]
[6,"2 МЛН +",1.2,1,0,-1853,1,6,1]
[5,"1 МЛН +",1.1000000000000001,2,1,{"$f":"$F$2*Таблица2[[#This Row],[Столбец1]]","v":-3706},2,{"$f":"VLOOKUP(CITYCHOICE,$A$2:$C$7,3,0)","v":1.2}]
[4,"0.5 МЛН +",1,3,2,{"$f":"$F$2*Таблица2[[#This Row],[Столбец1]]","v":-5559},3,{"$f":"VLOOKUP(CITYCHOICE,$A$2:$C$7,2,0)","v":"2 МЛН +"},{"$f":"VLOOKUP(SOLITERSQ,E2:F7,2,0)","v":-3706}]
[3,"0.1 МЛН +",0.9,4,3,{"$f":"$F$2*Таблица2[[#This Row],[Столбец1]]","v":-7412},4]
[2,"50 Т -",0.8,5,4,{"$f":"$F$2*Таблица2[[#This Row],[Столбец1]]","v":-9265},5]
[1,"20 Т -",0.7,6,5,{"$f":"$F$2*Таблица2[[#This Row],[Столбец1]]","v":-11118},6]
[null,null,null,null,null,null,"clnumber","clgroup","cllimit"]
[null,null,null,null,null,null,1,"Внутрішні клієнти інші",{"$f":"[0]!INCOME*2","v":{"$error":"#REF!"}}]
["ПРОЦЕНТНА СТАВКА.  РІЧНИХ","МІСЯЦІВ КРЕДИТУ","МІН. ЗАРПЛАТНЯ","КОЕФ. СОЦВНЕСКІВ","КОЕФ. СОЦВНЕСКІВ2",null,2,"Зовнішні клієнти",50000]
[null,null,null,null,null,null,3,"Співробітники Банку",250000]
[null,null,null,null,null,null,4,"Клієнти ЗКП/Пенсіонери",250000]
[null,null,null,null,null,null,null,"Макс сума кредиту",{"$f":"IF(D5=CASH!H9,CASH!I9,IF(D5=CASH!H10,CASH!I10,IF(D5=CASH!H11,CASH!I11,IF(D5=CASH!H12,CASH!I12,\"\"))))","v":""}]
[null,null,null,null,null,null,null,"Обрана клієнтська група",4]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(CLIENTCHOICE,$A$19:$C$22,3,0)","v":250000}]
[]
[]
["clnumber","clgroup","cllimit"]
[1,"Внутрішні клієнти інші",{"$f":"I9","v":{"$error":"#REF!"}}]
[2,"Зовнішні клієнти",50000,null,null,250]
[3,"Співробітники Банку",250000,null,null,450]
[4,"Клієнти ЗКП/Пенсіонери",250000]
[null,"Макс сума кредиту",""]
[null,"Обрана клієнтська група",{"$f":"CLIENTCHOICE","v":4}]
[null,"Макс сума кредиту",{"$f":"I15","v":250000}]
[null,"Клієнтська група",{"$f":"VLOOKUP(CLIETCHOCE,$A$19:$C$22,2,0)","v":"Клієнти ЗКП/Пенсіонери"}]

{"sheet":"калькулятор платежів","index":2,"n_rows":103,"n_cols":5,"rows_kept":103,"cut":false,"hidden":false,"merged":[[17,1,17,4],[18,0,18,1],[12,3,12,4],[13,3,13,4]]}
[]
[]
[]
[]
["Потужність ЕС",30,"кВт"]
["Орієн. вартість ПРОЕКТУ",530000,"грн."]
["Аванс",0.5,"%"]
["Сума авансу",{"$f":"B6*B7","v":265000},"грн."]
["Сума кредиту",{"$f":"B6-(B6*B7)","v":265000},"грн."]
["Разова комісія",2.9899999999999999E-2]
["Разова комісія",{"$f":"B9*B10","v":7923.5},"грн."]
["Процентна ставка",0.1799,"річних"]
["Строк кредитування",36,"міс.","Орієнт. дохід/міс., грн."]
["Метод погашення","стандарт",null,{"$f":"IF(B5=5,'окупность '!D6,IF(B5=10,'окупность '!D7,IF(B5=15,'окупность '!D8,IF(B5=20,'окупность '!D9,IF(B5=30,'окупность '!D10)))))","v":14050}]
["орієнтовний страховий платіж  від",{"$f":"B6*0.3%","v":1590},"грн."]
[]
["Місяць","Залишок заборгованості на кінець періоду","Погашення основної суми","Сума відсотків","Платіж"]
["Відсоток переплати,%",{"$f":"(D19+B11)/C19","v":{"$error":"#N/A"}}]
["Всього",null,{"$f":"SUMIF(C20:C103,\"<>#Н/Д\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"IF((B13=12)*(B14=\"ануїтет\"),#REF!,IF((B13=24)*(B14=\"ануїтет\"),#REF!,IF((B13=36)*(B14=\"ануїтет\"),#REF!,IF((B13=48)*(B14=\"ануїтет\"),#REF!,IF((B13=60)*(B14=\"ануїтет\"),#REF!,IF((B13=72)*(B14=\"ануїтет\"),#REF!,IF((B13=84)*(B14=\"ануїтет\"),#REF!,IF((B13=12)*(B14=\"стандарт\"),Zag_shema!A16:E27,IF((B13=24)*(B14=\"стандарт\"),Zag_shema!A16:E39,IF((B13=36)*(B14=\"стандарт\"),Zag_shema!A16:E51,IF((B13=48)*(B14=\"стандарт\"),Zag_shema!A16:E63,IF((B13=60)*(B14=\"стандарт\"),Zag_shema!A16:E75,IF((B13=72)*(B14=\"стандарт\"),Zag_shema!A16:E87,IF((B13=84)*(B14=\"стандарт\"),Zag_shema!A16:E99,\"\"))))))))))))))","v":1},257638.88888888888,7361.1111111111113,3972.7916666666665,11333.902777777777]
[2,250277.77777777775,7361.1111111111113,3862.4363425925926,11223.547453703704]
[3,242916.66666666663,7361.1111111111113,3752.0810185185182,11113.19212962963]
[4,235555.5555555555,7361.1111111111113,3641.7256944444439,11002.836805555555]
[5,228194.44444444438,7361.1111111111113,3531.37037037037,10892.481481481482]
[6,220833.33333333326,7361.1111111111113,3421.0150462962956,10782.126157407407]
[7,213472.22222222213,7361.1111111111113,3310.6597222222213,10671.770833333332]
[8,206111.11111111101,7361.1111111111113,3200.3043981481464,10561.415509259257]
[9,198749.99999999988,7361.1111111111113,3089.9490740740725,10451.060185185184]
[10,191388.88888888876,7361.1111111111113,2979.5937499999982,10340.704861111109]
[11,184027.77777777764,7361.1111111111113,2869.2384259259238,10230.349537037035]
[12,176666.66666666651,7361.1111111111113,2758.8831018518499,10119.994212962962]
[13,169305.55555555539,7361.1111111111113,2648.5277777777756,10009.638888888887]
[14,161944.44444444426,7361.1111111111113,2538.1724537037012,9899.2835648148121]
[15,154583.33333333314,7361.1111111111113,2427.8171296296268,9788.9282407407372]
[16,147222.22222222202,7361.1111111111113,2317.4618055555525,9678.5729166666642]
[17,139861.11111111089,7361.1111111111113,2207.1064814814786,9568.2175925925894]
[18,132499.99999999977,7361.1111111111113,2096.7511574074042,9457.8622685185146]
[19,125138.88888888866,7361.1111111111113,1986.3958333333301,9347.5069444444416]
[20,117777.77777777755,7361.1111111111113,1876.0405092592557,9237.1516203703668]
[21,110416.66666666644,7361.1111111111113,1765.6851851851818,9126.7962962962938]
[22,103055.55555555533,7361.1111111111113,1655.3298611111077,9016.440972222219]
[23,95694.44444444422,7361.1111111111113,1544.9745370370338,8906.085648148146]
[24,88333.33333333311,7361.1111111111113,1434.6192129629596,8795.7303240740712]
[25,80972.222222222001,7361.1111111111113,1324.2638888888855,8685.3749999999964]
[26,73611.111111110891,7361.1111111111113,1213.9085648148116,8575.0196759259234]
[27,66249.999999999782,7361.1111111111113,1103.5532407407375,8464.6643518518486]
[28,58888.888888888672,7361.1111111111113,993.19791666666345,8354.3090277777756]
[29,51527.777777777563,7361.1111111111113,882.84259259258943,8243.9537037037007]
[30,44166.666666666453,7361.1111111111113,772.48726851851541,8133.5983796296268]
[31,36805.555555555344,7361.1111111111113,662.13194444444127,8023.2430555555529]
[32,29444.444444444234,7361.1111111111113,551.77662037036714,7912.8877314814781]
[33,22083.333333333125,7361.1111111111113,441.42129629629312,7802.5324074074042]
[34,14722.222222222013,7361.1111111111113,331.0659722222191,7692.1770833333303]
[35,7361.1111111109021,7361.1111111111113,220.710648148145,7581.8217592592564]
[36,0,7361.1111111111113,110.35532407407095,7471.4664351851825]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"окупность ","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,"потужність","дохід міс."]
[null,null,5,2364.583333333333,170000]
[null,null,10,4731.25,280000]
[null,null,15,7095.833333333333,390000]
[null,null,20,9354.1666666666679,470000]
[null,null,30,14050,670000]