{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Mietübersicht","Zahlungen","Ausgaben"],"read":"whole","date_system":"1900"}

{"sheet":"Mietübersicht","index":0,"n_rows":209,"n_cols":13,"rows_kept":209,"merged":[[0,0,0,12]]}
["Hausverwaltung – Mietübersicht"]
[]
["Monat (1. Tag)",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2026-02-01"},"Ändere den Monat, um Einnahmen/Ausgaben und Status zu aktualisieren.",{"$nulls":4},"Soll-Warmmiete\n(Monat)",{"$f":"SUMIFS($F$10:$F$209,$L$10:$L$209,\"Ja\")","v":{"v":4410,"d":"4,410.00 €"}}]
[{"$nulls":7},"Ist-Einnahmen\n(Monat)",{"$f":"SUMIFS($I$10:$I$209,$L$10:$L$209,\"Ja\")","v":{"v":3200,"d":"3,200.00 €"}}]
[{"$nulls":7},"Offen (Monat)",{"$f":"MAX(0,I3-I4)","v":{"v":1210,"d":"1,210.00 €"}}]
[{"$nulls":7},"Ausgaben (Monat)",{"$f":"SUMIFS(Ausgaben!$F$6:$F$205,Ausgaben!$B$6:$B$205,$B$3)","v":{"v":360,"d":"360.00 €"}}]
[{"$nulls":7},"Cashflow (Monat)",{"$f":"I4-I6","v":{"v":2840,"d":"2,840.00 €"}}]
[]
["Objekt-ID","Objekt/Einheit","Mieter","Kaltmiete\n(€)","Nebenkosten (€)","Warmmiete\n(€)","Fälligkeit\n(Tag)","Fälligkeit\n(Monat)","Eingang\n(Monat)","Rest (Monat)","Status (Monat)","Aktiv?","Notizen"]
["W-001","Wohnung 1","Anna Müller",{"v":750,"d":"750.00 €"},{"v":200,"d":"200.00 €"},{"$f":"IF($A10=\"\",\"\",D10+E10)","v":{"v":950,"d":"950.00 €"}},3,{"$f":"IF($A10=\"\",\"\",DATE(YEAR($B$3),MONTH($B$3),G10))","v":"2026-02-03"},{"$f":"IF($A10=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A10,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":{"v":950,"d":"950.00 €"}},{"$f":"IF($A10=\"\",\"\",MAX(0,F10-I10))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF($A10=\"\",\"\",IF(J10=0,\"Bezahlt\",IF(I10=0,\"Offen\",\"Teilweise\")))","v":"Bezahlt"},"Ja"]
["W-002","Wohnung 2","Ben Schneider",{"v":820,"d":"820.00 €"},{"v":220,"d":"220.00 €"},{"v":1040,"d":"1,040.00 €"},3,"2026-02-03",{"$f":"IF($A11=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A11,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":{"v":700,"d":"700.00 €"}},{"v":340,"d":"340.00 €"},"Teilweise","Ja"]
["W-003","Wohnung 3","Carla Wagner",{"v":680,"d":"680.00 €"},{"v":190,"d":"190.00 €"},{"v":870,"d":"870.00 €"},5,"2026-02-05",{"$f":"IF($A12=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A12,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":{"v":0,"d":"0.00 €"}},{"v":870,"d":"870.00 €"},"Offen","Ja"]
["G-001","Gewerbe 1","Bäckerei Kruse GmbH",{"v":1200,"d":"1,200.00 €"},{"v":350,"d":"350.00 €"},{"v":1550,"d":"1,550.00 €"},1,"2026-02-01",{"$f":"IF($A13=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A13,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":{"v":1550,"d":"1,550.00 €"}},{"v":0,"d":"0.00 €"},"Bezahlt","Ja"]
["W-004","Wohnung 4","Daniel Fischer",{"v":900,"d":"900.00 €"},{"v":250,"d":"250.00 €"},{"v":1150,"d":"1,150.00 €"},5,"2026-02-05",{"$f":"IF($A14=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A14,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":{"v":0,"d":"0.00 €"}},{"v":1150,"d":"1,150.00 €"},"Offen","Nein","Leerstand"]
[{"$nulls":5},"",null,"",{"$f":"IF($A15=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A15,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A16=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A16,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A17=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A17,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A18=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A18,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A19=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A19,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A20=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A20,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A21=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A21,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A22=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A22,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A23=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A23,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A24=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A24,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A25=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A25,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A26=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A26,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A27=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A27,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A28=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A28,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A29=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A29,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A30=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A30,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A31=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A31,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A32=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A32,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A33=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A33,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A34=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A34,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A35=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A35,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A36=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A36,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A37=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A37,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A38=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A38,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A39=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A39,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A40=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A40,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A41=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A41,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},{"$f":"IF($A42=\"\",\"\",D42+E42)","v":""},null,{"$f":"IF($A42=\"\",\"\",DATE(YEAR($B$3),MONTH($B$3),G42))","v":""},{"$f":"IF($A42=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A42,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},{"$f":"IF($A42=\"\",\"\",MAX(0,F42-I42))","v":""},{"$f":"IF($A42=\"\",\"\",IF(J42=0,\"Bezahlt\",IF(I42=0,\"Offen\",\"Teilweise\")))","v":""}]
[{"$nulls":5},"",null,"",{"$f":"IF($A43=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A43,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A44=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A44,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A45=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A45,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A46=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A46,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A47=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A47,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A48=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A48,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A49=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A49,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A50=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A50,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A51=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A51,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A52=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A52,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A53=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A53,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A54=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A54,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A55=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A55,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A56=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A56,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A57=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A57,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A58=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A58,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A59=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A59,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A60=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A60,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A61=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A61,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A62=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A62,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A63=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A63,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A64=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A64,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A65=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A65,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A66=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A66,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A67=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A67,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A68=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A68,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A69=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A69,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A70=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A70,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A71=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A71,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A72=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A72,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A73=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A73,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},{"$f":"IF($A74=\"\",\"\",D74+E74)","v":""},null,{"$f":"IF($A74=\"\",\"\",DATE(YEAR($B$3),MONTH($B$3),G74))","v":""},{"$f":"IF($A74=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A74,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},{"$f":"IF($A74=\"\",\"\",MAX(0,F74-I74))","v":""},{"$f":"IF($A74=\"\",\"\",IF(J74=0,\"Bezahlt\",IF(I74=0,\"Offen\",\"Teilweise\")))","v":""}]
[{"$nulls":5},"",null,"",{"$f":"IF($A75=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A75,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A76=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A76,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A77=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A77,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A78=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A78,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A79=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A79,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A80=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A80,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A81=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A81,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A82=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A82,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A83=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A83,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A84=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A84,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A85=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A85,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A86=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A86,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A87=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A87,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A88=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A88,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A89=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A89,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A90=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A90,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A91=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A91,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A92=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A92,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A93=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A93,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A94=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A94,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A95=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A95,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A96=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A96,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A97=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A97,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A98=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A98,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A99=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A99,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A100=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A100,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A101=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A101,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A102=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A102,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A103=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A103,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A104=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A104,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A105=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A105,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},{"$f":"IF($A106=\"\",\"\",D106+E106)","v":""},null,{"$f":"IF($A106=\"\",\"\",DATE(YEAR($B$3),MONTH($B$3),G106))","v":""},{"$f":"IF($A106=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A106,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},{"$f":"IF($A106=\"\",\"\",MAX(0,F106-I106))","v":""},{"$f":"IF($A106=\"\",\"\",IF(J106=0,\"Bezahlt\",IF(I106=0,\"Offen\",\"Teilweise\")))","v":""}]
[{"$nulls":5},"",null,"",{"$f":"IF($A107=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A107,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A108=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A108,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A109=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A109,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A110=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A110,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A111=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A111,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A112=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A112,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A113=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A113,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A114=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A114,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A115=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A115,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A116=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A116,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A117=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A117,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A118=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A118,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A119=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A119,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A120=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A120,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A121=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A121,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A122=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A122,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A123=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A123,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A124=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A124,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A125=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A125,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A126=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A126,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A127=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A127,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A128=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A128,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A129=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A129,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A130=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A130,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A131=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A131,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A132=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A132,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A133=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A133,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A134=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A134,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A135=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A135,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A136=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A136,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A137=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A137,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},{"$f":"IF($A138=\"\",\"\",D138+E138)","v":""},null,{"$f":"IF($A138=\"\",\"\",DATE(YEAR($B$3),MONTH($B$3),G138))","v":""},{"$f":"IF($A138=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A138,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},{"$f":"IF($A138=\"\",\"\",MAX(0,F138-I138))","v":""},{"$f":"IF($A138=\"\",\"\",IF(J138=0,\"Bezahlt\",IF(I138=0,\"Offen\",\"Teilweise\")))","v":""}]
[{"$nulls":5},"",null,"",{"$f":"IF($A139=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A139,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A140=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A140,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A141=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A141,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A142=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A142,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A143=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A143,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A144=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A144,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A145=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A145,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A146=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A146,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A147=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A147,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A148=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A148,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A149=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A149,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A150=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A150,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A151=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A151,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A152=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A152,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A153=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A153,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A154=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A154,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A155=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A155,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A156=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A156,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A157=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A157,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A158=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A158,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A159=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A159,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A160=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A160,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A161=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A161,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A162=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A162,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A163=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A163,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A164=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A164,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A165=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A165,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A166=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A166,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A167=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A167,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A168=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A168,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A169=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A169,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},{"$f":"IF($A170=\"\",\"\",D170+E170)","v":""},null,{"$f":"IF($A170=\"\",\"\",DATE(YEAR($B$3),MONTH($B$3),G170))","v":""},{"$f":"IF($A170=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A170,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},{"$f":"IF($A170=\"\",\"\",MAX(0,F170-I170))","v":""},{"$f":"IF($A170=\"\",\"\",IF(J170=0,\"Bezahlt\",IF(I170=0,\"Offen\",\"Teilweise\")))","v":""}]
[{"$nulls":5},"",null,"",{"$f":"IF($A171=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A171,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A172=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A172,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A173=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A173,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A174=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A174,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A175=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A175,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A176=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A176,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A177=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A177,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A178=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A178,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A179=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A179,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A180=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A180,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A181=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A181,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A182=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A182,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A183=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A183,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A184=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A184,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A185=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A185,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A186=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A186,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A187=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A187,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A188=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A188,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A189=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A189,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A190=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A190,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A191=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A191,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A192=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A192,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A193=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A193,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A194=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A194,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A195=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A195,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A196=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A196,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A197=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A197,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A198=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A198,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A199=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A199,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A200=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A200,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A201=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A201,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},{"$f":"IF($A202=\"\",\"\",D202+E202)","v":""},null,{"$f":"IF($A202=\"\",\"\",DATE(YEAR($B$3),MONTH($B$3),G202))","v":""},{"$f":"IF($A202=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A202,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},{"$f":"IF($A202=\"\",\"\",MAX(0,F202-I202))","v":""},{"$f":"IF($A202=\"\",\"\",IF(J202=0,\"Bezahlt\",IF(I202=0,\"Offen\",\"Teilweise\")))","v":""}]
[{"$nulls":5},"",null,"",{"$f":"IF($A203=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A203,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A204=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A204,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A205=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A205,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A206=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A206,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A207=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A207,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A208=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A208,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]
[{"$nulls":5},"",null,"",{"$f":"IF($A209=\"\",\"\",SUMIFS(Zahlungen!$G$6:$G$205,Zahlungen!$B$6:$B$205,$B$3,Zahlungen!$C$6:$C$205,$A209,Zahlungen!$F$6:$F$205,\"Warmmiete\"))","v":""},"",""]

{"sheet":"Zahlungen","index":1,"n_rows":205,"n_cols":9,"rows_kept":205,"merged":[[0,0,0,8]]}
["Zahlungen – Einnahmen"]
[]
[]
[]
["Datum","Monat","Objekt-ID","Objekt/Einheit","Mieter","Kategorie","Betrag (€)","Zahlungsart","Referenz/Notiz"]
[{"$f":"Mietübersicht!$B$3","v":"2026-02-01"},{"$f":"IF(A6=\"\",\"\",DATE(YEAR(A6),MONTH(A6),1))","v":"2026-02-01"},"G-001",{"$f":"IF($C6=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C6,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Gewerbe 1"},{"$f":"IF($C6=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C6,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Bäckerei Kruse GmbH"},"Warmmiete",{"v":1550,"d":"1,550.00 €"},"Überweisung","Feb Warmmiete"]
[{"$f":"Mietübersicht!$B$3+1","v":"2026-02-02"},"2026-02-01","W-001",{"$f":"IF($C7=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C7,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Wohnung 1"},{"$f":"IF($C7=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C7,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Anna Müller"},"Kaution",{"v":1900,"d":"1,900.00 €"},"Überweisung","Kaution"]
[{"$f":"Mietübersicht!$B$3+2","v":"2026-02-03"},"2026-02-01","W-001",{"$f":"IF($C8=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C8,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Wohnung 1"},{"$f":"IF($C8=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C8,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Anna Müller"},"Warmmiete",{"v":950,"d":"950.00 €"},"Lastschrift","Feb Warmmiete"]
[{"$f":"Mietübersicht!$B$3+3","v":"2026-02-04"},"2026-02-01","W-002",{"$f":"IF($C9=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C9,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Wohnung 2"},{"$f":"IF($C9=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C9,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Ben Schneider"},"Warmmiete",{"v":700,"d":"700.00 €"},"Überweisung","Teilzahlung"]
[{"$f":"Mietübersicht!$B$3-29","v":"2026-01-03"},"2026-01-01","W-003",{"$f":"IF($C10=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C10,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Wohnung 3"},{"$f":"IF($C10=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C10,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Carla Wagner"},"Warmmiete",{"v":870,"d":"870.00 €"},"Überweisung","Jan Warmmiete"]
[{"$f":"Mietübersicht!$B$3+6","v":"2026-02-07"},"2026-02-01","W-002",{"$f":"IF($C11=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C11,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Wohnung 2"},{"$f":"IF($C11=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C11,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":"Ben Schneider"},"Sonstiges",{"v":50,"d":"50.00 €"},"Bar","Schlüsselgebühr"]
[null,"",null,{"$f":"IF($C12=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C12,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C12=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C12,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C13=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C13,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C13=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C13,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C14=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C14,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C14=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C14,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C15=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C15,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C15=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C15,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C16=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C16,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C16=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C16,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C17=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C17,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C17=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C17,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C18=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C18,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C18=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C18,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C19=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C19,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C19=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C19,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C20=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C20,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C20=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C20,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C21=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C21,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C21=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C21,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C22=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C22,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C22=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C22,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C23=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C23,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C23=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C23,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C24=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C24,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C24=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C24,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C25=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C25,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C25=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C25,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C26=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C26,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C26=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C26,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C27=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C27,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C27=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C27,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C28=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C28,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C28=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C28,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C29=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C29,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C29=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C29,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C30=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C30,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C30=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C30,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C31=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C31,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C31=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C31,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C32=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C32,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C32=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C32,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C33=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C33,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C33=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C33,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C34=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C34,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C34=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C34,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C35=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C35,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C35=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C35,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C36=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C36,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C36=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C36,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C37=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C37,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C37=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C37,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,{"$f":"IF(A38=\"\",\"\",DATE(YEAR(A38),MONTH(A38),1))","v":""},null,{"$f":"IF($C38=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C38,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C38=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C38,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C39=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C39,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C39=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C39,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C40=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C40,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C40=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C40,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C41=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C41,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C41=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C41,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C42=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C42,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C42=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C42,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C43=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C43,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C43=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C43,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C44=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C44,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C44=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C44,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C45=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C45,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C45=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C45,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C46=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C46,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C46=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C46,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C47=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C47,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C47=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C47,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C48=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C48,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C48=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C48,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C49=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C49,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C49=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C49,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C50=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C50,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C50=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C50,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C51=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C51,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C51=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C51,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C52=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C52,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C52=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C52,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C53=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C53,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C53=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C53,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C54=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C54,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C54=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C54,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C55=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C55,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C55=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C55,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C56=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C56,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C56=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C56,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C57=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C57,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C57=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C57,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C58=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C58,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C58=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C58,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C59=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C59,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C59=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C59,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C60=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C60,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C60=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C60,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C61=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C61,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C61=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C61,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C62=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C62,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C62=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C62,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C63=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C63,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C63=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C63,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C64=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C64,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C64=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C64,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C65=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C65,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C65=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C65,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C66=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C66,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C66=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C66,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C67=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C67,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C67=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C67,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C68=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C68,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C68=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C68,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C69=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C69,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C69=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C69,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,{"$f":"IF(A70=\"\",\"\",DATE(YEAR(A70),MONTH(A70),1))","v":""},null,{"$f":"IF($C70=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C70,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C70=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C70,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C71=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C71,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C71=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C71,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C72=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C72,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C72=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C72,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C73=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C73,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C73=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C73,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C74=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C74,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C74=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C74,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C75=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C75,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C75=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C75,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C76=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C76,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C76=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C76,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C77=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C77,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C77=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C77,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C78=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C78,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C78=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C78,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C79=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C79,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C79=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C79,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C80=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C80,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C80=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C80,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C81=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C81,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C81=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C81,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C82=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C82,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C82=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C82,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C83=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C83,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C83=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C83,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C84=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C84,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C84=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C84,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C85=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C85,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C85=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C85,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C86=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C86,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C86=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C86,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C87=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C87,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C87=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C87,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C88=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C88,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C88=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C88,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C89=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C89,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C89=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C89,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C90=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C90,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C90=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C90,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C91=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C91,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C91=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C91,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C92=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C92,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C92=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C92,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C93=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C93,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C93=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C93,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C94=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C94,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C94=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C94,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C95=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C95,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C95=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C95,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C96=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C96,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C96=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C96,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C97=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C97,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C97=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C97,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C98=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C98,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C98=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C98,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C99=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C99,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C99=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C99,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C100=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C100,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C100=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C100,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C101=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C101,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C101=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C101,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,{"$f":"IF(A102=\"\",\"\",DATE(YEAR(A102),MONTH(A102),1))","v":""},null,{"$f":"IF($C102=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C102,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C102=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C102,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C103=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C103,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C103=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C103,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C104=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C104,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C104=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C104,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C105=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C105,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C105=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C105,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C106=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C106,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C106=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C106,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C107=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C107,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C107=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C107,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C108=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C108,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C108=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C108,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C109=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C109,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C109=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C109,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C110=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C110,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C110=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C110,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C111=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C111,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C111=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C111,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C112=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C112,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C112=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C112,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C113=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C113,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C113=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C113,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C114=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C114,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C114=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C114,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C115=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C115,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C115=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C115,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C116=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C116,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C116=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C116,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C117=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C117,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C117=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C117,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C118=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C118,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C118=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C118,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C119=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C119,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C119=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C119,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C120=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C120,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C120=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C120,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C121=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C121,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C121=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C121,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C122=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C122,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C122=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C122,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C123=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C123,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C123=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C123,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C124=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C124,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C124=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C124,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C125=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C125,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C125=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C125,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C126=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C126,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C126=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C126,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C127=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C127,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C127=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C127,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C128=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C128,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C128=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C128,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C129=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C129,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C129=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C129,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C130=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C130,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C130=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C130,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C131=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C131,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C131=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C131,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C132=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C132,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C132=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C132,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C133=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C133,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C133=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C133,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,{"$f":"IF(A134=\"\",\"\",DATE(YEAR(A134),MONTH(A134),1))","v":""},null,{"$f":"IF($C134=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C134,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C134=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C134,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C135=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C135,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C135=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C135,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C136=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C136,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C136=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C136,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C137=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C137,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C137=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C137,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C138=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C138,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C138=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C138,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C139=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C139,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C139=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C139,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C140=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C140,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C140=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C140,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C141=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C141,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C141=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C141,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C142=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C142,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C142=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C142,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C143=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C143,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C143=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C143,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C144=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C144,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C144=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C144,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C145=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C145,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C145=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C145,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C146=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C146,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C146=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C146,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C147=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C147,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C147=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C147,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C148=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C148,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C148=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C148,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C149=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C149,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C149=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C149,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C150=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C150,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C150=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C150,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C151=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C151,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C151=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C151,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C152=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C152,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C152=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C152,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C153=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C153,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C153=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C153,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C154=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C154,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C154=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C154,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C155=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C155,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C155=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C155,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C156=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C156,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C156=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C156,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C157=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C157,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C157=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C157,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C158=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C158,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C158=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C158,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C159=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C159,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C159=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C159,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C160=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C160,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C160=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C160,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C161=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C161,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C161=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C161,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C162=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C162,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C162=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C162,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C163=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C163,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C163=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C163,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C164=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C164,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C164=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C164,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C165=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C165,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C165=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C165,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,{"$f":"IF(A166=\"\",\"\",DATE(YEAR(A166),MONTH(A166),1))","v":""},null,{"$f":"IF($C166=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C166,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C166=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C166,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C167=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C167,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C167=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C167,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C168=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C168,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C168=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C168,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C169=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C169,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C169=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C169,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C170=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C170,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C170=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C170,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C171=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C171,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C171=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C171,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C172=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C172,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C172=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C172,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C173=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C173,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C173=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C173,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C174=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C174,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C174=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C174,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C175=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C175,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C175=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C175,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C176=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C176,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C176=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C176,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C177=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C177,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C177=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C177,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C178=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C178,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C178=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C178,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C179=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C179,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C179=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C179,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C180=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C180,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C180=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C180,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C181=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C181,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C181=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C181,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C182=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C182,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C182=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C182,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C183=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C183,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C183=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C183,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C184=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C184,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C184=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C184,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C185=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C185,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C185=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C185,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C186=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C186,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C186=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C186,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C187=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C187,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C187=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C187,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C188=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C188,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C188=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C188,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C189=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C189,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C189=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C189,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C190=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C190,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C190=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C190,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C191=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C191,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C191=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C191,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C192=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C192,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C192=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C192,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C193=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C193,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C193=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C193,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C194=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C194,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C194=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C194,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C195=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C195,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C195=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C195,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C196=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C196,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C196=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C196,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C197=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C197,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C197=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C197,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,{"$f":"IF(A198=\"\",\"\",DATE(YEAR(A198),MONTH(A198),1))","v":""},null,{"$f":"IF($C198=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C198,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C198=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C198,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C199=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C199,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C199=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C199,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C200=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C200,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C200=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C200,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C201=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C201,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C201=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C201,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C202=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C202,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C202=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C202,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C203=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C203,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C203=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C203,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C204=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C204,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C204=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C204,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]
[null,"",null,{"$f":"IF($C205=\"\",\"\",IFERROR(INDEX(Mietübersicht!$B$10:$B$209,MATCH($C205,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""},{"$f":"IF($C205=\"\",\"\",IFERROR(INDEX(Mietübersicht!$C$10:$C$209,MATCH($C205,Mietübersicht!$A$10:$A$209,0)),\"\"))","v":""}]

{"sheet":"Ausgaben","index":2,"n_rows":205,"n_cols":11,"rows_kept":205,"merged":[[0,0,0,10]]}
["Ausgaben – Kosten & Instandhaltung"]
[]
[]
[]
["Datum","Monat","Objekt-ID","Kategorie","Beschreibung","Betrag (€)","Fällig am","Bezahlt?","Bezahlt am","Lieferant/Dienstleister","Rechnung-Nr."]
[{"$f":"Mietübersicht!$B$3+4","v":"2026-02-05"},{"$f":"IF(A6=\"\",\"\",DATE(YEAR(A6),MONTH(A6),1))","v":"2026-02-01"},"W-001","Instandhaltung","Klempner – Reparatur",{"v":180,"d":"180.00 €"},{"$f":"Mietübersicht!$B$3+11","v":"2026-02-12"},"Ja",{"$f":"Mietübersicht!$B$3+11","v":"2026-02-12"},"Sanitär Müller","RE-2026-021"]
[{"$f":"Mietübersicht!$B$3+7","v":"2026-02-08"},"2026-02-01","G-001","Verwaltung","Hausverwaltungssoftware",{"v":25,"d":"25.00 €"},{"$f":"Mietübersicht!$B$3+14","v":"2026-02-15"},"Nein",null,"SoftHaus GmbH","INV-8841"]
[{"$f":"Mietübersicht!$B$3+9","v":"2026-02-10"},"2026-02-01","W-002","Versicherung","Gebäudeversicherung (Anteil)",{"v":95,"d":"95.00 €"},{"$f":"Mietübersicht!$B$3+9","v":"2026-02-10"},"Ja",{"$f":"Mietübersicht!$B$3+9","v":"2026-02-10"},"Versicherer AG","2026-02-10"]
[{"$f":"Mietübersicht!$B$3+2","v":"2026-02-03"},"2026-02-01","W-003","Energie","Strom Allgemein",{"v":60,"d":"60.00 €"},{"$f":"Mietübersicht!$B$3+19","v":"2026-02-20"},"Nein",null,"Stadtwerke","SW-9932"]
[{"$f":"Mietübersicht!$B$3-12","v":"2026-01-20"},"2026-01-01","W-001","Sonstiges","Briefkasten-Schloss",{"v":18,"d":"18.00 €"},{"$f":"Mietübersicht!$B$3-4","v":"2026-01-28"},"Ja",{"$f":"Mietübersicht!$B$3-4","v":"2026-01-28"},"Schlüsseldienst","JAN-118"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A38=\"\",\"\",DATE(YEAR(A38),MONTH(A38),1))","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A70=\"\",\"\",DATE(YEAR(A70),MONTH(A70),1))","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A102=\"\",\"\",DATE(YEAR(A102),MONTH(A102),1))","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A134=\"\",\"\",DATE(YEAR(A134),MONTH(A134),1))","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A166=\"\",\"\",DATE(YEAR(A166),MONTH(A166),1))","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A198=\"\",\"\",DATE(YEAR(A198),MONTH(A198),1))","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]