{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet4","Sheet3","OBRACUN PDVa"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"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":"Sheet1","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"code","naziv","cijena"]
[null,101,"Pastrmka kalif. o~i{}ena",9.94]
[null,102,"Pastrmka kalif. neo~i{}ena",9.94]
[null,103,"Pastrmka poto~na o~i{}ena ",8.94]
[null,104,"Pastrmka poto~na neo~i{}ena ",8.94]
[null,105]
[null,106]
[null,107]
[null,108]

{"sheet":"Sheet4","index":1,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":false,"merged":[[49,1,49,2],[50,0,51,3],[52,0,53,3],[49,10,49,11],[50,10,50,11],[50,6,52,7],[35,0,35,1],[35,2,35,3],[7,0,7,11],[0,5,0,11],[6,5,6,11],[1,5,1,11],[2,5,2,11],[3,7,3,11],[4,7,4,11],[33,8,34,10],[33,11,34,11],[34,0,34,1],[34,2,34,3],[33,0,33,1],[33,2,33,3],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[8,5,8,10],[9,5,9,11],[10,5,10,11],[12,7,12,11],[13,7,14,11],[13,5,14,6],[12,5,12,6],[23,1,23,2],[18,6,18,7],[18,8,18,9],[11,5,11,10],[17,1,17,2],[17,6,17,7],[17,8,17,9],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[13,0,14,1],[13,3,14,3],[13,2,14,2],[5,7,5,11],[3,5,3,6],[4,5,4,6],[5,5,5,6],[11,0,12,1],[11,2,12,4]]}
[null,null,null,null,null,"KRUPSKI SLAPOVI D.O.O. Krupa na Vrbasu"]
[null,null,null,null,null,"tel/faks : 051/417-048, mob: 065/541-706, 065/354-906, 065/743-770"]
[null,null,null,null,null,"`iro ra~un : Nova banka a.d. Banja Luka 555-007-00514367-38"]
[null,null,null,null,null,"PDV broj",null,403405210004]
[null,null,null,null,null,"Mati~ni broj",null,11087515]
[null,null,null,null,null,"[ifra djelatnosti",null,"0322"]
[null,null,null,null,null,"e-mail adresa : krupskislapovidoo@gmail.com"]
["Privatno i proizvodno preduze}e za uzgoj ribe d.o.o. , Krupa na Vrbasu bb - Banja Luka"]
[]
[null,null,null,null,null,"FRATELLO-TRADE a.d.."]
[null,null,null,null,null,{"$f":"VLOOKUP(F10,iteam6,5,0)","v":"Ramici b.b. Banja Luka"}]
["Datum",null,"2018-11-15"]
[null,null,null,null,null,"PDV broj",null,{"$f":"VLOOKUP(F10,iteam6,3,0)","v":400929510006}]
["Ra~un broj",null,1122,"/18",null,"Mjesto isporuke"]
[]
[]
[]
["Red broj","Naziv proizvoda",null,"Koli~ina","Cijena","Rabat %","Cijena sa Rabatom",null,"Iznos sa rabatom",null,"PDV 17%","Ukupno sa PDV-om",null,null,null,null,null,"OSNOVICA","IZNOS PDV-a","UKUPNO SA PDV-om"]
[1,"Pastrmka kalif. neo~i{}ena",null,10,8.94,{"$f":"(E19-G19)/E19*100","v":35.123042505592835},{"$f":"VLOOKUP(F10,iteam6,2,0)","v":5.8},null,{"$f":"D19*G19","v":58},null,{"$f":"L19-I19","v":9.86},{"$f":"I19*1.17","v":67.86},null,null,null,null,null,{"$f":"L32","v":58},{"$f":"L33","v":9.86},{"$f":"L34","v":67.86}]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[null,null,null,null,null,null,null,null,null,"Ukupno bez Rabata",null,{"$f":"D19*E19+D20*E20","v":89.399999999999991}]
[null,null,null,null,null,null,null,null,null,"Rabat",null,{"$f":"L32-L30","v":-31.399999999999991}]
[null,null,null,null,null,null,null,null,null,"Ukupno bez PDV-a",null,{"$f":"I19","v":58}]
[null,null,null,null,null,null,null,null,null,"PDV 17%",null,{"$f":"K19","v":9.86}]
["Rok za pla}anje",null,"15 dana",null,null,null,null,null,"Ukupno sa PDV-om",null,null,{"$f":"L19","v":67.86}]
["Na~in pla}anja ",null,{"$f":"VLOOKUP(F10,iteam6,4,0)","v":"ZIRALNO"}]
["Nova banka a.d.",null,"555-007-00514367-38"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Robu primio",null,null,null,null,null,null,null,null,"Krupski Slapovi doo"]
[{"$f":"F10","v":"FRATELLO-TRADE a.d.."},null,null,null,null,null,"M.P.",null,null,null,"(odgovorno lice)"]

{"sheet":"Sheet3","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["CODE","KUPAC","CIJENA SA RABATOM","PDV BROJ","NACIN PLACANJA","ADRESA"]
[110,"FRATELLO-TRADE a.d.",7.35,400929510006,"ZIRALNO","Ramici b.b. Banja Luka"]
[111,"„VILA VRBAS'' D.O.O.",9.94,402486090001,"ZIRALNO","Banja Luka"]
[112,"EUROGAS D.O.O.",7.35,400795640005,"ZIRALNO","Vojvode Stepe Stjepanovi}a 259 Banja Luka"]
[113,"TULUMOVI] D.O.O.",7.15,401158620005,"ZIRALNO","Miroslava Anti}a br.41 LAKTA[I"]
[114,"VIDI] – PETROL D.O.O.",9.94,400126050006,"ZIRALNO","Brod"]
[115,"FRATELLO-TRADE a.d..",5.8,400929510006,"ZIRALNO","Ramici b.b. Banja Luka"]
[116,"SUR  „ZLATNA KRUNA''",9.94,508111740001,"ZIRALNO","Banja Luka"]
[117,"RIBARNICA ALAS S.P. \\OKO VU^I]",6.84,505349440007,"ZIRALNO","Banja Luka"]
[118,"''IHTIS'' Branislav Jevti} S.P.",8.94,4510556320007,"ZIRALNO","Banja Luka"]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]

{"sheet":"OBRACUN PDVa","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["OSNOVICA","IZNOS PDV-a","UKUPNO SA PDV-om"]
[58,9.86,67.86]