{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Útmutató","Napi pénzforgalom","Havi pénzforgalom","Éves pénzforgalom","Bevétel","Kiadás","Választható","Megtakarítások"],"not_rendered":{"charts":4,"defined_names":35,"pivot_tables":8},"read":"whole","date_system":"1900"}

{"sheet":"Útmutató","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,7],[2,1,2,8]]}
[{"$nulls":11}," "]
[null,"SZEMÉLYES PÉNZFORGALOM"]
[null,"  Ez a munkafüzet éves, havi és napi cash flow munkalapokat tartalmaz. \n  Az Önnek leginkább megfelelő pénzforgalomtípust kiválasztva vagy az összeset felhasználva betekintést nyerhet a személyes pénzforgalmába."]
[]
[null,"Napi pénzforgalom",null,null,"Havi pénzforgalom",null,null,"Éves pénzforgalom"]
[]
[null,"Megadhatja a napi pénzforgalom becsült értékét, és ellenőrizheti a becsült havi és éves végösszegeket.  Ezzel képet kaphat az egy hónapban vagy évben várható napi pénzköltési szokásairól.",null,null,"A havi pénzforgalmát megadva vagy a fennmaradó hónapokra szóló becslést készítve megtekintheti az év egyes hónapjaira vonatkozó tervezett pénzforgalmat.",null,null,"Adjon meg egy éves cash flow összeget négy munkalapon: Bevétel, Kiadások, Választható és Megtakarítások. \nMegtekintheti a havi lebontást és az értékek összehasonlítását, és ami még fontosabb, az éves és a havi eredményeket."]

{"sheet":"Napi pénzforgalom","index":1,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[1,3,1,4],[1,5,1,8]]}
[null,"SZEMÉLYES PÉNZFORGALOM"]
[null,null,"Rendelkezésre álló készpénz összesen:",{"$f":"NapiPénzforgalom","v":{"v":577.8399999999999,"d":"577.84 Ft"}},null,"MEGJEGYZÉS: Ha napi tételeket szeretne felvenni a táblázatba, becsülje fel azok havi összegét/értékét, és írja be az értéket a megfelelő hónap oszlopába."]
[]
[null,"NAPI ÖSSZEGZÉS"]
[null,"Összesen","Napi","Havi","Éves "]
[null,"Bevétel",{"$f":"SUMIF(Napi[Típus],$B6,Napi[Napi])","v":{"v":342.47,"d":"342.47 Ft"}},{"$f":"SUMIF(Napi[Típus],$B6,Napi[Havi])","v":{"v":10416.795833333334,"d":"10,416.80 Ft"}},{"$f":"SUMIF(Napi[Típus],$B6,Napi[Éves])","v":{"v":125001.55000000002,"d":"125,001.55 Ft"}}]
[null,"Kiadás",{"$f":"SUMIF(Napi[Típus],$B7,Napi[Napi])","v":{"v":136.05999999999997,"d":"136.06 Ft"}},{"$f":"SUMIF(Napi[Típus],$B7,Napi[Havi])","v":{"v":4138.491666666667,"d":"4,138.49 Ft"}},{"$f":"SUMIF(Napi[Típus],$B7,Napi[Éves])","v":{"v":49661.899999999994,"d":"49,661.90 Ft"}}]
[null,"Választható",{"$f":"SUMIF(Napi[Típus],$B8,Napi[Napi])","v":{"v":36.29,"d":"36.29 Ft"}},{"$f":"SUMIF(Napi[Típus],$B8,Napi[Havi])","v":{"v":1103.8208333333334,"d":"1,103.82 Ft"}},{"$f":"SUMIF(Napi[Típus],$B8,Napi[Éves])","v":{"v":13245.849999999999,"d":"13,245.85 Ft"}}]
[null,"Megtakarítások",{"$f":"SUMIF(Napi[Típus],$B9,Napi[Napi])","v":{"v":63.019999999999996,"d":"63.02 Ft"}},{"$f":"SUMIF(Napi[Típus],$B9,Napi[Havi])","v":{"v":1916.8583333333333,"d":"1,916.86 Ft"}},{"$f":"SUMIF(Napi[Típus],$B9,Napi[Éves])","v":{"v":23002.300000000003,"d":"23,002.30 Ft"}}]
[]
[null,"Típus","Leírás","Napi","Havi","Éves"]
[null,"Bevétel","Fizetés",{"v":246.58,"d":"246.58 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":7500.141666666667,"d":"7,500.14 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":90001.70000000001,"d":"90,001.70 Ft"}}]
[null,"Bevétel","Jutalék/bónusz",{"v":13.7,"d":"13.70 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":416.7083333333333,"d":"416.71 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":5000.5,"d":"5,000.50 Ft"}}]
[null,"Bevétel","Egyéb 1",{"v":82.19,"d":"82.19 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":2499.945833333333,"d":"2,499.95 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":29999.35,"d":"29,999.35 Ft"}}]
[null,"Bevétel","Egyéb 2",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Bevétel","Egyéb 3",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Bevétel","Egyéb 4",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Kiadás","Társadalombiztosítás/egészségbiztosítás",{"v":41.1,"d":"41.10 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":1250.125,"d":"1,250.13 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":15001.5,"d":"15,001.50 Ft"}}]
[null,"Kiadás","Jövedelemadó",{"v":6.85,"d":"6.85 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":208.35416666666666,"d":"208.35 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":2500.25,"d":"2,500.25 Ft"}}]
[null,"Kiadás","Járműadó/díjak",{"v":0.55,"d":"0.55 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":16.729166666666668,"d":"16.73 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":200.75000000000003,"d":"200.75 Ft"}}]
[null,"Kiadás","Járműtörlesztés",{"v":10.96,"d":"10.96 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":333.3666666666667,"d":"333.37 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":4000.4,"d":"4,000.40 Ft"}}]
[null,"Kiadás","Jelzálog/bérlet",{"v":41.1,"d":"41.10 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":1250.125,"d":"1,250.13 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":15001.5,"d":"15,001.50 Ft"}}]
[null,"Kiadás","Biztosítás",{"v":0.68,"d":"0.68 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":20.683333333333334,"d":"20.68 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":248.20000000000002,"d":"248.20 Ft"}}]
[null,"Kiadás","Áram",{"v":3.29,"d":"3.29 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":100.07083333333333,"d":"100.07 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":1200.85,"d":"1,200.85 Ft"}}]
[null,"Kiadás","Gáz",{"v":1.64,"d":"1.64 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":49.883333333333326,"d":"49.88 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":598.5999999999999,"d":"598.60 Ft"}}]
[null,"Kiadás","Víz",{"v":1.64,"d":"1.64 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":49.883333333333326,"d":"49.88 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":598.5999999999999,"d":"598.60 Ft"}}]
[null,"Kiadás","Csatorna",{"v":0.82,"d":"0.82 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":24.941666666666663,"d":"24.94 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":299.29999999999995,"d":"299.30 Ft"}}]
[null,"Kiadás","Szemét",{"v":0.41,"d":"0.41 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":12.470833333333331,"d":"12.47 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":149.64999999999998,"d":"149.65 Ft"}}]
[null,"Kiadás","Telefon",{"v":1.64,"d":"1.64 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":49.883333333333326,"d":"49.88 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":598.5999999999999,"d":"598.60 Ft"}}]
[null,"Kiadás","Internet",{"v":1.64,"d":"1.64 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":49.883333333333326,"d":"49.88 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":598.5999999999999,"d":"598.60 Ft"}}]
[null,"Kiadás","Fogyatékkal élőknek szóló prémium funkciók",{"v":4.11,"d":"4.11 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":125.0125,"d":"125.01 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":1500.15,"d":"1,500.15 Ft"}}]
[null,"Kiadás","Élelmiszer",{"v":13.7,"d":"13.70 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":416.7083333333333,"d":"416.71 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":5000.5,"d":"5,000.50 Ft"}}]
[null,"Kiadás","Ruhanemű",{"v":3.29,"d":"3.29 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":100.07083333333333,"d":"100.07 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":1200.85,"d":"1,200.85 Ft"}}]
[null,"Kiadás","Orvos/fogorvos/gyógyszerek",{"v":1.64,"d":"1.64 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":49.883333333333326,"d":"49.88 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":598.5999999999999,"d":"598.60 Ft"}}]
[null,"Kiadás","Busz",{"v":1,"d":"1.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":30.416666666666668,"d":"30.42 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":365,"d":"365.00 Ft"}}]
[null,"Kiadás","Egyéb 2",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Kiadás","Egyéb 3",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Kiadás","Egyéb 4",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Választható","Étkezés",{"v":3.29,"d":"3.29 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":100.07083333333333,"d":"100.07 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":1200.85,"d":"1,200.85 Ft"}}]
[null,"Választható","Ajándékok",{"v":1.64,"d":"1.64 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":49.883333333333326,"d":"49.88 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":598.5999999999999,"d":"598.60 Ft"}}]
[null,"Választható","Utazás",{"v":6.16,"d":"6.16 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":187.36666666666667,"d":"187.37 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":2248.4,"d":"2,248.40 Ft"}}]
[null,"Választható","Szórakozás",{"v":3.29,"d":"3.29 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":100.07083333333333,"d":"100.07 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":1200.85,"d":"1,200.85 Ft"}}]
[null,"Választható","Kozmetikumok",{"v":0.82,"d":"0.82 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":24.941666666666663,"d":"24.94 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":299.29999999999995,"d":"299.30 Ft"}}]
[null,"Választható","Bevásárlás",{"v":5.48,"d":"5.48 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":166.68333333333334,"d":"166.68 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":2000.2,"d":"2,000.20 Ft"}}]
[null,"Választható","Adományok",{"v":1.64,"d":"1.64 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":49.883333333333326,"d":"49.88 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":598.5999999999999,"d":"598.60 Ft"}}]
[null,"Választható","Klubtagságok",{"v":0.82,"d":"0.82 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":24.941666666666663,"d":"24.94 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":299.29999999999995,"d":"299.30 Ft"}}]
[null,"Választható","Otthoni fejlesztések",{"v":13.15,"d":"13.15 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":399.9791666666667,"d":"399.98 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":4799.75,"d":"4,799.75 Ft"}}]
[null,"Választható","Egyéb 1",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Választható","Egyéb 2",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Megtakarítások","Készpénztartalék",{"v":13.7,"d":"13.70 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":416.7083333333333,"d":"416.71 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":5000.5,"d":"5,000.50 Ft"}}]
[null,"Megtakarítások","401(k)/Etc",{"v":32.88,"d":"32.88 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":1000.1,"d":"1,000.10 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":12001.2,"d":"12,001.20 Ft"}}]
[null,"Megtakarítások","Megtakarítási számla",{"v":16.44,"d":"16.44 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":500.05,"d":"500.05 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":6000.6,"d":"6,000.60 Ft"}}]
[null,"Megtakarítások","Egyéb 1",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Megtakarítások","Egyéb 2",{"v":0,"d":"0.00 Ft"},{"$f":"Napi[[#This Row],[Éves]]/12","v":{"v":0,"d":"0.00 Ft"}},{"$f":"Napi[[#This Row],[Napi]]*365","v":{"v":0,"d":"0.00 Ft"}}]
[null," Összeg ",null,{"$f":"SUMIF(Napi[Típus],\"Bevétel\",Napi[Napi])-SUMIF(Napi[Típus],\"<>Bevétel\",Napi[Napi])","v":{"v":107.10000000000014,"d":"107.10 Ft"}},{"$f":"SUMIF(Napi[Típus],\"Bevétel\",Napi[Havi])-SUMIF(Napi[Típus],\"<>Bevétel\",Napi[Havi])","v":{"v":3257.625,"d":"3,257.63 Ft"}},{"$f":"SUMIF(Napi[Típus],\"Bevétel\",Napi[Éves])-SUMIF(Napi[Típus],\"<>Bevétel\",Napi[Éves])","v":{"v":39091.500000000015,"d":"39,091.50 Ft"}}]

{"sheet":"Havi pénzforgalom","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[1,3,1,4],[1,5,1,10]]}
[null,"SZEMÉLYES PÉNZFORGALOM",{"$nulls":15}," "]
[null,null,"Teljes havi pénzforgalom:",{"$f":"AktuálisHaviPénzforgalom","v":{"v":18380,"d":"18,380.00 Ft"}},null,"MEGJEGYZÉS: A napi tételek esetében becsülje fel a havi összeget/értéket, és írja be az értéket a megfelelő hónap oszlopába.\n"]
[]
[null,"Típus","Leírás","Jan.","Febr.","Márc.","Ápr.","Máj.","Jún.","Júl.","Aug.","Szept.","Okt.","Nov.","Dec.","Összeg"]
[null,"Bevétel","Fizetés",{"v":7500,"d":"7,500.00 Ft"},{"v":7500,"d":"7,500.00 Ft"},{"v":7500,"d":"7,500.00 Ft"},{"v":7500,"d":"7,500.00 Ft"},{"v":7500,"d":"7,500.00 Ft"},{"v":7500,"d":"7,500.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":45000,"d":"45,000.00 Ft"}}]
[null,"Bevétel","Jutalék/bónusz",{"v":400,"d":"400.00 Ft"},{"v":400,"d":"400.00 Ft"},{"v":500,"d":"500.00 Ft"},{"v":200,"d":"200.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":600,"d":"600.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":2100,"d":"2,100.00 Ft"}}]
[null,"Bevétel","Egyéb 1",{"v":2500,"d":"2,500.00 Ft"},{"v":2500,"d":"2,500.00 Ft"},{"v":2500,"d":"2,500.00 Ft"},{"v":2500,"d":"2,500.00 Ft"},{"v":2500,"d":"2,500.00 Ft"},{"v":2500,"d":"2,500.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":15000,"d":"15,000.00 Ft"}}]
[null,"Bevétel","Egyéb 2",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Bevétel","Egyéb 3",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Bevétel","Egyéb 4",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Kiadás","Társadalombiztosítás/egészségbiztosítás",{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":7500,"d":"7,500.00 Ft"}}]
[null,"Kiadás","Jövedelemadó",{"v":208.33333333333334,"d":"208.33 Ft"},{"v":208.33333333333334,"d":"208.33 Ft"},{"v":208.33333333333334,"d":"208.33 Ft"},{"v":208.33333333333334,"d":"208.33 Ft"},{"v":208.33333333333334,"d":"208.33 Ft"},{"v":208.33333333333334,"d":"208.33 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":1250,"d":"1,250.00 Ft"}}]
[null,"Kiadás","Járműadó/díjak",{"v":16.666666666666668,"d":"16.67 Ft"},{"v":16.666666666666668,"d":"16.67 Ft"},{"v":16.666666666666668,"d":"16.67 Ft"},{"v":16.666666666666668,"d":"16.67 Ft"},{"v":16.666666666666668,"d":"16.67 Ft"},{"v":16.666666666666668,"d":"16.67 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":100.00000000000001,"d":"100.00 Ft"}}]
[null,"Kiadás","Járműtörlesztés",{"v":333.3333333333333,"d":"333.33 Ft"},{"v":333.3333333333333,"d":"333.33 Ft"},{"v":333.3333333333333,"d":"333.33 Ft"},{"v":333.3333333333333,"d":"333.33 Ft"},{"v":333.3333333333333,"d":"333.33 Ft"},{"v":333.3333333333333,"d":"333.33 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":1999.9999999999998,"d":"2,000.00 Ft"}}]
[null,"Kiadás","Jelzálog/bérlet",{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"v":1250,"d":"1,250.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":7500,"d":"7,500.00 Ft"}}]
[null,"Kiadás","Biztosítás",{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":150,"d":"150.00 Ft"}}]
[null,"Kiadás","Áram",{"v":100,"d":"100.00 Ft"},{"v":100,"d":"100.00 Ft"},{"v":100,"d":"100.00 Ft"},{"v":100,"d":"100.00 Ft"},{"v":100,"d":"100.00 Ft"},{"v":100,"d":"100.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":600,"d":"600.00 Ft"}}]
[null,"Kiadás","Gáz",{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":300,"d":"300.00 Ft"}}]
[null,"Kiadás","Víz",{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":300,"d":"300.00 Ft"}}]
[null,"Kiadás","Csatorna",{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":150,"d":"150.00 Ft"}}]
[null,"Kiadás","Szemét",{"v":12.5,"d":"12.50 Ft"},{"v":12.5,"d":"12.50 Ft"},{"v":12.5,"d":"12.50 Ft"},{"v":12.5,"d":"12.50 Ft"},{"v":12.5,"d":"12.50 Ft"},{"v":12.5,"d":"12.50 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":75,"d":"75.00 Ft"}}]
[null,"Kiadás","Telefon",{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":300,"d":"300.00 Ft"}}]
[null,"Kiadás","Internet",{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":300,"d":"300.00 Ft"}}]
[null,"Kiadás","Fogyatékkal élőknek szóló prémium funkciók",{"v":125,"d":"125.00 Ft"},{"v":125,"d":"125.00 Ft"},{"v":125,"d":"125.00 Ft"},{"v":125,"d":"125.00 Ft"},{"v":125,"d":"125.00 Ft"},{"v":125,"d":"125.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":750,"d":"750.00 Ft"}}]
[null,"Kiadás","Élelmiszer",{"v":400,"d":"400.00 Ft"},{"v":500,"d":"500.00 Ft"},{"v":450,"d":"450.00 Ft"},{"v":400,"d":"400.00 Ft"},{"v":450,"d":"450.00 Ft"},{"v":425,"d":"425.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":2625,"d":"2,625.00 Ft"}}]
[null,"Kiadás","Ruhanemű",{"v":50,"d":"50.00 Ft"},{"v":75,"d":"75.00 Ft"},{"v":100,"d":"100.00 Ft"},{"v":75,"d":"75.00 Ft"},{"v":125,"d":"125.00 Ft"},{"v":75,"d":"75.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":500,"d":"500.00 Ft"}}]
[null,"Kiadás","Orvos/fogorvos/gyógyszerek",{"v":50,"d":"50.00 Ft"},{"v":10,"d":"10.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":20,"d":"20.00 Ft"},{"v":70,"d":"70.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":200,"d":"200.00 Ft"}}]
[null,"Kiadás","Busz",{"v":30,"d":"30.00 Ft"},{"v":30,"d":"30.00 Ft"},{"v":30,"d":"30.00 Ft"},{"v":20,"d":"20.00 Ft"},{"v":30,"d":"30.00 Ft"},{"v":30,"d":"30.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":170,"d":"170.00 Ft"}}]
[null,"Kiadás","Egyéb 2",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Kiadás","Egyéb 3",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Kiadás","Egyéb 4",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Választható","Étkezés",{"v":50,"d":"50.00 Ft"},{"v":150,"d":"150.00 Ft"},{"v":100,"d":"100.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":150,"d":"150.00 Ft"},{"v":100,"d":"100.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":600,"d":"600.00 Ft"}}]
[null,"Választható","Ajándékok",{"v":25,"d":"25.00 Ft"},{"v":75,"d":"75.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":75,"d":"75.00 Ft"},{"v":50,"d":"50.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":300,"d":"300.00 Ft"}}]
[null,"Választható","Utazás",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":1000,"d":"1,000.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":1000,"d":"1,000.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":2000,"d":"2,000.00 Ft"}}]
[null,"Választható","Szórakozás",{"v":50,"d":"50.00 Ft"},{"v":150,"d":"150.00 Ft"},{"v":100,"d":"100.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":150,"d":"150.00 Ft"},{"v":100,"d":"100.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":600,"d":"600.00 Ft"}}]
[null,"Választható","Kozmetikumok",{"v":15,"d":"15.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":35,"d":"35.00 Ft"},{"v":15,"d":"15.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":35,"d":"35.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":150,"d":"150.00 Ft"}}]
[null,"Választható","Bevásárlás",{"v":100,"d":"100.00 Ft"},{"v":200,"d":"200.00 Ft"},{"v":150,"d":"150.00 Ft"},{"v":175,"d":"175.00 Ft"},{"v":150,"d":"150.00 Ft"},{"v":175,"d":"175.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":950,"d":"950.00 Ft"}}]
[null,"Választható","Adományok",{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"v":50,"d":"50.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":300,"d":"300.00 Ft"}}]
[null,"Választható","Klubtagságok",{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"v":25,"d":"25.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":150,"d":"150.00 Ft"}}]
[null,"Választható","Otthoni fejlesztések",{"v":400,"d":"400.00 Ft"},{"v":400,"d":"400.00 Ft"},{"v":400,"d":"400.00 Ft"},{"v":400,"d":"400.00 Ft"},{"v":400,"d":"400.00 Ft"},{"v":400,"d":"400.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":2400,"d":"2,400.00 Ft"}}]
[null,"Választható","Egyéb 1",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Választható","Egyéb 2",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Megtakarítások","Készpénztartalék",{"v":416.6666666666667,"d":"416.67 Ft"},{"v":416.6666666666667,"d":"416.67 Ft"},{"v":416.6666666666667,"d":"416.67 Ft"},{"v":416.6666666666667,"d":"416.67 Ft"},{"v":416.6666666666667,"d":"416.67 Ft"},{"v":416.6666666666667,"d":"416.67 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":2500,"d":"2,500.00 Ft"}}]
[null,"Megtakarítások","401(k)/Etc",{"v":1000,"d":"1,000.00 Ft"},{"v":1000,"d":"1,000.00 Ft"},{"v":1000,"d":"1,000.00 Ft"},{"v":1000,"d":"1,000.00 Ft"},{"v":1000,"d":"1,000.00 Ft"},{"v":1000,"d":"1,000.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":6000,"d":"6,000.00 Ft"}}]
[null,"Megtakarítások","Megtakarítási számla",{"v":500,"d":"500.00 Ft"},{"v":500,"d":"500.00 Ft"},{"v":500,"d":"500.00 Ft"},{"v":500,"d":"500.00 Ft"},{"v":500,"d":"500.00 Ft"},{"v":500,"d":"500.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":3000,"d":"3,000.00 Ft"}}]
[null,"Megtakarítások","Egyéb 1",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Megtakarítások","Egyéb 2",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$nulls":6},{"$f":"SUM(Havi[[#This Row],[Jan.]:[Dec.]])","v":{"v":0,"d":"0.00 Ft"}}]
[null," Összeg",null,{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Jan.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Jan.])","v":{"v":3692.5,"d":"3,692.50 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Febr.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Febr.])","v":{"v":3247.5,"d":"3,247.50 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Márc.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Márc.])","v":{"v":2522.5,"d":"2,522.50 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Ápr.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Ápr.])","v":{"v":3427.5,"d":"3,427.50 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Máj.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Máj.])","v":{"v":2887.5,"d":"2,887.50 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Jún.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Jún.])","v":{"v":2602.5,"d":"2,602.50 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Júl.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Júl.])","v":{"v":0,"d":"0.00 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Aug.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Aug.])","v":{"v":0,"d":"0.00 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Szept.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Szept.])","v":{"v":0,"d":"0.00 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Okt.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Okt.])","v":{"v":0,"d":"0.00 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Nov.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Nov.])","v":{"v":0,"d":"0.00 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Dec.])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Dec.])","v":{"v":0,"d":"0.00 Ft"}},{"$f":"SUMIF(Havi[Típus],\"Bevétel\",Havi[Összeg])-SUMIF(Havi[Típus],\"<>Bevétel\",Havi[Összeg])","v":{"v":18380,"d":"18,380.00 Ft"}}]

{"sheet":"Éves pénzforgalom","index":3,"n_rows":29,"n_cols":28,"rows_kept":29,"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]]}
["Éves pénzforgalom\nEzen a munkalapon egy éves pénzforgalmi kimutatást hozhat létre. \nA következő négy munkalapon adhatja meg az adatokat.\nA sablon a D2 cellában automatikusan kiszámítja a teljes aktuális pénzforgalmat. A diagramok frissítéséhez lépjen ide: Adatok menüszalag -> Az összes frissítése. A G2 cellában egy tipp szerepel.","SZEMÉLYES PÉNZFORGALOM",{"$nulls":14}," "]
[null,null,"Teljes eddigi pénzforgalom:",{"$f":"AktuálisÉvesPénforgalom","v":{"v":42250,"d":"42,250.00 Ft"}},null,null,"Ez egy éves becslés.  Akkor használja ezt a munkalapot, ha az éves összegeket becsült havi értékekkel szeretné megtekinteni. Az elemeket a Bevétel, a Kiadások, a Belátás és a Megtakarítás munkalapon adhatja meg."]
[]
[null,"BEVÉTELEK ÖSSZEGZÉSE",{"$nulls":3},"KIADÁSOK ÖSSZEGZÉSE",{"$nulls":3},"VÁLASZTHATÓ KIADÁSOK ÖSSZEGZÉSE",{"$nulls":3},"MEGTAKARÍTÁSOK ÖSSZEGZÉSE"]
[null,"Teljes éves:",{"$f":"Bevétel!C11","v":{"v":125000,"d":"125,000.00 Ft"}},null,null,"Teljes éves:",{"$f":"Kiadások[[#Totals],[Éves  ]]","v":{"v":46500,"d":"46,500.00 Ft"}},null,null,"Teljes éves:",{"$f":"Választható[[#Totals],[Éves  ]]","v":{"v":13250,"d":"13,250.00 Ft"}},null,null,"Teljes éves:",{"$f":"Megtakarítások[[#Totals],[Éves  ]]","v":{"v":23000,"d":"23,000.00 Ft"}}]
[]
[]
[null,"Teljes havi:",{"$f":"Bevétel!D11","v":{"v":10416.666666666668,"d":"10,416.67 Ft"}},null,null,"Teljes havi:",{"$f":"Kiadások[[#Totals],[Havi ]]","v":{"v":3875,"d":"3,875.00 Ft"}},null,null,"Teljes havi:",{"$f":"Választható[[#Totals],[Havi ]]","v":{"v":1104.1666666666665,"d":"1,104.17 Ft"}},null,null,"Teljes havi:",{"$f":"Megtakarítások!D10","v":{"v":1916.6666666666667,"d":"1,916.67 Ft"}}]
[]
[{"$nulls":17},"Row Labels","Éves bevétel",null,"Row Labels","Sum of Éves  ",null,"Row Labels","Sum of Éves  ",null,"Row Labels","Sum of Éves  "]
[{"$nulls":17},"Egyéb 3",{"v":0,"d":"0 Ft"},null,"Egyéb 1",{"v":0,"d":"0 Ft"},null,"Egyéb 1",{"v":0,"d":"0 Ft"},null,"Egyéb 1",{"v":0,"d":"0 Ft"}]
[{"$nulls":17},"Egyéb 4",{"v":0,"d":"0 Ft"},null,"Egyéb 2",{"v":0,"d":"0 Ft"},null,"Egyéb 2",{"v":0,"d":"0 Ft"},null,"Egyéb 2",{"v":0,"d":"0 Ft"}]
[{"$nulls":17},"Egyéb 2",{"v":0,"d":"0 Ft"},null,"Szemét",{"v":150,"d":"150 Ft"},null,"Klubtagságok",{"v":300,"d":"300 Ft"},null,"Készpénztartalék",{"v":5000,"d":"5,000 Ft"}]
[{"$nulls":17},"Jutalék/bónusz",{"v":5000,"d":"5,000 Ft"},null,"Járműadó/díjak",{"v":200,"d":"200 Ft"},null,"Kozmetikumok",{"v":300,"d":"300 Ft"},null,"Megtakarítás/befektetés",{"v":6000,"d":"6,000 Ft"}]
[{"$nulls":17},"Egyéb 1",{"v":30000,"d":"30,000 Ft"},null,"Biztosítás",{"v":250,"d":"250 Ft"},null,"Ajándékok",{"v":600,"d":"600 Ft"},null,"Nyugdíj-megtakarítások",{"v":12000,"d":"12,000 Ft"}]
[{"$nulls":17},"Fizetés",{"v":90000,"d":"90,000 Ft"},null,"Internet",{"v":600,"d":"600 Ft"},null,"Adományok",{"v":600,"d":"600 Ft"},null,"Grand Total",{"v":23000,"d":"23,000 Ft"}]
[{"$nulls":17},"Grand Total",{"v":125000,"d":"125,000 Ft"},null,"Gáz",{"v":600,"d":"600 Ft"},null,"Étkezés",{"v":1200,"d":"1,200 Ft"}]
[{"$nulls":20},"Telefon",{"v":600,"d":"600 Ft"},null,"Szórakozás",{"v":1200,"d":"1,200 Ft"}]
[{"$nulls":20},"Orvos/fogorvos/gyógyszerek",{"v":600,"d":"600 Ft"},null,"Bevásárlás",{"v":2000,"d":"2,000 Ft"}]
[{"$nulls":20},"Víz/csatorna",{"v":600,"d":"600 Ft"},null,"Utazás",{"v":2250,"d":"2,250 Ft"}]
[{"$nulls":20},"Áram",{"v":1200,"d":"1,200 Ft"},null,"Otthoni fejlesztések",{"v":4800,"d":"4,800 Ft"}]
[{"$nulls":20},"Ruhanemű",{"v":1200,"d":"1,200 Ft"},null,"Grand Total",{"v":13250,"d":"13,250 Ft"}]
[{"$nulls":20},"Fogyatékkal élőknek szóló prémium funkciók",{"v":1500,"d":"1,500 Ft"}]
[{"$nulls":20},"Jövedelemadó",{"v":2500,"d":"2,500 Ft"}]
[{"$nulls":20},"Járműtörlesztés",{"v":4000,"d":"4,000 Ft"}]
[{"$nulls":20},"Élelmiszer",{"v":5000,"d":"5,000 Ft"}]
[{"$nulls":20},"Társadalombiztosítás/egészségbiztosítás",{"v":12500,"d":"12,500 Ft"}]
[{"$nulls":20},"Jelzálog/bérlet",{"v":15000,"d":"15,000 Ft"}]
[{"$nulls":20},"Grand Total",{"v":46500,"d":"46,500 Ft"}]

{"sheet":"Bevétel","index":4,"n_rows":11,"n_cols":9,"rows_kept":11,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"SZEMÉLYES PÉNZFORGALOM",{"$nulls":6},"Kiadás!A1"]
[null,null,"Teljes eddigi pénzforgalom:",{"$f":"AktuálisÉvesPénforgalom","v":{"v":42250,"d":"42,250.00 Ft"}},null,"Ez egy éves becslés.  Akkor használja ezt a munkalapot, ha az éves összegeket becsült havi értékekkel szeretné megtekinteni.\nHa napi tételeket szeretne felvenni a táblázatba, becsülje fel azok éves összegét/értékét, és írja be az értéket az Éves oszlopba."]
[]
[null,"Bevétel","Éves  ","Havi "]
[null,"Fizetés",{"v":90000,"d":"90,000.00 Ft"},{"$f":"Bevétel[[#This Row],[Éves  ]]/12","v":{"v":7500,"d":"7,500.00 Ft"}}]
[null,"Jutalék/bónusz",{"v":5000,"d":"5,000.00 Ft"},{"$f":"Bevétel[[#This Row],[Éves  ]]/12","v":{"v":416.6666666666667,"d":"416.67 Ft"}}]
[null,"Egyéb 1",{"v":30000,"d":"30,000.00 Ft"},{"$f":"Bevétel[[#This Row],[Éves  ]]/12","v":{"v":2500,"d":"2,500.00 Ft"}}]
[null,"Egyéb 2",{"v":0,"d":"0.00 Ft"},{"$f":"Bevétel[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Egyéb 3",{"v":0,"d":"0.00 Ft"},{"$f":"Bevétel[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Egyéb 4",{"v":0,"d":"0.00 Ft"},{"$f":"Bevétel[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null," Összeg",{"$f":"SUBTOTAL(109,Bevétel[[Éves  ]])","v":{"v":125000,"d":"125,000.00 Ft"}},{"$f":"SUBTOTAL(109,Bevétel[[Havi ]])","v":{"v":10416.666666666668,"d":"10,416.67 Ft"}}]

{"sheet":"Kiadás","index":5,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"SZEMÉLYES PÉNZFORGALOM",{"$nulls":5},"Kiadás!A1"]
[null,null,"Teljes eddigi pénzforgalom:",{"$f":"AktuálisÉvesPénforgalom","v":{"v":42250,"d":"42,250.00 Ft"}},null,"Ez egy éves becslés.  Akkor használja ezt a munkalapot, ha az éves összegeket becsült havi értékekkel szeretné megtekinteni.\nHa napi tételeket szeretne felvenni a táblázatba, becsülje fel azok éves összegét/értékét, és írja be az értéket az Éves oszlopba."]
[]
[null,"Kiadások","Éves  ","Havi "]
[null,"Társadalombiztosítás/egészségbiztosítás",{"v":12500,"d":"12,500.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":1041.6666666666667,"d":"1,041.67 Ft"}}]
[null,"Jövedelemadó",{"v":2500,"d":"2,500.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":208.33333333333334,"d":"208.33 Ft"}}]
[null,"Járműadó/díjak",{"v":200,"d":"200.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":16.666666666666668,"d":"16.67 Ft"}}]
[null,"Járműtörlesztés",{"v":4000,"d":"4,000.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":333.3333333333333,"d":"333.33 Ft"}}]
[null,"Jelzálog/bérlet",{"v":15000,"d":"15,000.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":1250,"d":"1,250.00 Ft"}}]
[null,"Biztosítás",{"v":250,"d":"250.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":20.833333333333332,"d":"20.83 Ft"}}]
[null,"Áram",{"v":1200,"d":"1,200.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":100,"d":"100.00 Ft"}}]
[null,"Gáz",{"v":600,"d":"600.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":50,"d":"50.00 Ft"}}]
[null,"Víz/csatorna",{"v":600,"d":"600.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":50,"d":"50.00 Ft"}}]
[null,"Szemét",{"v":150,"d":"150.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":12.5,"d":"12.50 Ft"}}]
[null,"Telefon",{"v":600,"d":"600.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":50,"d":"50.00 Ft"}}]
[null,"Internet",{"v":600,"d":"600.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":50,"d":"50.00 Ft"}}]
[null,"Fogyatékkal élőknek szóló prémium funkciók",{"v":1500,"d":"1,500.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":125,"d":"125.00 Ft"}}]
[null,"Élelmiszer",{"v":5000,"d":"5,000.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":416.6666666666667,"d":"416.67 Ft"}}]
[null,"Ruhanemű",{"v":1200,"d":"1,200.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":100,"d":"100.00 Ft"}}]
[null,"Orvos/fogorvos/gyógyszerek",{"v":600,"d":"600.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":50,"d":"50.00 Ft"}}]
[null,"Egyéb 1",{"v":0,"d":"0.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Egyéb 2",{"v":0,"d":"0.00 Ft"},{"$f":"Kiadások[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null," Összeg",{"$f":"SUBTOTAL(109,Kiadások[[Éves  ]])","v":{"v":46500,"d":"46,500.00 Ft"}},{"$f":"SUBTOTAL(109,Kiadások[[Havi ]])","v":{"v":3875,"d":"3,875.00 Ft"}}]

{"sheet":"Választható","index":6,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"SZEMÉLYES PÉNZFORGALOM",{"$nulls":4},"Kiadás!A1"]
[null,null,"Teljes eddigi pénzforgalom:",{"$f":"AktuálisÉvesPénforgalom","v":{"v":42250,"d":"42,250.00 Ft"}},null,"Ez egy éves becslés.  Akkor használja ezt a munkalapot, ha az éves összegeket becsült havi értékekkel szeretné megtekinteni.\nHa napi tételeket szeretne felvenni a táblázatba, becsülje fel azok éves összegét/értékét, és írja be az értéket az Éves oszlopba."]
[]
[null,"Kiadások","Éves  ","Havi "]
[null,"Étkezés",{"v":1200,"d":"1,200.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":100,"d":"100.00 Ft"}}]
[null,"Ajándékok",{"v":600,"d":"600.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":50,"d":"50.00 Ft"}}]
[null,"Utazás",{"v":2250,"d":"2,250.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":187.5,"d":"187.50 Ft"}}]
[null,"Szórakozás",{"v":1200,"d":"1,200.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":100,"d":"100.00 Ft"}}]
[null,"Kozmetikumok",{"v":300,"d":"300.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":25,"d":"25.00 Ft"}}]
[null,"Bevásárlás",{"v":2000,"d":"2,000.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":166.66666666666666,"d":"166.67 Ft"}}]
[null,"Adományok",{"v":600,"d":"600.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":50,"d":"50.00 Ft"}}]
[null,"Klubtagságok",{"v":300,"d":"300.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":25,"d":"25.00 Ft"}}]
[null,"Otthoni fejlesztések",{"v":4800,"d":"4,800.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":400,"d":"400.00 Ft"}}]
[null,"Egyéb 1",{"v":0,"d":"0.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Egyéb 2",{"v":0,"d":"0.00 Ft"},{"$f":"Választható[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null," Összeg",{"$f":"SUBTOTAL(109,Választható[[Éves  ]])","v":{"v":13250,"d":"13,250.00 Ft"}},{"$f":"SUBTOTAL(109,Választható[[Havi ]])","v":{"v":1104.1666666666665,"d":"1,104.17 Ft"}}]

{"sheet":"Megtakarítások","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"SZEMÉLYES PÉNZFORGALOM",{"$nulls":7}," "]
[null,null,"Teljes eddigi pénzforgalom:",{"$f":"AktuálisÉvesPénforgalom","v":{"v":42250,"d":"42,250.00 Ft"}},null,"Ez egy éves becslés.  Akkor használja ezt a munkalapot, ha az éves összegeket becsült havi értékekkel szeretné megtekinteni.\nHa napi tételeket szeretne felvenni a táblázatba, becsülje fel azok éves összegét/értékét, és írja be az értéket az Éves oszlopba."]
[]
[null,"Megtakarítások","Éves  ","Havi "]
[null,"Készpénztartalék",{"v":5000,"d":"5,000.00 Ft"},{"$f":"Megtakarítások[[#This Row],[Éves  ]]/12","v":{"v":416.6666666666667,"d":"416.67 Ft"}}]
[null,"Nyugdíj-megtakarítások",{"v":12000,"d":"12,000.00 Ft"},{"$f":"Megtakarítások[[#This Row],[Éves  ]]/12","v":{"v":1000,"d":"1,000.00 Ft"}}]
[null,"Megtakarítás/befektetés",{"v":6000,"d":"6,000.00 Ft"},{"$f":"Megtakarítások[[#This Row],[Éves  ]]/12","v":{"v":500,"d":"500.00 Ft"}}]
[null,"Egyéb 1",{"v":0,"d":"0.00 Ft"},{"$f":"Megtakarítások[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Egyéb 2",{"v":0,"d":"0.00 Ft"},{"$f":"Megtakarítások[[#This Row],[Éves  ]]/12","v":{"v":0,"d":"0.00 Ft"}}]
[null," Összeg",{"$f":"SUBTOTAL(109,Megtakarítások[[Éves  ]])","v":{"v":23000,"d":"23,000.00 Ft"}},{"$f":"SUBTOTAL(109,Megtakarítások[[Havi ]])","v":{"v":1916.6666666666667,"d":"1,916.67 Ft"}}]