{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Leitfaden","Täglicher Cashflow","Monatlicher Cashflow","Jährlicher Cashflow","Einkünfte","Ausgaben","Frei verfügbar","Spareinlagen"],"not_rendered":{"charts":4,"external_links":1,"defined_names":35,"pivot_tables":8},"read":"whole","date_system":"1900"}

{"sheet":"Leitfaden","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,7],[2,1,2,8]]}
[{"$nulls":11}," "]
[null,"PRIVATER CASHFLOW"]
[null,"  Diese Arbeitsmappe enthält jährliche, monatliche und tägliche „Cashflow“-Arbeitsblätter. \n  Wählen Sie den Cashflowtyp aus, der für Sie am besten funktioniert, oder verwenden Sie sie alle, um einen Einblick in Ihren privaten Cashflow zu gewinnen."]
[]
[null,"Täglicher Cashflow",null,null,"Monatlicher Cashflow",null,null,"Jährlicher Cashflow"]
[]
[null,"Geben Sie einen Schätzbetrag für Ihren täglichen Cashflow ein, und überprüfen Sie die geschätzten monatlichen und jährlichen Summen.  Verwenden Sie dies, um ein Gespür dafür zu entwickeln, wie sich Ihr tägliches Ausgabenverhalten im Laufe eines Monats oder Jahres auswirkt.",null,null,"Geben Sie den monatlichen Cashflow ein, oder schätzen Sie ihn für die verbleibenden Monate, um den für das Jahr prognostizierten Cashflow für die einzelnen Monate zu sehen.",null,null,"Geben Sie einen jährlichen Cashflowbetrag in vier Arbeitsblättern ein: Einkommen, Ausgaben, frei verfügbar und Spareinlagen. \nSehen Sie sich die monatliche Aufschlüsselung und alle Posten im Vergleich an, und, was sich im Monat und im Jahr unterm Strich ergibt."]

{"sheet":"Täglicher Cashflow","index":1,"n_rows":55,"n_cols":9,"rows_kept":55,"merged":[[1,3,1,4],[1,5,1,8]]}
[null,"PRIVATER CASHFLOW",{"$nulls":3}," "," ",null," "]
[null,null,"Gesamtes verfügbares Bargeld:",{"$f":"TäglicherCashFlow","v":{"v":577.8399999999999,"d":"577.84 €"}},null,"HINWEIS: Wenn Sie der Tabelle tägliche Posten hinzufügen möchten, schätzen Sie den monatlichen Betrag/Wert ab, und setzen Sie diesen Wert in die entsprechende Monatsspalte ein."]
[]
[null,"TÄGLICHE ZUSAMMENFASSUNG"]
[null,"Summen","Täglich","Monatlich","Jährlich "]
[null,"Einkünfte",{"$f":"SUMIF(Täglich[Typ],$B6,Täglich[Täglich])","v":{"v":342.47,"d":"342.47 €"}},{"$f":"SUMIF(Täglich[Typ],$B6,Täglich[Monatlich])","v":{"v":10416.795833333334,"d":"10,416.80 €"}},{"$f":"SUMIF(Täglich[Typ],$B6,Täglich[Jährlich])","v":{"v":125001.55000000002,"d":"125,001.55 €"}}]
[null,"Ausgaben",{"$f":"SUMIF(Täglich[Typ],$B7,Täglich[Täglich])","v":{"v":136.05999999999997,"d":"136.06 €"}},{"$f":"SUMIF(Täglich[Typ],$B7,Täglich[Monatlich])","v":{"v":4138.491666666667,"d":"4,138.49 €"}},{"$f":"SUMIF(Täglich[Typ],$B7,Täglich[Jährlich])","v":{"v":49661.899999999994,"d":"49,661.90 €"}}]
[null,"Frei verfügbar",{"$f":"SUMIF(Täglich[Typ],$B8,Täglich[Täglich])","v":{"v":36.29,"d":"36.29 €"}},{"$f":"SUMIF(Täglich[Typ],$B8,Täglich[Monatlich])","v":{"v":1103.8208333333334,"d":"1,103.82 €"}},{"$f":"SUMIF(Täglich[Typ],$B8,Täglich[Jährlich])","v":{"v":13245.849999999999,"d":"13,245.85 €"}}]
[null,"Spareinlagen",{"$f":"SUMIF(Täglich[Typ],$B9,Täglich[Täglich])","v":{"v":63.019999999999996,"d":"63.02 €"}},{"$f":"SUMIF(Täglich[Typ],$B9,Täglich[Monatlich])","v":{"v":1916.8583333333333,"d":"1,916.86 €"}},{"$f":"SUMIF(Täglich[Typ],$B9,Täglich[Jährlich])","v":{"v":23002.300000000003,"d":"23,002.30 €"}}]
[]
[null,"Typ","Beschreibung","Täglich","Monatlich","Jährlich"]
[null,"Einkünfte","Gehalt",{"v":246.58,"d":"246.58 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":7500.141666666667,"d":"7,500.14 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":90001.70000000001,"d":"90,001.70 €"}}]
[null,"Einkünfte","Provisionen/Boni",{"v":13.7,"d":"13.70 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":416.7083333333333,"d":"416.71 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":5000.5,"d":"5,000.50 €"}}]
[null,"Einkünfte","Sonstiges 1",{"v":82.19,"d":"82.19 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":2499.945833333333,"d":"2,499.95 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":29999.35,"d":"29,999.35 €"}}]
[null,"Einkünfte","Sonstiges 2",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Einkünfte","Sonstiges 3",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Einkünfte","Sonstiges 4",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Ausgaben","Krankenversicherung/Arbeitslosenversicherung",{"v":41.1,"d":"41.10 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":1250.125,"d":"1,250.13 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":15001.5,"d":"15,001.50 €"}}]
[null,"Ausgaben","Einkommensteuer",{"v":6.85,"d":"6.85 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":208.35416666666666,"d":"208.35 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":2500.25,"d":"2,500.25 €"}}]
[null,"Ausgaben","Kfz-Steuer/Gebühren",{"v":0.55,"d":"0.55 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":16.729166666666668,"d":"16.73 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":200.75000000000003,"d":"200.75 €"}}]
[null,"Ausgaben","Kfz-Kosten",{"v":10.96,"d":"10.96 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":333.3666666666667,"d":"333.37 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":4000.4,"d":"4,000.40 €"}}]
[null,"Ausgaben","Hypothek/Miete",{"v":41.1,"d":"41.10 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":1250.125,"d":"1,250.13 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":15001.5,"d":"15,001.50 €"}}]
[null,"Ausgaben","Versicherungen",{"v":0.68,"d":"0.68 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":20.683333333333334,"d":"20.68 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":248.20000000000002,"d":"248.20 €"}}]
[null,"Ausgaben","Strom",{"v":3.29,"d":"3.29 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":100.07083333333333,"d":"100.07 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":1200.85,"d":"1,200.85 €"}}]
[null,"Ausgaben","Gas",{"v":1.64,"d":"1.64 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Ausgaben","Wasser",{"v":1.64,"d":"1.64 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Ausgaben","Abwasser",{"v":0.82,"d":"0.82 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":24.941666666666663,"d":"24.94 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":299.29999999999995,"d":"299.30 €"}}]
[null,"Ausgaben","Müllabfuhr",{"v":0.41,"d":"0.41 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":12.470833333333331,"d":"12.47 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":149.64999999999998,"d":"149.65 €"}}]
[null,"Ausgaben","Telefon",{"v":1.64,"d":"1.64 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Ausgaben","Internet",{"v":1.64,"d":"1.64 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Ausgaben","Invaliditätsprämien",{"v":4.11,"d":"4.11 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":125.0125,"d":"125.01 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":1500.15,"d":"1,500.15 €"}}]
[null,"Ausgaben","Essen",{"v":13.7,"d":"13.70 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":416.7083333333333,"d":"416.71 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":5000.5,"d":"5,000.50 €"}}]
[null,"Ausgaben","Kleidung",{"v":3.29,"d":"3.29 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":100.07083333333333,"d":"100.07 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":1200.85,"d":"1,200.85 €"}}]
[null,"Ausgaben","Arzt/Zahnarzt/Rezepte",{"v":1.64,"d":"1.64 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Ausgaben","Bus",{"v":1,"d":"1.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":30.416666666666668,"d":"30.42 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":365,"d":"365.00 €"}}]
[null,"Ausgaben","Sonstiges 2",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Ausgaben","Sonstiges 3",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Ausgaben","Sonstiges 4",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Frei verfügbar","Ausgehen",{"v":3.29,"d":"3.29 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":100.07083333333333,"d":"100.07 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":1200.85,"d":"1,200.85 €"}}]
[null,"Frei verfügbar","Geschenke",{"v":1.64,"d":"1.64 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Frei verfügbar","Reise",{"v":6.16,"d":"6.16 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":187.36666666666667,"d":"187.37 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":2248.4,"d":"2,248.40 €"}}]
[null,"Frei verfügbar","Unterhaltung",{"v":3.29,"d":"3.29 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":100.07083333333333,"d":"100.07 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":1200.85,"d":"1,200.85 €"}}]
[null,"Frei verfügbar","Körperpflege",{"v":0.82,"d":"0.82 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":24.941666666666663,"d":"24.94 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":299.29999999999995,"d":"299.30 €"}}]
[null,"Frei verfügbar","Einkaufsliste",{"v":5.48,"d":"5.48 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":166.68333333333334,"d":"166.68 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":2000.2,"d":"2,000.20 €"}}]
[null,"Frei verfügbar","Spenden",{"v":1.64,"d":"1.64 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":49.883333333333326,"d":"49.88 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":598.5999999999999,"d":"598.60 €"}}]
[null,"Frei verfügbar","Clubs/Mitgliedschaften",{"v":0.82,"d":"0.82 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":24.941666666666663,"d":"24.94 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":299.29999999999995,"d":"299.30 €"}}]
[null,"Frei verfügbar","Baumaßnahmen",{"v":13.15,"d":"13.15 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":399.9791666666667,"d":"399.98 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":4799.75,"d":"4,799.75 €"}}]
[null,"Frei verfügbar","Sonstiges 1",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Frei verfügbar","Sonstiges 2",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Spareinlagen","Barreserven",{"v":13.7,"d":"13.70 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":416.7083333333333,"d":"416.71 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":5000.5,"d":"5,000.50 €"}}]
[null,"Spareinlagen","401(k)/Etc",{"v":32.88,"d":"32.88 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":1000.1,"d":"1,000.10 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":12001.2,"d":"12,001.20 €"}}]
[null,"Spareinlagen","Sparkonto",{"v":16.44,"d":"16.44 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":500.05,"d":"500.05 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":6000.6,"d":"6,000.60 €"}}]
[null,"Spareinlagen","Sonstiges 1",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Spareinlagen","Sonstiges 2",{"v":0,"d":"0.00 €"},{"$f":"Täglich[[#This Row],[Jährlich]]/12","v":{"v":0,"d":"0.00 €"}},{"$f":"Täglich[[#This Row],[Täglich]]*365","v":{"v":0,"d":"0.00 €"}}]
[null,"Ergebnis",null,{"$f":"SUMIF(Täglich[Typ],\"Einkünfte\",Täglich[Täglich])-SUMIF(Täglich[Typ],\"<>Einkünfte\",Täglich[Täglich])","v":{"v":107.10000000000014,"d":"107.10 €"}},{"$f":"SUMIF(Täglich[Typ],\"Einkünfte\",Täglich[Monatlich])-SUMIF(Täglich[Typ],\"<>Einkünfte\",Täglich[Monatlich])","v":{"v":3257.625,"d":"3,257.63 €"}},{"$f":"SUMIF(Täglich[Typ],\"Einkünfte\",Täglich[Jährlich])-SUMIF(Täglich[Typ],\"<>Einkünfte\",Täglich[Jährlich])","v":{"v":39091.500000000015,"d":"39,091.50 €"}}]

{"sheet":"Monatlicher Cashflow","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[1,3,1,4],[1,5,1,10]]}
[null,"PRIVATER CASHFLOW",{"$nulls":5}," "," "," ",{"$nulls":7}," "]
[null,null,"Gesamter monatlicher Cashflow:",{"$f":"MonatlicherCashFlowBisDatum","v":{"v":18380,"d":"18,380.00 €"}},null,"ANMERKUNG: Schätzen Sie für tägliche Posten den monatlichen Betrag/Wert ab, und setzen Sie diesen Wert in die entsprechende Monatsspalte ein.\n"]
[]
[null,"Typ","Beschreibung","Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Ergebnis"]
[null,"Einkünfte","Gehalt",{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":45000,"d":"45,000.00 €"}}]
[null,"Einkünfte","Provisionen/Boni",{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":500,"d":"500.00 €"},{"v":200,"d":"200.00 €"},{"v":0,"d":"0.00 €"},{"v":600,"d":"600.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":2100,"d":"2,100.00 €"}}]
[null,"Einkünfte","Sonstiges 1",{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"v":2500,"d":"2,500.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":15000,"d":"15,000.00 €"}}]
[null,"Einkünfte","Sonstiges 2",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Einkünfte","Sonstiges 3",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Einkünfte","Sonstiges 4",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Ausgaben","Krankenversicherung/Arbeitslosenversicherung",{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Ausgaben","Einkommensteuer",{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"v":208.33333333333334,"d":"208.33 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":1250,"d":"1,250.00 €"}}]
[null,"Ausgaben","Kfz-Steuer/Gebühren",{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"v":16.666666666666668,"d":"16.67 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":100.00000000000001,"d":"100.00 €"}}]
[null,"Ausgaben","Kfz-Kosten",{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"v":333.3333333333333,"d":"333.33 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":1999.9999999999998,"d":"2,000.00 €"}}]
[null,"Ausgaben","Hypothek/Miete",{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"v":1250,"d":"1,250.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Ausgaben","Versicherungen",{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Ausgaben","Strom",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Ausgaben","Gas",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Ausgaben","Wasser",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Ausgaben","Abwasser",{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Ausgaben","Müllabfuhr",{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"v":12.5,"d":"12.50 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":75,"d":"75.00 €"}}]
[null,"Ausgaben","Telefon",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Ausgaben","Internet",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Ausgaben","Invaliditätsprämien",{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"v":125,"d":"125.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":750,"d":"750.00 €"}}]
[null,"Ausgaben","Essen",{"v":400,"d":"400.00 €"},{"v":500,"d":"500.00 €"},{"v":450,"d":"450.00 €"},{"v":400,"d":"400.00 €"},{"v":450,"d":"450.00 €"},{"v":425,"d":"425.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":2625,"d":"2,625.00 €"}}]
[null,"Ausgaben","Kleidung",{"v":50,"d":"50.00 €"},{"v":75,"d":"75.00 €"},{"v":100,"d":"100.00 €"},{"v":75,"d":"75.00 €"},{"v":125,"d":"125.00 €"},{"v":75,"d":"75.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":500,"d":"500.00 €"}}]
[null,"Ausgaben","Arzt/Zahnarzt/Rezepte",{"v":50,"d":"50.00 €"},{"v":10,"d":"10.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":20,"d":"20.00 €"},{"v":70,"d":"70.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":200,"d":"200.00 €"}}]
[null,"Ausgaben","Bus",{"v":30,"d":"30.00 €"},{"v":30,"d":"30.00 €"},{"v":30,"d":"30.00 €"},{"v":20,"d":"20.00 €"},{"v":30,"d":"30.00 €"},{"v":30,"d":"30.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":170,"d":"170.00 €"}}]
[null,"Ausgaben","Sonstiges 2",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Ausgaben","Sonstiges 3",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Ausgaben","Sonstiges 4",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Frei verfügbar","Ausgehen",{"v":50,"d":"50.00 €"},{"v":150,"d":"150.00 €"},{"v":100,"d":"100.00 €"},{"v":50,"d":"50.00 €"},{"v":150,"d":"150.00 €"},{"v":100,"d":"100.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Frei verfügbar","Geschenke",{"v":25,"d":"25.00 €"},{"v":75,"d":"75.00 €"},{"v":50,"d":"50.00 €"},{"v":25,"d":"25.00 €"},{"v":75,"d":"75.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Frei verfügbar","Reise",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":1000,"d":"1,000.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":2000,"d":"2,000.00 €"}}]
[null,"Frei verfügbar","Unterhaltung",{"v":50,"d":"50.00 €"},{"v":150,"d":"150.00 €"},{"v":100,"d":"100.00 €"},{"v":50,"d":"50.00 €"},{"v":150,"d":"150.00 €"},{"v":100,"d":"100.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":600,"d":"600.00 €"}}]
[null,"Frei verfügbar","Körperpflege",{"v":15,"d":"15.00 €"},{"v":25,"d":"25.00 €"},{"v":35,"d":"35.00 €"},{"v":15,"d":"15.00 €"},{"v":25,"d":"25.00 €"},{"v":35,"d":"35.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Frei verfügbar","Einkaufsliste",{"v":100,"d":"100.00 €"},{"v":200,"d":"200.00 €"},{"v":150,"d":"150.00 €"},{"v":175,"d":"175.00 €"},{"v":150,"d":"150.00 €"},{"v":175,"d":"175.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":950,"d":"950.00 €"}}]
[null,"Frei verfügbar","Spenden",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":300,"d":"300.00 €"}}]
[null,"Frei verfügbar","Clubs/Mitgliedschaften",{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":150,"d":"150.00 €"}}]
[null,"Frei verfügbar","Baumaßnahmen",{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":2400,"d":"2,400.00 €"}}]
[null,"Frei verfügbar","Sonstiges 1",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Frei verfügbar","Sonstiges 2",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Spareinlagen","Barreserven",{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"v":416.6666666666667,"d":"416.67 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":2500,"d":"2,500.00 €"}}]
[null,"Spareinlagen","401(k)/Etc",{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":6000,"d":"6,000.00 €"}}]
[null,"Spareinlagen","Sparkonto",{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":3000,"d":"3,000.00 €"}}]
[null,"Spareinlagen","Sonstiges 1",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Spareinlagen","Sonstiges 2",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$nulls":6},{"$f":"SUM(Monatlich[[#This Row],[Jan]:[Dez]])","v":{"v":0,"d":"0.00 €"}}]
[null,"Ergebnis",null,{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Jan])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Jan])","v":{"v":3692.5,"d":"3,692.50 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Feb])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Feb])","v":{"v":3247.5,"d":"3,247.50 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Mrz])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Mrz])","v":{"v":2522.5,"d":"2,522.50 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Apr])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Apr])","v":{"v":3427.5,"d":"3,427.50 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Mai])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Mai])","v":{"v":2887.5,"d":"2,887.50 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Jun])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Jun])","v":{"v":2602.5,"d":"2,602.50 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Jul])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Jul])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Aug])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Aug])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Sep])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Sep])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Okt])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Okt])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Nov])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Nov])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Dez])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Dez])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Monatlich[Typ],\"Einkünfte\",Monatlich[Ergebnis])-SUMIF(Monatlich[Typ],\"<>Einkünfte\",Monatlich[Ergebnis])","v":{"v":18380,"d":"18,380.00 €"}}]

{"sheet":"Jährlicher Cashflow","index":3,"n_rows":29,"n_cols":28,"rows_kept":29,"merged":[[1,3,1,4],[1,6,1,11],[3,1,3,3],[3,5,3,7],[3,9,3,11],[3,13,3,15],[4,2,4,3],[4,6,4,7],[4,10,4,11],[4,14,4,15],[7,2,7,3],[7,6,7,7],[7,10,7,11],[7,14,7,15]]}
[null,"PRIVATER CASHFLOW",{"$nulls":5}," ",null," ",null," ",{"$nulls":4}," "]
[null,null,"Gesamter Cashflow bis Datum:",{"$f":"JährlicherCashFlowBisDatum","v":{"v":42250,"d":"42,250.00 €"}},null,null,"Dies ist eine Abschätzung aufs Jahr. Verwenden Sie dieses Arbeitsblatt, wenn Sie Jahresbeträge mit geschätzten Werten für die Monate anzeigen möchten. Verwenden Sie Arbeitsblätter „Einkommen“, „Ausgaben“, „Frei verfügbar“ und „Spareinlagen“, um Artikel einzugeben."]
[]
[null,"ZUSAMMENFASSUNG DER EINKÜNFTE",{"$nulls":3},"ZUSAMMENFASSUNG DER AUSGABEN",{"$nulls":3},"FREI VERFÜGBAR-ZUSAMMENFASSUNG",{"$nulls":3},"ZUSAMMENFASSUNG SPAREINLAGEN"]
[null,"Jahressumme:",{"$f":"Einkünfte!C11","v":{"v":125000,"d":"125,000.00 €"}},null,null,"Jahressumme:",{"$f":"Ausgaben[[#Totals],[Jährlich  ]]","v":{"v":46500,"d":"46,500.00 €"}},null,null,"Jahressumme:",{"$f":"Frei_verfügbar[[#Totals],[Jährlich  ]]","v":{"v":13250,"d":"13,250.00 €"}},null,null,"Jahressumme:",{"$f":"Spareinlagen[[#Totals],[Jährlich  ]]","v":{"v":23000,"d":"23,000.00 €"}}]
[]
[]
[null,"Monatssumme:",{"$f":"Einkünfte!D11","v":{"v":10416.666666666668,"d":"10,416.67 €"}},null,null,"Monatssumme:",{"$f":"Ausgaben[[#Totals],[Monatlich ]]","v":{"v":3875,"d":"3,875.00 €"}},null,null,"Monatssumme:",{"$f":"Frei_verfügbar[[#Totals],[Monatlich ]]","v":{"v":1104.1666666666665,"d":"1,104.17 €"}},null,null,"Monatssumme:",{"$f":"Spareinlagen[[#Totals],[Monatlich ]]","v":{"v":1916.6666666666667,"d":"1,916.67 €"}}]
[]
[{"$nulls":17},"Zeilenbeschriftungen","Jahreseinkommen",null,"Zeilenbeschriftungen","Summe der jährlichen",null,"Zeilenbeschriftungen","Summe der jährlichen",null,"Zeilenbeschriftungen","Summe der jährlichen"]
[{"$nulls":17},"Gehalt",{"v":90000,"d":"90,000 €"},null,"Arzt/Zahnarzt/Rezepte",{"v":600,"d":"600 €"},null,"Ausgehen",{"v":1200,"d":"1,200 €"},null,"Barreserven",{"v":5000,"d":"5,000 €"}]
[{"$nulls":17},"Provisionen/Boni",{"v":5000,"d":"5,000 €"},null,"Einkommensteuer",{"v":2500,"d":"2,500 €"},null,"Baumaßnahmen",{"v":4800,"d":"4,800 €"},null,"Betriebsrente",{"v":12000,"d":"12,000 €"}]
[{"$nulls":17},"Sonstiges 1",{"v":30000,"d":"30,000 €"},null,"Essen",{"v":5000,"d":"5,000 €"},null,"Clubs/Mitgliedschaften",{"v":300,"d":"300 €"},null,"Sonstiges 1",{"v":0,"d":"0 €"}]
[{"$nulls":17},"Sonstiges 2",{"v":0,"d":"0 €"},null,"Gas",{"v":600,"d":"600 €"},null,"Einkaufsliste",{"v":2000,"d":"2,000 €"},null,"Sonstiges 2",{"v":0,"d":"0 €"}]
[{"$nulls":17},"Sonstiges 3",{"v":0,"d":"0 €"},null,"Hypothek/Miete",{"v":15000,"d":"15,000 €"},null,"Geschenke",{"v":600,"d":"600 €"},null,"Spareinlagen/Investments",{"v":6000,"d":"6,000 €"}]
[{"$nulls":17},"Sonstiges 4",{"v":0,"d":"0 €"},null,"Internet",{"v":600,"d":"600 €"},null,"Körperpflege",{"v":300,"d":"300 €"},null,"Gesamtsumme",{"v":23000,"d":"23,000 €"}]
[{"$nulls":17},"Gesamtsumme",{"v":125000,"d":"125,000 €"},null,"Invaliditätsprämien",{"v":1500,"d":"1,500 €"},null,"Reise",{"v":2250,"d":"2,250 €"}]
[{"$nulls":20},"Kfz-Kosten",{"v":4000,"d":"4,000 €"},null,"Sonstiges 1",{"v":0,"d":"0 €"}]
[{"$nulls":20},"Kfz-Steuer/Gebühren",{"v":200,"d":"200 €"},null,"Sonstiges 2",{"v":0,"d":"0 €"}]
[{"$nulls":20},"Kleidung",{"v":1200,"d":"1,200 €"},null,"Spenden",{"v":600,"d":"600 €"}]
[{"$nulls":20},"Krankenversicherung/Arbeitslosenversicherung",{"v":12500,"d":"12,500 €"},null,"Unterhaltung",{"v":1200,"d":"1,200 €"}]
[{"$nulls":20},"Müllabfuhr",{"v":150,"d":"150 €"},null,"Gesamtsumme",{"v":13250,"d":"13,250 €"}]
[{"$nulls":20},"Sonstiges 1",{"v":0,"d":"0 €"}]
[{"$nulls":20},"Sonstiges 2",{"v":0,"d":"0 €"}]
[{"$nulls":20},"Strom",{"v":1200,"d":"1,200 €"}]
[{"$nulls":20},"Telefon",{"v":600,"d":"600 €"}]
[{"$nulls":20},"Versicherungen",{"v":250,"d":"250 €"}]
[{"$nulls":20},"Wasser/Abwasser",{"v":600,"d":"600 €"}]
[{"$nulls":20},"Gesamtsumme",{"v":46500,"d":"46,500 €"}]

{"sheet":"Einkünfte","index":4,"n_rows":11,"n_cols":9,"rows_kept":11,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PRIVATER CASHFLOW",{"$nulls":3}," ",null," "," "]
[null,null,"Gesamter Cashflow bis Datum:",{"$f":"JährlicherCashFlowBisDatum","v":{"v":42250,"d":"42,250.00 €"}},null,"Dies ist eine Abschätzung aufs Jahr. Verwenden Sie dieses Arbeitsblatt, wenn Sie Jahresbeträge mit geschätzten Werten für die Monate anzeigen möchten.\nWenn Sie den Tabellen tägliche Posten hinzufügen möchten, schätzen Sie den jährlichen Betrag/Wert ab, und setzen Sie diesen Wert in die entsprechende Jahresspalte ein."]
[]
[null,"Einkünfte","Jährlich  ","Monatlich "]
[null,"Gehalt",{"v":90000,"d":"90,000.00 €"},{"$f":"Einkünfte[[#This Row],[Jährlich  ]]/12","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Provisionen/Boni",{"v":5000,"d":"5,000.00 €"},{"$f":"Einkünfte[[#This Row],[Jährlich  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Sonstiges 1",{"v":30000,"d":"30,000.00 €"},{"$f":"Einkünfte[[#This Row],[Jährlich  ]]/12","v":{"v":2500,"d":"2,500.00 €"}}]
[null,"Sonstiges 2",{"v":0,"d":"0.00 €"},{"$f":"Einkünfte[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Sonstiges 3",{"v":0,"d":"0.00 €"},{"$f":"Einkünfte[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Sonstiges 4",{"v":0,"d":"0.00 €"},{"$f":"Einkünfte[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null," Ergebnis",{"$f":"SUBTOTAL(109,Einkünfte[[Jährlich  ]])","v":{"v":125000,"d":"125,000.00 €"}},{"$f":"SUBTOTAL(109,Einkünfte[[Monatlich ]])","v":{"v":10416.666666666668,"d":"10,416.67 €"}}]

{"sheet":"Ausgaben","index":5,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PRIVATER CASHFLOW",{"$nulls":3}," "," "," "," "]
[null,null,"Gesamter Cashflow bis Datum:",{"$f":"JährlicherCashFlowBisDatum","v":{"v":42250,"d":"42,250.00 €"}},null,"Dies ist eine Abschätzung aufs Jahr. Verwenden Sie dieses Arbeitsblatt, wenn Sie Jahresbeträge mit geschätzten Werten für die Monate anzeigen möchten.\nWenn Sie den Tabellen tägliche Posten hinzufügen möchten, schätzen Sie den jährlichen Betrag/Wert ab, und setzen Sie diesen Wert in die entsprechende Jahresspalte ein."]
[]
[null,"Ausgaben","Jährlich  ","Monatlich "]
[null,"Krankenversicherung/Arbeitslosenversicherung",{"v":12500,"d":"12,500.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":1041.6666666666667,"d":"1,041.67 €"}}]
[null,"Einkommensteuer",{"v":2500,"d":"2,500.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":208.33333333333334,"d":"208.33 €"}}]
[null,"Kfz-Steuer/Gebühren",{"v":200,"d":"200.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":16.666666666666668,"d":"16.67 €"}}]
[null,"Kfz-Kosten",{"v":4000,"d":"4,000.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":333.3333333333333,"d":"333.33 €"}}]
[null,"Hypothek/Miete",{"v":15000,"d":"15,000.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":1250,"d":"1,250.00 €"}}]
[null,"Versicherungen",{"v":250,"d":"250.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":20.833333333333332,"d":"20.83 €"}}]
[null,"Strom",{"v":1200,"d":"1,200.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Gas",{"v":600,"d":"600.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Wasser/Abwasser",{"v":600,"d":"600.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Müllabfuhr",{"v":150,"d":"150.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":12.5,"d":"12.50 €"}}]
[null,"Telefon",{"v":600,"d":"600.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Internet",{"v":600,"d":"600.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Invaliditätsprämien",{"v":1500,"d":"1,500.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":125,"d":"125.00 €"}}]
[null,"Essen",{"v":5000,"d":"5,000.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Kleidung",{"v":1200,"d":"1,200.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Arzt/Zahnarzt/Rezepte",{"v":600,"d":"600.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Sonstiges 1",{"v":0,"d":"0.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Sonstiges 2",{"v":0,"d":"0.00 €"},{"$f":"Ausgaben[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null," Ergebnis",{"$f":"SUBTOTAL(109,Ausgaben[[Jährlich  ]])","v":{"v":46500,"d":"46,500.00 €"}},{"$f":"SUBTOTAL(109,Ausgaben[[Monatlich ]])","v":{"v":3875,"d":"3,875.00 €"}}]

{"sheet":"Frei verfügbar","index":6,"n_rows":16,"n_cols":9,"rows_kept":16,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PRIVATER CASHFLOW",{"$nulls":3}," "," "," "," "]
[null,null,"Gesamter Cashflow bis Datum:",{"$f":"JährlicherCashFlowBisDatum","v":{"v":42250,"d":"42,250.00 €"}},null,"Dies ist eine Abschätzung aufs Jahr. Verwenden Sie dieses Arbeitsblatt, wenn Sie Jahresbeträge mit geschätzten Werten für die Monate anzeigen möchten.\nWenn Sie den Tabellen tägliche Posten hinzufügen möchten, schätzen Sie den jährlichen Betrag/Wert ab, und setzen Sie diesen Wert in die entsprechende Jahresspalte ein."]
[]
[null,"Frei verfügbar","Jährlich  ","Monatlich "]
[null,"Ausgehen",{"v":1200,"d":"1,200.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Geschenke",{"v":600,"d":"600.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Reise",{"v":2250,"d":"2,250.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":187.5,"d":"187.50 €"}}]
[null,"Unterhaltung",{"v":1200,"d":"1,200.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Körperpflege",{"v":300,"d":"300.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":25,"d":"25.00 €"}}]
[null,"Einkaufsliste",{"v":2000,"d":"2,000.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":166.66666666666666,"d":"166.67 €"}}]
[null,"Spenden",{"v":600,"d":"600.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Clubs/Mitgliedschaften",{"v":300,"d":"300.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":25,"d":"25.00 €"}}]
[null,"Baumaßnahmen",{"v":4800,"d":"4,800.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":400,"d":"400.00 €"}}]
[null,"Sonstiges 1",{"v":0,"d":"0.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Sonstiges 2",{"v":0,"d":"0.00 €"},{"$f":"Frei_verfügbar[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null," Ergebnis",{"$f":"SUBTOTAL(109,Frei_verfügbar[[Jährlich  ]])","v":{"v":13250,"d":"13,250.00 €"}},{"$f":"SUBTOTAL(109,Frei_verfügbar[[Monatlich ]])","v":{"v":1104.1666666666665,"d":"1,104.17 €"}}]

{"sheet":"Spareinlagen","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PRIVATER CASHFLOW",{"$nulls":3}," "," "," ",null," "]
[null,null,"Gesamter Cashflow bis Datum:",{"$f":"JährlicherCashFlowBisDatum","v":{"v":42250,"d":"42,250.00 €"}},null,"Dies ist eine Abschätzung aufs Jahr. Verwenden Sie dieses Arbeitsblatt, wenn Sie Jahresbeträge mit geschätzten Werten für die Monate anzeigen möchten.\nWenn Sie den Tabellen tägliche Posten hinzufügen möchten, schätzen Sie den jährlichen Betrag/Wert ab, und setzen Sie diesen Wert in die entsprechende Jahresspalte ein."]
[]
[null,"Spareinlagen","Jährlich  ","Monatlich "]
[null,"Barreserven",{"v":5000,"d":"5,000.00 €"},{"$f":"Spareinlagen[[#This Row],[Jährlich  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Betriebsrente",{"v":12000,"d":"12,000.00 €"},{"$f":"Spareinlagen[[#This Row],[Jährlich  ]]/12","v":{"v":1000,"d":"1,000.00 €"}}]
[null,"Spareinlagen/Investments",{"v":6000,"d":"6,000.00 €"},{"$f":"Spareinlagen[[#This Row],[Jährlich  ]]/12","v":{"v":500,"d":"500.00 €"}}]
[null,"Sonstiges 1",{"v":0,"d":"0.00 €"},{"$f":"Spareinlagen[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Sonstiges 2",{"v":0,"d":"0.00 €"},{"$f":"Spareinlagen[[#This Row],[Jährlich  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null," Ergebnis",{"$f":"SUBTOTAL(109,Spareinlagen[[Jährlich  ]])","v":{"v":23000,"d":"23,000.00 €"}},{"$f":"SUBTOTAL(109,Spareinlagen[[Monatlich ]])","v":{"v":1916.6666666666667,"d":"1,916.67 €"}}]