{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,7,5,10],[1,6,2,9],[1,1,1,4],[5,2,6,2],[5,1,6,1],[5,3,5,6]]}
[]
[null,"Вводные данные.",null,null,null,null,"Перейти на сайт RuExcel.ru",null,null,null,null,{"$f":"CONCATENATE(\"N\",D4+8)","v":"N9"}]
[null,"Сумма кредита. Руб.","Процент. %","Срок погашения, мес.","Дата предоставления кредита."]
[null,1,0.01,1,"1900-01-01"]
[]
[null,"№ п.п .","Дата платежа.","Аннуитетный платеж",null,null,null,"Дифференцированный платеж"]
[null,null,null,"Сумма всего, руб.","На погашение долга, руб.","На погашение процентов, руб.","Остаток долга после совершения платежа","Сумма всего, руб.","На погашение долга, руб.","На погашение процентов, руб.","Остаток долга после совершения платежа"]
[null,"Итого:",{"$f":"$E$4","v":"1900-01-01"},{"$f":"E8+F8","v":2},{"$f":"SUM(E9:E98801)","v":1.9991530054644808},{"$f":"SUM(F9:F98801)","v":8.4699453551912568E-4},{"$f":"$B$4","v":1},{"$f":"I8+J8","v":1.0008333333333332},{"$f":"SUM(I9:I98801)","v":1},{"$f":"SUM(J9:J98801)","v":8.3333333333333339E-4},{"$f":"$B$4","v":1},{"$f":"ROW(L8)","v":8},{"$f":"$D$4","v":1}]
[null,1,{"$f":"DATE(YEAR(C8),MONTH(C8)+1,DAY(C8))","v":"1900-02-01"},{"$f":"IF(N9*$C$4/12/(1-(1+$C$4/12)^(-M9))<G7,ROUNDUP(N9*$C$4/12/(1-(1+$C$4/12)^(-M9)),0),G8+F9)","v":2},{"$f":"D9-F9","v":1.9991530054644808},{"$f":"$B$4*$C$4*(C9-C8)/(DATE(YEAR(C9)+1,1,1)-DATE(YEAR(C9),1,1))","v":8.4699453551912568E-4},{"$f":"G8-E9","v":-0.99915300546448083},{"$f":"I9+J9","v":1.0008333333333332},{"$f":"IF($B$4/$D$4<K8,$B$4/$D$4,K8)","v":1},{"$f":"K8*$C$4/12","v":8.3333333333333339E-4},{"$f":"K8-I9","v":0},{"$f":"L8","v":8},{"$f":"$D$4","v":1},{"$f":"INDEX(G:G,L9,1)","v":1}]