{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":203,"n_cols":12,"rows_kept":203,"cut":false,"hidden":false,"merged":[[30,11,30,12],[28,11,28,12],[31,11,31,12],[0,1,5,12],[28,1,28,2],[29,1,29,2],[32,1,32,2],[33,1,33,2],[24,9,24,10],[25,9,25,10],[27,6,27,7],[28,6,28,7],[30,9,30,10],[25,1,25,2],[26,1,26,2],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[26,11,26,12],[27,11,27,12],[27,1,27,2],[6,3,6,12],[36,9,36,10],[37,9,37,10],[38,9,38,10],[34,9,34,10],[32,6,32,7],[34,1,34,2],[35,1,35,2],[15,1,16,12],[22,9,22,10],[22,11,22,12],[23,9,23,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[32,9,32,10],[29,6,29,7],[29,9,29,10],[29,11,29,12],[31,1,31,2],[31,6,31,7],[31,9,31,10],[22,1,22,2],[24,1,24,2],[21,1,21,2],[46,1,47,12],[50,1,50,2],[51,1,51,2],[41,1,41,4],[41,9,41,10],[40,1,40,2],[43,11,43,12],[44,11,44,12],[45,11,45,12],[48,1,48,2],[49,1,49,2],[48,4,48,10],[49,4,49,10],[50,6,50,10],[48,11,48,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[51,6,51,10],[7,3,7,12],[8,3,8,12],[9,3,9,12],[11,3,11,12],[39,1,39,2],[39,9,39,10],[6,1,6,2],[35,11,35,12],[30,1,30,2],[30,6,30,7],[36,11,36,12],[32,11,32,12],[34,11,34,12],[18,1,18,2],[17,1,17,2],[17,4,17,10],[18,4,18,10],[18,11,18,12],[17,11,17,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[11,1,11,2],[9,1,9,2],[55,1,55,2],[55,6,55,7],[55,9,55,10],[55,11,55,12],[52,1,52,2],[53,1,53,2],[53,6,53,7],[53,9,53,10],[52,11,52,12],[52,6,52,10],[58,1,58,2],[58,6,58,7],[58,9,58,10],[58,11,58,12],[59,1,59,2],[59,6,59,7],[59,9,59,10],[59,11,59,12],[56,1,56,2],[56,6,56,7],[56,9,56,10],[56,11,56,12],[57,1,57,2],[57,6,57,7],[57,9,57,10],[57,11,57,12],[62,1,62,2],[62,6,62,7],[62,9,62,10],[62,11,62,12],[63,1,63,2],[63,6,63,7],[63,9,63,10],[60,1,60,2],[60,6,60,7],[60,9,60,10],[60,11,60,12],[61,1,61,2],[61,6,61,7],[61,9,61,10],[61,11,61,12],[63,11,63,12],[66,1,66,2],[66,6,66,7],[66,9,66,10],[66,11,66,12],[67,6,67,7],[67,9,67,10],[64,1,64,2],[64,6,64,7],[64,9,64,10],[65,1,65,2],[65,6,65,7],[65,9,65,10],[67,11,67,12],[64,11,64,12],[65,11,65,12],[71,1,71,2],[72,1,72,4],[72,9,72,10],[74,1,74,4],[74,9,74,10],[68,6,68,7],[68,9,68,10],[69,6,69,7],[69,9,69,10],[70,1,70,2],[70,3,70,7],[70,9,70,10],[68,1,68,2],[69,1,69,2],[146,1,146,2],[146,6,146,7],[146,9,146,10],[146,11,146,12],[148,6,148,7],[148,9,148,10],[148,11,148,12],[140,1,141,12],[144,1,144,2],[145,1,145,2],[148,1,148,2],[147,1,147,2],[147,9,147,10],[147,6,147,7],[147,11,147,12],[142,1,142,2],[143,1,143,2],[142,11,142,12],[143,11,143,12],[144,11,144,12],[145,11,145,12],[144,6,144,10],[142,6,142,10],[154,1,154,2],[154,6,154,7],[154,9,154,10],[154,11,154,12],[155,1,155,2],[155,6,155,7],[155,9,155,10],[155,11,155,12],[149,1,149,2],[149,6,149,7],[149,9,149,10],[149,11,149,12],[153,1,153,2],[153,6,153,7],[153,9,153,10],[153,11,153,12],[151,1,151,2],[152,1,152,2],[150,1,150,2],[150,6,150,7],[151,6,151,7],[152,6,152,7],[150,11,150,12],[151,11,151,12],[157,1,157,2],[157,6,157,7],[157,9,157,10],[158,1,158,2],[158,6,158,7],[158,9,158,10],[160,11,160,12],[157,11,157,12],[156,1,156,2],[156,6,156,7],[156,9,156,10],[156,11,156,12],[164,1,164,2],[165,1,165,4],[165,9,165,10],[167,1,167,4],[167,9,167,10],[162,6,162,7],[162,9,162,10],[163,1,163,2],[163,9,163,10],[166,1,166,4],[166,9,166,10],[170,1,171,12],[178,1,178,2],[179,1,179,2],[180,1,180,2],[180,6,180,7],[180,9,180,10],[180,11,180,12],[178,11,178,12],[179,6,179,10],[179,11,179,12],[181,1,181,2],[181,6,181,7],[181,9,181,10],[181,11,181,12],[182,6,182,7],[182,9,182,10],[182,11,182,12],[183,1,183,2],[183,6,183,7],[183,9,183,10],[183,11,183,12],[182,1,182,2],[184,1,184,2],[184,6,184,7],[184,9,184,10],[184,11,184,12],[185,1,185,2],[185,6,185,7],[185,9,185,10],[185,11,185,12],[186,1,186,2],[186,6,186,7],[186,9,186,10],[186,11,186,12],[187,1,187,2],[187,6,187,7],[187,9,187,10],[187,11,187,12],[188,1,188,2],[188,6,188,7],[188,9,188,10],[188,11,188,12],[189,1,189,2],[189,6,189,7],[189,9,189,10],[189,11,189,12],[190,1,190,2],[190,6,190,7],[190,9,190,10],[190,11,190,12],[191,1,191,2],[191,6,191,7],[191,9,191,10],[191,11,191,12],[192,1,192,2],[192,6,192,7],[192,9,192,10],[192,11,192,12],[194,1,194,2],[194,6,194,7],[194,9,194,10],[194,11,194,12],[195,6,195,7],[195,9,195,10],[195,11,195,12],[196,6,196,7],[196,9,196,10],[196,11,196,12],[197,6,197,7],[197,9,197,10],[198,1,198,2],[198,3,198,7],[198,9,198,10],[199,1,199,2],[200,1,200,4],[200,9,200,10],[202,1,202,4],[202,9,202,10],[193,1,193,2],[193,6,193,7],[193,9,193,10],[193,11,193,12],[21,6,21,10],[20,6,20,10],[19,6,19,10],[19,11,19,12],[20,11,20,12],[21,11,21,12],[37,1,37,2],[38,1,38,2],[37,11,37,12],[38,11,38,12],[33,11,33,12],[40,3,40,8],[39,11,39,12],[40,11,40,12],[42,9,42,10],[44,9,44,10],[45,9,45,10],[40,9,40,10],[41,11,41,12],[42,11,42,12],[8,1,8,2],[7,1,7,2],[42,1,42,4],[44,1,44,4],[45,1,45,4],[39,3,39,8],[12,1,12,2],[13,1,13,2],[12,3,14,12],[14,1,14,2],[43,1,43,4],[43,9,43,10],[19,1,19,2],[20,1,20,2],[36,6,36,7],[37,6,37,7],[38,6,38,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[33,9,33,10],[35,9,35,10],[10,1,10,2],[10,3,10,12],[68,11,68,12],[69,11,69,12],[70,11,70,12],[71,11,71,12],[71,9,71,10],[53,11,53,12],[54,6,54,7],[54,9,54,10],[54,11,54,12],[161,1,161,2],[162,1,162,2],[161,11,161,12],[162,11,162,12],[163,3,163,8],[163,11,163,12],[71,3,71,7],[72,11,72,12],[73,11,73,12],[74,11,74,12],[75,11,75,12],[76,11,76,12],[73,9,73,10],[75,9,75,10],[76,9,76,10],[73,1,73,4],[76,1,76,4],[75,1,75,4],[159,11,159,12],[160,6,160,7],[160,9,160,10],[161,6,161,7],[161,9,161,10],[159,1,159,2],[202,11,202,12],[201,9,201,10],[201,1,201,4],[77,1,78,12],[79,1,79,2],[79,4,79,10],[79,11,79,12],[80,1,80,2],[80,4,80,10],[80,11,80,12],[197,11,197,12],[198,11,198,12],[199,11,199,12],[196,1,196,2],[197,1,197,2],[199,3,199,7],[199,9,199,10],[200,11,200,12],[201,11,201,12],[168,1,168,4],[169,1,169,4],[164,3,164,8],[164,11,164,12],[164,9,164,10],[81,1,81,2],[81,6,81,10],[81,11,81,12],[82,1,82,2],[82,6,82,10],[82,11,82,12],[83,1,83,2],[83,6,83,10],[83,11,83,12],[84,1,84,2],[84,6,84,7],[84,9,84,10],[84,11,84,12],[85,6,85,7],[85,9,85,10],[85,11,85,12],[86,1,86,2],[86,6,86,7],[86,9,86,10],[86,11,86,12],[87,1,87,2],[87,6,87,7],[87,9,87,10],[87,11,87,12],[88,1,88,2],[88,6,88,7],[88,9,88,10],[88,11,88,12],[89,1,89,2],[89,6,89,7],[89,9,89,10],[89,11,89,12],[90,1,90,2],[90,6,90,7],[90,9,90,10],[90,11,90,12],[91,1,91,2],[91,6,91,7],[91,9,91,10],[91,11,91,12],[92,1,92,2],[92,6,92,7],[92,9,92,10],[92,11,92,12],[93,1,93,2],[93,6,93,7],[93,9,93,10],[93,11,93,12],[94,1,94,2],[94,6,94,7],[94,9,94,10],[94,11,94,12],[95,1,95,2],[95,6,95,7],[95,9,95,10],[95,11,95,12],[96,1,96,2],[96,6,96,7],[96,9,96,10],[96,11,96,12],[97,1,97,2],[97,6,97,7],[97,9,97,10],[97,11,97,12],[98,6,98,7],[98,9,98,10],[98,11,98,12],[99,1,99,2],[99,6,99,7],[99,9,99,10],[99,11,99,12],[100,1,100,2],[100,6,100,7],[100,9,100,10],[100,11,100,12],[101,1,101,2],[101,3,101,7],[101,9,101,10],[101,11,101,12],[102,1,102,2],[102,3,102,7],[102,9,102,10],[102,11,102,12],[103,1,103,4],[103,9,103,10],[103,11,103,12],[104,1,104,4],[104,9,104,10],[104,11,104,12],[105,1,105,4],[105,9,105,10],[105,11,105,12],[106,1,106,4],[106,9,106,10],[106,11,106,12],[107,1,107,4],[107,9,107,10],[107,11,107,12],[114,1,114,2],[114,11,114,12],[115,1,115,2],[115,11,115,12],[116,1,116,2],[116,6,116,7],[116,9,116,10],[116,11,116,12],[111,1,111,2],[111,11,111,12],[112,1,112,2],[112,11,112,12],[113,1,113,2],[113,11,113,12],[117,6,117,7],[117,9,117,10],[117,11,117,12],[118,1,118,2],[118,6,118,7],[118,9,118,10],[118,11,118,12],[119,1,119,2],[119,6,119,7],[119,9,119,10],[119,11,119,12],[168,9,168,10],[169,9,169,10],[165,11,165,12],[166,11,166,12],[167,11,167,12],[168,11,168,12],[169,11,169,12],[145,6,145,10],[143,6,143,10],[158,11,158,12],[159,6,159,7],[159,9,159,10],[152,11,152,12],[150,9,150,10],[151,9,151,10],[152,9,152,10],[120,1,120,2],[120,6,120,7],[120,9,120,10],[120,11,120,12],[121,1,121,2],[121,6,121,7],[121,9,121,10],[121,11,121,12],[122,1,122,2],[122,6,122,7],[122,9,122,10],[122,11,122,12],[123,1,123,2],[123,6,123,7],[123,9,123,10],[123,11,123,12],[124,1,124,2],[124,6,124,7],[124,9,124,10],[124,11,124,12],[125,1,125,2],[125,6,125,7],[125,9,125,10],[125,11,125,12],[126,6,126,7],[126,9,126,10],[126,11,126,12],[127,1,127,2],[127,6,127,7],[127,9,127,10],[127,11,127,12],[128,1,128,2],[128,6,128,7],[128,9,128,10],[128,11,128,12],[134,11,134,12],[134,1,134,2],[134,3,134,7],[129,1,129,2],[129,9,129,10],[129,11,129,12],[130,9,130,10],[130,11,130,12],[131,9,131,10],[131,11,131,12],[203,1,203,4],[204,1,204,4],[203,9,203,10],[204,9,204,10],[203,11,203,12],[204,11,204,12],[109,1,110,12],[111,4,111,10],[112,4,112,10],[113,6,113,10],[114,6,114,10],[115,6,115,10],[126,1,126,2],[129,6,129,7],[130,6,130,7],[131,1,131,2],[131,6,131,7],[132,1,132,2],[132,6,132,7],[133,1,133,2],[133,3,133,7],[132,9,132,10],[132,11,132,12],[133,9,133,10],[139,1,139,4],[139,9,139,10],[139,11,139,12],[178,6,178,10],[177,1,177,12],[173,1,176,12],[172,1,172,12],[108,1,108,4],[108,9,108,10],[108,11,108,12],[136,1,136,4],[136,9,136,10],[136,11,136,12],[137,1,137,4],[137,9,137,10],[137,11,137,12],[138,1,138,4],[138,9,138,10],[138,11,138,12],[135,1,135,4],[135,9,135,10],[135,11,135,12],[133,11,133,12],[134,9,134,10]]}
[null,"Wirtschaftlichkeitsberechnung Heizungsanlage für Ein - Dreifamilienhäuser, Jahresheizenergiebedarf bis 35.000kWh ( 25kW Anschlussleistung)                                                                                                                            Größere Leistungen sind Sonderanschlüsse und werden gesondert bewertet, die beeinflusst auch die Preisbildung."]
[]
[]
[]
[]
[]
[null,"Grundlagen ",null,"Gesamtwirkungsgrad Heizkesselanlage, einschließlich Energieverluste durch den Kamin und Stillstand 90%"]
[null,null,null,"Aktuelle Marktübliche Endverbraucherpreise, Technik installiert und gewarten durch das Fachhandwerk"]
[null,null,null,"Energiepreise, Durchschnitte der letzten 3 Jahre, über die gängigen Suchportale"]
[null,null,null,"Nutzungsdauer der Anlagentechnik gemäß Herstelleraussagen, bzw. nach Ersatzteilgarantie"]
[null,null,null,"Bauliche Massnahmen, wie Bunker, Sonden usw. gemäß durchschnittlichen Erfahrungswerten"]
[null,null,null," Tägliche Kosten für Unterhaltsarbeiten Scheitholz/ Hackschnitzelkessel/ Pellets sind nicht kalkuliert "]
[null,null,null,"In dieser Tabelle kann man in den gelb hinterlegten Feldern seine eigenen Werte/ Kosten eintragen. Das Ergebnis sind die tatsächlichen Vollkosten je kW/h. Diese Berechnungen sollten zu ca. 95% stimmen, Einzelabweichungen im Sonderfall immer möglich."]
[]
[]
[null,"Ölheizung "]
[]
[]
[]
[null,"Ölbedarf jährlich",null,"in ltr",2300]
[null,"Energiebedarf jährlich ",null,"in kWh",{"$f":"10.08*E20","v":23184},null,"Energieinhalt Heizöl 1 ltr = 10,08 kWh"]
[null," Energiebedarf bereinigt",null,"in kWh",{"$f":"0.9*E21","v":20865.600000000002},null,"Gesamtwirkungsgrad Heizkessel mit eingerechnet"]
[null,"Kostenart",null,"Größe, ltr/ m³/ kW","Menge","Kosten","Faktor/ Einheit",null,"Laufjahre","jährliche Kosten",null,"Sonstiges"]
[null,"Heizkessel + Zubehör",null,"20  - 25 kW",1,18200,"€/Stk",null,17,{"$f":"(E24*F24)/I24","v":1070.5882352941176},null,"Ölbrennwert"]
[null,"Öllager ",null,"5000 Liter",1,4200,"€/ Stk",null,30,{"$f":"(E25*F25)/I25","v":140},null,"Sanierung nach 30 Jahren"]
[null,"Raumkosten Heizraum",null,"m²",8,1600,"€/m²",null,50,{"$f":"E26*F26/I26","v":256},null,"Baukosten/m² aktuell"]
[null,"Raumkosten Ölraum",null,"m²",8,1600,"€/m²",null,50,{"$f":"E27*F27/I27","v":256},null,"Baukosten/m² aktuell"]
[null,"Kamin",null,"10 m Höhe",10,80,"€/ Stk",null,17,{"$f":"E28*F28/I28","v":47.058823529411768},null,"Sanierungskosten"]
[null,"Reparaturrücklagen",null,"1 jährliche",1,150,"€/a",null,1,150]
[null,"Wartung",null,"1 jährliche",1,150,"€/Stk",null,1,150,null,"Instandhaltung"]
[null,"Kaminkehrer",null,"1 jährliche",1,80,"€/a",null,1,{"$f":"E31*F31","v":80}]
[]
[null,"Feste Kosten",null,"jährlich",1,null,"€/a",null,1,{"$f":"SUM(J24:J32)","v":2149.6470588235293},null,"ohne Inflation"]
[null,"Variable Kosten"]
[null,"Öleinkauf",null,"jährlich",{"$f":"E20","v":2300},1,"€/ltr",null,1,{"$f":"E35*F35","v":2300},null,"ohne CO² Steuer"]
[null,"Stromkosten",null,"jährlich",120,0.28000000000000003,"€/kWh",null,1,{"$f":"E36*F36","v":33.6},null,"Nur Brennergebläse"]
[null,"Variable Kosten gesamt",null,"jährlich",{"$nulls":5},{"$f":"SUM(J35:J36)","v":2333.6},null,"ohne Inflation"]
[]
[]
[null,"Gesamtkosten",null,"Feste + Variable Kosten gesamt",{"$nulls":5},{"$f":"J37+J33","v":4483.2470588235292}]
[]
[null,"Umgelegt auf die kWh entspricht dies Kosten von ",null,null,null,{"$f":"J40","v":4483.2470588235292},":",{"$f":"E22","v":20865.600000000002},"kWh            =",{"$f":"F42/H42","v":0.21486307888694928},null,"kWh"]
[]
[null,"Umgelegt auf die kWh ohne Raumkosten",null,null,null,{"$f":"F42-J26-J27","v":3971.2470588235292},":",{"$f":"E22","v":20865.600000000002},"kWh            =",{"$f":"F44/H44","v":0.19032508333446096},null,"kWh"]
[]
[]
[null,"Pelletsheizung "]
[]
[]
[]
[null,"Pelletsbedarf jährlich",null,"in kg",5000]
[null,"Energiebedarf jährlich ",null,"in kWh",{"$f":"5*E51","v":25000},null,"Energieinhalt Pellets, 1 kg = 5 kWh"]
[null," Energiebedarf bereinigt",null,"in kWh",{"$f":"0.9*E52","v":22500},null,"Gesamtwirkungsgrad Heizkessel mit eingerechnet"]
[null,"Kostenart",null,"Größe, ltr/ m³/ kW","Menge","Kosten","Faktor/ Einheit",null,"Laufjahre","jährliche Kosten",null,"Sonstiges"]
[null,"Heizkessel + Zubehör",null,"20 - 24 kW",1,28000,"€/Stk",null,17,{"$f":"(E55*F55)/I55","v":1647.0588235294117},null,"Heizwert mit Puffer"]
[null,"Pelletslager",null,"6000 kg",1,2500,"€/ Stk",null,17,{"$f":"(E56*F56)/I56","v":147.05882352941177},null,"Bau Bunker im Austausch"]
[null,"Raumkosten Heizraum",null,"m² ",8,1600,"€/m²",null,50,{"$f":"E57*F57/I57","v":256},null,"Baukosten/m² aktuell"]
[null,"Raumkosten Pellets",null,"m² ",8,1600,"€/m²",null,50,{"$f":"E58*F58/I58","v":256},null,"Baukosten/m² aktuell"]
[null,"Kamin",null,"10 m Höhe",10,80,"€/ Stk",null,17,{"$f":"E59*F59/I59","v":47.058823529411768},null,"Sanierungskosten"]
[null,"Reparaturrücklagen",null,"1 jährliche",1,250,"€/a",null,1,{"$f":"F60","v":250}]
[null,"Wartung",null,"1 jährliche",1,220,"€/Stk",null,1,{"$f":"F61","v":220},null,"Instandhaltung"]
[null,"Kaminkehrer",null,"1 jährliche",1,120,"€/a",null,1,{"$f":"E62*F62","v":120}]
[]
[null,"Feste Kosten",null,"jährlich",1,null,"€/a",null,1,{"$f":"SUM(J55:J63)","v":2943.1764705882351},null,"ohne Inflation"]
[null,"Variable Kosten"]
[null,"Pelleteinkauf",null,"jährlich",{"$f":"E51","v":5000},0.38,"€/kg",null,1,{"$f":"E66*F66","v":1900}]
[null,"Stromkosten",null,"jährlich",200,0.28000000000000003,"€/kWh",null,1,{"$f":"E67*F67","v":56.000000000000007},null,"Nur Kesseltechnik"]
[null,"Variable Kosten gesamt",null,"jährlich",{"$nulls":5},{"$f":"SUM(J66:J67)","v":1956},null,"ohne Inflation"]
[]
[]
[null,"Gesamtkosten",null,"Feste + Variable Kosten gesamt",{"$nulls":5},{"$f":"J68+J64","v":4899.1764705882351}]
[]
[null,"Umgelegt auf die kWh entspricht dies Kosten von ",null,null,null,{"$f":"J71","v":4899.1764705882351},":",{"$f":"E53","v":22500},"kWh            =",{"$f":"F73/H73","v":0.21774117647058822},null,"kWh"]
[]
[null,"Umgelegt auf die kWh ohne Raumkosten",null,null,null,{"$f":"F73-J57-J58","v":4387.1764705882351},":",{"$f":"E53","v":22500},"kWh            =",{"$f":"F75/H75","v":0.19498562091503266},null,"kWh"]
[]
[]
[null,"Hackschnitzelheizung"]
[]
[]
[]
[null,"Hackschnitzel jährlich",null,"in m³",40,{"$nulls":6},"Mischholz"]
[null,"Energiebedarf jährlich ",null,"in kWh",{"$f":"E82*800","v":32000},null,"Energieinhalt Hackschnitzel, 800kWh/m³"]
[null," Energiebedarf bereinigt",null,"in kWh",{"$f":"0.9*E83","v":28800},null,"Gesamtwirkungsgrad Heizkessel mit eingerechnet"]
[null,"Kostenart",null,"Größe, ltr/ m³/ kW","Menge","Kosten","Faktor/ Einheit",null,"Laufjahre","jährliche Kosten",null,"Sonstiges"]
[null,"Heizkessel + Zubehör",null,"20 - 24 kW",1,28000,"€/Stk",null,17,{"$f":"(E86*F86)/I86","v":1647.0588235294117},null,"Heizwert mit Puffer"]
[null,"Hackschnitzellager",null,"15 m³",1,2500,"€/ Stk",null,17,{"$f":"(E87*F87)/I87","v":147.05882352941177},null,"Bau Bunker im Austausch"]
[null,"Raumkosten Heizraum",null,"m² ",8,1600,"€/m²",null,50,{"$f":"E88*F88/I88","v":256},null,"Baukosten/m² aktuell"]
[null,"Raumkosten Lager",null,"m² ",12,1600,"€/m²",null,50,{"$f":"E89*F89/I89","v":384},null,"Baukosten/m² aktuell"]
[null,"Kamin",null,"10 m Höhe",10,80,"€/ Stk",null,17,{"$f":"E90*F90/I90","v":47.058823529411768},null,"Sanierungskosten"]
[null,"Reparaturrücklagen",null,"1 jährliche",1,300,"€/a",null,1,{"$f":"F91","v":300}]
[null,"Wartung",null,"1 jährliche",1,150,"€/Stk",null,1,{"$f":"F92","v":150},null,"Instandhaltung"]
[null,"Kaminkehrer",null,"1 jährliche",1,120,"€/a",null,1,{"$f":"E93*F93","v":120},null,"Putzen/ Messen"]
[]
[null,"Feste Kosten",null,"jährlich",1,null,"€/a",null,1,{"$f":"SUM(J86:J94)","v":3051.1764705882351},null,"ohne Inflation"]
[null,"Variable Kosten"]
[null,"Hackschnitzeleinkauf",null,"jährlich",{"$f":"E82","v":40},25,"€/m³",null,1,{"$f":"E97*F97","v":1000},null,"Zukauf"]
[null,"Stromkosten",null,"jährlich",150,0.28000000000000003,"€/kWh",null,1,{"$f":"E98*F98","v":42.000000000000007},null,"Nur Kesseltechnik"]
[null,"Variable Kosten gesamt",null,"jährlich",{"$nulls":5},{"$f":"SUM(J97:J98)","v":1042},null,"ohne Inflation"]
[]
[]
[null,"Gesamtkosten",null,"Feste + Variable Kosten gesamt",{"$nulls":5},{"$f":"J99+J95","v":4093.1764705882351}]
[]
[null,"Umgelegt auf die kWh entspricht dies Kosten von ",null,null,null,{"$f":"J102","v":4093.1764705882351},":",{"$f":"E84","v":28800},"kWh            =",{"$f":"F104/H104","v":0.14212418300653595},null,"kWh"]
[]
[null,"Umgelegt auf die kWh ohne Raumkosten",null,null,null,{"$f":"F104-J88-J89","v":3453.1764705882351},":",{"$f":"E84","v":28800},"kWh            =",{"$f":"F106/H106","v":0.11990196078431371},null,"kWh"]
[]
[]
[]
[null,"Scheitholzkessel"]
[]
[]
[]
[null,"Scheitholz jährlich",null,"in Ster",20,{"$nulls":6},"Mischholz"]
[null,"Energiebedarf jährlich ",null,"in kWh",{"$f":"E114*1800","v":36000},null,"Energieinhalt Ster Mischholz, 1800kWh/Ster"]
[null," Energiebedarf bereinigt",null,"in kWh",{"$f":"0.75*E115","v":27000},null,"Gesamtwirkungsgrad Heizkessel mit eingerechnet"]
[null,"Kostenart",null,"Größe, ltr/ m³/ kW","Menge","Kosten","Faktor/ Einheit",null,"Laufjahre","jährliche Kosten",null,"Sonstiges"]
[null,"Heizkessel + Zubehör",null,"20 - 24 kW",1,29000,"€/Stk",null,17,{"$f":"(E118*F118)/I118","v":1705.8823529411766},null,"Heizwert mit Puffer"]
[null,"Lagerraum Holz",null,"20 m³",1,0,"€/ Stk",null,17,{"$f":"(E119*F119)/I119","v":0},null,"keine Baukosten "]
[null,"Raumkosten Heizraum",null,"m² ",10,1600,"€/m²",null,50,{"$f":"E120*F120/I120","v":320},null,"Baukosten/m² aktuell"]
[null,"Raumkosten Lager",null,"m² ",12,1600,"€/m²",null,50,{"$f":"E121*F121/I121","v":384},null,"Baukosten/m² aktuell"]
[null,"Kamin",null,"10 m Höhe",10,80,"€/ Stk",null,17,{"$f":"E122*F122/I122","v":47.058823529411768},null,"Sanierungskosten"]
[null,"Reparaturrücklagen",null,"1 jährliche",1,150,"€/a",null,1,{"$f":"F123","v":150}]
[null,"Wartung",null,"1 jährliche",1,60,"€/Stk",null,1,{"$f":"F124","v":60},null,"Instandhaltung"]
[null,"Kaminkehrer",null,"1 jährliche",1,120,"€/a",null,1,{"$f":"E125*F125","v":120},null,"Putzen/ Messen"]
[]
[null,"Feste Kosten",null,"jährlich",1,null,"€/a",null,1,{"$f":"SUM(J118:J126)","v":2786.9411764705883},null,"ohne Inflation"]
[null,"Variable Kosten"]
[null,"Holzeinkauf",null,"jährlich",{"$f":"E114","v":20},55,"€/m³",null,1,{"$f":"E129*F129","v":1100},null,"Zukauf 1/2 Meter Scheit"]
[null,"Stromkosten",null,"jährlich",160,0.28000000000000003,"€/kWh",null,1,{"$f":"E130*F130","v":44.800000000000004},null,"Nur Kesseltechnik"]
[null,"Variable Kosten gesamt",null,"jährlich",{"$nulls":5},{"$f":"SUM(J129:J130)","v":1144.8},null,"ohne Inflation"]
[]
[]
[null,"Gesamtkosten",null,"Feste + Variable Kosten gesamt",{"$nulls":5},{"$f":"J131+J127","v":3931.7411764705885}]
[]
[null,"Umgelegt auf die kWh entspricht dies Kosten von ",null,null,null,{"$f":"J134","v":3931.7411764705885},":",{"$f":"E116","v":27000},"kWh            =",{"$f":"F136/H136","v":0.14562004357298475},null,"kWh"]
[]
[null,"Umgelegt auf die kWh ohne Raumkosten",null,null,null,{"$f":"F136-J120-J121","v":3227.7411764705885},":",{"$f":"E116","v":27000},"kWh            =",{"$f":"F138/H138","v":0.11954596949891068},null,"kWh"]
[]
[]
[null,"Wärmepumpenanlage"]
[]
[]
[]
[null,"Strombezug  WP jährlich ",null,"in kWh",7000,null,"Energieinhalt Strom, 1 kWh = 1 kWh"]
[null," Energiebedarf bereinigt",null,"in kWh",24000,null,"Heizenergiebedarf des Gebäudes in kWh"]
[null,"Kostenart",null,"Größe, ltr/ m³/ kW","Menge","Kosten","Faktor/ Einheit",null,"Laufjahre","jährliche Kosten",null,"Sonstiges"]
[null,"Luftwärmepumpe",null,"7 kW / COP2,5",1,17000,"€/Stk",null,12,{"$f":"F148*E148/I148","v":1416.6666666666667}]
[null,"Solewärmepumpe",null,"4 kW/ COP 4",0,14000,"€/Stk",null,12,{"$f":"F149*E149/I149","v":0}]
[null,"Tiefenbohrung",null,"m",0,400,"€/ m",null,17,{"$f":"(E150*F150)/I150","v":0},null,"Bau Bunker im Austausch"]
[null,"Erdkorb",null,"Stk",null,6000,"€/Stk",null,17,{"$f":"E151*F151/I151","v":0},null,"inkl Baggerarbeiten"]
[null,"Erdtauscher",null,"m²",null,30,"€/m²",null,17,{"$f":"E152*F152/I152","v":0},null,"inlk Baggerarbeiten"]
[null,"Fundament Aussenteil",null,"Stk",1,600,"€/Stk",null,17,{"$f":"E153*F153/I153","v":35.294117647058826},null,"am Haus"]
[null,"Raumkosten Heizraum",null,"m² ",8,1600,"€/m²",null,50,{"$f":"E154*F154/I154","v":256},null,"Baukosten/m² aktuell"]
[null,"Reparaturrücklagen",null,"1 jährliche",1,250,"€/a",null,1,{"$f":"F155","v":250}]
[null,"Wartung",null,"1 jährliche",1,120,"€/Stk",null,1,{"$f":"F156","v":120},null,"Instandhaltung"]
[]
[null,"Feste Kosten",null,"jährlich",1,null,"€/a",null,1,{"$f":"SUM(J148:J157)","v":2077.9607843137255},null,"ohne Inflation"]
[null,"Variable Kosten"]
[null,"Stromkosten",null,"jährlich",{"$f":"E145","v":7000},0.28000000000000003,"€/kWh",null,1,{"$f":"E160*F160","v":1960.0000000000002},null,"Antriebsenergie WP"]
[null,"Variable Kosten gesamt",null,"jährlich",{"$nulls":5},{"$f":"SUM(J160:J160)","v":1960.0000000000002},null,"ohne Inflation"]
[]
[]
[null,"Gesamtkosten",null,"Feste + Variable Kosten gesamt",{"$nulls":5},{"$f":"J161+J158","v":4037.9607843137255}]
[]
[null,"Umgelegt auf die kWh entspricht dies Kosten von ",null,null,null,{"$f":"J164","v":4037.9607843137255},":",{"$f":"E146","v":24000},"kWh            =",{"$f":"F166/H166","v":0.16824836601307189},null,"kWh"]
[]
[null,"Umgelegt auf die kWh ohne Raumkosten",null,null,null,{"$f":"F166-J154","v":3781.9607843137255},":",{"$f":"E146","v":24000},"kWh            =",{"$f":"F168/H168","v":0.15758169934640523},null,"kWh"]
[]
[]
[null,"Fernwärmeversorgung"]
[]
[]
[null,"Sämtliche Kosten der Fernwärme sind bis einschließlich der hydraulischen Anpassung im kWh Preis enthalten, Erstellung des Rohrleitunganschlusses sowie humusieren der Pflanzflächen, Verschließen der Pflaster- bzw. Asphaltflächen, Demontage und Entsorgung der alten Heizungsanlage, Einbau und Einregulierung der Übergabestation, Isolieren der neu erstellten Leitungen. Erstellung des Glasfaseranschlusses für Fernüberwachung, Wartung- und Instanhaltungskosten. Für den Anschließer bleibt nur die Ansaat des Rasens, sowie die Wiederherstellung der Pflanzflächen sowie die Demontage des bestehenden Brennstofflagers."]
[]
[]
[]
[]
[null,"Energiebedarf ",null,"in kWh",23000,null,"Fernwärme wird  verlustfrei übergeben"]
[null," Energiebedarf bereinigt",null,"in kWh",{"$f":"E179","v":23000},null,"Heizenergiebedarf des Gebäudes in kWh"]
[null,"Kostenart",null,"Größe, ltr/ m³/ kW","Menge","Kosten","Faktor/ Einheit",null,"Laufjahre","jährliche Kosten",null,"Sonstiges"]
[null,"Übergabepuffer/ station",null,"25 kW",1,0,"€/Stk",null,10,{"$f":"F182*E182/I182","v":0},null,"enthalten"]
[null,"Umbau der bestehenden",null,null,1,0,"€/Stk",null,10,{"$f":"F183*E183/I183","v":0},null,"enthalten"]
[null,"Heizung bis Oberkante",null,null,1,0,"€/Stk",null,10,{"$f":"(E184*F184)/I184","v":0},null,"enthalten"]
[null,"Absperrungen",null,null,1,0,"€/Stk",null,10,{"$f":"E185*F185/I185","v":0},null,"enthalten"]
[null,"Rohrleitungsanpassung",null,null,1,0,"€/Stk",null,10,{"$f":"E186*F186/I186","v":0},null,"enthalten"]
[null,"Verlegung Fernwärme",null,null,1,0,"€/Stk",null,10,0,null,"enthalten"]
[null,"Raumkosten Heizraum",null,"m² ",2.5,1600,"€/Stk",null,50,{"$f":"E188*F188/I188","v":80},null,"enthalten"]
[null,"Reparaturrücklagen",null,null,1,0,"€/Stk",null,10,0,null,"enthalten"]
[null,"Wartung",null,null,1,0,"€/Stk",null,10,0,null,"enthalten"]
[]
[null,"Feste Kosten",null,"jährlich",1,0,"€/a",null,10,{"$f":"SUM(J182:J191)","v":80},null,"ohne Inflation"]
[null,"Variable Kosten"]
[null,"Fernwärmekosten",null,"jährlich",{"$f":"E180","v":23000},0.14499999999999999,"€/kWh",null,1,{"$f":"E194*F194","v":3334.9999999999995},null,"Einkauf Wärme"]
[null,"Stromkosten",null,"jährlich",60,0.28000000000000003,"€/kWh",null,1,{"$f":"E195*F195","v":16.8},null,"Nur Kesseltechnik"]
[null,"Variable Kosten gesamt",null,"jährlich",{"$nulls":5},{"$f":"SUM(J194:J195)","v":3351.7999999999997},null,"ohne Inflation"]
[]
[]
[null,"Gesamtkosten",null,"Feste + Variable Kosten gesamt",{"$nulls":5},{"$f":"J192+J194+J195","v":3431.7999999999997}]
[]
[null,"Umgelegt auf die kWh entspricht dies Kosten von ",null,null,null,{"$f":"J199","v":3431.7999999999997},":",{"$f":"E180","v":23000},"kWh            =",{"$f":"F201/H201","v":0.1492086956521739},null,"kWh"]
[]
[null,"Umgelegt auf die kWh ohne Raumkosten",null,null,null,{"$f":"F201-J188","v":3351.7999999999997},":",{"$f":"E180","v":23000},"kWh            =",{"$f":"F203/H203","v":0.14573043478260869},null,"kWh"]