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

{"sheet":"Persönliches Monatsbudget","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"merged":[[0,1,0,9],[2,1,4,1],[2,2,2,3],[2,7,2,8],[3,2,3,3],[3,7,3,8],[4,2,4,3],[4,6,4,8],[5,1,7,1],[5,2,5,3],[5,7,5,8],[6,2,6,3],[6,7,6,8],[7,2,7,3],[7,6,7,8],[20,6,20,9],[21,1,21,4],[29,6,29,9],[31,1,31,4],[36,6,36,9],[38,1,38,4],[42,6,42,9],[44,1,44,4],[48,6,48,9],[52,1,52,4],[55,6,55,9]]}
[null,"Persönliches Monatsbudget"]
[]
[null,"ERWARTETES MONATSEINKOMMEN","Einkünfte 1",null,{"v":2500,"d":"2,500 €"},null,"ERGEBNIS DER ERWARTETEN AUSGABEN ","(Erwartete Einkünfte minus Ausgaben)",null,{"$f":"SUM(C21,C31,C38,C44,C52,C62,H20,H29,H36,H42,H48,H55)","v":{"v":2060,"d":"2,060 €"}}]
[null,null,"Zusatzeinkünfte",null,{"v":500,"d":"500 €"},null,"SUMME DER TATSÄCHLICHEN AUSGABEN ","(Tatsächliche Einkünfte minus Ausgaben)",null,{"$f":"SUM(D21,D31,D38,D44,D52,D62,I20,I29,I36,I42,I48,I55)","v":{"v":2040,"d":"2,040 €"}}]
[null,null,"Summe der monatlichen Einkünfte",null,{"$f":"SUM(E3:E4)","v":{"v":3000,"d":"3,000 €"}},null,"Gesamtausgabendifferenz",null,null,{"$f":"SUM(E21,E31,E38,E44,E52,E62,J20,J29,J36,J42,J48,J55)","v":{"v":20,"d":"20 €"}}]
[null,"TATSÄCHLICHES MONATSEINKOMMEN","Einkünfte 1",null,{"v":2500,"d":"2,500 €"},null,"ERWARTETER SALDO","(Erwartete Einkünfte minus Ausgaben)",null,{"$f":"E5-J3","v":{"v":940,"d":"940 €"}}]
[null,null,"Zusatzeinkünfte",null,{"v":500,"d":"500 €"},null,"TATSÄCHLICHER SALDO","(Tatsächliche Einkünfte minus Ausgaben)",null,{"$f":"E8-J4","v":{"v":960,"d":"960 €"}}]
[null,null,"Summe der monatlichen Einkünfte",null,{"$f":"SUM(E6:E7)","v":{"v":3000,"d":"3,000 €"}},null,"SALDENDIFFERENZ (tatsächlich abzüglich erwartet)",null,null,{"$f":"J7-J6","v":{"v":20,"d":"20 €"}}]
[]
[null,"WOHNEN","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"UNTERHALTUNG","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[null,"Hypothek oder Miete",{"v":1500,"d":"1,500 €"},{"v":1400,"d":"1,400 €"},{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":100,"d":"100 €"}},null,"Video/DVD",{"v":0,"d":"0 €"},{"v":50,"d":"50 €"},{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":-50,"d":"-50 €"}}]
[null,"Telefon",{"v":60,"d":"60 €"},{"v":100,"d":"100 €"},{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":-40,"d":"-40 €"}},null,"CDs",null,null,{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Strom",{"v":50,"d":"50 €"},{"v":60,"d":"60 €"},{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":-10,"d":"-10 €"}},null,"Filme",null,null,{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Gas",{"v":200,"d":"200 €"},{"v":180,"d":"180 €"},{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":20,"d":"20 €"}},null,"Konzerte",null,null,{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Wasser und Abwasser",null,null,{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sportveranstaltungen",null,null,{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kabelfernsehen",null,null,{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Theater",null,null,{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Müllabfuhr",null,null,{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstiges",null,null,{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Wartung oder Reparaturen",null,null,{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstiges",null,null,{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Lehrmittel",null,null,{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstiges",null,null,{"$f":"Unterhaltung[[#This Row],[Erwartete Kosten]]-Unterhaltung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Sonstiges",null,null,{"$f":"Wohnen[[#This Row],[Erwartete Kosten]]-Wohnen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Unterhaltung[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Unterhaltung[Tatsächliche Kosten])","v":{"v":50,"d":"50 €"}},{"$f":"SUBTOTAL(109,Unterhaltung[Differenz])","v":{"v":-50,"d":"-50 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Wohnen[Erwartete Kosten])","v":{"v":1810,"d":"1,810 €"}},{"$f":"SUBTOTAL(109,Wohnen[Tatsächliche Kosten])","v":{"v":1740,"d":"1,740 €"}},{"$f":"SUBTOTAL(109,Wohnen[Differenz])","v":{"v":70,"d":"70 €"}}]
[{"$nulls":6},"KREDITE","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[null,"BEFÖRDERUNG","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"Privat",null,null,{"$f":"Kredite[[#This Row],[Erwartete Kosten]]-Kredite[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kfz-Kosten",{"v":250,"d":"250 €"},{"v":250,"d":"250 €"},{"$f":"Verkehrsmittel[[#This Row],[Erwartete Kosten]]-Verkehrsmittel[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Studium",null,null,{"$f":"Kredite[[#This Row],[Erwartete Kosten]]-Kredite[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Bus-/Taxikosten",null,null,{"$f":"Verkehrsmittel[[#This Row],[Erwartete Kosten]]-Verkehrsmittel[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Kredite[[#This Row],[Erwartete Kosten]]-Kredite[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Versicherungen",null,null,{"$f":"Verkehrsmittel[[#This Row],[Erwartete Kosten]]-Verkehrsmittel[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Kredite[[#This Row],[Erwartete Kosten]]-Kredite[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kfz-Steuer",null,null,{"$f":"Verkehrsmittel[[#This Row],[Erwartete Kosten]]-Verkehrsmittel[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Kredite[[#This Row],[Erwartete Kosten]]-Kredite[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kraftstoff",null,null,{"$f":"Verkehrsmittel[[#This Row],[Erwartete Kosten]]-Verkehrsmittel[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstige",null,null,{"$f":"Kredite[[#This Row],[Erwartete Kosten]]-Kredite[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Wartung",null,null,{"$f":"Verkehrsmittel[[#This Row],[Erwartete Kosten]]-Verkehrsmittel[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Kredite[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Kredite[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Kredite[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Sonstiges",null,null,{"$f":"Verkehrsmittel[[#This Row],[Erwartete Kosten]]-Verkehrsmittel[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Verkehrsmittel[Erwartete Kosten])","v":{"v":250,"d":"250 €"}},{"$f":"SUBTOTAL(109,Verkehrsmittel[Tatsächliche Kosten])","v":{"v":250,"d":"250 €"}},{"$f":"SUBTOTAL(109,Verkehrsmittel[Differenz])","v":{"v":0,"d":"0 €"}},null,"STEUERN","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[{"$nulls":6},"EkSt",null,null,{"$f":"Steuern[[#This Row],[Erwartete Kosten]]-Steuern[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"VERSICHERUNGEN","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"USt",null,null,{"$f":"Steuern[[#This Row],[Erwartete Kosten]]-Steuern[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Haus",null,null,{"$f":"Versicherung[[#This Row],[Erwartete Kosten]]-Versicherung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Kommunalsteuern",null,null,{"$f":"Steuern[[#This Row],[Erwartete Kosten]]-Steuern[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Krankenversicherung",null,null,{"$f":"Versicherung[[#This Row],[Erwartete Kosten]]-Versicherung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstige",null,null,{"$f":"Steuern[[#This Row],[Erwartete Kosten]]-Steuern[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Lebensversicherung",null,null,{"$f":"Versicherung[[#This Row],[Erwartete Kosten]]-Versicherung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Steuern[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Steuern[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Steuern[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Sonstige",null,null,{"$f":"Versicherung[[#This Row],[Erwartete Kosten]]-Versicherung[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Versicherung[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Versicherung[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Versicherung[Differenz])","v":{"v":0,"d":"0 €"}},null,"SPAREINLAGEN ODER KAPITALANLAGEN","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[{"$nulls":6},"Altersvorsorgekonto",null,null,{"$f":"Spareinlagen_Kapitalanlagen[[#This Row],[Erwartete Kosten]]-Spareinlagen_Kapitalanlagen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"ESSEN","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"Anlagekonto",null,null,{"$f":"Spareinlagen_Kapitalanlagen[[#This Row],[Erwartete Kosten]]-Spareinlagen_Kapitalanlagen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Lebensmittel",null,null,{"$f":"Essen[[#This Row],[Erwartete Kosten]]-Essen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstiges",null,null,{"$f":"Spareinlagen_Kapitalanlagen[[#This Row],[Erwartete Kosten]]-Spareinlagen_Kapitalanlagen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ausgehen",null,null,{"$f":"Essen[[#This Row],[Erwartete Kosten]]-Essen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Spareinlagen_Kapitalanlagen[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Spareinlagen_Kapitalanlagen[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Spareinlagen_Kapitalanlagen[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Sonstige",null,null,{"$f":"Essen[[#This Row],[Erwartete Kosten]]-Essen[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Essen[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Essen[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Essen[Differenz])","v":{"v":0,"d":"0 €"}},null,"GESCHENKE UND SPENDEN","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[{"$nulls":6},"Spenden 1",null,null,{"$f":"GeschenkeUndSpenden[[#This Row],[Erwartete Kosten]]-GeschenkeUndSpenden[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"HAUSTIERE","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"Spenden 2",null,null,{"$f":"GeschenkeUndSpenden[[#This Row],[Erwartete Kosten]]-GeschenkeUndSpenden[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Essen",null,null,{"$f":"Haustiere[[#This Row],[Erwartete Kosten]]-Haustiere[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Spenden 3",null,null,{"$f":"GeschenkeUndSpenden[[#This Row],[Erwartete Kosten]]-GeschenkeUndSpenden[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Arztkosten",null,null,{"$f":"Haustiere[[#This Row],[Erwartete Kosten]]-Haustiere[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,GeschenkeUndSpenden[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,GeschenkeUndSpenden[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,GeschenkeUndSpenden[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Fellpflege",null,null,{"$f":"Haustiere[[#This Row],[Erwartete Kosten]]-Haustiere[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Spielzeuge",null,null,{"$f":"Haustiere[[#This Row],[Erwartete Kosten]]-Haustiere[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"RECHTSKOSTEN","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[null,"Sonstige",null,null,{"$f":"Haustiere[[#This Row],[Erwartete Kosten]]-Haustiere[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Anwalt",null,null,{"$f":"Rechtskosten[[#This Row],[Erwartete Kosten]]-Rechtskosten[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Haustiere[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Haustiere[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Haustiere[Differenz])","v":{"v":0,"d":"0 €"}},null,"Unterhalt",null,null,{"$f":"Rechtskosten[[#This Row],[Erwartete Kosten]]-Rechtskosten[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[{"$nulls":6},"Zahlungen für Pfändungen oder Gerichtsurteile",null,null,{"$f":"Rechtskosten[[#This Row],[Erwartete Kosten]]-Rechtskosten[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"KÖRPERPFLEGE","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"Sonstiges",null,null,{"$f":"Rechtskosten[[#This Row],[Erwartete Kosten]]-Rechtskosten[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Arztkosten",null,null,{"$f":"Körperpflege[[#This Row],[Erwartete Kosten]]-Körperpflege[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Rechtskosten[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Rechtskosten[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Rechtskosten[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Haare/Nägel",null,null,{"$f":"Körperpflege[[#This Row],[Erwartete Kosten]]-Körperpflege[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kleidung",null,null,{"$f":"Körperpflege[[#This Row],[Erwartete Kosten]]-Körperpflege[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Chemische Reinigung",null,null,{"$f":"Körperpflege[[#This Row],[Erwartete Kosten]]-Körperpflege[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Fitnesscenter",null,null,{"$f":"Körperpflege[[#This Row],[Erwartete Kosten]]-Körperpflege[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Vereinsbeiträge",null,null,{"$f":"Körperpflege[[#This Row],[Erwartete Kosten]]-Körperpflege[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Sonstiges",null,null,{"$f":"Körperpflege[[#This Row],[Erwartete Kosten]]-Körperpflege[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Körperpflege[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Körperpflege[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Körperpflege[Differenz])","v":{"v":0,"d":"0 €"}}]