{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FAKTURA1","ARTIKAL","Sheet4","Kupci"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"FAKTURA1","index":0,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[51,6,51,7],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[27,2,27,4],[36,2,36,4],[35,2,35,4],[34,2,34,4],[33,2,33,4],[32,2,32,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[9,5,9,7],[10,5,10,7],[11,5,11,7],[3,2,3,8],[50,6,50,7],[50,1,50,2],[4,2,4,8],[5,2,5,8],[6,2,6,8],[12,4,12,7],[14,2,14,4],[15,2,15,4],[16,2,16,4],[38,2,38,4],[37,2,37,4],[26,2,26,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Faktura broj:",{"$f":"Kupci!A1","v":4},"/16","Kupac:  ","Dejan"]
[]
[null,"Datum izdavanja:",{"$f":"TODAY()","v":"2016-03-13"},"god.","PIB:"]
[null,null,null,null,"PDV:"]
[]
[]
[null,"red br.","naziv proizvoda",null,null,"količina","cijena sa PDV","ukupno:"]
[null,{"$f":"IF(F16>0,\"1.\",\"\")","v":"1."},"maxidis 3l",null,null,2,{"$f":"VLOOKUP(C16,ARTIKAL!C4:D17,2,FALSE)","v":4.9000000000000004},{"$f":"F16*G16","v":9.8000000000000007}]
[null,{"$f":"IF(F17>0,\"2.\",\"\")","v":"2."},"maxipol 15l",null,null,2,{"$f":"VLOOKUP(C17,ARTIKAL!C5:D18,2,FALSE)","v":3},{"$f":"F17*G17","v":6}]
[null,{"$f":"IF(F18>0,\"3.\",\"\")","v":"3."},"maxipol 15l",null,null,3,{"$f":"VLOOKUP(C18,ARTIKAL!C4:D17,2,FALSE)","v":3},{"$f":"F18*G18","v":9}]
[null,{"$f":"IF(F19>0,\"4.\",\"\")","v":"4."},"Kanta M.",null,null,3,{"$f":"VLOOKUP(C19,ARTIKAL!C5:D18,2,FALSE)","v":2},6]
[null,{"$f":"IF(F20>0,\"5.\",\"\")","v":"5."},"Kanta M.",null,null,3,{"$f":"VLOOKUP(C20,ARTIKAL!C6:D19,2,FALSE)","v":2},6]
[null,{"$f":"IF(F21>0,\"6.\",\"\")","v":"6."},"maxidis 3l",null,null,3,{"$f":"VLOOKUP(C21,ARTIKAL!C7:D20,2,FALSE)","v":4.9000000000000004},14.700000000000001]
[null,{"$f":"IF(F22>0,\"7.\",\"\")","v":"7."},"maxipol 3l",null,null,3,{"$f":"VLOOKUP(C22,ARTIKAL!C8:D21,2,FALSE)","v":5.5},16.5]
[null,{"$f":"IF(F23>0,\"8.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F24>0,\"9.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F25>0,\"10.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F26>0,\"11.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F27>0,\"12.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F28>0,\"13.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F29>0,\"14.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F30>0,\"15.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F31>0,\"16.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F32>0,\"17.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F33>0,\"18.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F34>0,\"19.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F35>0,\"20.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F36>0,\"21.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F37>0,\"22.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F38>0,\"23.\",\"\")","v":""},null,null,null,null,null,0]
[null,{"$f":"IF(F39>0,\"24.\",\"\")","v":""},null,null,null,null,null,0]
[null,null,null,null,null,null,"Suma:",{"$f":"SUM(H16:H39)","v":68}]
[null,null,null,null,null,null,"Popust:",19]
[null,null,null,null,null,null,"Cijena  PDV",{"$f":"H40-H41%","v":67.81}]
[null,null,null,null,null,null,"Ukupno:",{"$f":"SUM(H16:H33)","v":68}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Izdao:",null,null,null,null,"Primio:"]

{"sheet":"ARTIKAL","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SIFRA","Naziv proizvoda","CIJENA"]
[null,null,"maxipol 15l"]
[null,289,"Bamper sprej",2.5]
[null,199,"cm 11 - 5",2.5]
[null,106,"Email zvezda 075",2]
[null,234,"Kanta M.",2]
[null,233,"Kanta V.",13.5]
[null,122,"Luxal 075",3.9]
[null,114,"maxidis 075l",6.3]
[null,11,"maxidis 3l",4.9000000000000004,null,289,"Bamper sprej"]
[null,133,"maxipol 075l",3.9,null,199,"cm 11 - 5"]
[null,133,"maxipol 15l",3,null,106,"Email zvezda 075"]
[null,135,"maxipol 3l",5.5,null,234,"Kanta M."]
[null,134,"maxipol 5l",3.5,null,233,"Kanta V."]
[null,181,"Sprej Cosmos",2,null,122,"Luxal 075"]
[null,167,"Uljani helios",3.5,null,114,"maxidis 075l"]
[null,null,null,null,null,11,"maxidis 3l"]
[null,null,null,null,null,133,"maxipol 075l"]
[null,null,null,null,null,133,"maxipol 15l"]
[null,null,null,null,null,135,"maxipol 3l"]
[null,null,null,null,null,134,"maxipol 5l"]
[null,null,null,null,null,181,"Sprej Cosmos"]
[null,null,null,null,null,167,"Uljani helios"]

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

{"sheet":"Kupci","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COUNTA(B:B)-1","v":4},"KUPCI","Datum"]
[null,"tzrt","13.3.2016 17:31:03"]
[null,"tzrt","13.3.2016 17:31:08"]
[null,"tzrt","13.3.2016 17:31:09"]
[null,"tzrt","13.3.2016 17:31:09"]