{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Faktura","Lager","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Faktura","index":0,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["R.Br.","Sifra","Naziv artikla","Kolicina","JM","Cena bez ","Vrednost bez","Poreska","PDV","Vrednost sa"]
[null,null,null,null,null,"poreza","poreza","stopa",null,"porezom"]
[]
[1,"pl-3",{"$f":"VLOOKUP(B4,Lager!$B$1:$J$30,2,FALSE)","v":"plastika 3"},{"$f":"VLOOKUP(B4,Lager!$B$1:$J$30,3,FALSE)","v":10}]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":2},"pl-2",{"$f":"VLOOKUP(B5,Lager!$B$1:$J$30,2,FALSE)","v":"plastika 2"},{"$f":"VLOOKUP(B5,Lager!$B$1:$J$30,3,FALSE)","v":50}]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":3},"pk-32",{"$f":"VLOOKUP(B6,Lager!$B$1:$J$30,2,FALSE)","v":"karton-32"},{"$f":"VLOOKUP(B6,Lager!$B$1:$J$30,3,FALSE)","v":1000}]
[{"$f":"IF(B7<>\"\",A6+1,\"\")","v":4},"pk-26",{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,Lager!$B$1:$J$30,2,FALSE))","v":"karton-26"},{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,Lager!$B$1:$J$30,3,FALSE))","v":500}]
["",null,{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B13=\"\",\"\",VLOOKUP(B13,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B13=\"\",\"\",VLOOKUP(B13,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B14=\"\",\"\",VLOOKUP(B14,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B14=\"\",\"\",VLOOKUP(B14,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B15=\"\",\"\",VLOOKUP(B15,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B15=\"\",\"\",VLOOKUP(B15,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B16=\"\",\"\",VLOOKUP(B16,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B16=\"\",\"\",VLOOKUP(B16,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B17=\"\",\"\",VLOOKUP(B17,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B17=\"\",\"\",VLOOKUP(B17,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B18=\"\",\"\",VLOOKUP(B18,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B18=\"\",\"\",VLOOKUP(B18,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B21=\"\",\"\",VLOOKUP(B21,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B21=\"\",\"\",VLOOKUP(B21,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B22=\"\",\"\",VLOOKUP(B22,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B22=\"\",\"\",VLOOKUP(B22,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B23=\"\",\"\",VLOOKUP(B23,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B23=\"\",\"\",VLOOKUP(B23,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B24=\"\",\"\",VLOOKUP(B24,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B24=\"\",\"\",VLOOKUP(B24,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B26=\"\",\"\",VLOOKUP(B26,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B26=\"\",\"\",VLOOKUP(B26,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B27=\"\",\"\",VLOOKUP(B27,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B27=\"\",\"\",VLOOKUP(B27,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B28=\"\",\"\",VLOOKUP(B28,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B28=\"\",\"\",VLOOKUP(B28,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B29=\"\",\"\",VLOOKUP(B29,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B29=\"\",\"\",VLOOKUP(B29,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B30=\"\",\"\",VLOOKUP(B30,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B30=\"\",\"\",VLOOKUP(B30,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B31=\"\",\"\",VLOOKUP(B31,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B31=\"\",\"\",VLOOKUP(B31,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B32=\"\",\"\",VLOOKUP(B32,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B32=\"\",\"\",VLOOKUP(B32,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B33=\"\",\"\",VLOOKUP(B33,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B33=\"\",\"\",VLOOKUP(B33,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B34=\"\",\"\",VLOOKUP(B34,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B34=\"\",\"\",VLOOKUP(B34,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B35=\"\",\"\",VLOOKUP(B35,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B35=\"\",\"\",VLOOKUP(B35,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Lager!$B$1:$J$30,3,FALSE))","v":""}]
["",null,{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Lager!$B$1:$J$30,2,FALSE))","v":""},{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Lager!$B$1:$J$30,3,FALSE))","v":""}]

{"sheet":"Lager","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["R.Br.","Sifra","Naziv artikla","Kolicina","JM","Cena bez ","Vrednost bez","Poreska ","PDV","Vrednost sa "]
[null,null,null,null,null,"poreza","poreza","stopa",null,"porezom"]
[]
[1,"pl-1","plastika 1",100,"kom",10]
[{"$f":"IF(B5<>\"\",A4+1,\"\")","v":2},"pl-2","plastika 2",50,"kom",20]
[{"$f":"IF(B6<>\"\",A5+1,\"\")","v":3},"pl-3","plastika 3",10,"kom",30]
[4,"pl-4","plastika 4",200,"kom",40]
[5,"pk-32","karton-32",1000,"kom",20]
[6,"pk-26","karton-26",500,"kom",15]
[""]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}