{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["График платежей"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"График платежей","index":0,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,14,0,15]]}
["Даты платежей","Суммы платежей",null,"Число дней","Остаток от деления","e(k)","q(k)","1+e(k)*i","(1+i)^q(k)","ДПk/((1+e(k)*i)*(1+i)^q(k))",null,null,null,"ПСК:",15.995000000000001]
["2014-09-03",-30000000,null,0,0,0,0,{"$f":"(1+F2*$M$2)","v":1},{"$f":"(1+$M$2)^G2","v":1},{"$f":"B2/(H2*I2)","v":-30000000},null,"i=",1.22702156599882E-2]
["2014-09-30",355068.49,null,27,27,0.9642857142857143,0,{"$f":"(1+F3*$M$2)","v":1.0118319936721314},{"$f":"(1+$M$2)^G3","v":1},{"$f":"B3/(H3*I3)","v":350916.44879837084},null,"Excel",1.22702156599882E-2]
["2014-10-31",407671.23,null,58,2,7.1428571428571425E-2,2,1.0008764439757134,1.0246909895123189,397499.58383095509,null,"ЦФТ",1.2273972602739699E-2]
["2014-11-28",394520.55,null,86,2,7.1428571428571425E-2,3,1.0008764439757134,1.0372641689384816,380014.16556327092]
["2014-12-31",407671.23,null,119,7,0.25,4,1.0030675539149971,1.0499916239877352,387074.04101707932,null,null,null,"Рассчитанное БП=",28]
["2015-01-30",407671.23,null,149,9,0.32142857142857145,5,1.0039439978907105,1.0628752476552459,382048.30989066133,null,null,null,"БП=",28]
["2015-02-27",368219.18,null,177,9,0.32142857142857145,6,1.0039439978907105,1.075916956163639,340893.06560478476,null,null,null,"ЧБП=",{"$f":"365/O7","v":13.035714285714286}]
["2015-03-31",407671.23,null,209,13,0.4642857142857143,7,1.0056968858421373,1.0891186892480047,372192.61166434822]
["2015-04-30",394520.55,null,239,15,0.5357142857142857,8,1.0065733298178507,1.1024824104444013,355510.58953522216]
["2015-05-29",407671.23,null,268,16,0.5714285714285714,9,1.0070115518057074,1.1160101073818975,362750.05190596182,null,null,null,"Вариант численного метода",1]
["2015-06-30",30394520.550000001,null,300,20,0.7142857142857143,10,1.0087644397571345,1.1297037920782,26671101.132189434,null,null,null,"Вариант алгоритма",2]
[null,null,null,null,null,null,null,null,"Проверка:",{"$f":"SUM(J2:J12)","v":8.5681676864624023E-8},null,null,null,"Максимальное число итераций",1000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Точность",1.0000000000000001E-15]