{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Obrazac","Artikli","Arhiva","poslovni partneri"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Obrazac","index":0,"n_rows":53,"n_cols":20,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,1,36,6],[51,0,51,6],[52,0,52,6],[53,0,53,6]]}
[null,"Enter j.d.o.o."]
[null,"Donji Pustakovec 10"]
[null,"40323 Prelog",null,null,"GSM:","091/520-5575"]
[null,"OIB: 96829189533"]
[]
[]
[]
[]
[null,"KUPAC:",2,null,null,"Donji Pustakovec,",{"$f":"TODAY()","v":"2020-04-23"},null,null,null,null,"Opis:"]
[null,null,null,null,null,null,null,null,null,null,null,"Obrazac računa ima nekoliko osnovnih funkcionalnosti"]
[null,{"$f":"+VLOOKUP($C$9,'poslovni partneri'!$A$2:$F$200,2,FALSE)","v":"ENTER j.d.o.o."},null,null,null,null,null,null,null,null,null,"- preuzimanje podataka o kupcu iz lista \"poslovni partneri\" unos šifre u b9"]
[null,{"$f":"+VLOOKUP($C$9,'poslovni partneri'!$A$2:$F$200,3,FALSE)","v":"Donji Pustakovec 10"},null,null,null,null,null,null,null,null,null,"- Arhiviranje računa u list \"Arhiva\" "]
[null,{"$f":"+VLOOKUP($C$9,'poslovni partneri'!$A$2:$F$200,4,FALSE)","v":"40323 Prelog"},null,null,null,null,null,null,null,null,null,"- Automatska numeracija br. računa"]
[null,{"$f":"+VLOOKUP($C$9,'poslovni partneri'!$A$2:$F$200,5,FALSE)","v":"040/628-094"},null,"RAČUN BR:",3,"/1/1",null,null,null,null,null,"- izračun valute (unos dana odgode u ćeliju h18)"]
[null,{"$f":"+VLOOKUP($C$9,'poslovni partneri'!$A$2:$F$200,6,FALSE)","v":"OIB: 96829189533"},null,null,null,null,null,null,null,null,null,"- Odabir Račun ili Predračun (C14)"]
[null,null,null,null,null,"Datum isporuke:",{"$f":"G9","v":"2020-04-23"},null,null,null,null,"- Ispis poziva na broj i vrijeme izdavanja računa"]
[null,null,null,null,null,null,null,null,"Valuta",null,null,"- Preuzimanje Artikala (cijena, j.mjere i PDV)"]
[null,null,null,null,null,{"$f":"+IF(D14=\"PONUDA BR:\",\"Valjanost ponude:\",\"Datum valute:\")","v":"Datum valute:"},{"$f":"G16+I18","v":"2020-05-23"},null,30]
[null,null,null,null,null,null,null,null,null,null,null,"Ispunjava se r.br. stavke (bitno!!), Količina i Rabat)"]
[null,null,null,null,null,"Vrijeme izdavanja:",{"$f":"NOW()","v":43944.986403703704}]
[]
["R. br.","Isporučeno dobro ili \nobavljena usluga","Jed. mjere","Količina","Jed. cijena","Rabat\n%","Ukupno"]
[null,null,null,null,null,null,{"$f":"D23*E23-(D23*E23*F23/100)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(D23*E23)-D23*E23*F23/100","v":0},{"$f":"ROUND(((D23*E23)-(D23*E23*F23/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,"Obrazac u excelu","kom",1,150,10,{"$f":"D24*E24-(D24*E24*F24/100)","v":135},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(D24*E24)-D24*E24*F24/100","v":135},{"$f":"ROUND(((D24*E24)-(D24*E24*F24/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"ROUND(((D25*E25)-(D25*E25*F25/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"ROUND(((D26*E26)-(D26*E26*F26/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"ROUND(((D30*E30)-(D30*E30*F30/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"ROUND(((D31*E31)-(D31*E31*F31/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"ROUND(((D32*E32)-(D32*E32*F32/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"ROUND(((D33*E33)-(D33*E33*F33/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"D34*E34-(D34*E34*F34/100)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"ROUND(((D34*E34)-(D34*E34*F34/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"D35*E35-(D35*E35*F35/100)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"ROUND(((D35*E35)-(D35*E35*F35/100))*#REF!/100,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,"Sveukupno:",null,{"$f":"SUM(G23:G35)","v":135}]
[null,{"$f":"CONCATENATE(\"Slovima: \",ConvertCurrencyToEnglish(G36))","v":"Slovima: jedna stotina trideset pet kuna i nula lipa"}]
[null,"Način plaćanja: Transakcijski račun",null,null,null,null,"PDV nije obračunat jer prodavatelj nije u sustavu PDV-a"]
[null,"IBAN: HRxx2484008xxxxxxx"]
[null,"           RAIFFEISENBANK d.d. ZAGREB"]
[]
[]
[]
[null,null,null,null,null,"Dokument izradio: ","Marino Bobetić"]
[null,{"$f":"CONCATENATE(\"Poziv na broj: \",E14,\"-1-1\")","v":"Poziv na broj: 3-1-1"},null,null,1]
[]
[]
[null,null,null,"M.P.","_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _"]
[null,null,null,null,"Potpis"]
[]
[]
[]
["Trgovački sud u Varaždinu MBS-xxx"]

{"sheet":"Artikli","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["ŠIFRARNIK ARTIKALA"]
[]
[]
["ŠIFRA","NAZIV","J.MJ.","CIJENA"]
[0]
["O1","Opisna stavka 2. red","KG",2.8]
["O2","NAPOMENA: Ovdje se upisuje napomena","KG",2]
["O3",null,"KOM",100]
["O4",null,"paušal",100]
[1,"Podešavanje Operativnog sustava","paušal",200]
[2,"Instalacija Internet bankarstva","paušal",150]
[3,"Podešenje e-mail adrese"]
[4]
[5]
[6]
[0]

{"sheet":"Arhiva","index":2,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,1,36,6],[51,0,51,6],[52,0,52,6],[53,0,53,6]]}
[null,"Enter j.d.o.o."]
[null,"Donji Pustakovec 10"]
[null,"40323 Prelog",null,null,"GSM:","091/520-5575"]
[null,"OIB: 96829189533"]
[]
[]
[]
[]
[null,"KUPAC:",1,null,null,"Donji Pustakovec,","2020-04-23"]
[]
[null,"POLJOPRIVRENDNA ZADRUGA \"Gljiva\""]
[null,"ZAGREBAČKA 22"]
[null,"40 000 ČAKOVEC"]
[null,"040/123-456",null,"RAČUN BR:",2,"/1/1"]
[null,"OIB: 15921865451"]
[null,null,null,null,null,"Datum isporuke:","2020-04-23"]
[]
[null,null,null,null,null,"Datum valute:","2020-05-23"]
[]
[null,null,null,null,null,"Vrijeme izdavanja:",43944.986102546296]
[]
["R. br.","Isporučeno dobro ili \nobavljena usluga","Jed. mjere","Količina","Jed. cijena","Rabat\n%","Ukupno"]
[null,null,null,null,null,null,0]
[null,"Obrazac u excelu","kom",1,150,10,135]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,"Sveukupno:",null,135]
[null,"Slovima: jedna stotina trideset pet kuna i nula lipa"]
[null,"Način plaćanja: Transakcijski račun",null,null,null,null,"PDV nije obračunat jer prodavatelj nije u sustavu PDV-a"]
[null,"IBAN: HRxx2484008xxxxxxx"]
[null,"           RAIFFEISENBANK d.d. ZAGREB"]
[]
[]
[]
[null,null,null,null,null,"Dokument izradio: ","Marino Bobetić"]
[null,"Poziv na broj: 2-1-1",null,null,1]
[]
[]
[null,null,null,"M.P.","_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _"]
[null,null,null,null,"Potpis"]
[]
[]
[]
["Trgovački sud u Varaždinu MBS-xxx"]

{"sheet":"poslovni partneri","index":3,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Šifra","NAZIV","ADRESA","ADRESA2","TEL","OIB"]
[1,"POLJOPRIVRENDNA ZADRUGA \"Gljiva\"","ZAGREBAČKA 22","40 000 ČAKOVEC","040/123-456","OIB: 15921865451"]
[2,"ENTER j.d.o.o.","Donji Pustakovec 10","40323 Prelog","040/628-094","OIB: 96829189533"]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[{"$f":"A11+1","v":11}]
[{"$f":"A12+1","v":12}]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]