{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Heizkostenabrechnung"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Heizkostenabrechnung","index":0,"n_rows":52,"n_cols":13,"rows_kept":52,"merged":[[0,0,0,12],[2,0,2,12],[3,0,3,1],[3,2,3,5],[3,6,3,7],[3,8,3,12],[4,0,4,1],[4,2,4,5],[4,6,4,7],[4,8,4,12],[5,0,5,1],[5,2,5,3],[5,6,5,7],[5,8,5,12],[8,0,8,12],[17,0,17,12],[18,0,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,12],[19,0,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,12],[20,0,20,3],[20,4,20,5],[21,0,21,3],[21,4,21,5],[23,0,23,12],[47,6,47,12],[48,6,48,9],[48,10,48,12],[49,6,49,9],[49,10,49,12],[50,6,50,9],[50,10,50,12],[51,6,51,9],[51,10,51,12]]}
["Heizkostenabrechnung"]
[]
["Objektdaten"]
["Objekt/Adresse",null,"Musterstraße 12, 10115 Berlin",{"$nulls":3},"Abrechnungszeitraum",null,"01.01.2025 – 31.12.2025"]
["Vermieter/Hausverwaltung",null,"Muster Hausverwaltung GmbH",{"$nulls":3},"Heizart/Energieträger",null,"Gas"]
["Währung",null,"EUR",{"$nulls":3},"Notizen",null,"Beispieldaten – frei editierbar"]
[]
[]
["Kostenübersicht (Gesamt)"]
["Kostenart","Betrag (€)","Bemerkung"]
["Brennstoff/Energie",{"v":1450,"d":"1,450.00 €"},"Rechnung Stadtwerke"]
["Betriebsstrom Heizung",{"v":120,"d":"120.00 €"}]
["Wartung/Instandhaltung",{"v":210,"d":"210.00 €"},"Jährliche Wartung"]
["Messdienst/Ablesung/Abrechnung",{"v":160,"d":"160.00 €"},"Messdienst GmbH"]
["Sonstiges",{"v":60,"d":"60.00 €"},"Kleinmaterial"]
["SUMME (Gesamtkosten)",{"$f":"SUM(B11:B15)","v":{"v":2000,"d":"2,000.00 €"}},"Automatisch"]
[]
["Verteilungsschlüssel"]
["Anteil Grundkosten (%)",{"$nulls":3},{"v":0.3,"d":"30.00%"},null,"Grundkosten (gesamt)",null,{"$f":"$B$16*$E$19","v":{"v":600,"d":"600.00 €"}}]
["Anteil Verbrauchskosten (%)",{"$nulls":3},{"$f":"1-$E$19","v":{"v":0.7,"d":"70.00%"}},null,"Verbrauchskosten (gesamt)",null,{"$f":"$B$16*$E$20","v":{"v":1400,"d":"1,400.00 €"}}]
["Grundkosten-Verteilung nach",{"$nulls":3},"Wohnfläche (m²)"]
["Verbrauchskosten-Verteilung nach",{"$nulls":3},"Verbrauch (kWh)"]
[]
["Abrechnung je Einheit"]
["Einheit","Mieter","Wohnfläche (m²)","Verbrauch (kWh)","Anteil Fläche (%)","Anteil Verbrauch (%)","Grundkosten (€)","Verbrauchskosten (€)","Gesamtkosten (€)","Vorauszahlungen (€)","Saldo (Nachzahlung + / Erstattung -)","Status","Hinweis"]
["Wohnung 1","M. Schmidt",80,1000,{"$f":"IF(C26=\"\",\"\",C26/SUM($C$26:$C$45))","v":{"v":0.38095238095238093,"d":"38.10%"}},{"$f":"IF(D26=\"\",\"\",D26/SUM($D$26:$D$45))","v":{"v":0.2222222222222222,"d":"22.22%"}},{"$f":"IF(E26=\"\",\"\",$I$19*E26)","v":{"v":228.57142857142856,"d":"228.57 €"}},{"$f":"IF(F26=\"\",\"\",$I$20*F26)","v":{"v":311.1111111111111,"d":"311.11 €"}},{"$f":"IF(OR(G26=\"\",H26=\"\"),\"\",G26+H26)","v":{"v":539.6825396825396,"d":"539.68 €"}},{"v":850,"d":"850.00 €"},{"$f":"IF(OR(I26=\"\",J26=\"\"),\"\",I26-J26)","v":{"v":-310.31746031746036,"d":"-310.32 €"}},{"$f":"IF(K26=\"\",\"\",IF(K26>0,\"Nachzahlung\",IF(K26<0,\"Erstattung\",\"Ausgeglichen\")))","v":"Erstattung"}]
["Wohnung 2","L. Weber",70,2000,{"v":0.3333333333333333,"d":"33.33%"},{"v":0.4444444444444444,"d":"44.44%"},{"v":200,"d":"200.00 €"},{"v":622.2222222222222,"d":"622.22 €"},{"v":822.2222222222222,"d":"822.22 €"},{"v":900,"d":"900.00 €"},{"v":-77.77777777777783,"d":"-77.78 €"},"Erstattung"]
["Wohnung 3","A. Fischer",60,1500,{"v":0.2857142857142857,"d":"28.57%"},{"v":0.3333333333333333,"d":"33.33%"},{"v":171.42857142857142,"d":"171.43 €"},{"v":466.66666666666663,"d":"466.67 €"},{"v":638.0952380952381,"d":"638.10 €"},{"v":780,"d":"780.00 €"},{"v":-141.90476190476193,"d":"-141.90 €"},"Erstattung"]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
[{"$nulls":4},"","","","","",null,"",""]
["SUMME",null,{"$f":"SUM(C26:C45)","v":210},{"$f":"SUM(D26:D45)","v":4500},null,null,{"$f":"SUM(G26:G45)","v":{"v":600,"d":"600.00 €"}},{"$f":"SUM(H26:H45)","v":{"v":1400,"d":"1,400.00 €"}},{"$f":"SUM(I26:I45)","v":{"v":2000,"d":"2,000.00 €"}},{"$f":"SUM(J26:J45)","v":{"v":2530,"d":"2,530.00 €"}},{"$f":"SUM(K26:K45)","v":{"v":-530.0000000000001,"d":"-530.00 €"}}]
[]
[{"$nulls":6},"Kontrollsummen"]
[{"$nulls":6},"Gesamt Wohnfläche (m²)",{"$nulls":3},{"$f":"C46","v":210}]
[{"$nulls":6},"Gesamt Verbrauch (kWh)",{"$nulls":3},{"$f":"D46","v":4500}]
[{"$nulls":6},"Summe Einheiten (Gesamtkosten)",{"$nulls":3},{"$f":"I46","v":{"v":2000,"d":"2,000.00 €"}}]
[{"$nulls":6},"Prüfsumme (soll 0 sein)",{"$nulls":3},{"$f":"I46-$B$16","v":{"v":0,"d":"0.00 €"}}]