{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Version Log","Checklist Instructions","Pre Permit Checklist","Mid Construction Checklist","As-Built Checklist","GHG Calculator FAQ","GHG Calculator Checklist"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"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":"Version Log","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[4,1,4,4],[6,1,6,4]]}
[]
[null,"New Homes Checklists for Residential 1-3 Storey Projects"]
[null,"Version Updates and Change Log"]
[]
[null,"This tab is to track changes made in new checklist versions and which checklists are no longer accepted\n"]
[null,"Version #","Date implemented","Description of Changes","Acceptable for Submission?"]
[null,"New Home Energy Checklists (Pre Permit, Mid Construction)"]
[null,"Older - Word Files","2007 to 2018","The original checklists, now out of date","No"]
[null,"1.1.5","March 2018","Major Update\nSwitched to Excel-based\nCombined Pre permit and pre-drywall checklists into one document","No"]
[null,"1.2.0","April 2018","Formatting fixes","2020 applications and earlier"]
[null,"1.2.1","November 2018","Formatting fixes, changed to 'mid construction checklist'","2020 applications and earlier",null,null," "]
[null,"1.2.2","May 2019","Major Update\nChecklists can be used for all 1-3 storey residential buildings","2020 applications and earlier"]
[null,"1.2.3","June 2019","Formatting fixes","2020 applications and earlier"]
[null,"1.2.4.","October 2019","Formatting fixes","2020 applications and earlier"]
[null,2.1,"January 2021","Major Update\nCombined energy checklists and GHG calculator into one document \nAdded version log\nAll forms: updated formatting / theme to grey & white color scheme\nPre-permit checklist: Added checkboxes for CHBA Net Zero, ILFI, Passive House. \nLanguage alignment with BC Step Code Pre-construction checklist\nMid Construction Checklist: major revisions in alignment with BC Step Code checklist\nFinal (as-built) Checklist: created new checklist for pre-occupancy inspection\nGHG Calculator: GHG limit is 2 tonnes / year starting January 2021","Use version 2.2 or later for submissions after January 1st 2021",null,null,null,null," "]
[null,2.2000000000000002,"January 2021","GHG Calculator: 2 tonne limit implementation starts June 1st 2021\nMinor formatting fixes"," Applications in 2021"]
[null,2.2999999999999998,"September 2021","Minor functionality fixes\nComments added back to GHG calculator (missing in previous version)"," Applications in 2021"]
[null,2.4,"January 2022","Major Update\nVBBL 2022 energy updates for 1-3 storey residential go into effect for building permits submitted after January 1st 2022\n- All checklists have a 'Energy Pathway' to select 1 of 3 pathway options. The checklist updates based on this selection\n- for performance path projects, the pre-permit checklist added a MEUI, TEDI and GHGI table with formulas to calculate compliance\n- mid construction and final checklists have automatic formulas to update the requirement list based on selected energy pathway\n","Applications after January 1st 2022"]
[null,2.5,"January 2022","- Added GHGI calculator in Pre Permit Checklist\n- Added 'Fireplace' row in As-built checklist\n- Large Home GHG - home size threshold is based only on HOT2000 modelled floor area (not architect floor area) ","Applications after January 1st 2022"]
[null,"2.5.1","March 2023","Terminology change:\n\"Project Area-weighted average\" to \"Building (or portion of) area-weighted average\" ","Applications after January 1st 2022"]
[null,2.6,"May 2023","- Removed area-weighted average calculator for TEDI, TEUI, GHGI\n- Added checkbox to allow modelling with COV Energy Modelling Guidelines and hourly modelling software, if certain projects require it\n- Added \"Other\" airtightness option to account for other 'beyond code' targets, e.g. Passive House, Net Zero\n- Removed the \"Submissions Requirements\" tab ( replaced by Energy Modelling Guidelines and Airtightness Bulletin)\n- Removed 'VBBL summary' tab. Please see the Builder's Guide for a summary of current energy requirements \n- Added: large Home GHG calculator is exempt for Net Zero projects\n","Applications January 1st 2022 to February 28th 2025"]
[null,3,"March 1st 2025","Major Update\n- alignment with Zero Carbon Step Code (EL-4) metrics\n","Applications after March 1st 2025"]

{"sheet":"Checklist Instructions","index":1,"n_rows":75,"n_cols":40,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,0,0,33],[60,2,63,31],[53,9,53,21],[49,2,51,31],[55,2,58,31],[2,1,4,33],[16,1,16,32],[21,1,21,32],[23,1,23,9],[29,1,29,32],[31,1,31,32],[33,1,33,9],[74,1,76,32],[39,1,39,32],[10,1,10,32],[13,1,13,32],[19,1,19,4],[20,1,20,4],[43,1,43,9],[65,1,65,32],[68,1,68,32],[72,1,72,9]]}
["New Homes - Energy Checklists"]
[]
[null,"These checklists are for use by Energy Advisors (or other accepted professionals) to verify that the energy efficiency measures indicated in the home design are compliant with the Vancouver Building By-law requirements in Part 10. \n\nThe requirements and checklists apply to single family homes, laneway homes, townhouses, rowhouses, duplexes and Multi Family Residential buildings up to 3 storeys and under 600m2. The Energy Advisor must be certified through an NRCan-recognized Service Organization. The Energy Advisor must complete the work on-site, or at least be present on-site when work is being completed. Some projects may be out of scope for an Energy Advisor. In this case, a qualified professional must complete the forms, and complete the associated testing and on-site verification as required. \n\n - Building permit applications before January 1st 2022 - version 2.3\n - Building permit applications January 1st 2022 to February 28th 2025 - version 2.6  \n - Building permit applications after March 1st 2025 - version 3.0 or later  \n\nThe checklist versions are located on the 1-3 storey webpage (link below). Checklists do not need to be updated to the most recent version, should there be a delay between submission and review.\n\n If you have any questions regarding the information requested on this form:\n\n"]
[]
[]
[null,null,null,"- Visit the ",null,null,"Energy for 1-3 storey residential buildings page on the City of Vancouver website"]
[null,null,null,"- Review the Builder's Guide to VBBL 2022 Updates - located on above page"]
[null,null,null,"- Refer to the latest VBBL, found here for free",null,null,null,null,null,null,null,null,null,null,null,"https://www.bcpublications.ca/BCPublications/ "]
[null,null,null,"- or call the Enquiry Centre at 604-873-7611"]
[]
[null,"1.0 ENERGY MODELLING GUIDELINES"]
[]
[null,"All projects must complete an energy model, typically a HOT2000 model"]
[null,"Projects that select the performance path (based on the Zero Carbon Step Code) must use the model to demonstrate compliance with TEDI, MEUI and GHG / GHGI metrics"]
[null,"The 1-3 Storey Residential Modelling Guidelines can be found on the energy webpage (link above)"]
[]
[null,"1.0 PRE PERMIT CHECKLIST"]
[]
[null,"LEGEND"]
[null,null,null,null,null,"To be filled out"]
[null,null,null,null,null,"Excel Calculation"]
[null,"The pre-permit checklist (PPC) is filled out by an Energy Advisor (or equivalent) to verify the modelling requirements and prescriptive elements (i.e. envelope, fenestration and mechanical systems) in a given project. The checklist is submitted for all new 1-3 storey residential Building Permit (BP) applications to verify compliance. "]
[]
[null,"Submission Requirements"]
[]
[null,"A completed pre-permit checklist is to be submitted to City intake staff in order to obtain a building permit."]
[null,"A P-file (or equivalent approved energy model such as PHPP) must  be created and submitted to your Service Organization"]
[null,"For MURBs - use ERS version 15 or later to model either the MURB unit by unit or whole building"]
[]
[null,"2.0 MID CONSTRUCTION CHECKLIST"]
[]
[null,"The mid-construction checklist is completed on-site for insulation or sheathing inspection. It is to ensure that all the stated components listed in the building plans and the pre-permit checklist, unless otherwised changed, have been installed as indicated in the plans. A blower door test must be completed in the home meeting the specified air change target."]
[]
[null,"Submission Requirements"]
[]
[null,"The completed mid-construction checklist is to be submitted to the City building official at sheathing / insulation inspection."]
[null,"A completed blower-door test demonstrating compliance with the final air-tightness target"]
[null,"Airtightness guidance is provided in the following bulletin: ",null,null,null,null,null,null,null,null,null,null,null,null,null,"City of Vancouver Airtightness Bulletin"]
[]
[null,"3.0 FINAL OCCUPANCY / AS-BUILT CHECKLIST"]
[]
[null,"To obtain the occupancy permit, a final EnerGuide (N-file) assessment of the home must be completed, or equivalent accepted model. "]
[]
[null,"Submission Requirements"]
[]
[null,"Complete and submit an N-file to your Service Organization"]
[null,"The completed final checklist is to be submitted, along with supporting documents, to the City building official at final inspection"]
[null,"A final blower door test with compliant result, and a Homeowner Information Sheet (HOIS) attached"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.0 LARGE HOME GREENHOUSE GAS (GHG) CALCULATOR CHECKLIST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Single Family homes with a primary dwelling floor area ≥325 m2 applying for a Building Permit after March 1st 2018 must be designed "]
[null,"such that the annual greenhouse gas emissions are less than 3 tonnes / year (reduced to 2 tonnes per year for applications after June 1st 2021). This includes the main dwelling, as well as all supplemental buildings and services on site. "]
[]
[null,"Modelling Guidelines for Large Homes:",null,null,null,null,null,null,null,null,null,null,"https://vancouver.ca/files/cov/modelling-guidelines-large-homes.pdf "]
[]
[null,"Submission Requirements"]
[]
[null,"In version 3.0 and later, the Large Home GHG Calculator has been incorporated into the Pre Permit Checklist.  Completion of the Pre Permit Checklist will confirm compliance with this requirement.  For versions older than 3.0, the GHG checklist is a standalone document that must be submitted with the checklist documents. "]

{"sheet":"Pre Permit Checklist","index":2,"n_rows":318,"n_cols":61,"rows_kept":318,"cut":false,"hidden":false,"merged":[[168,36,168,38],[113,30,114,40],[82,33,83,40],[84,33,85,40],[86,33,87,40],[99,5,99,18],[106,3,106,40],[90,19,91,32],[102,3,102,40],[111,30,111,40],[116,30,116,40],[113,21,114,29],[111,3,111,8],[112,3,112,8],[113,3,113,8],[114,3,114,8],[91,5,91,18],[93,5,93,18],[94,5,94,18],[96,33,97,40],[98,5,98,18],[87,5,87,18],[82,19,83,32],[169,36,169,38],[62,3,62,12],[63,3,65,12],[62,18,62,22],[63,18,63,22],[64,18,64,22],[65,18,65,22],[62,31,62,40],[63,31,65,40],[67,3,67,40],[68,3,68,12],[68,13,68,17],[69,13,69,17],[70,13,70,17],[115,3,115,8],[111,9,111,19],[112,9,112,19],[113,9,113,19],[114,9,114,19],[115,9,116,19],[94,33,95,40],[88,33,89,40],[98,33,99,40],[168,31,168,33],[28,21,28,22],[29,21,29,22],[35,11,35,20],[35,21,35,32],[79,5,79,18],[73,33,73,40],[74,33,75,40],[76,33,77,40],[78,33,79,40],[55,24,57,27],[58,24,59,27],[49,3,49,40],[53,31,54,40],[45,31,45,37],[42,28,44,30],[42,14,44,16],[42,11,44,13],[45,11,45,16],[39,17,40,20],[39,21,40,23],[42,17,44,20],[42,21,44,23],[39,31,41,37],[31,27,32,32],[33,16,34,20],[33,11,34,15],[33,27,34,32],[64,23,64,30],[61,3,61,40],[51,18,52,23],[51,13,52,17],[51,31,52,40],[51,3,52,12],[52,24,52,27],[53,13,54,17],[55,13,57,17],[58,13,59,17],[53,3,53,12],[55,3,55,12],[58,3,58,12],[54,3,54,12],[59,3,59,12],[56,3,56,12],[53,24,54,27],[1,3,3,6],[1,38,1,40],[2,38,2,40],[3,38,3,40],[1,7,3,37],[4,3,4,40],[5,3,5,40],[19,4,19,12],[21,13,21,17],[19,22,19,25],[20,22,20,25],[21,22,21,25],[19,26,19,29],[20,26,20,29],[21,26,21,29],[7,15,7,25],[8,15,8,25],[11,15,11,25],[12,15,12,25],[20,30,20,34],[9,15,9,25],[20,4,20,12],[10,15,10,25],[17,26,18,29],[286,12,286,15],[287,12,287,14],[152,11,152,15],[76,19,77,32],[78,19,79,32],[80,19,81,32],[46,11,46,16],[85,5,85,18],[82,5,82,18],[84,5,84,18],[81,5,81,18],[89,5,89,18],[96,19,97,32],[98,19,99,32],[83,5,83,18],[94,19,95,32],[86,5,86,18],[88,5,88,18],[88,19,89,24],[88,25,89,32],[86,19,87,32],[92,5,92,18],[169,31,169,33],[65,23,65,30],[291,12,291,15],[53,18,54,23],[55,18,57,23],[58,18,59,23],[96,5,96,18],[97,5,97,18],[84,19,85,32],[73,19,73,32],[80,5,80,18],[92,19,93,32],[95,5,95,18],[90,5,90,18],[73,5,73,18],[62,13,62,17],[76,5,76,18],[77,5,77,18],[78,5,78,18],[74,5,74,18],[75,5,75,18],[290,12,290,15],[103,3,104,40],[63,13,63,17],[72,3,72,40],[96,3,99,4],[19,30,19,34],[90,3,95,4],[73,3,73,4],[69,3,69,12],[70,3,70,12],[50,3,50,40],[52,28,52,30],[53,28,54,30],[55,28,57,30],[58,28,59,30],[51,24,51,30],[64,13,64,17],[65,13,65,17],[62,23,62,30],[63,23,63,30],[90,33,91,40],[92,33,93,40],[74,3,89,4],[74,19,75,32],[55,31,57,40],[58,31,59,40],[80,33,81,40],[31,16,32,20],[31,11,32,15],[41,11,41,16],[22,4,22,12],[23,4,23,12],[21,18,21,21],[22,18,22,21],[23,18,23,21],[17,22,18,25],[17,30,17,39],[18,30,18,39],[27,11,27,22],[23,13,23,17],[17,18,18,21],[19,18,19,21],[20,18,20,21],[23,26,23,29],[22,13,22,17],[22,22,22,25],[23,22,23,25],[22,26,22,29],[25,3,25,40],[18,4,18,12],[17,13,18,17],[19,13,19,17],[20,13,20,17],[112,30,112,40],[15,3,15,40],[21,4,21,12],[38,17,38,30],[45,17,45,30],[42,24,44,27],[38,11,38,16],[38,31,38,37],[21,30,21,34],[22,30,22,34],[23,30,23,34],[19,35,19,39],[20,35,20,39],[21,35,21,39],[22,35,22,39],[23,35,23,39],[31,21,32,26],[33,21,34,26],[39,11,40,13],[39,14,40,16],[39,24,40,27],[39,28,40,30],[41,24,41,30],[41,17,41,23]]}
[]
[null,null,null,null,null,null,null,"PRE-PERMIT ENERGY CHECKLIST \nfor 1-3 Storey Residential Buildings and Houses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,"Mar 1 2025"]
[null,null,null,"This form is to confirm the Vancouver Building Bylaw energy requirements for new 1-3 storey residential buildings with permit applications after Jan 1st 2022. This form is to be completed, signed and submitted for Building Permit by a certified energy advisor. One form can represent multiple buildings with matching specifications. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null," ",null,"1. Project Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"->",null,null,"Project Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy modelling standard"]
[null,null,null,null,"Unit & Model type (dropdown)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,"->",null,null,"Total Primary Dwelling Units (#)"]
[null,null,null,null,"Total Secondary Suites (#)"]
[null,"->",null,null,"Energy modelling software & version: "]
[null,null,null,null,"VBBL Energy Compliance Path (dropdown)"]
[]
[]
[null," ",null,"2. Energy Modelling Data Entry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,"P File #",null,null,null,null," Heated \nFloor Area (m2)",null,null,null," Electricity Use - GJ\n(GJ/a)",null,null,null," Natural Gas Use - GJ\n(GJ/a)",null,null,null,"                  Project (Modelled)\n            MEUI                      TEDI\n"]
[null,"->",null,null,"Unit Address(es)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(kWh/m2/year)"]
[]
[]
[]
[]
[]
[]
[null,null,null,"2.  Modelling Compliance Summary (auto-filled from checklist inputs)"]
[null,null,null,null,null,null,null,null,null,null,null,"LARGE HOME GHG CALCULATOR (detached homes >325m2)"]
[null,"->",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(P9=E143,P9=E144),OR(S20>325,S21>325,S22>325,S23>325,S24>325)),E176,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,"Total site GHG's (from calculator tab)",null,null,null,null,null,null,null,null,null,{"$f":"'GHG Calculator Checklist'!H70","v":0}]
[null,"->",null,null,null,null,null,null,null,null,null,"Window-to-wall ratio > 30%?",null,null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,"AGGREGATED ENERGY TARGETS - only if performance path is selected"]
[null,null,null,null,null,null,null,null,null,null,null,"Modelled MEUI\n(kWh/m2/year)",null,null,null,null,"Required MEUI\n(kWh/m2/year)",null,null,null,null,"Modelled TEDI\n(kWh/m2/year)",null,null,null,null,null,"Required TEDI\n(kWh/m2/year)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P13=E178,\"N/A\",ROUND((AE20*S20+AE21*S21+AE22*S22+S23*AE23+S24*AE24)/SUM(S20:V24),0))","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF(P13=E178,\"N/A\",AY200)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF(P13=E178,\"N/A\",ROUND((AJ20*S20+AJ21*S21+AJ22*S22+AJ23*S23+AJ24*S24)/SUM(S20:V24),0))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,20]
[]
[null,null,null,null,null,null,null,null,null,null,"Compliance ",{"$f":"IF(P13=E178,\"N/A\",IF(L34<=Q34,\"Yes\",\"No\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(P13=E178,\"N/A\",IF(V34<=AB34,\"Yes\",\"No\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,"  (all must be green - Yes or N/A)"]
[null,null,null,null,null,null,null,null,null,null,null,"ZERO CARBON STEP CODE - All Projects - only 1 path must comply"]
[null,null,null,null,null,null,null,null,null,null,null,"PATH 1",null,null,null,null,null,"PATH 2",null,null,null,null,null,null,null,null,null,null,null,null,null,"PATH 3"]
[null,null,null,null,null,null,null,null,null,null,null,"\nModelled GHG",null,null,"\nRequired GHG",null,null,"\nModelled\n GHG",null,null,null,"\nRequired GHG",null,null,"\nModelled GHGI",null,null,null,"\nRequired GHGI",null,null,"All Building Energy Systems are Electricity"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"(kgCO2e/yr)",null,null,null,null,null,"(kgCO2e/yr)",null,null,null,null,null,null,"(kgCO2e/m2 * yr)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ170:AQ174)/SUM(S20:V24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(P10)*265","v":0},null,null,{"$f":"L43","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"(P10)*500","v":0},null,null,{"$f":"R43/SUM(S20:V24)","v":{"$error":"#DIV/0!"}},null,null,null,1.5,null,null,{"$f":"IF(OR(N54=\"gas\",N56=\"Gas\",N59=\"gas\"),\"N\",\"Y\")","v":"Y"},"Heating & Hot Water"]
[null,null,null,null,null,null,null,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":"IF(AND(N70=0,N71=0),\"Y\",\"N\")","v":"Y"},"Cooking & Laundry"]
[null,null,null,null,null,null,null,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":"IF(S64=0,\"Y\",\"N\")","v":"Y"},"Fireplaces"]
[null,null,null,null,null,null,null,null,null,null,"Path Compliance ",{"$f":"IF(O43>=L43,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"IF(AND(V43>=R43,AC43>=Y43),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AF43=\"N\",AF44=\"N\",AF45=\"N\"),\"No\",\"Yes\")","v":"Yes"}]
[null,null,null,null,null,null,null,null,null,null,"Overall ZCSC Compliance ",{"$f":"IF(OR(L46=\"Yes\",R46=\"Yes\",AF46=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"(one path must comply)"]
[]
[null,null,null,"page 1 of 3"]
[null,null,null,"3. Primary Mechanical Systems"]
[null,null,null,"System Requirement",null,null,null,null,null,null,null,null,null,"Fuel Type\n(dropdown)",null,null,null,null,"System Type\n(dropdown)",null,null,null,null,null,"Efficiency Rating ",null,null,null,null,null,null,"Details"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metric",null,null,null,"Value"]
[null,null,null,"Principal Heating / Cooling"]
[null,"->",null,{"$f":"IF(P13=E178,R207,IF(P13=E179,R241,R275))","v":"Electric or gas (minimum 92% AFUE)"}]
[null,null,null,"Secondary (Backup) Heating ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(P13=E178,R207,IF(P13=E179,R241,R275))","v":"Electric or gas (minimum 92% AFUE)"}]
[null,null,null,"**if gas, model as the primary system"]
[null,null,null,"Domestic hot water"]
[null,null,null,{"$f":"IF(P13=E178,R211,R245)","v":"Electric or Gas UEF ≥ 0.78"}]
[]
[null,null,null,"4. Fireplaces"]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,"Fuel Type",null,null,null,null,"# Total Fireplace Units",null,null,null,null,"Combined BTU input\n(gas - under 60,000 BTU)",null,null,null,null,null,null,null,"Details"]
[null,null,null,"Interior Fireplaces",null,null,null,null,null,null,null,null,null,"Natural Gas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,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. Secondary Equipment & Appliances (related to ZCSC EL-4 - Path 3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"# Total Units"]
[null,null,null,"Gas Clothes Dryers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Gas Stoves "]
[]
[null,null,null,"6. Building Envelope & Other Characteristics"]
[null,"->",null,null,null,"System Requirement",null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Specification\n(assembly, system, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"R/USI or\nEfficiency "]
[null," ",null,"Insulation and Air Barrier",null,"1.1 Exterior above-grade walls & floor headers"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R251,IF($P$13=$E$179,R217,R183))","v":"Minimum R22 effective (RSI 3.85)"}]
[null,null,null,null,null,"1.2 Below-grade walls"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R253,IF($P$13=$E$179,R219,R185))","v":"Minimum R22 effective (RSI 3.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,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"1.3 Flat attic"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R255,IF($P$13=$E$179,R221,R187))","v":"Minimum R48 effective (RSI 8.5)"}]
[null,"->",null,null,null,"1.4 Flat, vaulted and cathedral roofs"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R257,IF($P$13=$E$179,R223,R189))","v":"Deck area > 10m2 = R40 effective (RSI 7.0); \nDeck area < 10m2 = R24 effective (RSI 4.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,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"1.5 Under foundation slab "]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R259,IF($P$13=$E$179,R225,R191))","v":"Minimum R14 effective (RSI 2.5)"}]
[null,null,null,null,null,"1.6 Exposed floors"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R261,IF($P$13=$E$179,R227,R193))","v":"Minimum R24 effective (RSI 4.2)"}]
[null,null,null,null,null,"1.7 Balconies, eyebrows, and exposed slab edge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF($P$13=$E$180,R263,IF($P$13=$E$179,R229,R195))","v":"Thermal break meets R2.4 effective (RSI 0.42)"}]
[null,null,null,null,null,"1.8 Air barrier ",null,null,null,null,null,null,null,null,null,null,null,null,null,"*select primary air barrier*",null,null,null,null,null,"*select air tightness requirement*"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R265,IF($P$13=$E$179,R231,R197))","v":"Continuous air barrier design"}]
[null,"->",null,"Fenestration",null,"2.1 Side-hinged doors"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R267,IF($P$13=$E$179,R233,R199))","v":"Aside from front entry door, USI 1.80 or lower"}]
[null,null,null,null,null,"2.2 Windows, curtainwalls and glazed doors"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R269,IF($P$13=$E$179,R235,R201))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"2.3 Skylights and roof hatches   "]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R271,IF($P$13=$E$179,R237,R203))","v":"Skylights USI 2.4 or lower. Roof hatches USI 2.9 or lower"}]
[null,null,null,"Add'l",null,"Ventilation "]
[null,null,null,null,null,{"$f":"IF(P13=E178,R205,R239)","v":"HRV - 65% SRE @ 0 deg C (on continuous mode or better)"}]
[null,null,null,null,null,"Hot Water Recirculating system"]
[null,null,null,null,null,{"$f":"IF($P$13=$E$180,R281,IF($P$13=$E$179,R247,R213))","v":"Piping wrapped with pipe insulation R2 (RSI 0.35)"}]
[null,null,null,"page 2 of 3"]
[]
[null,null,null,"5. Additional Notes"]
[]
[]
[]
[null,null,null,"6. Contact Information & Authorization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"As the Energy Advisor (or qualified energy modeller) assigned to this project, by signing I certify that:"]
[null,null,null,null,null,"• This checklist was completed based on information provided by the builder and the most recent prepared drawings ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"• (for Energuide-based projects) the P-file will be submitted to your Service Organization for submission to NRCan"]
[]
[null,null,null,"EA name and EA #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Builder company & contact"]
[null,null,null,"Email address: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  NRCan Builder #: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Phone:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Builder Signature:"]
[null,null,null,"Business License #:"]
[null,null,null,"Signature"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Date:"]
[null,null,null,"Visit www.vancouver.ca/homeenergy for the latest version of this form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"page 3 of 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Tables hidden below  ò"]
[null,null,null,null,"Laneway House"]
[null,null,null,null,"Single Detached"]
[null,null,null,null,"Single Detached w/Secondary Suite"]
[null,null,null,null,"Double/Semi-detached (non-MURB)",null,null,null,null,null,null,null,null,null,null,"Heating",null,null,"DHW",null,null,"Gas"]
[null,null,null,null,"Row House (non-MURB)",null,null,null,null,null,null,null,null,null,null,"AFUE",null,null,"% Eff",null,null,"Wood"]
[null,null,null,null,"Multi-plex (non-MURB)",null,null,null,null,null,null,null,null,null,null,"HSPF",null,null,"AFUE",null,null,"Electric"]
[null,null,null,null,"Low-Rise MURB",null,null,null,null,null,null,null,null,null,null,"SSE",null,null,"UEF",null,null,"Other"]
[null,null,null,null,"Stacked Duplex (MURB)",null,null,null,null,null,null,null,null,null,null,"COP",null,null,"EF"]
[null,null,null,null,"Triplex (MURB)",null,null,null,null,null,null,null,null,null,null,"EER",null,null,"EER"]
[null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,"-",null,null,"-"]
[]
[]
[null,null,null,null,null,null,"-"]
[null,null,null,null,"X",null,"Yes "]
[null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,"*select primary air barrier*",null,null,null,null,null,null,null,null,"*select air tightness requirement*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,"Needs revision",null,null,null,null,null,null,null,null,null,null,"Interior - polyethylene",null,null,null,null,null,null,null,null,"2.5 ACH @50Pa"]
[null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,"Interior - airtight drywall",null,null,null,null,null,null,null,null,"1.20 NLA @10Pa (cm2/m2)"]
[null,null,null,null,"Passive House project",null,null,null,null,null,null,null,null,null,null,"Exterior - sealed membrane",null,null,null,null,null,null,null,null,"0.89 NLR @50Pa (L/s*m2)"]
[null,null,null,null,"-",0,null,null,null,null,null,null,null,null,null,"Exterior - taped sheathing",null,null,null,null,null,null,null,null,"Other - specify ->"]
[null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,"Exterior - sealed insulation"]
[null,null,null,null,2,2,null,null,null,null,null,null,null,null,null,"Other (indicate in \"Additional Notes\")"]
[null,null,null,null,3,3,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,4,4]
[null,null,null,null,5,5]
[null,null,null,null,6,6,null,null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,7,7,null,null,null,null,null,null,null,null,null,"Y",null,null,null,null,null,null,null,null,"Emissions Factors ",null,null,null,null,null,null,null,"(kgCO2e/GJ)",null,null,null,null,"(kgCO2e/kWh)",null,null,null,"GHG calculations"]
[null,null,null,null,8,8,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,null,null,"Electricity",null,null,null,null,null,null,3.06,null,null,null,null,1.0999999999999999E-2,null,null,null,null,"GHG","GHG * m2"]
[null,null,null,null,9,9,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,"Natural Gas",null,null,null,null,null,null,51.4,null,null,null,null,0.185,null,null,null,null,{"$f":"W20*$AF$169+AA20*$AF$170","v":0},{"$f":"AP170*S20","v":0}]
[null,null,null,null,10,10,null,null,null,null,null,null,null,null,null,null,null,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":"W21*$AF$169+AA21*$AF$170","v":0},{"$f":"AP171*S21","v":0}]
[null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,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":"W22*$AF$169+AA22*$AF$170","v":0},{"$f":"AP172*S22","v":0}]
[null,null,null,null,"Y",null,null,null,null,null,null,null,null,null,null,null,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":"W23*$AF$169+AA23*$AF$170","v":0},{"$f":"AP173*S23","v":0}]
[null,null,null,null,"N",null,null,null,null,null,null,null,null,null,null,null,null,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":"W24*$AF$169+AA24*$AF$170","v":0},{"$f":"AP174*S24","v":0}]
[]
[null,null,null,null,"GHG Limit calculator required"]
[]
[null,null,null,null,"Option #1: Prescriptive Path"]
[null,null,null,null,"Option #2: Performance Path"]
[null,null,null,null,"Option #3: Passive House Path"]
[]
[null,null,null,null,"REQUIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,"PRESCRIPTIVE PATH",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor area conditioned space (m2)"]
[null,null,null,null,"1.1 Exterior above-grade walls & floor headers",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 effective (RSI 3.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,null,"MECHANICAL COOLING","Step","<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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 50% conditioned space",4,90,80,60,48,40,40]
[null,null,null,null,"1.2 Below-grade walls",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 effective (RSI 3.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,null,"> 50% conditioned space",4,125,108,78,58,48,45]
[]
[null,null,null,null,"1.3 Flat attic",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R48 effective (RSI 8.5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,80,60,48,40,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,90,80,60,48,40,40]
[null,null,null,null,"1.4 Flat, vaulted and cathedral roofs",null,null,null,null,null,null,null,null,null,null,null,null,"Deck area > 10m2 = R40 effective (RSI 7.0); \nDeck area < 10m2 = R24 effective (RSI 4.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,null,null,null,90,80,60,48,40,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,80,60,48,40,40]
[null,null,null,null,"1.5 Under foundation slab ",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R14 effective (RSI 2.5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,80,60,48,40,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"1.6 Exposed floors",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R24 effective (RSI 4.2)",null,null,null,null,null,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":"IF(S20<=50,AV187,0)","v":90},{"$f":"IF(AND(S20>50,S20<=75),AW187,0)","v":0},{"$f":"IF(AND(S20>75,S20<=120),AX187,0)","v":0},{"$f":"IF(AND(S20>120,S20<=165),AY187,0)","v":0},{"$f":"IF(AND(S20>165,S20<=210),AZ187,0)","v":0},{"$f":"IF(S20>210,BA187,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(S21<=50,AV188,0)","v":90},{"$f":"IF(AND(S21>50,S21<=75),AW188,0)","v":0},{"$f":"IF(AND(S21>75,S21<=120),AX188,0)","v":0},{"$f":"IF(AND(S21>120,S21<=165),AY188,0)","v":0},{"$f":"IF(AND(S21>165,S21<=210),AZ188,0)","v":0},{"$f":"IF(S21>210,BA188,0)","v":0}]
[null,null,null,null,"1.7 Balconies, eyebrows, and exposed slab edge",null,null,null,null,null,null,null,null,null,null,null,null,"Thermal break meets R2.4 effective (RSI 0.42)",null,null,null,null,null,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":"IF(S22<=50,AV189,0)","v":90},{"$f":"IF(AND(S22>50,S22<=75),AW189,0)","v":0},{"$f":"IF(AND(S22>75,S22<=120),AX189,0)","v":0},{"$f":"IF(AND(S22>120,S22<=165),AY189,0)","v":0},{"$f":"IF(AND(S22>165,S22<=210),AZ189,0)","v":0},{"$f":"IF(S22>210,BA189,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(S23<=50,AV190,0)","v":90},{"$f":"IF(AND(S23>50,S23<=75),AW190,0)","v":0},{"$f":"IF(AND(S23>75,S23<=120),AX190,0)","v":0},{"$f":"IF(AND(S23>120,S23<=165),AY190,0)","v":0},{"$f":"IF(AND(S23>165,S23<=210),AZ190,0)","v":0},{"$f":"IF(S23>210,BA190,0)","v":0}]
[null,null,null,null,"1.8 Air barrier ",null,null,null,null,null,null,null,null,null,null,null,null,"Continuous air barrier design",null,null,null,null,null,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":"IF(S24<=50,AV191,0)","v":90},{"$f":"IF(AND(S24>50,S24<=75),AW191,0)","v":0},{"$f":"IF(AND(S24>75,S24<=120),AX191,0)","v":0},{"$f":"IF(AND(S24>120,S24<=165),AY191,0)","v":0},{"$f":"IF(AND(S24>165,S24<=210),AZ191,0)","v":0},{"$f":"IF(S24>210,BA191,0)","v":0}]
[]
[null,null,null,null,"2.1 Side-hinged doors",null,null,null,null,null,null,null,null,null,null,null,null,"Aside from front entry door, USI 1.80 or lower",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Aggregation of MEUI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEUI","Floor area","Aggregated =",{"$f":"(AV201*AW201+AV202*AW202+AV203*AW203+AV204*AW204+AV205*AW205)/SUM(AW201:AW205)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"2.2 Windows, curtainwalls and glazed doors",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(P13=E178, P9=E143,#REF!>325),\"USI 1.22, or USI 1.04 or lower (if WWR > 30%)\",\"USI 1.22 or lower\")","v":{"$error":"#REF!"}},null,null,null,null,null,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":"IF(S20=0,0,SUM(AV193:BA193))","v":0},{"$f":"S20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(S21=0,0,SUM(AV194:BA194))","v":0},{"$f":"S21","v":0}]
[null,null,null,null,"2.3 Skylights and roof hatches   ",null,null,null,null,null,null,null,null,null,null,null,null,"Skylights USI 2.4 or lower. Roof hatches USI 2.9 or lower",null,null,null,null,null,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":"IF(S22=0,0,SUM(AV195:BA195))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(S23=0,0,SUM(AV196:BA196))","v":0},0]
[null,null,null,null,"3.1 Ventilation ",null,null,null,null,null,null,null,null,null,null,null,null,"HRV - 75% SRE @ 0 deg C (on continuous mode or better)",null,null,null,null,null,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":"IF(S24=0,0,SUM(AV197:BA197))","v":0},0]
[]
[null,null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric operated system "]
[]
[null,null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"Direct vent electronic ignition and timer. \nMaximum combined 60,000 BTU allowable limit"]
[]
[null,null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Electric operated system "]
[]
[null,null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]
[]
[]
[null,null,null,null,"REQUIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,"PERFORMANCE PATH"]
[null,null,null,null,"1.1 Exterior above-grade walls & floor headers",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,null,"1.2 Below-grade walls",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)",null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"1.3 Flat attic",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R48 effective (RSI 8.5)"]
[]
[null,null,null,null,"1.4 Flat, vaulted and cathedral roofs",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R24 effective (RSI 4.30) "]
[]
[null,null,null,null,"1.5 Under foundation slab ",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R14 eff. (RSI 2.5)"]
[]
[null,null,null,null,"1.6 Exposed floors",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R24 eff. (RSI 4.2)"]
[]
[null,null,null,null,"1.7 Balconies, eyebrows, and exposed slab edge",null,null,null,null,null,null,null,null,null,null,null,null,"Thermal break meets R2.4 eff. (RSI 0.42)"]
[]
[null,null,null,null,"1.8 Air barrier ",null,null,null,null,null,null,null,null,null,null,null,null,"Continuous air barrier - 2.5 ACH50 (or permitted alternative)"]
[]
[null,null,null,null,"2.1 Side-hinged doors",null,null,null,null,null,null,null,null,null,null,null,null,"Aside from front entry door, USI 1.80 or lower"]
[]
[null,null,null,null,"2.2 Windows, curtainwalls and glazed doors",null,null,null,null,null,null,null,null,null,null,null,null,"USI 1.44 or lower"]
[]
[null,null,null,null,"2.3 Skylights and roof hatches   ",null,null,null,null,null,null,null,null,null,null,null,null,"Skylights USI 2.4 or lower. Roof hatches USI 2.9 or lower"]
[]
[null,null,null,null,"3.1 Ventilation ",null,null,null,null,null,null,null,null,null,null,null,null,"HRV - 65% SRE @ 0 deg C (on continuous mode or better)"]
[]
[null,null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric or gas (minimum 92% AFUE)"]
[]
[null,null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"Direct vent electronic ignition and timer (outdoor: electric or match). "]
[]
[null,null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Electric or Gas UEF ≥ 0.78"]
[]
[null,null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]
[]
[]
[null,null,null,null,"REQUIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,"PASSIVE HOUSE PATH"]
[null,null,null,null,"1.1 Exterior above-grade walls & floor headers",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,null,"1.2 Below-grade walls",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,null,"1.3 Flat attic",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R48 effective (RSI 8.5)"]
[]
[null,null,null,null,"1.4 Flat, vaulted and cathedral roofs",null,null,null,null,null,null,null,null,null,null,null,null,"R30 eff. (RSI 5.28); 1&2 Family + LWH: R24 eff. (RSI 4.3)"]
[]
[null,null,null,null,"1.5 Under foundation slab ",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R14 eff. (RSI 2.5)"]
[]
[null,null,null,null,"1.6 Exposed floors",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R24 eff. (RSI 4.2)"]
[]
[null,null,null,null,"1.7 Balconies, eyebrows, and exposed slab edge",null,null,null,null,null,null,null,null,null,null,null,null,"Thermal break meets R2.4 eff. (RSI 0.42)"]
[]
[null,null,null,null,"1.8 Air barrier ",null,null,null,null,null,null,null,null,null,null,null,null,"Continuous air barrier - 2.5 ACH50 (or permitted alternative)"]
[]
[null,null,null,null,"2.1 Side-hinged doors",null,null,null,null,null,null,null,null,null,null,null,null,"Aside from front entry door, USI 1.84 or lower"]
[]
[null,null,null,null,"2.2 Windows, curtainwalls and glazed doors",null,null,null,null,null,null,null,null,null,null,null,null,"USI 1.44 or lower"]
[]
[null,null,null,null,"2.3 Skylights and roof hatches   ",null,null,null,null,null,null,null,null,null,null,null,null,"Skylights USI 2.4 or lower. Roof hatches USI 2.9 or lower"]
[]
[null,null,null,null,"3.1 Ventilation ",null,null,null,null,null,null,null,null,null,null,null,null,"HRV - 75% SRE @ 0 deg C (on continuous mode or better). 65% for Laneway Homes"]
[]
[null,null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric or gas (minimum 92% AFUE)"]
[]
[null,null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"Direct vent electronic ignition and timer (outdoor: electric or match). \nIndicate total number of fireplaces"]
[]
[null,null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Energy Factor (UEF or EF) ≥ 0.78\n or thermal efficiency (TE) ≥ 90% "]
[]
[null,null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]
[]
[]
[]
[]
[null,null,null,null,"Drop Downs",null,null,"GHG Emission Factor (kgCO2e/GJ) as per CoV Energy Modelling Guidelines v1.0"]
[null,null,null,null,"Choose",0,null,"Electricity",null,null,null,null,{"$f":"M291*277.78","v":3.0555799999999995},null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Electricity",1,null,"Natural Gas",null,null,null,null,{"$f":"M292*277.778","v":51.388930000000002}]
[null,null,null,null,"Natural Gas",2]
[null,null,null,null,null,3,null,"GHG Emission Factor (kgCO2e/kWh) as per CoV Energy Modelling Guidelines v1.0"]
[null,null,null,null,null,4,null,"Electricity",null,null,null,null,{"$f":"0.011","v":1.0999999999999999E-2}]
[null,null,null,null,null,5,null,"Natural Gas",null,null,null,null,{"$f":"0.185","v":0.185}]
[null,null,null,null,null,6]
[null,null,null,null,null,7]
[null,null,null,null,null,8]
[null,null,null,null,null,9]
[null,null,null,null,null,10]
[null,null,null,null,null,11]
[null,null,null,null,null,12,null,null,null,"PRIMARY",null,null,null,null,"SECONDARY",null,null,null,null,null,null,null,null,"DHW"]
[null,null,null,null,null,13,null,null,null,{"$f":"IF(N54=\"Electric\",\"Air-to-water heat pump\",IF(N54=\"Gas\",\"Gas Boiler\",\" \"))","v":" "},null,null,null,null,{"$f":"IF(N56=\"Electric\",\"Air-to-water heat pump\",IF(N56=\"Gas\",\"Gas Boiler\",\" \"))","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(N59=\"Electric\",\"Air-to-water heat pump\",IF(N59=\"Gas\",\"Gas Boiler - Tank\",\" \"))","v":" "}]
[null,null,null,null,null,14,null,null,null,{"$f":"IF(N54=\"Electric\",\"Central air-to-air heat pump\",IF(N54=\"Gas\",\"Gas Furnace\",\" \"))","v":" "},null,null,null,null,{"$f":"IF(N56=\"Electric\",\"Central air-to-air heat pump\",IF(N56=\"Gas\",\"Gas Furnace\",\" \"))","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(N59=\"Electric\",\"Electric Tank\",IF(N59=\"Gas\",\"Gas Boiler - Tankless\",\" \"))","v":" "}]
[null,null,null,null,null,15,null,null,null,{"$f":"IF(N54=\"Electric\",\"Air-to-air ductless minisplit\",IF(N54=\"Gas\",\"Other (provide in details)\",\" \"))","v":" "},null,null,null,null,{"$f":"IF(N56=\"Electric\",\"Air-to-air ductless minisplit\",IF(N56=\"Gas\",\"Other (provide in details)\",\" \"))","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(N59=\"Electric\",\"Other (provide details)\",IF(N59=\"Gas\",\"Other (provide in details)\",\" \"))","v":" "}]
[null,null,null,null,null,16,null,null,null,{"$f":"IF(N54=\"Electric\",\"Geo-exchange heat pump system\",\" \")","v":" "},null,null,null,null,{"$f":"IF(N56=\"Electric\",\"Geo-exchange heat pump system\",\" \")","v":" "}]
[null,null,null,null,null,17,null,null,null,{"$f":"IF(N54=\"Electric\",\"Electric Baseboard\",\" \")","v":" "},null,null,null,null,{"$f":"IF(N56=\"Electric\",\"Electric Baseboard\",\" \")","v":" "}]
[null,null,null,null,null,18,null,null,null,{"$f":"IF(N54=\"Electric\",\"Electric Boiler\",\" \")","v":" "},null,null,null,null,{"$f":"IF(N56=\"Electric\",\"Electric Boiler\",\" \")","v":" "}]
[null,null,null,null,null,19,null,null,null,{"$f":"IF(N54=\"Electric\",\"Other (provide in details)\",\" \")","v":" "},null,null,null,null,{"$f":"IF(N56=\"Electric\",\"Other (provide in details)\",\" \")","v":" "}]
[null,null,null,null,null,20]
[null,null,null,null,null,21]
[null,null,null,null,null,22]
[null,null,null,null,null,23]
[null,null,null,null,null,24,null,null,null,"Gas",null,"Gas",null,"Electric"]
[null,null,null,null,null,25,null,null,null,"Electric",null,"Electric",null,"N/A"]
[null,null,null,null,null,26,null,null,null,"N/A",null,"N/A"]
[null,null,null,null,null,27]
[null,null,null,null,null,28]
[null,null,null,null,null,29,null,null,null,"3 tonnes",false]
[null,null,null,null,null,30,null,null,null,"2 tonnes",false]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K317=TRUE,AND(K316=FALSE,K317=FALSE)),2,3)","v":2},null,null," "]

{"sheet":"Mid Construction Checklist","index":3,"n_rows":254,"n_cols":44,"rows_kept":254,"cut":false,"hidden":false,"merged":[[1,8,3,30],[3,31,3,34],[2,31,2,34],[1,31,1,34],[5,3,5,34],[60,3,60,34],[109,26,109,34],[110,26,110,34],[92,16,93,22],[7,25,7,34],[39,21,41,24],[11,21,12,24],[11,10,12,20],[36,25,38,34],[23,21,25,24],[23,25,25,34],[26,3,26,9],[20,3,20,9],[21,3,22,9],[14,3,14,9],[15,3,16,9],[14,25,16,34],[17,25,19,34],[39,25,41,34],[114,10,114,19],[112,10,113,19],[103,3,103,34],[112,26,113,34],[109,10,109,19],[110,10,110,19],[111,10,111,19],[92,4,93,7],[43,21,45,24],[46,10,48,20],[46,21,48,24],[49,3,49,9],[100,4,101,33],[55,3,57,9],[94,8,94,11],[94,25,95,33],[92,25,92,32],[52,10,54,20],[46,3,46,9],[47,3,48,9],[2,0,4,1],[4,3,4,34],[90,4,90,14],[49,25,51,34],[52,25,54,34],[49,10,51,20],[49,21,51,24],[13,3,13,34],[20,25,22,34],[10,3,10,34],[11,25,12,34],[1,3,3,6],[32,3,32,34],[50,3,51,9],[43,3,43,9],[44,3,45,9],[8,25,8,34],[7,8,7,17],[8,8,8,17],[19,3,19,9],[11,3,12,9],[36,10,38,20],[36,21,38,24],[39,10,41,20],[17,3,18,9],[36,3,36,9],[41,3,41,9],[39,3,40,9],[24,3,25,9],[96,25,97,33],[14,10,16,20],[14,21,16,24],[17,10,19,20],[17,21,19,24],[20,10,22,20],[20,21,22,24],[26,10,28,20],[26,21,28,24],[29,10,31,20],[29,21,31,24],[33,10,35,20],[33,21,35,24],[26,25,28,34],[29,25,31,34],[33,25,35,34],[52,21,54,24],[92,8,92,11],[23,3,23,9],[23,10,25,20],[29,3,30,9],[37,3,38,9],[31,3,31,9],[33,3,33,9],[34,3,35,9],[90,15,90,23],[42,3,42,34],[43,25,45,34],[46,25,48,34],[43,10,45,20],[55,10,57,20],[55,21,57,24],[90,24,90,33],[53,3,54,9],[52,3,52,9],[55,25,57,34],[27,3,28,9]]}
[]
[null,null,null,null,null,null,null,null,"MID-CONSTRUCTION CHECKLIST\nfor New 1&2 Family and 1-3 Storey Residential Buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,"March 1 2025"]
[null,null,null,"This checklist is to confirm energy components are properly installed and consistent with the building design. It is completed by a certified energy modeller and provided to the Building Official before insulation inspection. One form can be completed for multiple units with matching specifications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"1. Project Information"]
[]
[null,null,null,null,null,null,null,"Project Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Unit #'s (if applicable):"]
[null,"->",null,null,null,null,null,"Energy Pathway:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building Type:"]
[null,null,null,null,null," ",null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null," "," ",null," ",null," "]
[null,null,null,"2. Building Envelope Characteristics Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"MEASURE",null,null,null,null,null,null,"DETAILS (ASSEMBLY / SYSTEM \nTYPE / FUEL TYPE / ETC.)",null,null,null,null,null,null,null,null,null,null,"R-VALUE / EFFICIENCY",null,null,null,"UPGRADE HAS \nBEEN INSTALLED:",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,"Insulation & Opaque Envelope"]
[null,null,null,"ABOVE-GRADE WALLS"]
[null,null,null,{"$f":"IF(I9=D153,Q224,IF(I9=D152,Q190,Q156))","v":"Minimum R22 eff. (RSI 3.85)"}]
[]
[null,null,null,"BELOW-GRADE /  FOUNDATION WALLS"]
[]
[null,null,null,{"$f":"IF(I9=D153,Q224,IF(I9=D152,Q190,Q156))","v":"Minimum R22 eff. (RSI 3.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,null,null,null,null,null,null,null,null," "]
[null,null,null,"INSULATED FLOORS"]
[null,null,null,{"$f":"IF(I9=D153,Q234,IF(I9=D152,Q200,Q166))","v":"Minimum R24 eff. (RSI 4.2)"}]
[]
[null,null,null,"FLAT ATTIC"]
[null,null,null,{"$f":"IF(I9=D153,Q228,IF(I9=D152,Q194,Q160))","v":"Minimum R48 effective (RSI 8.5)"}]
[]
[null,null,null,"VAULTED & FLAT ROOF"]
[null,null,null,{"$f":"IF(I9=D153,Q230,IF(I9=D152,Q196,Q162))","v":"Units >110sq.m = R40 eff. (RSI 7.0); \nUnits <110sq.m = R30 (RSI 5.28)"}]
[]
[null,null,null,"BALCONIES & \nEXPOSED SLAB EDGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(I9=D153,Q236,IF(I9=D152,Q202,Q168))","v":"Thermal break R2.4 eff. (RSI 0.42)"}]
[null,null,null,"Fenestration & Transparent Envelope",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," "]
[null,"->",null,"WINDOWS & SLIDING DOORS"]
[null,null,null,{"$f":"IF(I9=D153,Q242,IF(I9=D152,Q208,Q174))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"->",null,"SIDE-HINGED DOORS"]
[null,null,null,{"$f":"IF(I9=D153,Q240,IF(I9=D152,Q206,Q172))","v":"Aside from front entry door, USI 1.80 or lower"}]
[]
[null,null,null,"SKYLIGHTS & SLOPED GLAZING"]
[]
[null,null,null,"Skylights USI ≤ 2.4 W / m2K\nRoof hatch USI ≤ 2.9"]
[null,"->",null,"Mechanical Systems (if installed 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,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"FIREPLACES"]
[null,null,null,{"$f":"IF(I9=D153,Q250,IF(I9=D152,Q216,Q182))","v":"If gas: maximum combined 60,000 BTU allowable limit"}]
[]
[null,null,null,"SPACE HEATING & COOLING"]
[null,null,null,{"$f":"IF(I9=D153,Q248,IF(I9=D152,Q214,Q180))","v":"Electric systems only"}]
[]
[null,null,null,"DOMESTIC HOT WATER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(I9=D153,Q252,IF(I9=D152,Q218,Q184))","v":"Electric systems only"}]
[]
[null,null,null,"VENTILATION",null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(I9=D153,Q246,IF(I9=D152,Q212,Q178))","v":"HRV - 75% SRE @ 0 deg C\n 65% for Laneway Homes"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"OTHER \nENERGY MEASURES"]
[]
[]
[null,null,null,"page 1 of 2"]
[]
[null,null,null,"2. Air Tightness"]
[]
[null,null,null,null,"Air Barrier System & Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"Interior: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Exterior: "]
[]
[]
[null,null,null,null,"Details and Continuity Checklist (checkmark to verify; not all may apply)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Yes"," N/A"]
[null,null,null,null,null,null,"Materials: compatible air barrier materials and tapes are used as designed"]
[null,null,null,null,null,null,"Insulation: insulation is continuous; all accessible cavities filled including in narrow sections"]
[null,null,null,null,null,null,"Continuity: air barrier is continuous at corners, junctions, penetrations (holes and cuts) and transitions"]
[null,null,null,null,null,null,"Shower/tub: air barrier is continuous behind showers and tubs, and is fully connected to the wall air barrier",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Staircases: air barrier is continuous behind staircases, and is fully connected to the wall air barrier"]
[null,null,null,null,null,null,"Wiring and recessed lighting: air barrier extends continuously behind boxes "]
[null,null,null,null,null,null,"Penetrations: fenestration, utilities, knee walls, shafts connected to exterior are sealed with caulk, tape or equivalent"]
[null,null,null,null,null,null,"Sheathing or sheathing membrane: fully taped at all seams, taped at interior/exterior connections and junctions"]
[null,null,null,null,null,null,"Garages & common walls: air barrier is installed in common walls and between units and garages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Fireplaces: where visible, air barrier is continuous and any gaps are fully sealed with caulk, tape or equivalent"]
[null,null,null,null,null,null,"Party wall: gaps between framing and party-wall fire separation is sealed with non-combustible materials"]
[]
[]
[null,null,null,null,"Blower Door Airtightness Testing (select applicable procedure)"]
[null,"->",null,null,null,"Single unit or per-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,null,null,null,null,null,null,null,null,null," "]
[null,"->",null,null,null,"Whole building (stacked multi-family)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null," "]
[null,null,null,null,"Testing completed:",null,null,null,null,null,"Blower door test (required)",null,null,null,null,null,null,null,"Thermal imaging",null,null,null,null,"Smoke testing",null,null,null,null,"Visual leak analysis",null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Test timing:",null,null,null,null,null,"Pre-drywall",null,null,null,null,null,"Post-drywall",null,null,null,null,null,"Other",null,null,null,null,null," "]
[]
[null,null,null,null,"Measured Air Leakage",null,null,null,null,null,null,null,null,null,null,"Method used to calculate score",null,null,null,null,null,null,null,null,"Achieved air tightness score",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"Pressure differential",null,null,null," ",null,null,null,"Pa",null,null,null,"Measured Air Leakage data extrapolated by HOT2000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null," ",null,null,null,null,null,null,null,null,null,null,null,null,"ACH @50 Pa",null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,"Flow rate",null,null,null," ",null,null,null," ","L/s",null,null,"Result from manometer",null,null,null,null,null,null," ",null,"L/s/m2 @75 Pa \nfor whole building multi-family",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "," "," ","CFM",null,null,"Other (describe below)",null,null,null,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,null,"De-pressurized",null,null,null,null,null,null,null,null,null,null,null,null," ",null,"NLA (cm2/m2) @10 Pa \nfor units <1,200 ft2",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,"Additional Testing Notes"]
[null,null,null,null," "]
[]
[]
[null,null,null,"3. Contact Information & Authorization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"By signing, I certify that:"]
[null,null,null,null,null,"• The building as-built to date conforms to the energy model submitted for the Building Permit"]
[null,null,null,null,null,"• This review was completed by the same advisor and/or team that created the original energy model"]
[null,null,null,null,null,"• The building as-built to date is on track to achieve airtightness and energy requirements"]
[]
[null,null,null,"  Energy Advisor (name, #)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Builder (company):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"  Company:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null," "]
[null,null,null,"  Email Address or Phone:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"  Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Builder Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[null,null,null,"  Date: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Visit www.vancouver.ca/homeenergy for the latest version of this form"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Tables hidden below  ò"]
[null,null,null,null,"Whole building"]
[null,null,null,null,"Individual Units"]
[]
[null,null,null,null,"Ground-oriented"]
[null,null,null,null,"Stacked Multi-family"]
[null,null,null,null,"Other"]
[]
[null,null,null,null,"Ground-oriented Townhouse or Rowhouse"]
[null,null,null,null,"Stacked Multi-family Building (1-3 storeys)"]
[null,null,null,null,"Other"]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"Y"]
[]
[null,null,null,"Laneway House"]
[null,null,null,"1&2 Family"]
[null,null,null,"Ground-oriented unit (other)"]
[null,null,null,"Stacked Multi-Family"]
[]
[]
[null,null,null,"Option #1: Prescriptive Path"]
[null,null,null,"Option #2: Performance Path"]
[null,null,null,"Option #3: Passive House Path"]
[]
[null,null,null,"REQUIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,"PRESCRIPTIVE PATH"]
[null,null,null,"1.1 Exterior above-grade walls & floor headers",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,"1.2 Below-grade walls",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,"1.3 Flat attic",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R48 effective (RSI 8.5)"]
[]
[null,null,null,"1.4 Flat, vaulted and cathedral roofs",null,null,null,null,null,null,null,null,null,null,null,null,"Units >110sq.m = R40 eff. (RSI 7.0); \nUnits <110sq.m = R30 (RSI 5.28)"]
[]
[null,null,null,"1.5 Under foundation slab ",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R14 eff. (RSI 2.5)"]
[]
[null,null,null,"1.6 Exposed floors",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R24 eff. (RSI 4.2)"]
[]
[null,null,null,"1.7 Balconies, eyebrows, and exposed slab edge",null,null,null,null,null,null,null,null,null,null,null,null,"Thermal break R2.4 eff. (RSI 0.42)"]
[]
[null,null,null,"1.8 Air barrier ",null,null,null,null,null,null,null,null,null,null,null,null,"Continuous air barrier design to meet specified target"]
[]
[null,null,null,"2.1 Side-hinged doors",null,null,null,null,null,null,null,null,null,null,null,null,"Aside from front entry door, USI 1.80 or lower"]
[]
[null,null,null,"2.2 Windows, curtainwalls and glazed doors",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Pre Permit Checklist'!R201","v":{"$error":"#REF!"}}]
[]
[null,null,null,"2.3 Skylights and roof hatches   ",null,null,null,null,null,null,null,null,null,null,null,null,"Skylights USI 2.4 or lower. Roof hatches USI 2.9 or lower"]
[]
[null,null,null,"3.1 Ventilation ",null,null,null,null,null,null,null,null,null,null,null,null,"HRV - 75% SRE @ 0 deg C\n 65% for Laneway Homes"]
[]
[null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric systems only"]
[]
[null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"If gas: maximum combined 60,000 BTU allowable limit"]
[]
[null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Electric systems only"]
[]
[null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]
[]
[]
[null,null,null,"REQUIREMENT",null,null," ",null,null,null,null,null,null,null,null,null,"PERFORMANCE PATH"]
[null,null,null,"1.1 Exterior above-grade walls & floor headers",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,"1.2 Below-grade walls",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,"1.3 Flat attic",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R48 effective (RSI 8.5)"]
[]
[null,null,null,"1.4 Flat, vaulted and cathedral roofs",null,null,null,null,null,null,null,null,null,null,null,null,"R30 eff. (RSI 5.28), 1&2 Family + LWH: R24 eff. (RSI 4.3)"]
[]
[null,null,null,"1.5 Under foundation slab ",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R14 eff. (RSI 2.5)"]
[]
[null,null,null,"1.6 Exposed floors",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R24 eff. (RSI 4.2)"]
[]
[null,null,null,"1.7 Balconies, eyebrows, and exposed slab edge",null,null,null,null,null,null,null,null,null,null,null,null,"Thermal break R2.4 eff. (RSI 0.42)"]
[]
[null,null,null,"1.8 Air barrier ",null,null,null,null,null,null,null,null,null,null,null,null,"Continuous air barrier design to meet specified target"]
[]
[null,null,null,"2.1 Side-hinged doors",null,null,null,null,null,null,null,null,null,null,null,null,"Aside from front entry door, USI 1.80 or lower"]
[]
[null,null,null,"2.2 Windows, curtainwalls and glazed doors",null,null,null,null,null,null,null,null,null,null,null,null,"USI 1.44 or lower"]
[]
[null,null,null,"2.3 Skylights and roof hatches   ",null,null,null,null,null,null,null,null,null,null,null,null,"Skylights USI 2.4 or lower. Roof hatches USI 2.9 or lower"]
[]
[null,null,null,"3.1 Ventilation ",null,null,null,null,null,null,null,null,null,null,null,null,"HRV - 75% SRE @ 0 deg C\n 65% for Laneway Homes"]
[]
[null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric or gas. For gas: minimum 92% AFUE"]
[]
[null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"Direct vent electronic ignition & timer. \nIndicate total # of fireplaces"]
[]
[null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Energy Factor (UEF or EF) ≥ 0.78 or thermal efficiency (TE) ≥ 90% "]
[]
[null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]
[]
[]
[null,null,null,"REQUIREMENT",null,null," ",null,null,null,null,null,null,null,null,null,"PASSIVE HOUSE PATH"]
[null,null,null,"1.1 Exterior above-grade walls & floor headers",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,"1.2 Below-grade walls",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R22 eff. (RSI 3.85)"]
[]
[null,null,null,"1.3 Flat attic",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R48 effective (RSI 8.5)"]
[]
[null,null,null,"1.4 Flat, vaulted and cathedral roofs",null,null,null,null,null,null,null,null,null,null,null,null,"R30 eff. (RSI 5.28), 1&2 Family + LWH: R24 eff. (RSI 4.3)"]
[]
[null,null,null,"1.5 Under foundation slab ",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R14 eff. (RSI 2.5)"]
[]
[null,null,null,"1.6 Exposed floors",null,null,null,null,null,null,null,null,null,null,null,null,"Minimum R24 eff. (RSI 4.2)"]
[]
[null,null,null,"1.7 Balconies, eyebrows, and exposed slab edge",null,null,null,null,null,null,null,null,null,null,null,null,"Thermal break R2.4 eff. (RSI 0.42)"]
[]
[null,null,null,"1.8 Air barrier ",null,null,null,null,null,null,null,null,null,null,null,null,"Continuous air barrier design to meet specified target"]
[]
[null,null,null,"2.1 Side-hinged doors",null,null,null,null,null,null,null,null,null,null,null,null,"Aside from front entry door, USI 1.80 or lower"]
[]
[null,null,null,"2.2 Windows, curtainwalls and glazed doors",null,null,null,null,null,null,null,null,null,null,null,null,"USI 1.44 or lower"]
[]
[null,null,null,"2.3 Skylights and roof hatches   ",null,null,null,null,null,null,null,null,null,null,null,null,"Skylights USI 2.4 or lower. Roof hatches USI 2.9 or lower"]
[]
[null,null,null,"3.1 Ventilation ",null,null,null,null,null,null,null,null,null,null,null,null,"HRV - 75% SRE @ 0 deg C\n 65% for Laneway Homes"]
[]
[null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric or gas. For gas: minimum 92% AFUE"]
[]
[null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"Direct vent electronic ignition & timer. \nIndicate total # of fireplaces"]
[]
[null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Energy Factor (UEF or EF) ≥ 0.78 or thermal efficiency (TE) ≥ 90% "]
[]
[null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]

{"sheet":"As-Built Checklist","index":4,"n_rows":154,"n_cols":49,"rows_kept":154,"cut":false,"hidden":false,"merged":[[7,15,7,23],[7,24,7,30],[8,24,8,30],[7,6,7,14],[2,0,4,1],[8,15,8,23],[1,8,3,30],[4,3,4,34],[5,3,5,34],[1,3,3,6],[3,31,3,34],[2,31,2,34],[1,31,1,34],[93,27,93,28],[60,26,60,33],[62,26,63,33],[44,4,44,14],[46,4,47,7],[60,9,60,19],[93,19,93,25],[46,16,47,22],[46,25,46,32],[61,9,61,19],[62,9,63,19],[64,9,64,19],[48,25,49,33],[54,4,54,33],[56,3,56,34],[59,26,59,33],[94,3,94,4],[92,3,92,7],[93,6,93,7],[93,9,93,14],[93,16,93,17],[14,21,14,33],[11,21,11,33],[20,3,20,9],[21,3,21,9],[8,6,8,14],[20,10,21,20],[20,25,21,34],[18,3,18,34],[19,3,19,9],[19,10,19,20],[19,21,19,24],[19,25,19,34],[20,21,21,24],[22,10,23,20],[22,21,23,24],[22,25,23,34],[48,8,48,11],[22,3,22,9],[23,3,23,9],[59,9,59,19],[46,8,46,11],[44,15,44,23],[25,3,26,9],[24,10,26,20],[24,21,26,24],[24,3,24,9],[44,24,44,33],[30,3,30,34],[27,3,29,9],[27,10,29,20],[27,21,29,24],[27,25,29,34],[24,25,26,34]]}
[]
[null,null,null,null,null,null,null,null,"FINAL (AS-BUILT) CHECKLIST\nfor New 1&2 Family and 1-3 Storey Residential Buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,"March 1 2025"]
[null,null,null,"This checklist is to confirm energy components are properly installed and consistent with building plans. It is completed by a certified energy modeller and \nis provided to the Building Official before final inspection. One form can be completed for multiple units with matching specifications"]
[null,null,null,"1. Project Information"]
[" "]
[null,null,null,null,null,null,"Address / Unit #(s) ",null,null,null,null,null,null,null,null,"Unit & Model type (dropdown)",null,null,null,null,null,null,null,null,"N File #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"->",null,null,"Building energy standard: ",null,null,null,null,null,null,"Other project checklists",null,null,null,null,null,null,null,null,null,"Selected energy pathway (dropdown)"]
[null,null,null,null,null,null,null,null,null,null,null,"(attach all that apply)"]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy modelling software & version: "]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," "]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,"2. Mechanical System Confirmation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,"Measure",null,null,null,null,null,null,"System Type / Make & Model / Fuel Type",null,null,null,null,null,null,null,null,null,null,"Efficiency",null,null,null,"Confirmed Installation",null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,"HEATING & COOLING",null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(V12=D124,Q148,IF(V12=D123,Q138,Q128))","v":"Electric systems only"}]
[null,null,null,"FIREPLACES",null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(V12=D124,Q150,IF(V12=D123,Q140,Q130))","v":"If gas: maximum combined 60,000 BTU allowable limit"}]
[null,null,null,"DOMESTIC HOT WATER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(V12=D124,Q152,IF(V12=D123,Q142,Q132))","v":"Electric systems only"}]
[]
[null,null,null,"VENTILATION\nHRV - 75% SRE @ 0 deg C\n65% for Laneway Homes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"3. Air Tightness"]
[]
[null,null,null,null,"Air Barrier System & Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"Interior: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Exterior: "]
[]
[]
[null,null,null,null,"Final Blower Door Airtightness Testing (select applicable procedure)"]
[null,"->",null,null,null,"Single unit or per-unit: 2.5 ACH @ 50Pa or 1.7 NLA for small units under 1,200 sq.ft.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"->",null,null,null,"Whole building (stacked multi-family): 2.03 L/s/m2  @ 75Pa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null," "]
[null,null,null,null,"Testing completed:",null,null,null,null,null,"Blower door test (required)",null,null,null,null,null,null,null,"Thermal imaging",null,null,null,null,"Smoke testing",null,null,null,null,"Visual leak analysis",null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"Measured Air Leakage",null,null,null,null,null,null,null,null,null,null,"Method used to calculate score",null,null,null,null,null,null,null,null,"Final air tightness score",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"Pressure differential",null,null,null," ",null,null,null,"Pa",null,null,null,"Measured Air Leakage data extrapolated by HOT2000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null," ",null,null,null,null,null,null,null,null,null,null,null,null,"ACH @50 Pa",null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,"Flow rate",null,null,null," ",null,null,null," ","L/s",null,null,"Result from manometer",null,null,null,null,null,null," ",null,"L/s/m2 @75 Pa \nfor whole building multi-family"]
[null,null,null,null,null,null,null,null,null,null," "," "," ","CFM",null,null,"Other (describe below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"NLA (cm2/m2) @10 Pa ",null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for dwelling units <1,200 ft2"]
[]
[null,null,null,null,"Additional Testing Notes"]
[]
[]
[null,null,null,"4. Contact Information & Authorization"]
[null,null,null,null,"By signing, I certify that the as-built building conforms to the final energy model:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"  Advisor (name, #)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Builder (company):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"  Company:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact name:"]
[null,null,null,"  Email and Phone:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"  Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Builder Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"  Date: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Visit www.vancouver.ca/homeenergy for the latest version of this form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Tables hidden below  ò"]
[null,null,null,null,"Whole building"]
[null,null,null,null,"Individual Units"]
[]
[null,null,null,null,"Laneway House",null,null,null,null,null,null,null,null,"Laneway House"]
[null,null,null,null,"1&2 Family",null,null,null,null,null,null,null,null,"1&2 Family"]
[null,null,null,null,"Ground-oriented unit (other)",null,null,null,null,null,null,null,null,"Ground-oriented unit (other)"]
[null,null,null,null,"Stacked MURB (per unit)",null,null,null,null,null,null,null,null,"Stacked Multi-Family"]
[null,null,null,null,"Stacked MURB (whole building)"]
[]
[null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,"Y"]
[]
[]
[null,null,null,"Option #1: Prescriptive Path"]
[null,null,null,"Option #2: Performance Path"]
[null,null,null,"Option #3: Passive House Path"]
[]
[null,null,null,"REQUIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,"PRESCRIPTIVE PATH"]
[]
[null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric systems only"]
[]
[null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"If gas: maximum combined 60,000 BTU allowable limit"]
[]
[null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Electric systems only"]
[]
[null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]
[]
[null,null,null,"REQUIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,"PERFORMANCE PATH"]
[]
[null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric or gas. For gas: minimum 92% AFUE."]
[]
[null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"Direct vent electronic ignition & timer. \nIndicate total # of fireplaces"]
[]
[null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Energy Factor (UEF or EF) ≥ 0.78 or thermal efficiency (TE) ≥ 90% "]
[]
[null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"REQUIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,"PASSIVE HOUSE PATH"]
[null,null,null,"3.2 Heating systems: ",null,null,null,null,null,null,null,null,null,null,null,null,"Electric or gas. For gas: minimum 92% AFUE"]
[]
[null,null,null,"3.3 Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,"Direct vent electronic ignition & timer. \nIndicate total # of fireplaces"]
[]
[null,null,null,"3.4 Domestic hot water",null,null,null,null,null,null,null,null,null,null,null,null,"Energy Factor (UEF or EF) ≥ 0.78 or thermal efficiency (TE) ≥ 90% "]
[]
[null,null,null,"3.5 Recirculating system",null,null,null,null,null,null,null,null,null,null,null,null,"Piping wrapped with pipe insulation R2 (RSI 0.35)"]

{"sheet":"GHG Calculator FAQ","index":5,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[24,2,24,14],[30,2,30,14],[32,2,32,14],[35,2,35,14],[39,2,39,14]]}
[]
[null,null,"Large Homes Greenhouse Gas Calculator - Overview"]
[]
[null,null,"WHEN IS THIS CALCULATOR REQUIRED?"]
[]
[null,null,"This calculator is required for homes applying for a Building Permit after March 1st 2018 that are 325 square meters in floor space or larger"]
[null,null,"The Annual Carbon Limit is:"]
[null,null," - March 1st 2018 to May 31st, 2020: 3.0 tonnes CO2 / year"]
[null,null,"- June 1st, 2021 and on: 2.0 tonnes CO2 / year"]
[null,null,"For homes outside the scope of EnerGuide (example: >600m2 building area), a HOT2000 'General Mode' or hourly software model must be "]
[null,null,"completed, and the calculator filled out to demonstrate compliance. "]
[null,null,"Read the Modelling Guidelines for Large Homes",null,null,null,null,"https://vancouver.ca/files/cov/modelling-guidelines-large-homes.pdf"]
[]
[null,null,"Certified Passive House Projects and all-electric projects are exempt from this requirement. "]
[]
[null,null,"WHAT ARE THE MODELLING GUIDELINES FOR LARGE HOMES?"]
[]
[null,null,"The Vancouver Building By-law (Article 10.2.2.20) refers to Modelling Guidelines for Large Homes. The most recent guidelines can be downloaded from "]
[null,null,"www.vancouver.ca/home-energy",null,null,".  The guidelines were developed to provide a basis for calculating the total annual GHG emissions footprint of a house, "]
[null,null,"including both base emissions accounted for by the energy model, as well as non-typical loads outside of the model. It is a reference document,"]
[null,null,"the calculations from the guidelines are all built into the calculator"]
[]
[null,null,"WHO FILLS OUT AND SIGNS THE FORM?"]
[]
[null,null,"If the home falls under EnerGuide, an Energy Advisor (EA) models the home, fills out the calculator, signs and submits.\nIf outside of EnerGuide, an Energy Advisor and HOT2000 is still permitted to complete the form in a default mode. In addition, a trained-modeller can complete and sign the calculator provided the City of Vancouver Modelling Guidelines are followed.\n"]
[]
[null,null,"HOW IS THE 325 SQUARE METER VALUE CALCULATED?"]
[]
[null,null,"The square meter calculation is done for the principal residence on the property. The value does not include laneway homes, pool houses etc."]
[]
[null,null,"The GHG calculation is triggered if the Energy Advisor's conditioned interior space calculation used in HOT2000 is ≥325m2"]
[]
[null,null,"To complete the calculator, all conditioned, habited spaces on the property must be modelled. The energy use of the laneway house and guest house cabana (if conditioned space) must have models completed and the energy use inputted in the calculator."]
[null,null,"WHAT ARE NON-TYPICAL LOADS?"]
[]
[null,null,"Non-typical loads are energy uses that are not captured within the typical base loads in the EnerGuide program. Where non-typical energy loads are present in the development, the modeller shall include the energy and GHG emissions from those loads in the total footprint of the development. This is built into the calculator spreadsheet. \n\nCertain items such as cooktops, ice melt systems and outdoor fireplace BTU ratings are not typically included in EnerGuide reporting. Therefore, the Energy Advisor or modeller must work with the builder / designer / homeowner to gather the number of intended non-typical loads on the property"]
[]
[null,null,"WHAT IF I NEED TO ADD ITEMS NOT IN THE LIST?"]
[]
[null,null,"There may be items in the home design that aren't listed in the calculator specifically. There are blank rows in the template to allow for additions. However, you will need to generate a reasonable GJ/a for that product. \n\n\n\n"]

{"sheet":"GHG Calculator Checklist","index":6,"n_rows":168,"n_cols":20,"rows_kept":168,"cut":false,"hidden":false,"merged":[[73,2,73,6],[68,4,68,6],[68,9,68,10],[69,4,69,6],[69,9,69,10],[70,4,70,6],[70,7,70,10],[63,1,63,6],[63,12,63,13],[64,12,64,13],[66,4,66,10],[67,4,67,6],[67,9,67,10],[60,1,60,6],[60,12,60,13],[61,1,61,6],[61,12,61,13],[62,1,62,6],[62,12,62,13],[55,1,55,6],[55,12,55,13],[56,1,56,6],[56,12,56,13],[58,2,58,6],[59,2,59,6],[52,1,52,6],[52,12,52,13],[53,1,53,6],[53,12,53,13],[54,1,54,6],[54,12,54,13],[49,1,49,6],[49,12,49,13],[50,1,50,6],[50,12,50,13],[51,1,51,6],[51,12,51,13],[46,1,46,6],[46,12,46,13],[47,1,47,6],[47,12,47,13],[48,1,48,6],[48,12,48,13],[43,1,43,6],[43,12,43,13],[44,1,44,6],[44,7,44,13],[45,1,45,6],[45,12,45,13],[40,1,40,6],[40,12,40,13],[41,1,41,6],[41,12,41,13],[42,1,42,6],[42,7,42,13],[36,12,36,13],[37,1,37,6],[37,12,37,13],[38,1,38,6],[38,7,38,13],[39,1,39,6],[39,12,39,13],[33,1,33,6],[33,12,33,13],[34,1,34,6],[34,7,34,13],[35,1,35,6],[35,12,35,13],[30,1,30,6],[30,12,30,13],[31,1,31,6],[31,12,31,13],[32,1,32,6],[32,12,32,13],[27,1,27,6],[27,12,27,13],[28,1,28,6],[28,12,28,13],[29,1,29,6],[29,7,29,13],[24,1,24,6],[24,7,24,13],[25,1,25,6],[25,12,25,13],[26,1,26,6],[26,12,26,13],[20,1,20,8],[20,12,20,13],[21,9,21,11],[21,12,21,13],[23,1,23,6],[23,12,23,13],[17,1,17,13],[17,16,17,28],[18,1,18,8],[18,12,18,13],[19,1,19,8],[19,12,19,13],[19,16,19,28],[14,1,14,3],[14,5,14,8],[14,9,14,13],[15,1,15,3],[15,5,15,8],[15,9,15,13],[11,1,11,13],[12,1,12,3],[12,5,12,8],[12,9,12,13],[13,1,13,3],[13,5,13,8],[13,9,13,13],[9,1,9,3],[9,4,9,5],[9,7,9,8],[6,1,6,3],[6,4,6,8],[6,12,6,13],[7,1,7,3],[7,4,7,8],[7,10,7,11],[7,12,7,13],[1,4,1,10],[1,12,1,13],[2,4,2,10],[2,12,2,13],[3,2,4,12],[5,1,5,8],[5,10,5,13],[8,1,8,3],[8,4,8,8],[8,10,8,13]]}
[]
[null,null,null,null,"GHG EMISSIONS CALCULATOR FOR LARGE HOMES",null,null,null,null,null,null,null,"Version 3.0"]
[null,null,null,null,"One and Two Family Dwellings over 325 square meters",null,null,null,null,null,null,null,"March 1 2025"]
[null,null,"This checklist must be completed electronically for 1&2 Family homes with a primary dwelling floor area ≥325 m2 applying for a Building Permit after March 1st 2018. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Project Information",null,null,null,null,null,null,null,null,"Exemptions"]
[null,"Project Address:",null,null,null,null,null,null,null,null,"All-electric service"]
[null,"Modelling Software:",null,null,null,null,null,null,null,null,"Passive House / Net Zero",null,null,null,null,null," "]
[null,"Modelling completed by:",null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"X\",\"Exempt\",IF(M8=\"X\",\"Exempt\",\" \"))","v":" "}]
[null,"Calculated Floor Area (m2):",null,null,null,null,"Date: "]
[]
[null,"Heating Systems Modelling"]
[null,"Heating System",null,null,"Energy type","System type (dropdown)",null,null,null,"System details (optional)"]
[null,"Primary"]
[null,"Secondary (backup / peak)"]
[null,"Domestic Hot Water"]
[]
[null,"Model Summary"]
[null,"Primary Dwelling Energy Model Results",null,null,null,null,null,null,null,"Energy Consumption (GJ/a)","Fuel Type\n(Elec/NG)","GHG Emission Factor\n(kgCO2e/GJ)","GHG Emissions \n(tCO2e)",null,null,null," "]
[null,"Modelled Electricity Consumption",null,null,null,null,null,null,null,null,"Electricity",{"$f":"G137","v":3.0555799999999995},{"$f":"J20*L20/1000","v":0},null,null,null,"         "]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"G138","v":51.388930000000002},{"$f":"J21*L21/1000","v":0},null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"Primary Dwelling GHG Emissions in tCO2e",null,null,{"$f":"SUM(M20:M21)","v":0}]
[]
[null,"Non-Typical Load Calculations",null,null,null,null,null,"Installed\n(#)","Area/\nLength\n(m2 or m)","Energy Consumption\n(GJ/a)","Fuel Type\n(Elec/NG)","GHG Emission Factor\n(kgCO2e/GJ)","GHG Emissions \n(tCO2e)"]
[null,"Indoor Appliances"]
[null,"Gas Clothes Dryer",null,null,null,null,null,null,null,3,"Natural Gas",{"$f":"IF(K26=\"Natural Gas\",$G$138,IF(K26=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H26*J26*L26/1000","v":0}]
[null,"Indoor Fireplace (>60 % Efficiency)",null,null,null,null,null,null,null,2,"Natural Gas",{"$f":"IF(K27=\"Natural Gas\",$G$138,IF(K27=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H27*J27*L27/1000","v":0},null,null,null,null,null," "," "]
[null,"Indoor Fireplace (≤60 % Efficiency)",null,null,null,null,null,null,null,3,"Natural Gas",{"$f":"IF(K28=\"Natural Gas\",$G$138,IF(K28=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H28*J28*L28/1000","v":0}]
[null,"Gas Appliance Rough-in",null,null,null,null,null,null,null,3,"Natural Gas",{"$f":"IF(K29=\"Natural Gas\",$G$138,IF(K29=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H29*J29*L29/1000","v":0}]
[null,"Outdoor Fireplaces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"<30,000 btu/hr (8.8 kW)",null,null,null,null,null,null,null,{"$f":"30000/3412.142*2*52/277.78","v":3.2917475722636524},"Natural Gas",{"$f":"IF(K31=\"Natural Gas\",$G$138,IF(K31=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H31*J31*L31/1000","v":0},null,null,null," "]
[null,"<100,000 btu/hr (29.3 kW)",null,null,null,null,null,null,null,{"$f":"((30000+100000)/2)/3412.142*2*52/277.78","v":7.1321197399045797},"Natural Gas",{"$f":"IF(K32=\"Natural Gas\",$G$138,IF(K32=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H32*J32*L32/1000","v":0}]
[null,"≥100,000 btu/hr (29.3 kW)",null,null,null,null,null,null,null,{"$f":"((100000+150000)/2)/3412.142*2*52/277.78","v":13.715614884431886},"Natural Gas",{"$f":"IF(K33=\"Natural Gas\",$G$138,IF(K33=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H33*J33*L33/1000","v":0}]
[null,"Rough-in",null,null,null,null,null,null,null,6,"Natural Gas",{"$f":"IF(K34=\"Natural Gas\",$G$138,IF(K34=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H34*J34*L34/1000","v":0}]
[null,"Outdoor Heaters & Grills"]
[null,"Plumbed Space or Decorative Space Heaters",null,null,null,null,null,null,null,6,"Natural Gas",{"$f":"IF(K36=\"Natural Gas\",$G$138,IF(K36=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H36*J36*L36/1000","v":0},null,null,null," "," "]
[null,null,null,null,null,null,"Plumbed BBQ's and Grills",null,null,6,"Natural Gas",{"$f":"IF(K37=\"Natural Gas\",$G$138,IF(K37=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H37*J37*L37/1000","v":0}]
[null,"Rough-in",null,null,null,null,null,null,null,6,"Natural Gas",{"$f":"IF(K38=\"Natural Gas\",$G$138,IF(K38=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H38*J38*L38/1000","v":0}]
[null,"Pools and Hot Tubs"]
[null,"Outdoor Pool (Above or Below Ground, Natural Gas Heater, Area in m2)",null,null,null,null,null,null,null,{"$f":"IF(I40=0,0,2.9114*I40-1.0587)","v":0},"Natural Gas",{"$f":"IF(K40=\"Natural Gas\",$G$138,IF(K40=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H40*J40*L40/1000","v":0},null,null," "]
[null,"Indoor Pool (Natural Gas Heater, Area in m2)",null,null,null,null,null,null,null,{"$f":"IF(I41=0,0,1.3617*I41-0.296)","v":0},"Natural Gas",{"$f":"IF(K41=\"Natural Gas\",$G$138,IF(K41=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H41*J41*L41/1000","v":0},null,null,null," "]
[null,"Indoor or Outdoor Hot Tub",null,null,null,null,null,null,null,11,null,{"$f":"IF(K42=\"Natural Gas\",$G$138,IF(K42=\"Electricity\",$G$137,))","v":0},{"$f":"H42*((3*G137)+(8*L42))/1000","v":0},null," ",null,null," "]
[null,"Cooking Areas"]
[null,"Supplemental Stove, Oven, or Cooktop",null,null,null,null,null,null,null,{"$f":"565/277.78","v":2.0339837281301754},null,{"$f":"IF(K44=\"Natural Gas\",$G$138,IF(K44=\"Electricity\",$G$137,))","v":0},{"$f":"H44*J44*L44/1000","v":0},null,null,null," ",null,null," "]
[null,"Outbuildings",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Pool House"]
[null,"Modelled Electricity Consumption",null,null,null,null,null,null,null,null,"Electricity",{"$f":"IF(K47=\"Natural Gas\",$G$138,IF(K47=\"Electricity\",$G$137,))","v":3.0555799999999995},{"$f":"J47*L47/1000","v":0},null,null,null,null," "]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"IF(K48=\"Natural Gas\",$G$138,IF(K48=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"J48*L48/1000","v":0}]
[null,"Laneway House"]
[null,"Modelled Electricity Consumption",null,null,null,null,null,null,null,null,"Electricity",{"$f":"IF(K50=\"Natural Gas\",$G$138,IF(K50=\"Electricity\",$G$137,))","v":3.0555799999999995},{"$f":"J50*L50/1000","v":0}]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"IF(K51=\"Natural Gas\",$G$138,IF(K51=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"J51*L51/1000","v":0},null,null,null,null," "]
[null,"Heated Garage"]
[null,"Modelled Electricity Consumption",null,null,null,null,null,null,null,null,"Electricity",{"$f":"IF(K53=\"Natural Gas\",$G$138,IF(K53=\"Electricity\",$G$137,))","v":3.0555799999999995},{"$f":"J53*L53/1000","v":0},null,null," "]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"IF(K54=\"Natural Gas\",$G$138,IF(K54=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"J54*L54/1000","v":0},null,null,null,null," "]
[null,"Other Outbuilding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Modelled Electricity Consumption",null,null,null,null,null,null,null,null,"Electricity",{"$f":"IF(K56=\"Natural Gas\",$G$138,IF(K56=\"Electricity\",$G$137,))","v":3.0555799999999995},{"$f":"J56*L56/1000","v":0}]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"IF(K57=\"Natural Gas\",$G$138,IF(K57=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"J57*L57/1000","v":0},null,null,null," "]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Heated Surfaces and Snowmelt System (Area in m2)",null,null,null,null,null,null,{"$f":"0.1*I59","v":0},null,{"$f":"IF(K59=\"Natural Gas\",#REF!,IF(K59=\"Electricity\",#REF!,))","v":0},{"$f":"H59*J59*L59/1000","v":0}]
[null,null,"De-Icing Cable (Length in m)",null,null,null,null,null,null,{"$f":"0.04*I60","v":0},null,{"$f":"IF(K60=\"Natural Gas\",#REF!,IF(K60=\"Electricity\",#REF!,))","v":0},0,null,null," "]
[null,"Spa Rooms (Natural Gas Heater)",null,null,null,null,null,null,null,17,"Natural Gas",{"$f":"IF(K61=\"Natural Gas\",$G$138,IF(K61=\"Electricity\",$G$137,))","v":51.388930000000002},0,null,null,null," "]
[null,"Heated Surfaces and Snowmelt System (Area in m2)",null,null,null,null,null,null,null,{"$f":"0.1*I62","v":0},null,{"$f":"IF(K62=\"Natural Gas\",$G$138,IF(K62=\"Electricity\",$G$137,))","v":0},0]
[null,"De-Icing Cable (Length in m)",null,null,null,null,null,null,null,{"$f":"0.04*I63","v":0},null,{"$f":"IF(K63=\"Natural Gas\",$G$138,IF(K63=\"Electricity\",$G$137,))","v":0},0]
[null,"Other",null,null,null,null,null,null,null,null,null,{"$f":"IF(K64=\"Natural Gas\",$G$138,IF(K64=\"Electricity\",$G$137,))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Non-Typical Load GHG Emissions in tCO2e",{"$f":"SUM(M26:M64)","v":0}]
[]
[null,null,null,null,"Total GHG Emissions Compliance Check"]
[null,null,null,null,"Primary Dwelling",null,null,{"$f":"M22","v":0},"tCO2e"]
[null,null,null,null,"Non-Typical Loads",null,null,{"$f":"M65","v":0},"tCO2e"]
[null,null,null,null,"Total",null,null,{"$f":"H68+H69","v":0},"tCO2e",{"$f":"IF(I168=2,\"(2.0 tCO2e cap)\",\"(3.0 tCO2e cap)\")","v":"(2.0 tCO2e cap)"},null,null,null,null,null," "]
[null,null,null,null,"Compliant with Large Homes policy?",null,null,{"$f":"IF(M7=\"X\",\"Yes (Exempted) - All Electric\",IF(M8=\"X\",\"Yes (Exempted) - Passive House\",IF(H70<2,\"Yes\",\"No\")))","v":"Yes"}]
[]
[]
[null,null,"  Signed: __________________________________________________________",null,null,null,null,null,"Date: _____________________________________________________________"]
[null,null,"www.vancouver.ca/homeenergy"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]
[null,null,"Tables hidden below  ò"]
[]
[null,null,"Drop Downs",null,null,"GHG Emission Factor (kgCO2e/GJ) as per CoV Energy Modelling Guidelines v1.0"]
[null,null,"Choose",0,null,"Electricity",{"$f":"G141*277.78","v":3.0555799999999995}]
[null,null,"Electricity",1,null,"Natural Gas",{"$f":"G142*277.778","v":51.388930000000002}]
[null,null,"Natural Gas",2]
[null,null,null,3,null,"GHG Emission Factor (kgCO2e/kWh) as per CoV Energy Modelling Guidelines v1.0"]
[null,null,null,4,null,"Electricity",{"$f":"0.011","v":1.0999999999999999E-2}]
[null,null,null,5,null,"Natural Gas",{"$f":"0.185","v":0.185}]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8,null,null,"X"]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12,null,null,null,"PRIMARY",null,null,"SECONDARY",null,null,"DHW"]
[null,null,null,13,null,null,null,{"$f":"IF(E14=\"Electric\",\"Air-to-water heat pump\",IF(E14=\"Gas\",\"Gas Boiler\",\" \"))","v":" "},null,null,{"$f":"IF(E15=\"Electric\",\"Air-to-water heat pump\",IF(E15=\"Gas\",\"Gas Boiler\",\" \"))","v":" "},null,null,{"$f":"IF(E16=\"Electric\",\"Air-to-water heat pump\",IF(E16=\"Gas\",\"Gas Boiler - Tank\",\" \"))","v":" "}]
[null,null,null,14,null,null,null,{"$f":"IF(E14=\"Electric\",\"Central air-to-air heat pump\",IF(E14=\"Gas\",\"Gas Furnace\",\" \"))","v":" "},null,null,{"$f":"IF(E15=\"Electric\",\"Central air-to-air heat pump\",IF(E15=\"Gas\",\"Gas Furnace\",\" \"))","v":" "},null,null,{"$f":"IF(E16=\"Electric\",\"Electric Tank\",IF(E16=\"Gas\",\"Gas Boiler - Tankless\",\" \"))","v":" "}]
[null,null,null,15,null,null,null,{"$f":"IF(E14=\"Electric\",\"Air-to-air ductless minisplit\",IF(E14=\"Gas\",\"Other (provide in details)\",\" \"))","v":" "},null,null,{"$f":"IF(E15=\"Electric\",\"Air-to-air ductless minisplit\",IF(E15=\"Gas\",\"Other (provide in details)\",\" \"))","v":" "},null,null,{"$f":"IF(E16=\"Electric\",\"Other (provide details)\",IF(E16=\"Gas\",\"Other (provide in details)\",\" \"))","v":" "}]
[null,null,null,16,null,null,null,{"$f":"IF(E14=\"Electric\",\"Geo-exchange heat pump system\",\" \")","v":" "},null,null,{"$f":"IF(E15=\"Electric\",\"Geo-exchange heat pump system\",\" \")","v":" "}]
[null,null,null,17,null,null,null,{"$f":"IF(E14=\"Electric\",\"Electric Baseboard\",\" \")","v":" "},null,null,{"$f":"IF(E15=\"Electric\",\"Electric Baseboard\",\" \")","v":" "}]
[null,null,null,18,null,null,null,{"$f":"IF(E14=\"Electric\",\"Electric Boiler\",\" \")","v":" "},null,null,{"$f":"IF(E15=\"Electric\",\"Electric Boiler\",\" \")","v":" "}]
[null,null,null,19,null,null,null,{"$f":"IF(E14=\"Electric\",\"Other (provide in details)\",\" \")","v":" "},null,null,{"$f":"IF(E15=\"Electric\",\"Other (provide in details)\",\" \")","v":" "}]
[null,null,null,20]
[null,null,null,21]
[null,null,null,22]
[null,null,null,23]
[null,null,null,24,null,null,null,"Gas",null,"Gas",null,"Electric"]
[null,null,null,25,null,null,null,"Electric",null,"Electric",null,"N/A"]
[null,null,null,26,null,null,null,"N/A",null,"N/A"]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29,null,null,null,"3 tonnes",false]
[null,null,null,30,null,null,null,"2 tonnes",false]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(I167=TRUE,AND(I166=FALSE,I167=FALSE)),2,3)","v":2},null,null," "]