{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Algus","Kuueelarve aruanne","Kuuväljaminekud","Lisaandmed"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Algus","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"TEAVE SELLE MALLI KOHTA"]
[null,"Selle töövihiku abil saate jälgida oma väljaminekuid ja koostada pere-eelarve."]
[null,"Sisestage töölehele Kuueelarve aruanne erinevatest allikatest saadav prognoositud ja tegelik sissetulek ning töölehele Kuuväljaminekud erinevates kategooriates kulutatud prognoositud ning tegelikud summad."]
[null,"Prognoositud ja tegelik saldo ning erinevus arvutatakse automaatselt ning töölehel Kuueelarve aruanne värskendatakse diagrammid Eelarve kokkuvõte ja Eelarve ülevaade."]
[null,"Kategooriaid saate muuta või uue kategooria lisada töölehel Lisaandmed andmed."]
[null,"Märkus. "]
[null,"Täiendavad juhised on antud töölehe KUUEELARVE ARUANNE veerus A ning töölehtede KUUVÄLJAMINEKUD ja LISAANDMED lahtris A1. See tekst on tahtlikult peidetud. Teksti eemaldamiseks valige veerg A või lahter A1 ja seejärel käsk KUSTUTA. Teksti kuvamiseks valige veerg A või lahter A1 ja muutke seejärel fondi värvi."]
[null,"Tabelite kohta lisateabe saamiseks vajutage tabelis tõstuklahvi (SHIFT) ja seejärel klahvi F10, valige TABELI suvand ja seejärel käsk ASETEKST. PivotTable-liigendtabelite puhul vajutage tabelis tõstuklahvi (Shift) ja seejärel klahvi F10, valige PIVOTTABLE-LIIGENDTABELI SUVANDID ja seejärel valige vahekaart ASETEKST."]

{"sheet":"Kuueelarve aruanne","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,13],[1,9,5,13],[2,2,2,5],[3,2,3,5],[4,2,4,5],[7,1,10,1],[7,5,10,5],[7,6,10,6],[8,9,31,9],[12,1,16,1],[12,5,16,5],[12,6,16,6],[19,1,34,6]]}
["Sellel töölehel saate luua Kuueelarve aruanne. Selle töölehe pealkiri on parempoolses lahtris ning alapealkiri lahtris J1. Töölehele Kuuväljaminekud liikumiseks valige lahter F1. Muud töölehe kasutamise kohta käivad kasulikud juhised leiate selle veeru lahtritest.","Eelarve ülevaade",{"$nulls":3},"Kuuväljaminekud",{"$nulls":3},"Eelarve kokkuvõte",null,null,"Selles lahtris on roheline nisu vars."]
["Paremal asuvas lahtris kuvatakse saldo silt. PivotTable-liigendtabeli tükeldid tabeliandmete filtreerimise on lahtrivahemikus J2–N6. Mitme kategooria valimiseks hoidke all juhtklahvi (Ctrl).","Saldo",{"$nulls":7},"Selles lahtris on kategooriatükeldi, mille abil saab valitud kategooria alusel filtreerida allolevat PivotTable-liigendtabelit."]
["Paremal asuvas lahtris kuvatakse silt Prognoositud saldo. Prognoositud saldo arvutatakse lahtris G3 automaatselt.","Prognoositud saldo","(Prognoositud miinus kulud)",{"$nulls":3},{"$f":"D17-SUM(Eelarve_üksikasjad[Prognoositavad kulud])","v":{"v":1585,"d":"1,585 €"}}]
["Paremal asuvas lahtris kuvatakse silt tegelik saldo. Tegelik saldo arvutatakse lahtris G4 automaatselt.","Tegelik saldo ","(Tegelik miinus kulud)",{"$nulls":3},{"$f":"D11-SUM(Eelarve_üksikasjad[Tegelik kulu])","v":{"v":1740,"d":"1,740 €"}}]
["Paremal asuvas lahtris kuvatakse silt Erinevus. Erinevus arvutatakse lahtris G5 automaatselt. Järgmine juhis on toodud lahtris A7.","Erinevus","(Tegelik miinus prognoositud)",{"$nulls":3},{"$f":"G4-G3","v":{"v":155,"d":"155 €"}}]
[]
["Paremal asuvas lahtris on silt Sissetulekud, lahtris F7 silt Kulud ja lahtris J7 näpunäide jaotise Eelarve kokkuvõte kohta.","Sissetulekud",{"$nulls":3},"Kulud",{"$nulls":3},"Valige allpool PivotTable-liigendtabel ja seejärel valige menüüs Analüüs värskendamiseks käsk Värskenda."]
["Silt Tegelik sissetulek on parempoolses lahtris ning silt Tegelikud kulud lahtris F8. Sisestage Sissetulek 1 lahtrisse D8. Tegelikud kulud arvutatakse automaatselt lahtris G8.","TEGELIK","Sissetulek 1",{"v":5800,"d":"5,800 €"},null,"TEGELIK",{"$f":"SUM(Eelarve_üksikasjad[Tegelik kulu])","v":{"v":7860,"d":"7,860 €"}}]
["Sisestage Sissetulek 2 lahtrisse D9. Pilt on lahtris J9. PivotTable-liigendtabel algab lahtris K9. PivotTable-liigendtabeli värskendamiseks valige menüüs Analüüs käsk Värskenda.",null,"Sissetulek 2",{"v":2300,"d":"2,300 €"},{"$nulls":5},"Selles lahtris kuvatakse pilt.","Kategooria","Prognoositavad kulud ","Tegelik kulu ","Erinevus "]
["Sisestage lahtrisse D10 Lisasissetulek.",null,"Lisasissetulek",{"v":1500,"d":"1,500 €"},{"$nulls":6},"Lapsed",{"v":140,"d":"140 €"},{"v":140,"d":"140 €"},{"v":0,"d":"0 €"}]
["Lahtris C11 on silt Kogutulu ja kogutulu arvutatakse automaatselt lahtris D11. Järgmised juhised on toodud lahtris A13.",null,"Kogutulu",{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"9,600 €"}}]
[{"$nulls":10},"Meelelahutus",{"v":400,"d":"400 €"},{"v":358,"d":"358 €"},{"v":42,"d":"42 €"}]
["Silt Prognoositavad sissetulekud on parempoolses lahtris ning silt Prognoositavad kulud lahtris F13. Prognoositavad kulud arvutatakse automaatselt lahtris G13.","PROGNOOSITAV",{"$nulls":3},"PROGNOOSITAV",{"$f":"SUM(Eelarve_üksikasjad[Prognoositavad kulud])","v":{"v":7915,"d":"7,915 €"}}]
["Sisestage Prognoositud sissetulek 1 lahtrisse D14.",null,"Sissetulek 1",{"v":6000,"d":"6,000 €"},{"$nulls":6},"Söök",{"v":1100,"d":"1,100 €"},{"v":1320,"d":"1,320 €"},{"v":-220,"d":"-220 €"}]
["Sisestage Prognoositud sissetulek 2 lahtrisse D15.",null,"Sissetulek 2",{"v":1000,"d":"1,000 €"}]
["Sisestage lahtrisse D16 Lisasissetulek.",null,"Lisasissetulek",{"v":2500,"d":"2,500 €"},{"$nulls":6},"Kingitused ja heategevus",{"v":100,"d":"100 €"},{"v":125,"d":"125 €"},{"v":-25,"d":"-25 €"}]
["Lahtris C17 on silt Kogutulu ja kogutulu arvutatakse automaatselt lahtris D17. Järgmine juhis on lahtris A20.",null,"Kogutulu",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"9,500 €"}}]
[{"$nulls":10},"Eluase",{"v":2830,"d":"2,830 €"},{"v":2702,"d":"2,702 €"},{"v":128,"d":"128 €"}]
[]
["Paremal asuvas lahtris on sektordiagramm, kus on kulud protsentuaalselt kategooria järgi kuvatud.","Selles lahtris on sektordiagramm, kus on kulud protsentuaalselt kategooria järgi kuvatud.",{"$nulls":8},"Kindlustus",{"v":900,"d":"900 €"},{"v":900,"d":"900 €"},{"v":0,"d":"0 €"}]
[]
[{"$nulls":10},"Laenud",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"v":0,"d":"0 €"}]
[]
[{"$nulls":10},"Isiklik hooldus",{"v":150,"d":"150 €"},{"v":140,"d":"140 €"},{"v":10,"d":"10 €"}]
[]
[{"$nulls":10},"Lemmikloomad",{"v":170,"d":"170 €"},{"v":100,"d":"100 €"},{"v":70,"d":"70 €"}]
[]
[{"$nulls":10},"Säästud või investeeringud",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"v":0,"d":"0 €"}]
[]
[{"$nulls":10},"Maksud",{"v":300,"d":"300 €"},{"v":300,"d":"300 €"},{"v":0,"d":"0 €"}]
[]
[{"$nulls":10},"Transport",{"v":1425,"d":"1,425 €"},{"v":1375,"d":"1,375 €"},{"v":50,"d":"50 €"}]
[]
[{"$nulls":10},"Üldkokkuvõte",{"v":7915,"d":"7,915 €"},{"v":7860,"d":"7,860 €"},{"v":55,"d":"55 €"}]

{"sheet":"Kuuväljaminekud","index":2,"n_rows":62,"n_cols":7,"rows_kept":62,"merged":[[0,1,0,4],[0,5,0,6]]}
["Sellel töölehel saate arvutada oma kuuväljaminekud. Paremal asuvas lahtris on selle töölehe pealkiri. Töölehele Kuueelarve aruanne liikumiseks valige lahter F1.","Kuuväljaminekud",{"$nulls":3},"Kuueelarve aruanne"]
[" Sisestage teave parempoolsest lahtrist algavasse tabelisse Eelarve üksikasjad.","Kirjeldus","Kategooria","Prognoositavad kulud","Tegelik kulu","Erinevus","Tegeliku kulu ülevaade"]
[null,"Õppekavavälised tegevused","Lapsed",{"v":40,"d":"40 €"},{"v":40,"d":"40 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":40,"d":"40 €"}}]
[null,"Meditsiinitarbed","Lapsed",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Koolitarbed","Lapsed",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Õppemaks","Lapsed",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":100,"d":"100 €"}}]
[null,"Kontserdid","Meelelahutus",{"v":50,"d":"50 €"},{"v":40,"d":"40 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":10,"d":"10 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":40,"d":"40 €"}}]
[null,"Teater","Meelelahutus",{"v":200,"d":"200 €"},{"v":150,"d":"150 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":50,"d":"50 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":150,"d":"150 €"}}]
[null,"Kino","Meelelahutus",{"v":50,"d":"50 €"},{"v":28,"d":"28 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":22,"d":"22 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":28,"d":"28 €"}}]
[null,"Muusika (CD-d, allalaadimised jne)","Meelelahutus",{"v":50,"d":"50 €"},{"v":30,"d":"30 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":20,"d":"20 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":30,"d":"30 €"}}]
[null,"Spordiüritused","Meelelahutus",{"v":0,"d":"0 €"},{"v":40,"d":"40 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-40,"d":"-40 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":40,"d":"40 €"}}]
[null,"Video/DVD (ost)","Meelelahutus",{"v":20,"d":"20 €"},{"v":50,"d":"50 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-30,"d":"-30 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":50,"d":"50 €"}}]
[null,"Video/DVD (laenutus)","Meelelahutus",{"v":30,"d":"30 €"},{"v":20,"d":"20 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":10,"d":"10 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":20,"d":"20 €"}}]
[null,"Väljas söömine","Söök",{"v":1000,"d":"1,000 €"},{"v":1200,"d":"1,200 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-200,"d":"-200 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":1200,"d":"1,200 €"}}]
[null,"Toiduained","Söök",{"v":100,"d":"100 €"},{"v":120,"d":"120 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-20,"d":"-20 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":120,"d":"120 €"}}]
[null,"Heategevus 1","Kingitused ja heategevus",{"v":75,"d":"75 €"},{"v":100,"d":"100 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-25,"d":"-25 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":100,"d":"100 €"}}]
[null,"Heategevus 2","Kingitused ja heategevus",{"v":25,"d":"25 €"},{"v":25,"d":"25 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":25,"d":"25 €"}}]
[null,"Kingitus 1","Kingitused ja heategevus",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Kingitus 2","Kingitused ja heategevus",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Televisioon","Eluase",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":100,"d":"100 €"}}]
[null,"Elekter","Eluase",{"v":45,"d":"45 €"},{"v":50,"d":"50 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-5,"d":"-5 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":50,"d":"50 €"}}]
[null,"Bensiin","Eluase",{"v":300,"d":"300 €"},{"v":400,"d":"400 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-100,"d":"-100 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":400,"d":"400 €"}}]
[null,"Kodukoristusteenused","Eluase",{"v":200,"d":"200 €"},null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":200,"d":"200 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Hooldamine","Eluase",{"v":200,"d":"200 €"},{"v":150,"d":"150 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":50,"d":"50 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":150,"d":"150 €"}}]
[null,"Eluasemelaen või rent","Eluase",{"v":1700,"d":"1,700 €"},{"v":1700,"d":"1,700 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":1700,"d":"1,700 €"}}]
[null,"Maagaas/nafta","Eluase",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Võrgu/Interneti-teenused","Eluase",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":100,"d":"100 €"}}]
[null,"Telefon (mobiilside)","Eluase",{"v":60,"d":"60 €"},{"v":60,"d":"60 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":60,"d":"60 €"}}]
[null,"Telefon (kodu)","Eluase",{"v":35,"d":"35 €"},{"v":39,"d":"39 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-4,"d":"-4 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":39,"d":"39 €"}}]
[null,"Tarbeesemed","Eluase",{"v":40,"d":"40 €"},{"v":55,"d":"55 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-15,"d":"-15 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":55,"d":"55 €"}}]
[null,"Prügivedu ja ringlussevõtt","Eluase",{"v":25,"d":"25 €"},{"v":22,"d":"22 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":3,"d":"3 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":22,"d":"22 €"}}]
[null,"Vesi- ja kanalisatsioon","Eluase",{"v":25,"d":"25 €"},{"v":26,"d":"26 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-1,"d":"-1 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":26,"d":"26 €"}}]
[null,"Tervisekindlustus","Kindlustus",{"v":400,"d":"400 €"},{"v":400,"d":"400 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":400,"d":"400 €"}}]
[null,"Kodukindlustus","Kindlustus",{"v":400,"d":"400 €"},{"v":400,"d":"400 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":400,"d":"400 €"}}]
[null,"Elukindlustus","Kindlustus",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":100,"d":"100 €"}}]
[null,"Krediitkaart 1","Laenud",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":200,"d":"200 €"}}]
[null,"Krediitkaart 2","Laenud",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Krediitkaart 3","Laenud",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Isiklik laen","Laenud",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Õppelaen","Laenud",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Riided","Isiklik hooldus",{"v":150,"d":"150 €"},{"v":140,"d":"140 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":10,"d":"10 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":140,"d":"140 €"}}]
[null,"Keemiline puhastus","Isiklik hooldus",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Juuksed ja küüned","Isiklik hooldus",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Spordiklubi","Isiklik hooldus",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Meditsiinitarbed","Isiklik hooldus",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Söök","Lemmikloomad",{"v":150,"d":"150 €"},{"v":75,"d":"75 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":75,"d":"75 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":75,"d":"75 €"}}]
[null,"Hoolitsus","Lemmikloomad",{"v":20,"d":"20 €"},{"v":25,"d":"25 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-5,"d":"-5 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":25,"d":"25 €"}}]
[null,"Meditsiinitarbed","Lemmikloomad",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Mänguasjad","Lemmikloomad",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Investeerimiskonto","Säästud või investeeringud",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":200,"d":"200 €"}}]
[null,"Pensionikonto","Säästud või investeeringud",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Riiklikud maksud","Maksud",{"v":300,"d":"300 €"},{"v":300,"d":"300 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":300,"d":"300 €"}}]
[null,"Kohalikud maksud","Maksud",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Maakonna maksud","Maksud",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Bussi- ja taksosõiduraha","Transport",{"v":100,"d":"100 €"},{"v":150,"d":"150 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":-50,"d":"-50 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":150,"d":"150 €"}}]
[null,"Kütus","Transport",{"v":450,"d":"450 €"},{"v":400,"d":"400 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":50,"d":"50 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":400,"d":"400 €"}}]
[null,"Kindlustus","Transport",{"v":300,"d":"300 €"},{"v":300,"d":"300 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":300,"d":"300 €"}}]
[null,"Autokool ","Transport",{"v":25,"d":"25 €"},{"v":25,"d":"25 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":25,"d":"25 €"}}]
[null,"Hooldamine","Transport",{"v":100,"d":"100 €"},{"v":50,"d":"50 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":50,"d":"50 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":50,"d":"50 €"}}]
[null,"Parkimine","Transport",null,null,{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}}]
[null,"Sõiduki makse","Transport",{"v":450,"d":"450 €"},{"v":450,"d":"450 €"},{"$f":"Eelarve_üksikasjad[[#This Row],[Prognoositavad kulud]]-Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":0,"d":"0 €"}},{"$f":"Eelarve_üksikasjad[[#This Row],[Tegelik kulu]]","v":{"v":450,"d":"450 €"}}]
[null,"Kokku",null,{"$f":"SUBTOTAL(109,Eelarve_üksikasjad[Prognoositavad kulud])","v":{"v":7915,"d":"7,915 €"}},{"$f":"SUBTOTAL(109,Eelarve_üksikasjad[Tegelik kulu])","v":{"v":7860,"d":"7,860 €"}},{"$f":"SUBTOTAL(109,Eelarve_üksikasjad[Erinevus])","v":{"v":55,"d":"55 €"}}]

{"sheet":"Lisaandmed","index":3,"n_rows":15,"n_cols":5,"rows_kept":15}
["Selle töölehe abil saate muuta töölehe Kuuväljaminekud tabeli Eelarve üksikasjad kategooria veeru ripploendit. Selleks muutke lahtrist E2 algavat Eelarve Kategooria otsing või sisestage sellesse uus kategooria. Lahtris B2 algab töölehe Kuueelarve aruanne diagrammiga Eelarve ülevaade lingitud PivotTable-liigendtabel.","Diagrammi Eelarve ülevaade PivotTable-liigendtabel",null,null,"Eelarve üksikasjad kategooria otsinguloend"]
[null,"Kategooria","Kulu",null,"Eelarve Kategooria otsing"]
[null,"Lapsed",{"v":140,"d":"140 €"},null,"Lapsed"]
[null,"Meelelahutus",{"v":358,"d":"358 €"},null,"Meelelahutus"]
[null,"Söök",{"v":1320,"d":"1,320 €"},null,"Söök"]
[null,"Kingitused ja heategevus",{"v":125,"d":"125 €"},null,"Kingitused ja heategevus"]
[null,"Eluase",{"v":2702,"d":"2,702 €"},null,"Eluase"]
[null,"Kindlustus",{"v":900,"d":"900 €"},null,"Kindlustus"]
[null,"Laenud",{"v":200,"d":"200 €"},null,"Laenud"]
[null,"Isiklik hooldus",{"v":140,"d":"140 €"},null,"Isiklik hooldus"]
[null,"Lemmikloomad",{"v":100,"d":"100 €"},null,"Lemmikloomad"]
[null,"Säästud või investeeringud",{"v":200,"d":"200 €"},null,"Säästud või investeeringud"]
[null,"Maksud",{"v":300,"d":"300 €"},null,"Maksud"]
[null,"Transport",{"v":1375,"d":"1,375 €"},null,"Transport"]
[null,"Üldkokkuvõte",{"v":7860,"d":"7,860 €"}]