{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Scope","ErP Inputs","LOW SPER","MEDIUM SPER","HIGH SPER","VERY HIGH SPER","Table 37","Version Control"],"not_rendered":{"charts":13,"images":7,"macros":1,"external_links":2,"defined_names":126,"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":"Scope","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,1,7,5],[9,1,9,4],[11,1,11,4],[13,1,13,4]]}
[]
[null,"MCS 027 - SPER AND SSHEE CALCULATOR "]
[]
[]
[]
[]
[]
[null,"This calculator can only be used for calculating the Seasonal Space Heating Energy Efficiency (SSHEE) and Seasonal Primary Energy Ratio (SPERh) for Air to Water and Water / Brine to Water heat pumps under the average climate conditions defined by Commission Regulation (EU) No. 813/2013"]
[]
[null,"MCS Certification Bodies may use the calculator when certifying products against the requirements of MCS 007 - (Product certification scheme requirements - Heat pumps). "]
[]
[null,"Data calculated in accordance with this calculator will be published within the product search section of the MCS database. Please visit http://www.mcscertified.com"]
[]
[null,"The calculator is designed for use as an Microsoft Excel Macro-Enabled workbook."]

{"sheet":"ErP Inputs","index":1,"n_rows":96,"n_cols":33,"rows_kept":96,"cut":false,"hidden":false,"merged":[[44,14,47,25],[0,1,0,15],[7,4,7,15],[17,14,17,15],[16,4,16,15],[13,6,13,13],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[15,2,15,5],[43,2,47,2],[43,1,47,1],[18,2,22,2],[28,2,32,2],[18,1,32,1],[23,2,27,2],[52,4,52,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[51,4,51,5]]}
[null,"This calculator can only be used for calculating the Seasonal Space Heating Energy Efficiency (SSHEE) and Seasonal Primary Energy Ratio (SPERh) for Air to Water and Water / Brine to Water heat pumps under the average climate conditions defined by Commission Regulation (EU) No. 813/2013"]
["Grace Davies 27/08/11"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,1,"Heat Generator?","Air Source",null,null,null,null,null,null,null,null,null,"Input Required"]
[null,2,"Temperature Control?","Variable Outlet",null,null,null,null,null,null,null,null,null,"Calculated Outcomes"]
[null,3,"Has the manufacturer provided data to demonstrate that the heat pump can reach a flow temperature of 52oC at Condition A according to the relevant product table within EN 12309 for the average climate and high temperature application?","Yes"]
[null,4,"Has the manufacturer provided data to demonstrate that the heat pump can reach a flow temperature of 61oC or greater at an inlet dry (wet) bulb temperature of -7oC (-8oC) for ASHP OR Brine 0oC for Ground Source OR Water 10oC for Water Source Heat Pumps","Yes"]
[null,null,"Classification under ErP",{"$f":"IF(D6=\"Yes\",\"Heat Pump\",\"Low Temperature Heat Pump\")","v":"Heat Pump"},{"$f":"IF(AND(D8=\"Low Temperature Heat Pump\",D9=\"Very High Temperature Heat Pump\"),\"Test data for VHTHP's signifies a flow temperautre greater than 52oC for ErP classification, Change D6 to YES\",\"\")","v":""}]
[null,null,"Classification under MCS",{"$f":"IF(AND(D6=\"No\",D7=\"No\"),\"Low Temperature Heat Pump\",IF(AND(D6=\"Yes\",D7=\"No\"),\"Heat Pump\",\"Very High Temperature Heat Pump\"))","v":"Very High Temperature Heat Pump"}]
[null,null,"Energy Label (Space Heater Only) to display SSHEE at",{"$f":"IF(D8=\"Heat Pump\",\"55oC and 35oC\",\"35oC\")","v":"55oC and 35oC"}]
[null,"Notes:","Low Temperature Heat Pumps only need to supply test data to 35oC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Source"]
[null,null,"Heat Pumps must supply test data at 35oC and 55oC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground Source"]
[null,null,"Very High Temperature Heat Pumps must supply test data to 35oC, 55oC and 65oC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Source"]
[null,null,null,null,null,null,"Flow Temperature (oC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed Outlet"]
[null,null,null,null,null,null,35,null,45,null,55,null,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Outlet"]
[null,null,"Rated Heat Output including the rated heat output of any supplementary heater under average climate conditions (kW)",null,null,null,null,null,null,null,null,null,null,null,"To be provided @ Tdesignh",null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[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,"No"]
[null,null,"All entries to 3 significant figures","Test Conditions EN 12309:2014",{"$f":"(16-(-7))/26","v":0.88461538461538458},"A",{"$f":"(16-2)/26","v":0.53846153846153844},"B",{"$f":"(16-7)/26","v":0.34615384615384615},"C",{"$f":"(16-12)/26","v":0.15384615384615385},"D",{"$f":"(16-(-10))/26","v":1},"E*"]
[null,"Product Performance Data","Low Temperature Application (35oC)\nEN 12309-6:2014 - Table 5 (ASHP) or\nTable 17 (GSHP)",null,{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A-7 / W\",\"W10 / W\"))","v":"A-7 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Low\",$AB$24:$AG$28,3,FALSE),VLOOKUP(\"Low\",$AB$24:$AG$28,2,FALSE))","v":34},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A2 / W\",\"W10 / W\"))","v":"A2 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Low\",$AB$24:$AG$28,4,FALSE),VLOOKUP(\"Low\",$AB$24:$AG$28,2,FALSE))","v":30},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A7 / W\",\"W10 / W\"))","v":"A7 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Low\",$AB$24:$AG$28,5,FALSE),VLOOKUP(\"Low\",$AB$24:$AG$28,2,FALSE))","v":27},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A12 / W\",\"W10 / W\"))","v":"A12 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Low\",$AB$24:$AG$28,6,FALSE),VLOOKUP(\"Low\",$AB$24:$AG$28,2,FALSE))","v":24},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A-10 / W\",\"W10 / W\"))","v":"A-10 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Low\",$AB$24:$AG$28,2,FALSE),VLOOKUP(\"Low\",$AB$24:$AG$28,2,FALSE))","v":35}]
[null,null,null,"Heating Capacity (kW)",{"$f":"$G$16*E$18","v":0},null,{"$f":"$G$16*G$18","v":0},null,{"$f":"$G$16*I$18","v":0},null,{"$f":"$G$16*K$18","v":0},null,{"$f":"$G$16*M$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Climate"]
[null,null,null,"Gas Utilization Efficiency PL (kW/kWGCV)",null,null,null,null,null,null,null,null,null,null,"Performance data always required",null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Outlet Flow Temperatures"]
[null,null,null,"Auxiliary Energy Factor PL (kW/kWel)",null,null,null,null,null,null,null,null,null,null,"Performance data always required"]
[null,null,null,"Capacity Ratio",null,null,null,null,null,null,null,null,null,null,"Leave blank if not measured",null,null,null,null,null,null,null,null,null,null,null,null,null,-10,-7,2,7,12]
[null,null,"High Temperature Application (55oC)\nEN 12309-6:2014 - Table 11 (ASHP) or\nTable 23 (GSHP)",null,{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A-7 / W\",\"W10 / W\"))","v":"A-7 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"High\",$AB$24:$AG$28,3,FALSE),VLOOKUP(\"High\",$AB$24:$AG$28,2,FALSE))","v":52},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A2 / W\",\"W10 / W\"))","v":"A2 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"High\",$AB$24:$AG$28,4,FALSE),VLOOKUP(\"High\",$AB$24:$AG$28,2,FALSE))","v":42},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A7 / W\",\"W10 / W\"))","v":"A7 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"High\",$AB$24:$AG$28,5,FALSE),VLOOKUP(\"High\",$AB$24:$AG$28,2,FALSE))","v":36},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A12 / W\",\"W10 / W\"))","v":"A12 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"High\",$AB$24:$AG$28,6,FALSE),VLOOKUP(\"High\",$AB$24:$AG$28,2,FALSE))","v":30},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A-10 / W\",\"W10 / W\"))","v":"A-10 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"High\",$AB$24:$AG$28,2,FALSE),VLOOKUP(\"High\",$AB$24:$AG$28,2,FALSE))","v":55},null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",35,34,30,27,24]
[null,null,null,"Heating Capacity (kW)",{"$f":"IF($D$8=\"Heat Pump\",$K$16*E$18,\"NA\")","v":0},null,{"$f":"IF($D$8=\"Heat Pump\",$K$16*G$18,\"NA\")","v":0},null,{"$f":"IF($D$8=\"Heat Pump\",$K$16*I$18,\"NA\")","v":0},null,{"$f":"IF($D$8=\"Heat Pump\",$K$16*K$18,\"NA\")","v":0},null,{"$f":"IF($D$8=\"Heat Pump\",$K$16*M$18,\"NA\")","v":0},null,{"$f":"IF($D$8=\"Heat Pump\",\"\",\"Not applicable\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Medium",45,43,37,33,28]
[null,null,null,"Gas Utilization Efficiency PL (kW/kWGCV)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$8=\"Heat Pump\",\"Performance data required\",\"Not applicable\")","v":"Performance data required"},null,null,null,null,null,null,null,null,null,null,null,null,"High",55,52,42,36,30]
[null,null,null,"Auxiliary Energy Factor PL (kW/kWel)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$8=\"Heat Pump\",\"Performance data required\",\"Not applicable\")","v":"Performance data required"}]
[null,null,null,"Capacity Ratio",null,null,null,null,null,null,null,null,null,null,"Leave blank if not measured",null,null,null,null,null,null,null,null,null,null,null,null,"Very High",65,61,49,41,32]
[null,null,"Very High Temperature Application (65oC)\nEN 12309-6:2014 - Table 14 (ASHP) or\nTable 26 (GSHP)",null,{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A-7 / W\",\"W10 / W\"))","v":"A-7 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Very High\",$AB$24:$AG$28,3,FALSE),VLOOKUP(\"Very High\",$AB$24:$AG$28,2,FALSE))","v":61},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A2 / W\",\"W10 / W\"))","v":"A2 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Very High\",$AB$24:$AG$28,4,FALSE),VLOOKUP(\"Very High\",$AB$24:$AG$28,2,FALSE))","v":49},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A7 / W\",\"W10 / W\"))","v":"A7 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Very High\",$AB$24:$AG$28,5,FALSE),VLOOKUP(\"Very High\",$AB$24:$AG$28,2,FALSE))","v":41},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A12 / W\",\"W10 / W\"))","v":"A12 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Very High\",$AB$24:$AG$28,6,FALSE),VLOOKUP(\"Very High\",$AB$24:$AG$28,2,FALSE))","v":32},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A-10 / W\",\"W10 / W\"))","v":"A-10 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Very High\",$AB$24:$AG$28,2,FALSE),VLOOKUP(\"Very High\",$AB$24:$AG$28,2,FALSE))","v":65}]
[null,null,null,"Heating Capacity (kW)",{"$f":"IF($D$9=\"Very High Temperature Heat Pump\",$M$16*E$18,\"NA\")","v":0},null,{"$f":"IF($D$9=\"Very High Temperature Heat Pump\",$M$16*G$18,\"NA\")","v":0},null,{"$f":"IF($D$9=\"Very High Temperature Heat Pump\",$M$16*I$18,\"NA\")","v":0},null,{"$f":"IF($D$9=\"Very High Temperature Heat Pump\",$M$16*K$18,\"NA\")","v":0},null,{"$f":"IF($D$9=\"Very High Temperature Heat Pump\",$M$16*M$18,\"NA\")","v":0},null,{"$f":"IF($D$9=\"Very High Temperature Heat Pump\",\"\",\"Not applicable\")","v":""}]
[null,null,null,"Gas Utilization Efficiency PL (kW/kWGCV)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$9=\"Very High Temperature Heat Pump\",\"Performance data required\",\"Not applicable\")","v":"Performance data required"}]
[null,null,null,"Auxiliary Energy Factor PL (kW/kWel)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$9=\"Very High Temperature Heat Pump\",\"Performance data required\",\"Not applicable\")","v":"Performance data required"}]
[null,null,null,"Capacity Ratio",null,null,null,null,null,null,null,null,null,null,"Leave blank if not measured"]
[null,null,"*If the declared Temperature Operation Limit (TOL) of the heat pump is lower than Tdesignh, then it may be assumed that TOL is equal to Tdesignh "]
[null,null,"Condition E - The design temperature (Tdesignh) for the average climate conditions is fixed at -10oC"]
[null,null,"Temperature application references are taken from EN 12309 NOT ErP definitions"]
[]
[null,null,"Temperature Operation Limit (TOL)",null,"oC","Air to Water heat pumps must be capable of working at a temperature of -10oC or less"]
[null,null,"Thermostat-off power (PTO)",null,"kW"]
[null,null,"Stand-By Mode (PSB)",null,"kW"]
[null,null,"Off power (POFF)",null,"kW"]
[]
[null,null,"The table below is only to be filled out if additional performance data is supplied by the manufacturer at the sink temperature of 45oC"]
[null,"Product Performance Data","Medium Temperature Application (45oC)\nEN 12309-6:2014 - Table 8 (ASHP) or\nTable 20 (GSHP)",null,{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A-7 / W\",\"W10 / W\"))","v":"A-7 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Medium\",$AB$24:$AG$28,3,FALSE),VLOOKUP(\"Medium\",$AB$24:$AG$28,2,FALSE))","v":43},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A2 / W\",\"W10 / W\"))","v":"A2 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Medium\",$AB$24:$AG$28,4,FALSE),VLOOKUP(\"Medium\",$AB$24:$AG$28,2,FALSE))","v":37},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A7 / W\",\"W10 / W\"))","v":"A7 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Medium\",$AB$24:$AG$28,5,FALSE),VLOOKUP(\"Medium\",$AB$24:$AG$28,2,FALSE))","v":33},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A12 / W\",\"W10 / W\"))","v":"A12 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Medium\",$AB$24:$AG$28,6,FALSE),VLOOKUP(\"Medium\",$AB$24:$AG$28,2,FALSE))","v":28},{"$f":"IF($D$4=\"Ground Source\",\"B0 / W\",IF($D$4=\"Air Source\",\"A-10 / W\",\"W10 / W\"))","v":"A-10 / W"},{"$f":"IF($D$5=\"Variable Outlet\",VLOOKUP(\"Medium\",$AB$24:$AG$28,2,FALSE),VLOOKUP(\"Medium\",$AB$24:$AG$28,2,FALSE))","v":45}]
[null,null,null,"Heating Capacity (kW)",{"$f":"$I$16*E$18","v":0},null,{"$f":"$I$16*G$18","v":0},null,{"$f":"$I$16*I$18","v":0},null,{"$f":"$I$16*K$18","v":0},null,{"$f":"$I$16*M$18","v":0},null,"This table is only to be completed in it entirety when performance data is supplied by the manufacturer at 45oC. Partial data is NOT to be accepted."]
[null,null,null,"Gas Utilization Efficiency PL (kW/kWGCV)"]
[null,null,null,"Auxiliary Energy Factor PL (kW/kWel)"]
[null,null,null,"Capacity Ratio"]
[]
[]
[null,null,"OUTPUTS"]
[null,"Application temperature","Seasonal Space Heating Energy Efficiency","Seasonal Primary Energy Ratio","CLASS"]
[null,"Low (35°C)",{"$f":"'LOW SPER'!P17","v":{"$error":"#DIV/0!"}},{"$f":"'LOW SPER'!P11","v":{"$error":"#DIV/0!"}},{"$f":"'LOW SPER'!P19","v":{"$error":"#DIV/0!"}}]
[null,"Medium (45°C)",{"$f":"IF($D$8=\"Low Temperature Heat Pump\",\"Not applicable\",'MEDIUM SPER'!P17)","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$8=\"Low Temperature Heat Pump\",\"Not applicable\",'MEDIUM SPER'!P11)","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$8=\"Low Temperature Heat Pump\",\"N/A\",'MEDIUM SPER'!P19)","v":{"$error":"#DIV/0!"}}]
[null,"High (55°C)",{"$f":"IF($O$25=\"Not applicable\",\"Not applicable\",'HIGH SPER'!P17)","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$25=\"Not applicable\",\"Not applicable\",'HIGH SPER'!P11)","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$25=\"Not applicable\",\"N/A\",'HIGH SPER'!P19)","v":{"$error":"#DIV/0!"}}]
[null,"Very High (65°C)",{"$f":"IF($O$30=\"Not applicable\",\"Not applicable\",'VERY HIGH SPER'!P17)","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$31=\"Not applicable\",\"Not applicable\",'VERY HIGH SPER'!P11)","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$30=\"Not applicable\",\"N/A\",'VERY HIGH SPER'!P19)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(OR(C53<100,C54<100,C55<100,C56<100),\"Cells highlighted red are not compliant with EcoDesign Lot 1 requirements\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Graph Data "]
[null,null,null,null,null,35,{"$f":"C53*2.5/100","v":{"$error":"#DIV/0!"}}]
[null,null,"System Design Flow Temperature",35,null,45,{"$f":"C54*2.5/100","v":{"$error":"#DIV/0!"}}]
[null,null,"System Equivalent SCOP*",{"$f":"IF(AND(D8=\"Low Temperature Heat Pump\",D60>35),\"HP Not Suitable\",IF(AND(D8=\"Low Temperature Heat Pump\",D60<=35),G59,IF(AND(D60>55,G64=\"\"),\"N/A\",IF(AND(D60>=35,D60<=45),((G60-G59)/(F60-F59)*(D60-F60)+G60),IF(AND(D60>45,D60<=55),((G61-G60)/(F61-F60)*(D60-F61)+G61),((G64-G63)/(F64-F63)*(D60-F64)+G64))))))","v":{"$error":"#DIV/0!"}},null,55,{"$f":"C55*2.5/100","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,65,{"$f":"IF(D9=\"Heat Pump\",\"\",C56*2.5/100)","v":{"$error":"#DIV/0!"}}]
[null,null,"Flow Temperature","Eq SCOP (equivalent to SPF3 SEPEMO SH only)",null,55,{"$f":"IF(G62=\"\",\"\",G61)","v":{"$error":"#DIV/0!"}}]
[null,null,35,{"$f":"IF(D8=\"Low Temperature Heat Pump\",G59,(($G$60-$G$59)/($F$60-$F$59)*(C64-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}},null,65,{"$f":"G62","v":{"$error":"#DIV/0!"}}]
[null,null,36,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C65-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,37,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C66-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,38,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C67-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,39,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C68-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,40,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C69-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,41,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C70-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,42,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C71-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,43,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C72-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,44,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C73-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,45,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",(($G$60-$G$59)/($F$60-$F$59)*(C74-$F$60)+$G$60))","v":{"$error":"#DIV/0!"}}]
[null,null,46,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C75>45,C75<=55),(($G$61-$G$60)/($F$61-$F$60)*(C75-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C75-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,47,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C76>45,C76<=55),(($G$61-$G$60)/($F$61-$F$60)*(C76-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C76-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,48,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C77>45,C77<=55),(($G$61-$G$60)/($F$61-$F$60)*(C77-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C77-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,49,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C78>45,C78<=55),(($G$61-$G$60)/($F$61-$F$60)*(C78-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C78-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,50,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C79>45,C79<=55),(($G$61-$G$60)/($F$61-$F$60)*(C79-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C79-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,51,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C80>45,C80<=55),(($G$61-$G$60)/($F$61-$F$60)*(C80-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C80-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,52,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C81>45,C81<=55),(($G$61-$G$60)/($F$61-$F$60)*(C81-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C81-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,53,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C82>45,C82<=55),(($G$61-$G$60)/($F$61-$F$60)*(C82-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C82-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,54,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C83>45,C83<=55),(($G$61-$G$60)/($F$61-$F$60)*(C83-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C83-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,55,{"$f":"IF(D8=\"Low Temperature Heat Pump\",\"HP Not Suitable for this temerpautre\",IF(AND(C84>45,C84<=55),(($G$61-$G$60)/($F$61-$F$60)*(C84-$F$61)+$G$61),(($G$64-$G$63)/($F$64-$F$63)*(C84-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,56,{"$f":"IF(AND(C85>45,C85<=55),(($G$61-$G$60)/($F$61-$F$60)*(C85-$F$61)+$G$61),IF($D$7=\"No\",\"HP Not suitable for this temperature\",(($G$64-$G$63)/($F$64-$F$63)*(C85-$F$64)+$G$64)))","v":{"$error":"#DIV/0!"}}]
[null,null,57,{"$error":"#DIV/0!"}]
[null,null,58,{"$error":"#DIV/0!"}]
[null,null,59,{"$error":"#DIV/0!"}]
[null,null,60,{"$error":"#DIV/0!"}]
[null,null,61,{"$error":"#DIV/0!"}]
[null,null,62,{"$error":"#DIV/0!"}]
[null,null,63,{"$error":"#DIV/0!"}]
[null,null,64,{"$error":"#DIV/0!"}]
[null,null,65,{"$error":"#DIV/0!"}]
[null,null,"Cells highlighted red indicate at which flow temperature the Heat pump cannot achieve a System Equivalent SCOP of 2.5"]
[null,null,"* System Equivalent SCOP = 2.5 * SSHEE"]

{"sheet":"LOW SPER","index":2,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Summary"]
[null,null,"Climate ","Average",null,null,null,null,null,"Table 1 Number of hours used for heating only - Average Climate",null,null,null,null,"Thermostat-off power PTO",{"$f":"'ErP Inputs'!$D$39","v":0},"kW"]
[null,null,"Tdesignh",-10,"oC",null,null,null,null,"On mode","Thermostat-off mode HTO","Standby mode HSB","Off mode HOFF",null,"Stand by power PSB",{"$f":"'ErP Inputs'!$D$40","v":0},"kW"]
[null,null,"Property Full load (Pdesignh)",{"$f":"'ErP Inputs'!G16","v":0},"kW",null,null,null,"Average Climate (h/y)",{"$f":"M59","v":2065.6153846153843},178,0,3672,null,"Off power POFF",{"$f":"'ErP Inputs'!$D$41","v":0},"kW"]
[null,null,"Primgas",1,null,null,null,null,null,null,null,null,null,null,"Qrefh = Pdesignh x HHE",{"$f":"D7*J7","v":0}]
[null,null,"Primelec",2.5,null,null,null,null,null,null,null,null,null,null,"SAEFh",{"$f":"P8/(P8/M29+K7*P5+L7*P6+M7*P7)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"'ErP Inputs'!D4","v":"Air Source"},null,null,null,null,null,null,null,null,null,null,null,"SPERh",{"$f":"1/(D8/M28+D9/P9)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'ErP Inputs'!D5","v":"Variable Outlet"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correction Factor F(1)",3,"%"]
[null,null,"Part Load Ratio",null,null,{"$f":"IF(D5=\"Average\",\"(Tj-16) / (-10-16) %\",IF(D5=\"Warmer\",\"(Tj-16) / (+2-16) %\",\"(Tj-16) / (-22-16) %\"))","v":"(Tj-16) / (-10-16) %"},null,null,null,null,null,null,null,null,"Correction Factor F(2)",{"$f":"IF(C11=\"Ground Source\",2,IF(C11=\"Water Source\",1,0))","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correction Factor SF(i)",{"$f":"P13+P14","v":3},"%"]
[]
[null,null,"Condition","Bin Temperature","Outdoor heat exchanger","Indoor Heat exchanger","Part Load Ratio","Part Load","GUEhPL(Tj)\n(GCV)","AEFhPL(Tj)","Capacity Ratio","Declared Capacity",null,null,"Seasonal Space Heating Energy Efficiency",{"$f":"100*P11-P15","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"%","kW",null,null,"CR","kW"]
[null,null,null,-15,{"$f":"IF($D$5=\"Average\",\"Not Applicable\",IF($D$5=\"Warmer\",\"Not Applicable\",IF($D$5=\"Colder\",(minus15-16)/(Tdesignh-16),\"Check Value\")))","v":"Not Applicable"},{"$f":"IF($D$5=\"Average\",\"Not Applicable\",IF($D$5=\"Warmer\",\"Not Applicable\",IF($D$5=\"Colder\",(minus15-16)/(Tdesignh-16),\"Check Value\")))","v":"Not Applicable"},null,null,null,null,null,null,null,null,"Seasonal Space Heating Energy Efficiency class",{"$f":"IF(P17>=175,\"A+++\",IF(AND(P17<175,P17>=150),\"A++\",IF(AND(P17<150,P17>=123),\"A+\",IF(AND(P17<123,P17>=115),\"A\",IF(AND(P17<115,P17>=107),\"B\",IF(AND(P17<107,P17>=100),\"C\",IF(AND(P17<100,P17>=61),\"D\",IF(AND(P17<61,P17>=59),\"E\",IF(AND(P17<59,P17>=55),\"F\",\"G\")))))))))","v":{"$error":"#DIV/0!"}}]
[null,null," E (TOL)",{"$f":"IF('ErP Inputs'!D38>-10,-10,IF('ErP Inputs'!D38<Tdesignh,Tdesignh,D10))","v":-10},{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",-10,10))","v":-10},{"$f":"'ErP Inputs'!N19","v":35},{"$f":"(D20-16)/(Tdesignh-16)","v":1},{"$f":"G20*$D$7","v":0},{"$f":"'ErP Inputs'!M21","v":0},{"$f":"'ErP Inputs'!M22","v":0},{"$f":"IF('ErP Inputs'!M23>0,'ErP Inputs'!M23,\"NA\")","v":"NA"},{"$f":"IF(K20=\"NA\",\"NA\",H20/K20)","v":"NA"}]
[null,null,"A",-7,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",-7,10))","v":-7},{"$f":"'ErP Inputs'!F19","v":34},{"$f":"(D21-16)/(Tdesignh-16)","v":0.88461538461538458},{"$f":"G21*$D$7","v":0},{"$f":"'ErP Inputs'!E21","v":0},{"$f":"'ErP Inputs'!E22","v":0},{"$f":"IF('ErP Inputs'!E23>0,'ErP Inputs'!E23,\"NA\")","v":"NA"},{"$f":"IF(K21=\"NA\",\"NA\",H21/K21)","v":"NA"}]
[null,null,"B",2,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",2,10))","v":2},{"$f":"'ErP Inputs'!H19","v":30},{"$f":"(D22-16)/(Tdesignh-16)","v":0.53846153846153844},{"$f":"G22*$D$7","v":0},{"$f":"'ErP Inputs'!G21","v":0},{"$f":"'ErP Inputs'!G22","v":0},{"$f":"IF('ErP Inputs'!G23>0,'ErP Inputs'!G23,\"NA\")","v":"NA"},{"$f":"IF(K22=\"NA\",\"NA\",H22/K22)","v":"NA"}]
[null,null,"C",7,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",7,10))","v":7},{"$f":"'ErP Inputs'!J19","v":27},{"$f":"(D23-16)/(Tdesignh-16)","v":0.34615384615384615},0,{"$f":"'ErP Inputs'!I21","v":0},{"$f":"'ErP Inputs'!I22","v":0},{"$f":"IF('ErP Inputs'!I23>0,'ErP Inputs'!I23,\"NA\")","v":"NA"},"NA"]
[null,null,"D",12,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",12,10))","v":12},{"$f":"'ErP Inputs'!L19","v":24},{"$f":"(D24-16)/(Tdesignh-16)","v":0.15384615384615385},0,{"$f":"'ErP Inputs'!K21","v":0},{"$f":"'ErP Inputs'!K22","v":0},{"$f":"IF('ErP Inputs'!K23>0,'ErP Inputs'!K23,\"NA\")","v":"NA"},"NA"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SGUEhGCV",{"$f":"M60","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SAEFhON",{"$f":"M61","v":{"$error":"#DIV/0!"}}]
[null,null,"Bin","Outdoor temperature (dry bulb)","Hours","Part Load Ratio","Part Load","Annual Heating Demand","Gas Utilization Efficiency","Auxiliary Energy Factor","Gas consumption","Electrical consumption","Equivalent hours"]
[null,null,"binj","Tj","Hj","PLRh(Tj)","Ph(Tj)","Hj*Ph(Tj)","GUEhPL(Tj)\n(GCV)","AEFhPL(Tj)","Hj*Ph(Tj) /\nGUEhPL(Tj)","Hj*Ph(Tj) /\nAEFhPL(Tj)","Hj*PLRh(Tj)"]
[null,null,null,"oC","h/y",null,"kW","kWh"]
[null,null,21,-10,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,24,FALSE)","v":1},{"$f":"(D33-16)/(Tdesignh-16)","v":1},{"$f":"$D$7*F33","v":0},{"$f":"E33*G33","v":0},{"$f":"I20","v":0},{"$f":"J20","v":0},{"$f":"E33*G33/I33","v":{"$error":"#DIV/0!"}},{"$f":"E33*G33/J33","v":{"$error":"#DIV/0!"}},{"$f":"E33*F33","v":1}]
[null,null,22,-9,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,25,FALSE)","v":25},0.96153846153846156,0,0,{"$f":"(I$36-I$33)/($D$36-$D$33)*($D34-$D$33)+I$33","v":0},{"$f":"(J$36-J$33)/($D$36-$D$33)*($D34-$D$33)+J$33","v":0},{"$f":"E34*G34/I34","v":{"$error":"#DIV/0!"}},{"$f":"E34*G34/J34","v":{"$error":"#DIV/0!"}},{"$f":"E34*F34","v":24.03846153846154}]
[null,null,23,-8,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,26,FALSE)","v":23},0.92307692307692313,0,0,{"$f":"(I$36-I$33)/($D$36-$D$33)*($D35-$D$33)+I$33","v":0},{"$f":"(J$36-J$33)/($D$36-$D$33)*($D35-$D$33)+J$33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},21.230769230769234]
[null,null,24,-7,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,27,FALSE)","v":24},0.88461538461538458,0,0,{"$f":"I21","v":0},{"$f":"J21","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},21.23076923076923]
[null,null,25,-6,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,28,FALSE)","v":27},0.84615384615384615,0,0,{"$f":"(I$45-I$36)/($D$45-$D$36)*($D37-$D$36)+I$36","v":0},{"$f":"(J$45-J$36)/($D$45-$D$36)*($D37-$D$36)+J$36","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},22.846153846153847]
[null,null,26,-5,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,29,FALSE)","v":68},0.80769230769230771,0,0,{"$f":"(I$45-I$36)/($D$45-$D$36)*($D38-$D$36)+I$36","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},54.923076923076927]
[null,null,27,-4,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,30,FALSE)","v":91},0.76923076923076927,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},70]
[null,null,28,-3,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,31,FALSE)","v":89},0.73076923076923073,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},65.038461538461533]
[null,null,29,-2,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,32,FALSE)","v":165},0.69230769230769229,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},114.23076923076923]
[null,null,30,-1,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,33,FALSE)","v":173},0.65384615384615385,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},113.11538461538461]
[null,null,31,0,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,34,FALSE)","v":240},0.61538461538461542,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},147.69230769230771]
[null,null,32,1,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,35,FALSE)","v":280},0.57692307692307687,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},161.53846153846152]
[null,null,33,2,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,36,FALSE)","v":320},0.53846153846153844,0,0,{"$f":"I22","v":0},{"$f":"J22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},172.30769230769229]
[null,null,34,3,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,37,FALSE)","v":357},0.5,0,0,{"$f":"(I$50-I$45)/($D$50-$D$45)*($D46-$D$45)+I$45","v":0},{"$f":"(J$50-J$45)/($D$50-$D$45)*($D46-$D$45)+J$45","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},178.5]
[null,null,35,4,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,38,FALSE)","v":356},0.46153846153846156,0,0,{"$f":"(I$50-I$45)/($D$50-$D$45)*($D47-$D$45)+I$45","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},164.30769230769232]
[null,null,36,5,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,39,FALSE)","v":303},0.42307692307692307,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},128.19230769230768]
[null,null,37,6,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,40,FALSE)","v":330},0.38461538461538464,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},126.92307692307693]
[null,null,38,7,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,41,FALSE)","v":326},0.34615384615384615,0,0,{"$f":"I23","v":0},{"$f":"J23","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},112.84615384615384]
[null,null,39,8,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,42,FALSE)","v":348},0.30769230769230771,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D51-$D$50)+I$50","v":0},{"$f":"(J$55-J$50)/($D$55-$D$50)*($D51-$D$50)+J$50","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},107.07692307692308]
[null,null,40,9,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,43,FALSE)","v":335},0.26923076923076922,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D52-$D$50)+I$50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},90.192307692307693]
[null,null,41,10,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,44,FALSE)","v":315},0.23076923076923078,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},72.692307692307693]
[null,null,42,11,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,45,FALSE)","v":215},0.19230769230769232,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},41.346153846153847]
[null,null,43,12,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,46,FALSE)","v":169},0.15384615384615385,0,0,{"$f":"I24","v":0},{"$f":"J24","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},26]
[null,null,44,13,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,47,FALSE)","v":151},0.11538461538461539,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D56-$D$50)+I$50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},17.423076923076923]
[null,null,45,14,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,48,FALSE)","v":105},7.6923076923076927E-2,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},8.0769230769230766]
[null,null,46,15,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,49,FALSE)","v":74},3.8461538461538464E-2,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},2.8461538461538463]
[null,null,null,null,{"$f":"SUM(E33:E58)","v":4910},null,null,{"$f":"SUM(H33:H58)","v":0},null,null,{"$f":"SUM(K33:K58)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L33:L58)","v":{"$error":"#DIV/0!"}},2065.6153846153843]
[null,null,null,null,null,null,null,null,null,null,null,"SGUEhGCV",{"$f":"H59/K59","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SAEFhON",{"$f":"H59/L59","v":{"$error":"#DIV/0!"}}]

{"sheet":"MEDIUM SPER","index":3,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Summary"]
[null,null,"Climate ","Average",null,null,null,null,null,"Table 1 Number of hours used for heating only - Average Climate",null,null,null,null,"Thermostat-off power PTO",{"$f":"'ErP Inputs'!$D$39","v":0},"kW"]
[null,null,"Tdesignh",-10,"oC",null,null,null,null,"On mode","Thermostat-off mode HTO","Standby mode HSB","Off mode HOFF",null,"Stand by power PSB",{"$f":"'ErP Inputs'!$D$40","v":0},"kW"]
[null,null,"Property Full load (Pdesignh)",{"$f":"'ErP Inputs'!I16","v":0},"kW",null,null,null,"Average Climate (h/y)",{"$f":"M59","v":2065.6153846153843},178,0,3672,null,"Off power POFF",{"$f":"'ErP Inputs'!$D$41","v":0},"kW"]
[null,null,"Primgas",1,null,null,null,null,null,null,null,null,null,null,"Qrefh = Pdesignh x HHE",{"$f":"D7*J7","v":0}]
[null,null,"Primelec",2.5,null,null,null,null,null,null,null,null,null,null,"SAEFh",{"$f":"P8/(P8/M29+K7*P5+L7*P6+M7*P7)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"'ErP Inputs'!D4","v":"Air Source"},null,null,null,null,null,null,null,null,null,null,null,"SPERh",{"$f":"1/(D8/M28+D9/P9)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'ErP Inputs'!D5","v":"Variable Outlet"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correction Factor F(1)",3,"%"]
[null,null,"Part Load Ratio",null,null,{"$f":"IF(D5=\"Average\",\"(Tj-16) / (-10-16) %\",IF(D5=\"Warmer\",\"(Tj-16) / (+2-16) %\",\"(Tj-16) / (-22-16) %\"))","v":"(Tj-16) / (-10-16) %"},null,null,null,null,null,null,null,null,"Correction Factor F(2)",{"$f":"IF(C11=\"Ground Source\",2,IF(C11=\"Water Source\",1,0))","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correction Factor SF(i)",{"$f":"P13+P14","v":3},"%"]
[]
[null,null,"Condition","Bin Temperature","Outdoor heat exchanger","Indoor Heat exchanger","Part Load Ratio","Part Load","GUEhPL(Tj)\n(GCV)","AEFhPL(Tj)","Capacity Ratio","Declared Capacity",null,null,"Seasonal Space Heating Energy Efficiency",{"$f":"100*P11-P15","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"%","kW",null,null,"CR","kW"]
[null,null,null,-15,{"$f":"IF($D$5=\"Average\",\"Not Applicable\",IF($D$5=\"Warmer\",\"Not Applicable\",IF($D$5=\"Colder\",(minus15-16)/(Tdesignh-16),\"Check Value\")))","v":"Not Applicable"},{"$f":"IF($D$5=\"Average\",\"Not Applicable\",IF($D$5=\"Warmer\",\"Not Applicable\",IF($D$5=\"Colder\",(minus15-16)/(Tdesignh-16),\"Check Value\")))","v":"Not Applicable"},null,null,null,null,null,null,null,null,"Seasonal Space Heating Energy Efficiency class",{"$f":"IF('ErP Inputs'!D8=\"Low Temperature Heat Pump\",IF(P17>=175,\"A+++\",IF(AND(P17<175,P17>=150),\"A++\",IF(AND(P17<150,P17>=123),\"A+\",IF(AND(P17<123,P17>=115),\"A\",IF(AND(P17<115,P17>=107),\"B\",IF(AND(P17<107,P17>=100),\"C\",IF(AND(P17<100,P17>=61),\"D\",IF(AND(P17<61,P17>=59),\"E\",IF(AND(P17<59,P17>=55),\"F\",\"G\"))))))))),IF(P17>=150,\"A+++\",IF(AND(P17<150,P17>=125),\"A++\",IF(AND(P17<125,P17>=98),\"A+\",IF(AND(P17<98,P17>=90),\"A\",IF(AND(P17<90,P17>=82),\"B\",IF(AND(P17<82,P17>=75),\"C\",IF(AND(P17<75,P17>=36),\"D\",IF(AND(P17<36,P17>=34),\"E\",IF(AND(P17<34,P17>=30),\"F\",\"G\"))))))))))","v":{"$error":"#DIV/0!"}}]
[null,null," E (TOL)",{"$f":"IF('ErP Inputs'!D38>-10,-10,IF('ErP Inputs'!D38<Tdesignh,Tdesignh,D10))","v":-10},{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",-10,10))","v":-10},{"$f":"'ErP Inputs'!N44","v":45},{"$f":"(D20-16)/(Tdesignh-16)","v":1},{"$f":"G20*$D$7","v":0},{"$f":"IF('ErP Inputs'!M46=\"\",(('HIGH SPER'!I20+'LOW SPER'!I20)*0.5),'ErP Inputs'!M46)","v":0},{"$f":"IF('ErP Inputs'!M47=\"\",(('HIGH SPER'!J20+'LOW SPER'!J20)*0.5),'ErP Inputs'!M47)","v":0},{"$f":"IF('ErP Inputs'!M48>0,'ErP Inputs'!M48,\"NA\")","v":"NA"},{"$f":"IF(K20=\"NA\",\"NA\",H20/K20)","v":"NA"}]
[null,null,"A",-7,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",-7,10))","v":-7},{"$f":"'ErP Inputs'!F44","v":43},{"$f":"(D21-16)/(Tdesignh-16)","v":0.88461538461538458},{"$f":"G21*$D$7","v":0},{"$f":"IF('ErP Inputs'!E46=\"\",(('HIGH SPER'!I21+'LOW SPER'!I21)*0.5),'ErP Inputs'!E46)","v":0},{"$f":"IF('ErP Inputs'!E47=\"\",(('HIGH SPER'!J21+'LOW SPER'!J21)*0.5),'ErP Inputs'!E47)","v":0},{"$f":"IF('ErP Inputs'!E48>0,'ErP Inputs'!E48,\"NA\")","v":"NA"},{"$f":"IF(K21=\"NA\",\"NA\",H21/K21)","v":"NA"}]
[null,null,"B",2,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",2,10))","v":2},{"$f":"'ErP Inputs'!H44","v":37},{"$f":"(D22-16)/(Tdesignh-16)","v":0.53846153846153844},{"$f":"G22*$D$7","v":0},{"$f":"IF('ErP Inputs'!G46=\"\",(('HIGH SPER'!I22+'LOW SPER'!I22)*0.5),'ErP Inputs'!G46)","v":0},{"$f":"IF('ErP Inputs'!G47=\"\",(('HIGH SPER'!J22+'LOW SPER'!J22)*0.5),'ErP Inputs'!G47)","v":0},{"$f":"IF('ErP Inputs'!G48>0,'ErP Inputs'!G48,\"NA\")","v":"NA"},{"$f":"IF(K22=\"NA\",\"NA\",H22/K22)","v":"NA"}]
[null,null,"C",7,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",7,10))","v":7},{"$f":"'ErP Inputs'!J44","v":33},{"$f":"(D23-16)/(Tdesignh-16)","v":0.34615384615384615},0,{"$f":"IF('ErP Inputs'!I46=\"\",(('HIGH SPER'!I23+'LOW SPER'!I23)*0.5),'ErP Inputs'!I46)","v":0},{"$f":"IF('ErP Inputs'!I47=\"\",(('HIGH SPER'!J23+'LOW SPER'!J23)*0.5),'ErP Inputs'!I47)","v":0},{"$f":"IF('ErP Inputs'!I48>0,'ErP Inputs'!I48,\"NA\")","v":"NA"},"NA"]
[null,null,"D",12,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",12,10))","v":12},{"$f":"'ErP Inputs'!L44","v":28},{"$f":"(D24-16)/(Tdesignh-16)","v":0.15384615384615385},0,{"$f":"IF('ErP Inputs'!K46=\"\",(('HIGH SPER'!I24+'LOW SPER'!I24)*0.5),'ErP Inputs'!K46)","v":0},{"$f":"IF('ErP Inputs'!K47=\"\",(('HIGH SPER'!J24+'LOW SPER'!J24)*0.5),'ErP Inputs'!K47)","v":0},{"$f":"IF('ErP Inputs'!K48>0,'ErP Inputs'!K48,\"NA\")","v":"NA"},"NA"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SGUEhGCV",{"$f":"M60","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SAEFhON",{"$f":"M61","v":{"$error":"#DIV/0!"}}]
[null,null,"Bin","Outdoor temperature (dry bulb)","Hours","Part Load Ratio","Part Load","Annual Heating Demand","Gas Utilization Efficiency","Auxiliary Energy Factor","Gas consumption","Electrical consumption","Equivalent hours"]
[null,null,"binj","Tj","Hj","PLRh(Tj)","Ph(Tj)","Hj*Ph(Tj)","GUEhPL(Tj)\n(GCV)","AEFhPL(Tj)","Hj*Ph(Tj) /\nGUEhPL(Tj)","Hj*Ph(Tj) /\nAEFhPL(Tj)","Hj*PLRh(Tj)"]
[null,null,null,"oC","h/y",null,"kW","kWh"]
[null,null,21,-10,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,24,FALSE)","v":1},{"$f":"(D33-16)/(Tdesignh-16)","v":1},{"$f":"$D$7*F33","v":0},{"$f":"E33*G33","v":0},{"$f":"I20","v":0},{"$f":"J20","v":0},{"$f":"E33*G33/I33","v":{"$error":"#DIV/0!"}},{"$f":"E33*G33/J33","v":{"$error":"#DIV/0!"}},{"$f":"E33*F33","v":1}]
[null,null,22,-9,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,25,FALSE)","v":25},0.96153846153846156,0,0,{"$f":"(I$36-I$33)/($D$36-$D$33)*($D34-$D$33)+I$33","v":0},{"$f":"(J$36-J$33)/($D$36-$D$33)*($D34-$D$33)+J$33","v":0},{"$f":"E34*G34/I34","v":{"$error":"#DIV/0!"}},{"$f":"E34*G34/J34","v":{"$error":"#DIV/0!"}},{"$f":"E34*F34","v":24.03846153846154}]
[null,null,23,-8,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,26,FALSE)","v":23},0.92307692307692313,0,0,{"$f":"(I$36-I$33)/($D$36-$D$33)*($D35-$D$33)+I$33","v":0},{"$f":"(J$36-J$33)/($D$36-$D$33)*($D35-$D$33)+J$33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},21.230769230769234]
[null,null,24,-7,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,27,FALSE)","v":24},0.88461538461538458,0,0,{"$f":"I21","v":0},{"$f":"J21","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},21.23076923076923]
[null,null,25,-6,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,28,FALSE)","v":27},0.84615384615384615,0,0,{"$f":"(I$45-I$36)/($D$45-$D$36)*($D37-$D$36)+I$36","v":0},{"$f":"(J$45-J$36)/($D$45-$D$36)*($D37-$D$36)+J$36","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},22.846153846153847]
[null,null,26,-5,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,29,FALSE)","v":68},0.80769230769230771,0,0,{"$f":"(I$45-I$36)/($D$45-$D$36)*($D38-$D$36)+I$36","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},54.923076923076927]
[null,null,27,-4,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,30,FALSE)","v":91},0.76923076923076927,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},70]
[null,null,28,-3,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,31,FALSE)","v":89},0.73076923076923073,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},65.038461538461533]
[null,null,29,-2,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,32,FALSE)","v":165},0.69230769230769229,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},114.23076923076923]
[null,null,30,-1,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,33,FALSE)","v":173},0.65384615384615385,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},113.11538461538461]
[null,null,31,0,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,34,FALSE)","v":240},0.61538461538461542,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},147.69230769230771]
[null,null,32,1,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,35,FALSE)","v":280},0.57692307692307687,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},161.53846153846152]
[null,null,33,2,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,36,FALSE)","v":320},0.53846153846153844,0,0,{"$f":"I22","v":0},{"$f":"J22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},172.30769230769229]
[null,null,34,3,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,37,FALSE)","v":357},0.5,0,0,{"$f":"(I$50-I$45)/($D$50-$D$45)*($D46-$D$45)+I$45","v":0},{"$f":"(J$50-J$45)/($D$50-$D$45)*($D46-$D$45)+J$45","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},178.5]
[null,null,35,4,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,38,FALSE)","v":356},0.46153846153846156,0,0,{"$f":"(I$50-I$45)/($D$50-$D$45)*($D47-$D$45)+I$45","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},164.30769230769232]
[null,null,36,5,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,39,FALSE)","v":303},0.42307692307692307,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},128.19230769230768]
[null,null,37,6,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,40,FALSE)","v":330},0.38461538461538464,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},126.92307692307693]
[null,null,38,7,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,41,FALSE)","v":326},0.34615384615384615,0,0,{"$f":"I23","v":0},{"$f":"J23","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},112.84615384615384]
[null,null,39,8,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,42,FALSE)","v":348},0.30769230769230771,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D51-$D$50)+I$50","v":0},{"$f":"(J$55-J$50)/($D$55-$D$50)*($D51-$D$50)+J$50","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},107.07692307692308]
[null,null,40,9,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,43,FALSE)","v":335},0.26923076923076922,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D52-$D$50)+I$50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},90.192307692307693]
[null,null,41,10,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,44,FALSE)","v":315},0.23076923076923078,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},72.692307692307693]
[null,null,42,11,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,45,FALSE)","v":215},0.19230769230769232,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},41.346153846153847]
[null,null,43,12,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,46,FALSE)","v":169},0.15384615384615385,0,0,{"$f":"I24","v":0},{"$f":"J24","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},26]
[null,null,44,13,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,47,FALSE)","v":151},0.11538461538461539,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D56-$D$50)+I$50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},17.423076923076923]
[null,null,45,14,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,48,FALSE)","v":105},7.6923076923076927E-2,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},8.0769230769230766]
[null,null,46,15,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,49,FALSE)","v":74},3.8461538461538464E-2,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},2.8461538461538463]
[null,null,null,null,{"$f":"SUM(E33:E58)","v":4910},null,null,{"$f":"SUM(H33:H58)","v":0},null,null,{"$f":"SUM(K33:K58)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L33:L58)","v":{"$error":"#DIV/0!"}},2065.6153846153843]
[null,null,null,null,null,null,null,null,null,null,null,"SGUEhGCV",{"$f":"H59/K59","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SAEFhON",{"$f":"H59/L59","v":{"$error":"#DIV/0!"}}]

{"sheet":"HIGH SPER","index":4,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Summary"]
[null,null,"Climate ","Average",null,null,null,null,null,"Table 1 Number of hours used for heating only - Average Climate",null,null,null,null,"Thermostat-off power PTO",{"$f":"'ErP Inputs'!$D$39","v":0},"kW"]
[null,null,"Tdesignh",-10,"oC",null,null,null,null,"On mode","Thermostat-off mode HTO","Standby mode HSB","Off mode HOFF",null,"Stand by power PSB",{"$f":"'ErP Inputs'!$D$40","v":0},"kW"]
[null,null,"Property Full load (Pdesignh)",{"$f":"'ErP Inputs'!K16","v":0},"kW",null,null,null,"Average Climate (h/y)",{"$f":"M59","v":2065.6153846153843},178,0,3672,null,"Off power POFF",{"$f":"'ErP Inputs'!$D$41","v":0},"kW"]
[null,null,"Primgas",1,null,null,null,null,null,null,null,null,null,null,"Qrefh = Pdesignh x HHE",{"$f":"D7*J7","v":0}]
[null,null,"Primelec",2.5,null,null,null,null,null,null,null,null,null,null,"SAEFh",{"$f":"P8/(P8/M29+K7*P5+L7*P6+M7*P7)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"'ErP Inputs'!D4","v":"Air Source"},null,null,null,null,null,null,null,null,null,null,null,"SPERh",{"$f":"1/(D8/M28+D9/P9)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'ErP Inputs'!D5","v":"Variable Outlet"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correction Factor F(1)",3,"%"]
[null,null,"Part Load Ratio",null,null,{"$f":"IF(D5=\"Average\",\"(Tj-16) / (-10-16) %\",IF(D5=\"Warmer\",\"(Tj-16) / (+2-16) %\",\"(Tj-16) / (-22-16) %\"))","v":"(Tj-16) / (-10-16) %"},null,null,null,null,null,null,null,null,"Correction Factor F(2)",{"$f":"IF(C11=\"Ground Source\",2,IF(C11=\"Water Source\",1,0))","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correction Factor SF(i)",{"$f":"P13+P14","v":3},"%"]
[]
[null,null,"Condition","Bin Temperature","Outdoor heat exchanger","Indoor Heat exchanger","Part Load Ratio","Part Load","GUEhPL(Tj)\n(GCV)","AEFhPL(Tj)","Capacity Ratio","Declared Capacity",null,null,"Seasonal Space Heating Energy Efficiency",{"$f":"100*P11-P15","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"%","kW",null,null,"CR","kW"]
[null,null,null,-15,{"$f":"IF($D$5=\"Average\",\"Not Applicable\",IF($D$5=\"Warmer\",\"Not Applicable\",IF($D$5=\"Colder\",(minus15-16)/(Tdesignh-16),\"Check Value\")))","v":"Not Applicable"},{"$f":"IF($D$5=\"Average\",\"Not Applicable\",IF($D$5=\"Warmer\",\"Not Applicable\",IF($D$5=\"Colder\",(minus15-16)/(Tdesignh-16),\"Check Value\")))","v":"Not Applicable"},null,null,null,null,null,null,null,null,"Seasonal Space Heating Energy Efficiency class",{"$f":"IF('ErP Inputs'!D8=\"Low Temperature Heat Pump\",IF(P17>=175,\"A+++\",IF(AND(P17<175,P17>=150),\"A++\",IF(AND(P17<150,P17>=123),\"A+\",IF(AND(P17<123,P17>=115),\"A\",IF(AND(P17<115,P17>=107),\"B\",IF(AND(P17<107,P17>=100),\"C\",IF(AND(P17<100,P17>=61),\"D\",IF(AND(P17<61,P17>=59),\"E\",IF(AND(P17<59,P17>=55),\"F\",\"G\"))))))))),IF(P17>=150,\"A+++\",IF(AND(P17<150,P17>=125),\"A++\",IF(AND(P17<125,P17>=98),\"A+\",IF(AND(P17<98,P17>=90),\"A\",IF(AND(P17<90,P17>=82),\"B\",IF(AND(P17<82,P17>=75),\"C\",IF(AND(P17<75,P17>=36),\"D\",IF(AND(P17<36,P17>=34),\"E\",IF(AND(P17<34,P17>=30),\"F\",\"G\"))))))))))","v":{"$error":"#DIV/0!"}}]
[null,null," E (TOL)",{"$f":"IF('ErP Inputs'!D38>-10,-10,IF('ErP Inputs'!D38<Tdesignh,Tdesignh,D10))","v":-10},{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",-10,10))","v":-10},{"$f":"'ErP Inputs'!N24","v":55},{"$f":"(D20-16)/(Tdesignh-16)","v":1},{"$f":"G20*$D$7","v":0},{"$f":"'ErP Inputs'!M26","v":0},{"$f":"'ErP Inputs'!M27","v":0},{"$f":"IF('ErP Inputs'!M28>0,'ErP Inputs'!M28,\"NA\")","v":"NA"},{"$f":"IF(K20=\"NA\",\"NA\",H20/K20)","v":"NA"}]
[null,null,"A",-7,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",-7,10))","v":-7},{"$f":"'ErP Inputs'!F24","v":52},{"$f":"(D21-16)/(Tdesignh-16)","v":0.88461538461538458},{"$f":"G21*$D$7","v":0},{"$f":"'ErP Inputs'!E26","v":0},{"$f":"'ErP Inputs'!E27","v":0},{"$f":"IF('ErP Inputs'!E28>0,'ErP Inputs'!E28,\"NA\")","v":"NA"},{"$f":"IF(K21=\"NA\",\"NA\",H21/K21)","v":"NA"}]
[null,null,"B",2,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",2,10))","v":2},{"$f":"'ErP Inputs'!H24","v":42},{"$f":"(D22-16)/(Tdesignh-16)","v":0.53846153846153844},{"$f":"G22*$D$7","v":0},{"$f":"'ErP Inputs'!G26","v":0},{"$f":"'ErP Inputs'!G27","v":0},{"$f":"IF('ErP Inputs'!G28>0,'ErP Inputs'!G28,\"NA\")","v":"NA"},{"$f":"IF(K22=\"NA\",\"NA\",H22/K22)","v":"NA"}]
[null,null,"C",7,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",7,10))","v":7},{"$f":"'ErP Inputs'!J24","v":36},{"$f":"(D23-16)/(Tdesignh-16)","v":0.34615384615384615},0,{"$f":"'ErP Inputs'!I26","v":0},{"$f":"'ErP Inputs'!I27","v":0},{"$f":"IF('ErP Inputs'!I28>0,'ErP Inputs'!I28,\"NA\")","v":"NA"},"NA"]
[null,null,"D",12,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",12,10))","v":12},{"$f":"'ErP Inputs'!L24","v":30},{"$f":"(D24-16)/(Tdesignh-16)","v":0.15384615384615385},0,{"$f":"'ErP Inputs'!K26","v":0},{"$f":"'ErP Inputs'!K27","v":0},{"$f":"IF('ErP Inputs'!K28>0,'ErP Inputs'!K28,\"NA\")","v":"NA"},"NA"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SGUEhGCV",{"$f":"M60","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SAEFhON",{"$f":"M61","v":{"$error":"#DIV/0!"}}]
[null,null,"Bin","Outdoor temperature (dry bulb)","Hours","Part Load Ratio","Part Load","Annual Heating Demand","Gas Utilization Efficiency","Auxiliary Energy Factor","Gas consumption","Electrical consumption","Equivalent hours"]
[null,null,"binj","Tj","Hj","PLRh(Tj)","Ph(Tj)","Hj*Ph(Tj)","GUEhPL(Tj)\n(GCV)","AEFhPL(Tj)","Hj*Ph(Tj) /\nGUEhPL(Tj)","Hj*Ph(Tj) /\nAEFhPL(Tj)","Hj*PLRh(Tj)"]
[null,null,null,"oC","h/y",null,"kW","kWh"]
[null,null,21,-10,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,24,FALSE)","v":1},{"$f":"(D33-16)/(Tdesignh-16)","v":1},{"$f":"$D$7*F33","v":0},{"$f":"E33*G33","v":0},{"$f":"I20","v":0},{"$f":"J20","v":0},{"$f":"E33*G33/I33","v":{"$error":"#DIV/0!"}},{"$f":"E33*G33/J33","v":{"$error":"#DIV/0!"}},{"$f":"E33*F33","v":1}]
[null,null,22,-9,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,25,FALSE)","v":25},0.96153846153846156,0,0,{"$f":"(I$36-I$33)/($D$36-$D$33)*($D34-$D$33)+I$33","v":0},{"$f":"(J$36-J$33)/($D$36-$D$33)*($D34-$D$33)+J$33","v":0},{"$f":"E34*G34/I34","v":{"$error":"#DIV/0!"}},{"$f":"E34*G34/J34","v":{"$error":"#DIV/0!"}},{"$f":"E34*F34","v":24.03846153846154}]
[null,null,23,-8,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,26,FALSE)","v":23},0.92307692307692313,0,0,{"$f":"(I$36-I$33)/($D$36-$D$33)*($D35-$D$33)+I$33","v":0},{"$f":"(J$36-J$33)/($D$36-$D$33)*($D35-$D$33)+J$33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},21.230769230769234]
[null,null,24,-7,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,27,FALSE)","v":24},0.88461538461538458,0,0,{"$f":"I21","v":0},{"$f":"J21","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},21.23076923076923]
[null,null,25,-6,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,28,FALSE)","v":27},0.84615384615384615,0,0,{"$f":"(I$45-I$36)/($D$45-$D$36)*($D37-$D$36)+I$36","v":0},{"$f":"(J$45-J$36)/($D$45-$D$36)*($D37-$D$36)+J$36","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},22.846153846153847]
[null,null,26,-5,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,29,FALSE)","v":68},0.80769230769230771,0,0,{"$f":"(I$45-I$36)/($D$45-$D$36)*($D38-$D$36)+I$36","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},54.923076923076927]
[null,null,27,-4,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,30,FALSE)","v":91},0.76923076923076927,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},70]
[null,null,28,-3,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,31,FALSE)","v":89},0.73076923076923073,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},65.038461538461533]
[null,null,29,-2,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,32,FALSE)","v":165},0.69230769230769229,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},114.23076923076923]
[null,null,30,-1,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,33,FALSE)","v":173},0.65384615384615385,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},113.11538461538461]
[null,null,31,0,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,34,FALSE)","v":240},0.61538461538461542,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},147.69230769230771]
[null,null,32,1,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,35,FALSE)","v":280},0.57692307692307687,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},161.53846153846152]
[null,null,33,2,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,36,FALSE)","v":320},0.53846153846153844,0,0,{"$f":"I22","v":0},{"$f":"J22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},172.30769230769229]
[null,null,34,3,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,37,FALSE)","v":357},0.5,0,0,{"$f":"(I$50-I$45)/($D$50-$D$45)*($D46-$D$45)+I$45","v":0},{"$f":"(J$50-J$45)/($D$50-$D$45)*($D46-$D$45)+J$45","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},178.5]
[null,null,35,4,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,38,FALSE)","v":356},0.46153846153846156,0,0,{"$f":"(I$50-I$45)/($D$50-$D$45)*($D47-$D$45)+I$45","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},164.30769230769232]
[null,null,36,5,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,39,FALSE)","v":303},0.42307692307692307,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},128.19230769230768]
[null,null,37,6,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,40,FALSE)","v":330},0.38461538461538464,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},126.92307692307693]
[null,null,38,7,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,41,FALSE)","v":326},0.34615384615384615,0,0,{"$f":"I23","v":0},{"$f":"J23","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},112.84615384615384]
[null,null,39,8,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,42,FALSE)","v":348},0.30769230769230771,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D51-$D$50)+I$50","v":0},{"$f":"(J$55-J$50)/($D$55-$D$50)*($D51-$D$50)+J$50","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},107.07692307692308]
[null,null,40,9,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,43,FALSE)","v":335},0.26923076923076922,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D52-$D$50)+I$50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},90.192307692307693]
[null,null,41,10,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,44,FALSE)","v":315},0.23076923076923078,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},72.692307692307693]
[null,null,42,11,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,45,FALSE)","v":215},0.19230769230769232,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},41.346153846153847]
[null,null,43,12,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,46,FALSE)","v":169},0.15384615384615385,0,0,{"$f":"I24","v":0},{"$f":"J24","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},26]
[null,null,44,13,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,47,FALSE)","v":151},0.11538461538461539,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D56-$D$50)+I$50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},17.423076923076923]
[null,null,45,14,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,48,FALSE)","v":105},7.6923076923076927E-2,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},8.0769230769230766]
[null,null,46,15,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,49,FALSE)","v":74},3.8461538461538464E-2,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},2.8461538461538463]
[null,null,null,null,{"$f":"SUM(E33:E58)","v":4910},null,null,{"$f":"SUM(H33:H58)","v":0},null,null,{"$f":"SUM(K33:K58)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L33:L58)","v":{"$error":"#DIV/0!"}},2065.6153846153843]
[null,null,null,null,null,null,null,null,null,null,null,"SGUEhGCV",{"$f":"H59/K59","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SAEFhON",{"$f":"H59/L59","v":{"$error":"#DIV/0!"}}]

{"sheet":"VERY HIGH SPER","index":5,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Summary"]
[null,null,"Climate ","Average",null,null,null,null,null,"Table 1 Number of hours used for heating only - Average Climate",null,null,null,null,"Thermostat-off power PTO",{"$f":"'ErP Inputs'!$D$39","v":0},"kW"]
[null,null,"Tdesignh",-10,"oC",null,null,null,null,"On mode","Thermostat-off mode HTO","Standby mode HSB","Off mode HOFF",null,"Stand by power PSB",{"$f":"'ErP Inputs'!$D$40","v":0},"kW"]
[null,null,"Property Full load (Pdesignh)",{"$f":"'ErP Inputs'!M16","v":0},"kW",null,null,null,"Average Climate (h/y)",{"$f":"M59","v":2065.6153846153843},178,0,3672,null,"Off power POFF",{"$f":"'ErP Inputs'!$D$41","v":0},"kW"]
[null,null,"Primgas",1,null,null,null,null,null,null,null,null,null,null,"Qrefh = Pdesignh x HHE",{"$f":"D7*J7","v":0}]
[null,null,"Primelec",2.5,null,null,null,null,null,null,null,null,null,null,"SAEFh",{"$f":"P8/(P8/M29+K7*P5+L7*P6+M7*P7)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"'ErP Inputs'!D4","v":"Air Source"},null,null,null,null,null,null,null,null,null,null,null,"SPERh",{"$f":"1/(D8/M28+D9/P9)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'ErP Inputs'!D5","v":"Variable Outlet"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correction Factor F(1)",3,"%"]
[null,null,"Part Load Ratio",null,null,{"$f":"IF(D5=\"Average\",\"(Tj-16) / (-10-16) %\",IF(D5=\"Warmer\",\"(Tj-16) / (+2-16) %\",\"(Tj-16) / (-22-16) %\"))","v":"(Tj-16) / (-10-16) %"},null,null,null,null,null,null,null,null,"Correction Factor F(2)",{"$f":"IF(C11=\"Ground Source\",2,IF(C11=\"Water Source\",1,0))","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correction Factor SF(i)",{"$f":"P13+P14","v":3},"%"]
[]
[null,null,"Condition","Bin Temperature","Outdoor heat exchanger","Indoor Heat exchanger","Part Load Ratio","Part Load","GUEhPL(Tj)\n(GCV)","AEFhPL(Tj)","Capacity Ratio","Declared Capacity",null,null,"Seasonal Space Heating Energy Efficiency",{"$f":"100*P11-P15","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"%","kW",null,null,"CR","kW"]
[null,null,null,-15,{"$f":"IF($D$5=\"Average\",\"Not Applicable\",IF($D$5=\"Warmer\",\"Not Applicable\",IF($D$5=\"Colder\",(minus15-16)/(Tdesignh-16),\"Check Value\")))","v":"Not Applicable"},{"$f":"IF($D$5=\"Average\",\"Not Applicable\",IF($D$5=\"Warmer\",\"Not Applicable\",IF($D$5=\"Colder\",(minus15-16)/(Tdesignh-16),\"Check Value\")))","v":"Not Applicable"},null,null,null,null,null,null,null,null,"Seasonal Space Heating Energy Efficiency class",{"$f":"IF('ErP Inputs'!D8=\"Low Temperature Heat Pump\",IF(P17>=175,\"A+++\",IF(AND(P17<175,P17>=150),\"A++\",IF(AND(P17<150,P17>=123),\"A+\",IF(AND(P17<123,P17>=115),\"A\",IF(AND(P17<115,P17>=107),\"B\",IF(AND(P17<107,P17>=100),\"C\",IF(AND(P17<100,P17>=61),\"D\",IF(AND(P17<61,P17>=59),\"E\",IF(AND(P17<59,P17>=55),\"F\",\"G\"))))))))),IF(P17>=150,\"A+++\",IF(AND(P17<150,P17>=125),\"A++\",IF(AND(P17<125,P17>=98),\"A+\",IF(AND(P17<98,P17>=90),\"A\",IF(AND(P17<90,P17>=82),\"B\",IF(AND(P17<82,P17>=75),\"C\",IF(AND(P17<75,P17>=36),\"D\",IF(AND(P17<36,P17>=34),\"E\",IF(AND(P17<34,P17>=30),\"F\",\"G\"))))))))))","v":{"$error":"#DIV/0!"}}]
[null,null," E (TOL)",{"$f":"IF('ErP Inputs'!D38>-10,-10,IF('ErP Inputs'!D38<Tdesignh,Tdesignh,D10))","v":-10},{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",-10,10))","v":-10},{"$f":"'ErP Inputs'!N29","v":65},{"$f":"(D20-16)/(Tdesignh-16)","v":1},{"$f":"G20*$D$7","v":0},{"$f":"'ErP Inputs'!M31","v":0},{"$f":"'ErP Inputs'!M32","v":0},{"$f":"IF('ErP Inputs'!M33>0,'ErP Inputs'!M33,\"NA\")","v":"NA"},{"$f":"IF(K20=\"NA\",\"NA\",H20/K20)","v":"NA"}]
[null,null,"A",-7,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",-7,10))","v":-7},{"$f":"'ErP Inputs'!F29","v":61},{"$f":"(D21-16)/(Tdesignh-16)","v":0.88461538461538458},{"$f":"G21*$D$7","v":0},{"$f":"'ErP Inputs'!E31","v":0},{"$f":"'ErP Inputs'!E32","v":0},{"$f":"IF('ErP Inputs'!E33>0,'ErP Inputs'!E33,\"NA\")","v":"NA"},{"$f":"IF(K21=\"NA\",\"NA\",H21/K21)","v":"NA"}]
[null,null,"B",2,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",2,10))","v":2},{"$f":"'ErP Inputs'!H29","v":49},{"$f":"(D22-16)/(Tdesignh-16)","v":0.53846153846153844},{"$f":"G22*$D$7","v":0},{"$f":"'ErP Inputs'!G31","v":0},{"$f":"'ErP Inputs'!G32","v":0},{"$f":"IF('ErP Inputs'!G33>0,'ErP Inputs'!G33,\"NA\")","v":"NA"},{"$f":"IF(K22=\"NA\",\"NA\",H22/K22)","v":"NA"}]
[null,null,"C",7,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",7,10))","v":7},{"$f":"'ErP Inputs'!J29","v":41},{"$f":"(D23-16)/(Tdesignh-16)","v":0.34615384615384615},0,{"$f":"'ErP Inputs'!I31","v":0},{"$f":"'ErP Inputs'!I32","v":0},{"$f":"IF('ErP Inputs'!I33>0,'ErP Inputs'!I33,\"NA\")","v":"NA"},"NA"]
[null,null,"D",12,{"$f":"IF('ErP Inputs'!D4=\"Ground Source\",0,IF('ErP Inputs'!D4=\"Air Source\",12,10))","v":12},{"$f":"'ErP Inputs'!L29","v":32},{"$f":"(D24-16)/(Tdesignh-16)","v":0.15384615384615385},0,{"$f":"'ErP Inputs'!K31","v":0},{"$f":"'ErP Inputs'!K32","v":0},{"$f":"IF('ErP Inputs'!K33>0,'ErP Inputs'!K33,\"NA\")","v":"NA"},"NA"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SGUEhGCV",{"$f":"M60","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SAEFhON",{"$f":"M61","v":{"$error":"#DIV/0!"}}]
[null,null,"Bin","Outdoor temperature (dry bulb)","Hours","Part Load Ratio","Part Load","Annual Heating Demand","Gas Utilization Efficiency","Auxiliary Energy Factor","Gas consumption","Electrical consumption","Equivalent hours"]
[null,null,"binj","Tj","Hj","PLRh(Tj)","Ph(Tj)","Hj*Ph(Tj)","GUEhPL(Tj)\n(GCV)","AEFhPL(Tj)","Hj*Ph(Tj) /\nGUEhPL(Tj)","Hj*Ph(Tj) /\nAEFhPL(Tj)","Hj*PLRh(Tj)"]
[null,null,null,"oC","h/y",null,"kW","kWh"]
[null,null,21,-10,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,24,FALSE)","v":1},{"$f":"(D33-16)/(Tdesignh-16)","v":1},{"$f":"$D$7*F33","v":0},{"$f":"E33*G33","v":0},{"$f":"I20","v":0},{"$f":"J20","v":0},{"$f":"E33*G33/I33","v":{"$error":"#DIV/0!"}},{"$f":"E33*G33/J33","v":{"$error":"#DIV/0!"}},{"$f":"E33*F33","v":1}]
[null,null,22,-9,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,25,FALSE)","v":25},0.96153846153846156,0,0,{"$f":"(I$36-I$33)/($D$36-$D$33)*($D34-$D$33)+I$33","v":0},{"$f":"(J$36-J$33)/($D$36-$D$33)*($D34-$D$33)+J$33","v":0},{"$f":"E34*G34/I34","v":{"$error":"#DIV/0!"}},{"$f":"E34*G34/J34","v":{"$error":"#DIV/0!"}},{"$f":"E34*F34","v":24.03846153846154}]
[null,null,23,-8,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,26,FALSE)","v":23},0.92307692307692313,0,0,{"$f":"(I$36-I$33)/($D$36-$D$33)*($D35-$D$33)+I$33","v":0},{"$f":"(J$36-J$33)/($D$36-$D$33)*($D35-$D$33)+J$33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},21.230769230769234]
[null,null,24,-7,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,27,FALSE)","v":24},0.88461538461538458,0,0,{"$f":"I21","v":0},{"$f":"J21","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},21.23076923076923]
[null,null,25,-6,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,28,FALSE)","v":27},0.84615384615384615,0,0,{"$f":"(I$45-I$36)/($D$45-$D$36)*($D37-$D$36)+I$36","v":0},{"$f":"(J$45-J$36)/($D$45-$D$36)*($D37-$D$36)+J$36","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},22.846153846153847]
[null,null,26,-5,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,29,FALSE)","v":68},0.80769230769230771,0,0,{"$f":"(I$45-I$36)/($D$45-$D$36)*($D38-$D$36)+I$36","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},54.923076923076927]
[null,null,27,-4,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,30,FALSE)","v":91},0.76923076923076927,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},70]
[null,null,28,-3,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,31,FALSE)","v":89},0.73076923076923073,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},65.038461538461533]
[null,null,29,-2,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,32,FALSE)","v":165},0.69230769230769229,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},114.23076923076923]
[null,null,30,-1,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,33,FALSE)","v":173},0.65384615384615385,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},113.11538461538461]
[null,null,31,0,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,34,FALSE)","v":240},0.61538461538461542,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},147.69230769230771]
[null,null,32,1,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,35,FALSE)","v":280},0.57692307692307687,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},161.53846153846152]
[null,null,33,2,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,36,FALSE)","v":320},0.53846153846153844,0,0,{"$f":"I22","v":0},{"$f":"J22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},172.30769230769229]
[null,null,34,3,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,37,FALSE)","v":357},0.5,0,0,{"$f":"(I$50-I$45)/($D$50-$D$45)*($D46-$D$45)+I$45","v":0},{"$f":"(J$50-J$45)/($D$50-$D$45)*($D46-$D$45)+J$45","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},178.5]
[null,null,35,4,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,38,FALSE)","v":356},0.46153846153846156,0,0,{"$f":"(I$50-I$45)/($D$50-$D$45)*($D47-$D$45)+I$45","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},164.30769230769232]
[null,null,36,5,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,39,FALSE)","v":303},0.42307692307692307,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},128.19230769230768]
[null,null,37,6,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,40,FALSE)","v":330},0.38461538461538464,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},126.92307692307693]
[null,null,38,7,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,41,FALSE)","v":326},0.34615384615384615,0,0,{"$f":"I23","v":0},{"$f":"J23","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},112.84615384615384]
[null,null,39,8,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,42,FALSE)","v":348},0.30769230769230771,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D51-$D$50)+I$50","v":0},{"$f":"(J$55-J$50)/($D$55-$D$50)*($D51-$D$50)+J$50","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},107.07692307692308]
[null,null,40,9,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,43,FALSE)","v":335},0.26923076923076922,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D52-$D$50)+I$50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},90.192307692307693]
[null,null,41,10,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,44,FALSE)","v":315},0.23076923076923078,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},72.692307692307693]
[null,null,42,11,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,45,FALSE)","v":215},0.19230769230769232,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},41.346153846153847]
[null,null,43,12,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,46,FALSE)","v":169},0.15384615384615385,0,0,{"$f":"I24","v":0},{"$f":"J24","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},26]
[null,null,44,13,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,47,FALSE)","v":151},0.11538461538461539,0,0,{"$f":"(I$55-I$50)/($D$55-$D$50)*($D56-$D$50)+I$50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},17.423076923076923]
[null,null,45,14,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,48,FALSE)","v":105},7.6923076923076927E-2,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},8.0769230769230766]
[null,null,46,15,{"$f":"HLOOKUP($D$5,'Table 37'!$B$3:$F$51,49,FALSE)","v":74},3.8461538461538464E-2,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},2.8461538461538463]
[null,null,null,null,{"$f":"SUM(E33:E58)","v":4910},null,null,{"$f":"SUM(H33:H58)","v":0},null,null,{"$f":"SUM(K33:K58)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L33:L58)","v":{"$error":"#DIV/0!"}},2065.6153846153843]
[null,null,null,null,null,null,null,null,null,null,null,"SGUEhGCV",{"$f":"H59/K59","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SAEFhON",{"$f":"H59/L59","v":{"$error":"#DIV/0!"}}]

{"sheet":"Table 37","index":6,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 37 - j,Tj& hj reference heating seasons"]
[null,null,null,"Warmer","Average","Colder"]
[null,"j","Tj","hjW","hjA","hjC"]
[null,null,"°C","h","h","h"]
[null,1,-30,0,0,0]
[null,2,-29,0,0,0]
[null,3,-28,0,0,0]
[null,4,-27,0,0,0]
[null,5,-26,0,0,0]
[null,6,-25,0,0,0]
[null,7,-24,0,0,0]
[null,8,-23,0,0,0]
[null,9,-22,0,0,1]
[null,10,-21,0,0,6]
[null,11,-20,0,0,13]
[null,12,-19,0,0,17]
[null,13,-18,0,0,19]
[null,14,-17,0,0,26]
[null,15,-16,0,0,39]
[null,16,-15,0,0,41]
[null,17,-14,0,0,35]
[null,18,-13,0,0,52]
[null,19,-12,0,0,37]
[null,20,-11,0,0,41]
[null,21,-10,0,1,43]
[null,22,-9,0,25,54]
[null,23,-8,0,23,90]
[null,24,-7,0,24,125]
[null,25,-6,0,27,169]
[null,26,-5,0,68,195]
[null,27,-4,0,91,278]
[null,28,-3,0,89,306]
[null,29,-2,0,165,454]
[null,30,-1,0,173,385]
[null,31,0,0,240,490]
[null,32,1,0,280,533]
[null,33,2,3,320,380]
[null,34,3,22,357,228]
[null,35,4,63,356,261]
[null,36,5,63,303,279]
[null,37,6,175,330,229]
[null,38,7,162,326,269]
[null,39,8,259,348,233]
[null,40,9,360,335,230]
[null,41,10,428,315,243]
[null,42,11,430,215,191]
[null,43,12,503,169,146]
[null,44,13,444,151,150]
[null,45,14,384,105,97]
[null,46,15,294,74,61]
[null,null,"Total",{"$f":"SUM(D6:D51)","v":3590},{"$f":"SUM(E6:E51)","v":4910},{"$f":"SUM(F6:F51)","v":6446}]

{"sheet":"Version Control","index":7,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AMENDMENTS SINCE PUBLICATION"]
[]
[null,"DATE","ISSUE","NOTES"]
[null,"2015-05-01",1,"First version published"]
[null,"2015-11-16",2,"amendement to classification of heat pumps in low temperature application (unconditioned reference to Table 2 of Regulation 811/2013)"]
[null,"2019-07-22",2.1,"Rebranding of document, update of email and website addresses and cosmetic changes."]