{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Pre Con Checklist","Mid Con Checklist","As Built Checklist","Calculator","Checklist Guide","Pre Con Hot2000 Details","Mid Con Hot2000 Details","As Built Hot2000 Details","References"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":3,"defined_names":60,"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":"Pre Con Checklist","index":0,"n_rows":202,"n_cols":12,"rows_kept":202,"cut":false,"hidden":false,"merged":[[74,10,74,11],[195,10,195,11],[183,3,183,5],[187,0,187,2],[187,3,187,4],[42,8,42,10],[169,7,169,10],[168,0,168,11],[159,0,159,2],[160,0,160,2],[161,0,161,2],[169,0,169,5],[172,0,172,6],[172,8,172,9],[171,10,171,11],[160,9,160,11],[160,3,160,5],[160,7,160,8],[159,9,159,11],[159,3,159,5],[159,7,159,8],[164,5,164,6],[63,3,63,9],[65,3,65,9],[66,3,66,9],[193,9,194,9],[193,10,194,11],[194,7,194,8],[178,0,178,5],[179,0,179,5],[164,3,164,4],[180,0,180,5],[181,0,181,5],[193,0,193,5],[72,10,72,11],[71,0,72,2],[75,0,79,2],[81,0,82,2],[72,3,72,9],[68,0,69,2],[76,3,76,9],[78,3,78,9],[77,3,77,9],[79,3,79,9],[71,3,71,9],[68,3,68,9],[69,3,69,9],[88,0,91,2],[201,0,201,9],[173,0,173,5],[185,3,185,4],[186,3,186,4],[188,3,188,4],[185,9,185,10],[190,0,190,11],[192,9,192,11],[201,10,201,11],[174,11,175,11],[176,11,177,11],[178,11,180,11],[186,9,186,10],[176,0,176,5],[177,0,177,5],[183,1,183,2],[196,0,197,1],[196,10,197,11],[198,0,200,1],[198,2,198,6],[198,10,200,11],[199,2,199,6],[200,2,200,6],[193,7,193,8],[4,3,4,6],[52,10,52,11],[5,3,5,6],[6,3,6,6],[51,10,51,11],[63,10,63,11],[7,8,7,10],[8,3,8,6],[46,5,46,6],[15,7,15,10],[16,7,18,10],[14,7,14,10],[21,7,23,10],[20,7,20,10],[15,1,15,5],[16,1,18,5],[20,1,20,5],[21,1,23,5],[61,10,61,11],[62,10,62,11],[58,10,58,11],[59,10,59,11],[61,0,63,2],[8,0,8,2],[61,3,61,9],[62,3,62,9],[102,3,102,11],[93,0,94,2],[1,4,1,8],[26,10,29,10],[39,10,39,11],[40,10,40,11],[41,10,41,11],[3,7,4,11],[3,3,3,6],[7,3,7,6],[40,8,40,9],[39,3,39,7],[40,3,40,7],[41,3,41,7],[39,8,39,9],[2,0,2,11],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[68,10,68,11],[6,8,6,10],[5,8,5,10],[10,0,10,11],[13,0,13,6],[35,0,35,2],[32,0,32,8],[33,3,33,8],[34,3,34,8],[35,3,35,8],[34,0,34,2],[28,3,29,3],[27,4,29,4],[28,8,29,8],[27,9,29,9],[33,0,33,2],[8,7,8,9],[14,1,14,5],[37,0,37,11],[45,0,47,1],[39,0,39,2],[40,0,40,2],[41,0,41,2],[42,0,42,2],[43,0,43,2],[45,5,45,6],[42,3,42,7],[46,3,46,4],[43,3,43,7],[47,3,47,4],[47,5,47,6],[45,3,45,4],[41,8,41,9],[51,0,54,2],[56,0,59,2],[48,0,48,11],[51,3,51,9],[52,3,52,9],[53,3,53,9],[54,3,54,9],[56,3,56,9],[57,3,57,9],[58,3,58,9],[59,3,59,9],[54,10,54,11],[53,10,53,11],[57,10,57,11],[56,10,56,11],[49,10,50,11],[65,10,65,11],[69,10,69,11],[71,10,71,11],[172,11,173,11],[94,3,94,9],[161,7,161,8],[161,9,161,11],[99,0,99,2],[66,10,66,11],[75,3,75,9],[85,3,85,9],[86,3,86,9],[89,3,89,9],[91,3,91,9],[99,3,99,9],[161,3,161,5],[172,10,173,10],[173,8,173,9],[101,3,101,11],[101,0,102,2],[88,3,88,4],[88,5,88,9],[90,3,90,4],[65,0,66,2],[81,3,81,9],[82,3,82,9],[84,0,86,2],[84,3,84,9],[188,6,188,8],[188,9,188,10],[158,7,158,11],[104,3,104,9],[183,9,183,10],[174,0,174,5],[175,0,175,5],[90,5,90,9],[93,3,93,9],[81,10,82,10],[96,0,97,2],[96,3,96,9],[97,3,97,9],[106,3,106,9],[155,0,155,11],[158,0,158,5],[107,3,107,9],[106,0,107,2],[187,9,187,10]]}
[]
[null,null,null,null,"BC STEP CODE COMPLIANCE CHECKLIST - PERFORMANCE PATHS FOR PART 9 BUILDINGS"]
["A: PROJECT INFORMATION"]
["Building Permit #:",null,null,null,null,null,null,"Pre Construction"]
["Builder:"]
["Project Address:",null,null,null,null,null,null,null,"Building Type"]
["Municipality / District:",null,null,null,null,null,null,null,{"$f":"Calculator!L178","v":"Single Detached"}]
["Postal Code:",null,null,null,null,null,null,"Other:"]
["PID or Legal Description:",null,null,null,null,null,null,"# of Dwelling Units:",null,null,{"$f":"Calculator!J31","v":0}]
[]
["B: CODE COMPLIANCE SUMMARY"]
[]
["BC Building Code Performance Compliance Path:"]
["9.36.6. BC Energy Step Code  ERS"]
[null,"Energy Step Code",null,null,null,null,null,"Zero Carbon Step Code"]
[null,"Step Required",null,null,null,null,null,"Level Required"]
[null,{"$f":"IF(ISBLANK(Calculator!$H$172),\"Not yet selected\",Calculator!$H$172)","v":3},null,null,null,null,null,{"$f":"IF(ISBLANK(Calculator!$P$172),\"Not yet selected\",Calculator!$P$172)","v":"EL 1 - Measure Only"}]
[]
[]
[]
[null,"Proposed Step Achieved",null,null,null,null,null,"Proposed Level Achieved"]
[null,{"$f":"IFERROR(IF(Calculator!$P$199=\"Yes\",Calculator!$H$173,\"Fail\"),\"Data not yet entered\")","v":"Data not yet entered"},null,null,null,null,null,{"$f":"IFERROR(IF(Calculator!$AD$198=\"yes\",Calculator!$P$173,\"Fail\"),\"Data not yet entered\")","v":"Fail"}]
[]
[]
[]
[null,null,{"$f":"IF(B22=C30,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(B22=D29,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(B22=E28,\"Achieved\n↓\",\"\")","v":""},null,null,{"$f":"IF(H22=References!AH12,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H22=References!AH13,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H22=References!AH14,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H22=References!AH15,\"Achieved\n↓\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"EL 4"]
[null,null,null,null,5,null,null,null,null,"EL 3"]
[null,null,null,4,null,null,null,null,"EL2"]
[null,null,3,null,null,null,null,"EL 1"]
[null,null,{"$f":"IF($B$17=C30,\"↑\nRequired\",\"\")","v":"↑\nRequired"},{"$f":"IF($B$17=D29,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($B$17=E28,\"↑\nRequired\",\"\")","v":""},null,null,{"$f":"IF($H$17=References!AH12,\"↑\nRequired\",\"\")","v":"↑\nRequired"},{"$f":"IF($H$17=References!AH13,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($H$17=References!AH14,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($H$17=References!AH15,\"↑\nRequired\",\"\")","v":""}]
[]
["Based on info provided by the builder & the following drawings:"]
["Plan Author"]
["Plan Version"]
["Plan Date"]
[]
["C: COMPLETED BY"]
[]
["Full Name (Print):",null,null,null,null,null,null,null,"Date (YYYY-MM-DD):"]
["Company Name:",null,null,null,null,null,null,null,"Service Organisation:"]
["Phone:",null,null,null,null,null,null,null,"Energy Advisor ID #:"]
["Address:",null,null,null,null,null,null,null,"CODECO placed in Field 8 of H2K",null,null,"x"]
["Email:"]
[]
["P File #",null,{"$f":"IF(Calculator!F11=\"\",\"\",Calculator!F11)","v":""},{"$f":"IF(Calculator!F12=\"\",\"\",Calculator!F12)","v":""},null,{"$f":"IF(Calculator!F13=\"\",\"\",Calculator!F13)","v":""},null,{"$f":"IF(Calculator!F14=\"\",\"\",Calculator!F14)","v":""},{"$f":"IF(Calculator!F15=\"\",\"\",Calculator!F15)","v":""},{"$f":"IF(Calculator!F16=\"\",\"\",Calculator!F16)","v":""},{"$f":"IF(Calculator!F17=\"\",\"\",Calculator!F17)","v":""},{"$f":"IF(Calculator!F18=\"\",\"\",Calculator!F18)","v":""}]
[null,null,{"$f":"IF(Calculator!F19=\"\",\"\",Calculator!F19)","v":""},{"$f":"IF(Calculator!F20=\"\",\"\",Calculator!F20)","v":""},null,{"$f":"IF(Calculator!F21=\"\",\"\",Calculator!F21)","v":""},null,{"$f":"IF(Calculator!F22=\"\",\"\",Calculator!F22)","v":""},{"$f":"IF(Calculator!F23=\"\",\"\",Calculator!F23)","v":""},{"$f":"IF(Calculator!F24=\"\",\"\",Calculator!F24)","v":""},{"$f":"IF(Calculator!F25=\"\",\"\",Calculator!F25)","v":""},{"$f":"IF(Calculator!F26=\"\",\"\",Calculator!F26)","v":""}]
[null,null,{"$f":"IF(Calculator!F27=\"\",\"\",Calculator!F27)","v":""},{"$f":"IF(Calculator!F28=\"\",\"\",Calculator!F28)","v":""},null,{"$f":"IF(Calculator!F29=\"\",\"\",Calculator!F29)","v":""},null,{"$f":"IF(Calculator!F30=\"\",\"\",Calculator!F30)","v":""}]
["D: BUILDING CHARACTERISTICS SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,"Average Effective RSI"]
[null,null,null,"Details (Assembly / System Type / Fuel Type / Etc.) "]
["Roof / Ceilings"]
[]
[]
[]
[]
["Above Grade Walls"]
[]
[]
[]
[]
["Rim Joists / Floor Headers and Lintels"]
[]
[]
[]
["Floors Over Unheated Space"]
[]
[]
["Walls Below Grade"]
[]
[]
["Slabs"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Performance Values"]
["Windows and glazed doors",null,null,null,null,null,null,null,null,null,"USI","SHGC"]
[]
[]
[]
[]
[]
["Doors",null,null,null,null,null,null,null,null,null,"RSI"]
[]
[]
["Air Barrier System & Location",null,null,null,null,null,null,null,null,null,"ACH",{"$f":"Calculator!P31","v":""}]
[null,null,null,null,null,null,null,null,null,null,"NLA",{"$f":"Calculator!Q31","v":""}]
[null,null,null,null,null,null,null,null,null,null,"NLR",{"$f":"Calculator!R31","v":""}]
[]
["Space Heating/ Cooling",null,null,"Principal",null,null,null,null,null,null,"-"]
[]
[null,null,null,"Supplementary",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-"]
[]
["Domestic Hot Water",null,null,null,null,null,null,null,null,null,"EF"]
[]
[]
["Ventilation",null,null,null,null,null,null,null,null,null,"% EFF","L/s"]
[]
[]
["Other"]
[]
["Fossil Fuels"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["E: 9.36.5. ENERGY PERFORMANCE COMPLIANCE"]
["Complete this section if using the Energy Performance Compliance Path in Subsection 9.36.5."]
[]
["Proposed House Energy Consumption (GJ/year)",null,null,null,null,null,null,"Reference House Rated Energy Target (GJ/year)"]
["HVAC",null,null,null,null,null,null,"HVAC"]
["DHW Heating",null,null,null,null,null,null,"DHW Heating"]
["SUM",null,null,{"$f":"SUM(D160:F161)","v":0},null,null,null,"SUM",null,{"$f":"SUM(J160:L161)","v":0}]
[]
["The airtightness value used in the energy model calculations for the Proposed house is:"]
["Or Testing Target:",null,null,{"$f":"Calculator!P31","v":""}]
[]
["The above calculation was performed in compliance with Subsection 9.36.5. of Division B:"]
[]
["F: 9.36.6. ENERGY STEP CODE COMPLIANCE"]
["Proposed House Rated Energy Consumption \n(GJ/year):",null,null,null,null,null,{"$f":"Calculator!J187","v":"-"},"Reference House Rated Energy Target (GJ/year):",null,null,null,{"$f":"Calculator!P187","v":"-"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Proposed Calculations"]
["Proposed House Metrics",null,null,null,null,null,null,"Unit","Proposed Step Requirement",null,"Proposed House Result ","Proposed House \nPass or Fail"]
["Step Code Level",null,null,null,null,null,null,"Step 3, 4 or 5",{"$f":"Calculator!H173","v":3}]
["Mechanical Energy Use Intensity (MEUI)",null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"Calculator!N192","v":"-"},"(max)",{"$f":"Calculator!P192","v":-1E-3},{"$f":"Calculator!Q192","v":{"$error":"#N/A"}}]
["% Improvement",null,null,null,null,null,null,"%",{"$f":"Calculator!N193","v":{"$error":"#N/A"}},"(min)",{"$f":"Calculator!P193","v":0}]
["Thermal Energy Demand (TEDI)",null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"Calculator!N194","v":"-"},"(max)",{"$f":"Calculator!P194","v":""},{"$f":"Calculator!Q194","v":{"$error":"#N/A"}}]
["% Heat Loss Reduction",null,null,null,null,null,null,"%",{"$f":"Calculator!N195","v":{"$error":"#N/A"}},"(min)",{"$f":"Calculator!P195","v":0}]
["Airtightness in Air Changes per Hour at 50 Pa differential",null,null,null,null,null,null,"ACH @ 50 Pa",{"$f":"Calculator!N196","v":"-"},"(max)",{"$f":"Calculator!P196","v":{"$error":"#VALUE!"}},{"$f":"Calculator!Q196","v":{"$error":"#VALUE!"}}]
["Normalized Leakage Area (NLA10)",null,null,null,null,null,null,"10 Pa (cm²/m²)",{"$f":"Calculator!N197","v":"-"},"(max)",{"$f":"Calculator!P197","v":{"$error":"#VALUE!"}}]
["Normalized Leakage Rate (NLR50)",null,null,null,null,null,null,"L/s/m²",{"$f":"Calculator!N198","v":"-"},"(max)",{"$f":"Calculator!P198","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Step Code Requirements Met:",{"$f":"Calculator!P199","v":{"$error":"#N/A"}}]
[]
[null,"Software Used:",null,{"$f":"Calculator!F235","v":0},null,null,null,null,"Version:",{"$f":"Calculator!F236","v":0}]
[]
[null,null,"Heated Floor Area (m2)",{"$f":"Calculator!I31","v":0},null,null,null,null,"Climate Data (Location): ",{"$f":"Calculator!F233","v":0}]
[null,null,"Building Volume (m3)",{"$f":"Calculator!O31","v":0},null,null,null,null,"Degree Days Below 18°C (HDD): ",{"$f":"Calculator!G177","v":0}]
["Building Surface Area (m2)",null,null,{"$f":"Calculator!N31","v":0},null,null,null,null,null,{"$f":"Calculator!I236","v":"Caution User Entered HDD"}]
[null,null,"FWDR:",{"$f":"Calculator!F234","v":0},null,null,"% Of Space Cooled",null,null,{"$f":"Calculator!G180","v":"-"}]
[]
["G: ZERO CARBON STEP CODE"]
[]
[null,null,null,null,null,null,null,null,null,"Proposed Calculations"]
["Proposed House Metrics",null,null,null,null,null,"Unit","Proposed Level Requirement",null,"Proposed House Result ","Proposed House \nPass or Fail"]
["Zero Carbon Step Code Level",null,null,null,null,null,"EL-1 - EL-4",{"$f":"Calculator!P173","v":"EL 1 - Measure Only"}]
["Total GHG",null,null,null,null,null,"kg CO2e/ year",{"$f":"Calculator!AB192","v":"NA"},"(max)",{"$f":"Calculator!AD192","v":0},{"$f":"Calculator!AE192","v":"Error"}]
["CO2e per floor area with max",null,"Per Floor area",null,null,null,"kg CO2e/m²/year",{"$f":"Calculator!AB193","v":"NA"},"(max)",{"$f":"Calculator!AD193","v":""},{"$f":"Calculator!AE193","v":"Error"}]
[null,null,"Max",null,null,null,"kg CO2e",{"$f":"Calculator!AB194","v":"NA"},"(max)",{"$f":"Calculator!AD194","v":0}]
["Prescriptive",null,"Heating",null,null,null,null,{"$f":"Calculator!AB195","v":"NA"},{"$f":"Calculator!AC195","v":1},{"$f":"Calculator!AD195","v":"Zero Carb"},{"$f":"Calculator!AE195","v":"Error"}]
[null,null,"Hot Water",null,null,null,null,{"$f":"Calculator!AB196","v":"NA"},{"$f":"Calculator!AC196","v":1},{"$f":"Calculator!AD196","v":"Zero Carb"}]
[null,null,"All building systems, equipment and appliances",null,null,null,null,{"$f":"Calculator!AB197","v":"NA"},{"$f":"Calculator!AC197","v":1},{"$f":"Calculator!AD197","v":"Zero Carb"}]
["Target Reached:",null,null,null,null,null,null,null,null,null,{"$f":"Calculator!AD198","v":"No"}]

{"sheet":"Mid Con Checklist","index":1,"n_rows":214,"n_cols":12,"rows_kept":214,"cut":false,"hidden":false,"merged":[[69,10,69,11],[72,3,72,9],[156,0,156,11],[71,3,71,9],[75,3,75,9],[176,4,176,5],[85,3,85,9],[76,3,76,9],[78,3,78,9],[81,3,81,9],[83,3,83,9],[119,0,119,11],[120,0,120,11],[81,0,81,2],[83,0,84,2],[85,0,85,2],[87,0,88,2],[92,0,92,2],[93,0,93,2],[114,0,114,2],[95,0,95,2],[96,0,96,2],[113,0,113,2],[116,5,116,6],[68,0,68,2],[69,0,69,2],[71,0,71,2],[72,0,72,2],[76,0,78,2],[74,0,75,2],[80,0,80,2],[87,3,87,4],[89,3,89,4],[16,7,18,10],[20,7,20,10],[21,7,23,10],[71,10,71,11],[72,10,72,11],[61,10,61,11],[39,10,39,11],[40,10,40,11],[39,8,39,9],[43,3,43,7],[68,3,68,9],[69,3,69,9],[40,8,40,9],[53,3,53,9],[59,3,59,9],[61,3,61,9],[62,3,62,9],[63,3,63,9],[65,3,65,9],[66,3,66,9],[68,10,68,11],[53,10,53,11],[58,10,58,11],[62,10,62,11],[13,0,13,6],[58,3,58,9],[45,3,45,4],[45,5,45,6],[27,3,28,3],[26,4,28,4],[25,10,28,10],[26,9,28,9],[27,8,28,8],[30,0,31,7],[32,0,32,8],[43,0,43,2],[32,9,32,11],[40,0,40,2],[33,9,33,11],[39,3,39,7],[40,3,40,7],[14,1,14,5],[14,7,14,10],[15,1,15,5],[16,1,18,5],[20,1,20,5],[21,1,23,5],[15,7,15,10],[1,4,1,8],[2,0,2,11],[3,3,3,6],[4,3,4,6],[7,3,7,6],[3,7,4,11],[5,3,5,6],[8,7,8,9],[6,3,6,6],[7,8,7,10],[8,3,8,6],[5,8,5,10],[6,8,6,10],[42,8,42,10],[213,10,213,11],[213,0,213,9],[146,0,146,11],[147,0,147,11],[148,0,148,11],[149,0,149,11],[150,0,150,11],[151,0,151,11],[152,0,152,11],[153,0,153,11],[154,0,154,11],[155,0,155,11],[212,2,212,6],[208,10,209,11],[184,8,184,9],[184,10,185,10],[184,11,185,11],[200,6,200,8],[200,9,200,10],[185,8,185,9],[200,3,200,4],[172,3,172,5],[197,9,197,10],[56,10,56,11],[57,10,57,11],[65,10,65,11],[66,10,66,11],[49,10,50,11],[51,10,51,11],[52,10,52,11],[45,0,47,1],[63,10,63,11],[59,10,59,11],[52,3,52,9],[54,3,54,9],[57,3,57,9],[57,0,59,2],[61,0,62,2],[63,0,63,2],[65,0,65,2],[66,0,66,2],[210,2,210,6],[208,0,209,1],[39,0,39,2],[56,3,56,9],[51,3,51,9],[45,7,45,8],[46,7,46,8],[47,7,47,8],[51,0,51,2],[52,0,54,2],[56,0,56,2],[41,8,41,9],[46,3,46,4],[46,5,46,6],[47,3,47,4],[47,5,47,6],[48,0,48,11],[41,3,41,7],[42,0,42,2],[42,3,42,7],[50,3,50,9],[41,0,41,2],[54,10,54,11],[41,10,41,11],[73,10,73,11],[74,3,74,9],[77,3,77,9],[80,3,80,9],[80,10,81,10],[84,3,84,9],[88,3,88,9],[121,0,121,11],[140,0,140,11],[129,0,129,11],[130,0,130,11],[131,0,131,11],[128,0,128,11],[132,0,132,11],[133,0,133,11],[139,0,139,11],[101,3,101,11],[89,0,90,2],[100,0,101,2],[87,5,87,9],[89,5,89,9],[100,3,100,11],[98,0,98,2],[95,3,95,9],[188,11,189,11],[190,11,192,11],[204,9,204,11],[205,7,205,8],[205,9,206,9],[195,0,195,2],[195,3,195,5],[195,9,195,10],[202,0,202,11],[191,0,191,5],[192,0,192,5],[188,0,188,5],[189,0,189,5],[196,0,197,2],[199,9,199,10],[186,11,187,11],[141,0,141,11],[123,0,123,10],[122,0,122,7],[116,3,116,4],[116,0,116,2],[112,7,112,8],[113,7,113,8],[114,7,114,8],[187,0,187,5],[186,0,186,5],[173,3,173,5],[161,0,161,11],[162,0,162,11],[173,7,173,8],[160,0,160,11],[173,9,173,11],[171,9,171,11],[159,0,159,11],[172,9,172,11],[171,7,171,8],[171,3,171,5],[165,0,165,11],[96,3,96,9],[98,3,98,9],[211,2,211,6],[181,0,181,5],[181,7,181,10],[210,0,212,1],[142,0,142,11],[143,0,143,11],[144,0,144,11],[145,0,145,11],[157,0,157,11],[158,0,158,11],[170,7,170,11],[205,10,206,11],[206,7,206,8],[197,3,197,4],[210,10,212,11],[198,3,198,4],[176,2,176,3],[198,9,198,10],[183,10,183,11],[163,0,163,11],[164,0,164,11],[207,10,207,11],[10,0,10,11],[107,0,107,11],[167,0,167,11],[127,0,127,11],[134,0,134,11],[135,0,135,11],[136,0,136,11],[137,0,137,11],[138,0,138,11],[92,3,92,9],[93,3,93,9],[90,3,90,9],[115,7,115,8],[116,7,116,8],[126,0,126,11],[125,0,125,7],[109,0,109,5],[109,7,109,8],[115,9,115,11],[116,9,116,11],[114,9,114,11],[113,9,113,11],[112,9,112,11],[114,3,114,4]]}
[]
[null,null,null,null,"BC STEP CODE COMPLIANCE CHECKLIST - PERFORMANCE PATHS FOR PART 9 BUILDINGS"]
["A: PROJECT INFORMATION"]
["Building Permit #:",null,null,null,null,null,null,"Mid Construction"]
["Builder:"]
["Project Address:",null,null,null,null,null,null,null,"Building Type"]
["Municipality / District:",null,null,null,null,null,null,null,{"$f":"Calculator!L178","v":"Single Detached"}]
["Postal Code:",null,null,null,null,null,null,"Other:"]
["PID or Legal Description:",null,null,null,null,null,null,"# of Dwelling Units:",null,null,{"$f":"Calculator!J140","v":0}]
[]
["B: CODE COMPLIANCE SUMMARY"]
[]
["BC Building Code Performance Compliance Path:"]
["9.36.6. BC Energy Step Code  ERS"]
[null,"Energy Step Code",null,null,null,null,null,"Zero Carbon Step Code"]
[null,"Step Required",null,null,null,null,null,"Level Required"]
[null,{"$f":"IF(ISBLANK(Calculator!$H$172),\"Not yet selected\",Calculator!$H$172)","v":3},null,null,null,null,null,{"$f":"IF(ISBLANK(Calculator!$P$172),\"Not yet selected\",Calculator!$P$172)","v":"EL 1 - Measure Only"}]
[]
[]
[]
[null,"Proposed Step Achieved",null,null,null,null,null,"Proposed Level Achieved"]
[null,{"$f":"IFERROR(IF(Calculator!$P$213=\"Yes\",Calculator!$H$174,\"Fail\"),\"Data not yet entered\")","v":"Data not yet entered"},null,null,null,null,null,{"$f":"IFERROR(IF(Calculator!$AD$212=\"yes\",Calculator!$P$174,\"Fail\"),\"Data not yet entered\")","v":"Fail"}]
[]
[]
[null,null,{"$f":"IF(B22=C29,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(B22=D28,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(B22=E27,\"Achieved\n↓\",\"\")","v":""},null,null,{"$f":"IF(H22=References!AH12,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H22=References!AH13,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H22=References!AH14,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H22=References!AH15,\"Achieved\n↓\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"EL 4"]
[null,null,null,null,5,null,null,null,null,"EL 3"]
[null,null,null,4,null,null,null,null,"EL 2"]
[null,null,3,null,null,null,null,"EL 1"]
[null,null,{"$f":"IF($B$17=C29,\"↑\nRequired\",\"\")","v":"↑\nRequired"},{"$f":"IF($B$17=D28,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($B$17=E27,\"↑\nRequired\",\"\")","v":""},null,null,{"$f":"IF($H$17=References!AH12,\"↑\nRequired\",\"\")","v":"↑\nRequired"},{"$f":"IF($H$17=References!AH13,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($H$17=References!AH14,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($H$17=References!AH15,\"↑\nRequired\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
["C: COMPLETED BY"]
[]
["Full Name (Print):",null,null,null,null,null,null,null,"Date (YYYY-MM-DD):"]
["Company Name:",null,null,null,null,null,null,null,"Service Organisation:"]
["Phone:",null,null,null,null,null,null,null,"Energy Advisor ID #:"]
["Address:",null,null,null,null,null,null,null,"CODECO placed in Field 8 of H2K",null,null,"x"]
["Email:"]
[]
["File #",null,{"$f":"IF(Calculator!F120=\"\",\"\",Calculator!F120)","v":""},{"$f":"IF(Calculator!F121=\"\",\"\",Calculator!F121)","v":""},null,{"$f":"IF(Calculator!F122=\"\",\"\",Calculator!F122)","v":""},null,{"$f":"IF(Calculator!F123=\"\",\"\",Calculator!F123)","v":""},null,{"$f":"IF(Calculator!F124=\"\",\"\",Calculator!F124)","v":""},{"$f":"IF(Calculator!F125=\"\",\"\",Calculator!F125)","v":""}]
[null,null,{"$f":"IF(Calculator!F126=\"\",\"\",Calculator!F126)","v":""},{"$f":"IF(Calculator!F127=\"\",\"\",Calculator!F127)","v":""},null,{"$f":"IF(Calculator!F128=\"\",\"\",Calculator!F128)","v":""},null,{"$f":"IF(Calculator!F129=\"\",\"\",Calculator!F129)","v":""},null,{"$f":"IF(Calculator!F130=\"\",\"\",Calculator!F130)","v":""},{"$f":"IF(Calculator!F131=\"\",\"\",Calculator!F131)","v":""},{"$f":"IF(Calculator!F133=\"\",\"\",Calculator!F133)","v":""}]
[null,null,{"$f":"IF(Calculator!F134=\"\",\"\",Calculator!F134)","v":""},{"$f":"IF(Calculator!F135=\"\",\"\",Calculator!F135)","v":""},null,{"$f":"IF(Calculator!F136=\"\",\"\",Calculator!F136)","v":""},null,{"$f":"IF(Calculator!F137=\"\",\"\",Calculator!F137)","v":""},null,{"$f":"IF(Calculator!F138=\"\",\"\",Calculator!F138)","v":""},{"$f":"IF(Calculator!F139=\"\",\"\",Calculator!F139)","v":""}]
["D: BUILDING CHARACTERISTICS SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,"Average Effective RSI"]
[null,null,null,"Details (Assembly / System Type / Fuel Type / Etc.) "]
["Roof / Ceilings"]
[]
[]
[]
[]
["Above Grade Walls"]
[]
[]
[]
[]
["Rim Joists / Floor Headers and Lintels"]
[]
[]
[]
["Floors Over Unheated Space"]
[]
[]
["Walls Below Grade"]
[]
[]
["Slabs"]
[]
[null,null,null,null,null,null,null,null,null,null,"Performance Values"]
["Windows and glazed doors",null,null,null,null,null,null,null,null,null,"USI","SHGC"]
[]
[]
[]
[]
[]
["Doors",null,null,null,null,null,null,null,null,null,"RSI"]
[]
[]
["Air Barrier System & Location",null,null,null,null,null,null,null,null,null,"ACH",{"$f":"Calculator!P140","v":""}]
[null,null,null,null,null,null,null,null,null,null,"NLA",{"$f":"Calculator!Q140","v":""}]
[null,null,null,null,null,null,null,null,null,null,"NLR",{"$f":"Calculator!R140","v":""}]
[]
["Space Heating/ Cooling",null,null,"Principal",null,null,null,null,null,null,"-"]
[]
[null,null,null,"Supplementary",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-"]
[]
["Domestic Hot Water",null,null,null,null,null,null,null,null,null,"EF"]
[]
[]
["Ventilation",null,null,null,null,null,null,null,null,null,"% EFF","L/s"]
[]
[]
["Other"]
[]
["Fossil Fuels"]
[]
[]
[]
[]
[]
[]
["D2: MID CONSTRUCTION TESTING RESULTS AND SITE REVIEW"]
[]
[null,null,null,null,null,null,"Date:"]
[]
["Testing Conditions",null,null,null,null,null,null,"Testing Completed By"]
[null,null,null,"Low","High",null,null,"Full Name:"]
["Test Presures (Pa)",null,null,null,null,null,null,"Company Name:"]
["Test Direction",null,null,null,null,null,null,"Phone:"]
[null,null,null,null,null,null,null,"Email:"]
["Best result",null,null,null,null,null,null,"Energy Advisor ID #"]
[]
["State of home during test"]
[]
[]
[]
["Status of buildings code compliance:"]
[]
[]
["Notes From Mid Construction Testing:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["E: 9.36.5. ENERGY PERFORMANCE COMPLIANCE"]
["Complete this section if using the Energy Performance Compliance Path in Subsection 9.36.5."]
[]
["Proposed House Energy Consumption (GJ/year)",null,null,null,null,null,null,"Reference House Rated Energy Target (GJ/year)"]
["HVAC",null,null,null,null,null,null,"HVAC"]
["DHW Heating",null,null,null,null,null,null,"DHW Heating"]
["SUM",null,null,{"$f":"SUM(D172:F173)","v":0},null,null,null,"SUM",null,{"$f":"SUM(J172:L173)","v":0}]
[]
["The airtightness value used in the energy model calculations for the Proposed house is:"]
["Or Tested At:",null,{"$f":"Calculator!P31","v":""}]
[]
["The above calculation was performed in compliance with Subsection 9.36.5. of Division B:"]
[]
["F: 9.36.6. ENERGY STEP CODE COMPLIANCE (see BCBC Sentence 2.2.8.3.(3) of Division C)"]
["Proposed House Rated Energy Consumption\n(GJ/year):",null,null,null,null,null,{"$f":"Calculator!J187","v":"-"},"Reference House Rated Energy Target \n(GJ/year):",null,null,null,{"$f":"Calculator!P187","v":"-"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Proposed Calculations"]
["Proposed House Metrics",null,null,null,null,null,null,"Unit","Mid Con Step Requirements",null,"Proposed House Result ","Proposed House \nPass or Fail"]
["Step Code Level",null,null,null,null,null,null,"Step 3, 4 or 5",{"$f":"Calculator!N205","v":3}]
["Mechanical Energy Use Intensity (MEUI)",null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"Calculator!N206","v":"-"},"(max)",{"$f":"Calculator!P206","v":-1E-3},{"$f":"Calculator!Q206","v":{"$error":"#N/A"}}]
["% Improvement",null,null,null,null,null,null,"%",{"$f":"Calculator!N207","v":{"$error":"#N/A"}},"(min)",{"$f":"Calculator!P207","v":-1E-3}]
["Thermal Energy Demand (TEDI)",null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"Calculator!N208","v":"-"},"(max)",{"$f":"Calculator!P208","v":""},{"$f":"Calculator!Q208","v":{"$error":"#N/A"}}]
["% Heat Loss Reduction",null,null,null,null,null,null,"%",{"$f":"Calculator!N209","v":{"$error":"#N/A"}},"(min)",{"$f":"Calculator!P209","v":-1E-3}]
["Airtightness in Air Changes per Hour at 50 Pa differential",null,null,null,null,null,null,"ACH @ 50 Pa",{"$f":"Calculator!N210","v":"-"},"(max)",{"$f":"Calculator!P210","v":{"$error":"#VALUE!"}},{"$f":"Calculator!Q210","v":{"$error":"#VALUE!"}}]
["Normalized Leakage Area (NLA10)",null,null,null,null,null,null,"10 Pa (cm²/m²)",{"$f":"Calculator!N211","v":"-"},"(max)",{"$f":"Calculator!P211","v":{"$error":"#VALUE!"}}]
["Normalized Leakage Rate (NLR50)",null,null,null,null,null,null,"L/s/m²",{"$f":"Calculator!N212","v":"-"},"(max)",{"$f":"Calculator!P212","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Step Code Requirements Met:",{"$f":"Calculator!P213","v":{"$error":"#N/A"}}]
[]
["Software Used:",null,null,{"$f":"Calculator!F235","v":0},null,null,null,null,"Version:",{"$f":"Calculator!F236","v":0}]
["Heated Floor Area (m2)"]
[null,null,null,{"$f":"Calculator!I85","v":0},null,null,null,null,"Climate Data (Location): ",{"$f":"Calculator!F233","v":0}]
[null,null,"Building Volume (m3)",{"$f":"Calculator!O85","v":0},null,null,null,null,"Degree Days Below 18°C (HDD): ",{"$f":"Calculator!G177","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Calculator!I236","v":"Caution User Entered HDD"}]
[null,null,"FWDR:",{"$f":"Calculator!F234","v":0},null,null,"% Of Space Cooled",null,null,{"$f":"Calculator!G181","v":"-"}]
[]
["G: ZERO CARBON STEP CODE"]
[]
[null,null,null,null,null,null,null,null,null,"Proposed Calculations"]
["Proposed House Metrics",null,null,null,null,null,"Unit","Proposed Level Requirement",null,"Proposed House Result ","Proposed House \nPass or Fail"]
["Zero Carbon Step Code Level",null,null,null,null,null,"EL-1 - EL-4",{"$f":"Calculator!P174","v":"EL 1 - Measure Only"}]
["Total GHG",null,null,null,null,null,"kg CO2e/ year",{"$f":"Calculator!AB206","v":"NA"},"(max)",{"$f":"Calculator!AD206","v":0},{"$f":"Calculator!AE206","v":"Error"}]
["CO2e per floor area with max",null,"Per Floor area",null,null,null,"kg CO2e/m²/year",{"$f":"Calculator!AB207","v":"NA"},"(max)",{"$f":"Calculator!AD207","v":""},{"$f":"Calculator!AE207","v":"Error"}]
[null,null,"Max",null,null,null,"kg CO2e",{"$f":"Calculator!AB208","v":"NA"},"(max)",{"$f":"Calculator!AD208","v":0}]
["Perscriptive",null,"Heating",null,null,null,null,{"$f":"Calculator!AB209","v":"NA"},{"$f":"VLOOKUP(H211,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"Calculator!AD209","v":"Zero Carb"},{"$f":"Calculator!AE209","v":"Error"}]
[null,null,"Hot Water",null,null,null,null,{"$f":"Calculator!AB210","v":"NA"},{"$f":"VLOOKUP(H212,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"Calculator!AD210","v":"Zero Carb"}]
[null,null,"All building systems, equipment and appliances",null,null,null,null,{"$f":"Calculator!AB211","v":"NA"},{"$f":"VLOOKUP(H213,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"Calculator!AD211","v":"Zero Carb"}]
["Target Reached",null,null,null,null,null,null,null,null,null,{"$f":"Calculator!AD212","v":"No"}]

{"sheet":"As Built Checklist","index":2,"n_rows":194,"n_cols":12,"rows_kept":194,"cut":false,"hidden":false,"merged":[[171,0,171,5],[172,0,172,5],[65,0,66,2],[61,0,63,2],[68,0,69,2],[71,0,72,2],[72,3,72,9],[72,10,72,11],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,10,45,11],[46,3,46,4],[46,5,46,6],[46,7,46,8],[47,3,47,4],[47,5,47,6],[47,7,47,8],[65,3,65,9],[68,10,68,11],[164,8,164,9],[164,10,165,10],[164,11,165,11],[165,8,165,9],[8,3,8,6],[8,7,8,9],[56,3,56,9],[57,3,57,9],[58,3,58,9],[43,0,43,2],[44,0,44,2],[41,3,41,7],[42,3,42,7],[42,0,42,2],[16,1,16,5],[17,1,19,5],[21,1,21,5],[22,1,24,5],[16,7,16,10],[53,10,53,11],[40,0,40,2],[41,0,41,2],[37,0,37,2],[51,0,54,2],[56,0,59,2],[32,9,32,11],[33,9,33,11],[39,8,39,9],[3,7,4,11],[5,8,5,10],[6,8,6,10],[65,10,65,11],[17,7,19,10],[21,7,21,10],[22,7,24,10],[28,3,29,3],[27,4,29,4],[28,8,29,8],[27,9,29,9],[26,10,29,10],[56,10,56,11],[57,10,57,11],[58,10,58,11],[59,10,59,11],[61,3,61,9],[62,3,62,9],[63,3,63,9],[13,0,13,6],[49,10,50,11],[45,0,47,1],[39,0,39,2],[41,8,41,9],[1,4,1,8],[191,2,191,6],[192,2,192,6],[5,3,5,6],[6,3,6,6],[2,0,2,11],[3,3,3,6],[4,3,4,6],[7,3,7,6],[7,8,7,10],[40,3,40,7],[59,3,59,9],[32,0,32,8],[44,3,44,7],[48,0,48,11],[51,10,51,11],[52,10,52,11],[51,3,51,9],[52,3,52,9],[53,3,53,9],[54,3,54,9],[167,0,167,5],[168,0,168,5],[39,3,39,7],[40,10,40,11],[41,10,41,11],[61,10,61,11],[62,10,62,11],[63,10,63,11],[71,10,71,11],[54,10,54,11],[66,3,66,9],[78,3,78,9],[40,8,40,9],[43,3,43,7],[66,10,66,11],[73,10,73,11],[76,3,76,9],[77,3,77,9],[42,8,42,10],[39,10,39,11],[69,10,69,11],[68,3,68,9],[69,3,69,9],[71,3,71,9],[151,9,151,11],[152,9,152,11],[188,10,189,11],[190,10,192,11],[166,11,167,11],[168,11,169,11],[170,11,172,11],[166,0,166,5],[74,3,74,9],[75,3,75,9],[175,0,175,2],[175,3,175,5],[175,9,175,10],[153,7,153,8],[150,0,150,5],[151,3,151,5],[152,3,152,5],[156,2,156,3],[163,10,163,11],[193,10,193,11],[193,0,193,9],[177,3,177,4],[178,3,178,4],[180,3,180,4],[177,9,177,10],[178,9,178,10],[180,6,180,8],[180,9,180,10],[190,2,190,6],[187,10,187,11],[188,0,189,1],[190,0,192,1],[184,9,184,11],[185,7,185,8],[185,9,186,9],[185,10,186,11],[186,7,186,8],[179,9,179,10],[83,3,83,9],[87,3,87,4],[87,5,87,9],[89,3,89,4],[89,5,89,9],[153,3,153,5],[169,0,169,5],[161,7,161,10],[161,0,161,5],[153,9,153,11],[156,4,156,5],[150,7,150,11],[151,7,151,8],[101,3,101,11],[100,0,101,2],[100,3,100,11],[15,1,15,5],[15,7,15,10],[10,0,10,11],[147,0,147,11],[160,0,160,11],[98,0,98,2],[95,0,96,2],[95,3,95,9],[98,3,98,9],[96,3,96,9],[74,0,78,2],[80,0,81,2],[80,10,81,10],[81,3,81,9],[83,0,85,2],[85,3,85,9],[87,0,90,2],[92,0,93,2],[92,3,92,9],[88,3,88,9],[90,3,90,9],[93,3,93,9],[84,3,84,9],[80,3,80,9]]}
[]
[null,null,null,null,"BC STEP CODE COMPLIANCE CHECKLIST - PERFORMANCE PATHS FOR PART 9 BUILDINGS"]
["A: PROJECT INFORMATION"]
["Building Permit #:",null,null,null,null,null,null,"As Built"]
["Builder:"]
["Project Address:",null,null,null,null,null,null,null,"Building Type"]
["Municipality / District:",null,null,null,null,null,null,null,{"$f":"Calculator!L178","v":"Single Detached"}]
["Postal Code:",null,null,null,null,null,null,"Other:"]
["PID or Legal Description:",null,null,null,null,null,null,"# of Dwelling Units:",null,null,{"$f":"Calculator!J140","v":0}]
[]
["B: CODE COMPLIANCE SUMMARY"]
[]
["BC Building Code Performance Compliance Path:"]
["9.36.6. BC Energy Step Code  ERS"]
[]
[null,"Energy Step Code",null,null,null,null,null,"Zero Carbon Step Code"]
[null,"Step Required",null,null,null,null,null,"Level Required"]
[null,{"$f":"IF(ISBLANK(Calculator!$H$172),\"Not yet selected\",Calculator!$H$172)","v":3},null,null,null,null,null,{"$f":"IF(ISBLANK(Calculator!$P$172),\"Not yet selected\",Calculator!$P$172)","v":"EL 1 - Measure Only"}]
[]
[]
[]
[null,"Step Achieved",null,null,null,null,null,"Level Achieved"]
[null,{"$f":"IFERROR(IF(Calculator!$P$227=\"Yes\",Calculator!$H$175,\"Fail\"),\"Data not yet entered\")","v":"Data not yet entered"},null,null,null,null,null,{"$f":"IFERROR(IF(Calculator!$AD$226=\"yes\",Calculator!$P$175,\"Fail\"),\"Data not yet entered\")","v":"Fail"}]
[]
[]
[null,null,{"$f":"IF(B23=C30,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(B23=D29,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(B23=E28,\"Achieved\n↓\",\"\")","v":""},null,null,{"$f":"IF(H23=References!AH12,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H23=References!AH13,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H23=References!AH14,\"Achieved\n↓\",\"\")","v":""},{"$f":"IF(H23=References!AH15,\"Achieved\n↓\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"EL 4"]
[null,null,null,null,5,null,null,null,null,"EL 3"]
[null,null,null,4,null,null,null,null,"EL 2"]
[null,null,3,null,null,null,null,"EL 1"]
[null,null,{"$f":"IF($B$18=C30,\"↑\nRequired\",\"\")","v":"↑\nRequired"},{"$f":"IF($B$18=D29,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($B$18=E28,\"↑\nRequired\",\"\")","v":""},null,null,{"$f":"IF($H$18=References!AH12,\"↑\nRequired\",\"\")","v":"↑\nRequired"},{"$f":"IF($H$18=References!AH13,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($H$18=References!AH14,\"↑\nRequired\",\"\")","v":""},{"$f":"IF($H$18=References!AH15,\"↑\nRequired\",\"\")","v":""}]
[]
["Based on info provided by the builder & drawings prepared by: "]
[null,null,null,null,null,null,null,null,"Site Visit Date"]
[]
[]
[]
["C: COMPLETED BY"]
[]
["Full Name (Print):",null,null,null,null,null,null,null,"Date (YYYY-MM-DD):"]
["Company Name:",null,null,null,null,null,null,null,"Service Organisation"]
["Phone:",null,null,null,null,null,null,null,"Energy Advisor ID #"]
["Address:",null,null,null,null,null,null,null,"CODECO placed in Field 8 of H2K",null,null,"x"]
["Email:"]
[]
["N File #",null,{"$f":"IF(Calculator!F120=\"\",\"\",Calculator!F120)","v":""},{"$f":"IF(Calculator!F121=\"\",\"\",Calculator!F121)","v":""},null,{"$f":"IF(Calculator!F122=\"\",\"\",Calculator!F122)","v":""},null,{"$f":"IF(Calculator!F123=\"\",\"\",Calculator!F123)","v":""},null,{"$f":"IF(Calculator!F124=\"\",\"\",Calculator!F124)","v":""},{"$f":"IF(Calculator!F125=\"\",\"\",Calculator!F125)","v":""}]
[null,null,{"$f":"IF(Calculator!F126=\"\",\"\",Calculator!F126)","v":""},{"$f":"IF(Calculator!F127=\"\",\"\",Calculator!F127)","v":""},null,{"$f":"IF(Calculator!F128=\"\",\"\",Calculator!F128)","v":""},null,{"$f":"IF(Calculator!F129=\"\",\"\",Calculator!F129)","v":""},null,{"$f":"IF(Calculator!F130=\"\",\"\",Calculator!F130)","v":""},{"$f":"IF(Calculator!F131=\"\",\"\",Calculator!F131)","v":""},{"$f":"IF(Calculator!F133=\"\",\"\",Calculator!F133)","v":""}]
[null,null,{"$f":"IF(Calculator!F134=\"\",\"\",Calculator!F134)","v":""},{"$f":"IF(Calculator!F135=\"\",\"\",Calculator!F135)","v":""},null,{"$f":"IF(Calculator!F136=\"\",\"\",Calculator!F136)","v":""},null,{"$f":"IF(Calculator!F137=\"\",\"\",Calculator!F137)","v":""},null,{"$f":"IF(Calculator!F138=\"\",\"\",Calculator!F138)","v":""},{"$f":"IF(Calculator!F139=\"\",\"\",Calculator!F139)","v":""}]
["D: BUILDING CHARACTERISTICS SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,"Average Effective RSI"]
[null,null,null,"Details (Assembly / System Type / Fuel Type / Etc.) "]
["Roof / Ceilings"]
[]
[]
[]
[]
["Above Grade Walls"]
[]
[]
[]
[]
["Rim Joists / Floor Headers and Lintels"]
[]
[]
[]
["Floors Over Unheated Space"]
[]
[]
["Walls Below Grade"]
[]
[]
["Slabs"]
[]
[null,null,null,null,null,null,null,null,null,null,"Performance Values"]
["Windows and glazed doors",null,null,null,null,null,null,null,null,null,"USI","SHGC"]
[]
[]
[]
[]
[]
["Doors",null,null,null,null,null,null,null,null,null,"RSI"]
[]
[]
["Air Barrier System & Location",null,null,null,null,null,null,null,null,null,"ACH",{"$f":"Calculator!P140","v":""}]
[null,null,null,null,null,null,null,null,null,null,"NLA",{"$f":"Calculator!Q140","v":""}]
[null,null,null,null,null,null,null,null,null,null,"NLR",{"$f":"Calculator!R140","v":""}]
[]
["Space Heating/ Cooling",null,null,"Principal",null,null,null,null,null,null,"-"]
[]
[null,null,null,"Supplementary",null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,"-"]
[]
["Domestic Hot Water",null,null,null,null,null,null,null,null,null,"EF"]
[]
[]
["Ventilation",null,null,null,null,null,null,null,null,null,"% EFF","L/s"]
[]
[]
["Other"]
[]
["Fossil Fuels"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["E: 9.36.5. ENERGY PERFORMANCE COMPLIANCE"]
["Complete this section if using the Energy Performance Compliance Path in Subsection 9.36.5."]
[]
["Proposed House Energy Consumption (GJ/year)",null,null,null,null,null,null,"Reference House Rated Energy Target (GJ/year)"]
["HVAC",null,null,null,null,null,null,"HVAC"]
["DHW Heating",null,null,null,null,null,null,"DHW Heating"]
["SUM",null,null,{"$f":"SUM(D152:F153)","v":0},null,null,null,"SUM",null,{"$f":"SUM(J152:L153)","v":0}]
[]
["The airtightness value used in the energy model calculations for the Proposed house is:"]
["Or Tested At:",null,{"$f":"Calculator!P31","v":""}]
[]
["The above calculation was performed in compliance with Subsection 9.36.5. of Division B:"]
[]
["F: 9.36.6. ENERGY STEP CODE COMPLIANCE"]
["As Built House Rated Energy Consumption \n(GJ/year):",null,null,null,null,null,{"$f":"Calculator!J215","v":"-"},"Reference House Rated Energy Target (GJ/year):",null,null,null,{"$f":"Calculator!P215","v":"-"}]
[]
[null,null,null,null,null,null,null,null,null,null,"As-built Calculations"]
["Proposed House Metrics",null,null,null,null,null,null,"Unit","As Built Step Requirements",null,"As-built House Result ","As-built House \nPass or Fail"]
["Step Code Level",null,null,null,null,null,null,"Step 3, 4 or 5",{"$f":"Calculator!N219","v":3}]
["Mechanical Energy Use Intensity (MEUI)",null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"Calculator!N220","v":"-"},"(max)",{"$f":"Calculator!P220","v":-1E-3},{"$f":"Calculator!Q220","v":{"$error":"#N/A"}}]
["% Improvement",null,null,null,null,null,null,"%",{"$f":"Calculator!N221","v":{"$error":"#N/A"}},"(min)",{"$f":"Calculator!P221","v":-1E-3}]
["Thermal Energy Demand (TEDI)",null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"Calculator!N222","v":"-"},"(max)",{"$f":"Calculator!P222","v":""},{"$f":"Calculator!Q222","v":{"$error":"#N/A"}}]
["% Heat Loss Reduction",null,null,null,null,null,null,"%",{"$f":"Calculator!N223","v":{"$error":"#N/A"}},"(min)",{"$f":"Calculator!P223","v":-1E-3}]
["Airtightness in Air Changes per Hour at 50 Pa differential",null,null,null,null,null,null,"ACH @ 50 Pa",{"$f":"Calculator!N224","v":"-"},"(max)",{"$f":"Calculator!P224","v":{"$error":"#VALUE!"}},{"$f":"Calculator!Q224","v":{"$error":"#VALUE!"}}]
["Normalized Leakage Area (NLA10)",null,null,null,null,null,null,"10 Pa (cm²/m²)",{"$f":"Calculator!N225","v":"-"},"(max)",{"$f":"Calculator!P225","v":{"$error":"#VALUE!"}}]
["Normalized Leakage Rate (NLR50)",null,null,null,null,null,null,"L/s/m²",{"$f":"Calculator!N226","v":"-"},"(max)",{"$f":"Calculator!P226","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Step Code Requirements Met:",{"$f":"Calculator!P227","v":{"$error":"#N/A"}}]
[]
["Software Used:",null,null,{"$f":"Calculator!F235","v":0},null,null,null,null,"Version:",{"$f":"Calculator!F236","v":0}]
[]
[null,null,"Heated Floor Area (m2)",{"$f":"Calculator!I140","v":0},null,null,null,null,"Climate Data (Location): ",{"$f":"Calculator!F233","v":0}]
[null,null,"Building Volume (m3)",{"$f":"Calculator!O140","v":0},null,null,null,null,"Degree Days Below 18°C (HDD): ",{"$f":"Calculator!G177","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Calculator!I236","v":"Caution User Entered HDD"}]
[null,null,"FWDR:",{"$f":"Calculator!F234","v":0},null,null,"% Of Space Cooled",null,null,{"$f":"Calculator!G182","v":"-"}]
[]
["G: ZERO CARBON STEP CODE"]
[]
[null,null,null,null,null,null,null,null,null,"Proposed Calculations"]
["Proposed House Metrics",null,null,null,null,null,"Unit","Proposed Level Requirement",null,"Proposed House Result ","Proposed House \nPass or Fail"]
["Zero Carbon Step Code Level",null,null,null,null,null,"EL-1 - EL-4",{"$f":"Calculator!AB219","v":"EL 1 - Measure Only"}]
["Total GHG",null,null,null,null,null,"kg CO2e/ year",{"$f":"Calculator!AB220","v":"NA"},"(max)",{"$f":"Calculator!AD220","v":0},{"$f":"Calculator!AE220","v":"Error"}]
["CO2e per floor area with max",null,"Per Floor area",null,null,null,"kg CO2e/m²/year",{"$f":"Calculator!AB221","v":"NA"},"(max)",{"$f":"Calculator!AD221","v":""},{"$f":"Calculator!AE221","v":"Error"}]
[null,null,"Max",null,null,null,"kg CO2e",{"$f":"Calculator!AB222","v":"NA"},"(max)",{"$f":"Calculator!AD222","v":0}]
["Perscriptive",null,"Heating",null,null,null,null,{"$f":"Calculator!AB223","v":"NA"},{"$f":"VLOOKUP(H191,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"Calculator!AD223","v":"Zero Carb"},{"$f":"Calculator!AE223","v":"Error"}]
[null,null,"Hot Water",null,null,null,null,{"$f":"Calculator!AB224","v":"NA"},{"$f":"VLOOKUP(H192,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"Calculator!AD224","v":"Zero Carb"}]
[null,null,"All building systems,equipment and appliances",null,null,null,null,{"$f":"Calculator!AB225","v":"NA"},{"$f":"VLOOKUP(H193,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"Calculator!AD225","v":"Zero Carb"}]
["Target Reached",null,null,null,null,null,null,null,null,null,{"$f":"Calculator!AD226","v":"No"}]

{"sheet":"Calculator","index":3,"n_rows":242,"n_cols":43,"rows_kept":242,"cut":false,"hidden":false,"merged":[[30,4,30,5],[219,16,220,16],[203,15,204,15],[203,16,204,16],[117,27,118,27],[180,6,180,7],[240,8,240,17],[241,8,241,17],[239,8,239,17],[237,5,237,6],[230,8,230,17],[231,8,231,17],[232,8,232,17],[233,8,233,17],[234,8,234,17],[236,8,236,12],[236,13,236,17],[238,8,238,17],[237,8,237,12],[237,13,237,17],[225,19,225,26],[220,19,221,22],[221,4,221,8],[221,16,222,16],[188,29,188,30],[116,6,117,8],[114,10,114,12],[114,13,114,17],[169,11,170,15],[116,12,118,12],[116,13,118,13],[116,14,118,14],[116,15,118,15],[188,15,188,16],[117,23,118,23],[117,25,118,25],[116,10,118,10],[116,11,118,11],[184,4,184,16],[184,19,184,30],[171,4,174,5],[139,4,139,5],[114,3,114,9],[116,22,118,22],[176,6,176,7],[116,9,118,9],[171,11,174,13],[169,4,170,7],[7,31,7,32],[7,14,9,14],[7,21,9,21],[7,22,9,22],[7,27,7,28],[116,20,118,20],[116,21,118,21],[116,23,116,24],[116,25,116,26],[114,21,114,22],[8,23,9,23],[116,16,118,16],[116,17,118,17],[116,18,118,18],[116,19,118,19],[7,15,9,15],[7,16,9,16],[8,28,9,28],[8,25,9,25],[8,24,9,24],[61,23,61,24],[61,25,61,26],[8,27,9,27],[62,27,63,27],[220,30,221,30],[197,19,197,26],[189,29,190,29],[190,27,190,28],[222,19,224,21],[224,22,224,26],[223,22,223,26],[222,22,222,26],[194,19,196,21],[196,22,196,26],[195,22,195,26],[202,29,202,30],[203,27,203,28],[203,29,204,29],[203,30,204,30],[216,29,216,30],[217,27,217,28],[217,29,218,29],[217,30,218,30],[218,27,218,28],[189,30,190,30],[192,30,193,30],[194,30,196,30],[192,19,193,22],[5,3,5,9],[7,5,9,5],[7,3,9,3],[6,6,6,8],[7,6,8,8],[7,9,9,9],[5,21,5,22],[217,16,218,16],[190,13,190,14],[217,13,217,14],[217,15,218,15],[189,13,189,14],[189,15,190,15],[216,15,216,16],[195,16,197,16],[114,19,114,20],[168,17,169,22],[194,22,194,26],[189,16,190,16],[191,16,192,16],[8,26,9,26],[7,13,9,13],[5,13,5,17],[203,13,203,14],[2,14,2,19],[5,19,5,20],[7,19,9,19],[7,20,9,20],[7,17,9,17],[7,18,9,18],[7,10,9,10],[5,10,5,12],[7,11,9,11],[7,12,9,12],[223,16,225,16],[7,29,7,30],[7,33,9,33],[7,34,9,34],[7,23,7,24],[7,25,7,26],[218,13,218,14],[175,4,175,5],[176,4,176,5],[177,4,181,5],[175,6,175,7],[179,6,179,7],[181,6,181,7],[193,4,193,8],[116,27,116,28],[116,29,116,30],[116,31,116,32],[116,33,118,33],[116,5,118,5],[193,16,194,16],[7,4,9,4],[222,30,224,30],[116,4,118,4],[61,33,63,33],[7,42,9,42],[5,38,5,42],[116,42,118,42],[114,38,114,42],[117,24,118,24],[117,26,118,26],[117,28,118,28],[117,30,118,30],[117,32,118,32],[5,23,5,37],[116,40,118,40],[116,41,118,41],[7,40,9,40],[7,41,9,41],[7,38,9,38],[8,32,9,32],[116,38,118,38],[116,39,118,39],[116,34,118,34],[8,30,9,30],[7,39,9,39],[114,23,114,37],[116,35,117,37],[7,35,8,37],[61,34,63,34],[61,35,62,37],[61,38,63,38],[61,39,63,39],[61,40,63,40],[61,41,63,41],[61,42,63,42],[59,3,59,9],[59,10,59,12],[59,13,59,17],[59,19,59,20],[59,21,59,22],[59,23,59,37],[59,38,59,42],[61,4,63,4],[61,5,63,5],[61,6,62,8],[61,9,63,9],[61,10,63,10],[61,11,63,11],[61,12,63,12],[61,13,63,13],[61,14,63,14],[62,23,63,23],[62,24,63,24],[62,25,63,25],[62,26,63,26],[62,28,63,28],[62,30,63,30],[62,32,63,32],[61,27,61,28],[84,4,84,5],[61,31,61,32],[61,15,63,15],[61,16,63,16],[61,17,63,17],[61,18,63,18],[61,19,63,19],[61,20,63,20],[61,21,63,21],[61,22,63,22],[61,29,61,30],[206,30,207,30],[207,4,207,8],[207,16,208,16],[208,19,210,21],[208,22,208,26],[208,30,210,30],[209,16,211,16],[209,22,209,26],[210,22,210,26],[211,19,211,26],[181,11,181,12],[176,11,176,15],[177,11,177,15],[178,11,178,12],[179,11,179,12],[180,11,180,12],[204,13,204,14],[204,27,204,28],[205,16,206,16],[206,19,207,22],[202,15,202,16],[189,27,189,28]]}
["BC Energy and Carbon Step Code Compliance Calculator "]
[]
[]
[]
[null,null,null,"9.36 Step Code Data Proposed"]
[null,null,null,"The following columns are used to calculate:",null,null,null,null,null,null,"% Improvement & MEUI",null,null,"Whole Building ACH & NLA",null,null,null,null,"TEDI"," % Heat Loss Reduction",null,"% of Building Cooled",null,"GHG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Consumption"]
[]
[null,null,null,"Line #","Suite Number/ Name","P\nFile #'s:","Heated Floor Area (m2)",null,null,"Number Of Dwelling Units","Baseloads\n (GJ)","Total AEC\n (GJ)","ERS Reference\nHouse (GJ)","Building Envelope Surface Area\n(m2)","Building Volume (m3)","ACH\n@ 50Pa","Airtightness\nNLA @ 10 Pa (cm2/m2)","Airtightness NLR  (L/s/m2) @ 50Pa","Auxiliary Energy\nRequired (MJ)","PROPOSED\nGross Space Heat Loss (GJ)","REFERENCE\nGross Space Heat Loss (GJ)","Design Cooling Load (Watts)","Cooling System Capacity\n(Watts)","Electricity",null,"Natural Gas",null,"Propane",null,"District Energy",null,"Other GHG",null,"Total GHG (kg)","GHGI\n(kg CO2e /m²)","Fuel Type",null,null,"Electricity Consumption\n(GJ)","Natural Gas Consumption\n(GJ)","Propane Consumption\n(GJ)","District Energy Consumption \n(GJ)","Other (GJ)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF\n(kg CO2e/GJ)","GHG (kg)","EF\n(kg CO2e/GJ)","GHG (kg)","EF \n(kg CO2e/GJ)","GHG (kg)","EF \n(kg CO2e/GJ)","GHG (kg)","EF\n(kg CO2e/GJ)","GHG (kg)"]
[null,null,null,null,null,null,"Above Grade","Below Grade","Total",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,"Heating","Hot Water","Other"]
[null,null,null,1,null,null,null,null,{"$f":"SUM(G11:H11)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(I11>0,(((O11*P11)*1000)/3600)/N11,\"0\")","v":"0"},null,null,null,null,null,{"$f":"$X$31","v":3.0555799999999995},{"$f":"AM11*X11","v":0},{"$f":"$Z$31","v":50.000399999999992},{"$f":"AN11*Z11","v":0},{"$f":"$AB$31","v":59.87},{"$f":"AO11*AB11","v":0},{"$f":"$AD$31","v":0},{"$f":"AP11*AP11","v":0},{"$f":"$AF$10","v":0},{"$f":"AF11*AQ11","v":0},{"$f":"AG11+AE11+AC11+AA11+Y11","v":0},{"$f":"IF(I11>0,(AH11)/I11,0)","v":0}]
[null,null,null,{"$f":"D11+1","v":2},null,null,null,null,{"$f":"SUM(G12:H12)","v":0},null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,{"$f":"AM12*X12","v":0},{"$f":"$Z$31","v":50.000399999999992},{"$f":"AN12*Z12","v":0},59.87,{"$f":"AO12*AB12","v":0},0,{"$f":"AP12*AP12","v":0},0,{"$f":"AF12*AQ12","v":0},{"$f":"AG12+AE12+AC12+AA12+Y12","v":0},{"$f":"IF(I12>0,(AH12/1000)/I12,0)","v":0}]
[null,null,null,{"$f":"D12+1","v":3},null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,{"$f":"AG13+AE13+AC13+AA13+Y13","v":0},0]
[null,null,null,4,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,5,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,6,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,7,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,8,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,9,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,10,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,11,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,12,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,13,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,14,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,15,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,16,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,17,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D27+1","v":18},null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,19,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D29+1","v":20},null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,{"$f":"$X$31","v":3.0555799999999995},0,{"$f":"$Z$31","v":50.000399999999992},0,{"$f":"$AB$31","v":59.87},0,{"$f":"$AD$31","v":0},0,0,0,0,0]
[null,null,null,null,"Proposed total",null,{"$f":"SUM(G11:G30)","v":0},{"$f":"SUM(H11:H30)","v":0},{"$f":"G31+H31","v":0},{"$f":"SUM(J11:J30)","v":0},{"$f":"SUM(K11:K30)","v":0},0,0,0,0,{"$f":"IFERROR(AVERAGE(P11:P30),\"\")","v":""},{"$f":"IFERROR(AVERAGE(Q11:Q30),\"\")","v":""},{"$f":"IFERROR(AVERAGE(R11:R30),\"\")","v":""},{"$f":"SUM(S11:S30)","v":0},0,0,0,0,{"$f":"References!C62","v":3.0555799999999995},{"$f":"SUM(Y11:Y30)","v":0},{"$f":"References!C66","v":50.000399999999992},{"$f":"SUM(AA11:AA30)","v":0},{"$f":"References!C73","v":59.87},{"$f":"SUM(AC11:AC30)","v":0},{"$f":"AD10","v":0},0,{"$f":"AF10","v":0},0,0,{"$f":"IFERROR((AH31/I31),\"\")","v":""},{"$f":"IF(References!$AH$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"IF(References!$AI$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"IF(References!$AJ$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"SUM(AM11:AM30)","v":0},{"$f":"SUM(AN11:AN30)","v":0},{"$f":"SUM(AO11:AO30)","v":0},{"$f":"SUM(AP11:AP30)","v":0},{"$f":"SUM(AQ11:AQ30)","v":0}]
[]
[]
[null,null,null,"9.36.5 Reference house   "]
[]
[null,null,null,1]
[null,null,null,{"$f":"D36+1","v":2}]
[null,null,null,{"$f":"D37+1","v":3}]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,null,"Proposed Reference",null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P36:P55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(Q36:Q55)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R36:R55)","v":0}]
[]
[]
[null,null,null,"9.36 Step Code Data Mid Construction"]
[null,null,null,"The following columns are used to calculate:",null,null,null,null,null,null,"% Improvement & MEUI",null,null,"Whole Building ACH & NLA",null,null,null,null,"TEDI"," % Heat Loss Reduction",null,"% of Building Cooled",null,"GHG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Consumption"]
[]
[null,null,null,null,"Suite Number/ Name","N\nFile #'s:","Heated Floor Area (m2)",null,null,"Number Of Dwelling Units","Baseloads\n (GJ)","Total AEC\n (GJ)","ERS Reference\nHouse (GJ)","Building Envelope Surface Area\n(m2)","Building Volume (m3)","ACH\n@ 50Pa","Airtightness\nNLA @ 10 Pa (cm2/m2)","Airtightness NLR @ L/s/m2","Auxiliary Energy\nRequired (MJ)","PROPOSED\nGross Space Heat Loss (GJ)","REFERENCE\nGross Space Heat Loss (GJ)","Design Cooling Load (Watts)","Cooling System Capacity\n(Watts)","Electricity",null,"Natural Gas",null,"Propane",null,"District Energy",null,"Other GHG",null,"Total GHG (kg)","GHGI\n(kg CO2e /m²)","Fuel Type",null,null,"Electricity Consumption\n(GJ)","Natural Gas Consumption\n(GJ)","Propane Consumption\n(GJ)","District Energy Consumption \n(GJ)","Other (GJ)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF \n(kg CO2e/GJ)","GHG (kg)","EF \n(kg CO2e/GJ)","GHG (kg)","EF\n(kg CO2e/GJ)","GHG (kg)","EF \n(kg CO2e/GJ)","GHG (kg)","EF\n(kg CO2e/GJ)","GHG (kg)"]
[null,null,null,"Line #",null,null,"Above Grade","Below Grade","Total",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,"Heating","Hot Water","Other"]
[null,null,null,1,null,null,null,null,{"$f":"H65+G65","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(I65>0,(((O65*P65)*1000)/3600)/N65,\"0\")","v":"0"},null,null,null,null,null,{"$f":"$X$140","v":3.0555799999999995},{"$f":"AM65*X65","v":0},{"$f":"$Z$140","v":50.000399999999992},{"$f":"AN65*Z65","v":0},{"$f":"$AB$85","v":59.87},{"$f":"AB65*AO65","v":0},{"$f":"$AD$140","v":0},{"$f":"AD65*AP65","v":0},{"$f":"$AF$119","v":0},{"$f":"AF65*AQ65","v":0},{"$f":"AG65+AE65+AC65+AA65+Y65","v":0},{"$f":"IF(I65>0,(AH65)/I65,0)","v":0}]
[null,null,null,{"$f":"D65+1","v":2},null,null,null,null,{"$f":"H66+G66","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(I66>0,(((O66*P66)*1000)/3600)/N66,\"0\")","v":"0"},null,null,null,null,null,3.0555799999999995,{"$f":"AM66*X66","v":0},50.000399999999992,{"$f":"AN66*Z66","v":0},{"$f":"$AB$85","v":59.87},{"$f":"AB66*AO66","v":0},0,{"$f":"AD66*AP66","v":0},{"$f":"$AF$119","v":0},{"$f":"AF66*AQ66","v":0},{"$f":"AG66+AE66+AC66+AA66+Y66","v":0},{"$f":"IF(I66>0,(AH66/1000)/I66,0)","v":0}]
[null,null,null,{"$f":"D66+1","v":3},null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,{"$f":"AG67+AE67+AC67+AA67+Y67","v":0},0]
[null,null,null,4,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,5,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,6,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,7,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,8,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,9,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,10,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,11,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,12,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,13,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,14,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,15,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,16,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,17,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,{"$f":"AM81*X81","v":0},50.000399999999992,{"$f":"AN81*Z81","v":0},59.87,{"$f":"AB81*AO81","v":0},0,{"$f":"AD81*AP81","v":0},0,{"$f":"AF81*AQ81","v":0},{"$f":"AG81+AE81+AC81+AA81+Y81","v":0},{"$f":"IF(I81>0,(AH81/1000)/I81,0)","v":0}]
[null,null,null,18,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,{"$f":"AM82*X82","v":0},50.000399999999992,{"$f":"AN82*Z82","v":0},59.87,{"$f":"AB82*AO82","v":0},0,{"$f":"AD82*AP82","v":0},0,{"$f":"AF82*AQ82","v":0},{"$f":"AG82+AE82+AC82+AA82+Y82","v":0},{"$f":"IF(I82>0,(AH82/1000)/I82,0)","v":0}]
[null,null,null,19,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,20,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,null,"As-Built Total",null,{"$f":"SUM(G65:G84)","v":0},{"$f":"SUM(H65:H84)","v":0},{"$f":"G85+H85","v":0},{"$f":"SUM(J65:J84)","v":0},{"$f":"SUM(K65:K84)","v":0},0,0,0,0,{"$f":"IFERROR(AVERAGE(P65:P84),\"\")","v":""},{"$f":"IFERROR(AVERAGE(Q65:Q84),\"\")","v":""},{"$f":"IFERROR(AVERAGE(R65:R84),\"\")","v":""},{"$f":"SUM(S65:S84)","v":0},{"$f":"SUM(T65:T84)","v":0},{"$f":"SUM(U65:U84)","v":0},{"$f":"SUM(V65:V84)","v":0},{"$f":"SUM(W65:W84)","v":0},{"$f":"References!C62","v":3.0555799999999995},{"$f":"SUM(Y65:Y84)","v":0},{"$f":"References!C66","v":50.000399999999992},{"$f":"SUM(AA65:AA84)","v":0},{"$f":"References!C73","v":59.87},{"$f":"SUM(AC65:AC84)","v":0},{"$f":"AD64","v":0},{"$f":"SUM(AE65:AE84)","v":0},{"$f":"AF64","v":0},{"$f":"SUM(AG65:AG84)","v":0},{"$f":"SUM(AH65:AH84)","v":0},{"$f":"IFERROR(AH85/I85,\"\")","v":""},{"$f":"IF(References!$AP$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"IF(References!$AQ$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"IF(References!$AR$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"SUM(AM65:AM84)","v":0},{"$f":"SUM(AN65:AN84)","v":0},{"$f":"SUM(AO65:AO84)","v":0},{"$f":"SUM(AP65:AP84)","v":0},{"$f":"SUM(AQ65:AQ84)","v":0}]
[]
[]
[null,null,null,"9.36.5 Reference house   "]
[]
[]
[null,null,null,1]
[null,null,null,{"$f":"D91+1","v":2}]
[null,null,null,{"$f":"D92+1","v":3}]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,null,"As-Built Reference",null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P91:P110)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(Q91:Q110)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(R91:R110)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,"9.36 Step Code Data As Built"]
[null,null,null,"The following columns are used to calculate:",null,null,null,null,null,null,"% Improvement & MEUI",null,null,"Whole Building ACH & NLA",null,null,null,null,"TEDI"," % Heat Loss Reduction",null,"% of Building Cooled",null,"GHG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Consumption"]
[]
[null,null,null,null,"Suite Number/ Name","N\nFile #'s:","Heated Floor Area (m2)",null,null,"Number Of Dwelling Units","Baseloads\n (GJ)","Total AEC\n (GJ)","ERS Reference\nHouse (GJ)","Building Envelope Surface Area\n(m2)","Building Volume (m3)","ACH\n@ 50Pa","Airtightness\nNLA @ 10 Pa (cm2/m2)","Airtightness NLR @ L/s/m2","Auxiliary Energy\nRequired (MJ)","PROPOSED\nGross Space Heat Loss (GJ)","REFERENCE\nGross Space Heat Loss (GJ)","Design Cooling Load (Watts)","Cooling System Capacity\n(Watts)","Electricity",null,"Natural Gas",null,"Propane",null,"District Energy",null,"Other GHG",null,"Total GHG (kg)","GHGI\n(kg CO2e /m²)","Fuel Type",null,null,"Electricity Consumption\n(GJ)","Natural Gas Consumption\n(GJ)","Propane Consumption\n(GJ)","District Energy Consumption \n(GJ)","Other (GJ)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF \n(kg CO2e/GJ)","GHG (kg)","EF \n(kg CO2e/GJ)","GHG (kg)","EF\n(kg CO2e/GJ)","GHG (kg)","EF \n(kg CO2e/GJ)","GHG (kg)","EF\n(kg CO2e/GJ)","GHG (kg)"]
[null,null,null,"Line #",null,null,"Above Grade","Below Grade","Total",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,"Heating","Hot Water","Other"]
[null,null,null,1,null,null,null,null,{"$f":"H120+G120","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(I120>0,(((O120*P120)*1000)/3600)/N120,\"0\")","v":"0"},null,null,null,null,null,{"$f":"$X$140","v":3.0555799999999995},{"$f":"AM120*X120","v":0},{"$f":"$Z$140","v":50.000399999999992},{"$f":"AN120*Z120","v":0},{"$f":"$AB$140","v":59.87},{"$f":"AB120*AO120","v":0},{"$f":"$AD$140","v":0},{"$f":"AD120*AP120","v":0},{"$f":"$AF$119","v":0},{"$f":"AF120*AQ120","v":0},{"$f":"AG120+AE120+AC120+AA120+Y120","v":0},{"$f":"IF(I120>0,(AH120)/I120,0)","v":0}]
[null,null,null,{"$f":"D120+1","v":2},null,null,null,null,{"$f":"H121+G121","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(I121>0,(((O121*P121)*1000)/3600)/N121,\"0\")","v":"0"},null,null,null,null,null,3.0555799999999995,{"$f":"AM121*X121","v":0},50.000399999999992,{"$f":"AN121*Z121","v":0},59.87,{"$f":"AB121*AO121","v":0},0,{"$f":"AD121*AP121","v":0},{"$f":"$AF$119","v":0},{"$f":"AF121*AQ121","v":0},{"$f":"AG121+AE121+AC121+AA121+Y121","v":0},{"$f":"IF(I121>0,(AH121/1000)/I121,0)","v":0}]
[null,null,null,{"$f":"D121+1","v":3},null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,{"$f":"AG122+AE122+AC122+AA122+Y122","v":0},0]
[null,null,null,4,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,5,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,6,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,7,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,8,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,9,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,10,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,11,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,12,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,13,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,14,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,15,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,16,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,17,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,{"$f":"AM136*X136","v":0},50.000399999999992,{"$f":"AN136*Z136","v":0},59.87,{"$f":"AB136*AO136","v":0},0,{"$f":"AD136*AP136","v":0},0,{"$f":"AF136*AQ136","v":0},{"$f":"AG136+AE136+AC136+AA136+Y136","v":0},{"$f":"IF(I136>0,(AH136/1000)/I136,0)","v":0}]
[null,null,null,18,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,19,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,20,null,null,null,null,0,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,3.0555799999999995,0,50.000399999999992,0,59.87,0,0,0,0,0,0,0]
[null,null,null,null,"As-Built Total",null,{"$f":"SUM(G120:G139)","v":0},{"$f":"SUM(H120:H139)","v":0},{"$f":"G140+H140","v":0},{"$f":"SUM(J120:J139)","v":0},{"$f":"SUM(K120:K139)","v":0},0,0,0,0,{"$f":"IFERROR(AVERAGE(P120:P139),\"\")","v":""},{"$f":"IFERROR(AVERAGE(Q120:Q139),\"\")","v":""},{"$f":"IFERROR(AVERAGE(R120:R139),\"\")","v":""},{"$f":"SUM(S120:S139)","v":0},{"$f":"SUM(T120:T139)","v":0},{"$f":"SUM(U120:U139)","v":0},{"$f":"SUM(V120:V139)","v":0},{"$f":"SUM(W120:W139)","v":0},{"$f":"References!C62","v":3.0555799999999995},{"$f":"SUM(Y120:Y139)","v":0},{"$f":"References!C66","v":50.000399999999992},{"$f":"SUM(AA120:AA139)","v":0},{"$f":"References!C73","v":59.87},{"$f":"SUM(AC120:AC139)","v":0},{"$f":"AD119","v":0},{"$f":"SUM(AE120:AE139)","v":0},{"$f":"AF119","v":0},{"$f":"SUM(AG120:AG139)","v":0},{"$f":"SUM(AH120:AH139)","v":0},{"$f":"IFERROR(AH140/I140,\"\")","v":""},{"$f":"IF(References!$AL$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"IF(References!$AM$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"IF(References!$AN$62>2,References!$AH$37,References!$AH$36)","v":"Zero Carb"},{"$f":"SUM(AM120:AM139)","v":0},{"$f":"SUM(AN120:AN139)","v":0},{"$f":"SUM(AO120:AO139)","v":0},{"$f":"SUM(AP120:AP139)","v":0},{"$f":"SUM(AQ120:AQ139)","v":0}]
[]
[]
[null,null,null,"9.36.5 Reference house   "]
[]
[]
[null,null,null,1]
[null,null,null,{"$f":"D146+1","v":2}]
[null,null,null,{"$f":"D147+1","v":3}]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17,null,"SUMMERLAND"]
[null,null,null,18,null,0.21787767198229399]
[null,null,null,19,null,"Hot 2000"]
[null,null,null,20,null,11.11]
[null,null,null,null,"As-Built Reference",3359,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P146:P165)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(Q146:Q165)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(R146:R165)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Create Detailed Model Reports"]
[null,null,null,null,"Energy Step Code ",null,null,null,null,null,null,"Carbon Standard"]
[]
[null,null,null,null,"SELECT Energy Step Level:",null,"Required",3,null,null,null,"Carbon Standard Level:",null,null,"Required","EL 1 - Measure Only"]
[null,null,null,null,null,null,"Proposed:",3,null,null,null,null,null,null,"Proposed:","EL 1 - Measure Only"]
[null,null,null,null,null,null,"Mid-Con",3,null,null,null,null,null,null,"Mid-Con","EL 1 - Measure Only"]
[null,null,null,null,null,null,"As-Built:",3,null,null,null,null,null,null,"As-Built:","EL 1 - Measure Only"]
[null,null,null,null,null,null,{"$f":"IF(AND(2300<=$G$177,$G$177<3000),References!$W$16,IF(AND(3000<=$G$177,$G$177<4000),References!$W$17,IF(AND(4000<=$G$177,$G$177<5000),References!$W$18,IF(AND(5000<=$G$177,$G$177<6000),References!$W$19,IF(AND(6000<=$G$177,$G$177<7000),References!$W$20,IF(7000<=$G$177,References!$W$21,\"-\"))))))","v":"-"}]
[null,null,null,null,"ENTER Heating Degree Days (HDD):",null,null,null,null,null,null,"Building Type Selection"]
[null,null,null,null,"Cooling System Capacity (Watts)",null,"Proposed:",{"$f":"W31","v":0},null,null,null,"Single Detached"]
[null,null,null,null,null,null,"As-Built:",{"$f":"W140","v":0},null,null,null,"*Hover here for important note*",null,"Dwelling Unit Count (ERS)","Unit Count w/o Suites","Unit Count Used "]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(W31/V31 <= 0.5, \"Not more than 50%\", \"More than 50%\"), \"-\")","v":"-"},null,null,null,null,"Proposed",null,{"$f":"J31","v":0},{"$f":"COUNTIF(J11:J30,\">0\")","v":0},{"$f":"IF(OR($L$178=References!$B$26,$L$178=References!$B$29),O180,N180)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(W85/V85 <= 0.5, \"Not more than 50%\", \"More than 50%\"), \"-\")","v":"-"},null,null,null,null,"Mid-Con",null,{"$f":"J85","v":0},{"$f":"COUNTIF(J65:J84,\">0\")","v":0},{"$f":"IF(OR($L$178=References!$B$26,$L$178=References!$B$29),O181,N181)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(W140/V140 <= 0.5, \"Not more than 50%\", \"More than 50%\"), \"-\")","v":"-"},null,{"$f":"IF(AND(2500<=$H$172,$H$172<3000),References!$W$16,IF(AND(3000<=$H$172,$H$172<4000),References!$W$17,IF(AND(4000<=$H$172,$H$172<5000),References!$W$18,IF(AND(5000<=$H$172,$H$172<6000),References!$W$19,IF(AND(6000<=$H$172,$H$172<7000),References!$W$20,IF(7000<=$H$172,References!$W$21,\"-\"))))))","v":"-"},null,null,"As-Built",null,{"$f":"J140","v":0},{"$f":"COUNTIF(J120:J139,\">0\")","v":0},{"$f":"IF(OR($L$178=References!$B$26,$L$178=References!$B$29),O182,N182)","v":0}]
[]
[]
[null,null,null,null,"F: 9.36.6. ENERGY STEP CODE COMPLIANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F: Zero Carbon Step code Compliance"]
[]
[null,null,null,null,null,null,null,null,"Proposed House Rated Energy Consumption (GJ/year):",{"$f":"IF((L31-K31)>0,ROUND(L31-K31,0),\"-\")","v":"-"},null,null,null,null,"Reference House Rated Energy Target (GJ/year):",{"$f":"IF((M31-K31)>0,ROUND(M31-K31,0),\"-\")","v":"-"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Calculations"]
[null,null,null,null,"Proposed House Metrics",null,null,null,null,null,null,null,"Unit","Proposed Step Requirement",null,"Proposed House Result ","Proposed House \nPass or Fail",null,null,"Proposed House Metrics",null,null,null,null,null,null,"Unit","Proposed Level Requirement",null,"Proposed House Result ","Proposed House \nPass or Fail"]
[null,null,null,null,"Step Code Level",null,null,null,null,null,null,null,"Step 3, 4 or 5",{"$f":"IF(ISBLANK(H173),\"\",H173)","v":3},null,null,null,null,null,"Carbon Step Code Level",null,null,null,null,null,null,"EL-1 to 4",{"$f":"IF(ISBLANK(P173),\"\",P173)","v":"EL 1 - Measure Only"}]
[null,null,null,null,"Mechanical Energy Use Intensity (MEUI)",null,null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"IFERROR(VLOOKUP($G$176&$G$180&$H$173&References!$B$8,References!AA9:AF224,6,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IFERROR(ROUND((L31-K31)/(I31)*277.78,0),-0.001)","v":-1E-3},{"$f":"IF(H191=1, IF(P193<N193, \"Fail\", \"Pass\"), IF(OR(AND(P192<=N192,N192<>\"-\",P192<>0),P193>=N193), \"Pass\", \"Fail\"))","v":{"$error":"#N/A"}},null,null,"Total GHG",null,null,null,null,null,null,"kg CO2e/ year",{"$f":"IF((VLOOKUP(AB191,References!$AH$12:$AI$15,2,FALSE))=\"NA\", (VLOOKUP(AB191,References!$AH$12:$AI$15,2,FALSE)), (VLOOKUP(AB191,References!$AH$12:$AI$15,2,FALSE))*P180)","v":"NA"},"(max)",{"$f":"AH31","v":0},{"$f":"IF(AD192<=AB192, IF(AD192<>0, \"Pass\", \"Error\"), \"Fail\")","v":"Error"}]
[null,null,null,null,"% Improvement",null,null,null,null,null,null,null,"%",{"$f":"IF(O31>300,(VLOOKUP($H$173&$G$176,References!$I$9:$T$38,7,FALSE)),(VLOOKUP($H$173&$G$176,References!$I$9:$T$38,8,FALSE)))","v":{"$error":"#N/A"}},"(min)",{"$f":"IF(OR(PCRefHouse=0,CodePath=References!W44),0,IFERROR(ROUND(((M31-K31)-(L31-K31))/(M31-K31)*100,1),-0.001))","v":0},null,null,null,"CO2e Per floor area with Max",null,null,null,null,"Per Floor area",null,"kg CO2e/m²/year",{"$f":"VLOOKUP(AB191,References!$AH$20:$AJ$23,2,FALSE)","v":"NA"},"(max)",{"$f":"AI31","v":""},{"$f":"IF(AND(AD193<=AB193, AD194<=AB194), IF(AND(AD193<>0, AD194<>0), \"Pass\", \"Error\"), \"Fail\")","v":"Error"}]
[null,null,null,null,"Thermal Energy Demand (TEDI)",null,null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"IFERROR(ROUND(VLOOKUP($H$173&$G$176,References!$I$9:$T$38,10,FALSE),0),\"-\")","v":"-"},"(max)",{"$f":"IFERROR(ROUND(S31/1000/(I31)*277.78,0),\"\")","v":""},{"$f":"IF(H193=1, IF(P195<N195, \"Fail\", \"Pass\"), IF(OR(AND(P194<=N194,N194<>\"-\",P194<>0),P195>=N195), \"Pass\", \"Fail\"))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Max GHG",null,"kg CO2e",{"$f":"IF((VLOOKUP(AB191,References!$AH$20:$AJ$23,3,FALSE))=\"NA\", (VLOOKUP(AB191,References!$AH$20:$AJ$23,3,FALSE)), (VLOOKUP(AB191,References!$AH$20:$AJ$23,3,FALSE))*P180)","v":"NA"},"(max)",{"$f":"AH31","v":0},null,null,null,null,"Cross Ref"]
[null,null,null,null,"% Heat Loss Reduction",null,null,null,null,null,null,null,"%",{"$f":"IF(O31>300,(VLOOKUP($H$173&$G$176,References!I7:U38,12,FALSE)),(VLOOKUP($H$173&$G$176,References!I7:U38,13,FALSE)))","v":{"$error":"#N/A"}},"(min)",{"$f":"IF(OR(U31=0,CodePath=References!W44),0,IFERROR(ROUND(((U31-T31)/U31)*100,0),-0.001))","v":0},null,{"$f":"IF(OR(N191=1,P195>=N195,N195=\"-\"),TRUE,FALSE)","v":{"$error":"#N/A"}},null,"Prescriptive",null,null,"Heating",null,null,null,null,{"$f":"VLOOKUP(AB191,References!$AH$28:$AK$31,2,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB195,References!AH35:AI37,2,FALSE)","v":1},{"$f":"AJ31","v":"Zero Carb"},{"$f":"IF(AJ11=\"\", \"Error\", IF(AND(AC195<=AI195, AC196<=AI196, AC197<=AI197), \"Pass\", \"Fail\"))","v":"Error"},null,null,null,{"$f":"VLOOKUP(AJ31,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Airtightness in Air Changes per Hour at 50 Pa differential",null,null,null,null,null,null,null,"ACH @ 50 Pa",{"$f":"IFERROR(VLOOKUP($H$173&$G$176,References!$I$9:$T$38,4,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(P31,1)>0,ROUND(P31,1),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(P196<=N196,P197<=N197,P198<=N198),\"Pass\",\"Fail\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Hot Water",null,null,null,null,{"$f":"VLOOKUP(AB191,References!$AH$28:$AK$31,3,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB196,References!AH35:AI37,2,FALSE)","v":1},{"$f":"AK31","v":"Zero Carb"},null,null,null,null,{"$f":"VLOOKUP(AK31,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Normalized Leakage Area",null,null,null,null,null,null,null,"10 Pa (cm2/m2)",{"$f":"IFERROR(VLOOKUP($H$173&$G$176,References!$I$9:$T$38,5,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(Q31,2)>0,ROUND(Q31,2),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,"All building systems, equipment and appliances",null,null,null,null,{"$f":"VLOOKUP(AB191,References!$AH$28:$AK$31,4,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB197,References!AH35:AI37,2,FALSE)","v":1},{"$f":"AL31","v":"Zero Carb"},null,null,null,null,{"$f":"VLOOKUP(AL31,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Normalized Leakage Rate",null,null,null,null,null,null,null,"L/s/m2",{"$f":"IFERROR(VLOOKUP($H$173&$G$176,References!$I$9:$T$38,6,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(R31,2)>0,ROUND(R31,2),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Target Reached",{"$f":"IF(OR(AE192=\"Pass\", AE193=\"Pass\", AE195=\"Pass\"), \"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Step Code Requirements Met:",{"$f":"IF(AND(Q194=\"Pass\", Q192=\"Pass\", Q196=\"Pass\"), \"Yes\",\"No\")","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,"Proposed House Rated Energy Consumption (GJ/year):",{"$f":"IF((L85-K85)>0,ROUND(L85-K85,0),\"-\")","v":"-"},null,null,null,null,"Reference House Rated Energy Target (GJ/year):",{"$f":"IF((M85-K85)>0,ROUND(M85-K85,0),\"-\")","v":"-"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,"As-Built Calculations"]
[null,null,null,null,"As-Built House Metrics",null,null,null,null,null,null,null,"Unit","As Built Step Requirement",null,"Proposed House Result ","Proposed House \nPass or Fail",null,null,"As-Built Metrics",null,null,null,null,null,null,"Unit","Requirement",null,"As-Built House Result ","As-Built House \nPass or Fail"]
[null,null,null,null,"Step Code Level",null,null,null,null,null,null,null,"Step 3, 4 or 5",{"$f":"IF(ISBLANK(H174),\"\",H174)","v":3},null,null,null,null,null,"Carbon Step Code Level",null,null,null,null,null,null,"EL-1  to 4",{"$f":"IF(ISBLANK(P174),\"\",P174)","v":"EL 1 - Measure Only"}]
[null,null,null,null,"Mechanical Energy Use Intensity (MEUI)",null,null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"IFERROR(VLOOKUP($G$176&$G$181&$H$174&References!$B$8,References!AA9:AF224,6,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IFERROR(ROUND((L85-K85)/(I85)*277.78,0),-0.001)","v":-1E-3},{"$f":"IF(H205=1, IF(P207<N207, \"Fail\", \"Pass\"), IF(OR(AND(P206<=N206,N206<>\"-\",P206<>0),P207>=N207), \"Pass\", \"Fail\"))","v":{"$error":"#N/A"}},null,null,"Total GHG",null,null,null,null,null,null,"kg CO2e/ year",{"$f":"IF((VLOOKUP(AB205,References!$AH$12:$AI$15,2,FALSE))=\"NA\", (VLOOKUP(AB205,References!$AH$12:$AI$15,2,FALSE)), (VLOOKUP(AB205,References!$AH$12:$AI$15,2,FALSE))*P181)","v":"NA"},"(max)",{"$f":"AH85","v":0},{"$f":"IF(AD206<=AB206, IF(AD206<>0, \"Pass\", \"Error\"), \"Fail\")","v":"Error"}]
[null,null,null,null,"% Improvement",null,null,null,null,null,null,null,"%",{"$f":"IF(O17>300,(VLOOKUP($H$174&$G$176,References!$I$9:$T$38,7,FALSE)),(VLOOKUP($H$174&$G$176,References!$I$9:$T$38,8,FALSE)))","v":{"$error":"#N/A"}},"(min)",{"$f":"IF(OR(CodePathAB = References!W30, CodePathMC = References!W30),0,IFERROR(ROUND(((M85-K85)-(L85-K85))/(M85-K85)*100,1),-0.001))","v":-1E-3},null,null,null,"C02e Per floor area with Max",null,null,null,null,"Per Floor area",null,"kg CO2e/m²/year",{"$f":"VLOOKUP(AB205,References!$AH$20:$AJ$23,2,FALSE)","v":"NA"},"(max)",{"$f":"AI85","v":""},{"$f":"IF(AND(AD207<=AB207, AD208<=AB208), IF(AND(AD207<>0, AD208<>0), \"Pass\", \"Error\"), \"Fail\")","v":"Error"}]
[null,null,null,null,"Thermal Energy Demand (TEDI)",null,null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"IFERROR(ROUND(VLOOKUP($H$174&$G$176,References!$I$9:$T$38,10,FALSE),0),\"-\")","v":"-"},"(max)",{"$f":"IFERROR(ROUND(S85/1000/(I85)*277.78,0),\"\")","v":""},{"$f":"IF(H207=1, IF(P209<N209, \"Fail\", \"Pass\"), IF(OR(AND(P208<=N208,N208<>\"-\",P208<>0),P209>=N209), \"Pass\", \"Fail\"))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Max GHG",null,"kg CO2e",{"$f":"IF((VLOOKUP(AB205,References!$AH$20:$AJ$23,3,FALSE))=\"NA\", (VLOOKUP(AB205,References!$AH$20:$AJ$23,3,FALSE)), (VLOOKUP(AB205,References!$AH$20:$AJ$23,3,FALSE))*P181)","v":"NA"},"(max)",{"$f":"AH85","v":0},null,null,null,null,"Cross Ref"]
[null,null,null,null,"% Heat Loss Reduction",null,null,null,null,null,null,null,"%",{"$f":"IF(O31>300,(VLOOKUP($H$174&$G$176,References!I7:U38,12,FALSE)),(VLOOKUP($H$174&$G$176,References!I7:U38,13,FALSE)))","v":{"$error":"#N/A"}},"(min)",{"$f":"IF(OR(CodePathAB = References!W30, CodePathMC = References!W30), 0, IFERROR(ROUND(((U85 - T85) / U85) * 100, 0), -0.001))","v":-1E-3},null,{"$f":"IF(OR(N205=1,P209>=N209,N209=\"-\"),TRUE,FALSE)","v":{"$error":"#N/A"}},null,"Prescriptive",null,null,"Heating",null,null,null,null,{"$f":"VLOOKUP(AB205,References!$AH$28:$AK$31,2,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB209,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"AJ85","v":"Zero Carb"},{"$f":"IF(AJ65=\"\", \"Error\", IF(AND(AC209<=AI209, AC210<=AI210, AC211<=AI211), \"Pass\", \"Fail\"))","v":"Error"},null,null,null,{"$f":"VLOOKUP(AJ85,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Airtightness in Air Changes per Hour at 50 Pa differential",null,null,null,null,null,null,null,"ACH @ 50 Pa",{"$f":"IFERROR(VLOOKUP($H$174&$G$176,References!$I$9:$T$38,4,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(P85,1)>0,ROUND(P85,1),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(P210<=N210,P211<=N211,P212<=N212),\"Pass\",\"Fail\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Hot Water",null,null,null,null,{"$f":"VLOOKUP(AB205,References!$AH$28:$AK$31,3,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB210,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"AK85","v":"Zero Carb"},null,null,null,null,{"$f":"VLOOKUP(AK85,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Normalized Leakage Area",null,null,null,null,null,null,null,"10 Pa (cm2/m2)",{"$f":"IFERROR(VLOOKUP($H$174&$G$176,References!$I$9:$T$38,5,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(Q85,2)>0,ROUND(Q85,2),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,"All building systems, equipment and appliances",null,null,null,null,{"$f":"VLOOKUP(AB205,References!$AH$28:$AK$31,4,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB211,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"AL85","v":"Zero Carb"},null,null,null,null,{"$f":"VLOOKUP(AL85,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Normalized Leakage Rate",null,null,null,null,null,null,null,"L/s/m2",{"$f":"IFERROR(VLOOKUP($H$174&$G$176,References!$I$9:$T$38,6,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(R85,2)>0,ROUND(R85,2),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Target Reached",{"$f":"IF(OR(AE206=\"Pass\", AE207=\"Pass\", AE209=\"Pass\"), \"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Step Code Requirements Met:",{"$f":"IF(AND(Q208=\"Pass\", Q206=\"Pass\", Q210=\"Pass\"), \"Yes\",\"No\")","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,"Proposed House Rated Energy Consumption (GJ/year):",{"$f":"IF((L140-K140)>0,ROUND(L140-K140,0),\"-\")","v":"-"},null,null,null,null,"Reference House Rated Energy Target (GJ/year):",{"$f":"IF((M140-K140)>0,ROUND(M140-K140,0),\"-\")","v":"-"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,"As-Built Calculations"]
[null,null,null,null,"As-Built House Metrics",null,null,null,null,null,null,null,"Unit","As Built Step Requirement",null,"Proposed House Result ","Proposed House \nPass or Fail",null,null,"As-Built Metrics",null,null,null,null,null,null,"Unit","Requirement",null,"As-Built House Result ","As-Built House \nPass or Fail"]
[null,null,null,null,"Step Code Level",null,null,null,null,null,null,null,"Step 3, 4 or 5",{"$f":"IF(ISBLANK(H175),\"\",H175)","v":3},null,null,null,null,null,"Carbon Step Code Level",null,null,null,null,null,null,"EL-1  to 4",{"$f":"IF(ISBLANK(P175),\"\",P175)","v":"EL 1 - Measure Only"}]
[null,null,null,null,"Mechanical Energy Use Intensity (MEUI)",null,null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"IFERROR(VLOOKUP($G$176&$G$182&$H$175&References!$B$8,References!AA9:AF238,6,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IFERROR(ROUND((L140-K140)/(I140)*277.78,0),-0.001)","v":-1E-3},{"$f":"IF(H219=1, IF(P221<N221, \"Fail\", \"Pass\"), IF(OR(AND(P220<=N220,N220<>\"-\",P220<>0),P221>=N221), \"Pass\", \"Fail\"))","v":{"$error":"#N/A"}},null,null,"Total GHG",null,null,null,null,null,null,"kg CO2e/ year",{"$f":"IF((VLOOKUP(AB219,References!AH12:AI15,2,FALSE))=\"NA\", (VLOOKUP(AB219,References!AH12:AI15,2,FALSE)), (VLOOKUP(AB219,References!AH12:AI15,2,FALSE))*P182)","v":"NA"},"(max)",{"$f":"AH140","v":0},{"$f":"IF(AD220<=AB220, IF(AD220<>0, \"Pass\", \"Error\"), \"Fail\")","v":"Error"}]
[null,null,null,null,"% Improvement",null,null,null,null,null,null,null,"%",{"$f":"IF(O31>300,(VLOOKUP($H$175&$G$176,References!$I$9:$T$38,7,FALSE)),(VLOOKUP($H$175&$G$176,References!$I$9:$T$38,8,FALSE)))","v":{"$error":"#N/A"}},"(min)",{"$f":"IF(OR(CodePathAB = References!W44, CodePathMC = References!W44),0,IFERROR(ROUND(((M140-K140)-(L140-K140))/(M140-K140)*100,1),-0.001))","v":-1E-3},null,null,null,"C02e Per floor area with Max",null,null,null,null,"Per Floor area",null,"kg CO2e/m²/year",{"$f":"VLOOKUP(AB219,References!AH20:AJ23,2,FALSE)","v":"NA"},"(max)",{"$f":"AI140","v":""},{"$f":"IF(AND(AD221<=AB221, AD222<=AB222), IF(AND(AD221<>0, AD222<>0), \"Pass\", \"Error\"), \"Fail\")","v":"Error"}]
[null,null,null,null,"Thermal Energy Demand (TEDI)",null,null,null,null,null,null,null,"kWh/(m²·year)",{"$f":"IFERROR(ROUND(VLOOKUP($H$175&$G$176,References!$I$9:$T$38,10,FALSE),0),\"-\")","v":"-"},"(max)",{"$f":"IFERROR(ROUND(S140/1000/(I140)*277.78,0),\"\")","v":""},{"$f":"IF(H221=1, IF(P223<N223, \"Fail\", \"Pass\"), IF(OR(AND(P222<=N222,N222<>\"-\",P222<>0),P223>=N223), \"Pass\", \"Fail\"))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Max GHG",null,"kg CO2e",{"$f":"IF((VLOOKUP(AB219,References!AH20:AJ23,3,FALSE))=\"NA\", (VLOOKUP(AB219,References!AH20:AJ23,3,FALSE)), (VLOOKUP(AB219,References!AH20:AJ23,3,FALSE))*P182)","v":"NA"},"(max)",{"$f":"AH140","v":0},null,null,null,null,"Cross Ref"]
[null,null,null,null,"% Heat Loss Reduction",null,null,null,null,null,null,null,"%",{"$f":"IF(O140>300,(VLOOKUP($H$175&$G$176,References!I7:U38,12,FALSE)),(VLOOKUP($H$175&$G$176,References!I7:U38,13,FALSE)))","v":{"$error":"#N/A"}},"(min)",{"$f":"IF(OR(CodePathAB = References!W44, CodePathMC = References!W44), 0, IFERROR(ROUND(((U140 - T140) / U140) * 100, 0), -0.001))","v":-1E-3},null,{"$f":"IF(OR(N219=1,P223>=N223,N223=\"-\"),TRUE,FALSE)","v":{"$error":"#N/A"}},null,"Prescriptive",null,null,"Heating",null,null,null,null,{"$f":"VLOOKUP($AB$219,References!$AH$28:$AK$31,2,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB223,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"AJ140","v":"Zero Carb"},{"$f":"IF(AJ120=\"\", \"Error\", IF(AND(AC223<=AI223, AC224<=AI224, AC225<=AI225), \"Pass\", \"Fail\"))","v":"Error"},null,null,null,{"$f":"VLOOKUP(AJ140,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Airtightness in Air Changes per Hour at 50 Pa differential",null,null,null,null,null,null,null,"ACH @ 50 Pa",{"$f":"IFERROR(VLOOKUP($H$175&$G$176,References!$I$9:$T$38,4,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(P140,1)>0,ROUND(P140,1),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(P224<=N224,P225<=N225,P226<=N226),\"Pass\",\"Fail\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Hot Water",null,null,null,null,{"$f":"VLOOKUP($AB$219,References!$AH$28:$AK$31,3,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB224,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"AK140","v":"Zero Carb"},null,null,null,null,{"$f":"VLOOKUP(AK140,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Normalized Leakage Area",null,null,null,null,null,null,null,"10 Pa (cm2/m2)",{"$f":"IFERROR(VLOOKUP($H$175&$G$176,References!$I$9:$T$38,5,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(Q140,2)>0,ROUND(Q140,2),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,"All building systems, equipment and appliances",null,null,null,null,{"$f":"VLOOKUP($AB$219,References!$AH$28:$AK$31,4,FALSE)","v":"NA"},{"$f":"VLOOKUP(AB225,References!$AH$35:$AI$37,2,FALSE)","v":1},{"$f":"AL140","v":"Zero Carb"},null,null,null,null,{"$f":"VLOOKUP(AL140,References!$AH$35:$AI$37,2,FALSE)","v":3}]
[null,null,null,null,"Normalized Leakage Rate",null,null,null,null,null,null,null,"L/s/m2",{"$f":"IFERROR(VLOOKUP($H$175&$G$176,References!$I$9:$T$38,6,FALSE),\"-\")","v":"-"},"(max)",{"$f":"IF(ROUND(R140,2)>0,ROUND(R140,2),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Target Reached",{"$f":"IF(OR(AE220=\"Pass\", AE221=\"Pass\", AE223=\"Pass\"), \"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Step Code Requirements Met:",{"$f":"IF(AND(Q222=\"Pass\", Q220=\"Pass\", Q224=\"Pass\"), \"Yes\",\"No\")","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,null,"Supplemental Information",null,null,null,"Warnings"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(CodePath = References!W44, CodePathAB = References!W44, CodePathMC = References!W44), \"One or more sheets is set to 9.36.5. Is this correct?\", \"\")","v":""}]
[null,null,null,null,"Weather Location:",null,null,null,{"$f":"IF(OR(E120<>\"\", E11<>\"\"), IF(OR(I31<>I140), \"Floor area is different between stages. Is that correct?\", \"\"), \"\")","v":""}]
[null,null,null,null,"FWDR:",null,null,null,{"$f":"IF(OR(O140<>O31), \"Volume is different between stages Is that correct?\", \"\")","v":""}]
[null,null,null,null,"Software Used",null,null,null,{"$f":"IF((O140>4*I140), \"Volume seems high for the given floor area\", \"\")","v":""}]
[null,null,null,null,"Software Version",null,null,null,{"$f":"IFERROR(IF(G177<>F237, \"Caution User Entered HDD\", \"\"),\"\")","v":"Caution User Entered HDD"}]
[null,null,null,null,"Modeled HDD",4965,null,null,"Compactness Pre Con",null,null,null,null,{"$f":"IFERROR((PI()^(1/3) * (6 *O31)^(2/3) /N31),\"\")","v":""}]
[null,null,null,null,"Home Size",{"$f":"IF(I140=0,I31,I140)","v":0},null,null,"Compactness As Built",null,null,null,null,{"$f":"IFERROR((PI()^(1/3) * (6 *O140)^(2/3) /N140),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N237>0.9, \"Pre Con Possible volume or surface area Error -  Unless attatched dwelling\",\"\")","v":"Pre Con Possible volume or surface area Error -  Unless attatched dwelling"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N237<0.4, \"Pre con Extream Articulation or Volume/surface area error\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N238>0.9, \"As Built Possible volume or surface area Error -  Unless attatched dwelling\",\"\")","v":"As Built Possible volume or surface area Error -  Unless attatched dwelling"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N238<0.4, \"As Built Extream Articulation or Volume/surface area error\",\"\")","v":""}]

{"sheet":"Checklist Guide","index":4,"n_rows":269,"n_cols":14,"rows_kept":269,"cut":false,"hidden":false,"merged":[[15,10,17,10],[15,9,17,9],[19,10,21,10],[19,9,21,9],[13,6,13,7],[13,9,13,10],[24,2,24,3],[25,2,25,3],[37,2,37,3],[33,1,33,3],[16,0,17,0],[30,0,31,0],[96,2,96,3],[97,2,97,3],[99,2,99,3],[83,4,109,4],[46,4,47,4],[54,2,54,3],[78,2,78,3],[79,2,79,3],[63,4,75,4],[56,2,56,3],[57,2,57,3],[61,1,61,3],[107,1,109,1],[98,2,98,3],[100,2,100,3],[80,1,80,3],[64,1,65,1],[71,2,71,3],[50,1,51,1],[50,2,50,3],[55,2,55,3],[74,2,74,3],[210,0,211,0],[207,2,207,3],[192,2,192,3],[188,2,188,3],[150,0,151,0],[121,2,121,3],[122,2,122,3],[126,2,126,3],[139,0,140,0],[139,1,140,1],[139,2,139,3],[140,2,140,3],[180,2,180,3],[182,2,182,3],[177,2,177,3],[156,2,156,3],[156,1,157,1],[153,1,153,3],[152,1,152,3],[170,2,170,3],[161,2,161,3],[180,1,182,1],[160,0,161,0],[170,0,171,0],[213,4,216,4],[216,2,216,3],[158,0,159,0],[172,0,173,0],[201,0,202,0],[203,0,204,0],[178,0,179,0],[178,1,179,1],[178,2,178,3],[179,2,179,3],[210,4,212,4],[158,1,159,1],[158,2,158,3],[159,2,159,3],[172,1,173,1],[172,2,172,3],[160,4,166,4],[173,2,173,3],[175,1,175,3],[176,1,177,1],[184,2,184,3],[160,1,161,1],[160,2,160,3],[170,1,171,1],[105,2,105,3],[90,2,90,3],[91,2,91,3],[66,0,67,0],[66,1,67,1],[121,1,122,1],[110,1,111,1],[110,2,110,3],[117,2,117,3],[112,0,113,0],[112,1,113,1],[110,0,111,0],[119,0,120,0],[119,1,120,1],[115,2,115,3],[119,2,119,3],[120,2,120,3],[113,2,113,3],[116,1,118,1],[109,2,109,3],[106,2,106,3],[74,0,75,0],[76,2,76,3],[77,2,77,3],[205,1,207,1],[234,2,234,3],[183,2,183,3],[233,2,233,3],[227,2,227,3],[171,2,171,3],[185,2,185,3],[181,2,181,3],[217,1,218,1],[217,2,217,3],[218,2,218,3],[208,1,209,1],[209,2,209,3],[215,1,216,1],[215,2,215,3],[211,2,211,3],[210,2,210,3],[212,2,212,3],[213,2,213,3],[187,2,187,3],[205,2,205,3],[206,2,206,3],[157,2,157,3],[190,2,190,3],[191,2,191,3],[189,2,189,3],[147,2,147,3],[174,1,174,3],[204,2,204,3],[201,2,201,3],[202,2,202,3],[201,1,202,1],[151,2,151,3],[92,0,93,0],[92,1,93,1],[18,0,19,0],[32,1,32,3],[38,2,38,3],[38,1,39,1],[38,0,39,0],[73,2,73,3],[84,0,85,0],[84,1,85,1],[84,2,84,3],[85,2,85,3],[54,1,55,1],[52,1,53,1],[52,2,52,3],[51,2,51,3],[72,1,73,1],[72,2,72,3],[20,0,21,0],[22,0,23,0],[24,0,25,0],[26,0,27,0],[63,2,63,3],[88,1,89,1],[88,2,88,3],[89,2,89,3],[90,1,91,1],[58,2,58,3],[59,2,59,3],[86,0,87,0],[42,0,43,0],[42,1,43,1],[42,2,42,3],[43,2,43,3],[70,0,71,0],[70,1,71,1],[70,2,70,3],[82,0,83,0],[90,0,91,0],[46,0,47,0],[82,1,83,1],[82,2,82,3],[83,2,83,3],[75,2,75,3],[76,0,77,0],[76,1,77,1],[74,1,75,1],[44,0,45,0],[2,6,2,7],[14,1,14,3],[16,1,17,1],[16,2,16,3],[17,2,17,3],[18,1,19,1],[18,2,18,3],[19,2,19,3],[15,1,15,3],[16,4,27,4],[22,2,22,3],[23,2,23,3],[26,2,26,3],[27,2,27,3],[20,1,21,1],[26,1,27,1],[2,1,2,2],[3,1,3,2],[8,1,8,2],[13,2,13,3],[24,1,25,1],[22,1,23,1],[10,1,10,3],[121,0,126,0],[112,2,112,3],[107,0,109,0],[116,0,118,0],[114,0,115,0],[114,1,115,1],[114,2,114,3],[111,2,111,3],[124,2,124,3],[125,1,126,1],[123,1,124,1],[123,2,123,3],[125,2,125,3],[108,2,108,3],[118,2,118,3],[116,2,116,3],[107,2,107,3],[28,0,29,0],[28,1,29,1],[28,2,28,3],[29,2,29,3],[30,1,31,1],[30,2,30,3],[31,2,31,3],[20,2,20,3],[21,2,21,3],[34,0,37,0],[39,2,39,3],[35,2,35,3],[36,2,36,3],[34,1,37,1],[40,0,41,0],[40,1,41,1],[40,2,40,3],[41,2,41,3],[34,2,34,3],[101,0,102,0],[101,1,102,1],[101,2,101,3],[102,2,102,3],[103,0,104,0],[103,1,104,1],[103,2,103,3],[104,2,104,3],[94,0,100,0],[94,2,94,3],[95,2,95,3],[94,1,100,1],[44,1,45,1],[44,2,44,3],[54,0,55,0],[68,0,69,0],[68,1,69,1],[68,2,68,3],[69,2,69,3],[56,0,57,0],[56,1,57,1],[58,0,59,0],[58,1,59,1],[62,0,63,0],[62,1,63,1],[64,0,65,0],[64,2,64,3],[65,2,65,3],[46,1,47,1],[46,2,46,3],[47,2,47,3],[45,2,45,3],[52,0,53,0],[53,2,53,3],[62,2,62,3],[135,0,136,0],[135,1,136,1],[135,2,135,3],[131,0,132,0],[48,0,49,0],[48,1,49,1],[48,2,48,3],[49,2,49,3],[50,0,51,0],[78,0,79,0],[78,1,79,1],[86,1,87,1],[86,2,86,3],[87,2,87,3],[81,1,81,3],[60,1,60,3],[66,2,66,3],[67,2,67,3],[72,0,73,0],[105,0,106,0],[105,1,106,1],[92,2,92,3],[93,2,93,3],[88,0,89,0],[127,2,127,3],[128,2,128,3],[156,0,157,0],[154,0,155,0],[148,0,149,0],[137,0,138,0],[137,1,138,1],[137,2,137,3],[127,0,128,0],[127,1,128,1],[141,1,141,3],[136,2,136,3],[131,1,132,1],[148,1,149,1],[132,2,132,3],[148,2,148,3],[149,2,149,3],[131,2,131,3],[138,2,138,3],[129,0,130,0],[129,1,130,1],[129,2,129,3],[130,2,130,3],[133,0,134,0],[162,0,169,0],[162,1,169,1],[169,2,169,3],[162,2,162,3],[163,2,163,3],[164,2,164,3],[165,2,165,3],[166,2,166,3],[168,2,168,3],[167,2,167,3],[133,1,134,1],[133,2,133,3],[134,2,134,3],[155,2,155,3],[142,1,142,3],[154,2,154,3],[154,1,155,1],[143,2,143,3],[145,2,145,3],[144,2,144,3],[150,1,151,1],[150,2,150,3],[2,9,2,10],[240,2,240,3],[146,0,147,0],[146,1,147,1],[146,2,146,3],[196,1,198,1],[194,1,195,1],[190,1,191,1],[192,1,193,1],[188,1,189,1],[186,1,187,1],[183,1,185,1],[221,0,222,0],[197,2,197,3],[221,1,222,1],[221,2,221,3],[203,2,203,3],[225,0,226,0],[227,0,228,0],[231,2,231,3],[168,4,169,4],[196,0,198,0],[198,2,198,3],[186,4,187,4],[233,0,234,0],[233,1,234,1],[229,2,229,3],[266,2,266,3],[268,2,268,3],[235,0,236,0],[235,1,236,1],[235,2,235,3],[236,2,236,3],[258,2,258,3],[259,2,259,3],[260,2,260,3],[238,1,238,3],[241,2,241,3],[242,2,242,3],[243,2,243,3],[247,2,247,3],[257,2,257,3],[229,0,230,0],[262,2,262,3],[263,2,263,3],[256,2,256,3],[261,2,261,3],[255,2,255,3],[264,1,264,3],[265,1,265,3],[245,2,245,3],[246,2,246,3],[239,2,239,3],[222,2,222,3],[237,1,237,3],[225,1,226,1],[225,2,225,3],[226,2,226,3],[227,1,228,1],[228,2,228,3],[248,2,248,3],[249,2,249,3],[250,2,250,3],[251,2,251,3],[252,2,252,3],[244,2,244,3],[253,2,253,3],[254,2,254,3],[229,1,230,1],[230,2,230,3],[152,4,155,4],[231,0,232,0],[231,1,232,1],[232,2,232,3],[178,4,180,4],[183,0,185,0],[186,0,187,0],[199,4,200,4],[200,2,200,3],[219,1,219,3],[188,0,189,0],[192,0,193,0],[210,1,211,1],[212,0,214,0],[212,1,214,1],[214,2,214,3],[203,1,204,1],[205,0,207,0],[208,0,209,0],[195,2,195,3],[199,0,200,0],[199,1,200,1],[190,0,191,0],[208,2,208,3],[267,2,267,3],[22,12,24,12],[22,13,24,13],[13,12,13,13],[15,12,17,12],[15,13,17,13],[19,12,21,12],[19,13,21,13],[223,0,224,0],[223,1,224,1],[223,2,223,3],[224,2,224,3],[220,1,220,3],[176,2,176,3],[176,0,177,0],[180,0,182,0],[186,2,186,3],[193,2,193,3],[194,0,195,0],[196,2,196,3],[199,2,199,3],[194,2,194,3],[215,0,216,0],[217,0,218,0]]}
[null,"Checklist and Variables Guide "]
[null,"Pre-Construction Checklist"]
[null,"Data requiring manual entry in the Pre-Construction Checklist has light-yellow fields."]
[null,"Light yellow fields in the Pre-Construction checklist typically auto-populate to the As-Built checklist;"]
[null,"Example:"]
[null,"Requires data","No Data entry (Data Auto-populates)"]
[]
[null,"As Built Checklist"]
[null,"Data can be overwritten by Energy Advisors in the case of changes."]
[]
[null,"This table of instructions provides a description of what information should be included within each data entry point (field) of the BC Energy Compliance checklist. Cell references may differ between sheets."]
[]
[]
["CELL REF","CHECKLIST ITEM","INSTRUCTIONS",null,null,null,"Glossary of Terms",null,null,"Trouble Shooting Guide",null,null,"Change list"]
[null,"A: PROJECT INFORMATION",null,null,null,null,"ACH","Air Changes per Hour, typically at a 50 Pa pressure differential.",null,"Problem","Solution",null,"Problem","Solution"]
[null,"The purpose of this section is to provide a basic overview of building/address/builder information.",null,null,null,null,"AFUE","Annual Fuel Utilization Efficiency.",null,"Missing data from H2K extraction","Calculate within the HOT2000 model then save, repeat extraction.  HOT2000 will only populate the full data after calculating and saving.",null,"NLA Not an average","Corrected formulat"]
["D4","Building Permit # (if available) ","Building Permit Number from the AHJ (i.e. the Local Government). To be retrieved/acquired when available from the AHJ or builder. ",null,"***need to add the auto-populate",null,"AHJ","Authority having Jurisdiction such as a municipality regional distric or city. "]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed.",null,null,null,"As Built","As Built or Post-Construction"]
["D5","Builder","Full Builder Company Name. In the case of Homeowner Builder, enter Homeowner’s Name.",null,null,null,"BCBC","BC Building Code, This version of the Checklist refers to BCBC2018 Revision 5",null,"Buttons don't function","Enable macros - internet search \"how to enable Excel Macros\" for the version of spreadsheet software you are using. Note: Macros do not work in browser-based Excel versions.",null,"Mid Con report colours incorect in compliance section","Corrected formulat"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed.",null,null,null,"Calculator","The tab within the Checklist Excel sheet where data is entered and calculations for compliance are completed. ",null,"When using Get Data Button, Error stating \"name already taken\"","There is either data on that line already or there is a Suite sheet hidden. Use Del Data button or right click on sheet tabs, select unhide, select relevant Suite sheet (whichever Suite sheet number corresponds to the Get Data button you are using) and delete the sheet.",null,"Fire places were captured in the Perscriptive ZCSC","Removed fire place values from formula"]
["D6","Project Address","The address for the project. If no address is available write \"PENDING\".",null,null,null,"DES","District Energy System"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed.",null,null,null,"EA","Energy Advisor"]
["D7","Municipality / District","Full name of Jurisdiction of where the building is being constructed, e.g. enter “City of North Vancouver” or “District of North Vancouver”.  Please ensure the Jurisdiction’s name is identified correctly. ",null,null,null,"EF","Emissions Factor",null,"Items not calculating after data extraction","Save file",null,"Added Notes section to Detail reports","Added "]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed.",null,null,null,"% EFF / ER","Efficiency or Energy Ratio.",null,"Macro Not working on a MAC Computer","This sheet is not compatable with Mac or Macs running parrallels. "]
["D8","Postal Code","Canada Post Postal Code, if available. If no postal code is available write PENDING.",null,null,null,"ERS","EnerGuide Rating System; for the purposes of this manual this refers to revision 15 or newer"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed.",null,null,null,"Fenestration","Envelope assemblies that transfer visible light such as windows (including framing)",null,null,null,null,"ZCSC 0 value shows pass","changed formula to show error on Zero or blank"]
["D9","PID or Legal Description","The Parcel Identifier (PID) is a nine-digit number that uniquely identifies a parcel in the land title register in BC. Check the BC Land Title and Survey website to find the PID or Legal Description for the property.",null,null,null,"GHG","Greenhouse Gas",null,null,null,null,"Ref house can be left blank and % better shows very high number compliance shows pass","Compliance now returns 0 if ref house left blank"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed.",null,null,null,"HDD","Heating Degree Days",null,null,null,null,"9.36.5 doesn’t use ref house and shows pass ","If 9.36.5 selected ref house set to 0"]
["I7","Building Type","Indicates the building type. This is informational only.",null,null,null,"HSPF","Heating Seasonal Performance Factor.",null,null,null,null,"Warning Note Added","Warning note added for basic erros to calculator sheet"]
[null,null,"Select appropriate type of building from the drop-down menu; e.g. Single-Detached House, rowhouse, etc. Entered data auto-populates in the other checklists but can be changed manually if needed.",null,null,null,"MEUI","Mechanical Energy Use Intensity in kWh/(m²·year).",null,null,null,null,"TEDI and MEUI Tables Adjusted ","Table and formula update"]
["I8","If Other, Please Specify","If the building type is not listed in the drop-down menu, specify what building type it is. ",null,null,null,"Mid Con","Mid-Construction",null,null,null,null,"P9.11 System not showing as carbon","Extraction adjusted"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed.",null,null,null,"NLA","Normalized Leakage Area in cm²/m², typically at a reference pressure of 10 Pa.",null,null,null,null,"Hot Water rating options","added COP EFF and % eff to Hot water selection"]
[null,"B: CODE COMPLIANCE SUMMARY",null,null,null,null,"NLR","Normalized Leakage Rate L/s/m², typically at a reference pressure of 50 Pa for Part 9 buildings.",null,null,null,null,"Mid Con Data entry ","Mid con data entry added "]
[null,"The purpose of this section is to provide a basic overview of code compliance.",null,null,null,null,"NRCan","Natural Resources Canada (-resources.canada.ca)",null,null,null,null,"Unit Count doesn’t match building code","Unit count corrected with work around ERS counts differntly selection is now made in calculator page"]
["A14","BC Building Code Performance Compliance Path:","Indicates which code pathway the building is targeting",null,null,null,"Pre Con","Pre-Construction"]
[null,null,"·      If following the Subsection 9.36.6. Energy Step Code Compliance Path, check the box and complete Sections A, B, C, D, F and  G of the BC Energy Compliance Checklist. ",null,null,null,"SEER","Seasonal Energy Efficiency Ratio.",null,null,null,null,"Heating System Capactiy Added","Capacticy now shows on Model Detail reports"]
[null,null,"·      If using the Subsection 9.36.5. Energy Performance Compliance Path AND complying with Subsection 9.36.6. Energy Step Code Compliance Path check the box and complete Sections A, B, C, D, E, F and G of the BC Energy Compliance Checklist.",null,null,null,"SHGC","Solar heat gain coefficient"]
[null,null,"Select appropriate code compliance from the drop-down menu; e.g. 9.36.6. BC Energy Step Code, 9.36.5. BC Energy Step Code, etc.",null,null,null,"TEDI","Thermal Energy Demand Intensity in kWh/(m²·year)."]
["B16","Step Required","Indicates the Energy Step Code step required by the AHJ. The Modeller will need to confirm this with the AHJ.",null,null,null,"USI","U-value in metric (SI) units (W/m²K). Indicates the insulation of windows"]
[null,null,"Data will auto populate from Proposed section of the Calculator."]
["H16","Level Required","Indicates the Zero Carbon Step Code level required by the AHJ."]
[null,null,"Data will auto populate from Proposed section of the Calculator."]
["B21","Proposed Step Achieved\n(Pre Con Checklist)","Indicates the Energy Step Code step reached based on the data provided and the results of the calculator for the proposed building."]
[null,null,"Data will auto populate from Proposed section of the Calculator."]
["H21","Proposed Level Achieved\n(Pre Con Checklist)","Indicates the Zero Carbon Step Code level reached based on the data provided and the results of the calculator for the proposed building."]
[null,null,"Data will auto populate from Proposed section of the Calculator."]
["H21","This Building is Expected to Achieve Level\n(Mid Con Checklist)","Indicates the Zero Carbon Step Code level that the building is expected to reach based on data provided by the builder and/or a site visit completed by the Energy Modeller."]
[null,null,"Data will auto populate from As Built section of the Calculator."]
["B22","Step Achieved\n(As Built Checklist)","Indicates the Energy Step Code step reached based on the data provided and the results of the calculator for the as-built building."]
[null,null,"Data will auto populate from the As Built section of the Calculator."]
["H22","Level Achieved\n(As Built Checklist)","Indicates the Zero Carbon Step Code level reached based on the data provided and the results of the calculator for the as-built building."]
[null,null,"Data will auto populate from the As Built section of the Calculator."]
["D34","Based on information provided by the builder and drawings prepared by:","Indicates the information provided is sourced from information provided by the builder to the Modeller or sourced by the Modeller from the architectural drawings. Provide the name of the firm that completed the architectural drawings."]
[null,null,"Data must be entered manually."]
["D35","Plan Version\n(Pre Con Checklist)","Provide the version of the plans that the data are extracted from."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist."]
["D36","Plan Date\n(Pre Con Checklist)","Provide the date on the plans that the data are extracted from."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist."]
["J34","Site Visit Date\n( As Built Checklist)","Provide the date that the site visit was completed by the Energy Modeller."]
[null,null,"Data must be entered manually in the Mid-Construction and As Built Checklists."]
[null,"C: COMPLETED BY"]
[null,"The purpose of this section is to provide a basic overview of Energy Modeller information."]
["D40","Full Name","Provide the full name (printed not signature) of the Modeller that completed the calculations and checklist.  No signature, or professional stamp is required on this checklist"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed. ",null,"***need to add the auto-populate"]
["D41","Company Name","Provide the company/business name of the Modeller that completed the calculations and checklist."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed. "]
["D41","Phone","Provide the company/business phone number for the Modeller that completed the calculations and checklist."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed. "]
["D42","Address","Provide the company/business address for the Modeller that completed the calculations and checklist."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed. "]
["D43","Email","Provide the company/business email for the Energy Modeller) that completed the calculations and checklist."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed. "]
["K40","Date","Provide the date that the checklist was completed."]
[null,null,"Data must be entered manually."]
["K41","Advisor ID #","Provide the advisor ID number for the Modeller that completed the calculations and checklist.  If not certified Enter: no certificate"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Entered data auto-populates in the other checklists but can be changed manually if needed. "]
["C46","P File #\n(Pre Con Checklist)","This indicates the Hot2000 registration number files that have been used to select data from for the checklist. "]
[null,null,"Data will auto populate from the Proposed section Calculator."]
["C46","N File #\n(As Built Checklist)","This indicates the Hot2000 registration number files that have been used to select data from for the checklist. "]
[null,null,"Data will auto populate from the As Built section of the Calculator."]
[null,"D: BUILDING CHARACTERISTICS SUMMARY (see BCBC Clause 2.2.8.3.(2)(b) of Division C)"]
[null,"The purpose of this section is to provide clear instructions to the build/construction team. Provide a summary list of the building characteristics details as per example in Appendix I. Details listed should match building plans. To ensure clear communication it is recommended that acronym abbreviations and other jargon be avoided. When listing building envelope assemblies, it is good practice to list the components from inside to outside for walls and bottom to top for ceilings and floors. It is also recommended that only details that have a material impact on the performance be listed. This would included insulation R value, stud spacing and whether or not there is rain screen. It can be assumed that drywall and siding will be installed on a wall so it is not necessary to list these items unless they are uncommon. Less common siding having a material impact would include brick and rock, or siding with significant R value. "]
["D52","Roof/Ceiling Details","Indicates the key roof and ceiling details (assembly, system type, etc.)"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist.",null,"Copy Data Button needs to be updated and moved to top of report page."]
["D57","Above Grade Walls","Indicates the key above grade wall details (assembly, system type, etc.)"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D62","Rim Joists / Floor Headers and Lintels","Indicates the key rim joists/floor headers and lintels details (assembly, system type, etc.)"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D66","Floors Over Unheated Space","Indicates the key floors over unheated space details (assembly, system type, etc.)"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D69","Walls Below Grade","Indicates the key walls below ground details (assembly, system type, etc.)"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D72","Slabs","Indicates the key slab details (assembly, system type, etc.). "]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["K52-\nK101","Average Effective RSI and Performance values","Indicates the energy performance by stating the average effective RSI value of each building assembly (roof/ceiling, above grade walls, etc.)   \nWhere there are significant differences, assemblies should be listed on separate lines."]
[null,null,"Building Envelope: Indicate the modeled effective RSI-value of the building envelope components.  This value takes into account all framing and openings within that component and may not match a traditional RSI calculation"]
[null,null,"Note: the RSI-values from HOT2000 may be different from RSI-values on the architectural drawings."]
[null,null,"  Fenestration and Doors: Indicate the range of U-values and SHGC for the windows, skylights, and doors from the energy performance labels."]
[null,null," HVAC: Indicate the efficiency of the HVAC systems. "]
[]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D57","Windows and glazed doors","Indicates the key windows and glazed doors details. \nWhere there are significant differences they should be listed on separate lines."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["K77","USI","Indicates the USI of the windows/glazed doors."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["L77","SHGC","Indicates the solar heat gain coefficient (SHGC) of the windows/glazed doors."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D85","Air Barrier System & Location","Indicates the key air barrier system details as well as the location of the air barrier within the assembly."]
[null,null,"Note: Specifics are require entries should include location of the barrier as well as basic material \nE.g.: Walls: Interior poly and caulk or Wall: Exterior sealed membrane "]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["K85","ACH","Indicates air changes per hour (ACH)."]
[null,null,"Data will auto populate from calculator"]
["K86","NLA","Indicates normalized leakage area (NLA)."]
[null,null,"Data will auto populate from calculator"]
["K87","NLR","Indicates normalised leakage rate (NLR)."]
[null,null,"Data will auto populate from calculator"]
["D90","Principal Heating System / cooling","See Manual for definitions"]
[null,null,"Note: In Hot2000 if a heat pump is modeled this will always be the primary system unless the size is adjusted down.  A furnace will always be supplementary unless sizes are adjusted "]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D92","Supplementary Space Heating/ Cooling","See Manual for definitions"]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["L89 -\nL92","HSPF","Indicates heating seasonal performance factor (HSPF). Can be left blank if not applicable."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
[null,"SEER","Indicates seasonal energy efficiency rating (SEER). Can be left blank if not applicable. "]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
[null,"AFUE","Indicates annual fuel utilization efficiency (AFUE). Can be left blank if not applicable."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D94","Domestic Hot Water","Indicates the domestic hot water mechanical system(s)."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["L94","% EFF / ER","Indicates performance of domestic hot water (percent efficiency or efficiency rating). "]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D97","Ventilation","Indicates the ventilation system(s)."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["K98","% EFF","Indicates the % of heat recovery of the system (percent efficiency), if there is no heat recovery use 0%."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["L98","L/s","Indicates flow rate of the principal ventilation system."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D100","Other","Space to include any other energy features that may have impact on code compliance. e.g. drain water heat recovery unit."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
["D102","Fossil Fuels","Indicates if the building includes any fossil fuel use for equipment or appliances in addition to heating equipment, DHW equipment and ventilation equipment such as gas fireplaces, cook tops and laundry drying equipment."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist. Use the Copy Data button to copy data from Pre-Construction Checklist."]
[null,"D2: Mid Construction Testing Results\n(Mid Construction Checklist Only)"]
[null,"This section is only included in the Mid Construction Checklist. The purpose of this section is to provide a basic overview of testing results. This is where the Energy Modeller would provide comments on the test and/or suggested corrections to be made in order the reach the proposed energy step and emissions level.  \n\nTesting at mid construction, although highly recommended, is not mandatory unless required by an AHJ."]
["A109","Site Visit Completed on","Select Site visit completed on or No site visit. A date field will be visible if a site visit was completed. Selecting No site visit will remove the data entry fields for testing."]
["D113 \n- E113","Test Pressure High / Low","Indicates the highest and lowest test pressures used during mid construction testing. Reaching 50pa is not required. Using a range of pressures will result in more accurate results. "]
["J112 \n- J116 ","Testing Completed by","Indicates contact information for the person who completed the testing.  Modellers working in teams may not be the same person who completed the original model. "]
["A119","State of Building During test","Indicates the state of the home during the test  E.g: Missing front windows and basement door. "]
[null,null,"E.g: Missing front windows and basement door. "]
["A123","Status of buildings code compliance","States the status of the buildings code compliance based on the results of the blower door test and site visit of Energy Modeller"]
[null,null,"Select appropriate status from the drop-down menu; e.g. Building passes, No changes required, Building Did Not Pass, corrections required, retesting recommended, etc."]
["A127 \n- A152","Notes From Mid Construction Testing","Provide comments about the results of the blower door test and suggestions for corrections if the building is in need of corrections to achieve the required or proposed energy step."]
[null,null,"Data must be entered manually in Mid-Construction Checklist."]
[null,"E: 9.36.5. ENERGY PERFORMANCE COMPLIANCE (see BCBC Clause 2.2.8.3.(2)(c) of Division C)",null,null,"Should this be labelled something different for mid con and as built reports? \"proposed\" versus as built.\nIs the description still relevant?\n\n"]
[null,"The purpose of this section is to provide a more detailed overview of compliance regarding  Subsection 9.36.5.\nNote: The following guidance applies where HOT2000 is used to model for compliance.  Those using other software may not be able to apply these instructions to their projects, see the instruction manual for more details"]
["D160","Proposed House Energy Consumption - HVAC","Where using HOT2000 for Subsection 9.36.5. compliance, follow NRCan’s instructions as outlined in the “Guidelines for Using HOT2000 v.11 to Demonstrate Compliance with Subsection 9.36.5 of the 2015 National Building Code” document to obtain the HVAC energy consumption for the Proposed / As-Built House."]
[null,null,"Data must be entered manually in Mid-Construction Checklist."]
["D161","Proposed House Energy Consumption - Hot Water Heating","Where using HOT2000 for Subsection 9.36.5. compliance, follow NRCan’s instructions as outlined in the “Guidelines for Using HOT2000 v.11 to Demonstrate Compliance with Subsection 9.36.5 of the 2015 National Building Code” document to obtain the Hot Water Heating energy consumption for the Proposed / As-Built House."]
[null,null,"Data must be entered manually in Mid-Construction Checklist."]
["J160","Reference House Rated Energy Target - HVAC","Where using HOT2000 for Subsection 9.36.5. compliance, follow NRCan’s instructions as outlined in the “Guidelines for Using HOT2000 v.11 to Demonstrate Compliance with Subsection 9.36.5 of the 2015 National Building Code” document to obtain the HVAC energy consumption for the Reference House."]
[null,null,"Data must be entered manually in Mid-Construction Checklist."]
["J161","Reference House Rated Energy Target - Hot Water Heating","Where using HOT2000 for Subsection 9.36.5. compliance, follow NRCan’s instructions as outlined in the “Guidelines for Using HOT2000 v.11 to Demonstrate Compliance with Subsection 9.36.5 of the 2015 National Building Code” document to obtain the Hot Water Heating energy consumption for the Reference House.",null,"Should we even have options for step 1 and 2 since code change?  No that can be removed\n"]
[null,null,"Data must be entered manually in Mid-Construction Checklist."]
["K164","The airtightness value used in the energy model calculations for the Proposed house","Indicates the airtightness value or ACH (Air Changes per Hour) that was entered into the Hot2000 model and, therefore, used for the calculations by selecting the appropriate option in the calculator (this can be equal to or greater than the step required by the AHJ):"]
[null,null,"·       3.2 ACH @ 50 Pa, where the construction complies with Section 9.25."]
[null,null,"·       2.5 ACH @ 50 Pa, where it can be shown that the air barrier system is constructed in accordance with Subsection 9.25.3 and Articles 9.36.2.9. and 9.36.2.10."]
[null,null,"·       Tested in accordance with  Sentence 9.36.7.3.(1)  (only an option for the As-Built house)."]
[null,null,"Note: If complying with Step 3 or above of Subsection 9.36.6. using Subsection 9.36.5., the airtightness value being used in the proposed house need not be entered in the Pre-Construction Checklist. This should be added in the calculator sheet and will auto populate section D air leakage numbers."]
[null,null,"Note: If using the \"Or Tested At\" space, select the dash to indicate this space is not applicable."]
[null,null,"For more details, see BCBC Article 9.36.5.10.(9) of Division B. ",null,"Whats the difference between this and above?  Above is an untested house  Not sure we still need this\n"]
[null,null,"Select appropriate ACH value from the drop-down menu; e.g. -, 2.5, etc. Entered data auto-populates in the other checklists but can be changed manually if needed."]
["D165","Or Tested At","Indicates the tested values used for 9.35.5 compliance."]
[null,null,"Data will auto populate from calculator"]
["L167","The above calculation was performed in compliance with Subsection 9.36.5. of Division B","Indicates whether or not the building is in compliance with Subsection 9.36.5. of Division B."]
[null,null,"Select appropriate value from the drop-down menu; e.g. yes or no. Entered data auto-populates in the other checklists but can be changed manually if needed."]
[null,"F: 9.36.6. ENERGY STEP CODE COMPLIANCE (see BCBC Sentence 2.2.8.3.(3) of Division C)"]
[null,"The purpose of this section is to provide a more detailed overview of compliance regarding Subsection 9.36.6. \nNote: The following guidance applies where HOT2000 is used to model for compliance.  Those using other software may not be able to apply these instructions to their projects."]
["G170","Proposed House Rated Energy Consumption (GJ/year):","Annual energy consumption of the Proposed / As-Built building without baseloads. Equivalent to ‘Total AEC’ minus ‘Baseloads’ from the HOT2000 calculation results, rounded to the nearest whole number. "]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["L170","Reference House Rated Energy Target (GJ/year):","Annual energy consumption of the Reference House without baseloads. Equivalent to ‘ERS reference house-Base Case’ minus ‘Baseloads’ from the HOT2000 calculation results, rounded to the nearest whole number. ",null,"Would this be Correct?\n\nAdd comment about the new BC code"]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["I174","Step Code Level","Indicates the Step Code level the project is proposing to meet, This may be higher than the AHJ requires. The proposed step code is selected in the calculator which auto populates the checklists."]
[null,null,"Note: This Step Code Level may be different in the pre-construction, mid-construction, and as-built checklists if the client is aiming for a higher step than required by the AHJ. Depending on the construction progress and/or changes made to the design or mechanical systems after the pre-construction checklist was completed, this step can be raised or reduced but cannot be reduced below the step required by the AHJ. "]
[null,null,"Data will auto populate from calculator. The required, proposed, and as-built step code levels must be selected in the calculator. "]
["K175","Mechanical Energy Use Intensity (MEUI) ","The MEUI (Mechanical Energy Use Intensity) is automatically calculated after input of HOT2000 data as well as Climate and Cooling Information into the calculator. "]
[]
[null,null,"Data will auto populate from calculator based on calculator results. The required data must be entered into the calculator for this to calculate. "]
["K176","% Improvement","Indicates the buildings % improvement over the reference House. This info is automatically calculated for buildings that have complied following the ERS, after HOT2000 data are entered into the calculator"]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["K177","Thermal Energy Demand (TEDI)","The TEDI (Thermal Energy Demand Intensity) is automatically calculated after input of HOT2000 data in calculator. "]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["K178","% Heat Loss Reduction","The gross space heat loss % better is automatically calculated after input of HOT2000 data in calculator. "]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["K179","Airtightness in Air Changes per Hour at 50 Pa differential","Indicates the ACH (Air Change per Hour) at 50 Pa which gives a better idea of the airtightness of the building."]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["K180","Normalized Leakage Area\n(Proposed Step Requirement)","Indicates the Airtightness NLA (Normalized Leakage Area) at 10 Pa. "]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["K181","Normalized Leakage Rate\n(Proposed Step Requirement)","Indicates the Airtightness NLR (Normalized Leakage Rate). "]
[]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["L182","Step Code Requirement Met","Indicates whether the home met, or did not meet, the requirements for the Proposed / As-built Step Code level."]
[null,null,"Data will auto populate from calculator based on calculator results."]
["D186","Heated Floor Area (m2)","Indicates the floor area of conditioned space in square metres. In HOT2000, this is calculated by summing the Above Grade and Below Grade heated floor area found in the Specifications tab. "]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["D187","Building Volume (m3)","Indicates the buildings heated volume in meters cubed."]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["J186","Climatic Data (Location)","Indicates the weather location used by the Software. In HOT2000, this can be found in the Weather tab under the Location drop down menu. The building's design weather location can be found in the HOT2000 climate data:"]
[null,null,"https://fgp-pgf.maps.arcgis.com/apps/webappviewer/index.html?id=1f4a2a144bc1406f9deca7713986ced2",null,"Does this need updating?  This has been updated\n"]
[null,null,"Data must be entered manually in the Pre-Construction Report. Entered data auto-populates in the other reports."]
["J187","Degree Days Below 18°C (HDD)","Indicates the Heating Degree Days (HDD) Below 18°C that the building will be subjected to. The Heating Degree Days Below 18°C can be determined by the building’s weather location found in the HOT2000 climate data."]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["D189","FDWR ","Indicates the ratio of total vertical fenestration and door area to gross wall area as a percentage.  "]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["J189","% Of Space Cooled","Indicates the % cooled"]
[null,null,"Using HOT2000 will auto populate this data. "]
[null,null,"Data will auto populate from calculator. This data must be entered into the calculator."]
["D184","Software Name","List Full Name of Software (e.g. HOT2000) used for energy performance modelling."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist."]
["J184","Version","List Version of Software (e.g. v11.11 of HOT2000)."]
[null,null,"Data must be entered manually in the Pre-Construction Checklist."]
[null,"G: ZERO CARBON STEP CODE"]
[null,"The purpose of this section is to provide a more detailed overview of compliance related to Zero Carbon Step Code.\nNote: The following guidance applies where HOT2000 is used to model for compliance. \nThose using other software may not be able to apply these instructions to their projects."]
["H195","Zero Carbon Step Code Level","The Zero Carbon Step code level targeted"]
[null,null,"Data will auto populate from calculator.  The appropriate required, proposed, and as-built levels must be selected in the calculator."]
["J196","Total Carbon","The total carbon emissions per year of the building"]
[null,null,"Data will auto populate from calculator based on calculator results."]
["J197","CO2 Per floor area","Carbon intensity,  total Carbon per year divided by the floor area"]
[null,null,"Data will auto populate from calculator based on calculator results."]
["J198","CO2 Max","The total carbon emissions per year of the building"]
[null,null,"Data will auto populate from calculator based on calculator results."]
["J199","Prescriptive: Heating","Indicates if the system is decarbonized"]
[null,null,"Data will auto populate from calculator based on calculator results."]
["J200","Prescriptive: Hot Water","Indicates if the system is decarbonized"]
[null,null,"Data will auto populate from calculator based on calculator results."]
["J201","Prescriptive: Other","Indicates if the system is decarbonized"]
[null,null,"Data will auto populate from calculator based on calculator results."]
["K202","Target Reached","Indicates if the target has been reached."]
[null,null,"Data will auto populate from calculator based on calculator results."]
[null,"CALCULATOR TAB"]
[null,"The Calculator tab is the source of all calculations. Data must be entered here to activate most of the functions within the other sheets. \nInstructions here are given for the Pre Construction tab, however, they are the same for the As Built tab.     \nThe images indicate where to find the information in HOT2000 and its reports, if manually completing the Calculator.  NOTE: Maually filling in the calculator will not alow the model detail report to be created and alternative methods may be required"]
["E11","Suite Number / Name","Address of the project, include suite number for town homes or MURBS"]
["F11","P File #","P File number for each model"]
["G11","Heated Floor Area Above Grade ","Specification Tab - The Total Above grade heated floor area"]
["H11","Heated Floor Area Below Grade ","Specification Tab - The Total Below grade heated floor area"]
["J11","# Of Dwelling Units ","Specification Tab - number of dwelling units (MURB only)"]
["K11","Baseloads","Calculate window - Base loads such as plug loads and other occupant loads"]
["L11","Total AEC","Calculate window"]
["M11","ERS Reference House","Calculate window"]
["N11","Building Envelope Surface Area","Full House Report - Standard operating conditions"]
["O11","Building Volume","Full House Report - Standard operating conditions"]
["P11","ACH","Full House Report - Standard operating conditions"]
["Q11","NLR","Full House Report - Standard operating conditions"]
["S11","Auxiliary Energy","Full House Report - Standard operating conditions"]
["T11","Proposed Gross Space Heat Loss","Calculate / Code Compliance tab"]
["T11","Reference Gross Space Heat Loss","Calculate / Code Compliance tab"]
["V11","Design Cooling Load","Full House Report - Standard operating conditions"]
["W11","Cooling System Capacity","HOT2000 does not record this data in reports.  Use the manufacturer's capacity "]
["AJ11","Heating System Fuel Type","If the Fuel type is Electric select Zero Carb (Zero Carbon - low emissions) otherwise select Carb (Carbon - high emissions)"]
["AK11","Hot Water System Fuel Type","If the Fuel type is Electric select Zero Carb (Zero Carbon - low emissions) otherwise select Carb (Carbon - high emissions)"]
["AL11","Other Fuel Type","If the Fuel type is Electric select Zero Carb (Zero Carbon - low emissions) otherwise select Carb (Carbon - high emissions)"]
["AM11","Electricity Consumption","Full House Report - Standard operating conditions  requires conversion from kWh"]
["AN11","Gas Consumption","Full House Report - Standard operating conditions  requires conversion from m³"]
["G121","HDD","Weather Tab"]
["GF162","Weather Location","Weather Tab"]
["GF163","FWDR","Calculate window"]
[null,"HOT2000 Model Details"]
[null,"The Purpose of this sheet is to replace the Hot2000 Full house report with one that has more specific data that a plan checker needs.  This feature is only available to those using ERS procedures and Macros within the sheets.  Those not using this may still need to rely on the full house report or other documents. "]
["S172","Pre Con HOT2000 Detail Report","Click the button to generate the report"]
[177,"Mid Con HOT2000 Detail Report","Click the button to generate the report"]
["S180","As Built HOT2000 Detail Report","Click the button to generate the report"]

{"sheet":"Pre Con Hot2000 Details","index":5,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,1,0,12]]}
[null,"Pre Construction Hot2000 Model Details"]

{"sheet":"Mid Con Hot2000 Details","index":6,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,1,0,12]]}
[null,"Mid Con Hot2000 Model Details"]

{"sheet":"As Built Hot2000 Details","index":7,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,1,0,12]]}
[null,"As Built Hot2000 Model Details"]

{"sheet":"References","index":8,"n_rows":224,"n_cols":54,"rows_kept":224,"cut":false,"hidden":true,"merged":[[118,1,118,8],[93,1,93,8],[23,22,24,24],[6,17,6,18],[6,10,7,10],[6,9,7,9],[6,8,7,8],[109,1,109,7],[101,1,101,7],[3,8,4,19],[6,11,6,13],[6,16,7,16],[7,14,7,15],[7,19,7,20],[39,41,39,43],[87,1,87,3],[81,1,81,4],[50,1,50,9],[39,33,39,35],[39,37,39,39],[72,34,74,34],[72,35,74,35],[72,36,74,36],[72,37,72,42],[74,37,74,42]]}
[]
[null,"Step Code Reference Charts"]
[]
[null,"Update the individual tables below when needed",null,null,null,null,null,null,"This table's Adjusted TEDI depends on the HDD entered in the \"SFH & MURB Calcualtor\" & \"Attached Non-MURB Calculator\" Tabs. The Formulas used to calculate the TEDI targets based on HDDS can be found in section 9.36.6.3 of the BCBC Revision 2 Amendments ",null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon Standard Refernce Tables"]
[null,null,null,null,null,null,null,null,1,{"$f":"I6+1","v":2},3,4,5,6,7,8,9,10,11,12,13,null,"Dropdown menu 1",null,null,null,1,2,3,4,5,6]
[null,"Floor Area of Conditioned Space (m2)",null,null,null,null,null,null,"Helper","Step Level","Climate Zone","Airtightness",null,null,"Over 300m3","Under 300m3","TEDI","HDD Adjusted TEDI",null,"Over 300m3","Under 300m3"]
[null,{"$f":"IF(Calculator!I31<50.5,\"≤ 50\",(IF((AND(Calculator!I31>=50.5,Calculator!I31<75.5)),\"51 to 75\",(IF((AND(Calculator!I31>=75.5,Calculator!I31<120.5)),\"76 to 120\",(IF((AND(Calculator!I31>=120.5,Calculator!I31<165.5)),\"121 to 165\",(IF((AND(Calculator!I31>=165.5,Calculator!I31<210.5)),\"166 to 210\",(IF(Calculator!I31>=210.5,\"> 210\",1)))))))))))","v":"≤ 50"},{"$f":"IF(Calculator!I140<50.5,\"≤ 50\",(IF((AND(Calculator!I140>=50.5,Calculator!I140<75.5)),\"51 to 75\",(IF((AND(Calculator!I140>=75.5,Calculator!I140<120.5)),\"76 to 120\",(IF((AND(Calculator!I140>=120.5,Calculator!I140<165.5)),\"121 to 165\",(IF((AND(Calculator!I140>=165.5,Calculator!I140<210.5)),\"166 to 210\",(IF(Calculator!I140>=210.5,\"> 210\",1)))))))))))","v":"≤ 50"},null,null,null,null,null,null,null,null,"ACH","NLA","NLR","% LTRH",null,null,"SFH &\nMURB\nCalculator",null,"Grose Space HL",null,null,"Step Level",null,null,null,"Helper","Heating Degree-Days of Building Location in Celsius Degree-Days","Amount of the Building’s Conditioned Space Served by\nSpace-Cooling\nEquipment","Step","Floor Area of Conditioned Space (m2)","Mechanical Energy Use Intensity, kWh/(m2•year)"]
[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,{"$f":"AB9 & AC9 & AD9 & AE9","v":"4 - Less than 3000Not more than 50%3≤ 50"},"4 - Less than 3000","Not more than 50%",3,"≤ 50",120,null,"Total Carbon"]
[null,"Fuel Conversion Factors",null,null,"/ GJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - Less than 3000Not more than 50%351 to 75","4 - Less than 3000","Not more than 50%",3,"51 to 75",100,null,1,2]
[null,"Natural Gas",37.26,"MJ/m3 gas",{"$f":"C11*0.001","v":3.7260000000000001E-2},null,null,null,{"$f":"J11 & K11","v":"34 - Less than 3000"},3,"4 - Less than 3000",2.5,1.2,0.89,20,10,30,{"$f":"(Q11+(Q16-Q11)*(Calculator!$G$177-2500)/500)","v":-20},null,10,5,null,3,null,null,null,"4 - Less than 3000Not more than 50%376 to 120","4 - Less than 3000","Not more than 50%",3,"76 to 120",75,null,"Level"]
[null,"Oil",38.520000000000003,"MJ/L oil",{"$f":"C12*0.001","v":3.8520000000000006E-2},null,null,null,"44 - Less than 3000",4,"4 - Less than 3000",1.5,0.72,0.53,40,30,20,{"$f":"(Q12+(Q17-Q12)*(Calculator!$G$177-2500)/500)","v":-30},null,20,15,null,4,null,null,null,"4 - Less than 3000Not more than 50%3121 to 165","4 - Less than 3000","Not more than 50%",3,"121 to 165",63,null,"EL 1 - Measure Only","NA"]
[null,"Electricity",3.6,"MJ/kWh",{"$f":"C13*0.001","v":3.6000000000000003E-3},null,null,null,"54 - Less than 3000",5,"4 - Less than 3000",1,0.48,0.35,70,60,15,{"$f":"(Q13+(Q18-Q13)*(Calculator!$G$177-2500)/500)","v":-10},null,40,25,null,5,null,null,null,"4 - Less than 3000Not more than 50%3166 to 210","4 - Less than 3000","Not more than 50%",3,"166 to 210",53,null,"EL 2 - Moderate",1050]
[null,"Propane",25.6,"MJ/L",{"$f":"C14*0.001","v":2.5600000000000001E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dropdown menu 2",null,null,null,"4 - Less than 3000Not more than 50%3> 210","4 - Less than 3000","Not more than 50%",3,"> 210",50,null,"EL 3 - Strong",440]
[null,"Wood",1.7999999999999999E-2,"GJ/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Climate Zone",null,null,null,"4 - Less than 3000Not more than 50%4≤ 50","4 - Less than 3000","Not more than 50%",4,"≤ 50",90,null,"EL 4 - Zero Carbon",265]
[null,"District Energy",null,null,1,null,null,null,"35 - 3000 to 3999",3,"5 - 3000 to 3999",2.5,1.2,0.89,20,10,40,{"$f":"((Q16+(Q21-Q16)*(Calculator!$G$177-3000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-2},null,10,5,null,"4 - Less than 3000",null,null,null,"4 - Less than 3000Not more than 50%451 to 75","4 - Less than 3000","Not more than 50%",4,"51 to 75",80]
[null,null,null,null,null,null,null,null,"45 - 3000 to 3999",4,"5 - 3000 to 3999",1.5,0.72,0.53,40,30,30,{"$f":"((Q17+(Q22-Q17)*(Calculator!$G$177-3000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-12},null,20,15,null,"5 - 3000 to 3999",null,null,null,"4 - Less than 3000Not more than 50%476 to 120","4 - Less than 3000","Not more than 50%",4,"76 to 120",60,null,"Carbon Per Floor Area"]
[null,null,null,null,null,null,null,null,"55 - 3000 to 3999",5,"5 - 3000 to 3999",1,0.48,0.35,70,60,20,{"$f":"((Q18+(Q23-Q18)*(Calculator!$G$177-3000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-7},null,40,25,null,"6 - 4000 to 4999",null,null,null,"4 - Less than 3000Not more than 50%4121 to 165","4 - Less than 3000","Not more than 50%",4,"121 to 165",48,null,1,2,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7A - 5000 to 5999",null,null,null,"4 - Less than 3000Not more than 50%4166 to 210","4 - Less than 3000","Not more than 50%",4,"166 to 210",40,null,null,"Per Floor","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7B - 6000 to 6999",null,null,null,"4 - Less than 3000Not more than 50%4> 210","4 - Less than 3000","Not more than 50%",4,"> 210",40,null,"EL 1 - Measure Only","NA","NA"]
[null,null,null,null,null,null,null,null,"36 - 4000 to 4999",3,"6 - 4000 to 4999",2.5,1.2,0.89,20,10,50,{"$f":"((Q21+(Q26-Q21)*(Calculator!$G$177-4000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-42},null,10,5,null,"8 - More than 6999",null,null,null,"4 - Less than 3000Not more than 50%5≤ 50","4 - Less than 3000","Not more than 50%",5,"≤ 50",65,null,"EL 2 - Moderate",6,2400]
[null,"Building Types*",null,null,null,null,null,null,"46 - 4000 to 4999",4,"6 - 4000 to 4999",1.5,0.72,0.53,40,30,40,{"$f":"((Q22+(Q27-Q22)*(Calculator!$G$177-4000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-32},null,20,15,null,null,null,null,null,"4 - Less than 3000Not more than 50%551 to 75","4 - Less than 3000","Not more than 50%",5,"51 to 75",55,null,"EL 3 - Strong",2.5,800]
[null,"Select One",null,null,null,null,null,null,"56 - 4000 to 4999",5,"6 - 4000 to 4999",1,0.48,0.35,70,60,25,{"$f":"((Q23+(Q28-Q23)*(Calculator!$G$177-4000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-27},null,40,25,null,"Dropdown menu 3",null,null,null,"4 - Less than 3000Not more than 50%576 to 120","4 - Less than 3000","Not more than 50%",5,"76 to 120",40,null,"EL 4 - Zero Carbon",1.5,500]
[null,"Laneway House",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building's Conditioned Space served by Space-Cooling Equipment",null,null,null,"4 - Less than 3000Not more than 50%5121 to 165","4 - Less than 3000","Not more than 50%",5,"121 to 165",30]
[null,"Single Detached",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - Less than 3000Not more than 50%5166 to 210","4 - Less than 3000","Not more than 50%",5,"166 to 210",25,null,"Perscriptive"]
[null,"Single Detached w/Secondary Suite (MURB)",null,null,null,null,null,null,"37A - 5000 to 5999",3,"7A - 5000 to 5999",2.5,1.2,0.89,20,10,70,{"$f":"((Q26+(Q31-Q26)*(Calculator!$G$177-5000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-42},null,10,5,null,"-",null,null,null,"4 - Less than 3000Not more than 50%5> 210","4 - Less than 3000","Not more than 50%",5,"> 210",25,null,1,{"$f":"AH26+1","v":2},{"$f":"AI26+1","v":3},{"$f":"AJ26+1","v":4}]
[null,"Duplex/Semi-detached",null,null,null,null,null,null,"47A - 5000 to 5999",4,"7A - 5000 to 5999",1.5,0.72,0.53,40,30,55,{"$f":"((Q27+(Q32-Q27)*(Calculator!$G$177-5000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-7},null,20,15,null,"Not more than 50%",null,null,null,"4 - Less than 3000More than 50%3≤ 50","4 - Less than 3000","More than 50%",3,"≤ 50",155,null,null,"Fuel Type Heating","Fuel Type Hot Water","Fuel Type Other"]
[null,"Row House",null,null,null,null,null,null,"57A - 5000 to 5999",5,"7A - 5000 to 5999",1,0.48,0.35,70,60,35,{"$f":"((Q28+(Q33-Q28)*(Calculator!$G$177-5000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-52},null,40,25,null,"More than 50%",null,null,null,"4 - Less than 3000More than 50%351 to 75","4 - Less than 3000","More than 50%",3,"51 to 75",128,null,"EL 1 - Measure Only","NA","NA","NA"]
[null,"Row House w/Secondary Suite (MURB)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - Less than 3000More than 50%376 to 120","4 - Less than 3000","More than 50%",3,"76 to 120",93,null,"EL 2 - Moderate","Zero Carb","NA","NA"]
[null,"Low-Rise (MURB)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dropdown menu 5",null,null,null,"4 - Less than 3000More than 50%3121 to 165","4 - Less than 3000","More than 50%",3,"121 to 165",73,null,"EL 3 - Strong","Zero Carb","Zero Carb","NA"]
[null,"Stacked Duplex (MURB)",null,null,null,null,null,null,"37B - 6000 to 6999",3,"7B - 6000 to 6999",2.5,1.2,0.89,20,10,90,{"$f":"((Q31+(Q36-Q31)*(Calculator!$G$177-6000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-12},null,10,5,null,"Conditioned Space Area",null,null,null,"4 - Less than 3000More than 50%3166 to 210","4 - Less than 3000","More than 50%",3,"166 to 210",60,null,"EL 4 - Zero Carbon","Zero Carb","Zero Carb","Zero Carb"]
[null,"Triplex (MURB)",null,null,null,null,null,null,"47B - 6000 to 6999",4,"7B - 6000 to 6999",1.5,0.72,0.53,40,30,65,{"$f":"((Q32+(Q37-Q32)*(Calculator!$G$177-6000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-37},null,20,15,null,"≤ 50",null,null,null,"4 - Less than 3000More than 50%3> 210","4 - Less than 3000","More than 50%",3,"> 210",55]
[null,"Retail",null,null,null,null,null,null,"57B - 6000 to 6999",5,"7B - 6000 to 6999",1,0.48,0.35,70,60,50,{"$f":"((Q33+(Q38-Q33)*(Calculator!$G$177-6000)/1000))+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-22},null,40,25,null,"51 to \n75",null,null,null,"4 - Less than 3000More than 50%4≤ 50","4 - Less than 3000","More than 50%",4,"≤ 50",125,null,"Fuel Numbers"]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"76 to \n120",null,null,null,"4 - Less than 3000More than 50%451 to 75","4 - Less than 3000","More than 50%",4,"51 to 75",108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121 to \n165",null,null,null,"4 - Less than 3000More than 50%476 to 120","4 - Less than 3000","More than 50%",4,"76 to 120",78,null,"NA",1,"NA"]
[null,null,null,null,null,null,null,null,"38 - More than 6999",3,"8 - More than 6999",2.5,1.2,0.89,20,10,105,{"$f":"(Q36+(Q36-Q31)*(Calculator!$G$177-7000)/1000)+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-12},null,10,5,null,"166 to \n210",null,null,null,"4 - Less than 3000More than 50%4121 to 165","4 - Less than 3000","More than 50%",4,"121 to 165",58,null,"Carbon",2,"Gas"]
[null,null,null,null,null,null,null,null,"48 - More than 6999",4,"8 - More than 6999",1.5,0.72,0.53,40,30,80,{"$f":"(Q37+(Q37-Q32)*(Calculator!$G$177-7000)/1000)+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-37},null,20,15,null,"> 210",null,null,null,"4 - Less than 3000More than 50%4166 to 210","4 - Less than 3000","More than 50%",4,"166 to 210",48,null,"Zero Carb",3,"Electric"]
[null,"Slab is:",null,null,null,null,null,null,"58 - More than 6999",5,"8 - More than 6999",1,0.48,0.35,70,60,60,{"$f":"(Q38+(Q38-Q33)*(Calculator!$G$177-7000)/1000)+(IF(Calculator!$F$238>=210,\"0\",(0.004*(Calculator!$G$177-3000))))","v":-22},null,40,25,null,null,null,null,null,"4 - Less than 3000More than 50%4> 210","4 - Less than 3000","More than 50%",4,"> 210",45]
[null,"Below",null,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dropdown menu 6",null,null,null,"4 - Less than 3000More than 50%5≤ 50","4 - Less than 3000","More than 50%",5,"≤ 50",100]
[null,"Above Frostline",null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code path",null,null,null,"4 - Less than 3000More than 50%551 to 75","4 - Less than 3000","More than 50%",5,"51 to 75",83,null,"Pre Construction",null,null,null,"Post Construction",null,null,null,"Mid Construction"]
[null,"Heated",null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.36.6. BC Energy Step Code  ERS",null,null,null,"4 - Less than 3000More than 50%576 to 120","4 - Less than 3000","More than 50%",5,"76 to 120",58,null,"Heating","Hot Water","Other",null,"Heating","Hot Water","Other",null,"Heating","Hot Water","Other"]
[null,"Unheated",null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.36.6. BC Energy Step Code  NECB",null,null,null,"4 - Less than 3000More than 50%5121 to 165","4 - Less than 3000","More than 50%",5,"121 to 165",40,null,{"$f":"IF(Calculator!AJ11=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK11=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL11=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ120=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK120=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL120=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ65=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK65=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL65=$AH$36,2,3)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.36.6. Passive House ",null,null,null,"4 - Less than 3000More than 50%5166 to 210","4 - Less than 3000","More than 50%",5,"166 to 210",33,null,{"$f":"IF(Calculator!AJ12=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK12=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL12=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ121=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK121=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL121=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ66=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK66=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL66=$AH$36,2,3)","v":3}]
[null,"Building Types*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.36.5. BC Energy Step Code",null,null,null,"4 - Less than 3000More than 50%5> 210","4 - Less than 3000","More than 50%",5,"> 210",30,null,{"$f":"IF(Calculator!AJ13=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK13=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL13=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ122=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK122=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL122=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ67=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK67=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL67=$AH$36,2,3)","v":3}]
[null,"Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - 3000 to 3999Not more than 50%3≤ 50","5 - 3000 to 3999","Not more than 50%",3,"≤ 50",135,null,{"$f":"IF(Calculator!AJ14=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK14=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL14=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ123=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK123=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL123=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ68=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK68=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL68=$AH$36,2,3)","v":3}]
[null,"Double/Semi-detached",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - 3000 to 3999Not more than 50%351 to 75","5 - 3000 to 3999","Not more than 50%",3,"51 to 75",115,null,{"$f":"IF(Calculator!AJ15=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK15=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL15=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ124=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK124=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL124=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ69=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK69=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL69=$AH$36,2,3)","v":3}]
[null,"Row, End Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - 3000 to 3999Not more than 50%376 to 120","5 - 3000 to 3999","Not more than 50%",3,"76 to 120",90,null,{"$f":"IF(Calculator!AJ16=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK16=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL16=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ125=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK125=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL125=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ70=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK70=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL70=$AH$36,2,3)","v":3}]
[null,"Row, Middle Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - 3000 to 3999Not more than 50%3121 to 165","5 - 3000 to 3999","Not more than 50%",3,"121 to 165",78,null,{"$f":"IF(Calculator!AJ17=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK17=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL17=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ126=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK126=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL126=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ71=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK71=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL71=$AH$36,2,3)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down 7",null,null,null,"5 - 3000 to 3999Not more than 50%3166 to 210","5 - 3000 to 3999","Not more than 50%",3,"166 to 210",68,null,{"$f":"IF(Calculator!AJ18=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK18=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL18=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ127=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK127=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL127=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ72=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK72=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL72=$AH$36,2,3)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon Standard",null,null,null,"5 - 3000 to 3999Not more than 50%3> 210","5 - 3000 to 3999","Not more than 50%",3,"> 210",65,null,{"$f":"IF(Calculator!AJ19=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK19=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL19=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ128=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK128=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL128=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ73=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK73=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL73=$AH$36,2,3)","v":3}]
[null,"Modeling Slection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EL 1 - Measure Only",null,null,null,"5 - 3000 to 3999Not more than 50%4≤ 50","5 - 3000 to 3999","Not more than 50%",4,"≤ 50",100,null,{"$f":"IF(Calculator!AJ20=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK20=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL20=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ129=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK129=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL129=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ74=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK74=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL74=$AH$36,2,3)","v":3}]
[null,"Subsection 9.36.5.,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EL 2 - Moderate",null,null,null,"5 - 3000 to 3999Not more than 50%451 to 75","5 - 3000 to 3999","Not more than 50%",4,"51 to 75",90,null,{"$f":"IF(Calculator!AJ21=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK21=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL21=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ130=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK130=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL130=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ75=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK75=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL75=$AH$36,2,3)","v":3}]
[null,"The Passive House Planning Package (PHPP), version 9 or newer, and the energy model was prepared by ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EL 3 - Strong",null,null,null,"5 - 3000 to 3999Not more than 50%476 to 120","5 - 3000 to 3999","Not more than 50%",4,"76 to 120",70,null,{"$f":"IF(Calculator!AJ22=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK22=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL22=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ131=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK131=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL131=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ76=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK76=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL76=$AH$36,2,3)","v":3}]
[null,"a Certified Passive House Designer or Certified Passive House Consultant,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EL 4 - Zero Carbon",null,null,null,"5 - 3000 to 3999Not more than 50%4121 to 165","5 - 3000 to 3999","Not more than 50%",4,"121 to 165",58,null,{"$f":"IF(Calculator!AJ23=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK23=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL23=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ132=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK132=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL132=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ77=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK77=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL77=$AH$36,2,3)","v":3}]
[null,"The EnerGuide Rating System (ERS), version 15 or newer, or",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - 3000 to 3999Not more than 50%4166 to 210","5 - 3000 to 3999","Not more than 50%",4,"166 to 210",50,null,{"$f":"IF(Calculator!AJ24=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK24=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL24=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ133=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK133=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL133=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ78=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK78=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL78=$AH$36,2,3)","v":3}]
[null,"The applicable requirements of NECB Part 8 and the City of Vancouver Energy Modelling Guidelines.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down 8",null,null,null,"5 - 3000 to 3999Not more than 50%4> 210","5 - 3000 to 3999","Not more than 50%",4,"> 210",50,null,{"$f":"IF(Calculator!AJ25=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK25=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL25=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ134=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK134=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL134=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ79=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK79=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL79=$AH$36,2,3)","v":3}]
[null,"The \"Instructions for Modelling Attached Ground Oriented Part 9 Resdiential Buildings\" (found in Section 6 of the BC Energy Compliance Reports Instruction Manual)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methane Gas",51,null,null,"5 - 3000 to 3999Not more than 50%5≤ 50","5 - 3000 to 3999","Not more than 50%",5,"≤ 50",70,null,{"$f":"IF(Calculator!AJ26=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK26=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL26=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ135=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK135=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL135=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ80=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK80=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL80=$AH$36,2,3)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bio Methane Gas",4,null,null,"5 - 3000 to 3999Not more than 50%551 to 75","5 - 3000 to 3999","Not more than 50%",5,"51 to 75",60,null,{"$f":"IF(Calculator!AJ27=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK27=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL27=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ136=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK136=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL136=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ81=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK81=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL81=$AH$36,2,3)","v":3}]
[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,"5 - 3000 to 3999Not more than 50%576 to 120","5 - 3000 to 3999","Not more than 50%",5,"76 to 120",45,null,{"$f":"IF(Calculator!AJ28=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK28=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL28=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ137=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK137=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL137=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ82=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK82=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL82=$AH$36,2,3)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down 9",null,null,null,"5 - 3000 to 3999Not more than 50%5121 to 165","5 - 3000 to 3999","Not more than 50%",5,"121 to 165",35,null,{"$f":"IF(Calculator!AJ29=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK29=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL29=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ138=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK138=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL138=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ83=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK83=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL83=$AH$36,2,3)","v":3}]
[null,"Emmission Factors  Electric",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,"5 - 3000 to 3999Not more than 50%5166 to 210","5 - 3000 to 3999","Not more than 50%",5,"166 to 210",30,null,{"$f":"IF(Calculator!AJ30=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK30=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL30=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ139=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK139=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL139=$AH$36,2,3)","v":3},null,{"$f":"IF(Calculator!AJ84=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AK84=$AH$36,2,3)","v":3},{"$f":"IF(Calculator!AL84=$AH$36,2,3)","v":3}]
[null,"Grid Standard",{"$f":"E62*277.78","v":3.0555799999999995},"kgCO2e/GJ",1.0999999999999999E-2,"kgCO2e/kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,"5 - 3000 to 3999Not more than 50%5> 210","5 - 3000 to 3999","Not more than 50%",5,"> 210",30,null,{"$f":"MIN(AH42:AH61)","v":3},{"$f":"MIN(AI42:AI61)","v":3},{"$f":"MIN(AJ42:AJ61)","v":3},null,{"$f":"MIN(AL42:AL61)","v":3},{"$f":"MIN(AM42:AM61)","v":3},{"$f":"MIN(AN42:AN61)","v":3},null,{"$f":"MIN(AP42:AP61)","v":3},{"$f":"MIN(AQ42:AQ61)","v":3},{"$f":"MIN(AR42:AR61)","v":3}]
[null,"Other",null,"kgCO2e/GJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - 3000 to 3999More than 50%3≤ 50","5 - 3000 to 3999","More than 50%",3,"≤ 50",170]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down 10",null,null,null,"5 - 3000 to 3999More than 50%351 to 75","5 - 3000 to 3999","More than 50%",3,"51 to 75",143]
[null,"Emmission Factors  Methane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,"5 - 3000 to 3999More than 50%376 to 120","5 - 3000 to 3999","More than 50%",3,"76 to 120",108]
[null,"Gas Standard",{"$f":"E66*277.78","v":50.000399999999992},"kgCO2e/GJ",0.18,"kgCO2e/kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.5 ACH",null,null,null,"5 - 3000 to 3999More than 50%3121 to 165","5 - 3000 to 3999","More than 50%",3,"121 to 165",88]
[null,"Other Gas",null,"kgCO2e/GJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.2 ACH",null,null,null,"5 - 3000 to 3999More than 50%3166 to 210","5 - 3000 to 3999","More than 50%",3,"166 to 210",75]
[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,"5 - 3000 to 3999More than 50%3> 210","5 - 3000 to 3999","More than 50%",3,"> 210",70]
[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,"5 - 3000 to 3999More than 50%4≤ 50","5 - 3000 to 3999","More than 50%",4,"≤ 50",135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section D drop downs",null,null,null,"5 - 3000 to 3999More than 50%451 to 75","5 - 3000 to 3999","More than 50%",4,"51 to 75",118]
[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,"5 - 3000 to 3999More than 50%476 to 120","5 - 3000 to 3999","More than 50%",4,"76 to 120",88]
[null,"Emmission Factors  Propane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AFUE",null,null,null,"5 - 3000 to 3999More than 50%4121 to 165","5 - 3000 to 3999","More than 50%",4,"121 to 165",68]
[null,"Default",59.87,"kgCO2e/GJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HSPF",null,null,null,{"$f":"AB73 & AC73 & AD73 & AE73","v":"5 - 3000 to 3999More than 50%4166 to 210"},"5 - 3000 to 3999","More than 50%",4,"166 to 210",58,null,null,"CZ","Space Cooling Area","Step","Floor Area of Conditioned Space (m²)  "]
[null,"Other",null,"kgCO2e/GJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSE",null,null,null,"5 - 3000 to 3999More than 50%4> 210","5 - 3000 to 3999","More than 50%",4,"> 210",55,null,null,null,null,null,"<50","51-75","76-120","121-165","166-210",">210"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP",null,null,null,"5 - 3000 to 3999More than 50%5≤ 50","5 - 3000 to 3999","More than 50%",5,"≤ 50",105,null,null,null,null,null,"MEUI (kWh/m²/yr) "]
[null,"Emmission Factors District Energy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEER",null,null,null,"5 - 3000 to 3999More than 50%551 to 75","5 - 3000 to 3999","More than 50%",5,"51 to 75",88,null,null,4,"Up to 50%",3,130,108,81,67,55,50,null,null,null,null,null,"Up to 50%",null,null,"> 50%"]
[null,"Standard",10,"kgCO2e/GJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,"5 - 3000 to 3999More than 50%576 to 120","5 - 3000 to 3999","More than 50%",5,"76 to 120",63,null,null,null,null,4,98,86,64,50,41,40,null,null,null,null,null,3,4,5,3,4,5]
[null,"Other",null,"kgCO2e/GJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,"5 - 3000 to 3999More than 50%5121 to 165","5 - 3000 to 3999","More than 50%",5,"121 to 165",45,null,null,null,null,5,70,59,43,32,26,25,null,null,null,null,null,130,98,70,165,133,105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP",null,null,null,"5 - 3000 to 3999More than 50%5166 to 210","5 - 3000 to 3999","More than 50%",5,"166 to 210",38,null,null,null,"> 50%",3,165,136,99,77,62,55,null,null,null,null,null,108,86,59,136,114,87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Eff",null,null,null,"5 - 3000 to 3999More than 50%5> 210","5 - 3000 to 3999","More than 50%",5,"> 210",35,null,null,null,null,4,133,114,82,60,49,45,null,null,null,null,null,81,64,43,99,82,61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ER",null,null,null,"6 - 4000 to 4999Not more than 50%3≤ 50","6 - 4000 to 4999","Not more than 50%",3,"≤ 50",145,null,null,null,null,5,112,94,68,49,41,35]
[null,"site visit conducted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EER",null,null,null,"6 - 4000 to 4999Not more than 50%351 to 75","6 - 4000 to 4999","Not more than 50%",3,"51 to 75",125,null,null,6,"Up to 50%",3,161,139,112,98,86,75]
[null,"No mid construction site vist was completed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999Not more than 50%376 to 120","6 - 4000 to 4999","Not more than 50%",3,"76 to 120",100,null,null,null,null,4,119,107,85,71,62,55]
[null,"Mid construction site visit completed on",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section D2 drop downs",null,null,null,"6 - 4000 to 4999Not more than 50%3121 to 165","6 - 4000 to 4999","Not more than 50%",3,"121 to 165",88,null,null,null,null,5,91,80,64,53,47,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressurized",null,null,null,"6 - 4000 to 4999Not more than 50%3166 to 210","6 - 4000 to 4999","Not more than 50%",3,"166 to 210",78,null,null,null,"> 50%",3,196,167,130,108,93,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depressurized",null,null,null,"6 - 4000 to 4999Not more than 50%3> 210","6 - 4000 to 4999","Not more than 50%",3,"> 210",75,null,null,null,null,4,154,135,103,81,70,60]
[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,"6 - 4000 to 4999Not more than 50%4≤ 50","6 - 4000 to 4999","Not more than 50%",4,"≤ 50",105,null,null,null,null,5,126,108,82,63,55,45]
[null,"Mid Con Verificaiton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999Not more than 50%451 to 75","6 - 4000 to 4999","Not more than 50%",4,"51 to 75",95,null,null,"7A","Up to 50%",3,185,163,136,122,110,95]
[null,"Site Verified",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section D2 Drop Downs 2",null,null,null,"6 - 4000 to 4999Not more than 50%476 to 120","6 - 4000 to 4999","Not more than 50%",4,"76 to 120",75,null,null,null,null,4,138,126,104,90,81,70]
[null,"Unable To Verify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACH@50pa",null,null,null,"6 - 4000 to 4999Not more than 50%4121 to 165","6 - 4000 to 4999","Not more than 50%",4,"121 to 165",63,null,null,null,null,5,110,99,83,72,66,55]
[null,"Not Yet Installed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NLR@10pa",null,null,null,"6 - 4000 to 4999Not more than 50%4166 to 210","6 - 4000 to 4999","Not more than 50%",4,"166 to 210",55,null,null,null,"> 50%",3,220,191,154,132,117,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NLA L/s/m2",null,null,null,"6 - 4000 to 4999Not more than 50%4> 210","6 - 4000 to 4999","Not more than 50%",4,"> 210",55,null,null,null,null,4,173,154,122,100,89,75]
[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,"6 - 4000 to 4999Not more than 50%5≤ 50","6 - 4000 to 4999","Not more than 50%",5,"≤ 50",80,null,null,null,null,5,145,127,101,82,74,60]
[null,"Mid Construction Verification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999Not more than 50%551 to 75","6 - 4000 to 4999","Not more than 50%",5,"51 to 75",70,null,null,"7B","Up to 50%",3,209,187,160,146,134,115]
[null,"Building expected to pass, no changes required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section D2 Drop Downs 2",null,null,null,"6 - 4000 to 4999Not more than 50%576 to 120","6 - 4000 to 4999","Not more than 50%",5,"76 to 120",55,null,null,null,null,4,157,145,123,109,100,85]
[null,"Building expected to pass with minor corrections, no further testing recommended",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USI",null,null,null,"6 - 4000 to 4999Not more than 50%5121 to 165","6 - 4000 to 4999","Not more than 50%",5,"121 to 165",45,null,null,null,null,5,124,113,97,86,80,65]
[null,"Building did not pass, corrections required, retesting recommended.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U Imp",null,null,null,"6 - 4000 to 4999Not more than 50%5166 to 210","6 - 4000 to 4999","Not more than 50%",5,"166 to 210",40,null,null,null,"> 50%",3,244,215,178,156,141,120]
[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,"6 - 4000 to 4999Not more than 50%5> 210","6 - 4000 to 4999","Not more than 50%",5,"> 210",40,null,null,null,null,4,192,173,141,119,108,90]
[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,"6 - 4000 to 4999More than 50%3≤ 50","6 - 4000 to 4999","More than 50%",3,"≤ 50",180,null,null,null,null,5,159,141,115,96,88,70]
[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,"6 - 4000 to 4999More than 50%351 to 75","6 - 4000 to 4999","More than 50%",3,"51 to 75",153,null,null,8,"Up to 50%",3,228,206,179,165,153,130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,"6 - 4000 to 4999More than 50%376 to 120","6 - 4000 to 4999","More than 50%",3,"76 to 120",118,null,null,null,null,4,176,164,142,128,119,100]
[null,"Fossil Fuel  Proposed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999More than 50%3121 to 165","6 - 4000 to 4999","More than 50%",3,"121 to 165",98,null,null,null,null,5,138,127,111,100,94,75]
[null,"The building including all units is designed with NO fossil fuel use or infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999More than 50%3166 to 210","6 - 4000 to 4999","More than 50%",3,"166 to 210",85,null,null,null,"> 50%",3,263,234,197,175,160,135]
[null,"The building IS designed to use fossil fuels or has infrastructure for it",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999More than 50%3> 210","6 - 4000 to 4999","More than 50%",3,"> 210",80,null,null,null,null,4,211,192,160,138,127,105]
[null,"Fossil fuel use and infrastructure is unknown at this time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999More than 50%4≤ 50","6 - 4000 to 4999","More than 50%",4,"≤ 50",140,null,null,null,null,5,173,155,129,110,102,80]
[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,"6 - 4000 to 4999More than 50%451 to 75","6 - 4000 to 4999","More than 50%",4,"51 to 75",123]
[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,"6 - 4000 to 4999More than 50%476 to 120","6 - 4000 to 4999","More than 50%",4,"76 to 120",93]
[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,"6 - 4000 to 4999More than 50%4121 to 165","6 - 4000 to 4999","More than 50%",4,"121 to 165",73]
[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,"6 - 4000 to 4999More than 50%4166 to 210","6 - 4000 to 4999","More than 50%",4,"166 to 210",63]
[null,"Fossil Fuel   AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999More than 50%4> 210","6 - 4000 to 4999","More than 50%",4,"> 210",60]
[null,"The building including all units has NO fossil fuel use or infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999More than 50%5≤ 50","6 - 4000 to 4999","More than 50%",5,"≤ 50",115]
[null,"The building has fossil fuel use or infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999More than 50%551 to 75","6 - 4000 to 4999","More than 50%",5,"51 to 75",98]
[null,"Unable to verify fossil fuel use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - 4000 to 4999More than 50%576 to 120","6 - 4000 to 4999","More than 50%",5,"76 to 120",73]
[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,"6 - 4000 to 4999More than 50%5121 to 165","6 - 4000 to 4999","More than 50%",5,"121 to 165",55]
[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,"6 - 4000 to 4999More than 50%5166 to 210","6 - 4000 to 4999","More than 50%",5,"166 to 210",48]
[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,"6 - 4000 to 4999More than 50%5> 210","6 - 4000 to 4999","More than 50%",5,"> 210",45]
[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,"7A - 5000 to 5999Not more than 50%3≤ 50","7A - 5000 to 5999","Not more than 50%",3,"≤ 50",165]
[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,"7A - 5000 to 5999Not more than 50%351 to 75","7A - 5000 to 5999","Not more than 50%",3,"51 to 75",145]
[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,"7A - 5000 to 5999Not more than 50%376 to 120","7A - 5000 to 5999","Not more than 50%",3,"76 to 120",120]
[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,"7A - 5000 to 5999Not more than 50%3121 to 165","7A - 5000 to 5999","Not more than 50%",3,"121 to 165",108]
[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,"7A - 5000 to 5999Not more than 50%3166 to 210","7A - 5000 to 5999","Not more than 50%",3,"166 to 210",98]
[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,"7A - 5000 to 5999Not more than 50%3> 210","7A - 5000 to 5999","Not more than 50%",3,"> 210",95]
[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,"7A - 5000 to 5999Not more than 50%4≤ 50","7A - 5000 to 5999","Not more than 50%",4,"≤ 50",120]
[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,"7A - 5000 to 5999Not more than 50%451 to 75","7A - 5000 to 5999","Not more than 50%",4,"51 to 75",110]
[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,"7A - 5000 to 5999Not more than 50%476 to 120","7A - 5000 to 5999","Not more than 50%",4,"76 to 120",90]
[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,"7A - 5000 to 5999Not more than 50%4121 to 165","7A - 5000 to 5999","Not more than 50%",4,"121 to 165",78]
[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,"7A - 5000 to 5999Not more than 50%4166 to 210","7A - 5000 to 5999","Not more than 50%",4,"166 to 210",70]
[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,"7A - 5000 to 5999Not more than 50%4> 210","7A - 5000 to 5999","Not more than 50%",4,"> 210",70]
[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,"7A - 5000 to 5999Not more than 50%5≤ 50","7A - 5000 to 5999","Not more than 50%",5,"≤ 50",95]
[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,"7A - 5000 to 5999Not more than 50%551 to 75","7A - 5000 to 5999","Not more than 50%",5,"51 to 75",85]
[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,"7A - 5000 to 5999Not more than 50%576 to 120","7A - 5000 to 5999","Not more than 50%",5,"76 to 120",70]
[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,"7A - 5000 to 5999Not more than 50%5121 to 165","7A - 5000 to 5999","Not more than 50%",5,"121 to 165",60]
[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,"7A - 5000 to 5999Not more than 50%5166 to 210","7A - 5000 to 5999","Not more than 50%",5,"166 to 210",55]
[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,"7A - 5000 to 5999Not more than 50%5> 210","7A - 5000 to 5999","Not more than 50%",5,"> 210",55]
[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,"7A - 5000 to 5999More than 50%3≤ 50","7A - 5000 to 5999","More than 50%",3,"≤ 50",200]
[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,"7A - 5000 to 5999More than 50%351 to 75","7A - 5000 to 5999","More than 50%",3,"51 to 75",173]
[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,{"$f":"AB137 & AC137 & AD137 & AE137","v":"7A - 5000 to 5999More than 50%376 to 120"},"7A - 5000 to 5999","More than 50%",3,"76 to 120",138]
[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,"7A - 5000 to 5999More than 50%3121 to 165","7A - 5000 to 5999","More than 50%",3,"121 to 165",118]
[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,"7A - 5000 to 5999More than 50%3166 to 210","7A - 5000 to 5999","More than 50%",3,"166 to 210",105]
[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,"7A - 5000 to 5999More than 50%3> 210","7A - 5000 to 5999","More than 50%",3,"> 210",100]
[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,"7A - 5000 to 5999More than 50%4≤ 50","7A - 5000 to 5999","More than 50%",4,"≤ 50",155]
[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,"7A - 5000 to 5999More than 50%451 to 75","7A - 5000 to 5999","More than 50%",4,"51 to 75",138]
[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,"7A - 5000 to 5999More than 50%476 to 120","7A - 5000 to 5999","More than 50%",4,"76 to 120",108]
[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,"7A - 5000 to 5999More than 50%4121 to 165","7A - 5000 to 5999","More than 50%",4,"121 to 165",88]
[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,"7A - 5000 to 5999More than 50%4166 to 210","7A - 5000 to 5999","More than 50%",4,"166 to 210",78]
[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,"7A - 5000 to 5999More than 50%4> 210","7A - 5000 to 5999","More than 50%",4,"> 210",75]
[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,"7A - 5000 to 5999More than 50%5≤ 50","7A - 5000 to 5999","More than 50%",5,"≤ 50",130]
[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,"7A - 5000 to 5999More than 50%551 to 75","7A - 5000 to 5999","More than 50%",5,"51 to 75",113]
[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,"7A - 5000 to 5999More than 50%576 to 120","7A - 5000 to 5999","More than 50%",5,"76 to 120",88]
[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,"7A - 5000 to 5999More than 50%5121 to 165","7A - 5000 to 5999","More than 50%",5,"121 to 165",70]
[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,"7A - 5000 to 5999More than 50%5166 to 210","7A - 5000 to 5999","More than 50%",5,"166 to 210",63]
[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,"7A - 5000 to 5999More than 50%5> 210","7A - 5000 to 5999","More than 50%",5,"> 210",60]
[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,"7B - 6000 to 6999Not more than 50%3≤ 50","7B - 6000 to 6999","Not more than 50%",3,"≤ 50",185]
[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,"7B - 6000 to 6999Not more than 50%351 to 75","7B - 6000 to 6999","Not more than 50%",3,"51 to 75",165]
[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,"7B - 6000 to 6999Not more than 50%376 to 120","7B - 6000 to 6999","Not more than 50%",3,"76 to 120",140]
[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,"7B - 6000 to 6999Not more than 50%3121 to 165","7B - 6000 to 6999","Not more than 50%",3,"121 to 165",128]
[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,"7B - 6000 to 6999Not more than 50%3166 to 210","7B - 6000 to 6999","Not more than 50%",3,"166 to 210",118]
[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,"7B - 6000 to 6999Not more than 50%3> 210","7B - 6000 to 6999","Not more than 50%",3,"> 210",115]
[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,"7B - 6000 to 6999Not more than 50%4≤ 50","7B - 6000 to 6999","Not more than 50%",4,"≤ 50",135]
[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,"7B - 6000 to 6999Not more than 50%451 to 75","7B - 6000 to 6999","Not more than 50%",4,"51 to 75",125]
[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,"7B - 6000 to 6999Not more than 50%476 to 120","7B - 6000 to 6999","Not more than 50%",4,"76 to 120",105]
[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,"7B - 6000 to 6999Not more than 50%4121 to 165","7B - 6000 to 6999","Not more than 50%",4,"121 to 165",93]
[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,"7B - 6000 to 6999Not more than 50%4166 to 210","7B - 6000 to 6999","Not more than 50%",4,"166 to 210",85]
[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,"7B - 6000 to 6999Not more than 50%4> 210","7B - 6000 to 6999","Not more than 50%",4,"> 210",85]
[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,"7B - 6000 to 6999Not more than 50%5≤ 50","7B - 6000 to 6999","Not more than 50%",5,"≤ 50",105]
[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,"7B - 6000 to 6999Not more than 50%551 to 75","7B - 6000 to 6999","Not more than 50%",5,"51 to 75",95]
[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,"7B - 6000 to 6999Not more than 50%576 to 120","7B - 6000 to 6999","Not more than 50%",5,"76 to 120",80]
[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,"7B - 6000 to 6999Not more than 50%5121 to 165","7B - 6000 to 6999","Not more than 50%",5,"121 to 165",70]
[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,"7B - 6000 to 6999Not more than 50%5166 to 210","7B - 6000 to 6999","Not more than 50%",5,"166 to 210",65]
[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,"7B - 6000 to 6999Not more than 50%5> 210","7B - 6000 to 6999","Not more than 50%",5,"> 210",65]
[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,"7B - 6000 to 6999More than 50%3≤ 50","7B - 6000 to 6999","More than 50%",3,"≤ 50",220]
[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,"7B - 6000 to 6999More than 50%351 to 75","7B - 6000 to 6999","More than 50%",3,"51 to 75",193]
[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,"7B - 6000 to 6999More than 50%376 to 120","7B - 6000 to 6999","More than 50%",3,"76 to 120",158]
[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,"7B - 6000 to 6999More than 50%3121 to 165","7B - 6000 to 6999","More than 50%",3,"121 to 165",138]
[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,"7B - 6000 to 6999More than 50%3166 to 210","7B - 6000 to 6999","More than 50%",3,"166 to 210",125]
[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,"7B - 6000 to 6999More than 50%3> 210","7B - 6000 to 6999","More than 50%",3,"> 210",120]
[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,"7B - 6000 to 6999More than 50%4≤ 50","7B - 6000 to 6999","More than 50%",4,"≤ 50",170]
[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,"7B - 6000 to 6999More than 50%451 to 75","7B - 6000 to 6999","More than 50%",4,"51 to 75",153]
[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,"7B - 6000 to 6999More than 50%476 to 120","7B - 6000 to 6999","More than 50%",4,"76 to 120",123]
[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,"7B - 6000 to 6999More than 50%4121 to 165","7B - 6000 to 6999","More than 50%",4,"121 to 165",103]
[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,"7B - 6000 to 6999More than 50%4166 to 210","7B - 6000 to 6999","More than 50%",4,"166 to 210",93]
[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,"7B - 6000 to 6999More than 50%4> 210","7B - 6000 to 6999","More than 50%",4,"> 210",90]
[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,"7B - 6000 to 6999More than 50%5≤ 50","7B - 6000 to 6999","More than 50%",5,"≤ 50",140]
[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,"7B - 6000 to 6999More than 50%551 to 75","7B - 6000 to 6999","More than 50%",5,"51 to 75",123]
[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,"7B - 6000 to 6999More than 50%576 to 120","7B - 6000 to 6999","More than 50%",5,"76 to 120",98]
[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,"7B - 6000 to 6999More than 50%5121 to 165","7B - 6000 to 6999","More than 50%",5,"121 to 165",80]
[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,"7B - 6000 to 6999More than 50%5166 to 210","7B - 6000 to 6999","More than 50%",5,"166 to 210",73]
[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,"7B - 6000 to 6999More than 50%5> 210","7B - 6000 to 6999","More than 50%",5,"> 210",70]
[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,"8 - More than 6999Not more than 50%3≤ 50","8 - More than 6999","Not more than 50%",3,"≤ 50",200]
[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,"8 - More than 6999Not more than 50%351 to 75","8 - More than 6999","Not more than 50%",3,"51 to 75",180]
[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,"8 - More than 6999Not more than 50%376 to 120","8 - More than 6999","Not more than 50%",3,"76 to 120",155]
[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,"8 - More than 6999Not more than 50%3121 to 165","8 - More than 6999","Not more than 50%",3,"121 to 165",143]
[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,"8 - More than 6999Not more than 50%3166 to 210","8 - More than 6999","Not more than 50%",3,"166 to 210",133]
[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,"8 - More than 6999Not more than 50%3> 210","8 - More than 6999","Not more than 50%",3,"> 210",130]
[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,"8 - More than 6999Not more than 50%4≤ 50","8 - More than 6999","Not more than 50%",4,"≤ 50",150]
[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,"8 - More than 6999Not more than 50%451 to 75","8 - More than 6999","Not more than 50%",4,"51 to 75",140]
[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,"8 - More than 6999Not more than 50%476 to 120","8 - More than 6999","Not more than 50%",4,"76 to 120",120]
[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,"8 - More than 6999Not more than 50%4121 to 165","8 - More than 6999","Not more than 50%",4,"121 to 165",108]
[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,"8 - More than 6999Not more than 50%4166 to 210","8 - More than 6999","Not more than 50%",4,"166 to 210",100]
[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,"8 - More than 6999Not more than 50%4> 210","8 - More than 6999","Not more than 50%",4,"> 210",100]
[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,{"$f":"AB201 & AC201 & AD201 & AE201","v":"8 - More than 6999Not more than 50%5≤ 50"},"8 - More than 6999","Not more than 50%",5,"≤ 50",115]
[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,"8 - More than 6999Not more than 50%551 to 75","8 - More than 6999","Not more than 50%",5,"51 to 75",105]
[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,"8 - More than 6999Not more than 50%576 to 120","8 - More than 6999","Not more than 50%",5,"76 to 120",90]
[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,"8 - More than 6999Not more than 50%5121 to 165","8 - More than 6999","Not more than 50%",5,"121 to 165",80]
[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,"8 - More than 6999Not more than 50%5166 to 210","8 - More than 6999","Not more than 50%",5,"166 to 210",75]
[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,"8 - More than 6999Not more than 50%5> 210","8 - More than 6999","Not more than 50%",5,"> 210",75]
[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,"8 - More than 6999More than 50%3≤ 50","8 - More than 6999","More than 50%",3,"≤ 50",235]
[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,"8 - More than 6999More than 50%351 to 75","8 - More than 6999","More than 50%",3,"51 to 75",208]
[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,"8 - More than 6999More than 50%376 to 120","8 - More than 6999","More than 50%",3,"76 to 120",173]
[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,"8 - More than 6999More than 50%3121 to 165","8 - More than 6999","More than 50%",3,"121 to 165",153]
[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,"8 - More than 6999More than 50%3166 to 210","8 - More than 6999","More than 50%",3,"166 to 210",140]
[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,"8 - More than 6999More than 50%3> 210","8 - More than 6999","More than 50%",3,"> 210",135]
[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,"8 - More than 6999More than 50%4≤ 50","8 - More than 6999","More than 50%",4,"≤ 50",185]
[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,"8 - More than 6999More than 50%451 to 75","8 - More than 6999","More than 50%",4,"51 to 75",168]
[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,"8 - More than 6999More than 50%476 to 120","8 - More than 6999","More than 50%",4,"76 to 120",138]
[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,"8 - More than 6999More than 50%4121 to 165","8 - More than 6999","More than 50%",4,"121 to 165",118]
[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,"8 - More than 6999More than 50%4166 to 210","8 - More than 6999","More than 50%",4,"166 to 210",108]
[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,"8 - More than 6999More than 50%4> 210","8 - More than 6999","More than 50%",4,"> 210",105]
[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,"8 - More than 6999More than 50%5≤ 50","8 - More than 6999","More than 50%",5,"≤ 50",150]
[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,"8 - More than 6999More than 50%551 to 75","8 - More than 6999","More than 50%",5,"51 to 75",133]
[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,"8 - More than 6999More than 50%576 to 120","8 - More than 6999","More than 50%",5,"76 to 120",108]
[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,"8 - More than 6999More than 50%5121 to 165","8 - More than 6999","More than 50%",5,"121 to 165",90]
[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,"8 - More than 6999More than 50%5166 to 210","8 - More than 6999","More than 50%",5,"166 to 210",83]
[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,"8 - More than 6999More than 50%5> 210","8 - More than 6999","More than 50%",5,"> 210",80]