{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Buchungen","Übersicht","Listen"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Buchungen","index":0,"n_rows":500,"n_cols":9,"rows_kept":500,"merged":[[0,0,0,8],[1,0,2,8]]}
["Haushaltsbuch – Buchungen"]
["Trage hier alle Einnahmen und Ausgaben ein. Nutze ‘Typ’ + ‘Kategorie’. Betrag immer positiv eingeben."]
[]
[]
["Datum","Typ","Kategorie","Beschreibung","Betrag (€)","Zahlungsmittel","Monat","Jahr","Betrag_signiert"]
["2026-01-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",{"$f":"IF($A6=\"\",\"\",MONTH($A6))","v":1},{"$f":"IF($A6=\"\",\"\",YEAR($A6))","v":2026},{"$f":"IF($B6=\"\",\"\",IF($B6=\"Ausgabe\",-ABS($E6),ABS($E6)))","v":{"v":3200,"d":"€ 3,200.00"}}]
["2026-01-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",1,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-01-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",1,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-01-03","Ausgabe","Lebensmittel","Supermarkt",{"v":128,"d":"€ 128.00"},"Karte",1,2026,{"v":-128,"d":"-€ 128.00"}]
["2026-01-04","Ausgabe","Lebensmittel","Supermarkt",{"v":106,"d":"€ 106.00"},"Karte",1,2026,{"v":-106,"d":"-€ 106.00"}]
["2026-01-05","Ausgabe","Lebensmittel","Supermarkt",{"v":110,"d":"€ 110.00"},"Karte",1,2026,{"v":-110,"d":"-€ 110.00"}]
["2026-01-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":185,"d":"€ 185.00"},"Lastschrift",1,2026,{"v":-185,"d":"-€ 185.00"}]
["2026-01-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",1,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-01-17","Ausgabe","Freizeit","Restaurant/Kino",{"v":33,"d":"€ 33.00"},"Karte",1,2026,{"v":-33,"d":"-€ 33.00"}]
["2026-01-19","Ausgabe","Freizeit","Restaurant/Kino",{"v":23,"d":"€ 23.00"},"Karte",1,2026,{"v":-23,"d":"-€ 23.00"}]
["2026-01-21","Ausgabe","Lebensmittel","Supermarkt",{"v":66,"d":"€ 66.00"},"Karte",1,2026,{"v":-66,"d":"-€ 66.00"}]
["2026-02-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",2,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-02-02","Ausgabe","Freizeit","Restaurant/Kino",{"v":72,"d":"€ 72.00"},"Karte",2,2026,{"v":-72,"d":"-€ 72.00"}]
["2026-02-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",2,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-02-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",2,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-02-03","Ausgabe","Lebensmittel","Supermarkt",{"v":115,"d":"€ 115.00"},"Karte",2,2026,{"v":-115,"d":"-€ 115.00"}]
["2026-02-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":160,"d":"€ 160.00"},"Lastschrift",2,2026,{"v":-160,"d":"-€ 160.00"}]
["2026-02-08","Ausgabe","Lebensmittel","Supermarkt",{"v":71,"d":"€ 71.00"},"Karte",2,2026,{"v":-71,"d":"-€ 71.00"}]
["2026-02-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",2,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-02-14","Ausgabe","Lebensmittel","Supermarkt",{"v":68,"d":"€ 68.00"},"Karte",2,2026,{"v":-68,"d":"-€ 68.00"}]
["2026-02-18","Ausgabe","Lebensmittel","Supermarkt",{"v":114,"d":"€ 114.00"},"Karte",2,2026,{"v":-114,"d":"-€ 114.00"}]
["2026-02-19","Ausgabe","Freizeit","Restaurant/Kino",{"v":27,"d":"€ 27.00"},"Karte",2,2026,{"v":-27,"d":"-€ 27.00"}]
["2026-03-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",3,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-03-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",3,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-03-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",3,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-03-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":175,"d":"€ 175.00"},"Lastschrift",3,2026,{"v":-175,"d":"-€ 175.00"}]
["2026-03-08","Ausgabe","Freizeit","Restaurant/Kino",{"v":22,"d":"€ 22.00"},"Karte",3,2026,{"v":-22,"d":"-€ 22.00"}]
["2026-03-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",3,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-03-13","Ausgabe","Lebensmittel","Supermarkt",{"v":66,"d":"€ 66.00"},"Karte",3,2026,{"v":-66,"d":"-€ 66.00"}]
["2026-03-18","Ausgabe","Freizeit","Restaurant/Kino",{"v":74,"d":"€ 74.00"},"Karte",3,2026,{"v":-74,"d":"-€ 74.00"}]
["2026-03-19","Ausgabe","Lebensmittel","Supermarkt",{"v":67,"d":"€ 67.00"},"Karte",3,2026,{"v":-67,"d":"-€ 67.00"}]
["2026-03-19","Ausgabe","Lebensmittel","Supermarkt",{"v":134,"d":"€ 134.00"},"Karte",3,2026,{"v":-134,"d":"-€ 134.00"}]
["2026-03-21","Ausgabe","Lebensmittel","Supermarkt",{"v":140,"d":"€ 140.00"},"Karte",3,2026,{"v":-140,"d":"-€ 140.00"}]
["2026-04-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",4,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-04-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",4,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-04-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",4,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-04-04","Ausgabe","Lebensmittel","Supermarkt",{"v":133,"d":"€ 133.00"},"Karte",4,2026,{"v":-133,"d":"-€ 133.00"}]
["2026-04-05","Ausgabe","Lebensmittel","Supermarkt",{"v":129,"d":"€ 129.00"},"Karte",4,2026,{"v":-129,"d":"-€ 129.00"}]
["2026-04-06","Ausgabe","Freizeit","Restaurant/Kino",{"v":26,"d":"€ 26.00"},"Karte",4,2026,{"v":-26,"d":"-€ 26.00"}]
["2026-04-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":175,"d":"€ 175.00"},"Lastschrift",4,2026,{"v":-175,"d":"-€ 175.00"}]
["2026-04-10","Ausgabe","Lebensmittel","Supermarkt",{"v":113,"d":"€ 113.00"},"Karte",4,2026,{"v":-113,"d":"-€ 113.00"}]
["2026-04-10","Ausgabe","Lebensmittel","Supermarkt",{"v":131,"d":"€ 131.00"},"Karte",4,2026,{"v":-131,"d":"-€ 131.00"}]
["2026-04-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",4,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-04-27","Ausgabe","Freizeit","Restaurant/Kino",{"v":63,"d":"€ 63.00"},"Karte",4,2026,{"v":-63,"d":"-€ 63.00"}]
["2026-05-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",5,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-05-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",5,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-05-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",5,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-05-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":175,"d":"€ 175.00"},"Lastschrift",5,2026,{"v":-175,"d":"-€ 175.00"}]
["2026-05-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",5,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-05-12","Ausgabe","Lebensmittel","Supermarkt",{"v":72,"d":"€ 72.00"},"Karte",5,2026,{"v":-72,"d":"-€ 72.00"}]
["2026-05-16","Ausgabe","Freizeit","Restaurant/Kino",{"v":63,"d":"€ 63.00"},"Karte",5,2026,{"v":-63,"d":"-€ 63.00"}]
["2026-05-18","Ausgabe","Lebensmittel","Supermarkt",{"v":68,"d":"€ 68.00"},"Karte",5,2026,{"v":-68,"d":"-€ 68.00"}]
["2026-05-18","Ausgabe","Freizeit","Restaurant/Kino",{"v":47,"d":"€ 47.00"},"Karte",5,2026,{"v":-47,"d":"-€ 47.00"}]
["2026-05-19","Ausgabe","Lebensmittel","Supermarkt",{"v":67,"d":"€ 67.00"},"Karte",5,2026,{"v":-67,"d":"-€ 67.00"}]
["2026-05-20","Ausgabe","Lebensmittel","Supermarkt",{"v":86,"d":"€ 86.00"},"Karte",5,2026,{"v":-86,"d":"-€ 86.00"}]
["2026-06-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",6,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-06-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",6,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-06-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",6,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-06-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":185,"d":"€ 185.00"},"Lastschrift",6,2026,{"v":-185,"d":"-€ 185.00"}]
["2026-06-08","Ausgabe","Freizeit","Restaurant/Kino",{"v":25,"d":"€ 25.00"},"Karte",6,2026,{"v":-25,"d":"-€ 25.00"}]
["2026-06-10","Ausgabe","Lebensmittel","Supermarkt",{"v":91,"d":"€ 91.00"},"Karte",6,2026,{"v":-91,"d":"-€ 91.00"}]
["2026-06-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",6,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-06-15","Einnahme","Bonus","Sommerbonus",{"v":800,"d":"€ 800.00"},"Überweisung",6,2026,{"v":800,"d":"€ 800.00"}]
["2026-06-15","Ausgabe","Lebensmittel","Supermarkt",{"v":134,"d":"€ 134.00"},"Karte",6,2026,{"v":-134,"d":"-€ 134.00"}]
["2026-06-15","Ausgabe","Lebensmittel","Supermarkt",{"v":106,"d":"€ 106.00"},"Karte",{"$f":"IF($A70=\"\",\"\",MONTH($A70))","v":6},{"$f":"IF($A70=\"\",\"\",YEAR($A70))","v":2026},{"$f":"IF($B70=\"\",\"\",IF($B70=\"Ausgabe\",-ABS($E70),ABS($E70)))","v":{"v":-106,"d":"-€ 106.00"}}]
["2026-06-23","Ausgabe","Freizeit","Restaurant/Kino",{"v":69,"d":"€ 69.00"},"Karte",6,2026,{"v":-69,"d":"-€ 69.00"}]
["2026-06-26","Ausgabe","Lebensmittel","Supermarkt",{"v":83,"d":"€ 83.00"},"Karte",6,2026,{"v":-83,"d":"-€ 83.00"}]
["2026-07-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",7,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-07-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",7,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-07-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",7,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-07-03","Ausgabe","Lebensmittel","Supermarkt",{"v":75,"d":"€ 75.00"},"Karte",7,2026,{"v":-75,"d":"-€ 75.00"}]
["2026-07-06","Ausgabe","Freizeit","Restaurant/Kino",{"v":68,"d":"€ 68.00"},"Karte",7,2026,{"v":-68,"d":"-€ 68.00"}]
["2026-07-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":185,"d":"€ 185.00"},"Lastschrift",7,2026,{"v":-185,"d":"-€ 185.00"}]
["2026-07-10","Ausgabe","Lebensmittel","Supermarkt",{"v":137,"d":"€ 137.00"},"Karte",7,2026,{"v":-137,"d":"-€ 137.00"}]
["2026-07-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",7,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-07-11","Ausgabe","Lebensmittel","Supermarkt",{"v":117,"d":"€ 117.00"},"Karte",7,2026,{"v":-117,"d":"-€ 117.00"}]
["2026-07-17","Ausgabe","Lebensmittel","Supermarkt",{"v":123,"d":"€ 123.00"},"Karte",7,2026,{"v":-123,"d":"-€ 123.00"}]
["2026-07-17","Ausgabe","Freizeit","Restaurant/Kino",{"v":46,"d":"€ 46.00"},"Karte",7,2026,{"v":-46,"d":"-€ 46.00"}]
["2026-08-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",8,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-08-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",8,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-08-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",8,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-08-05","Ausgabe","Lebensmittel","Supermarkt",{"v":122,"d":"€ 122.00"},"Karte",8,2026,{"v":-122,"d":"-€ 122.00"}]
["2026-08-05","Ausgabe","Urlaub","Hotel",{"v":650,"d":"€ 650.00"},"Karte",8,2026,{"v":-650,"d":"-€ 650.00"}]
["2026-08-06","Ausgabe","Urlaub","Flug",{"v":280,"d":"€ 280.00"},"Karte",8,2026,{"v":-280,"d":"-€ 280.00"}]
["2026-08-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":185,"d":"€ 185.00"},"Lastschrift",8,2026,{"v":-185,"d":"-€ 185.00"}]
["2026-08-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",8,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-08-14","Ausgabe","Lebensmittel","Supermarkt",{"v":65,"d":"€ 65.00"},"Karte",8,2026,{"v":-65,"d":"-€ 65.00"}]
["2026-08-19","Ausgabe","Freizeit","Restaurant/Kino",{"v":70,"d":"€ 70.00"},"Karte",8,2026,{"v":-70,"d":"-€ 70.00"}]
["2026-08-22","Ausgabe","Lebensmittel","Supermarkt",{"v":69,"d":"€ 69.00"},"Karte",8,2026,{"v":-69,"d":"-€ 69.00"}]
["2026-08-25","Ausgabe","Lebensmittel","Supermarkt",{"v":131,"d":"€ 131.00"},"Karte",8,2026,{"v":-131,"d":"-€ 131.00"}]
["2026-08-27","Ausgabe","Freizeit","Restaurant/Kino",{"v":40,"d":"€ 40.00"},"Karte",8,2026,{"v":-40,"d":"-€ 40.00"}]
["2026-09-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",9,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-09-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",9,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-09-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",9,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-09-03","Ausgabe","Lebensmittel","Supermarkt",{"v":71,"d":"€ 71.00"},"Karte",9,2026,{"v":-71,"d":"-€ 71.00"}]
["2026-09-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":185,"d":"€ 185.00"},"Lastschrift",9,2026,{"v":-185,"d":"-€ 185.00"}]
["2026-09-09","Ausgabe","Freizeit","Restaurant/Kino",{"v":50,"d":"€ 50.00"},"Karte",9,2026,{"v":-50,"d":"-€ 50.00"}]
["2026-09-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",9,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-09-19","Ausgabe","Lebensmittel","Supermarkt",{"v":118,"d":"€ 118.00"},"Karte",9,2026,{"v":-118,"d":"-€ 118.00"}]
["2026-09-20","Ausgabe","Lebensmittel","Supermarkt",{"v":123,"d":"€ 123.00"},"Karte",9,2026,{"v":-123,"d":"-€ 123.00"}]
["2026-09-23","Ausgabe","Lebensmittel","Supermarkt",{"v":104,"d":"€ 104.00"},"Karte",9,2026,{"v":-104,"d":"-€ 104.00"}]
["2026-09-23","Ausgabe","Freizeit","Restaurant/Kino",{"v":62,"d":"€ 62.00"},"Karte",9,2026,{"v":-62,"d":"-€ 62.00"}]
["2026-10-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",10,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-10-01","Ausgabe","Freizeit","Restaurant/Kino",{"v":80,"d":"€ 80.00"},"Karte",10,2026,{"v":-80,"d":"-€ 80.00"}]
["2026-10-02","Ausgabe","Lebensmittel","Supermarkt",{"v":99,"d":"€ 99.00"},"Karte",10,2026,{"v":-99,"d":"-€ 99.00"}]
["2026-10-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",10,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-10-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",10,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-10-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":160,"d":"€ 160.00"},"Lastschrift",10,2026,{"v":-160,"d":"-€ 160.00"}]
["2026-10-10","Ausgabe","Lebensmittel","Supermarkt",{"v":109,"d":"€ 109.00"},"Karte",10,2026,{"v":-109,"d":"-€ 109.00"}]
["2026-10-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",10,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-10-21","Ausgabe","Lebensmittel","Supermarkt",{"v":133,"d":"€ 133.00"},"Karte",10,2026,{"v":-133,"d":"-€ 133.00"}]
["2026-10-22","Ausgabe","Lebensmittel","Supermarkt",{"v":117,"d":"€ 117.00"},"Karte",10,2026,{"v":-117,"d":"-€ 117.00"}]
["2026-10-22","Ausgabe","Freizeit","Restaurant/Kino",{"v":42,"d":"€ 42.00"},"Karte",10,2026,{"v":-42,"d":"-€ 42.00"}]
["2026-11-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",11,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-11-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",11,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-11-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",11,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-11-05","Ausgabe","Freizeit","Restaurant/Kino",{"v":67,"d":"€ 67.00"},"Karte",11,2026,{"v":-67,"d":"-€ 67.00"}]
["2026-11-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":190,"d":"€ 190.00"},"Lastschrift",11,2026,{"v":-190,"d":"-€ 190.00"}]
["2026-11-07","Ausgabe","Lebensmittel","Supermarkt",{"v":96,"d":"€ 96.00"},"Karte",11,2026,{"v":-96,"d":"-€ 96.00"}]
["2026-11-08","Ausgabe","Freizeit","Restaurant/Kino",{"v":45,"d":"€ 45.00"},"Karte",11,2026,{"v":-45,"d":"-€ 45.00"}]
["2026-11-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",11,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-11-12","Ausgabe","Lebensmittel","Supermarkt",{"v":81,"d":"€ 81.00"},"Karte",11,2026,{"v":-81,"d":"-€ 81.00"}]
["2026-11-16","Ausgabe","Lebensmittel","Supermarkt",{"v":67,"d":"€ 67.00"},"Karte",11,2026,{"v":-67,"d":"-€ 67.00"}]
["2026-11-20","Ausgabe","Lebensmittel","Supermarkt",{"v":74,"d":"€ 74.00"},"Karte",11,2026,{"v":-74,"d":"-€ 74.00"}]
["2026-12-01","Einnahme","Gehalt","Monatsgehalt",{"v":3200,"d":"€ 3,200.00"},"Überweisung",12,2026,{"v":3200,"d":"€ 3,200.00"}]
["2026-12-02","Ausgabe","Transport","ÖPNV",{"v":49,"d":"€ 49.00"},"Lastschrift",12,2026,{"v":-49,"d":"-€ 49.00"}]
["2026-12-03","Ausgabe","Miete","Warmmiete",{"v":950,"d":"€ 950.00"},"Überweisung",12,2026,{"v":-950,"d":"-€ 950.00"}]
["2026-12-03","Ausgabe","Lebensmittel","Supermarkt",{"v":81,"d":"€ 81.00"},"Karte",12,2026,{"v":-81,"d":"-€ 81.00"}]
["2026-12-05","Ausgabe","Freizeit","Restaurant/Kino",{"v":72,"d":"€ 72.00"},"Karte",{"$f":"IF($A134=\"\",\"\",MONTH($A134))","v":12},{"$f":"IF($A134=\"\",\"\",YEAR($A134))","v":2026},{"$f":"IF($B134=\"\",\"\",IF($B134=\"Ausgabe\",-ABS($E134),ABS($E134)))","v":{"v":-72,"d":"-€ 72.00"}}]
["2026-12-07","Ausgabe","Nebenkosten","Strom/Wasser",{"v":190,"d":"€ 190.00"},"Lastschrift",12,2026,{"v":-190,"d":"-€ 190.00"}]
["2026-12-10","Ausgabe","Abos","Streaming",{"v":35,"d":"€ 35.00"},"PayPal",12,2026,{"v":-35,"d":"-€ 35.00"}]
["2026-12-14","Ausgabe","Freizeit","Restaurant/Kino",{"v":75,"d":"€ 75.00"},"Karte",12,2026,{"v":-75,"d":"-€ 75.00"}]
["2026-12-15","Ausgabe","Lebensmittel","Supermarkt",{"v":111,"d":"€ 111.00"},"Karte",12,2026,{"v":-111,"d":"-€ 111.00"}]
["2026-12-18","Ausgabe","Lebensmittel","Supermarkt",{"v":95,"d":"€ 95.00"},"Karte",12,2026,{"v":-95,"d":"-€ 95.00"}]
["2026-12-28","Ausgabe","Lebensmittel","Supermarkt",{"v":123,"d":"€ 123.00"},"Karte",12,2026,{"v":-123,"d":"-€ 123.00"}]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},{"$f":"IF($A198=\"\",\"\",MONTH($A198))","v":""},{"$f":"IF($A198=\"\",\"\",YEAR($A198))","v":""},{"$f":"IF($B198=\"\",\"\",IF($B198=\"Ausgabe\",-ABS($E198),ABS($E198)))","v":""}]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},{"$f":"IF($A262=\"\",\"\",MONTH($A262))","v":""},{"$f":"IF($A262=\"\",\"\",YEAR($A262))","v":""},{"$f":"IF($B262=\"\",\"\",IF($B262=\"Ausgabe\",-ABS($E262),ABS($E262)))","v":""}]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},{"$f":"IF($A326=\"\",\"\",MONTH($A326))","v":""},{"$f":"IF($A326=\"\",\"\",YEAR($A326))","v":""},{"$f":"IF($B326=\"\",\"\",IF($B326=\"Ausgabe\",-ABS($E326),ABS($E326)))","v":""}]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},{"$f":"IF($A390=\"\",\"\",MONTH($A390))","v":""},{"$f":"IF($A390=\"\",\"\",YEAR($A390))","v":""},{"$f":"IF($B390=\"\",\"\",IF($B390=\"Ausgabe\",-ABS($E390),ABS($E390)))","v":""}]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},{"$f":"IF($A454=\"\",\"\",MONTH($A454))","v":""},{"$f":"IF($A454=\"\",\"\",YEAR($A454))","v":""},{"$f":"IF($B454=\"\",\"\",IF($B454=\"Ausgabe\",-ABS($E454),ABS($E454)))","v":""}]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]

{"sheet":"Übersicht","index":1,"n_rows":21,"n_cols":10,"rows_kept":21,"merged":[[0,0,0,5],[2,0,2,1],[2,2,2,3],[2,4,2,5],[3,0,3,1],[3,2,3,3],[3,4,3,5]]}
["Haushaltsbuch Übersicht"]
["Jahr wählen",2026]
["Einnahmen (Jahr)",null,"Ausgaben (Jahr)",null,"Saldo (Jahr)"]
[{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2)","v":{"v":39200,"d":"€ 39,200.00"}},null,{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2)","v":{"v":21588,"d":"€ 21,588.00"}},null,{"$f":"SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$H$6:$H$500,$B$2)","v":{"v":17612,"d":"€ 17,612.00"}}]
[]
["Monat","Einnahmen","Ausgaben","Saldo","Kumuliert",null,"Kategorie","Budget/Monat","Ausgaben (Jahr)","Abweichung"]
[{"$f":"DATE($B$2,1,1)","v":"2026-01-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A7))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A7))","v":{"v":1685,"d":"€ 1,685.00"}},{"$f":"B7-C7","v":{"v":1515,"d":"€ 1,515.00"}},{"$f":"SUM($D$7:D7)","v":{"v":1515,"d":"€ 1,515.00"}},null,"Miete",{"$f":"IFERROR(VLOOKUP($G7,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":950,"d":"€ 950.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G7)","v":{"v":11400,"d":"€ 11,400.00"}},{"$f":"I7-(H7*12)","v":{"v":0,"d":"€ 0.00"}}]
[{"$f":"DATE($B$2,2,1)","v":"2026-02-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A8))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A8))","v":{"v":1661,"d":"€ 1,661.00"}},{"v":1539,"d":"€ 1,539.00"},{"$f":"SUM($D$7:D8)","v":{"v":3054,"d":"€ 3,054.00"}},null,"Nebenkosten",{"$f":"IFERROR(VLOOKUP($G8,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":180,"d":"€ 180.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G8)","v":{"v":2150,"d":"€ 2,150.00"}},{"v":-10,"d":"-€ 10.00"}]
[{"$f":"DATE($B$2,3,1)","v":"2026-03-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A9))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A9))","v":{"v":1712,"d":"€ 1,712.00"}},{"v":1488,"d":"€ 1,488.00"},{"$f":"SUM($D$7:D9)","v":{"v":4542,"d":"€ 4,542.00"}},null,"Lebensmittel",{"$f":"IFERROR(VLOOKUP($G9,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":420,"d":"€ 420.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G9)","v":{"v":4839,"d":"€ 4,839.00"}},{"v":-201,"d":"-€ 201.00"}]
[{"$f":"DATE($B$2,4,1)","v":"2026-04-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A10))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A10))","v":{"v":1804,"d":"€ 1,804.00"}},{"v":1396,"d":"€ 1,396.00"},{"$f":"SUM($D$7:D10)","v":{"v":5938,"d":"€ 5,938.00"}},null,"Transport",{"$f":"IFERROR(VLOOKUP($G10,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":90,"d":"€ 90.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G10)","v":{"v":588,"d":"€ 588.00"}},{"v":-492,"d":"-€ 492.00"}]
[{"$f":"DATE($B$2,5,1)","v":"2026-05-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A11))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A11))","v":{"v":1612,"d":"€ 1,612.00"}},{"v":1588,"d":"€ 1,588.00"},{"$f":"SUM($D$7:D11)","v":{"v":7526,"d":"€ 7,526.00"}},null,"Auto",{"$f":"IFERROR(VLOOKUP($G11,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":140,"d":"€ 140.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G11)","v":{"v":0,"d":"€ 0.00"}},{"v":-1680,"d":"-€ 1,680.00"}]
[{"$f":"DATE($B$2,6,1)","v":"2026-06-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A12))","v":{"v":4000,"d":"€ 4,000.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A12))","v":{"v":1727,"d":"€ 1,727.00"}},{"v":2273,"d":"€ 2,273.00"},{"$f":"SUM($D$7:D12)","v":{"v":9799,"d":"€ 9,799.00"}},null,"Versicherungen",{"$f":"IFERROR(VLOOKUP($G12,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":80,"d":"€ 80.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G12)","v":{"v":0,"d":"€ 0.00"}},{"v":-960,"d":"-€ 960.00"}]
[{"$f":"DATE($B$2,7,1)","v":"2026-07-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A13))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A13))","v":{"v":1785,"d":"€ 1,785.00"}},{"v":1415,"d":"€ 1,415.00"},{"$f":"SUM($D$7:D13)","v":{"v":11214,"d":"€ 11,214.00"}},null,"Gesundheit",{"$f":"IFERROR(VLOOKUP($G13,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":50,"d":"€ 50.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G13)","v":{"v":0,"d":"€ 0.00"}},{"v":-600,"d":"-€ 600.00"}]
[{"$f":"DATE($B$2,8,1)","v":"2026-08-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A14))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A14))","v":{"v":2646,"d":"€ 2,646.00"}},{"v":554,"d":"€ 554.00"},{"$f":"SUM($D$7:D14)","v":{"v":11768,"d":"€ 11,768.00"}},null,"Kleidung",{"$f":"IFERROR(VLOOKUP($G14,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":60,"d":"€ 60.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G14)","v":{"v":0,"d":"€ 0.00"}},{"v":-720,"d":"-€ 720.00"}]
[{"$f":"DATE($B$2,9,1)","v":"2026-09-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A15))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A15))","v":{"v":1747,"d":"€ 1,747.00"}},{"v":1453,"d":"€ 1,453.00"},{"$f":"SUM($D$7:D15)","v":{"v":13221,"d":"€ 13,221.00"}},null,"Freizeit",{"$f":"IFERROR(VLOOKUP($G15,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":120,"d":"€ 120.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G15)","v":{"v":1261,"d":"€ 1,261.00"}},{"v":-179,"d":"-€ 179.00"}]
[{"$f":"DATE($B$2,10,1)","v":"2026-10-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A16))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A16))","v":{"v":1774,"d":"€ 1,774.00"}},{"v":1426,"d":"€ 1,426.00"},{"$f":"SUM($D$7:D16)","v":{"v":14647,"d":"€ 14,647.00"}},null,"Abos",{"$f":"IFERROR(VLOOKUP($G16,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":35,"d":"€ 35.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G16)","v":{"v":420,"d":"€ 420.00"}},{"v":0,"d":"€ 0.00"}]
[{"$f":"DATE($B$2,11,1)","v":"2026-11-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A17))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A17))","v":{"v":1654,"d":"€ 1,654.00"}},{"v":1546,"d":"€ 1,546.00"},{"$f":"SUM($D$7:D17)","v":{"v":16193,"d":"€ 16,193.00"}},null,"Bildung",{"$f":"IFERROR(VLOOKUP($G17,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":40,"d":"€ 40.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G17)","v":{"v":0,"d":"€ 0.00"}},{"v":-480,"d":"-€ 480.00"}]
[{"$f":"DATE($B$2,12,1)","v":"2026-12-01"},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$B$6:$B$500,\"Einnahme\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A18))","v":{"v":3200,"d":"€ 3,200.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$G$6:$G$500,MONTH($A18))","v":{"v":1781,"d":"€ 1,781.00"}},{"v":1419,"d":"€ 1,419.00"},{"$f":"SUM($D$7:D18)","v":{"v":17612,"d":"€ 17,612.00"}},null,"Urlaub",{"$f":"IFERROR(VLOOKUP($G18,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":120,"d":"€ 120.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G18)","v":{"v":930,"d":"€ 930.00"}},{"v":-510,"d":"-€ 510.00"}]
[{"$nulls":6},"Geschenke",{"$f":"IFERROR(VLOOKUP($G19,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":30,"d":"€ 30.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G19)","v":{"v":0,"d":"€ 0.00"}},{"v":-360,"d":"-€ 360.00"}]
[{"$nulls":6},"Haustiere",{"$f":"IFERROR(VLOOKUP($G20,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":25,"d":"€ 25.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G20)","v":{"v":0,"d":"€ 0.00"}},{"v":-300,"d":"-€ 300.00"}]
[{"$nulls":6},"Sonstiges",{"$f":"IFERROR(VLOOKUP($G21,Listen!$A$34:$B$60,2,FALSE),0)","v":{"v":70,"d":"€ 70.00"}},{"$f":"-SUMIFS(Buchungen!$I$6:$I$500,Buchungen!$B$6:$B$500,\"Ausgabe\",Buchungen!$H$6:$H$500,$B$2,Buchungen!$C$6:$C$500,$G21)","v":{"v":0,"d":"€ 0.00"}},{"v":-840,"d":"-€ 840.00"}]

{"sheet":"Listen","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[0,0,0,2],[0,4,0,5],[0,7,0,8]]}
["Kategorien",{"$nulls":3},"Zahlungsmittel",null,null,"Jahre"]
["Miete",{"$nulls":3},"Bar",null,null,2024]
["Nebenkosten",{"$nulls":3},"Karte",null,null,2025]
["Lebensmittel",{"$nulls":3},"Überweisung",null,null,2026]
["Transport",{"$nulls":3},"Lastschrift",null,null,2027]
["Auto",{"$nulls":3},"PayPal",null,null,2028]
["Versicherungen",{"$nulls":3},"Sonstiges",null,null,2029]
["Gesundheit",{"$nulls":6},2030]
["Kleidung"]
["Freizeit"]
["Abos"]
["Bildung"]
["Urlaub"]
["Geschenke"]
["Haustiere"]
["Sonstiges"]
["Gehalt"]
["Bonus"]
["Nebenjob"]
["Zinsen"]
["Rückerstattung"]
{"$rows_empty":11}
["Kategorie","Budget/Monat (€)","Notiz"]
["Miete",{"v":950,"d":"€ 950.00"}]
["Nebenkosten",{"v":180,"d":"€ 180.00"}]
["Lebensmittel",{"v":420,"d":"€ 420.00"}]
["Transport",{"v":90,"d":"€ 90.00"}]
["Auto",{"v":140,"d":"€ 140.00"}]
["Versicherungen",{"v":80,"d":"€ 80.00"}]
["Gesundheit",{"v":50,"d":"€ 50.00"}]
["Kleidung",{"v":60,"d":"€ 60.00"}]
["Freizeit",{"v":120,"d":"€ 120.00"}]
["Abos",{"v":35,"d":"€ 35.00"}]
["Bildung",{"v":40,"d":"€ 40.00"}]
["Urlaub",{"v":120,"d":"€ 120.00"}]
["Geschenke",{"v":30,"d":"€ 30.00"}]
["Haustiere",{"v":25,"d":"€ 25.00"}]
["Sonstiges",{"v":70,"d":"€ 70.00"}]