{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Monatliches Familienbudget"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Monatliches Familienbudget","index":0,"n_rows":68,"n_cols":9,"rows_kept":68,"merged":[[0,0,0,6],[2,0,2,1],[2,5,2,6],[8,5,8,6],[18,0,18,3],[27,5,27,8],[29,0,29,3],[36,0,36,3],[37,5,37,8],[42,0,42,3],[44,5,44,8],[54,0,54,3],[54,5,54,8],[61,0,61,3],[62,5,62,8]]}
["Monatliches Familienbudget"]
[]
["Voraussichtliche Gesamtkosten",null,"Tatsächliche Gesamtkosten","Gesamtdifferenz",null,"Voraussichtliches Monatseinkommen"]
[null,{"$f":"Housing[[#Totals],[Voraussichtliche Kosten]]+Transportation[[#Totals],[Voraussichtliche Kosten]]+Insurance[[#Totals],[Voraussichtliche Kosten]]+Food[[#Totals],[Voraussichtliche Kosten]]+Children[[#Totals],[Voraussichtliche Kosten]]+Legal[[#Totals],[Voraussichtliche Kosten]]+Savings[[#Totals],[Voraussichtliche Kosten]]+Loans[[#Totals],[Voraussichtliche Kosten]]+Entertainment[[#Totals],[Voraussichtliche Kosten]]+Taxes[[#Totals],[Voraussichtliche Kosten]]+PersonalCare[[#Totals],[Voraussichtliche Kosten]]+Pets[[#Totals],[Voraussichtliche Kosten]]+Gifts[[#Totals],[Voraussichtliche Kosten]]","v":{"v":1203,"d":"1,203 €"}},{"$f":"Housing[[#Totals],[Ist-Kosten]]+Transportation[[#Totals],[Ist-Kosten]]+Insurance[[#Totals],[Ist-Kosten]]+Food[[#Totals],[Ist-Kosten]]+Children[[#Totals],[Ist-Kosten]]+Legal[[#Totals],[Ist-Kosten]]+Savings[[#Totals],[Ist-Kosten]]+Loans[[#Totals],[Ist-Kosten]]+Entertainment[[#Totals],[Ist-Kosten]]+Taxes[[#Totals],[Ist-Kosten]]+PersonalCare[[#Totals],[Ist-Kosten]]+Pets[[#Totals],[Ist-Kosten]]+Gifts[[#Totals],[Ist-Kosten]]","v":{"v":1317,"d":"1,317 €"}},{"$f":"Housing[[#Totals],[Differenz]]+Transportation[[#Totals],[Differenz]]+Insurance[[#Totals],[Differenz]]+Food[[#Totals],[Differenz]]+Children[[#Totals],[Differenz]]+Legal[[#Totals],[Differenz]]+Savings[[#Totals],[Differenz]]+Loans[[#Totals],[Differenz]]+Entertainment[[#Totals],[Differenz]]+Taxes[[#Totals],[Differenz]]+PersonalCare[[#Totals],[Differenz]]+Pets[[#Totals],[Differenz]]+Gifts[[#Totals],[Differenz]]","v":{"v":-114,"d":"114 €"}},null,"Einkommen 1",{"v":4000,"d":"4,000 €"}]
[{"$nulls":5},"Einkommen 2",{"v":1200,"d":"1,200 €"}]
["Wohnen","Voraussichtliche Kosten","Ist-Kosten","Differenz",null,"Nebeneinkünfte",{"v":300,"d":"300 €"}]
["Hypothek oder Miete",{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Monatseinkommen gesamt",{"$f":"SUM(G4:G6)","v":{"v":5500,"d":"5,500 €"}}]
["Zweite Hypothek oder Miete",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Telefon",{"v":62,"d":"62 €"},{"v":100,"d":"100 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":-38,"d":"38 €"}},null,"Tatsächliches Monatseinkommen"]
["Strom",{"v":44,"d":"44 €"},{"v":125,"d":"125 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":-81,"d":"81 €"}},null,"Einkommen 1",{"v":4000,"d":"4,000 €"}]
["Gas",{"v":22,"d":"22 €"},{"v":35,"d":"35 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":-13,"d":"13 €"}},null,"Einkommen 2",{"v":1200,"d":"1,200 €"}]
["Wasser und Abwasser",{"v":8,"d":"8 €"},{"v":8,"d":"8 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Nebeneinkünfte",{"v":300,"d":"300 €"}]
["Kabelanschluss",{"v":34,"d":"34 €"},{"v":39,"d":"39 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":-5,"d":"5 €"}},null,"Monatseinkommen gesamt",{"$f":"SUM(G10:G12)","v":{"v":5500,"d":"5,500 €"}}]
["Müllabfuhr",{"v":10,"d":"10 €"},{"v":10,"d":"10 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Wartung oder Reparaturen",{"v":23,"d":"23 €"},{"v":0,"d":"0 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":23,"d":"23 €"}},null,"Geplanter Saldo\n",{"$f":"SUM(G7-B4)","v":{"v":4297,"d":"4,297 €"}}]
["Material",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Ist-Saldo",{"$f":"SUM(G13-C4)","v":{"v":4183,"d":"4,183 €"}}]
["Weiteres",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"$f":"Housing[Voraussichtliche Kosten]-Housing[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Differenz",{"$f":"SUM(G16-G15)","v":{"v":-114,"d":"114 €"}}]
["Summe",{"$f":"SUBTOTAL(109,Housing[Voraussichtliche Kosten])","v":{"v":1203,"d":"1,203 €"}},{"$f":"SUBTOTAL(109,Housing[Ist-Kosten])","v":{"v":1317,"d":"1,317 €"}},{"$f":"SUBTOTAL(109,Housing[Differenz])","v":{"v":-114,"d":"114 €"}}]
[]
["Transport","Voraussichtliche Kosten","Ist-Kosten","Differenz",null,"Kredite","Voraussichtliche Kosten","Ist-Kosten","Differenz"]
["Kosten Auto 1",null,null,{"$f":"Transportation[Voraussichtliche Kosten]-Transportation[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Persönlich",null,null,{"$f":"Loans[Voraussichtliche Kosten]-Loans[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Kosten Auto 2",null,null,{"$f":"Transportation[Voraussichtliche Kosten]-Transportation[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Schüler/in",null,null,{"$f":"Loans[Voraussichtliche Kosten]-Loans[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Bus-/Bahn-/Taxikosten",null,null,{"$f":"Transportation[Voraussichtliche Kosten]-Transportation[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Loans[Voraussichtliche Kosten]-Loans[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Versicherung",null,null,{"$f":"Transportation[Voraussichtliche Kosten]-Transportation[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Loans[Voraussichtliche Kosten]-Loans[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Kfz-Steuer",null,null,{"$f":"Transportation[Voraussichtliche Kosten]-Transportation[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Loans[Voraussichtliche Kosten]-Loans[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Benzin",null,null,{"$f":"Transportation[Voraussichtliche Kosten]-Transportation[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Weiteres",null,null,{"$f":"Loans[Voraussichtliche Kosten]-Loans[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Pflege",null,null,{"$f":"Transportation[Voraussichtliche Kosten]-Transportation[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Summe",{"$f":"SUBTOTAL(109,Loans[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Loans[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Loans[Differenz])","v":{"v":0,"d":"0 €"}}]
["Weiteres",null,null,{"$f":"Transportation[Voraussichtliche Kosten]-Transportation[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Summe",{"$f":"SUBTOTAL(109,Transportation[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Transportation[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Transportation[Differenz])","v":{"v":0,"d":"0 €"}},null,"Unterhaltung","Voraussichtliche Kosten","Ist-Kosten","Differenz"]
[{"$nulls":5},"Video/DVD",null,null,{"$f":"Entertainment[Voraussichtliche Kosten]-Entertainment[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Versicherung","Voraussichtliche Kosten","Ist-Kosten","Differenz",null,"CDs",null,null,{"$f":"Entertainment[Voraussichtliche Kosten]-Entertainment[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Haus",null,null,{"$f":"Insurance[Voraussichtliche Kosten]-Insurance[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Kino",null,null,{"$f":"Entertainment[Voraussichtliche Kosten]-Entertainment[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Gesundheit",null,null,{"$f":"Insurance[Voraussichtliche Kosten]-Insurance[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Oper/Konzerte",null,null,{"$f":"Entertainment[Voraussichtliche Kosten]-Entertainment[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Leben",null,null,{"$f":"Insurance[Voraussichtliche Kosten]-Insurance[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Sportveranstaltungen",null,null,{"$f":"Entertainment[Voraussichtliche Kosten]-Entertainment[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Weiteres",null,null,{"$f":"Insurance[Voraussichtliche Kosten]-Insurance[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Theater",null,null,{"$f":"Entertainment[Voraussichtliche Kosten]-Entertainment[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Summe",{"$f":"SUBTOTAL(109,Insurance[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Insurance[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Insurance[Differenz])","v":{"v":0,"d":"0 €"}},null,"Weiteres",null,null,{"$f":"Entertainment[Voraussichtliche Kosten]-Entertainment[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
[{"$nulls":5},"Summe",{"$f":"SUBTOTAL(109,Entertainment[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Entertainment[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Entertainment[Differenz])","v":{"v":0,"d":"0 €"}}]
["Essen","Voraussichtliche Kosten","Ist-Kosten","Differenz"]
["Lebensmittel",null,null,{"$f":"Food[Voraussichtliche Kosten]-Food[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Steuern","Voraussichtliche Kosten","Ist-Kosten","Differenz"]
["Restaurantbesuche",null,null,{"$f":"Food[Voraussichtliche Kosten]-Food[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Einkommensteuer",null,null,{"$f":"Taxes[Voraussichtliche Kosten]-Taxes[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Weiteres",null,null,{"$f":"Food[Voraussichtliche Kosten]-Food[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Land",null,null,{"$f":"Taxes[Voraussichtliche Kosten]-Taxes[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Summe",{"$f":"SUBTOTAL(109,Food[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Food[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Food[Differenz])","v":{"v":0,"d":"0 €"}},null,"Grundsteuer",null,null,{"$f":"Taxes[Voraussichtliche Kosten]-Taxes[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
[{"$nulls":5},"Weiteres",null,null,{"$f":"Taxes[Voraussichtliche Kosten]-Taxes[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Kinder","Voraussichtliche Kosten","Ist-Kosten","Differenz",null,"Summe",{"$f":"SUBTOTAL(109,Taxes[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Taxes[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Taxes[Differenz])","v":{"v":0,"d":"0 €"}}]
["Arzt/Medikamente",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Kleidung",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Persönliche Pflege","Voraussichtliche Kosten","Ist-Kosten","Differenz"]
["Nachhilfeunterricht",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Arzt/Medikamente",null,null,{"$f":"PersonalCare[Voraussichtliche Kosten]-PersonalCare[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Schulbücher/-material",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Haar-/Nagelpflege",null,null,{"$f":"PersonalCare[Voraussichtliche Kosten]-PersonalCare[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Vereinsbeiträge",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Kleidung",null,null,{"$f":"PersonalCare[Voraussichtliche Kosten]-PersonalCare[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Geld für Mittagessen",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Chemische Reinigung",null,null,{"$f":"PersonalCare[Voraussichtliche Kosten]-PersonalCare[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Babysitter",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Fitnesscenter",null,null,{"$f":"PersonalCare[Voraussichtliche Kosten]-PersonalCare[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Spielzeug/Spiele",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Vereinsbeiträge",null,null,{"$f":"PersonalCare[Voraussichtliche Kosten]-PersonalCare[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Weiteres",null,null,{"$f":"Children[Voraussichtliche Kosten]-Children[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Weiteres",null,null,{"$f":"PersonalCare[Voraussichtliche Kosten]-PersonalCare[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Summe",{"$f":"SUBTOTAL(109,Children[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Children[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Children[Differenz])","v":{"v":0,"d":"0 €"}},null,"Summe",{"$f":"SUBTOTAL(109,PersonalCare[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PersonalCare[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,PersonalCare[Differenz])","v":{"v":0,"d":"0 €"}}]
[]
["Rechtswesen","Voraussichtliche Kosten","Ist-Kosten","Differenz",null,"Haustiere","Voraussichtliche Kosten","Ist-Kosten","Differenz"]
["Anwalt",null,null,{"$f":"Legal[Voraussichtliche Kosten]-Legal[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Essen",null,null,{"$f":"Pets[Voraussichtliche Kosten]-Pets[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Unterhaltszahlung",null,null,{"$f":"Legal[Voraussichtliche Kosten]-Legal[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Arzt/Medikamente",null,null,{"$f":"Pets[Voraussichtliche Kosten]-Pets[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Zahlungen",null,null,{"$f":"Legal[Voraussichtliche Kosten]-Legal[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Pflege",null,null,{"$f":"Pets[Voraussichtliche Kosten]-Pets[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Weiteres",null,null,{"$f":"Legal[Voraussichtliche Kosten]-Legal[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Spielzeug",null,null,{"$f":"Pets[Voraussichtliche Kosten]-Pets[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Summe",{"$f":"SUBTOTAL(109,Legal[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Legal[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Legal[Differenz])","v":{"v":0,"d":"0 €"}},null,"Weiteres",null,null,{"$f":"Pets[Voraussichtliche Kosten]-Pets[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
[{"$nulls":5},"Summe",{"$f":"SUBTOTAL(109,Pets[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Pets[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Pets[Differenz])","v":{"v":0,"d":"0 €"}}]
["Vermögensbildung","Voraussichtliche Kosten","Ist-Kosten","Differenz"]
["Rentenkonto",null,null,{"$f":"Savings[Voraussichtliche Kosten]-Savings[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Geschenke und Spenden","Voraussichtliche Kosten","Ist-Kosten","Differenz"]
["Anlagekonto",null,null,{"$f":"Savings[Voraussichtliche Kosten]-Savings[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Spende 1",null,null,{"$f":"Gifts[Voraussichtliche Kosten]-Gifts[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Universität/Hochschule",null,null,{"$f":"Savings[Voraussichtliche Kosten]-Savings[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Spende 2",null,null,{"$f":"Gifts[Voraussichtliche Kosten]-Gifts[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Weiteres",null,null,{"$f":"Savings[Voraussichtliche Kosten]-Savings[Ist-Kosten]","v":{"v":0,"d":"0 €"}},null,"Spende 3",null,null,{"$f":"Gifts[Voraussichtliche Kosten]-Gifts[Ist-Kosten]","v":{"v":0,"d":"0 €"}}]
["Summe",{"$f":"SUBTOTAL(109,Savings[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Savings[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Savings[Differenz])","v":{"v":0,"d":"0 €"}},null,"Summe",{"$f":"SUBTOTAL(109,Gifts[Voraussichtliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Gifts[Ist-Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Gifts[Differenz])","v":{"v":0,"d":"0 €"}}]