{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Persönliches Budget"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Persönliches Budget","index":0,"n_rows":92,"n_cols":14,"rows_kept":92,"merged":[[0,0,0,13],[5,0,5,13],[10,0,10,13],[11,0,11,13],[21,0,21,13],[29,0,29,13],[37,0,37,13],[43,0,43,13],[52,0,52,13],[60,0,60,13],[66,0,66,13],[75,0,75,13],[82,0,82,13],[89,0,89,13]]}
["Persönliches Budget"]
[]
[null,"Jan","Feb","März","April","Mai","Juni","Juli","Aug","Sep","Okt","Nov","Dez","Jahr"]
["Gesamtausgaben",{"$f":"SUM(B21,B29,B37,B43,B52,B60,B66,B75,B82,B89,B92)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B4:M4)","v":0}]
["Kassendefizit/-überschuss",{"$f":"SUM(B10-B4)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B5:M5)","v":0}]
["Einnahmen"]
["Löhne",{"$nulls":12},{"$f":"SUM(Table1[[#This Row],[Column2]:[Column13]])","v":0}]
["Zinsen/Dividenden",{"$nulls":12},{"$f":"SUM(Table1[[#This Row],[Column2]:[Column13]])","v":0}]
["Verschiedenes",{"$nulls":12},{"$f":"SUM(Table1[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table1[Column2])","v":0},{"$f":"SUBTOTAL(109,Table1[Column3])","v":0},{"$f":"SUBTOTAL(109,Table1[Column4])","v":0},{"$f":"SUBTOTAL(109,Table1[Column5])","v":0},{"$f":"SUBTOTAL(109,Table1[Column6])","v":0},{"$f":"SUBTOTAL(109,Table1[Column7])","v":0},{"$f":"SUBTOTAL(109,Table1[Column8])","v":0},{"$f":"SUBTOTAL(109,Table1[Column9])","v":0},{"$f":"SUBTOTAL(109,Table1[Column10])","v":0},{"$f":"SUBTOTAL(109,Table1[Column11])","v":0},{"$f":"SUBTOTAL(109,Table1[Column12])","v":0},{"$f":"SUBTOTAL(109,Table1[Column13])","v":0},{"$f":"SUBTOTAL(109,Table1[Column14])","v":0}]
["Ausgaben"]
["Start"]
["Hypothek/Miete",{"$nulls":12},{"$f":"SUM(Table2[[#This Row],[Column2]:[Column13]])","v":0}]
["Betriebsmittel",{"$nulls":12},{"$f":"SUM(Table2[[#This Row],[Column2]:[Column13]])","v":0}]
["Festnetzanschluss",{"$nulls":12},{"$f":"SUM(Table2[[#This Row],[Column2]:[Column13]])","v":0}]
["Mobiltelefon",{"$nulls":12},{"$f":"SUM(Table2[[#This Row],[Column2]:[Column13]])","v":0}]
["Reparaturen in Haus und Wohnung",{"$nulls":12},{"$f":"SUM(Table2[[#This Row],[Column2]:[Column13]])","v":0}]
["Wohnungsmodernisierung",{"$nulls":12},{"$f":"SUM(Table2[[#This Row],[Column2]:[Column13]])","v":0}]
["Sicherheitsanlagen",{"$nulls":12},{"$f":"SUM(Table2[[#This Row],[Column2]:[Column13]])","v":0}]
["Gartencenter",{"$nulls":12},{"$f":"SUM(Table2[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table2[Column2])","v":0},{"$f":"SUBTOTAL(109,Table2[Column3])","v":0},{"$f":"SUBTOTAL(109,Table2[Column4])","v":0},{"$f":"SUBTOTAL(109,Table2[Column5])","v":0},{"$f":"SUBTOTAL(109,Table2[Column6])","v":0},{"$f":"SUBTOTAL(109,Table2[Column7])","v":0},{"$f":"SUBTOTAL(109,Table2[Column8])","v":0},{"$f":"SUBTOTAL(109,Table2[Column9])","v":0},{"$f":"SUBTOTAL(109,Table2[Column10])","v":0},{"$f":"SUBTOTAL(109,Table2[Column11])","v":0},{"$f":"SUBTOTAL(109,Table2[Column12])","v":0},{"$f":"SUBTOTAL(109,Table2[Column13])","v":0},{"$f":"SUBTOTAL(109,Table2[Column14])","v":0}]
["Alltägliche Ausgaben"]
["Lebensmittel ",{"$nulls":12},{"$f":"SUM(Table3[[#This Row],[Column2]:[Column13]])","v":0}]
["Babysitter",{"$nulls":12},{"$f":"SUM(Table3[[#This Row],[Column2]:[Column13]])","v":0}]
["Chemische Reinigung",{"$nulls":12},{"$f":"SUM(Table3[[#This Row],[Column2]:[Column13]])","v":0}]
["Restaurantbesuche",{"$nulls":12},{"$f":"SUM(Table3[[#This Row],[Column2]:[Column13]])","v":0}]
["Hausreinigungsdienst",{"$nulls":12},{"$f":"SUM(Table3[[#This Row],[Column2]:[Column13]])","v":0}]
["Hundeausführer",{"$nulls":12},{"$f":"SUM(Table3[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table3[Column2])","v":0},{"$f":"SUBTOTAL(109,Table3[Column3])","v":0},{"$f":"SUBTOTAL(109,Table3[Column4])","v":0},{"$f":"SUBTOTAL(109,Table3[Column5])","v":0},{"$f":"SUBTOTAL(109,Table3[Column6])","v":0},{"$f":"SUBTOTAL(109,Table3[Column7])","v":0},{"$f":"SUBTOTAL(109,Table3[Column8])","v":0},{"$f":"SUBTOTAL(109,Table3[Column9])","v":0},{"$f":"SUBTOTAL(109,Table3[Column10])","v":0},{"$f":"SUBTOTAL(109,Table3[Column11])","v":0},{"$f":"SUBTOTAL(109,Table3[Column12])","v":0},{"$f":"SUBTOTAL(109,Table3[Column13])","v":0},{"$f":"SUBTOTAL(109,Table3[Column14])","v":0}]
["Fahrten"]
["Kraftstoffe/Brennstoffe",{"$nulls":12},{"$f":"SUM(Table4[[#This Row],[Column2]:[Column13]])","v":0}]
["Versicherung",{"$nulls":12},{"$f":"SUM(Table4[[#This Row],[Column2]:[Column13]])","v":0}]
["Reparaturen",{"$nulls":12},{"$f":"SUM(Table4[[#This Row],[Column2]:[Column13]])","v":0}]
["Autowäsche/Dienstleistungen (detailliert)",{"$nulls":12},{"$f":"SUM(Table4[[#This Row],[Column2]:[Column13]])","v":0}]
["Parkplatz",{"$nulls":12},{"$f":"SUM(Table4[[#This Row],[Column2]:[Column13]])","v":0}]
["Öffentlicher Verkehr",{"$nulls":12},{"$f":"SUM(Table4[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table4[Column2])","v":0},{"$f":"SUBTOTAL(109,Table4[Column3])","v":0},{"$f":"SUBTOTAL(109,Table4[Column4])","v":0},{"$f":"SUBTOTAL(109,Table4[Column5])","v":0},{"$f":"SUBTOTAL(109,Table4[Column6])","v":0},{"$f":"SUBTOTAL(109,Table4[Column7])","v":0},{"$f":"SUBTOTAL(109,Table4[Column8])","v":0},{"$f":"SUBTOTAL(109,Table4[Column9])","v":0},{"$f":"SUBTOTAL(109,Table4[Column10])","v":0},{"$f":"SUBTOTAL(109,Table4[Column11])","v":0},{"$f":"SUBTOTAL(109,Table4[Column12])","v":0},{"$f":"SUBTOTAL(109,Table4[Column13])","v":0},{"$f":"SUBTOTAL(109,Table4[Column14])","v":0}]
["Unterhaltung"]
["Kabelfernsehen",{"$nulls":12},{"$f":"SUM(Table5[[#This Row],[Column2]:[Column13]])","v":0}]
["Video-/DVD-Ausleihe",{"$nulls":12},{"$f":"SUM(Table5[[#This Row],[Column2]:[Column13]])","v":0}]
["Kino/Theater",{"$nulls":12},{"$f":"SUM(Table5[[#This Row],[Column2]:[Column13]])","v":0}]
["Konzerte/Clubs",{"$nulls":12},{"$f":"SUM(Table5[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table5[Column2])","v":0},{"$f":"SUBTOTAL(109,Table5[Column3])","v":0},{"$f":"SUBTOTAL(109,Table5[Column4])","v":0},{"$f":"SUBTOTAL(109,Table5[Column5])","v":0},{"$f":"SUBTOTAL(109,Table5[Column6])","v":0},{"$f":"SUBTOTAL(109,Table5[Column7])","v":0},{"$f":"SUBTOTAL(109,Table5[Column8])","v":0},{"$f":"SUBTOTAL(109,Table5[Column9])","v":0},{"$f":"SUBTOTAL(109,Table5[Column10])","v":0},{"$f":"SUBTOTAL(109,Table5[Column11])","v":0},{"$f":"SUBTOTAL(109,Table5[Column12])","v":0},{"$f":"SUBTOTAL(109,Table5[Column13])","v":0},{"$f":"SUBTOTAL(109,Table5[Column14])","v":0}]
["Gesundheit"]
["Fitnesscentergebühren",{"$nulls":12},{"$f":"SUM(Table6[[#This Row],[Column2]:[Column13]])","v":0}]
["Versicherung",{"$nulls":12},{"$f":"SUM(Table6[[#This Row],[Column2]:[Column13]])","v":0}]
["Verschreibungspflichtige Medikamente oder Behandlungen",{"$nulls":12},{"$f":"SUM(Table6[[#This Row],[Column2]:[Column13]])","v":0}]
["Rezeptfreie Medikamente",{"$nulls":12},{"$f":"SUM(Table6[[#This Row],[Column2]:[Column13]])","v":0}]
["Zuzahlungen/Selbstbeteiligungen",{"$nulls":12},{"$f":"SUM(Table6[[#This Row],[Column2]:[Column13]])","v":0}]
["Tierarzt/Tiermedizin",{"$nulls":12},{"$f":"SUM(Table6[[#This Row],[Column2]:[Column13]])","v":0}]
["Lebensversicherung",{"$nulls":12},{"$f":"SUM(Table6[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table6[Column2])","v":0},{"$f":"SUBTOTAL(109,Table6[Column3])","v":0},{"$f":"SUBTOTAL(109,Table6[Column4])","v":0},{"$f":"SUBTOTAL(109,Table6[Column5])","v":0},{"$f":"SUBTOTAL(109,Table6[Column6])","v":0},{"$f":"SUBTOTAL(109,Table6[Column7])","v":0},{"$f":"SUBTOTAL(109,Table6[Column8])","v":0},{"$f":"SUBTOTAL(109,Table6[Column9])","v":0},{"$f":"SUBTOTAL(109,Table6[Column10])","v":0},{"$f":"SUBTOTAL(109,Table6[Column11])","v":0},{"$f":"SUBTOTAL(109,Table6[Column12])","v":0},{"$f":"SUBTOTAL(109,Table6[Column13])","v":0},{"$f":"SUBTOTAL(109,Table6[Column14])","v":0}]
["Urlaub"]
["Flugticket",{"$nulls":12},{"$f":"SUM(Table7[[#This Row],[Column2]:[Column13]])","v":0}]
["Unterkünfte",{"$nulls":12},{"$f":"SUM(Table7[[#This Row],[Column2]:[Column13]])","v":0}]
["Essen",{"$nulls":12},{"$f":"SUM(Table7[[#This Row],[Column2]:[Column13]])","v":0}]
["Souvenire",{"$nulls":12},{"$f":"SUM(Table7[[#This Row],[Column2]:[Column13]])","v":0}]
["Tierfutter",{"$nulls":12},{"$f":"SUM(Table7[[#This Row],[Column2]:[Column13]])","v":0}]
["Mietwagen",{"$nulls":12},{"$f":"SUM(Table7[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table7[Column2])","v":0},{"$f":"SUBTOTAL(109,Table7[Column3])","v":0},{"$f":"SUBTOTAL(109,Table7[Column4])","v":0},{"$f":"SUBTOTAL(109,Table7[Column5])","v":0},{"$f":"SUBTOTAL(109,Table7[Column6])","v":0},{"$f":"SUBTOTAL(109,Table7[Column7])","v":0},{"$f":"SUBTOTAL(109,Table7[Column8])","v":0},{"$f":"SUBTOTAL(109,Table7[Column9])","v":0},{"$f":"SUBTOTAL(109,Table7[Column10])","v":0},{"$f":"SUBTOTAL(109,Table7[Column11])","v":0},{"$f":"SUBTOTAL(109,Table7[Column12])","v":0},{"$f":"SUBTOTAL(109,Table7[Column13])","v":0},{"$f":"SUBTOTAL(109,Table7[Column14])","v":0}]
["Freizeit"]
["Sportclubgebühren",{"$nulls":12},{"$f":"SUM(Table8[[#This Row],[Column2]:[Column13]])","v":0}]
["Sportausrüstung",{"$nulls":12},{"$f":"SUM(Table8[[#This Row],[Column2]:[Column13]])","v":0}]
["Mannschaftsbeiträge",{"$nulls":12},{"$f":"SUM(Table8[[#This Row],[Column2]:[Column13]])","v":0}]
["Spielzeug/Kindersachen",{"$nulls":12},{"$f":"SUM(Table8[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table8[Column2])","v":0},{"$f":"SUBTOTAL(109,Table8[Column3])","v":0},{"$f":"SUBTOTAL(109,Table8[Column4])","v":0},{"$f":"SUBTOTAL(109,Table8[Column5])","v":0},{"$f":"SUBTOTAL(109,Table8[Column6])","v":0},{"$f":"SUBTOTAL(109,Table8[Column7])","v":0},{"$f":"SUBTOTAL(109,Table8[Column8])","v":0},{"$f":"SUBTOTAL(109,Table8[Column9])","v":0},{"$f":"SUBTOTAL(109,Table8[Column10])","v":0},{"$f":"SUBTOTAL(109,Table8[Column11])","v":0},{"$f":"SUBTOTAL(109,Table8[Column12])","v":0},{"$f":"SUBTOTAL(109,Table8[Column13])","v":0},{"$f":"SUBTOTAL(109,Table8[Column14])","v":0}]
["Beiträge/Abonnements"]
["Zeitschriften",{"$nulls":12},{"$f":"SUM(Table9[[#This Row],[Column2]:[Column13]])","v":0}]
["Zeitungen",{"$nulls":12},{"$f":"SUM(Table9[[#This Row],[Column2]:[Column13]])","v":0}]
["Internetverbindung",{"$nulls":12},{"$f":"SUM(Table9[[#This Row],[Column2]:[Column13]])","v":0}]
["Öffentlich-rechtlicher Rundfunk",{"$nulls":12},{"$f":"SUM(Table9[[#This Row],[Column2]:[Column13]])","v":0}]
["Öffentlich-rechtliches Fernsehen",{"$nulls":12},{"$f":"SUM(Table9[[#This Row],[Column2]:[Column13]])","v":0}]
["Religiöse Organisationen",{"$nulls":12},{"$f":"SUM(Table9[[#This Row],[Column2]:[Column13]])","v":0}]
["Spende",{"$nulls":12},{"$f":"SUM(Table9[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table9[Column2])","v":0},{"$f":"SUBTOTAL(109,Table9[Column3])","v":0},{"$f":"SUBTOTAL(109,Table9[Column4])","v":0},{"$f":"SUBTOTAL(109,Table9[Column5])","v":0},{"$f":"SUBTOTAL(109,Table9[Column6])","v":0},{"$f":"SUBTOTAL(109,Table9[Column7])","v":0},{"$f":"SUBTOTAL(109,Table9[Column8])","v":0},{"$f":"SUBTOTAL(109,Table9[Column9])","v":0},{"$f":"SUBTOTAL(109,Table9[Column10])","v":0},{"$f":"SUBTOTAL(109,Table9[Column11])","v":0},{"$f":"SUBTOTAL(109,Table9[Column12])","v":0},{"$f":"SUBTOTAL(109,Table9[Column13])","v":0},{"$f":"SUBTOTAL(109,Table9[Column14])","v":0}]
["Persönlich"]
["Kleidung",{"$nulls":12},{"$f":"SUM(Table10[[#This Row],[Column2]:[Column13]])","v":0}]
["Geschenke",{"$nulls":12},{"$f":"SUM(Table10[[#This Row],[Column2]:[Column13]])","v":0}]
["Salon/Friseur",{"$nulls":12},{"$f":"SUM(Table10[[#This Row],[Column2]:[Column13]])","v":0}]
["Bücher",{"$nulls":12},{"$f":"SUM(Table10[[#This Row],[Column2]:[Column13]])","v":0}]
["Musik (CDs, etc.)",{"$nulls":12},{"$f":"SUM(Table10[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table10[Column2])","v":0},{"$f":"SUBTOTAL(109,Table10[Column3])","v":0},{"$f":"SUBTOTAL(109,Table10[Column4])","v":0},{"$f":"SUBTOTAL(109,Table10[Column5])","v":0},{"$f":"SUBTOTAL(109,Table10[Column6])","v":0},{"$f":"SUBTOTAL(109,Table10[Column7])","v":0},{"$f":"SUBTOTAL(109,Table10[Column8])","v":0},{"$f":"SUBTOTAL(109,Table10[Column9])","v":0},{"$f":"SUBTOTAL(109,Table10[Column10])","v":0},{"$f":"SUBTOTAL(109,Table10[Column11])","v":0},{"$f":"SUBTOTAL(109,Table10[Column12])","v":0},{"$f":"SUBTOTAL(109,Table10[Column13])","v":0},{"$f":"SUBTOTAL(109,Table10[Column14])","v":0}]
["Finanzielle Verpflichtungen"]
["Sparplan",{"$nulls":12},{"$f":"SUM(Table11[[#This Row],[Column2]:[Column13]])","v":0}]
["Altersvorsorge (401k, Roth IRA)",{"$nulls":12},{"$f":"SUM(Table11[[#This Row],[Column2]:[Column13]])","v":0}]
["Kreditkartenzahlungen",{"$nulls":12},{"$f":"SUM(Table11[[#This Row],[Column2]:[Column13]])","v":0}]
["Einkommenssteuer (zusätzlich)",{"$nulls":12},{"$f":"SUM(Table11[[#This Row],[Column2]:[Column13]])","v":0}]
["Andere Verpflichtungen",{"$nulls":12},{"$f":"SUM(Table11[[#This Row],[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table11[Column2])","v":0},{"$f":"SUBTOTAL(109,Table11[Column3])","v":0},{"$f":"SUBTOTAL(109,Table11[Column4])","v":0},{"$f":"SUBTOTAL(109,Table11[Column5])","v":0},{"$f":"SUBTOTAL(109,Table11[Column6])","v":0},{"$f":"SUBTOTAL(109,Table11[Column7])","v":0},{"$f":"SUBTOTAL(109,Table11[Column8])","v":0},{"$f":"SUBTOTAL(109,Table11[Column9])","v":0},{"$f":"SUBTOTAL(109,Table11[Column10])","v":0},{"$f":"SUBTOTAL(109,Table11[Column11])","v":0},{"$f":"SUBTOTAL(109,Table11[Column12])","v":0},{"$f":"SUBTOTAL(109,Table11[Column13])","v":0},{"$f":"SUBTOTAL(109,Table11[Column14])","v":0}]
["Sonstige Zahlungen"]
["Weiteres",{"$nulls":12},{"$f":"SUM(Table12[[Column2]:[Column13]])","v":0}]
["Summe",{"$f":"SUBTOTAL(109,Table12[Column2])","v":0},{"$f":"SUBTOTAL(109,Table12[Column3])","v":0},{"$f":"SUBTOTAL(109,Table12[Column4])","v":0},{"$f":"SUBTOTAL(109,Table12[Column5])","v":0},{"$f":"SUBTOTAL(109,Table12[Column6])","v":0},{"$f":"SUBTOTAL(109,Table12[Column7])","v":0},{"$f":"SUBTOTAL(109,Table12[Column8])","v":0},{"$f":"SUBTOTAL(109,Table12[Column9])","v":0},{"$f":"SUBTOTAL(109,Table12[Column10])","v":0},{"$f":"SUBTOTAL(109,Table12[Column11])","v":0},{"$f":"SUBTOTAL(109,Table12[Column12])","v":0},{"$f":"SUBTOTAL(109,Table12[Column13])","v":0},{"$f":"SUBTOTAL(109,Table12[Column14])","v":0}]