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

{"sheet":"Príručka","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[{"$nulls":6},"PRÍRUČKA","PRÍJEM"]
[null,"OSOBNÝ PEŇAŽNÝ TOK"]
[null,"Tento zošit obsahuje hárky pre ročný, mesačný a denný peňažný tok.  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,"Ročný peňažný tok",null,"Mesačný peňažný tok",null,"Denný peňažný tok"]
[null,"Zadajte sumy ročného peňažného toku v rámci rôznych oblastí. Pozrite si mesačný rozpis aj porovnania, ale hlavne si pozrite konečné súčty ročných aj mesačných čísel.",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,"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."]

{"sheet":"Ročný peňažný tok","index":1,"n_rows":6,"n_cols":15,"rows_kept":6,"merged":[[0,1,0,5],[0,7,0,8],[1,1,1,2],[1,3,1,5],[1,6,1,15],[2,1,2,3],[2,5,2,7],[2,9,2,11],[2,13,2,15],[3,2,3,3],[3,6,3,7],[3,10,3,11],[3,14,3,15],[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":4},"PRÍRUČKA","ROČNÝ PEŇAŽNÝ TOK",null,"MESAČNÝ \nPEŇAŽNÝ TOK"]
[null,"Celkový peňažný tok k dnešnému dňu:",null,{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":39750,"d":"39,750.00 €"}},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. Denné položky môžete pridať na ďalších hárkoch."]
[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íjem!C10","v":{"v":125000,"d":"125,000.00 €"}},null,null,"Celkovo za rok:",{"$f":"Výdavky[[#Totals],[Ročne  ]]","v":{"v":49000,"d":"49,000.00 €"}},null,null,"Celkovo za rok:",{"$f":"NepovinnéVýdavky[[#Totals],[Ročne  ]]","v":{"v":13250,"d":"13,250.00 €"}},null,null,"Celkovo za rok:",{"$f":"Úspory[[#Totals],[Ročne  ]]","v":{"v":23000,"d":"23,000.00 €"}}]
[null,"V tejto bunke sa nachádza koláčový graf zobrazujúci príjem z rôznych zdrojov.",{"$nulls":3},"V tejto bunke sa nachádza koláčový graf zobrazujúci výdavky.",{"$nulls":3},"V tejto bunke sa nachádza koláčový graf zobrazujúci nepovinné výdavky.",{"$nulls":3},"V tejto bunke sa nachádza koláčový graf zobrazujúci úspory a investície."]
[null,"Celkovo za mesiac:",{"$f":"Príjem!D10","v":{"v":10416.666666666668,"d":"10,416.67 €"}},null,null,"Celkovo za mesiac:",{"$f":"Výdavky[[#Totals],[Mesačne ]]","v":{"v":4083.333333333333,"d":"4,083.33 €"}},null,null,"Celkovo za mesiac:",{"$f":"NepovinnéVýdavky[[#Totals],[Mesačne ]]","v":{"v":1104.1666666666665,"d":"1,104.17 €"}},null,null,"Celkovo za mesiac:",{"$f":"Úspory!D9","v":{"v":1916.6666666666667,"d":"1,916.67 €"}}]

{"sheet":"Mesačný peňažný tok","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,15],[47,1,47,15]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":5},"PRÍRUČKA","ROČNÝ \nPEŇAŽNÝ TOK","MESAČNÝ PEŇAŽNÝ TOK","DENNÝ SÚHRN"]
[null,"Celkový mesačný peňažný tok:",null,{"$f":"MesačnýPeňažnýTokKDátumu","v":{"v":18380,"d":"18,380.00 €"}},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."]
[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 €"},{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":45000,"d":"45,000.00 €"}}]
[null,"Príjmy","Provízie/prémie",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2100,"d":"2,100.00 €"}}]
[null,"Príjmy","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":15000,"d":"15,000.00 €"}}]
[null,"Príjmy","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Príjmy","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Príjmy","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Výdavky","Zdravotná starostlivosť/leká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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Výdavky","Štátna daň z príjmu",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":1250,"d":"1,250.00 €"}}]
[null,"Výdavky","Poplatky/dane za automobil",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":100.00000000000001,"d":"100.00 €"}}]
[null,"Výdavky","Platby za automobil",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":1999.9999999999998,"d":"2,000.00 €"}}]
[null,"Výdavky","Hypotéka/nájomné",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Výdavky","Poistenie",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Výdavky","Elektrina",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Výdavky","Plyn",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Výdavky","Voda",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Výdavky","Kanalizácia",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Výdavky","Odpad",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":75,"d":"75.00 €"}}]
[null,"Výdavky","Telefón",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Výdavky","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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Výdavky","Životné poistenie/poistenie pre prípad invalidity",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":750,"d":"750.00 €"}}]
[null,"Výdavky","Strava",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2625,"d":"2,625.00 €"}}]
[null,"Výdavky","Oblečenie",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":500,"d":"500.00 €"}}]
[null,"Výdavky","Zdravotná starostlivosť/zubár/RTG",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":200,"d":"200.00 €"}}]
[null,"Výdavky","Autobus",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":170,"d":"170.00 €"}}]
[null,"Výdavky","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Výdavky","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Výdavky","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Nepovinné výdavky","Obedy",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Nepovinné výdavky","Dary",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Nepovinné výdavky","Cestovanie",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2000,"d":"2,000.00 €"}}]
[null,"Nepovinné výdavky","Zábava",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Nepovinné výdavky","Osobná starostlivosť",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Nepovinné výdavky","Nákupy",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":950,"d":"950.00 €"}}]
[null,"Nepovinné výdavky","Charita",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Nepovinné výdavky","Členstvá v kluboch",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Nepovinné výdavky","Opravy v domácnosti",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2400,"d":"2,400.00 €"}}]
[null,"Nepovinné výdavky","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Nepovinné výdavky","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Úspory","Peňažná rezerva",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":2500,"d":"2,500.00 €"}}]
[null,"Úspory","401 000/iné",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":6000,"d":"6,000.00 €"}}]
[null,"Úspory","Úspory/investície",{"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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":3000,"d":"3,000.00 €"}}]
[null,"Úspory","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Úspory","Iné 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(Mesačne[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 €"}}]
[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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}},{"$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 €"}}]

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

{"sheet":"Príjem","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":3},"PRÍRUČKA","DENNÝ SÚHRN","PRÍJEM","VÝDAVKY"]
[null,"Celkový peňažný tok k dnešnému dňu:",null,{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":39750,"d":"39,750.00 €"}},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čne  ","Mesačne "]
[null,"Mzda",{"v":90000,"d":"90,000.00 €"},{"$f":"Príjmy[[#This Row],[Ročne  ]]/12","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Provízie/prémie",{"v":5000,"d":"5,000.00 €"},{"$f":"Príjmy[[#This Row],[Ročne  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Iné 1",{"v":30000,"d":"30,000.00 €"},{"$f":"Príjmy[[#This Row],[Ročne  ]]/12","v":{"v":2500,"d":"2,500.00 €"}}]
[null,"Iné 2",null,{"$f":"Príjmy[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Iné 3",null,{"$f":"Príjmy[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Iné 4",null,{"$f":"Príjmy[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null," Celková hodnota",{"$f":"SUBTOTAL(109,Príjmy[[Ročne  ]])","v":{"v":125000,"d":"125,000.00 €"}},{"$f":"SUBTOTAL(109,Príjmy[[Mesačne ]])","v":{"v":10416.666666666668,"d":"10,416.67 €"}}]

{"sheet":"Výdavky","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":3},"PRÍRUČKA","PRÍJEM","VÝDAVKY","NEPOVINNÉ VÝDAVKY"]
[null,"Celkový peňažný tok k dnešnému dňu:",null,{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":39750,"d":"39,750.00 €"}},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čne  ","Mesačne "]
[null,"Zdravotná starostlivosť/lekár",{"v":15000,"d":"15,000.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":1250,"d":"1,250.00 €"}}]
[null,"Štátna daň z príjmu",{"v":2500,"d":"2,500.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":208.33333333333334,"d":"208.33 €"}}]
[null,"Poplatky/dane za automobil",{"v":200,"d":"200.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":16.666666666666668,"d":"16.67 €"}}]
[null,"Platby za automobil",{"v":4000,"d":"4,000.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":333.3333333333333,"d":"333.33 €"}}]
[null,"Hypotéka/nájomné",{"v":15000,"d":"15,000.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":1250,"d":"1,250.00 €"}}]
[null,"Poistenie",{"v":250,"d":"250.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":20.833333333333332,"d":"20.83 €"}}]
[null,"Elektrina",{"v":1200,"d":"1,200.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Plyn",{"v":600,"d":"600.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Voda/kanalizácia",{"v":600,"d":"600.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Odpad",{"v":150,"d":"150.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":12.5,"d":"12.50 €"}}]
[null,"Telefón",{"v":600,"d":"600.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Internet",{"v":600,"d":"600.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Životné poistenie/poistenie pre prípad invalidity",{"v":1500,"d":"1,500.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":125,"d":"125.00 €"}}]
[null,"Strava",{"v":5000,"d":"5,000.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Oblečenie",{"v":1200,"d":"1,200.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Zdravotná starostlivosť/zubár/RTG",{"v":600,"d":"600.00 €"},{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Iné 1",null,{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Iné 2",null,{"$f":"Výdavky[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null," Celková hodnota",{"$f":"SUBTOTAL(109,Výdavky[[Ročne  ]])","v":{"v":49000,"d":"49,000.00 €"}},{"$f":"SUBTOTAL(109,Výdavky[[Mesačne ]])","v":{"v":4083.333333333333,"d":"4,083.33 €"}}]

{"sheet":"Nepovinné výdavky","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":3},"PRÍRUČKA","VÝDAVKY","NEPOVINNÉ VÝDAVKY","ÚSPORY"]
[null,"Celkový peňažný tok k dnešnému dňu:",null,{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":39750,"d":"39,750.00 €"}},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čne  ","Mesačne "]
[null,"Obedy",{"v":1200,"d":"1,200.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Dary",{"v":600,"d":"600.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Cestovanie",{"v":2250,"d":"2,250.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":187.5,"d":"187.50 €"}}]
[null,"Zábava",{"v":1200,"d":"1,200.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Osobná starostlivosť",{"v":300,"d":"300.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":25,"d":"25.00 €"}}]
[null,"Nákupy",{"v":2000,"d":"2,000.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":166.66666666666666,"d":"166.67 €"}}]
[null,"Charita",{"v":600,"d":"600.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Členstvá v kluboch",{"v":300,"d":"300.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":25,"d":"25.00 €"}}]
[null,"Opravy v domácnosti",{"v":4800,"d":"4,800.00 €"},{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":400,"d":"400.00 €"}}]
[null,"Iné 1",null,{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Iné 2",null,{"$f":"NepovinnéVýdavky[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null," Celková hodnota",{"$f":"SUBTOTAL(109,NepovinnéVýdavky[[Ročne  ]])","v":{"v":13250,"d":"13,250.00 €"}},{"$f":"SUBTOTAL(109,NepovinnéVýdavky[[Mesačne ]])","v":{"v":1104.1666666666665,"d":"1,104.17 €"}}]

{"sheet":"Úspory","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"OSOBNÝ PEŇAŽNÝ TOK",{"$nulls":3},"PRÍRUČKA","NEPOVINNÉ VÝDAVKY","ÚSPORY"]
[null,"Celkový peňažný tok k dnešnému dňu:",null,{"$f":"RočnýPeňažnýTokKDátumu","v":{"v":39750,"d":"39,750.00 €"}},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čne  ","Mesačne "]
[null,"Peňažná rezerva",{"v":5000,"d":"5,000.00 €"},{"$f":"Úspory[[#This Row],[Ročne  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"401 000/iné",{"v":12000,"d":"12,000.00 €"},{"$f":"Úspory[[#This Row],[Ročne  ]]/12","v":{"v":1000,"d":"1,000.00 €"}}]
[null,"Úspory/investície",{"v":6000,"d":"6,000.00 €"},{"$f":"Úspory[[#This Row],[Ročne  ]]/12","v":{"v":500,"d":"500.00 €"}}]
[null,"Iné 1",null,{"$f":"Úspory[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Iné 2",null,{"$f":"Úspory[[#This Row],[Ročne  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null," Celková hodnota",{"$f":"SUBTOTAL(109,Úspory[[Ročne  ]])","v":{"v":23000,"d":"23,000.00 €"}},{"$f":"SUBTOTAL(109,Úspory[[Mesačne ]])","v":{"v":1916.6666666666667,"d":"1,916.67 €"}}]