{"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":64,"n_cols":10,"rows_kept":64,"merged":[[1,1,1,9],[2,1,2,9],[4,1,6,1],[4,2,4,3],[4,6,5,8],[4,9,5,9],[5,2,5,3],[6,2,6,3],[6,6,7,8],[6,9,7,9],[7,1,9,1],[7,2,7,3],[8,2,8,3],[8,6,9,8],[8,9,9,9],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9]]}
[]
[null,"Persönliches Monatsbudget"]
[]
[]
[null,"ERWARTETES MONATSEINKOMMEN","Einkünfte 1",null,{"v":2500,"d":"2,500 €"},null,"GEPLANTER SALDO (geplantes Einkommen minus Ausgaben)",null,null,{"$f":"E7-J59","v":{"v":940,"d":"940 €"}}]
[null,null,"Zusatzeinkünfte",null,{"v":500,"d":"500 €"}]
[null,null,"Summe der monatlichen Einkünfte",null,{"$f":"SUM(E5:E6)","v":{"v":3000,"d":"3,000 €"}},null,"ISTSALDO (Isteinkommen minus Ausgaben)",null,null,{"$f":"E10-J61","v":{"v":960,"d":"960 €"}}]
[null,"TATSÄCHLICHES MONATSEINKOMMEN","Einkünfte 1",null,{"v":2500,"d":"2,500 €"}]
[null,null,"Zusatzeinkünfte",null,{"v":500,"d":"500 €"},null,"DIFFERENZ (Ist minus geplant)",null,null,{"$f":"J7-J5","v":{"v":20,"d":"20 €"}}]
[null,null,"Summe der monatlichen Einkünfte",null,{"$f":"SUM(E8:E9)","v":{"v":3000,"d":"3,000 €"}}]
[]
[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":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":100,"d":"100 €"}},null,"Video/DVD",{"v":0,"d":"0 €"},{"v":50,"d":"50 €"},{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":-50,"d":"-50 €"}}]
[null,"Telefon",{"v":60,"d":"60 €"},{"v":100,"d":"100 €"},{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":-40,"d":"-40 €"}},null,"CDs",null,null,{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Strom",{"v":50,"d":"50 €"},{"v":60,"d":"60 €"},{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":-10,"d":"-10 €"}},null,"Filme",null,null,{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Gas",{"v":200,"d":"200 €"},{"v":180,"d":"180 €"},{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":20,"d":"20 €"}},null,"Konzerte",null,null,{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Wasser und Abwasser",null,null,{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sportveranstaltungen",null,null,{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kabelfernsehen",null,null,{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Theater",null,null,{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Müllabfuhr",null,null,{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstiges",null,null,{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Wartung oder Reparaturen",null,null,{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstiges",null,null,{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Lehrmittel",null,null,{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstiges",null,null,{"$f":"Tabelle2[[#This Row],[Erwartete Kosten]]-Tabelle2[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Sonstiges",null,null,{"$f":"Tabelle1[[#This Row],[Erwartete Kosten]]-Tabelle1[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle2[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle2[Tatsächliche Kosten])","v":{"v":50,"d":"50 €"}},{"$f":"SUBTOTAL(109,Tabelle2[Differenz])","v":{"v":-50,"d":"-50 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle1[Erwartete Kosten])","v":{"v":1810,"d":"1,810 €"}},{"$f":"SUBTOTAL(109,Tabelle1[Tatsächliche Kosten])","v":{"v":1740,"d":"1,740 €"}},{"$f":"SUBTOTAL(109,Tabelle1[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":"Tabelle8[[#This Row],[Erwartete Kosten]]-Tabelle8[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kfz-Kosten",{"v":250,"d":"250 €"},{"v":250,"d":"250 €"},{"$f":"Tabelle3[[#This Row],[Erwartete Kosten]]-Tabelle3[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Studium",null,null,{"$f":"Tabelle8[[#This Row],[Erwartete Kosten]]-Tabelle8[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Bus-/Taxikosten",null,null,{"$f":"Tabelle3[[#This Row],[Erwartete Kosten]]-Tabelle3[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Tabelle8[[#This Row],[Erwartete Kosten]]-Tabelle8[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Versicherungen",null,null,{"$f":"Tabelle3[[#This Row],[Erwartete Kosten]]-Tabelle3[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Tabelle8[[#This Row],[Erwartete Kosten]]-Tabelle8[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kfz-Steuer",null,null,{"$f":"Tabelle3[[#This Row],[Erwartete Kosten]]-Tabelle3[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Kreditkarte",null,null,{"$f":"Tabelle8[[#This Row],[Erwartete Kosten]]-Tabelle8[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kraftstoff",null,null,{"$f":"Tabelle3[[#This Row],[Erwartete Kosten]]-Tabelle3[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstige",null,null,{"$f":"Tabelle8[[#This Row],[Erwartete Kosten]]-Tabelle8[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Wartung",null,null,{"$f":"Tabelle3[[#This Row],[Erwartete Kosten]]-Tabelle3[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle8[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle8[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle8[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Sonstiges",null,null,{"$f":"Tabelle3[[#This Row],[Erwartete Kosten]]-Tabelle3[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle3[Erwartete Kosten])","v":{"v":250,"d":"250 €"}},{"$f":"SUBTOTAL(109,Tabelle3[Tatsächliche Kosten])","v":{"v":250,"d":"250 €"}},{"$f":"SUBTOTAL(109,Tabelle3[Differenz])","v":{"v":0,"d":"0 €"}},null,"STEUERN","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[{"$nulls":6},"EkSt",null,null,{"$f":"Tabelle9[[#This Row],[Erwartete Kosten]]-Tabelle9[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"VERSICHERUNGEN","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"USt",null,null,{"$f":"Tabelle9[[#This Row],[Erwartete Kosten]]-Tabelle9[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Haus",null,null,{"$f":"Tabelle4[[#This Row],[Erwartete Kosten]]-Tabelle4[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Kommunalsteuern",null,null,{"$f":"Tabelle9[[#This Row],[Erwartete Kosten]]-Tabelle9[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Krankenversicherung",null,null,{"$f":"Tabelle4[[#This Row],[Erwartete Kosten]]-Tabelle4[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstige",null,null,{"$f":"Tabelle9[[#This Row],[Erwartete Kosten]]-Tabelle9[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Lebensversicherung",null,null,{"$f":"Tabelle4[[#This Row],[Erwartete Kosten]]-Tabelle4[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle9[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle9[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle9[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Sonstige",null,null,{"$f":"Tabelle4[[#This Row],[Erwartete Kosten]]-Tabelle4[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle4[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle4[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle4[Differenz])","v":{"v":0,"d":"0 €"}},null,"SPAREINLAGEN ODER KAPITALANLAGEN","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[{"$nulls":6},"Altersvorsorgekonto",null,null,{"$f":"Tabelle10[[#This Row],[Erwartete Kosten]]-Tabelle10[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"ESSEN","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"Anlagekonto",null,null,{"$f":"Tabelle10[[#This Row],[Erwartete Kosten]]-Tabelle10[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Lebensmittel",null,null,{"$f":"Tabelle5[[#This Row],[Erwartete Kosten]]-Tabelle5[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Sonstiges",null,null,{"$f":"Tabelle10[[#This Row],[Erwartete Kosten]]-Tabelle10[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ausgehen",null,null,{"$f":"Tabelle5[[#This Row],[Erwartete Kosten]]-Tabelle5[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle10[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle10[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle10[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Sonstige",null,null,{"$f":"Tabelle5[[#This Row],[Erwartete Kosten]]-Tabelle5[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle5[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle5[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle5[Differenz])","v":{"v":0,"d":"0 €"}},null,"GESCHENKE UND SPENDEN","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[{"$nulls":6},"Spenden 1",null,null,{"$f":"Tabelle11[[#This Row],[Erwartete Kosten]]-Tabelle11[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"HAUSTIERE","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"Spenden 2",null,null,{"$f":"Tabelle11[[#This Row],[Erwartete Kosten]]-Tabelle11[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Essen",null,null,{"$f":"Tabelle6[[#This Row],[Erwartete Kosten]]-Tabelle6[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Spenden 3",null,null,{"$f":"Tabelle11[[#This Row],[Erwartete Kosten]]-Tabelle11[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Arztkosten",null,null,{"$f":"Tabelle6[[#This Row],[Erwartete Kosten]]-Tabelle6[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle11[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle11[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle11[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Fellpflege",null,null,{"$f":"Tabelle6[[#This Row],[Erwartete Kosten]]-Tabelle6[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Spielzeuge",null,null,{"$f":"Tabelle6[[#This Row],[Erwartete Kosten]]-Tabelle6[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"RECHTSKOSTEN","Erwartete Kosten","Tatsächliche Kosten","Differenz"]
[null,"Sonstige",null,null,{"$f":"Tabelle6[[#This Row],[Erwartete Kosten]]-Tabelle6[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Anwalt",null,null,{"$f":"Tabelle12[[#This Row],[Erwartete Kosten]]-Tabelle12[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle6[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle6[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle6[Differenz])","v":{"v":0,"d":"0 €"}},null,"Unterhalt",null,null,{"$f":"Tabelle12[[#This Row],[Erwartete Kosten]]-Tabelle12[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[{"$nulls":6},"Zahlungen für Pfändungen oder Gerichtsurteile",null,null,{"$f":"Tabelle12[[#This Row],[Erwartete Kosten]]-Tabelle12[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"KÖRPERPFLEGE","Erwartete Kosten","Tatsächliche Kosten","Differenz",null,"Sonstiges",null,null,{"$f":"Tabelle12[[#This Row],[Erwartete Kosten]]-Tabelle12[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Arztkosten",null,null,{"$f":"Tabelle7[[#This Row],[Erwartete Kosten]]-Tabelle7[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle12[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle12[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle12[Differenz])","v":{"v":0,"d":"0 €"}}]
[null,"Haare/Nägel",null,null,{"$f":"Tabelle7[[#This Row],[Erwartete Kosten]]-Tabelle7[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Kleidung",null,null,{"$f":"Tabelle7[[#This Row],[Erwartete Kosten]]-Tabelle7[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"SUMME DER GEPLANTEN KOSTEN",null,null,{"$f":"SUM(C23,C33,C40,C46,C54,C64,H22,H31,H38,H44,H50,H57)","v":{"v":2060,"d":"2,060 €"}}]
[null,"Chemische Reinigung",null,null,{"$f":"Tabelle7[[#This Row],[Erwartete Kosten]]-Tabelle7[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Fitnesscenter",null,null,{"$f":"Tabelle7[[#This Row],[Erwartete Kosten]]-Tabelle7[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"SUMME DER TATSÄCHLICHEN KOSTEN",null,null,{"$f":"SUM(D23,D33,D40,D46,D54,D64,I22,I31,I38,I44,I50,I57)","v":{"v":2040,"d":"2,040 €"}}]
[null,"Vereinsbeiträge",null,null,{"$f":"Tabelle7[[#This Row],[Erwartete Kosten]]-Tabelle7[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}}]
[null,"Sonstiges",null,null,{"$f":"Tabelle7[[#This Row],[Erwartete Kosten]]-Tabelle7[[#This Row],[Tatsächliche Kosten]]","v":{"v":0,"d":"0 €"}},null,"GESAMTDIFFERENZ",null,null,{"$f":"SUM(E23,E33,E40,E46,E54,E64,J22,J31,J38,J44,J50,J57)","v":{"v":20,"d":"20 €"}}]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,Tabelle7[Erwartete Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle7[Tatsächliche Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tabelle7[Differenz])","v":{"v":0,"d":"0 €"}}]