{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Mieteinnahmen Mehrfamilienhaus","Mieteinnahmen Wohnungen","Mieter und Zahlungen"],"read":"whole","date_system":"1900"}

{"sheet":"Mieteinnahmen Mehrfamilienhaus","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"merged":[[0,0,0,3],[1,1,1,3],[2,1,2,3],[19,8,19,10],[20,8,20,10],[21,8,21,10],[23,0,23,4]]}
["Mieteinnahmen Mehrfamilienhaus"]
["Stand:","03.09.2025"]
["Anschrift:","Musterstraße 12, 10115 Berlin"]
[]
["Nr.","Lage","Größe\n(qm)","Status","Netto-Kaltmiete\n(€)","Qm-Preis\n(€/qm)","Nebenkosten\nVorauszahlung (€)","Nebenkosten / qm\n(€/qm)","Stellplatz-Miete\n(€)","Brutto-Miete\n(€)","SOLL\nNetto-Kaltmiete (€)","SOLL\nStellplatz-Miete (€)"]
[1,"WE 1 links",{"v":62.5,"d":"62.50"},"vermietet",{"v":680,"d":"€ 680.00"},{"$f":"IF(C6>0,E6/C6,\"\")","v":10.88},{"v":120,"d":"€ 120.00"},{"$f":"IF(C6>0,G6/C6,\"\")","v":1.92},{"v":0,"d":"€ 0.00"},{"$f":"IF(D6=\"vermietet\",E6+G6+I6,0)","v":{"v":800,"d":"€ 800.00"}},{"v":700,"d":"€ 700.00"},{"v":0,"d":"€ 0.00"}]
[2,"WE 1 rechts",{"v":58,"d":"58.00"},"vermietet",{"v":640,"d":"€ 640.00"},{"v":11.03448275862069,"d":"11.03"},{"v":110,"d":"€ 110.00"},{"v":1.896551724137931,"d":"1.90"},{"v":0,"d":"€ 0.00"},{"v":750,"d":"€ 750.00"},{"v":670,"d":"€ 670.00"},{"v":0,"d":"€ 0.00"}]
[3,"WE 2 links",{"v":75.2,"d":"75.20"},"vermietet",{"v":820,"d":"€ 820.00"},{"v":10.904255319148936,"d":"10.90"},{"v":140,"d":"€ 140.00"},{"v":1.8617021276595744,"d":"1.86"},{"v":60,"d":"€ 60.00"},{"v":1020,"d":"€ 1,020.00"},{"v":860,"d":"€ 860.00"},{"v":50,"d":"€ 50.00"}]
[4,"WE 2 rechts",{"v":74.8,"d":"74.80"},"leer",{"v":0,"d":"€ 0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":850,"d":"€ 850.00"},{"v":40,"d":"€ 40.00"}]
[5,"WE 3 links",{"v":80,"d":"80.00"},"vermietet",{"v":900,"d":"€ 900.00"},11.25,{"v":150,"d":"€ 150.00"},{"v":1.875,"d":"1.88"},{"v":0,"d":"€ 0.00"},{"v":1050,"d":"€ 1,050.00"},{"v":920,"d":"€ 920.00"},{"v":0,"d":"€ 0.00"}]
[6,"WE 3 rechts",{"v":80,"d":"80.00"},"vermietet",{"v":910,"d":"€ 910.00"},{"v":11.375,"d":"11.38"},{"v":150,"d":"€ 150.00"},{"v":1.875,"d":"1.88"},{"v":0,"d":"€ 0.00"},{"v":1060,"d":"€ 1,060.00"},{"v":930,"d":"€ 930.00"},{"v":0,"d":"€ 0.00"}]
[7,"WE 4 links",{"v":52,"d":"52.00"},"vermietet",{"v":560,"d":"€ 560.00"},{"v":10.76923076923077,"d":"10.77"},{"v":95,"d":"€ 95.00"},{"v":1.8269230769230769,"d":"1.83"},{"v":0,"d":"€ 0.00"},{"v":655,"d":"€ 655.00"},{"v":600,"d":"€ 600.00"},{"v":0,"d":"€ 0.00"}]
[8,"WE 4 rechts",{"v":52,"d":"52.00"},"leer",{"v":0,"d":"€ 0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":600,"d":"€ 600.00"},{"v":0,"d":"€ 0.00"}]
[9,"Dachgeschoss",{"v":45.5,"d":"45.50"},"vermietet",{"v":520,"d":"€ 520.00"},{"v":11.428571428571429,"d":"11.43"},{"v":85,"d":"€ 85.00"},{"v":1.8681318681318682,"d":"1.87"},{"v":0,"d":"€ 0.00"},{"v":605,"d":"€ 605.00"},{"v":540,"d":"€ 540.00"},{"v":0,"d":"€ 0.00"}]
[10,"Gewerbe EG",{"v":120,"d":"120.00"},"vermietet",{"v":1500,"d":"€ 1,500.00"},{"v":12.5,"d":"12.50"},{"v":300,"d":"€ 300.00"},{"v":2.5,"d":"2.50"},{"v":0,"d":"€ 0.00"},{"v":1800,"d":"€ 1,800.00"},{"v":1600,"d":"€ 1,600.00"},{"v":0,"d":"€ 0.00"}]
[{"$nulls":5},"",null,"",null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":5},"",null,"",null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":5},"",null,"",null,{"v":0,"d":"€ 0.00"}]
[]
[{"$nulls":8},"Gesamt-Miete IST pro Monat:",null,null,{"$f":"SUMIF(D6:D18,\"vermietet\",E6:E18)+SUMIF(D6:D18,\"vermietet\",I6:I18)","v":{"v":6590,"d":"€ 6,590.00"}}]
[{"$nulls":8},"Gesamt-Miete SOLL pro Monat:",null,null,{"$f":"SUM(L6:L18)+SUM(M6:M18)","v":{"v":90,"d":"€ 90.00"}}]
[{"$nulls":8},"Differenz:",null,null,{"$f":"L21-L20","v":{"v":-6500,"d":"-€ 6,500.00"}}]
[]
["Hinweis: Nebenkosten werden in den Gesamtsummen IST/SOLL nicht mitgerechnet."]

{"sheet":"Mieteinnahmen Wohnungen","index":1,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[0,0,0,2],[19,9,19,11],[20,9,20,11],[21,9,21,11],[23,0,23,4]]}
["Mieteinnahmen Wohnungen"]
["Stand:","03.09.2025"]
[]
["Nr.","Adresse","Detail","Größe\n(qm)","Status","Netto-Kaltmiete\n(€)","Qm-Preis\n(€/qm)","Nebenkosten\nVorauszahlung (€)","Nebenkosten / qm\n(€/qm)","Stellplatz-Miete\n(€)","Brutto-Miete\n(€)","SOLL\nNetto-Kaltmiete (€)","SOLL\nStellplatz-Miete (€)"]
[1,"Lindenweg 5, Köln","WE 1",{"v":55,"d":"55.00"},"vermietet",{"v":620,"d":"€ 620.00"},{"$f":"IF(D5>0,F5/D5,\"\")","v":{"v":11.272727272727273,"d":"11.27"}},{"v":100,"d":"€ 100.00"},{"$f":"IF(D5>0,H5/D5,\"\")","v":{"v":1.8181818181818181,"d":"1.82"}},{"v":0,"d":"€ 0.00"},{"$f":"IF(E5=\"vermietet\",F5+H5+J5,0)","v":{"v":720,"d":"€ 720.00"}},{"v":650,"d":"€ 650.00"},{"v":0,"d":"€ 0.00"}]
[2,"Lindenweg 5, Köln","WE 2",{"v":60,"d":"60.00"},"vermietet",{"v":690,"d":"€ 690.00"},{"v":11.5,"d":"11.50"},{"v":110,"d":"€ 110.00"},{"v":1.8333333333333333,"d":"1.83"},{"v":0,"d":"€ 0.00"},{"v":800,"d":"€ 800.00"},{"v":710,"d":"€ 710.00"},{"v":0,"d":"€ 0.00"}]
[3,"Lindenweg 5, Köln","WE 3",{"v":0,"d":"0.00"},"leer",{"v":0,"d":"€ 0.00"},"",{"v":0,"d":"€ 0.00"},"",{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":700,"d":"€ 700.00"},{"v":0,"d":"€ 0.00"}]
[4,"Ahornallee 9, München","WE 1",{"v":78,"d":"78.00"},"vermietet",{"v":980,"d":"€ 980.00"},{"v":12.564102564102564,"d":"12.56"},{"v":160,"d":"€ 160.00"},{"v":2.051282051282051,"d":"2.05"},{"v":70,"d":"€ 70.00"},{"v":1210,"d":"€ 1,210.00"},{"v":1000,"d":"€ 1,000.00"},{"v":50,"d":"€ 50.00"}]
[5,"Ahornallee 9, München","WE 2",{"v":80,"d":"80.00"},"vermietet",{"v":1020,"d":"€ 1,020.00"},12.75,{"v":165,"d":"€ 165.00"},{"v":2.0625,"d":"2.06"},{"v":70,"d":"€ 70.00"},{"v":1255,"d":"€ 1,255.00"},{"v":1050,"d":"€ 1,050.00"},{"v":50,"d":"€ 50.00"}]
[6,"Birkenstraße 3, Hamburg","WE 1",{"v":45,"d":"45.00"},"vermietet",{"v":540,"d":"€ 540.00"},{"v":12,"d":"12.00"},{"v":85,"d":"€ 85.00"},{"v":1.8888888888888888,"d":"1.89"},{"v":0,"d":"€ 0.00"},{"v":625,"d":"€ 625.00"},{"v":560,"d":"€ 560.00"},{"v":0,"d":"€ 0.00"}]
[7,"Birkenstraße 3, Hamburg","WE 2",{"v":46,"d":"46.00"},"vermietet",{"v":555,"d":"€ 555.00"},{"v":12.065217391304348,"d":"12.07"},{"v":85,"d":"€ 85.00"},{"v":1.8478260869565217,"d":"1.85"},{"v":0,"d":"€ 0.00"},{"v":640,"d":"€ 640.00"},{"v":570,"d":"€ 570.00"},{"v":0,"d":"€ 0.00"}]
[8,"Birkenstraße 3, Hamburg","WE 3",{"v":46,"d":"46.00"},"leer",{"v":0,"d":"€ 0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":570,"d":"€ 570.00"},{"v":0,"d":"€ 0.00"}]
[9,"Birkenstraße 3, Hamburg","WE 4",{"v":50,"d":"50.00"},"vermietet",{"v":600,"d":"€ 600.00"},{"v":12,"d":"12.00"},{"v":90,"d":"€ 90.00"},{"v":1.8,"d":"1.80"},{"v":0,"d":"€ 0.00"},{"v":690,"d":"€ 690.00"},{"v":620,"d":"€ 620.00"},{"v":0,"d":"€ 0.00"}]
[10,"Birkenstraße 3, Hamburg","WE 5",{"v":52,"d":"52.00"},"vermietet",{"v":630,"d":"€ 630.00"},{"v":12.115384615384615,"d":"12.12"},{"v":95,"d":"€ 95.00"},{"v":1.8269230769230769,"d":"1.83"},{"v":0,"d":"€ 0.00"},{"v":725,"d":"€ 725.00"},{"v":640,"d":"€ 640.00"},{"v":0,"d":"€ 0.00"}]
[{"$nulls":6},"",null,"",null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":6},"",null,"",null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":6},"",null,"",null,{"v":0,"d":"€ 0.00"}]
[{"$nulls":6},"",null,"",null,{"v":0,"d":"€ 0.00"}]
[]
[{"$nulls":9},"Gesamt-Miete IST pro Monat:",null,null,{"$f":"SUMIF(E5:E18,\"vermietet\",F5:F18)+SUMIF(E5:E18,\"vermietet\",J5:J18)","v":{"v":5775,"d":"€ 5,775.00"}}]
[{"$nulls":9},"Gesamt-Miete SOLL pro Monat:",null,null,{"$f":"SUM(L5:L18)+SUM(M5:M18)","v":{"v":7170,"d":"€ 7,170.00"}}]
[{"$nulls":9},"Differenz:",null,null,{"$f":"M21-M20","v":{"v":1395,"d":"€ 1,395.00"}}]
[]
["Hinweis: Nebenkosten werden in den Gesamtsummen IST/SOLL nicht mitgerechnet."]

{"sheet":"Mieter und Zahlungen","index":2,"n_rows":11,"n_cols":15,"rows_kept":11}
["Mieter und Zahlungen"]
["Stand:","09/2025"]
[]
[]
["Wohnung","Mieter","Brutto-Miete (€)","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"]
["WE 1 links (Berlin)","Anna Müller",{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"},{"v":800,"d":"€ 800.00"}]
["WE 2 links (Berlin)","Jonas Weber",{"v":1020,"d":"€ 1,020.00"},{"v":1020,"d":"€ 1,020.00"},{"v":1020,"d":"€ 1,020.00"},{"v":1020,"d":"€ 1,020.00"}]
["WE 3 links (Berlin)","Lea Schäfer",{"v":1050,"d":"€ 1,050.00"},{"v":1050,"d":"€ 1,050.00"},{"v":1050,"d":"€ 1,050.00"},{"v":1050,"d":"€ 1,050.00"},{"v":1050,"d":"€ 1,050.00"},{"v":1050,"d":"€ 1,050.00"}]
["WE 1 (Köln)","Emir Yilmaz",{"v":720,"d":"€ 720.00"},{"v":720,"d":"€ 720.00"},{"v":720,"d":"€ 720.00"}]
["WE 1 (München)","Sophie Lange",{"v":1120,"d":"€ 1,120.00"},{"v":1120,"d":"€ 1,120.00"}]
["WE 1 (Hamburg)","Diego Torres",{"v":625,"d":"€ 625.00"},{"v":625,"d":"€ 625.00"},{"v":625,"d":"€ 625.00"},{"v":625,"d":"€ 625.00"},{"v":625,"d":"€ 625.00"}]