{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Magacin","Firme","Fakture","Otpremnice"],"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":"Magacin","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["ARTIKLI"]
["ŠIFRA","NAZIV ARTIKLA","J.M.","KOLIČINA","VP CIJENA sa pdv","nabavna cijena","vp cijena","mp cijena"]
[11,"Artikal 1 - 25kg","kg",10000,2,0.48599999999999999,0.91,1.4]
[22,"Artikal 2 - 15kg","kom",10000,0.39900000000000002,0.39900000000000002,0.92800000000000005,1.2]
[33,"Artikal 3 - 15kg","kg",10000,1.119,1.119,2.1419999999999999,2.8]
[44,"Artikal 4 - 12kg","kg",10000,1.111,1.111,2.0699999999999998,2.6]
[55,"Artikal 3 - 15kg","kom",10000,1.4275,1.4275,2.6859999999999999,3.3]
[66,"Artikal 4 - 12kg","kg",10000,1.6870000000000001,1.6870000000000001,3.1554000000000002,3.82]
[77,"Artikal 3 - 15kg","kg",10000,1.9464999999999999,1.9464999999999999,3.6248,4.34]
[88,"Artikal 4 - 12kg","kg",10000,2.206,2.206,4.0941999999999998,4.8600000000000003]
[99,"Artikal 3 - 15kg","kg",10000,2.4655,2.4655,4.5636000000000001,5.38]
[1010,"Artikal 4 - 12kg","kom",10000,2.7250000000000001,2.7250000000000001,5.0330000000000004,5.9]
[1111,"Artikal 3 - 15kg","kg",10000,2.9845000000000002,2.9845000000000002,5.5023999999999997,6.42]

{"sheet":"Firme","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["KUPCI"]
["ŠIFRA","NAZIV","ADRESA","PIB","PDV"]
[0,"-","-","-","-"]
[1,"Firma 1","Adresa 1",11,111]
[2,"Firma 2","Adresa 2",22,222]
[3,"Firma 3","Adresa 3",33,333]
[4,"Firma 4","Adresa 4",44,444]
[5,"Firma 5","Adresa 5",55,555]
[6,"Firma 6","Adresa 6",66,666]
[7,"Firma 7","Adresa 7",77,777]
[8,"Firma 8","Adresa 8",88,888]
[9,"Firma 9","Adresa 9",99,999]
[10,"Firma 10","Adresa 10",110,1110]
[11,"Firma 11","Adresa 11",121,1221]
[12,"Firma 12","Adresa 12",132,1332]
[13,"Firma 13","Adresa 13",143,1443]

{"sheet":"Fakture","index":2,"n_rows":131,"n_cols":13,"rows_kept":131,"cut":false,"hidden":false,"merged":[[129,9,129,11],[128,9,128,11],[1,8,6,11],[14,4,14,6],[2,2,2,3],[3,2,3,3],[4,2,4,3],[8,3,8,4],[122,10,122,11],[123,10,123,11],[124,10,124,11],[121,10,121,11],[120,10,120,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"RAČUN BR.",0,null,null,null,null,null,"KUPAC (ID):",0]
[null,null,null,null,null,null,null,null,"Naziv kupca:",{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,Firme!A3:E50001,2,FALSE))","v":"-"}]
[null,"Datum:",null,null,null,null,null,null,"Adresa:",{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,Firme!A3:E50001,3,FALSE))","v":"-"}]
[null,null,null,null,null,null,null,null,"PIB",{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,Firme!A3:E50001,4,FALSE))","v":"-"}]
[null,null,null,null,null,null,null,null,"PDV:",{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,Firme!A3:E50001,5,FALSE))","v":"-"}]
[]
[]
[]
["R.br","Šifra","Naziv artikla","J.M","Kol","Cijena\nbez\nPDV","Vrijednost\nbez\nPDV","Rabat %","Iznos\nrabata","Vrijednost\nbez PDV-a\nsa rabatom","PDV%","Cijena sa\nPDV","Vrijednost"]
[1,null,{"$f":"IF(B18=\"\",\"\",VLOOKUP(B18,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B18<>\"\",VLOOKUP(C18,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},{"$f":"IF(B18<>\"\",E18*F18,\"\")","v":""},0.1,{"$f":"IF(B18<>\"\",G18*H18,\"\")","v":""},{"$f":"IF(B18<>\"\",G18-I18,\"\")","v":""},{"$f":"IF(B18<>\"\",21%,\"\")","v":""},{"$f":"IF(B18=\"\",\"\",VLOOKUP(B18,Magacin!$A$3:$E$48683,5,FALSE))","v":""},{"$f":"IF(B18<>\"\",(L18*E18)-(I18:I120),\"\")","v":""}]
[{"$f":"IF(B19=\"\",\"\",A18+1)","v":""},null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B19<>\"\",VLOOKUP(C19,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0.1,{"$f":"IF(B19<>\"\",G19*H19,\"\")","v":""},{"$f":"IF(B19<>\"\",G19-I19,\"\")","v":""},"",{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
[{"$f":"IF(B20=\"\",\"\",A19+1)","v":""},null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B20<>\"\",VLOOKUP(C20,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0.1,{"$f":"IF(B20<>\"\",G20*H20,\"\")","v":""},{"$f":"IF(B20<>\"\",G20-I20,\"\")","v":""},"",{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B21=\"\",\"\",VLOOKUP(B21,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B21<>\"\",VLOOKUP(C21,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0.1,"","","",{"$f":"IF(B21=\"\",\"\",VLOOKUP(B21,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B22=\"\",\"\",VLOOKUP(B22,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B22<>\"\",VLOOKUP(C22,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B22=\"\",\"\",VLOOKUP(B22,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B23=\"\",\"\",VLOOKUP(B23,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B23<>\"\",VLOOKUP(C23,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},{"$f":"IF(B23<>\"\",E23*F23,\"\")","v":""},0,{"$f":"IF(B23<>\"\",G23*H23,\"\")","v":""},{"$f":"IF(B23<>\"\",G23-I23,\"\")","v":""},{"$f":"IF(B23<>\"\",21%,\"\")","v":""},{"$f":"IF(B23=\"\",\"\",VLOOKUP(B23,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B24=\"\",\"\",VLOOKUP(B24,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B24<>\"\",VLOOKUP(C24,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,{"$f":"IF(B24<>\"\",G24*H24,\"\")","v":""},{"$f":"IF(B24<>\"\",G24-I24,\"\")","v":""},"",{"$f":"IF(B24=\"\",\"\",VLOOKUP(B24,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B25<>\"\",VLOOKUP(C25,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,{"$f":"IF(B25<>\"\",G25*H25,\"\")","v":""},{"$f":"IF(B25<>\"\",G25-I25,\"\")","v":""},"",{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B26=\"\",\"\",VLOOKUP(B26,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B26<>\"\",VLOOKUP(C26,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B26=\"\",\"\",VLOOKUP(B26,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B27=\"\",\"\",VLOOKUP(B27,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B27<>\"\",VLOOKUP(C27,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B27=\"\",\"\",VLOOKUP(B27,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B28=\"\",\"\",VLOOKUP(B28,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B28<>\"\",VLOOKUP(C28,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B28=\"\",\"\",VLOOKUP(B28,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B29=\"\",\"\",VLOOKUP(B29,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B29<>\"\",VLOOKUP(C29,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B29=\"\",\"\",VLOOKUP(B29,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B30=\"\",\"\",VLOOKUP(B30,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B30<>\"\",VLOOKUP(C30,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B30=\"\",\"\",VLOOKUP(B30,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B31=\"\",\"\",VLOOKUP(B31,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B31<>\"\",VLOOKUP(C31,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B31=\"\",\"\",VLOOKUP(B31,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B32=\"\",\"\",VLOOKUP(B32,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B32<>\"\",VLOOKUP(C32,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B32=\"\",\"\",VLOOKUP(B32,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B33=\"\",\"\",VLOOKUP(B33,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B33<>\"\",VLOOKUP(C33,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B33=\"\",\"\",VLOOKUP(B33,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B34=\"\",\"\",VLOOKUP(B34,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP(C34,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B34<>\"\",VLOOKUP(C34,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B34=\"\",\"\",VLOOKUP(B34,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B35=\"\",\"\",VLOOKUP(B35,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C35=\"\",\"\",VLOOKUP(C35,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B35<>\"\",VLOOKUP(C35,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B35=\"\",\"\",VLOOKUP(B35,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C36=\"\",\"\",VLOOKUP(C36,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B36<>\"\",VLOOKUP(C36,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C37=\"\",\"\",VLOOKUP(C37,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B37<>\"\",VLOOKUP(C37,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(C38,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B38<>\"\",VLOOKUP(C38,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C39=\"\",\"\",VLOOKUP(C39,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B39<>\"\",VLOOKUP(C39,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C40=\"\",\"\",VLOOKUP(C40,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B40<>\"\",VLOOKUP(C40,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C41=\"\",\"\",VLOOKUP(C41,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B41<>\"\",VLOOKUP(C41,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C42=\"\",\"\",VLOOKUP(C42,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B42<>\"\",VLOOKUP(C42,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C43=\"\",\"\",VLOOKUP(C43,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B43<>\"\",VLOOKUP(C43,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B44=\"\",\"\",VLOOKUP(B44,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C44=\"\",\"\",VLOOKUP(C44,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B44<>\"\",VLOOKUP(C44,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B44=\"\",\"\",VLOOKUP(B44,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C45=\"\",\"\",VLOOKUP(C45,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B45<>\"\",VLOOKUP(C45,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C46=\"\",\"\",VLOOKUP(C46,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B46<>\"\",VLOOKUP(C46,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C47=\"\",\"\",VLOOKUP(C47,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B47<>\"\",VLOOKUP(C47,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B48=\"\",\"\",VLOOKUP(B48,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C48=\"\",\"\",VLOOKUP(C48,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B48<>\"\",VLOOKUP(C48,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B48=\"\",\"\",VLOOKUP(B48,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C49=\"\",\"\",VLOOKUP(C49,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B49<>\"\",VLOOKUP(C49,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C50=\"\",\"\",VLOOKUP(C50,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B50<>\"\",VLOOKUP(C50,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C51=\"\",\"\",VLOOKUP(C51,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B51<>\"\",VLOOKUP(C51,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C52=\"\",\"\",VLOOKUP(C52,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B52<>\"\",VLOOKUP(C52,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C53=\"\",\"\",VLOOKUP(C53,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B53<>\"\",VLOOKUP(C53,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B54=\"\",\"\",VLOOKUP(B54,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C54=\"\",\"\",VLOOKUP(C54,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B54<>\"\",VLOOKUP(C54,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B54=\"\",\"\",VLOOKUP(B54,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C55=\"\",\"\",VLOOKUP(C55,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B55<>\"\",VLOOKUP(C55,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B56=\"\",\"\",VLOOKUP(B56,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C56=\"\",\"\",VLOOKUP(C56,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B56<>\"\",VLOOKUP(C56,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B56=\"\",\"\",VLOOKUP(B56,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B57=\"\",\"\",VLOOKUP(B57,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C57=\"\",\"\",VLOOKUP(C57,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B57<>\"\",VLOOKUP(C57,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B57=\"\",\"\",VLOOKUP(B57,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B58=\"\",\"\",VLOOKUP(B58,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C58=\"\",\"\",VLOOKUP(C58,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B58<>\"\",VLOOKUP(C58,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B58=\"\",\"\",VLOOKUP(B58,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B59=\"\",\"\",VLOOKUP(B59,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C59=\"\",\"\",VLOOKUP(C59,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B59<>\"\",VLOOKUP(C59,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B59=\"\",\"\",VLOOKUP(B59,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B60=\"\",\"\",VLOOKUP(B60,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C60=\"\",\"\",VLOOKUP(C60,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B60<>\"\",VLOOKUP(C60,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B60=\"\",\"\",VLOOKUP(B60,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B61=\"\",\"\",VLOOKUP(B61,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C61=\"\",\"\",VLOOKUP(C61,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B61<>\"\",VLOOKUP(C61,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B61=\"\",\"\",VLOOKUP(B61,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B62=\"\",\"\",VLOOKUP(B62,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C62=\"\",\"\",VLOOKUP(C62,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B62<>\"\",VLOOKUP(C62,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B62=\"\",\"\",VLOOKUP(B62,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B63=\"\",\"\",VLOOKUP(B63,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C63=\"\",\"\",VLOOKUP(C63,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B63<>\"\",VLOOKUP(C63,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B63=\"\",\"\",VLOOKUP(B63,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
["",null,{"$f":"IF(B64=\"\",\"\",VLOOKUP(B64,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C64=\"\",\"\",VLOOKUP(C64,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B64<>\"\",VLOOKUP(C64,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B64=\"\",\"\",VLOOKUP(B64,Magacin!$A$3:$E$48683,5,FALSE))","v":""},""]
[]
[{"$f":"IF(B66=\"\",\"\",A64+1)","v":""},null,{"$f":"IF(B66=\"\",\"\",VLOOKUP(B66,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C66=\"\",\"\",VLOOKUP(C66,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B66<>\"\",VLOOKUP(C66,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B66=\"\",\"\",VLOOKUP(B66,Magacin!$A$3:$E$48683,5,FALSE))","v":""},{"$f":"IF(B66<>\"\",(L66*E66)-(I66:I167),\"\")","v":""}]
[]
[{"$f":"IF(B68=\"\",\"\",A66+1)","v":""},null,{"$f":"IF(B68=\"\",\"\",VLOOKUP(B68,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C68=\"\",\"\",VLOOKUP(C68,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B68<>\"\",VLOOKUP(C68,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B68=\"\",\"\",VLOOKUP(B68,Magacin!$A$3:$E$48683,5,FALSE))","v":""},{"$f":"IF(B68<>\"\",(L68*E68)-(I68:I168),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B93=\"\",\"\",A68+1)","v":""},null,{"$f":"IF(B93=\"\",\"\",VLOOKUP(B93,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C93=\"\",\"\",VLOOKUP(C93,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B93<>\"\",VLOOKUP(C93,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B93=\"\",\"\",VLOOKUP(B93,Magacin!$A$3:$E$48683,5,FALSE))","v":""},{"$f":"IF(B93<>\"\",(L93*E93)-(I93:I169),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B105=\"\",\"\",A93+1)","v":""},null,{"$f":"IF(B105=\"\",\"\",VLOOKUP(B105,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C105=\"\",\"\",VLOOKUP(C105,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B105<>\"\",VLOOKUP(C105,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B105=\"\",\"\",VLOOKUP(B105,Magacin!$A$3:$E$48683,5,FALSE))","v":""},{"$f":"IF(B105<>\"\",(L105*E105)-(I105:I170),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B116=\"\",\"\",A105+1)","v":""},null,{"$f":"IF(B116=\"\",\"\",VLOOKUP(B116,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C116=\"\",\"\",VLOOKUP(C116,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B116<>\"\",VLOOKUP(C116,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B116=\"\",\"\",VLOOKUP(B116,Magacin!$A$3:$E$48683,5,FALSE))","v":""},{"$f":"IF(B116<>\"\",(L116*E116)-(I116:I171),\"\")","v":""}]
[]
[]
[]
[{"$f":"IF(B120=\"\",\"\",A116+1)","v":""},null,{"$f":"IF(B120=\"\",\"\",VLOOKUP(B120,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C120=\"\",\"\",VLOOKUP(C120,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B120<>\"\",VLOOKUP(C120,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B120=\"\",\"\",VLOOKUP(B120,Magacin!$A$3:$E$48683,5,FALSE))","v":""},{"$f":"IF(B120<>\"\",(L120*E120)-(I120:I172),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Vrijednost bez PDV",null,{"$f":"SUM(G18:G120)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Iznos rabata",null,{"$f":"SUM(I18:I120)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Osnovica 21%",null,{"$f":"M121-M122","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Iznos PDV",null,{"$f":"M123*(21/100)","v":0}]
["",null,{"$f":"IF(B125=\"\",\"\",VLOOKUP(B125,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C125=\"\",\"\",VLOOKUP(C125,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B125<>\"\",VLOOKUP(C125,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","Za uplatu",null,{"$f":"M123+M124","v":0}]
["",null,{"$f":"IF(B126=\"\",\"\",VLOOKUP(B126,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C126=\"\",\"\",VLOOKUP(C126,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B126<>\"\",VLOOKUP(C126,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},"",0,"","","",{"$f":"IF(B126=\"\",\"\",VLOOKUP(B126,Magacin!$A$3:$E$48683,5,FALSE))","v":""}]
["",null,{"$f":"IF(B127=\"\",\"\",VLOOKUP(B127,Magacin!$A$3:$E$48683,2,FALSE))","v":""},{"$f":"IF(C127=\"\",\"\",VLOOKUP(C127,Magacin!$B$3:$H$48683,2,FALSE))","v":""},null,{"$f":"IF(B127<>\"\",VLOOKUP(C127,Magacin!$B$3:$H$48683,4,FALSE)*(1-0.21),\"\")","v":""},{"$f":"IF(B127<>\"\",E127*F127,\"\")","v":""},0,"","",{"$f":"IF(B127<>\"\",21%,\"\")","v":""},{"$f":"IF(B127=\"\",\"\",VLOOKUP(B127,Magacin!$A$3:$E$48683,5,FALSE))","v":""}]
[null,null,{"$f":"IF(B128=\"\",\"\",VLOOKUP(B128,Magacin!A7:E3835,2,FALSE))","v":""}]
[null,null,"Kupac",null,null,null,null,null,null,"Fakturisao"]
[null,null,{"$f":"IF(B130=\"\",\"\",VLOOKUP(B130,Magacin!A7:E3837,2,FALSE))","v":""},null,null,null,"M.P.",null,null,"  "]
[null,null,{"$f":"IF(B131=\"\",\"\",VLOOKUP(B131,Magacin!A7:E3838,2,FALSE))","v":""}]

{"sheet":"Otpremnice","index":3,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,2,3],[3,2,3,3],[4,2,4,3],[29,8,29,9],[30,8,30,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["r.br","šifra","Naziv artikla","Količina","Nabavna\nCijena","Nabavna.\nVrijednost","Veleprod.\n Cijena","Veleprod. \nVijednost","Maloprod.\nCijena","Maloprod.\nCijena"]
[1,55,{"$f":"IF(B13=\"\",\"\",VLOOKUP(B13,Magacin!$A$3:$H$49985,2,FALSE))","v":"Artikal 3 - 15kg"},8574,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,Magacin!$B$3:$H49985,5,FALSE))","v":1.119},{"$f":"IF(B13<>\"\",D13*E13,\"\")","v":9594.3060000000005},{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,Magacin!$B$3:$H49985,6,FALSE))","v":2.1419999999999999},{"$f":"IF(B13<>\"\",D13*G13,\"\")","v":18365.507999999998},{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,Magacin!$B$3:$H49985,7,TRUE))","v":2.8},{"$f":"IF(B13<>\"\",D13*I13,\"\")","v":24007.199999999997}]
[{"$f":"IF(B14=\"\",\"\",A13+1)","v":""},null,{"$f":"IF(B14=\"\",\"\",VLOOKUP(B14,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,Magacin!$B$3:$H49986,5,FALSE))","v":""},{"$f":"IF(B14<>\"\",D14*E14,\"\")","v":""},{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,Magacin!$B$3:$H49986,6,FALSE))","v":""},{"$f":"IF(B14<>\"\",D14*G14,\"\")","v":""},{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,Magacin!$B$3:$H49986,7,TRUE))","v":""},{"$f":"IF(B14<>\"\",D14*I14,\"\")","v":""}]
[{"$f":"IF(B15=\"\",\"\",A14+1)","v":""},null,{"$f":"IF(B15=\"\",\"\",VLOOKUP(B15,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Magacin!$B$3:$H49987,5,FALSE))","v":""},"",{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Magacin!$B$3:$H49987,6,FALSE))","v":""},"",{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Magacin!$B$3:$H49987,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B16=\"\",\"\",VLOOKUP(B16,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,Magacin!$B$3:$H49988,5,FALSE))","v":""},"",{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,Magacin!$B$3:$H49988,6,FALSE))","v":""},"",{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,Magacin!$B$3:$H49988,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B17=\"\",\"\",VLOOKUP(B17,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Magacin!$B$3:$H49989,5,FALSE))","v":""},"",{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Magacin!$B$3:$H49989,6,FALSE))","v":""},"",{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Magacin!$B$3:$H49989,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B18=\"\",\"\",VLOOKUP(B18,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Magacin!$B$3:$H49990,5,FALSE))","v":""},"",{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Magacin!$B$3:$H49990,6,FALSE))","v":""},"",{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Magacin!$B$3:$H49990,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(B19,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Magacin!$B$3:$H49991,5,FALSE))","v":""},"",{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Magacin!$B$3:$H49991,6,FALSE))","v":""},"",{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Magacin!$B$3:$H49991,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Magacin!$B$3:$H49992,5,FALSE))","v":""},"",{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Magacin!$B$3:$H49992,6,FALSE))","v":""},"",{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Magacin!$B$3:$H49992,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B21=\"\",\"\",VLOOKUP(B21,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Magacin!$B$3:$H49993,5,FALSE))","v":""},"",{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Magacin!$B$3:$H49993,6,FALSE))","v":""},"",{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Magacin!$B$3:$H49993,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B22=\"\",\"\",VLOOKUP(B22,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Magacin!$B$3:$H49994,5,FALSE))","v":""},"",{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Magacin!$B$3:$H49994,6,FALSE))","v":""},"",{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Magacin!$B$3:$H49994,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B23=\"\",\"\",VLOOKUP(B23,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Magacin!$B$3:$H49995,5,FALSE))","v":""},"",{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Magacin!$B$3:$H49995,6,FALSE))","v":""},"",{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Magacin!$B$3:$H49995,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B24=\"\",\"\",VLOOKUP(B24,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Magacin!$B$3:$H49996,5,FALSE))","v":""},"",{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Magacin!$B$3:$H49996,6,FALSE))","v":""},"",{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Magacin!$B$3:$H49996,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Magacin!$B$3:$H49997,5,FALSE))","v":""},"",{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Magacin!$B$3:$H49997,6,FALSE))","v":""},"",{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Magacin!$B$3:$H49997,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B26=\"\",\"\",VLOOKUP(B26,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Magacin!$B$3:$H49998,5,FALSE))","v":""},"",{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Magacin!$B$3:$H49998,6,FALSE))","v":""},"",{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Magacin!$B$3:$H49998,7,TRUE))","v":""},""]
["",null,{"$f":"IF(B27=\"\",\"\",VLOOKUP(B27,Magacin!$A$3:$H$49985,2,FALSE))","v":""},null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Magacin!$B$3:$H49999,5,FALSE))","v":""},"",{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Magacin!$B$3:$H49999,6,FALSE))","v":""},"",{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Magacin!$B$3:$H49999,7,TRUE))","v":""},""]
[null,null,null,null,"Ukupno",{"$f":"SUM(F13:F19)","v":9594.3060000000005},null,{"$f":"SUM(H13:H19)","v":18365.507999999998},null,{"$f":"SUM(J13:J19)","v":24007.199999999997}]