{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Denarni tok","Grafikon denarnega toka"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Denarni tok","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Projekcija denarnega toka za majhno podjetje"]
[null,"Ime podjetja"]
[null,"Datum začetka",{"$f":"TODAY()","v":"2019-04-25"}]
[null,"Opozorilo za najnižje stanje denarnih sredstev",null,{"$f":"Denar_minimalno","v":0},{"$f":"Denar_minimalno","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Začetek","jan 18","feb 18","mar 18","apr 18","maj 2018","jun 18","jul 18","avg 18","sep 18","okt 18","nov 18","dec 18","Vsota"]
[null,"Denar v blagajni (začetek meseca)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"GOTOVINSKI PREJEMKI"," ","jan 18","feb 18","mar 18","apr 18","maj 2018","jun 18","jul 18","avg 18","sep 18","okt 18","nov 18","de 18","Vsota"]
[null,"Gotovinska prodaja",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Vračila in nadomestila",{"$nulls":13},0]
[null,"Poravnava terjatev",{"$nulls":13},0]
[null,"Obresti, drugi prihodki",{"$nulls":13},0]
[null,"Iztržek od posojil",{"$nulls":13},0]
[null,"Prispevki lastnika",{"$nulls":13},0]
[null,"Vsota GOTOVINSKI PREJEMKI",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,GotovinskoPlačilo[Vsota])","v":0}]
[null,"Skupna razpoložljiva denarna sredstva",{"$f":"(C7+GotovinskoPlačilo[[#Totals],[ ]])","v":0},{"$f":"(D7+GotovinskoPlačilo[[#Totals],[jan 18]])","v":0},{"$f":"(E7+GotovinskoPlačilo[[#Totals],[feb 18]])","v":0},{"$f":"(F7+GotovinskoPlačilo[[#Totals],[mar 18]])","v":0},{"$f":"(G7+GotovinskoPlačilo[[#Totals],[apr 18]])","v":0},{"$f":"(H7+GotovinskoPlačilo[[#Totals],[maj 2018]])","v":0},{"$f":"(I7+GotovinskoPlačilo[[#Totals],[jun 18]])","v":0},{"$f":"(J7+GotovinskoPlačilo[[#Totals],[jul 18]])","v":0},{"$f":"(K7+GotovinskoPlačilo[[#Totals],[avg 18]])","v":0},{"$f":"(L7+GotovinskoPlačilo[[#Totals],[sep 18]])","v":0},{"$f":"(M7+GotovinskoPlačilo[[#Totals],[okt 18]])","v":0},{"$f":"(N7+GotovinskoPlačilo[[#Totals],[nov 18]])","v":0},{"$f":"(O7+GotovinskoPlačilo[[#Totals],[de 18]])","v":0}]
[]
[null,"GOTOVINSKI IZDATKI"," ","jan 18","feb 18","mar 18","apr 18","maj 2018","jun 18","jul 18","avg 18","sep 18","okt 18","nov 18","de 18","Vsota"]
[null,"Oglaševanje",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Provizije in pristojbine",{"$nulls":13},0]
[null,"Pogodbeno delo",{"$nulls":13},0]
[null,"Programi ugodnosti za zaposlene",{"$nulls":13},0]
[null,"Zavarovanje (razen zdravstvenega)",{"$nulls":13},0]
[null,"Obrestni odhodki",{"$nulls":13},0]
[null,"Materiali in zaloge (v okviru stroškov prodanega blaga)",{"$nulls":13},0]
[null,"Hrana in zabava",{"$nulls":13},0]
[null,"Hipotekarne obresti",{"$nulls":13},0]
[null,"Pisarniški stroški",{"$nulls":13},0]
[null,"Drugi obrestni odhodki",{"$nulls":13},0]
[null,"Pokojninski načrt in načrt delitve dobička",{"$nulls":13},0]
[null,"Nabava za nadaljnjo prodajo",{"$nulls":13},0]
[null,"Najem ali zakup",{"$nulls":13},0]
[null,"Najem ali zakup: vozila, oprema",{"$nulls":13},0]
[null,"Popravila in vzdrževanje",{"$nulls":13},0]
[null,"Zaloge (ne v okviru stroškov prodanega blaga)",{"$nulls":13},0]
[null,"Davki in licence",{"$nulls":13},0]
[null,"Potovanje",{"$nulls":13},0]
[null,"Potrebščine",{"$nulls":13},0]
[null,"Plače (olajšave za zaposlovanje)",{"$nulls":13},0]
[null,"Drugih stroški",{"$nulls":13},0]
[null,"Drugih stroški",{"$nulls":13},0]
[null,"Drugih stroški",{"$nulls":13},0]
[null,"Razno",{"$nulls":13},0]
[null,"DELNA VSOTA",null,{"$f":"SUBTOTAL(109,Stroški[jan 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[feb 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[mar 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[apr 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[maj 2018])","v":0},{"$f":"SUBTOTAL(109,Stroški[jun 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[jul 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[avg 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[sep 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[okt 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[nov 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[de 18])","v":0},{"$f":"SUBTOTAL(109,Stroški[Vsota])","v":0}]
[null,"GOTOVINSKI IZDATKI"," ","jan 18","feb 18","mar 18","apr 18","maj 2018","jun 18","jul 18","avg 18","sep 18","okt 18","nov 18","de 18","Vsota"]
[null,"Plačilo glavnice posojila",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Naložbe v kapital",{"$nulls":13},0]
[null,"Drugi zagonski stroški",{"$nulls":13},0]
[null,"Račun rezerv in/ali depozitni račun",{"$nulls":13},0]
[null,"Dvig gotovine lastnikov",{"$nulls":13},0]
[null,"SKUPAJ GOTOVINSKI IZDATKI",null,{"$f":"Stroški[[#Totals],[jan 18]]+SUBTOTAL(109,GotovinskiIzdatki[jan 18])","v":0},{"$f":"Stroški[[#Totals],[feb 18]]+SUBTOTAL(109,GotovinskiIzdatki[feb 18])","v":0},{"$f":"Stroški[[#Totals],[mar 18]]+SUBTOTAL(109,GotovinskiIzdatki[mar 18])","v":0},{"$f":"Stroški[[#Totals],[apr 18]]+SUBTOTAL(109,GotovinskiIzdatki[apr 18])","v":0},{"$f":"Stroški[[#Totals],[maj 2018]]+SUBTOTAL(109,GotovinskiIzdatki[maj 2018])","v":0},{"$f":"Stroški[[#Totals],[jun 18]]+SUBTOTAL(109,GotovinskiIzdatki[jun 18])","v":0},{"$f":"Stroški[[#Totals],[jul 18]]+SUBTOTAL(109,GotovinskiIzdatki[jul 18])","v":0},{"$f":"Stroški[[#Totals],[avg 18]]+SUBTOTAL(109,GotovinskiIzdatki[avg 18])","v":0},{"$f":"Stroški[[#Totals],[sep 18]]+SUBTOTAL(109,GotovinskiIzdatki[sep 18])","v":0},{"$f":"Stroški[[#Totals],[okt 18]]+SUBTOTAL(109,GotovinskiIzdatki[okt 18])","v":0},{"$f":"Stroški[[#Totals],[nov 18]]+SUBTOTAL(109,GotovinskiIzdatki[nov 18])","v":0},{"$f":"Stroški[[#Totals],[de 18]]+SUBTOTAL(109,GotovinskiIzdatki[de 18])","v":0},0]
[null,"Denar v blagajni (konec meseca)",{"$f":"C17","v":0},{"$f":"D17-GotovinskiIzdatki[[#Totals],[jan 18]]","v":0},{"$f":"E17-GotovinskiIzdatki[[#Totals],[feb 18]]","v":0},{"$f":"F17-GotovinskiIzdatki[[#Totals],[mar 18]]","v":0},{"$f":"G17-GotovinskiIzdatki[[#Totals],[apr 18]]","v":0},{"$f":"H17-GotovinskiIzdatki[[#Totals],[maj 2018]]","v":0},{"$f":"I17-GotovinskiIzdatki[[#Totals],[jun 18]]","v":0},{"$f":"J17-GotovinskiIzdatki[[#Totals],[jul 18]]","v":0},{"$f":"K17-GotovinskiIzdatki[[#Totals],[avg 18]]","v":0},{"$f":"L17-GotovinskiIzdatki[[#Totals],[sep 18]]","v":0},{"$f":"M17-GotovinskiIzdatki[[#Totals],[okt 18]]","v":0},{"$f":"N17-GotovinskiIzdatki[[#Totals],[nov 18]]","v":0},{"$f":"O17-GotovinskiIzdatki[[#Totals],[de 18]]","v":0}]
[]
[null,"DRUGI OPERATIVNI PODATKI"," ","jan 18","feb 18","mar 18","apr 18","maj 2018","jun 18","jul 18","avg 18","sep 18","okt 18","nov 18","de 18","Vsota"]
[null,"Obseg prodaje (evri)",{"$nulls":13},{"$f":"SUM(DrugiOperativniPodatki[[#This Row],[jan 18]:[de 18]])","v":0}]
[null,"Stanje terjatev",{"$nulls":13},{"$f":"SUM(DrugiOperativniPodatki[[#This Row],[jan 18]:[de 18]])","v":0}]
[null,"Stanje slabega posojila",{"$nulls":13},{"$f":"SUM(DrugiOperativniPodatki[[#This Row],[jan 18]:[de 18]])","v":0}]
[null,"Takoj dobavljive zaloge",{"$nulls":13},{"$f":"SUM(DrugiOperativniPodatki[[#This Row],[jan 18]:[de 18]])","v":0}]
[null,"Stanje obveznosti",{"$nulls":13},{"$f":"SUM(DrugiOperativniPodatki[[#This Row],[jan 18]:[de 18]])","v":0}]
[null,"Amortizacija",{"$nulls":13},{"$f":"SUM(DrugiOperativniPodatki[[#This Row],[jan 18]:[de 18]])","v":0}]

{"sheet":"Grafikon denarnega toka","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"V tej celici sta kombinacijski grafikon, ki prikazuje opozorilo za najnižje stanje denarnih sredstev, in projekcija denarnega toka."]
{"$rows_empty":34}
[null,"Opozorilo za najnižje stanje denarnih sredstev",null,{"$f":"[0]!Denar_minimalno","v":{"v":0,"d":"0 €"}}]