{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Armatuurlaud","Kulude logi","Isiklike kulude andmed"],"not_rendered":{"charts":1,"defined_names":5,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Armatuurlaud","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[0,1,0,4],[1,1,1,5],[2,1,2,2],[2,3,2,4]]}
[null,"isiklike kulude armatuurlaud",{"$nulls":3},"kuva kulude logi >"]
[null,"Selles lahtris on PivotChart-liigenddiagramm, kus kategooria lõikes kuvatavad kulud on toodud kuu kaupa. Allpool lahtrites B3, D3 ja F3 on toodud tükeldid kulude filtreerimiseks kuupäeva, kategooriate ja alamkategooriate järgi."]
[null,"Selles lahtris asuva tükeldi abil saate filtreerida tabeli andmeid kuupäeva alusel.",null,"Selles lahtris asuva tükeldi abil saate filtreerida tabeli andmeid kategooria alusel.",null,"Selles lahtris asuva tükeldi abil saate filtreerida tabeli andmeid alamkategooria alusel."]

{"sheet":"Kulude logi","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,4]]}
[null,"kulude logi",{"$nulls":3},"< kuva armatuurlaud"]
[null,"kuupäev","kategooria","alamkategooria","summa","märkus"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2018-03-02"},"Eluase","Internet",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2018-03-02"},"Eluase","Lauatelefon",{"v":39,"d":"39.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2018-03-04"},"Eluase","Elekter",{"v":62,"d":"62.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2018-03-04"},"Meelelahutus","Jõusaal",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2018-03-06"},"Olme","Riided",{"v":42,"d":"42.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2018-03-06"},"Transport","Ühistransport",{"v":21,"d":"21.00 €"},"märtsi kuukaart"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2018-04-02"},"Transport","Kütus",{"v":54,"d":"54.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2018-04-02"},"Olme","Juuksur",{"v":12,"d":"12.00 €"}]
[null,"2018-04-02","Olme","Tee/kohv",{"v":12,"d":"12.00 €"}]
[null,"2018-04-02","Olme","Maiustused",{"v":2.75,"d":"2.75 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2018-04-04"},"Eluase","Internet",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2018-04-04"},"Eluase","Lauatelefon",{"v":39,"d":"39.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2018-04-04"},"Eluase","Elekter",{"v":62,"d":"62.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2018-04-04"},"Olme","Kontaktläätsed",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2018-04-06"},"Olme","Riided",{"v":42,"d":"42.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2018-04-06"},"Transport","Ühistransport",{"v":21,"d":"21.00 €"},"aprilli kuukaart"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2018-05-01"},"Transport","Kütus",{"v":54,"d":"54.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Olme","Juuksur",{"v":12,"d":"12.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2018-07-01"},"Meelelahutus","Kino",{"v":21,"d":"21.00 €"},"vanade filmide õhtu"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2018-08-01"},"Olme","Maiustused",{"v":2.75,"d":"2.75 €"}]

{"sheet":"Isiklike kulude andmed","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"isiklike kulude andmed"]
[null,"Allolev PivotTable-liigendtabel on andmeallikaks armatuurlaual olevale isiklike kulude PivotChart-liigenddiagrammile. Kui muudate midagi, siis võivad need põhjustada PivotChart-liigenddiagrammis visuaalseid muudatusi või tõrkeid."]
[null,"Reasildid","Summa kogusummast summa"]
[null,"märts",222]
[null,"Meelelahutus",29]
[null,"Transport",21]
[null,"Olme",42]
[null,"Eluase",130]
[null,"apr",302.75]
[null,"Transport",75]
[null,"Olme",97.75]
[null,"Eluase",130]
[null,"mai",54]
[null,"Transport",54]
[null,"juuni",12]
[null,"Olme",12]
[null,"juuli",21]
[null,"Meelelahutus",21]
[null,"aug",2.75]
[null,"Olme",2.75]
[null,"Üldkokkuvõte",614.5]