{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Henk.koht. varojen seurantac","Henk.koht. varojen seuranta","Kaaviotiedot"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Henk.koht. varojen seurantac","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[8,3,8,6],[19,1,20,1],[21,1,23,1]]}
[null,"Henkilökohtaisten varojen seuranta"]
[]
[{"$nulls":3},"Varojen yhteenveto"]
[{"$nulls":3},"Tili","Aloitusvarat","Kulut yhteensä","Jäljellä olevat varat"]
[{"$nulls":3},"Sekkitili ",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(CashSpent[Tili],\"=\" &CashSummaryTable[[#This Row],[Tili]],CashSpent[Määrä])","v":{"v":428,"d":"428.00"}},{"$f":"CashSummaryTable[[#This Row],[Aloitusvarat]]-CashSummaryTable[[#This Row],[Kulut yhteensä]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Talletukset ",{"v":500,"d":"500.00"},{"$f":"SUMIF(CashSpent[Tili],\"=\" &CashSummaryTable[[#This Row],[Tili]],CashSpent[Määrä])","v":{"v":450,"d":"450.00"}},{"$f":"CashSummaryTable[[#This Row],[Aloitusvarat]]-CashSummaryTable[[#This Row],[Kulut yhteensä]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Muut ",{"v":200,"d":"200.00"},{"$f":"SUMIF(CashSpent[Tili],\"=\" &CashSummaryTable[[#This Row],[Tili]],CashSpent[Määrä])","v":{"v":30,"d":"30.00"}},{"$f":"CashSummaryTable[[#This Row],[Aloitusvarat]]-CashSummaryTable[[#This Row],[Kulut yhteensä]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3}," Yhteensä ",{"$f":"SUBTOTAL(109,CashSummaryTable[Aloitusvarat])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[Kulut yhteensä])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[Jäljellä olevat varat])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"Käytetty käteinen"]
[{"$nulls":3},"Päivämäärä","Kuvaus","Määrä","Tili"]
[{"$nulls":3},"2012-01-04"," Käteisnosto ",{"v":40,"d":"40.00"},"Sekkitili "]
[{"$nulls":3},"2012-01-05"," Lounas ",{"v":5,"d":"5.00"},"Sekkitili "]
[{"$nulls":3},"2012-01-06"," Automaksu ",{"v":230,"d":"230.00"},"Talletukset "]
[{"$nulls":3},"2012-02-03"," Sähkömaksu ",{"v":70,"d":"70.00"},"Sekkitili "]
[{"$nulls":3},"2012-02-07"," Illallinen ",{"v":53,"d":"53.00"},"Sekkitili "]
[{"$nulls":3},"2012-03-01"," Käteissiirto ",{"v":100,"d":"100.00"},"Talletukset "]
[{"$nulls":3},"2012-03-06"," Automaksu ",{"v":230,"d":"230.00"},"Sekkitili "]
[{"$nulls":3},"2012-04-06"," Sähkömaksu ",{"v":70,"d":"70.00"},"Talletukset "]
[null,"Jäljellä oleva varat:",null,"2012-04-20"," Käteisnosto ",{"v":30,"d":"30.00"},"Sekkitili "]
[{"$nulls":3},"2012-05-03"," Käteisnosto ",{"v":50,"d":"50.00"},"Talletukset "]
[null,{"$f":"CashSummaryTable[[#Totals],[Jäljellä olevat varat]]/CashSummaryTable[[#Totals],[Aloitusvarat]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10"," Käteisnosto ",{"v":30,"d":"30.00"},"Muut "]

{"sheet":"Henk.koht. varojen seuranta","index":1,"n_rows":26,"n_cols":9,"rows_kept":26}
[null,"Kuukausittainen yhteenveto"]
[null,"Tiliyhteenveto"]
{"$rows_empty":13}
[null,"Kulujen yhteenveto"]
[null,"Summa  / Määrä"]
[null,null," Automaksu "," Illallinen "," Käteisnosto "," Käteissiirto "," Lounas "," Sähkömaksu ","Kaikki yhteensä"]
[null,"tammi",230,null,40,null,5,null,275]
[null,"helmi",null,53,{"$nulls":3},70,123]
[null,"maalis"]
[null,"Sekkitili ",230,{"$nulls":5},230]
[null,"Talletukset ",{"$nulls":3},100,null,null,100]
[null,"huhti",null,null,30,null,null,70,100]
[null,"touko",null,null,80,{"$nulls":3},80]
[null,"Kaikki yhteensä",460,53,150,100,5,140,908]

{"sheet":"Kaaviotiedot","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"Pivot-kaavion tiedot"]
[null,"Tämä Pivot-taulukko on Kuukausittainen yhteenveto -taulukon asiakkuusyhteenvedon Pivot-kaavion tietolähde."]
[null,"Summa  / Määrä","Sarakeotsikot"]
[null,"Riviotsikot","Sekkitili ","Talletukset ","Muut ","Kaikki yhteensä"]
[null,"tammi",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"helmi",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"maalis",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"huhti",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"touko",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Kaikki yhteensä",{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]