{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Podaci o prodaji","Izvješće o prodaji","Zalihe"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Podaci o prodaji","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"DNEVNA PRODAJA ZA BLAGAJNU"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"DATUM","VRIJEME","BROJ TRANSAKCIJE","OZNAKA/BROJ PROIZVODA","OPIS","IZNOS PRODAJE","% POREZA","PDV","UKUPNO"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"\",VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"Nije pronađen nikakav osip\")","v":"Deka"},{"v":74.95,"d":"74.95 kn"},{"v":0.05,"d":"5.00%"},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]*tblPodaciOProdaji[[#This Row],[% POREZA]]","v":{"v":3.7475000000000005,"d":"3.75 kn"}},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]+tblPodaciOProdaji[[#This Row],[PDV]]","v":{"v":78.6975,"d":"78.70 kn"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"\",VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"Nije pronađen nikakav osip\")","v":"Stolnjak, 15 cm, okrugli"},{"v":34.99,"d":"34.99 kn"},{"v":0.05,"d":"5.00%"},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]*tblPodaciOProdaji[[#This Row],[% POREZA]]","v":{"v":1.7495000000000003,"d":"1.75 kn"}},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]+tblPodaciOProdaji[[#This Row],[PDV]]","v":{"v":36.7395,"d":"36.74 kn"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"\",VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"Nije pronađen nikakav osip\")","v":"Okrugli pladanj"},{"v":55.95,"d":"55.95 kn"},{"v":0.05,"d":"5.00%"},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]*tblPodaciOProdaji[[#This Row],[% POREZA]]","v":{"v":2.7975000000000003,"d":"2.80 kn"}},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]+tblPodaciOProdaji[[#This Row],[PDV]]","v":{"v":58.7475,"d":"58.75 kn"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"\",VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"Nije pronađen nikakav osip\")","v":"Kvadratni pladanj"},{"v":2.95,"d":"2.95 kn"},{"v":0.05,"d":"5.00%"},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]*tblPodaciOProdaji[[#This Row],[% POREZA]]","v":{"v":0.14750000000000002,"d":"0.15 kn"}},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]+tblPodaciOProdaji[[#This Row],[PDV]]","v":{"v":3.0975,"d":"3.10 kn"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"\",VLOOKUP(tblPodaciOProdaji[[#This Row],[OZNAKA/BROJ PROIZVODA]],tblZalihe[],2,0)),\"Nije pronađen nikakav osip\")","v":"Jastuk"},{"v":14.98,"d":"14.98 kn"},{"v":0.05,"d":"5.00%"},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]*tblPodaciOProdaji[[#This Row],[% POREZA]]","v":{"v":0.7490000000000001,"d":"0.75 kn"}},{"$f":"tblPodaciOProdaji[[#This Row],[IZNOS PRODAJE]]+tblPodaciOProdaji[[#This Row],[PDV]]","v":{"v":15.729000000000001,"d":"15.73 kn"}}]

{"sheet":"Izvješće o prodaji","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"DNEVNA PRODAJA ZA BLAGAJNU"]
[]
[]
[]
[]
[]
[null,"OZNAKA/BROJ PROIZVODA","OPIS","DATUM","Sales Amount ","Sales Tax ","Total "]
[null,90001,"Deka","2012-02-01",{"v":74.95,"d":"74.95 kn"},{"v":3.7475000000000005,"d":"3.75 kn"},{"v":78.6975,"d":"78.70 kn"}]
[null,90002,"Jastuk","2012-02-01",{"v":14.98,"d":"14.98 kn"},{"v":0.7490000000000001,"d":"0.75 kn"},{"v":15.729000000000001,"d":"15.73 kn"}]
[null,90004,"Kvadratni pladanj","2012-02-01",{"v":2.95,"d":"2.95 kn"},{"v":0.14750000000000002,"d":"0.15 kn"},{"v":3.0975,"d":"3.10 kn"}]
[null,90005,"Okrugli pladanj","2012-02-01",{"v":55.95,"d":"55.95 kn"},{"v":2.7975000000000003,"d":"2.80 kn"},{"v":58.7475,"d":"58.75 kn"}]
[null,90023,"Stolnjak, 15 cm, okrugli","2012-02-01",{"v":34.99,"d":"34.99 kn"},{"v":1.7495000000000003,"d":"1.75 kn"},{"v":36.7395,"d":"36.74 kn"}]
[null,"Grand Total",null,null,{"v":183.82000000000002,"d":"183.82 kn"},{"v":9.191000000000003,"d":"9.19 kn"},{"v":193.011,"d":"193.01 kn"}]

{"sheet":"Zalihe","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"DNEVNA PRODAJA ZA BLAGAJNU"]
[]
[]
[]
[]
[]
[null,"OZNAKA/BROJ PROIZVODA","OPIS"]
[null,90001,"Deka"]
[null,90002,"Jastuk"]
[null,90003,"Plahte"]
[null,90004,"Kvadratni pladanj"]
[null,90005,"Okrugli pladanj"]
[null,90006,"Zdjela, velika"]
[null,90007,"Zdjela, mala"]
[null,90008,"Okrugli pladanj, mali"]
[null,90009,"Vilica, mala"]
[null,90010,"Vilica, velika"]
[null,90011,"Žlica, mala"]
[null,90012,"Žlica, velika"]
[null,90013,"Nož za mazanje, mali"]
[null,90014,"Nož za mazanje, veliki"]
[null,90015,"Stolnjak, 25X13"]
[null,90016,"Stolnjak, 20X13"]
[null,90017,"Stolnjak, 20X20"]
[null,90018,"Stolnjak, 15x15"]
[null,90019,"Stolnjak, 15x10"]
[null,90020,"Stolnjak, 10x10"]
[null,90021,"Stolnjak, 25 cm, okrugli"]
[null,90022,"Stolnjak, 20 cm, okrugli"]
[null,90023,"Stolnjak, 15 cm, okrugli"]