{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Personaalne rahajälgija","Kuukokkuvõte","Diagrammiandmed"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Personaalne rahajälgija","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,"Personaalne rahajälgija"]
[]
[{"$nulls":3},"Sularaha kokkuvõte"]
[{"$nulls":3},"Konto","Sularaha algsumma","Kogukulu","Järelejäänud sularaha"]
[{"$nulls":3},"Veaotsing",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(KulutatudSularaha[Konto],\"=\" &SularahaKokkuvõtteTabel[[#This Row],[Konto]],KulutatudSularaha[Summa])","v":{"v":428,"d":"428.00"}},{"$f":"SularahaKokkuvõtteTabel[[#This Row],[Sularaha algsumma]]-SularahaKokkuvõtteTabel[[#This Row],[Kogukulu]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Hoiused",{"v":500,"d":"500.00"},{"$f":"SUMIF(KulutatudSularaha[Konto],\"=\" &SularahaKokkuvõtteTabel[[#This Row],[Konto]],KulutatudSularaha[Summa])","v":{"v":450,"d":"450.00"}},{"$f":"SularahaKokkuvõtteTabel[[#This Row],[Sularaha algsumma]]-SularahaKokkuvõtteTabel[[#This Row],[Kogukulu]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Muu",{"v":200,"d":"200.00"},{"$f":"SUMIF(KulutatudSularaha[Konto],\"=\" &SularahaKokkuvõtteTabel[[#This Row],[Konto]],KulutatudSularaha[Summa])","v":{"v":30,"d":"30.00"}},{"$f":"SularahaKokkuvõtteTabel[[#This Row],[Sularaha algsumma]]-SularahaKokkuvõtteTabel[[#This Row],[Kogukulu]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Kokku",{"$f":"SUBTOTAL(109,SularahaKokkuvõtteTabel[Sularaha algsumma])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,SularahaKokkuvõtteTabel[Kogukulu])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,SularahaKokkuvõtteTabel[Järelejäänud sularaha])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"Kulutatud sularaha"]
[{"$nulls":3},"Kuupäev","Kirjeldus","Summa","Konto"]
[{"$nulls":3},"2012-01-04","Pangaautomaadi väljamaksed",{"v":40,"d":"40.00"},"Veaotsing"]
[{"$nulls":3},"2012-01-05","Lõuna",{"v":5,"d":"5.00"},"Veaotsing"]
[{"$nulls":3},"2012-01-06","Automakse",{"v":230,"d":"230.00"},"Hoiused"]
[{"$nulls":3},"2012-02-03","Elektrimakse",{"v":70,"d":"70.00"},"Veaotsing"]
[{"$nulls":3},"2012-02-07","Õhtusöök",{"v":53,"d":"53.00"},"Veaotsing"]
[{"$nulls":3},"2012-03-01","Sularaha väljamaksed",{"v":100,"d":"100.00"},"Hoiused"]
[{"$nulls":3},"2012-03-06","Automakse",{"v":230,"d":"230.00"},"Veaotsing"]
[{"$nulls":3},"2012-04-06","Elektrimakse",{"v":70,"d":"70.00"},"Hoiused"]
[null,"Järelejäänud sularaha:",null,"2012-04-20","Pangaautomaadi väljamaksed",{"v":30,"d":"30.00"},"Veaotsing"]
[{"$nulls":3},"2012-05-03","Pangaautomaadi väljamaksed",{"v":50,"d":"50.00"},"Hoiused"]
[null,{"$f":"SularahaKokkuvõtteTabel[[#Totals],[Järelejäänud sularaha]]/SularahaKokkuvõtteTabel[[#Totals],[Sularaha algsumma]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10","Pangaautomaadi väljamaksed",{"v":30,"d":"30.00"},"Muu"]

{"sheet":"Kuukokkuvõte","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Kuukokkuvõte"]
[null,"Konto kokkuvõte"]
{"$rows_empty":13}
[null,"Kulude kokkuvõte"]
[null,"Išsamiau"]
[null,null,"Hoiused","Muu","Veaotsing","Kogusumma"]
[null,"jaan",{"v":230,"d":"230.00"},null,{"v":45,"d":"45.00"},{"v":275,"d":"275.00"}]
[null,"veebr",null,null,{"v":123,"d":"123.00"},{"v":123,"d":"123.00"}]
[null,"märts",{"v":100,"d":"100.00"},null,{"v":230,"d":"230.00"},{"v":330,"d":"330.00"}]
[null,"Automakse",null,null,{"v":230,"d":"230.00"},{"v":230,"d":"230.00"}]
[null,"Sularaha väljamaksed",{"v":100,"d":"100.00"},null,null,{"v":100,"d":"100.00"}]
[null,"apr",{"v":70,"d":"70.00"},null,{"v":30,"d":"30.00"},{"v":100,"d":"100.00"}]
[null,"mai",{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},null,{"v":80,"d":"80.00"}]
[null,"Kogusumma",{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":428,"d":"428.00"},{"v":908,"d":"908.00"}]

{"sheet":"Diagrammiandmed","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"PivotChart-andmed"]
[null,"See PivotTable-liigendtabel on kuukokkuvõtte lehel oleva konto kokkuvõtte PivotChart-liigenddiagrammi andmete allikas"]
[null,"Sum of Summa","Veerusildid"]
[null,"Reasildid","Hoiused","Muu","Veaotsing","Kogusumma"]
[null,"jaan",{"v":230,"d":"230.00"},null,{"v":45,"d":"45.00"},{"v":275,"d":"275.00"}]
[null,"veebr",null,null,{"v":123,"d":"123.00"},{"v":123,"d":"123.00"}]
[null,"märts",{"v":100,"d":"100.00"},null,{"v":230,"d":"230.00"},{"v":330,"d":"330.00"}]
[null,"apr",{"v":70,"d":"70.00"},null,{"v":30,"d":"30.00"},{"v":100,"d":"100.00"}]
[null,"mai",{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},null,{"v":80,"d":"80.00"}]
[null,"Kogusumma",{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":428,"d":"428.00"},{"v":908,"d":"908.00"}]