{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Juhend","Päeva rahavoog","Kuu rahavoog","Aasta rahavoog","Sissetulek","Kulud","Valikulised","Säästud"],"not_rendered":{"charts":4,"defined_names":39,"pivot_tables":8},"read":"whole","date_system":"1900"}

{"sheet":"Juhend","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,7],[2,1,2,8]]}
[{"$nulls":11}," "]
[null,"ISIKLIK RAHAVOOG"]
[null,"  Selles töövihikus on aasta, kuu ja päeva töölehed. \n  Isiklikest rahavoogudest ülevaate saamiseks valige sobiv rahavoo tüüp või kasutage neid kõiki."]
[]
[null,"Päeva rahavoog",null,null,"Kuu rahavoog",null,null,"Aasta rahavoog"]
[]
[null,"Sisestage igapäevane prognoositav rahavoosumma ja vaadake läbi prognoositavad igakuised ja -aastased kogusummad.  Selle abil saate ülevaate oma päeva kulutamisharjumustest kuu või aasta lõikes.",null,null,"Sisestage igakuine rahavoog või hinnake järelejäänud kuid, et näha aasta prognoositud rahavoogu iga kuu kohta.",null,null,"Sisestage aasta rahavoo summa neljale töölehele: Sissetulekud, kulud, valikulised kulud ja säästud. \nSaate vaadata kuujaotust ja eri valdkondade võrdlust ning mis kõige tähtsam, üldseisu aasta ja kuu lõikes."]

{"sheet":"Päeva rahavoog","index":1,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[1,3,1,4],[1,5,1,8]]}
[null,"ISIKLIK RAHAVOOG"]
[null,null,"Kogu vaba raha:",{"$f":"PäevaRahavoog","v":{"v":577.8399999999999,"d":"577.84 €"}},null,"MÄRKUS: Kui soovite tabelisse lisada igapäevaseid üksusi, hinnake nende kuuväärtust ja paigutage need sobivasse kuuveergu."]
[]
[null,"PÄEVAKOKKUVÕTE"]
[null,"Kogusummad","Igapäevane","Igakuine","Aastane "]
[null,"Sissetulek",{"$f":"SUMIF(Igapäevane[Tüüp],$B6,Igapäevane[Igapäevane])","v":{"v":342.47,"d":"342.47 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],$B6,Igapäevane[Igakuine])","v":{"v":10416.795833333334,"d":"10,416.80 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],$B6,Igapäevane[Aastane])","v":{"v":125001.55000000002,"d":"125,001.55 €"}}]
[null,"Kulud",{"$f":"SUMIF(Igapäevane[Tüüp],$B7,Igapäevane[Igapäevane])","v":{"v":136.05999999999997,"d":"136.06 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],$B7,Igapäevane[Igakuine])","v":{"v":4138.491666666667,"d":"4,138.49 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],$B7,Igapäevane[Aastane])","v":{"v":49661.899999999994,"d":"49,661.90 €"}}]
[null,"Valikulised",{"$f":"SUMIF(Igapäevane[Tüüp],$B8,Igapäevane[Igapäevane])","v":{"v":36.29,"d":"36.29 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],$B8,Igapäevane[Igakuine])","v":{"v":1103.8208333333334,"d":"1,103.82 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],$B8,Igapäevane[Aastane])","v":{"v":13245.849999999999,"d":"13,245.85 €"}}]
[null,"Säästud",{"$f":"SUMIF(Igapäevane[Tüüp],$B9,Igapäevane[Igapäevane])","v":{"v":63.019999999999996,"d":"63.02 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],$B9,Igapäevane[Igakuine])","v":{"v":1916.8583333333333,"d":"1,916.86 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],$B9,Igapäevane[Aastane])","v":{"v":23002.300000000003,"d":"23,002.30 €"}}]
[]
[null,"Tüüp","Kirjeldus","Igapäevane","Igakuine","Aastane"]
[null,"Sissetulek","Palk",{"v":246.58,"d":"246.58 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":7500.141666666667,"d":"7,500.14 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":90001.70000000001,"d":"90,001.70 €"}}]
[null,"Sissetulek","Komisjonitasud/boonus",{"v":13.7,"d":"13.70 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":416.7083333333333,"d":"416.71 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":5000.5,"d":"5,000.50 €"}}]
[null,"Sissetulek","Muu 1",{"v":82.19,"d":"82.19 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":2499.945833333333,"d":"2,499.95 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":29999.35,"d":"29,999.35 €"}}]
[null,"Sissetulek","Muu 2",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Sissetulek","Muu 3",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Sissetulek","Muu 4",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Kulud","Sotsiaalmaksud",{"v":41.1,"d":"41.10 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":1250.125,"d":"1,250.13 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":15001.5,"d":"15,001.50 €"}}]
[null,"Kulud","Tulumaks",{"v":6.85,"d":"6.85 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":208.35416666666666,"d":"208.35 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":2500.25,"d":"2,500.25 €"}}]
[null,"Kulud","Sõidukitasud",{"v":0.55,"d":"0.55 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":16.729166666666668,"d":"16.73 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":200.75000000000003,"d":"200.75 €"}}]
[null,"Kulud","Sõidukimaksed",{"v":10.96,"d":"10.96 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":333.3666666666667,"d":"333.37 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":4000.4,"d":"4,000.40 €"}}]
[null,"Kulud","Hüpoteek/üür",{"v":41.1,"d":"41.10 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":1250.125,"d":"1,250.13 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":15001.5,"d":"15,001.50 €"}}]
[null,"Kulud","Kindlustus",{"v":0.68,"d":"0.68 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":20.683333333333334,"d":"20.68 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":248.20000000000002,"d":"248.20 €"}}]
[null,"Kulud","Elekter",{"v":3.29,"d":"3.29 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":100.07083333333333,"d":"100.07 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":1200.85,"d":"1,200.85 €"}}]
[null,"Kulud","Gaas",{"v":1.64,"d":"1.64 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Kulud","Vesi",{"v":1.64,"d":"1.64 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Kulud","Kanalisatsioon",{"v":0.82,"d":"0.82 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":24.941666666666663,"d":"24.94 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":299.29999999999995,"d":"299.30 €"}}]
[null,"Kulud","Prügivedu",{"v":0.41,"d":"0.41 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":12.470833333333331,"d":"12.47 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":149.64999999999998,"d":"149.65 €"}}]
[null,"Kulud","Telefon",{"v":1.64,"d":"1.64 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Kulud","Internet",{"v":1.64,"d":"1.64 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Kulud","Tervisekahjustuse kindlustus",{"v":4.11,"d":"4.11 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":125.0125,"d":"125.01 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":1500.15,"d":"1,500.15 €"}}]
[null,"Kulud","Toit",{"v":13.7,"d":"13.70 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":416.7083333333333,"d":"416.71 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":5000.5,"d":"5,000.50 €"}}]
[null,"Kulud","Riided",{"v":3.29,"d":"3.29 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":100.07083333333333,"d":"100.07 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":1200.85,"d":"1,200.85 €"}}]
[null,"Kulud","Ravikulud",{"v":1.64,"d":"1.64 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Kulud","Ühistransport",{"v":1,"d":"1.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":30.416666666666668,"d":"30.42 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":365,"d":"365.00 €"}}]
[null,"Kulud","Muu 2",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Kulud","Muu 3",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Kulud","Muu 4",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Valikulised","Einestamine",{"v":3.29,"d":"3.29 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":100.07083333333333,"d":"100.07 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":1200.85,"d":"1,200.85 €"}}]
[null,"Valikulised","Kingitused",{"v":1.64,"d":"1.64 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Valikulised","Reisimine",{"v":6.16,"d":"6.16 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":187.36666666666667,"d":"187.37 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":2248.4,"d":"2,248.40 €"}}]
[null,"Valikulised","Meelelahutus",{"v":3.29,"d":"3.29 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":100.07083333333333,"d":"100.07 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":1200.85,"d":"1,200.85 €"}}]
[null,"Valikulised","Isiklik hooldus",{"v":0.82,"d":"0.82 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":24.941666666666663,"d":"24.94 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":299.29999999999995,"d":"299.30 €"}}]
[null,"Valikulised","Ostud",{"v":5.48,"d":"5.48 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":166.68333333333334,"d":"166.68 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":2000.2,"d":"2,000.20 €"}}]
[null,"Valikulised","Heategevus",{"v":1.64,"d":"1.64 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Valikulised","Klubid/liikmesused",{"v":0.82,"d":"0.82 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":24.941666666666663,"d":"24.94 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":299.29999999999995,"d":"299.30 €"}}]
[null,"Valikulised","Koduremont",{"v":13.15,"d":"13.15 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":399.9791666666667,"d":"399.98 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":4799.75,"d":"4,799.75 €"}}]
[null,"Valikulised","Muu 1",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Valikulised","Muu 2",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Säästud","Reservid",{"v":13.7,"d":"13.70 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":416.7083333333333,"d":"416.71 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":5000.5,"d":"5,000.50 €"}}]
[null,"Säästud","401(k)/jne",{"v":32.88,"d":"32.88 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":1000.1,"d":"1,000.10 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":12001.2,"d":"12,001.20 €"}}]
[null,"Säästud","Säästukonto",{"v":16.44,"d":"16.44 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":500.05,"d":"500.05 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":6000.6,"d":"6,000.60 €"}}]
[null,"Säästud","Muu 1",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Säästud","Muu 2",{"v":0,"d":"0.00 €"},{"$f":"Igapäevane[[#This Row],[Aastane]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Igapäevane[[#This Row],[Igapäevane]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Kokku",null,{"$f":"SUMIF(Igapäevane[Tüüp],\"Sissetulekud\",Igapäevane[Igapäevane])-SUMIF(Igapäevane[Tüüp],\"<>Sissetulek\",Igapäevane[Igapäevane])","v":{"v":-235.3699999999999,"d":"-235.37 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],\"Sissetulekud\",Igapäevane[Igakuine])-SUMIF(Igapäevane[Tüüp],\"<>Sissetulek\",Igapäevane[Igakuine])","v":{"v":-7159.170833333334,"d":"-7,159.17 €"}},{"$f":"SUMIF(Igapäevane[Tüüp],\"Sissetulekud\",Igapäevane[Aastane])-SUMIF(Igapäevane[Tüüp],\"<>Sissetulek\",Igapäevane[Aastane])","v":{"v":-85910.05,"d":"-85,910.05 €"}}]

{"sheet":"Kuu rahavoog","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[1,3,1,4],[1,5,1,10]]}
[null,"ISIKLIK RAHAVOOG",{"$nulls":15}," "]
[null,null,"Kuu rahavoog kokku:",{"$f":"KuuRahavoogTänaseni","v":{"v":18380,"d":"18,380.00 €"}},null,"MÄRKUS. Hinnake igapäevaste üksuste kuuväärtust ja paigutage need sobivasse kuuveergu.\n"]
[]
[null,"Liik","Kirjeldus","Jaan","Veebr","Märts","Apr","Mai","Juuni","Juuli","Aug","Sept","Okt","Nov","Dets","Kokku"]
[null,"Sissetulek","Palk",{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":45000,"d":"45,000.00 €"}}]
[null,"Sissetulek","Komisjonitasud/boonus",{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":500,"d":"500.00 €"},{"v":200,"d":"200.00 €"},{"v":0,"d":"0.00 €"},{"v":600,"d":"600.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":2100,"d":"2,100.00 €"}}]
[null,"Sissetulek","Muu 1",{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":15000,"d":"15,000.00 €"}}]
[null,"Sissetulek","Muu 2",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Sissetulek","Muu 3",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Sissetulek","Muu 4",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Kulud","Sotsiaalmaksud",{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Kulud","Tulumaks",{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":1250,"d":"1,250.00 €"}}]
[null,"Kulud","Sõidukitasud",{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":100.00000000000001,"d":"100.00 €"}}]
[null,"Kulud","Sõidukimaksed",{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":1999.9999999999998,"d":"2,000.00 €"}}]
[null,"Kulud","Hüpoteek/üür",{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Kulud","Kindlustus",{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Kulud","Elekter",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Kulud","Gaas",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Kulud","Vesi",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Kulud","Kanalisatsioon",{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Kulud","Prügivedu",{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":75,"d":"75.00 €"}}]
[null,"Kulud","Telefon",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Kulud","Internet",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Kulud","Tervisekahjustuse kindlustus",{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":750,"d":"750.00 €"}}]
[null,"Kulud","Toit",{"v":400,"d":"400.00 €"},{"v":500,"d":"500.00 €"},{"v":450,"d":"450.00 €"},{"v":400,"d":"400.00 €"},{"v":450,"d":"450.00 €"},{"v":425,"d":"425.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":2625,"d":"2,625.00 €"}}]
[null,"Kulud","Riided",{"v":50,"d":"50.00 €"},{"v":75,"d":"75.00 €"},{"v":100,"d":"100.00 €"},{"v":75,"d":"75.00 €"},{"v":125,"d":"125.00 €"},{"v":75,"d":"75.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":500,"d":"500.00 €"}}]
[null,"Kulud","Ravikulud",{"v":50,"d":"50.00 €"},{"v":10,"d":"10.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":20,"d":"20.00 €"},{"v":70,"d":"70.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":200,"d":"200.00 €"}}]
[null,"Kulud","Ühistransport",{"v":30,"d":"30.00 €"},{"v":30,"d":"30.00 €"},{"v":30,"d":"30.00 €"},{"v":20,"d":"20.00 €"},{"v":30,"d":"30.00 €"},{"v":30,"d":"30.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":170,"d":"170.00 €"}}]
[null,"Kulud","Muu 2",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Kulud","Muu 3",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Kulud","Muu 4",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Valikulised","Einestamine",{"v":50,"d":"50.00 €"},{"v":150,"d":"150.00 €"},{"v":100,"d":"100.00 €"},{"v":50,"d":"50.00 €"},{"v":150,"d":"150.00 €"},{"v":100,"d":"100.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Valikulised","Kingitused",{"v":25,"d":"25.00 €"},{"v":75,"d":"75.00 €"},{"v":50,"d":"50.00 €"},{"v":25,"d":"25.00 €"},{"v":75,"d":"75.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Valikulised","Reisimine",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":1000,"d":"1,000.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":2000,"d":"2,000.00 €"}}]
[null,"Valikulised","Meelelahutus",{"v":50,"d":"50.00 €"},{"v":150,"d":"150.00 €"},{"v":100,"d":"100.00 €"},{"v":50,"d":"50.00 €"},{"v":150,"d":"150.00 €"},{"v":100,"d":"100.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Valikulised","Isiklik hooldus",{"v":15,"d":"15.00 €"},{"v":25,"d":"25.00 €"},{"v":35,"d":"35.00 €"},{"v":15,"d":"15.00 €"},{"v":25,"d":"25.00 €"},{"v":35,"d":"35.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Valikulised","Ostud",{"v":100,"d":"100.00 €"},{"v":200,"d":"200.00 €"},{"v":150,"d":"150.00 €"},{"v":175,"d":"175.00 €"},{"v":150,"d":"150.00 €"},{"v":175,"d":"175.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":950,"d":"950.00 €"}}]
[null,"Valikulised","Heategevus",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Valikulised","Klubid/liikmesused",{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Valikulised","Koduremont",{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":2400,"d":"2,400.00 €"}}]
[null,"Valikulised","Muu 1",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Valikulised","Muu 2",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Säästud","Reservid",{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":2500,"d":"2,500.00 €"}}]
[null,"Säästud","401(k)/jne",{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":6000,"d":"6,000.00 €"}}]
[null,"Säästud","Säästukonto",{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":3000,"d":"3,000.00 €"}}]
[null,"Säästud","Muu 1",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Säästud","Muu 2",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Igakuine[[#This Row],[Jaan]:[Dets]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Kokku",null,{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Jaan])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Jaan])","v":{"v":3692.5,"d":"3,692.50 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Veebr])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Veebr])","v":{"v":3247.5,"d":"3,247.50 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Märts])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Märts])","v":{"v":2522.5,"d":"2,522.50 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Apr])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Apr])","v":{"v":3427.5,"d":"3,427.50 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Mai])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Mai])","v":{"v":2887.5,"d":"2,887.50 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Juuni])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Juuni])","v":{"v":2602.5,"d":"2,602.50 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Juuli])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Juuli])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Aug])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Aug])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Sept])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Sept])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Okt])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Okt])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Nov])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Nov])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Dets])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Dets])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Igakuine[Liik],\"Sissetulek\",Igakuine[Kokku])-SUMIF(Igakuine[Liik],\"<>Sissetulek\",Igakuine[Kokku])","v":{"v":18380,"d":"18,380.00 €"}}]

{"sheet":"Aasta rahavoog","index":3,"n_rows":10,"n_cols":28,"rows_kept":10,"merged":[[1,3,1,4],[1,6,1,11],[3,1,3,3],[3,5,3,7],[3,9,3,11],[3,13,3,15],[4,2,4,3],[4,6,4,7],[4,10,4,11],[4,14,4,15],[7,2,7,3],[7,6,7,7],[7,10,7,11],[7,14,7,15]]}
[null,"ISIKLIK RAHAVOOG",{"$nulls":14}," "]
[null,null,"Rahavoog tänaseni kokku:",{"$f":"AastaRahavoogTänaseni","v":{"v":42250,"d":"42,250.00 €"}},null,null,"See on aastaprognoos. Selle töölehe abil saate vaadata aastasummasid ja prognoositavaid kuuväärtusi. Kasutage üksuste sisestamiseks töölehti Sissetulekud, Kulud, Valikulised kulud ja Säästud."]
[]
[null,"SISSETULEKUTE KOKKUVÕTE",{"$nulls":3},"KULUDE KOKKUVÕTE",{"$nulls":3},"VALIKULISTE KULUDE KOKKUVÕTE",{"$nulls":3},"SÄÄSTUDE KOKKUVÕTE"]
[null,"Aasta kogusumma:",{"$f":"Sissetulek!C11","v":{"v":125000,"d":"125,000.00 €"}},null,null,"Aasta kogusumma:",{"$f":"Kulud[[#Totals],[Aastane  ]]","v":{"v":46500,"d":"46,500.00 €"}},null,null,"Aasta kogusumma:",{"$f":"Valikulised_[[#Totals],[Aastane  ]]","v":{"v":13250,"d":"13,250.00 €"}},null,null,"Aasta kogusumma:",{"$f":"Säästud[[#Totals],[Aastane  ]]","v":{"v":23000,"d":"23,000.00 €"}}]
[]
[]
[null,"Kuu kogusumma:",{"$f":"Sissetulek!D11","v":{"v":10416.666666666668,"d":"10,416.67 €"}},null,null,"Kuu kogusumma:",{"$f":"Kulud[[#Totals],[Igakuine ]]","v":{"v":3875,"d":"3,875.00 €"}},null,null,"Kuu kogusumma:",{"$f":"Valikulised_[[#Totals],[Igakuine ]]","v":{"v":1104.1666666666665,"d":"1,104.17 €"}},null,null,"Kuu kogusumma:",{"$f":"Säästud!D10","v":{"v":1916.6666666666667,"d":"1,916.67 €"}}]
[]
[{"$nulls":17},"Reasildid","Aasta sissetulek",null,"Reasildid","Aastasumma",null,"Reasildid","Aastasumma",null,"Reasildid","Aastasumma"]

{"sheet":"Sissetulek","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"ISIKLIK RAHAVOOG"]
[null,null,"Rahavoog tänaseni kokku:",{"$f":"AastaRahavoogTänaseni","v":{"v":42250,"d":"42,250.00 €"}},null,"See on aastaprognoos. Selle töölehe abil saate vaadata aastasummasid ja prognoositavaid kuuväärtusi.\nKui soovite tabelitesse lisada igapäevaseid üksusi, hinnake nende aastaväärtust ja paigutage need sobivasse aastaveergu."]
[]
[null,"Sissetulek","Aastane  ","Igakuine "]
[null,"Palk",{"v":90000,"d":"90,000.00 €"},{"$f":"Sissetulek[[#This Row],[Aastane  ]]/12","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Komisjonitasud/boonus",{"v":5000,"d":"5,000.00 €"},{"$f":"Sissetulek[[#This Row],[Aastane  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Muu 1",{"v":30000,"d":"30,000.00 €"},{"$f":"Sissetulek[[#This Row],[Aastane  ]]/12","v":{"v":2500,"d":"2,500.00 €"}}]
[null,"Muu 2",{"v":0,"d":"0.00 €"},{"$f":"Sissetulek[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Muu 3",{"v":0,"d":"0.00 €"},{"$f":"Sissetulek[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Muu 4",{"v":0,"d":"0.00 €"},{"$f":"Sissetulek[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Sissetulek[[Aastane  ]])","v":{"v":125000,"d":"125,000.00 €"}},{"$f":"SUBTOTAL(109,Sissetulek[[Igakuine ]])","v":{"v":10416.666666666668,"d":"10,416.67 €"}}]

{"sheet":"Kulud","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"ISIKLIK RAHAVOOG"]
[null,null,"Rahavoog tänaseni kokku:",{"$f":"AastaRahavoogTänaseni","v":{"v":42250,"d":"42,250.00 €"}},null,"See on aastaprognoos. Selle töölehe abil saate vaadata aastasummasid ja prognoositavaid kuuväärtusi.\nKui soovite tabelitesse lisada igapäevaseid üksusi, hinnake nende aastaväärtust ja paigutage need sobivasse aastaveergu."]
[]
[null,"Kulud","Aastane  ","Igakuine "]
[null,"Sotsiaalmaksud",{"v":12500,"d":"12,500.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":1041.6666666666667,"d":"1,041.67 €"}}]
[null,"Tulumaks",{"v":2500,"d":"2,500.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":208.33333333333334,"d":"208.33 €"}}]
[null,"Sõidukitasud",{"v":200,"d":"200.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":16.666666666666668,"d":"16.67 €"}}]
[null,"Sõidukimaksed",{"v":4000,"d":"4,000.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":333.3333333333333,"d":"333.33 €"}}]
[null,"Hüpoteek/üür",{"v":15000,"d":"15,000.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":1250,"d":"1,250.00 €"}}]
[null,"Kindlustus",{"v":250,"d":"250.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":20.833333333333332,"d":"20.83 €"}}]
[null,"Elekter",{"v":1200,"d":"1,200.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Gaas",{"v":600,"d":"600.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Vesi/kanalisatsioon",{"v":600,"d":"600.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Prügivedu",{"v":150,"d":"150.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":12.5,"d":"12.50 €"}}]
[null,"Telefon",{"v":600,"d":"600.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Internet",{"v":600,"d":"600.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Tervisekahjustuse kindlustus",{"v":1500,"d":"1,500.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":125,"d":"125.00 €"}}]
[null,"Toit",{"v":5000,"d":"5,000.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Riided",{"v":1200,"d":"1,200.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Ravikulud",{"v":600,"d":"600.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Muu 1",{"v":0,"d":"0.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Muu 2",{"v":0,"d":"0.00 €"},{"$f":"Kulud[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Kulud[[Aastane  ]])","v":{"v":46500,"d":"46,500.00 €"}},{"$f":"SUBTOTAL(109,Kulud[[Igakuine ]])","v":{"v":3875,"d":"3,875.00 €"}}]

{"sheet":"Valikulised","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"ISIKLIK RAHAVOOG"]
[null,null,"Rahavoog tänaseni kokku:",{"$f":"AastaRahavoogTänaseni","v":{"v":42250,"d":"42,250.00 €"}},null,"See on aastaprognoos. Selle töölehe abil saate vaadata aastasummasid ja prognoositavaid kuuväärtusi.\nKui soovite tabelitesse lisada igapäevaseid üksusi, hinnake nende aastaväärtust ja paigutage need sobivasse aastaveergu."]
[]
[null,"Valikulised","Aastane  ","Igakuine "]
[null,"Einestamine",{"v":1200,"d":"1,200.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Kingitused",{"v":600,"d":"600.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Reisimine",{"v":2250,"d":"2,250.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":187.5,"d":"187.50 €"}}]
[null,"Meelelahutus",{"v":1200,"d":"1,200.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Isiklik hooldus",{"v":300,"d":"300.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":25,"d":"25.00 €"}}]
[null,"Ostud",{"v":2000,"d":"2,000.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":166.66666666666666,"d":"166.67 €"}}]
[null,"Heategevus",{"v":600,"d":"600.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Klubid/liikmesused",{"v":300,"d":"300.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":25,"d":"25.00 €"}}]
[null,"Koduremont",{"v":4800,"d":"4,800.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":400,"d":"400.00 €"}}]
[null,"Muu 1",{"v":0,"d":"0.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Muu 2",{"v":0,"d":"0.00 €"},{"$f":"Valikulised_[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Valikulised_[[Aastane  ]])","v":{"v":13250,"d":"13,250.00 €"}},{"$f":"SUBTOTAL(109,Valikulised_[[Igakuine ]])","v":{"v":1104.1666666666665,"d":"1,104.17 €"}}]

{"sheet":"Säästud","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"ISIKLIK RAHAVOOG",{"$nulls":7}," "]
[null,null,"Rahavoog tänaseni kokku:",{"$f":"AastaRahavoogTänaseni","v":{"v":42250,"d":"42,250.00 €"}},null,"See on aastaprognoos. Selle töölehe abil saate vaadata aastasummasid ja prognoositavaid kuuväärtusi.\nKui soovite tabelitesse lisada igapäevaseid üksusi, hinnake nende aastaväärtust ja paigutage need sobivasse aastaveergu."]
[]
[null,"Säästud","Aastane  ","Igakuine "]
[null,"Reservid",{"v":5000,"d":"5,000.00 €"},{"$f":"Säästud[[#This Row],[Aastane  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Pension jne",{"v":12000,"d":"12,000.00 €"},{"$f":"Säästud[[#This Row],[Aastane  ]]/12","v":{"v":1000,"d":"1,000.00 €"}}]
[null,"Säästud/investeeringud",{"v":6000,"d":"6,000.00 €"},{"$f":"Säästud[[#This Row],[Aastane  ]]/12","v":{"v":500,"d":"500.00 €"}}]
[null,"Muu 1",{"v":0,"d":"0.00 €"},{"$f":"Säästud[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Muu 2",{"v":0,"d":"0.00 €"},{"$f":"Säästud[[#This Row],[Aastane  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Säästud[[Aastane  ]])","v":{"v":23000,"d":"23,000.00 €"}},{"$f":"SUBTOTAL(109,Säästud[[Igakuine ]])","v":{"v":1916.6666666666667,"d":"1,916.67 €"}}]