{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["12 kuukauden kassavirta","Kassavirran yhteenveto"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":12,"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":"12 kuukauden kassavirta","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[11,0,11,15],[7,0,7,15],[17,0,17,15],[33,0,33,15]]}
[]
["Kahdentoista kuukauden kassavirta",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tilikausi alkaa:","2013-07-01"]
["Yrityksen nimi"]
["Osoite, paikkakunta, postinumero"]
["Puhelinnumero, sähköpostiosite, www-osoite"]
[]
[null,"Aloitus",{"$f":"FiscalYear","v":"2013-07-01"},{"$f":"DATE(YEAR(C7),MONTH(C7)+1,1)","v":"2013-08-01"},{"$f":"DATE(YEAR(D7),MONTH(D7)+1,1)","v":"2013-09-01"},"2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","Kuukauden\nkeskiarvo","Yleiskatsaus"]
["Varojen yhteenveto"]
["Käteinen\n(kuukauden alussa)",55000,{"$f":"IF(Receipts[[#Totals],[Column3]]+PaidOut[[#Totals],[Column3]]=0,\"\",B11)","v":67593},{"$f":"IF(Receipts[[#Totals],[Column4]]+PaidOut[[#Totals],[Column4]]=0,\"\",C11)","v":54265},{"$f":"IF(Receipts[[#Totals],[Column5]]+PaidOut[[#Totals],[Column5]]=0,\"\",D11)","v":55739},{"$f":"IF(Receipts[[#Totals],[Column6]]+PaidOut[[#Totals],[Column6]]=0,\"\",E11)","v":69290},{"$f":"IF(Receipts[[#Totals],[Column7]]+PaidOut[[#Totals],[Column7]]=0,\"\",F11)","v":65618},{"$f":"IF(Receipts[[#Totals],[Column8]]+PaidOut[[#Totals],[Column8]]=0,\"\",G11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column9]]+PaidOut[[#Totals],[Column9]]=0,\"\",H11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column10]]+PaidOut[[#Totals],[Column10]]=0,\"\",I11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column11]]+PaidOut[[#Totals],[Column11]]=0,\"\",J11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column12]]+PaidOut[[#Totals],[Column12]]=0,\"\",K11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column13]]+PaidOut[[#Totals],[Column13]]=0,\"\",L11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column14]]+PaidOut[[#Totals],[Column14]]=0,\"\",M11)","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":62501}]
["Käyttövarat\n(käteisvarat + tulot, ennen kassamenoja)",{"$f":"SUM(B9,Receipts[[#Totals],[Column2]])","v":67593},{"$f":"IF(C9=\"\",\"\",SUM(C9,Receipts[[#Totals],[Column3]]))","v":76065},{"$f":"IF(D9=\"\",\"\",SUM(D9,Receipts[[#Totals],[Column4]]))","v":83301},{"$f":"IF(E9=\"\",\"\",SUM(E9,Receipts[[#Totals],[Column5]]))","v":91032},{"$f":"IF(F9=\"\",\"\",SUM(F9,Receipts[[#Totals],[Column6]]))","v":89662},{"$f":"IF(G9=\"\",\"\",SUM(G9,Receipts[[#Totals],[Column7]]))","v":76200},{"$f":"IF(H9=\"\",\"\",SUM(H9,Receipts[[#Totals],[Column8]]))","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I9,Receipts[[#Totals],[Column9]]))","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J9,Receipts[[#Totals],[Column10]]))","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K9,Receipts[[#Totals],[Column11]]))","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L9,Receipts[[#Totals],[Column12]]))","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M9,Receipts[[#Totals],[Column13]]))","v":""},{"$f":"IF(N9=\"\",\"\",SUM(N9,Receipts[[#Totals],[Column14]]))","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":83252}]
["Maksuvalmius \n(kuun lopussa)",{"$f":"(B10-PaidOut[[#Totals],[Column2]])","v":67593},{"$f":"IFERROR(C10-PaidOut[[#Totals],[Column3]],\"\")","v":54265},{"$f":"IFERROR(D10-PaidOut[[#Totals],[Column4]],\"\")","v":55739},{"$f":"IFERROR(E10-PaidOut[[#Totals],[Column5]],\"\")","v":69290},{"$f":"IFERROR(F10-PaidOut[[#Totals],[Column6]],\"\")","v":65618},{"$f":"IFERROR(G10-PaidOut[[#Totals],[Column7]],\"\")","v":51413},{"$f":"IFERROR(H10-PaidOut[[#Totals],[Column8]],\"\")","v":""},{"$f":"IFERROR(I10-PaidOut[[#Totals],[Column9]],\"\")","v":""},{"$f":"IFERROR(J10-PaidOut[[#Totals],[Column10]],\"\")","v":""},{"$f":"IFERROR(K10-PaidOut[[#Totals],[Column11]],\"\")","v":""},{"$f":"IFERROR(L10-PaidOut[[#Totals],[Column12]],\"\")","v":""},{"$f":"IFERROR(M10-PaidOut[[#Totals],[Column13]],\"\")","v":""},{"$f":"IFERROR(N10-PaidOut[[#Totals],[Column14]],\"\")","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":59265}]
[]
["Kassatulot"]
["Käteismyynti",5616,3889,24411,31642,14647,3034,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":15524.6}]
["Kassaperittävät",4498,3493,1987,1029,2911,4234,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":2730.8}]
["Laina / muu käteinen",2479,1090,2638,2622,2814,3314,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":2495.6}]
["Kassatulot yhteensä",{"$f":"SUBTOTAL(109,Receipts[Column2])","v":12593},{"$f":"SUBTOTAL(109,Receipts[Column3])","v":8472},{"$f":"SUBTOTAL(109,Receipts[Column4])","v":29036},{"$f":"SUBTOTAL(109,Receipts[Column5])","v":35293},{"$f":"SUBTOTAL(109,Receipts[Column6])","v":20372},{"$f":"SUBTOTAL(109,Receipts[Column7])","v":10582},{"$f":"SUBTOTAL(109,Receipts[Column8])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column9])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column10])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column11])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column12])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column13])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column14])","v":0},{"$f":"IFERROR(AVERAGE(Receipts[[#Totals],[Column3]:[Column14]]),\"\")","v":8646.25}]
[]
["Kassamenot"]
["Ostot (määritä)",null,521,323,274,451,104,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":334.6}]
["Bruttopalkat (tarkka nosto)",null,10572,14514,10561,13170,12478,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":12259}]
["Tarvikkeet (toimisto ja toiminta)",null,250,428,165,1168,345,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":471.2}]
["Korjaukset ja huollot",null,0,2200,163,67,0,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":486}]
["Markkinointi",null,1100,625,1356,0,2560,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":1128.2}]
["Vuokra",null,3500,3500,3500,3500,3500,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":3500}]
["Tarvikkeet",null,285,318,151,134,228,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":223.2}]
["Muut (määritä)",null,123,234,123,234,123,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":167.4}]
["Lainan lyhennys",null,4000,4000,4000,4000,4000,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":4000}]
["Pääoman osto (määritä)",null,679,700,679,650,679,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":677.4}]
["Muut käynnistyskustannukset",null,400,350,400,300,400,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":370}]
["Rahastot ja/tai talletukset",null,300,300,300,300,300,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":300}]
["Omistajien nostot",null,70,70,70,70,70,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":70}]
["Kassamenot yhteensä",null,{"$f":"SUBTOTAL(109,PaidOut[Column3])","v":21800},{"$f":"SUBTOTAL(109,PaidOut[Column4])","v":27562},{"$f":"SUBTOTAL(109,PaidOut[Column5])","v":21742},{"$f":"SUBTOTAL(109,PaidOut[Column6])","v":24044},{"$f":"SUBTOTAL(109,PaidOut[Column7])","v":24787},{"$f":"SUBTOTAL(109,PaidOut[Column8])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column9])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column10])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column11])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column12])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column13])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column14])","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#Totals],[Column3]:[Column14]]),\"\")","v":9994.5833333333339}]
[]
["Olennaiset toimintatiedot (kassavirtaan liittymättömät tiedot)"]
["Liikevaihto (euroa)",2000,2500,2257,2387,2664,2324,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":2355.3333333333335}]
["Myyntisaamiset",1500,500,886,1035,1775,839,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":1089.1666666666667}]
["Luottotappio (kuukauden lopussa)",300,200,225,269,448,359,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":300.16666666666669}]
["Varastoarvo (kuukauden lopussa)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["Ostovelat (kuukauden lopussa)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["Poistot",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]

{"sheet":"Kassavirran yhteenveto","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Arvopisteet:",5]
[null,null,"(Muuta kaavion kokonaistietopisteitä yllä olevaa liukusäädintä vetämällä.)"]