{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Данные","ТРАНШ 001"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":244,"n_cols":12,"rows_kept":244,"cut":false,"hidden":false,"merged":[[1,1,1,3],[16,1,16,3]]}
[]
[null,"Параметры кредита:"]
[null,"Банк",null,null,null,null,"Выбор из списка"]
[null,"ФИО должника",null,null,null,null,"Заполняется вручную"]
[null,"Номер договора",null,null,null,null,"Недоступно"]
[null,"Дата выдачи"]
[null,"Сумма кредита"]
[null,"Срок кредита, мес."]
[null,"Процентная ставка ",null,null,"В год"]
[null,"Сумма платежа",null,null,"Аннуитет"]
[null,"Дата платежей",null,null,"Следующий рабочий"]
[null,"Размер комиссии",null,null,"Ежемесячно"]
[null,"Размер пеней",null,null,"В день"]
[null,"Расчет на дату"]
[]
[]
[null,"СТРАНИЦА НЕ ДЛЯ ПЕЧАТИ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"В день","Всегда","Ежемесячно","Аннуитет","АКБ \"ПРОБИЗНЕСБАНК\" (ОАО) ",null,null,null,null,null,"Конец месяца текущего"]
[null,"В год","Следующий рабочий","Единоразово","Дифференцированный","АКБ \"ИНВЕСТБАНК\" (ОАО)",null,null,null,null,null,"Конец месяца следующего"]
[null,null,"Предыдущий рабочий",null,null,null,null,null,null,null,null,"Число"]
[]
[null,null,null,"Выходные дни"]
[null,null,null,"2006-01-01"]
[null,null,null,{"$f":"DATE(YEAR(D36)+1,MONTH(D36),DAY(D36))","v":"2007-01-01"}]
[null,null,null,{"$f":"DATE(YEAR(D37)+1,MONTH(D37),DAY(D37))","v":"2008-01-01"}]
[null,null,null,"2009-01-01"]
[null,null,null,"2010-01-01"]
[null,null,null,"2011-01-01"]
[null,null,null,"2012-01-01"]
[null,null,null,"2013-01-01"]
[null,null,null,"2014-01-01"]
[null,null,null,"2015-01-01"]
[null,null,null,"2016-01-01"]
[null,null,null,"2017-01-01"]
[null,null,null,"2018-01-01"]
[null,null,null,"2006-01-02"]
[null,null,null,"2007-01-02"]
[null,null,null,"2008-01-02"]
[null,null,null,"2009-01-02"]
[null,null,null,"2010-01-02"]
[null,null,null,"2011-01-02"]
[null,null,null,"2012-01-02"]
[null,null,null,"2013-01-02"]
[null,null,null,"2014-01-02"]
[null,null,null,"2015-01-02"]
[null,null,null,"2016-01-02"]
[null,null,null,"2017-01-02"]
[null,null,null,"2018-01-02"]
[null,null,null,"2006-01-03"]
[null,null,null,"2007-01-03"]
[null,null,null,"2008-01-03"]
[null,null,null,"2009-01-03"]
[null,null,null,"2010-01-03"]
[null,null,null,"2011-01-03"]
[null,null,null,"2012-01-03"]
[null,null,null,"2013-01-03"]
[null,null,null,"2014-01-03"]
[null,null,null,"2015-01-03"]
[null,null,null,"2016-01-03"]
[null,null,null,"2017-01-03"]
[null,null,null,"2018-01-03"]
[null,null,null,"2006-01-04"]
[null,null,null,"2007-01-04"]
[null,null,null,"2008-01-04"]
[null,null,null,"2009-01-04"]
[null,null,null,"2010-01-04"]
[null,null,null,"2011-01-04"]
[null,null,null,"2012-01-04"]
[null,null,null,"2013-01-04"]
[null,null,null,"2014-01-04"]
[null,null,null,"2015-01-04"]
[null,null,null,"2016-01-04"]
[null,null,null,"2017-01-04"]
[null,null,null,"2018-01-04"]
[null,null,null,"2006-01-05"]
[null,null,null,"2007-01-05"]
[null,null,null,"2008-01-05"]
[null,null,null,"2009-01-05"]
[null,null,null,"2010-01-05"]
[null,null,null,"2011-01-05"]
[null,null,null,"2012-01-05"]
[null,null,null,"2013-01-05"]
[null,null,null,"2014-01-05"]
[null,null,null,"2015-01-05"]
[null,null,null,"2016-01-05"]
[null,null,null,"2017-01-05"]
[null,null,null,"2018-01-05"]
[null,null,null,"2006-01-06"]
[null,null,null,"2007-01-06"]
[null,null,null,"2008-01-06"]
[null,null,null,{"$f":"DATE(YEAR(D103)+1,MONTH(D103),DAY(D103))","v":"2009-01-06"}]
[null,null,null,"2010-01-06"]
[null,null,null,"2011-01-06"]
[null,null,null,"2012-01-06"]
[null,null,null,"2013-01-06"]
[null,null,null,"2014-01-06"]
[null,null,null,"2015-01-06"]
[null,null,null,"2016-01-06"]
[null,null,null,"2017-01-06"]
[null,null,null,"2018-01-06"]
[null,null,null,"2006-01-07"]
[null,null,null,"2007-01-07"]
[null,null,null,"2008-01-07"]
[null,null,null,"2009-01-07"]
[null,null,null,"2010-01-07"]
[null,null,null,"2011-01-07"]
[null,null,null,"2012-01-07"]
[null,null,null,"2013-01-07"]
[null,null,null,"2014-01-07"]
[null,null,null,"2015-01-07"]
[null,null,null,"2016-01-07"]
[null,null,null,"2017-01-07"]
[null,null,null,"2018-01-07"]
[null,null,null,"2006-01-08"]
[null,null,null,"2007-01-08"]
[null,null,null,"2008-01-08"]
[null,null,null,"2009-01-08"]
[null,null,null,"2010-01-08"]
[null,null,null,"2011-01-08"]
[null,null,null,"2012-01-08"]
[null,null,null,"2013-01-08"]
[null,null,null,"2014-01-08"]
[null,null,null,"2015-01-08"]
[null,null,null,"2016-01-08"]
[null,null,null,"2017-01-08"]
[null,null,null,"2018-01-08"]
[null,null,null,"2006-01-09"]
[null,null,null,"2007-01-09"]
[null,null,null,"2009-01-09"]
[null,null,null,"2011-01-10"]
[null,null,null,"2012-01-09"]
[null,null,null,"2015-01-09"]
[null,null,null,"2006-02-23"]
[null,null,null,"2007-02-23"]
[null,null,null,"2008-02-23"]
[null,null,null,"2009-02-23"]
[null,null,null,"2010-02-23"]
[null,null,null,"2011-02-23"]
[null,null,null,"2012-02-23"]
[null,null,null,"2013-02-23"]
[null,null,null,"2014-02-23"]
[null,null,null,"2015-02-23"]
[null,null,null,"2016-02-23"]
[null,null,null,"2017-02-23"]
[null,null,null,"2018-02-23"]
[null,null,null,"2006-03-08"]
[null,null,null,"2007-03-08"]
[null,null,null,"2008-03-08"]
[null,null,null,"2009-03-08"]
[null,null,null,"2010-03-08"]
[null,null,null,"2011-03-08"]
[null,null,null,"2012-03-08"]
[null,null,null,"2013-03-08"]
[null,null,null,"2014-03-08"]
[null,null,null,{"$f":"DATE(YEAR(D167)+1,MONTH(D167),DAY(D167))","v":"2015-03-08"}]
[null,null,null,"2016-03-08"]
[null,null,null,"2017-03-08"]
[null,null,null,"2018-03-08"]
[null,null,null,"2006-05-01"]
[null,null,null,"2007-05-01"]
[null,null,null,"2008-05-01"]
[null,null,null,"2009-05-01"]
[null,null,null,"2010-05-01"]
[null,null,null,"2011-05-01"]
[null,null,null,"2012-05-01"]
[null,null,null,"2013-05-01"]
[null,null,null,"2014-05-01"]
[null,null,null,"2015-05-01"]
[null,null,null,"2016-05-01"]
[null,null,null,"2017-05-01"]
[null,null,null,"2018-05-01"]
[null,null,null,"2006-05-09"]
[null,null,null,"2007-05-09"]
[null,null,null,"2008-05-09"]
[null,null,null,"2009-05-09"]
[null,null,null,"2010-05-09"]
[null,null,null,"2011-05-09"]
[null,null,null,"2012-05-09"]
[null,null,null,"2013-05-09"]
[null,null,null,"2014-05-09"]
[null,null,null,"2015-05-09"]
[null,null,null,"2016-05-09"]
[null,null,null,"2017-05-09"]
[null,null,null,"2018-05-09"]
[null,null,null,"2006-06-12"]
[null,null,null,"2007-06-12"]
[null,null,null,"2008-06-12"]
[null,null,null,"2009-06-12"]
[null,null,null,"2010-06-12"]
[null,null,null,"2011-06-12"]
[null,null,null,"2012-06-12"]
[null,null,null,"2013-06-12"]
[null,null,null,"2014-06-12"]
[null,null,null,"2015-06-12"]
[null,null,null,"2016-06-12"]
[null,null,null,"2017-06-12"]
[null,null,null,"2018-06-12"]
[null,null,null,"2006-11-04"]
[null,null,null,"2007-11-04"]
[null,null,null,"2008-11-04"]
[null,null,null,"2009-11-04"]
[null,null,null,"2010-11-04"]
[null,null,null,"2011-11-04"]
[null,null,null,"2012-11-04"]
[null,null,null,"2013-11-04"]
[null,null,null,"2014-11-04"]
[null,null,null,"2015-11-04"]
[null,null,null,"2016-11-04"]
[null,null,null,"2017-11-04"]
[null,null,null,"2018-11-04"]
[null,null,null,"2019-11-04"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2013-05-09"]

{"sheet":"ТРАНШ 001","index":1,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,6,39,7],[39,0,39,1],[7,0,7,1],[8,0,8,1]]}
[]
[{"$f":"\"Расчет \"","v":"Расчет "}]
[]
[{"$f":"\"По состоянию на \" & TEXT(Данные!D14,\"дд.ММ.ГГГГ\") & \"г.\"","v":"По состоянию на 00.01.1900г."}]
[]
[]
["1. Расчет суммы основного долга",null,null,null,null,null,null,null,null,"(Таблица 1)"]
[]
[1,null,2,3,4,5,6,7,8,9,null,null,null,null,{"$f":"ROW()","v":9}]
["2012-01-01",{"$f":"$A$10","v":"2012-01-01"},0,50000,0,{"$f":"C10+D10-E10","v":50000},"-","-",0,{"$f":"E10-I10","v":0}]
[{"$f":"B10+1","v":"2012-01-02"},"2012-02-01",{"$f":"F10","v":50000},0,0,{"$f":"C11+D11-E11","v":50000},{"$f":"B11","v":"2012-02-01"},"-",0,{"$f":"J10+E11-I11","v":0}]
["2012-02-02","2012-03-01",50000,0,0,50000,{"$f":"B12","v":"2012-03-01"},"-",0,{"$f":"J11+E12-I12","v":0}]
[{"$f":"B12+1","v":"2012-03-02"},"2012-03-02",{"$f":"F12","v":50000},0,0,50000,"2012-03-02","-",0,{"$f":"J12+E13-I13","v":0}]
["2012-03-03","2012-03-03",50000,0,0,50000,"2012-03-03","-",0,{"$f":"J13+E14-I14","v":0}]
[{"$f":"B14+1","v":"2012-03-04"},"2012-03-04",{"$f":"F14","v":50000},0,0,50000,"2012-03-04","-",0,{"$f":"J14+E15-I15","v":0}]
["2012-03-05","2012-03-05",50000,0,0,50000,"2012-03-05","-",0,{"$f":"J15+E16-I16","v":0}]
["2012-03-06","2012-03-06",50000,0,35000,15000,"2012-03-06","-",0,{"$f":"J16+E17-I17","v":35000}]
["2012-03-07","2012-03-07",15000,0,0,15000,"2012-03-07","-",0,{"$f":"J17+E18-I18","v":35000}]
["2012-03-08","2012-03-08",15000,0,0,15000,"2012-03-08","-",0,35000]
[{"$f":"B19+1","v":"2012-03-09"},"2012-03-09",{"$f":"F19","v":15000},0,0,15000,"2012-03-09","-",0,{"$f":"J19+E20-I20","v":35000}]
[null,null,null,null,null,null,null,null,null,35000]
[{"$f":"B20+1","v":"2012-03-10"},"2012-03-10",{"$f":"F20","v":15000},0,0,15000,"2012-03-10","-",0,35000]
["2012-03-11","2012-03-11",15000,0,0,15000,"2012-03-11","-",0,35000]
["2012-03-12","2012-03-12",15000,0,0,15000,"2012-03-12","-",0,35000]
[]
[{"$f":"B24+1","v":"2012-03-13"},"2012-03-13",{"$f":"F24","v":15000},0,0,15000,"2012-03-13","-",0,{"$f":"J24+E26-I26","v":35000}]
["2012-03-14","2012-03-14",15000,0,0,15000,"2012-03-14","-",0,35000]
["2012-03-15","2012-03-15",15000,0,0,15000,"2012-03-15","-",0,35000]
["2012-03-16","2012-03-16",15000,0,0,15000,"2012-03-16","-",0,35000]
[{"$f":"B29+1","v":"2012-03-17"},"2012-03-18",15000,0,0,15000,"2012-03-18","-",0,{"$f":"J29+E30-I30","v":35000}]
[{"$f":"B30+1","v":"2012-03-19"},"2012-03-19",15000,0,0,15000,"2012-03-19","-",0,35000]
[{"$f":"B31+1","v":"2012-03-20"},"2012-03-20",15000,0,0,15000,"2012-03-20","-",0,35000]
["2012-03-21","2012-03-21",15000,0,0,15000,"2012-03-21","-",0,35000]
[{"$f":"B33+1","v":"2012-03-22"},"2012-03-22",15000,0,0,15000,"2012-03-22","-",0,{"$f":"J33+E34-I34","v":35000}]
[{"$f":"B34+1","v":"2012-03-23"},"2012-03-23",15000,0,0,15000,"2012-03-23","-",0,{"$f":"J34+E35-I35","v":35000}]
["2012-03-24","2012-03-24",15000,0,0,15000,"2012-03-24","-",0,{"$f":"J35+E36-I36","v":35000}]
["2012-03-25","2012-03-25",15000,0,0,15000,"2012-03-25","-",0,35000]
["2012-03-26","2012-03-26",15000,0,0,15000,"2012-03-26","-",0,35000]
["2012-03-27",{"$f":"TODAY()","v":"2017-08-31"},15000,0,0,15000,"2017-08-31","-",0,{"$f":"J38+E39-I39","v":35000}]
["Итого:",null,"Выдано:",{"$f":"SUM(D10:D39)","v":50000},null,{"$f":"F39","v":15000},null,null,{"$f":"SUM($I$10:$I$39)","v":0},{"$f":"J39","v":35000}]