{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ТРАНШ 001"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"ТРАНШ 001","index":0,"n_rows":80,"n_cols":15,"rows_kept":80,"cut":false,"hidden":false,"merged":[[43,6,43,7],[43,0,43,1],[8,0,8,1],[48,0,48,1],[49,0,49,1],[9,0,9,1],[79,0,79,1],[79,2,79,4]]}
[]
[null,null,null,null,null,null,null,{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9}]
[]
[]
[]
[]
[]
["Таблица 1"]
[]
[1,null,2,3,4,5,6,7,8,9,null,null,null,null,{"$f":"ROW()","v":10}]
["2012-01-25",{"$f":"$A$11","v":"2012-01-25"},0,1500000,0,{"$f":"C11+D11-E11","v":1500000},"-","-",0,{"$f":"E11-I11","v":0}]
[{"$f":"B11+1","v":"2012-01-26"},"2012-02-25",{"$f":"F11","v":1500000},0,35000,{"$f":"C12+D12-E12","v":1465000},{"$f":"B12","v":"2012-02-25"},"-",0,{"$f":"J11+E12-I12","v":35000}]
["2012-02-26","2012-03-25",1465000,0,35000,1430000,{"$f":"B13","v":"2012-03-25"},"-",0,{"$f":"J12+E13-I13","v":70000}]
[null,null,null,null,null,null,null,"2012-03-27",70000,{"$f":"J13+E14-I14","v":0}]
[{"$f":"B13+1","v":"2012-03-26"},"2012-04-25",{"$f":"F13","v":1430000},0,35000,1395000,"2012-04-25","-",0,35000]
["2012-04-26","2012-05-25",1395000,0,35000,1360000,"2012-05-25","-",0,70000]
["2012-05-26","2012-06-25",1360000,0,35000,1325000,"2012-06-25","-",0,105000]
["2012-06-26","2012-07-25",1325000,0,35000,1290000,"2012-07-25","-",0,{"$f":"J17+E18-I18","v":140000}]
[{"$f":"B18+1","v":"2012-07-26"},"2012-08-25",{"$f":"F18","v":1290000},0,35000,1255000,"2012-08-25","-",0,175000]
[{"$f":"B19+1","v":"2012-08-26"},"2012-09-25",{"$f":"F19","v":1255000},0,35000,1220000,"2012-09-25","-",0,210000]
[{"$f":"B20+1","v":"2012-09-26"},"2012-10-25",{"$f":"F20","v":1220000},0,35000,1185000,"2012-10-25","-",0,245000]
[{"$f":"B21+1","v":"2012-10-26"},"2012-11-25",{"$f":"F21","v":1185000},0,35000,1150000,"2012-11-25","-",0,280000]
[{"$f":"B22+1","v":"2012-11-26"},"2012-12-25",{"$f":"F22","v":1150000},0,35000,1115000,"2012-12-25","-",0,315000]
[{"$f":"B23+1","v":"2012-12-26"},"2013-01-25",{"$f":"F23","v":1115000},0,35000,1080000,"2013-01-25","-",0,350000]
[{"$f":"B24+1","v":"2013-01-26"},"2013-02-25",{"$f":"F24","v":1080000},0,35000,1045000,"2013-02-25","-",0,385000]
[{"$f":"B25+1","v":"2013-02-26"},"2013-03-25",1045000,0,35000,1010000,"2013-03-25","-",0,420000]
["2013-03-26","2013-04-25",1010000,0,35000,975000,"2013-04-25","-",0,455000]
["2013-04-26","2013-05-25",975000,0,35000,940000,"2013-05-25","-",0,490000]
[{"$f":"B28+1","v":"2013-05-26"},"2013-06-25",940000,0,35000,905000,"2013-06-25","-",0,525000]
["2013-06-26","2013-07-25",905000,0,35000,870000,"2013-07-25","-",0,560000]
[{"$f":"B30+1","v":"2013-07-26"},"2013-08-25",{"$f":"F30","v":870000},0,35000,835000,"2013-08-25","-",0,595000]
["2013-08-26","2013-09-25",835000,0,35000,800000,"2013-09-25","-",0,630000]
["2013-09-26","2013-10-25",800000,0,35000,765000,"2013-10-25","-",0,665000]
["2013-10-26","2013-11-25",765000,0,35000,730000,"2013-11-25","-",0,700000]
["2013-11-26","2013-12-25",730000,0,35000,695000,"2013-12-25","-",0,735000]
["2013-12-26","2014-01-25",695000,0,35000,660000,"2014-01-25","-",0,770000]
[{"$f":"B36+1","v":"2014-01-26"},"2014-02-25",660000,0,35000,625000,"2014-02-25","-",0,805000]
[{"$f":"B37+1","v":"2014-02-26"},"2014-03-25",{"$f":"F37","v":625000},0,35000,590000,"2014-03-25","-",0,840000]
[{"$f":"B38+1","v":"2014-03-26"},"2014-04-25",590000,0,35000,555000,"2014-04-25","-",0,875000]
[{"$f":"B39+1","v":"2014-04-26"},"2014-05-25",555000,0,35000,520000,"2014-05-25","-",0,910000]
[{"$f":"B40+1","v":"2014-05-26"},"2014-06-25",520000,0,35000,485000,"2014-06-25","-",0,945000]
["2014-06-26","2014-07-25",485000,0,35000,450000,"2014-07-25","-",0,980000]
["2014-07-26","2014-08-25",450000,0,35000,415000,"2014-08-25","-",0,1015000]
["Итого:",null,"Выдано:",{"$f":"SUM(D11:D43)","v":1500000},null,{"$f":"F43","v":415000},"Погашено/Просрочено:",null,{"$f":"SUM($I$11:$I$43)","v":70000},{"$f":"J43","v":1015000}]
[]
[]
[]
["Таблица 2"]
["Период начисления"]
[1,null,2,3,4,5,6,7,8]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(1:1)))+1","v":"2012-02-26"},{"$f":"IF(I13>0,H13,G13)","v":"2012-03-25"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(1:1)))","v":35000},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(B51-A51)+1","v":29},{"$f":"IF(#REF!=#REF!,ROUND(C51*D51*E51,2),ROUND(C51*D51*E51/365,2))","v":{"$error":"#REF!"}},"-",0,{"$f":"F51-H51","v":{"$error":"#REF!"}}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(2:2)))+1","v":"2012-03-26"},{"$f":"IF(I14>0,H14,G14)","v":"2012-03-27"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(2:2)))","v":70000},{"$f":"D51","v":{"$error":"#REF!"}},{"$f":"(B52-A52)+1","v":2},{"$f":"IF(#REF!=#REF!,ROUND(C52*D52*E52,2),ROUND(C52*D52*E52/365,2))","v":{"$error":"#REF!"}},"-",0,{"$f":"I51+F52-H52","v":{"$error":"#REF!"}}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(3:3)))+1","v":"2012-04-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(3:3)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(3:3)))","v":35000},{"$f":"D52","v":{"$error":"#REF!"}},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C53*D53*E53,2),ROUND(C53*D53*E53/365,2))","v":{"$error":"#REF!"}},"-",0,{"$f":"I52+F53-H53","v":{"$error":"#REF!"}}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(4:4)))+1","v":"2012-05-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(4:4)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(4:4)))","v":70000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C54*D54*E54,2),ROUND(C54*D54*E54/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(5:5)))+1","v":"2012-06-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(5:5)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(5:5)))","v":105000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C55*D55*E55,2),ROUND(C55*D55*E55/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(6:6)))+1","v":"2012-07-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(6:6)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(6:6)))","v":140000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C56*D56*E56,2),ROUND(C56*D56*E56/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(7:7)))+1","v":"2012-08-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(7:7)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(7:7)))","v":175000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C57*D57*E57,2),ROUND(C57*D57*E57/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(8:8)))+1","v":"2012-09-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(8:8)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(8:8)))","v":210000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C58*D58*E58,2),ROUND(C58*D58*E58/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(9:9)))+1","v":"2012-10-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(9:9)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(9:9)))","v":245000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C59*D59*E59,2),ROUND(C59*D59*E59/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(10:10)))+1","v":"2012-11-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(10:10)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(10:10)))","v":280000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C60*D60*E60,2),ROUND(C60*D60*E60/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(11:11)))+1","v":"2012-12-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(11:11)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(11:11)))","v":315000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C61*D61*E61,2),ROUND(C61*D61*E61/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(12:12)))+1","v":"2013-01-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(12:12)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(12:12)))","v":350000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C62*D62*E62,2),ROUND(C62*D62*E62/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(13:13)))+1","v":"2013-02-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(13:13)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(13:13)))","v":385000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C63*D63*E63,2),ROUND(C63*D63*E63/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(15:15)))+1","v":"2013-04-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(14:14)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(15:15)))","v":455000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C64*D64*E64,2),ROUND(C64*D64*E64/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(16:16)))+1","v":"2013-05-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(15:15)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(16:16)))","v":490000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C65*D65*E65,2),ROUND(C65*D65*E65/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(17:17)))+1","v":"2013-06-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(16:16)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(17:17)))","v":525000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C66*D66*E66,2),ROUND(C66*D66*E66/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(18:18)))+1","v":"2013-07-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(17:17)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(18:18)))","v":560000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C67*D67*E67,2),ROUND(C67*D67*E67/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(19:19)))+1","v":"2013-08-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(18:18)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(19:19)))","v":595000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C68*D68*E68,2),ROUND(C68*D68*E68/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(20:20)))+1","v":"2013-09-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(19:19)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(20:20)))","v":630000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C69*D69*E69,2),ROUND(C69*D69*E69/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(21:21)))+1","v":"2013-10-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(20:20)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(21:21)))","v":665000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C70*D70*E70,2),ROUND(C70*D70*E70/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(22:22)))+1","v":"2013-11-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(21:21)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(22:22)))","v":700000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C71*D71*E71,2),ROUND(C71*D71*E71/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(23:23)))+1","v":"2013-12-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(22:22)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(23:23)))","v":735000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C72*D72*E72,2),ROUND(C72*D72*E72/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(24:24)))+1","v":"2014-01-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(23:23)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(24:24)))","v":770000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C73*D73*E73,2),ROUND(C73*D73*E73/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(25:25)))+1","v":"2014-02-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(24:24)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(25:25)))","v":805000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C74*D74*E74,2),ROUND(C74*D74*E74/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(26:26)))+1","v":"2014-03-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(25:25)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(26:26)))","v":840000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C75*D75*E75,2),ROUND(C75*D75*E75/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(27:27)))+1","v":"2014-04-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(26:26)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(27:27)))","v":875000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C76*D76*E76,2),ROUND(C76*D76*E76/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(28:28)))+1","v":"2014-05-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(27:27)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(28:28)))","v":910000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C77*D77*E77,2),ROUND(C77*D77*E77/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(29:29)))+1","v":"2014-06-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(29:29)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(29:29)))","v":945000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C78*D78*E78,2),ROUND(C78*D78*E78/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
[{"$f":"INDEX(VALUE($G$11:$G$43),SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(30:30)))+1","v":"2014-07-26"},{"$f":"INDEX($H$11:$H$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10+1),ROW(30:30)))","v":"-"},{"$f":"INDEX($J$11:$J$43,SMALL(IF($J$11:$J$43<>0,ROW($J$11:$J$43)-$O$10),ROW(30:30)))","v":980000},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"IF(#REF!=#REF!,ROUND(C79*D79*E79,2),ROUND(C79*D79*E79/365,2))","v":{"$error":"#REF!"}},"-",0,{"$error":"#REF!"}]
["ИТОГО:",null,"Начислено/Погашено/Просрочено",null,null,{"$f":"SUM($F$51:$F$79)","v":{"$error":"#REF!"}},null,{"$f":"SUM($H$51:$H$79)","v":0},{"$f":"F80-H80","v":{"$error":"#REF!"}}]