{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Ausgabenjournal","Persönliche Ausgabendaten"],"not_rendered":{"charts":1,"defined_names":5,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":1,"n_cols":6,"rows_kept":1,"merged":[[0,1,0,4],[2,1,2,2],[2,3,2,4]]}
[null,"Dashboard „Persönliche Ausgaben“",{"$nulls":3},"zu Ausgabenjournal >"]

{"sheet":"Ausgabenjournal","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,4]]}
[null,"Ausgabenjournal",{"$nulls":3},"< zu Dashboard"]
[null,"Datum","Kategorie","Unterkategorie","Betrag","Hinweis"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2022-03-02"},"Wohnen","Internet",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2022-03-02"},"Wohnen","Festnetztelefon",{"v":39,"d":"39.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2022-03-04"},"Wohnen","Strom/Heizung",{"v":62,"d":"62.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2022-03-04"},"Unterhaltung","Fitness-Studio",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2022-03-06"},"Täglich","Kleidung",{"v":42,"d":"42.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2022-03-06"},"Transport","Monatskarte für U-Bahn",{"v":21,"d":"21.00 €"},"Monatskarte für März"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2022-04-02"},"Transport","Kraftstoff",{"v":54,"d":"54.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2022-04-02"},"Täglich","Friseur",{"v":12,"d":"12.00 €"}]
[null,"2022-04-02","Täglich","Tee/Kaffee",{"v":12,"d":"12.00 €"}]
[null,"2022-04-02","Täglich","Süßigkeiten",{"v":2.75,"d":"2.75 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2022-04-04"},"Wohnen","Internet",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2022-04-04"},"Wohnen","Festnetztelefon",{"v":39,"d":"39.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2022-04-04"},"Wohnen","Strom/Heizung",{"v":62,"d":"62.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2022-04-04"},"Täglich","Kontaktlinsen",{"v":29,"d":"29.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2022-04-06"},"Täglich","Kleidung",{"v":42,"d":"42.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2022-04-06"},"Transport","Monatskarte für U-Bahn",{"v":21,"d":"21.00 €"},"Monatskarte für April"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2022-05-01"},"Transport","Kraftstoff",{"v":54,"d":"54.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2022-06-01"},"Täglich","Friseur",{"v":12,"d":"12.00 €"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2022-07-01"},"Unterhaltung","Kino",{"v":21,"d":"21.00 €"},"Abend mit Filmklassikern"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2022-08-01"},"Täglich","Süßigkeiten",{"v":2.75,"d":"2.75 €"}]

{"sheet":"Persönliche Ausgabendaten","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"Persönliche Ausgabendaten"]
[null,"Die nachstehende PivotTable liefert die Datenquelle für das PivotChart \"Persönliche Ausgaben\" auf dem Dashboard. Eventuelle Änderungen können zu visuellen Änderungen am PivotChart oder Fehlern führen."]
[null,"Summe von Betrag","Spaltenbeschriftungen"]
[null,"Zeilenbeschriftungen","Unterhaltung","Transport","Täglich","Wohnen","Gesamtergebnis"]
[null,"Mar",29,21,42,130,222]
[null,"Apr",null,75,97.75,130,302.75]
[null,"May",null,54,null,null,54]
[null,"Jun",null,null,12,null,12]
[null,"Jul",21,{"$nulls":3},21]
[null,"Aug",null,null,2.75,null,2.75]
[null,"Gesamtergebnis",50,150,154.5,260,614.5]