{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Transmission","Lüftung_Gewinne","Warmwasser","Lüftungsanlage","Heizung","Primärenergie","Ergebnis","Info","Hilfe","rech","ref"],"not_rendered":{"charts":1,"images":27,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Transmission","index":0,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[[20,10,21,10]]}
["Transmissionswärmeverlust"]
[]
["Gebäudevolumen",501.91,"m³",null,"Gebäudenutzfläche",null,{"$f":"B3*0.32","v":160.61120000000003},"m²"]
[]
["Gebäudetyp"]
[]
[]
[null,"Fläche",null,"U-Wert",null,"Gewichtung","Verluste"]
["Aussenwand",158.87,"m²",0.21,"W/(m²∙K)",1,{"$f":"rech!I5","v":3623.1815942399994},"kWh",null,null,null,null,null,null,null,null,null,{"$f":"B9*D9*F9","v":33.362699999999997}]
["Haustür",3.8,"m²",1.3,"W/(m²∙K)",1,{"$f":"rech!I6","v":449.97897599999999},"kWh",null,null,null,null,null,null,null,null,null,{"$f":"B10*D10*F10","v":4.9399999999999995}]
["Kellerdecke/Sohle",87.24,"m²",0.23,"W/(m²∙K)",0.6,{"$f":"rech!I7","v":1174.6240663680001},"kWh",null,null,"Bestimmung Höchstwerte",null,null,null,null,null,null,12.03912]
["Dach",50,"m²",0.17,"W/(m²∙K)",1,{"$f":"rech!I8","v":964.86720000000003},"kWh",null,null,"für H'T und H'T,ref",null,null,null,null,null,null,8.5]
["OG-Decke",63.91,"m²",0.17,"W/(m²∙K)",0.8,{"$f":"rech!I9","v":1042.6933883519998},"kWh",null,null,null,null,null,null,null,null,null,8.6917600000000004]
["Bodenluke",0.72,"m²",0.7,"W/(m²∙K)",0.8,{"$f":"rech!I10","v":38.524515839999992},"kWh",null,null,null,null,null,null,null,null,null,0.4032]
["Fenster nord",5.47,"m²",1.3,"W/(m²∙K)",1,{"$f":"rech!I11","v":647.73289439999996},"kWh",null,null,"∙",null,null,null,null,null,null,7.1109999999999998]
["Fenster ost",4.88,"m²",1.3,"W/(m²∙K)",1,{"$f":"rech!I12","v":577.86773760000005},"kWh",null,null,null,null,null,null,null,null,null,6.3440000000000003]
["Fenster west",7.44,"m²",1.3,"W/(m²∙K)",1,{"$f":"rech!I13","v":881.01146880000022},"kWh",null,null,"∙",null,null,null,null,null,null,9.6720000000000006]
["Fenster süd",12.88,"m²",1.3,"W/(m²∙K)",1,{"$f":"rech!I14","v":1525.1918976000006},"kWh",null,null,null,null,null,null,null,null,null,16.744000000000003]
[]
["Hüllfläche gesamt",{"$f":"SUM(B9:B18)","v":395.21000000000009},"m²"]
[null,null,null,null,null,null,null,null,null,null,"H'T,ref zulässig EnEV 2016"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ref!H18","v":0.36698514713696512}]
["Wärmebrücken",null,null,null,null,null,{"$f":"rech!I18","v":1733.2962096000001},"kWh",null,null,"H'T zulässig EnEV 2009 - 2016",null,null,null,null,null,null,{"$f":"IF(F42=0,0.05*B20,IF(F42=1,0.1*B20))","v":19.760500000000008}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L42=0,M42,IF(L42=1,M43,IF(L42=2,M44,IF(L42=3,M45,IF(L42=4,M46)))))","v":0.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R9:R18)+R24","v":127.56828}]
["Transmissionswärmeverlust",null,null,null,null,null,{"$f":"SUM(G9:G18)","v":10925.6737392},"kWh",null,null,"Vorhandener spezifischer"]
[null,null,null,null,null,null,null,null,null,null,"    Transmissionswärmeverlust"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"R26/B20","v":0.32278606310569058}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2009/2013"]
["mit Berücksichtigung DIN 4108 Bbl. 2 (0,05)",null,null,null,null,0,null,null,null,null,"freistehend AN ≤ 350m²",0,0.4]
["ohne Berücksichtigung DIN 4108 Bbl. 2 (0,10)",null,null,null,null,null,null,null,null,null,"freistehend AN > 350m²",null,0.5]
[null,null,null,null,null,null,null,null,null,null,"einseitig angebaut",null,0.45]
["Solargewinne durch opake Bauteile",null,null,null,null,false,null,null,null,null,"zweiseitig angebaut ≤350 m²",null,0.65]
[null,null,null,null,null,null,null,null,null,null,"alle anderen",null,0.65]
[]
[]
[]
["EZFH bis 3 Vollgeschosse",null,null,null,null,0]
["sonstige Gebäude"]

{"sheet":"Lüftung_Gewinne","index":1,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Lüftungswärmeverlust"]
[]
["Art des Dichtheitsnachweises"]
[]
[]
["Lüftungswärmeverlust Heizperiode",null,null,null,null,null,null,{"$f":"rech!I27","v":7963.2666054681604},"kWh"]
[]
[]
["Solare und interne Gewinne"]
[null,null,null,null,null,null,null,null,null,null,"Transmissionswärmeverluste"]
["wirks. Wärmespeicherfähigkeit",null,null,"g-Wert",null,"Fläche",null,null,null,null,{"$f":"Transmission!G27","v":10925.6737392}]
[null,null,"nord   ",{"$f":"A33/100","v":0.57999999999999996},null,{"$f":"Transmission!B15","v":5.47},"m²",{"$f":"rech!I41","v":782.11737233279973},"kWh",null,"+"]
[null,null,"ost   ",{"$f":"A34/100","v":0.57999999999999996},null,{"$f":"Transmission!B16","v":4.88},"m²",{"$f":"rech!I42","v":1145.9305073663995},"kWh",null,"Lüftungswärmeverluste"]
["  m. NA = mit Nachtabsenkung",null,"west   ",{"$f":"A35/100","v":0.57999999999999996},null,{"$f":"Transmission!B17","v":7.44},"m²",{"$f":"rech!I44","v":1747.0743800831997},"kWh",null,{"$f":"H6","v":7963.2666054681604}]
["  o. NA = ohne Nachtabsenkung",null,"süd   ",{"$f":"A36/100","v":0.57999999999999996},null,{"$f":"Transmission!B18","v":12.88},"m²",{"$f":"rech!I43","v":3444.5526732288004},"kWh",null,"-"]
[null,null,null,null,null,null,null,null,null,null,"nutzbare Solargewinne"]
["Nutzbare Solargewinne",null,null,null,null,null,null,{"$f":"rech!I67","v":3848.6912775127794},"kWh",null,{"$f":"H17","v":3848.6912775127794}]
[null,null,null,null,null,null,null,null,null,null,"-"]
["Nutzbare interne Gewinne",null,null,null,null,null,null,{"$f":"rech!I68","v":4790.3355022423975},"kWh",null,"nutzbare Interne Gewinne"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H19","v":4790.3355022423975}]
["Solare und interne Gewinne",null,null,null,null,null,null,{"$f":"H17+H19","v":8639.0267797551769},"kWh",null,"="]
[null,null,null,null,null,null,null,null,null,null,"Jahres-Heizwärmebedarf"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H24","v":8876.4361864325638}]
["Jahres-Heizwärmebedarf",null,null,null,null,null,null,{"$f":"rech!I71","v":8876.4361864325638},"kWh"]
[]
["Spez. Jahres-Heizwärmebedarf",null,null,null,null,null,null,{"$f":"H24/Transmission!G3","v":55.266607723698982},"kWh/m²"]
[]
[]
[]
[]
[]
[]
[58]
[58]
[58]
[58]
[]
[]
[]
["ohne Luftdichtheitstest (n=0,7)",null,null,null,null,0]
["mit Luftdichtheitstest (n=0,6)"]
["mit Test + Abluftanlage (n=0,55)"]
[]
["Leichte Bauweise o. NA",null,null,null,null,3]
["Schwere Bauweise o. NA"]
["Leichte Bauweise m. NA"]
["Schwere Bauweise m. NA"]

{"sheet":"Warmwasser","index":2,"n_rows":410,"n_cols":73,"rows_kept":410,"cut":false,"hidden":false,"merged":[[63,9,63,11],[60,17,60,18],[61,17,61,18],[62,7,62,8],[62,17,62,18],[60,5,60,6],[61,5,61,6],[62,5,62,6],[3,10,4,12],[63,17,63,18],[59,12,59,14],[60,12,60,14],[61,12,61,14],[62,12,62,14],[63,12,63,14],[57,15,57,18],[58,17,58,18],[59,17,59,18],[48,15,48,18],[49,17,49,18],[50,17,50,18],[51,17,51,18],[52,17,52,18],[53,17,53,18],[51,9,51,11],[52,9,52,11],[62,3,62,4],[58,12,58,14],[59,7,59,8],[60,7,60,8],[61,7,61,8],[54,17,54,18],[62,9,62,11],[53,9,53,11],[54,9,54,11],[54,7,54,8],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[57,2,57,6],[57,7,57,14],[58,7,58,8],[58,9,58,11],[59,9,59,11],[60,9,60,11],[61,9,61,11],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[63,5,63,6],[48,7,48,14],[48,2,48,6],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[49,3,49,4],[50,3,50,4],[53,7,53,8],[49,12,49,14],[50,12,50,14],[51,12,51,14],[52,12,52,14],[53,12,53,14],[54,12,54,14],[49,9,49,11],[50,9,50,11],[63,7,63,8],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[63,3,63,4],[58,5,58,6],[59,5,59,6],[66,9,66,11],[67,9,67,11],[68,9,68,11],[69,9,69,11],[70,9,70,11],[71,9,71,11],[72,5,72,6],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[70,7,70,8],[71,7,71,8],[72,7,72,8],[66,5,66,6],[67,5,67,6],[68,5,68,6],[69,5,69,6],[70,5,70,6],[71,5,71,6],[67,18,67,19],[68,18,68,19],[69,18,69,19],[70,18,70,19],[71,18,71,19],[72,18,72,19],[72,9,72,11],[67,12,67,14],[68,12,68,14],[69,12,69,14],[70,12,70,14],[71,12,71,14],[72,12,72,14]]}
["Ermittlung der Anlagenaufwand nach DIN V 4701-10"]
[]
["Trinkwassererwärmung",null,null,"Verteilung im unbeheizten Bereich"]
[null,null,null,null,null,null,null,null,null,null,"gemeinsame Installationswand"]
["Trinkwasserwärmebedarf",null,null,null,"12,5 ∙ AN",null,{"$f":"Transmission!G3*12.5","v":2007.6400000000003},"kWh/a"]
[]
[]
["Aufwand",null,null,null,"Brennstoff",null,null,null,null,null,null,"Hilfsenergie"]
[null,null,null,null,"spezifisch",null,"absolut",null,"Gewinn"]
["Übergabe",null,null,null,0,"kWh/m²",{"$f":"E10*Transmission!G3+G5","v":2007.6400000000003},"kWh",null,null,null,0,"kWh/m²"]
[]
["Verteilung",null,null,null,11.281663999999999,"kWh/m²",{"$f":"E12*Transmission!G3+G10","v":3819.6015930368003},"kWh",1.7,"kWh/m²",null,0.78604415999999988,"kWh/m²"]
[]
["Speicherung",null,null,null,4.587775999999999,"kWh/m²",4556.4498017280002,"kWh",null,null,null,7.7877760000000004E-2,"kWh/m²"]
[]
["Erzeugung",null,null,null,1.1878777599999999,"  -",5412.5053840291002,"kWh",null,null,null,0.23363327999999997,"kWh/m²"]
[]
[]
["Endenergiebedarf Trinkwassererwärmung"]
[]
[null,"Brennstoff",null,null,null,null,{"$f":"G16","v":5412.5053840291002},"kWh/a"]
[]
[null,"Hilfsenergie",null,null,null,null,{"$f":"(L10+L12+L14+L16)*Transmission!G3","v":176.27965773824002},"kWh/a"]
[]
["Wärmerückgewinn für Heizung",null,null,null,null,null,{"$f":"I12*Transmission!G3","v":273.03904000000006},"kWh/a"]
[]
[]
[]
[]
["zentral, ohne Zirkulation",null,null,1]
["zentral, mit Zirkulation"]
["wohnungszentral"]
[]
["Indirekt beheizter Speicher",null,null,0]
["Solarspeicher"]
["gasbefeuerter Speicher"]
["ohne Speicher"]
[]
["Standardkessel",null,null,1]
["NT-Kessel"]
["Brennwertkessel"]
["Gasbefeuerter Speicher"]
["elektr. Durchlauferhitzer"]
["Nah-/Fernwärme"]
["Heizungs-WP (Luft)"]
["Heizungs-WP (Erde)"]
[]
["Verteilung - immer außerhalb der thermischen Hülle"]
[null,null,"mit Zirkulation",null,null,null,null,"ohne Zirkulation",null,null,null,null,null,null,null,"wohnungszentrale WW-Versorgung"]
[null,"AN","Verlust","Gewinn",null,"Hilfsenergie",null,"Verlust",null,"Gewinn",null,null,"Hilfsenergie",null,null,"Verlust","Gewinn","Hilfsenergie"]
[null,100,14.6,1.7,null,1.1399999999999999,null,6.7,null,1,null,null,0,null,null,1.51,0.68,0]
[null,150,11.6,1.7,null,0.82,null,5.4,null,1,null,null,0,null,null,1.51,0.68,0]
[null,200,10.1,1.8,null,0.66,null,4.7,null,1,null,null,0,null,null,1.51,0.68,0]
[null,300,8.6999999999999993,1.8,null,0.49,null,4,null,1,null,null,0,null,null,1.51,0.68,0]
[null,500,7.6,1.9,null,0.34,null,3.4,null,1,null,null,0,null,null,1.51,0.68,0]
[]
["Speicher - immer außerhalb der thermischen Hülle"]
[null,null,"indirekt beheizter Speicher",null,null,null,null,"Solarspeicher",null,null,null,null,null,null,null,"gasbefeuerter Speicher"]
[null,"AN","Verlust","Gewinn",null,"Hilfsenergie",null,"Verlust",null,"Deckung mit Zirkulation",null,null,"Deckung ohne Zirkulation",null,null,"Verlust","Gewinn","Hilfsenergie"]
[null,100,6.5,0,null,0.11,null,4.3,null,0.51,null,null,0.63,null,null,21.3,0,0]
[null,150,4.8,0,null,0.08,null,3.1,null,0.51,null,null,0.61,null,null,18,0,0]
[null,200,3.8,0,null,7.0000000000000007E-2,null,2.4,null,0.5,null,null,0.59,null,null,16.100000000000001,0,0]
[null,300,2.8,0,null,0.05,null,1.7,null,0.49,null,null,0.56999999999999995,null,null,14,0,0]
[null,500,1.9,0,null,0.04,null,1.9,null,0.53,null,null,0.56999999999999995,null,null,11.9,0,0]
[]
["Erzeugung - immer außerhalb der thermischen Hülle"]
[null,null,"Standardkessel",null,null,"NT-Kessel",null,null,null,"BW-Kessel",null,null,null,null,null,"gasbefeuerter Speicher",null,"el. DLE",null,null,"Nah-/Fernwärme",null,"Heizungs-WP (Luft)",null,"Heizungs-WP (Erde)"]
[null,"AN","Aufwandszahl","Hilfsen.",null,"Aufwandszahl",null,"Hilfsen.",null,"Aufwandszahl",null,null,"Hilfsen.",null,null,"Aufwandszahl","Hilfsenergie","Aufwand","Hilfsenergie",null,"Aufwand","Hilfsenergie","Aufwand","Hilfsenergie","Aufwand","Hilfsenergie"]
[null,100,1.82,0.3,null,1.21,null,0.3,null,1.17,null,null,0.3,null,null,1.22,0,1,0,null,1.1399999999999999,0.4,0.3,0,0.27,{"$f":"0.5*Transmission!$G$3^-0.1","v":0.30087937733066872}]
[null,150,1.71,0.24,null,1.19,null,0.24,null,1.1499999999999999,null,null,0.24,null,null,1.22,0,1,0,null,1.1399999999999999,0.4,0.3,0,0.27,{"$f":"0.5*Transmission!$G$3^-0.1","v":0.30087937733066872}]
[null,200,1.64,0.21,null,1.18,null,0.21,null,1.1399999999999999,null,null,0.21,null,null,1.22,0,1,0,null,1.1399999999999999,0.4,0.3,0,0.27,{"$f":"0.5*Transmission!$G$3^-0.1","v":0.30087937733066872}]
[null,300,1.56,0.17,null,1.17,null,0.17,null,1.1299999999999999,null,null,0.17,null,null,1.22,0,1,0,null,1.1399999999999999,0.4,0.3,0,0.27,{"$f":"0.5*Transmission!$G$3^-0.1","v":0.30087937733066872}]
[null,500,1.46,0.13,null,1.1499999999999999,null,0.13,null,1.1200000000000001,null,null,0.13,null,null,1.22,0,1,0,null,1.1399999999999999,0.4,0.3,0,0.27,{"$f":"0.5*Transmission!$G$3^-0.1","v":0.30087937733066872}]
[]
[]
["gemeinsame Installationswand",null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,null,null,null,null,null,null,273.03904000000006,null,0.78604415999999988]

{"sheet":"Lüftungsanlage","index":3,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Ermittlung der Aufwandszahl nach DIN V 4701-10"]
[]
["Lüftungsanlage",null,null,null,"Anlage ohne Nachheizung"]
[null,null,null,null,"Verteilung im unbeheizten Dach"]
[null,null,null,null,"Anlagenluftwechsel 0,4"]
[]
[]
["Aufwand",null,null,null,"Brennstoff",null,null,null,null,null,null,"Hilfsenergie"]
[null,null,null,null,"spezifisch",null,"absolut",null,"Gewinn"]
["Übergabe",null,null,null,0,"kWh/m²",0,"kWh",null,null,null,0,"kWh/m²"]
[]
["Verteilung",null,null,null,0,"kWh/m²",{"$f":"E12*Transmission!G3+G10","v":0},"kWh",null,null,null,0,"kWh/m²"]
[]
["Erzeugung",null,null,null,{"$f":"IF(G39=0,E39,IF(G39=1,E40,IF(G39=2,E41,IF(G39=3,E42))))","v":0},"kWh/m²",{"$f":"E14*Transmission!G3+G12","v":0},"kWh",{"$f":"IF(G39=0,IF(Lüftung_Gewinne!F40=0,0,F39),IF(G39=1,IF(Lüftung_Gewinne!F40=0,0,F40),IF(G39=2,F41,IF(G39=3,F42))))","v":0},"kWh/m²",null,{"$f":"IF(G39=0,I39,IF(G39=1,I40,IF(G39=2,I41,IF(G39=3,I42))))","v":0},"kWh/m²"]
[]
[]
[]
[]
["Endenergiebedarf Lüftungsanlage"]
[]
[null,"Brennstoff",null,null,null,null,{"$f":"G14","v":0},"kWh/a"]
[]
[null,"Hilfsenergie",null,null,null,null,{"$f":"(L10+L12+L14)*Transmission!G3","v":0},"kWh/a"]
[]
["Wärmerückgewinn für Heizung",null,null,null,null,null,{"$f":"I14*Transmission!G3","v":0},"kWh/a"]
[]
[]
[]
[]
[]
[]
[]
[]
["dezentral ohne WRG",null,null,null,0,null,3]
["zentral mit WRG (η=0,6)",null,null,null,4.0999999999999996]
["zentral mit WRG (η=0,8)",null,null,null,0]
["keine Anlage",null,null,null,0]
[]
["zentral mit WRG (η=0,6)",null,null,null,0,13.5,3,null,1.7]
["zentral mit WRG (η=0,8)",null,null,null,0,17.2,null,null,2.6]
["dezentral ohne WRG",null,null,null,0,0,null,null,1.1000000000000001]
["keine Anlage",null,null,null,0,0,null,null,0]

{"sheet":"Heizung","index":4,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Ermittlung der Aufwandszahl nach DIN V 4701-10"]
[]
["Heizung",null,null,null,"horizontale Verteilung außerhalb der thermischen Hülle"]
[null,null,null,null,"Verteilungsstränge außenliegend und geregelte Pumpen"]
["Heizwärmebedarf",null,null,null,null,null,{"$f":"Lüftung_Gewinne!H24","v":8876.4361864325638},"kWh/a"]
[]
["abzgl. Gewinne (aus WW + Lüftung)",null,null,null,{"$f":"Warmwasser!G25+Lüftungsanlage!G25","v":273.03904000000006},"kWh/a",{"$f":"G5-E7","v":8603.3971464325641},"kWh/a"]
[]
[]
["Aufwand",null,null,null,"Brennstoff",null,null,null,null,null,null,"Hilfsenergie"]
[null,null,null,null,"spezifisch",null,"absolut"]
["Übergabe",null,null,null,3.3,"kWh/m²",{"$f":"E12*Transmission!G3+G7","v":9133.4141064325649},"kWh",null,null,null,0,"kWh/m²"]
[]
["Verteilung",null,null,null,6.2665535999999999,"kWh/m²",{"$f":"E14*Transmission!G3+G12","v":10139.892799992886},"kWh",null,null,null,1.2884550399999999,"kWh/m²"]
[]
["Erzeugung",null,null,null,1.1278777599999998,"  -",{"$f":"E16*G14","v":11436.559577896101},"kWh",null,null,null,0.64302207999999994,"kWh/m²"]
[]
[]
["Endenergiebedarf Heizung"]
[]
[null,"Brennstoff",null,null,null,null,{"$f":"G16","v":11436.559577896101},"kWh/a"]
[]
[null,"Hilfsenergie",null,null,null,null,{"$f":"(L12+L14+L16)*Transmission!G3","v":310.21685801574404},"kWh/a"]
[]
[]
[]
[]
[]
[]
["Heizkörper 2K-Ventile",null,null,null,null,null,0]
["Heizkörper 1K-Ventile"]
["Fußbodenheizung 0,5K"]
["dez. Einzelfeuerstätte"]
["Heizkörper (55/45)",null,null,null,null,null,0]
["Fußbodenheizung (35/28)"]
["dezentral (raumweise)"]
[]
["Standardkessel",null,null,null,null,null,1]
["NT-Kessel (55/45)"]
["Brennwertkessel (55/45)"]
["Brennwertkessel (35/28)"]
["Speicherheizung"]
["Nah-/Fernwärme"]
["Wärmepumpe(Luft 35/28)"]
["Wärmep.(Erdreich 35/28)"]

{"sheet":"Primärenergie","index":5,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[39,8,39,9],[40,8,40,9],[41,8,41,9]]}
["Primärenergiebedarf"]
[]
[]
["Primärenergiebedarf Wärme"]
[null,"Endenergiebedarf",null,null,"Primärenergie-Faktor",null,"PE-Bedarf"]
["Heizung",{"$f":"Heizung!G21","v":11436.559577896101},"kWh",null,null,null,12580.215535685713,"kWh"]
["Warmwasser",{"$f":"Warmwasser!G21","v":5412.5053840291002},"kWh",null,null,null,5953.7559224320112,"kWh"]
["Lüftungsanlage",{"$f":"Lüftungsanlage!G21","v":0},"kWh",null,null,null,0,"kWh"]
[]
["Primärenergiebedarf Hilfsenergie"]
[null,"Endenergiebedarf",null,null,"Primärenergie-Faktor",null,"PE-Bedarf"]
["Heizung",{"$f":"Heizung!G23","v":310.21685801574404},"kWh",null,null,null,806.56383084093454,"kWh"]
["Warmwasser",{"$f":"Warmwasser!G23","v":176.27965773824002},"kWh",null,null,null,458.32711011942405,"kWh"]
["Lüftungsanlage",{"$f":"Lüftungsanlage!G23","v":0},"kWh",null,null,null,0,"kWh"]
[]
["Primärenergiebedarf gesamt"]
[null,null,null,null,null,null,"PE-Bedarf"]
["Heizung",null,null,null,null,null,{"$f":"G6+G12","v":13386.779366526647},"kWh",null,null,"∙"]
["Warmwasser",null,null,null,null,null,{"$f":"G7+G13","v":6412.0830325514353},"kWh",null,null,"Zulässiger spezifischer"]
["Lüftungsanlage",null,null,null,null,null,{"$f":"G8+G14","v":0},"kWh",null,null,"    Primärenergiebedarf"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ref!O115","v":59.428208548580258}]
[]
["Jahres-Primärenergiebedarf",null,null,null,null,null,{"$f":"G18+G19+G20","v":19798.862399078083},"kWh",null,null,"Vorhandener Spezifischer"]
[null,null,null,null,null,null,null,null,null,null,"    Primärenergiebedarf"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G23/Transmission!G3","v":123.27199098866132}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
["Heizöl (1,1)",null,null,1,null,null,null,null,2009,null,false]
["Erdgas H (1,1)",null,null,1,null,null,null,null,2013,null,false]
["Flüssiggas (1,1)",null,null,0,null,null,null,null,2016,null,true]
["Steinkohle (1,1)",null,null,0]
["Braunkohle (1,2)",null,null,0]
["Holz (0,2)",null,null,0]
["Nah-/Fernwärme KWK fossil (0,7)"]
["Nah-/Fernwärme KWK reg. (0,0)"]
["Nah-/Fernwärme fossil (1,3)"]
["Nah-/Fernwärme reg. (0,1)"]
["Strom 2009 (2,6)"]
["Strom 2013 (2,4)"]
["Strom 2016 (1,8)"]

{"sheet":"Ergebnis","index":6,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Ergebnis nach EnEV 2009/2013/2016"]
[]
[]
[]
[null,null,null,null,null,"Spez. Transmissionsverlust H'T"]
[]
[null,null,null,null,null,"zulässig",{"$f":"Transmission!K25","v":0.4},"W/(m²∙K)"]
[null,null,null,null,null,"erreicht",{"$f":"Transmission!K29","v":0.32278606310569058},"W/(m²∙K)"]
[]
[]
[null,null,null,null,null,"Spez. Transmissionsverlust H'T,ref"]
[]
[null,null,null,null,null,"zulässig",{"$f":"Transmission!K23","v":0.36698514713696512},"W/(m²∙K)"]
[null,null,null,null,null,"erreicht",{"$f":"Transmission!K29","v":0.32278606310569058},"W/(m²∙K)"]
[]
[]
[null,null,null,null,null,"Jahres-Primärenergiebedarf"]
[]
[null,null,null,null,null,"zulässig",{"$f":"Primärenergie!K21","v":59.428208548580258},"kWh/m²∙a"]
[null,null,null,null,null,"erreicht",{"$f":"Primärenergie!K25","v":123.27199098866132},"kWh/m²∙a"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Transmission","Aussenwand",{"$f":"rech!I5","v":3623.1815942399994},0]
[null,"Haustür",{"$f":"rech!I6","v":449.97897599999999},0]
[null,"Bodenplatte",{"$f":"rech!I7","v":1174.6240663680001},0]
[null,"Dach",{"$f":"rech!I8","v":964.86720000000003},0]
[null,"OG-Decke",{"$f":"rech!I9","v":1042.6933883519998},0]
[null,"Bodenluke",{"$f":"rech!I10","v":38.524515839999992},0]
[null,"Fenster",{"$f":"rech!J14","v":3631.8039984000011},0]
[null,"Wärmebrücken",{"$f":"rech!I18","v":1733.2962096000001},0]
["Lüftung","Lüftung",{"$f":"rech!I27","v":7963.2666054681604},0]
["Anlagen","Anlagenaufwand",{"$f":"D47-SUM(C33:C41)","v":7815.6526245651003},0]
[null,"Solar",0,{"$f":"Lüftung_Gewinne!H17","v":3848.6912775127794}]
[null,"Intern",0,{"$f":"Lüftung_Gewinne!H19","v":4790.3355022423975}]
[null,"Brennstoff",0,{"$f":"Primärenergie!G23","v":19798.862399078083}]
[]
[null,null,{"$f":"SUM(C33:C45)","v":28437.889178833262},{"$f":"SUM(D33:D45)","v":28437.889178833262}]

{"sheet":"Info","index":7,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"EXCEL-Arbeitsmappe zur Energieeinsparverordnung 2013/2016"]
[null,"(nach dem Stand der Energieeinsparverordnung vom 18.11.2013 - Bundesgesetzblatt)"]
[]
[]
[]
[]
[null,null,null,"Ingenieurbüro für Energieberatung"]
[null,null,null,"Ernst Merkschien"]
[null,null,null,"33604 Bielefeld"]
[null,null,null,"Tel.: 0521/5575275"]
[null,null,null,"Fax: 0521/5575279"]
[null,null,null,"Mail: info@merkschien.de"]
[null,null,null,"http://www.merkschien.de"]
[]
[]
[]
[]
[]
[null,"Diese EXCEL-Arbeitmappe wurde ursprünglich als Begleitmaterial für den REN-IMPULS-Kurs zur"]
[null,"Energieeinsparverordnung im Auftrag der Energieagentur NRW erstellt. Die Fortschreibung mit den"]
[null,"Berechnungen nach EnEV 2013 erfolgte durch das Ingenieurbüro für Energieberatung, Bielefeld."]
[]
[null,"Für die Richtigkeit der Berechnung und die Funktion der Arbeitsmappe wird keine Haftung übenommen."]
[null,"Die Berechnung des Heizwärmebedarfs erfolgt nach dem Monatsbilanzverfahren der DIN V 4108-6."]
[null,"Die Berechnungen für den Bereich Versorgungstechnik basieren auf den Regelungen der DIN V 4701-10."]
[]
[null,"Copyright© 2000-2016 Ernst Merkschien, Stand: 26.01.2016"]

{"sheet":"Hilfe","index":8,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EXCEL-Berechnungstool Nachweis Neubau (EnEV.XLS)"]
[null,"Kurzbeschreibung zur Arbeitsmappe"]
[]
[null,"Bei der Arbeitsmappe EnEV.XLS handelt es sich um ein didaktisches Instrument, mit dessen Hilfe die Rechengänge der Energieeinsparverordnung im Rahmen eines Seminars den Teilnehmern vermittelt werden sollen. Es ist auch dazu geeignet, sich im Rahmen des Selbststudiums ein Gefühl für die Verordnung zu erarbeiten."]
[]
[null,"Die Arbeitsmappe wurde auf dem Betriebssystem Windows mit Excel ´97 erstellt und an die folgenden Excel-Versionen bis inkl. Version 2013 angepasst, so dass sie auf allen heute verwendeten Excel-Versionen lauffähig sein müsste. Mit dem Programm OpenOffice ist das Arbeitsblatt nicht zu betreiben."]
[]
[null,"Nach dem Start der Datei gibt Excel einen Hinweis darauf, dass die Arbeitsmappe Makros enthält. Hier muss die Schaltfläche „Makros aktivieren“ gedrückt werden, da das Rechenblatt sonst nicht komplett funktioniert. In neueren Excel-Versionen erscheint unterhalb der Menuleiste der folgende Hinweis:"]
[]
[null,"„Sicherheitswarnung: Die automatische Aktualisierung von Hyperlinks wurde deaktiviert“"]
[]
[null,"Dahinter befindet sich ein Knopf mit der Beschriftung „Qptionen“. Dieser muss betätigt werden und in der folgenden Auswahl ist der Punkt „Diesen Inhalt aktivieren“ zu markieren. Die Auswahl ist mit „OK“ zu bestätigen."]
[]
[null,"Nach dem Öffnen des Arbeitsblattes gelangt man auf die Info-Seite.  Hier werden Informationen zum Ersteller und Copyright gegeben."]
[]
[null,"Auf den übrigen Tabellenblättern werden Daten ein- und ausgegeben, sowie die Berechnungen durchgeführt.  Der Aufbau dieser Tabellenblätter ist immer gleich.  Auf der rechten Seite befindet sich der gelb hinterlegte Info-Bereich, wo Informationen über den Ablauf der Berechnungen und Ergebnisse dargestellt werden."]
[]
[null,"Der größere linke Bereich der Tabellenblätter ist grau hinterlegt.  Hier werden Eingaben getätigt und Berechnungen ausgeführt.  Bei den Zellen gibt es zwei Typen:"]
[null,"·         Die weiss hinterlegten sind Eingabefelder, wo Daten eingegeben werden müssen."]
[null,"·         Die blauen sind Ausgabefelder, wo sich Ergebnisse, Zwischenergebnisse oder feste Werte befinden."]
[]
[null,"Die Daten des bereits eingegebenen Beispielgebäudes können nach Belieben geändert werden.  Die Arbeitsmappe ist in keinerlei Weise geschützt oder gesperrt, so dass Sie theoretisch auch die Formeln und Makros ändern können.  Es wird allerdings davon abgeraten."]
[]
[null,"Bei dem Gebäude handelt es sich um ein Einfamilienhaus, welches nach dem Monatsbilanzverfahren gemäß Anlage 1 der EnEV gerechnet wird."]
[]
[null,"Da das Arbeitsblatt für Schulungszwecke erstellt wurde, besitzt es keine Routine zum Ausdruck. Auch ist der Rechengang nicht an allen Stellen komplett, da die komplette EnEV im Rahmen dieses Arbeitsblattes nicht behandelt werden kann.  So wurde insbesondere bei den versorgungstechnischen Anlagen eine eingeschränkte Auswahl der zur Verfügung stehenden Systeme nach DIN V 4701-10 getroffen."]
[null," "]
[null,"Für das Funktionieren des Arbeitsblattes und der enthaltenen Rechengänge übernimmt der Ersteller keine Haftung.  Ebenfalls kann keine Garantie hinsichtlich Virenfreiheit übernommen werden.  Wir raten Ihnen zur ständigen Benutzung eines Virenscanners mit den neuesten Signaturen."]

{"sheet":"rech","index":9,"n_rows":199,"n_cols":23,"rows_kept":199,"cut":false,"hidden":true,"merged":[[181,10,181,14],[172,12,172,14],[175,10,175,14],[176,10,176,14],[178,10,178,14],[180,10,180,14],[164,10,164,11],[164,12,164,14],[165,10,165,11],[165,12,165,14],[166,10,171,11],[166,12,166,14],[167,12,167,14],[168,12,168,14],[169,12,169,14],[170,12,170,14],[171,12,171,14],[161,10,161,11],[161,12,161,14],[162,10,162,11],[162,12,162,14],[163,10,163,11],[163,12,163,14],[158,10,158,11],[158,12,158,14],[159,10,159,11],[159,12,159,14],[160,10,160,11],[160,12,160,14],[155,10,155,11],[155,12,155,14],[156,10,156,11],[156,12,156,14],[157,10,157,11],[157,12,157,14],[152,10,152,11],[152,12,152,14],[153,10,153,11],[153,12,153,14],[154,10,154,11],[154,12,154,14],[146,10,146,14],[147,10,147,14],[149,10,149,14],[150,10,150,14],[151,10,151,16],[141,10,141,14],[142,10,142,14],[143,10,143,14],[144,10,144,14],[145,10,145,14],[191,4,191,5],[192,4,192,5],[193,4,193,5],[185,4,185,5],[186,4,186,5],[187,4,187,5],[188,4,188,5],[189,4,189,5],[190,4,190,5]]}
["Transmissionswärmeverluste"]
[]
[null,null,"Fläche","U-Wert","g-Wert","Fx","HWB","HT","Q in kWh",null,null,"J","F","M","A","M","J","J","A","S","O","N","D"]
[]
[null,{"$f":"Transmission!A9","v":"Aussenwand"},{"$f":"Transmission!B9","v":158.87},{"$f":"Transmission!D9","v":0.21},"-",{"$f":"Transmission!F9","v":1},{"$f":"$C$20*C5","v":7.9435000000000002},{"$f":"C5*D5*F5+G5","v":41.306199999999997},{"$f":"SUM(L5:W5)","v":3623.1815942399994},null,null,{"$f":"(C5*D5*F5+G5)*0.024*(L$20-L$21)*L$22","v":623.85579983999992},{"$f":"(C5*D5*F5+G5)*0.024*(M$20-M$21)*M$22","v":510.74290175999994},{"$f":"(C5*D5*F5+G5)*0.024*(N$20-N$21)*N$22","v":457.90401071999997},{"$f":"(C5*D5*F5+G5)*0.024*(O$20-O$21)*O$22","v":282.53440799999998},{"$f":"(C5*D5*F5+G5)*0.024*(P$20-P$21)*P$22","v":187.46405807999997},{"$f":"(C5*D5*F5+G5)*0.024*(Q$20-Q$21)*Q$22","v":98.143531200000012},{"$f":"(C5*D5*F5+G5)*0.024*(R$20-R$21)*R$22","v":30.731812799999997},{"$f":"(C5*D5*F5+G5)*0.024*(S$20-S$21)*S$22","v":21.512268959999975},{"$f":"(C5*D5*F5+G5)*0.024*(T$20-T$21)*T$22","v":136.80613439999999},{"$f":"(C5*D5*F5+G5)*0.024*(U$20-U$21)*U$22","v":304.24494671999997},{"$f":"(C5*D5*F5+G5)*0.024*(V$20-V$21)*V$22","v":425.28863519999999},{"$f":"(C5*D5*F5+G5)*0.024*(W$20-W$21)*W$22","v":543.95308655999986}]
[null,{"$f":"Transmission!A10","v":"Haustür"},{"$f":"Transmission!B10","v":3.8},{"$f":"Transmission!D10","v":1.3},"-",{"$f":"Transmission!F10","v":1},{"$f":"$C$20*C6","v":0.19},{"$f":"C6*D6*F6+G6","v":5.13},{"$f":"SUM(L6:W6)","v":449.97897599999999},null,null,77.479416000000001,{"$f":"(C6*D6*F6+G6)*0.024*(M$20-M$21)*M$22","v":63.431423999999993},{"$f":"(C6*D6*F6+G6)*0.024*(N$20-N$21)*N$22","v":56.869127999999996},{"$f":"(C6*D6*F6+G6)*0.024*(O$20-O$21)*O$22","v":35.089199999999998},{"$f":"(C6*D6*F6+G6)*0.024*(P$20-P$21)*P$22","v":23.281991999999999},{"$f":"(C6*D6*F6+G6)*0.024*(Q$20-Q$21)*Q$22","v":12.188880000000001},{"$f":"(C6*D6*F6+G6)*0.024*(R$20-R$21)*R$22","v":3.8167199999999997},{"$f":"(C6*D6*F6+G6)*0.024*(S$20-S$21)*S$22","v":2.6717039999999974},{"$f":"(C6*D6*F6+G6)*0.024*(T$20-T$21)*T$22","v":16.990559999999999},{"$f":"(C6*D6*F6+G6)*0.024*(U$20-U$21)*U$22","v":37.785527999999999},{"$f":"(C6*D6*F6+G6)*0.024*(V$20-V$21)*V$22","v":52.818480000000001},{"$f":"(C6*D6*F6+G6)*0.024*(W$20-W$21)*W$22","v":67.555943999999982}]
[null,{"$f":"Transmission!A11","v":"Kellerdecke/Sohle"},{"$f":"Transmission!B11","v":87.24},{"$f":"Transmission!D11","v":0.23},"-",0.45,{"$f":"$C$20*C7","v":4.3620000000000001},13.391340000000001,1174.6240663680001,null,null,202.25208628800002,165.58124083200002,148.45103870400001,91.596765600000012,60.775257455999999,31.817823840000013,9.963156960000001,6.9742098719999932,44.352118080000004,98.63525390400001,137.87723664000004,176.347878192]
[null,{"$f":"Transmission!A12","v":"Dach"},{"$f":"Transmission!B12","v":50},{"$f":"Transmission!D12","v":0.17},"-",{"$f":"Transmission!F12","v":1},2.5,11,964.86720000000003,null,null,166.13520000000003,136.0128,121.94160000000001,75.239999999999995,49.922400000000003,26.136000000000006,8.1840000000000011,5.7287999999999943,36.431999999999995,81.021600000000007,113.25600000000001,144.85679999999999]
[null,{"$f":"Transmission!A13","v":"OG-Decke"},{"$f":"Transmission!B13","v":63.91},{"$f":"Transmission!D13","v":0.17},"-",{"$f":"Transmission!F13","v":0.8},3.1955,11.887260000000001,1042.6933883519998,null,null,179.53566523200001,146.983592448,131.77740945600002,81.30885840000002,53.949140784000001,28.244129760000007,8.8441214400000003,6.1908850079999942,39.37060512,87.556802256000012,122.39122896000002,156.540949488]
[null,{"$f":"Transmission!A14","v":"Bodenluke"},{"$f":"Transmission!B14","v":0.72},{"$f":"Transmission!D14","v":0.7},"-",{"$f":"Transmission!F14","v":0.8},3.5999999999999997E-2,0.43919999999999998,38.524515839999992,null,null,6.6333254399999992,5.4306201599999993,4.8687955199999999,3.0041279999999997,1.9932652799999997,1.0435392000000001,0.32676479999999997,0.22873535999999978,1.4546303999999997,3.2349715200000002,4.5220032000000003,5.7837369599999997]
[{"$f":"$C$5*C11/$C$15","v":28.334492989892404},{"$f":"Transmission!A15","v":"Fenster nord"},{"$f":"Transmission!B15","v":5.47},{"$f":"Transmission!D15","v":1.3},{"$f":"Lüftung_Gewinne!D12","v":0.57999999999999996},{"$f":"Transmission!F15","v":1},0.27350000000000002,7.3845000000000001,647.73289439999996,null,null,111.52958040000001,91.307865599999985,81.861613199999994,50.509979999999999,33.513814799999999,17.545572000000003,5.4940679999999995,3.8458475999999959,24.457463999999998,54.391273200000001,76.030812000000012,97.24500359999999]
[{"$f":"$C$5*C12/$C$15","v":25.278304532116074},{"$f":"Transmission!A16","v":"Fenster ost"},{"$f":"Transmission!B16","v":4.88},{"$f":"Transmission!D16","v":1.3},{"$f":"Lüftung_Gewinne!D13","v":0.57999999999999996},{"$f":"Transmission!F16","v":1},0.24399999999999999,6.5880000000000001,577.86773760000005,null,null,99.499881600000009,81.459302399999999,73.031932800000007,45.061920000000001,29.898979199999999,15.653088000000006,4.9014720000000001,3.4310303999999965,21.819455999999999,48.524572800000008,67.830048000000005,86.756054399999996]
[{"$f":"$C$5*C13/$C$15","v":38.539054450603196},{"$f":"Transmission!A17","v":"Fenster west"},{"$f":"Transmission!B17","v":7.44},{"$f":"Transmission!D17","v":1.3},{"$f":"Lüftung_Gewinne!D14","v":0.57999999999999996},{"$f":"Transmission!F17","v":1},0.37200000000000005,10.044,881.01146880000022,null,null,151.69654080000004,124.19205120000001,111.34376640000001,68.700960000000009,45.5836896,23.864544000000006,7.4727360000000003,5.2309151999999948,33.265728000000003,73.980086400000005,103.41302400000001,132.26742720000001]
[{"$f":"$C$5*C14/$C$15","v":66.718148027388324},{"$f":"Transmission!A18","v":"Fenster süd"},{"$f":"Transmission!B18","v":12.88},{"$f":"Transmission!D18","v":1.3},{"$f":"Lüftung_Gewinne!D15","v":0.57999999999999996},{"$f":"Transmission!F18","v":1},0.64400000000000013,17.388000000000005,1525.1918976000006,{"$f":"SUM(I11:I14)","v":3631.8039984000011},null,262.61444160000008,214.99914240000007,192.75641280000008,118.93392000000004,78.913699200000025,41.31388800000002,12.936672000000003,9.0556703999999932,57.589056000000014,128.07305280000006,179.02684800000009,228.97909440000004]
[null,null,{"$f":"SUM(C11:C14)","v":30.67}]
[]
[null,null,{"$f":"SUM(C5:C14)","v":395.21000000000009},null,null,null,{"$f":"SUM(G5:G14)","v":19.7605},{"$f":"SUM(H5:H14)","v":124.5585},{"$f":"SUM(I5:I14)","v":10925.6737392},null,null,{"$f":"SUM(L5:L14)","v":1881.2319371999997},{"$f":"SUM(M5:M14)","v":1540.1409408},1380.8057076000002,851.98014000000023,565.29629639999996,295.95099600000003,92.671523999999991,64.870066799999947,412.53775200000001,917.44808760000001,1282.4543160000003,1640.2859747999998]
[null,null,null,null,null,null,null,null,{"$f":"SUM(L18:W18)","v":1733.2962096000001},null,null,{"$f":"$G$17*0.024*(L$20-L$21)*L$22","v":298.44678360000006},{"$f":"$G$17*0.024*(M$20-M$21)*M$22","v":244.33463039999998},219.0569988,135.16182000000001,89.681053199999994,46.950948000000011,14.701812,10.291268399999989,65.446775999999986,145.54793880000003,203.45410800000002,260.2220724]
[]
[null,"∆UWB",{"$f":"IF(Transmission!F42=0,0.05,IF(Transmission!F42=1,0.1))","v":0.05},null,null,null,null,null,"Innentemp.",null,"Θi",19,19,19,19,19,19,19,19,19,19,19,19]
[null,null,null,null,null,null,null,null,"Außentemp.",null,"Θe,M",-1.3,0.6,4.0999999999999996,9.5,12.9,15.7,18,18.3,14.4,9.1,4.7,1.3]
[null,null,null,null,null,null,null,null,"Tage je Mon.",null,"tM",31,28,31,30,31,30,31,31,30,31,30,31]
[]
[]
["Lüftungswärmeverluste",null,null,null,null,null,null,"HV"]
[]
[null,"0,76 oder 0,80",{"$f":"IF(Transmission!F50=0,0.76,IF(Transmission!F50=1,0.8))","v":0.76},null,null,null,null,{"$f":"0.34*$C$28*$C$30","v":90.785480800000002},{"$f":"SUM(L27:W27)","v":7963.2666054681604},null,null,{"$f":"0.34*$C$28*$C$30*0.024*(L$20-L$21)*L$22","v":1371.1512736185603},{"$f":"0.34*$C$28*$C$30*0.024*(M$20-M$21)*M$22","v":1122.5443129958398},1006.4115259564801,620.97268867200012,412.02082606272,215.70630238080005,67.544397715200006,47.281078400639949,300.68151240959997,668.68953738048015,934.72731031680019,1195.5358395590399]
[null,"n",{"$f":"IF(Lüftung_Gewinne!F40=0,0.7,IF(Lüftung_Gewinne!F40=1,0.6,IF(Lüftung_Gewinne!F40=2,0.55)))","v":0.7}]
[null,"Ve",{"$f":"Transmission!B3","v":501.91}]
[null,"V",{"$f":"C27*C29","v":381.45160000000004}]
[]
[]
["Interne Gewinne"]
[]
[null,"AN",{"$f":"0.32*C29","v":160.61120000000003},null,null,null,null,null,{"$f":"SUM(L35:W35)","v":7034.7705600000008},null,null,{"$f":"$C$36*$C$35*0.024*L$22","v":597.47366400000021},{"$f":"$C$36*$C$35*0.024*M$22","v":539.65363200000013},597.47366400000021,578.20032000000015,597.47366400000021,578.20032000000015,597.47366400000021,597.47366400000021,578.20032000000015,597.47366400000021,578.20032000000015,597.47366400000021]
[null,"qi",5]
[]
[]
["Solare Gewinne"]
[]
[null,"FF",0.7,null,null,null,null,null,{"$f":"SUM(L41:W41)","v":782.11737233279973},null,"FE nord",{"$f":"L47*$C$41*$C$42*$C$43*$C$44*$E$11*$C$11*24/1000*L22","v":18.736969507199991},{"$f":"M47*$C$41*$C$42*$C$43*$C$44*$E$11*$C$11*24/1000*M22","v":27.803245075199992},45.504068803199999,82.891662335999996,108.40675214879997,128.22304017599996,133.83549647999999,93.684847535999992,62.168746751999983,44.165713838399988,23.313280031999994,13.383549647999999]
[null,"FS",0.9,null,null,null,null,null,{"$f":"SUM(L42:W42)","v":1145.9305073663995},null,"FE ost",{"$f":"L48*$C$41*$C$42*$C$43*$C$44*$E$12*$C$12*24/1000*L22","v":29.849964480000004},{"$f":"M48*$C$41*$C$42*$C$43*$C$44*$E$12*$C$12*24/1000*M22","v":39.902662195199994},63.281924697599969,144.43531199999998,156.41381387519993,173.32237439999997,186.26377835519995,137.30983660799998,103.99342463999996,60.893927539199986,32.353509887999998,17.909978687999999]
[null,"FC",1,null,null,null,null,null,{"$f":"SUM(L43:W43)","v":3444.5526732288004},null,"FE süd",{"$f":"L49*$C$41*$C$42*$C$43*$C$44*$E$14*$C$14*24/1000*L22","v":176.47690475519997},{"$f":"M49*$C$41*$C$42*$C$43*$C$44*$E$14*$C$14*24/1000*M22","v":173.63050306559998},252.10986393600001,417.81110515199987,375.01342260479998,396.46309248000006,425.43539539200003,352.95380951039994,350.71735104000004,255.26123723519996,164.684669184,103.9953188736]
[null,"Fw",0.9,null,null,null,null,null,{"$f":"SUM(L44:W44)","v":1747.0743800831997},null,"FE west",{"$f":"L50*$C$41*$C$42*$C$43*$C$44*$E$13*$C$13*24/1000*L22","v":45.50896224000001},{"$f":"M50*$C$41*$C$42*$C$43*$C$44*$E$13*$C$13*24/1000*M22","v":60.835206297599996},96.478999948799967,220.20465599999997,238.46696213759992,264.24558719999999,283.97592437759988,209.341226304,158.54735231999999,92.838282969599987,49.325842943999987,27.305377344000004]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"IS,nord",14,23,34,64,81,99,100,70,48,33,18,10]
[null,null,null,null,null,null,null,null,null,null,"IS,ost",25,37,53,125,131,150,156,115,90,51,28,15]
[null,null,null,null,null,null,null,null,null,null,"IS,süd",56,61,80,137,119,130,135,112,115,81,54,33]
[null,null,null,null,null,null,null,null,null,null,"IS,west",25,37,53,125,131,150,156,115,90,51,28,15]
["Ausnutzungsgrad Gewinne"]
[]
["spez.","Cwirk,ƞ leichte Gebäude",null,15,"Wh/(m³*K)"]
["spez.","Cwirk,ƞ schwere Gebäude",null,50,"Wh/(m³*K)"]
["spez.","Cwirk,NA leichte Gebäude",null,12,"Wh/(m³*K)",null,null,null,{"$f":"SUM(L55:W55)","v":14154.445493011197},null,"Qg",{"$f":"L35+SUM(L41:L44)","v":868.04646498240027},{"$f":"M35+SUM(M41:M44)","v":841.82524863360004},1054.8485213856002,1443.5430554879999,1475.7746147664002,1540.4544142560001,1626.9842586047998,1390.7633839584,1253.6271947519999,1050.6328255824001,847.87762204800015,760.06788855360014]
["spez.","Cwirk,NA schwere Gebäude",null,18,"Wh/(m³*K)",null,null,null,{"$f":"SUM(L56:W56)","v":18175.096996856315},null,"Ql",{"$f":"L17+L27-K138","v":3113.3609275906588},{"$f":"M17+M27-L138","v":2555.7046328572515},2299.7724105489433,1422.7570050344104,944.02106567004216,494.2257297796628,154.75755174918737,108.33028622443118,688.92071423831783,1532.0203218861604,2136.9989928212849,2724.2273584559621]
[]
["abs.","Cwirk",null,{"$f":"IF(Lüftung_Gewinne!F44=0,D53*$C$29,IF(Lüftung_Gewinne!F44=1,D54*$C$29,IF(Lüftung_Gewinne!F44=2,D55*$C$29,IF(Lüftung_Gewinne!F44=3,D56*$C$29))))","v":9034.380000000001},"Wh/K",null,{"$f":"Transmission!F45","v":false},null,null,null,"Ɣ = Qg / Ql",{"$f":"L55/L56","v":0.27881330985102221},{"$f":"M55/M56","v":0.32939066502862974},0.45867517870336288,1.0146096981986652,1.5632856812564164,3.1169045264858428,10.513117067408913,12.838176953369373,1.8196973451989042,0.68578256474359567,0.39676088987230856,0.27900310383212346]
[null,null,null,null,null,null,null,null,null,null," = Cwirk / H",{"$f":"$D$58/($H$17+$H$27)","v":41.953250638524473},{"$f":"$D$58/($H$17+$H$27)","v":41.953250638524473},41.953250638524473,41.953250638524473,41.953250638524473,41.953250638524473,41.953250638524473,41.953250638524473,41.953250638524473,41.953250638524473,41.953250638524473,41.953250638524473]
[null,null,null,null,null,null,null,null,null,null,"a = 1+(/16)",{"$f":"1+L59/16","v":3.6220781649077796},{"$f":"1+M59/16","v":3.6220781649077796},3.6220781649077796,3.6220781649077796,3.6220781649077796,3.6220781649077796,3.6220781649077796,3.6220781649077796,3.6220781649077796,3.6220781649077796,3.6220781649077796,3.6220781649077796]
[null,"wenn Ɣ = 1","dann"," = a / (a+1)"]
[null,"wenn Ɣ  1","dann"," = 1 - Ɣa / 1 - Ɣa+1",null,null,null,null,null,null,"",{"$f":"IF(L58=1,L60/(L60+1),(1-L58^L60)/(1-L58^(L60+1)))","v":0.99291863164240157},{"$f":"IF(M58=1,M60/(M60+1),(1-M58^M60)/(1-M58^(M60+1)))","v":0.98791763538744881},0.96693225509323399,0.77792843606422879,0.5873521504936644,0.31726478173623585,9.5102125413539434E-2,7.7885741901013286E-2,0.51933504504260875,0.90286203381673291,0.97850052847167812,0.99290296305518821]
[]
[]
["Heizwärmebedarf"]
[null,null,null,null,null,null,null,null,null,null,null,"J","F","M","A","M","J","J","A","S","O","N","D"]
[null,"nutzbare Solargewinne",null,null,null,null,null,null,{"$f":"SUM(L67:W67)","v":3848.6912775127794},null,"Qs",{"$f":"SUM(L41:L44)*L62","v":268.65677531109645},{"$f":"SUM(M41:M44)*M62","v":298.52066898586878},442.25050227480449,673.17472087772137,515.87195221327499,305.2893351889291,97.908645682673225,61.785958381407042,350.77284642231831,409.14020226897105,263.87938257078434,161.44028733493008]
[null,"nutzbare interne Gewinne",null,null,null,null,null,null,{"$f":"SUM(L68:W68)","v":4790.3355022423975},null,"Qi",{"$f":"L35*L62","v":593.24273290125223},{"$f":"M35*M62","v":533.13334005368858},577.71655729033739,449.79847066943677,350.92744141372918,183.44259832462177,56.82101532501494,46.534679586956749,300.27968923085086,539.43628743097554,565.76931868249358,593.23337133304017]
[null,"Transmission",null,null,null,null,null,null,{"$f":"SUM(L69:W69)","v":10925.6737392},null,"QT",{"$f":"L17","v":1881.2319371999997},{"$f":"M17","v":1540.1409408},1380.8057076000002,851.98014000000023,565.29629639999996,295.95099600000003,92.671523999999991,64.870066799999947,412.53775200000001,917.44808760000001,1282.4543160000003,1640.2859747999998]
[null,"Lüftung",null,null,null,null,null,null,{"$f":"SUM(L70:W70)","v":7963.2666054681604},null,"QV",{"$f":"L27","v":1371.1512736185603},{"$f":"M27","v":1122.5443129958398},1006.4115259564801,620.97268867200012,412.02082606272,215.70630238080005,67.544397715200006,47.281078400639949,300.68151240959997,668.68953738048015,934.72731031680019,1195.5358395590399]
[null,"Heizwärmebedarf",null,null,null,{"$f":"I71/C35","v":55.266607723698982},"kWh/(m²*a)",null,{"$f":"SUM(L71:W71)","v":8876.4361864325638},null,"Qh",{"$f":"(L69+L70-K138-K196)-(L67+L68)","v":1930.8389354826568},{"$f":"(M69+M70-L138-L196)-(M67+M68)","v":1732.9785945807016},1281.2556888461868,289.21734138764214,22.796089002307667,-52.158820137675491,-68.194677618931166,-74.102163784947294,-10.114004941716644,549.57481548100361,1297.540954389834,1976.8034337455006]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"J","F","M","A","M","J","J","A","S","O","N","D"]
[null,null,null,"Außentemperatur",null,null,null,"q e","°C",null,{"$f":"L21","v":-1.3},{"$f":"M21","v":0.6},4.0999999999999996,9.5,12.9,15.7,18,18.3,14.4,9.1,4.7,1.3]
[null,null,null,"niedrigste  Innentemperatur ",null,null,null,"q inh ","°C",null,{"$f":"K125","v":-1.3},{"$f":"L125","v":0.6},4.0999999999999996,9.5,12.9,15.7,18,18.3,14.4,9.1,4.7,1.3]
[null,null,null,"niedrigste Bauteiltemperatur",null,null,null,"q cnh ","°C",null,{"$f":"K125+$P$176*(K126-K125)","v":-1.3},{"$f":"L125+$P$176*(L126-L125)","v":0.6},4.0999999999999996,9.5,12.9,15.7,18,18.3,14.4,9.1,4.7,1.3]
[null,null,null,"Innentemp. am Ende der nicht Heizph.",null,null,null,"q i1 ","°C",null,{"$f":"K126+$P$177*(K135-K127)*EXP(-K129/$P$179)","v":15.19696752256548},{"$f":"L126+$P$177*(L135-L127)*EXP(-L129/$P$179)","v":15.552916375133242},16.208611629863334,17.220255737161182,17.857216841756131,18.3817730455402,18.812658498648545,18.868860949053982,18.138229093783309,17.145319136620607,16.321016530674207,15.684055426079262]
[null,null,null,"Zeit in der nicht geheizt wird  ",null,null,null,"tnh ","h",null,{"$f":"$P$142","v":7},{"$f":"$P$142","v":7},7,7,7,7,7,7,7,7,7,7]
[null,null,null,"Zeit mit abgesenkten Regelbetrieb",null,null,null,"tsb","h",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"höchst mögliche Innentemperatur",null,null,null,"q ipp","°C",null,{"$f":"K125+($P$144+$P$146)/$P$150","v":39.434224920578792},{"$f":"L125+($P$144+$P$146)/$P$150","v":41.334224920578791},44.834224920578791,50.234224920578789,53.634224920578788,56.434224920578785,58.734224920578789,59.034224920578794,55.134224920578788,49.834224920578791,45.434224920578792,42.034224920578787]
[null,null,null,"höchst mögliche Bauteiltemperatur",null,null,null,"q cpp","°C",null,{"$f":"K125+$P$176*(K131-K125)","v":38.881769379122169},{"$f":"L125+$P$176*(L131-L125)","v":40.781769379122167},44.281769379122167,49.681769379122166,53.081769379122164,55.881769379122161,58.181769379122166,58.48176937912217,54.581769379122164,49.281769379122167,44.881769379122169,41.481769379122163]
[null,null,null,"Bauteiltemperatur Ende nicht Heizph.",null,null,null,"q c1","°C",null,{"$f":"K127+(K128-K126)/$P$177","v":15.692088485186186},{"$f":"L127+(L128-L126)/$P$177","v":16.001695966868265},16.572025538387891,17.451962591589592,18.005997032494371,18.462260689710067,18.837048693851536,18.885934085696075,18.250423991717064,17.386782069130213,16.669796322076973,16.11576188117219]
[null,null,null,"Zeit der Aufheizphase",null,null,null,"tbh","h",null,{"$f":"IF(SUM($P$179*LN($P$177*(K132-K133)/(K131-$P$182)))>0,$P$179*LN($P$177*(K132-K133)/(K131-$P$182)),0)","v":4.1315531742753242},{"$f":"IF(SUM($P$179*LN($P$177*(L132-L133)/(L131-$P$182)))>0,$P$179*LN($P$177*(L132-L133)/(L131-$P$182)),0)","v":3.1691950627274608},1.7269065029843977,7.6982276687051251E-2,0,0,0,0,0,0.18126046375774682,1.5139002533922363,2.8498920844815951]
[null,null,null,"Bauteiltemperatur beginn Absenkung",null,null,null,"q co","°C",null,{"$f":"K125+$P$176*($P$182-K125)","v":18.724682438086511},{"$f":"L125+$P$176*($P$182-L125)","v":18.750451076886296},18.797919622043793,18.871156806001075,18.917269107011219,18.955243943137216,18.986437558526429,18.990506290968501,18.937612769221573,18.865731829411651,18.806057086927936,18.759944785917796]
[null,null,null,"Bauteiltemperatur ende Aufheizph.",null,null,null,"q c3","°C",null,{"$f":"IF(K134>0,K132+($P$182-K131)/$P$177,K133)","v":17.834255191940539},{"$f":"IF(L134>0,L132+($P$182-L131)/$P$177,L133)","v":17.777230782594241},17.672185818008959,17.510116444077376,18.005997032494371,18.462260689710067,18.837048693851536,18.885934085696075,18.250423991717064,17.522121582887124,17.654178109794337,17.756221789677188]
[null,null,null,"Berechnung der täglichen Reduzierung ",null,null,null,"DQilj","kWh/d",null,{"$f":"($P$150*(($P$182-K126)*K129+($P$182-$P$143)*K130+($P$182-K131)*K134)-$P$147*$P$176*(K135-K133+K133-K136))/1000","v":4.4845897815451972},{"$f":"($P$150*(($P$182-L126)*L129+($P$182-$P$143)*L130+($P$182-L131)*L134)-$P$147*$P$176*(L135-L133+L133-L136))/1000","v":3.8207364620924347},2.8208007421786094,1.6731941212529946,1.0740663481508945,0.58105228670457476,0.17607645051653639,0.12325351536157132,0.80995167237607346,1.7457194546554802,2.672754449850514,3.5998211581637989]
[null,null,null,"Berechnung der monatl. Reduzierung ",null,null,null,"DQil","kWh/M",null,{"$f":"K137*L22","v":139.02228322790111},{"$f":"L137*M22","v":106.98062093858817},87.444823007536897,50.195823637589839,33.296056792677732,17.431568601137243,5.4583699660126284,3.8208589762087111,24.298550171282205,54.117303094319887,80.182633495515418,111.59445590307777,{"$f":"SUM(K138:V138)","v":713.84334781184771}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Dauer der Nachtabsenkung tu =",null,null,null,null,7,"h"]
[null,null,null,null,null,null,null,null,null,null,"Mindest- Innentemperatur qisb =",null,null,null,null,14,"°C"]
[null,null,null,null,null,null,null,null,null,null,"Nennleistung der Heizungsanlage Fpp = 1,5 x (HT+HV,n=0,5) x 31",null,null,null,null,{"$f":"1.5*(H17+P149)*31","v":8771.8701492},"W"]
[null,null,null,null,null,null,null,null,null,null,"Abschaltbetrieb =",null,null,null,null,"ja"]
[null,null,null,null,null,null,null,null,null,null,"Interne Wärmegewinne während der Nachtabsenkung Fg =",null,null,null,null,0,"W"]
[null,null,null,null,null,null,null,null,null,null,"Wirksame Wärmespeicherf. Cwirk,HU =",null,null,null,null,{"$f":"D58","v":9034.380000000001},"Wh/K"]
[null,null,null,null,null,null,null,null,null,null,"Lüftungswärmeverluste Hv =",null,null,null,null,{"$f":"H27","v":90.785480800000002},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Lüftungswärmeverluste Hv,n=0,5 =",null,null,null,null,{"$f":"0.5*C30*0.28*1.2","v":64.083868800000005},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Spezifischer Wärmeverlust Hsb = (HT + HV) =",null,null,null,null,{"$f":"H17+H27","v":215.3439808},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Spezifischer Wärmeverlust zwischen den Bauteilen Hic = 4 x AN/0,13 m²",null,null,null,null,{"$f":"4*C35/0.13","v":4941.8830769230772},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Spezif. Wärmeverlust leichter Bauteile Hw (Fenster, Türen, Paneele <60kg(m²))"]
[null,null,null,null,null,null,null,null,null,null,"Eingabe Bauteilnummer",null,"Name Bauteil",null,null,"HW"]
[null,null,null,null,null,null,null,null,null,null,3,null,"Dachfläche",null,null,{"$f":"H8","v":11},"W/K"]
[null,null,null,null,null,null,null,null,null,null,4,null,"Haustüre",null,null,{"$f":"H6","v":5.13},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Fenster",null,"Fenster Süd",null,null,{"$f":"H14","v":17.388000000000005},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster Ost",null,null,{"$f":"H12","v":6.5880000000000001},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster West",null,null,{"$f":"H13","v":10.044},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster Nord",null,null,{"$f":"H11","v":7.3845000000000001},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster <30°C",null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster ohne Gewinne",null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe HW =",null,null,{"$f":"SUM(P154:P172)","v":57.534500000000008},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Spezifischer Wärmeverlust zwischen den Innenbauteilen und außen Hce: "]
[null,null,null,null,null,null,null,null,null,null,"Hce = Hic x (Hsb - Hw - Hv) / (Hic - Hsb + Hw + Hv) = ",null,null,null,null,{"$f":"P151*(P150-P173-P148)/(P151-P150+P173+P148)","v":67.945506961558223},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Wirksamer Anteil der Wärmespeicherfähigkeit z = Hic / (Hic + Hce) =",null,null,null,null,{"$f":"P151/(P151+P175)","v":0.98643755852642911}," -----"]
[null,null,null,null,null,null,null,null,null,null,"Verhältniswert x = Hic / (Hic + Hw + Hv) =",null,null,null,null,{"$f":"P151/(+P151+P173+P148)","v":0.97086167700619286}," -----"]
[null,null,null,null,null,null,null,null,null,null,"Reaktionszeit der Bauteiltemperatur auf einen Wechsel der Heizleistung "]
[null,null,null,null,null,null,null,null,null,null," tp = z x C /(x . Hsb) =",null,null,null,null,{"$f":"+P176*P147/(P177*P150)","v":42.626321660700853}]
[null,null,null,null,null,null,null,null,null,null,"Ansprechzeit der Bauteiltemperatur auf einen Wechsel der Lufttemperatur:"]
[null,null,null,null,null,null,null,null,null,null," tT = z x C /(Hce + Hic) =",null,null,null,null,{"$f":"+P176*P147/(P175+P151)","v":1.7788735883433615}]
[null,null,null,null,null,null,null,null,null,null,"normale Sollinnentemperatur q io =",null,null,null,null,19,"°C"]
[]
[null,"Solare Gewinne durch opake Bauteile"]
[]
[null,null,null,"Fläche","Strahlungsab-sorptionsgrad",null,"U-Wert","Formfaktor"]
[null,null,null,"m²","αi",null,"W/(m²*K)","Ff",null,null,"gesamt","J","F","M","A","M","J","J","A","S","O","N","D"]
[null,{"$f":"B5","v":"Aussenwand"},"nord",{"$f":"A11","v":28.334492989892404},0.5,null,{"$f":"D5","v":0.21},0.5,null,null,{"$f":"SUM(L188:W188)","v":10.042106997128137},{"$f":"$G188*$D188*$D$197*($E188*L47-$H188*$D$198*$D$199)*L$22*0.024","v":-2.3020302160652104},{"$f":"$G188*$D188*$D$197*($E188*M47-$H188*$D$198*$D$199)*M$22*0.024","v":-1.3595116412494292},-0.53123774216889463,2.056404163234431,3.6301245714874475,5.0553269012846425,5.3123774216889466,2.6561887108444733,0.68546805441147696,-0.61977736586371057,-1.8850371496315621,-2.6561887108444733]
[null,null,"ost",{"$f":"A12","v":25.278304532116074},0.5,null,{"$f":"D5","v":0.21},0.5,null,null,{"$f":"SUM(L189:W189)","v":38.608100523278772},{"$f":"$G189*$D189*$D$197*($E189*L48-$H189*$D$198*$D$199)*L$22*0.024","v":-1.1848446900293443},-0.21403646013433322,1.0268653980254319,6.4975353969351159,7.1880577861780237,8.4085752195630903,9.1627989362269311,5.9242234501467221,3.82207964525595,0.86888610602151928,-0.91729911486142812,-1.9747411500489076]
[null,null,"west",{"$f":"A13","v":38.539054450603196},0.5,null,{"$f":"D5","v":0.21},0.5,null,null,58.861530305982399,{"$f":"$G190*$D190*$D$197*($E190*L50-$H190*$D$198*$D$199)*L$22*0.024","v":-1.8064025602086735},{"$f":"$G190*$D190*$D$197*($E190*M50-$H190*$D$198*$D$199)*M$22*0.024","v":-0.32631788184414739},1.5655488855141837,9.9060785559830471,10.958842198599283,12.819631072448651,13.969513132280404,9.0320128010433667,5.8271050329312031,1.3246952108196937,-1.3985052079034888,-3.0106709336811215]
[null,null,"süd",{"$f":"A14","v":66.718148027388324},0.5,null,{"$f":"D5","v":0.21},0.5,null,null,129.68855086926379,{"$f":"$G191*$D191*$D$197*($E191*L49-$H191*$D$198*$D$199)*L$22*0.024","v":3.3356939032957285},{"$f":"$G191*$D191*$D$197*($E191*M49-$H191*$D$198*$D$199)*M$22*0.024","v":3.9544113208425169},8.3392347582393214,19.570300924577765,16.469988647522658,18.158011167134006,19.805682550818389,15.010622564830781,15.131675972611673,8.5477156271953039,2.8245795148875121,-1.4593660826918813]
[null,{"$f":"B6","v":"Haustür"},"nord",{"$f":"C6","v":3.8},0.5,null,{"$f":"D6","v":1.3},0.5,null,null,8.3371392000000011,{"$f":"$G192*$D192*$D$197*($E192*L47-$H192*$D$198*$D$199)*L$22*0.024","v":-1.9111872000000001},{"$f":"$G192*$D192*$D$197*($E192*M47-$H192*$D$198*$D$199)*M$22*0.024","v":-1.1286912},-0.44104319999999997,1.7072639999999999,3.0137952000000001,4.1970239999999999,4.4104320000000001,2.2052160000000001,0.56908800000000004,-0.51455039999999996,-1.5649919999999999,-2.2052160000000001]
[null,"Dach","ost",25,0.8,null,{"$f":"D8","v":0.17},1,null,null,37.542528000000011,{"$f":"$G193*$D193*$D$197*($E193*L48-$H193*$D$198*$D$199)*L$22*0.024","v":-2.5296000000000003},-1.1880959999999998,0.30355200000000071,7.3440000000000012,8.1959040000000023,9.7920000000000016,10.725504000000003,6.5769600000000006,3.9168000000000003,0.10118400000000054,-2.1542400000000002,-3.541440000000001]
[null,null,"west",25,0.8,null,{"$f":"D8","v":0.17},1,null,null,37.542528000000011,{"$f":"$G194*$D194*$D$197*($E194*L50-$H194*$D$198*$D$199)*L$22*0.024","v":-2.5296000000000003},{"$f":"$G194*$D194*$D$197*($E194*M50-$H194*$D$198*$D$199)*M$22*0.024","v":-1.1880959999999998},0.30355200000000071,7.3440000000000012,8.1959040000000023,9.7920000000000016,10.725504000000003,6.5769600000000006,3.9168000000000003,0.10118400000000054,-2.1542400000000002,-3.541440000000001]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K188:K194)","v":320.62248389565315},{"$f":"SUM(L188:L194)","v":-8.9279707630075009},-1.4503378623853926,10.566472099610042,54.425583040730366,57.65261640378742,68.222568360430387,74.111812041014673,47.982183526865342,33.869016705210306,9.8093371781728074,-7.2497339575089672,-18.389062877266387]
[null,"Durchlasswiderstand",null,0.04]
[null,"Abstrahlungskoeffizient hr",null,4]
[null,"Temperaturdifferenz ∆θer",null,10]

{"sheet":"ref","index":10,"n_rows":199,"n_cols":23,"rows_kept":199,"cut":false,"hidden":true,"merged":[[181,10,181,14],[171,12,171,14],[172,12,172,14],[175,10,175,14],[176,10,176,14],[178,10,178,14],[180,10,180,14],[166,10,171,11],[166,12,166,14],[167,12,167,14],[162,10,162,11],[162,12,162,14],[168,12,168,14],[169,12,169,14],[170,12,170,14],[163,10,163,11],[163,12,163,14],[164,10,164,11],[164,12,164,14],[165,10,165,11],[165,12,165,14],[186,4,186,5],[145,10,145,14],[146,10,146,14],[147,10,147,14],[149,10,149,14],[150,10,150,14],[151,10,151,16],[152,10,152,11],[152,12,152,14],[153,10,153,11],[153,12,153,14],[154,10,154,11],[154,12,154,14],[155,10,155,11],[155,12,155,14],[156,10,156,11],[141,10,141,14],[142,10,142,14],[143,10,143,14],[144,10,144,14],[185,4,185,5],[156,12,156,14],[157,10,157,11],[157,12,157,14],[158,10,158,11],[158,12,158,14],[159,10,159,11],[159,12,159,14],[160,10,160,11],[160,12,160,14],[161,10,161,11],[161,12,161,14],[193,4,193,5],[187,4,187,5],[188,4,188,5],[189,4,189,5],[190,4,190,5],[191,4,191,5],[192,4,192,5]]}
["Transmissionswärmeverluste"]
[]
[null,null,"Fläche","U-Wert","g-Wert","Fx","HWB","HT","Q in kWh",null,null,"J","F","M","A","M","J","J","A","S","O","N","D"]
[]
[null,{"$f":"Transmission!A9","v":"Aussenwand"},{"$f":"Transmission!B9","v":158.87},0.28000000000000003,"-",{"$f":"Transmission!F9","v":1},{"$f":"$C$20*C5","v":7.9435000000000002},{"$f":"C5*D5*F5+G5","v":52.427100000000003},{"$f":"SUM(L5:W5)","v":4598.6535619200004},null,null,{"$f":"(C5*D5*F5+G5)*0.024*(L$20-L$21)*L$22","v":791.81697672000007},{"$f":"(C5*D5*F5+G5)*0.024*(M$20-M$21)*M$22","v":648.25060608000001},{"$f":"(C5*D5*F5+G5)*0.024*(N$20-N$21)*N$22","v":581.18585976000008},{"$f":"(C5*D5*F5+G5)*0.024*(O$20-O$21)*O$22","v":358.60136400000005},{"$f":"(C5*D5*F5+G5)*0.024*(P$20-P$21)*P$22","v":237.93515064000002},{"$f":"(C5*D5*F5+G5)*0.024*(Q$20-Q$21)*Q$22","v":124.56678960000004},{"$f":"(C5*D5*F5+G5)*0.024*(R$20-R$21)*R$22","v":39.005762400000002},{"$f":"(C5*D5*F5+G5)*0.024*(S$20-S$21)*S$22","v":27.304033679999975},{"$f":"(C5*D5*F5+G5)*0.024*(T$20-T$21)*T$22","v":173.63855519999998},{"$f":"(C5*D5*F5+G5)*0.024*(U$20-U$21)*U$22","v":386.15704776000007},{"$f":"(C5*D5*F5+G5)*0.024*(V$20-V$21)*V$22","v":539.78942160000008},{"$f":"(C5*D5*F5+G5)*0.024*(W$20-W$21)*W$22","v":690.40199447999998}]
[null,{"$f":"Transmission!A10","v":"Haustür"},{"$f":"Transmission!B10","v":3.8},1.8,"-",{"$f":"Transmission!F10","v":1},{"$f":"$C$20*C6","v":0.19},{"$f":"C6*D6*F6+G6","v":7.03},{"$f":"SUM(L6:W6)","v":616.63785600000006},null,null,{"$f":"(C6*D6*F6+G6)*0.024*(L$20-L$21)*L$22","v":106.17549600000001},{"$f":"(C6*D6*F6+G6)*0.024*(M$20-M$21)*M$22","v":86.924543999999997},{"$f":"(C6*D6*F6+G6)*0.024*(N$20-N$21)*N$22","v":77.931768000000005},{"$f":"(C6*D6*F6+G6)*0.024*(O$20-O$21)*O$22","v":48.0852},{"$f":"(C6*D6*F6+G6)*0.024*(P$20-P$21)*P$22","v":31.904951999999998},{"$f":"(C6*D6*F6+G6)*0.024*(Q$20-Q$21)*Q$22","v":16.703280000000007},{"$f":"(C6*D6*F6+G6)*0.024*(R$20-R$21)*R$22","v":5.2303199999999999},{"$f":"(C6*D6*F6+G6)*0.024*(S$20-S$21)*S$22","v":3.6612239999999967},{"$f":"(C6*D6*F6+G6)*0.024*(T$20-T$21)*T$22","v":23.283360000000002},{"$f":"(C6*D6*F6+G6)*0.024*(U$20-U$21)*U$22","v":51.78016800000001},{"$f":"(C6*D6*F6+G6)*0.024*(V$20-V$21)*V$22","v":72.380880000000019},{"$f":"(C6*D6*F6+G6)*0.024*(W$20-W$21)*W$22","v":92.576663999999994}]
[null,{"$f":"Transmission!A11","v":"Kellerdecke/Sohle"},{"$f":"Transmission!B11","v":87.24},0.35,"-",0.45,{"$f":"$C$20*C7","v":4.3620000000000001},18.1023,1587.8468649599999,null,null,273.40265736000003,223.83131903999998,200.67485687999999,123.819732,82.155478319999986,43.011064800000007,13.468111199999999,9.4276778399999888,59.954817599999991,133.33430088,186.38128079999998,238.38556824]
[null,{"$f":"Transmission!A12","v":"Dach"},{"$f":"Transmission!B12","v":50},0.2,"-",{"$f":"Transmission!F12","v":1},2.5,12.5,1096.44,null,null,188.79,154.56,138.57,85.5,56.73,29.700000000000006,9.2999999999999989,6.5099999999999927,41.4,92.070000000000007,128.69999999999999,164.60999999999999]
[null,{"$f":"Transmission!A13","v":"OG-Decke"},{"$f":"Transmission!B13","v":63.91},0.2,"-",{"$f":"Transmission!F13","v":0.8},3.1955,13.421099999999999,1177.2344707199998,null,null,202.70155751999999,165.94921727999997,148.78094615999998,91.800323999999989,60.91032023999999,31.888533600000002,9.9852983999999996,6.9897088799999922,44.450683199999993,98.854454159999989,138.18364559999998,176.73978167999996]
[null,{"$f":"Transmission!A14","v":"Bodenluke"},{"$f":"Transmission!B14","v":0.72},0.2,"-",{"$f":"Transmission!F14","v":0.8},3.5999999999999997E-2,0.1512,13.262538239999998,null,null,2.2836038400000001,1.86955776,1.6761427200000001,1.034208,0.68620608000000005,0.3592512000000001,0.1124928,7.8744959999999919E-2,0.50077439999999995,1.1136787200000002,1.5567552,1.99112256]
[{"$f":"$C$5*C11/$C$15","v":28.334492989892404},{"$f":"Transmission!A15","v":"Fenster nord"},{"$f":"Transmission!B15","v":5.47},1.3,0.6,{"$f":"Transmission!F15","v":1},0.27350000000000002,7.3845000000000001,647.73289439999996,null,null,111.52958040000001,91.307865599999985,81.861613199999994,50.509979999999999,33.513814799999999,17.545572000000003,5.4940679999999995,3.8458475999999959,24.457463999999998,54.391273200000001,76.030812000000012,97.24500359999999]
[{"$f":"$C$5*C12/$C$15","v":25.278304532116074},{"$f":"Transmission!A16","v":"Fenster ost"},{"$f":"Transmission!B16","v":4.88},1.3,0.6,{"$f":"Transmission!F16","v":1},0.24399999999999999,6.5880000000000001,577.86773760000005,null,null,99.499881600000009,81.459302399999999,73.031932800000007,45.061920000000001,29.898979199999999,15.653088000000006,4.9014720000000001,3.4310303999999965,21.819455999999999,48.524572800000008,67.830048000000005,86.756054399999996]
[{"$f":"$C$5*C13/$C$15","v":38.539054450603196},{"$f":"Transmission!A17","v":"Fenster west"},{"$f":"Transmission!B17","v":7.44},1.3,0.6,{"$f":"Transmission!F17","v":1},0.37200000000000005,10.044,881.01146880000022,null,null,151.69654080000004,124.19205120000001,111.34376640000001,68.700960000000009,45.5836896,23.864544000000006,7.4727360000000003,5.2309151999999948,33.265728000000003,73.980086400000005,103.41302400000001,132.26742720000001]
[{"$f":"$C$5*C14/$C$15","v":66.718148027388324},{"$f":"Transmission!A18","v":"Fenster süd"},{"$f":"Transmission!B18","v":12.88},1.3,0.6,{"$f":"Transmission!F18","v":1},0.64400000000000013,17.388000000000005,1525.1918976000006,null,null,{"$f":"(C14*D14*F14+G14)*0.024*(L$20-L$21)*L$22","v":262.61444160000008},214.99914240000007,192.75641280000008,118.93392000000004,78.913699200000025,41.31388800000002,12.936672000000003,9.0556703999999932,57.589056000000014,128.07305280000006,179.02684800000009,228.97909440000004]
[null,null,{"$f":"SUM(C11:C14)","v":30.67}]
[]
[null,null,{"$f":"SUM(C5:C14)","v":395.21000000000009},null,null,null,{"$f":"SUM(G5:G14)","v":19.7605},{"$f":"SUM(H5:H14)","v":145.03620000000001},{"$f":"SUM(I5:I14)","v":12721.879290239998},null,null,{"$f":"SUM(L5:L15)","v":2190.5107358400001},1793.3436057599999,1607.8132987200001,992.0476080000002,658.23229007999987,344.60601120000018,107.90693279999999,75.534852959999938,480.35989440000009,1068.2786347200004,1493.2927152000002,1909.9527105599998]
[null,null,null,null,"HT,ref",null,null,{"$f":"H17/C17","v":0.36698514713696512},{"$f":"SUM(L18:W18)","v":1733.2962096000001},null,null,{"$f":"$G$17*0.024*(L$20-L$21)*L$22","v":298.44678360000006},{"$f":"$G$17*0.024*(M$20-M$21)*M$22","v":244.33463039999998},219.0569988,135.16182000000001,89.681053199999994,46.950948000000011,14.701812,10.291268399999989,65.446775999999986,145.54793880000003,203.45410800000002,260.2220724]
[]
[null,"∆UWB",0.05,null,null,null,null,null,"Innentemp.",null,"Θi",19,19,19,19,19,19,19,19,19,19,19,19]
[null,null,null,null,null,null,null,null,"Außentemp.",null,"Θe,M",-1.3,0.6,4.0999999999999996,9.5,12.9,15.7,18,18.3,14.4,9.1,4.7,1.3]
[null,null,null,null,null,null,null,null,"Tage je Mon.",null,"tM",31,28,31,30,31,30,31,31,30,31,30,31]
[]
[]
["Lüftungswärmeverluste",null,null,null,null,null,null,"HV"]
[]
[null,"0,76 oder 0,80",{"$f":"IF(Transmission!F50=0,0.76,IF(Transmission!F50=1,0.8))","v":0.76},null,null,null,null,{"$f":"0.34*$C$28*$C$30","v":71.331449200000023},{"$f":"SUM(L27:W27)","v":6256.8523328678421},null,null,{"$f":"0.34*$C$28*$C$30*0.024*(L$20-L$21)*L$22","v":1077.3331435574403},{"$f":"0.34*$C$28*$C$30*0.024*(M$20-M$21)*M$22","v":881.99910306816025},790.75191325152025,487.9071125280002,323.73064904928009,169.4835232992001,53.070598204800021,37.149418743359973,236.24975975040007,525.39892222752019,734.42860096320032,939.34958822496026]
[null,"n",0.55000000000000004]
[null,"Ve",{"$f":"Transmission!B3","v":501.91}]
[null,"V",{"$f":"C27*C29","v":381.45160000000004}]
[]
[]
["Interne Gewinne"]
[]
[null,"AN",{"$f":"0.32*C29","v":160.61120000000003},null,null,null,null,null,{"$f":"SUM(L35:W35)","v":7034.7705600000008},null,null,{"$f":"$C$36*$C$35*0.024*L$22","v":597.47366400000021},{"$f":"$C$36*$C$35*0.024*M$22","v":539.65363200000013},597.47366400000021,578.20032000000015,597.47366400000021,578.20032000000015,597.47366400000021,597.47366400000021,578.20032000000015,597.47366400000021,578.20032000000015,597.47366400000021]
[null,"qi",5]
[]
[]
["Solare Gewinne"]
[]
[null,"FF",0.7,"Rahmenanteil",null,null,null,null,{"$f":"SUM(L41:W41)","v":809.08693689599977},null,"FE nord",{"$f":"L47*$C$41*$C$42*$C$43*$C$44*$E$11*$C$11*24/1000*L22","v":19.383071903999998},{"$f":"M47*$C$41*$C$42*$C$43*$C$44*$E$11*$C$11*24/1000*M22","v":28.761977663999996},47.073174623999989,85.749995519999985,112.14491601599995,132.64452431999996,138.45051359999999,96.91535952000001,64.312496639999992,45.688669487999995,24.117186239999995,13.845051359999998]
[null,"FS",0.9,"Verschattung",null,null,null,null,{"$f":"SUM(L42:W42)","v":1185.445352448},null,"FE ost",{"$f":"L48*$C$41*$C$42*$C$43*$C$44*$E$12*$C$12*24/1000*L22","v":30.879273600000005},{"$f":"M48*$C$41*$C$42*$C$43*$C$44*$E$12*$C$12*24/1000*M22","v":41.278616063999991},65.464060031999978,149.41584,161.80739366399996,179.29900799999999,192.68666726399996,142.04465855999999,107.57940479999998,62.993718143999992,33.469148160000003,18.527564160000001]
[null,"FC",1,"Abminderung Sonnenschutz",null,null,null,null,{"$f":"SUM(L43:W43)","v":3563.3303516160004},null,"FE süd",{"$f":"L49*$C$41*$C$42*$C$43*$C$44*$E$14*$C$14*24/1000*L22","v":182.56231526399998},{"$f":"M49*$C$41*$C$42*$C$43*$C$44*$E$14*$C$14*24/1000*M22","v":179.61776179199998},260.80330752000003,432.2183846399999,387.94491993599996,410.13423360000007,440.10558143999992,365.12463052799995,362.81105280000003,264.06334886399998,170.36345087999999,107.58136435200001]
[null,"Fw",0.9,"Abminderung nicht senkrechte Strahlung",null,null,null,null,{"$f":"SUM(L44:W44)","v":1807.3183242240004},null,"FE west",{"$f":"L50*$C$41*$C$42*$C$43*$C$44*$E$13*$C$13*24/1000*L22","v":47.078236800000013},{"$f":"M50*$C$41*$C$42*$C$43*$C$44*$E$13*$C$13*24/1000*M22","v":62.932972031999995},99.805862016000006,227.79792000000003,246.68996083199994,273.35750400000001,293.76819763200001,216.55988927999999,164.0145024,96.039603071999991,51.026734079999997,28.246942080000007]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I41:I44)","v":7365.1809651840003}]
[null,null,null,null,null,null,null,null,null,null,"IS,nord",14,23,34,64,81,99,100,70,48,33,18,10]
[null,null,null,null,null,null,null,null,null,null,"IS,ost",25,37,53,125,131,150,156,115,90,51,28,15]
[null,null,null,null,null,null,null,null,null,null,"IS,süd",56,61,80,137,119,130,135,112,115,81,54,33]
[null,null,null,null,null,null,null,null,null,null,"IS,west",25,37,53,125,131,150,156,115,90,51,28,15]
["Ausnutzungsgrad Gewinne"]
[]
["spez.","Cwirk,ƞ leichte Gebäude",null,15,"Wh/(m³*K)"]
["spez.","Cwirk,ƞ schwere Gebäude",null,50,"Wh/(m³*K)"]
["spez.","Cwirk,NA leichte Gebäude",null,12,"Wh/(m³*K)",null,null,null,{"$f":"SUM(L55:W55)","v":14399.951525184002},null,"Qg",{"$f":"L35+SUM(L41:L44)","v":877.37656156800017},{"$f":"M35+SUM(M41:M44)","v":852.24495955200018},1070.6200681920002,1473.3824601599999,1506.0608544480001,1573.6355899200003,1662.4846239359999,1418.1182018880002,1276.9177766400003,1066.259003568,857.17683936000014,765.67458595200014]
["spez.","Cwirk,NA schwere Gebäude",null,18,"Wh/(m³*K)",null,null,null,{"$f":"SUM(L56:W56)","v":18277.703253074393},null,"Ql",{"$f":"L17+L27-K138","v":3135.2704947534917},{"$f":"M17+M27-L138","v":2572.0014822949106},2312.313794181287,1429.0517329898269,948.18836038026711,496.40744409120293,155.44071481643707,108.80850037150627,691.96189176349526,1538.8630766827291,2148.3702689787601,2741.0254917704769]
[]
["abs.","Cwirk",null,{"$f":"IF(Lüftung_Gewinne!F44=0,D53*$C$29,IF(Lüftung_Gewinne!F44=1,D54*$C$29,IF(Lüftung_Gewinne!F44=2,D55*$C$29,IF(Lüftung_Gewinne!F44=3,D56*$C$29))))","v":9034.380000000001},"Wh/K",null,null,null,null,null,"Ɣ = Qg / Ql",{"$f":"L55/L56","v":0.27984078663585399},{"$f":"M55/M56","v":0.33135476997920338},0.46300812237772898,1.0310210793260965,1.5883561931133603,3.1700483315695052,10.695297084160092,13.033156389860174,1.8453585260103258,0.69288750878765348,0.39898934170573119,0.27933873225580158]
[null,null,null,null,null,null,null,null,null,null," = Cwirk / H",{"$f":"$D$58/($H$17+$H$27)","v":41.754763401108306},{"$f":"$D$58/($H$17+$H$27)","v":41.754763401108306},41.754763401108306,41.754763401108306,41.754763401108306,41.754763401108306,41.754763401108306,41.754763401108306,41.754763401108306,41.754763401108306,41.754763401108306,41.754763401108306]
[null,null,null,null,null,null,null,null,null,null,"a = 1+(/16)",{"$f":"1+L59/16","v":3.6096727125692691},{"$f":"1+M59/16","v":3.6096727125692691},3.6096727125692691,3.6096727125692691,3.6096727125692691,3.6096727125692691,3.6096727125692691,3.6096727125692691,3.6096727125692691,3.6096727125692691,3.6096727125692691,3.6096727125692691]
[null,"wenn Ɣ = 1","dann"," = a / (a+1)"]
[null,"wenn Ɣ  1","dann"," = 1 - Ɣa / 1 - Ɣa+1",null,null,null,null,null,null,"",{"$f":"IF(L58=1,L60/(L60+1),(1-L58^L60)/(1-L58^(L60+1)))","v":0.99271909642093981},{"$f":"IF(M58=1,M60/(M60+1),(1-M58^M60)/(1-M58^(M60+1)))","v":0.98751784904782025},0.96568246113171241,0.77094818252612063,0.57978930650493876,0.3120813818395724,9.3482703521158478E-2,7.6720696023660273E-2,0.51299404485845501,0.89986000497883756,0.97787849994294274,0.99276126314181989]
[]
[]
["Heizwärmebedarf"]
[null,null,null,null,null,null,null,null,null,null,null,"J","F","M","A","M","J","J","A","S","O","N","D"]
[null,"nutzbare Solargewinne",null,null,null,null,null,null,{"$f":"SUM(L67:W67)","v":3953.6367429056468},null,"Qs",{"$f":"SUM(L41:L44)*L62","v":277.86495155930777},{"$f":"SUM(M41:M44)*M62","v":308.68951541515366},456.90918407575049,690.13904398619479,526.78913704911656,310.65681456848137,99.560103814481465,62.960420134782403,358.43789429496576,421.84117799766648,272.80514027106011,166.98335973868618]
[null,"nutzbare interne Gewinne",null,null,null,null,null,null,{"$f":"SUM(L68:W68)","v":4770.1342249320624},null,"Qi",{"$f":"L35*L62","v":593.12351586138846},{"$f":"M35*M62","v":532.91759390348409},576.96983831290197,445.7624858400215,346.4088413055249,180.44555484568301,55.853453393412281,45.838595357886547,296.61332089525314,537.64265426176451,565.40966158812967,593.14870936661146]
[null,"Transmission",null,null,null,null,null,null,{"$f":"SUM(L69:W69)","v":12721.879290239998},null,"QT",{"$f":"L17","v":2190.5107358400001},{"$f":"M17","v":1793.3436057599999},1607.8132987200001,992.0476080000002,658.23229007999987,344.60601120000018,107.90693279999999,75.534852959999938,480.35989440000009,1068.2786347200004,1493.2927152000002,1909.9527105599998]
[null,"Lüftung",null,null,null,null,null,null,{"$f":"SUM(L70:W70)","v":6256.8523328678421},null,"QV",{"$f":"L27","v":1077.3331435574403},{"$f":"M27","v":881.99910306816025},790.75191325152025,487.9071125280002,323.73064904928009,169.4835232992001,53.070598204800021,37.149418743359973,236.24975975040007,525.39892222752019,734.42860096320032,939.34958822496026]
[null,"Heizwärmebedarf",null,null,null,{"$f":"I71/C35","v":54.156367682610252},"kWh/(m²*a)",null,{"$f":"SUM(L71:W71)","v":8698.1192011452531},null,"Qh",{"$f":"(L69+L70-K138-K196)-(L67+L68)","v":1848.1358845385914},{"$f":"(M69+M70-L138-L196)-(M67+M68)","v":1741.6027435936162},1280.0537012091484,279.1794232974637,4.6393859713184611,-69.148370128011379,-88.079498872030527,-95.667576509182268,-25.115296129210833,535.42017148301784,1297.1344820820068,1989.9641506085247]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Brennstoff",null,"Gewinn","Hilfsenergie",null,"Deckung"]
[null,null,null,null,null,"Nutzenergie Warmwasser",null,null,{"$f":"C35*12.5","v":2007.6400000000003},null,null,"spezifisch","absolut"]
[]
[null,null,null,null,null,"Aufwand Warmwasser",null,null,null,null,"Verteilung",9.0665536000000007,{"$f":"L82*Transmission!G3+I80","v":3463.8300535603207},4.163888,0.78604415999999988]
[]
[null,null,null,null,null,null,null,null,null,null,"Speicherung",2.3938879999999996,2069.9232014538138,1.0575551999999999,7.7877760000000004E-2,null,0.53787775999999998]
[]
[null,null,null,null,null,null,null,null,null,null,"Erzeugung",1.1278777599999998,{"$f":"M84*L86","v":2334.6203438277557},null,0.85755519999999996]
[]
[null,null,null,null,null,null,null,null,null,null,"gesamt",null,{"$f":"M86","v":2334.6203438277557},{"$f":"(N82+N84)*Transmission!G3","v":838.62225808384005},{"$f":"(O82+O84+O86)*Transmission!G3","v":276.48850601574401}]
[]
[]
[null,null,null,null,null,"Aufwand Lüftungsanlage",null,null,null,null,"Verteilung",0,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,"Erzeugung",0,null,0,1.1000000000000001]
[]
[null,null,null,null,null,null,null,null,null,null,"gesamt",{"$f":"(L91+L93)*Transmission!D3","v":0},null,{"$f":"(N91+N93)*Transmission!F3","v":0},{"$f":"(O91+O93)*Transmission!G3","v":176.67232000000004}]
[]
[]
[null,null,null,null,null,"Nutzenergie Heizung",null,null,{"$f":"I71","v":8698.1192011452531}]
[null,null,null,null,null,"abzgl. Rückgewinn",null,null,{"$f":"N88+N95","v":838.62225808384005}]
[null,null,null,null,null,"Netto Nutzenergie Heizung",null,null,{"$f":"I98-I99","v":7859.4969430614128}]
[]
[null,null,null,null,null,"Aufwand Heizung",null,null,null,null,"Übergabe",1.1000000000000001,{"$f":"L102*Transmission!G3+I100","v":8036.1692630614125},null,0]
[]
[null,null,null,null,null,null,null,null,null,null,"Verteilung",1.7575551999999999,{"$f":"M102+L104*Transmission!G3","v":8318.4523127996526},null,1.2884550399999999]
[]
[null,null,null,null,null,null,null,null,null,null,"Erzeugung",0.96,{"$f":"M104*L106","v":7985.7142202876666},null,0.64302207999999994]
[]
[null,null,null,null,null,null,null,null,null,null,"gesamt",null,{"$f":"M106","v":7985.7142202876666},null,{"$f":"(O102+O104+O106)*Transmission!G3","v":310.21685801574404}]
[]
[null,null,null,null,null,null,null,null,null,null,"Nutzenergie",null,null,null,{"$f":"I80+I98","v":10705.759201145254}]
[null,null,null,null,null,null,null,null,null,null,"Endenergie",null,{"$f":"M88+M95+M108","v":10320.334564115423},null,{"$f":"O88+O95+O108","v":763.37768403148812},null,2009,{"$f":"Primärenergie!K40","v":false}]
[null,null,null,null,null,null,null,null,null,null,"PE-Faktor",null,1.1000000000000001,null,{"$f":"IF(R111=TRUE,2.6,IF(R112=TRUE,2.4,IF(R113=TRUE,1.8)))","v":1.8},null,2013,{"$f":"Primärenergie!K41","v":false}]
[null,null,null,null,null,null,null,null,null,null,"PE",null,{"$f":"M111*M112","v":11352.368020526967},null,{"$f":"O111*O112","v":1374.0798312566787},null,2016,{"$f":"Primärenergie!K42","v":true}]
[null,null,null,null,null,null,null,null,null,null,"gesamt",null,null,null,{"$f":"M113+O113","v":12726.447851783645}]
[null,null,null,null,null,null,null,null,null,null,"gesamt spezifisch",null,null,null,{"$f":"IF(R111=TRUE,O114/Transmission!G3,IF(R112=TRUE,O114/Transmission!G3,IF(R113=TRUE,O114/Transmission!G3*0.75)))","v":59.428208548580258}]
[null,null,null,null,null,null,null,null,null,null,"ep",null,null,null,{"$f":"O114/O110","v":1.188747814393418}]
[]
[]
[]
[]
[]
[null,"Einfluss Nachtabsenkung"]
[]
[null,null,null,null,null,null,null,null,null,null,"J","F","M","A","M","J","J","A","S","O","N","D"]
[null,null,null,"Außentemperatur",null,null,null,"q e","°C",null,{"$f":"L21","v":-1.3},{"$f":"M21","v":0.6},4.0999999999999996,9.5,12.9,15.7,18,18.3,14.4,9.1,4.7,1.3]
[null,null,null,"niedrigste  Innentemperatur ",null,null,null,"q inh ","°C",null,{"$f":"K125","v":-1.3},{"$f":"L125","v":0.6},4.0999999999999996,9.5,12.9,15.7,18,18.3,14.4,9.1,4.7,1.3]
[null,null,null,"niedrigste Bauteiltemperatur",null,null,null,"q cnh ","°C",null,{"$f":"K125+$P$176*(K126-K125)","v":-1.3},{"$f":"L125+$P$176*(L126-L125)","v":0.6},4.0999999999999996,9.5,12.9,15.7,18,18.3,14.4,9.1,4.7,1.3]
[null,null,null,"Innentemp. am Ende der nicht Heizph.",null,null,null,"q i1 ","°C",null,{"$f":"K126+$P$177*(K135-K127)*EXP(-K129/$P$179)","v":15.160137317374705},{"$f":"L126+$P$177*(L135-L127)*EXP(-L129/$P$179)","v":15.519533332004656},16.181578622112468,17.203019926850232,17.846149637240675,18.375785869326922,18.810844202826342,18.867590941978438,18.129883333001164,17.12735760798077,16.295072100416665,15.651942390026221]
[null,null,null,"Zeit in der nicht geheizt wird  ",null,null,null,"tnh ","h",null,{"$f":"$P$142","v":7},{"$f":"$P$142","v":7},7,7,7,7,7,7,7,7,7,7]
[null,null,null,"Zeit mit abgesenkten Regelbetrieb",null,null,null,"tsb","h",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"höchst mögliche Innentemperatur",null,null,null,"q ipp","°C",null,{"$f":"K125+($P$144+$P$146)/$P$150","v":43.642408142593993},{"$f":"L125+($P$144+$P$146)/$P$150","v":45.542408142593992},49.042408142593992,54.44240814259399,57.842408142593989,60.642408142593993,62.94240814259399,63.242408142593987,59.342408142593989,54.042408142593992,49.642408142593993,46.242408142593987]
[null,null,null,"höchst mögliche Bauteiltemperatur",null,null,null,"q cpp","°C",null,{"$f":"K125+$P$176*(K131-K125)","v":42.877571567536997},{"$f":"L125+$P$176*(L131-L125)","v":44.777571567536995},48.277571567536995,53.677571567536994,57.077571567536992,59.87757156753699,62.177571567536994,62.477571567536998,58.577571567536992,53.277571567536995,48.877571567536997,45.477571567536991]
[null,null,null,"Bauteiltemperatur Ende nicht Heizph.",null,null,null,"q c1","°C",null,{"$f":"K127+(K128-K126)/$P$177","v":15.600681064030976},{"$f":"L127+(L128-L126)/$P$177","v":15.918843920106891},16.504933391825691,17.409185719620407,17.978529777861525,18.447401355236561,18.832545865223203,18.88278210565624,18.229710980026724,17.342204065709691,16.605405872691772,16.036061814450655]
[null,null,null,"Zeit der Aufheizphase",null,null,null,"tbh","h",null,{"$f":"IF(SUM($P$179*LN($P$177*(K132-K133)/(K131-$P$182)))>0,$P$179*LN($P$177*(K132-K133)/(K131-$P$182)),0)","v":3.1673854293246233},{"$f":"IF(SUM($P$179*LN($P$177*(L132-L133)/(L131-$P$182)))>0,$P$179*LN($P$177*(L132-L133)/(L131-$P$182)),0)","v":2.4129355333010132},1.2467120503688163,0,0,0,0,0,0,0,1.0707529309864083,2.158477480669426]
[null,null,null,"Bauteiltemperatur beginn Absenkung",null,null,null,"q co","°C",null,{"$f":"K125+$P$176*($P$182-K125)","v":18.654531585748693},{"$f":"L125+$P$176*($P$182-L125)","v":18.686866067870735},18.746429587569239,18.838327589389781,18.896189294239754,18.943840109998554,18.982981851514715,18.9880872960603,18.921716516967685,18.831520329995669,18.756640476660408,18.698778771810435]
[null,null,null,"Bauteiltemperatur ende Aufheizph.",null,null,null,"q c3","°C",null,{"$f":"IF(K134>0,K132+($P$182-K131)/$P$177,K133)","v":17.575627079622716},{"$f":"IF(L134>0,L132+($P$182-L131)/$P$177,L133)","v":17.524774945007572},17.431099960190199,17.409185719620407,17.978529777861525,18.447401355236561,18.832545865223203,18.88278210565624,18.229710980026724,17.342204065709691,17.415041391364365,17.506039948044098]
[null,null,null,"Berechnung der täglichen Reduzierung ",null,null,null,"DQilj","kWh/d",null,{"$f":"($P$150*(($P$182-K126)*K129+($P$182-$P$143)*K130+($P$182-K131)*K134)-$P$147*$P$176*(K135-K133+K133-K136))/1000","v":4.2765607949660769},{"$f":"($P$150*(($P$182-L126)*L129+($P$182-$P$143)*L130+($P$182-L131)*L134)-$P$147*$P$176*(L135-L133+L133-L136))/1000","v":3.6907580904731931},2.7823037996849469,1.6967662512724546,1.0895025402907359,0.58940301359990921,0.17860697381815976,0.12502488167269815,0.82159207956349656,1.768209040799724,2.6450349061480192,3.4928002262736371]
[null,null,null,"Berechnung der monatl. Reduzierung ",null,null,null,"DQil","kWh/M",null,{"$f":"K137*L22","v":132.57338464394837},{"$f":"L137*M22","v":103.34122653324941},86.251417790233347,50.90298753817364,33.774578749012811,17.682090407997276,5.5368161883629528,3.8757713318536426,24.647762386904898,54.814480264791442,79.351047184440574,108.27680701448276,{"$f":"SUM(K138:V138)","v":701.02837003345121}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Dauer der Nachtabsenkung tu =",null,null,null,null,7,"h"]
[null,null,null,null,null,null,null,null,null,null,"Mindest- Innentemperatur qisb =",null,null,null,null,14,"°C"]
[null,null,null,null,null,null,null,null,null,null,"Nennleistung der Heizungsanlage Fpp = 1,5 x (HT+HV,n=0,5) x 31",null,null,null,null,{"$f":"1.5*(H17+P149)*31","v":9724.0831992000003},"W"]
[null,null,null,null,null,null,null,null,null,null,"Abschaltbetrieb =",null,null,null,null,"ja"]
[null,null,null,null,null,null,null,null,null,null,"Interne Wärmegewinne während der Nachtabsenkung Fg =",null,null,null,null,0,"W"]
[null,null,null,null,null,null,null,null,null,null,"Wirksame Wärmespeicherf. Cwirk,HU =",null,null,null,null,{"$f":"D58","v":9034.380000000001},"Wh/K"]
[null,null,null,null,null,null,null,null,null,null,"Lüftungswärmeverluste Hv =",null,null,null,null,{"$f":"H27","v":71.331449200000023},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Lüftungswärmeverluste Hv,n=0,5 =",null,null,null,null,{"$f":"0.5*C30*0.28*1.2","v":64.083868800000005},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Spezifischer Wärmeverlust Hsb = (HT + HV) =",null,null,null,null,{"$f":"H17+H27","v":216.36764920000002},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Spezifischer Wärmeverlust zwischen den Bauteilen Hic = 4 x AN/0,13 m²",null,null,null,null,{"$f":"4*C35/0.13","v":4941.8830769230772},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Spezif. Wärmeverlust leichter Bauteile Hw (Fenster, Türen, Paneele <60kg(m²))"]
[null,null,null,null,null,null,null,null,null,null,"Eingabe Bauteilnummer",null,"Name Bauteil",null,null,"HW"]
[null,null,null,null,null,null,null,null,null,null,3,null,"Dachfläche",null,null,{"$f":"H8","v":12.5},"W/K"]
[null,null,null,null,null,null,null,null,null,null,4,null,"Haustüre",null,null,{"$f":"H6","v":7.03},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Fenster",null,"Fenster Süd",null,null,{"$f":"H14","v":17.388000000000005},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster Ost",null,null,{"$f":"H12","v":6.5880000000000001},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster West",null,null,{"$f":"H13","v":10.044},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster Nord",null,null,{"$f":"H11","v":7.3845000000000001},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster <30°C",null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fenster ohne Gewinne",null,null,null,"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe HW =",null,null,{"$f":"SUM(P154:P172)","v":60.934500000000014},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Spezifischer Wärmeverlust zwischen den Innenbauteilen und außen Hce: "]
[null,null,null,null,null,null,null,null,null,null,"Hce = Hic x (Hsb - Hw - Hv) / (Hic - Hsb + Hw + Hv) = ",null,null,null,null,{"$f":"P151*(P150-P173-P148)/(P151-P150+P173+P148)","v":85.557734225107509},"W/K"]
[null,null,null,null,null,null,null,null,null,null,"Wirksamer Anteil der Wärmespeicherfähigkeit z = Hic / (Hic + Hce) =",null,null,null,null,{"$f":"P151/(P151+P175)","v":0.98298185151471384}," -----"]
[null,null,null,null,null,null,null,null,null,null,"Verhältniswert x = Hic / (Hic + Hw + Hv) =",null,null,null,null,{"$f":"P151/(+P151+P173+P148)","v":0.97393337315891593}," -----"]
[null,null,null,null,null,null,null,null,null,null,"Reaktionszeit der Bauteiltemperatur auf einen Wechsel der Heizleistung "]
[null,null,null,null,null,null,null,null,null,null," tp = z x C /(x . Hsb) =",null,null,null,null,{"$f":"P176*P147/(P177*P150)","v":42.142692476442228}]
[null,null,null,null,null,null,null,null,null,null,"Ansprechzeit der Bauteiltemperatur auf einen Wechsel der Lufttemperatur:"]
[null,null,null,null,null,null,null,null,null,null," tT = z x C /(Hce + Hic) =",null,null,null,null,{"$f":"P176*P147/(P175+P151)","v":1.766431851369586}]
[null,null,null,null,null,null,null,null,null,null,"normale Sollinnentemperatur q io =",null,null,null,null,19,"°C"]
[]
[null,"Solare Gewinne durch opake Bauteile"]
[]
[null,null,null,"Fläche","Strahlungsab-sorptionsgrad",null,"U-Wert","Formfaktor"]
[null,null,null,"m²","αi",null,"W/(m²*K)","Ff",null,null,"gesamt","J","F","M","A","M","J","J","A","S","O","N","D"]
[null,{"$f":"B5","v":"Aussenwand"},"nord",{"$f":"A11","v":28.334492989892404},0.5,null,{"$f":"D5","v":0.28000000000000003},0.5,null,null,{"$f":"SUM(L188:W188)","v":13.389475996170855},{"$f":"$G188*$D188*$D$197*($E188*L47-$H188*$D$198*$D$199)*L$22*0.024","v":-3.0693736214202807},{"$f":"$G188*$D188*$D$197*($E188*M47-$H188*$D$198*$D$199)*M$22*0.024","v":-1.812682188332573},-0.7083169895585264,2.7418722176459087,4.8401660953165964,6.7404358683795254,7.0831698955852644,3.5415849477926322,0.9139574058819695,-0.82636982115161406,-2.5133828661754163,-3.5415849477926322]
[null,null,"ost",{"$f":"A12","v":25.278304532116074},0.5,null,{"$f":"D5","v":0.28000000000000003},0.5,null,null,{"$f":"SUM(L189:W189)","v":51.477467364371698},{"$f":"$G189*$D189*$D$197*($E189*L48-$H189*$D$198*$D$199)*L$22*0.024","v":-1.5797929200391267},{"$f":"$G189*$D189*$D$197*($E189*M48-$H189*$D$198*$D$199)*M$22*0.024","v":-0.28538194684577767},1.3691538640339096,8.6633805292468224,9.5840770482373667,11.211433626084123,12.217065248302578,7.8989646001956322,5.0961061936746015,1.1585148080286929,-1.2230654864819044,-2.6329882000652107]
[null,null,"west",{"$f":"A13","v":38.539054450603196},0.5,null,{"$f":"D5","v":0.28000000000000003},0.5,null,null,78.482040407976541,{"$f":"$G190*$D190*$D$197*($E190*L50-$H190*$D$198*$D$199)*L$22*0.024","v":-2.4085367469448977},{"$f":"$G190*$D190*$D$197*($E190*M50-$H190*$D$198*$D$199)*M$22*0.024","v":-0.43509050912552988},2.0873985140189113,13.208104741310729,14.611789598132381,17.092841429931536,18.626017509707211,12.042683734724489,7.7694733772416056,1.7662602810929251,-1.8646736105379855,-4.0142279115748298]
[null,null,"süd",{"$f":"A14","v":66.718148027388324},0.5,null,{"$f":"D5","v":0.28000000000000003},0.5,null,null,172.91806782568503,{"$f":"$G191*$D191*$D$197*($E191*L49-$H191*$D$198*$D$199)*L$22*0.024","v":4.4475918710609719},{"$f":"$G191*$D191*$D$197*($E191*M49-$H191*$D$198*$D$199)*M$22*0.024","v":5.2725484277900234},11.11897967765243,26.093734566103684,21.959984863363548,24.210681556178677,26.407576734424524,20.014163419774373,20.17556796348223,11.396954169593741,3.766106019850016,-1.945821443589175]
[null,{"$f":"B6","v":"Haustür"},"nord",{"$f":"C6","v":3.8},0.5,null,{"$f":"D6","v":1.8},0.5,null,null,11.5437312,{"$f":"$G192*$D192*$D$197*($E192*L47-$H192*$D$198*$D$199)*L$22*0.024","v":-2.6462592000000003},{"$f":"$G192*$D192*$D$197*($E192*M47-$H192*$D$198*$D$199)*M$22*0.024","v":-1.5628032000000001},-0.61067520000000008,2.3639039999999998,4.1729472000000003,5.8112640000000004,6.1067520000000002,3.0533760000000001,0.787968,-0.71245440000000004,-2.1669120000000004,-3.0533760000000001]
[null,"Dach","ost",25,0.8,null,{"$f":"D8","v":0.2},1,null,null,44.167680000000004,{"$f":"$G193*$D193*$D$197*($E193*L48-$H193*$D$198*$D$199)*L$22*0.024","v":-2.976},{"$f":"$G193*$D193*$D$197*($E193*M48-$H193*$D$198*$D$199)*M$22*0.024","v":-1.3977599999999997},0.35712000000000088,8.64,9.6422400000000028,11.52,12.618240000000002,7.7376000000000014,4.6080000000000005,0.11904000000000065,-2.5343999999999998,-4.1664000000000003]
[null,null,"west",25,0.8,null,{"$f":"D8","v":0.2},1,null,null,44.167680000000004,{"$f":"$G194*$D194*$D$197*($E194*L50-$H194*$D$198*$D$199)*L$22*0.024","v":-2.976},{"$f":"$G194*$D194*$D$197*($E194*M50-$H194*$D$198*$D$199)*M$22*0.024","v":-1.3977599999999997},0.35712000000000088,8.64,9.6422400000000028,11.52,12.618240000000002,7.7376000000000014,4.6080000000000005,0.11904000000000065,-2.5343999999999998,-4.1664000000000003]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K188:K194)","v":416.14614279420414},{"$f":"SUM(L188:L194)","v":-11.208370617343334},-1.6189294165138566,13.970779866146724,70.350996054307146,74.453444805049898,88.106656480573847,95.677061388019581,62.025972702487124,43.959072940280407,13.020985037563745,-9.0707279433452896,-23.520798503021847]
[null,"Durchlasswiderstand",null,0.04]
[null,"Abstrahlungskoeffizient hr",null,4]
[null,"Temperaturdifferenz ∆θer",null,10]