{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Pregled","Kupac1","Kupac2","Kupac3","Šifarnik"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Pregled","index":0,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[6,1,6,4],[9,1,9,2],[8,1,8,2],[11,1,11,2],[12,1,12,2]]}
["Tabela",1,2,3,4,"Suma"]
["Kupac1",{"$f":"Kupac1!B5","v":12},{"$f":"Kupac1!C5","v":24},{"$f":"Kupac1!D5","v":12},{"$f":"Kupac1!E5","v":0},{"$f":"Kupac1!F5","v":48}]
["Kupac2",{"$f":"Kupac2!B5","v":25},{"$f":"Kupac2!C5","v":0},{"$f":"Kupac2!D5","v":24},{"$f":"Kupac2!E5","v":0},{"$f":"Kupac1!F6","v":0},null,"Zbir uplata svakog kupca za godinu"]
["Kupac3",{"$f":"Kupac3!B5","v":0},{"$f":"Kupac3!C5","v":0},{"$f":"Kupac3!D5","v":0},{"$f":"Kupac3!F5","v":0},{"$f":"Kupac1!F7","v":0}]
["Suma",{"$f":"SUM(B2:B4)","v":37},{"$f":"SUM(C2:C4)","v":24},36,0,{"$f":"SUM(F2:F4)","v":48},null,"Zbir svih uplata za godinu"]
[]
[null,"Zbir svih uplata po kvartalima"]
[]
[null,"Kupac",null,null,"Kvartal"]
[null,"Kupac2",null,null,1]
[]
[null,"Artikal",null,null,"Iznos"]
[null,"Luk",null,null,1]
[]
[null,{"$f":"B10","v":"Kupac2"},{"$f":"B13","v":"Luk"},{"$f":"E10","v":1}]
[]
[null,{"$f":"CONCATENATE(Pregled!B15,\"!\",VLOOKUP(Pregled!E10,Šifarnik!E2:H5,2,FALSE),ROW(INDEX(Kupac1!A2:A4,MATCH(Pregled!C15,Kupac1!A2:A4,0))))","v":{"$error":"#N/A"}}]

{"sheet":"Kupac1","index":1,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Artikal",1,2,3,4,"Suma"]
["Jabuka",12,24,12,0,{"$f":"SUM(B2:E2)","v":48}]
["Kruška",0,0,0,0,{"$f":"SUM(B3:E3)","v":0}]
["Banana",0,0,0,0,{"$f":"SUM(B4:E4)","v":0}]
["Suma",{"$f":"SUM(B2:B4)","v":12},{"$f":"SUM(C2:C4)","v":24},12,0,48]

{"sheet":"Kupac2","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Artikal",1,2,3,4,"Suma"]
["Luk",13,0,24,0,{"$f":"SUM(B2:E2)","v":37}]
["Krompir",12,0,0,0,{"$f":"SUM(B3:E3)","v":12}]
["Kupus",0,0,0,0,{"$f":"SUM(B4:E4)","v":0}]
["Suma",{"$f":"SUM(B2:B4)","v":25},{"$f":"SUM(C2:C4)","v":0},24,0,49]

{"sheet":"Kupac3","index":3,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Artikal",1,2,3,4,"Suma"]
["Krompir",0,0,0,0,{"$f":"SUM(B2:E2)","v":0}]
["Jabuka",0,0,0,0,{"$f":"SUM(B3:E3)","v":0}]
["Jagoda",0,0,0,0,{"$f":"SUM(B4:E4)","v":0}]
["Suma",{"$f":"SUM(B2:B4)","v":0},{"$f":"SUM(C2:C4)","v":0},0,0,0]

{"sheet":"Šifarnik","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Kupac",null,"Arikal",null,"Kvartal"]
["Kupac1",null,"Luk",null,1,"B"]
["Kupac2",null,"Krompir",null,2,"C"]
["Kupac3",null,"Kupus",null,3,"D"]
[null,null,"Jabuka",null,4,"E"]
[null,null,"Kruška"]
[null,null,"Jagoda"]
[null,null,"Banana"]