{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Eingabe","Daten","Zwischenergebnisse","SOLCAL","Datenblatt_1","Datenblatt_2","Datenblatt_3","Datenblatt_4","Datenblatt_5","Datenblatt_6","Label_1","Label_2","Label_3"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":83,"comments":4,"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":"Eingabe","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Eco-Design Daten Eingabe"]
["Verbundanlage:"]
["Heizkessel, Zusatzheizkessel, Solaranlage"]
["Typenbezeichnung",null,"Type"]
["Hersteller",null,"Hersteller"]
[{"$f":"VLOOKUP(A3,Daten!B2:C7,2,FALSE)","v":"Nennheizleistung des Heizkessels in kW"},"Prated",15,null,{"$f":"IF(C6>70,\"Achtung! Kein Label erforderlich!\",\"\")","v":""}]
["Ist die Warmwasserbereitungs-Energieeffizienz des Kessels hwh bekannt?",null,"JA"]
["Warmwasserbereitungs-Energieeffizienz","hwh",0.84,null,"hwh,calc",{"$f":"IF(l_Blatt<3,Zwischenergebnisse!E52,Zwischenergebnisse!H52)","v":0.84117076544017388}]
["Nennleistung bei Hochtemperaturbetrieb in kW","P4",10]
["Wärmeverlust im Bereitschaftszustand in kW","Pstby",0.05]
["Hilfsstromverbrauch bei Vollast in kW","elmax",0.12]
["Hilsstromverbrauch im Bereitschaftszustand in kW","PSB",5.0000000000000001E-3]
["Energieeffizienz bei Nennleistung und Hochtemperaturbetrieb in %","h4",0.95]
["Raumheizungs-Energieeffizienz in %","hs",0.95]
["Raumheizungs-Energieeffizienz bei kälteren Klimaverhältnissen","hs, kalt",1.06]
["Raumheizungs-Energieeffizienz bei wärmeren Klimaverhältnissen","hs, warm",1.06]
["COP der Wärmepumpe","COPN",4]
["Betriebsart der Wärmepumpe",null,"Außenluft mittel"]
["Ist ein Zusatzheizkessel vorhanden?",null,"NEIN"]
["Nennheizleistung des Zusatzheizkessels in kW","Psup",10]
["Raumheizungs-Energieeffizienz des Zusatzheizkessels ηs sup in %","ηs sup",0.98]
["Ist eine Zusatzwärmepumpe vorhanden?",null,"NEIN"]
["Nennheizleistung der Zusatzwärmepumpe in kW","Psup,wp",12]
["Raumheizungs-Energieeffizienz der Zusatzwärmepumpe ηs sup in %","ηs sup,wp",1.2]
["Temperaturregelung, Reglerklasse",null,"VI",null,{"$f":"VLOOKUP(C25,Daten!A10:B18,2,FALSE)","v":"Witterungsgeführte Regelung, Raumaufschaltung, modulierend"}]
["Ist eine Solaranlage vorhanden?",null,"NEIN"]
["Speichervolumen in Liter","V",300]
["Stillstandswärmeverlustverlust des Speichers in W","S",60,"oder",1.44,"kWh/24h",{"$f":"(16.66+8.33*C27^0.4)*24/1000","v":2.3573534060320647},"kWh/24h"]
["Kollektor-Aperturfläche in m²","Aap",2.2599999999999998,"Asol",{"$f":"Aap*_n","v":6.7799999999999994},"m²"]
["Anzahl der Kollektoren","n",3]
["Kollektorwirkungsgrad in %","h0,col",0.82]
["Wärmedurchgangskoeffizient in W/m²K","a1",3.8210000000000002]
["temperaturabhängiger Wärmedurchgangskoeffizient in W/m²K²","a2",1.0800000000000001E-2]
["Winkelkorrekturfaktor","IAM",0.96]
["Leistung der Solar-Umwälzpumpe in W","solpump",35]
["Standby-Leistung der Solar-Regler in W","solstdby",4]
["mittlere Umgebungstemperatur am Speicher in °C","Ta",20]
["Zapfprofil des Speichers",null,"XL",null,{"$f":"VLOOKUP(C38,Daten!A19:B28,2,FALSE)","v":"bis zu 3 Bäder mit Badewanne, Dusche und Waschbecken mit 55°C"}]
[]
[]
[]
[]
[]
["Bitte alle blau hinterlegten Felder ausfüllen bzw. den geeigneten Wert auswählen."]

{"sheet":"Daten","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Blatt","Art der Verbund-Anlage","Text 1","Text 2"]
[1,"Heizkessel, Zusatzheizkessel, Solaranlage","Nennheizleistung des Heizkessels in kW","Jahreszeitbedingte Raumheizungs-Energieeffizienz des Heizkessels"]
[2,"Kraft-Wärme-Kopplung, Solaranlage","Nennheizleistung der KWK-Anlage in kW","Jahreszeitbedingte Raumheizungs-Energieeffizienz des Raumheizgeräts mit Kraft-Wärme-Kopplung"]
[3,"Wärmepumpe, Zusatzheizkessel, Solaranlage","Nennheizleistung der Wärmepumpe in kW","Jahreszeitbedingte Raumheizungs-Energieeffizienz der Wärmepumpe"]
[4,"Niedertemperatur-Wärmepumpe, Zusatzheizkessel, Solaranlage","Nennheizleistung der Niedertemperatur-Wärmepumpe in kW","Jahreszeitbedingte Raumheizungs-Energieeffizienz der Niedertemperatur-Wärmepumpe"]
[5,"Zusatzdatenblatt für Warmwasserbereitung",null,"Warmwasserbereitungs-Energieeffizienz des Kombi-Heizgerätes"]
[6,"Warmwasserbereiter, Solaranlage (ohne Heizung)"]
[]
["Klasse","Regelungstyp","Faktor in %"]
["k.a.","keine Angabe",0]
["I","Raumthermostat, ON/OFF",0.01]
["II","Witterungsgeführte Regelung, modulierend",0.02]
["III","Witterungsgeführte Regelung, ON/OFF",1.4999999999999999E-2]
["IV","Raumthermostat, TPI",0.02]
["V","Raumthermostat, modulierend",0.03]
["VI","Witterungsgeführte Regelung, Raumaufschaltung, modulierend",0.04]
["VII","Witterungsgeführte Regelung, Raumaufschaltung, stufiges Output",3.5000000000000003E-2]
["VIII","Multi-Sensor-Raumregelung mit mindestens 3 Sensoren",0.05]
[]
["Zapfprofil","Typische Anwendung","Qref in kWh"]
["3XS","Kleines Einzelwaschbecken mit 35°C",0.34499999999999997]
["XXS","Einzelwaschbecken mit 35°C",2.1]
["XS","Dusche klein",2.1]
["S","Dusche und Einzelwaschbecken mit 35°C",2.1]
["M","Duschen und Spüle mit 55°C",5.8449999999999998]
["L","Badewanne, Dusche und Waschbecken mit 55°C",11.654999999999999]
["XL","bis zu 3 Bäder mit Badewanne, Dusche und Waschbecken mit 55°C",19.07]
["XXL","bis zu 3 simultan benützte Bäder mit Badewanne, Dusche und Waschbecken mit 55°C",24.53]
[]
["Frage"]
["JA"]
["NEIN"]
[]
[{"$f":"ISERROR(SEARCH(\"Wärmepumpe\",Eingabe!A3))","v":true}]

{"sheet":"Zwischenergebnisse","index":2,"n_rows":82,"n_cols":15,"rows_kept":82,"cut":false,"hidden":true,"merged":[[28,0,28,4]]}
[]
["Profil","Qref","k","V40,min","A+++","A+++","A++","A+","A","B","C","D","E","F","G"]
["3XS",0.34499999999999997,0.23,null,10,0.62,0.53,0.44,0.35,0.32,0.28999999999999998,0.26,0.22,0.19]
["XXS",2.1,0.23,null,10,0.62,0.53,0.44,0.35,0.32,0.28999999999999998,0.26,0.23,0.2]
["XS",2.1,0.23,null,10,0.69,0.61,0.53,0.38,0.35,0.32,0.28999999999999998,0.26,0.23]
["S",2.1,0.23,null,10,0.9,0.72,0.55000000000000004,0.38,0.35,0.32,0.28999999999999998,0.26,0.23]
["M",5.8449999999999998,0.23,65,10,1.63,1.3,1,0.65,0.39,0.36,0.33,0.3,0.27]
["L",11.654999999999999,0.23,130,10,1.88,1.5,1.1499999999999999,0.75,0.5,0.37,0.34,0.3,0.27]
["XL",19.07,0.23,210,10,2,1.6,1.23,0.8,0.55000000000000004,0.38,0.35,0.3,0.27]
["XXL",24.53,0,300,10,2.13,1.7,1.31,0.85,0.6,0.4,0.36,0.32,0.28000000000000003]
[]
["Label für Speicher"]
["Volumen","V",{"$f":"Vnom","v":300},"l"]
["Wärmeverlust","S",{"$f":"SWV_W","v":60},"W",{"$f":"SWV_KW","v":1.44}]
["Ergebnis",null,{"$f":"HLOOKUP(C14,B19:I21,3,1)","v":"B"},{"$f":"HLOOKUP(C14,B19:I22,4,1)","v":5}]
["Tankeinstufung",null,{"$f":"HLOOKUP(C14,B19:I21,2,1)","v":0.86},null,null,null,null,null,null,null,null,null,"B"]
[]
[null,null,{"$f":"C19*24/1000","v":0.87458611801456509},{"$f":"D19*24/1000","v":1.2027313296081965},1.6815239493121426,2.3573534060320647,2.9315046199653345,3.8340399911642269,4.6590268120641305,"kWh/24h"]
["S größer als",0,{"$f":"5.5+3.16*$C$13^0.4","v":36.441088250606875},{"$f":"8.5+4.25*$C$13^0.4","v":50.113805400341519},{"$f":"12+5.93*$C$13^0.4","v":70.063497888005941},{"$f":"16.66+8.33*$C$13^0.4","v":98.223058584669374},{"$f":"21+10.33*$C$13^0.4","v":122.14602583188892},{"$f":"26+13.66*$C$13^0.4","v":159.75166629850946},{"$f":"31+16.66*$C$13^0.4","v":194.12611716933876},"W"]
["Tankeinstufung",0.95,0.91,0.86,0.83,0.81,0.81,0.81,0.81,"%"]
["Label","A+","A","B","C","D","E","F","G"]
["Label-Einstufung",7,6,5,4,3,2,1,0]
[]
["Suchkriterien"]
[{"$f":"Daten!B1","v":"Art der Verbund-Anlage"}]
[{"$f":"Eingabe!A3","v":"Heizkessel, Zusatzheizkessel, Solaranlage"}]
["Gewähltes Blatt:",{"$f":"DGET(Daten!A1:D7,\"Blatt\",A25:A26)","v":1}]
[]
["Gewichtung des Vorzugsraumheizgerätes \nund des Zusatzheizgerätes",null,null,null,null,null,"Zuletzt verwendetes Datenblatt",null,null,1,null,"Korrekturfaktor für Wärmepumpen","f"]
[null,"Warmwasserspeicher",null,null,null,null,"Solare Anlage vorhanden?",null,null,"JA",null,"Außenluft mittel",0.91900000000000004]
[null,"Blatt 1",null,"Blatt 2 bis 4",null,null,"Temperaturregler?",null,null,"JA",null,"Außenluft kälter",0.84]
["Psup/(Prated+Psup)","ohne","mit","ohne","mit",null,"Zusatzheizkessel oder WP?",null,null,null,null,"Außenluft wärmer",1.0589999999999999]
[0,0,0,1,1,null,"Errechnete Effizienz",null,null,99,null,"Innenluft",0.88800000000000001]
[0.1,0.3,0.37,0.7,0.63,null,"Label",null,null,7,null,"Sole",0.93100000000000005]
[0.2,0.55000000000000004,0.7,0.45,0.3,null,null,null,null,null,null,"Wasser",0.91400000000000003]
[0.3,0.75,0.85,0.25,0.15]
[0.4,0.85,0.94,0.15,0.06]
[0.5,0.95,0.98,0.05,0.02]
[0.6,0.98,1,0.02,0]
[0.7,1,1,0,0]
[]
["Kennwerte",null,null,"Bei Öl oder Gasbetrieb",null,null,"Bei Wärmepumpenbetrieb"]
["Qref",{"$f":"VLOOKUP(Eingabe!C38,A3:B10,2,FALSE)","v":19.07},"kWh","P4",{"$f":"Eingabe!C9","v":10},"kW","COPN",{"$f":"Eingabe!C17","v":4}]
["Prated",{"$f":"Prated","v":15},"kW","Pstby",{"$f":"Eingabe!C10","v":0.05},"kW","f",{"$f":"VLOOKUP(Eingabe!C18,Zwischenergebnisse!L30:M35,2,0)","v":0.91900000000000004},{"$f":"Eingabe!C18","v":"Außenluft mittel"}]
["Psup",{"$f":"IF(ZusatzHK=\"JA\",Eingabe!C20,0)+IF(ZusatzWP=\"JA\",Eingabe!C23,0)","v":0},"kW","PSB",{"$f":"Eingabe!C12","v":5.0000000000000001E-3},"kW"]
["Psup/(Prated+Psup)",{"$f":"Psup/(Prated+Psup)","v":0},null,"elmax",{"$f":"Eingabe!C11","v":0.12},"kW"]
["Qnonsol,avg",{"$f":"Qnonsolavg","v":1496.6195725399048},"kWh","h4",{"$f":"Eingabe!C13","v":0.95}]
["Qaux",{"$f":"(solpump*solhrs+solstdby*24*365)/1000","v":105.04},"kWh","ton",{"$f":"(B43+(24-B43/E43)*E44)/E43","v":2.0174650000000001},"h"]
["hwh,nonsol",{"$f":"E52","v":0.84117076544017388},null,"Qelec",{"$f":"(24-E48)*E45+E48*E46","v":0.35200847499999999},"kWh"]
["Qtota",{"$f":"B47/(1.1*E52-0.1)+2.5*B48","v":2076.0516182156152},"kWh","Qfuel",{"$f":"E48*E43/E47","v":21.236473684210527},"kWh"]
["Zeile",{"$f":"MATCH(B46,A33:A40,1)","v":1},null,"k",{"$f":"IF(B43<24,0.23,0)","v":0.23}]
["Spalte",{"$f":"IF(Blattnr<=2,IF(Solaranlage=\"JA\",3,2),IF(Blattnr<5,IF(Solaranlage=\"JA\",5,4),IF(l_Blatt<=2,3,5)))","v":2},null,"hwh_calc",{"$f":"0.95*B43/((1-E51)*E50+(2.5-E51)*E49+E51*B43)","v":0.84117076544017388},null,"hwh_calc",{"$f":"0.95*H44*H43/2.5*B43/(B43+E14)","v":1.2988055387615796},null,null,null,null,null,null,"Energieeffizienz bei Wärmepumpen"]
[]
["Blatt",1,2,3,4,5,6]
["Interpolation"]
["x1",{"$f":"INDEX(A33:A40,B51,1)","v":0}]
["x2",{"$f":"INDEX(A33:A40,B51+IF(B51=8,0,1),1)","v":0.1}]
["y1",{"$f":"INDEX(A33:E40,B51,B52)","v":0}]
["y2",{"$f":"INDEX(A33:E40,B51+IF(B51=8,0,1),B52)","v":0.3}]
[]
["Blatt",1,2,3,4,5,6]
["\"I\"",{"$f":"Eingabe!$C$14","v":0.95},{"$f":"B62","v":0.95},{"$f":"B62","v":0.95},{"$f":"B62","v":0.95},{"$f":"IF(l_Blatt<3,IF(Eingabe!C7=\"JA\",Eingabe!C8,Zwischenergebnisse!E52),IF(Eingabe!C7=\"JA\",Eingabe!C8,H52))","v":0.84},{"$f":"F62","v":0.84}]
["\"II\"",{"$f":"B58+(B59-B58)*(B46-B56)/(B57-B56)","v":0},{"$f":"B63","v":0},{"$f":"B63","v":0},{"$f":"B63","v":0},{"$f":"IF(Eingabe!C26=\"JA\",220*B43/B47,0)","v":0},{"$f":"F63","v":0}]
["\"III\"",{"$f":"294/11/B44","v":1.7818181818181817},{"$f":"B64","v":1.7818181818181817},{"$f":"B64","v":1.7818181818181817},{"$f":"B64","v":1.7818181818181817},{"$f":"IF(Eingabe!C26=\"JA\",2.5*B48/(220*B43),0)","v":0},{"$f":"F64","v":0}]
["\"IV\"",{"$f":"115/11/B44","v":0.69696969696969702},{"$f":"B65","v":0.69696969696969702},{"$f":"B65","v":0.69696969696969702},{"$f":"B65","v":0.69696969696969702}]
["\"V\"",null,null,{"$f":"ABS(Eingabe!C15-Eingabe!C14)","v":0.1100000000000001},{"$f":"D66","v":0.1100000000000001}]
["\"VI\"",null,null,{"$f":"ABS(Eingabe!C16-Eingabe!C14)","v":0.1100000000000001},{"$f":"D67","v":0.1100000000000001}]
[]
[]
["Kessel-Label"]
["WW-Label"]
[null,null,"Textlänge"]
[9,"A+++",{"$f":"LEN(B73)","v":4}]
[8,"A++",{"$f":"LEN(B74)","v":3}]
[7,"A+",2]
[6,"A",1]
[5,"B",1]
[4,"C",1]
[3,"D",1]
[2,"E",1]
[1,"F",1]
[0,"G",1]

{"sheet":"SOLCAL","index":3,"n_rows":102,"n_cols":15,"rows_kept":102,"cut":false,"hidden":true,"merged":[[93,1,95,1],[99,1,101,1],[69,1,71,1],[75,1,77,1],[81,1,83,1],[87,1,89,1],[49,1,51,1],[57,1,59,1],[63,1,65,1],[22,1,24,1],[28,1,30,1],[36,1,38,1],[42,1,44,1]]}
["Calculation of Qnonsol and Qaux with the SOLCAL-Method"]
[null,"Table 3 (annex VII)"]
["Load profiles of water heaters ",null,null,"M","L","XL","XXL"]
["Typical daily heat withdrawal","Qref","kWh/day",5.8449999999999998,11.654999999999999,19.07,24.53]
[]
[null,"Position"]
[null,"inside"]
[null,"outside"]
[]
["specific standing loss of the tank","psbsol",{"$f":"SWV_W/(65-20)","v":1.3333333333333333},"W/K","psbsol = SWV_W/(65-20)"]
["total collector apperture","Asol",{"$f":"Asol","v":6.7799999999999994},"m²","Asol = Aap x n"]
["loop losses in W/(m2K)","UL",{"$f":"(6+0.3*Asol)/Asol","v":1.1849557522123892},"W/m²K","UL = (6 + 0,3 × Asol) / Asol"]
["loop efficiency","etaloop",{"$f":"1-(eta0*_a1)/100","v":0.96866779999999997},null,"etaloop=1 - (η0 × a1) / 100"]
[null,"Ac",{"$f":"_a1+40*_a2","v":4.2530000000000001},null,"Ac = a1 + а2 × 40"]
["storage coefficient","ccap",{"$f":"(75*Asol/Vnom)^0.25","v":1.1410178160875288},null,"ccap = (75 × Asol / Vnom)^0,25"]
["number of active solar hours in h","solhrs",2000,"h"]
["cold water temperature","Tcold",10,"°C"]
["heat demand for the solar thermal system","Lwh,tm",{"$f":"(Qref+1.09)*0.6*30.5","v":368.928},"kWh/month",null,"Lwh,tm = 30,5 × 0,6 × (Qref + 1,09)"]
[]
[null,"Touttm (monthly average daytime temperature in °C)"]
[null,"Table 4 (annex VII)"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",2.8,2.6,7.4,12.2,16.3,19.8,21,22,17,11.9,5.6,3.2]
[null,null,"Colder",-3.8,-4.0999999999999996,-0.6,5.2,11,16.5,19.3,18.399999999999999,12.8,6.7,1.2,-3.5]
[null,null,"Warmer",9.5,10.1,11.6,15.3,21.4,26.5,28.8,27.9,23.6,19,14.5,10.4]
[]
[null,"Trefw (monthly average reference temperature)",null,null,null,null,"Trefw = 97,4 - 1,32 x Tout,tm"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"97.4-1.32*D23","v":93.704000000000008},{"$f":"97.4-1.32*E23","v":93.968000000000004},87.632000000000005,81.296000000000006,75.884,71.26400000000001,69.680000000000007,68.36,74.960000000000008,81.692000000000007,90.00800000000001,93.176000000000002]
[null,null,"Colder",{"$f":"97.4-1.32*D24","v":102.41600000000001},102.81200000000001,98.192000000000007,90.536000000000001,82.88000000000001,75.62,71.924000000000007,73.112000000000009,80.504000000000005,88.556000000000012,95.816000000000003,102.02000000000001]
[null,null,"Warmer",{"$f":"97.4-1.32*D25","v":84.86},84.068000000000012,82.088000000000008,77.204000000000008,69.152000000000001,62.42,59.384,60.572000000000003,66.248000000000005,72.320000000000007,78.260000000000005,83.671999999999997]
[]
[null,"xa",{"$f":"(Asol*(Ac+UL)*etaloop*ccap*0.732)/Lwhtm","v":8.0854112776072823E-2},null,"xa = (Asol × (Ac + UL) × etaloop × ccap × 0,732) / Lwh,tm"]
[]
[null,"(Xtm)","Xtm = xa x (Trefw — Touttm)",null,null,null,"(Xtm) = xa x (97,4 - 2,32 x Tout,tm)"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"xa*(D29-D23)","v":7.3499622677961245},7.3874785761242228,6.487087176249875,5.5866957763755281,4.8176114556495238,4.1610760599078125,3.9359782099392255,3.748396668298736,4.6863043765011811,5.642970238867675,6.8247339512027558,7.274929651139928]
[null,null,"Colder",{"$f":"xa*(D30-D24)","v":8.5880004426233523},8.6442749051154983,7.9877395093737862,6.8997665678589506,5.811793626344115,4.7800951473214255,4.2548668307280568,4.4236902182044968,5.474146851391235,6.6183942553982176,7.6500927344209062,8.5317259801312044]
[null,null,"Warmer",{"$f":"xa*(D31-D25)","v":6.093165938804848},5.9806170138205559,5.699244701359822,5.0051929972900133,3.8609455932830294,2.904279730916536,2.4728421851434113,2.6416655726198517,3.4482662016739538,4.3111412932202038,5.1552582306024037,5.9243425513284071]
[]
["monthly aggregated coefficient X","Xtm","IF (Xtm) < 0 then 0 else (IF (Xtm) > 18 then 18  else (Xtm))"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"IF(D37<0,0,IF(D37>18,18,D37))","v":7.3499622677961245},{"$f":"IF(E37<0,0,IF(E37>18,18,E37))","v":7.3874785761242228},6.487087176249875,5.5866957763755281,4.8176114556495238,4.1610760599078125,3.9359782099392255,3.748396668298736,4.6863043765011811,5.642970238867675,6.8247339512027558,7.274929651139928]
[null,null,"Colder",{"$f":"IF(D38<0,0,IF(D38>18,18,D38))","v":8.5880004426233523},8.6442749051154983,7.9877395093737862,6.8997665678589506,5.811793626344115,4.7800951473214255,4.2548668307280568,4.4236902182044968,5.474146851391235,6.6183942553982176,7.6500927344209062,8.5317259801312044]
[null,null,"Warmer",6.093165938804848,5.9806170138205559,5.699244701359822,5.0051929972900133,3.8609455932830294,2.904279730916536,2.4728421851434113,2.6416655726198517,3.4482662016739538,4.3111412932202038,5.1552582306024037,5.9243425513284071]
[]
[null,"QsolMtm (monthly average solar irradiation in W/m²)"]
[null,"Table 5 (annex VII)"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",70,104,149,192,221,222,232,217,176,129,80,56]
[null,null,"Colder",22,75,124,192,234,237,238,181,120,64,23,13]
[null,null,"Warmer",128,137,182,227,248,268,268,263,243,175,126,109]
[]
[null,"ya",{"$f":"(Asol*IAM*eta0*etaloop*0.732)/Lwhtm","v":1.0257915239771426E-2},"ya = (Asol × IAM × η0 × etaloop × 0,732) / Lwhtm"]
[]
[null,"(Ytm)","Ytm = ya*QsolMtm"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"ya*D50","v":0.71805406678399986},{"$f":"ya*E50","v":1.0668231849362284},{"$f":"ya*F50","v":1.5284293707259424},{"$f":"ya*G50","v":1.9695197260361139},{"$f":"ya*H50","v":2.266999267989485},{"$f":"ya*I50","v":2.2772571832292567},{"$f":"ya*J50","v":2.3798363356269707},{"$f":"ya*K50","v":2.2259676070303995},{"$f":"ya*L50","v":1.805393082199771},{"$f":"ya*M50","v":1.323271065930514},{"$f":"ya*N50","v":0.82063321918171406},{"$f":"ya*O50","v":0.57444325342719982}]
[null,null,"Colder",{"$f":"ya*D51","v":0.22567413527497138},{"$f":"ya*E51","v":0.76934364298285696},{"$f":"ya*F51","v":1.2719814897316568},{"$f":"ya*G51","v":1.9695197260361139},{"$f":"ya*H51","v":2.4003521661065137},{"$f":"ya*I51","v":2.4311259118258279},{"$f":"ya*J51","v":2.4413838270655992},{"$f":"ya*K51","v":1.8566826583986282},{"$f":"ya*L51","v":1.2309498287725711},{"$f":"ya*M51","v":0.65650657534537127},{"$f":"ya*N51","v":0.23593205051474281},{"$f":"ya*O51","v":0.13335289811702855}]
[null,null,"Warmer",{"$f":"ya*D52","v":1.3130131506907425},{"$f":"ya*E52","v":1.4053343878486855},{"$f":"ya*F52","v":1.8669405736383995},{"$f":"ya*G52","v":2.3285467594281135},{"$f":"ya*H52","v":2.5439629794633136},{"$f":"ya*I52","v":2.749121284258742},{"$f":"ya*J52","v":2.749121284258742},{"$f":"ya*K52","v":2.6978317080598853},{"$f":"ya*L52","v":2.4926734032644564},{"$f":"ya*M52","v":1.7951351669599995},{"$f":"ya*N52","v":1.2924973202111998},{"$f":"ya*O52","v":1.1181127611350854}]
[]
["monthly aggregated coefficient Y","Ytm","IF (Ytm) < 0 then 0 else (IF (Ytm) > 3 then 3 else (Ytm))"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"IF(D58<0,0,IF(D58>3,3,D58))","v":0.71805406678399986},{"$f":"IF(E58<0,0,IF(E58>3,3,E58))","v":1.0668231849362284},1.5284293707259424,1.9695197260361139,2.266999267989485,2.2772571832292567,2.3798363356269707,2.2259676070303995,1.805393082199771,1.323271065930514,0.82063321918171406,0.57444325342719982]
[null,null,"Colder",{"$f":"IF(D59<0,0,IF(D59>3,3,D59))","v":0.22567413527497138},0.76934364298285696,1.2719814897316568,1.9695197260361139,2.4003521661065137,2.4311259118258279,2.4413838270655992,1.8566826583986282,1.2309498287725711,0.65650657534537127,0.23593205051474281,0.13335289811702855]
[null,null,"Warmer",1.3130131506907425,1.4053343878486855,1.8669405736383995,2.3285467594281135,2.5439629794633136,2.749121284258742,2.749121284258742,2.6978317080598853,2.4926734032644564,1.7951351669599995,1.2924973202111998,1.1181127611350854]
[]
[null,"LsolW1,tm","LsolW1tm = Lwhtm ×(1,029×Ytm - 0,065×Xtm - 0,245×Ytm2 + 0,0018 × Xtm2 + 0,0215×Ytm3)"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"Lwhtm*(1.029*D64-0.065*D43-0.245*D64^2+0.0018*D43^2+0.0215*D64^3)","v":88.54534984585311},170.84200430041523,269.78402142275462,344.42345455942785,388.38550893718383,401.15583189590552,414.34262555558234,404.10236490401593,339.64430564476203,248.2818884812109,122.31875505678327,50.441723481214929]
[null,null,"Colder",{"$f":"Lwhtm*(1.029*D65-0.065*D44-0.245*D65^2+0.0018*D44^2+0.0215*D65^3)","v":-75.805497085472993},84.505333465363961,203.78299034842692,323.82343541934137,383.21546458998404,403.21625059912031,413.48535423330185,350.93909339472975,233.76582414422884,82.892074931055745,-59.948660149677323,-107.21980266061871]
[null,null,"Warmer",{"$f":"Lwhtm*(1.029*D66-0.065*D45-0.245*D66^2+0.0018*D45^2+0.0215*D66^3)","v":239.1207324609662},257.34113965546879,330.2134133261801,390.64344543434453,428.69590383158811,461.28028566159128,470.08572427305756,463.33850330253705,432.72714076326304,345.05233388881101,250.82078906987678,203.79295943706254]
[]
[null,"LsolW1,tm","IF LsolW1tm < 0 then 0 else LsolW1tm"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"IF(D70<0,0,D70)","v":88.54534984585311},{"$f":"IF(E70<0,0,E70)","v":170.84200430041523},269.78402142275462,344.42345455942785,388.38550893718383,401.15583189590552,414.34262555558234,404.10236490401593,339.64430564476203,248.2818884812109,122.31875505678327,50.441723481214929]
[null,null,"Colder",{"$f":"IF(D71<0,0,D71)","v":0},84.505333465363961,203.78299034842692,323.82343541934137,383.21546458998404,403.21625059912031,413.48535423330185,350.93909339472975,233.76582414422884,82.892074931055745,0,0]
[null,null,"Warmer",239.1207324609662,257.34113965546879,330.2134133261801,390.64344543434453,428.69590383158811,461.28028566159128,470.08572427305756,463.33850330253705,432.72714076326304,345.05233388881101,250.82078906987678,203.79295943706254]
[]
[null,"Qbuftm","Qbuftm = 0,732 × psbsol × (10 + 50 × LsolW1tm / Lwhtm − Ta)"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"0.732*psbsol*(10+50*D76/Lwhtm-Ta)","v":1.9523478632080835},{"$f":"0.732*psbsol*(10+50*E76/Lwhtm-Ta)","v":12.83814871698614},25.925717119411988,35.79865801050633,41.613744568410567,43.302940726971627,45.04722560259026,43.692693770372479,35.166495455656353,23.081519640371816,6.4197295048655123,-3.0878143543366505]
[null,null,"Colder",{"$f":"0.732*psbsol*(10+50*D77/Lwhtm-Ta)","v":-9.76},1.4179541620851797,17.195422003760175,33.073787753881135,40.929876268516402,43.57548288348152,44.933829925039923,36.660514999302876,21.161405310083179,1.204560176065574,-9.76,-9.76]
[null,null,"Warmer",{"$f":"0.732*psbsol*(10+50*D78/Lwhtm-Ta)","v":21.869726516000821},24.279833287760418,33.919022926743402,41.912413417241339,46.945807385130692,51.255910801797782,52.420651358870046,51.528161812504905,47.479039783500397,35.881843106985578,23.417353051571002,17.196740666278114]
[]
[null,"LsolWtm","LsolWtm = LsolW1tm - Qbuftm"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"D76-D82","v":86.593001982645021},{"$f":"E76-E82","v":158.00385558342907},243.85830430334263,308.62479654892149,346.77176436877323,357.85289116893387,369.29539995299206,360.40967113364343,304.4778101891057,225.20036884083908,115.89902555191776,53.529537835551579]
[null,null,"Colder",{"$f":"D77-D83","v":9.76},83.08737930327878,186.58756834466675,290.7496476654602,342.28558832146763,359.64076771563879,368.55152430826195,314.27857839542685,212.60441883414566,81.687514754990175,9.76,9.76]
[null,null,"Warmer",217.25100594496539,233.06130636770837,296.29439039943668,348.73103201710319,381.75009644645741,410.02437485979351,417.66507291418753,411.81034149003216,385.24810097976263,309.17049078182544,227.40343601830577,186.59621877078442]
[]
["monthly non-solar heat contribution","Qnonsol,tm","Qnonsoltm  = Lwhtm - LsolWtm (Vbu=0)",null,null,null,"Qnonsoltm = Lwhtm - LsolWtm + psbSol × Vbu/Vnom × (60 - Ta) × 0,732 = Lwhtm - LsolWtm"]
[null,null,"Month:","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"Climate:","Average",{"$f":"Lwhtm-D88","v":282.33499801735496},210.92414441657093,125.06969569665736,60.303203451078502,22.156235631226764,11.075108831066132,-0.3673999529920593,8.5183288663565691,64.450189810894301,143.72763115916092,253.02897444808224,315.3984621644484]
[null,null,"Colder",{"$f":"Lwhtm-D89","v":359.16800000000001},285.8406206967212,182.34043165533325,78.178352334539795,26.642411678532369,9.2872322843612096,0.37647569173805095,54.649421604573149,156.32358116585434,287.24048524500984,359.16800000000001,359.16800000000001]
[null,null,"Warmer",{"$f":"Lwhtm-D90","v":151.67699405503461},135.86669363229163,72.633609600563318,20.196967982896808,-12.822096446457408,-41.096374859793514,-48.737072914187536,-42.882341490032161,-16.320100979762628,59.757509218174562,141.52456398169423,182.33178122921558]
[]
[]
["annual non-solar heat contribution","Qnonsol"]
[null,"Climate:","Average",{"$f":"SUM(D94:O94)","v":1496.6195725399048},"kWh/a"]
[null,null,"Colder",{"$f":"SUM(D95:O95)","v":2158.3830123566636},"kWh/a"]
[null,null,"Warmer",{"$f":"SUM(D96:O96)","v":602.13013300963758},"kWh/a"]

{"sheet":"Datenblatt_1","index":4,"n_rows":54,"n_cols":19,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz des Heizkessels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!C14","v":0.95},null,"\"1\""]
[]
[]
[null,"Temperaturregler",null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"VLOOKUP(Eingabe!C25,Daten!A11:C18,3,FALSE)","v":0.04},null,"\"2\""]
[null,"vom Datenblatt des Reglerherstellers"]
[]
[]
[null,"Zusatzheizkessel"]
[null,"vom Datenblatt des Kesselherstellers"]
[null,null,null,null,null,null,null,null,"(",{"$f":"IF(Eingabe!C19=\"JA\",Eingabe!C21,0)","v":0}," - \"I\") x 0,1 =",null,null,null,null,"±",{"$f":"IF(J11=0,0,(J11-Q2)*0.1)","v":0},null,"\"3\""]
[]
[]
[null,"Solarer Beitrag"]
[]
[null,"vom Datenblatt der Solareinrichtung"]
[null,null,null,null,null,null,"(\"III\" x",{"$f":"IF(SolAnl=\"NEIN\",0,Asol)","v":6.7799999999999994},"+ \"IV\" x",{"$f":"IF(SolAnl=\"NEIN\",0,Eingabe!C27/1000)","v":0.3},") x 0,9 x",{"$f":"IF(SolAnl=\"NEIN\",0,Eingabe!C31)","v":0.82},"/ 100 x",{"$f":"IF(SolAnl=\"NEIN\",0,Zwischenergebnisse!C16)","v":0.86}," =","+",{"$f":"(Q53*H17+Q54*J17)*0.9*L17/100*N17","v":7.8001018036363626E-2},null,"\"4\""]
[]
[]
[null,"Zusatzwärmepumpe"]
[null,"vom Datenblatt des Wärmepumpenherstellers"]
[null,null,null,null,null,null,null,null,"(",{"$f":"IF(Eingabe!C22=\"NEIN\",0,Eingabe!C24)","v":0}," - \"I\") x \"II\" =",null,null,null,null,"+",{"$f":"IF(Eingabe!C22=\"NEIN\",0,(J22-Q51)*Q52)","v":0},null,"\"5\""]
[]
[]
[null,"Solarer Beitrag und Zusatzwärmepumpe"]
[null,"kleineren Wert auswählen",null,null,null,null,null,null,null,"\"4\"",null,null,"\"5\""]
[null,null,null,null,null,null,null,null,"0,5 x ",{"$f":"IF(Eingabe!C19=\"JA\",Q17,0)","v":0},"ODER","0,5 x ",{"$f":"IF(SolAnl=\"JA\",Q22,0)","v":0},null,null,"-",{"$f":"IF(J27<M27,J27,M27)*0.5","v":0},null,"\"6\""]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Verbundanlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q2:Q27)","v":1.0680010180363637},null,"\"7\""]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Verbundanlage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Einbau von Heizkessel und Zusatzwärmepumpe mit Niedertemperatur-Wärmestrahlern (<35°C)?"]
[null,"vom Datenblatt des Wärmepumpenherstellers"]
[null,null,null,null,null,null,null,null,null,"\"7\""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Q52=0,0,Q30)","v":0},"+ (50% x \"II\") =",null,null,null,null,null,{"$f":"IF(Q52=0,0,J47+(50%*Q52))","v":0},null,"\"8\""]
[]
[]
[null,"Bedeutung der Variablen:"]
[null,"\"I\"","Raumheizungs-Energieeffizienz hs des Vorzugsraumheizgerätes",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q2","v":0.95}]
[null,"\"II\"","Faktor zur Gewichtung der Wärmeleistung der Vorzugs- und Zusatzheizgeräte",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Eingabe!C19=\"NEIN\",Eingabe!C22=\"NEIN\"),0,Zwischenergebnisse!B63)","v":0}]
[null,"\"III\"","Der Ausdruck 294/(11xPrated)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!B64","v":1.7818181818181817}]
[null,"\"IV\"","Der Ausdruck 115/(11xPrated)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!B65","v":0.69696969696969702}]

{"sheet":"Datenblatt_2","index":5,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz des Raumheizgeräts mit Kraft-Wärme-Kopplung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!C14","v":0.95},null,"\"1\""]
[]
[]
[null,"Temperaturregler",null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"VLOOKUP(Eingabe!C25,Daten!A11:C18,3,FALSE)","v":0.04},null,"\"2\""]
[null,"vom Datenblatt des Reglerherstellers"]
[]
[]
[null,"Zusatzheizkessel"]
[null,"vom Datenblatt des Kesselherstellers"]
[null,null,null,null,null,null,null,null,"(",{"$f":"IF(Eingabe!C19=\"NEIN\",0,Eingabe!C21)","v":0}," - \"I\") x \"II\" =",null,null,null,null,"±",{"$f":"IF(J11=0,0,(J11-Q35)*Q36)","v":0},null,"\"3\""]
[]
[]
[null,"Solarer Beitrag"]
[]
[null,"vom Datenblatt der Solareinrichtung"]
[null,null,null,null,null,null,"(\"III\" x",{"$f":"IF(SolAnl=\"NEIN\",0,Asol)","v":6.7799999999999994},"+ \"IV\" x",{"$f":"IF(SolAnl=\"NEIN\",0,Eingabe!C27/1000)","v":0.3},") x 0,7 x (",{"$f":"IF(SolAnl=\"NEIN\",0,Eingabe!C31)","v":0.82}," / 100 ) x",{"$f":"IF(SolAnl=\"NEIN\",0,Zwischenergebnisse!C16)","v":0.86}," =","+",{"$f":"(Q37*H17+Q38*J17)*0.7*(L17/100*N17)","v":6.0667458472727254E-2},null,"\"4\""]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Verbundanlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q2:Q18)","v":1.0506674584727271},null,"\"7\""]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Verbundanlage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bedeutung der Variablen:"]
[null,"\"I\"","Raumheizungs-Energieeffizienz hs des Vorzugsraumheizgerätes",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q2","v":0.95}]
[null,"\"II\"","Faktor zur Gewichtung der Wärmeleistung der Vorzugs- und Zusatzheizgeräte",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Eingabe!C19=\"NEIN\",Eingabe!C22=\"NEIN\"),0,Zwischenergebnisse!C63)","v":0}]
[null,"\"III\"","Der Ausdruck 294/(11xPrated)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!C64","v":1.7818181818181817}]
[null,"\"IV\"","Der Ausdruck 115/(11xPrated)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!C65","v":0.69696969696969702}]

{"sheet":"Datenblatt_3","index":6,"n_rows":49,"n_cols":19,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Wärmepumpe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!C14","v":0.95},null,"\"1\""]
[]
[]
[null,"Temperaturregler",null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"VLOOKUP(Eingabe!C25,Daten!A11:C18,3,FALSE)","v":0.04},null,"\"2\""]
[null,"vom Datenblatt des Reglerherstellers"]
[]
[]
[null,"Zusatzheizkessel"]
[null,"vom Datenblatt des Kesselherstellers"]
[null,null,null,null,null,null,null,null,"(",{"$f":"IF(Eingabe!C19=\"NEIN\",0,Eingabe!C21)","v":0}," - \"I\") x \"II\" =",null,null,null,null,"±",{"$f":"IF(J11=0,0,(J11-Q42)*Q43)","v":0},null,"\"3\""]
[]
[]
[null,"Solarer Beitrag"]
[]
[null,"vom Datenblatt der Solareinrichtung"]
[null,null,null,null,null,null,"(\"III\" x",{"$f":"IF(SolAnl=\"NEIN\",0,Asol)","v":6.7799999999999994},"+ \"IV\" x",{"$f":"IF(SolAnl=\"JA\",Eingabe!C27/1000,0)","v":0.3},") x 0,45 x (",{"$f":"IF(SolAnl=\"JA\",Eingabe!C31,0)","v":0.82}," ) x",{"$f":"IF(SolAnl=\"JA\",Zwischenergebnisse!C16,0)","v":0.86}," =","+",{"$f":"(Q44*H17+Q45*J17)*0.45*L17/100*N17","v":3.9000509018181813E-2},null,"\"4\""]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Verbundanlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q2:Q18)","v":1.0290005090181817},null,"\"5\""]
[null,"bei durchschnittlichem Klima"]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Verbundanlage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz bei kälterem und wärmerem Klima"]
[]
[null,null,null,null,null,null,null,"\"5\"",null,null,null,"\"5\""]
[null,null,null,null,null,null,"Kälter:",{"$f":"Q20","v":1.0290005090181817}," - \"V\" =",{"$f":"H38-Q47","v":0.91900050901818164},"Wärmer:",{"$f":"Q20","v":1.0290005090181817}," + \"VI\" =",{"$f":"L38+Q49","v":1.1390005090181818},null,null,null,null,"\"6\""]
[]
[]
[null,"Bedeutung der Variablen:"]
[null,"\"I\"","Raumheizungs-Energieeffizienz hs des Vorzugsraumheizgerätes",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q2","v":0.95}]
[null,"\"II\"","Faktor zur Gewichtung der Wärmeleistung der Vorzugs- und Zusatzheizgeräte",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Eingabe!C19=\"NEIN\",Eingabe!C22=\"NEIN\"),0,Zwischenergebnisse!D63)","v":0}]
[null,"\"III\"","Der Ausdruck 294/(11xPrated)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!D64","v":1.7818181818181817}]
[null,"\"IV\"","Der Ausdruck 115/(11xPrated)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!D65","v":0.69696969696969702}]
[null,"\"V\"","Wert der Differenz zwischen der jahreszeitbedingten Raumheizungs-Energieeffizienz bei durchschnittlichen"]
[null,null,"und derjenigen bei kälteren Klimaverhältnissen in Prozent.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!D66","v":0.1100000000000001}]
[null,"\"VI\"","Wert der Differenz zwischen der jahreszeitbedingten Raumheizungs-Energieeffizienz bei durchschnittlichen"]
[null,null,"und derjenigen bei wärmeren Klimaverhältnissen in Prozent.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!D67","v":0.1100000000000001}]

{"sheet":"Datenblatt_4","index":7,"n_rows":49,"n_cols":19,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Niedertemperatur-Wärmepumpe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Eingabe!C14","v":0.95},null,"\"1\""]
[]
[]
[null,"Temperaturregler",null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"VLOOKUP(Eingabe!C25,Daten!A11:C18,3,FALSE)","v":0.04},null,"\"2\""]
[null,"vom Datenblatt des Reglerherstellers"]
[]
[]
[null,"Zusatzheizkessel"]
[null,"vom Datenblatt des Kesselherstellers"]
[null,null,null,null,null,null,null,null,"(",{"$f":"IF(Eingabe!C19=\"JA\",Eingabe!C21,0)","v":0}," - \"I\") x \"II\" =",null,null,null,null,"±",{"$f":"IF(J11=0,0,(J11-Q42)*Q43)","v":0},null,"\"3\""]
[]
[]
[null,"Solarer Beitrag"]
[]
[null,"vom Datenblatt der Solareinrichtung"]
[null,null,null,null,null,null,"(\"III\" x",{"$f":"IF(SolAnl=\"NEIN\",0,Asol)","v":6.7799999999999994},"+ \"IV\" x",{"$f":"IF(SolAnl=\"NEIN\",0,Eingabe!C27/1000)","v":0.3},") x 0,45 x (",{"$f":"IF(SolAnl=\"NEIN\",0,Eingabe!C31)","v":0.82}," / 100) x",{"$f":"IF(SolAnl=\"NEIN\",0,Zwischenergebnisse!C16)","v":0.86}," =","+",{"$f":"(Q44*H17+Q45*J17)*0.45*L17/100*N17","v":3.9000509018181813E-2},null,"\"4\""]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Verbundanlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q2:Q18)","v":1.0290005090181817},null,"\"5\""]
[null,"bei durchschnittlichem Klima"]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz der Verbundanlage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz bei kälterem und wärmerem Klima"]
[]
[null,null,null,null,null,null,null,"\"5\"",null,null,null,"\"5\""]
[null,null,null,null,null,null,"Kälter:",{"$f":"Q20","v":1.0290005090181817}," - \"V\" =",{"$f":"H38-Q47","v":0.91900050901818164},"Wärmer:",{"$f":"Q20","v":1.0290005090181817}," + \"VI\" =",{"$f":"L38+Q49","v":1.1390005090181818}]
[]
[]
[null,"Bedeutung der Variablen:"]
[null,"\"I\"","Raumheizungs-Energieeffizienz hs des Vorzugsraumheizgerätes",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q2","v":0.95}]
[null,"\"II\"","Faktor zur Gewichtung der Wärmeleistung der Vorzugs- und Zusatzheizgeräte",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Eingabe!C19=\"NEIN\",Eingabe!C22=\"NEIN\"),0,Zwischenergebnisse!E63)","v":0}]
[null,"\"III\"","Der Ausdruck 294/(11xPrated)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!E64","v":1.7818181818181817}]
[null,"\"IV\"","Der Ausdruck 115/(11xPrated)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!E65","v":0.69696969696969702}]
[null,"\"V\"","Wert der Differenz zwischen der jahreszeitbedingten Raumheizungs-Energieeffizienz bei durchschnittlichen"]
[null,null,"und derjenigen bei kälteren Klimaverhältnissen in Prozent.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!E66","v":0.1100000000000001}]
[null,"\"VI\"","Wert der Differenz zwischen der jahreszeitbedingten Raumheizungs-Energieeffizienz bei durchschnittlichen"]
[null,null,"und derjenigen bei wärmeren Klimaverhältnissen in Prozent.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!E67","v":0.1100000000000001}]

{"sheet":"Datenblatt_5","index":8,"n_rows":49,"n_cols":19,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Warmwasserbereitungs-Energieeffizienz hwh des Kombiheizgerätes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!F62","v":0.84},null,"\"1\""]
[]
[null,"Angegebenes Lastprofil:",null,null,null,null,null,{"$f":"Eingabe!C38","v":"XL"},null,{"$f":"Eingabe!E38","v":"bis zu 3 Bäder mit Badewanne, Dusche und Waschbecken mit 55°C"}]
[]
[]
[null,"Solarer Beitrag"]
[]
[null,"vom Datenblatt der Solareinrichtung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"( 1,1 x \"I\" - 10%) x \"II\" - \"III\" - \"I\" =",null,"+",{"$f":"IF(Eingabe!C26=\"NEIN\",0,(1.1*Q45-0.1)*Q46-Q47-Q45)","v":0},null,"\"2\""]
[]
[]
[null,"Warmwasserbereitungs-Energieeffizienz der Verbundanlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q2:Q11)","v":0.84},null,"\"3\""]
[null,"bei durchschnittlichem Klima"]
[]
[]
[null,"Warmwasserbereitungs-Energieeffizienz der Verbundanlage bei durchschnittlichem Klima"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz bei kälterem und wärmerem Klima"]
[]
[null,null,null,null,null,null,null,"\"3\"",null,"\"2\""]
[null,null,null,null,null,null,"Kälter:",{"$f":"Q13","v":0.84}," - 0,2 x",{"$f":"Q10","v":0},"=",{"$f":"H38-0.2*J38","v":0.84}]
[]
[null,null,null,null,null,null,null,"\"3\"",null,"\"2\""]
[null,null,null,null,null,null,"Wärmer:",{"$f":"Q13","v":0.84}," + 0,4 x",{"$f":"Q10","v":0},"=",{"$f":"H41+0.4*J41","v":0.84}]
[]
[]
[null,"Bedeutung der Variablen:"]
[null,"\"I\"","Warmwasserbereitungs-Energieeffizienz hwh des Vorzugsraumheizgerätes",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!F62","v":0.84}]
[null,"\"II\"","Der Ausdruck (220 x Qref) / Qnonsol",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Eingabe!C26=\"NEIN\",0,Zwischenergebnisse!F63)","v":0}]
[null,"\"III\"","Der Ausdruck (2,5 x Qaux) / (220 x Qref)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!F64","v":0}]
[null,"Qnonsol","Jährlicher nichtsolarer Wärmebeitrag in kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Qnonsolavg","v":1496.6195725399048}]
[null,"Qaux","Jährlicher Hilfsstromverbrauch in kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Qaux","v":105.04}]

{"sheet":"Datenblatt_6","index":9,"n_rows":49,"n_cols":19,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Warmwasserbereitungs-Energieeffizienz hwh des Warmwasserbereiters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!G62","v":0.84},null,"\"1\""]
[]
[null,"Angegebenes Lastprofil:",null,null,null,null,null,{"$f":"Eingabe!C38","v":"XL"},null,{"$f":"Eingabe!E38","v":"bis zu 3 Bäder mit Badewanne, Dusche und Waschbecken mit 55°C"}]
[]
[]
[null,"Solarer Beitrag"]
[]
[null,"vom Datenblatt der Solareinrichtung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"( 1,1 x \"I\" - 10%) x \"II\" - \"III\" - \"I\" =",null,"+",{"$f":"IF(Eingabe!C26=\"JA\",(1.1*Q45-10%)*Q46-Q47-Q45,0)","v":0},null,"\"2\""]
[]
[]
[null,"Warmwasserbereitungs-Energieeffizienz der Verbundanlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q2:Q11)","v":0.84},null,"\"3\""]
[null,"bei durchschnittlichem Klima"]
[]
[]
[null,"Warmwasserbereitungs-Energieeffizienz der Verbundanlage bei durchschnittlichem Klima"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jahreszeitbedingte Raumheizungs-Energieeffizienz bei kälterem und wärmerem Klima"]
[]
[null,null,null,null,null,null,null,"\"3\"",null,"\"2\""]
[null,null,null,null,null,null,"Kälter:",{"$f":"Q13","v":0.84}," - 0,2 x",{"$f":"Q10","v":0},"=",{"$f":"H38-0.2*J38","v":0.84}]
[]
[null,null,null,null,null,null,null,"\"3\"",null,"\"2\""]
[null,null,null,null,null,null,"Wärmer:",{"$f":"Q13","v":0.84}," + 0,4 x",{"$f":"Q10","v":0},"=",{"$f":"H41+0.4*J41","v":0.84}]
[]
[]
[null,"Bedeutung der Variablen:"]
[null,"\"I\"","Warmwasserbereitungs-Energieeffizienz hwh des Vorzugsraumheizgerätes",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q2","v":0.84}]
[null,"\"II\"","Der Ausdruck (220 x Qref) / Qnonsol",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!G63","v":0}]
[null,"\"III\"","Der Ausdruck (2,5 x Qaux) / (220 x Qref)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Zwischenergebnisse!G64","v":0}]
[null,"Qnonsol","Jährlicher nichtsolarer Wärmebeitrag in kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Qnonsolavg","v":1496.6195725399048}]
[null,"Qaux","Jährlicher Hilfsstromverbrauch in kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Qaux","v":105.04}]

{"sheet":"Label_1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Label_2","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Label_3","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}