{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Расчет суммы (корректировка РМ)","Обучающий материал","Новый график 2 ставки+отсрочка"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":14,"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":"Расчет суммы (корректировка РМ)","index":0,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":true,"merged":[[3,0,3,1],[4,0,4,1],[5,0,5,1],[7,0,7,2],[14,0,14,1],[9,0,9,1],[11,0,11,1],[10,0,10,1],[12,0,12,1],[6,0,6,1]]}
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Общая сумма кредита утвержденная РМ (ИТОГО)",null,0,null,null,null,null,"Тип","Название СК","коэф.","Знач"]
["Новая сумма клиенту                                            ",null,{"$f":"IFERROR(MROUND(C4/K5,100),\"\")","v":""},null,null,null,"Cтраховка",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(J5/1)+1","v":{"$error":"#REF!"}}]
["Новая сумма страховой организации ",null,{"$f":"IFERROR((C4)-(C5),\"\")","v":""}]
["Сумма, которую необходимо внести клиенту в кассу магазина. ",null,{"$f":"#REF!-'Расчет суммы (корректировка РМ)'!C5","v":{"$error":"#REF!"}}]
["Новые параметры кредитования "]
[]
["Процентная ставка по договору ",null,{"$f":"IF(C6=\"\",\"\",#REF!)","v":""}]
["Cрок кредита (мес.)",null,{"$f":"IF(C6=\"\",\"\",#REF!)","v":""}]
["Ежемесячный платеж по кредиту (BYR)",null,{"$f":"IFERROR(CEILING(C4*(C10/12)/(1-POWER(1+C10/12,-C11)),1000),\"\")","v":""}]
["Абонентская плата за использование пакета услуг (BYR)",null,{"$f":"IF(C6=\"\",\"\",#REF!)","v":""}]
[]
["ИТОГО  Сумма ежемесячного платежа",null,{"$f":"IF(C6=\"\",\"\",(SUM(C12:C13)))","v":""}]

{"sheet":"Обучающий материал","index":1,"n_rows":110,"n_cols":5,"rows_kept":110,"cut":false,"hidden":true,"merged":[[85,0,86,0],[85,9,86,9]]}
[]
["I","Расчет доступной суммы кредита для кредитного продукта "]
[]
[null,"Расчет доступной суммы кредита осуществляется с обязательным заполнением следующих полей:"]
[]
[null,1,"Выбор программы кредитования"]
[null,2,"Запрашиваемый срок кредита (По умолчанию рассчитывается исходя из срока  60 мес.)"]
[null,null,"При желании клиента оформить кредит на иной срок - запрашиваемый срок кредита необходимо изменить . "]
[null,3,"Подтвержденный доход"]
[null,4,"Выплаты по кредитам"]
[null,5,"Иные платежа кроме коммунальных"]
[null,6,"Количество членов семьи"]
[null,"После заполнения вышеуказанных полей вы сможете увидеть максимально доступную сумму кредита, "]
[null,"без дополнительной проверки путем ввода максимальной  суммы кредита в поле \"Запрашиваемая сумма кредита\". "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["II","Работа   с вкладкой калькулятора «Расчет суммы (корректировка РМ)»"]
[null," Для корректного пересчета суммы кредита с/без страховки , сниженной при рассмотрении риск-менеджером, необходимо: "]
[]
[null,"1.На вкладке «Калькулятор» обязательно заполняем следующие поля:"]
[null,"1.1. Программа кредитования"]
[null,"1.2. Указать сумму товара по Счет-Фактуре"]
[null,"1.3. Указать сумму первоночального взноса",null,null,"(если имеется)"]
[null,"1.4. Указать срок"]
[null,"*информация в полях должна четко соответствовать первоначально введенным параметрам по заявке до рассмотрения риск-менеджером."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Переходим на вкладку «Расчет суммы (корректировки РМ)"]
[null,"2.1. В поле \"Общая сумма кредита утвержденная РМ (ИТОГО) вводим утвержденную сумму риск-менеджером."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.В поле \"Общая сумма кредита утвержденная (РМ)\" - необходимо внести сумму которую утвердил РМ."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4. Получаете обновленную  информацию:"]
[null,"-           Новая сумма клиенту"]
[null,"-           Новая сумма страховой организации"]
[null,"-           Сумма, которую необходимо внести клиенту в кассу магазина."]

{"sheet":"Новый график 2 ставки+отсрочка","index":2,"n_rows":132,"n_cols":24,"rows_kept":132,"cut":false,"hidden":false,"merged":[[0,0,0,4],[3,0,3,2],[3,3,3,4],[10,9,10,10],[2,8,2,12],[3,8,3,12],[1,8,1,12],[10,11,10,12],[1,0,1,2],[1,3,1,4],[7,0,7,2],[7,3,7,4],[9,0,9,1],[4,0,4,2],[4,3,4,4],[5,0,5,2],[6,0,6,2],[6,3,6,4],[10,13,11,13],[2,0,2,2],[10,14,11,14],[10,15,11,15],[10,16,11,16],[10,17,10,20],[0,8,0,13],[4,8,4,12],[5,8,5,12],[6,8,6,12],[7,8,7,12]]}
["Предварительный график платежей по кредиту",null,null,null,null,null,null,null,"Даты "]
["Дата договора ",null,null,"2020-09-28",null,null,null,null,"Дата выдачи кредита/сегодня ",null,null,null,null,{"$f":"D2","v":"2020-09-28"},{"$f":"DATE(YEAR(Дата_выдачи_кредита),MONTH(Дата_выдачи_кредита),DAY(N4))","v":"2020-09-28"}]
["ППС Начало/конец",null,null,{"$f":"SUM(D13:D132)*360/SUM(W13:W132)","v":0.26384281671368248},{"$f":"SUM(D13:D132)*360/SUM(X13:X132)","v":0.29899151090818493},null,null,null,"Дата начала действаия 2-й ставки ",null,null,null,null,{"$f":"Дата_выдачи_кредита+Кол_во_Льготных_дней","v":"2020-09-28"}]
["Сумма кредита ",null,null,2000,null,null,null,null,"Платежная дата ",null,null,null,null,{"$f":"DAY(Дата_выдачи_кредита)","v":28}]
["Срок кредита (мес.)",null,null,12,null,null,null,null,"Количество дней после платежной даты",null,null,null,null,{"$f":"IF((N6-Платежная_дата<0),0,N6-Платежная_дата)","v":2}]
["%-ставка по договору(Льготная /Основная)",null,null,0.29899999999999999,0.29899999999999999,null,null,null,"Количество дней в месяце",null,null,null,null,30]
["Отсрочка платежа по ОД (мес.)",null,null,0,null,null,null,null,"количество льгодных дней в периоде с ID = 2",null,null,null,null,{"$f":"IF((DAY(Дата_второй_ставки))=1,Платежная_дата,IF((DAY(Дата_второй_ставки-1))>30,30,DAY(Дата_второй_ставки-1)))","v":27}]
["Срок действия льготной ставки (дней)",null,null,0,null,null,null,null,"количество НЕ_льгодных дней в периоде с ID = 2",null,null,null,null,{"$f":"IF((N6-N7)<0,0,N6-N7)","v":3}]
[]
["Итого (бел.руб.)",null,{"$f":"SUM(C13:C132)","v":1999.9999999999995},{"$f":"SUM(D13:D132)","v":338.50000000000006},{"$f":"SUM(E13:E132)","v":2338.5000000000005}]
[null,null,null,null,null,null,null,null,"Для ОД ","Для процентов",null,"начисление % (сроки)",null,"ID","Количество  дней для              1-й ставки","Количество  дней для              2-й ставки","Расчет суммы процентов","%"]
["Платеж","Дата платежа","Сумма платежа по ОД (бел.руб)","Сумма платежа по %  (бел.руб)","Сумма  платежа по кредиту (бел.руб)",null,null,null,"Остаток ОД ","Остаток ОД на начало","Остаток ОД на конец","дата начала периода начисления ","дата конеца периода начисления ",null,null,null,null,"для ID 1 ставки","для ID 2 ставки","для ID 3 ставки","для ID 4 ставки",null,"Среднедневные остатки на начало","Среднедневные остатки на конец"]
[{"$f":"IF(Срок_Кредита<1,\"\",1)","v":1},{"$f":"IFERROR((DATE(YEAR(O2),MONTH(O2)+1,DAY(O2))),\"\")","v":"2020-10-28"},{"$f":"IF(A13=\"\",\"\",IF(A13<=Отсрочка_ОД,0,ROUND((I13*(Основная_Ставка/12)/(1-POWER(1+Основная_Ставка/12,-Срок_Кредита))),2)-ROUND((I13*Основная_Ставка/12),2)))","v":145.05000000000001},{"$f":"IF(A13=\"\",\"\",Q13)","v":3.32},{"$f":"IF(A13=\"\",\"\",C13+D13)","v":148.37},null,null,null,{"$f":"IF(A13=\"\",\"\",Сумма_Кредита)","v":2000},{"$f":"IF(A13=\"\",\"\",I13)","v":2000},{"$f":"IF(A13=\"\",\"\",J13)","v":2000},{"$f":"IF(A13=\"\",\"\",DATE(YEAR(Дата_выдачи_кредита),MONTH(Дата_выдачи_кредита),DAY(Дата_выдачи_кредита)))","v":"2020-09-28"},{"$f":"IF(A13=\"\",\"\",EOMONTH(L13,0))","v":"2020-09-30"},{"$f":"IF(A13=\"\",\"\",IF(A13=Срок_Кредита,4,IF(Кол_во_Льготных_дней=0,1,IF(Дата_второй_ставки>M13,1,IF(Дата_второй_ставки>=L13,IF(Дата_второй_ставки<=M13,2),3)))))","v":1},{"$f":"IF(A13=\"\",\"\",IF(N13=1,$N$5,IF(N13=2,Кол_во_Льготных_дней-1,0)))","v":2},{"$f":"IF(A13=\"\",\"\",N5-O13)","v":0},{"$f":"IF(A13=\"\",\"\",ROUND((J13*Льготная_Ставка*O13/360)+(K13*Основная_Ставка*P13/360),2))","v":3.32},null,null,null,null,null,{"$f":"IFERROR(J13*30,0)","v":60000},{"$f":"IFERROR(K13*30,0)","v":60000}]
[{"$f":"IF(Срок_Кредита<2,\"\",2)","v":2},{"$f":"IF(A14=\"\",\"\",IFERROR((DATE(YEAR(B13),MONTH(B13)+1,DAY(B13))),\"\"))","v":"2020-11-28"},{"$f":"IF(A14=\"\",\"\",IF(A14<=Отсрочка_ОД,0,ROUND((I14*(Основная_Ставка/12)/(1-POWER(1+Основная_Ставка/12,-(Срок_Кредита-A13)))),2)-ROUND((I14*Основная_Ставка/12),2)))","v":148.66},49.59,{"$f":"IF(A14=\"\",\"\",C14+D14)","v":198.25},null,null,null,{"$f":"IF(A14=\"\",\"\",I13-C13)","v":1854.95},{"$f":"IF(A14=\"\",\"\",K13)","v":2000},{"$f":"IF(A14=\"\",\"\",I14)","v":1854.95},{"$f":"IF(A14=\"\",\"\",DATE(YEAR(Дата_выдачи_кредита),MONTH(Дата_выдачи_кредита)+A13,DAY(1)))","v":"2020-10-01"},"2020-10-31",{"$f":"IF(A14=\"\",\"\",IF(A14=Срок_Кредита,4,IF(Кол_во_Льготных_дней=0,3,IF(Дата_второй_ставки>=M14,1,IF(Дата_второй_ставки>L14,IF(Дата_второй_ставки<M14,2),3)))))","v":3},{"$f":"IF(A14=\"\",\"\",IF(N14=1,Платежная_дата,IF(N14=2,$N$7,Платежная_дата)))","v":28},{"$f":"IF(A14=\"\",\"\",IF(N14=1,$N$5,IF(N14=2,$N$8,$N$5)))","v":2},{"$f":"IF(A14=\"\",\"\",IF(N14=1,R14,IF(N14=2,S14,IF(N14=3,T14,IF(N14=4,U14)))))","v":49.59},{"$f":"IF(A14=\"\",\"\",ROUND((J14*Льготная_Ставка*O14/360)+(K14*Льготная_Ставка*P14/360),2))","v":49.59},{"$f":"IF(A14=\"\",\"\",IF($N$7<Платежная_дата,(ROUND((J14*Льготная_Ставка*$N$7/360)+(J14*Основная_Ставка*(Платежная_дата-$N$7)/360)+(K14*Основная_Ставка*$N$5/360),2)),IF($N$7=Платежная_дата,(ROUND((J14*Льготная_Ставка*Платежная_дата/360)+(K14*Основная_Ставка*$N$5/360),2)),IF($N$7>Платежная_дата,(ROUND((J14*Льготная_Ставка*Платежная_дата/360)+(K14*Льготная_Ставка*($N$7-Платежная_дата)/360)+(K14*Основная_Ставка*$N$8/360),2))))))","v":49.59},{"$f":"IF(A14=\"\",\"\",ROUND((J14*Основная_Ставка*O14/360)+(K14*Основная_Ставка*P14/360),2))","v":49.59},{"$f":"IF(A14=\"\",\"\",ROUND((J14*Основная_Ставка*O14/360)+(K14*Основная_Ставка*P14/360)+(K14*Основная_Ставка*Платежная_дата/360),2))","v":92.73},null,{"$f":"IFERROR(J14*30,0)","v":60000},{"$f":"IFERROR(K14*30,0)","v":55648.5}]
[{"$f":"IF(Срок_Кредита<3,\"\",3)","v":3},{"$f":"IF(A15=\"\",\"\",IFERROR((DATE(YEAR(B14),MONTH(B14)+1,DAY(B14))),\"\"))","v":"2020-12-28"},152.35,45.97,198.32,null,null,null,1706.29,1854.95,1706.29,"2020-11-01","2020-11-30",3,28,{"$f":"IF(A15=\"\",\"\",IF(N15=1,$N$5,IF(N15=2,$N$8,$N$5)))","v":2},45.97,45.97,45.97,45.97,85.65,null,55648.5,51188.7]
[{"$f":"IF(Срок_Кредита<4,\"\",4)","v":4},"2021-01-28",156.16,42.26,198.42,null,null,null,1553.94,1706.29,1553.94,"2020-12-01","2020-12-31",3,28,2,42.26,42.26,42.26,42.26,78.400000000000006,null,51188.7,46618.200000000004]
[{"$f":"IF(Срок_Кредита<5,\"\",5)","v":5},"2021-02-28",160.05000000000001,38.46,198.51000000000002,null,null,null,1397.78,1553.94,1397.78,"2021-01-01","2021-01-31",3,28,2,38.46,38.46,38.46,38.46,70.97,null,46618.200000000004,41933.4]
[{"$f":"IF(Срок_Кредита<6,\"\",6)","v":6},"2021-03-28",164.03,34.56,198.59,null,null,null,1237.73,1397.78,1237.73,"2021-02-01","2021-02-28",3,28,2,34.56,34.56,34.56,34.56,63.35,null,41933.4,37131.9]
[{"$f":"IF(Срок_Кредита<7,\"\",7)","v":7},"2021-04-28",168.13,30.57,198.7,null,null,null,1073.7,1237.73,1073.7,"2021-03-01","2021-03-31",3,28,2,30.57,30.57,30.57,30.57,55.54,null,37131.9,32211]
[{"$f":"IF(Срок_Кредита<8,\"\",8)","v":8},"2021-05-28",172.31,26.47,198.78,null,null,null,905.57,1073.7,905.57,"2021-04-01","2021-04-30",3,28,2,26.47,26.47,26.47,26.47,47.53,null,32211,27167.100000000002]
[{"$f":"IF(Срок_Кредита<9,\"\",9)","v":9},"2021-06-28",176.6,22.28,198.88,null,null,null,733.26,905.57,733.26,"2021-05-01","2021-05-31",3,28,2,22.28,22.28,22.28,22.28,39.33,null,27167.100000000002,21997.8]
[{"$f":"IF(Срок_Кредита<10,\"\",10)","v":10},"2021-07-28",181.01,17.98,198.98999999999998,null,null,null,556.66,733.26,556.66,"2021-06-01","2021-06-30",3,28,2,17.98,17.98,17.98,17.98,30.92,null,21997.8,16699.8]
[{"$f":"IF(Срок_Кредита<11,\"\",11)","v":11},"2021-08-28",185.51,13.57,199.07999999999998,null,null,null,375.65,556.66,375.65,"2021-07-01","2021-07-31",3,28,2,13.57,13.57,13.57,13.57,22.31,null,16699.8,11269.5]
[{"$f":"IF(Срок_Кредита<12,\"\",12)","v":12},"2021-09-28",190.14,13.47,203.60999999999999,null,null,null,190.14,375.65,190.14,"2021-08-01","2021-08-31",4,28,2,13.47,9.0500000000000007,9.0500000000000007,9.0500000000000007,13.47,null,11269.5,5704.2]
[{"$f":"IF(Срок_Кредита<13,\"\",13)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<14,\"\",14)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<15,\"\",15)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<16,\"\",16)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<17,\"\",17)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<18,\"\",18)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<19,\"\",19)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<20,\"\",20)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<21,\"\",21)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<22,\"\",22)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<23,\"\",23)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<24,\"\",24)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<25,\"\",25)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<26,\"\",26)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<27,\"\",27)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<28,\"\",28)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<29,\"\",29)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<30,\"\",30)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<31,\"\",31)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<32,\"\",32)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<33,\"\",33)","v":""},"","",{"$f":"IF(A45=\"\",\"\",Q45)","v":""},"",null,null,null,"","","","",{"$f":"IF(A45=\"\",\"\",EOMONTH(L45,0))","v":""},"","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<34,\"\",34)","v":""},"",{"$f":"IF(A46=\"\",\"\",IF(A46<=Отсрочка_ОД,0,ROUND((I46*(Основная_Ставка/12)/(1-POWER(1+Основная_Ставка/12,-(Срок_Кредита-A45)))),2)-ROUND((I46*Основная_Ставка/12),2)))","v":""},"","",null,null,null,{"$f":"IF(A46=\"\",\"\",I45-C45)","v":""},{"$f":"IF(A46=\"\",\"\",K45)","v":""},{"$f":"IF(A46=\"\",\"\",I46)","v":""},{"$f":"IF(A46=\"\",\"\",DATE(YEAR(Дата_выдачи_кредита),MONTH(Дата_выдачи_кредита)+A45,DAY(1)))","v":""},"",{"$f":"IF(A46=\"\",\"\",IF(A46=Срок_Кредита,4,IF(Кол_во_Льготных_дней=0,3,IF(Дата_второй_ставки>=M46,1,IF(Дата_второй_ставки>L46,IF(Дата_второй_ставки<M46,2),3)))))","v":""},{"$f":"IF(A46=\"\",\"\",IF(N46=1,Платежная_дата,IF(N46=2,$N$7,Платежная_дата)))","v":""},"",{"$f":"IF(A46=\"\",\"\",IF(N46=1,R46,IF(N46=2,S46,IF(N46=3,T46,IF(N46=4,U46)))))","v":""},{"$f":"IF(A46=\"\",\"\",ROUND((J46*Льготная_Ставка*O46/360)+(K46*Льготная_Ставка*P46/360),2))","v":""},{"$f":"IF(A46=\"\",\"\",IF($N$7<Платежная_дата,(ROUND((J46*Льготная_Ставка*$N$7/360)+(J46*Основная_Ставка*(Платежная_дата-$N$7)/360)+(K46*Основная_Ставка*$N$5/360),2)),IF($N$7=Платежная_дата,(ROUND((J46*Льготная_Ставка*Платежная_дата/360)+(K46*Основная_Ставка*$N$5/360),2)),IF($N$7>Платежная_дата,(ROUND((J46*Льготная_Ставка*Платежная_дата/360)+(K46*Льготная_Ставка*($N$7-Платежная_дата)/360)+(K46*Основная_Ставка*$N$8/360),2))))))","v":""},{"$f":"IF(A46=\"\",\"\",ROUND((J46*Основная_Ставка*O46/360)+(K46*Основная_Ставка*P46/360),2))","v":""},{"$f":"IF(A46=\"\",\"\",ROUND((J46*Основная_Ставка*O46/360)+(K46*Основная_Ставка*P46/360)+(K46*Основная_Ставка*Платежная_дата/360),2))","v":""},null,0,0]
[{"$f":"IF(Срок_Кредита<35,\"\",35)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<36,\"\",36)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<37,\"\",37)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<38,\"\",38)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<39,\"\",39)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<40,\"\",40)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<41,\"\",41)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<42,\"\",42)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<43,\"\",43)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<44,\"\",44)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<45,\"\",45)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<46,\"\",46)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<47,\"\",47)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<48,\"\",48)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<49,\"\",49)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<50,\"\",50)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<51,\"\",51)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<52,\"\",52)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<53,\"\",53)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<54,\"\",54)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<55,\"\",55)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<56,\"\",56)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<57,\"\",57)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<58,\"\",58)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<59,\"\",59)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<60,\"\",60)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<61,\"\",61)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<62,\"\",62)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<63,\"\",63)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<64,\"\",64)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<65,\"\",65)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<66,\"\",66)","v":""},"","","",{"$f":"IF(A78=\"\",\"\",C78+D78)","v":""},null,null,null,"","","","","","","","","","","","","",null,{"$f":"IFERROR(J78*30,0)","v":0},{"$f":"IFERROR(K78*30,0)","v":0}]
[{"$f":"IF(Срок_Кредита<67,\"\",67)","v":""},{"$f":"IF(A79=\"\",\"\",IFERROR((DATE(YEAR(B78),MONTH(B78)+1,DAY(B78))),\"\"))","v":""},"","","",null,null,null,"","","","","","","",{"$f":"IF(A79=\"\",\"\",IF(N79=1,$N$5,IF(N79=2,$N$8,$N$5)))","v":""},"","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<68,\"\",68)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<69,\"\",69)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<70,\"\",70)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<71,\"\",71)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<72,\"\",72)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<73,\"\",73)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<74,\"\",74)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<75,\"\",75)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<76,\"\",76)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<77,\"\",77)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<78,\"\",78)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<79,\"\",79)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<80,\"\",80)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<81,\"\",81)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<82,\"\",82)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<83,\"\",83)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<84,\"\",84)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<85,\"\",85)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<86,\"\",86)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<87,\"\",87)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<88,\"\",88)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<89,\"\",89)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<90,\"\",90)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<91,\"\",91)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<92,\"\",92)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<93,\"\",93)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<94,\"\",94)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<95,\"\",95)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<96,\"\",96)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<97,\"\",97)","v":""},"","",{"$f":"IF(A109=\"\",\"\",Q109)","v":""},"",null,null,null,"","","","",{"$f":"IF(A109=\"\",\"\",EOMONTH(L109,0))","v":""},"","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<98,\"\",98)","v":""},"",{"$f":"IF(A110=\"\",\"\",IF(A110<=Отсрочка_ОД,0,ROUND((I110*(Основная_Ставка/12)/(1-POWER(1+Основная_Ставка/12,-(Срок_Кредита-A109)))),2)-ROUND((I110*Основная_Ставка/12),2)))","v":""},"","",null,null,null,{"$f":"IF(A110=\"\",\"\",I109-C109)","v":""},{"$f":"IF(A110=\"\",\"\",K109)","v":""},{"$f":"IF(A110=\"\",\"\",I110)","v":""},{"$f":"IF(A110=\"\",\"\",DATE(YEAR(Дата_выдачи_кредита),MONTH(Дата_выдачи_кредита)+A109,DAY(1)))","v":""},"",{"$f":"IF(A110=\"\",\"\",IF(A110=Срок_Кредита,4,IF(Кол_во_Льготных_дней=0,3,IF(Дата_второй_ставки>=M110,1,IF(Дата_второй_ставки>L110,IF(Дата_второй_ставки<M110,2),3)))))","v":""},{"$f":"IF(A110=\"\",\"\",IF(N110=1,Платежная_дата,IF(N110=2,$N$7,Платежная_дата)))","v":""},"",{"$f":"IF(A110=\"\",\"\",IF(N110=1,R110,IF(N110=2,S110,IF(N110=3,T110,IF(N110=4,U110)))))","v":""},{"$f":"IF(A110=\"\",\"\",ROUND((J110*Льготная_Ставка*O110/360)+(K110*Льготная_Ставка*P110/360),2))","v":""},{"$f":"IF(A110=\"\",\"\",IF($N$7<Платежная_дата,(ROUND((J110*Льготная_Ставка*$N$7/360)+(J110*Основная_Ставка*(Платежная_дата-$N$7)/360)+(K110*Основная_Ставка*$N$5/360),2)),IF($N$7=Платежная_дата,(ROUND((J110*Льготная_Ставка*Платежная_дата/360)+(K110*Основная_Ставка*$N$5/360),2)),IF($N$7>Платежная_дата,(ROUND((J110*Льготная_Ставка*Платежная_дата/360)+(K110*Льготная_Ставка*($N$7-Платежная_дата)/360)+(K110*Основная_Ставка*$N$8/360),2))))))","v":""},{"$f":"IF(A110=\"\",\"\",ROUND((J110*Основная_Ставка*O110/360)+(K110*Основная_Ставка*P110/360),2))","v":""},{"$f":"IF(A110=\"\",\"\",ROUND((J110*Основная_Ставка*O110/360)+(K110*Основная_Ставка*P110/360)+(K110*Основная_Ставка*Платежная_дата/360),2))","v":""},null,0,0]
[{"$f":"IF(Срок_Кредита<99,\"\",99)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<100,\"\",100)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<101,\"\",101)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<102,\"\",102)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<103,\"\",103)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<104,\"\",104)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<105,\"\",105)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<106,\"\",106)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<107,\"\",107)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<108,\"\",108)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<109,\"\",109)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<110,\"\",110)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<111,\"\",111)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<112,\"\",112)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<113,\"\",113)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<114,\"\",114)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<115,\"\",115)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<116,\"\",116)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<117,\"\",117)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<118,\"\",118)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<119,\"\",119)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]
[{"$f":"IF(Срок_Кредита<120,\"\",120)","v":""},"","","","",null,null,null,"","","","","","","","","","","","","",null,0,0]