{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Zusammenfassung","Monatliche Einkünfte","Monatliche Ausgaben","Monatliche Spareinlagen","Diagrammdaten"],"not_rendered":{"charts":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"Zusammenfassung","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[2,1,9,1],[2,3,10,7]]}
[null,"Persönliches Budget"]
[null,"Ausgegebener Prozentsatz der Einkünfte","Zusammenfassung"]
[null,{"$f":"Ausgegebener_Prozentsatz_der_Einkünfte","v":{"v":0.6229333333333333,"d":"62%"}},"SUMME MONATLICHE EINKÜNFTE","Das Säulendiagramm mit der Summe der monatlichen Einkünfte und der Summe der monatlichen Ausgaben befindet sich in dieser Zelle."]
[null,null,{"$f":"SUM(MonatlicheEinkünfte[[#All],[BETRAG]])","v":{"v":3750,"d":"3,750 €"}}]
[null,null,"SUMME MONATLICHE AUSGABEN"]
[null,null,{"$f":"SUM(MonatlicheAusgaben[[#All],[BETRAG]])","v":{"v":2336,"d":"2,336 €"}}]
[null,null,"SUMME MONATLICHE SPAREINLAGEN"]
[null,null,{"$f":"SUM(Spareinlagen[[#All],[BETRAG]])","v":{"v":550,"d":"550 €"}}]
[null,null,"KASSENBESTAND"]
[null,null,{"$f":"SummeMonatlicheEinkünfte-SummeMonatlicheAusgaben-SummeMonatlicheSpareinlagen","v":{"v":864,"d":"864 €"}}]

{"sheet":"Monatliche Einkünfte","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"Budgettitel","v":"Persönliches Budget"}]
[null,"Monatliche Einkünfte"]
[null,"POSTEN","BETRAG"]
[null,"Einkünfte Quelle 1",{"v":2500,"d":"2,500.00 €"}]
[null,"Einkünfte Quelle 2",{"v":1000,"d":"1,000.00 €"}]
[null,"Sonstiges",{"v":250,"d":"250.00 €"}]

{"sheet":"Monatliche Ausgaben","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,{"$f":"Budgettitel","v":"Persönliches Budget"}]
[null,"Monatliche Ausgaben"]
[null,"POSTEN","FÄLLIGKEITSDATUM","BETRAG"]
[null,"Miete/Hypothek","Datum",{"v":800,"d":"800.00 €"}]
[null,"Strom","Datum",{"v":120,"d":"120.00 €"}]
[null,"Gas","Datum",{"v":50,"d":"50.00 €"}]
[null,"Mobiltelefon","Datum",{"v":45,"d":"45.00 €"}]
[null,"Lebensmittel","Datum",{"v":500,"d":"500.00 €"}]
[null,"Rate für Kfz","Datum",{"v":273,"d":"273.00 €"}]
[null,"Kfz-Kosten","Datum",{"v":120,"d":"120.00 €"}]
[null,"Studienkredite","Datum",{"v":50,"d":"50.00 €"}]
[null,"Kreditkarten","Datum",{"v":100,"d":"100.00 €"}]
[null,"Autoversicherung","Datum",{"v":78,"d":"78.00 €"}]
[null,"Persönlicher Bedarf","Datum",{"v":50,"d":"50.00 €"}]
[null,"Unterhaltung","Datum",{"v":100,"d":"100.00 €"}]
[null,"Verschiedenes","Datum",{"v":50,"d":"50.00 €"}]

{"sheet":"Monatliche Spareinlagen","index":3,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"Budgettitel","v":"Persönliches 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":"Diagrammdaten","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[]
[null,"DIAGRAMMDATEN"]
[]
[null,{"$f":"MIN(1,1-B5)","v":{"v":0.37706666666666666,"d":"38%"}}]
[null,{"$f":"MIN(SummeMonatlicheAusgaben/SummeMonatlicheEinkünfte,1)","v":{"v":0.6229333333333333,"d":"62%"}}]
[null,{"$f":"(SummeMonatlicheAusgaben/SummeMonatlicheEinkünfte)>1","v":false}]