{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Intro, Info & Instructions","Version Change Log","Submission Requirements","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":7,"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":"Intro, Info & Instructions","index":0,"n_rows":73,"n_cols":40,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,33],[49,2,52,31],[42,9,42,21],[38,2,40,31],[44,2,47,31],[2,1,4,33],[8,1,8,32],[10,1,10,32],[17,1,17,9],[23,1,23,32],[25,1,25,32],[12,1,12,32],[34,1,34,32],[27,1,27,9],[31,1,31,32],[63,1,63,32],[66,1,66,32],[68,1,68,9],[54,1,54,32],[57,1,57,32],[58,1,58,9]]}
["New Home Energy Checklists"]
[]
[null,"The pre-permit and pre-drywall checklists are for use by Energy Advisors to qualify and quantify that the energy efficiency measures indicated in the home design, and then confirm these measures as installed.  \n\nThe 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. \n\nFor permits after March 1st 2018, all homes including single family homes, laneway homes, townhouses, rowhouses, duplexes and Multi Family Residential buildings up to 3 storeys and under 600m2 will require this form to be submitted. \n\nSome 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 If you have any questions regarding the information requested on this form:\n\n"]
[]
[]
[null,null,null,"- Visit the ",null,null,"Energy for Low-Rise Homes page on the City of Vancouver website"]
[null,null,null,"- call the Enquiry Centre at 604-873-7611"]
[]
[null,"1.0 PRE PERMIT CHECKLIST"]
[]
[null,"For every new home in Vancouver, an Energy Advisor (EA) must complete a pre-permit checklist. The reason is to have an EA review the plans to check that all the energy components, including envelope, glazing and mechanical, all meet the Vancouver Building Bylaw, and will provide energy-efficient outcomes for the homeowner."]
[]
[null,"For projects with permits after March 1 2018, the form will be required for all new Part 9 buildings with building permits obtained after this date"]
[]
[null,"The latest R22 Effective Wall Guide can be found",null,null,null,null,null,null,null,null,null,null,null,"here"]
[]
[]
[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 must also 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 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 and properly as per manufacturers specifications. A blower door test must be completed and air sealing recommendations made. "]
[]
[null,"Submission Requirements"]
[]
[null,"An approved, completed mid-construction checklist is to be submitted to the City building official upon completion"]
[]
[null,"3.0 FINAL OCCUPANCY"]
[]
[null,"To obtain the occupancy permit, a final EnerGuide assessment of the home must be completed "]
[null,"Complete and submit a Homeowner Information Sheet (HOIS) with ACH and NLA (for laneway homes) blower door test results"]
[null,"Complete and submit an N-file to your Service Organization"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.0 REZONING CHECKLIST"]
[]
[null,"Project that undergo 'Rezoning' the process of City Council approving the change in zone of a site to accommodate a different"]
[null,"(typically more dense) building form, must meet additional energy requirements"]
[null,"Submission Requirements"]
[]
[null,"The 1-3 storey Rezoning Checklist must be completed for Rezoning Permit. And then again for Building Permit (the upgrades in the"]
[null,"Pre-permit checklist must match). Refer to the bulletin under \"Green Buildings Policy for Rezonings\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vancouver.ca/zero-emissions"]
[]
[null,"5.0 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,"1&2 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,"Submission Requirements"]
[]
[null,"Refer to the tabs at the end for instructions and the GHG Calculator Checklist. The completed checklist must be submitted"]
[null,"at Building Permit stage to confirm the design is compliant, and again the updated checklist to confirm the final constructed building"]
[null,"at final occupancy inspection"]

{"sheet":"Version Change Log","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"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","Yes, 2020 applications and earlier"]
[null,"1.2.1","November 2018","Formatting fixes, changed to 'mid construction checklist'","Yes, 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","Yes, 2020 applications and earlier"]
[null,"1.2.3","June 2019","Formatting fixes","Yes, 2020 applications and earlier"]
[null,"1.2.4.","October 2019","Formatting fixes","Yes, 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","Yes\n Applications after Jan 1st 2021 "]
[null,2.2999999999999998,"September 2021","Minor functionality fixes\nComments added back to GHG calculator (missing in previous version)","Yes\n Applications after Jan 1st 2021 "]

{"sheet":"Submission Requirements","index":2,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[53,1,53,5],[19,5,21,5],[32,3,37,3],[32,5,37,5],[5,1,5,3],[6,1,6,3],[9,4,11,4],[9,5,11,5],[19,3,21,3],[47,3,51,3],[47,2,51,2],[1,1,1,5],[2,1,2,5],[39,1,39,5],[4,1,4,5],[34,4,37,4],[19,2,21,2],[32,2,37,2]]}
[]
[null,"Air Tightness and Energy Documentation Requirements "]
[null,"for Residential 1-3 Storey Projects"]
[]
[null,"As of January 1st, 2015:  Airtightness requirements for 1&2 Family Dwellings of 3.5 ACH @ 50Pa\nAs of March 1st 2018: All residential buildings from 1-3 storeys residential must achieve airtightness targets through blower door testing\n"]
[null,"COV requested documentation"]
[null,"Air tightness requirements"]
[]
[null,null,"Rezoning Application\n(if applicable)","Building Permit","Mid-Construction","Final Occupancy"]
[null,"Coach and Laneway Homes ",null,"1 Pre-permit checklist (PPC)","Mid-construction checklist (MCC)","N-file HOIS form"]
[null,"(<1,200 sq.ft. floor area)","N/A","1 P-file"]
[]
[null,null,"N/A","State air tightness plan in PPC","Recommend ≤ 2.1 cm2/m2 NLA","≤ 2.1 cm2/m2 NLA"]
[null,"1&2 Family Dwellings:",null,"For each house w/ or w/o suite:","For each house w/ or w/o suite:"]
[null,"(with or without secondary suites)",null,"One PPC  + One P-file ","One Mid-Construction Checklist",null,null,null,null," "]
[null,null,null,null,"(e.g. 2 MCC’s for a duplex with suites)"]
[null,"Homes >325m2 must submit a GHG limit calculation","N/A","Example: 2 P-files and 2 PPC’s for a duplex + suites",null,"N-file HOIS submitted for each dwelling",null,null,null," ",null," "]
[null,null,null,">325m2 - Large Home calculator"]
[]
[null,null,"N/A","State air tightness plan in PPC","Each dwelling + suite tested ","Each dwelling + suite achieves ≤ 3.5 ACH @ 50Pa"]
[null,null,null,null," Required 3.5 ACH @ 50Pa "]
[]
[null,"Ground-oriented Townhouse, Rowhouse, Attached or Semi-attached ",null,"Modelled as single family homes","1 Mid-construction checklist (MCC) for all identical units / addresses.","1 N-file for every house"]
[null,null,null,"Each unit needs a P-file",null,"1 HOIS submitted for every house"]
[null,null,null,null,"Example: 20 unit townhouse"]
[null,null,"Complete the Rezoning Checklist (in tab)","1 Pre-permit checklist can be submitted for identical units / addresses","1 MCC for 18 identical middle units (include all unit/address #’s)",null,null,null,null,null," "]
[null,null,null,null,"1 MCC for one-side end unit"]
[null,null,null,"Example: 20 unit townhouse","1 MCC for other side end unit"]
[null,null,null,"·         20 P-files","Airtightness results provided as required below"]
[null,null,null,"·         1 PPC for 18 identical middle units"]
[null,null,null,"·         1 PPC for one-side end unit"]
[null,null,null,"·         1 PPC for other side end unit"]
[null,null,"N/A","State air tightness plan in PPC","Blower door can be completed after airtight drywall installed, if applicable.","Blower door test required for every house ≤ 3.5 ACH @ 50Pa"]
[null,null,null,null,"SAMPLING PROTOCOL"]
[null,null,null,null,"For multiple identical units, sampling protocol allows that only 3 units must be tested to confirm compliance for this unit type, unless the building official states otherwise."]
[]
[]
[]
[]
[null,"ERS version 15 – MURB Modelling\n\nUnder version 15 of the EnerGuide Rating System, MURB whole buildings or MURB single units may be evaluated and labelled. Depending on which approach is used, and the configuration of the building, it could be that one or multiple blower door tests will be performed. For the whole building, one label approach, if the entire building can be tested at once, such as when the multiple units have access to a common lobby, then it is possible that one test would suffice. \n\nA row of attached houses that are not stacked and that do not share a common space, then each house would be evaluated separately with its own blower door test and label issued.\n"]
[null,null,"Rezoning Permit\n(if applicable)","Building Permit","Mid-Construction","Final Occupancy"]
[null,"1-3 Storey MURBs",null,"YOU CHOOSE:","Whole building: 1 Mid construction checklist for whole building","Whole building: 1 HOIS and 1 N-file"]
[null,"Stacked townhouses","Complete the Rezoning Checklist (in tab)","Under version 15 of the EnerGuide Rating System, MURB whole buildings or MURB single units may be evaluated and labelled.","Each unit: 1 Mid-Construction Checklist for all identical units / addresses.","Each unit: 1 HOIS and 1 N-file for each unit"]
[null,"Stacked Triplex, Quadplex etc."]
[null,"(outright)",null,"EITHER:"]
[null,null,null,"Whole building: 1 P-file, 1 PPC"]
[null,null,null,"Each unit: 1 P-file and 1 PPC per unit"]
[null,null,"N/A","State air tightness plan","Whole building: ","Whole building: "]
[null,null,null,null,"Testing to be completed at the discretion of the project","2.03 L/s-m2 @ 75 Pa"]
[]
[null,null,null,null,"Each unit:"]
[null,null,null,null,"Testing to be completed at the discretion of the project","Every unit: ≤ 3.5 ACH @ 50Pa"]
[]
[null,"Tips for a Successful Air Tightness Test\n\nTo ensure a passed air tightness test, it is highly recommended to:\n1. Plan ahead: have a continuous air barrier strategy outlined at the design stage, including interior partition walls between two family dwellings\n2. On-site supervision: have a dedicated ‘air-tightness boss’ to provide oversight and ensure continuity is maintained\n3. Repair leaks at pre-drywall stage: while the minimum requirement to pass inspection at  mid-construction is 5.0 ACH (3.0 NLA), it is recommended to achieve <3.5 ACH (2.1 NLA), as repairing leaks is much less intrusive at this pre-drywall stage\n4. Take an airtightness course: learn how to design and install an effective air barrier in a hands-on class\n\nAir tightness courses\nTaking an airtightness course will help you understand the path to achieving the City VBBL requirements.  One day air-tightness courses are available through BCIT and Small Planet Supply\n\nRelaxations to meeting code will no longer be permitted through airtightness course participation. \n\nBC Housing Illustrated Guide\nThe most effective air barrier strategy may change depending on the envelope design, location and the penetrations and junctions.  Refer to the R22+ Effective Walls in Residential Construction in BC Guide for more guidance and illustrations.\n",null,null,null,null,null,null,null,null," "]
[null,"http://www.smallplanetsupply.com/vancouver-airtightness-1"]
[null,"R22+ Effective Walls in Residential Construction in BC Guide"]

{"sheet":"Pre Permit Checklist","index":3,"n_rows":133,"n_cols":45,"rows_kept":133,"cut":false,"hidden":false,"merged":[[6,11,6,15],[7,3,7,10],[7,11,7,15],[8,3,8,10],[8,11,8,15],[8,29,8,36],[8,37,8,38],[11,3,11,10],[11,11,11,15],[11,16,11,23],[11,24,11,27],[10,29,10,38],[6,29,6,38],[10,3,10,10],[10,11,10,15],[10,16,10,23],[7,16,7,23],[8,16,8,23],[9,16,9,23],[6,3,6,10],[7,24,7,27],[8,24,8,27],[9,24,9,27],[9,11,9,15],[33,35,33,38],[35,35,35,38],[34,35,34,38],[24,35,24,38],[111,11,111,15],[20,35,20,38],[17,3,17,38],[32,35,32,38],[22,35,22,38],[29,35,29,38],[30,35,30,38],[31,35,31,38],[28,35,28,38],[18,3,18,4],[23,35,23,38],[27,35,27,38],[26,35,26,38],[19,5,19,17],[19,18,19,31],[19,32,19,34],[20,5,20,17],[20,18,20,31],[20,32,20,34],[21,5,21,17],[2,0,4,1],[1,3,3,6],[1,36,1,38],[2,36,2,38],[3,36,3,38],[1,7,3,35],[4,3,4,38],[19,35,19,38],[25,35,25,38],[21,35,21,38],[18,35,18,38],[10,24,10,27],[7,37,7,38],[7,29,7,36],[6,16,6,23],[18,5,18,17],[18,18,18,31],[18,32,18,34],[19,3,26,4],[21,18,21,31],[11,29,11,38],[9,29,9,38],[9,3,9,10],[6,24,6,27],[21,32,21,34],[22,5,22,17],[22,18,22,31],[22,32,22,34],[23,5,23,17],[23,18,23,31],[23,32,23,34],[24,5,24,17],[24,18,24,31],[24,32,24,34],[27,3,29,4],[27,5,27,17],[27,18,27,31],[27,32,27,34],[28,5,28,17],[28,18,28,31],[28,32,28,34],[29,5,29,17],[29,18,29,31],[29,32,29,34],[26,32,26,34],[31,32,31,34],[32,5,32,17],[32,18,32,31],[32,32,32,34],[33,5,33,17],[33,18,33,31],[33,32,33,34],[34,5,34,17],[34,18,34,31],[34,32,34,34],[48,29,48,38],[40,3,40,8],[40,9,40,16],[40,17,40,20],[41,3,41,8],[41,9,41,16],[41,17,41,20],[41,21,41,26],[41,32,41,37],[40,21,40,37],[15,10,15,18],[15,25,15,37],[5,3,5,38],[43,9,44,20],[43,29,43,38],[44,29,44,38],[46,9,46,20],[46,21,47,28],[46,29,47,38],[30,3,35,4],[30,5,30,17],[30,18,30,31],[30,32,30,34],[31,5,31,17],[31,18,31,31],[35,5,35,17],[35,18,35,31],[35,32,35,34],[25,5,25,17],[25,18,25,31],[25,32,25,34],[26,5,26,17],[26,18,26,23],[26,24,26,31]]}
[]
[null,null,null,null,null,null,null,"PRE-PERMIT ENERGY 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,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,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01"]
[null,null,null,"This form is to confirm the Vancouver Building Bylaw energy requirements for buildings permitted to use the EnerGuide Rating System. This form is to be completed, signed and submitted at permit application stage by an Energy Advisor (EA). One form can represent 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,null,null," "]
[null,null,null,"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,"Address(es) / Unit # ",null,null,null,null,null,null,null,"Floor Area (m2)",null,null,null,null,"Unit & Model type (dropdown)",null,null,null,null,null,null,null,"P File #",null,null,null,null,"Additional Criteria"]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reconstruction of existing",null,null,null,null,null,null,null,null,null,null,null," "]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed Rezoning",null,null,null,null,null,null,null,null,null," ",null," ",null,null," "]
[null," ",null,null,null,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(AL8=\"Y\",\"Home upgraded to current energy code\",\" \")","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,{"$f":"IF(AL9=\"Y\",\"Attach rezoning checklist\",\" \")","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,{"$f":"IF(AND(OR(Q9=E106,Q10=E106,Q11=E106,Q12=E106,Q8=E106),OR(L8>325,L9>325,L10>325,L11>325,L12>325),AND(AO115=FALSE,AO116=FALSE,AO117=FALSE)),\"GHG Limit calculation required\",\" \")","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," "]
[null,"->",null,null,"Building energy standard: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 model & version: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Additional information:"]
[null," "]
[null,null,null,"Upgrade Summary Table"]
[null,"->",null,null,null,"EA Verification Guidelines for Building Plans",null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Specification\n(assembly, system, fuel type, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"R/USI or\nEfficiency ",null,null,"EA Verified\n(dropdown)",null,null,null," "]
[null," ",null,"Insulation and Air Barrier",null,"1.1 Exterior above-grade walls & floor headers\nMinimum R22 eff. (RSI 3.85)"]
[null,null,null,null,null,"1.2 Below-grade walls\nMinimum 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,null,null,"1.3 Flat attic\nMinimum 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,null,null,null,null,null," "]
[null,"->",null,null,null,"1.4 Flat, vaulted and cathedral roofs\nR30 eff. (RSI 5.28), 1&2 Family + LWH: R24 eff. (RSI 4.3)"]
[null,null,null,null,null,"1.5 Under foundation slab \nMinimum R14 eff. (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,null,null,null,null,null,null," "]
[null,null,null,null,null,"1.6 Exposed floors\nMinimum R24 eff. (RSI 4.2)"]
[null,null,null,null,null,"1.7 Balconies, eyebrows, and exposed slab edge\nThermal break meets R2.4 eff. (RSI 0.42)"]
[null,null,null,null,null,"1.8 Air barrier \nContinuous air barrier design to meet specified target",null,null,null,null,null,null,null,null,null,null,null,null,"*select primary air barrier*"]
[null,"->",null,"Fenestration",null,"2.1 Side-hinged doors\nAside from front entry door, USI 1.8 or lower"]
[null,null,null,null,null,"2.2 Windows, curtainwalls and glazed doors\nUSI 1.4 or lower"]
[null,null,null,null,null,"2.3 Skylights and roof hatches \nSkylights USI 2.4 or lower. Roof hatches USI 2.9 or lower  "]
[null,"->",null,"Mechanical",null,"3.1 Ventilation \nHRV - 65% SRE @ 0 deg C (on continuous mode or better)."]
[null,null,null,null,null,"3.2 Heating systems: \nFurnace/boiler: minimum 92% AFUE, no side venting. \nIndicate backup / secondary systems"]
[null,null,null,null,null,"3.3 Fireplaces\nDirect vent electronic ignition and timer (outdoor: electric or match). Indicate total number of units"]
[null,null,null,null,null,"3.4 Domestic hot water\nEnergy Factor (UEF or EF) ≥ 0.78 \nor thermal efficiency (TE) ≥ 90% "]
[null,null,null,null,null,"3.5 Recirculating system\nPiping wrapped with pipe insulation R2 (RSI 0.35)"]
[null,null,null,null,null,"3.6 Solar chase\n2x >50mm PVC or 2x 25mm conduit to rooftop or attic"]
[null,null,null,null,null,"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,"• (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,"Company / S.O.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Email address: ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone #:",null,null,null,null,null,null,null,null,null," Business License #: ",null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Builder company & contact"]
[null,null,null,"  Signature:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Builder #: "]
[]
[null,null,null,"  Date: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Builder Signature:"]
[]
[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,"  Review 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,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,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  ò"]
["1102:133",null,null,null,"MURB - whole building"]
[null,null,null,null,"MURB - per unit"]
[]
[null,null,null,null,"Laneway House"]
[null,null,null,null,"1&2 Family"]
[null,null,null,null,"Ground-oriented unit (other)",null,null,null,null,null,null,null,null,null,null,"One P-file for each ancillary dwelling unit such as a laneway, infill or coach house"]
[null,null,null,null,"Stacked MURB (per unit)",null,null,null,null,null,null,null,null,null,null,"One P-file and one checklist for each dwelling with or without a secondary suite"]
[null,null,null,null,"Stacked MURB (whole building)",null,null,null,null,null,null,null,null,null,null,"Each unit must receive a unique P-file, energy model and checklist. Units with identical specifications can be represented by a single checklist. Add more rows as needed."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The entire building receives one P-file and model. This checklist represents the single project address and one P-file"]
[]
[null,null,null,null,"X"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHBA",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ILFI",false]
[null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,"Interior - airtight drywall"]
[null,null,null,null,"Passive House project",null,null,null,null,null,null,null,null,null,null,"Interior - spray foam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exterior - sealed membrane"]
[null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,"Exterior - taped sheathing"]
[null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,"Exterior - sealed insulation"]
[null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,"Other "]
[null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,5]
[null,null,null,null,6]
[null,null,null,null,7]
[null,null,null,null,8]
[null,null,null,null,9]
[null,null,null,null,10]
[null,null,null,null,"-"]
[null,null,null,null,"Y"]
[null,null,null,null,"N"]

{"sheet":"Mid Construction Checklist","index":4,"n_rows":180,"n_cols":44,"rows_kept":180,"cut":false,"hidden":false,"merged":[[142,27,142,28],[143,3,143,4],[5,3,5,34],[59,3,59,34],[141,3,141,7],[142,6,142,7],[142,9,142,14],[142,16,142,17],[142,19,142,25],[108,26,108,34],[109,26,109,34],[91,16,92,22],[113,10,113,19],[111,10,112,19],[102,3,102,34],[111,26,112,34],[108,10,108,19],[109,10,109,19],[110,10,110,19],[91,4,92,7],[91,8,91,12],[40,21,42,24],[43,10,45,20],[43,21,45,24],[2,0,4,1],[2,32,2,34],[3,32,3,34],[4,3,4,34],[89,4,89,14],[46,3,48,9],[46,25,48,34],[49,25,51,34],[46,10,48,20],[46,21,48,24],[13,3,13,34],[20,25,22,34],[10,3,10,34],[11,25,12,34],[1,3,3,6],[1,7,3,31],[1,32,1,34],[29,3,29,34],[26,3,28,9],[30,3,32,9],[20,3,22,9],[23,3,25,9],[14,3,16,9],[17,3,19,9],[33,3,35,9],[36,3,38,9],[33,10,35,20],[33,21,35,24],[36,10,38,20],[36,21,38,24],[89,15,89,23],[89,24,89,33],[14,25,16,34],[17,25,19,34],[55,25,57,34],[26,10,28,20],[26,21,28,24],[30,10,32,20],[30,21,32,24],[23,25,25,34],[26,25,28,34],[30,25,32,34],[33,25,35,34],[36,25,38,34],[99,4,100,33],[55,3,57,9],[7,9,7,16],[8,9,8,16],[7,23,7,32],[93,8,93,11],[93,25,94,33],[91,25,91,32],[49,3,51,9],[52,3,54,9],[49,10,51,20],[49,21,51,24],[52,10,54,20],[52,21,54,24],[39,3,39,34],[40,3,42,9],[43,3,45,9],[40,25,42,34],[43,25,45,34],[40,10,42,20],[55,10,57,20],[55,21,57,24],[11,3,12,9],[52,25,54,34],[95,25,96,33],[11,21,12,24],[11,10,12,20],[14,10,16,20],[14,21,16,24],[17,10,19,20],[17,21,19,24],[20,10,22,20],[20,21,22,24],[23,10,25,20],[23,21,25,24]]}
[]
[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,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,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01"]
[null,null,null,"This checklist is to confirm energy components are properly installed and consistent with building plans. It is completed by an Energy Advisor 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,"Project Address:",null,null,null,null,null,null,null,null,null,null,null,null,"   Unit #'s (if applicable):",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 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,null,null,null,null,null,null,null,null,null,null," "]
[null,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\nMinimum R22 effective"]
[]
[]
[null,null,null,"BELOW-GRADE /  FOUNDATION WALLS\nMinimum R22 effective"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\nMinimum R24 effective"]
[]
[]
[null,null,null,"ROOF & ATTIC\nAttic: R48 eff., Ceiling: R30 eff (R24 eff. 1&2 Family)"]
[]
[]
[null,null,null,"BALCONIES & EXPOSED SLAB EDGE\nThermal break R 2.4 eff."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[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\nUSI ≤ 1.44 W / m2K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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\nUSI ≤ 1.84 W / m2K \nexcept primary front door"]
[]
[]
[null,null,null,"SKYLIGHTS & SLOPED GLAZING\nSkylights USI ≤ 2.4 W / m2K\nRoof hatch USI ≤ 2.9"]
[]
[]
[null,null,null,"Mechanical Systems",null,null,null,null,null,null,null,null,null,null,null,null,null,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\nDirect vent, electronic ignition"]
[]
[]
[null,null,null,"SPACE CONDITIONING \n(Heating & Cooling)\n92% AFUE gas systems"]
[]
[]
[null,null,null,"DOMESTIC HOT WATER\nEF / UEF ≥ 78%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,"VENTILATION\nHRV - 65% SRE @ 0 deg C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"SOLAR CHASE\n2x >50mm PVC or 2x 25mm conduit to rooftop or attic"]
[]
[]
[null,null,null,"OTHER \nENERGY MEASURES"]
[]
[]
[]
[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,"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: target 3.5 ACH @ 50Pa or 2.1 NLA for small units. Sampling permitted for multi-unit (see note)",null,null,null,null,null,null,null,null,null,null,null,null,null,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): target 2.0 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,"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,null,"Pa",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,"4. Contact Information and 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 EA and/or team that created the original energy model for the Building Permit"]
[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,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"]

{"sheet":"As-Built Checklist","index":5,"n_rows":130,"n_cols":49,"rows_kept":130,"cut":false,"hidden":false,"merged":[[2,0,4,1],[2,32,2,34],[3,32,3,34],[4,3,4,34],[5,3,5,34],[1,3,3,6],[1,7,3,31],[1,32,1,34],[8,15,8,23],[20,25,22,34],[18,3,18,34],[19,3,19,9],[19,10,19,20],[19,21,19,24],[19,25,19,34],[20,3,22,9],[20,10,22,20],[92,19,92,25],[23,25,25,34],[26,3,28,9],[26,10,28,20],[26,21,28,24],[26,25,28,34],[45,16,46,22],[45,25,45,32],[29,3,29,34],[92,27,92,28],[59,26,59,33],[61,26,62,33],[93,3,93,4],[91,3,91,7],[92,6,92,7],[92,9,92,14],[92,16,92,17],[43,4,43,14],[45,4,46,7],[45,8,45,12],[11,21,11,33],[7,24,7,30],[8,24,8,30],[43,15,43,23],[43,24,43,33],[20,21,22,24],[7,6,7,14],[8,6,8,14],[23,3,25,9],[23,10,25,20],[23,21,25,24],[14,21,15,33],[7,15,7,23],[59,9,59,19],[60,9,60,19],[61,9,62,19],[63,9,63,19],[47,25,48,33],[53,4,53,33],[55,3,55,34],[58,26,58,33],[47,8,47,11],[58,9,58,19]]}
[]
[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,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,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01"]
[null,null,null,"This checklist is to confirm energy components are properly installed and consistent with building plans. It is completed by an Energy Advisor and 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 # ",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,"Building energy standard: ",null,null,null,null,null,null,null,"Other project checklists",null,null,null,null,null,null,null,null,"Energy model & version: "]
[null,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,"Additional notes"]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "]
[null,"->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,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,"SPACE CONDITIONING \n(Heating & Cooling)\n92% AFUE gas systems",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "]
[]
[]
[null,null,null,"DOMESTIC HOT WATER\nEF / UEF ≥ 78%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,"VENTILATION\nHRV - 65% SRE @ 0 deg C\nPrimary dwelling & suite(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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: 3.5 ACH @ 50Pa or 2.1 NLA for small units.",null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,"Pa",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,"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 ",null,null,null,null,null,null,null,null,null,null,null," "]
[null,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 and Authorization"]
[null,null,null,null,"By signing, I certify that the as-built building conforms to the energy model and plans submitted for the Building Permit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"  EA (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,"1&2 Family"]
[null,null,null,null,"Ground-oriented unit (other)"]
[null,null,null,null,"Stacked MURB (per unit)"]
[null,null,null,null,"Stacked MURB (whole building)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[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"]

{"sheet":"GHG Calculator FAQ","index":6,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,2,41,14],[24,2,24,14],[30,2,30,14],[32,2,32,14],[34,2,34,14],[37,2,37,14]]}
[]
[null,null,"Frequently Asked Questions"]
[null,null,"Large Homes Greenhouse Gas Calculator"]
[]
[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 or hourly software model must be "]
[null,null,"completed, and the calculator filled out to demonstrate compliance. "]
[]
[null,null,"Certified Passive House Projects and entirely 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 325 m2 threshold can be triggered if either of the following two calculations results in 325 m2:"]
[]
[null,null,"         ●  The Energy Advisor's conditioned interior space calculation used in HOT2000 is ≥325m2, or\n         ● The architect / designer's proposed floor area calculation on the drawings is ≥325 m2"]
[]
[null,null,"EXAMPLE: A new building permit application for a single family dwelling with a laneway house and pool cabana.\n\nPrincipal Dwelling: The Energy Advisor calculates 318 m2 for the single family dwelling, but the architect calculates 329 m2. The calculator must be completed.\n\nTo complete the calculator, all conditioned, habited spaces on the property must be modelled. The energy use of the laneway house and pool 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. \n\nCertain items such as cooktops, ice melt systems and outdoor fireplace BTU ratings are not typically known for 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":7,"n_rows":168,"n_cols":20,"rows_kept":168,"cut":false,"hidden":false,"merged":[[62,12,62,13],[70,4,70,6],[70,7,70,10],[73,2,73,6],[66,4,66,6],[66,9,66,10],[67,4,67,6],[67,9,67,10],[68,4,68,6],[68,9,68,10],[48,12,48,13],[63,12,63,13],[65,4,65,10],[50,1,50,6],[50,12,50,13],[51,1,51,6],[51,12,51,13],[52,1,52,6],[52,12,52,13],[53,1,53,6],[53,12,53,13],[54,1,54,6],[54,12,54,13],[55,1,55,6],[55,12,55,13],[57,2,57,6],[58,2,58,6],[59,1,59,6],[59,12,59,13],[60,1,60,6],[60,12,60,13],[61,1,61,6],[61,12,61,13],[62,1,62,6],[36,12,36,13],[37,1,37,6],[37,7,37,13],[38,1,38,6],[38,12,38,13],[49,1,49,6],[49,12,49,13],[40,1,40,6],[40,12,40,13],[41,1,41,6],[41,7,41,13],[42,1,42,6],[42,12,42,13],[43,1,43,6],[43,7,43,13],[44,1,44,6],[44,12,44,13],[45,1,45,6],[45,12,45,13],[46,1,46,6],[46,12,46,13],[47,1,47,6],[47,12,47,13],[48,1,48,6],[23,12,23,13],[24,1,24,6],[24,7,24,13],[25,1,25,6],[25,12,25,13],[39,1,39,6],[39,12,39,13],[27,1,27,6],[27,12,27,13],[28,1,28,6],[28,7,28,13],[29,1,29,6],[29,12,29,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],[33,1,33,6],[33,7,33,13],[34,1,34,6],[34,12,34,13],[36,1,36,6],[17,16,17,28],[18,1,18,8],[18,12,18,13],[19,1,19,8],[19,12,19,13],[19,16,19,28],[8,1,8,3],[8,4,8,8],[8,10,8,13],[9,1,9,3],[9,4,9,5],[9,7,9,8],[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],[14,1,14,3],[14,5,14,8],[14,9,14,13],[15,1,15,3],[15,5,15,8],[35,12,35,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],[6,1,6,3],[6,4,6,8],[6,12,6,13],[26,1,26,6],[26,12,26,13],[15,9,15,13],[17,1,17,13],[20,1,20,8],[20,12,20,13],[21,9,21,11],[21,12,21,13],[23,1,23,6]]}
[]
[null,null,null,null,"GHG EMISSIONS CALCULATOR FOR LARGE HOMES",null,null,null,null,null,null,null,"Version 2.3"]
[null,null,null,null,"One and Two Family Dwellings over 325 square meters",null,null,null,null,null,null,null,"Sept 2021"]
[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. \nIt is submitted at Building Permit application to demonstrate compliance with the applicable carbon limit. The form (with revisions) is also submitted at final occupancy inspection."]
[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 Standard",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 Fireplaces (Gas)"]
[null,"Indoor Fireplace (>60 % Efficiency)",null,null,null,null,null,null,null,2,"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,null,null,null,null," "," "]
[null,"Indoor Fireplace (≤60 % Efficiency)",null,null,null,null,null,null,null,3,"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,"Rough-in",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,"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(K30=\"Natural Gas\",$G$138,IF(K30=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H30*J30*L30/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(K31=\"Natural Gas\",$G$138,IF(K31=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H31*J31*L31/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(K32=\"Natural Gas\",$G$138,IF(K32=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H32*J32*L32/1000","v":0}]
[null,"Rough-in",null,null,null,null,null,null,null,6,"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,"Outdoor Heaters & Grills"]
[null,"Plumbed Space or Decorative Space Heaters",null,null,null,null,null,null,null,6,"Natural Gas",{"$f":"IF(K35=\"Natural Gas\",$G$138,IF(K35=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H35*J35*L35/1000","v":0},null,null,null," "," "]
[null,null,null,null,null,null,"Plumbed BBQ's and Grills",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,"Rough-in",null,null,null,null,null,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,"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(I39=0,0,2.9114*I39-1.0587)","v":0},"Natural Gas",{"$f":"IF(K39=\"Natural Gas\",$G$138,IF(K39=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"H39*J39*L39/1000","v":0},null,null," "]
[null,"Indoor Pool (Natural Gas Heater, Area in m2)",null,null,null,null,null,null,null,{"$f":"IF(I40=0,0,1.3617*I40-0.296)","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," "]
[null,"Indoor or Outdoor Hot Tub",null,null,null,null,null,null,null,11,null,{"$f":"IF(K41=\"Natural Gas\",$G$138,IF(K41=\"Electricity\",$G$137,))","v":0},{"$f":"H41*((3*G137)+(8*L41))/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(K43=\"Natural Gas\",$G$138,IF(K43=\"Electricity\",$G$137,))","v":0},{"$f":"H43*J43*L43/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(K46=\"Natural Gas\",$G$138,IF(K46=\"Electricity\",$G$137,))","v":3.0555799999999995},{"$f":"J46*L46/1000","v":0},null,null,null,null," "]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"IF(K47=\"Natural Gas\",$G$138,IF(K47=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"J47*L47/1000","v":0}]
[null,"Laneway House"]
[null,"Modelled Electricity Consumption",null,null,null,null,null,null,null,null,"Electricity",{"$f":"IF(K49=\"Natural Gas\",$G$138,IF(K49=\"Electricity\",$G$137,))","v":3.0555799999999995},{"$f":"J49*L49/1000","v":0}]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"IF(K50=\"Natural Gas\",$G$138,IF(K50=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"J50*L50/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(K52=\"Natural Gas\",$G$138,IF(K52=\"Electricity\",$G$137,))","v":3.0555799999999995},{"$f":"J52*L52/1000","v":0},null,null," "]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"IF(K53=\"Natural Gas\",$G$138,IF(K53=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"J53*L53/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(K55=\"Natural Gas\",$G$138,IF(K55=\"Electricity\",$G$137,))","v":3.0555799999999995},{"$f":"J55*L55/1000","v":0}]
[null,"Modelled Natural Gas Consumption",null,null,null,null,null,null,null,null,"Natural Gas",{"$f":"IF(K56=\"Natural Gas\",$G$138,IF(K56=\"Electricity\",$G$137,))","v":51.388930000000002},{"$f":"J56*L56/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*I58","v":0},null,{"$f":"IF(K58=\"Natural Gas\",#REF!,IF(K58=\"Electricity\",#REF!,))","v":0},{"$f":"H58*J58*L58/1000","v":0}]
[null,null,"De-Icing Cable (Length in m)",null,null,null,null,null,null,{"$f":"0.04*I59","v":0},null,{"$f":"IF(K59=\"Natural Gas\",#REF!,IF(K59=\"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(K60=\"Natural Gas\",$G$138,IF(K60=\"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*I61","v":0},null,{"$f":"IF(K61=\"Natural Gas\",$G$138,IF(K61=\"Electricity\",$G$137,))","v":0},0]
[null,"De-Icing Cable (Length in m)",null,null,null,null,null,null,null,{"$f":"0.04*I62","v":0},null,{"$f":"IF(K62=\"Natural Gas\",$G$138,IF(K62=\"Electricity\",$G$137,))","v":0},0]
[null,"Other",null,null,null,null,null,null,null,null,null,{"$f":"IF(K63=\"Natural Gas\",$G$138,IF(K63=\"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:M63)","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":"M64","v":0},"tCO2e"]
[null,null,null,null,"Total",null,null,{"$f":"H67+H68","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(H69<I168,\"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",true]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(I167=TRUE,AND(I166=FALSE,I167=FALSE)),2,3)","v":2},null,null," "]