{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Készpénzforgalom","Havi bevétel","Havi kiadás","Diagramadatok"],"not_rendered":{"charts":1,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Készpénzforgalom","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," Családnév"]
[null,"Családi költségvetés"]
[null,{"$f":"\" A következő hónapra: \" & TEXT(TODAY(),\"hhhh éééé\")","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"Készpénzforgalom-elemzés"]
[]
[]
[null," ","Tervezett","Tényleges","Különbség"]
[{"$f":"Bevétel[[#Totals],[Különbség]]","v":300},"Összes bevétel",{"$f":"Bevétel[[#Totals],[Tervezett]]","v":{"v":5700,"d":"5,700 Ft"}},{"$f":"Bevétel[[#Totals],[Tényleges]]","v":{"v":6000,"d":"6,000 Ft"}},{"$f":"A12","v":{"v":300,"d":"300 Ft"}}]
[{"$f":"Kiadások[[#Totals],[Különbség]]","v":-52},"Összes kiadás",{"$f":"Kiadások[[#Totals],[Tervezett]]","v":{"v":3603,"d":"3,603 Ft"}},{"$f":"Kiadások[[#Totals],[Tényleges]]","v":{"v":3655,"d":"3,655 Ft"}},{"$f":"A13","v":{"v":-52,"d":"-52 Ft"}}]
[null,"Összes készpénz",{"$f":"C12-C13","v":{"v":2097,"d":"2,097 Ft"}},{"$f":"D12-D13","v":{"v":2345,"d":"2,345 Ft"}},{"$f":"SUBTOTAL(109,Készpénzforgalom[Különbség])","v":{"v":248,"d":"248 Ft"}}]

{"sheet":"Havi bevétel","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"Havi bevétel"]
[]
[]
[null," ","Tervezett","Tényleges","Különbség"]
[null,"Bevétel 1",{"v":4000,"d":"4,000.00 Ft"},{"v":4000,"d":"4,000.00 Ft"},{"$f":"Bevétel[[#This Row],[Tényleges]]-Bevétel[[#This Row],[Tervezett]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Bevétel 2",{"v":1400,"d":"1,400.00 Ft"},{"v":1500,"d":"1,500.00 Ft"},{"$f":"Bevétel[[#This Row],[Tényleges]]-Bevétel[[#This Row],[Tervezett]]","v":{"v":100,"d":"100.00 Ft"}}]
[null,"Egyéb bevétel",{"v":300,"d":"300.00 Ft"},{"v":500,"d":"500.00 Ft"},{"$f":"Bevétel[[#This Row],[Tényleges]]-Bevétel[[#This Row],[Tervezett]]","v":{"v":200,"d":"200.00 Ft"}}]
[null,"Összes bevétel",{"$f":"SUBTOTAL(109,Bevétel[Tervezett])","v":{"v":5700,"d":"5,700.00 Ft"}},{"$f":"SUBTOTAL(109,Bevétel[Tényleges])","v":{"v":6000,"d":"6,000.00 Ft"}},{"$f":"SUBTOTAL(109,Bevétel[Különbség])","v":{"v":300,"d":"300.00 Ft"}}]

{"sheet":"Havi kiadás","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"Havi kiadás"]
[]
[]
[null," ","Tervezett","Tényleges","Különbség"]
[null,"Lakás",{"v":1500,"d":"1,500.00 Ft"},{"v":1500,"d":"1,500.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Élelmiszer",{"v":250,"d":"250.00 Ft"},{"v":280,"d":"280.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":-30,"d":"-30.00 Ft"}}]
[null,"Telefon",{"v":38,"d":"38.00 Ft"},{"v":38,"d":"38.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Áram/gáz",{"v":65,"d":"65.00 Ft"},{"v":78,"d":"78.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":-13,"d":"-13.00 Ft"}}]
[null,"Víz/csatorna/szemét",{"v":25,"d":"25.00 Ft"},{"v":21,"d":"21.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":4,"d":"4.00 Ft"}}]
[null,"Kábeltévé",{"v":75,"d":"75.00 Ft"},{"v":83,"d":"83.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":-8,"d":"-8.00 Ft"}}]
[null,"Internet",{"v":60,"d":"60.00 Ft"},{"v":60,"d":"60.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Karbantartás/javítások",{"v":0,"d":"0.00 Ft"},{"v":60,"d":"60.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":-60,"d":"-60.00 Ft"}}]
[null,"Gyermekgondozás",{"v":180,"d":"180.00 Ft"},{"v":150,"d":"150.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":30,"d":"30.00 Ft"}}]
[null,"Tandíj",{"v":250,"d":"250.00 Ft"},{"v":250,"d":"250.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Társállatok",{"v":75,"d":"75.00 Ft"},{"v":80,"d":"80.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":-5,"d":"-5.00 Ft"}}]
[null,"Közlekedés",{"v":280,"d":"280.00 Ft"},{"v":260,"d":"260.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":20,"d":"20.00 Ft"}}]
[null,"Kozmetikumok",{"v":75,"d":"75.00 Ft"},{"v":65,"d":"65.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":10,"d":"10.00 Ft"}}]
[null,"Biztosítás",{"v":255,"d":"255.00 Ft"},{"v":255,"d":"255.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Hitelkártyák",{"v":100,"d":"100.00 Ft"},{"v":100,"d":"100.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Hitelek",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Adók",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Ajándékok/adományok",{"v":150,"d":"150.00 Ft"},{"v":150,"d":"150.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Megtakarítások",{"v":225,"d":"225.00 Ft"},{"v":225,"d":"225.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Egyéb",{"v":0,"d":"0.00 Ft"},{"v":0,"d":"0.00 Ft"},{"$f":"Kiadások[[#This Row],[Tervezett]]-Kiadások[[#This Row],[Tényleges]]","v":{"v":0,"d":"0.00 Ft"}}]
[null,"Összeg",{"$f":"SUBTOTAL(109,Kiadások[Tervezett])","v":{"v":3603,"d":"3,603.00 Ft"}},{"$f":"SUBTOTAL(109,Kiadások[Tényleges])","v":{"v":3655,"d":"3,655.00 Ft"}},{"$f":"SUBTOTAL(109,Kiadások[Különbség])","v":{"v":-52,"d":"-52.00 Ft"}}]

{"sheet":"Diagramadatok","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Diagramadatok"]
[]
[null,null,"Tervezett","Tényleges"]
[null,"Havi bevétel",{"$f":"Bevétel[[#Totals],[Tervezett]]","v":5700},{"$f":"Bevétel[[#Totals],[Tényleges]]","v":6000}]
[null,"Havi kiadás",{"$f":"Kiadások[[#Totals],[Tervezett]]","v":3603},{"$f":"Kiadások[[#Totals],[Tényleges]]","v":3655}]
[null,"Készpénzforgalom",{"$f":"Készpénzforgalom[[#Totals],[Tervezett]]","v":2097},{"$f":"Készpénzforgalom[[#Totals],[Tényleges]]","v":2345}]