{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Sprievodca","Denný peňažný tok","Mesačný peňažný tok","Ročný peňažný tok","Príjmy","Výdavky","Nepovinné výdavky","Úspory"],"not_rendered":{"charts":4,"defined_names":34,"pivot_tables":8},"read":"whole","date_system":"1900"}

{"sheet":"Sprievodca","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,7],[2,1,2,8]]}
[{"$nulls":11}," "]
[null,"OSOBNÝ PEŇAŽNÝ TOK"]
[null,"  Tento zošit obsahuje hárky pre ročný, mesačný a denný peňažný tok. \n  Vyberte si typ peňažného toku, ktorý vám najviac vyhovuje, alebo ich používajte všetky naraz, aby ste získali dokonalý prehľad o svojom osobnom peňažnom toku."]
[]
[null,"Denný peňažný tok",null,null,"Mesačný peňažný tok",null,null,"Ročný peňažný tok"]
[]
[null,"Zadajte odhadovanú sumu peňažného roku vytvoreného z denných položiek a pozrite si odhadovaný mesačný či ročný súčet.  Pomocou tejto šablóny získate predstavu o svojich návykoch pri denných výdavkoch v priebehu mesiaca či roka.",null,null,"Zadajte mesačný peňažný tok vytvorený z položiek za mesiac alebo odhadnite zostávajúce mesiace, aby ste spoznali predpokladaný peňažný tok na rok či jednotlivé mesiace.",null,null,"Zadajte sumy ročného peňažného toku do štyroch hárkov. Príjmy, výdavky, nepovinné výdavky a úspory. \nPozrite si mesačný rozpis aj porovnania, ale hlavne si pozrite konečné súčty ročných aj mesačných čísel."]

{"sheet":"Denný peňažný tok","index":1,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[1,3,1,4],[1,5,1,8]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK"]
[null,null,"Celkové dostupné prostriedky:",{"$f":"DennýPeňažnýTok","v":{"v":577.8399999999999,"d":"577.84 EUR"}},null,"POZNÁMKA: Ak chcete do tabuľky pridať denné položky, odhadnite ich mesačnú sumu/hodnotu a zapíšte ju do stĺpca pre príslušný mesiac."]
[]
[null,"DENNÝ SÚHRN"]
[null,"Súčty","Denne","Mesačne","Ročne "]
[null,"Príjmy",{"$f":"SUMIF(Denne[Typ],$B6,Denne[Denne])","v":{"v":342.47,"d":"342.47 EUR"}},{"$f":"SUMIF(Denne[Typ],$B6,Denne[Mesačne])","v":{"v":10416.795833333334,"d":"10,416.80 EUR"}},{"$f":"SUMIF(Denne[Typ],$B6,Denne[Ročne])","v":{"v":125001.55000000002,"d":"125,001.55 EUR"}}]
[null,"Výdavky",{"$f":"SUMIF(Denne[Typ],$B7,Denne[Denne])","v":{"v":136.05999999999997,"d":"136.06 EUR"}},{"$f":"SUMIF(Denne[Typ],$B7,Denne[Mesačne])","v":{"v":4138.491666666667,"d":"4,138.49 EUR"}},{"$f":"SUMIF(Denne[Typ],$B7,Denne[Ročne])","v":{"v":49661.899999999994,"d":"49,661.90 EUR"}}]
[null,"Nepovinné výdavky",{"$f":"SUMIF(Denne[Typ],$B8,Denne[Denne])","v":{"v":36.29,"d":"36.29 EUR"}},{"$f":"SUMIF(Denne[Typ],$B8,Denne[Mesačne])","v":{"v":1103.8208333333334,"d":"1,103.82 EUR"}},{"$f":"SUMIF(Denne[Typ],$B8,Denne[Ročne])","v":{"v":13245.849999999999,"d":"13,245.85 EUR"}}]
[null,"Úspory",{"$f":"SUMIF(Denne[Typ],$B9,Denne[Denne])","v":{"v":63.019999999999996,"d":"63.02 EUR"}},{"$f":"SUMIF(Denne[Typ],$B9,Denne[Mesačne])","v":{"v":1916.8583333333333,"d":"1,916.86 EUR"}},{"$f":"SUMIF(Denne[Typ],$B9,Denne[Ročne])","v":{"v":23002.300000000003,"d":"23,002.30 EUR"}}]
[]
[null,"Typ","Popis","Denne","Mesačne","Ročne"]
[null,"Príjmy","Mzda",{"v":246.58,"d":"246.58 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":7500.141666666667,"d":"7,500.14 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":90001.70000000001,"d":"90,001.70 EUR"}}]
[null,"Príjmy","Provízie/prémie",{"v":13.7,"d":"13.70 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":416.7083333333333,"d":"416.71 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":5000.5,"d":"5,000.50 EUR"}}]
[null,"Príjmy","Iné 1",{"v":82.19,"d":"82.19 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":2499.945833333333,"d":"2,499.95 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":29999.35,"d":"29,999.35 EUR"}}]
[null,"Príjmy","Iné 2",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Príjmy","Iné 3",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Príjmy","Iné 4",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Výdavky","Zdravotná starostlivosť/lekár",{"v":41.1,"d":"41.10 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":1250.125,"d":"1,250.13 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":15001.5,"d":"15,001.50 EUR"}}]
[null,"Výdavky","Štátna daň z príjmu",{"v":6.85,"d":"6.85 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":208.35416666666666,"d":"208.35 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":2500.25,"d":"2,500.25 EUR"}}]
[null,"Výdavky","Poplatky/dane za automobil",{"v":0.55,"d":"0.55 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":16.729166666666668,"d":"16.73 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":200.75000000000003,"d":"200.75 EUR"}}]
[null,"Výdavky","Platby za automobil",{"v":10.96,"d":"10.96 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":333.3666666666667,"d":"333.37 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":4000.4,"d":"4,000.40 EUR"}}]
[null,"Výdavky","Hypotéka/nájomné",{"v":41.1,"d":"41.10 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":1250.125,"d":"1,250.13 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":15001.5,"d":"15,001.50 EUR"}}]
[null,"Výdavky","Poistenie",{"v":0.68,"d":"0.68 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":20.683333333333334,"d":"20.68 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":248.20000000000002,"d":"248.20 EUR"}}]
[null,"Výdavky","Elektrina",{"v":3.29,"d":"3.29 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":100.07083333333333,"d":"100.07 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":1200.85,"d":"1,200.85 EUR"}}]
[null,"Výdavky","Plyn",{"v":1.64,"d":"1.64 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Výdavky","Voda",{"v":1.64,"d":"1.64 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Výdavky","Kanalizácia",{"v":0.82,"d":"0.82 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":24.941666666666663,"d":"24.94 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":299.29999999999995,"d":"299.30 EUR"}}]
[null,"Výdavky","Odpad",{"v":0.41,"d":"0.41 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":12.470833333333331,"d":"12.47 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":149.64999999999998,"d":"149.65 EUR"}}]
[null,"Výdavky","Telefón",{"v":1.64,"d":"1.64 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Výdavky","Internet",{"v":1.64,"d":"1.64 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Výdavky","Poistenie pre prípad invalidity",{"v":4.11,"d":"4.11 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":125.0125,"d":"125.01 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":1500.15,"d":"1,500.15 EUR"}}]
[null,"Výdavky","Strava",{"v":13.7,"d":"13.70 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":416.7083333333333,"d":"416.71 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":5000.5,"d":"5,000.50 EUR"}}]
[null,"Výdavky","Oblečenie",{"v":3.29,"d":"3.29 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":100.07083333333333,"d":"100.07 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":1200.85,"d":"1,200.85 EUR"}}]
[null,"Výdavky","Zdravotná starostlivosť/zubár/RTG",{"v":1.64,"d":"1.64 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Výdavky","Autobus",{"v":1,"d":"1.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":30.416666666666668,"d":"30.42 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":365,"d":"365.00 EUR"}}]
[null,"Výdavky","Iné 2",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Výdavky","Iné 3",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Výdavky","Iné 4",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Nepovinné výdavky","Obedy",{"v":3.29,"d":"3.29 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":100.07083333333333,"d":"100.07 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":1200.85,"d":"1,200.85 EUR"}}]
[null,"Nepovinné výdavky","Dary",{"v":1.64,"d":"1.64 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Nepovinné výdavky","Cestovanie",{"v":6.16,"d":"6.16 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":187.36666666666667,"d":"187.37 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":2248.4,"d":"2,248.40 EUR"}}]
[null,"Nepovinné výdavky","Zábava",{"v":3.29,"d":"3.29 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":100.07083333333333,"d":"100.07 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":1200.85,"d":"1,200.85 EUR"}}]
[null,"Nepovinné výdavky","Osobná starostlivosť",{"v":0.82,"d":"0.82 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":24.941666666666663,"d":"24.94 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":299.29999999999995,"d":"299.30 EUR"}}]
[null,"Nepovinné výdavky","Nákupy",{"v":5.48,"d":"5.48 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":166.68333333333334,"d":"166.68 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":2000.2,"d":"2,000.20 EUR"}}]
[null,"Nepovinné výdavky","Charita",{"v":1.64,"d":"1.64 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Nepovinné výdavky","Členstvá v kluboch",{"v":0.82,"d":"0.82 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":24.941666666666663,"d":"24.94 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":299.29999999999995,"d":"299.30 EUR"}}]
[null,"Nepovinné výdavky","Opravy v domácnosti",{"v":13.15,"d":"13.15 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":399.9791666666667,"d":"399.98 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":4799.75,"d":"4,799.75 EUR"}}]
[null,"Nepovinné výdavky","Iné 1",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Nepovinné výdavky","Iné 2",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Úspory","Peňažná rezerva",{"v":13.7,"d":"13.70 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":416.7083333333333,"d":"416.71 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":5000.5,"d":"5,000.50 EUR"}}]
[null,"Úspory","401 000/iné",{"v":32.88,"d":"32.88 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":1000.1,"d":"1,000.10 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":12001.2,"d":"12,001.20 EUR"}}]
[null,"Úspory","Sporiaci účet",{"v":16.44,"d":"16.44 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":500.05,"d":"500.05 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":6000.6,"d":"6,000.60 EUR"}}]
[null,"Úspory","Iné 1",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Úspory","Iné 2",{"v":0,"d":"0.00 EUR"},{"$f":"Denne[[#This Row],[Ročne]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Denne[[#This Row],[Denne]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Celková hodnota",null,{"$f":"SUMIF(Denne[Typ],\"Príjmy\",Denne[Denne])-SUMIF(Denne[Typ],\"<>Príjmy\",Denne[Denne])","v":{"v":107.10000000000014,"d":"107.10 EUR"}},{"$f":"SUMIF(Denne[Typ],\"Príjmy\",Denne[Mesačne])-SUMIF(Denne[Typ],\"<>Príjmy\",Denne[Mesačne])","v":{"v":3257.625,"d":"3,257.63 EUR"}},{"$f":"SUMIF(Denne[Typ],\"Príjmy\",Denne[Ročne])-SUMIF(Denne[Typ],\"<>Príjmy\",Denne[Ročne])","v":{"v":39091.500000000015,"d":"39,091.50 EUR"}}]

{"sheet":"Mesačný peňažný tok","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[1,3,1,4],[1,5,1,10]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":15}," "]
[null,null,"Celkový mesačný peňažný tok:",{"$f":"MjesečninovčanitokDoDanašnjegDatuma","v":{"v":18380,"d":"18,380.00 EUR"}},null,"POZNÁMKA: V prípade denných položiek odhadnite mesačnú sumu/hodnotu a zapíšte ju do stĺpca pre príslušný mesiac.\n"]
[]
[null,"Typ","Popis","Jan","Feb","Mar","Apr","Máj","Jún","Júl","Aug","Sep","Okt","Nov","Dec","Celková hodnota"]
[null,"Príjmy","Mzda",{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":45000,"d":"45,000.00 EUR"}}]
[null,"Príjmy","Provízie/prémie",{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":600,"d":"600.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2100,"d":"2,100.00 EUR"}}]
[null,"Príjmy","Iné 1",{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":15000,"d":"15,000.00 EUR"}}]
[null,"Príjmy","Iné 2",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Príjmy","Iné 3",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Príjmy","Iné 4",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Výdavky","Zdravotná starostlivosť/lekár",{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"7,500.00 EUR"}}]
[null,"Výdavky","Štátna daň z príjmu",{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":1250,"d":"1,250.00 EUR"}}]
[null,"Výdavky","Poplatky/dane za automobil",{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":100.00000000000001,"d":"100.00 EUR"}}]
[null,"Výdavky","Platby za automobil",{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":1999.9999999999998,"d":"2,000.00 EUR"}}]
[null,"Výdavky","Hypotéka/nájomné",{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"7,500.00 EUR"}}]
[null,"Výdavky","Poistenie",{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 EUR"}}]
[null,"Výdavky","Elektrina",{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 EUR"}}]
[null,"Výdavky","Plyn",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Výdavky","Voda",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Výdavky","Kanalizácia",{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 EUR"}}]
[null,"Výdavky","Odpad",{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":75,"d":"75.00 EUR"}}]
[null,"Výdavky","Telefón",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Výdavky","Internet",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Výdavky","Poistenie pre prípad invalidity",{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":750,"d":"750.00 EUR"}}]
[null,"Výdavky","Strava",{"v":400,"d":"400.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":450,"d":"450.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":450,"d":"450.00 EUR"},{"v":425,"d":"425.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2625,"d":"2,625.00 EUR"}}]
[null,"Výdavky","Oblečenie",{"v":50,"d":"50.00 EUR"},{"v":75,"d":"75.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":75,"d":"75.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":75,"d":"75.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":500,"d":"500.00 EUR"}}]
[null,"Výdavky","Zdravotná starostlivosť/zubár/RTG",{"v":50,"d":"50.00 EUR"},{"v":10,"d":"10.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":20,"d":"20.00 EUR"},{"v":70,"d":"70.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":200,"d":"200.00 EUR"}}]
[null,"Výdavky","Autobus",{"v":30,"d":"30.00 EUR"},{"v":30,"d":"30.00 EUR"},{"v":30,"d":"30.00 EUR"},{"v":20,"d":"20.00 EUR"},{"v":30,"d":"30.00 EUR"},{"v":30,"d":"30.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":170,"d":"170.00 EUR"}}]
[null,"Výdavky","Iné 2",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Výdavky","Iné 3",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Výdavky","Iné 4",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Nepovinné výdavky","Obedy",{"v":50,"d":"50.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":100,"d":"100.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 EUR"}}]
[null,"Nepovinné výdavky","Dary",{"v":25,"d":"25.00 EUR"},{"v":75,"d":"75.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":75,"d":"75.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Nepovinné výdavky","Cestovanie",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2000,"d":"2,000.00 EUR"}}]
[null,"Nepovinné výdavky","Zábava",{"v":50,"d":"50.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":100,"d":"100.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 EUR"}}]
[null,"Nepovinné výdavky","Osobná starostlivosť",{"v":15,"d":"15.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":35,"d":"35.00 EUR"},{"v":15,"d":"15.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":35,"d":"35.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 EUR"}}]
[null,"Nepovinné výdavky","Nákupy",{"v":100,"d":"100.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":175,"d":"175.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":175,"d":"175.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":950,"d":"950.00 EUR"}}]
[null,"Nepovinné výdavky","Charita",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Nepovinné výdavky","Členstvá v kluboch",{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 EUR"}}]
[null,"Nepovinné výdavky","Opravy v domácnosti",{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2400,"d":"2,400.00 EUR"}}]
[null,"Nepovinné výdavky","Iné 1",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Nepovinné výdavky","Iné 2",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Úspory","Peňažná rezerva",{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2500,"d":"2,500.00 EUR"}}]
[null,"Úspory","401 000/iné",{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":6000,"d":"6,000.00 EUR"}}]
[null,"Úspory","Sporiaci účet",{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":3000,"d":"3,000.00 EUR"}}]
[null,"Úspory","Iné 1",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Úspory","Iné 2",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Celková hodnota",null,{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Jan])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Jan])","v":{"v":3692.5,"d":"3,692.50 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Feb])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Feb])","v":{"v":3247.5,"d":"3,247.50 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Mar])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Mar])","v":{"v":2522.5,"d":"2,522.50 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Apr])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Apr])","v":{"v":3427.5,"d":"3,427.50 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Máj])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Máj])","v":{"v":2887.5,"d":"2,887.50 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Jún])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Jún])","v":{"v":2602.5,"d":"2,602.50 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Júl])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Júl])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Aug])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Aug])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Sep])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Sep])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Okt])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Okt])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Nov])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Nov])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Dec])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Dec])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mesačne[Typ],\"Príjmy\",Mesačne[Celková hodnota])-SUMIF(Mesačne[Typ],\"<>Príjmy\",Mesačne[Celková hodnota])","v":{"v":18380,"d":"18,380.00 EUR"}}]

{"sheet":"Ročný peňažný tok","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,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":14}," "]
[null,null,"Celkový peňažný tok k dnešnému dňu:",{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":42250,"d":"42,250.00 EUR"}},null,null,"Toto je ročný odhad.  Tento hárok použite, ak si chcete pozrieť ročné sumy s odhadnutými mesačnými hodnotami. Na zadávanie položiek použite hárky Príjmy, výdavky, nepovinné výdavky a úspory."]
[]
[null,"SÚHRN PRÍJMOV",{"$nulls":3},"SÚHRN VÝDAVKOV",{"$nulls":3},"SÚHRN NEPOVINNÝCH VÝDAVKOV",{"$nulls":3},"SÚHRN ÚSPOR"]
[null,"Celkovo za rok:",{"$f":"Príjmy!C11","v":{"v":125000,"d":"125,000.00 EUR"}},null,null,"Celkovo za rok:",{"$f":"Výdavky[[#Totals],[Ročná  ]]","v":{"v":46500,"d":"46,500.00 EUR"}},null,null,"Celkovo za rok:",{"$f":"Nepovinné_výdavky[[#Totals],[Ročná  ]]","v":{"v":13250,"d":"13,250.00 EUR"}},null,null,"Celkovo za rok:",{"$f":"Úspory[[#Totals],[Ročná  ]]","v":{"v":23000,"d":"23,000.00 EUR"}}]
[]
[]
[null,"Celkovo za mesiac:",{"$f":"Príjmy!D11","v":{"v":10416.666666666668,"d":"10,416.67 EUR"}},null,null,"Celkovo za mesiac:",{"$f":"Výdavky[[#Totals],[Mesačne ]]","v":{"v":3875,"d":"3,875.00 EUR"}},null,null,"Celkovo za mesiac:",{"$f":"Nepovinné_výdavky[[#Totals],[Mesačne ]]","v":{"v":1104.1666666666665,"d":"1,104.17 EUR"}},null,null,"Celkovo za mesiac:",{"$f":"Úspory[[#Totals],[Mesačne ]]","v":{"v":1916.6666666666667,"d":"1,916.67 EUR"}}]
[]
[{"$nulls":17},"Row Labels","Sum of Ročná",null,"Row Labels","Sum of Ročná",null,"Row Labels","Sum of Ročná",null,"Row Labels","Sum of Ročná"]

{"sheet":"Príjmy","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK"]
[null,null,"Celkový peňažný tok k dnešnému dňu:",{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":42250,"d":"42,250.00 EUR"}},null,"Toto je ročný odhad.  Tento hárok použite, ak si chcete pozrieť ročné sumy s odhadnutými mesačnými hodnotami.\nAk chcete do tabuľky pridať denné položky, odhadnite ich ročnú sumu/hodnotu a zapíšte ju do stĺpca pre ročné výdavky."]
[]
[null,"Príjmy","Ročná  ","Mesačne "]
[null,"Mzda",{"v":90000,"d":"90,000.00 EUR"},{"$f":"Príjmy[[#This Row],[Ročná  ]]/12","v":{"v":7500,"d":"7,500.00 EUR"}}]
[null,"Provízie/prémie",{"v":5000,"d":"5,000.00 EUR"},{"$f":"Príjmy[[#This Row],[Ročná  ]]/12","v":{"v":416.6666666666667,"d":"416.67 EUR"}}]
[null,"Iné 1",{"v":30000,"d":"30,000.00 EUR"},{"$f":"Príjmy[[#This Row],[Ročná  ]]/12","v":{"v":2500,"d":"2,500.00 EUR"}}]
[null,"Iné 2",{"v":0,"d":"0.00 EUR"},{"$f":"Príjmy[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Iné 3",{"v":0,"d":"0.00 EUR"},{"$f":"Príjmy[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Iné 4",{"v":0,"d":"0.00 EUR"},{"$f":"Príjmy[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null," Celková hodnota",{"$f":"SUBTOTAL(109,Príjmy[[Ročná  ]])","v":{"v":125000,"d":"125,000.00 EUR"}},{"$f":"SUBTOTAL(109,Príjmy[[Mesačne ]])","v":{"v":10416.666666666668,"d":"10,416.67 EUR"}}]

{"sheet":"Výdavky","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK"]
[null,null,"Celkový peňažný tok k dnešnému dňu:",{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":42250,"d":"42,250.00 EUR"}},null,"Toto je ročný odhad.  Tento hárok použite, ak si chcete pozrieť ročné sumy s odhadnutými mesačnými hodnotami.\nAk chcete do tabuľky pridať denné položky, odhadnite ich ročnú sumu/hodnotu a zapíšte ju do stĺpca pre ročné výdavky."]
[]
[null,"Výdavky","Ročná  ","Mesačne "]
[null,"Zdravotná starostlivosť/lekár",{"v":12500,"d":"12,500.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":1041.6666666666667,"d":"1,041.67 EUR"}}]
[null,"Štátna daň z príjmu",{"v":2500,"d":"2,500.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":208.33333333333334,"d":"208.33 EUR"}}]
[null,"Poplatky/dane za automobil",{"v":200,"d":"200.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":16.666666666666668,"d":"16.67 EUR"}}]
[null,"Platby za automobil",{"v":4000,"d":"4,000.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":333.3333333333333,"d":"333.33 EUR"}}]
[null,"Hypotéka/nájomné",{"v":15000,"d":"15,000.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":1250,"d":"1,250.00 EUR"}}]
[null,"Poistenie",{"v":250,"d":"250.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":20.833333333333332,"d":"20.83 EUR"}}]
[null,"Elektrina",{"v":1200,"d":"1,200.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Plyn",{"v":600,"d":"600.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Voda/kanalizácia",{"v":600,"d":"600.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Odpad",{"v":150,"d":"150.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":12.5,"d":"12.50 EUR"}}]
[null,"Telefón",{"v":600,"d":"600.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Internet",{"v":600,"d":"600.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Poistenie pre prípad invalidity",{"v":1500,"d":"1,500.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":125,"d":"125.00 EUR"}}]
[null,"Strava",{"v":5000,"d":"5,000.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":416.6666666666667,"d":"416.67 EUR"}}]
[null,"Oblečenie",{"v":1200,"d":"1,200.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Zdravotná starostlivosť/zubár/RTG",{"v":600,"d":"600.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Iné 1",{"v":0,"d":"0.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Iné 2",{"v":0,"d":"0.00 EUR"},{"$f":"Výdavky[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null," Celková hodnota",{"$f":"SUBTOTAL(109,Výdavky[[Ročná  ]])","v":{"v":46500,"d":"46,500.00 EUR"}},{"$f":"SUBTOTAL(109,Výdavky[[Mesačne ]])","v":{"v":3875,"d":"3,875.00 EUR"}}]

{"sheet":"Nepovinné výdavky","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK"]
[null,null,"Celkový peňažný tok k dnešnému dňu:",{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":42250,"d":"42,250.00 EUR"}},null,"Toto je ročný odhad.  Tento hárok použite, ak si chcete pozrieť ročné sumy s odhadnutými mesačnými hodnotami.\nAk chcete do tabuľky pridať denné položky, odhadnite ich ročnú sumu/hodnotu a zapíšte ju do stĺpca pre ročné výdavky."]
[]
[null,"Nepovinné výdavky","Ročná  ","Mesačne "]
[null,"Obedy",{"v":1200,"d":"1,200.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Dary",{"v":600,"d":"600.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Cestovanie",{"v":2250,"d":"2,250.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":187.5,"d":"187.50 EUR"}}]
[null,"Zábava",{"v":1200,"d":"1,200.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Osobná starostlivosť",{"v":300,"d":"300.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":25,"d":"25.00 EUR"}}]
[null,"Nákupy",{"v":2000,"d":"2,000.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":166.66666666666666,"d":"166.67 EUR"}}]
[null,"Charita",{"v":600,"d":"600.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Členstvá v kluboch",{"v":300,"d":"300.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":25,"d":"25.00 EUR"}}]
[null,"Opravy v domácnosti",{"v":4800,"d":"4,800.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":400,"d":"400.00 EUR"}}]
[null,"Iné 1",{"v":0,"d":"0.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Iné 2",{"v":0,"d":"0.00 EUR"},{"$f":"Nepovinné_výdavky[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null," Celková hodnota",{"$f":"SUBTOTAL(109,Nepovinné_výdavky[[Ročná  ]])","v":{"v":13250,"d":"13,250.00 EUR"}},{"$f":"SUBTOTAL(109,Nepovinné_výdavky[[Mesačne ]])","v":{"v":1104.1666666666665,"d":"1,104.17 EUR"}}]

{"sheet":"Úspory","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":7}," "]
[null,null,"Celkový peňažný tok k dnešnému dňu:",{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":42250,"d":"42,250.00 EUR"}},null,"Toto je ročný odhad.  Tento hárok použite, ak si chcete pozrieť ročné sumy s odhadnutými mesačnými hodnotami.\nAk chcete do tabuľky pridať denné položky, odhadnite ich ročnú sumu/hodnotu a zapíšte ju do stĺpca pre ročné výdavky."]
[]
[null,"Úspory","Ročná  ","Mesačne "]
[null,"Peňažná rezerva",{"v":5000,"d":"5,000.00 EUR"},{"$f":"Úspory[[#This Row],[Ročná  ]]/12","v":{"v":416.6666666666667,"d":"416.67 EUR"}}]
[null,"401 000/iné",{"v":12000,"d":"12,000.00 EUR"},{"$f":"Úspory[[#This Row],[Ročná  ]]/12","v":{"v":1000,"d":"1,000.00 EUR"}}]
[null,"Úspory/investície",{"v":6000,"d":"6,000.00 EUR"},{"$f":"Úspory[[#This Row],[Ročná  ]]/12","v":{"v":500,"d":"500.00 EUR"}}]
[null,"Iné 1",{"v":0,"d":"0.00 EUR"},{"$f":"Úspory[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Iné 2",{"v":0,"d":"0.00 EUR"},{"$f":"Úspory[[#This Row],[Ročná  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null," Celková hodnota",{"$f":"SUBTOTAL(109,Úspory[[Ročná  ]])","v":{"v":23000,"d":"23,000.00 EUR"}},{"$f":"SUBTOTAL(109,Úspory[[Mesačne ]])","v":{"v":1916.6666666666667,"d":"1,916.67 EUR"}}]