{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Einnahmen-Ausgaben","Kategorien","Pivot Tabellen","Börsendaten","Charts"],"not_rendered":{"charts":4,"images":12,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":6},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Einnahmen-Ausgaben","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Jahr","Datum","Monat","Kategorie","Unterkategorie","Beschreibung","Einnahmen","Ausgaben","Umsatz"]
[2024,"2024-01-01",{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},"Haushalt","Miete und Nebenkosten",null,null,800,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":-800}]
[2024,"2024-03-04",{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":3},"Einnahmen","Gehalt",null,2850,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":2850}]
[2025,"2025-01-02",{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},"Freizeit",null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]
[null,null,{"$f":"MONTH(Tabelle12[[#This Row],[Datum]])","v":1},null,null,null,null,null,{"$f":"Tabelle12[[#This Row],[Einnahmen]]-Tabelle12[[#This Row],[Ausgaben]]","v":0}]

{"sheet":"Kategorien","index":1,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Hauptkategorie",null,"Einnahmen",null,"Beruf",null,"Freizeit",null,"Haushalt",null,"Auto",null,"Bürokratie",null,"Gesundheit"]
["Einnahmen",null,"Gehalt",null,"Arbeitskleidung",null,"Hobby",null,"Miete und Nebenkosten",null,"Tanken",null,"Kontoführung",null,"Medikamente"]
["Beruf",null,"Rente",null,"Literatur (Bücher)",null,"Haustiere",null,"Kleidung",null,"Strom (E-Auto)",null,"Porto",null,"Vorsorge (IGEL-Leistungen)"]
["Freizeit",null,"Kindergeld",null,"Elektronik (PC, Laptop)",null,"Ausgehen, Kultur",null,"Lebensmittel",null,"Garage (Miete)",null,"Steuerberatung",null,"sonstige"]
["Haushalt",null,"Elterngeld",null,"Bewerbungskosten",null,"Unterhaltung, Medien, Kino",null,"Haushaltsgeräte",null,"Kfz-Steuer",null,"Versicherungen (diverse)"]
["Auto",null,"Krankengeld",null,"Telefonkosten (beruflich)",null,"Urlaub",null,"Möbel, Deko",null,"Werkstattkosten"]
["Bürokratie",null,"ALG I",null,null,null,"Geschenke",null,"Instandhaltung",null,"Kfz-Versicherung"]
["Gesundheit",null,"Bürgergeld",null,null,null,"Sport",null,"Rundfunkgebühren"]
[null,null,"Zinsen, Dividenden",null,null,null,null,null,"Handy, Festnetz, Internet"]
[null,null,"Nebeneinkünfte",null,null,null,null,null,"Schule (Kinder)"]
[null,null,"Private Verkäufe"]

{"sheet":"Pivot Tabellen","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[[16,6,16,9],[0,0,0,7]]}
[]
[]
["Einnahmen Gesamt","Summe von Einnahmen",null,"Ausgaben Gesamt","Summe von Ausgaben",null,"Summe von Umsatz"]
[2024,2850,null,"(Leer)",null,null,2050]
["Gesamtergebnis",2850,null,"(Leer)"]
[null,null,null,2024,800]
[null,null,null,"2024-01-01",800]
[null,null,null,"2024-03-04"]
[null,null,null,"Gesamtergebnis",800]
[]
["Top Einnahmen","Summe von Einnahmen",null,"Top Ausgaben","Summe von Ausgaben",null,"Datum",{"$f":"TODAY()","v":"2026-06-09"}]
["Einnahmen",2850,null,"Haushalt",800,null,"Monat",{"$f":"MONTH(H11)","v":6}]
["Gehalt",2850,null,null,null,null,"Einnahmen",{"$f":"GETPIVOTDATA(\"Umsatz\",$G$3)","v":2050}]
[null,null,null,null,null,null,"Ausgaben",{"$f":"SUMIF(Tabelle12[Monat],'Pivot Tabellen'!H12,Tabelle12[Ausgaben])","v":0}]
[]
[]
[null,null,null,null,null,null,"Verfügbar DG"]
["Summe von Einnahmen","Summe von Ausgaben","Summe von Umsatz","Sparquote",null,"leer",{"$f":"H13","v":2050},"leer",{"$f":"G18","v":2050}]
[2850,800,2050,null,null,"frei",{"$f":"G18-G20","v":2050},"frei",{"$f":"G19","v":2050}]
[null,null,null,null,null,"costs",{"$f":"IF(H14<H13,H14,H13)","v":0},"pointer",{"$f":"0.02*I18","v":41}]
[{"$f":"(GETPIVOTDATA(\"Summe von Einnahmen\",A19))","v":2850},{"$f":"(GETPIVOTDATA(\"Summe von Ausgaben\",B19))","v":800},{"$f":"(GETPIVOTDATA(\"Summe von Umsatz\",B19))","v":2050},{"$f":"C21/A21","v":0.7192982456140351},null,null,null,"costs",{"$f":"G20-I20","v":-41}]

{"sheet":"Börsendaten","index":3,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Column1","Rohstoff","Letzter","Perf. abs.","Perf. %","2",null,"Column1","1 Woche","1 Monat","3 Monate","Lfd. Jahr","1 Jahr","3 Jahre"]
[null,"","Gold","2.660,71 $","-0,24 $",-1E-4,"ETCs",null,"Kurs",15823,15661,15444,13915.5,13948,10767]
[null,"","Palladium","1.029,67 $","-11,08 $",-1.0699999999999999E-2,"ETCs",null,"Änderung",7.7000000000000002E-3,1.8100000000000002E-2,3.2399999999999998E-2,0.14580000000000001,0.14319999999999999,0.48089999999999999]
[null,"","Platin","981,3729 $","-7,99 $",-8.0999999999999996E-3,"ETCs"]
[null,"","Silber","31,1151 $","-0,070 $",-2.2000000000000001E-3,"ETCs"]
[]
[null,"Column1","Rohstoff","Letzter","Perf. abs.","Perf. %","2"]
[null,"","Aluminium","2.606,98 $","+37,91 $",1.4800000000000001E-2,"ETCs"]
[null,"","Aluminium London","2.672,65 $","+48,80 $",1.8599999999999998E-2,"ETCs"]
[null,"","Blei London","2.002,25 $","+5,37 $",2.7000000000000001E-3,"ETCs"]
[null,"","Kupfer London","9.554,74 $","+206,59 $",2.2100000000000002E-2,"ETCs"]
[null,"","Nickel London","16.390,17 $","+252,94 $",1.5699999999999999E-2,"ETCs"]
[null,"","Zink London","3.069,32 $","+80,86 $",2.7099999999999999E-2,"ETCs"]
[null,"","Zinn London","31.846,64 $","+533,10 $",1.7000000000000001E-2,"ETCs"]
[null,"Column1","Währung","Letzter","Änd.","2","Zeit"]
[null,"","Australischer Dollar",1.6411,-8.8999999999999999E-3,""]
[null,"","Brasilianischer Real",5.4871999999999996,0,"",2804]
[null,"","Britische Pfund Sterling",0.87880000000000003,2.9999999999999997E-4,""]
[null,"","Bulgarischer Neuer Lew",1.9558,0,"",2804]
[null,"","Chin. Renminbi Yuan",7.5979000000000001,0,"",2804]
[null,"","Dänische Krone",7.4530000000000003,0,""]
[null,"","Hong Kong Dollar",8.6196999999999999,2.9999999999999997E-4,""]
[null,"","Indische Rupie",89.855500000000006,0,"",2804]
[null,"","Indonesische Rupiah",16111.9,0,"",2804]
[null,"","Isländische Krone",149.1,0,"",2804]
[null,"","Israelischer Neuer Schekel",3.9939,0,"",2804]
[null,"","Japanischer Yen",151.21700000000001,1.8E-3,""]
[null,"","Kanadische Dollar",1.4864999999999999,-2.0000000000000001E-4,""]
[null,"","Malaysischer Ringgit",4.8981000000000003,0,"",2804]
[null,"","Mexikanischer Peso",19.692799999999998,-6.9999999999999999E-4,""]
[null,"","Neuseeland-Dollar",1.7766,-1.5E-3,""]
[null,"","Norwegische Krone",11.781599999999999,-1E-4,""]
[null,"","Philippinischer Peso",60.923000000000002,0,"",2804]
[null,"","Polnischer Zloty",4.6052,4.0000000000000002E-4,""]
[null,"","Rumänischer Neuer Leu",4.9301000000000004,0,"",2804]
[null,"","Schwedische Krone",11.3246,-6.9999999999999999E-4,""]
[null,"","Schweizer Franken",0.98370000000000002,5.0000000000000001E-4,""]
[null,"","Singapur-Dollar",1.4666999999999999,-2.0000000000000001E-4,""]
[null,"","Südafrikanischer Rand",20.194600000000001,-2.9999999999999997E-4,""]
[null,"","Südkoreanischer Won",1470.89,0,"",2804]
[null,"","Thailändischer Baht",37.466999999999999,0,"",2804]
[null,"","Tschechische Krone",23.554600000000001,4.0000000000000002E-4,""]
[null,"","Türkische Lira",21.396000000000001,-8.9999999999999998E-4,""]
[null,"","Ungarische Forint",372.47750000000002,2.9999999999999997E-4,""]
[null,"","US-Dollar",1.0981000000000001,2.9999999999999997E-4,""]
[null,"Charts vergleichen"]
[null,"In Watchlist aufnehmen"]
[null,"In Depot aufnehmen"]

{"sheet":"Charts","index":4,"n_rows":1,"n_cols":18,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2026-06-09"}]