{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Monatliches Einkommen","Monatliche Spareinlagen","Monatliche Ausgaben","Diagrammdaten"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Monatliches Einkommen","index":0,"n_rows":16,"n_cols":3,"rows_kept":16}
[null,"BUDGET"]
[null,"% der ausgegebenen Einnahmen","Zusammenfassung"]
[null,"Kreisdiagramm \"% der ausgegebenen Einkünfte\". Den Prozentwert finden Sie in der Zelle unten","Summe der monatlichen Einkünfte"]
[null,null,{"$f":"SUM(Einkünfte[Betrag])","v":{"v":3750,"d":"3,750 €"}}]
[null,null,"Summe der monatlichen Ausgaben"]
[null,null,{"$f":"SUM(Ausgaben[[#All],[Betrag]])","v":{"v":2058,"d":"2,058 €"}}]
[null,null,"Summe der monatlichen Spareinlagen"]
[null,null,{"$f":"SUM(Spareinlagen[[#All],[Betrag]])","v":{"v":550,"d":"550 €"}}]
[null,null,"Barguthaben"]
[null,null,{"$f":"Monatliche_Einkünfte_gesamt-Monatliche_Ausgaben_gesamt-Monatliche_Spareinlagen_gesamt","v":{"v":1142,"d":"1,142 €"}}]
[null,{"$f":"MIN(Monatliche_Ausgaben_gesamt/Monatliche_Einkünfte_gesamt,1)","v":{"v":0.5488,"d":"55%"}}]
[null,"Monatliches Einkommen"]
[null,"Posten","Betrag"]
[null,"Einkommensquelle 1",{"v":2500,"d":"2,500.00 €"}]
[null,"Einkommensquelle 2",{"v":1000,"d":"1,000.00 €"}]
[null,"Sonstiges",{"v":250,"d":"250.00 €"}]

{"sheet":"Monatliche Spareinlagen","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"Budgettitel","v":"BUDGET"}]
[null,"Monatliche Spareinlagen"]
[null,"Datum","Betrag"]
[null,"Datum",{"v":200,"d":"200.00 €"}]
[null,"Datum",{"v":250,"d":"250.00 €"}]
[null,"Datum",{"v":100,"d":"100.00 €"}]

{"sheet":"Monatliche Ausgaben","index":2,"n_rows":12,"n_cols":3,"rows_kept":12}
[null,{"$f":"Budgettitel","v":"BUDGET"}]
[null,"Monatliche Ausgaben"]
[null,"Posten","Betrag"]
[null,"Miete/Hypothek",{"v":800,"d":"800.00 €"}]
[null,"Strom",{"v":120,"d":"120.00 €"}]
[null,"Gas",{"v":50,"d":"50.00 €"}]
[null,"Mobiltelefon",{"v":45,"d":"45.00 €"}]
[null,"Lebensmittel",{"v":500,"d":"500.00 €"}]
[null,"Rate für Kfz",{"v":273,"d":"273.00 €"}]
[null,"Kreditkarten",{"v":120,"d":"120.00 €"}]
[null,"Autoversicherung",{"v":50,"d":"50.00 €"}]
[null,"Verschiedenes",{"v":100,"d":"100.00 €"}]

{"sheet":"Diagrammdaten","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[null,"DIAGRAMMDATEN"]
[null,{"$f":"MIN(1-B3,1)","v":{"v":0.45120000000000005,"d":"45%"}}]
[null,{"$f":"MIN(Monatliche_Ausgaben_gesamt/Monatliche_Einkünfte_gesamt,1)","v":{"v":0.5488,"d":"55%"}}]
[null,{"$f":"(Monatliche_Ausgaben_gesamt/Monatliche_Einkünfte_gesamt)>1","v":false}]