{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Rahavoog","Rahavoogude diagramm"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Rahavoog","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Väikeettevõtte rahavoo prognoos"]
[null,"Ettevõtte nimi"]
[null,"Alguskuupäev",{"$f":"TODAY()","v":"2019-04-25"}]
[null,"Kassasaldo hoiatuse miinimum",null,{"$f":"Raha_miinimum","v":0},{"$f":"Raha_miinimum","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Algus"," jaanuar 18"," veebruar 18"," märts 18"," aprill 18"," mai 18"," juuni 18"," juuli 18"," august 18"," september 18"," oktoober 18"," november 18"," detsember 18","Kokku"]
[null,"Kassas olev sularaha (kuu alguses)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"LAEKUMISED"," "," jaanuar 18"," veebruar 18"," märts 18"," aprill 18"," mai 18"," juuni 18"," juuli 18"," august 18"," september 18"," oktoober 18"," november 18"," detsember 18","Kokku"]
[null,"Sularahamüük",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Tagastused ja hüvitised",{"$nulls":13},0]
[null,"Müügireskontro sissenõuded",{"$nulls":13},0]
[null,"Intress, muu sissetulek",{"$nulls":13},0]
[null,"Laenusumma",{"$nulls":13},0]
[null,"Omanike panused",{"$nulls":13},0]
[null,"LAEKUMISED KOKKU",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,Laekumised[Kokku])","v":0}]
[null,"Kogu vaba raha",{"$f":"(C7+Laekumised[[#Totals],[ ]])","v":0},{"$f":"(D7+Laekumised[[#Totals],[ jaanuar 18]])","v":0},{"$f":"(E7+Laekumised[[#Totals],[ veebruar 18]])","v":0},{"$f":"(F7+Laekumised[[#Totals],[ märts 18]])","v":0},{"$f":"(G7+Laekumised[[#Totals],[ aprill 18]])","v":0},{"$f":"(H7+Laekumised[[#Totals],[ mai 18]])","v":0},{"$f":"(I7+Laekumised[[#Totals],[ juuni 18]])","v":0},{"$f":"(J7+Laekumised[[#Totals],[ juuli 18]])","v":0},{"$f":"(K7+Laekumised[[#Totals],[ august 18]])","v":0},{"$f":"(L7+Laekumised[[#Totals],[ september 18]])","v":0},{"$f":"(M7+Laekumised[[#Totals],[ oktoober 18]])","v":0},{"$f":"(N7+Laekumised[[#Totals],[ november 18]])","v":0},{"$f":"(O7+Laekumised[[#Totals],[ detsember 18]])","v":0}]
[]
[null,"SULARAHA VÄLJAMAKSED"," "," jaanuar 18"," veebruar 18"," märts 18"," aprill 18"," mai 18"," juuni 18"," juuli 18"," august 18"," september 18"," oktoober 18"," november 18"," detsember 18","Kokku"]
[null,"Reklaam",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Vahendustasud ja tasud",{"$nulls":13},0]
[null,"Tööleping",{"$nulls":13},0]
[null,"Töötajate soodusprogrammid",{"$nulls":13},0]
[null,"Kindlustus (mitte tervisekindlustus)",{"$nulls":13},0]
[null,"Intressikulu",{"$nulls":13},0]
[null,"Materjalid ja tarbed (COGS-is)",{"$nulls":13},0]
[null,"Toitlustus ja meelelahutus",{"$nulls":13},0]
[null,"Eluasemelaenu intress",{"$nulls":13},0]
[null,"Kontorikulud",{"$nulls":13},0]
[null,"Muu intressikulu",{"$nulls":13},0]
[null,"Pension ja kasumiosaluse kava",{"$nulls":13},0]
[null,"Ostud edasimüügiks",{"$nulls":13},0]
[null,"Rent või üür",{"$nulls":13},0]
[null,"Rent või üür: sõidukid, seadmed",{"$nulls":13},0]
[null,"Remont ja hooldus",{"$nulls":13},0]
[null,"Tarvikute (ei sisaldu GOGS-is)",{"$nulls":13},0]
[null,"Maksud ja litsentsid",{"$nulls":13},0]
[null,"Reisimine",{"$nulls":13},0]
[null,"Kommunaalkulud",{"$nulls":13},0]
[null,"Palgad (vähem tööhõivekrediiti)",{"$nulls":13},0]
[null,"Muud kulud",{"$nulls":13},0]
[null,"Muud kulud",{"$nulls":13},0]
[null,"Muud kulud",{"$nulls":13},0]
[null,"Mitmesugust",{"$nulls":13},0]
[null,"VAHESUMMA",null,{"$f":"SUBTOTAL(109,Väljaminekud[[ jaanuar 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ veebruar 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ märts 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ aprill 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ mai 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ juuni 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ juuli 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ august 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ september 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ oktoober 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ november 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[[ detsember 18]])","v":0},{"$f":"SUBTOTAL(109,Väljaminekud[Kokku])","v":0}]
[null,"SULARAHA VÄLJAMAKSED"," "," jaanuar 18"," veebruar 18"," märts 18"," aprill 18"," mai 18"," juuni 18"," juuli 18"," august 18"," september 18"," oktoober 18"," november 18"," detsember 18","Kokku"]
[null,"Laenu põhiosa makse",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Kapitalikaupade ostud",{"$nulls":13},0]
[null,"Muud alustuskulud",{"$nulls":13},0]
[null,"Reserv ja/või deposiit",{"$nulls":13},0]
[null,"Omanike väljamakse",{"$nulls":13},0]
[null,"SULARAHA VÄLJAMAKSED KOKKU",null,{"$f":"Väljaminekud[[#Totals],[ jaanuar 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ jaanuar 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ veebruar 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ veebruar 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ märts 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ märts 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ aprill 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ aprill 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ mai 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ mai 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ juuni 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ juuni 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ juuli 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ juuli 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ august 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ august 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ september 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ september 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ oktoober 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ oktoober 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ november 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ november 18]])","v":0},{"$f":"Väljaminekud[[#Totals],[ detsember 18]]+SUBTOTAL(109,SularahaVäljamaksed[[ detsember 18]])","v":0},0]
[null,"Kassas olev sularaha (kuu lõpus)",{"$f":"C17","v":0},{"$f":"D17-SularahaVäljamaksed[[#Totals],[ jaanuar 18]]","v":0},{"$f":"E17-SularahaVäljamaksed[[#Totals],[ veebruar 18]]","v":0},{"$f":"F17-SularahaVäljamaksed[[#Totals],[ märts 18]]","v":0},{"$f":"G17-SularahaVäljamaksed[[#Totals],[ aprill 18]]","v":0},{"$f":"H17-SularahaVäljamaksed[[#Totals],[ mai 18]]","v":0},{"$f":"I17-SularahaVäljamaksed[[#Totals],[ juuni 18]]","v":0},{"$f":"J17-SularahaVäljamaksed[[#Totals],[ juuli 18]]","v":0},{"$f":"K17-SularahaVäljamaksed[[#Totals],[ august 18]]","v":0},{"$f":"L17-SularahaVäljamaksed[[#Totals],[ september 18]]","v":0},{"$f":"M17-SularahaVäljamaksed[[#Totals],[ oktoober 18]]","v":0},{"$f":"N17-SularahaVäljamaksed[[#Totals],[ november 18]]","v":0},{"$f":"O17-SularahaVäljamaksed[[#Totals],[ detsember 18]]","v":0}]
[]
[null,"MUUD TEGEVUSEGA SEOTUD ANDMED"," "," jaanuar 18"," veebruar 18"," märts 18"," aprill 18"," mai 18"," juuni 18"," juuli 18"," august 18"," september 18"," oktoober 18"," november 18"," detsember 18","Kokku"]
[null,"Müügimaht (eurodes)",{"$nulls":13},{"$f":"SUM(MuudTegevusegaSeotudAndmed[[#This Row],[ jaanuar 18]:[ detsember 18]])","v":0}]
[null,"Müügireskontro saldo",{"$nulls":13},{"$f":"SUM(MuudTegevusegaSeotudAndmed[[#This Row],[ jaanuar 18]:[ detsember 18]])","v":0}]
[null,"Halva võla saldo",{"$nulls":13},{"$f":"SUM(MuudTegevusegaSeotudAndmed[[#This Row],[ jaanuar 18]:[ detsember 18]])","v":0}]
[null,"Olemasolev laoseis",{"$nulls":13},{"$f":"SUM(MuudTegevusegaSeotudAndmed[[#This Row],[ jaanuar 18]:[ detsember 18]])","v":0}]
[null,"Ostureskontro saldo",{"$nulls":13},{"$f":"SUM(MuudTegevusegaSeotudAndmed[[#This Row],[ jaanuar 18]:[ detsember 18]])","v":0}]
[null,"Kulum",{"$nulls":13},{"$f":"SUM(MuudTegevusegaSeotudAndmed[[#This Row],[ jaanuar 18]:[ detsember 18]])","v":0}]

{"sheet":"Rahavoogude diagramm","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"Liitdiagrammi, kus on kuvatud kassas oleva sularaha hoiatuse miinimum ja selles lahtris on rahavoo prognoos."]
{"$rows_empty":34}
[null,"Kassasaldo hoiatuse miinimum",null,{"$f":"[0]!Raha_miinimum","v":{"v":0,"d":"0 €"}}]