{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Drop Down","Introduction","Version History","Basic Info","Model Inputs (PHI)","Model Inputs (PHIUS)","Water Savings","Energy Savings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":25,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Drop Down","index":0,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Garage","Condition","YN","Milestone","Rev","Income","Construction","Fuel","DHW Method","Units","Energy Star","Water Sense","Pump Type","Pump Class","Fan Control","Heating Control","Fan","FanRate","YesNo",null,"PHStatus","Errors"]
["N/A","N/A","N/A","Please Select",0,"Please Select","Please Select","Please Select","Please Select",null,"Please Select","Please Select","Please Select","Please Select","Please Select","Please Select","Please Select","NA","Please Select",2,"Pre-Certified","Only use 'Unconditioned' for spaces that have no active heating or cooling AND are not indirectly conditioned by adjacent conditioned spaces."]
["Under Ground Garage","Heated & Cooled","Yes","Proposed Design",1,"Market Rate","New Construction","natural gas","Apartment Method","kBtu/hr","Not Applicable","Not Applicable","One-Speed","Standard","Variable Speed","Fixed","Ceiling ( 10-80 CFM)",1.2,"Yes",5,"Certified","You must fill in the conditioned column."]
["Above Ground Garage","Heated-Only","No","As-Built",2,"Low-to-Moderate Income","Gut-rehab","oil","Occupancy Method","cubic feet","None Installed","None Installed","Two-Speed","High Efficiency","Inlet","OA Reset","Ceiling (90-500 CFM)",2.2999999999999998,"No",7]
["Parking Lot","Cooled-Only",null,null,3,"Blended",null,"propane",null,"degrees","Non-Energy Star","Non-WaterSense","Variable Speed","Premium","Discharge","Scheduled","Inline or Range Hood",2.2999999999999998,null,6]
[null,"Unconditioned",null,null,4,null,null,"steam",null,"each","Energy Star","WaterSense","Cycle",null,"Cycling","Load Reset","Rooftop/Other","NA"]
[null,null,null,null,5,null,null,"electric",null,"gallons",null,null,null,null,"Two Speed","N/A"]
[null,null,null,null,6,null,null,null,null,"linear feet",null,null,null,null,"Constant Volume"]
[null,null,null,null,null,null,null,null,null,"square feet"]
[null,null,null,null,null,null,null,null,null,"tons"]

{"sheet":"Introduction","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,1,4,2],[6,1,6,2]]}
[null,"Multifamily New Construction Program (MF NCP) - PON 3716"]
[null,"Building Performance Plan"]
[null,"Version 1.5 -  ECCC NYS 2016 - April 2019"]
[]
[null,"The following worksheets detail the information regarding the recommended scope of work and document the achievement of the program's required threshold(s) for PHIUS and PHI path projects. Some cells are protected to prevent accidental over-writing of formulas. "]
[]
[null,"Note that throughout these worksheets, common information from cells are linked and should automatically update.  Only cells shaded in blue need to be entered manually at Milestone #1. For PHI projects, green cells only need to be entered at the Milestone #2 submittal. Entering values into white cells will override pre-determined formulas.  However, depending on the project, there may be reason to write over the pre-determined formulas."]
[]
[null,"Basic Info"]
[null,null,"In blue cells only, enter the basic information about the building."]
[]
[null,"Water Savings"]
[null,null,"By entering data in blue cells only, this worksheet will calculate the water savings in gallons based on the proposed flow rates entered. This information does not affect the Performance Rating but can be used when calculating SIR to justify measures that reduce consumption of water. This tab is optional. "]
[]
[null,"For PHIUS Projects "]
[]
[null,"Model Inputs - Proposed Design/As-Built Design (Milestone #1 & Milestone #3)"]
[null,null,"In blue cells only, enter information about how the building was modeled.  Follow the formatting guidelines presented as comments (red corners) where available."]
[]
[null,"For PHI Projects "]
[]
[null,"Model Inputs - Proposed Design/As-Built Design (Milestone #1 & Milestone #3)"]
[null,null,"In blue cells only, enter information about how the building was modeled.  Follow the formatting guidelines presented as comments (red corners) where available."]
[]
[null,"Model Inputs - Updates to Proposed Design at Open Wall Milestone (Milestone #2)"]
[null,null,"In the green cells only, indicate whether there have been any changes to the component from the proposed design. If yes, enter the as-built design following the formatting guidelines presented as comments (red corners) where available. Indicate whether the component was verified in the field and include the initials of the field inspector."]

{"sheet":"Version History","index":2,"n_rows":129,"n_cols":2,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
["BPP Version 1.5 - Addition of Milestone #2 fields for PHI projects "]
["Introduction","Updated to reflect Milestone #2 submittal requirements "]
["Model Inputs","Added fields for for PHI Milestone #2 project information updates & inspection fields "]
["Model Inputs ","Deleted AFUE & EER information in columns W-Z"]
["Basic Info","Added Macro to workbook which selects model inputs tab based on input of cell C3. Based on selection either PHI tab will appear or the PHIUS tab will appear. "]
["Water Savings","Water Savings populates based on PHI or PHIUS selection. "]
[]
["BPP Version 1.4 - Bug fixes and enhancements"]
["Basic Info","Added note to common area field to describe what spaces should be included."]
[null,"Removed the utility cost fields."]
[null,"Added explicit fields asking if THERM, PV Watt and PHIUS+ Multifamily Calculator were used."]
[null,"Added note that incremental cost fields were optional."]
["Model Inputs","Updated envelope data fields to match Passive House inputs (e.g., Psi-value of floor perimeter/floor edge)"]
[null,"Added note to fenestration U-factor field to specify that the psi-value should not be included in this assembly value."]
[null,"Updated ventilation fan power units from kW to W/CFM to match Passive House tool inputs."]
["Energy Savings","Deleted energy cost savings fields."]
[]
["BPP Version 1.3 - Update to Passive House only tool"]
["Introduction","Update to reflect new intended use: for PHI and PHIUS projects only."]
["Basic Info","Reduced amount of data collected; updated to align with PHI and PHIUS projects only. Added total incremental project cost."]
["Model Inputs","Reduced amount of data collected; updated to align with PHI and PHIUS projects only."]
["Water Savings","Added Water Use Occupancy field; updated links to reference Model Inputs tab."]
["Energy Savings","Added Energy Savings tab to calculate savings for PHI and PHIUS projects for NYSERDA reporting."]
["Reporting Summary","Deleted Reporting Summary tab, which was used for Performance Path projects."]
["Detailed Measures","Deleted Detailed Measures tab, which was used for Performance Path projects."]
["Results from eQUEST","Deleted Results from eQUEST tab, which was used for Performance Path projects using eQUEST."]
["Simulation Guidelines Appx (multiple)","Deleted Simulation Guidelines Appendix tabs, as they were intended to help in the creation of eQUEST models."]
[]
[]
["BPP Version 1.2 - Bug fixes"]
["Exterior Lighting","Fixed error in calculations"]
["Water Savings","Fixed error in calculations"]
[]
[]
["BPP Version 1.1 - ASHRAE 2010 Updates"]
[]
["Basic Info","Added compliance path drop-down - Choosing a PH pathway causes tabs and columns throughout workbook to hide"]
[null,"Added TFA and iCFA for appropriate PH pathways"]
[null,"Added Total Square Footage within Thermal Boundary for PH pathways"]
[null,"Added Passive House Certification Status"]
[null,"Added PHIUS Project #"]
[null,"Added \"blended\" option to Housing Income Classification drop down"]
[null,"Added \"Other Software\" for Partners to note other Passive House software used on project (WUFI Plus, THERM, etc.)"]
[null,"Added comment to Weather File Location: If project is located in NYC and following the PHIUS path, enter ASHRAE 2013 & Global Solar Radiation Location from PHIUS climate map"]
[null,"Added fields for Passive House Consultant, Field Verification, and Certifier"]
[]
["Model Inputs","Envelope: Added location field for certain envelope components."]
[null,"Envelope: Added shading reduction factor field."]
[null,"Envelope: Expanded comments"]
[null,"Heating: Added location field, and added comment on quantity field."]
[null,"Cooling: Added location field, and added comment on quantity field."]
[null,"DHW: Added quantity and location field, with comment.  Added WaterSense option for fixtures."]
[null,"Ventilation: Added model and make for corridor supply ventilation and garage exhaust fan."]
[null,"Added Renewable and Distributed Generation section."]
[null,"Added Passive House Modeling Results section."]
[]
[]
["BPP Version 1.0 - ASHRAE 2010 Updates","Release Date 8/2016"]
[]
["Basic Info","Added Performance Tier drop-down."]
[null,"Updated energy rates per MF NCP Guidelines."]
["Model Inputs","Added field in Envelope section, requiring a description of all penetrations through the continuous insulation."]
["Detailed Measures","Removed all measure cost fields and cost effectiveness calculations."]
[null,"Clarified instructions."]
[null,"Added some additional measures to pull-down menu."]
["Water Savings/DHW Demand","Shifted around some fields so that DHW Demand tab could be completed prior to any inputs into Water Savings tab."]
[null,"Updated water rates to reflect higher NYC water costs.  Non-NYC water costs remained the same."]
["Interior Lighting","Updated parking garage LPD for Whole Building calculation method."]
[null,"Updated to allow increase to Baseline LPD per 9.6.3 and remove credit for spaces with mandatory occupancy sensors."]
["Infiltration and Ventilation tab","Updated to allow for air sealing/infiltration credit."]
["EIR for PTAC and PTHP","Updated Efficiency Conversion Calculators per ASHRAE 90.1-2013, G3.1.2.1"]
[]
["Version 6.1 - ASHRAE 2010 Updates","Release Date 1/2015"]
[]
["Model Inputs","Updated baseline guidance to match updated code (ASHRAE 90.1-2010, 62.1-2010 and 62.2-2010)."]
[null,"Updated baseline ventilation guidelines to require baseline ventilation rates meet ASHRAE 62.1 or 62.2, as the baseline is no longer allowed to be up to 50% higher than code."]
[null,"Added linking from Model Input tab to Infiltration and Ventilation tab to reduce amount of data entry necessary.  Altered fields to reflect these changes."]
[null,"Added allowance to claim infiltration improvement for As-Built building, based on blower door results."]
[null,"Updated garage demand control requirements from ASHRAE 90.1-2010."]
["Exterior Lighting","Updated to incorporate ASHRAE 90.1-2010 exterior lighting requirements.  Includes differing lighting allowances based on exterior lighting zone, and added base site allowance."]
["Infiltration/Ventilation","Updated baseline to require baseline ventilation rates meet ASHRAE 62.1 or 62.2, as the baseline is no longer allowed to be up to 50% higher than code."]
[null,"Added option for which infiltration baseline to use - either 0.3 CFM/sqft at 50 Pa or 0.4 CFM/sqft at 75 Pa."]
[null,"Added allowance to claim infiltration improvement for As-Built building, based on blower door results."]
[null,"Separated duct sealing credit by spaces (apt, corridor and other)"]
[]
["2015-02-04","Corrections made to cell references in Infiltration & Ventilation tab to reference the correct cells in the DHW Demand tab. Corrections made on the Appliance tab so the elevator calculation matches the table in the Simulation Guidelines (page 26.)"]
[]
["Version 6.1  - ASHRAE 2007 Updates","Release Date 11/2014"]
[]
["General Updates","Added \"General Notes\" section to the bottom of most tabs.  These notes fields are intended to allow the Partners to make comments in addition to what it easily input into the templated tables.  Adding notes are NOT mandatory, but instead should only be used when the Partners feel it is needed."]
["Basic Info","Added two ASHRAE space types (Lounge/Recreation and Exercise Area). "]
[null,"Deleted the “Mechanically Ventilated?” column for each space type.  "]
[null,"Removed “Non-Residential Spaces” from “Total Project Square Footage”."]
[null,"Added \"Project county\""]
[null,"Added \"MPP Program Version\" to assign correct incentives based on which phase of Version 6 the project is subject to."]
[null,"Added \"Revision Notes\" section to the bottom of the sheet.  This section is to be used with every revision, including As-Built Rev0, to help the reviewers understand what changes have occurred in the model (and/or design) since the last review."]
["Model Inputs","Updated ventilation section to correspond with updated Simulation Guidelines."]
[null,"Corrected maximum bathroom and kitchen intermittent exhaust rates (CFM) in baseline description.  (Should be 50% above ASHRAE 62.2.)"]
["Reporting Summary","Comment added that appears only if common area lighting exceed prerequisite (20% over ASHRAE).  "]
[null,"Separated out the Annual Other end use to Annual Fans and Annual Pumps."]
[null,"Added \"County\" to Table 1 to facilitate confirmation of Climate Zone."]
[null,"Updated Table 4 to get inputs necessary for Portfolio Manager."]
[null,"Automated the plug load value in Table 6."]
[null,"Added calculation determining the contribution of each end use to overall savings (% and points)."]
["Detailed Measures","Automated the heating fuel column."]
["Water Savings","Incorporated Low/Medium/High Usage into the proposed and baseline water usage. Incorporated PSI for fixture types in baseline and proposed fixtures. "]
["DHW Demand","Comment added that GPM flowrates entered must be the GPM rated at 80 psi."]
[null,"Incorporated PSI into avg faucet gpm. Based baseline & proposed avg faucet gpm and showerhead gpm on PSI for fixture types.  "]
["Interior Lighting","Updated to allow Prescriptive Path users to compare to 90.1-2010. "]
[null,"Added to note in lumen/fixture column that screw-in LEDs should use 70 lumen/Watt."]
[null,"Added two ASHRAE space types (Lounge/Recreation and Exercise Area)"]
[null,"Provided functionality to reduce W/sf for spaces if using automatic controls. "]
[null,"Note provided to caution users to only insert rows at the end of tables. "]
[null,"Food prep and family dining areas removed from ASHRAE space type drop-down. If these areas exist in common spaces, use \"Multipurpose\". "]
[null,"Drop-down added to indicate Space-by-Space or Building Area method for both 2007 and 2010."]
[null,"Changed the “24/7?” column to “Notes”, as any fixture type may be used in both 24/7 and non-24/7 spaces.  "]
[null,"Added note in instructions section clarifying requirement that total proposed wattage cannot exceed the total baseline wattage by more than 20%, as well as the similar comment for Prescriptive projects."]
[null,"Updated footcandle calculations to be based on light source & distribution. Incorporated room type into this equation.   "]
[null,"Added ASHRAE space types."]
[null,"Updated foot candle warning."]
[null,"Added instructional comment to remind users to add ballast power to \"Watts/Fixture\" entry in schedule"]
["In-unit lighting","Added lookup for illumination. It is based on the Interior Lighting worksheet. "]
[null,"Modified error check to check for appropriate calculations of lit area and to calculate average footcandles and room-by-room lighting power densities."]
["Exterior Lighting","Added ASHRAE 90.1-2010 Zones 2-3 into the table. Added warning for proposed building façade lighting exceeding baseline. Added Base site allowance dropdown to add into tradable or non-tradable equations. "]
[null,"Revised instruction #4 & #6 to assign exterior lighting to the \"exterior\" end-use category. Separated apartment balcony lighting to facilitate reporting."]
["Infiltration/Ventilation","Major overhaul of this tab that cannot be adequately captured by narrative.  Check it out."]
[null,"Range hood included as an option in the drop-down menu for Exhaust Fan type; Rooftop expanded to include \"other\".  "]
[null,"Updated exhaust fan calculations so that they are functional now."]
["EIR for PTAC and PTHP","Added Efficiency Conversion Calculator (SEER to EER; HSPF to COP)"]

{"sheet":"Basic Info","index":3,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,1,55,6],[56,1,60,6],[48,1,48,6],[38,2,38,3],[41,1,41,6],[42,1,46,6],[23,2,23,3],[24,2,24,3],[33,2,33,3],[37,2,37,3],[49,1,53,6]]}
[null,"Basic Project Information"]
[]
[null,"Compliance Pathway"]
[null,{"$f":"IF(Path=\"Performance Path\",\"\",\"Passive House Certification Status\")","v":"Passive House Certification Status"}]
[null,{"$f":"IF(Path=\"PHIUS\",\"PHIUS Project #\",\"\")","v":""}]
[]
[null,null,"Number of Units"]
[null,"Studio"]
[null,"1 - Bedroom"]
[null,"2 - Bedroom"]
[null,"3 - Bedroom"]
[null,"4 - Bedroom"]
[null,"Total Units",{"$f":"SUM(C8:C12)","v":0}]
[null,null," "]
[null,"Building Area","Total Square Ft",{"$f":"IF(Path=\"Performance Path\",\"\",\"Total Square Ft within Thermal Boundary\")","v":"Total Square Ft within Thermal Boundary"},"Conditioned?","Included in Passive House model?"]
[null,"Apartment"]
[null,"Common Areas"]
[null,"Non-Residential Associated Spaces"]
[null,"Total Project Square Footage",{"$f":"SUM(C16:C17)","v":0}]
[null,{"$f":"IF(Path=\"Performance Path\",\"N/A\",IF(Path=\"PHIUS\",\"PHIUS Interior Conditioned Floor Area (iCFA)\",IF(Path=\"PHI\",\"PHI Treated Floor Area (TFA)\",\"N/A\")))","v":"N/A"}]
[]
[null,"Type of Garage"]
[]
[null,"Project Name (Salesforce)"]
[null,"Application Number (Salesforce)"]
[null,"MF NCP PON Number"]
[null,"Performance Tier"]
[null,"Milestone","Please Select"]
[null,"Revision"]
[null,"Report Date"]
[null,"Space Heating Fuel Type","Please Select"]
[null,"DHW Fuel Type","Please Select"]
[]
[null,"Simulation Program & Version #"]
[null,"THERM software used?"]
[null,"PV Watts sofware used?"]
[null,{"$f":"IF(Path=\"PHIUS\",\"PHIUS+ Multifamily Calculator used?\",\"\")","v":""}]
[null,"Other Software Used"]
[null,"Weather File Location (City, ST)"]
[null,"Total Incremental Project Cost (optional)"]
[]
[null,"Incremental Project Costs - Please describe how the incremental project cost listed above was calculated. (Optional)"]
[]
[]
[]
[]
[]
[]
[null,"Revision Notes - Provide a narrative describing any additional changes made between this and the last revision not addressed by the responses to the review comments. "]
[]
[]
[]
[]
[]
[]
[null,"Partner Notes - Use this section to include any notes about the information entered above."]

{"sheet":"Model Inputs (PHI)","index":4,"n_rows":176,"n_cols":36,"rows_kept":176,"cut":false,"hidden":true,"merged":[[64,2,64,7],[153,1,154,3],[151,2,151,3],[169,1,173,3],[168,1,168,3],[162,1,166,3],[161,1,161,3],[155,1,159,3],[79,2,79,3],[96,2,96,7],[113,2,113,8],[147,4,147,5],[148,4,148,5],[3,1,3,5],[175,1,175,3],[176,1,180,3],[7,2,7,3],[36,5,36,9],[113,9,113,16],[133,3,133,4],[79,4,79,8],[96,8,96,14],[36,1,36,4],[48,9,48,15],[64,8,64,14],[7,4,7,7],[47,1,47,5],[63,1,63,5],[48,2,48,8]]}
[null,"Model Inputs Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes ","Yes "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","No"]
[null,"Proposed Design (Milestone #1)/ As-Built Design (Milestone #3) : In the blue cells, enter the proposed design/as-built information used in the model and/or that matches the proposed/as-built building. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"As-Built Design (Milestone #2): In the green cells, note if there have been any changes since the Milestone #1 submittal and list any changes to the design in the As-Built Design column. These columns only needs to be filled out at Milestone #2 and does not need to be adjusted at Milestone #3. \nIndicate whether the component was verified in the field and include the initials of the field inspector."]
[null,"Notes:  Read the notes, which are indicated by red corners, to assist in properly completing this tab."]
[null,"             If the building component does not exist in the building, enter \"N/A\" in the proposed/as-built columns."]
[]
[null,null,{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},null,"Milestone #2 (PHI Projects Only) "]
[null,"Envelope Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Location","Have there been any changes to the Proposed Design?","As-Built Design ","Verified in Field ","Verified by \n(PEC Initials)","Additional Comments"]
[null,"Above Grade Wall Construction"]
[null,"Above Grade Wall U-value"]
[null,"Floor Perimeter/Plank Edge Construction"]
[null,"Floor Perimeter/Plank Edge Psi-value"]
[null,"Penetrations through Continuous Insulation"]
[null,"Below Grade Wall Construction"]
[null,"Below Grade Wall U-value"]
[null,"Floor above Unconditioned Space Construction"]
[null,"Floor above Unconditioned Space U-value"]
[null,"Slab-on-Grade Construction (Unheated)"]
[null,"Slab-on Grade F-value (Unheated)"]
[null,"Slab-on-Grade Construction (Embedded Heat)"]
[null,"Slab-on Grade F-value (Embedded Heat)"]
[null,"Slab-Below-Grade Construction"]
[null,"Slab-Below Grade U-value"]
[null,"Roof Construction"]
[null,"Roof U-value"]
[null,"Window to Gross Wall Ratio"]
[null,"Fenestration Framing"]
[null,"Fenestration Glazing"]
[null,"Fenestration Assembly U-factor (average)"]
[null,"Fenestration Assembly SHGC"]
[null,"Shading Devices"]
[null,"Shading Reduction Factor"]
[null,"Door Description"]
[null,"Door U-value"]
[]
[null,{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},null,null,null,"Milestone #2 (PHI Projects Only) "]
[null,"Appliances and Process Loads","Quantity","Energy Star?","Energy Use (kWh/yr)","Have there been any changes to the Proposed Design?","Quantity","Energy Star?","Verified in Field ","PEC Initials ","Additional Comments"]
[null,"Refrigerator"]
[null,"Dishwasher"]
[null,"In-Unit Clothes Washer"]
[null,"Common Area Clothes Washer"]
[null,"Elevator"]
[null,"Please Select Type of Clothes Dryer"]
[null,"Please Select Type of Stove"]
[null,"<Other Appliance>"]
[]
[null,"Additional Heating Systems Note:  If there are more than 3 heating systems, copy and paste the table below and paste it below the  Partner Notes table.  For each additional heating system, there should be an additional set of three rows (Type, Efficiency, Capacity).  The words \"Primary,\" \"Secondary,\" etc. should be removed from the heating system type row. "]
[null,null,{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},null,null,null,null,null,null,"Milestone #2 (PHI Projects Only) "]
[null,"Heating Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Location","Manufacturer","Model No.","Energy Star?","Spaces Served?","Electric Resistance Heating?","Have there been any changes to the Proposed Design?","As-Built Design ","Manufacturer","Model No.","Energy Star?","Verified in Field ","PEC Initials ","Additional Comments"]
[null,"Primary Heating System Type"]
[null,"Primary Heating System Quantity"]
[null,"Primary Heating System Efficiency (AFUE)"]
[null,"Primary Heating System Capacity (kBtu)"]
[null,"Secondary Heating System Type"]
[null,"Secondary Heating System Quantity"]
[null,"Secondary Heating System Efficiency (AFUE)"]
[null,"Secondary Heating System Capacity (kBtu)"]
[null,"Tertiary Heating System Type"]
[null,"Tertiary Heating System Quantity"]
[null,"Tertiary Heating System Efficiency (AFUE)"]
[null,"Tertiary Heating System Capacity (kBtu)"]
[]
[null,"Additional Cooling Systems Note:  If there are more than 3 cooling systems, copy and paste the table below and paste it below the Partner Notes table.  For each additional cooling system,. there should be an additional set of three rows (Type, Efficiency, Capacity).  The words \"Primary,\" \"Secondary,\" etc. should be removed from the cooling system type row. "]
[null,null,{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},null,null,null,null,null,"Milestone #2 (PHI Projects Only) "]
[null,"Cooling Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Location","Manufacturer","Model No.","Energy Star?","Spaces Served?","Have there been any changes to the Proposed Design?","As-Built Design ","Manufacturer","Model No.","Energy Star?","Verified in Field ","PEC Initials ","Additional Comments"]
[null,"Primary Cooling System Type"]
[null,"Primary Cooling System Quantity"]
[null,"Primary Cooling System Efficiency (EER)"]
[null,"Primary Cooling System Capacity (tons)"]
[null,"Secondary Cooling System Type"]
[null,"Secondary Cooling System Quantity"]
[null,"Secondary Cooling System Efficiency (EER)"]
[null,"Secondary Cooling System Capacity (tons)"]
[null,"Tertiary Cooling System Type"]
[null,"Tertiary Cooling System Quantity"]
[null,"Tertiary Cooling System Efficiency (EER)"]
[null,"Tertiary Cooling System Capacity (tons)"]
[]
[null,null,{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},null,"Milestone #2 (PHI Projects Only) "]
[null,"Heating/Cooling Controls",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Quantity","Have there been any changes to the Proposed Design?","As-Built Design ","Quantity","Verified in Field ","PEC Initials ","Additional Comments"]
[null,"Heating System Supply Water Temp."]
[null,"Heating System Return Water Temp."]
[null,"HW Loop Setpoint Control"]
[null,"HW Loop Setpoint Control Temp."]
[null,"Cooling Controls"]
[null,"Heating Pump?"]
[null,"Heating Pump Efficacy"]
[null,"Heating Pump Motor Class"]
[null,"Heating Pump Capacity Control"]
[null,"Heating Pump Size (HP)"]
[null,"Heating Fan Control"]
[null,"Heating Fan kW/CFM"]
[null,"Cooling Fan Control"]
[null,"Cooling Fan kW/CFM"]
[]
[null,null,{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},null,null,null,null,null,"Milestone #2 (PHI Projects Only) "]
[null,"DHW Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Location","Manufacturer","Model No.","Energy Star /Water Sense?","Type?","Have there been any changes to the Proposed Design?","As-Built Design ","Manufacturer","Model No.","Energy Star /Water Sense?","Verified in Field ","PEC Initials ","Additional Comments"]
[null,"DHW System Type"]
[null,"DHW System Efficiency (Et)"]
[null,"DHW System Capacity (kBtu/h)"]
[null,"DHW Storage Tank Size (gal)"]
[null,"Quantity of Systems"]
[null,"DHW Circulating Pump?"]
[null,"Quantity of DHW Pumps"]
[null,"DHW Pump Motor Efficiency"]
[null,"DHW Pump Motor Class"]
[null,"DHW Pump Capacity Control"]
[null,"DHW Pump Size (HP)"]
[null,"Showerheads (gpm)"]
[null,"Kitchen Faucets (gpm)"]
[null,"Lavatory Faucets (gpm)"]
[]
[null,null,{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},null,null,null,null,null,null,"Milestone #2 (PHI Projects Only) "]
[null,"Ventilation Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Quantity","Manufacturer","Model No.","Energy Star?","Continuous or Intermittent","Fan Type","Have there been any changes to the Proposed Design?","As-Built Design ","Quantity","Manufacturer","Model No.","Energy Star?","Verified in Field ","PEC Initials ","Additional Comments"]
[null,"Apt - Bathroom Exhaust (CFM/bath)"]
[null,"Apt - Kitchen Exhaust (CFM/kitchen)"]
[null,"Apt - Total Exhaust Fan Power (W/CFM)"]
[null,"Apt - Total Dedicated OA Mechanical Supply (CFM)"]
[null,"Apt - Dedicated OA Supply Fan Power (W/CFM)"]
[null,"Corridor - Total Supply Ventilation (CFM)"]
[null,"Corridor - Total Supply Ventilation Fan Power (W/CFM)"]
[null,"Other Ventilation Fans (CFM)"]
[null,"Other Ventilation Fans (hp)"]
[null,"Other Ventilation Fans (efficiency)"]
[null,"Other Ventilation Fans Power (W/CFM)"]
[null,"Heat/Energy Recovery (Yes/No)"]
[null,"Heat/Energy Recovery Central or In-Unit"]
[null,"Heat/Energy Recovery Sensible Effectiveness (%)"]
[null,"Heat/Energy Recovery Fan Power (W/CFM)"]
[null,"Heat/Energy Recovery Supply Air Flow(CFM)"]
[null,"Heat/Energy Recovery Exhaust Air Flow (CFM)"]
[]
[null,null,{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},"Milestone #2 (PHI Projects Only) "]
[null,"Renewable and Distributed Generation Systems",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Have there been any changes to the Proposed Design?","As-Built Design "]
[null,"Solar Thermal System (Yes/No)"]
[null,"Solar Thermal System Size (Sq ft)"]
[null,"Solar Thermal System Contribution to DHW (kBTU/yr)"]
[null,"Solar Thermal System Contribution to Space Heating (kBTU/yr)"]
[null,"Solar PV System (Yes/No)"]
[null,"Solar PV System Size "]
[null,"Cogen System (Yes/No)"]
[null,"Cogen System Size "]
[null,"Other Renewable System (Yes/No)"]
[null,"Other Renewable System Description"]
[null,"Other Renewable System Size"]
[]
[null,"Passive House Modeling Results",{"$f":"IF($C$9=\"Proposed Design\",\"Milestone #1\",(IF($C$9=\"As-Built\",\"Milestone #3\",\"\")))","v":""},null,"Do you expect the modeling results to significantly change based on the changes to the design?"]
[null,"Primary Energy Demand excluding renewables and distributed generation and with all amenities",null,{"$f":"IF(Path=\"PHIUS\",\"kWh/person-yr\",\"kBtu/TFA-yr\")","v":"kBtu/TFA-yr"}]
[null,"Primary Energy Demand excluding renewables and distributed generation, removing  amenities",null,{"$f":"IF(Path=\"PHIUS\",\"kWh/person-yr\",\"kBtu/TFA-yr\")","v":"kBtu/TFA-yr"}]
[null,"Primary Energy Demand including renewables and distributed generation, removing amenities",null,{"$f":"IF(Path=\"PHIUS\",\"kWh/person-yr\",\"kBtu/TFA-yr\")","v":"kBtu/TFA-yr"}]
[null,"List amenities removed from above metrics, if applicable"]
[]
[null,"List any deviations from Passive House program defaults for operating assumptions, such as site-to-source conversion, plug loads and hours of operation."]
[]
[]
[]
[]
[]
[]
[]
[null,"List any calculations performed outside of the approved version of the software used. "]
[]
[]
[]
[]
[]
[]
[null,"Partner Notes - Use this section to include any notes about the information entered above."]
[]
[]
[]
[]
[]
[]
[null,"List any additional Milestone #2 updates not mentioned above. "]

{"sheet":"Model Inputs (PHIUS)","index":5,"n_rows":168,"n_cols":36,"rows_kept":168,"cut":false,"hidden":true,"merged":[[62,1,62,5],[46,1,46,5],[167,1,167,3],[168,1,172,3],[150,2,150,3],[152,1,153,3],[154,1,158,3],[160,1,160,3],[161,1,165,3]]}
[null,"Model Inputs Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes ","Yes "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","No"]
[null,"Proposed Design/As-Built In the blue cells, enter the proposed design/as-built information used in the model and/or that matches the proposed/as-built building. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"Notes:  Read the notes, which are indicated by red corners, to assist in properly completing this tab."]
[null,"             If the building component does not exist in the building, enter \"N/A\" in the proposed/as-built columns."]
[]
[]
[null,"Envelope Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Location"]
[null,"Above Grade Wall Construction"]
[null,"Above Grade Wall U-value"]
[null,"Floor Perimeter/Plank Edge Construction"]
[null,"Floor Perimeter/Plank Edge Psi-value"]
[null,"Penetrations through Continuous Insulation"]
[null,"Below Grade Wall Construction"]
[null,"Below Grade Wall U-value"]
[null,"Floor above Unconditioned Space Construction"]
[null,"Floor above Unconditioned Space U-value"]
[null,"Slab-on-Grade Construction (Unheated)"]
[null,"Slab-on Grade F-value (Unheated)"]
[null,"Slab-on-Grade Construction (Embedded Heat)"]
[null,"Slab-on Grade F-value (Embedded Heat)"]
[null,"Slab-Below-Grade Construction"]
[null,"Slab-Below Grade U-value"]
[null,"Roof Construction"]
[null,"Roof U-value"]
[null,"Window to Gross Wall Ratio"]
[null,"Fenestration Framing"]
[null,"Fenestration Glazing"]
[null,"Fenestration Assembly U-factor (average)"]
[null,"Fenestration Assembly SHGC"]
[null,"Shading Devices"]
[null,"Shading Reduction Factor"]
[null,"Door Description"]
[null,"Door U-value"]
[]
[]
[null,"Appliances and Process Loads","Quantity","Energy Star?","Energy Use (kWh/yr)"]
[null,"Refrigerator",null,"Please Select"]
[null,"Dishwasher",null,"Please Select"]
[null,"In-Unit Clothes Washer",null,"Please Select"]
[null,"Common Area Clothes Washer",null,"Please Select"]
[null,"Elevator"]
[null,"Please Select Type of Clothes Dryer"]
[null,"Please Select Type of Stove"]
[null,"<Other Appliance>",null,"Please Select"]
[]
[null,"Additional Heating Systems Note:  If there are more than 3 heating systems, copy and paste the table below and paste it below the  Partner Notes table.  For each additional heating system, there should be an additional set of three rows (Type, Efficiency, Capacity).  The words \"Primary,\" \"Secondary,\" etc. should be removed from the heating system type row. "]
[]
[null,"Heating Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Location","Manufacturer","Model No.","Energy Star?","Spaces Served?","Electric Resistance Heating?"]
[null,"Primary Heating System Type",null,null,null,null,"Please Select"]
[null,"Primary Heating System Quantity"]
[null,"Primary Heating System Efficiency (AFUE)"]
[null,"Primary Heating System Capacity (kBtu)"]
[null,"Secondary Heating System Type",null,null,null,null,"Please Select"]
[null,"Secondary Heating System Quantity"]
[null,"Secondary Heating System Efficiency (AFUE)"]
[null,"Secondary Heating System Capacity (kBtu)"]
[null,"Tertiary Heating System Type",null,null,null,null,"Please Select"]
[null,"Tertiary Heating System Quantity"]
[null,"Tertiary Heating System Efficiency (AFUE)"]
[null,"Tertiary Heating System Capacity (kBtu)"]
[]
[null,"Additional Cooling Systems Note:  If there are more than 3 cooling systems, copy and paste the table below and paste it below the Partner Notes table.  For each additional cooling system,. there should be an additional set of three rows (Type, Efficiency, Capacity).  The words \"Primary,\" \"Secondary,\" etc. should be removed from the cooling system type row. "]
[]
[null,"Cooling Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Location","Manufacturer","Model No.","Energy Star?","Spaces Served?"]
[null,"Primary Cooling System Type",null,null,null,null,"Please Select"]
[null,"Primary Cooling System Quantity"]
[null,"Primary Cooling System Efficiency (EER)"]
[null,"Primary Cooling System Capacity (tons)"]
[null,"Secondary Cooling System Type",null,null,null,null,"Please Select"]
[null,"Secondary Cooling System Quantity"]
[null,"Secondary Cooling System Efficiency (EER)"]
[null,"Secondary Cooling System Capacity (tons)"]
[null,"Tertiary Cooling System Type",null,null,null,null,"Please Select"]
[null,"Tertiary Cooling System Quantity"]
[null,"Tertiary Cooling System Efficiency (EER)"]
[null,"Tertiary Cooling System Capacity (tons)"]
[]
[]
[null,"Heating/Cooling Controls",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Quantity"]
[null,"Heating System Supply Water Temp."]
[null,"Heating System Return Water Temp."]
[null,"HW Loop Setpoint Control"]
[null,"HW Loop Setpoint Control Temp."]
[null,"Cooling Controls"]
[null,"Heating Pump?","Please select"]
[null,"Heating Pump Efficacy"]
[null,"Heating Pump Motor Class"]
[null,"Heating Pump Capacity Control"]
[null,"Heating Pump Size (HP)"]
[null,"Heating Fan Control"]
[null,"Heating Fan kW/CFM"]
[null,"Cooling Fan Control"]
[null,"Cooling Fan kW/CFM"]
[]
[]
[null,"DHW Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Location","Manufacturer","Model No.","Energy Star /Water Sense?","Type?"]
[null,"DHW System Type",null,null,null,null,"Please Select"]
[null,"DHW System Efficiency (Et)"]
[null,"DHW System Capacity (kBtu/h)"]
[null,"DHW Storage Tank Size (gal)"]
[null,"Quantity of Systems"]
[null,"DHW Circulating Pump?","Please select"]
[null,"Quantity of DHW Pumps"]
[null,"DHW Pump Motor Efficiency"]
[null,"DHW Pump Motor Class","Please Select"]
[null,"DHW Pump Capacity Control","Please Select"]
[null,"DHW Pump Size (HP)"]
[null,"Showerheads (gpm)",null,null,null,null,"Please Select"]
[null,"Kitchen Faucets (gpm)"]
[null,"Lavatory Faucets (gpm)",null,null,null,null,"Please Select"]
[]
[]
[null,"Ventilation Components",{"$f":"'Basic Info'!$C$28","v":"Please Select"},"Quantity","Manufacturer","Model No.","Energy Star?","Continuous or Intermittent","Fan Type"]
[null,"Apt - Bathroom Exhaust (CFM/bath)",null,null,null,null,"Please Select"]
[null,"Apt - Kitchen Exhaust (CFM/kitchen)",null,null,null,null,"Please Select"]
[null,"Apt - Total Exhaust Fan Power (W/CFM)"]
[null,"Apt - Total Dedicated OA Mechanical Supply (CFM)"]
[null,"Apt - Dedicated OA Supply Fan Power (W/CFM)"]
[null,"Corridor - Total Supply Ventilation (CFM)"]
[null,"Corridor - Total Supply Ventilation Fan Power (W/CFM)"]
[null,"Other Ventilation Fans (CFM)"]
[null,"Other Ventilation Fans (hp)"]
[null,"Other Ventilation Fans (efficiency)"]
[null,"Other Ventilation Fans Power (W/CFM)"]
[null,"Heat/Energy Recovery (Yes/No)"]
[null,"Heat/Energy Recovery Central or In-Unit"]
[null,"Heat/Energy Recovery Sensible Effectiveness (%)"]
[null,"Heat/Energy Recovery Fan Power (W/CFM)"]
[null,"Heat/Energy Recovery Supply Air Flow(CFM)"]
[null,"Heat/Energy Recovery Exhaust Air Flow (CFM)"]
[]
[]
[null,"Renewable and Distributed Generation Systems",{"$f":"'Basic Info'!$C$28","v":"Please Select"}]
[null,"Solar Thermal System (Yes/No)"]
[null,"Solar Thermal System Size (Sq ft)"]
[null,"Solar Thermal System Contribution to DHW (kBTU/yr)"]
[null,"Solar Thermal System Contribution to Space Heating (kBTU/yr)"]
[null,"Solar PV System (Yes/No)"]
[null,"Solar PV System Size "]
[null,"Cogen System (Yes/No)"]
[null,"Cogen System Size "]
[null,"Other Renewable System (Yes/No)"]
[null,"Other Renewable System Description"]
[null,"Other Renewable System Size"]
[]
[null,"Passive House Modeling Results",{"$f":"'Basic Info'!$C$28","v":"Please Select"}]
[null,"Primary Energy Demand excluding renewables and distributed generation and with all amenities",null,{"$f":"IF(Path=\"PHIUS\",\"kWh/person-yr\",\"kBtu/TFA-yr\")","v":"kBtu/TFA-yr"}]
[null,"Primary Energy Demand excluding renewables and distributed generation, removing  amenities",null,{"$f":"IF(Path=\"PHIUS\",\"kWh/person-yr\",\"kBtu/TFA-yr\")","v":"kBtu/TFA-yr"}]
[null,"Primary Energy Demand including renewables and distributed generation, removing amenities",null,{"$f":"IF(Path=\"PHIUS\",\"kWh/person-yr\",\"kBtu/TFA-yr\")","v":"kBtu/TFA-yr"}]
[null,"List amenities removed from above metrics, if applicable"]
[]
[null,"List any deviations from Passive House program defaults for operating assumptions, such as site-to-source conversion, plug loads and hours of operation."]
[]
[]
[]
[]
[]
[]
[]
[null,"List any calculations performed outside of the approved version of the software used. "]
[]
[]
[]
[]
[]
[]
[null,"Partner Notes - Use this section to include any notes about the information entered above."]

{"sheet":"Water Savings","index":6,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,1,5,4],[46,1,50,6],[45,1,45,6],[6,1,6,4],[7,1,7,4],[8,1,8,4]]}
[null,"Water Savings Calculator"]
[]
[null,"Instructions:"]
[null,"First, complete the Model Inputs tab."]
[null,"In the top table, enter data into blue cells."]
[null,"In the \"Baseline Fixture\" table, if there are urinals in the project, enter an estimated number of uses/day for urinals in the appropriate space. "]
[null,"In the \"Proposed Fixture\" table, enter the proposed toilet and urinal (if applicable) flow rates.  The proposed usage and pressures for the showerheads and faucets will autofill from the Model Inputs tab."]
[null,"When on-site collected graywater or rainwater is used for sewage conveyance, the total estimated annual graywater quantity may be subtracted from the total annual design case water usage. Estimated graywater quantity may not be greater than the total usage of fixtures that utilize it. For example, if graywater will be used only in flush toilets, the estimated graywater quantity cannot be greater than the total annual water used by the toilets.  Estimate graywater usage for each fixture type and enter the value in the appropriate cell."]
[null,"The remaining values will generate automatically.  Water usage savings and cost savings may be reported as indicated in the Water Savings section of the Simulation Guidelines. "]
[]
[null,"Compliance Pathway",{"$f":"Path","v":0}]
[null,"Average Price per Gallon of Water",3.0899999999999999E-3]
[null,"No. of Occupants"]
[null,"Dishwasher Savings (Gal/yr)",{"$f":"IF(C11=\"PHI\",(IF('Model Inputs (PHI)'!D40=\"Energy Star\",430*'Model Inputs (PHI)'!C40,0)),(IF('Model Inputs (PHIUS)'!D39=\"Energy Star\",430*'Model Inputs (PHIUS)'!C39,0)))","v":0}]
[null,"Clothes Washers Savings (Gal/yr)",{"$f":"IF(C11=\"PHI\",(IF('Model Inputs (PHI)'!D42=\"Energy Star\",'Model Inputs (PHI)'!C42*3170.8,0)+IF('Model Inputs (PHI)'!D41=\"Energy Star\",'Model Inputs (PHI)'!C41*1308.4,0)),(IF('Model Inputs (PHIUS)'!D41=\"Energy Star\",'Model Inputs (PHIUS)'!C41*3170.8,0)+IF('Model Inputs (PHIUS)'!D40=\"Energy Star\",'Model Inputs (PHIUS)'!C40*1308.4,0)))","v":0}]
[null,"Water Usage, based on occupancy"]
[null,"Does this project have urinals?"]
[null,"Does this project use graywater?"]
[]
[null,"Baseline Fixture","(Uses/Day)","Baseline Flow Rates (GPF/GPM)","Baseline Usage (Gallons/year)"]
[null,"Toilets",null,1.6,{"$f":"IF(C22=\"<Enter '0' if no urinals>\",D21*($C$13*5)*365,D21*($C$13*5-C22)*365)","v":0}]
[null,"Urinals",null,1,{"$f":"IF(C22=\"<Enter '0' if no urinals>\",0,C22*D22*365)","v":0}]
[null,"Showerheads",null,2.5,{"$f":"$C$13*D23*1*(IF('Water Savings'!C16=\"Low\",150,IF('Water Savings'!C16=\"Medium\",300,IF('Water Savings'!C16=\"High\",600))))*365/60","v":0}]
[null,"Bathroom Faucets",null,2.5,{"$f":"$C$13*D24*5*(IF('Water Savings'!C16=\"Low\",8,IF('Water Savings'!C16=\"Medium\",15,IF('Water Savings'!C16=\"High\",30))))*365/60","v":0}]
[null,"Kitchen Faucets",null,2.5,{"$f":"$C$13*D25*4*(IF('Water Savings'!C16=\"Low\",30,IF('Water Savings'!C16=\"Medium\",60,IF('Water Savings'!C16=\"High\",80))))*365/60","v":0}]
[null,"Total",null,null,{"$f":"SUM(E21:E25)","v":0}]
[]
[null,"Proposed Fixture","Proposed Fixture Flow Rate (GPM/GPF)","Graywater Usage (Gallons/year)","Proposed Usage (Gallons/year)"]
[null,"Toilets",null,null,{"$f":"IF(C22=\"<Enter '0' if no urinals>\",(C29*($C$13*5)*365)-D29,(C29*($C$13*5-C22)*365)-D29)","v":0}]
[null,"Urinals",null,null,{"$f":"IF(C22=\"<Enter '0' if no urinals>\",0,(C30*C22*365)-D30)","v":0}]
[null,"Showerheads",{"$f":"IF(C11=\"PHI\",'Model Inputs (PHI)'!C110, 'Model Inputs (PHIUS)'!C109)","v":0},null,{"$f":"$C$13*C31*1*(IF('Water Savings'!C16=\"Low\",150,IF('Water Savings'!C16=\"Medium\",300,IF('Water Savings'!C16=\"High\",600))))*365/60-D31","v":0}]
[null,"Bathroom Faucets",{"$f":"IF(C11=\"PHI\",'Model Inputs (PHI)'!C112, 'Model Inputs (PHIUS)'!C111)","v":0},null,{"$f":"$C$13*C32*5*(IF('Water Savings'!C16=\"Low\",8,IF('Water Savings'!C16=\"Medium\",15,IF('Water Savings'!C16=\"High\",30))))*365/60-D32","v":0}]
[null,"Kitchen Faucets",{"$f":"IF(C11=\"PHI\",'Model Inputs (PHI)'!C111, 'Model Inputs (PHIUS)'!C110)","v":0},null,{"$f":"$C$13*C33*4*(IF('Water Savings'!C16=\"Low\",30,IF('Water Savings'!C16=\"Medium\",60,IF('Water Savings'!C16=\"High\",80))))*365/60-D33","v":0}]
[null,"Total",null,null,{"$f":"SUM(E29:E33)","v":0}]
[]
[null,"Savings by Fixture Type","Water Usage Savings (Gallons/year)","Cost Savings ($/year)"]
[null,"Toilets",{"$f":"E21-E29","v":0},{"$f":"C37*$C$12","v":0}]
[null,"Urinals",{"$f":"E22-E30","v":0},0]
[null,"Showerheads",{"$f":"E23-E31","v":0},0]
[null,"Bathroom Faucets",{"$f":"E24-E32","v":0},0]
[null,"Kitchen Faucets",{"$f":"E25-E33","v":0},0]
[null,"Total savings (fixtures only)",{"$f":"SUM(C37:C41)","v":0},0]
[null,"Total Savings (fixtures + appliances)",{"$f":"SUM(C37:C41,C14:C15)","v":0},0]
[]
[]
[null,"Partner Notes - Use this section to include any notes about the information entered above."]

{"sheet":"Energy Savings","index":7,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,9,8,10],[5,6,5,10]]}
[null,"Energy Savings Calculator"]
[null,"This tab is for NYSERDA reporting information only.  Do not alter or delete."]
[]
[]
[]
[null,"Primary Energy Demand excluding renewables and distributed generation and with all amenities",{"$f":"IF(Path=\"PHI\",'Model Inputs (PHI)'!C149,'Model Inputs (PHIUS)'!C148)","v":0},{"$f":"IF(Path=\"PHIUS\",\"kWh/person-yr\",\"kBtu/TFA-yr\")","v":"kBtu/TFA-yr"},null,null,"HIDE"]
[null,"Source Savings, in reference to ASHRAE 2013",{"$f":"IF('Model Inputs (PHIUS)'!C148=\"\",\"\",IF(Path=\"PHIUS\",-0.00009*C6+0.8358,-0.0113*C6+0.7427))","v":""}]
[null,"Number of units",{"$f":"IF('Basic Info'!C13=0,\"\",'Basic Info'!C13)","v":""}]
[null,null,null,null,null,null,null,null,null,"SITE SAVINGS TO 2013 PER UNIT PER % SAVED"]
[null,null,"Electric Savings (kWh/yr)","Gas Savings (MMBtu/yr)",null,null,null,"DHW","Heating","Elec (kWh)","Gas (MMBtu)"]
[null,"Annual site energy savings",{"$f":"IF(J14=\"\",\"\",J14*C8*C7*100)","v":""},{"$f":"IF(K14=\"\",\"\",K14*C8*C7*100)","v":""},null,null,null,"Gas","Gas",97.398436708860771,0.3836561181434599]
[null,"Annual source energy savings",{"$f":"IF(C11=\"\",\"\",C11*2.55)","v":""},{"$f":"IF(D11=\"\",\"\",D11*1.05)","v":""},null,null,null,"Gas","Electric",105.22282670042193,0.10988842006563525]
[null,null,null,null,null,null,null,"Electric","Electric",124.06771454166088,0]
[null,null,null,null,null,null,"For this project",{"$f":"IF('Basic Info'!C32=\"natural gas\",\"Gas\",IF('Basic Info'!C32=\"electric\",\"Electric\",\"\"))","v":""},{"$f":"IF('Basic Info'!C31=\"natural gas\",\"Gas\",IF('Basic Info'!C31=\"electric\",\"Electric\",\"\"))","v":""},{"$f":"IF(AND($H$14=\"Gas\",$I$14=\"Gas\"),J11,IF(AND($H$14=\"Gas\",$I$14=\"Electric\"),J12,IF(AND($H$14=\"Electric\",$I$14=\"Electric\"),J13,\"\")))","v":""},{"$f":"IF(AND($H$14=\"Gas\",$I$14=\"Gas\"),K11,IF(AND($H$14=\"Gas\",$I$14=\"Electric\"),K12,IF(AND($H$14=\"Electric\",$I$14=\"Electric\"),K13,\"\")))","v":""}]