{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Калькулятор","Платежный график","Процентная ставка","Настройки","Макс. кредит","Надбавки"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":167,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Калькулятор","index":0,"n_rows":99,"n_cols":8,"rows_kept":99,"cut":false,"hidden":false,"merged":[[92,2,92,4],[5,7,5,9],[50,2,50,4],[81,2,81,4],[1,1,1,9],[2,2,2,4],[3,2,3,4],[9,7,10,7],[91,2,91,4]]}
[]
[null,"Ипотечный калькулятор"]
[null,null,"1. Исходные данные"]
[]
[]
[null,null,"Дата рождения заемщика",null,"1977-05-21",null,null,{"$f":"IF(DATE(YEAR(E8)+INT(E10/12),MONTH(E8)+MOD(E10,12),DAY(E8))>DATE(YEAR(E6)+65,MONTH(E6),DAY(E6)),\"Заемщик не проходит по возрасту!\",\"\")","v":""}]
[]
[null,null,"Предполагаемая дата выдачи",null,"2013-05-23"]
[]
[null,null,"Срок кредита (в мес.)",null,240,null,null,{"$f":"IF(E10=6,\"\",IF(E10<36,\"Срок кредита - 6 мес. или не менее 36 мес.\",IF(MOD(E10,12)<>0,\"Срок должен быть кратен 12!\",\"\")))","v":""}]
[]
[null,null,"Ежемесячный совокупный доход",null,60000]
[]
[null,null,"Желаемая сумма кредита (без учета средств МСК)",null,1300000]
[]
[null,null,"Сумма средств МСК, направляемая на погашение кредита",null,429408.5]
[null,null,null,null,"по Договору",null,null,"по Отчету об оценке"]
[null,null,"Стоимость квартиры",null,2890000,null,null,1899000]
[]
[null,null,"Цели выдачи кредита соответствуют СУ \"Новостройка\" (да - 1 / нет - 0)",null,1,null,null,{"$f":"IF(AND(OR(perv=1,perv=0),NOT(perv=\"\")),\"\",\"Укажите рынок жилья\")","v":""}]
[]
[null,null,"Объект МЭЖ  (да -1 / нет - 0)",null,0]
[]
[null,null,"Период фиксации (мес)",null,240]
[]
[null,null,"Наличие личного страхования (да -1 / нет - 0)",null,1]
[]
[null,null,"Участник подпрограммы «Обеспечение жильем молодых семей» (да -1 / нет - 0)",null,0]
[]
[null,null,"Владелец государственного жилищного сертификата участника подпрограммы «Выполнение государственных обязательств по обеспечению жильем категорий граждан, установленных федеральным законодательством» (да -1 / нет - 0)",null,0]
[]
[null,null,"Строительство предмета ипотеки осуществляется в рамках программы \"Стимул\" (да -1 / нет - 0)",null,0]
[]
[null,null,"Общая площадь квартиры (кв.м)",null,40]
[]
[null,null,"Размер ставки в случае отличия от условий Паспорта продукта",null,null,null,null,{"$f":"IF(AND(OR(insur=1,insur=0),NOT(insur=\"\")),\"\",\"Укажите наличие личного страхования\")","v":""}]
[]
[null,null,{"$f":"IF(MEJ=1,\"Размер надбавки к уровню инфляции, установленная кредитором.\nЦели кредитования соответствуют целям продукта «Малоэтажное жилье»\",\"Размер надбавки к уровню инфляции, установленная кредитором.\nЦели кредитования НЕ соответствуют целям продукта «Малоэтажное жилье»\")","v":"Размер надбавки к уровню инфляции, установленная кредитором.\nЦели кредитования НЕ соответствуют целям продукта «Малоэтажное жилье»"},null,0]
[]
[null,null,"Дата вступления в силу ставки, соответствующей условиям Паспорта продукта"]
[]
[null,null,"Наличие ипотечного страхования (да -1 / нет - 0)",null,0]
[]
[null,null,"Регион нахождения предмета ипотеки",null,"Иркутская область",null,null,{"$f":"IF(E44<>\"\",\"\",\"Укажите регион нахождения предмета ипотеки\")","v":""}]
[]
[null,null,"Способ округления аннуитета",null,"До копеек"]
[]
[]
[]
[]
[null,null,"2. Кредит Часть 1"]
[]
[]
[]
[null,null,"Сумма кредита Часть 1, руб",null,1300000.28]
[]
[null,null,"Ставка процента по Части 1",null,0.115]
[]
[null,null,"Размер ставки, соответствующей условиям Паспорта продукта",null,0.1]
[]
[null,null,"Дата окончания срока фиксации",null,"2033-04-30"]
[]
[null,null,"Ежемесячный платеж",null,13893.77]
[]
[null,null,"Первоначальный взнос",null,1183637]
[]
[null,null,"Коэффициент К/З",null,0.68]
[]
[null,null,"Коэффициент П/Д",null,{"$f":"Rnd(((platezh1+c_credit1*1.1*0.02/12)/E12*100)/100)","v":0.27}]
[]
[null,null,"Надбавка к уровню инфляции",null,0.05]
[null,null,null,null,"в рублях",null,null,"в % от ОД"]
[null,null,"Единоразовые платежи заемщика при предоставлении кредита (займа), в том числе в пользу третьих лиц",null,0,null,null,0]
[]
[null,null,null,null,"в рублях",null,null,"в % от ОД"]
[null,null,"Ежегодные платежи в процессе обслуживания кредита (займа), в том числе в пользу третьих лиц",null,0,null,null,0]
[null,null,null,null,null,null,null,"в % от ОД+10%"]
[null,null,"Страховой платеж при предоставлении кредита (займа)",null,null,null,null,0]
[null,null,null,null,null,null,null,"в % от ОД+10%"]
[null,null,"Страховые платежи в процессе обслуживания кредита (займа)",null,null,null,null,0]
[]
[null,null,"3. Кредит Часть 2 "]
[]
[null,null,"Сумма кредита ЧАСТЬ 2, руб",null,406362.72]
[]
[null,null,"Фактический срок кредита ЧАСТЬ 2, дней.",null,180]
[]
[null,null,"Дата внесения РПП, платежный период",null,{"$f":"E8+180","v":"2013-11-19"}]
[]
[null,null,"Действующая ставка по ЧАСТИ 2",null,0.115]
[]
[]
[null,null,"4 .Итог"]
[null,null,"ИТОГО СУММА КРЕДИТА ЧАСТЬ 1 и ЧАСТЬ 2",null,{"$f":"ROUND(c_credit1+Credit_part2,2)","v":1706363}]
[]
[null,null,"Общий Кредит/Залог*",null,{"$f":"ROUND((summa1/MIN(p_zalog,estim))*100,0)/100","v":0.9}]
[null,null,null,null,{"$f":"IF(AND(flat_value>0,H20>0),CEILING((summa1/MIN(H20,flat_value))*10000,1)/10000,\"-\")","v":{"$error":"#REF!"}}]
[null,null,"Стоимость квартиры",null,2890000]
[null,null,"Фактическая дата выдачи кредита",null,"2013-05-23"]

{"sheet":"Платежный график","index":1,"n_rows":258,"n_cols":10,"rows_kept":258,"cut":false,"hidden":false,"merged":[[10,0,10,4],[12,0,15,0],[12,9,15,9],[3,0,3,4],[8,0,8,4],[4,7,6,7],[4,9,6,9],[7,9,9,9],[4,0,4,4],[3,5,3,8],[4,6,7,6],[5,0,5,4],[6,0,6,4],[7,0,7,4],[9,0,9,4],[13,6,15,6],[0,0,0,9],[1,0,1,4],[1,5,1,8],[2,0,2,4],[2,5,2,8],[13,7,13,8],[12,1,12,3],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5],[12,4,12,8]]}
["График ежемесячных платежей"]
["К кредитному договору"]
["ФИО Заемщика (ов)",null,null,null,null,{"$f":"Калькулятор!C4","v":0}]
["Процентная ставка по Части -1, % годовых",null,null,null,null,{"$f":"Калькулятор!E57","v":0.115}]
["Процентная ставка по Части-2, % годовых",null,null,null,null,{"$f":"Калькулятор!stavmsk","v":0.115},null,null,null,"Полная стоимость кредита"]
["Срок кредитования Части-1, мес",null,null,null,null,{"$f":"srok","v":240}]
["Срок кредитования Части-2, дней",null,null,null,null,{"$f":"Калькулятор!E86","v":180}]
["Сумма кредита всего, руб",null,null,null,null,{"$f":"Калькулятор!summa1","v":1706363},null,null,null,{"$f":"TRUNC(XIRR(I16:I257,H16:H257,0.1),4)","v":0.10730000000000001}]
["Сумма кредита Части-1, руб",null,null,null,null,{"$f":"c_credit1","v":1300000.28}]
["Сумма кредита Части-2, руб",null,null,null,null,{"$f":"Калькулятор!Credit_part2","v":406362.72}]
["Дата выдачи кредита",null,null,null,null,{"$f":"[0]!data_vyd1","v":"2013-05-23"}]
[null,null,null,null,null,null,null,null,null,240]
["№ п/п","Срок платежа",null,null,"Сумма платежа",null,null,null,null,"Остаток основного долга"]
[null,"День","Месяц","Год","Сумма платежа (ежемесячного платежа и разового планового платежа)","Погашение основного долга","Погашение процентов","Досрочный платеж"]
[null,null,null,null,null,null,null,"По основному долгу","По процентам"]
[null,null,null,null,null,null,null,"2013-05-23",-1708747]
[1,30,"Июнь",2013,2920.55,0,2920.55,41417,0,1708747]
[2,30,"Июнь",2013,12794.12,1842.07,10952.05,41455,15714.670000000002,1706904.93]
[3,31,"Июль",2013,12794.12,1493.03,11301.09,41486,12794.12,1705411.9]
[4,31,"Август",2013,12794.12,1506.03,11288.09,41517,12794.12,1703905.87]
[5,30,"Сентябрь",2013,12794.12,1882.85,10911.27,41547,12794.12,1702023.02]
[6,31,"Октябрь",2013,12794.12,1535.53,11258.59,41578,12794.12,1700487.49]
[7,19,"Ноябрь",2013,429408.5,408747.17,20661.330000000002,41597,429408.5,1291740.32]
[7,30,"Ноябрь",2013,12794.12,1911.65,10882.47,41608,12794.12,1289828.67]
[8,31,"Декабрь",2013,12794.12,1565.54,11228.58,41639,12794.12,1288263.1299999999]
[9,31,"Январь",2014,12794.12,1579.17,11214.95,41670,12794.12,1286683.96]
[10,28,"Февраль",2014,12794.12,2676.91,10117.209999999999,41698,12794.12,1284007.05]
[11,31,"Март",2014,12794.12,1616.22,11177.9,41729,12794.12,1282390.83]
[12,30,"Апрель",2014,12794.12,1990.42,10803.7,41759,12794.12,1280400.4099999999]
[13,31,"Май",2014,12794.12,1647.62,11146.5,41790,12794.12,1278752.79]
[14,30,"Июнь",2014,12794.12,2021.07,10773.05,41820,12794.12,1276731.72]
[15,31,"Июль",2014,12794.12,1679.56,11114.56,41851,12794.12,1275052.1599999999]
[16,31,"Август",2014,12794.12,1694.18,11099.94,41882,12794.12,1273357.98]
[17,30,"Сентябрь",2014,12794.12,2066.52,10727.6,41912,12794.12,1271291.46]
[18,31,"Октябрь",2014,12794.12,1726.92,11067.2,41943,12794.12,1269564.54]
[19,30,"Ноябрь",2014,12794.12,2098.4699999999998,10695.65,41973,12794.12,1267466.07]
[20,31,"Декабрь",2014,12794.12,1760.22,11033.9,42004,12794.12,1265705.8500000001]
[21,31,"Январь",2015,12794.12,1775.54,11018.58,42035,12794.12,1263930.31]
[22,28,"Февраль",2015,12794.12,2855.82,9938.2999999999993,42063,12794.12,1261074.49]
[23,31,"Март",2015,12794.12,1815.86,10978.26,42094,12794.12,1259258.6299999999]
[24,30,"Апрель",2015,12794.12,2185.3000000000002,10608.82,42124,12794.12,1257073.33]
[25,31,"Май",2015,12794.12,1850.69,10943.43,42155,12794.12,1255222.6399999999]
[26,30,"Июнь",2015,12794.12,2219.3000000000002,10574.82,42185,12794.12,1253003.3400000001]
[27,31,"Июль",2015,12794.12,1886.13,10907.99,42216,12794.12,1251117.21]
[28,31,"Август",2015,12794.12,1902.54,10891.58,42247,12794.12,1249214.67]
[29,30,"Сентябрь",2015,12794.12,2269.91,10524.21,42277,12794.12,1246944.76]
[30,31,"Октябрь",2015,12794.12,1938.87,10855.25,42308,12794.12,1245005.8899999999]
[31,30,"Ноябрь",2015,12794.12,2305.37,10488.75,42338,12794.12,1242700.52]
[32,31,"Декабрь",2015,12794.12,1975.82,10818.3,42369,12794.12,1240724.7]
[33,31,"Январь",2016,12794.12,2022.53,10771.59,42400,12794.12,1238702.17]
[34,29,"Февраль",2016,12794.12,2733.9,10060.219999999999,42429,12794.12,1235968.27]
[35,31,"Март",2016,12794.12,2063.8200000000002,10730.3,42460,12794.12,1233904.45]
[36,30,"Апрель",2016,12794.12,2427.3000000000002,10366.82,42490,12794.12,1231477.1499999999]
[37,31,"Май",2016,12794.12,2102.81,10691.31,42521,12794.12,1229374.3400000001]
[38,30,"Июнь",2016,12794.12,2465.36,10328.76,42551,12794.12,1226908.98]
[39,31,"Июль",2016,12794.12,2142.4699999999998,10651.65,42582,12794.12,1224766.51]
[40,31,"Август",2016,12794.12,2161.0700000000002,10633.05,42613,12794.12,1222605.44]
[41,30,"Сентябрь",2016,12794.12,2522.23,10271.89,42643,12794.12,1220083.21]
[42,31,"Октябрь",2016,12794.12,2201.73,10592.39,42674,12794.12,1217881.48]
[43,30,"Ноябрь",2016,12794.12,2561.92,10232.200000000001,42704,12794.12,1215319.56]
[44,31,"Декабрь",2016,12794.12,2243.09,10551.03,42735,12794.12,1213076.47]
[45,31,"Январь",2017,12794.12,2233.71,10560.41,42766,12794.12,1210842.76]
[46,28,"Февраль",2017,12794.12,3273.25,9520.8700000000008,42794,12794.12,1207569.51]
[47,31,"Март",2017,12794.12,2281.65,10512.47,42825,12794.12,1205287.8600000001]
[48,30,"Апрель",2017,12794.12,2639.98,10154.14,42855,12794.12,1202647.8799999999]
[49,31,"Май",2017,12794.12,2324.4899999999998,10469.629999999999,42886,12794.12,1200323.3899999999]
[50,30,"Июнь",2017,12794.12,2681.81,10112.31,42916,12794.12,1197641.58]
[51,31,"Июль",2017,12794.12,2368.08,10426.040000000001,42947,12794.12,1195273.5]
[52,31,"Август",2017,12794.12,2388.69,10405.43,42978,12794.12,1192884.81]
[53,30,"Сентябрь",2017,12794.12,2744.47,10049.65,43008,12794.12,1190140.3400000001]
[54,31,"Октябрь",2017,12794.12,2433.38,10360.74,43039,12794.12,1187706.96]
[55,30,"Ноябрь",2017,12794.12,2788.1,10006.02,43069,12794.12,1184918.8600000001]
[56,31,"Декабрь",2017,12794.12,2478.83,10315.290000000001,43100,12794.12,1182440.03]
[57,31,"Январь",2018,12794.12,2500.41,10293.709999999999,43131,12794.12,1179939.6200000001]
[58,28,"Февраль",2018,12794.12,3516.24,9277.8799999999992,43159,12794.12,1176423.3799999999]
[59,31,"Март",2018,12794.12,2552.79,10241.33,43190,12794.12,1173870.5900000001]
[60,30,"Апрель",2018,12794.12,2904.66,9889.4599999999991,43220,12794.12,1170965.93]
[61,31,"Май",2018,12794.12,2600.3000000000002,10193.82,43251,12794.12,1168365.6299999999]
[62,30,"Июнь",2018,12794.12,2951.04,9843.08,43281,12794.12,1165414.5900000001]
[63,31,"Июль",2018,12794.12,2648.63,10145.49,43312,12794.12,1162765.96]
[64,31,"Август",2018,12794.12,2671.68,10122.44,43343,12794.12,1160094.28]
[65,30,"Сентябрь",2018,12794.12,3020.72,9773.4,43373,12794.12,1157073.56]
[66,31,"Октябрь",2018,12794.12,2721.24,10072.879999999999,43404,12794.12,1154352.32]
[67,30,"Ноябрь",2018,12794.12,3069.1,9725.02,43434,12794.12,1151283.22]
[68,31,"Декабрь",2018,12794.12,2771.65,10022.469999999999,43465,12794.12,1148511.57]
[69,31,"Январь",2019,12794.12,2795.78,9998.34,43496,12794.12,1145715.79]
[70,28,"Февраль",2019,12794.12,3785.34,9008.7800000000007,43524,12794.12,1141930.45]
[71,31,"Март",2019,12794.12,2853.07,9941.0499999999993,43555,12794.12,1139077.3799999999]
[72,30,"Апрель",2019,12794.12,3197.78,9596.34,43585,12794.12,1135879.6000000001]
[73,31,"Май",2019,12794.12,2905.74,9888.3799999999992,43616,12794.12,1132973.8600000001]
[74,30,"Июнь",2019,12794.12,3249.2,9544.92,43646,12794.12,1129724.6599999999]
[75,31,"Июль",2019,12794.12,2959.33,9834.7900000000009,43677,12794.12,1126765.33]
[76,31,"Август",2019,12794.12,2985.09,9809.0300000000007,43708,12794.12,1123780.24]
[77,30,"Сентябрь",2019,12794.12,3326.66,9467.4599999999991,43738,12794.12,1120453.58]
[78,31,"Октябрь",2019,12794.12,3040.03,9754.09,43769,12794.12,1117413.55]
[79,30,"Ноябрь",2019,12794.12,3380.29,9413.83,43799,12794.12,1114033.26]
[80,31,"Декабрь",2019,12794.12,3095.93,9698.19,43830,12794.12,1110937.33]
[81,31,"Январь",2020,12794.12,3149.3,9644.82,43861,12794.12,1107788.03]
[82,29,"Февраль",2020,12794.12,3797.13,8996.99,43890,12794.12,1103990.8999999999]
[83,31,"Март",2020,12794.12,3209.61,9584.51,43921,12794.12,1100781.29]
[84,30,"Апрель",2020,12794.12,3545.75,9248.3700000000008,43951,12794.12,1097235.54]
[85,31,"Май",2020,12794.12,3268.26,9525.86,43982,12794.12,1093967.28]
[86,30,"Июнь",2020,12794.12,3603,9191.1200000000008,44012,12794.12,1090364.28]
[87,31,"Июль",2020,12794.12,3327.91,9466.2099999999991,44043,12794.12,1087036.3700000001]
[88,31,"Август",2020,12794.12,3356.8,9437.32,44074,12794.12,1083679.57]
[89,30,"Сентябрь",2020,12794.12,3689.44,9104.68,44104,12794.12,1079990.1299999999]
[90,31,"Октябрь",2020,12794.12,3417.98,9376.14,44135,12794.12,1076572.1499999999]
[91,30,"Ноябрь",2020,12794.12,3749.15,9044.9699999999993,44165,12794.12,1072823]
[92,31,"Декабрь",2020,12794.12,3480.2,9313.92,44196,12794.12,1069342.8]
[93,31,"Январь",2021,12794.12,3484.98,9309.14,44227,12794.12,1065857.82]
[94,28,"Февраль",2021,12794.12,4413.2700000000004,8380.85,44255,12794.12,1061444.55]
[95,31,"Март",2021,12794.12,3553.74,9240.3799999999992,44286,12794.12,1057890.81]
[96,30,"Апрель",2021,12794.12,3881.75,8912.3700000000008,44316,12794.12,1054009.06]
[97,31,"Май",2021,12794.12,3618.47,9175.65,44347,12794.12,1050390.5900000001]
[98,30,"Июнь",2021,12794.12,3944.94,8849.18,44377,12794.12,1046445.65]
[99,31,"Июль",2021,12794.12,3684.31,9109.81,44408,12794.12,1042761.34]
[100,31,"Август",2021,12794.12,3716.38,9077.74,44439,12794.12,1039044.96]
[101,30,"Сентябрь",2021,12794.12,4040.52,8753.6,44469,12794.12,1035004.44]
[102,31,"Октябрь",2021,12794.12,3783.91,9010.2099999999991,44500,12794.12,1031220.53]
[103,30,"Ноябрь",2021,12794.12,4106.4399999999996,8687.68,44530,12794.12,1027114.09]
[104,31,"Декабрь",2021,12794.12,3852.6,8941.52,44561,12794.12,1023261.49]
[105,31,"Январь",2022,12794.12,3886.14,8907.98,44592,12794.12,1019375.35]
[106,28,"Февраль",2022,12794.12,4778.76,8015.36,44620,12794.12,1014596.59]
[107,31,"Март",2022,12794.12,3961.57,8832.5499999999993,44651,12794.12,1010635.02]
[108,30,"Апрель",2022,12794.12,4279.87,8514.25,44681,12794.12,1006355.15]
[109,31,"Май",2022,12794.12,4033.32,8760.7999999999993,44712,12794.12,1002321.83]
[110,30,"Июнь",2022,12794.12,4349.8999999999996,8444.2199999999993,44742,12794.12,997971.93]
[111,31,"Июль",2022,12794.12,4106.3,8687.82,44773,12794.12,993865.63]
[112,31,"Август",2022,12794.12,4142.04,8652.08,44804,12794.12,989723.59]
[113,30,"Сентябрь",2022,12794.12,4456.04,8338.08,44834,12794.12,985267.55]
[114,31,"Октябрь",2022,12794.12,4216.8900000000003,8577.23,44865,12794.12,981050.66]
[115,30,"Ноябрь",2022,12794.12,4529.1000000000004,8265.02,44895,12794.12,976521.56]
[116,31,"Декабрь",2022,12794.12,4293.03,8501.09,44926,12794.12,972228.53]
[117,31,"Январь",2023,12794.12,4330.3999999999996,8463.7199999999993,44957,12794.12,967898.13]
[118,28,"Февраль",2023,12794.12,5183.5200000000004,7610.6,44985,12794.12,962714.61]
[119,31,"Март",2023,12794.12,4413.2299999999996,8380.89,45016,12794.12,958301.38]
[120,30,"Апрель",2023,12794.12,4720.76,8073.36,45046,12794.12,953580.62]
[121,31,"Май",2023,12794.12,4492.74,8301.3799999999992,45077,12794.12,949087.88]
[122,30,"Июнь",2023,12794.12,4798.38,7995.74,45107,12794.12,944289.5]
[123,31,"Июль",2023,12794.12,4573.63,8220.49,45138,12794.12,939715.87]
[124,31,"Август",2023,12794.12,4613.4399999999996,8180.68,45169,12794.12,935102.43]
[125,30,"Сентябрь",2023,12794.12,4916.2,7877.92,45199,12794.12,930186.23]
[126,31,"Октябрь",2023,12794.12,4696.3999999999996,8097.72,45230,12794.12,925489.83]
[127,30,"Ноябрь",2023,12794.12,4997.1899999999996,7796.93,45260,12794.12,920492.64]
[128,31,"Декабрь",2023,12794.12,4780.79,8013.33,45291,12794.12,915711.85]
[129,31,"Январь",2024,12794.12,4844.1899999999996,7949.93,45322,12794.12,910867.66]
[130,29,"Февраль",2024,12794.12,5396.43,7397.69,45351,12794.12,905471.23]
[131,31,"Март",2024,12794.12,4933.1000000000004,7861.02,45382,12794.12,900538.13]
[132,30,"Апрель",2024,12794.12,5228.12,7566,45412,12794.12,895310.01]
[133,31,"Май",2024,12794.12,5021.3100000000004,7772.81,45443,12794.12,890288.7]
[134,30,"Июнь",2024,12794.12,5314.24,7479.88,45473,12794.12,884974.46]
[135,31,"Июль",2024,12794.12,5111.04,7683.08,45504,12794.12,879863.42]
[136,31,"Август",2024,12794.12,5155.42,7638.7,45535,12794.12,874708]
[137,30,"Сентябрь",2024,12794.12,5445.14,7348.98,45565,12794.12,869262.86]
[138,31,"Октябрь",2024,12794.12,5247.45,7546.67,45596,12794.12,864015.41]
[139,30,"Ноябрь",2024,12794.12,5534.97,7259.15,45626,12794.12,858480.44]
[140,31,"Декабрь",2024,12794.12,5341.06,7453.06,45657,12794.12,853139.38]
[141,31,"Январь",2025,12794.12,5367.13,7426.99,45688,12794.12,847772.25]
[142,28,"Февраль",2025,12794.12,6128.08,6666.04,45716,12794.12,841644.17]
[143,31,"Март",2025,12794.12,5467.2,7326.92,45747,12794.12,836176.97]
[144,30,"Апрель",2025,12794.12,5749.62,7044.5,45777,12794.12,830427.35]
[145,31,"Май",2025,12794.12,5564.85,7229.27,45808,12794.12,824862.5]
[146,30,"Июнь",2025,12794.12,5844.94,6949.18,45838,12794.12,819017.56]
[147,31,"Июль",2025,12794.12,5664.18,7129.94,45869,12794.12,813353.38]
[148,31,"Август",2025,12794.12,5713.49,7080.63,45900,12794.12,807639.89]
[149,30,"Сентябрь",2025,12794.12,5990.03,6804.09,45930,12794.12,801649.86]
[150,31,"Октябрь",2025,12794.12,5815.37,6978.75,45961,12794.12,795834.49]
[151,30,"Ноябрь",2025,12794.12,6089.49,6704.63,45991,12794.12,789745]
[152,31,"Декабрь",2025,12794.12,5919.01,6875.11,46022,12794.12,783825.99]
[153,31,"Январь",2026,12794.12,5970.54,6823.58,46053,12794.12,777855.45]
[154,28,"Февраль",2026,12794.12,6677.83,6116.29,46081,12794.12,771177.62]
[155,31,"Март",2026,12794.12,6080.65,6713.47,46112,12794.12,765096.97]
[156,30,"Апрель",2026,12794.12,6348.44,6445.68,46142,12794.12,758748.53]
[157,31,"Май",2026,12794.12,6188.85,6605.27,46173,12794.12,752559.68]
[158,30,"Июнь",2026,12794.12,6454.06,6340.06,46203,12794.12,746105.62]
[159,31,"Июль",2026,12794.12,6298.91,6495.21,46234,12794.12,739806.71]
[160,31,"Август",2026,12794.12,6353.75,6440.37,46265,12794.12,733452.96]
[161,30,"Сентябрь",2026,12794.12,6615.03,6179.09,46295,12794.12,726837.93]
[162,31,"Октябрь",2026,12794.12,6466.65,6327.47,46326,12794.12,720371.28]
[163,30,"Ноябрь",2026,12794.12,6725.24,6068.88,46356,12794.12,713646.04]
[164,31,"Декабрь",2026,12794.12,6581.49,6212.63,46387,12794.12,707064.55]
[165,31,"Январь",2027,12794.12,6638.78,6155.34,46418,12794.12,700425.77]
[166,28,"Февраль",2027,12794.12,7286.66,5507.46,46446,12794.12,693139.11]
[167,31,"Март",2027,12794.12,6760.01,6034.11,46477,12794.12,686379.1]
[168,30,"Апрель",2027,12794.12,7011.61,5782.51,46507,12794.12,679367.49]
[169,31,"Май",2027,12794.12,6879.9,5914.22,46538,12794.12,672487.59]
[170,30,"Июнь",2027,12794.12,7128.64,5665.48,46568,12794.12,665358.94999999995]
[171,31,"Июль",2027,12794.12,7001.85,5792.27,46599,12794.12,658357.1]
[172,31,"Август",2027,12794.12,7062.81,5731.31,46630,12794.12,651294.29]
[173,30,"Сентябрь",2027,12794.12,7307.19,5486.93,46660,12794.12,643987.1]
[174,31,"Октябрь",2027,12794.12,7187.9,5606.22,46691,12794.12,636799.19999999995]
[175,30,"Ноябрь",2027,12794.12,7429.3,5364.82,46721,12794.12,629369.9]
[176,31,"Декабрь",2027,12794.12,7315.15,5478.97,46752,12794.12,622054.75]
[177,31,"Январь",2028,12794.12,7393.63,5400.49,46783,12794.12,614661.12]
[178,29,"Февраль",2028,12794.12,7802.1,4992.0200000000004,46812,12794.12,606859.02]
[179,31,"Март",2028,12794.12,7525.56,5268.56,46843,12794.12,599333.46]
[180,30,"Апрель",2028,12794.12,7758.74,5035.38,46873,12794.12,591574.72]
[181,31,"Май",2028,12794.12,7658.25,5135.87,46904,12794.12,583916.47]
[182,30,"Июнь",2028,12794.12,7888.26,4905.8599999999997,46934,12794.12,576028.21]
[183,31,"Июль",2028,12794.12,7793.22,5000.8999999999996,46965,12794.12,568234.99]
[184,31,"Август",2028,12794.12,7860.88,4933.24,46996,12794.12,560374.11]
[185,30,"Сентябрь",2028,12794.12,8086.06,4708.0600000000004,47026,12794.12,552288.05000000005]
[186,31,"Октябрь",2028,12794.12,7999.32,4794.8,47057,12794.12,544288.73]
[187,30,"Ноябрь",2028,12794.12,8221.2000000000007,4572.92,47087,12794.12,536067.53]
[188,31,"Декабрь",2028,12794.12,8140.15,4653.97,47118,12794.12,527927.38]
[189,31,"Январь",2029,12794.12,8198.26,4595.8599999999997,47149,12794.12,519729.12]
[190,28,"Февраль",2029,12794.12,8707.48,4086.64,47177,12794.12,511021.64]
[191,31,"Март",2029,12794.12,8345.43,4448.6899999999996,47208,12794.12,502676.21]
[192,30,"Апрель",2029,12794.12,8559.25,4234.87,47238,12794.12,494116.96]
[193,31,"Май",2029,12794.12,8492.59,4301.53,47269,12794.12,485624.37]
[194,30,"Июнь",2029,12794.12,8702.9,4091.22,47299,12794.12,476921.47]
[195,31,"Июль",2029,12794.12,8642.2900000000009,4151.83,47330,12794.12,468279.18]
[196,31,"Август",2029,12794.12,8717.5300000000007,4076.59,47361,12794.12,459561.65]
[197,30,"Сентябрь",2029,12794.12,8922.4699999999993,3871.65,47391,12794.12,450639.18]
[198,31,"Октябрь",2029,12794.12,8871.09,3923.03,47422,12794.12,441768.09]
[199,30,"Ноябрь",2029,12794.12,9072.3799999999992,3721.74,47452,12794.12,432695.71]
[200,31,"Декабрь",2029,12794.12,9027.2999999999993,3766.82,47483,12794.12,423668.41]
[201,31,"Январь",2030,12794.12,9105.8799999999992,3688.24,47514,12794.12,414562.53]
[202,28,"Февраль",2030,12794.12,9534.41,3259.71,47542,12794.12,405028.12]
[203,31,"Март",2030,12794.12,9268.16,3525.96,47573,12794.12,395759.96]
[204,30,"Апрель",2030,12794.12,9459.98,3334.14,47603,12794.12,386299.98]
[205,31,"Май",2030,12794.12,9431.19,3362.93,47634,12794.12,376868.79]
[206,30,"Июнь",2030,12794.12,9619.1299999999992,3174.99,47664,12794.12,367249.66]
[207,31,"Июль",2030,12794.12,9597.0400000000009,3197.08,47695,12794.12,357652.62]
[208,31,"Август",2030,12794.12,9680.58,3113.54,47726,12794.12,347972.04]
[209,30,"Сентябрь",2030,12794.12,9862.57,2931.55,47756,12794.12,338109.47]
[210,31,"Октябрь",2030,12794.12,9850.7099999999991,2943.41,47787,12794.12,328258.76]
[211,30,"Ноябрь",2030,12794.12,10028.65,2765.47,47817,12794.12,318230.11]
[212,31,"Декабрь",2030,12794.12,10023.77,2770.35,47848,12794.12,308206.34000000003]
[213,31,"Январь",2031,12794.12,10111.040000000001,2683.08,47879,12794.12,298095.3]
[214,28,"Февраль",2031,12794.12,10450.19,2343.9299999999998,47907,12794.12,287645.11]
[215,31,"Март",2031,12794.12,10290.030000000001,2504.09,47938,12794.12,277355.08]
[216,30,"Апрель",2031,12794.12,10457.5,2336.62,47968,12794.12,266897.58]
[217,31,"Май",2031,12794.12,10470.65,2323.4699999999998,47999,12794.12,256426.93]
[218,30,"Июнь",2031,12794.12,10633.81,2160.31,48029,12794.12,245793.12]
[219,31,"Июль",2031,12794.12,10654.37,2139.75,48060,12794.12,235138.75]
[220,31,"Август",2031,12794.12,10747.12,2047,48091,12794.12,224391.63]
[221,30,"Сентябрь",2031,12794.12,10903.7,1890.42,48121,12794.12,213487.93]
[222,31,"Октябрь",2031,12794.12,10935.61,1858.51,48152,12794.12,202552.32000000001]
[223,30,"Ноябрь",2031,12794.12,11087.69,1706.43,48182,12794.12,191464.63]
[224,31,"Декабрь",2031,12794.12,11127.33,1666.79,48213,12794.12,180337.3]
[225,31,"Январь",2032,12794.12,11228.49,1565.63,48244,12794.12,169108.81]
[226,29,"Февраль",2032,12794.12,11420.69,1373.43,48273,12794.12,157688.12]
[227,31,"Март",2032,12794.12,11425.12,1369,48304,12794.12,146263]
[228,30,"Апрель",2032,12794.12,11565.27,1228.8499999999999,48334,12794.12,134697.73000000001]
[229,31,"Май",2032,12794.12,11624.72,1169.4000000000001,48365,12794.12,123073.01]
[230,30,"Июнь",2032,12794.12,11760.1,1034.02,48395,12794.12,111312.91]
[231,31,"Июль",2032,12794.12,11827.74,966.38,48426,12794.12,99485.17]
[232,31,"Август",2032,12794.12,11930.42,863.7,48457,12794.12,87554.75]
[233,30,"Сентябрь",2032,12794.12,12058.52,735.6,48487,12794.12,75496.23]
[234,31,"Октябрь",2032,12794.12,12138.68,655.44,48518,12794.12,63357.55]
[235,30,"Ноябрь",2032,12794.12,12261.81,532.30999999999995,48548,12794.12,51095.74]
[236,31,"Декабрь",2032,12794.12,12350.52,443.6,48579,12794.12,38745.22]
[237,31,"Январь",2033,12794.12,12456.82,337.3,48610,12794.12,26288.400000000001]
[238,28,"Февраль",2033,12794.12,12587.41,206.71,48638,12794.12,13700.99]
[239,31,"Март",2033,12794.12,12674.85,119.27,48669,12794.12,1026.1400000000001]
[240,30,"Апрель",2033,1034.7800000000002,1026.1400000000001,8.64,48699,1034.7800000000002,0]
[null,null,null,"ИТОГО",3478364.3900000206,1708746.9999999998,1769617.39]

{"sheet":"Процентная ставка","index":2,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["МСК (Вторичный рынок)",null,null,null,null,null,null,null,"МСК (первичный рынок)"]
["K<=0,5 от макс. К",null,null,null,null,null,null,null,"K<=0,5 от макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+",null,"К/з",60,"61-131","132+"]
[50,8.85,10.85,11.15,11.200000000000001,11.25,11.3,null,50,7.65,9.6999999999999993,9.8000000000000007]
[60,11,11,11.3,11.35,11.4,11.450000000000001,null,60,9.6999999999999993,9.85,9.9499999999999993]
[70,11.200000000000001,11.200000000000001,11.450000000000001,11.500000000000002,11.55,11.6,null,70,10,10.15,10.25]
[80,11.25,11.25,11.500000000000002,11.55,11.6,11.65,null,80,10.1,10.25,10.35]
[0,0,0,0,0,0,0,null,80,10.35,10.5,10.6]
["0,5 от макс. К<K<=0,75 от макс. К",null,null,null,null,null,null,null,"0,5 от макс. К<K<=0,75 от макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+",null,"К/з",60,"61-131","132+"]
[50,10.549999999999999,10.85,11.15,11.200000000000001,11.25,11.3,null,50,7.65,9.8000000000000007,9.9]
[60,11.049999999999999,11.049999999999999,11.35,11.4,11.450000000000001,11.500000000000002,null,60,9.8000000000000007,9.9499999999999993,10.050000000000001]
[70,11.25,11.25,11.55,11.6,11.65,11.7,null,70,10.1,10.25,10.35]
[80,11.3,11.3,11.6,11.65,11.7,11.749999999999998,null,80,10.199999999999999,10.35,10.45]
[0,0,0,0,0,0,0,null,80,10.45,10.6,10.7]
["0,75 от макс. К<K<= макс. К",null,null,null,null,null,null,null,"0,75 от макс. К<K<= макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+",null,"К/з",60,"61-131","132+"]
[50,10.549999999999999,10.85,11.15,11.200000000000001,11.25,11.3,null,50,7.65,9.9,10]
[60,11.049999999999999,11.049999999999999,11.35,11.4,11.450000000000001,11.500000000000002,null,60,9.9,10.050000000000001,10.15]
[70,11.35,11.35,11.65,11.7,11.749999999999998,11.799999999999999,null,70,10.199999999999999,10.35,10.45]
[80,11.4,11.4,11.7,11.749999999999998,11.799999999999999,11.85,null,80,10.3,10.45,10.55]
[0,0,0,0,0,0,0,null,80,10.55,10.65,10.75]
["макс. К<K<= 1,25 макс. К",null,null,null,null,null,null,null,"макс. К<K<= 1,25 макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+",null,"К/з",60,"61-131","132+"]
[50,10.6,10.950000000000001,11.25,11.3,11.35,11.4,null,50,9.85,10,10.1]
[60,11.15,11.15,11.450000000000001,11.500000000000002,11.55,11.6,null,60,10,10.15,10.25]
[70,11.450000000000001,11.450000000000001,11.749999999999998,11.799999999999999,11.85,11.9,null,70,10.4,10.45,10.55]
[80,11.450000000000001,11.450000000000001,11.749999999999998,11.799999999999999,11.85,11.9,null,80,10.65,10.75,10.75]
[0,0,0,0,0,0,0,null,90,0,0,0]
["1,25 макс. К<K<= 1,5 макс. К",null,null,null,null,null,null,null,"1,25 макс. К<K<= 1,5 макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+",null,"К/з",60,"61-131","132+"]
[50,10.65,11.1,11.4,11.450000000000001,11.500000000000002,11.55,null,50,9.85,10,10.1]
[60,11.35,11.35,11.65,11.7,11.749999999999998,11.799999999999999,null,60,10.1,10.25,10.35]
[70,11.55,11.55,11.85,11.9,11.95,12,null,70,10.75,10.75,10.75]
[80,11.6,11.6,11.9,11.95,12,12.049999999999999,null,80,10.75,10.75,10.75]
[0,0,0,0,0,0,0,null,90,0,0,0]

{"sheet":"Настройки","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[1,1,1,2],[4,3,6,3],[7,3,9,3],[12,1,12,2]]}
[9.5500000000000002E-2]
[null,"Ставки по кредиту"]
[null,"Наличие личного страхования","Отсутствие личного страхования"]
["К/З, в %%",null,null,null,null,null,null,"КВАЛИФИЦИРОВАН"]
["30-50",10.25,{"$f":"B5+0.7","v":10.95},"Первичный рынок жилья",null,null,null,"НЕ квалифицирован"]
["51-60",10.5,11.2,null,null,null,null,"НЕ хватает данных"]
["61-70",10.75,11.45]
["30-50",{"$f":"B5+1","v":11.25},11.95,"Вторичный рынок жилья"]
["51-60",{"$f":"B6+1","v":11.5},12.2]
["61-70",{"$f":"B7+1","v":11.75},12.45]
[]
[null,null,null,null,null,null,null,"429 тысяч 408 рублей 50 копеек"]
[null,"Константы",null,"При страховании ответственности"]
[null,0.3,"Минимальное значение К/З"]
[null,0.7,"Максимальное значение К/З (Часть-1/Залог )",0.8,"Максимальное значение К/З (Часть-1/Залог )"]
[null,0.9,"Максимальное значение К/З ((Часть-1+Часть-2)/Залог  )",0.9,"Максимальное значение К/З ((Часть-1+Часть-2)/Залог  )"]
[null,4000000,"Максимальный размер Части-1","При покупке на первичном рынке"]
[null,300000,"Минимальный размер Части-1",0.8,"Максимальное значение К/З (Часть-1/Залог )"]
[null,429408.5,"Максимальный размер Части-2"]
[null,100000,"Минимальный размер Части-2"]
[null,0.45,"Максимальное значение П/Д"]
[null,6.5000000000000002E-2,"Значение уровня инфляции"]
[]
[]
[]
[]
[null,null,"keshstavka"]

{"sheet":"Макс. кредит","index":4,"n_rows":85,"n_cols":91,"rows_kept":85,"cut":false,"hidden":true,"merged":[[6,3,11,3],[1,3,5,3]]}
[10,"Алтайский край",30585,null,"к/з min, % ","к/з max, % (включительно)","Алтайский край","Амурская область","Архангельская область","Астраханская область","Белгородская область","Брянская область","Владимирская область","Волгоградская область","Вологодская область","Воронежская область","г. Владивосток","г. Сочи","г.Москва","г.Санкт-Петербург","Еврейская автономная область","Забайкальский край","Ивановская область","Иркутская область","Кабардино-Балкарская Республика","Калининградская область","Калужская область","Камчатский край","Карачаево-Черкесская Республика","Кемеровская область","Кировская область","Костромская область","Краснодарский край","Красноярский край","Курганская область","Курская область","Ленинградская область","Липецкая область","Магаданская область","Московская область","Мурманская область","Ненецкий автономный округ","Нижегородская область","Новгородская область","Новосибирская область","Омская область","Оренбургская область","Орловская область","Пензенская область","Пермский край","Приморский край (за исключением г. Владивосток)","Псковская область","Республика Адыгея","Республика Алтай","Республика Башкортостан","Республика Бурятия","Республика Дагестан","Республика Ингушетия","Республика Калмыкия","Республика Карелия","Республика Коми","Республика Марий Эл","Республика Мордовия","Республика Саха (Якутия)","Республика Северная Осетия - Алания","Республика Татарстан","Республика Тыва","Республика Хакасия","Ростовская область","Рязанская область","Самарская область","Саратовская область","Сахалинская область","Свердловская область","Смоленская область","Ставропольский край","Тамбовская область","Тверская область","Томская область","Тульская область","Тюменская область","Удмуртская Республика","Ульяновская область","Хабаровский край","Ханты-Мансийский автономный округ - Югра","Челябинская область","Чеченская Республика","Чувашская Республика","Чукотский автономный округ","Ямало-Ненецкий автономный округ","Ярославская область"]
[11,"Амурская область",39345,"Вторичка",30,50,2.7,4.2,3.2,2.4,3.2,2.6,3.1,3,2.7,2.8,5,6.1,10,5.7,2.6,2.8,2.7,3.5,2.6,3,4.2,3.2,1.9,2.9,2.6,2.8,3,3.2,2.6,2.1,3.9,2.8,2.6,7.1,2.6,3.2,3.2,2.9,3.1,2.6,2.8,2.4,2.7,3.1,3.1,2.7,2.1,2.8,3.5,2.7,2.7,1.7,2.1,3.1,3.9,2.7,2.7,4.0999999999999996,1.9,3.5,3.1,2.9,3.9,2.9,3,2.1,4.2,4.0999999999999996,3,2.6,2.4,3.1,3,2.9,3.1,2.8,2.6,4.0999999999999996,5,2.7,1.8,2.8,2.6,3.9,3.1]
[5,"Архангельская область",39695,null,50,60,2.4,3.8,2.9,2.1,2.9,2.2999999999999998,2.8,2.7,2.4,2.5,4.5,5.5,9,5.0999999999999996,2.2999999999999998,2.5,2.4,3.1,2.2999999999999998,2.7,3.8,2.9,1.7,2.6,2.2999999999999998,2.5,2.7,2.9,2.2999999999999998,1.9,3.5,2.5,2.2999999999999998,6.4,2.2999999999999998,2.9,2.9,2.6,2.8,2.2999999999999998,2.5,2.1,2.4,2.8,2.8,2.4,1.9,2.5,3.1,2.4,2.4,1.5,1.9,2.8,3.5,2.4,2.4,3.7,1.7,3.1,2.8,2.6,3.5,2.6,2.7,1.9,3.8,3.7,2.7,2.2999999999999998,2.1,2.8,2.7,2.6,2.8,2.5,2.2999999999999998,3.7,4.5,2.4,1.6,2.5,2.2999999999999998,3.5,2.8]
[3,"Астраханская область",25755,null,60,70,2.1,3.4,2.6,1.9,2.6,2,2.5,2.4,2.1,2.2000000000000002,4,4.9000000000000004,8,4.5999999999999996,2,2.2000000000000002,2.1,2.8,2,2.4,3.4,2.6,1.5,2.2999999999999998,2,2.2000000000000002,2.4,2.6,2,1.7,3.1,2.2000000000000002,2,5.8,2,2.6,2.6,2.2999999999999998,2.5,2,2.2000000000000002,1.9,2.1,2.5,2.5,2.1,1.7,2.2000000000000002,2.8,2.1,2.1,1.3,1.7,2.5,3.1,2.1,2.1,3.3,1.5,2.8,2.5,2.2999999999999998,3.1,2.2999999999999998,2.4,1.7,3.4,3.3,2.4,2,1.9,2.5,2.4,2.2999999999999998,2.5,2.2000000000000002,2,3.3,4,2.1,1.4,2.2000000000000002,2,3.1,2.5]
[3,"Белгородская область",31290,null,70,80,1.9,3.1,2.4,1.7,2.4,1.8,2.2999999999999998,2.2000000000000002,1.9,2,3.6,4.4000000000000004,7.3,4.2,1.8,2,1.9,2.5,1.8,2.2000000000000002,3.1,2.4,1.4,2.1,1.8,2,2.2000000000000002,2.4,1.8,1.5,2.8,2,1.8,5.3,1.8,2.4,2.4,2.1,2.2999999999999998,1.8,2,1.7,1.9,2.2999999999999998,2.2999999999999998,1.9,1.5,2,2.5,1.9,1.9,1.2,1.5,2.2999999999999998,2.8,1.9,1.9,3,1.4,2.5,2.2999999999999998,2.1,2.8,2.1,2.2000000000000002,1.5,3.1,3,2.2000000000000002,1.8,1.7,2.2999999999999998,2.2000000000000002,2.1,2.2999999999999998,2,1.8,3,3.6,1.9,1.3,2,1.8,2.8,2.2999999999999998]
[4,"Брянская область",26975,null,80,90,1.7,2.8,2.2000000000000002,1.5,2.2000000000000002,1.6,2.1,2,1.7,1.8,3.3,4,6.6,3.8,1.6,1.8,1.7,2.2999999999999998,1.6,2,2.8,2.2000000000000002,1.3,1.9,1.6,1.8,2,2.2000000000000002,1.6,1.4,2.5,1.8,1.6,4.8,1.6,2.2000000000000002,2.2000000000000002,1.9,2.1,1.6,1.8,1.5,1.7,2.1,2.1,1.7,1.4,1.8,2.2999999999999998,1.7,1.7,1.1000000000000001,1.4,2.1,2.5,1.7,1.7,2.7,1.3,2.2999999999999998,2.1,1.9,2.5,1.9,2,1.4,2.8,2.7,2,1.6,1.5,2.1,2,1.9,2.1,1.8,1.6,2.7,3.3,1.7,1.2,1.8,1.6,2.5,2.1]
[3,"Владимирская область",31965,"Первичка","к/з min","к/з max (включительно)"]
[4,"Волгоградская область",31100,null,30,50,2.7,4.2,3.2,2.4,3.2,2.6,3.1,3,2.7,2.8,5,6.1,10,5.7,2.6,2.8,2.7,3.5,2.6,3,4.2,3.2,1.9,2.9,2.6,2.8,3,3.2,2.6,2.1,3.9,2.8,2.6,7.1,2.6,3.2,3.2,2.9,3.1,2.6,2.8,2.4,2.7,3.1,3.1,2.7,2.1,2.8,3.5,2.7,2.7,1.7,2.1,3.1,3.9,2.7,2.7,4.0999999999999996,1.9,3.5,3.1,2.9,3.9,2.9,3,2.1,4.2,4.0999999999999996,3,2.6,2.4,3.1,3,2.9,3.1,2.8,2.6,4.0999999999999996,5,2.7,1.8,2.8,2.6,3.9,3.1]
[4,"Вологодская область",34410,null,50,60,2.4,3.8,2.9,2.1,2.9,2.2999999999999998,2.8,2.7,2.4,2.5,4.5,5.5,9,5.0999999999999996,2.2999999999999998,2.5,2.4,3.1,2.2999999999999998,2.7,3.8,2.9,1.7,2.6,2.2999999999999998,2.5,2.7,2.9,2.2999999999999998,1.9,3.5,2.5,2.2999999999999998,6.4,2.2999999999999998,2.9,2.9,2.6,2.8,2.2999999999999998,2.5,2.1,2.4,2.8,2.8,2.4,1.9,2.5,3.1,2.4,2.4,1.5,1.9,2.8,3.5,2.4,2.4,3.7,1.7,3.1,2.8,2.6,3.5,2.6,2.7,1.9,3.8,3.7,2.7,2.2999999999999998,2.1,2.8,2.7,2.6,2.8,2.5,2.2999999999999998,3.7,4.5,2.4,1.6,2.5,2.2999999999999998,3.5,2.8]
[4,"Воронежская область",31215,null,60,70,2.1,3.4,2.6,1.9,2.6,2,2.5,2.4,2.1,2.2000000000000002,4,4.9000000000000004,8,4.5999999999999996,2,2.2000000000000002,2.1,2.8,2,2.4,3.4,2.6,1.5,2.2999999999999998,2,2.2000000000000002,2.4,2.6,2,1.7,3.1,2.2000000000000002,2,5.8,2,2.6,2.6,2.2999999999999998,2.5,2,2.2000000000000002,1.9,2.1,2.5,2.5,2.1,1.7,2.2000000000000002,2.8,2.1,2.1,1.3,1.7,2.5,3.1,2.1,2.1,3.3,1.5,2.8,2.5,2.2999999999999998,3.1,2.2999999999999998,2.4,1.7,3.4,3.3,2.4,2,1.9,2.5,2.4,2.2999999999999998,2.5,2.2000000000000002,2,3.3,4,2.1,1.4,2.2000000000000002,2,3.1,2.5]
[4,"г.Москва",90400,null,70,80,1.9,3.1,2.4,1.7,2.4,1.8,2.2999999999999998,2.2000000000000002,1.9,2,3.6,4.4000000000000004,7.3,4.2,1.8,2,1.9,2.5,1.8,2.2000000000000002,3.1,2.4,1.4,2.1,1.8,2,2.2000000000000002,2.4,1.8,1.5,2.8,2,1.8,5.3,1.8,2.4,2.4,2.1,2.2999999999999998,1.8,2,1.7,1.9,2.2999999999999998,2.2999999999999998,1.9,1.5,2,2.5,1.9,1.9,1.2,1.5,2.2999999999999998,2.8,1.9,1.9,3,1.4,2.5,2.2999999999999998,2.1,2.8,2.1,2.2000000000000002,1.5,3.1,3,2.2000000000000002,1.8,1.7,2.2999999999999998,2.2000000000000002,2.1,2.2999999999999998,2,1.8,3,3.6,1.9,1.3,2,1.8,2.8,2.2999999999999998]
[4,"г.Санкт-Петербург",56125,null,80,90,1.7,2.8,2.2000000000000002,1.5,2.2000000000000002,1.6,2.1,2,1.7,1.8,3.3,4,6.6,3.8,1.6,1.8,1.7,2.2999999999999998,1.6,2,2.8,2.2000000000000002,1.3,1.9,1.6,1.8,2,2.2000000000000002,1.6,1.4,2.5,1.8,1.6,4.8,1.6,2.2000000000000002,2.2000000000000002,1.9,2.1,1.6,1.8,1.5,1.7,2.1,2.1,1.7,1.4,1.8,2.2999999999999998,1.7,1.7,1.1000000000000001,1.4,2.1,2.5,1.7,1.7,2.7,1.3,2.2999999999999998,2.1,1.9,2.5,1.9,2,1.4,2.8,2.7,2,1.6,1.5,2.1,2,1.9,2.1,1.8,1.6,2.7,3.3,1.7,1.2,1.8,1.6,2.5,2.1]
[5,"Еврейская автономная область",31450]
[4,"Забайкальский край",31530]
[5,"Ивановская область",28185]
[4,"Иркутская область",34410]
[6,"Кабардино-Балкарская Республика",27010,null,null,"Коэффициент К/З (%):","до 50","51-60","61-70","71-80","81-90"]
[3,"Калининградская область",31690,null,null,"Максимальная сумма (млн.руб.)\n(за исключением Москвы)",7.1,6.4,5.8,5.3,4.8]
[3,"Калужская область",37950,null,null,"Максимальная сумма для Москвы (млн. руб.)",10,9,8,7.3,6.6]
[2,"Камчатский край",40640]
[6,"Карачаево-Черкесская Республика",22310]
[3,"Кемеровская область",30635]
[4,"Кировская область",31535]
[5,"Костромская область",29150]
[3,"Краснодарский край",34015]
[3,"Красноярский край",37790]
[4,"Курганская область",29710]
[5,"Курская область",25550]
[3,"Ленинградская область",40210]
[3,"Липецкая область",30260]
[4,"Магаданская область",39750]
[1,"Московская область",49730]
[5,"Мурманская область",35820]
[3,"Ненецкий автономный округ",51920]
[3,"Нижегородская область",37350]
[3,"Новгородская область",32330]
[3,"Новосибирская область",35980]
[4,"Омская область",30975]
[4,"Оренбургская область",29230]
[4,"Орловская область",26920]
[4,"Пензенская область",29425]
[3,"Пермский край",32742]
[3,"Приморский край (за исключением г. Владивосток)",45830]
[4,"Псковская область",32050]
[5,"Республика Адыгея",24280]
[4,"Республика Алтай",33845]
[3,"Республика Башкортостан",32395]
[4,"Республика Бурятия",31110]
[4,"Республика Дагестан",25450]
[6,"Республика Ингушетия",23857]
[6,"Республика Калмыкия",24075]
[3,"Республика Карелия",40065]
[3,"Республика Коми",37470]
[6,"Республика Марий Эл",31670]
[5,"Республика Мордовия",31450]
[2,"Республика Саха (Якутия)",43940]
[5,"Республика Северная Осетия - Алания",27790]
[3,"Республика Татарстан",31640]
[5,"Республика Тыва",33820]
[4,"Республика Хакасия",30370]
[3,"Ростовская область",34780]
[4,"Рязанская область",32450]
[2,"Самарская область",32240]
[5,"Саратовская область",26180]
[1,"Сахалинская область",51885]
[2,"Свердловская область",40820]
[4,"Смоленская область",30450]
[5,"Ставропольский край",24610]
[4,"Тамбовская область",27080]
[3,"Тверская область",36720]
[3,"Томская область",34450]
[3,"Тульская область",31565]
[2,"Тюменская область",38005]
[4,"Удмуртская Республика",32080]
[5,"Ульяновская область",28000]
[2,"Хабаровский край",44800]
[2,"Ханты-Мансийский автономный округ - Югра",40640]
[4,"Челябинская область",29050]
[6,"Чеченская Республика",22180]
[5,"Чувашская Республика",29185]
[5,"Чукотский автономный округ",31710]
[1,"Ямало-Ненецкий автономный округ",45850]
[4,"Ярославская область",35825]
[1,"г. Владивосток",45830]
[4,"г. Сочи",34015]

{"sheet":"Надбавки","index":5,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["МСК (Вторичный рынок)"]
["K<=0,5 от макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+"]
[50,2.3499999999999996,4.3499999999999996,4.6500000000000004,4.7,4.75,4.8000000000000007]
[60,4.5,4.5,4.8000000000000007,4.8500000000000005,4.9000000000000004,4.95]
[70,4.7,4.7,4.95,5.0000000000000009,5.0500000000000007,5.1000000000000005]
[80,4.75,4.75,5.0000000000000009,5.0500000000000007,5.1000000000000005,5.1499999999999995]
[0,0,0,0,0,0,0]
["0,5 от макс. К<K<=0,75 от макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+"]
[50,4.05,4.3499999999999996,4.6500000000000004,4.7,4.75,4.8000000000000007]
[60,4.55,4.55,4.8500000000000005,4.9000000000000004,4.95,5.0000000000000009]
[70,4.75,4.75,5.0500000000000007,5.1000000000000005,5.1499999999999995,5.1999999999999993]
[80,4.8000000000000007,4.8000000000000007,5.1000000000000005,5.1499999999999995,5.1999999999999993,5.2499999999999991]
[0,0,0,0,0,0,0]
["0,75 от макс. К<K<= макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+"]
[50,4.05,4.3499999999999996,4.6500000000000004,4.7,4.75,4.8000000000000007]
[60,4.55,4.55,4.8500000000000005,4.9000000000000004,4.95,5.0000000000000009]
[70,4.8500000000000005,4.8500000000000005,5.1499999999999995,5.1999999999999993,5.2499999999999991,5.2999999999999989]
[80,4.9000000000000004,4.9000000000000004,5.1999999999999993,5.2499999999999991,5.2999999999999989,5.35]
[0,0,0,0,0,0,0]
["макс. К<K<= 1,25 макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+"]
[50,4.0999999999999996,4.45,4.75,4.8000000000000007,4.8500000000000005,4.9000000000000004]
[60,4.6500000000000004,4.6500000000000004,4.95,5.0000000000000009,5.0500000000000007,5.1000000000000005]
[70,4.95,4.95,5.2499999999999991,5.2999999999999989,5.35,5.3999999999999995]
[80,4.95,4.95,5.2499999999999991,5.2999999999999989,5.35,5.3999999999999995]
[0,0,0,0,0,0,0]
["1,25 макс. К<K<= 1,5 макс. К"]
["К/з","до 12","13-36","37-60","61-84","85-120","120+"]
[50,4.1499999999999995,4.6000000000000005,4.9000000000000004,4.95,5.0000000000000009,5.0500000000000007]
[60,4.8500000000000005,4.8500000000000005,5.1499999999999995,5.1999999999999993,5.2499999999999991,5.2999999999999989]
[70,5.0500000000000007,5.0500000000000007,5.35,5.3999999999999995,5.4499999999999993,5.5]
[80,5.1000000000000005,5.1000000000000005,5.3999999999999995,5.4499999999999993,5.5,5.55]
[0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]