{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["unos","kopirano"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":7,"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":"unos","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
[null,null,"Ivan"]
["Iznos kredita",null,15000]
["Broj mesečnih rata",null,3]
["Kamata na godišnjem nivou",null,0.03]
["Mesec dospeća I rate",null,"2013-02-01"]
["Iznos mesečne rate",null,{"$f":"IF(C3=0,\"\",C2/C3*(1+C4))","v":5150}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ovdje možeš napraviti i formu pa preko nje unositi podatke"]

{"sheet":"kopirano","index":1,"n_rows":11,"n_cols":45,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["PLAN i RASPORED MJESEČNIH RATA ZA KREDIT",null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
["rb","korisnik kredita","iznos kredita","br. mjesečnih rata","KTA na godišnjem nivou","mjesec dospijeća 1. rate","iznos mjesečne rate",null,"korisnik","jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec","jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec","jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"]
[null,"Goran",10000,4,7.8E-2,"2011-05-01",2695,null,{"$f":"B3","v":"Goran"},{"$f":"IF(J$1<MONTH(INDIRECT(\"$F$\"&ROW())),\"\",IF(J$1>(INDIRECT(\"$D$\"&ROW())+MONTH(INDIRECT(\"$F$\"&ROW()))-1),\"\",IF(ISBLANK(INDIRECT(\"$F$\"&ROW())),\"\",INDIRECT(\"$G$\"&ROW()))))","v":""},"","","",2695,2695,2695,2695,"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Marko",10000,5,7.8E-2,"2013-04-01",2156,null,{"$f":"B4","v":"Marko"},"","","",2156,2156,2156,2156,2156,"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Zoran",20000,6,0.1,"2013-06-01",3666.666666666667,null,"Zoran","","","","","",3666.666666666667,3666.666666666667,3666.666666666667,3666.666666666667,3666.666666666667,3666.666666666667,"","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ivan",15000,3,0.03,"2013-02-01",5150,null,"Ivan","",5150,5150,5150,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,"","",{"$f":"IF(L$1<MONTH(INDIRECT(\"$F$\"&ROW())),\"\",IF(L$1>(INDIRECT(\"$D$\"&ROW())+MONTH(INDIRECT(\"$F$\"&ROW()))-1),\"\",IF(ISBLANK(INDIRECT(\"$F$\"&ROW())),\"\",INDIRECT(\"$G$\"&ROW()))))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AB$1<MONTH(INDIRECT(\"$F$\"&ROW())),\"\",IF(AB$1>(INDIRECT(\"$D$\"&ROW())+MONTH(INDIRECT(\"$F$\"&ROW()))-1),\"\",IF(ISBLANK(INDIRECT(\"$F$\"&ROW())),\"\",INDIRECT(\"$G$\"&ROW()))))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AR$1<MONTH(INDIRECT(\"$F$\"&ROW())),\"\",IF(AR$1>(INDIRECT(\"$D$\"&ROW())+MONTH(INDIRECT(\"$F$\"&ROW()))-1),\"\",IF(ISBLANK(INDIRECT(\"$F$\"&ROW())),\"\",INDIRECT(\"$G$\"&ROW()))))","v":""},""]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(J$1<MONTH(INDIRECT(\"$F$\"&ROW())),\"\",IF(J$1>(INDIRECT(\"$D$\"&ROW())+MONTH(INDIRECT(\"$F$\"&ROW()))-1),\"\",IF(ISBLANK(INDIRECT(\"$F$\"&ROW())),\"\",INDIRECT(\"$G$\"&ROW()))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]