{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Notes","Instructions","BaselineParameters","REFERENCE","1- pre screen","2- Proposal","3- Study Inputs","4- Study Results","5- Incremental Costs","Summary","6- Baseline Hourly Results","7- Proposed Hourly Results","Prescreening Review","Proposal Review","Study Review","Financial Model inputs"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":16,"comments":7,"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":"Notes","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,"Concept design (LCE Baseline) energy model does not change from pre-screening going forward to proposal and study submission."]
[null,"Pre-screen to be submitted before kick off meeting and after doing the concept design modelling"]
[null,"Fill the pre-screening sheet for each building where there is good potential for electrification."]
[null,"Proposal to be submitted after kick off meeting"]
[]
[]
[null,"A clear EM is a measure that saves GHG and increases electricity."]
[null,"All ECMs (gas and/or electric) or EMs all must be included in final proposed bundle model."]
[null,"Electric ECMs (saving only electricity) will not be modelled separately. GHG, energy, costing impacts of these ECMs must be equaly included in both baseline and porposed models."]
[null,"Non-fuel-switching gas saving measures (e.g. low flow fixtures, condensing boilers, etc.) should not be modelled separately. They are to be included in EM models and bundle model."]
[null,"GHG-saving measures that save electicity and gas (e.g. building envelope, DCV)  will not be modelled as separate measures. Their GHG impact to be included in final proposed bundle model."]
[]
["BaselineParameters","When government publish new parameters, the data in this sheet is to be updated (especially for hotels and offices). MH to give us new parameters."]
[]
["Alan to help on the following items:"]
["All sheets","Printing formating to be fixed to allow proper printing of all content."]
[null,"Final check and make workbook appearance like the efficiency BC workbook."]
[null,"Add logos at the bottom right corner of each sheet (or as footer)."]
[]
[]
[null,"Lock all sheets"]
[]
[null,"Hide Notes sheet"]

{"sheet":"Instructions","index":1,"n_rows":68,"n_cols":3,"rows_kept":68,"cut":false,"hidden":false,"merged":[[54,0,54,12],[32,0,32,12],[35,0,35,12],[20,0,20,11],[50,0,50,12],[46,0,46,12],[37,0,37,12],[42,0,42,12],[44,0,44,12],[39,0,39,12],[28,0,28,12],[5,0,5,12],[8,1,8,12],[9,1,9,12],[10,1,10,12],[24,0,24,12],[17,2,17,12],[18,2,18,12]]}
["CleanBC New Construction Incentives"]
["Energy Modeling Study Proposal and Report Workbook"]
[]
["Introduction"]
[]
["This workbook has been developed for the CleanBC New Construction Incentives (the Program) to standardize the energy modeling study reporting format and provide consultants performing the work the  minimum inputs/results information required for the technical review and proposal/study approval process. This workbook is to be completed as part of the requirements for energy study funding under the Program and it has to be submitted to BC Hydro in its original electronic format. \n\nAt the project eligibility assessment stage, this workbook (with Pre-Screen worksheet filled out) is to be submitted along with associated preliminary calculations / estimates that support the electrical load growth and fuel offset claims. The data provided will be evaluated by the Program's engineering team and, if accepted, the project will proceed to project application stage.\n\nAt the project application stage, this workbook (with Proposal worksheet filled out) is to be submitted along with project application and consultants' proposal(s). The consultant's proposal(s) do not need to contain project technical details, but just  a reference to this workbook (Proposal worksheet tab). Information provided in this workbook need not be duplicated in the Consultants' proposal(s).  \n\nAt the study report submission stage, this workbook is the only document required by BC Hydro for review. Consultants are welcome to organize and present study results to the customer in a different format. If required, consultants are also welcome to add additional worksheets to the end of this workbook with additional calculations and project details.\n\nThe workbook has been formatted to minimize re-entering data and shall be filled out in the following order:"]
[]
["Worksheet tab color-coding conventions"]
[null,"Black worksheets are input worksheets. "]
[null,"White worksheets are filled automatically."]
[null,"Green worksheets are instructions/reference worksheets and it shall be edited only by BC Hydro."]
[null,"Grey worksheets are project review worksheets."]
[]
["Cell color-coding conventions"]
[]
[null,null,"White, bordered cells for user inputs"]
[null,null,"Colored cells are filled automatically."]
[null,null,"Grey cells in Study Inputs worksheet contain information carried over from Proposal worksheet. They can be updated to reflect changes from Proposal stage."]
[null,null,"Yellow cells indicate change in user's input "]
[]
["Important Note: Many user input cells have drop-down menus that must be used."]
[]
["Project Eligibility Screening (Pre-Screen) Worksheet Tab"]
[]
["The mandatory project application requirement for the Program is an already completed concept design energy model. This model should already have confirmed the project's code compliance, analyzed energy efficiency measures and should provide the most cost effective concept design for the project. The concept modeling cost is not eligible for the Program's modeling funding. The project is eligible for application if the concept design heating plant/systems could be further optimized (electrified) during the detailed design phase. The detailed design modeling update costs related to the electrification measures are eligible for the Program's modeling funding.\nAt project eligibility assessment stage, the workbook (with Pre-Screen worksheet filled out) is to be submitted along with associated preliminary calculations / estimates that support the electrical energy consumption increase and fuel offset claims. The data provided will be evaluated by the Program's engineering team and, if accepted, the project will proceed to application stage.\n The Program's engineer will use this worksheet to review the proposed electrification baseline (concept design model data), proposed electrification measures' electricity consumption growth / fuel offset data and associated costs. It is essential that the project consultant fill out all applicable fields to the best of his/her ability and knowledge as these data will be evaluated from both technical and cost effectiveness prospective and will directly influence acceptance of the project. Multi-type building projects shall have inputs broken down by building type.\n\n\n"]
[]
["Proposal Worksheet Tab"]
[]
["At the project application stage, this workbook (with completed Proposal worksheet) is to be submitted along with the project application and consultants proposal(s). The consultant's proposal(s) do not need to contain project technical details, but rather  a reference to this workbook (Proposal worksheet tab). Technical information provided in this workbook does not need to be duplicated in Consultants' proposal(s). \nThe Program's engineer will use this worksheet to review the proposed modeling study scope and costs. The modeling consultant shall fill out all applicable fields to the best of their ability and knowledge. Multitype building projects shall have inputs broken down by building type. \nThe project's concept model will represent the Program electrification baseline regardless of the referenced energy efficiency standard. Please refer to the Program's Energy Modeling Guideline for more details about the baseline, the updated model and other modeling requirements. Electrification measures (EMs) have to be listed in tables.\n"]
[]
["Study Inputs Worksheet Tab"]
[]
["This worksheet tab has to be updated at the study report submission stage. \nDuring the detailed design and modeling stage, modeling inputs agreed upon at the proposal stage may change and this worksheet should capture all those changes. Edited cells will be automatically highlighted in yellow to give an indication to both the modeller and reviewer that assumptions/inputs have been changed from the proposal stage. \nAny additional modeling process details/descriptions shall be added at the bottom of the worksheet. Where applicable, consultants may be required to add additional worksheets to the end of this workbook with additional calculations and project details. \n"]
["Study Results Worksheet Tab"]
[]
["This worksheet tab is the central location for all simulation results (baseline, EMs and proposed bundle) and associated costing information. If this worksheet is properly completed, the workbook Summary worksheets will be automatically populated without any errors. At the same time, modelled EMs names will be automatically added in the Incremental Costs worksheet. "]
["Electrification Measure (EM) Name"]
["For each EM, enter a clear and descriptive name. \nChoose one of the standard EM types from the drop down menu.\nIn case one EM includes other measures (e.g. radiant heating with proposed building envelope), then select a standard EM type for the dominant EM."]
["Life Expectancy"]
["The expected life of the measure will be automatically populated once the standard BC Hydro EM type name is selected from the drop-down menu. "]
[]
["Annual Savings"]
["For each measure, enter the electric load growth and fuel savings in the appropriate units. For kW, enter the electricity average monthly peak demand increase. For natural gas enter GJ, for other fuels enter L of fuel. Enter the combined energy cost savings for both electricity and fuel, accounting for actual rate structures and applicable taxes (except GST). Enter the annual maintenance savings or additional costs (negative saving) in dollars. If the maintenance costs vary through the life of the measure, use an average value. "]
["Operation and Maintenance Annual Saving/Cost ($ )"]
["Enter proposed operation and maintenance cost saving (or penalty) of the measure."]
["Bundle"]
["The Bundle column is intended to evaluate the combined impact of a bundle of measures. Indicate which measures are in the bundle by using the drop-down menu (row 52) in the Measures table. All efficiency and electrification interactions between measures shall be captured in bundle simulation run. Likewise, any cost interactions should be accounted for. For bundle life expectancy, use a weighted average of the individual measure life expectancies and their energy consumptions. "]
[]
["Incremental Costs Worksheet Tab"]
[]
["This worksheet tab is for cost consultants and/or qualified contractors in charge for cost estimates. This worksheet will automatically get EM names of modelled measures from the Study Results Worksheet. The Energy modeller has to add other EMs details required for the cost consultant to fill out the costing information (areas, equipment sizes etc.). Alternatively, the cost consultant can submit the costing information in their own preferred format, and the modeling consultant shall then copy over those numbers to this worksheet in the study report workbook."]
[]
["Baseline and Proposed Models' Hourly Results Worksheet Tabs"]
[]
["The hourly simulation results (8760 hours) from the simulation program for both baseline and proposed models shall be copied into these worksheet tabs. Results in this worksheet to show total building electricity and gas separately."]
[]
[]
["Further Important Notes"]
[]
["Projects with Multiple Building Types"]
["Different building types must have separate meters for electricity and gas where applicable."]
["Energy consumption from individual meters is to be used to fill these two tables."]
[]
["Multiple Bundles"]
["For each non-approved Bundle, input results as one EM in tab \"Study Results\", and select \"No\" in row # 52."]
[]
["Exhaust air heat recovery"]
["If Baseline HVAC is mixed air system, this EM should be modelled with Proposed HVAC (not Baseline HVAC)."]

{"sheet":"BaselineParameters","index":2,"n_rows":85,"n_cols":10,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Building Type","Location","ASHRAE Climate Zone","Step","Design Infiltration Rate (m3/s/m2 envelope area)","HRV Effectiveness","TEDI (kWh/m2)","GHG (kgCO2/m2)","Enevelope Surface Heat Loss (Opaque + Window), W/m2","Infiltration Heat Loss, W/m2"]
["MURB","Vancouver","Climate Zone 4","Step Code 1",2.5000000000000001E-4,"None",62.220884359999999,11.07634271,27.796003898635476,5.9468591617933715]
["MURB","Vancouver","Climate Zone 4","Step Code 2",2.5000000000000001E-4,0.6,40.623692599999998,6.1632938939999997,27.814780701754387,4.8217334307992203]
["MURB","Vancouver","Climate Zone 4","Step Code 3",1E-4,0.6,28.232626230000001,6.0027645400000003,23.474563840155948,1.9476659356725143]
["MURB","Vancouver","Climate Zone 4","Step Code 4",1.0000000000000001E-5,0.6,14.24695766,5.790910888,15.972102826510721,0.16824015594541911]
["MURB","Kamloops","Climate Zone 5","Step Code 1",2.5000000000000001E-4,"None",74.511951280000005,12.119135,44.245338693957109,8.4671710526315795]
["MURB","Kamloops","Climate Zone 5","Step Code 2",2.5000000000000001E-4,0.6,44.076813440000002,6.2651899000000002,37.761776315789476,6.7253299220272895]
["MURB","Kamloops","Climate Zone 5","Step Code 3",1E-4,0.6,29.87712938,6.0803965819999997,34.550601851851845,2.7076734892787524]
["MURB","Kamloops","Climate Zone 5","Step Code 4",1.0000000000000001E-5,0.8,14.77145335,5.8530522139999999,23.01348440545809,0.23064127680311888]
["MURB","Prince George","Climate Zone 6","Step Code 1",2.5000000000000001E-4,"None",83.202311030000004,14.14945065,34.753715886939574,5.234348927875244]
["MURB","Prince George","Climate Zone 6","Step Code 2",2.5000000000000001E-4,0.6,40.463518489999998,6.3337699470000004,29.228481968810922,3.6083971734892786]
["MURB","Prince George","Climate Zone 6","Step Code 3",1E-4,0.6,29.592141009999999,6.1868416450000003,24.847763157894736,1.4470748050682261]
["MURB","Prince George","Climate Zone 6","Step Code 4",1.0000000000000001E-5,0.8,14.68612925,5.9340950030000004,13.601464424951267,0.14496310916179336]
["MURB","Fort St. John","Climate Zone 7","Step Code 1",2.5000000000000001E-4,0.6,81.466646519999998,6.9300481759999997,36.467261208576993,9.8694590643274847]
["MURB","Fort St. John","Climate Zone 7","Step Code 2",2.5000000000000001E-4,0.8,43.959113209999998,6.4158848129999999,22.706725146198831,9.8695370370370359]
["MURB","Fort St. John","Climate Zone 7","Step Code 3",1E-4,0.8,28.088978319999999,6.2053642059999996,18.700782163742691,7.7797368421052617]
["MURB","Fort St. John","Climate Zone 7","Step Code 4",1.0000000000000001E-5,0.8,13.08564039,5.9419174420000003,11.634166666666667,0.39915565302144251]
["Retail","Vancouver","Climate Zone 4","Step Code 1",2.5000000000000001E-4,"None",49.482158310000003,1.8641069269999999,15.03292351988939,0.33348535068502816]
["Retail","Vancouver","Climate Zone 4","Step Code 2",2.5000000000000001E-4,0.6,22.355497360000001,1.8155552340000001,13.125630577928348,0.33536023135593146]
["Retail","Vancouver","Climate Zone 4","Step Code 3",1E-4,0.6,16.994364600000001,1.819204974,12.68274883566472,0.13469189792758726]
["Retail","Kamloops","Climate Zone 5","Step Code 1",2.5000000000000001E-4,"None",69.222881509999993,2.045959758,22.848882084302669,3.6484797812397924]
["Retail","Kamloops","Climate Zone 5","Step Code 2",2.5000000000000001E-4,0.6,29.267549469999999,1.9191111350000001,18.221396985170166,3.7299402698488975]
["Retail","Kamloops","Climate Zone 5","Step Code 3",1E-4,0.8,18.848523520000001,1.6495101640000001,14.303570507547931,1.4943622374420549]
["Retail","Prince George","Climate Zone 6","Step Code 1",2.5000000000000001E-4,"None",94.190460209999998,2.1353566490000002,25.670106964113959,0.81632412994949954]
["Retail","Prince George","Climate Zone 6","Step Code 2",2.5000000000000001E-4,0.6,27.65726295,1.8537909809999999,16.808459041729666,2.7352083949772745]
["Retail","Prince George","Climate Zone 6","Step Code 3",1E-4,0.8,19.7972137,1.8472673550000001,15.106860054454787,1.0955383812142749]
["Retail","Fort St. John","Climate Zone 7","Step Code 1",2.5000000000000001E-4,"None",134.17992430000001,2.1902870490000002,30.194944156244883,7.392250915497355]
["Retail","Fort St. John","Climate Zone 7","Step Code 2",2.5000000000000001E-4,0.8,29.94029338,1.950164969,16.932335086057208,3.0035778369559614]
["Retail","Fort St. John","Climate Zone 7","Step Code 3",1E-4,0.8,19.706880999999999,1.692105432,13.033872723472292,0.30091563308440494]
["Office","Vancouver","Climate Zone 4","Step Code 1",2.5000000000000001E-4,"None",36.356064779999997,3.6915262659999999,29.757320755922656,4.5891133123783279]
["Office","Vancouver","Climate Zone 4","Step Code 2",2.5000000000000001E-4,"None",29.391708730000001,3.6704356790000001,26.864005369858059,4.5875330107452239]
["Office","Vancouver","Climate Zone 4","Step Code 3",1E-4,"None",19.542596899999999,3.6576109240000001,18.901636655395912,1.3094510162957673]
["Office","Kamloops","Climate Zone 5","Step Code 1",2.5000000000000001E-4,"None",48.048746080000001,3.781027285,49.690481226980616,4.8133302264396649]
["Office","Kamloops","Climate Zone 5","Step Code 2",2.5000000000000001E-4,0.6,27.288577969999999,3.7348522860000002,46.555093928446709,4.8778884746363991]
["Office","Kamloops","Climate Zone 5","Step Code 3",1E-4,0.6,19.388550939999998,3.7131088239999999,40.624425031867695,1.954668548430633]
["Office","Prince George","Climate Zone 6","Step Code 1",2.5000000000000001E-4,"None",66.39389362,3.7452759809999998,58.016901171034498,0]
["Office","Prince George","Climate Zone 6","Step Code 2",2.5000000000000001E-4,0.6,28.349960549999999,3.6488891369999998,41.338707598338146,0]
["Office","Prince George","Climate Zone 6","Step Code 3",1E-4,0.6,19.232410300000002,3.625928525,33.411026332576441,0]
["Office","Fort St. John","Climate Zone 7","Step Code 1",2.5000000000000001E-4,"None",90.236178089999996,3.9210883810000001,61.692978861003972,32.338080710927777]
["Office","Fort St. John","Climate Zone 7","Step Code 2",2.5000000000000001E-4,0.6,29.851810839999999,3.7106237480000002,25.702280537073946,8.5154983865085914]
["Office","Fort St. John","Climate Zone 7","Step Code 3",1E-4,0.6,19.41104949,3.686319653,23.098587272312621,15.012417934488614]
["Hotel","Vancouver","Climate Zone 4","Step Code 1",2.5000000000000001E-4,"None",39.776765570000002,11.83085827,25.332920661137965,4.2729410390213411]
["Hotel","Vancouver","Climate Zone 4","Step Code 2",2.5000000000000001E-4,"None",24.93815695,8.9026230579999996,15.722917196296081,0.4766943001596034]
["Hotel","Vancouver","Climate Zone 4","Step Code 3",1E-4,0.9,14.94440887,6.6858572770000002,14.6933301543033,0.48128634385973362]
["Hotel","Vancouver","Climate Zone 4","Step Code 4",1.0000000000000001E-5,0.9,10.447636620000001,5.8295074549999999,13.735083253982937,1.9649777693538498E-2]
[]
[]
[]
[]
[]
["Lookup List of Building Types",null,"Lookup List of ASHRAE90.1 Climate Zones"]
["MURB",null,"Climate Zone 4"]
["Retail",null,"Climate Zone 5"]
["Office",null,"Climate Zone 6"]
["Hotel",null,"Climate Zone 7"]
["Automotive Facility",null,"Climate Zone 8"]
["Convention Centre"]
["Courthouse"]
["Dining: Bar/Lounge/Leisure"]
["Dining: Cafeteria/Fast Food"]
["Dining: Family"]
["Dormitory"]
["Exercise Centre"]
["Fire Station"]
["Gymnasium"]
["Healthcare-Clinic/Nursing"]
["Hospital"]
["Library"]
["Manufacturing Facility"]
["Motion Picture Theatre"]
["Museum"]
["Parking Garage"]
["Penitentiary"]
["Performing Arts Theatre"]
["Police Station"]
["Religious Building"]
["School - primary"]
["School - secondary"]
["Sports Arena"]
["Town Hall"]
["Transportation"]
["University/College"]
["Warehouse"]
["Workshop"]
["Other"]

{"sheet":"REFERENCE","index":3,"n_rows":90,"n_cols":34,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
["Climate Zone","Building Types",null,"Standard EMs (choose one)","EM EMLs","Sorting Options","Standard End Use","Energy Codes","Units","ICC Units",null,"Heating Source",null,null,null,null,"Yes/No",null,null,"Proposed Space Heating",null,null,"Exterior Wall Types",null,null,null,"Electricity Rates",null,null,null,null,null,"Proposed Space Heating"]
["GVRD and Victoria (ASHRAE Zone 4C)","Mixed Use",null,"HVAC Air Source VRF Distributed Heat Pumps",18,"Project #","Process HVAC","Step Code 1","Metric units","m2",null,"Electric",null,null,null,null,"Yes  ",null,null,null,"None",null,"Mass",null,null,null,"SGS","Small General Service",null,null,null,null,null,"None"]
["City of Vancouver and SFU (ASHRAE Zone 5)","Automotive Facility",null,"HVAC Water Source VRF Distributed Heat Pumps",22,"Project Name","Fans","Step Code 2","Imperial units","ft2",null,"Hybrid","elec and gas serve the same system",null,null,null,"No",null,null,null,"PTACand PTHP",null,"Metal Building",null,null,null,"MGS","Medium General Service",null,null,null,null,null,"PTAC"]
["BC Interior Kelowna, Vernon (ASHRAE Zone 5)","Convention Centre",null,"HVAC Water-to-Air Distributed Heat Pumps",18,"Building Type","Pumps","Step Code 3",null,"# of units",null,"DES",null,null,null,null,null,null,null,null,"PSZ-AC - Pack rooftop air conditioner CV",null,"Steel-framed",null,null,null,"LGS","Large General Service",null,null,null,null,null,"PTHP"]
["Vancouver Island except Victoria (ASHRAE Zone 5)","Courthouse",null,"HVAC Air-to-Air Heat Pump (ductless or minisplit)",18,"Area","DHW","Step Code 4",null,"L/s",null,"Natural Gas ",null,null,null,null,null,null,null,null,"Baseboard heating",null,"Wood-framed and Other",null,null,null,"TSR","Transmission Service Rate",null,null,null,null,null,"Hydronic Baseboard heating"]
["Coastal BC (ASHRAE Zone 5)","Dining: Bar/Lounge/Leisure",null,"HVAC Air-to-Water Heat Pump",15,"Climate Zone","Space Cooling","ASHRAE 90.1 2016",null,"CFM",null,"Renewable Natural Gas ",null,null,null,null,null,null,null,null,"VAV box (overhead and underfloor)",null,null,null,null,null,"RES 1","Residential Tier 1",null,null,null,null,null,"Electric Baseboard heating"]
["BC South Interior (ASHRAE Zone 6)","Dining: Cafeteria/Fast Food",null,"HVAC Electric Boiler",20,"Mech Consultant","Plug Load","NECB 2015",null,"TON",null,"Propane ",null,null,null,null,null,null,null,null,"Fan Coil unit",null,null,null,null,null,"RES 2","Residential Tier 2",null,null,null,null,null,"PSZ-AC - Pack rooftop air conditioner CV"]
["BC Interior (ASHRAE Zone 7)","Dining: Family",null,"HVAC Electric Water Heater",15,"Elec Consultant","Refrigeration",null,null,"kW",null,"Light Fuel Oil ",null,null,null,null,null,null,null,null,"Distributed heat pump ",null,null,null,null,null,null,null,null,null,null,null,null,"SZ-CV-HW Single-zone CV Chilled Water"]
["Northern BC (ASHRAE Zone 8)","Dormitory",null,"HVAC Exhaust Air Heat Recovery Heat Pump",15,null,"Elevators",null,null,"hp",null,"Heavy Fuel Oil ",null,null,null,null,null,null,null,null,"Thermal displacement ventilation",null,null,null,null,null,null,null,null,null,null,null,null,"Packaged VAV w/Reheat"]
["Lower Mainland and Victoria (NECB Zone 4)","Exercise Centre",null,"HVAC Ground Source Heat Pump",15,null,"IT Process Load",null,null,"GPM",null,"Kerosene ",null,null,null,null,null,null,null,null,"Chilled-beam",null,null,null,null,null,null,null,null,null,null,null,null,"VAV w/Reheat"]
["Coastal and South Interior BC (NECB Zone 5)","Fire Station",null,"HVAC Heat Recovery Chiller",22,null,"Heat Rejection",null,null,"MBH",null,"Diesel Fuel ",null,null,null,null,null,null,null,null,"Radiant floor/in-slab ceiling ",null,null,null,null,null,null,null,null,null,null,null,null,"Fan Coil unit"]
["BC Mid Interior (NECB Zone 6)","Gymnasium",null,"HVAC High-efficiency (>75%) HRV",15,null,"Interior Lights",null,null,null,null,"Marine Diesel ",null,null,null,null,null,null,null,null,"Radiant panel/capillary tubing heating",null,null,null,null,null,null,null,null,null,null,null,null,"Distributed heat pump "]
["BC Interior - Prince George (NECB Zone 7A)","Healthcare-Clinic/Nursing",null,"HVAC Rooftop Air-to-Air Heat Pump",15,null,"Exterior Lights",null,null,null,null,"Biodiesel (B100) ",null,null,null,null,null,null,null,null,"VRF",null,null,null,null,null,null,null,null,null,null,null,null,"Thermal displacement ventilation"]
["BC Interior - Fort Nelson (NECB Zone 7B)","Hospital",null,"HVAC Rooftop Air-to-Water Heat Pump",15,null,"Heating - Ventilation",null,null,null,null,"Gasoline ",null,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,"Chilled-beam"]
["BC Interior - Prince George (NECB Zone 7A)","Hotel",null,"HVAC Water-to-Water Heat Pump",15,null,"Space Heating",null,null,null,null,"Wood Fuel – Industrial (50% moisture) ",null,null,null,null,null,null,null,"Proposed Space Cooling",null,null,null,null,null,null,null,null,null,null,null,null,null,"Radiant floor/in-slab ceiling "]
["Northern BC (NECB Zone 8)","Library",null,"DHW Air-to-Water Heat Pump (central plant)",15,null,"Cooking",null,null,null,null,"Wood Fuel – Residential (0% moisture) ",null,null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,null,null,null,null,"Radiant panel/capillary tubing heating"]
[null,"Manufacturing Facility",null,"DHW Air-to-Water Heat Pump Water Heater",15,null,"Other Process Load",null,null,null,null,"Ethanol (E100) ",null,null,null,null,null,null,null,null,"PTACand PTHP",null,null,null,null,null,null,null,null,null,null,null,null,"Air-source VRF"]
[null,"Motel",null,"DHW Electric Boiler",20,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,"PSZ-AC - Pack rooftop air conditioner CV",null,null,null,null,null,null,null,null,null,null,null,null,"Water-source VRF"]
[null,"Motion Picture Theatre",null,"DHW Electric Water Heater",15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAV box (overhead and underfloor)",null,null,null,null,null,null,null,null,null,null,null,null,"Warm air furnace RTU, gas fired"]
[null,"Museum",null,"DHW Ground Source Heat Pump",15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fan Coil unit",null,null,null,null,null,null,null,null,null,null,null,null,"Gas-fired unit heaters"]
[null,"Office - Small (under 50,000 sqft)",null,"DHW Heat Recovery Chiller",22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distributed heat pump ",null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,"Office - Large  (over 50,000 sqft)",null,"DHW Sewage Heat Recovery Heat Pump",15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermal displacement ventilation"]
[null,"Parking Garage",null,"DHW Water-to-Water Heat Pump",15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chilled-beam"]
[null,"Penitentiary",null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radiant floor/in-slab ceiling "]
[null,"Performing Arts Theatre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radiant panel/capillary tubing heating"]
[null,"Police Station",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VRF"]
[null,"Post Office",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural ventilation"]
[null,"Religious Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,"Retail - small (under 50,000 sqft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Ventilation Sys"]
[null,"Retail - large (over 50,000 sqft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,"Residential Low Rise (4-storey)",null,"Results Sort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed air ventilation"]
[null,"Residential High Rise (over 4-storey)",null,"Building Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100% dedicated outdoor air"]
[null,"School - primary",null,"Climate Zone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Displacement ventilation "]
[null,"School - secondary",null,"ASHRAE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat recovery ventilator"]
[null,"Sports Arena",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural ventilation"]
[null,"Town Hall",null,"Project Status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Earth tube/Thermal labyrinth"]
[null,"Transportation",null,"In Progress",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar wall/double skin façade"]
[null,"University/College",null,"Completed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,"Warehouse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Heating Plant"]
[null,"Workshop",null,"Yes or No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat Recovery Chiller"]
[null,"Other",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water-to-Water Heat pump"]
[null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air-to-water Heat Pump"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhaust Air Source Heat Pump"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sewage Source Heat Pump"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground Source Heat Pump"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 Heat Pump (air-to-water)"]
[null,null,null,null,null,null,null,"Emission Factor ",null,null,null,null,null,null,null,null,null,null,null,null,"Glycol run-around loop"]
[null,"TEDI (kWh/m2)","Climate Zone 4","Climate Zone 5","Climate Zone 6","Climate Zone 7a",null,"BC Hydro Elec",10.67,"tCO2e per GWh Elec",null,null,null,null,null,null,null,null,null,null,"Electric Boiler"]
[null,"Office - Small (under 50,000 sqft)",35,36,47,63,null,"BC Hydro Elec",2.964,"kgCO2e per GJ Elec",null,null,null,null,null,null,null,null,null,null,"Other"]
[null,"Office - Large  (over 50,000 sqft)",{"$f":"C49","v":35},{"$f":"D49","v":36},{"$f":"E49","v":47},{"$f":"F49","v":63},null,"Natural Gas ",49.87,"kg eCO2 per GJ"]
[null,"Retail - small (under 50,000 sqft)",30,39,55,69,null,"Renewable Natural Gas ",0.28999999999999998,"kg eCO2 per GJ"]
[null,"Retail - large (over 50,000 sqft)",{"$f":"C51","v":30},{"$f":"D51","v":39},{"$f":"E51","v":55},{"$f":"F51","v":69},null,"Propane ",61.15,"kg eCO2 per GJ"]
[null,"Residential Low Rise (4-storey)",49,56,70,65,null,"Light Fuel Oil ",68.37,"kg eCO2 per GJ"]
[null,"Residential High Rise (over 4-storey)",{"$f":"C53","v":49},{"$f":"D53","v":56},{"$f":"E53","v":70},{"$f":"F53","v":65},null,"Heavy Fuel Oil ",74.739999999999995,"kg eCO2 per GJ",null,null,null,null,null,null,null,null,null,"Proposed Cooling Plant"]
[null,"Other","N/A","N/A","N/A","N/A",null,"Kerosene ",68.2,"kg eCO2 per GJ",null,null,null,null,null,null,null,null,null,null,"None"]
[null,null,null,null,null,null,null,"Diesel Fuel ",70.62,"kg eCO2 per GJ",null,null,null,null,null,null,null,null,null,null,"Chiller"]
[null,null,null,null,null,null,null,"Marine Diesel ",76.08,"kg eCO2 per GJ",null,null,null,null,null,null,null,null,null,null,"Heat pump"]
[null,null,null,null,null,null,null,"Biodiesel (B100) ",69.36,"kg eCO2 per GJ",null,null,null,null,null,null,null,null,null,null,"Evaporative cooling"]
[null,null,null,null,null,null,null,"Gasoline ",65.22,"kg eCO2 per GJ",null,null,null,null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,"Wood Fuel – Industrial (50% moisture) ",2.2400000000000002,"kg eCO2 per GJ"]
[null,null,null,null,null,null,null,"Wood Fuel – Residential (0% moisture) ",23.48,"kg eCO2 per GJ"]
[null,null,null,null,null,null,null,"Ethanol (E100) ",64.430000000000007,"kg eCO2 per GJ"]
[null,"Standard ECMs (choose one)",null,"ECM Name",null,null,null,"N/A",0]
[null,"Roof Insulation Increase",null,"B1: Bundle #1",null,null,null,null,0]
[null,"Wall Insulation Increase",null,"E1: Roof Insulation Increase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baseline Technology"]
[null,"High Efficiency Glazing",null,"E2: Wall Insulation Increase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial End Uses","Baseline Central Plant","Baseline Termial system"]
[null,"Parkade ceiling insulation",null,"E3: High Efficiency Glazing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC","Gas Boiler","Electric Baseboard Heating"]
[null,"Shading (concrete)",null,"E4: Shading",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Domestic Hot Water","Gas Water Heater","Hydronic Baseboard Heating"]
[null,"Shading (motorized)",null,"L1: Interior LPD Reduction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat Recovery Chiller","VAV"]
[null,"Low Flow Fixtures",null,"L2: Interior Lighting Control",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District Energy System","Fan Coils"]
[null,"Heat recovery for domestic hot water pre-heat",null,"L3: Exterior LPD Reduction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air-to-water Heat Pump","Terminal Air Conditioning"]
[null,"Adjustable speed drive on pump",null,"L4: Exterior Lighting Control",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hybrid gas/electric","Radiant Heating"]
[null,"Domestic hot water boiler upgrade; Efficient boiler",null,"M-D1: DHW Low Flow Fixtures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other","Other"]
[null,"Domestic hot water recirculation pump demand control",null,"M-D2: DHW Heating/Preheating"]
[null,"Electronically commutated motor pumps",null,"M-H1: High eff HVAC system (w H/C plants)"]
[null,"Adjustable speed drive on pump",null,"M-H2: Heat Recovery"]
[null,"CNC Only - High Efficiency HVAC System/ Plant, Central Heat Pumps",null,"M-H3: Demand Ventilation Control"]
[null,"CNC Only - High Efficiency HVAC System/ Plant, Distributed Heat Pumps.",null,"M-H4: VFD"]
[null,"High Efficiency Boiler",null,"M-H5: Natural Ventilation"]
[null,"High efficiency chiller, chiller/cooler upgrade",null,"M-H6: Renewable Energy"]
[null,"Adjustable speed drive on fan",null,"M-P1: Process HVAC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baseline DHW Plant"]
[null,"Heat recovery upgrade/ retrofit",null,"M-P2: Process Load Savings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Hot Water Heater"]
[null,"CO2 based demand control ventilation",null,"M-P3: Process Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric Resistance Hot Water Heater"]
[null,"CO based parkade ventilation control",null,"Not Included in Bundle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat Pump Water Heater"]
[null,"Natural Ventilation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DES"]
[null,"Renewable Energy (solar thermal)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,"Exterior LPD Reduction"]
[null,"Interior LPD Reduction"]
[null,"Parkade LPD Reduction"]
[null,"New lighting controls including time clocks, occupancy sensors or photocells"]

{"sheet":"1- pre screen","index":4,"n_rows":134,"n_cols":7,"rows_kept":134,"cut":false,"hidden":false,"merged":[[0,6,1,6],[24,1,24,2],[24,4,24,5],[102,0,114,6],[11,1,11,5],[2,0,2,1],[9,0,10,0],[31,1,31,4],[30,1,30,4],[84,0,96,6],[19,0,20,0],[21,1,21,5],[22,1,22,5],[14,0,15,0],[23,1,23,5]]}
["CleanBC New Construction Incentives",null,null,null,null,null,"CleanBC New Construction Workbook v2.0"]
["Project Eligibility Screening Sheet"]
["White, bordered cells for user inputs"]
[]
["Date submitted   (DD-MM-YYYY)",null,"Day-Month-Year"]
["Name of BC Hydro Key Account Manager (KAM)","KAM's name"]
[]
[]
[]
["Customer Information"]
[]
["Organization","Organization name"]
["Customer","Company Name","contact name","phone","email","address"]
[]
["Modeling Consultant Details"]
[]
["Primary (Lead) Consultant","Company Name","contact name","phone","email","address"]
["Energy Modeller","Company Name","contact name","phone","email","address"]
[]
["General Project Information"]
[]
["Project Name","Project Name"]
["Site Address","Site Address"]
["Site City","Site City"]
["If applicable, BC Hydro Sponsored Energy Manager","Energy manager name",null,"phone","email"]
[]
[]
["Concept Design Parameters (Baseline)","Building Type 1","Building Type 2","Building Type 3","Building Type 4","TOTAL"]
["Building Type"]
["Conditioned Area (m2)",null,null,null,null,{"$f":"SUM(B30:E30)","v":0},"m2"]
["ASHRAE Climate Zone"]
["Applicable Legislation or By Law Energy Code Level"]
["Concept Design Heat Loss Rate (W/m2) - if Step Code applicable",null,null,null,null,{"$f":"SUMPRODUCT(B30:E30,B33:E33)/F30","v":{"$error":"#DIV/0!"}},"W/m2"]
[null,586613.72499999998,{"$f":"IFERROR(C30*C35,0)","v":0},0,0]
["Maximum Allowable Heat Loss Rate (W/m2) - Step Code",{"$f":"IFERROR(INDEX(BaselineParameters!$I$2:$I$45,MATCH(B29&$B$31&$B$32,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(BaselineParameters!$I$2:$I$45,MATCH(C29&$B$31&$B$32,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(BaselineParameters!$I$2:$I$45,MATCH(D29&$B$31&$B$32,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(BaselineParameters!$I$2:$I$45,MATCH(E29&$B$31&$B$32,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"SUM(B34:E34)/F30","v":{"$error":"#DIV/0!"}},"W/m2"]
["Baseline HRV Requirements (effectiveness) - Step Code",{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(B29&$B$31&$B$32,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(C29&$B$31&$B$32,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(D29&$B$31&$B$32,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(E29&$B$31&$B$32,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""}]
["Is HRV included in current concept design? (Yes/No)"]
["Space Heating Electric Heating Seasonal Efficiency (if applicable)"]
["Space Heating Fuel Heating Seasonal Efficiency (ifapplicable)"]
["Ventilation Electric Heating Seasonal Efficiency (if applicable)"]
["Ventilation Fuel Heating Seasonal Efficiency (if applicable)"]
["DHW  Electric Heating Seasonal Efficiency (if applicable)"]
["DHW  Fuel Heating Seasonal Efficiency (if applicable)"]
["Heating Fuel Type (if applicable)"]
["BC Hydro Electricity Rate"]
["Fuel Rate without taxes (total $ per GJ)"]
["Fuel Carbon Tax ($/tCO2e)"]
["Carbon Offset Credit if applicable ($/tCO2e)",null,{"$f":"B48","v":0},{"$f":"C48","v":0},0]
["Purchased Heating Energy Rate without taxes if applicable ($/unit)"]
[]
[]
[]
["Concept Design (Baseline) \nAnnual Energy Consumption by End Use Breakdown","Building Type 1","Building Type 2","Building Type 3","Building Type 4","TOTAL"]
["Space Heating and Ventilation Electric Heating (kWh/year)",null,null,null,null,{"$f":"SUM(B54:E54)","v":0}]
["Space Heating and Ventilation Fuel Heating (ekWh/year)",null,null,null,null,{"$f":"SUM(B55:E55)","v":0}]
["DHW Electric Heating (kWh/year)",null,null,null,null,0]
["DHW Fuel Heating (ekWh/year)",null,null,null,null,0]
["Process Electric Heating (kWh/year)",null,null,null,null,0]
["Process Fuel Heating (ekWh/year)",null,null,null,null,0]
["All Other Electric Uses (kWh/year)",null,null,null,null,0]
["All Other Fuel Uses (ekWh/year)",null,null,null,null,0]
["Expected Electricity Annual Peak Demand ( kW )"]
["Expected Electricity Average Monthly Peak Demand ( kW )"]
["Total Electric Energy Use (kWh/year)",{"$f":"B66-B65","v":0},{"$f":"C66-C65","v":0},0,0,0]
["Total Fuel Energy Use (ekWh/year)",{"$f":"B55+B57+B59+B61","v":0},{"$f":"C55+C57+C59+C61","v":0},{"$f":"D55+D57+D59+D61","v":0},{"$f":"E55+E57+E59+E61","v":0},0]
["Total Energy Use (ekWh/year)",{"$f":"SUM(B54:B61)","v":0},{"$f":"SUM(C54:C61)","v":0},{"$f":"SUM(D54:D61)","v":0},{"$f":"SUM(E54:E61)","v":0},0]
["TEUI (ekWh/year/m2)",{"$f":"B66/B30","v":{"$error":"#DIV/0!"}},{"$f":"C66/C30","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total Fuel Energy Use ( GJ / year)",{"$f":"B65*3.6/1000","v":0},{"$f":"C65*3.6/1000","v":0},0,0,0]
["Fuel AND Electric GHG emissions (tonneCO2e/yr)",{"$f":"IFERROR(VLOOKUP(B44,REFERENCE!$H$48:$I$64,2,FALSE)*B68/1000+REFERENCE!$I$48*'1- pre screen'!B64/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C44,REFERENCE!$H$48:$I$64,2,FALSE)*C68/1000+REFERENCE!$I$48*'1- pre screen'!C64/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D44,REFERENCE!$H$48:$I$64,2,FALSE)*D68/1000+REFERENCE!$I$48*'1- pre screen'!D64/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E44,REFERENCE!$H$48:$I$64,2,FALSE)*E68/1000+REFERENCE!$I$48*'1- pre screen'!E64/1000000,\"\")","v":""},0]
[null,{"$f":"IFERROR(VLOOKUP(B44,REFERENCE!$H$48:$I$64,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C44,REFERENCE!$H$48:$I$64,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D44,REFERENCE!$H$48:$I$64,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E44,REFERENCE!$H$48:$I$64,2,FALSE),\"\")","v":""}]
[]
[]
[]
[]
["Concept Design's  (Baseline) \nHeating Source Breakdown Ratios (Electricity vs. Fuel Energy)","Building Type 1","Building Type 2","Building Type 3","Building Type 4","TOTAL"]
["Space Heating and Ventilation heating (electric)",{"$f":"B54/(B54+B55)","v":{"$error":"#DIV/0!"}},{"$f":"C54/(C54+C55)","v":{"$error":"#DIV/0!"}},{"$f":"D54/(D54+D55)","v":{"$error":"#DIV/0!"}},{"$f":"E54/(E54+E55)","v":{"$error":"#DIV/0!"}},{"$f":"F54/(F54+F55)","v":{"$error":"#DIV/0!"}}]
["Space Heating and Ventilation heating (Fuel)",{"$f":"1-B76","v":{"$error":"#DIV/0!"}},{"$f":"1-C76","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["DHW  (electric)",{"$f":"B56/(B56+B57)","v":{"$error":"#DIV/0!"}},{"$f":"C56/(C56+C57)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"F56/(F56+F57)","v":{"$error":"#DIV/0!"}}]
["DHW  (Fuel)",{"$f":"1-B78","v":{"$error":"#DIV/0!"}},{"$f":"1-C78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Concept Design (Baseline) Details and Probable Cost Estimates"]
["Provide brief description of current concept design of the HVAC system (including terminal, central, and plant components).\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proposed Electrification Measures and Probable Cost Estimates"]
["Provide brief description of the proposed electrification measures (including terminal, central, and plant components).\nProvide anticipated seasonal heating efficiencies of proposed electrification measures.\n\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Estimate the following relative to Concept Design","EM-1","EM-2","EM-3","EM-4","EM-5","Bundle"]
["Proposed Electrification Measure"]
["Estimated Measure Life (years)",{"$f":"IF(B120=\"\",\"\",VLOOKUP(B120,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},{"$f":"IF(C120=\"\",\"\",VLOOKUP(C120,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},{"$f":"IF(D120=\"\",\"\",VLOOKUP(D120,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},{"$f":"IF(E120=\"\",\"\",VLOOKUP(E120,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},{"$f":"IF(F120=\"\",\"\",VLOOKUP(F120,REFERENCE!$D$2:$E$28,2,FALSE))","v":""}]
["Expected increase in electricity consumption ( kWh / year )",null,null,null,null,null,{"$f":"SUM(B122:F122)","v":0}]
["Expected Increase in Electricity Annual Peak Demand ( kW )",null,null,null,null,null,{"$f":"SUM(B123:F123)","v":0}]
["Expected Increase in Electricity Average Monthly Peak Demand ( kW )",null,null,null,null,null,{"$f":"SUM(B124:F124)","v":0}]
["Expected decrease in fuel consumption ( GJ / year )",null,null,null,null,null,{"$f":"SUM(B125:F125)","v":0}]
["% Reduction of Fuel Consumption",{"$f":"B125/$F$68","v":{"$error":"#DIV/0!"}},{"$f":"C125/$F$68","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G125/F68","v":{"$error":"#DIV/0!"}}]
["Expected decrease in GHG ( tonneCO2e/yr )",{"$f":"IFERROR(VLOOKUP(B44,REFERENCE!$H$48:$I$64,2,FALSE)*B125/1000-REFERENCE!$I$48*'1- pre screen'!B122/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C44,REFERENCE!$H$48:$I$64,2,FALSE)*C125/1000-REFERENCE!$I$48*'1- pre screen'!C122/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D44,REFERENCE!$H$48:$I$64,2,FALSE)*D125/1000-REFERENCE!$I$48*'1- pre screen'!D122/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E44,REFERENCE!$H$48:$I$64,2,FALSE)*E125/1000-REFERENCE!$I$48*'1- pre screen'!E122/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F44,REFERENCE!$H$48:$I$64,2,FALSE)*F125/1000-REFERENCE!$I$48*'1- pre screen'!F122/1000000,\"\")","v":""},{"$f":"SUM(B127:F127)","v":0}]
["Expected decrease in GHG ( tonneCO2e) over measure life",{"$f":"IFERROR(B127*B121,\"\")","v":""},{"$f":"IFERROR(C127*C121,\"\")","v":""},"","","",0]
["Provide probable cost estimate of concept design (Electrification Baseline) HVAC system (sum of terminal, central, and plant components) $$$   >>>>",null,null,null,null,null,0]
["Provide coarse cost estimate of proposed electrification measures \n(sum of terminal, central, and plant components) $$$   >>>>",null,null,null,null,null,0]
["Expected Increase (or Decrease) in Annual O&M Cost ($/year)",null,null,null,null,null,0]
["Expected Incremental Capital Cost ( $ )",{"$f":"B130-B129","v":0},{"$f":"C130-C129","v":0},0,0,0,0]
[]
[null,{"$f":"IFERROR(IF(G128<400,\"Project may not qualify for incentive as GHG reduction over measure(s) life must be equal or greater than 400 tCO2e.\",\"\"),\"\")","v":"Project may not qualify for incentive as GHG reduction over measure(s) life must be equal or greater than 400 tCO2e."}]

{"sheet":"2- Proposal","index":5,"n_rows":201,"n_cols":19,"rows_kept":201,"cut":false,"hidden":false,"merged":[[7,0,8,0],[9,1,9,5],[12,0,13,0],[20,0,21,0],[22,1,22,5],[23,1,23,5],[24,1,24,5],[25,1,25,2],[25,4,25,5],[2,0,2,1],[131,0,148,4],[120,16,120,17],[44,16,44,17],[48,16,48,17],[49,16,49,17],[69,15,69,17],[82,15,82,17],[100,15,100,17],[116,15,116,17],[121,15,121,17],[125,16,125,17],[118,1,118,2],[120,1,120,2],[122,1,122,2],[123,1,123,2],[117,6,117,7],[118,6,118,7],[120,6,120,7],[121,5,121,7],[125,1,125,2],[41,6,41,7],[38,1,38,2],[40,1,40,2],[46,1,46,2],[69,5,69,7],[82,5,82,7],[41,1,41,2],[59,6,59,7],[41,16,41,17],[81,11,81,12],[40,6,40,7],[39,6,39,7],[56,0,56,2],[62,0,62,2],[69,0,69,2],[57,6,57,7],[61,1,61,2],[50,0,50,2],[44,6,44,7],[48,6,48,7],[81,16,81,17],[43,5,43,7],[41,11,41,12],[49,11,49,12],[100,0,100,2],[60,1,60,2],[49,6,49,7],[56,5,56,7],[45,6,45,7],[46,6,46,7],[47,6,47,7],[50,10,50,12],[116,10,116,12],[110,1,110,2],[111,1,111,2],[58,1,58,2],[108,0,108,2],[59,1,59,2],[61,6,61,7],[57,1,57,2],[80,1,80,2],[80,6,80,7],[81,6,81,7],[110,6,110,7],[111,6,111,7],[81,1,81,2],[82,0,82,2],[58,11,58,12],[117,11,117,12],[50,5,50,7],[62,5,62,7],[100,5,100,7],[57,11,57,12],[82,10,82,12],[59,11,59,12],[80,11,80,12],[60,11,60,12],[60,6,60,7],[116,5,116,7],[115,6,115,7],[58,6,58,7],[100,10,100,12],[69,10,69,12],[62,10,62,12],[125,11,125,12],[119,1,119,2],[119,6,119,7],[119,11,119,12],[108,5,108,7],[108,10,108,12],[114,0,114,2],[114,5,114,7],[114,10,114,12],[110,11,110,12],[122,11,122,12],[123,11,123,12],[124,11,124,12],[120,11,120,12],[121,10,121,12],[121,0,121,2],[116,0,116,2],[124,1,124,2],[122,6,122,7],[123,6,123,7],[124,6,124,7],[125,6,125,7],[115,11,115,12],[118,11,118,12],[122,16,122,17],[123,16,123,17],[124,16,124,17],[38,6,38,7],[117,16,117,17],[118,16,118,17],[119,16,119,17],[33,0,33,2],[36,1,36,2],[35,1,35,2],[43,0,43,2],[44,1,44,2],[45,1,45,2],[42,1,42,2],[39,1,39,2],[37,1,37,2],[34,1,34,2],[48,1,48,2],[49,1,49,2],[47,1,47,2],[42,6,42,7],[117,1,117,2],[48,11,48,12],[111,11,111,12],[115,16,115,17],[45,16,45,17],[46,16,46,17],[47,16,47,17],[57,16,57,17],[56,15,56,17],[61,16,61,17],[50,15,50,17],[62,15,62,17],[58,16,58,17],[59,16,59,17],[108,15,108,17],[114,15,114,17],[60,16,60,17],[80,16,80,17],[111,16,111,17],[36,11,36,12],[37,11,37,12],[33,5,33,7],[36,6,36,7],[37,6,37,7],[34,6,34,7],[35,11,35,12],[38,11,38,12],[34,11,34,12],[0,7,1,7],[33,15,33,17],[36,16,36,17],[37,16,37,17],[34,16,34,17],[35,6,35,7],[56,10,56,12],[61,11,61,12],[110,16,110,17],[42,16,42,17],[43,15,43,17],[35,16,35,17],[40,16,40,17],[39,16,39,17],[42,11,42,12],[43,10,43,12],[38,16,38,17],[45,11,45,12],[46,11,46,12],[47,11,47,12],[39,11,39,12],[40,11,40,12],[44,11,44,12],[33,10,33,12]]}
["CleanBC New Construction Incentives",null,null,null,null,null,null,{"$f":"'1- pre screen'!G1:G2","v":"CleanBC New Construction Workbook v2.0"}]
["Energy Study Proposal"]
["White, bordered cells for user inputs",null,"BC Hydro Ref # >>>","BCH-00000"]
[null,null,"Proposal Date  >>>",null,"Day-Month-Year"]
[null,null,"Name of BC Hydro Key Account Manager (KAM)",{"$f":"'1- pre screen'!B6","v":"KAM's name"}]
["1. General Information"]
[]
["Customer Information"]
[]
["Organization",{"$f":"'1- pre screen'!B12:F12","v":"Organization name"}]
["Customer",{"$f":"'1- pre screen'!B13","v":"Company Name"},{"$f":"'1- pre screen'!C13","v":"contact name"},{"$f":"'1- pre screen'!D13","v":"phone"},{"$f":"'1- pre screen'!E13","v":"email"},{"$f":"'1- pre screen'!F13","v":"address"}]
[]
["Consultants Details"]
[]
["Primary (Lead) Consultant",{"$f":"'1- pre screen'!B17","v":"Company Name"},{"$f":"'1- pre screen'!C17","v":"contact name"},{"$f":"'1- pre screen'!D17","v":"phone"},{"$f":"'1- pre screen'!E17","v":"email"},{"$f":"'1- pre screen'!F17","v":"address"}]
["Energy Modeller",{"$f":"'1- pre screen'!B18","v":"Company Name"},{"$f":"'1- pre screen'!C18","v":"contact name"},{"$f":"'1- pre screen'!D18","v":"phone"},{"$f":"'1- pre screen'!E18","v":"email"},{"$f":"'1- pre screen'!F18","v":"address"}]
["Mechanical Consultant","Company Name","contact name","phone","email","address"]
["Cost Consultant","Company Name","contact name","phone","email","address"]
["General Contractor","Company Name","contact name","phone","email","address"]
[]
["General Project Information"]
[]
["Project Name",{"$f":"'1- pre screen'!B22:F22","v":"Project Name"}]
["Site Address",{"$f":"'1- pre screen'!B23:F23","v":"Site Address"}]
["Site City",{"$f":"'1- pre screen'!B24:F24","v":"Site City"}]
["BC Hydro Sponsored Energy Manager",{"$f":"'1- pre screen'!B25:C25","v":"Energy manager name"},null,{"$f":"'1- pre screen'!D25","v":"phone"},{"$f":"'1- pre screen'!E25:F25","v":"email"}]
[]
[]
[]
[]
[]
["2.1 Energy Model Input Parameters - BUILDING TYPE 1",null,null,null,null,"2.2 Energy Model Input Parameters - BUILDING TYPE 2 (if applicable)",null,null,null,null,"2.3 Energy Model Input Parameters - BUILDING TYPE 3 (if applicable)",null,null,null,null,"2.4 Energy Model Input Parameters - BUILDING TYPE 4 (if applicable)"]
["Metric Units","Baseline\n(Concept Design Model)","Proposed Building Design","EM # (up to 5)\nwhere applicable",null,{"$f":"$A$33","v":"Metric Units"},"Baseline\n(Concept Design Model)","Proposed Building Design","EM # (up to 5)\nwhere applicable",null,{"$f":"$A$33","v":"Metric Units"},"Baseline\n(Concept Design Model)","Proposed Building Design","EM # (up to 5)\nwhere applicable",null,{"$f":"$A$33","v":"Metric Units"},"Baseline\n(Concept Design Model)","Proposed Building Design","EM # (up to 5)\nwhere applicable"]
["GENERAL",null,null,null,null,"GENERAL",null,null,null,null,"GENERAL",null,null,null,null,"GENERAL"]
["Energy Code (Energy Step Code)",{"$f":"'1- pre screen'!$B$32","v":0},null,null,null,{"$f":"A35","v":"Energy Code (Energy Step Code)"},{"$f":"$B$35","v":0},null,null,null,"Energy Code",{"$f":"$B$35","v":0},null,null,null,"Energy Code",{"$f":"$B$35","v":0}]
["Modelling Software",null,null,null,null,{"$f":"A36","v":"Modelling Software"},{"$f":"B36","v":0},null,null,null,"Modelling Software",{"$f":"G36","v":0},null,null,null,"Modelling Software",{"$f":"L36","v":0}]
["ASHRAE Climate Zone",{"$f":"'1- pre screen'!B31","v":0},null,null,null,"ASHRAE Climate Zone",{"$f":"$B$37","v":0},null,null,null,"Climate Zone",{"$f":"$B$37","v":0},null,null,null,"Climate Zone",{"$f":"$B$37","v":0}]
["Building Type",{"$f":"'1- pre screen'!B29","v":0},null,null,null,"Building Type",{"$f":"'1- pre screen'!C29","v":0},null,null,null,"Building Type",{"$f":"'1- pre screen'!D29","v":0},null,null,null,"Building Type",{"$f":"'1- pre screen'!E29","v":0}]
["Conditioned Area (m2)",{"$f":"'1- pre screen'!B30","v":0},null,null,null,"Conditioned Area (m2)",{"$f":"'1- pre screen'!C30","v":0},null,null,null,{"$f":"F39","v":"Conditioned Area (m2)"},{"$f":"'1- pre screen'!D30","v":0},null,null,null,{"$f":"K39","v":"Conditioned Area (m2)"},{"$f":"'1- pre screen'!E30","v":0}]
[{"$f":"'1- pre screen'!A35","v":"Maximum Allowable Heat Loss Rate (W/m2) - Step Code"},{"$f":"'1- pre screen'!B35","v":""},null,null,null,"Maximum Allowable Heat Loss Rate (W/m2) - Step Code",{"$f":"'1- pre screen'!C35","v":""},null,null,null,"Maximum Allowable Heat Loss Rate (W/m2) - Step Code",{"$f":"'1- pre screen'!D35","v":""},null,null,null,"Maximum Allowable Heat Loss Rate (W/m2) - Step Code",{"$f":"'1- pre screen'!E35","v":""}]
[{"$f":"'1- pre screen'!A33","v":"Concept Design Heat Loss Rate (W/m2) - if Step Code applicable"},{"$f":"'1- pre screen'!B33","v":0},null,null,null,"Concept Design Heat Loss Rate (W/m2) - if Step Code applicable",{"$f":"'1- pre screen'!C33","v":0},null,null,null,"Concept Design Heat Loss Rate (W/m2) - if Step Code applicable",{"$f":"'1- pre screen'!D33","v":0},null,null,null,"Concept Design Heat Loss Rate (W/m2) - if Step Code applicable",{"$f":"'1- pre screen'!E33","v":0}]
["Number of Floors",null,null,null,null,{"$f":"A42","v":"Number of Floors"},null,null,null,null,{"$f":"F42","v":"Number of Floors"},null,null,null,null,"Number of Floors"]
[{"$f":"'1- pre screen'!A44","v":"Heating Fuel Type (if applicable)"},{"$f":"'1- pre screen'!B44","v":0},null,null,null,"Heating Fuel Type (if applicable)",{"$f":"'1- pre screen'!C44","v":0},null,null,null,{"$f":"F43","v":"Heating Fuel Type (if applicable)"},{"$f":"'1- pre screen'!D44","v":0},null,null,null,{"$f":"K43","v":"Heating Fuel Type (if applicable)"},{"$f":"'1- pre screen'!E44","v":0}]
["OCCUPANCY AND OPERATING SCHEDULES",null,null,null,null,{"$f":"A44","v":"OCCUPANCY AND OPERATING SCHEDULES"},null,null,null,null,{"$f":"F44","v":"OCCUPANCY AND OPERATING SCHEDULES"},null,null,null,null,{"$f":"K44","v":"OCCUPANCY AND OPERATING SCHEDULES"}]
["Occupancy Schedules",null,null,null,null,"Occupancy Schedules",null,null,null,null,{"$f":"F45","v":"Occupancy Schedules"},null,null,null,null,{"$f":"K45","v":"Occupancy Schedules"}]
["Lighting Schedule",null,null,null,null,"Lighting Schedule",null,null,null,null,"Lighting Schedule",null,null,null,null,"Lighting Schedule"]
["Plug Load Schedule",null,null,null,null,"Plug Load Schedule",null,null,null,null,"Plug Load Schedule",null,null,null,null,"Plug Load Schedule"]
["Ventilation Schedule",null,null,null,null,"Ventilation Schedule",null,null,null,null,"Ventilation Schedule",null,null,null,null,"Ventilation Schedule"]
["Indoor Heating Setpoint/Setback Temperature Schedule",null,null,null,null,"Indoor Heating Setpoint/Setback Temperature Schedule",null,null,null,null,"Indoor Heating Setpoint/Setback Temperature Schedule",null,null,null,null,"Indoor Heating Setpoint/Setback Temperature Schedule"]
["Indoor Cooling Setpoint/Setback Temperature Schedule",null,null,null,null,"Indoor Cooling Setpoint/Setback Temperature Schedule",null,null,null,null,"Indoor Cooling Setpoint/Setback Temperature Schedule",null,null,null,null,"Indoor Cooling Setpoint/Setback Temperature Schedule"]
["BUILDING ENVELOPE",null,null,null,null,{"$f":"A51","v":"BUILDING ENVELOPE"},null,null,null,null,"BUILDING ENVELOPE",null,null,null,null,"BUILDING ENVELOPE"]
["Roof assembly (effective) U-value",null,null,".",null,"Roof assembly (effective) U-value",null,null,".",null,{"$f":"F52","v":"Roof assembly (effective) U-value"},null,null,".",null,{"$f":"K52","v":"Roof assembly (effective) U-value"},null,null,"."]
["External above grade wall assembly (effective) U-value\n(provide BC Hydro Thermal Envelope Bridging Calculator or equivalent)",null,null,".",null,"External above grade wall assembly (effective) U-value\n(provide BC Hydro Thermal Envelope Bridging Calculator or equivalent)",null,null,".",null,"External above grade wall assembly (effective) U-value\n(provide BC Hydro Thermal Envelope Bridging Calculator or equivalent)",null,null,".",null,"External above grade wall assembly (effective) U-value\n(provide BC Hydro Thermal Envelope Bridging Calculator or equivalent)",null,null,"."]
["Window to wall area ratio",null,null,".",null,"Window to wall area ratio",null,null,".",null,"Window to wall area ratio",null,null,".",null,"Window to wall area ratio",null,null,"."]
["Window assembly (effective) U-value and SHGC",null,null,".",null,"Window assembly (effective) U-value and SHGC",null,null,".",null,"Window assembly (effective) U-value and SHGC",null,null,".",null,"Window assembly (effective) U-value and SHGC",null,null,"."]
["Average Infiltration Rate (L/s/m² envelope area) and Schedule (e.g. 24/7)",{"$f":"IFERROR(INDEX(BaselineParameters!$E$2:$E$45,MATCH(B$38&B$37&B$35,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"B56","v":""},null,null,"Average Infiltration Rate (L/s/m² envelope area) and Schedule (e.g. 24/7)",{"$f":"IFERROR(INDEX(BaselineParameters!$E$2:$E$45,MATCH(G$38&G$37&G$35,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"G56","v":""},null,null,"Average Infiltration Rate (L/s/m² envelope area) and Schedule (e.g. 24/7)",{"$f":"IFERROR(INDEX(BaselineParameters!$E$2:$E$45,MATCH(L$38&L$37&L$35,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"L56","v":""},null,null,"Average Infiltration Rate (L/s/m² envelope area) and Schedule (e.g. 24/7)",{"$f":"IFERROR(INDEX(BaselineParameters!$E$2:$E$45,MATCH(Q$38&Q$37&Q$35,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"Q56","v":""}]
["INTERNAL / EXTERNAL LOADS",null,null,null,null,"INTERNAL / EXTERNAL LOADS",null,null,null,null,"INTERNAL / EXTERNAL LOADS",null,null,null,null,"INTERNAL / EXTERNAL LOADS"]
["Interior Lighting Power Density (W/unit area for typical space types)",null,null,null,null,{"$f":"A58","v":"Interior Lighting Power Density (W/unit area for typical space types)"},null,null,null,null,"Interior Lighting Power Density (W/unit area for typical space types)",null,null,null,null,"Interior Lighting Power Density (W/unit area for typical space types)"]
["Interior Lighting Controls Modelled ( Yes / No )",null,null,null,null,"Interior Lighting Controls Modelled ( Yes / No )",null,null,null,null,"Interior Lighting Controls Modelled ( Yes / No )",null,null,null,null,"Interior Lighting Controls Modelled ( Yes / No )"]
["Interior Plug Load Density (W/unit area for typical space types)",null,null,null,null,"Interior Plug Load Density (W/unit area for typical space types)",null,null,null,null,"Interior Plug Load Density (building average)",null,null,null,null,"Interior Plug Load Density (building average)"]
["Elevators Load ( kW )",null,null,null,null,"Elevators Load ( kW )",null,null,null,null,"Interior Plug Load Density (building average)",null,null,null,null,"Interior Plug Load Density (building average)"]
["Total number of occupants",null,null,null,null,"Total number of occupants",null,null,null,null,"Number of occupants",null,null,null,null,"Number of occupants"]
["TERMINAL HEATING / COOLING SYSTEM",null,null,null,null,{"$f":"A63","v":"TERMINAL HEATING / COOLING SYSTEM"},null,null,null,null,{"$f":"F63","v":"TERMINAL HEATING / COOLING SYSTEM"},null,null,null,null,{"$f":"K63","v":"TERMINAL HEATING / COOLING SYSTEM"}]
["Space Heating System Source",null,null,".",null,"Space Heating System Source",null,null,".",null,{"$f":"F64","v":"Space Heating System Source"},null,null,".",null,{"$f":"K64","v":"Space Heating System Source"},null,null,"."]
["Space Heating/Cooling Terminal System Type",null,null,".",null,"Space Heating/Cooling Terminal System Type",null,null,".",null,"Space Heating/Cooling Terminal System Type",null,null,".",null,"Space Heating/Cooling Terminal System Type",null,null,"."]
["Space Heating System Description",null,null,".",null,"Space Heating System Description",null,null,".",null,"Space Heating System Description",null,null,".",null,"Space Heating System Description",null,null,"."]
["Space Cooling System Description",null,null,".",null,"Space Cooling System Description",null,null,".",null,"Space Cooling System Description",null,null,".",null,"Space Cooling System Description",null,null,"."]
["Terminal heating/cooling efficiency/COP",null,null,".",null,"Terminal heating/cooling efficiency/COP",null,null,".",null,"Terminal heating/cooling efficiency/COP",null,null,".",null,"Terminal heating/cooling efficiency/COP",null,null,"."]
["Terminal Fan Power / Efficiency (W/CFM)",null,null,".",null,"Terminal Fan Power / Efficiency (W/CFM)",null,null,".",null,"Terminal Fan Power / Efficiency (W/CFM)",null,null,".",null,"Terminal Fan Power / Efficiency (W/CFM)",null,null,"."]
["VENTILATION SYSTEM",null,null,null,null,{"$f":"A70","v":"VENTILATION SYSTEM"},null,null,null,null,{"$f":"F70","v":"VENTILATION SYSTEM"},null,null,null,null,{"$f":"K70","v":"VENTILATION SYSTEM"}]
["Ventilation Heating Source",null,null,".",null,"Ventilation Heating Source",null,null,".",null,{"$f":"F71","v":"Ventilation Heating Source"},null,null,".",null,{"$f":"K71","v":"Ventilation Heating Source"},null,null,"."]
["Ventilation Heating Type",null,null,".",null,"Ventilation Heating Type",null,null,".",null,"Ventilation Heating Type",null,null,".",null,"Ventilation Heating Type",null,null,"."]
["Ventilation System Description (heating and cooling)",null,null,".",null,"Ventilation System Description (heating and cooling)",null,null,".",null,"Ventilation System Description (heating and cooling)",null,null,".",null,"Ventilation System Description (heating and cooling)",null,null,"."]
["Ventilation heating/cooling efficiency/COP",null,null,".",null,"Ventilation heating/cooling efficiency/COP",null,null,".",null,"Ventilation heating/cooling efficiency/COP",null,null,".",null,"Ventilation heating/cooling efficiency/COP",null,null,"."]
["Central Fan Power / Efficiency (W/CFM)",null,null,".",null,"Central Fan Power / Efficiency (W/CFM)",null,null,".",null,"Central Fan Power / Efficiency (W/CFM)",null,null,".",null,"Central Fan Power / Efficiency (W/CFM)",null,null,"."]
["Building Total Mixed Air Supply Rate",null,null,".",null,"Building Total Mixed Air Supply Rate",null,null,".",null,"Building Total Mixed Air Supply Rate",null,null,".",null,"Building Total Mixed Air Supply Rate",null,null,"."]
["Building Total Outdoor Air Ventilation Rate",null,null,".",null,"Building Total Outdoor Air Ventilation Rate",null,null,".",null,"Building Total Outdoor Air Ventilation Rate",null,null,".",null,"Building Total Outdoor Air Ventilation Rate",null,null,"."]
["Exhaust Air Energy Recovery Type(s) and Description",null,null,".",null,"Exhaust Air Energy Recovery Type(s) and Description",null,null,".",null,"Exhaust Air Energy Recovery Type(s) and Description",null,null,".",null,"Exhaust Air Energy Recovery Type(s) and Description",null,null,"."]
["Exhaust Air Energy Recovery Effectiveness",{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(B$38&B$37&B$35,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},null,".",null,"Exhaust Air Energy Recovery Effectiveness",{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(G$38&G$37&G$35,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},null,".",null,"Exhaust Air Energy Recovery Effectiveness",{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(L$38&L$37&L$35,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},null,".",null,"Exhaust Air Energy Recovery Effectiveness",{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(Q$38&Q$37&Q$35,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},null,"."]
["Demand Controlled Ventilation (Yes / No)",null,null,".",null,"Demand Controlled Ventilation (Yes / No)",null,null,".",null,"Demand Controlled Ventilation (Yes / No)",null,null,".",null,"Demand Controlled Ventilation (Yes / No)",null,null,"."]
["Central Cooling Supply Air Temperature and Control",".",null,null,null,"Central Cooling Supply Air Temperature and Control",".",null,null,null,"Central Cooling Supply Air Temperature and Control",".",null,null,null,"Central Cooling Supply Air Temperature and Control","."]
["Natural Ventilation Description (Yes/No)",".",null,null,null,"Natural Ventilation Description (Yes/No)",".",null,null,null,"Natural Ventilation Description (Yes/No)",".",null,null,null,"Natural Ventilation Description (Yes/No)","."]
["CENTRAL HEATING/COOLING PLANT",null,null,null,null,{"$f":"A83","v":"CENTRAL HEATING/COOLING PLANT"},null,null,null,null,{"$f":"F83","v":"CENTRAL HEATING/COOLING PLANT"},null,null,null,null,{"$f":"K83","v":"CENTRAL HEATING/COOLING PLANT"}]
["Heating Source",null,null,".",null,{"$f":"A84","v":"Heating Source"},null,null,".",null,{"$f":"F84","v":"Heating Source"},null,null,".",null,{"$f":"K84","v":"Heating Source"},null,null,"."]
["Heating Plant Type",null,null,".",null,{"$f":"A85","v":"Heating Plant Type"},null,null,".",null,{"$f":"F85","v":"Heating Plant Type"},null,null,".",null,{"$f":"K85","v":"Heating Plant Type"},null,null,"."]
["Heating Plant Description",null,null,".",null,{"$f":"A86","v":"Heating Plant Description"},null,null,".",null,{"$f":"F86","v":"Heating Plant Description"},null,null,".",null,{"$f":"K86","v":"Heating Plant Description"},null,null,"."]
["Cooling Plant Type",null,null,".",null,"Cooling Plant Type",null,null,".",null,"Cooling Plant Type",null,null,".",null,"Cooling Plant Type",null,null,"."]
["Cooling Plant Description",null,null,".",null,"Cooling Plant Description",null,null,".",null,"Cooling Plant Description",null,null,".",null,"Cooling Plant Description",null,null,"."]
["Central Plant Heating efficiency",null,null,".",null,"Central Plant Heating efficiency",null,null,".",null,"Central Plant Heating efficiency",null,null,".",null,"Central Plant Heating efficiency",null,null,"."]
["Central Plant Cooling efficiency",null,null,".",null,"Central Plant Cooling efficiency",null,null,".",null,"Central Plant Cooling efficiency",null,null,".",null,"Central Plant Cooling efficiency",null,null,"."]
["Hot Water Pumping Efficiency (W/gpm)",null,null,".",null,"Hot Water Pumping Efficiency (W/gpm)",null,null,".",null,"Hot Water Pumping Efficiency (W/gpm)",null,null,".",null,"Hot Water Pumping Efficiency (W/gpm)",null,null,"."]
["Hot Water Pumping Control",null,null,".",null,"Hot Water Pumping Control",null,null,".",null,"Hot Water Pumping Control",null,null,".",null,"Hot Water Pumping Control",null,null,"."]
["Chilled Water Pumping Efficiency (W/gpm)",null,null,".",null,"Chilled Water Pumping Efficiency (W/gpm)",null,null,".",null,"Chilled Water Pumping Efficiency (W/gpm)",null,null,".",null,"Chilled Water Pumping Efficiency (W/gpm)",null,null,"."]
["Chilled Water Pumping Control",null,null,".",null,"Chilled Water Pumping Control",null,null,".",null,"Chilled Water Pumping Control",null,null,".",null,"Chilled Water Pumping Control",null,null,"."]
["Hot Water Supply Temperature and Reset",null,null,".",null,"Hot Water Supply Temperature and Reset",null,null,".",null,"Hot Water Supply Temperature and Reset",null,null,".",null,"Hot Water Supply Temperature and Reset",null,null,"."]
["Chilled Water Supply Temperature and Reset",null,null,".",null,"Chilled Water Supply Temperature and Reset",null,null,".",null,"Chilled Water Supply Temperature and Reset",null,null,".",null,"Chilled Water Supply Temperature and Reset",null,null,"."]
["Heat Rejection Type, Description and Efficiency",null,null,".",null,"Heat Rejection Type, Description and Efficiency",null,null,".",null,"Heat Rejection Type, Description and Efficiency",null,null,".",null,"Heat Rejection Type, Description and Efficiency",null,null,"."]
["Condenser water-side heat recovery description (if applicable)",null,null,".",null,"Condenser water-side heat recovery description (if applicable)",null,null,".",null,"Condenser water-side heat recovery description (if applicable)",null,null,".",null,"Condenser water-side heat recovery description (if applicable)",null,null,"."]
["Part-load Perfromance Reference",null,null,".",null,{"$f":"A99","v":"Part-load Perfromance Reference"},null,null,".",null,{"$f":"F99","v":"Part-load Perfromance Reference"},null,null,".",null,{"$f":"K99","v":"Part-load Perfromance Reference"},null,null,"."]
["Annual Space Heating Load Assignment (% Heat Pump  / % Boiler)",null,null,".",null,{"$f":"A100","v":"Annual Space Heating Load Assignment (% Heat Pump  / % Boiler)"},null,null,".",null,{"$f":"F100","v":"Annual Space Heating Load Assignment (% Heat Pump  / % Boiler)"},null,null,".",null,{"$f":"K100","v":"Annual Space Heating Load Assignment (% Heat Pump  / % Boiler)"},null,null,"."]
["DOMESTIC HOT WATER",null,null,null,null,{"$f":"A101","v":"DOMESTIC HOT WATER"},null,null,null,null,{"$f":"F101","v":"DOMESTIC HOT WATER"},null,null,null,null,{"$f":"K101","v":"DOMESTIC HOT WATER"}]
["DHW Heating Source",null,null,".",null,{"$f":"A102","v":"DHW Heating Source"},null,null,".",null,{"$f":"F102","v":"DHW Heating Source"},null,null,".",null,{"$f":"K102","v":"DHW Heating Source"},null,null,"."]
["DHW Heating Plant Type",null,null,".",null,{"$f":"A103","v":"DHW Heating Plant Type"},null,null,".",null,{"$f":"F103","v":"DHW Heating Plant Type"},null,null,".",null,{"$f":"K103","v":"DHW Heating Plant Type"},null,null,"."]
["DHW Heating Plant Description",null,null,".",null,{"$f":"A104","v":"DHW Heating Plant Description"},null,null,".",null,{"$f":"F104","v":"DHW Heating Plant Description"},null,null,".",null,{"$f":"K104","v":"DHW Heating Plant Description"},null,null,"."]
["DHW Heating Efficiency",null,null,".",null,"DHW Heating Efficiency",null,null,".",null,"DHW Heating Efficiency",null,null,".",null,"DHW Heating Efficiency",null,null,"."]
["Low flow fixtures if applicable (Yes / No)",null,null,".",null,"Low flow fixtures if applicable (Yes / No)",null,null,".",null,"Low flow fixtures if applicable (Yes / No)",null,null,".",null,"Low flow fixtures if applicable (Yes / No)",null,null,"."]
["Average Daily Consumption (Gallon per Day)",null,null,".",null,"Average Daily Consumption (Gallon per Day)",null,null,".",null,"Average Daily Consumption (Gallon per Day)",null,null,".",null,"Average Daily Consumption (Gallon per Day)",null,null,"."]
["Additional Description (heat recovery, preheat, etc.)",null,null,".",null,"Additional Description (heat recovery, preheat, etc.)",null,null,".",null,"Additional Description (heat recovery, preheat, etc.)",null,null,".",null,"Additional Description (heat recovery, preheat, etc.)",null,null,"."]
["PROCESS LOADS DESCRIPTION (if applicable)",null,null,null,null,{"$f":"A109","v":"PROCESS LOADS DESCRIPTION (if applicable)"},null,null,null,null,{"$f":"F109","v":"PROCESS LOADS DESCRIPTION (if applicable)"},null,null,null,null,{"$f":"K109","v":"PROCESS LOADS DESCRIPTION (if applicable)"}]
["Process HVAC",null,null,".",null,"Process HVAC",null,null,".",null,"Process HVAC",null,null,".",null,"Process HVAC",null,null,"."]
["Refrigeration",".",null,null,null,"Refrigeration",".",null,null,null,"Refrigeration",".",null,null,null,"Refrigeration","."]
["IT Process Load",".",null,null,null,"IT Process Load",".",null,null,null,"IT Process Load",".",null,null,null,"IT Process Load","."]
["Cooking",null,null,".",null,"Cooking",null,null,".",null,"Cooking",null,null,".",null,"Cooking",null,null,"."]
["Other Process Loads",null,null,".",null,"Other Process Loads",null,null,".",null,"Other Process Loads",null,null,".",null,"Other Process Loads",null,null,"."]
["RENEWABLE ENERGY  (if applicable)",null,null,null,null,"RENEWABLE ENERGY  (if applicable)",null,null,null,null,"RENEWABLE ENERGY  (if applicable)",null,null,null,null,"RENEWABLE ENERGY  (if applicable)"]
["Type and Description",null,null,".",null,"Type and Description",".",null,".",null,"Type and Description",".",null,".",null,"Type and Description",".",null,"."]
["UTILITY RATES",null,null,null,null,"UTILITY RATES",null,null,null,null,"UTILITY RATES",null,null,null,null,"UTILITY RATES"]
["Electric Demand Cost ($/kW)",".",null,null,null,"Electric Demand Cost ($/kW)",".",null,null,null,"Electric Demand Cost ($/kW)",".",null,null,null,"Electric Demand Cost ($/kW)","."]
["Electric Energy Cost ($/kWh)",".",null,null,null,"Electric Energy Cost ($/kWh)",".",null,null,null,"Electric Energy Cost ($/kWh)",".",null,null,null,"Electric Energy Cost ($/kWh)","."]
["Fuel Energy Cost ($/GJ)\nInclude carbon tax",{"$f":"IFERROR('1- pre screen'!B46+'1- pre screen'!B47*'1- pre screen'!B70/1000,\"\")","v":""},null,null,null,"Fuel Energy Cost ($/GJ)\nInclude carbon tax",{"$f":"IFERROR('1- pre screen'!C46+'1- pre screen'!C47*'1- pre screen'!C70/1000,\"\")","v":""},null,null,null,"Fuel Energy Cost ($/GJ)\nInclude carbon tax",{"$f":"IFERROR('1- pre screen'!D46+'1- pre screen'!D47*'1- pre screen'!D70/1000,\"\")","v":""},null,null,null,"Fuel Energy Cost ($/GJ)\nInclude carbon tax",{"$f":"IFERROR('1- pre screen'!E46+'1- pre screen'!E47*'1- pre screen'!E70/1000,\"\")","v":""}]
["Carbon Offset Credit if applicable ($/tCO2e)",{"$f":"'1- pre screen'!B48","v":0},null,null,null,"Carbon Offset Credit if applicable ($/tCO2e)",{"$f":"$B$121","v":0},null,null,null,"Carbon Offset Credit if applicable ($/tCO2e)",{"$f":"$B$121","v":0},null,null,null,"Carbon Offset Credit if applicable ($/tCO2e)",{"$f":"$B$121","v":0}]
["PURCHASED ENERGY RATES (DES if applicable)",null,null,null,null,"PURCHASED ENERGY RATES (DES if applicable)",null,null,null,null,"PURCHASED ENERGY RATES (DES if applicable)",null,null,null,null,"PURCHASED ENERGY RATES (DES if applicable)"]
["Hot water Cost",".",null,null,null,"Hot water Cost",".",null,null,null,"Hot water Cost",".",null,null,null,"Hot water Cost","."]
["Steam Cost",".",null,null,null,"Steam Cost",".",null,null,null,"Steam Cost",".",null,null,null,"Steam Cost","."]
["Chilled Water Cost",".",null,null,null,"Chilled Water Cost",".",null,null,null,"Chilled Water Cost",".",null,null,null,"Chilled Water Cost","."]
["Other",".",null,null,null,"Other",".",null,null,null,"Other",".",null,null,null,"Other","."]
[]
[]
[]
[]
["3. Proposed Project Description and HVAC System and Modelling Methodology"]
["Provide brief description of the Proposed HVAC system and modelling approach including workarounds (if any).\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4. Energy Study Cost"]
["4.1 - Energy Modelling"]
["Energy Modelling Tasks","Company ","Performed By","Hours","Hourly Rate","Task Total"]
[null,null,null,null,null,{"$f":"D155*E155","v":0}]
[null,null,null,null,null,{"$f":"D156*E156","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,"Sum",{"$f":"SUM(F155:F166)","v":0}]
["4.2 - Primary (Lead) Consultant "]
["Primary (Lead) Consultant Tasks","Company ","Performed By","Hours","Hourly Rate","Task Total"]
[null,null,null,null,null,{"$f":"D170*E170","v":0}]
[null,null,null,null,null,{"$f":"D171*E171","v":0}]
[null,null,null,null,null,{"$f":"D172*E172","v":0}]
[null,null,null,null,"Sum",{"$f":"SUM(F170:F172)","v":0}]
["4.3 - Architect (if applicable)"]
["Architect Tasks","Company ","Performed By","Hours","Hourly Rate","Task Total"]
[null,null,null,null,null,{"$f":"D176*E176","v":0}]
[null,null,null,null,null,{"$f":"D177*E177","v":0}]
[null,null,null,null,null,{"$f":"D178*E178","v":0}]
[null,null,null,null,"Sum",{"$f":"SUM(F176:F178)","v":0}]
["4.4 - Mechanical Consultant (if applicable)"]
["Mechanical Consultant Tasks","Company ","Performed By","Hours","Hourly Rate","Task Total"]
[null,null,null,null,null,{"$f":"D182*E182","v":0}]
[null,null,null,null,null,{"$f":"D183*E183","v":0}]
[null,null,null,null,null,{"$f":"D184*E184","v":0}]
[null,null,null,null,"Sum",{"$f":"SUM(F182:F184)","v":0}]
["4.5 - Cost Consultant"]
["Cost Consultant Tasks","Company ","Performed By","Hours","Hourly Rate","Task Total"]
[null,null,null,null,null,{"$f":"D188*E188","v":0}]
[null,null,null,null,null,{"$f":"D189*E189","v":0}]
[null,null,null,null,null,{"$f":"D190*E190","v":0}]
[null,null,null,null,"Sum",{"$f":"SUM(F188:F190)","v":0}]
["4.6 - Electrical Consultant (if applicable)"]
["Electrical Consultant Tasks","Company ","Performed By","Hours","Hourly Rate","Task Total"]
["Start-up meetings",null,null,null,null,{"$f":"D194*E194","v":0}]
["Coordination with Modeler",null,null,null,null,{"$f":"D195*E195","v":0}]
["Coordination with Cost Consultant",null,null,null,null,{"$f":"D196*E196","v":0}]
[null,null,null,null,"Sum",{"$f":"SUM(F194:F196)","v":0}]
[]
[null,null,null,null,"Total Energy Study Cost",{"$f":"F167+F173+F179+F185+F191+F197","v":0}]
[null,null,null,null,null,{"$f":"IF(F199>15000,\"Maximum study funding available is $15,000\",\"\")","v":""}]
["E-Signature"]

{"sheet":"3- Study Inputs","index":6,"n_rows":131,"n_cols":19,"rows_kept":131,"cut":false,"hidden":false,"merged":[[32,0,32,2],[32,5,32,7],[32,10,32,12],[32,15,32,17],[33,1,33,2],[33,6,33,7],[33,11,33,12],[40,1,40,2],[40,6,40,7],[40,11,40,12],[40,16,40,17],[34,1,34,2],[34,6,34,7],[34,11,34,12],[34,16,34,17],[35,1,35,2],[35,6,35,7],[35,11,35,12],[35,16,35,17],[39,1,39,2],[39,6,39,7],[39,11,39,12],[39,16,39,17],[33,16,33,17],[43,1,43,2],[43,6,43,7],[43,11,43,12],[43,16,43,17],[44,1,44,2],[45,1,45,2],[41,1,41,2],[41,6,41,7],[41,11,41,12],[41,16,41,17],[42,0,42,2],[42,5,42,7],[42,10,42,12],[42,15,42,17],[44,6,44,7],[45,6,45,7],[44,11,44,12],[45,11,45,12],[44,16,44,17],[45,16,45,17],[38,1,38,2],[38,6,38,7],[38,11,38,12],[38,16,38,17],[36,1,36,2],[36,6,36,7],[36,11,36,12],[36,16,36,17],[37,1,37,2],[37,6,37,7],[37,11,37,12],[37,16,37,17],[49,0,49,2],[49,5,49,7],[49,10,49,12],[56,1,56,2],[57,1,57,2],[58,1,58,2],[49,15,49,17],[46,1,46,2],[47,1,47,2],[47,6,47,7],[47,11,47,12],[47,16,47,17],[48,1,48,2],[48,6,48,7],[48,11,48,12],[48,16,48,17],[46,6,46,7],[46,11,46,12],[46,16,46,17],[59,1,59,2],[59,6,59,7],[59,11,59,12],[59,16,59,17],[56,16,56,17],[57,16,57,17],[58,16,58,17],[55,0,55,2],[55,5,55,7],[55,10,55,12],[60,6,60,7],[60,11,60,12],[60,16,60,17],[56,6,56,7],[57,6,57,7],[58,6,58,7],[56,11,56,12],[57,11,57,12],[58,11,58,12],[123,1,123,2],[123,6,123,7],[123,11,123,12],[123,16,123,17],[124,1,124,2],[124,6,124,7],[124,11,124,12],[124,16,124,17],[130,0,147,4],[130,6,194,17],[115,0,115,2],[115,5,115,7],[115,10,115,12],[115,15,115,17],[116,1,116,2],[116,6,116,7],[116,11,116,12],[116,16,116,17],[99,0,99,2],[99,5,99,7],[99,10,99,12],[99,15,99,17],[107,0,107,2],[109,1,109,2],[110,1,110,2],[113,0,113,2],[113,5,113,7],[113,10,113,12],[113,15,113,17],[109,6,109,7],[110,6,110,7],[110,11,110,12],[110,16,110,17],[79,1,79,2],[80,1,80,2],[81,0,81,2],[81,5,81,7],[81,10,81,12],[79,16,79,17],[80,16,80,17],[81,15,81,17],[109,11,109,12],[109,16,109,17],[79,6,79,7],[80,6,80,7],[79,11,79,12],[80,11,80,12],[61,15,61,17],[68,15,68,17],[107,5,107,7],[107,10,107,12],[107,15,107,17],[25,1,25,2],[25,4,25,5],[2,0,2,1],[6,0,7,0],[8,1,8,5],[11,0,12,0],[19,0,20,0],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[55,15,55,17],[61,0,61,2],[61,5,61,7],[61,10,61,12],[68,0,68,2],[68,5,68,7],[68,10,68,12],[60,1,60,2],[122,11,122,12],[122,16,122,17],[120,0,120,2],[120,5,120,7],[120,10,120,12],[118,1,118,2],[118,6,118,7],[117,11,117,12],[120,15,120,17],[121,1,121,2],[121,6,121,7],[121,11,121,12],[121,16,121,17],[122,1,122,2],[122,6,122,7],[117,16,117,17],[118,16,118,17],[119,16,119,17],[119,1,119,2],[119,6,119,7],[119,11,119,12],[117,1,117,2],[117,6,117,7],[118,11,118,12]]}
["CleanBC New Construction Incentives"]
["Energy Study Inputs"]
["Grey cells for user inputs (only where different from proposal)",null,"BC Hydro Ref # >>>",{"$f":"'2- Proposal'!D3","v":"BCH-00000"}]
[null,null,"Proposal Date  >>>",null,"Day-Month-Year"]
[]
["1. General Information"]
["Customer Information"]
[]
["Organization",{"$f":"'2- Proposal'!B10:F10","v":"Organization name"}]
["Customer",{"$f":"'2- Proposal'!B11","v":"Company Name"},{"$f":"'2- Proposal'!C11","v":"contact name"},{"$f":"'2- Proposal'!D11","v":"phone"},{"$f":"'2- Proposal'!E11","v":"email"},{"$f":"'2- Proposal'!F11","v":"address"}]
[]
["Consultants Details"]
[]
["Primary (Lead) Consultant",{"$f":"'2- Proposal'!B15","v":"Company Name"},{"$f":"'2- Proposal'!C15","v":"contact name"},{"$f":"'2- Proposal'!D15","v":"phone"},{"$f":"'2- Proposal'!E15","v":"email"},{"$f":"'2- Proposal'!F15","v":"address"}]
["Energy Modeller",{"$f":"'2- Proposal'!B16","v":"Company Name"},{"$f":"'2- Proposal'!C16","v":"contact name"},{"$f":"'2- Proposal'!D16","v":"phone"},{"$f":"'2- Proposal'!E16","v":"email"},{"$f":"'2- Proposal'!F16","v":"address"}]
["Mechanical Consultant",{"$f":"'2- Proposal'!B17","v":"Company Name"},{"$f":"'2- Proposal'!C17","v":"contact name"},{"$f":"'2- Proposal'!D17","v":"phone"},{"$f":"'2- Proposal'!E17","v":"email"},{"$f":"'2- Proposal'!F17","v":"address"}]
["Cost Consultant",{"$f":"'2- Proposal'!B18","v":"Company Name"},{"$f":"'2- Proposal'!C18","v":"contact name"},{"$f":"'2- Proposal'!D18","v":"phone"},{"$f":"'2- Proposal'!E18","v":"email"},{"$f":"'2- Proposal'!F18","v":"address"}]
["General Contractor",{"$f":"'2- Proposal'!B19","v":"Company Name"},{"$f":"'2- Proposal'!C19","v":"contact name"},{"$f":"'2- Proposal'!D19","v":"phone"},{"$f":"'2- Proposal'!E19","v":"email"},{"$f":"'2- Proposal'!F19","v":"address"}]
[]
["General Project Information"]
[]
["Project Name",{"$f":"'2- Proposal'!B23:F23","v":"Project Name"}]
["Site Address",{"$f":"'2- Proposal'!B24:F24","v":"Site Address"}]
["Site City",{"$f":"'2- Proposal'!B25:F25","v":"Site City"}]
["BC Hydro Key Account Manager (or BC Hydro Representative)",{"$f":"'2- Proposal'!D5","v":"KAM's name"}]
["BC Hydro Sponsored Energy Manager",{"$f":"'2- Proposal'!B26:C26","v":"Energy manager name"},null,{"$f":"'2- Proposal'!D26","v":"phone"},{"$f":"'2- Proposal'!E26:F26","v":"email"}]
[]
[]
[]
[]
["2.1 Energy Model Input Parameters - BUILDING TYPE 1",null,null,null,null,"2.2 Energy Model Input Parameters - BUILDING TYPE 2 (if applicable)",null,null,null,null,"2.3 Energy Model Input Parameters - BUILDING TYPE 3 (if applicable)",null,null,null,null,"2.4 Energy Model Input Parameters - BUILDING TYPE 4 (if applicable)"]
["Metric Units","Baseline\n(Concept Design Model)","Proposed Building Design","EM # (up to 5)\nwhere applicable",null,"Metric Units","Baseline\n(Concept Design Model)","Proposed Building Design","EM # (up to 5)\nwhere applicable",null,"Metric Units","Baseline\n(Concept Design Model)","Proposed Building Design","EM # (up to 5)\nwhere applicable",null,"Metric Units","Baseline\n(Concept Design Model)","Proposed Building Design","EM # (up to 5)\nwhere applicable"]
[{"$f":"'2- Proposal'!A34:C34","v":"GENERAL"},null,null,null,null,{"$f":"'2- Proposal'!F34:H34","v":"GENERAL"},null,null,null,null,{"$f":"'2- Proposal'!K34:M34","v":"GENERAL"},null,null,null,null,{"$f":"'2- Proposal'!P34:R34","v":"GENERAL"}]
[{"$f":"'2- Proposal'!A35","v":"Energy Code (Energy Step Code)"},{"$f":"'2- Proposal'!B35:C35","v":0},null,null,null,{"$f":"'2- Proposal'!F35","v":"Energy Code (Energy Step Code)"},{"$f":"'2- Proposal'!G35:H35","v":0},null,null,null,{"$f":"'2- Proposal'!K35","v":"Energy Code"},{"$f":"'2- Proposal'!L35:M35","v":0},null,null,null,{"$f":"'2- Proposal'!P35","v":"Energy Code"},{"$f":"'2- Proposal'!Q35:R35","v":0}]
[{"$f":"'2- Proposal'!A36","v":"Modelling Software"},{"$f":"'2- Proposal'!B36:C36","v":0},null,null,null,{"$f":"'2- Proposal'!F36","v":"Modelling Software"},{"$f":"'2- Proposal'!G36:H36","v":0},null,null,null,{"$f":"'2- Proposal'!K36","v":"Modelling Software"},{"$f":"'2- Proposal'!L36:M36","v":0},null,null,null,{"$f":"'2- Proposal'!P36","v":"Modelling Software"},{"$f":"'2- Proposal'!Q36:R36","v":0}]
[{"$f":"'2- Proposal'!A37","v":"ASHRAE Climate Zone"},{"$f":"'2- Proposal'!B37:C37","v":0},null,null,null,{"$f":"'2- Proposal'!F37","v":"ASHRAE Climate Zone"},{"$f":"'2- Proposal'!G37:H37","v":0},null,null,null,{"$f":"'2- Proposal'!K37","v":"Climate Zone"},{"$f":"'2- Proposal'!L37:M37","v":0},null,null,null,{"$f":"'2- Proposal'!P37","v":"Climate Zone"},{"$f":"'2- Proposal'!Q37:R37","v":0}]
[{"$f":"'2- Proposal'!A38","v":"Building Type"},{"$f":"'2- Proposal'!B38:C38","v":0},null,null,null,{"$f":"'2- Proposal'!F38","v":"Building Type"},{"$f":"'2- Proposal'!G38:H38","v":0},null,null,null,{"$f":"'2- Proposal'!K38","v":"Building Type"},{"$f":"'2- Proposal'!L38:M38","v":0},null,null,null,{"$f":"'2- Proposal'!P38","v":"Building Type"},{"$f":"'2- Proposal'!Q38:R38","v":0}]
[{"$f":"'2- Proposal'!A39","v":"Conditioned Area (m2)"},{"$f":"'2- Proposal'!B39:C39","v":0},null,null,null,{"$f":"'2- Proposal'!F39","v":"Conditioned Area (m2)"},{"$f":"'2- Proposal'!G39:H39","v":0},null,null,null,{"$f":"'2- Proposal'!K39","v":"Conditioned Area (m2)"},{"$f":"'2- Proposal'!L39:M39","v":0},null,null,null,{"$f":"'2- Proposal'!P39","v":"Conditioned Area (m2)"},{"$f":"'2- Proposal'!Q39:R39","v":0}]
[{"$f":"'2- Proposal'!A40","v":"Maximum Allowable Heat Loss Rate (W/m2) - Step Code"},{"$f":"'2- Proposal'!B40:C40","v":""},null,null,null,{"$f":"'2- Proposal'!F40","v":"Maximum Allowable Heat Loss Rate (W/m2) - Step Code"},{"$f":"'2- Proposal'!G40:H40","v":""},null,null,null,{"$f":"'2- Proposal'!K40","v":"Maximum Allowable Heat Loss Rate (W/m2) - Step Code"},{"$f":"'2- Proposal'!L40:M40","v":""},null,null,null,{"$f":"'2- Proposal'!P40","v":"Maximum Allowable Heat Loss Rate (W/m2) - Step Code"},{"$f":"'2- Proposal'!Q40:R40","v":""}]
[{"$f":"'2- Proposal'!A41","v":"Concept Design Heat Loss Rate (W/m2) - if Step Code applicable"},{"$f":"'2- Proposal'!B41:C41","v":0},null,null,null,{"$f":"'2- Proposal'!F41","v":"Concept Design Heat Loss Rate (W/m2) - if Step Code applicable"},{"$f":"'2- Proposal'!G41:H41","v":0},null,null,null,{"$f":"'2- Proposal'!K41","v":"Concept Design Heat Loss Rate (W/m2) - if Step Code applicable"},{"$f":"'2- Proposal'!L41:M41","v":0},null,null,null,{"$f":"'2- Proposal'!P41","v":"Concept Design Heat Loss Rate (W/m2) - if Step Code applicable"},{"$f":"'2- Proposal'!Q41:R41","v":0}]
[{"$f":"'2- Proposal'!A42","v":"Number of Floors"},{"$f":"'2- Proposal'!B42:C42","v":0},null,null,null,{"$f":"'2- Proposal'!F42","v":"Number of Floors"},{"$f":"'2- Proposal'!G42:H42","v":0},null,null,null,{"$f":"'2- Proposal'!K42","v":"Number of Floors"},{"$f":"'2- Proposal'!L42:M42","v":0},null,null,null,{"$f":"'2- Proposal'!P42","v":"Number of Floors"},{"$f":"'2- Proposal'!Q42:R42","v":0}]
[{"$f":"'2- Proposal'!A43","v":"Heating Fuel Type (if applicable)"},{"$f":"'2- Proposal'!B43:C43","v":0},null,null,null,{"$f":"'2- Proposal'!F43","v":"Heating Fuel Type (if applicable)"},{"$f":"'2- Proposal'!G43:H43","v":0},null,null,null,{"$f":"'2- Proposal'!K43","v":"Heating Fuel Type (if applicable)"},{"$f":"'2- Proposal'!L43:M43","v":0},null,null,null,{"$f":"'2- Proposal'!P43","v":"Heating Fuel Type (if applicable)"},{"$f":"'2- Proposal'!Q43:R43","v":0}]
[{"$f":"'2- Proposal'!A44:C44","v":"OCCUPANCY AND OPERATING SCHEDULES"},null,null,null,null,{"$f":"'2- Proposal'!F44:H44","v":"OCCUPANCY AND OPERATING SCHEDULES"},null,null,null,null,{"$f":"'2- Proposal'!K44:M44","v":"OCCUPANCY AND OPERATING SCHEDULES"},null,null,null,null,{"$f":"'2- Proposal'!P44:R44","v":"OCCUPANCY AND OPERATING SCHEDULES"}]
[{"$f":"'2- Proposal'!A45","v":"Occupancy Schedules"},{"$f":"'2- Proposal'!B45:C45","v":0},null,null,null,{"$f":"'2- Proposal'!F45","v":"Occupancy Schedules"},{"$f":"'2- Proposal'!G45:H45","v":0},null,null,null,{"$f":"'2- Proposal'!K45","v":"Occupancy Schedules"},{"$f":"'2- Proposal'!L45:M45","v":0},null,null,null,{"$f":"'2- Proposal'!P45","v":"Occupancy Schedules"},{"$f":"'2- Proposal'!Q45:R45","v":0}]
[{"$f":"'2- Proposal'!A46","v":"Lighting Schedule"},{"$f":"'2- Proposal'!B46:C46","v":0},null,null,null,{"$f":"'2- Proposal'!F46","v":"Lighting Schedule"},{"$f":"'2- Proposal'!G46:H46","v":0},null,null,null,{"$f":"'2- Proposal'!K46","v":"Lighting Schedule"},{"$f":"'2- Proposal'!L46:M46","v":0},null,null,null,{"$f":"'2- Proposal'!P46","v":"Lighting Schedule"},{"$f":"'2- Proposal'!Q46:R46","v":0}]
[{"$f":"'2- Proposal'!A47","v":"Plug Load Schedule"},{"$f":"'2- Proposal'!B47:C47","v":0},null,null,null,{"$f":"'2- Proposal'!F47","v":"Plug Load Schedule"},{"$f":"'2- Proposal'!G47:H47","v":0},null,null,null,{"$f":"'2- Proposal'!K47","v":"Plug Load Schedule"},{"$f":"'2- Proposal'!L47:M47","v":0},null,null,null,{"$f":"'2- Proposal'!P47","v":"Plug Load Schedule"},{"$f":"'2- Proposal'!Q47:R47","v":0}]
[{"$f":"'2- Proposal'!A48","v":"Ventilation Schedule"},{"$f":"'2- Proposal'!B48:C48","v":0},null,null,null,{"$f":"'2- Proposal'!F48","v":"Ventilation Schedule"},{"$f":"'2- Proposal'!G48:H48","v":0},null,null,null,{"$f":"'2- Proposal'!K48","v":"Ventilation Schedule"},{"$f":"'2- Proposal'!L48:M48","v":0},null,null,null,{"$f":"'2- Proposal'!P48","v":"Ventilation Schedule"},{"$f":"'2- Proposal'!Q48:R48","v":0}]
[{"$f":"'2- Proposal'!A49","v":"Indoor Heating Setpoint/Setback Temperature Schedule"},{"$f":"'2- Proposal'!B49:C49","v":0},null,null,null,{"$f":"'2- Proposal'!F49","v":"Indoor Heating Setpoint/Setback Temperature Schedule"},{"$f":"'2- Proposal'!G49:H49","v":0},null,null,null,{"$f":"'2- Proposal'!K49","v":"Indoor Heating Setpoint/Setback Temperature Schedule"},{"$f":"'2- Proposal'!L49:M49","v":0},null,null,null,{"$f":"'2- Proposal'!P49","v":"Indoor Heating Setpoint/Setback Temperature Schedule"},{"$f":"'2- Proposal'!Q49:R49","v":0}]
[{"$f":"'2- Proposal'!A50","v":"Indoor Cooling Setpoint/Setback Temperature Schedule"},{"$f":"'2- Proposal'!B50:C50","v":0},null,null,null,{"$f":"'2- Proposal'!F50","v":"Indoor Cooling Setpoint/Setback Temperature Schedule"},{"$f":"'2- Proposal'!G50:H50","v":0},null,null,null,{"$f":"'2- Proposal'!K50","v":"Indoor Cooling Setpoint/Setback Temperature Schedule"},{"$f":"'2- Proposal'!L50:M50","v":0},null,null,null,{"$f":"'2- Proposal'!P50","v":"Indoor Cooling Setpoint/Setback Temperature Schedule"},{"$f":"'2- Proposal'!Q50:R50","v":0}]
[{"$f":"'2- Proposal'!A51:C51","v":"BUILDING ENVELOPE"},null,null,null,null,{"$f":"'2- Proposal'!F51:H51","v":"BUILDING ENVELOPE"},null,null,null,null,{"$f":"'2- Proposal'!K51:M51","v":"BUILDING ENVELOPE"},null,null,null,null,{"$f":"'2- Proposal'!P51:R51","v":"BUILDING ENVELOPE"}]
[{"$f":"'2- Proposal'!A52","v":"Roof assembly (effective) U-value"},{"$f":"'2- Proposal'!B52:C52","v":0},{"$f":"'2- Proposal'!C52:D52","v":0},{"$f":"'2- Proposal'!D52","v":"."},null,{"$f":"'2- Proposal'!F52","v":"Roof assembly (effective) U-value"},{"$f":"'2- Proposal'!G52:H52","v":0},{"$f":"'2- Proposal'!H52:I52","v":0},{"$f":"'2- Proposal'!I52","v":"."},null,{"$f":"'2- Proposal'!K52","v":"Roof assembly (effective) U-value"},{"$f":"'2- Proposal'!L52:M52","v":0},{"$f":"'2- Proposal'!M52:N52","v":0},{"$f":"'2- Proposal'!N52","v":"."},null,{"$f":"'2- Proposal'!P52","v":"Roof assembly (effective) U-value"},{"$f":"'2- Proposal'!Q52:R52","v":0},{"$f":"'2- Proposal'!R52:S52","v":0},{"$f":"'2- Proposal'!S52","v":"."}]
["External above grade wall assembly (effective) U-value\n(provide BC Hydro Thermal Envelope Bridging Calculator or equivalent)",{"$f":"'2- Proposal'!B53:C53","v":0},{"$f":"'2- Proposal'!C53:D53","v":0},{"$f":"'2- Proposal'!D53","v":"."},null,"External above grade wall assembly (effective) U-value\n(provide BC Hydro Thermal Envelope Bridging Calculator or equivalent)",{"$f":"'2- Proposal'!G53:H53","v":0},{"$f":"'2- Proposal'!H53:I53","v":0},{"$f":"'2- Proposal'!I53","v":"."},null,"External above grade wall assembly (effective) U-value\n(provide BC Hydro Thermal Envelope Bridging Calculator or equivalent)",{"$f":"'2- Proposal'!L53:M53","v":0},{"$f":"'2- Proposal'!M53:N53","v":0},{"$f":"'2- Proposal'!N53","v":"."},null,"External above grade wall assembly (effective) U-value\n(provide BC Hydro Thermal Envelope Bridging Calculator or equivalent)",{"$f":"'2- Proposal'!Q53:R53","v":0},{"$f":"'2- Proposal'!R53:S53","v":0},{"$f":"'2- Proposal'!S53","v":"."}]
[{"$f":"'2- Proposal'!A54","v":"Window to wall area ratio"},{"$f":"'2- Proposal'!B54:C54","v":0},{"$f":"'2- Proposal'!C54:D54","v":0},{"$f":"'2- Proposal'!D54","v":"."},null,{"$f":"'2- Proposal'!F54","v":"Window to wall area ratio"},{"$f":"'2- Proposal'!G54:H54","v":0},{"$f":"'2- Proposal'!H54:I54","v":0},{"$f":"'2- Proposal'!I54","v":"."},null,{"$f":"'2- Proposal'!K54","v":"Window to wall area ratio"},{"$f":"'2- Proposal'!L54:M54","v":0},{"$f":"'2- Proposal'!M54:N54","v":0},{"$f":"'2- Proposal'!N54","v":"."},null,{"$f":"'2- Proposal'!P54","v":"Window to wall area ratio"},{"$f":"'2- Proposal'!Q54:R54","v":0},{"$f":"'2- Proposal'!R54:S54","v":0},{"$f":"'2- Proposal'!S54","v":"."}]
[{"$f":"'2- Proposal'!A55","v":"Window assembly (effective) U-value and SHGC"},{"$f":"'2- Proposal'!B55:C55","v":0},{"$f":"'2- Proposal'!C55:D55","v":0},{"$f":"'2- Proposal'!D55","v":"."},null,{"$f":"'2- Proposal'!F55","v":"Window assembly (effective) U-value and SHGC"},{"$f":"'2- Proposal'!G55:H55","v":0},{"$f":"'2- Proposal'!H55:I55","v":0},{"$f":"'2- Proposal'!I55","v":"."},null,{"$f":"'2- Proposal'!K55","v":"Window assembly (effective) U-value and SHGC"},{"$f":"'2- Proposal'!L55:M55","v":0},{"$f":"'2- Proposal'!M55:N55","v":0},{"$f":"'2- Proposal'!N55","v":"."},null,{"$f":"'2- Proposal'!P55","v":"Window assembly (effective) U-value and SHGC"},{"$f":"'2- Proposal'!Q55:R55","v":0},{"$f":"'2- Proposal'!R55:S55","v":0},{"$f":"'2- Proposal'!S55","v":"."}]
[{"$f":"'2- Proposal'!A56","v":"Average Infiltration Rate (L/s/m² envelope area) and Schedule (e.g. 24/7)"},{"$f":"IFERROR(INDEX(BaselineParameters!$E$2:$E$45,MATCH(B37&B36&B34,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"B55","v":""},null,null,{"$f":"'2- Proposal'!F56","v":"Average Infiltration Rate (L/s/m² envelope area) and Schedule (e.g. 24/7)"},{"$f":"IFERROR(INDEX(BaselineParameters!$E$2:$E$45,MATCH(G37&G36&G34,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"G55","v":""},null,null,{"$f":"'2- Proposal'!K56","v":"Average Infiltration Rate (L/s/m² envelope area) and Schedule (e.g. 24/7)"},{"$f":"IFERROR(INDEX(BaselineParameters!$E$2:$E$45,MATCH(L37&L36&L34,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"L55","v":""},null,null,{"$f":"'2- Proposal'!P56","v":"Average Infiltration Rate (L/s/m² envelope area) and Schedule (e.g. 24/7)"},{"$f":"IFERROR(INDEX(BaselineParameters!$E$2:$E$45,MATCH(Q37&Q36&Q34,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"Q55","v":""}]
[{"$f":"'2- Proposal'!A57:C57","v":"INTERNAL / EXTERNAL LOADS"},null,null,null,null,{"$f":"'2- Proposal'!F57:H57","v":"INTERNAL / EXTERNAL LOADS"},null,null,null,null,{"$f":"'2- Proposal'!K57:M57","v":"INTERNAL / EXTERNAL LOADS"},null,null,null,null,{"$f":"'2- Proposal'!P57:R57","v":"INTERNAL / EXTERNAL LOADS"}]
[{"$f":"'2- Proposal'!A58","v":"Interior Lighting Power Density (W/unit area for typical space types)"},{"$f":"'2- Proposal'!B58:C58","v":0},null,null,null,{"$f":"'2- Proposal'!F58","v":"Interior Lighting Power Density (W/unit area for typical space types)"},{"$f":"'2- Proposal'!G58:H58","v":0},null,null,null,{"$f":"'2- Proposal'!K58","v":"Interior Lighting Power Density (W/unit area for typical space types)"},{"$f":"'2- Proposal'!L58:M58","v":0},null,null,null,{"$f":"'2- Proposal'!P58","v":"Interior Lighting Power Density (W/unit area for typical space types)"},{"$f":"'2- Proposal'!Q58:R58","v":0}]
[{"$f":"'2- Proposal'!A59","v":"Interior Lighting Controls Modelled ( Yes / No )"},{"$f":"'2- Proposal'!B59:C59","v":0},null,null,null,{"$f":"'2- Proposal'!F59","v":"Interior Lighting Controls Modelled ( Yes / No )"},{"$f":"'2- Proposal'!G59:H59","v":0},null,null,null,{"$f":"'2- Proposal'!K59","v":"Interior Lighting Controls Modelled ( Yes / No )"},{"$f":"'2- Proposal'!L59:M59","v":0},null,null,null,{"$f":"'2- Proposal'!P59","v":"Interior Lighting Controls Modelled ( Yes / No )"},{"$f":"'2- Proposal'!Q59:R59","v":0}]
[{"$f":"'2- Proposal'!A60","v":"Interior Plug Load Density (W/unit area for typical space types)"},{"$f":"'2- Proposal'!B60:C60","v":0},null,null,null,{"$f":"'2- Proposal'!F60","v":"Interior Plug Load Density (W/unit area for typical space types)"},{"$f":"'2- Proposal'!G60:H60","v":0},null,null,null,{"$f":"'2- Proposal'!K60","v":"Interior Plug Load Density (building average)"},{"$f":"'2- Proposal'!L60:M60","v":0},null,null,null,{"$f":"'2- Proposal'!P60","v":"Interior Plug Load Density (building average)"},{"$f":"'2- Proposal'!Q60:R60","v":0}]
[{"$f":"'2- Proposal'!A61","v":"Elevators Load ( kW )"},{"$f":"'2- Proposal'!B61:C61","v":0},null,null,null,{"$f":"'2- Proposal'!F61","v":"Elevators Load ( kW )"},{"$f":"'2- Proposal'!G61:H61","v":0},null,null,null,{"$f":"'2- Proposal'!K61","v":"Interior Plug Load Density (building average)"},{"$f":"'2- Proposal'!L61:M61","v":0},null,null,null,{"$f":"'2- Proposal'!P61","v":"Interior Plug Load Density (building average)"},{"$f":"'2- Proposal'!Q61:R61","v":0}]
[{"$f":"'2- Proposal'!A62","v":"Total number of occupants"},{"$f":"'2- Proposal'!B62:C62","v":0},null,null,null,{"$f":"'2- Proposal'!F62","v":"Total number of occupants"},{"$f":"'2- Proposal'!G62:H62","v":0},null,null,null,{"$f":"'2- Proposal'!K62","v":"Number of occupants"},{"$f":"'2- Proposal'!L62:M62","v":0},null,null,null,{"$f":"'2- Proposal'!P62","v":"Number of occupants"},{"$f":"'2- Proposal'!Q62:R62","v":0}]
[{"$f":"'2- Proposal'!A63:C63","v":"TERMINAL HEATING / COOLING SYSTEM"},null,null,null,null,{"$f":"'2- Proposal'!F63:H63","v":"TERMINAL HEATING / COOLING SYSTEM"},null,null,null,null,{"$f":"'2- Proposal'!K63:M63","v":"TERMINAL HEATING / COOLING SYSTEM"},null,null,null,null,{"$f":"'2- Proposal'!P63:R63","v":"TERMINAL HEATING / COOLING SYSTEM"}]
[{"$f":"'2- Proposal'!A64","v":"Space Heating System Source"},{"$f":"'2- Proposal'!B64","v":0},{"$f":"'2- Proposal'!C64","v":0},null,null,{"$f":"'2- Proposal'!F64","v":"Space Heating System Source"},{"$f":"'2- Proposal'!G64","v":0},{"$f":"'2- Proposal'!H64","v":0},null,null,{"$f":"'2- Proposal'!K64","v":"Space Heating System Source"},{"$f":"'2- Proposal'!L64","v":0},{"$f":"'2- Proposal'!M64","v":0},null,null,{"$f":"'2- Proposal'!P64","v":"Space Heating System Source"},{"$f":"'2- Proposal'!Q64","v":0},{"$f":"'2- Proposal'!R64","v":0}]
[{"$f":"'2- Proposal'!A65","v":"Space Heating/Cooling Terminal System Type"},{"$f":"'2- Proposal'!B65","v":0},{"$f":"'2- Proposal'!C65","v":0},{"$f":"'2- Proposal'!D65","v":"."},null,{"$f":"'2- Proposal'!F65","v":"Space Heating/Cooling Terminal System Type"},{"$f":"'2- Proposal'!G65","v":0},{"$f":"'2- Proposal'!H65","v":0},{"$f":"'2- Proposal'!I65","v":"."},null,{"$f":"'2- Proposal'!K65","v":"Space Heating/Cooling Terminal System Type"},{"$f":"'2- Proposal'!L65","v":0},{"$f":"'2- Proposal'!M65","v":0},{"$f":"'2- Proposal'!N65","v":"."},null,{"$f":"'2- Proposal'!P65","v":"Space Heating/Cooling Terminal System Type"},{"$f":"'2- Proposal'!Q65","v":0},{"$f":"'2- Proposal'!R65","v":0},{"$f":"'2- Proposal'!S65","v":"."}]
[{"$f":"'2- Proposal'!A66","v":"Space Heating System Description"},{"$f":"'2- Proposal'!B66","v":0},{"$f":"'2- Proposal'!C66","v":0},{"$f":"'2- Proposal'!D66","v":"."},null,{"$f":"'2- Proposal'!F66","v":"Space Heating System Description"},{"$f":"'2- Proposal'!G66","v":0},{"$f":"'2- Proposal'!H66","v":0},{"$f":"'2- Proposal'!I66","v":"."},null,{"$f":"'2- Proposal'!K66","v":"Space Heating System Description"},{"$f":"'2- Proposal'!L66","v":0},{"$f":"'2- Proposal'!M66","v":0},{"$f":"'2- Proposal'!N66","v":"."},null,{"$f":"'2- Proposal'!P66","v":"Space Heating System Description"},{"$f":"'2- Proposal'!Q66","v":0},{"$f":"'2- Proposal'!R66","v":0},{"$f":"'2- Proposal'!S66","v":"."}]
[{"$f":"'2- Proposal'!A67","v":"Space Cooling System Description"},{"$f":"'2- Proposal'!B67","v":0},{"$f":"'2- Proposal'!C67","v":0},{"$f":"'2- Proposal'!D67","v":"."},null,{"$f":"'2- Proposal'!F67","v":"Space Cooling System Description"},{"$f":"'2- Proposal'!G67","v":0},{"$f":"'2- Proposal'!H67","v":0},{"$f":"'2- Proposal'!I67","v":"."},null,{"$f":"'2- Proposal'!K67","v":"Space Cooling System Description"},{"$f":"'2- Proposal'!L67","v":0},{"$f":"'2- Proposal'!M67","v":0},{"$f":"'2- Proposal'!N67","v":"."},null,{"$f":"'2- Proposal'!P67","v":"Space Cooling System Description"},{"$f":"'2- Proposal'!Q67","v":0},{"$f":"'2- Proposal'!R67","v":0},{"$f":"'2- Proposal'!S67","v":"."}]
[{"$f":"'2- Proposal'!A68","v":"Terminal heating/cooling efficiency/COP"},{"$f":"'2- Proposal'!B68","v":0},{"$f":"'2- Proposal'!C68","v":0},{"$f":"'2- Proposal'!D68","v":"."},null,{"$f":"'2- Proposal'!F68","v":"Terminal heating/cooling efficiency/COP"},{"$f":"'2- Proposal'!G68","v":0},{"$f":"'2- Proposal'!H68","v":0},{"$f":"'2- Proposal'!I68","v":"."},null,{"$f":"'2- Proposal'!K68","v":"Terminal heating/cooling efficiency/COP"},{"$f":"'2- Proposal'!L68","v":0},{"$f":"'2- Proposal'!M68","v":0},{"$f":"'2- Proposal'!N68","v":"."},null,{"$f":"'2- Proposal'!P68","v":"Terminal heating/cooling efficiency/COP"},{"$f":"'2- Proposal'!Q68","v":0},{"$f":"'2- Proposal'!R68","v":0},{"$f":"'2- Proposal'!S68","v":"."}]
[{"$f":"'2- Proposal'!A69","v":"Terminal Fan Power / Efficiency (W/CFM)"},{"$f":"'2- Proposal'!B69","v":0},{"$f":"'2- Proposal'!C69","v":0},{"$f":"'2- Proposal'!D69","v":"."},null,{"$f":"'2- Proposal'!F69","v":"Terminal Fan Power / Efficiency (W/CFM)"},{"$f":"'2- Proposal'!G69","v":0},{"$f":"'2- Proposal'!H69","v":0},{"$f":"'2- Proposal'!I69","v":"."},null,{"$f":"'2- Proposal'!K69","v":"Terminal Fan Power / Efficiency (W/CFM)"},{"$f":"'2- Proposal'!L69","v":0},{"$f":"'2- Proposal'!M69","v":0},{"$f":"'2- Proposal'!N69","v":"."},null,{"$f":"'2- Proposal'!P69","v":"Terminal Fan Power / Efficiency (W/CFM)"},{"$f":"'2- Proposal'!Q69","v":0},{"$f":"'2- Proposal'!R69","v":0},{"$f":"'2- Proposal'!S69","v":"."}]
[{"$f":"'2- Proposal'!A70:C70","v":"VENTILATION SYSTEM"},null,null,null,null,{"$f":"'2- Proposal'!F70:H70","v":"VENTILATION SYSTEM"},null,null,null,null,{"$f":"'2- Proposal'!K70:M70","v":"VENTILATION SYSTEM"},null,null,null,null,{"$f":"'2- Proposal'!P70:R70","v":"VENTILATION SYSTEM"}]
[{"$f":"'2- Proposal'!A71","v":"Ventilation Heating Source"},{"$f":"'2- Proposal'!B71","v":0},{"$f":"'2- Proposal'!C71","v":0},{"$f":"'2- Proposal'!D71","v":"."},null,{"$f":"'2- Proposal'!F71","v":"Ventilation Heating Source"},{"$f":"'2- Proposal'!G71","v":0},{"$f":"'2- Proposal'!H71","v":0},{"$f":"'2- Proposal'!I71","v":"."},null,{"$f":"'2- Proposal'!K71","v":"Ventilation Heating Source"},{"$f":"'2- Proposal'!L71","v":0},{"$f":"'2- Proposal'!M71","v":0},{"$f":"'2- Proposal'!N71","v":"."},null,{"$f":"'2- Proposal'!P71","v":"Ventilation Heating Source"},{"$f":"'2- Proposal'!Q71","v":0},{"$f":"'2- Proposal'!R71","v":0},{"$f":"'2- Proposal'!S71","v":"."}]
[{"$f":"'2- Proposal'!A72","v":"Ventilation Heating Type"},{"$f":"'2- Proposal'!B72","v":0},{"$f":"'2- Proposal'!C72","v":0},{"$f":"'2- Proposal'!D72","v":"."},null,{"$f":"'2- Proposal'!F72","v":"Ventilation Heating Type"},{"$f":"'2- Proposal'!G72","v":0},{"$f":"'2- Proposal'!H72","v":0},{"$f":"'2- Proposal'!I72","v":"."},null,{"$f":"'2- Proposal'!K72","v":"Ventilation Heating Type"},{"$f":"'2- Proposal'!L72","v":0},{"$f":"'2- Proposal'!M72","v":0},{"$f":"'2- Proposal'!N72","v":"."},null,{"$f":"'2- Proposal'!P72","v":"Ventilation Heating Type"},{"$f":"'2- Proposal'!Q72","v":0},{"$f":"'2- Proposal'!R72","v":0},{"$f":"'2- Proposal'!S72","v":"."}]
[{"$f":"'2- Proposal'!A73","v":"Ventilation System Description (heating and cooling)"},{"$f":"'2- Proposal'!B73","v":0},{"$f":"'2- Proposal'!C73","v":0},{"$f":"'2- Proposal'!D73","v":"."},null,{"$f":"'2- Proposal'!F73","v":"Ventilation System Description (heating and cooling)"},{"$f":"'2- Proposal'!G73","v":0},{"$f":"'2- Proposal'!H73","v":0},{"$f":"'2- Proposal'!I73","v":"."},null,{"$f":"'2- Proposal'!K73","v":"Ventilation System Description (heating and cooling)"},{"$f":"'2- Proposal'!L73","v":0},{"$f":"'2- Proposal'!M73","v":0},{"$f":"'2- Proposal'!N73","v":"."},null,{"$f":"'2- Proposal'!P73","v":"Ventilation System Description (heating and cooling)"},{"$f":"'2- Proposal'!Q73","v":0},{"$f":"'2- Proposal'!R73","v":0},{"$f":"'2- Proposal'!S73","v":"."}]
[{"$f":"'2- Proposal'!A74","v":"Ventilation heating/cooling efficiency/COP"},{"$f":"'2- Proposal'!B74","v":0},{"$f":"'2- Proposal'!C74","v":0},{"$f":"'2- Proposal'!D74","v":"."},null,{"$f":"'2- Proposal'!F74","v":"Ventilation heating/cooling efficiency/COP"},{"$f":"'2- Proposal'!G74","v":0},{"$f":"'2- Proposal'!H74","v":0},{"$f":"'2- Proposal'!I74","v":"."},null,{"$f":"'2- Proposal'!K74","v":"Ventilation heating/cooling efficiency/COP"},{"$f":"'2- Proposal'!L74","v":0},{"$f":"'2- Proposal'!M74","v":0},{"$f":"'2- Proposal'!N74","v":"."},null,{"$f":"'2- Proposal'!P74","v":"Ventilation heating/cooling efficiency/COP"},{"$f":"'2- Proposal'!Q74","v":0},{"$f":"'2- Proposal'!R74","v":0},{"$f":"'2- Proposal'!S74","v":"."}]
[{"$f":"'2- Proposal'!A75","v":"Central Fan Power / Efficiency (W/CFM)"},{"$f":"'2- Proposal'!B75","v":0},{"$f":"'2- Proposal'!C75","v":0},{"$f":"'2- Proposal'!D75","v":"."},null,{"$f":"'2- Proposal'!F75","v":"Central Fan Power / Efficiency (W/CFM)"},{"$f":"'2- Proposal'!G75","v":0},{"$f":"'2- Proposal'!H75","v":0},{"$f":"'2- Proposal'!I75","v":"."},null,{"$f":"'2- Proposal'!K75","v":"Central Fan Power / Efficiency (W/CFM)"},{"$f":"'2- Proposal'!L75","v":0},{"$f":"'2- Proposal'!M75","v":0},{"$f":"'2- Proposal'!N75","v":"."},null,{"$f":"'2- Proposal'!P75","v":"Central Fan Power / Efficiency (W/CFM)"},{"$f":"'2- Proposal'!Q75","v":0},{"$f":"'2- Proposal'!R75","v":0},{"$f":"'2- Proposal'!S75","v":"."}]
[{"$f":"'2- Proposal'!A76","v":"Building Total Mixed Air Supply Rate"},{"$f":"'2- Proposal'!B76","v":0},{"$f":"'2- Proposal'!C76","v":0},{"$f":"'2- Proposal'!D76","v":"."},null,{"$f":"'2- Proposal'!F76","v":"Building Total Mixed Air Supply Rate"},{"$f":"'2- Proposal'!G76","v":0},{"$f":"'2- Proposal'!H76","v":0},{"$f":"'2- Proposal'!I76","v":"."},null,{"$f":"'2- Proposal'!K76","v":"Building Total Mixed Air Supply Rate"},{"$f":"'2- Proposal'!L76","v":0},{"$f":"'2- Proposal'!M76","v":0},{"$f":"'2- Proposal'!N76","v":"."},null,{"$f":"'2- Proposal'!P76","v":"Building Total Mixed Air Supply Rate"},{"$f":"'2- Proposal'!Q76","v":0},{"$f":"'2- Proposal'!R76","v":0},{"$f":"'2- Proposal'!S76","v":"."}]
[{"$f":"'2- Proposal'!A77","v":"Building Total Outdoor Air Ventilation Rate"},{"$f":"'2- Proposal'!B77","v":0},{"$f":"'2- Proposal'!C77","v":0},{"$f":"'2- Proposal'!D77","v":"."},null,{"$f":"'2- Proposal'!F77","v":"Building Total Outdoor Air Ventilation Rate"},{"$f":"'2- Proposal'!G77","v":0},{"$f":"'2- Proposal'!H77","v":0},{"$f":"'2- Proposal'!I77","v":"."},null,{"$f":"'2- Proposal'!K77","v":"Building Total Outdoor Air Ventilation Rate"},{"$f":"'2- Proposal'!L77","v":0},{"$f":"'2- Proposal'!M77","v":0},{"$f":"'2- Proposal'!N77","v":"."},null,{"$f":"'2- Proposal'!P77","v":"Building Total Outdoor Air Ventilation Rate"},{"$f":"'2- Proposal'!Q77","v":0},{"$f":"'2- Proposal'!R77","v":0},{"$f":"'2- Proposal'!S77","v":"."}]
[{"$f":"'2- Proposal'!A78","v":"Exhaust Air Energy Recovery Type(s) and Description"},{"$f":"'2- Proposal'!B78","v":0},{"$f":"'2- Proposal'!C78","v":0},{"$f":"'2- Proposal'!D78","v":"."},null,{"$f":"'2- Proposal'!F78","v":"Exhaust Air Energy Recovery Type(s) and Description"},{"$f":"'2- Proposal'!G78","v":0},{"$f":"'2- Proposal'!H78","v":0},{"$f":"'2- Proposal'!I78","v":"."},null,{"$f":"'2- Proposal'!K78","v":"Exhaust Air Energy Recovery Type(s) and Description"},{"$f":"'2- Proposal'!L78","v":0},{"$f":"'2- Proposal'!M78","v":0},{"$f":"'2- Proposal'!N78","v":"."},null,{"$f":"'2- Proposal'!P78","v":"Exhaust Air Energy Recovery Type(s) and Description"},{"$f":"'2- Proposal'!Q78","v":0},{"$f":"'2- Proposal'!R78","v":0},{"$f":"'2- Proposal'!S78","v":"."}]
[{"$f":"'2- Proposal'!A79","v":"Exhaust Air Energy Recovery Effectiveness"},{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(B$37&B$36&B$34,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"'2- Proposal'!C79","v":0},{"$f":"'2- Proposal'!D79","v":"."},null,{"$f":"'2- Proposal'!F79","v":"Exhaust Air Energy Recovery Effectiveness"},{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(G$37&G$36&G$34,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"'2- Proposal'!H79","v":0},{"$f":"'2- Proposal'!I79","v":"."},null,{"$f":"'2- Proposal'!K79","v":"Exhaust Air Energy Recovery Effectiveness"},{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(L$37&L$36&L$34,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"'2- Proposal'!M79","v":0},{"$f":"'2- Proposal'!N79","v":"."},null,{"$f":"'2- Proposal'!P79","v":"Exhaust Air Energy Recovery Effectiveness"},{"$f":"IFERROR(INDEX(BaselineParameters!$F$2:$F$45,MATCH(Q$37&Q$36&Q$34,BaselineParameters!$A$2:$A$45&BaselineParameters!$C$2:$C$45&BaselineParameters!$D$2:$D$45,0)),\"\")","v":""},{"$f":"'2- Proposal'!R79","v":0},{"$f":"'2- Proposal'!S79","v":"."}]
[{"$f":"'2- Proposal'!A80","v":"Demand Controlled Ventilation (Yes / No)"},{"$f":"'2- Proposal'!B80","v":0},{"$f":"'2- Proposal'!C80","v":0},null,null,{"$f":"'2- Proposal'!F80","v":"Demand Controlled Ventilation (Yes / No)"},{"$f":"'2- Proposal'!G80","v":0},{"$f":"'2- Proposal'!H80","v":0},null,null,{"$f":"'2- Proposal'!K80","v":"Demand Controlled Ventilation (Yes / No)"},{"$f":"'2- Proposal'!L80","v":0},{"$f":"'2- Proposal'!M80","v":0},null,null,{"$f":"'2- Proposal'!P80","v":"Demand Controlled Ventilation (Yes / No)"},{"$f":"'2- Proposal'!Q80","v":0},{"$f":"'2- Proposal'!R80","v":0}]
[{"$f":"'2- Proposal'!A81","v":"Central Cooling Supply Air Temperature and Control"},{"$f":"IF('2- Proposal'!B81:C81=0,\"\",'2- Proposal'!B81:C81)","v":"."},null,null,null,{"$f":"'2- Proposal'!F81","v":"Central Cooling Supply Air Temperature and Control"},{"$f":"IF('2- Proposal'!G81:H81=0,\"\",'2- Proposal'!G81:H81)","v":"."},null,null,null,{"$f":"'2- Proposal'!K81","v":"Central Cooling Supply Air Temperature and Control"},{"$f":"IF('2- Proposal'!L81:M81=0,\"\",'2- Proposal'!L81:M81)","v":"."},null,null,null,{"$f":"'2- Proposal'!P81","v":"Central Cooling Supply Air Temperature and Control"},{"$f":"IF('2- Proposal'!Q81:R81=0,\"\",'2- Proposal'!Q81:R81)","v":"."}]
[{"$f":"'2- Proposal'!A82","v":"Natural Ventilation Description (Yes/No)"},{"$f":"IF('2- Proposal'!B82:C82=0,\"\",'2- Proposal'!B82:C82)","v":"."},null,null,null,{"$f":"'2- Proposal'!F82","v":"Natural Ventilation Description (Yes/No)"},{"$f":"IF('2- Proposal'!G82:H82=0,\"\",'2- Proposal'!G82:H82)","v":"."},null,null,null,{"$f":"'2- Proposal'!K82","v":"Natural Ventilation Description (Yes/No)"},{"$f":"IF('2- Proposal'!L82:M82=0,\"\",'2- Proposal'!L82:M82)","v":"."},null,null,null,{"$f":"'2- Proposal'!P82","v":"Natural Ventilation Description (Yes/No)"},{"$f":"IF('2- Proposal'!Q82:R82=0,\"\",'2- Proposal'!Q82:R82)","v":"."}]
[{"$f":"'2- Proposal'!A83:C83","v":"CENTRAL HEATING/COOLING PLANT"},null,null,null,null,{"$f":"'2- Proposal'!F83:H83","v":"CENTRAL HEATING/COOLING PLANT"},null,null,null,null,{"$f":"'2- Proposal'!K83:M83","v":"CENTRAL HEATING/COOLING PLANT"},null,null,null,null,{"$f":"'2- Proposal'!P83:R83","v":"CENTRAL HEATING/COOLING PLANT"}]
[{"$f":"'2- Proposal'!A84","v":"Heating Source"},{"$f":"'2- Proposal'!B84","v":0},{"$f":"'2- Proposal'!C84","v":0},{"$f":"'2- Proposal'!D84","v":"."},null,{"$f":"'2- Proposal'!F84","v":"Heating Source"},{"$f":"'2- Proposal'!G84","v":0},{"$f":"'2- Proposal'!H84","v":0},{"$f":"'2- Proposal'!I84","v":"."},null,{"$f":"'2- Proposal'!K84","v":"Heating Source"},{"$f":"'2- Proposal'!L84","v":0},{"$f":"'2- Proposal'!M84","v":0},{"$f":"'2- Proposal'!N84","v":"."},null,{"$f":"'2- Proposal'!P84","v":"Heating Source"},{"$f":"'2- Proposal'!Q84","v":0},{"$f":"'2- Proposal'!R84","v":0},{"$f":"'2- Proposal'!S84","v":"."}]
[{"$f":"'2- Proposal'!A85","v":"Heating Plant Type"},{"$f":"'2- Proposal'!B85","v":0},{"$f":"'2- Proposal'!C85","v":0},{"$f":"'2- Proposal'!D85","v":"."},null,{"$f":"'2- Proposal'!F85","v":"Heating Plant Type"},{"$f":"'2- Proposal'!G85","v":0},{"$f":"'2- Proposal'!H85","v":0},{"$f":"'2- Proposal'!I85","v":"."},null,{"$f":"'2- Proposal'!K85","v":"Heating Plant Type"},{"$f":"'2- Proposal'!L85","v":0},{"$f":"'2- Proposal'!M85","v":0},{"$f":"'2- Proposal'!N85","v":"."},null,{"$f":"'2- Proposal'!P85","v":"Heating Plant Type"},{"$f":"'2- Proposal'!Q85","v":0},{"$f":"'2- Proposal'!R85","v":0},{"$f":"'2- Proposal'!S85","v":"."}]
[{"$f":"'2- Proposal'!A86","v":"Heating Plant Description"},{"$f":"'2- Proposal'!B86","v":0},{"$f":"'2- Proposal'!C86","v":0},{"$f":"'2- Proposal'!D86","v":"."},null,{"$f":"'2- Proposal'!F86","v":"Heating Plant Description"},{"$f":"'2- Proposal'!G86","v":0},{"$f":"'2- Proposal'!H86","v":0},{"$f":"'2- Proposal'!I86","v":"."},null,{"$f":"'2- Proposal'!K86","v":"Heating Plant Description"},{"$f":"'2- Proposal'!L86","v":0},{"$f":"'2- Proposal'!M86","v":0},{"$f":"'2- Proposal'!N86","v":"."},null,{"$f":"'2- Proposal'!P86","v":"Heating Plant Description"},{"$f":"'2- Proposal'!Q86","v":0},{"$f":"'2- Proposal'!R86","v":0},{"$f":"'2- Proposal'!S86","v":"."}]
[{"$f":"'2- Proposal'!A87","v":"Cooling Plant Type"},{"$f":"'2- Proposal'!B87","v":0},{"$f":"'2- Proposal'!C87","v":0},{"$f":"'2- Proposal'!D87","v":"."},null,{"$f":"'2- Proposal'!F87","v":"Cooling Plant Type"},{"$f":"'2- Proposal'!G87","v":0},{"$f":"'2- Proposal'!H87","v":0},{"$f":"'2- Proposal'!I87","v":"."},null,{"$f":"'2- Proposal'!K87","v":"Cooling Plant Type"},{"$f":"'2- Proposal'!L87","v":0},{"$f":"'2- Proposal'!M87","v":0},{"$f":"'2- Proposal'!N87","v":"."},null,{"$f":"'2- Proposal'!P87","v":"Cooling Plant Type"},{"$f":"'2- Proposal'!Q87","v":0},{"$f":"'2- Proposal'!R87","v":0},{"$f":"'2- Proposal'!S87","v":"."}]
[{"$f":"'2- Proposal'!A88","v":"Cooling Plant Description"},{"$f":"'2- Proposal'!B88","v":0},{"$f":"'2- Proposal'!C88","v":0},{"$f":"'2- Proposal'!D88","v":"."},null,{"$f":"'2- Proposal'!F88","v":"Cooling Plant Description"},{"$f":"'2- Proposal'!G88","v":0},{"$f":"'2- Proposal'!H88","v":0},{"$f":"'2- Proposal'!I88","v":"."},null,{"$f":"'2- Proposal'!K88","v":"Cooling Plant Description"},{"$f":"'2- Proposal'!L88","v":0},{"$f":"'2- Proposal'!M88","v":0},{"$f":"'2- Proposal'!N88","v":"."},null,{"$f":"'2- Proposal'!P88","v":"Cooling Plant Description"},{"$f":"'2- Proposal'!Q88","v":0},{"$f":"'2- Proposal'!R88","v":0},{"$f":"'2- Proposal'!S88","v":"."}]
[{"$f":"'2- Proposal'!A89","v":"Central Plant Heating efficiency"},{"$f":"'2- Proposal'!B89","v":0},{"$f":"'2- Proposal'!C89","v":0},{"$f":"'2- Proposal'!D89","v":"."},null,{"$f":"'2- Proposal'!F89","v":"Central Plant Heating efficiency"},{"$f":"'2- Proposal'!G89","v":0},{"$f":"'2- Proposal'!H89","v":0},{"$f":"'2- Proposal'!I89","v":"."},null,{"$f":"'2- Proposal'!K89","v":"Central Plant Heating efficiency"},{"$f":"'2- Proposal'!L89","v":0},{"$f":"'2- Proposal'!M89","v":0},{"$f":"'2- Proposal'!N89","v":"."},null,{"$f":"'2- Proposal'!P89","v":"Central Plant Heating efficiency"},{"$f":"'2- Proposal'!Q89","v":0},{"$f":"'2- Proposal'!R89","v":0},{"$f":"'2- Proposal'!S89","v":"."}]
[{"$f":"'2- Proposal'!A90","v":"Central Plant Cooling efficiency"},{"$f":"'2- Proposal'!B90","v":0},{"$f":"'2- Proposal'!C90","v":0},{"$f":"'2- Proposal'!D90","v":"."},null,{"$f":"'2- Proposal'!F90","v":"Central Plant Cooling efficiency"},{"$f":"'2- Proposal'!G90","v":0},{"$f":"'2- Proposal'!H90","v":0},{"$f":"'2- Proposal'!I90","v":"."},null,{"$f":"'2- Proposal'!K90","v":"Central Plant Cooling efficiency"},{"$f":"'2- Proposal'!L90","v":0},{"$f":"'2- Proposal'!M90","v":0},{"$f":"'2- Proposal'!N90","v":"."},null,{"$f":"'2- Proposal'!P90","v":"Central Plant Cooling efficiency"},{"$f":"'2- Proposal'!Q90","v":0},{"$f":"'2- Proposal'!R90","v":0},{"$f":"'2- Proposal'!S90","v":"."}]
[{"$f":"'2- Proposal'!A91","v":"Hot Water Pumping Efficiency (W/gpm)"},{"$f":"'2- Proposal'!B91","v":0},{"$f":"'2- Proposal'!C91","v":0},{"$f":"'2- Proposal'!D91","v":"."},null,{"$f":"'2- Proposal'!F91","v":"Hot Water Pumping Efficiency (W/gpm)"},{"$f":"'2- Proposal'!G91","v":0},{"$f":"'2- Proposal'!H91","v":0},{"$f":"'2- Proposal'!I91","v":"."},null,{"$f":"'2- Proposal'!K91","v":"Hot Water Pumping Efficiency (W/gpm)"},{"$f":"'2- Proposal'!L91","v":0},{"$f":"'2- Proposal'!M91","v":0},{"$f":"'2- Proposal'!N91","v":"."},null,{"$f":"'2- Proposal'!P91","v":"Hot Water Pumping Efficiency (W/gpm)"},{"$f":"'2- Proposal'!Q91","v":0},{"$f":"'2- Proposal'!R91","v":0},{"$f":"'2- Proposal'!S91","v":"."}]
[{"$f":"'2- Proposal'!A92","v":"Hot Water Pumping Control"},{"$f":"'2- Proposal'!B92","v":0},{"$f":"'2- Proposal'!C92","v":0},{"$f":"'2- Proposal'!D92","v":"."},null,{"$f":"'2- Proposal'!F92","v":"Hot Water Pumping Control"},{"$f":"'2- Proposal'!G92","v":0},{"$f":"'2- Proposal'!H92","v":0},{"$f":"'2- Proposal'!I92","v":"."},null,{"$f":"'2- Proposal'!K92","v":"Hot Water Pumping Control"},{"$f":"'2- Proposal'!L92","v":0},{"$f":"'2- Proposal'!M92","v":0},{"$f":"'2- Proposal'!N92","v":"."},null,{"$f":"'2- Proposal'!P92","v":"Hot Water Pumping Control"},{"$f":"'2- Proposal'!Q92","v":0},{"$f":"'2- Proposal'!R92","v":0},{"$f":"'2- Proposal'!S92","v":"."}]
[{"$f":"'2- Proposal'!A93","v":"Chilled Water Pumping Efficiency (W/gpm)"},{"$f":"'2- Proposal'!B93","v":0},{"$f":"'2- Proposal'!C93","v":0},{"$f":"'2- Proposal'!D93","v":"."},null,{"$f":"'2- Proposal'!F93","v":"Chilled Water Pumping Efficiency (W/gpm)"},{"$f":"'2- Proposal'!G93","v":0},{"$f":"'2- Proposal'!H93","v":0},{"$f":"'2- Proposal'!I93","v":"."},null,{"$f":"'2- Proposal'!K93","v":"Chilled Water Pumping Efficiency (W/gpm)"},{"$f":"'2- Proposal'!L93","v":0},{"$f":"'2- Proposal'!M93","v":0},{"$f":"'2- Proposal'!N93","v":"."},null,{"$f":"'2- Proposal'!P93","v":"Chilled Water Pumping Efficiency (W/gpm)"},{"$f":"'2- Proposal'!Q93","v":0},{"$f":"'2- Proposal'!R93","v":0},{"$f":"'2- Proposal'!S93","v":"."}]
[{"$f":"'2- Proposal'!A94","v":"Chilled Water Pumping Control"},{"$f":"'2- Proposal'!B94","v":0},{"$f":"'2- Proposal'!C94","v":0},{"$f":"'2- Proposal'!D94","v":"."},null,{"$f":"'2- Proposal'!F94","v":"Chilled Water Pumping Control"},{"$f":"'2- Proposal'!G94","v":0},{"$f":"'2- Proposal'!H94","v":0},{"$f":"'2- Proposal'!I94","v":"."},null,{"$f":"'2- Proposal'!K94","v":"Chilled Water Pumping Control"},{"$f":"'2- Proposal'!L94","v":0},{"$f":"'2- Proposal'!M94","v":0},{"$f":"'2- Proposal'!N94","v":"."},null,{"$f":"'2- Proposal'!P94","v":"Chilled Water Pumping Control"},{"$f":"'2- Proposal'!Q94","v":0},{"$f":"'2- Proposal'!R94","v":0},{"$f":"'2- Proposal'!S94","v":"."}]
[{"$f":"'2- Proposal'!A95","v":"Hot Water Supply Temperature and Reset"},{"$f":"'2- Proposal'!B95","v":0},{"$f":"'2- Proposal'!C95","v":0},{"$f":"'2- Proposal'!D95","v":"."},null,{"$f":"'2- Proposal'!F95","v":"Hot Water Supply Temperature and Reset"},{"$f":"'2- Proposal'!G95","v":0},{"$f":"'2- Proposal'!H95","v":0},{"$f":"'2- Proposal'!I95","v":"."},null,{"$f":"'2- Proposal'!K95","v":"Hot Water Supply Temperature and Reset"},{"$f":"'2- Proposal'!L95","v":0},{"$f":"'2- Proposal'!M95","v":0},{"$f":"'2- Proposal'!N95","v":"."},null,{"$f":"'2- Proposal'!P95","v":"Hot Water Supply Temperature and Reset"},{"$f":"'2- Proposal'!Q95","v":0},{"$f":"'2- Proposal'!R95","v":0},{"$f":"'2- Proposal'!S95","v":"."}]
[{"$f":"'2- Proposal'!A96","v":"Chilled Water Supply Temperature and Reset"},{"$f":"'2- Proposal'!B96","v":0},{"$f":"'2- Proposal'!C96","v":0},{"$f":"'2- Proposal'!D96","v":"."},null,{"$f":"'2- Proposal'!F96","v":"Chilled Water Supply Temperature and Reset"},{"$f":"'2- Proposal'!G96","v":0},{"$f":"'2- Proposal'!H96","v":0},{"$f":"'2- Proposal'!I96","v":"."},null,{"$f":"'2- Proposal'!K96","v":"Chilled Water Supply Temperature and Reset"},{"$f":"'2- Proposal'!L96","v":0},{"$f":"'2- Proposal'!M96","v":0},{"$f":"'2- Proposal'!N96","v":"."},null,{"$f":"'2- Proposal'!P96","v":"Chilled Water Supply Temperature and Reset"},{"$f":"'2- Proposal'!Q96","v":0},{"$f":"'2- Proposal'!R96","v":0},{"$f":"'2- Proposal'!S96","v":"."}]
[{"$f":"'2- Proposal'!A97","v":"Heat Rejection Type, Description and Efficiency"},{"$f":"'2- Proposal'!B97","v":0},{"$f":"'2- Proposal'!C97","v":0},{"$f":"'2- Proposal'!D97","v":"."},null,{"$f":"'2- Proposal'!F97","v":"Heat Rejection Type, Description and Efficiency"},{"$f":"'2- Proposal'!G97","v":0},{"$f":"'2- Proposal'!H97","v":0},{"$f":"'2- Proposal'!I97","v":"."},null,{"$f":"'2- Proposal'!K97","v":"Heat Rejection Type, Description and Efficiency"},{"$f":"'2- Proposal'!L97","v":0},{"$f":"'2- Proposal'!M97","v":0},{"$f":"'2- Proposal'!N97","v":"."},null,{"$f":"'2- Proposal'!P97","v":"Heat Rejection Type, Description and Efficiency"},{"$f":"'2- Proposal'!Q97","v":0},{"$f":"'2- Proposal'!R97","v":0},{"$f":"'2- Proposal'!S97","v":"."}]
[{"$f":"'2- Proposal'!A98","v":"Condenser water-side heat recovery description (if applicable)"},{"$f":"'2- Proposal'!B98","v":0},{"$f":"'2- Proposal'!C98","v":0},{"$f":"'2- Proposal'!D98","v":"."},null,{"$f":"'2- Proposal'!F98","v":"Condenser water-side heat recovery description (if applicable)"},{"$f":"'2- Proposal'!G98","v":0},{"$f":"'2- Proposal'!H98","v":0},{"$f":"'2- Proposal'!I98","v":"."},null,{"$f":"'2- Proposal'!K98","v":"Condenser water-side heat recovery description (if applicable)"},{"$f":"'2- Proposal'!L98","v":0},{"$f":"'2- Proposal'!M98","v":0},{"$f":"'2- Proposal'!N98","v":"."},null,{"$f":"'2- Proposal'!P98","v":"Condenser water-side heat recovery description (if applicable)"},{"$f":"'2- Proposal'!Q98","v":0},{"$f":"'2- Proposal'!R98","v":0},{"$f":"'2- Proposal'!S98","v":"."}]
[{"$f":"'2- Proposal'!A99","v":"Part-load Perfromance Reference"},{"$f":"'2- Proposal'!B99","v":0},{"$f":"'2- Proposal'!C99","v":0},{"$f":"'2- Proposal'!D99","v":"."},null,{"$f":"'2- Proposal'!F99","v":"Part-load Perfromance Reference"},{"$f":"'2- Proposal'!G99","v":0},{"$f":"'2- Proposal'!H99","v":0},{"$f":"'2- Proposal'!I99","v":"."},null,{"$f":"'2- Proposal'!K99","v":"Part-load Perfromance Reference"},{"$f":"'2- Proposal'!L99","v":0},{"$f":"'2- Proposal'!M99","v":0},{"$f":"'2- Proposal'!N99","v":"."},null,{"$f":"'2- Proposal'!P99","v":"Part-load Perfromance Reference"},{"$f":"'2- Proposal'!Q99","v":0},{"$f":"'2- Proposal'!R99","v":0},{"$f":"'2- Proposal'!S99","v":"."}]
[{"$f":"'2- Proposal'!A100","v":"Annual Space Heating Load Assignment (% Heat Pump  / % Boiler)"},{"$f":"'2- Proposal'!B100","v":0},{"$f":"'2- Proposal'!C100","v":0},{"$f":"'2- Proposal'!D100","v":"."},null,{"$f":"'2- Proposal'!F100","v":"Annual Space Heating Load Assignment (% Heat Pump  / % Boiler)"},{"$f":"'2- Proposal'!G100","v":0},{"$f":"'2- Proposal'!H100","v":0},{"$f":"'2- Proposal'!I100","v":"."},null,{"$f":"'2- Proposal'!K100","v":"Annual Space Heating Load Assignment (% Heat Pump  / % Boiler)"},{"$f":"'2- Proposal'!L100","v":0},{"$f":"'2- Proposal'!M100","v":0},{"$f":"'2- Proposal'!N100","v":"."},null,{"$f":"'2- Proposal'!P100","v":"Annual Space Heating Load Assignment (% Heat Pump  / % Boiler)"},{"$f":"'2- Proposal'!Q100","v":0},{"$f":"'2- Proposal'!R100","v":0},{"$f":"'2- Proposal'!S100","v":"."}]
[{"$f":"'2- Proposal'!A101:C101","v":"DOMESTIC HOT WATER"},null,null,null,null,{"$f":"'2- Proposal'!F101:H101","v":"DOMESTIC HOT WATER"},null,null,null,null,{"$f":"'2- Proposal'!K101:M101","v":"DOMESTIC HOT WATER"},null,null,null,null,{"$f":"'2- Proposal'!P101:R101","v":"DOMESTIC HOT WATER"}]
[{"$f":"'2- Proposal'!A102","v":"DHW Heating Source"},{"$f":"'2- Proposal'!B102","v":0},{"$f":"'2- Proposal'!C102","v":0},{"$f":"'2- Proposal'!D103","v":"."},null,{"$f":"'2- Proposal'!F102","v":"DHW Heating Source"},{"$f":"'2- Proposal'!G102","v":0},{"$f":"'2- Proposal'!H102","v":0},{"$f":"'2- Proposal'!I103","v":"."},null,{"$f":"'2- Proposal'!K102","v":"DHW Heating Source"},{"$f":"'2- Proposal'!L102","v":0},{"$f":"'2- Proposal'!M102","v":0},{"$f":"'2- Proposal'!N103","v":"."},null,{"$f":"'2- Proposal'!P102","v":"DHW Heating Source"},{"$f":"'2- Proposal'!Q102","v":0},{"$f":"'2- Proposal'!R102","v":0},{"$f":"'2- Proposal'!S103","v":"."}]
[{"$f":"'2- Proposal'!A103","v":"DHW Heating Plant Type"},{"$f":"'2- Proposal'!B103","v":0},{"$f":"'2- Proposal'!C103","v":0},{"$f":"'2- Proposal'!D104","v":"."},null,{"$f":"'2- Proposal'!F103","v":"DHW Heating Plant Type"},{"$f":"'2- Proposal'!G103","v":0},{"$f":"'2- Proposal'!H103","v":0},{"$f":"'2- Proposal'!I104","v":"."},null,{"$f":"'2- Proposal'!K103","v":"DHW Heating Plant Type"},{"$f":"'2- Proposal'!L103","v":0},{"$f":"'2- Proposal'!M103","v":0},{"$f":"'2- Proposal'!N104","v":"."},null,{"$f":"'2- Proposal'!P103","v":"DHW Heating Plant Type"},{"$f":"'2- Proposal'!Q103","v":0},{"$f":"'2- Proposal'!R103","v":0},{"$f":"'2- Proposal'!S104","v":"."}]
[{"$f":"'2- Proposal'!A104","v":"DHW Heating Plant Description"},{"$f":"'2- Proposal'!B104","v":0},{"$f":"'2- Proposal'!C104","v":0},{"$f":"'2- Proposal'!D105","v":"."},null,{"$f":"'2- Proposal'!F104","v":"DHW Heating Plant Description"},{"$f":"'2- Proposal'!G104","v":0},{"$f":"'2- Proposal'!H104","v":0},{"$f":"'2- Proposal'!I105","v":"."},null,{"$f":"'2- Proposal'!K104","v":"DHW Heating Plant Description"},{"$f":"'2- Proposal'!L104","v":0},{"$f":"'2- Proposal'!M104","v":0},{"$f":"'2- Proposal'!N105","v":"."},null,{"$f":"'2- Proposal'!P104","v":"DHW Heating Plant Description"},{"$f":"'2- Proposal'!Q104","v":0},{"$f":"'2- Proposal'!R104","v":0},{"$f":"'2- Proposal'!S105","v":"."}]
[{"$f":"'2- Proposal'!A105","v":"DHW Heating Efficiency"},{"$f":"'2- Proposal'!B105","v":0},{"$f":"'2- Proposal'!C105","v":0},{"$f":"'2- Proposal'!D106","v":"."},null,{"$f":"'2- Proposal'!F105","v":"DHW Heating Efficiency"},{"$f":"'2- Proposal'!G105","v":0},{"$f":"'2- Proposal'!H105","v":0},{"$f":"'2- Proposal'!I106","v":"."},null,{"$f":"'2- Proposal'!K105","v":"DHW Heating Efficiency"},{"$f":"'2- Proposal'!L105","v":0},{"$f":"'2- Proposal'!M105","v":0},{"$f":"'2- Proposal'!N106","v":"."},null,{"$f":"'2- Proposal'!P105","v":"DHW Heating Efficiency"},{"$f":"'2- Proposal'!Q105","v":0},{"$f":"'2- Proposal'!R105","v":0},{"$f":"'2- Proposal'!S106","v":"."}]
[{"$f":"'2- Proposal'!A106","v":"Low flow fixtures if applicable (Yes / No)"},{"$f":"'2- Proposal'!B106","v":0},{"$f":"'2- Proposal'!C106","v":0},{"$f":"'2- Proposal'!D107","v":"."},null,{"$f":"'2- Proposal'!F106","v":"Low flow fixtures if applicable (Yes / No)"},{"$f":"'2- Proposal'!G106","v":0},{"$f":"'2- Proposal'!H106","v":0},{"$f":"'2- Proposal'!I107","v":"."},null,{"$f":"'2- Proposal'!K106","v":"Low flow fixtures if applicable (Yes / No)"},{"$f":"'2- Proposal'!L106","v":0},{"$f":"'2- Proposal'!M106","v":0},{"$f":"'2- Proposal'!N107","v":"."},null,{"$f":"'2- Proposal'!P106","v":"Low flow fixtures if applicable (Yes / No)"},{"$f":"'2- Proposal'!Q106","v":0},{"$f":"'2- Proposal'!R106","v":0},{"$f":"'2- Proposal'!S107","v":"."}]
[{"$f":"'2- Proposal'!A107","v":"Average Daily Consumption (Gallon per Day)"},{"$f":"'2- Proposal'!B107","v":0},{"$f":"'2- Proposal'!C107","v":0},{"$f":"'2- Proposal'!D108","v":"."},null,{"$f":"'2- Proposal'!F107","v":"Average Daily Consumption (Gallon per Day)"},{"$f":"'2- Proposal'!G107","v":0},{"$f":"'2- Proposal'!H107","v":0},{"$f":"'2- Proposal'!I108","v":"."},null,{"$f":"'2- Proposal'!K107","v":"Average Daily Consumption (Gallon per Day)"},{"$f":"'2- Proposal'!L107","v":0},{"$f":"'2- Proposal'!M107","v":0},{"$f":"'2- Proposal'!N108","v":"."},null,{"$f":"'2- Proposal'!P107","v":"Average Daily Consumption (Gallon per Day)"},{"$f":"'2- Proposal'!Q107","v":0},{"$f":"'2- Proposal'!R107","v":0},{"$f":"'2- Proposal'!S108","v":"."}]
[{"$f":"'2- Proposal'!A108","v":"Additional Description (heat recovery, preheat, etc.)"},{"$f":"'2- Proposal'!B108","v":0},{"$f":"'2- Proposal'!C108","v":0},null,null,{"$f":"'2- Proposal'!F108","v":"Additional Description (heat recovery, preheat, etc.)"},{"$f":"'2- Proposal'!G108","v":0},{"$f":"'2- Proposal'!H108","v":0},null,null,{"$f":"'2- Proposal'!K108","v":"Additional Description (heat recovery, preheat, etc.)"},{"$f":"'2- Proposal'!L108","v":0},{"$f":"'2- Proposal'!M108","v":0},null,null,{"$f":"'2- Proposal'!P108","v":"Additional Description (heat recovery, preheat, etc.)"},{"$f":"'2- Proposal'!Q108","v":0},{"$f":"'2- Proposal'!R108","v":0}]
[{"$f":"'2- Proposal'!A109:C109","v":"PROCESS LOADS DESCRIPTION (if applicable)"},null,null,null,null,{"$f":"'2- Proposal'!F109:H109","v":"PROCESS LOADS DESCRIPTION (if applicable)"},null,null,null,null,{"$f":"'2- Proposal'!K109:M109","v":"PROCESS LOADS DESCRIPTION (if applicable)"},null,null,null,null,{"$f":"'2- Proposal'!P109:R109","v":"PROCESS LOADS DESCRIPTION (if applicable)"}]
[{"$f":"'2- Proposal'!A110","v":"Process HVAC"},{"$f":"'2- Proposal'!B110","v":0},{"$f":"'2- Proposal'!C110","v":0},{"$f":"'2- Proposal'!D110","v":"."},null,{"$f":"'2- Proposal'!F110","v":"Process HVAC"},{"$f":"'2- Proposal'!G110","v":0},{"$f":"'2- Proposal'!H110","v":0},{"$f":"'2- Proposal'!I110","v":"."},null,{"$f":"'2- Proposal'!K110","v":"Process HVAC"},{"$f":"'2- Proposal'!L110","v":0},{"$f":"'2- Proposal'!M110","v":0},{"$f":"'2- Proposal'!N110","v":"."},null,{"$f":"'2- Proposal'!P110","v":"Process HVAC"},{"$f":"'2- Proposal'!Q110","v":0},{"$f":"'2- Proposal'!R110","v":0},{"$f":"'2- Proposal'!S110","v":"."}]
[{"$f":"'2- Proposal'!A111","v":"Refrigeration"},{"$f":"IF('2- Proposal'!B111:C111=0,\"\",'2- Proposal'!B111:C111)","v":"."},null,null,null,{"$f":"'2- Proposal'!F111","v":"Refrigeration"},{"$f":"IF('2- Proposal'!G111:H111=0,\"\",'2- Proposal'!G111:H111)","v":"."},null,null,null,{"$f":"'2- Proposal'!K111","v":"Refrigeration"},{"$f":"IF('2- Proposal'!L111:M111=0,\"\",'2- Proposal'!L111:M111)","v":"."},null,null,null,{"$f":"'2- Proposal'!P111","v":"Refrigeration"},{"$f":"IF('2- Proposal'!Q111:R111=0,\"\",'2- Proposal'!Q111:R111)","v":"."}]
[{"$f":"'2- Proposal'!A112","v":"IT Process Load"},{"$f":"IF('2- Proposal'!B112:C112=0,\"\",'2- Proposal'!B112:C112)","v":"."},null,null,null,{"$f":"'2- Proposal'!F112","v":"IT Process Load"},{"$f":"IF('2- Proposal'!G112:H112=0,\"\",'2- Proposal'!G112:H112)","v":"."},null,null,null,{"$f":"'2- Proposal'!K112","v":"IT Process Load"},{"$f":"IF('2- Proposal'!L112:M112=0,\"\",'2- Proposal'!L112:M112)","v":"."},null,null,null,{"$f":"'2- Proposal'!P112","v":"IT Process Load"},{"$f":"IF('2- Proposal'!Q112:R112=0,\"\",'2- Proposal'!Q112:R112)","v":"."}]
[{"$f":"'2- Proposal'!A113","v":"Cooking"},{"$f":"'2- Proposal'!B113","v":0},{"$f":"'2- Proposal'!C113","v":0},{"$f":"'2- Proposal'!D113","v":"."},null,{"$f":"'2- Proposal'!F113","v":"Cooking"},{"$f":"'2- Proposal'!G113","v":0},{"$f":"'2- Proposal'!H113","v":0},{"$f":"'2- Proposal'!I113","v":"."},null,{"$f":"'2- Proposal'!K113","v":"Cooking"},{"$f":"'2- Proposal'!L113","v":0},{"$f":"'2- Proposal'!M113","v":0},{"$f":"'2- Proposal'!N113","v":"."},null,{"$f":"'2- Proposal'!P113","v":"Cooking"},{"$f":"'2- Proposal'!Q113","v":0},{"$f":"'2- Proposal'!R113","v":0},{"$f":"'2- Proposal'!S113","v":"."}]
[{"$f":"'2- Proposal'!A114","v":"Other Process Loads"},{"$f":"'2- Proposal'!B114","v":0},{"$f":"'2- Proposal'!C114","v":0},{"$f":"'2- Proposal'!D114","v":"."},null,{"$f":"'2- Proposal'!F114","v":"Other Process Loads"},{"$f":"'2- Proposal'!G114","v":0},{"$f":"'2- Proposal'!H114","v":0},{"$f":"'2- Proposal'!I114","v":"."},null,{"$f":"'2- Proposal'!K114","v":"Other Process Loads"},{"$f":"'2- Proposal'!L114","v":0},{"$f":"'2- Proposal'!M114","v":0},{"$f":"'2- Proposal'!N114","v":"."},null,{"$f":"'2- Proposal'!P114","v":"Other Process Loads"},{"$f":"'2- Proposal'!Q114","v":0},{"$f":"'2- Proposal'!R114","v":0},{"$f":"'2- Proposal'!S114","v":"."}]
[{"$f":"'2- Proposal'!A115:C115","v":"RENEWABLE ENERGY  (if applicable)"},null,null,null,null,{"$f":"'2- Proposal'!F115:H115","v":"RENEWABLE ENERGY  (if applicable)"},null,null,null,null,{"$f":"'2- Proposal'!K115:M115","v":"RENEWABLE ENERGY  (if applicable)"},null,null,null,null,{"$f":"'2- Proposal'!P115:R115","v":"RENEWABLE ENERGY  (if applicable)"}]
[{"$f":"'2- Proposal'!A116","v":"Type and Description"},{"$f":"'2- Proposal'!B116","v":0},{"$f":"'2- Proposal'!C116","v":0},null,null,{"$f":"'2- Proposal'!F116","v":"Type and Description"},{"$f":"'2- Proposal'!G116","v":"."},{"$f":"'2- Proposal'!H116","v":0},null,null,{"$f":"'2- Proposal'!K116","v":"Type and Description"},{"$f":"'2- Proposal'!L116","v":"."},{"$f":"'2- Proposal'!M116","v":0},null,null,{"$f":"'2- Proposal'!P116","v":"Type and Description"},{"$f":"'2- Proposal'!Q116","v":"."},{"$f":"'2- Proposal'!R116","v":0}]
[{"$f":"'2- Proposal'!A117:C117","v":"UTILITY RATES"},null,null,null,null,{"$f":"'2- Proposal'!F117:H117","v":"UTILITY RATES"},null,null,null,null,{"$f":"'2- Proposal'!K117:M117","v":"UTILITY RATES"},null,null,null,null,{"$f":"'2- Proposal'!P117:R117","v":"UTILITY RATES"}]
[{"$f":"'2- Proposal'!A118","v":"Electric Demand Cost ($/kW)"},{"$f":"IF('2- Proposal'!B118:C118=0,\"\",'2- Proposal'!B118:C118)","v":"."},null,null,null,{"$f":"'2- Proposal'!F118","v":"Electric Demand Cost ($/kW)"},{"$f":"IF('2- Proposal'!G118:H118=0,\"\",'2- Proposal'!G118:H118)","v":"."},null,null,null,{"$f":"'2- Proposal'!K118","v":"Electric Demand Cost ($/kW)"},{"$f":"IF('2- Proposal'!L118:M118=0,\"\",'2- Proposal'!L118:M118)","v":"."},null,null,null,{"$f":"'2- Proposal'!P118","v":"Electric Demand Cost ($/kW)"},{"$f":"IF('2- Proposal'!Q118:R118=0,\"\",'2- Proposal'!Q118:R118)","v":"."}]
[{"$f":"'2- Proposal'!A119","v":"Electric Energy Cost ($/kWh)"},{"$f":"IF('2- Proposal'!B119:C119=0,\"\",'2- Proposal'!B119:C119)","v":"."},null,null,null,{"$f":"'2- Proposal'!F119","v":"Electric Energy Cost ($/kWh)"},{"$f":"IF('2- Proposal'!G119:H119=0,\"\",'2- Proposal'!G119:H119)","v":"."},null,null,null,{"$f":"'2- Proposal'!K119","v":"Electric Energy Cost ($/kWh)"},{"$f":"IF('2- Proposal'!L119:M119=0,\"\",'2- Proposal'!L119:M119)","v":"."},null,null,null,{"$f":"'2- Proposal'!P119","v":"Electric Energy Cost ($/kWh)"},{"$f":"IF('2- Proposal'!Q119:R119=0,\"\",'2- Proposal'!Q119:R119)","v":"."}]
[{"$f":"'2- Proposal'!A120","v":"Fuel Energy Cost ($/GJ)\nInclude carbon tax"},{"$f":"IF('2- Proposal'!B120:C120=0,0,'2- Proposal'!B120:C120)","v":""},null,null,null,{"$f":"'2- Proposal'!F120","v":"Fuel Energy Cost ($/GJ)\nInclude carbon tax"},{"$f":"IF('2- Proposal'!G120:H120=0,0,'2- Proposal'!G120:H120)","v":""},null,null,null,{"$f":"'2- Proposal'!K120","v":"Fuel Energy Cost ($/GJ)\nInclude carbon tax"},{"$f":"IF('2- Proposal'!L120:M120=0,0,'2- Proposal'!L120:M120)","v":""},null,null,null,{"$f":"'2- Proposal'!P120","v":"Fuel Energy Cost ($/GJ)\nInclude carbon tax"},{"$f":"IF('2- Proposal'!Q120:R120=0,0,'2- Proposal'!Q120:R120)","v":""}]
[{"$f":"'2- Proposal'!A121","v":"Carbon Offset Credit if applicable ($/tCO2e)"},{"$f":"IF('2- Proposal'!B121:C121=0,0,'2- Proposal'!B121:C121)","v":0},null,null,null,{"$f":"'2- Proposal'!F121","v":"Carbon Offset Credit if applicable ($/tCO2e)"},{"$f":"IF('2- Proposal'!G121:H121=0,0,'2- Proposal'!G121:H121)","v":0},null,null,null,{"$f":"'2- Proposal'!K121","v":"Carbon Offset Credit if applicable ($/tCO2e)"},{"$f":"IF('2- Proposal'!L121:M121=0,0,'2- Proposal'!L121:M121)","v":0},null,null,null,{"$f":"'2- Proposal'!P121","v":"Carbon Offset Credit if applicable ($/tCO2e)"},{"$f":"IF('2- Proposal'!Q121:R121=0,0,'2- Proposal'!Q121:R121)","v":0}]
["PURCHASED ENERGY RATES (DES if applicable)",null,null,null,null,"PURCHASED ENERGY RATES (DES if applicable)",null,null,null,null,"PURCHASED ENERGY RATES (DES if applicable)",null,null,null,null,"PURCHASED ENERGY RATES (DES if applicable)"]
[{"$f":"'2- Proposal'!A123","v":"Hot water Cost"},{"$f":"IF('2- Proposal'!B123:C123=0,\"\",'2- Proposal'!B123:C123)","v":"."},null,null,null,{"$f":"'2- Proposal'!F123","v":"Hot water Cost"},{"$f":"IF('2- Proposal'!G123:H123=0,\"\",'2- Proposal'!G123:H123)","v":"."},null,null,null,{"$f":"'2- Proposal'!K123","v":"Hot water Cost"},{"$f":"IF('2- Proposal'!L123:M123=0,\"\",'2- Proposal'!L123:M123)","v":"."},null,null,null,{"$f":"'2- Proposal'!P123","v":"Hot water Cost"},{"$f":"IF('2- Proposal'!Q123:R123=0,\"\",'2- Proposal'!Q123:R123)","v":"."}]
[{"$f":"'2- Proposal'!A124","v":"Steam Cost"},{"$f":"IF('2- Proposal'!B124:C124=0,\"\",'2- Proposal'!B124:C124)","v":"."},null,null,null,{"$f":"'2- Proposal'!F124","v":"Steam Cost"},{"$f":"IF('2- Proposal'!G124:H124=0,\"\",'2- Proposal'!G124:H124)","v":"."},null,null,null,{"$f":"'2- Proposal'!K124","v":"Steam Cost"},{"$f":"IF('2- Proposal'!L124:M124=0,\"\",'2- Proposal'!L124:M124)","v":"."},null,null,null,{"$f":"'2- Proposal'!P124","v":"Steam Cost"},{"$f":"IF('2- Proposal'!Q124:R124=0,\"\",'2- Proposal'!Q124:R124)","v":"."}]
[{"$f":"'2- Proposal'!A125","v":"Chilled Water Cost"},{"$f":"IF('2- Proposal'!B125:C125=0,\"\",'2- Proposal'!B125:C125)","v":"."},null,null,null,{"$f":"'2- Proposal'!F125","v":"Chilled Water Cost"},{"$f":"IF('2- Proposal'!G125:H125=0,\"\",'2- Proposal'!G125:H125)","v":"."},null,null,null,{"$f":"'2- Proposal'!K125","v":"Chilled Water Cost"},{"$f":"IF('2- Proposal'!L125:M125=0,\"\",'2- Proposal'!L125:M125)","v":"."},null,null,null,{"$f":"'2- Proposal'!P125","v":"Chilled Water Cost"},{"$f":"IF('2- Proposal'!Q125:R125=0,\"\",'2- Proposal'!Q125:R125)","v":"."}]
[{"$f":"'2- Proposal'!A126","v":"Other"},{"$f":"IF('2- Proposal'!B126:C126=0,\"\",'2- Proposal'!B126:C126)","v":"."},null,null,null,{"$f":"'2- Proposal'!F126","v":"Other"},{"$f":"IF('2- Proposal'!G126:H126=0,\"\",'2- Proposal'!G126:H126)","v":"."},null,null,null,{"$f":"'2- Proposal'!K126","v":"Other"},{"$f":"IF('2- Proposal'!L126:M126=0,\"\",'2- Proposal'!L126:M126)","v":"."},null,null,null,{"$f":"'2- Proposal'!P126","v":"Other"},{"$f":"IF('2- Proposal'!Q126:R126=0,\"\",'2- Proposal'!Q126:R126)","v":"."}]
[]
[]
[]
[]
["3. Proposed Project Description and HVAC System and Modelling Methodology"]
[{"$f":"'2- Proposal'!A132","v":"Provide brief description of the Proposed HVAC system and modelling approach including workarounds (if any).\n\n"},null,null,null,null,null,"Please attach to this workbook a 3D image of the building from the energy model."]

{"sheet":"4- Study Results","index":7,"n_rows":116,"n_cols":16,"rows_kept":116,"cut":false,"hidden":false,"merged":[[49,1,49,4],[49,9,49,13],[16,1,16,4],[16,9,16,12],[10,1,10,4],[10,9,10,12],[16,6,16,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8]]}
["CleanBC New Construction Incentives"]
["Energy Study Results"]
["White, bordered cells for user inputs (if applicable)",null,"DATE of SUBMISSION >>>",null,"Day-Month-Year"]
["Different building types must have separate sub-meters for electricity and gas where applicable. Energy consumption from individual sub-meters is to be used to fill tese two tables."]
[]
[null,"Building Type 1","Building Type 2","Building Type 3","Building Type 4","TOTAL"]
[{"$f":"'1- pre screen'!A29","v":"Building Type"},{"$f":"'3- Study Inputs'!B37:C37","v":0},{"$f":"'3- Study Inputs'!G37","v":0},{"$f":"'3- Study Inputs'!L37","v":0},{"$f":"'3- Study Inputs'!Q37","v":0}]
[{"$f":"'1- pre screen'!A30","v":"Conditioned Area (m2)"},{"$f":"'3- Study Inputs'!B38:C38","v":0},{"$f":"'3- Study Inputs'!G38","v":0},{"$f":"'3- Study Inputs'!L38","v":0},{"$f":"'3- Study Inputs'!Q38","v":0},{"$f":"SUM(B8:E8)","v":0},"m2"]
[]
[]
[null,"Baseline Heat Loss Rate\n(Concept Design Model)",null,null,null,null,null,null,null,"Proposed Heat Loss Rate (W/m2)\n(Updated Design Model)"]
[null,"Building Type 1","Building Type 2","Building Type 3","Building Type 4","Baseline\nSub-Totals",null,null,null,"Building Type 1","Building Type 2","Building Type 3","Building Type 4","Proposed\nSub-Totals"]
["Concept Design Heat Loss Rate (W/m2) - when Step Code required",{"$f":"'1- pre screen'!B33","v":0},{"$f":"'1- pre screen'!C33","v":0},{"$f":"'1- pre screen'!D33","v":0},{"$f":"'1- pre screen'!E33","v":0},{"$f":"SUMPRODUCT($B$8:$E$8,B13:E13)/$F$8","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(B8:E8,J13:M13)/F8","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1- pre screen'!A35","v":"Maximum Allowable Heat Loss Rate (W/m2) - Step Code"},{"$f":"'1- pre screen'!B35","v":""},{"$f":"'1- pre screen'!C35","v":""},{"$f":"'1- pre screen'!D35","v":""},{"$f":"'1- pre screen'!E35","v":""},{"$f":"SUMPRODUCT($B$8:$E$8,B14:E14)/$F$8","v":{"$error":"#DIV/0!"}}]
[]
[]
["Electricity in kWh / year      Gas in ekWh / year","Baseline Energy Consumption \n(Concept Design Model)",null,null,null,null,"Electricity in kWh / year      Gas in ekWh / year",null,null,"Proposed Building Design \nEnergy Consumption"]
["Building Type",{"$f":"B7","v":0},{"$f":"C7","v":0},{"$f":"D7","v":0},{"$f":"E7","v":0},"Baseline\nSub-Totals","% of Baseline Total",null,"Building Type",{"$f":"B7","v":0},{"$f":"C7","v":0},{"$f":"D7","v":0},{"$f":"E7","v":0},"Proposed\nSub-Totals","% of Bundle Total"]
[{"$f":"'1- pre screen'!A54","v":"Space Heating and Ventilation Electric Heating (kWh/year)"},null,null,null,null,{"$f":"SUM(B19:E19)","v":0},{"$f":"F19/$F$37","v":{"$error":"#DIV/0!"}},null,{"$f":"A19","v":"Space Heating and Ventilation Electric Heating (kWh/year)"},null,null,null,null,{"$f":"SUM(J19:M19)","v":0},{"$f":"N19/$N$37","v":{"$error":"#DIV/0!"}},{"$f":"A19","v":"Space Heating and Ventilation Electric Heating (kWh/year)"}]
[{"$f":"'1- pre screen'!A55","v":"Space Heating and Ventilation Fuel Heating (ekWh/year)"},null,null,null,null,0,{"$error":"#DIV/0!"},null,"Space Heating and Ventilation Fuel Heating (ekWh/year)",null,null,null,null,0,{"$f":"N20/$N$37","v":{"$error":"#DIV/0!"}},"Space Heating and Ventilation Fuel Heating (ekWh/year)"]
[{"$f":"'1- pre screen'!A56","v":"DHW Electric Heating (kWh/year)"},null,null,null,null,0,{"$error":"#DIV/0!"},null,"DHW Electric Heating (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"DHW Electric Heating (kWh/year)"]
[{"$f":"'1- pre screen'!A57","v":"DHW Fuel Heating (ekWh/year)"},null,null,null,null,0,{"$error":"#DIV/0!"},null,"DHW Fuel Heating (ekWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"DHW Fuel Heating (ekWh/year)"]
[{"$f":"'1- pre screen'!A58","v":"Process Electric Heating (kWh/year)"},null,null,null,null,0,{"$error":"#DIV/0!"},null,"Process Electric Heating (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Process Electric Heating (kWh/year)"]
[{"$f":"'1- pre screen'!A59","v":"Process Fuel Heating (ekWh/year)"},null,null,null,null,0,{"$error":"#DIV/0!"},null,"Process Fuel Heating (ekWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Process Fuel Heating (ekWh/year)"]
["Space Cooling (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Space Cooling (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Space Cooling (kWh/year)"]
["Heat Rejection (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Heat Rejection (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Heat Rejection (kWh/year)"]
["Interior Lighting (excluding parking lighting) (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Interior Lighting (excluding parking lighting) (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Interior Lighting (excluding parking lighting) (kWh/year)"]
["Plug Load (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Plug Load (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Plug Load (kWh/year)"]
["Fans (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Fans (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Fans (kWh/year)"]
["Pumps (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Pumps (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Pumps (kWh/year)"]
["Other Electric End Use (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Other Electric End Use (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Other Electric End Use (kWh/year)"]
["Other Electric End Use (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Other Electric End Use (kWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Other Electric End Use (kWh/year)"]
["Other Gas End Use (ekWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Other Gas End Use (ekWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Other Gas End Use (ekWh/year)"]
["Other Gas End Use (ekWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},null,"Other Gas End Use (ekWh/year)",null,null,null,null,0,{"$error":"#DIV/0!"},"Other Gas End Use (ekWh/year)"]
[{"$f":"'1- pre screen'!A64","v":"Total Electric Energy Use (kWh/year)"},{"$f":"SUM(B19,B21,B23,B25:B32)","v":0},{"$f":"SUM(C19,C21,C23,C25:C32)","v":0},{"$f":"SUM(D19,D21,D23,D25:D32)","v":0},{"$f":"SUM(E19,E21,E23,E25:E32)","v":0},{"$f":"SUM(F19,F21,F23,F25:F32)","v":0},{"$error":"#DIV/0!"},null,"Total Electric Energy Use (kWh/year)",{"$f":"SUM(J19,J21,J23,J25:J32)","v":0},{"$f":"SUM(K19,K21,K23,K25:K32)","v":0},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'1- pre screen'!A65","v":"Total Fuel Energy Use (ekWh/year)"},{"$f":"SUM(B20,B22,B24,B33:B34)","v":0},{"$f":"SUM(C20,C22,C24,C33:C34)","v":0},{"$f":"SUM(D20,D22,D24,D33:D34)","v":0},{"$f":"SUM(E20,E22,E24,E33:E34)","v":0},{"$f":"SUM(F20,F22,F24,F33:F34)","v":0},{"$error":"#DIV/0!"},null,{"$f":"A36","v":"Total Fuel Energy Use (ekWh/year)"},{"$f":"SUM(J20,J22,J24,J33:J34)","v":0},{"$f":"SUM(K20,K22,K24,K33:K34)","v":0},0,0,0,{"$error":"#DIV/0!"}]
[{"$f":"'1- pre screen'!A66","v":"Total Energy Use (ekWh/year)"},{"$f":"SUM(B35:B36)","v":0},{"$f":"SUM(C35:C36)","v":0},0,0,0,null,null,"Total Energy Use (ekWh/year)",{"$f":"SUM(J35:J36)","v":0},{"$f":"SUM(K35:K36)","v":0},0,0,0]
[{"$f":"'1- pre screen'!A68","v":"Total Fuel Energy Use ( GJ / year)"},{"$f":"B36/277.7778","v":0},{"$f":"C36/277.7778","v":0},0,0,0,null,null,"Total Fuel Energy Use ( GJ / year)",{"$f":"J36/277.7778","v":0},{"$f":"K36/277.7778","v":0},0,0,0]
[{"$f":"'1- pre screen'!A69","v":"Fuel AND Electric GHG emissions (tonneCO2e/yr)"},{"$f":"IFERROR(VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*B38/1000+REFERENCE!$I$48*B35/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP('3- Study Inputs'!$G$42,REFERENCE!$H$48:$I$64,2,FALSE)*C38/1000+REFERENCE!$I$48*C35/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP('3- Study Inputs'!$L$42,REFERENCE!$H$48:$I$64,2,FALSE)*D38/1000+REFERENCE!$I$48*D35/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP('3- Study Inputs'!$Q$42,REFERENCE!$H$48:$I$64,2,FALSE)*E38/1000+REFERENCE!$I$48*E35/1000000,\"\")","v":""},{"$f":"SUM(B39:E39)","v":0},null,null,"Fuel AND Electric GHG emissions (tonneCO2e/yr)",{"$f":"IFERROR(VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*J38/1000+REFERENCE!$I$48*J35/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP('3- Study Inputs'!$G$42,REFERENCE!$H$48:$I$64,2,FALSE)*K38/1000+REFERENCE!$I$48*K35/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP('3- Study Inputs'!$L$42,REFERENCE!$H$48:$I$64,2,FALSE)*L38/1000+REFERENCE!$I$48*L35/1000000,\"\")","v":""},{"$f":"IFERROR(VLOOKUP('3- Study Inputs'!$Q$42,REFERENCE!$H$48:$I$64,2,FALSE)*M38/1000+REFERENCE!$I$48*M35/1000000,\"\")","v":""},{"$f":"SUM(J39:M39)","v":0}]
[]
["Current Concept Design's  (Baseline) \nHeating Source Breakdown Ratios \n(Electricity vs. Fuel Energy)","Building Type 1","Building Type 2","Building Type 3","Building Type 4","TOTAL",null,"Current Proposed Design's  (Bundle of EM's) \nHeating Source Breakdown Ratios \n(Electricity vs. Fuel Energy)",null,"Building Type 1","Building Type 2","Building Type 3","Building Type 4","TOTAL"]
["Space Heating and Ventilation heating (electric)",{"$f":"B19/(B19+B20)","v":{"$error":"#DIV/0!"}},{"$f":"C19/(C19+C20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"F19/(F19+F20)","v":{"$error":"#DIV/0!"}},null,"Space Heating and Ventilation heating (electric)",null,{"$f":"J19/(J19+J20)","v":{"$error":"#DIV/0!"}},{"$f":"K19/(K19+K20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Space Heating and Ventilation heating (Fuel)",{"$f":"1-B42","v":{"$error":"#DIV/0!"}},{"$f":"1-C42","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Space Heating and Ventilation heating (Fuel)",null,{"$f":"1-J42","v":{"$error":"#DIV/0!"}},{"$f":"1-K42","v":{"$error":"#DIV/0!"}},{"$f":"1-L42","v":{"$error":"#DIV/0!"}},{"$f":"1-M42","v":{"$error":"#DIV/0!"}},{"$f":"1-N42","v":{"$error":"#DIV/0!"}}]
["DHW  (electric)",{"$f":"B21/(B21+B22)","v":{"$error":"#DIV/0!"}},{"$f":"C21/(C21+C22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"F21/(F21+F22)","v":{"$error":"#DIV/0!"}},null,"DHW  (electric)",null,{"$f":"J21/(J21+J22)","v":{"$error":"#DIV/0!"}},{"$f":"K21/(K21+K22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["DHW  (Fuel)",{"$f":"1-B44","v":{"$error":"#DIV/0!"}},{"$f":"1-C44","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"DHW  (Fuel)",null,{"$f":"1-J44","v":{"$error":"#DIV/0!"}},{"$f":"1-K44","v":{"$error":"#DIV/0!"}},{"$f":"1-L44","v":{"$error":"#DIV/0!"}},{"$f":"1-M44","v":{"$error":"#DIV/0!"}},{"$f":"1-N44","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,"Project Summary Results\n",null,null,null,"TOTAL",null,null,null,"Total Energy Use Intensity - TEUI (kWh/m2)"]
["Net Incremental Electrical Energy (kWh/year)",{"$f":"J35-B35","v":0},{"$f":"K35-C35","v":0},{"$f":"L35-D35","v":0},{"$f":"M35-E35","v":0},{"$f":"N35-F35","v":0},{"$f":"F51/F35","v":{"$error":"#DIV/0!"}},null,null,"Building Type 1","Building Type 2","Building Type 3","Building Type 4","TOTAL"]
["Net Incremental Fuel Consumption (\tGJ / yer)",{"$f":"-1*(B38-J38)","v":0},0,0,0,0,{"$f":"F52/F38","v":{"$error":"#DIV/0!"}},null,{"$f":"B17","v":"Baseline Energy Consumption \n(Concept Design Model)"},{"$f":"B37/B8","v":{"$error":"#DIV/0!"}},{"$f":"C37/C8","v":{"$error":"#DIV/0!"}},{"$f":"D37/D8","v":{"$error":"#DIV/0!"}},{"$f":"E37/E8","v":{"$error":"#DIV/0!"}},{"$f":"F37/F8","v":{"$error":"#DIV/0!"}}]
["Net Incremental Fuel and Electric GHG Emissions (\ttonne CO2e / year)",{"$f":"IFERROR(-1*(B39-J39),\"\")","v":""},{"$f":"IFERROR(-1*(C39-K39),\"\")","v":""},"","",0,{"$f":"IFERROR(F53/F39,\"\")","v":""},null,{"$f":"J17","v":"Proposed Building Design \nEnergy Consumption"},{"$f":"J37/B8","v":{"$error":"#DIV/0!"}},{"$f":"K37/C8","v":{"$error":"#DIV/0!"}},{"$f":"L37/D8","v":{"$error":"#DIV/0!"}},{"$f":"M37/E8","v":{"$error":"#DIV/0!"}},{"$f":"N37/F8","v":{"$error":"#DIV/0!"}}]
[]
["Electrification Measures Study Results"]
["Electricity in kWh / year\nGas in ekWh / year",{"$f":"B17","v":"Baseline Energy Consumption \n(Concept Design Model)"},"% of Baseline Total","EM-1","%\ndifference\nfrom Baseline","EM-2",{"$f":"$E$56","v":"%\ndifference\nfrom Baseline"},"EM-3",{"$f":"$E$56","v":"%\ndifference\nfrom Baseline"},"EM-4",{"$f":"$E$56","v":"%\ndifference\nfrom Baseline"},"EM-5",{"$f":"$E$56","v":"%\ndifference\nfrom Baseline"},"Proposed",{"$f":"$E$56","v":"%\ndifference\nfrom Baseline"}]
["EM Name    >   >   >   >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>","All Buildings Combined",null,null,null,null,null,null,null,null,null,null,null,"BUNDLE"]
["Standard BC Hydro EM Type   >   >   >   >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"]
["EM in Bundle (Yes or No)   >   >   >   >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>",null,null,"No",null,"No",null,"No",null,"No",null,"No"]
["Estimated Measure Life of EM      >>>>>>>>>>>>>>>>>>>>",null,null,{"$f":"IF(D58=\"\",\"\",VLOOKUP(D58,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},null,{"$f":"IF(F58=\"\",\"\",VLOOKUP(F58,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},null,{"$f":"IF(H58=\"\",\"\",VLOOKUP(H58,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},null,{"$f":"IF(J58=\"\",\"\",VLOOKUP(J58,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},null,{"$f":"IF(L58=\"\",\"\",VLOOKUP(L58,REFERENCE!$D$2:$E$28,2,FALSE))","v":""},null,{"$f":"Summary!G30","v":{"$error":"#DIV/0!"}}]
["Energy End Use Breakdown"]
[{"$f":"A19","v":"Space Heating and Ventilation Electric Heating (kWh/year)"},{"$f":"F19","v":0},{"$f":"B62/$B$90","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($B62=0,\"\",D62/$B62-1)","v":""},null,{"$f":"IF($B62=0,\"\",F62/$B62-1)","v":""},null,{"$f":"IF($B62=0,\"\",H62/$B62-1)","v":""},null,{"$f":"IF($B62=0,\"\",J62/$B62-1)","v":""},null,{"$f":"IF($B62=0,\"\",L62/$B62-1)","v":""},{"$f":"N19","v":0},{"$f":"IF($B62=0,\"\",N62/$B62-1)","v":""},{"$f":"A62","v":"Space Heating and Ventilation Electric Heating (kWh/year)"}]
["Space Heating and Ventilation Fuel Heating (ekWh/year)",0,{"$error":"#DIV/0!"},null,{"$f":"IF($B63=0,\"\",D63/$B63-1)","v":""},null,"",null,{"$f":"IF($B63=0,\"\",H63/$B63-1)","v":""},null,{"$f":"IF($B63=0,\"\",J63/$B63-1)","v":""},null,{"$f":"IF($B63=0,\"\",L63/$B63-1)","v":""},0,"","Space Heating and Ventilation Fuel Heating (ekWh/year)"]
["DHW Electric Heating (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B64=0,\"\",H64/$B64-1)","v":""},null,{"$f":"IF($B64=0,\"\",J64/$B64-1)","v":""},null,{"$f":"IF($B64=0,\"\",L64/$B64-1)","v":""},0,"","DHW Electric Heating (kWh/year)"]
["DHW Fuel Heating (ekWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B65=0,\"\",H65/$B65-1)","v":""},null,{"$f":"IF($B65=0,\"\",J65/$B65-1)","v":""},null,{"$f":"IF($B65=0,\"\",L65/$B65-1)","v":""},0,"","DHW Fuel Heating (ekWh/year)"]
["Process Electric Heating (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B66=0,\"\",H66/$B66-1)","v":""},null,{"$f":"IF($B66=0,\"\",J66/$B66-1)","v":""},null,{"$f":"IF($B66=0,\"\",L66/$B66-1)","v":""},0,"","Process Electric Heating (kWh/year)"]
["Process Fuel Heating (ekWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B67=0,\"\",H67/$B67-1)","v":""},null,{"$f":"IF($B67=0,\"\",J67/$B67-1)","v":""},null,{"$f":"IF($B67=0,\"\",L67/$B67-1)","v":""},0,"","Process Fuel Heating (ekWh/year)"]
["Space Cooling (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B68=0,\"\",H68/$B68-1)","v":""},null,{"$f":"IF($B68=0,\"\",J68/$B68-1)","v":""},null,{"$f":"IF($B68=0,\"\",L68/$B68-1)","v":""},0,"","Space Cooling (kWh/year)"]
["Heat Rejection (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B69=0,\"\",H69/$B69-1)","v":""},null,{"$f":"IF($B69=0,\"\",J69/$B69-1)","v":""},null,{"$f":"IF($B69=0,\"\",L69/$B69-1)","v":""},0,"","Heat Rejection (kWh/year)"]
["Interior Lighting (excluding parking lighting) (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B70=0,\"\",H70/$B70-1)","v":""},null,{"$f":"IF($B70=0,\"\",J70/$B70-1)","v":""},null,{"$f":"IF($B70=0,\"\",L70/$B70-1)","v":""},0,"","Interior Lighting (excluding parking lighting) (kWh/year)"]
["Plug Load (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B71=0,\"\",H71/$B71-1)","v":""},null,{"$f":"IF($B71=0,\"\",J71/$B71-1)","v":""},null,{"$f":"IF($B71=0,\"\",L71/$B71-1)","v":""},0,"","Plug Load (kWh/year)"]
["Fans (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B72=0,\"\",H72/$B72-1)","v":""},null,{"$f":"IF($B72=0,\"\",J72/$B72-1)","v":""},null,{"$f":"IF($B72=0,\"\",L72/$B72-1)","v":""},0,"","Fans (kWh/year)"]
["Pumps (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B73=0,\"\",H73/$B73-1)","v":""},null,{"$f":"IF($B73=0,\"\",J73/$B73-1)","v":""},null,{"$f":"IF($B73=0,\"\",L73/$B73-1)","v":""},0,"","Pumps (kWh/year)"]
["Other Electric End Use (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B74=0,\"\",H74/$B74-1)","v":""},null,{"$f":"IF($B74=0,\"\",J74/$B74-1)","v":""},null,{"$f":"IF($B74=0,\"\",L74/$B74-1)","v":""},0,"","Other Electric End Use (kWh/year)"]
["Other Electric End Use (kWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B75=0,\"\",H75/$B75-1)","v":""},null,{"$f":"IF($B75=0,\"\",J75/$B75-1)","v":""},null,{"$f":"IF($B75=0,\"\",L75/$B75-1)","v":""},0,"","Other Electric End Use (kWh/year)"]
["Other Gas End Use (ekWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B76=0,\"\",H76/$B76-1)","v":""},null,{"$f":"IF($B76=0,\"\",J76/$B76-1)","v":""},null,{"$f":"IF($B76=0,\"\",L76/$B76-1)","v":""},0,"","Other Gas End Use (ekWh/year)"]
["Other Gas End Use (ekWh/year)",0,{"$error":"#DIV/0!"},null,"",null,"",null,{"$f":"IF($B77=0,\"\",H77/$B77-1)","v":""},null,{"$f":"IF($B77=0,\"\",J77/$B77-1)","v":""},null,{"$f":"IF($B77=0,\"\",L77/$B77-1)","v":""},0,"","Other Gas End Use (ekWh/year)"]
["Electricity Consumption and GHG Emissions"]
[{"$f":"A35","v":"Total Electric Energy Use (kWh/year)"},{"$f":"SUM(B62,B64,B66,B68,B69,B70,B71,B72,B73,B74,B75)","v":0},{"$f":"B79/B$90","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D62,D64,D66,D68,D69,D70,D71,D72,D73,D74,D75)","v":0},"",{"$f":"SUM(F62,F64,F66,F68,F69,F70,F71,F72,F73,F74,F75)","v":0},{"$f":"IF($B79=0,\"\",F79/$B79-1)","v":""},{"$f":"SUM(H62,H64,H66,H68,H69,H70,H71,H72,H73,H74,H75)","v":0},{"$f":"IF($B79=0,\"\",H79/$B79-1)","v":""},{"$f":"SUM(J62,J64,J66,J68,J69,J70,J71,J72,J73,J74,J75)","v":0},{"$f":"IF($B79=0,\"\",J79/$B79-1)","v":""},{"$f":"SUM(L62,L64,L66,L68,L69,L70,L71,L72,L73,L74,L75)","v":0},"",{"$f":"SUM(N62,N64,N66,N68,N69,N70,N71,N72,N73,N74,N75)","v":0},{"$f":"IF($B79=0,\"\",N79/$B79-1)","v":""},"Total Electric Energy Use (kWh/year)"]
["Electricity Annual Peak Demand ( kW )",null,null,null,{"$f":"IF($B80=0,\"\",D80/$B80-1)","v":""},null,{"$f":"IF($B80=0,\"\",F80/$B80-1)","v":""},null,{"$f":"IF($B80=0,\"\",H80/$B80-1)","v":""},null,{"$f":"IF($B80=0,\"\",J80/$B80-1)","v":""},null,{"$f":"IF($B80=0,\"\",L80/$B80-1)","v":""},null,{"$f":"IF($B80=0,\"\",N80/$B80-1)","v":""},{"$f":"A80","v":"Electricity Annual Peak Demand ( kW )"}]
["Electricity Average Monthly Peak Demand ( kW )",null,null,null,{"$f":"IF($B81=0,\"\",D81/$B81-1)","v":""},null,{"$f":"IF($B81=0,\"\",F81/$B81-1)","v":""},null,{"$f":"IF($B81=0,\"\",H81/$B81-1)","v":""},null,{"$f":"IF($B81=0,\"\",J81/$B81-1)","v":""},null,{"$f":"IF($B81=0,\"\",L81/$B81-1)","v":""},null,{"$f":"IF($B81=0,\"\",N81/$B81-1)","v":""},{"$f":"A81","v":"Electricity Average Monthly Peak Demand ( kW )"}]
["Annual Electricity Cost ( $ / year) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A82","v":"Annual Electricity Cost ( $ / year) "}]
["Electric GHG emissions (tonneCO2e/yr)",{"$f":"REFERENCE!$I$48*B79/1000000","v":0},null,{"$f":"REFERENCE!$I$48*D79/1000000","v":0},"",{"$f":"REFERENCE!$I$48*F79/1000000","v":0},{"$f":"IF($B83=0,\"\",F83/$B83-1)","v":""},{"$f":"REFERENCE!$I$48*H79/1000000","v":0},{"$f":"IF($B83=0,\"\",H83/$B83-1)","v":""},{"$f":"REFERENCE!$I$48*J79/1000000","v":0},{"$f":"IF($B83=0,\"\",J83/$B83-1)","v":""},{"$f":"REFERENCE!$I$48*L79/1000000","v":0},"",{"$f":"REFERENCE!$I$48*N79/1000000","v":0},{"$f":"IF($B83=0,\"\",N83/$B83-1)","v":""},"Electric GHG emissions (tonneCO2e/yr)"]
["Fuel Consumption and GHG Emissions"]
[{"$f":"A36","v":"Total Fuel Energy Use (ekWh/year)"},{"$f":"SUM(B63,B65,B67,B76,B77)","v":0},{"$f":"B85/B$90","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D63,D65,D67,D76,D77)","v":0},{"$f":"IF($B85=0,\"\",D85/$B85-1)","v":""},{"$f":"SUM(F63,F65,F67,F76,F77)","v":0},{"$f":"IF($B85=0,\"\",F85/$B85-1)","v":""},{"$f":"SUM(H63,H65,H67,H76,H77)","v":0},{"$f":"IF($B85=0,\"\",H85/$B85-1)","v":""},{"$f":"SUM(J63,J65,J67,J76,J77)","v":0},{"$f":"IF($B85=0,\"\",J85/$B85-1)","v":""},{"$f":"SUM(L63,L65,L67,L76,L77)","v":0},{"$f":"IF($B85=0,\"\",L85/$B85-1)","v":""},{"$f":"SUM(N63,N65,N67,N76,N77)","v":0},{"$f":"IF($B85=0,\"\",N85/$B85-1)","v":""},{"$f":"A85","v":"Total Fuel Energy Use (ekWh/year)"}]
[{"$f":"A38","v":"Total Fuel Energy Use ( GJ / year)"},{"$f":"B85*3.6/1000","v":0},null,{"$f":"D85*3.6/1000","v":0},null,{"$f":"F85*3.6/1000","v":0},null,{"$f":"H85*3.6/1000","v":0},null,{"$f":"J85*3.6/1000","v":0},null,{"$f":"L85*3.6/1000","v":0},null,{"$f":"N85*3.6/1000","v":0},null,{"$f":"A86","v":"Total Fuel Energy Use ( GJ / year)"}]
["Annual Fuel Cost ( $ / year) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A87","v":"Annual Fuel Cost ( $ / year) "}]
["Fuel GHG emissions (tonne CO2e/yr)",{"$f":"VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*B86/1000","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*D86/1000","v":{"$error":"#N/A"}},{"$f":"IF($B88=0,\"\",D88/$B88-1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*F86/1000","v":{"$error":"#N/A"}},{"$f":"IF($B88=0,\"\",F88/$B88-1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*H86/1000","v":{"$error":"#N/A"}},{"$f":"IF($B88=0,\"\",H88/$B88-1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*J86/1000","v":{"$error":"#N/A"}},{"$f":"IF($B88=0,\"\",J88/$B88-1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*L86/1000","v":{"$error":"#N/A"}},{"$f":"IF($B88=0,\"\",L88/$B88-1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('3- Study Inputs'!$B$42,REFERENCE!$H$48:$I$64,2,FALSE)*N86/1000","v":{"$error":"#N/A"}},{"$f":"IF($B88=0,\"\",N88/$B88-1)","v":{"$error":"#N/A"}},"Fuel GHG emissions (tonne CO2e/yr)"]
["Total Energy Consumption and GHG Emissions"]
[{"$f":"A37","v":"Total Energy Use (ekWh/year)"},{"$f":"SUM(B62:B77)","v":0},{"$f":"B90/B$90","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D62:D77)","v":0},{"$f":"IF($B90=0,\"\",D90/$B90-1)","v":""},{"$f":"SUM(F62:F77)","v":0},{"$f":"IF($B90=0,\"\",F90/$B90-1)","v":""},{"$f":"SUM(H62:H77)","v":0},{"$f":"IF($B90=0,\"\",H90/$B90-1)","v":""},{"$f":"SUM(J62:J77)","v":0},{"$f":"IF($B90=0,\"\",J90/$B90-1)","v":""},{"$f":"SUM(L62:L77)","v":0},{"$f":"IF($B90=0,\"\",L90/$B90-1)","v":""},{"$f":"SUM(N62:N77)","v":0},{"$f":"IF($B90=0,\"\",N90/$B90-1)","v":""},{"$f":"A90","v":"Total Energy Use (ekWh/year)"}]
["Total GHG emissions (tonne CO2e/yr)",{"$f":"B88+B83","v":{"$error":"#N/A"}},null,{"$f":"D88+D83","v":{"$error":"#N/A"}},{"$f":"IF($B91=0,\"\",D91/$B91-1)","v":{"$error":"#N/A"}},{"$f":"F88+F83","v":{"$error":"#N/A"}},{"$f":"IF($B91=0,\"\",F91/$B91-1)","v":{"$error":"#N/A"}},{"$f":"H88+H83","v":{"$error":"#N/A"}},{"$f":"IF($B91=0,\"\",H91/$B91-1)","v":{"$error":"#N/A"}},{"$f":"J88+J83","v":{"$error":"#N/A"}},{"$f":"IF($B91=0,\"\",J91/$B91-1)","v":{"$error":"#N/A"}},{"$f":"L88+L83","v":{"$error":"#N/A"}},{"$f":"IF($B91=0,\"\",L91/$B91-1)","v":{"$error":"#N/A"}},{"$f":"N88+N83","v":{"$error":"#N/A"}},{"$f":"IF($B91=0,\"\",N91/$B91-1)","v":{"$error":"#N/A"}},{"$f":"A91","v":"Total GHG emissions (tonne CO2e/yr)"}]
["Incremental Energy Consumption and GHG Emissions"]
["Net Incremental Electrical Energy (kWh/year)","N/A","N/A",{"$f":"IF(D79>0,D79-$B$79,\"\")","v":""},{"$f":"D93/$B$79","v":{"$error":"#VALUE!"}},{"$f":"IF(F79>0,F79-$B$79,\"\")","v":""},{"$f":"F93/$B$79","v":{"$error":"#VALUE!"}},{"$f":"IF(H79>0,H79-$B$79,\"\")","v":""},{"$f":"H93/$B$79","v":{"$error":"#VALUE!"}},{"$f":"IF(J79>0,J79-$B$79,\"\")","v":""},{"$f":"J93/$B$79","v":{"$error":"#VALUE!"}},{"$f":"IF(L79>0,L79-$B$79,\"\")","v":""},{"$f":"L93/$B$79","v":{"$error":"#VALUE!"}},{"$f":"N79-$B$79","v":0},{"$f":"N93/$B$79","v":{"$error":"#DIV/0!"}},{"$f":"A93","v":"Net Incremental Electrical Energy (kWh/year)"}]
["Net Incremental Electrical Annual Peak Demand (kW)","N/A","N/A",{"$f":"D80-$B$80","v":0},{"$f":"D94/$B$79","v":{"$error":"#DIV/0!"}},{"$f":"F80-$B$80","v":0},{"$f":"F94/$B$79","v":{"$error":"#DIV/0!"}},{"$f":"H80-$B$80","v":0},{"$f":"H94/$B$79","v":{"$error":"#DIV/0!"}},{"$f":"J80-$B$80","v":0},{"$f":"J94/$B$79","v":{"$error":"#DIV/0!"}},{"$f":"L80-$B$80","v":0},{"$f":"L94/$B$79","v":{"$error":"#DIV/0!"}},{"$f":"N80-$B$80","v":0},{"$f":"N94/$B$79","v":{"$error":"#DIV/0!"}},{"$f":"A94","v":"Net Incremental Electrical Annual Peak Demand (kW)"}]
["Net Incremental Electrical Annual Monthly Average Demand (kW)","N/A","N/A",{"$f":"D81-$B$81","v":0},{"$f":"D95/$B$81","v":{"$error":"#DIV/0!"}},{"$f":"F81-$B$81","v":0},{"$f":"F95/$B$81","v":{"$error":"#DIV/0!"}},{"$f":"H81-$B$81","v":0},{"$f":"H95/$B$81","v":{"$error":"#DIV/0!"}},{"$f":"J81-$B$81","v":0},{"$f":"J95/$B$81","v":{"$error":"#DIV/0!"}},{"$f":"L81-$B$81","v":0},{"$f":"L95/$B$81","v":{"$error":"#DIV/0!"}},{"$f":"N81-$B$81","v":0},{"$f":"N95/$B$81","v":{"$error":"#DIV/0!"}},{"$f":"A95","v":"Net Incremental Electrical Annual Monthly Average Demand (kW)"}]
["Net Incremental Fuel Consumption (\tGJ / yer)","N/A","N/A",{"$f":"IF(D86>0,D86-$B$86,\"\")","v":""},{"$f":"D96/$B$86","v":{"$error":"#VALUE!"}},{"$f":"IF(F86>0,F86-$B$86,\"\")","v":""},{"$f":"F96/$B$86","v":{"$error":"#VALUE!"}},{"$f":"IF(H86>0,H86-$B$86,\"\")","v":""},{"$f":"H96/$B$86","v":{"$error":"#VALUE!"}},{"$f":"IF(J86>0,J86-$B$86,\"\")","v":""},{"$f":"J96/$B$86","v":{"$error":"#VALUE!"}},{"$f":"IF(L86>0,L86-$B$86,\"\")","v":""},{"$f":"L96/$B$86","v":{"$error":"#VALUE!"}},{"$f":"IF(N86>0,N86-$B$86,\"\")","v":""},{"$f":"N96/$B$86","v":{"$error":"#VALUE!"}},"Net Incremental Fuel Consumption (\tGJ / yer)"]
["Net Incremental GHG Emissions (\ttonne CO2e / year)","N/A","N/A",{"$f":"IF(D83>0,($B$83-D83+$B$88-D88)*(-1),\"\")","v":""},{"$f":"D97/$B$91","v":{"$error":"#VALUE!"}},{"$f":"IF(F83>0,($B$83-F83+$B$88-F88)*(-1),\"\")","v":""},{"$f":"F97/$B$91","v":{"$error":"#VALUE!"}},{"$f":"IF(H83>0,($B$83-H83+$B$88-H88)*(-1),\"\")","v":""},{"$f":"H97/$B$91","v":{"$error":"#VALUE!"}},{"$f":"IF(J83>0,($B$83-J83+$B$88-J88)*(-1),\"\")","v":""},{"$f":"J97/$B$91","v":{"$error":"#VALUE!"}},{"$f":"IF(L83>0,($B$83-L83+$B$88-L88)*(-1),\"\")","v":""},{"$f":"L97/$B$91","v":{"$error":"#VALUE!"}},{"$f":"IF(N83>0,($B$83-N83+$B$88-N88)*(-1),\"\")","v":""},{"$f":"N97/$B$91","v":{"$error":"#VALUE!"}},"Net Incremental GHG Emissions (\ttonne CO2e / year)"]
["Net Incremental GHG Emissions Over Project Life (\ttonne CO2e)","N/A","N/A",{"$f":"IF(D97=\"\",\"\",D97*D60)","v":""},{"$f":"E97","v":{"$error":"#VALUE!"}},{"$f":"IF(F97=\"\",\"\",F97*F60)","v":""},{"$f":"G97","v":{"$error":"#VALUE!"}},{"$f":"IF(H97=\"\",\"\",H97*H60)","v":""},{"$f":"I97","v":{"$error":"#VALUE!"}},{"$f":"IF(J97=\"\",\"\",J97*J60)","v":""},{"$f":"K97","v":{"$error":"#VALUE!"}},{"$f":"IF(L97=\"\",\"\",L97*L60)","v":""},{"$f":"M97","v":{"$error":"#VALUE!"}},{"$f":"N97*N60","v":{"$error":"#VALUE!"}},{"$f":"O97","v":{"$error":"#VALUE!"}},{"$f":"A98","v":"Net Incremental GHG Emissions Over Project Life (\ttonne CO2e)"}]
["Capital Cost"]
["Baseline Capital Cost (material + labour) in $",{"$f":"SUMIF($D$59:$M$59,\"Yes\",D100:M100)","v":0},null,{"$f":"'5- Incremental Costs'!$I$19","v":0},null,{"$f":"'5- Incremental Costs'!I27","v":0},null,{"$f":"'5- Incremental Costs'!I35","v":0},null,{"$f":"'5- Incremental Costs'!I43","v":0},null,{"$f":"'5- Incremental Costs'!I51","v":0},null,{"$f":"SUMIF($D$59:$M$59,\"Yes\",D100:M100)","v":0},null,{"$f":"A100","v":"Baseline Capital Cost (material + labour) in $"}]
["Proposed Capital Cost (material + labour) in $","N/A",null,{"$f":"'5- Incremental Costs'!P19","v":0},null,{"$f":"'5- Incremental Costs'!P27","v":0},null,{"$f":"'5- Incremental Costs'!P35","v":0},null,{"$f":"'5- Incremental Costs'!P43","v":0},null,{"$f":"'5- Incremental Costs'!P51","v":0},null,{"$f":"SUMIF($D$59:$M$59,\"Yes\",D101:M101)","v":0},null,{"$f":"A101","v":"Proposed Capital Cost (material + labour) in $"}]
["Operation and Maintenance Cost"]
["Annual Operation and Maintenance Cost ( $ / year )",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($D$59:$M$59,\"Yes\",D113:M113)+B103","v":0},null,{"$f":"A103","v":"Annual Operation and Maintenance Cost ( $ / year )"}]
["Annual Energy Cost ( $ / year)",{"$f":"B87+B82","v":0},null,{"$f":"D87+D82","v":0},null,{"$f":"F87+F82","v":0},null,{"$f":"H87+H82","v":0},null,{"$f":"J87+J82","v":0},null,{"$f":"L87+L82","v":0},null,{"$f":"N87+N82","v":0},null,{"$f":"A104","v":"Annual Energy Cost ( $ / year)"}]
["Total Annual Cost ( $ / year )",{"$f":"SUM(B103:B104)","v":0},null,{"$f":"SUM(D103:D104)","v":0},null,{"$f":"SUM(F103:F104)","v":0},null,{"$f":"SUM(H103:H104)","v":0},null,{"$f":"SUM(J103:J104)","v":0},null,{"$f":"SUM(L103:L104)","v":0},null,{"$f":"SUM(N103:N104)","v":0},null,"Total Annual Cost ( $ / year )"]
["Additional Benefits for Proposed Electrification Measures"]
["Annual Carbon Offset Credit ( $ / year )","N/A",null,{"$f":"'1- pre screen'!$B$48*D97","v":{"$error":"#VALUE!"}},null,{"$f":"'1- pre screen'!$B$48*F97","v":{"$error":"#VALUE!"}},null,{"$f":"'1- pre screen'!$B$48*H97","v":{"$error":"#VALUE!"}},null,{"$f":"'1- pre screen'!$B$48*J97","v":{"$error":"#VALUE!"}},null,{"$f":"'1- pre screen'!$B$48*L97","v":{"$error":"#VALUE!"}},null,{"$f":"'1- pre screen'!$B$48*N97","v":{"$error":"#VALUE!"}},null,{"$f":"A107","v":"Annual Carbon Offset Credit ( $ / year )"}]
["Annual non-energy benefits or detriments (Water conservation, etc.) $/year","N/A"]
["3rd Party Funding (one time)","N/A"]
["Other Benefit (one time)","N/A"]
["Project Costs Summary  for Proposed Measures (Not Incl. Incentive)"]
["Net Incremental Capital Cost","N/A",null,{"$f":"IF(D101>0,D101-D100-D109-D110,\"\")","v":""},null,{"$f":"IF(F101>0,F101-F100-F109-F110,\"\")","v":""},null,{"$f":"IF(H101>0,H101-H100-H109-H110,\"\")","v":""},null,{"$f":"IF(J101>0,J101-J100-J109-J110,\"\")","v":""},null,{"$f":"IF(L101>0,L101-L100-L109-L110,\"\")","v":""},null,{"$f":"IF(N101>0,N101-N100-N109-N110,\"\")","v":""},null,{"$f":"A112","v":"Net Incremental Capital Cost"}]
["Net Incremental O&M Cost ","N/A",null,{"$f":"IF(D105>0,D103-$B$103-D107-D108,\"\")","v":""},null,{"$f":"IF(F105>0,F103-$B$103-F107-F108,\"\")","v":""},null,{"$f":"IF(H105>0,H103-$B$103-H107-H108,\"\")","v":""},null,{"$f":"IF(J105>0,J103-$B$103-J107-J108,\"\")","v":""},null,{"$f":"IF(L105>0,L103-$B$103-L107-L108,\"\")","v":""},null,{"$f":"IF(N105>0,N103-$B$103-N107-N108,\"\")","v":""},null,{"$f":"A113","v":"Net Incremental O&M Cost "}]
["Net Incremental Energy Cost (Electric + Fuel)","N/A",null,{"$f":"IF(D105>0,D104-$B$104,\"\")","v":""},null,{"$f":"IF(F105>0,F104-$B$104,\"\")","v":""},null,{"$f":"IF(H105>0,H104-$B$104,\"\")","v":""},null,{"$f":"IF(J105>0,J104-$B$104,\"\")","v":""},null,{"$f":"IF(L105>0,L104-$B$104,\"\")","v":""},null,{"$f":"IF(N105>0,N104-$B$104,\"\")","v":""},null,{"$f":"A114","v":"Net Incremental Energy Cost (Electric + Fuel)"}]
["Net Incremental Annual Cost (O&M+Energy)","N/A",null,{"$f":"IF(D105>0,D114+D113,\"\")","v":""},null,{"$f":"IF(F105>0,F114+F113,\"\")","v":""},null,{"$f":"IF(H105>0,H114+H113,\"\")","v":""},null,{"$f":"IF(J105>0,J114+J113,\"\")","v":""},null,{"$f":"IF(L105>0,L114+L113,\"\")","v":""},null,{"$f":"IF(N105>0,N114+N113,\"\")","v":""},null,{"$f":"A115","v":"Net Incremental Annual Cost (O&M+Energy)"}]
["Simple Payback (without incentive)","N/A",null,{"$f":"IF(D115=\"\",\"\",IF(D115<0,ABS(D112/D115),\"N/A\"))","v":""},null,{"$f":"IF(F115=\"\",\"\",IF(F115<0,ABS(F112/F115),\"N/A\"))","v":""},null,{"$f":"IF(H115=\"\",\"\",IF(H115<0,ABS(H112/H115),\"N/A\"))","v":""},null,{"$f":"IF(J115=\"\",\"\",IF(J115<0,ABS(J112/J115),\"N/A\"))","v":""},null,{"$f":"IF(L115=\"\",\"\",IF(L115<0,ABS(L112/L115),\"N/A\"))","v":""},null,{"$f":"IF(N115=\"\",\"\",IF(N115<0,ABS(N112/N115),\"N/A\"))","v":""}]

{"sheet":"5- Incremental Costs","index":8,"n_rows":55,"n_cols":28,"rows_kept":55,"cut":false,"hidden":false,"merged":[[4,3,4,15],[6,3,6,15],[8,3,8,15],[15,0,17,0],[23,0,25,0],[13,1,14,1],[13,3,13,8],[19,1,19,3],[15,1,17,1],[21,10,21,15],[21,1,22,1],[21,3,21,8],[45,3,45,8],[45,10,45,15],[27,1,27,3],[23,1,25,1],[29,1,30,1],[29,3,29,8],[29,10,29,15],[31,1,33,1],[35,1,35,3],[37,1,38,1],[2,0,2,7],[2,13,2,15],[54,1,54,3],[54,6,54,7],[54,13,54,14],[37,3,37,8],[37,10,37,15],[39,1,41,1],[43,1,43,3],[45,1,46,1],[51,1,51,3],[47,1,49,1],[13,10,13,15],[31,0,33,0],[39,0,41,0],[47,0,49,0]]}
["CleanBC New Construction Incentives"]
["Incremental Capital Costs"]
["White, bordered cells for user inputs (if applicable)",null,null,null,null,null,null,null,null,null,null,null,"DATE of SUBMISSION >>>",null,null,null,"Day-Month-Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden Y-AC"]
[null,"Project:",null,{"$f":"'1- pre screen'!B22","v":"Project Name"}]
[]
[null,"Owner:",null,{"$f":"'1- pre screen'!B12","v":"Organization name"}]
[]
[null,"Analysis by:"]
[]
[null,"This sheet accepts insertion of new rows - please complete \"Capital Cost $\" column formula if inserting row"]
[]
[]
[null,"Measure Name",null,{"$f":"'2- Proposal'!B33","v":"Baseline\n(Concept Design Model)"},null,null,null,null,null,null,{"$f":"'2- Proposal'!C33","v":"Proposed Building Design"}]
[null,null,null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $",null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $","Incremental $ per unit area",null,null,null,null,null,null,null,null,"Roof Area","Unit","Area Metric"]
[1,{"$f":"'4- Study Results'!D57","v":0},null,null,null,null,null,null,{"$f":"F16*H16","v":0},null,null,null,null,null,null,{"$f":"M16*O16","v":0},{"$f":"O16-H16","v":0},null,null,null,null,null,null,null,null,{"$f":"M16","v":0},{"$f":"N16","v":0},{"$f":"IF(AA16=\"m2\", Z16,Z16*0.0929)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F17*H17","v":0},null,null,null,null,null,null,{"$f":"M17*O17","v":0},{"$f":"O17-H17","v":0},null,null,null,null,null,null,null,null,{"$f":"M17","v":0},{"$f":"N17","v":0},{"$f":"IF(AA17=\"m2\", Z17,Z17*0.0929)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F18*H18","v":0},null,null,null,null,null,null,{"$f":"M18*O18","v":0},{"$f":"O18-H18","v":0},null,null,null,null,null,null,null,null,{"$f":"M18","v":0},0,0]
[null,null,null,null,"Total",{"$f":"SUM(F16:F18)","v":0},null,"Total",{"$f":"SUM(I16:I18)","v":0},null,null,"Total",{"$f":"SUM(M16:M18)","v":0},null,"Total",{"$f":"SUM(P16:P18)","v":0},null,null,null,null,null,null,null,null,null,null,"Tot. Metric",{"$f":"SUM(AB16:AB18)","v":0}]
[null,"Incremental Capital Cost",null,null,{"$f":"P19-I19","v":0}]
[]
[null,"Measure Name",null,{"$f":"$D$14","v":"Baseline\n(Concept Design Model)"},null,null,null,null,null,null,{"$f":"$K$14","v":"Proposed Building Design"}]
[null,null,null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $",null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $","Incremental $ per unit area",null,null,null,null,null,null,null,null,"Wall Area","Unit","Area Metric"]
[2,{"$f":"'4- Study Results'!F57","v":0},null,null,null,null,null,null,{"$f":"F24*H24","v":0},null,null,null,null,null,null,{"$f":"M24*O24","v":0},{"$f":"O24-H24","v":0},null,null,null,null,null,null,null,null,{"$f":"M24","v":0},{"$f":"N24","v":0},{"$f":"IF(AA24=\"m2\", Z24,Z24*0.0929)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F25*H25","v":0},null,null,null,null,null,null,{"$f":"M25*O25","v":0},{"$f":"O25-H25","v":0},null,null,null,null,null,null,null,null,{"$f":"M25","v":0},{"$f":"N25","v":0},{"$f":"IF(AA25=\"m2\", Z25,Z25*0.0929)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F26*H26","v":0},null,null,null,null,null,null,{"$f":"M26*O26","v":0},{"$f":"O26-H26","v":0},null,null,null,null,null,null,null,null,{"$f":"M26","v":0},0,0]
[null,null,null,null,"Total",{"$f":"SUM(F24:F26)","v":0},null,"Total",{"$f":"SUM(I24:I26)","v":0},null,null,"Total",{"$f":"SUM(M24:M26)","v":0},null,"Total",{"$f":"SUM(P24:P26)","v":0},null,null,null,null,null,null,null,null,null,null,"Tot. Metric",{"$f":"SUM(AB24:AB26)","v":0}]
[null,"Incremental Capital Cost",null,null,{"$f":"P27-I27","v":0}]
[]
[null,"Measure Name",null,{"$f":"$D$14","v":"Baseline\n(Concept Design Model)"},null,null,null,null,null,null,{"$f":"$K$14","v":"Proposed Building Design"}]
[null,null,null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $",null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $","Incremental $ per unit area",null,null,null,null,null,null,null,null,"Window Area","Unit","Area Metric"]
[3,{"$f":"'4- Study Results'!H57","v":0},null,null,null,null,null,null,{"$f":"F32*H32","v":0},null,null,null,null,null,null,{"$f":"M32*O32","v":0},{"$f":"O32-H32","v":0},null,null,null,null,null,null,null,null,{"$f":"M32","v":0},{"$f":"N32","v":0},{"$f":"IF(AA32=\"m2\", Z32,Z32*0.0929)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F33*H33","v":0},null,null,null,null,null,null,{"$f":"M33*O33","v":0},{"$f":"O33-H33","v":0},null,null,null,null,null,null,null,null,{"$f":"M33","v":0},{"$f":"N33","v":0},{"$f":"IF(AA33=\"m2\", Z33,Z33*0.0929)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F34*H34","v":0},null,null,null,null,null,null,{"$f":"M34*O34","v":0},{"$f":"O34-H34","v":0},null,null,null,null,null,null,null,null,{"$f":"M34","v":0},0,0]
[null,null,null,null,"Total",{"$f":"SUM(F32:F34)","v":0},null,"Total",{"$f":"SUM(I32:I34)","v":0},null,null,"Total",{"$f":"SUM(M32:M34)","v":0},null,"Total",{"$f":"SUM(P32:P34)","v":0},null,null,null,null,null,null,null,null,null,null,"Tot. Metric",{"$f":"SUM(AB32:AB34)","v":0}]
[null,"Incremental Capital Cost",null,null,{"$f":"P35-I35","v":0}]
[]
[null,"Measure Name",null,{"$f":"$D$14","v":"Baseline\n(Concept Design Model)"},null,null,null,null,null,null,{"$f":"$K$14","v":"Proposed Building Design"}]
[null,null,null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $",null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $"]
[4,{"$f":"'4- Study Results'!J57","v":0},null,null,null,null,null,null,{"$f":"F40*H40","v":0},null,null,null,null,null,null,{"$f":"M40*O40","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F41*H41","v":0},null,null,null,null,null,null,{"$f":"M41*O41","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F42*H42","v":0},null,null,null,null,null,null,{"$f":"M42*O42","v":0}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I40:I42)","v":0},null,null,null,null,null,"Total",{"$f":"SUM(P40:P42)","v":0}]
[null,"Incremental Capital Cost",null,null,{"$f":"P43-I43","v":0}]
[]
[null,"Measure Name",null,{"$f":"$D$14","v":"Baseline\n(Concept Design Model)"},null,null,null,null,null,null,{"$f":"$K$14","v":"Proposed Building Design"}]
[null,null,null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $",null,"Item","Description","Quantity","Unit","Cost per Unit  $","Capital Cost $"]
[5,{"$f":"'4- Study Results'!L57","v":0},null,null,null,null,null,null,{"$f":"F48*H48","v":0},null,null,null,null,null,null,{"$f":"M48*O48","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F49*H49","v":0},null,null,null,null,null,null,{"$f":"M49*O49","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F50*H50","v":0},null,null,null,null,null,null,{"$f":"M50*O50","v":0}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I48:I50)","v":0},null,null,null,null,null,"Total",{"$f":"SUM(P48:P50)","v":0}]
[null,"Incremental Capital Cost",null,null,{"$f":"P51-I51","v":0}]
[]
[]
[null,"Total Incremental Capital Cost",null,null,{"$f":"P55-I55","v":0},null,"Total Baseline Capital Cost",null,{"$f":"'4- Study Results'!B100","v":0},null,null,null,null,"Total Proposed Capital Cost",null,{"$f":"'4- Study Results'!N101","v":0}]

{"sheet":"Summary","index":9,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,6,0,7],[0,0,0,5],[1,0,1,2],[36,4,36,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[4,1,4,2],[5,1,5,2],[3,1,3,5]]}
["CleanBC New Construction Incentives\nSummary report",null,null,null,null,null,{"$f":"'1- pre screen'!G1:G2","v":"CleanBC New Construction Workbook v2.0"}]
[{"$f":"IF('4- Study Results'!B19=\"\",IF('2- Proposal'!B36=\"\",\"Pre-screen\",\"Proposal\"),\"Study Report\")","v":"Pre-screen"}]
[]
["Project Name",{"$f":"'3- Study Inputs'!B22","v":"Project Name"}]
["Project Location",{"$f":"'1- pre screen'!B24:F24","v":"Site City"},null,null,"printed:",{"$f":"TODAY()","v":"2020-09-25"}]
["Project Owner",{"$f":"'3- Study Inputs'!B10","v":"Company Name"},null,null,"BC Hydro Ref #",{"$f":"'3- Study Inputs'!D3","v":"BCH-00000"}]
["Building Types",{"$f":"'3- Study Inputs'!B37:C37","v":0},{"$f":"'3- Study Inputs'!G37","v":0},{"$f":"'3- Study Inputs'!L37","v":0},{"$f":"'3- Study Inputs'!Q37","v":0},"Total Conditioned Area (m2)"]
["Conditioned Area (m2)",{"$f":"'3- Study Inputs'!B38","v":0},{"$f":"'3- Study Inputs'!G38","v":0},{"$f":"'3- Study Inputs'!L38","v":0},{"$f":"'3- Study Inputs'!Q38","v":0},{"$f":"SUM(B8:E8)","v":0}]
[]
["Net Incremental GHG Emissions ",{"$f":"'4- Study Results'!N98","v":{"$error":"#VALUE!"}},"tonneCO2e","over measures life"]
[{"$f":"IFERROR(IF(B10>-400,\"Project may not qualify for incentive as GHG reduction over measure(s) life must be equal or greater than 400 tCO2e.\",\"\"),\"\")","v":""}]
[null,null,null,null,"% reduction"]
["Net Incremental Fuel Consumption",{"$f":"'4- Study Results'!F52","v":0},"GJ / year",">>>>>>",{"$f":"(B13/'4- Study Results'!B85)*1000/3.6","v":{"$error":"#DIV/0!"}},"of Baseline Gas"]
["Net Incremental GHG Emissions",{"$f":"'4- Study Results'!F53","v":0},"tonneCO2e / year",">>>>>>",{"$f":"B14/'4- Study Results'!B91","v":{"$error":"#N/A"}},"of Baseline GHG"]
["Net Incremental Electrical Energy",{"$f":"'4- Study Results'!F51","v":0},"kWh / year",">>>>>>",{"$f":"B15/'4- Study Results'!B79","v":{"$error":"#DIV/0!"}},"of Baseline Electricity"]
["Net Incremental Electrical Annual Monthly Average Demand",{"$f":"'4- Study Results'!N95","v":0},"kW",">>>>>>",{"$f":"B16/'4- Study Results'!B81","v":{"$error":"#DIV/0!"}},"of Baseline Electric Demand"]
["Net Incremental Operating Cost (O&M+Energy)",{"$f":"'4- Study Results'!N115","v":""},"per year",">>>>>>",{"$f":"B17/'4- Study Results'!B104","v":{"$error":"#VALUE!"}},"of Baseline Total Annual Cost"]
["Net Incremental Capital Cost",{"$f":"'4- Study Results'!N112","v":""},"$",">>>>>>",{"$f":"B18/'4- Study Results'!B100","v":{"$error":"#VALUE!"}},"of Baseline Capital Cost"]
["Total Energy Use Intensity (TEUI)   ekWh/m2/year","Baseline = ",{"$f":"'4- Study Results'!N52","v":{"$error":"#DIV/0!"}},"Proposed = ",{"$f":"'4- Study Results'!N53","v":{"$error":"#DIV/0!"}},"based on CONDITIONED area"]
["Annual GHG Intensity (GHGI)   kgCO2e/m2/year","Baseline = ",{"$f":"1000*'4- Study Results'!F39/'4- Study Results'!F8","v":{"$error":"#DIV/0!"}},"Proposed = ",{"$f":"1000*'4- Study Results'!N39/'4- Study Results'!F8","v":{"$error":"#DIV/0!"}},"based on CONDITIONED area"]
[]
["Electrification Measures Included in Proposed Design Bundle"]
[null,"Net Incremental Electrical Energy\n( kWh/year )","Net Incremental Fuel Consumption\n( GJ / year )","Net Incremental GHG Emissions (tCO2e/year)","Net Incremental Annual Cost (O&M+Energy)","Net Incremental Capital Cost","Expected Measure Life","Simple Payback\n(year)"]
[{"$f":"IF('4- Study Results'!D59=\"Yes\",'4- Study Results'!D57,\"\")","v":""},{"$f":"IF(A24=\"\",\"\",'4- Study Results'!D93)","v":""},{"$f":"IF(A24=\"\",\"\",'4- Study Results'!D96)","v":""},{"$f":"IF(A24=\"\",\"\",'4- Study Results'!D97)","v":""},{"$f":"IF(A24=\"\",\"\",'4- Study Results'!D115)","v":""},{"$f":"IF(A24=\"\",\"\",'4- Study Results'!D112)","v":""},{"$f":"IF(A24=\"\",\"\",'4- Study Results'!D60)","v":""},{"$f":"IF(E24=\"\",\"\",IF(AND(E24<0,F24>0),ABS(F24/E24),\"N/A\"))","v":""}]
[{"$f":"IF('4- Study Results'!F59=\"Yes\",'4- Study Results'!F57,\"\")","v":""},{"$f":"IF(A25=\"\",\"\",'4- Study Results'!F93)","v":""},{"$f":"IF(A25=\"\",\"\",'4- Study Results'!F96)","v":""},{"$f":"IF(A25=\"\",\"\",'4- Study Results'!F97)","v":""},{"$f":"IF(A25=\"\",\"\",'4- Study Results'!F115)","v":""},{"$f":"IF(A25=\"\",\"\",'4- Study Results'!F112)","v":""},{"$f":"IF(A25=\"\",\"\",'4- Study Results'!F60)","v":""},""]
[{"$f":"IF('4- Study Results'!H59=\"Yes\",'4- Study Results'!H57,\"\")","v":""},{"$f":"IF(A26=\"\",\"\",'4- Study Results'!H93)","v":""},{"$f":"IF(A26=\"\",\"\",'4- Study Results'!H96)","v":""},{"$f":"IF(A26=\"\",\"\",'4- Study Results'!H97)","v":""},{"$f":"IF(A26=\"\",\"\",'4- Study Results'!H115)","v":""},{"$f":"IF(A26=\"\",\"\",'4- Study Results'!H112)","v":""},{"$f":"IF(A26=\"\",\"\",'4- Study Results'!H60)","v":""},""]
[{"$f":"IF('4- Study Results'!J59=\"Yes\",'4- Study Results'!J57,\"\")","v":""},{"$f":"IF(A27=\"\",\"\",'4- Study Results'!J93)","v":""},{"$f":"IF(A27=\"\",\"\",'4- Study Results'!J96)","v":""},{"$f":"IF(A27=\"\",\"\",'4- Study Results'!J97)","v":""},{"$f":"IF(A27=\"\",\"\",'4- Study Results'!J115)","v":""},{"$f":"IF(A27=\"\",\"\",'4- Study Results'!J112)","v":""},{"$f":"IF(A27=\"\",\"\",'4- Study Results'!J60)","v":""},""]
[{"$f":"IF('4- Study Results'!L59=\"Yes\",'4- Study Results'!L57,\"\")","v":""},{"$f":"IF(A28=\"\",\"\",'4- Study Results'!L93)","v":""},{"$f":"IF(A28=\"\",\"\",'4- Study Results'!L96)","v":""},{"$f":"IF(A28=\"\",\"\",'4- Study Results'!L97)","v":""},{"$f":"IF(A28=\"\",\"\",'4- Study Results'!L115)","v":""},{"$f":"IF(A28=\"\",\"\",'4- Study Results'!L112)","v":""},{"$f":"IF(A28=\"\",\"\",'4- Study Results'!L60)","v":""},""]
[]
["BUNDLE",{"$f":"B15","v":0},{"$f":"B13","v":0},{"$f":"B14","v":0},{"$f":"B17","v":""},{"$f":"B18","v":""},{"$f":"SUMPRODUCT(D24:D28,G24:G28)/SUM(D24:D28)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(E30<0,F30>0),ABS(F30/E30),\"N/A\")","v":"N/A"}]
["Positive values indicate cost increase, negative values indicate cost decrease",null,null,null,null,null,null,{"$f":"IFERROR(IF(H30<=4,\"Paypack period is four years or less, this project will not qualify for incentives\",\"\"),\"\")","v":""}]
[]
[{"$f":"'3- Study Inputs'!A14","v":"Primary (Lead) Consultant"},{"$f":"'3- Study Inputs'!B14","v":"Company Name"},{"$f":"'3- Study Inputs'!C14","v":"contact name"},{"$f":"'3- Study Inputs'!D14","v":"phone"},{"$f":"'3- Study Inputs'!E14","v":"email"}]
[{"$f":"'3- Study Inputs'!A15","v":"Energy Modeller"},{"$f":"'3- Study Inputs'!B15","v":"Company Name"},{"$f":"'3- Study Inputs'!C15","v":"contact name"},{"$f":"'3- Study Inputs'!D15","v":"phone"},{"$f":"'3- Study Inputs'!E15","v":"email"}]
[{"$f":"'3- Study Inputs'!A16","v":"Mechanical Consultant"},{"$f":"'3- Study Inputs'!B16","v":"Company Name"},{"$f":"'3- Study Inputs'!C16","v":"contact name"},{"$f":"'3- Study Inputs'!D16","v":"phone"},{"$f":"'3- Study Inputs'!E16","v":"email"}]
[{"$f":"'3- Study Inputs'!A17","v":"Cost Consultant"},{"$f":"'3- Study Inputs'!B17","v":"Company Name"},{"$f":"'3- Study Inputs'!C17","v":"contact name"},{"$f":"'3- Study Inputs'!D17","v":"phone"},{"$f":"'3- Study Inputs'!E17","v":"email"}]
[{"$f":"'3- Study Inputs'!A18","v":"General Contractor"},{"$f":"'3- Study Inputs'!B18","v":"Company Name"},{"$f":"'3- Study Inputs'!C18","v":"contact name"},{"$f":"'3- Study Inputs'!D18","v":"phone"},{"$f":"'3- Study Inputs'!E18","v":"email"}]

{"sheet":"6- Baseline Hourly Results","index":10,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Copy/paste hourly results from your model for the whole year for electricity AND gas"]
["the table should show breakdown of end uses (e.g. lighting, heating, cooling, etc.)"]

{"sheet":"7- Proposed Hourly Results","index":11,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Copy/paste hourly results from your model for the whole year for electricity AND gas"]
["the table should show breakdown of end uses (e.g. lighting, heating, cooling, etc.)"]

{"sheet":"Prescreening Review","index":12,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Date",null,null,"day-month-year","day-month-year","day-month-year","day-month-year"]
["Comment #","Sheet Name","Cell Reference","FIRST Review - by \nNAME\nEMAIL\nTEL","RESPONSE to First Review - by \nNAME\nEMAIL\nTEL","SECOND Review - by \nNAME\nEMAIL\nTEL","RESPONSE to Second Review - by \nNAME\nEMAIL\nTEL"]
[1]
[{"$f":"1+A3","v":2}]
[{"$f":"1+A4","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Proposal Review","index":13,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Date",null,null,"day-month-year","day-month-year","day-month-year","day-month-year"]
["Comment #","Sheet Name","Cell Reference","FIRST Review - by \nNAME\nEMAIL\nTEL","RESPONSE to First Review - by \nNAME\nEMAIL\nTEL","SECOND Review - by \nNAME\nEMAIL\nTEL","RESPONSE to Second Review - by \nNAME\nEMAIL\nTEL"]
[1]
[{"$f":"1+A3","v":2}]
[{"$f":"1+A4","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Study Review","index":14,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Date",null,null,"day-month-year","day-month-year","day-month-year","day-month-year"]
["Comment #","Sheet Name","Cell Reference","FIRST Review - by \nNAME\nEMAIL\nTEL","RESPONSE to First Review - by \nNAME\nEMAIL\nTEL","SECOND Review - by \nNAME\nEMAIL\nTEL","RESPONSE to Second Review - by \nNAME\nEMAIL\nTEL"]
[1]
[{"$f":"1+A3","v":2}]
[{"$f":"1+A4","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Financial Model inputs","index":15,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,"Financial Model Inputs","Building 1","Building 2","Building 3","Building 4","TOTAL",{"$f":"E4","v":"Financial Model Inputs"}]
[null,null,null,null,"Elec Rate",{"$f":"'1- pre screen'!B45","v":0},{"$f":"'1- pre screen'!C45","v":0},{"$f":"'1- pre screen'!D45","v":0},{"$f":"'1- pre screen'!E45","v":0},{"$f":"('4- Study Results'!N104-J6*'4- Study Results'!N86)/'4- Study Results'!N79","v":{"$error":"#DIV/0!"}},"Elec Rate"]
[null,null,null,null,"Gas Rate",{"$f":"'1- pre screen'!B46","v":0},{"$f":"'1- pre screen'!C46","v":0},{"$f":"'1- pre screen'!D46","v":0},{"$f":"'1- pre screen'!E46","v":0},{"$f":"SUMPRODUCT('4- Study Results'!$B$8:$E$8,F6:I6)/'4- Study Results'!$F$8","v":{"$error":"#DIV/0!"}},"Gas Rate"]
[null,null,null,null,"Gas reduction GJ",{"$f":"'4- Study Results'!B52","v":0},{"$f":"'4- Study Results'!C52","v":0},{"$f":"'4- Study Results'!D52","v":0},{"$f":"'4- Study Results'!E52","v":0},{"$f":"SUM(F7:I7)","v":0},"Gas reduction GJ"]
[null,null,null,null,"Gas GHG reduction (tonns)",{"$f":"'4- Study Results'!B53","v":""},{"$f":"'4- Study Results'!C53","v":""},{"$f":"'4- Study Results'!D53","v":""},{"$f":"'4- Study Results'!E53","v":""},{"$f":"SUM(F8:I8)","v":0},"Gas GHG reduction (tonns)"]
[null,null,null,null,"Elect Growth kWh",{"$f":"'4- Study Results'!B51","v":0},{"$f":"'4- Study Results'!C51","v":0},{"$f":"'4- Study Results'!D51","v":0},{"$f":"'4- Study Results'!E51","v":0},{"$f":"SUM(F9:I9)","v":0},"Elect Growth kWh"]
[null,null,null,null,"Elec demand growth kW",{"$f":"'4- Study Results'!B51","v":0},{"$f":"'4- Study Results'!C51","v":0},{"$f":"'4- Study Results'!D51","v":0},{"$f":"'4- Study Results'!E51","v":0},{"$f":"SUM(G10:I10)","v":0},"Elec demand growth kW"]
[null,null,null,null,"Carbon tax",{"$f":"'1- pre screen'!B47","v":0},{"$f":"'1- pre screen'!C47","v":0},{"$f":"'1- pre screen'!D47","v":0},{"$f":"'1- pre screen'!E47","v":0},{"$f":"SUMPRODUCT('4- Study Results'!$B$8:$E$8,F11:I11)/'4- Study Results'!$F$8","v":{"$error":"#DIV/0!"}},"Carbon tax"]
[null,null,null,null,"Carbon offset credit",{"$f":"'1- pre screen'!B48","v":0},{"$f":"'1- pre screen'!C48","v":0},{"$f":"'1- pre screen'!D48","v":0},{"$f":"'1- pre screen'!E48","v":0},{"$f":"SUMPRODUCT('4- Study Results'!$B$8:$E$8,F12:I12)/'4- Study Results'!$F$8","v":{"$error":"#DIV/0!"}},"Carbon offset credit"]
[null,null,null,null,"Baseline cap cost",null,null,null,null,{"$f":"'4- Study Results'!B100","v":0},"Baseline cap cost"]
[null,null,null,null,"Baseline O&M cost",null,null,null,null,0,"Baseline O&M cost"]
[null,null,null,null,"Proposed Cap Cost",null,null,null,null,{"$f":"'4- Study Results'!N101","v":0},"Proposed Cap Cost"]
[null,null,null,null,"Proposed O&M cost",null,null,null,null,{"$f":"'4- Study Results'!N103","v":0},"Proposed O&M cost"]
[null,null,null,null,"EML",null,null,null,null,{"$f":"Summary!G30","v":{"$error":"#DIV/0!"}},"EML"]