{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculator","HOT2000 Data","Step Code Levels","Rounding Calculations"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":3,"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":"Calculator","index":0,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[14,4,14,5],[13,4,13,5],[26,1,26,8],[28,14,29,14],[30,14,31,14],[26,14,27,14],[26,11,26,12],[27,11,27,12]]}
[null,"Energy Step Code Compliance Calculator ",null,null,null,null,null,null,"Version 1.0 (Jan 24, 2018)"]
[]
[null,"Instructions:"]
[null,"This calculator is to be used in conjunction with the BC Energy Compliance Report Instruction Manual"]
[]
[null,"1) HOT2000 Data: Set HOT2000 to metric and enter energy modelling data from the HOT2000 file in to the Yellow Cells. Enter all values to the hundredth decimal place (2 numbers after the decimal)."]
[null,"2) Step Level and Climate Zone: Select the step level and climate zone to set minimum requirements for the required Step."]
[null,"3) Results: The Compliance Calculator will indicate which of the metrics are compliant (Green) or non-compliant (Red), and whether the house met the required Step."]
[null,"4) Data Transfer: Transfer all metrics to the BC Energy Compliance Report."]
[null,"5) Click \"Clear\" to clear user data entry."]
[]
[null,"HOT2000 Data"]
[null,"File#:"]
[null,"A","B","C","D",null,"E","F","G","H"]
[null,"Baseloads\n (GJ)","Total AEC\n (GJ)","ERS Reference\nHouse (GJ)","Heated Floor\n Area  (m2)",null,"ACH\n@ 50Pa","Auxiliary Energy\nRequired (MJ)","Design Heat Loss\n(Watts)","Estimated Greenhouse Gas Emissions (tonnes/year)"]
[null,25.62]
[null,null,null,null,"Above Grade","Below Grade",null,null,null,"*Enter to the thousandth (3) decimal place for GHG"]
[]
[null,"Step Level and Climate Zone"]
[null,"Select Step Level:",null,1]
[null,"Select Climate Zone:",null,4]
[]
[null,"D: 9.36.6. ENERGY STEP CODE COMPLIANCE"]
[]
[null,null,null,null,null,null,"Proposed / As-Built House Rated Energy Consumption (GJ/year):",{"$f":"IF((C16-B16)>0,ROUND(C16-B16,0),0)","v":0},null,null,null,null,"Reference House Rated Energy Target (GJ/year):",{"$f":"IF((D16-B16)>0,ROUND(D16-B16,0), 0)","v":0}]
[]
[null,"Metric",null,null,null,null,null,null,null,"Unit",null,"Required",null,"Calculations","Pass or Fail"]
[null,"Step Code Level",null,null,null,null,null,null,null,null,"Step 1, 2, 3, 4 or 5",{"$f":"D20","v":1}]
[null,"Mechanical energy Use Intensity (MEUI)",null,null,null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"VLOOKUP(D20&D21,'Step Code Levels'!I8:P37, 5,)","v":"-"},"(max)",{"$f":"ROUND((C16-B16)/(E16+F16)*277.78,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D20=1, IF(N30<L30, \"Fail\", \"Pass\"), IF(OR(N29<=L29, N30>=L30), \"Pass\", \"Fail\"))","v":"Pass"}]
[null,"ERS Rating % Lower Than EnerGuide Reference House, where applicable",null,null,null,null,null,null,null,null,"%",{"$f":"VLOOKUP(D20&D21,'Step Code Levels'!I3:P37, 4,)","v":0},"(min)",{"$f":"ROUND(((D16-B16)-(C16-B16))/(D16-B16)*100,1)","v":0}]
[null,"Thermal Energy Demand Intensity (TEDI)",null,null,null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"VLOOKUP(D20&D21,'Step Code Levels'!I8:P37, 6,FALSE)","v":"-"},"(max)",{"$f":"ROUND(H16/1000/(E16+F16)*277.78,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(L32=\"NR\", \"Pass\", IF(OR(N31<=L31,N32<=L32), \"Pass\", \"Fail\"))","v":{"$error":"#DIV/0!"}}]
[null,"Peak Thermal Load (PTL)",null,null,null,null,null,null,null,null,"W/m²",{"$f":"VLOOKUP(D20&D21,'Step Code Levels'!I8:P37, 7,)","v":"-"},"(max)",{"$f":"ROUND(I16/(E16+F16),0)","v":{"$error":"#DIV/0!"}}]
[null,"Airtightness in Air Changes per Hour at 50 Pa differential",null,null,null,null,null,null,null,null,"ACH @ 50 Pa",{"$f":"VLOOKUP(D20&D21,'Step Code Levels'!I8:P37, 8,)","v":"-"},"(max)",{"$f":"ROUND(G16,1)","v":0},{"$f":"IF(L33=\"NT\",\"Pass\",IF(N33<=L33, \"Pass\", \"Fail\"))","v":"Pass"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Step Code Requirements Met:",{"$f":"IF(AND(O31=\"Pass\", O29=\"Pass\", O33=\"Pass\"), \"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"F: OTHER ENERGY MODELLING METRICS"]
[null,"Rated Greenhouse Gas Emissions",null,null,null,null,null,null,null,null,"kg/year",null,null,{"$f":"J16*1000","v":0}]
[null,"Rated Greenhouse Gas Intensity ",null,null,null,null,null,null,null,null,"kg/m2/year",null,null,{"$f":"ROUND(J16/(E16+F16)*1000,1)","v":{"$error":"#DIV/0!"}}]

{"sheet":"HOT2000 Data","index":1,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"From HOT2000 File:"]
[null,"HOT2000 Calculation Results (press Alt C)",null,null,null,null,null,null,null,null,"Specifications Tab",null,null,null,null,"Natural Air Infiltration Component"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"From Full House Report"]
[null,"Always generate the full house report by selecting the \"House with standard operating conditions\" option."]

{"sheet":"Step Code Levels","index":2,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Update the individual tables below when needed",null,null,null,null,null,null,"Reference Table, do not modify!"]
[null,"See Article 9.36.6.3. Complaine Requirements of Division B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dropdown menu 1"]
[null,"Climate Zone 4",null,null,null,null,null,null,"Helper","Step Level","Climate Zone","ERS %","MEUI","TEDI","PTL","Airtightness",null,"Step Level"]
[null,"Step Level","ERS %","MEUI","TEDI","PTL","Airtightness",null,{"$f":"J8 & K8","v":"14"},1,4,{"$f":"C9","v":0},"-","-","-",{"$f":"G9","v":"-"},null,1]
[null,1,0,"-","-","-","-",null,{"$f":"J9 & K9","v":"24"},2,4,10,60,45,35,{"$f":"G10","v":3},null,2]
[null,2,10,60,45,35,3,null,"34",3,4,20,45,40,30,2.5,null,3]
[null,3,20,45,40,30,2.5,null,"44",4,4,40,35,25,25,1.5,null,4]
[null,4,40,35,25,25,1.5,null,"54",5,4,"-",25,15,10,1,null,5]
[null,5,"-",25,15,10,1,null,"15",1,5,{"$f":"C18","v":0},"-","-","-",{"$f":"G18","v":"-"},null,"Dropdown menu 2"]
[null,null,null,null,null,null,null,null,"25",2,5,10,90,60,55,{"$f":"G19","v":3},null,"Climate Zone"]
[null,null,null,null,null,null,null,null,"35",3,5,20,75,50,45,2.5,null,4]
[null,"Climate Zone 5",null,null,null,null,null,null,"45",4,5,40,45,40,40,1.5,null,5]
[null,"Step Level","ERS %","MEUI","TEDI","PTL","Airtightness",null,"55",5,5,"-",25,15,10,1,null,6]
[null,1,0,"-","-","-","-",null,"16",1,6,{"$f":"C27","v":0},"-","-","-",{"$f":"G27","v":"-"},null,"7a"]
[null,2,10,90,60,55,3,null,"26",2,6,10,100,70,55,{"$f":"G28","v":3},null,"7b"]
[null,3,20,75,50,45,2.5,null,"36",3,6,20,85,60,50,2.5,null,8]
[null,4,40,45,40,40,1.5,null,"46",4,6,40,55,50,45,1.5]
[null,5,"-",25,15,10,1,null,"56",5,6,"-",25,15,10,1]
[null,null,null,null,null,null,null,null,"17a",1,"7a",{"$f":"C27","v":0},"-","-","-",{"$f":"G27","v":"-"}]
[null,null,null,null,null,null,null,null,"27a",2,"7a",10,100,70,55,{"$f":"G28","v":3}]
[null,"Climate Zone 6, 7a, 7b, and 8",null,null,null,null,null,null,"37a",3,"7a",20,85,60,50,2.5]
[null,"Step Level","ERS %","MEUI","TEDI","PTL","Airtightness",null,"47a",4,"7a",40,55,50,45,1.5]
[null,1,0,"-","-","-","-",null,"57a",5,"7a","-",25,15,10,1]
[null,2,10,100,70,55,3,null,"17b",1,"7b",{"$f":"C27","v":0},"-","-","-",{"$f":"G27","v":"-"}]
[null,3,20,85,60,50,2.5,null,"27b",2,"7b",{"$f":"C28","v":10},{"$f":"D28","v":100},70,55,{"$f":"G28","v":3}]
[null,4,40,55,50,45,1.5,null,"37b",3,"7b",20,85,60,50,2.5]
[null,5,"-",25,15,10,1,null,"47b",4,"7b",40,55,50,45,1.5]
[null,null,null,null,null,null,null,null,"57b",5,"7b","-",25,15,10,1]
[null,null,null,null,null,null,null,null,"18",1,8,{"$f":"C27","v":0},"-","-","-",{"$f":"G27","v":"-"}]
[null,null,null,null,null,null,null,null,"28",2,8,10,100,70,55,{"$f":"G28","v":3}]
[null,null,null,null,null,null,null,null,"38",3,8,20,85,60,50,2.5]
[null,null,null,null,null,null,null,null,"48",4,8,40,55,50,45,1.5]
[null,null,null,null,null,null,null,null,"58",5,8,"-",25,15,10,1]

{"sheet":"Rounding Calculations","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Note: that rounding of the results is automatically applied to the to the Energy Step Code Compliance Calculator.  This is provided from the Instruction Manual for reference only."]
[]
["Appendix II - Round Calculations"]
["To ensure consistency among Energy Advisors, below are guidelines for rounding when performing calculations to obtain the Step Code Metrics:"]
[null,"1) When pulling information from HOT2000 and making calculations (through the Energy Step Code Compliance Calculator or by hand) enter all values to the hundredth decimal place (2 numbers after the decimal)."]
[null,"2) When entering Proposed or As-Built House Rated Energy Consumption, Reference House Rated Energy Target, TEDI, MEUI and PTL calculation results into Section D of the BC Energy Compliance Report, round the results to the nearest whole number (i.e. no decimal places). This means that:"]
[null,"·         If the tenth decimal is less than 5, round down (e.g. 26.49 is rounded down to 26)."]
[null,"·         If the tenth decimal is equal to or greater than 5, round up (e.g. 26.51 is rounded up to 27)."]
[]
[null,"3) When entering ERS % Lower Than Reference House and Airtightness in Air Changes Per Hour at 50Pa into Section D of the BC Energy Compliance Report, round the results to the tenth decimal place (i.e. one decimal place). This means that:"]
[null,"·         If the hundredth decimal is less than 5, round down (e.g. 26.51 is rounded down to 26.5)."]
[null,"·         If the hundredth decimal is equal to or greater than 5, round up (e.g. 26.49 is rounded up to 26.5).  Similarly, 26.95 is rounded up to 27.0."]