Spreadsheet: 28edd9bb-ba73-4940-8e20-af1b7e7cbb1e
Sheet: 2. Indoor Water Demand

NON-POTABLE WATER CALCULATOR
Step 2 of 7: Calculate Indoor Water Demand (Indoor Fixtures and Fittings)
 | Project Name: |  |  |  |  | LEGEND:
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Linked from User Input
 | Instructions: |  |  |  |  | Default Value
 | Annual indoor water demand is calculated based on water demand from domestic fixtures and fittings, using assumed usage rates based on the building uses and occupancy profiles entered in Step 1.  User input is required in Section D at the end of this page. |  |  |  |  | Autogenerated Value
 | A. COMMERCIAL WATER DEMAND (No user input needed - auto-calculated from Step 1 inputs)
 | Total Water Demand (gpd) = (Flow Rate x Duration x Ave Daily Use x No. of FTEs) + (Flow Rate x Duration x Ave Daily Use (Transient FTE) x No. of Transient FTEs)
 | Fixture Type | Flow Rate | Unit | Duration(7) | Unit | Ave Daily Use (7) | No. of FTEs | Ave Daily Use (Transient) (6)(7) | No. of Transient FTEs | Total Water Demand (gpd) | Allowable End Use for Non-Potable? |  | Total Potable Demand (gpd) | Total Potential Non-Potable Demand (gpd)
 | Showerhead (1)(2)(7)(8) | 2 | gpm | 5 | min | 0.65 |  | 0 |  |  | No
 | [NAME] (2) | 0.4 | gpm | 0.25 | min | 3 |  | 0.5 |  |  | No
 | Urinals (2)(3) | 0.5 | gpf | 1 | flush | 1.74 |  | 0.4 |  |  | Yes
 | Toilet (Water Closet) (2)(3) | 1.28 | gpf | 1 | flush | 1.74 |  | 0.5 |  |  | Yes
 | [NAME] (2)(4) | 1.8 | gpm |  | min | 1 |  | 0 |  |  | No
 | Low [NAME] (5) | 82.51 | gal/emp/day | 1 | - | 1 |  | 0 |  |  | No
 | TOTAL
 | Notes: |  |  |  |  |  |  |  | Key
 | (1) Applied to 0.5% of FTEs in Hotel and General Office uses. |  |  |  |  |  |  |  | gpm: gallons per minute
 | (2) Flow rate based on maximum flow rate prescribed by 2011 SF Green Building Requirements for the Prescriptive Approach (Table 13C.5.303.2.3). |  |  |  |  |  |  |  | gpf: gallons per flush
 | (3) Durations and Ave Daily Use (FTE) from 2011 SFPUC Water Demand Conservation Model (Retail Model for Non-Residential). |  |  |  |  |  |  |  | gal/emp/day: gallons per employee per day
 | (4) Applied to General Office, [NAME], Medical Office, R&D or Laboratory, and Educational Facilities.
 | (5) From 2011 SFPUC Water Demand Conservation Model (Retail Model for Non-Residential), Estimated Usage for Nonresidential Low-Flow Sprayers in Restaurants.
 | (6) From [NAME] 2009 Water Use Reduction Additional Guidance (Revision 3). Updated July 14, 2011. Table 1. Non-residential Default Fixture Usage Rates
 | (7) Hotel property developers may need to manually increase the default values of Duration and Average Daily Use for showerheads to account for transients (hotel guests).
 | A future version of the NP Calculator will enable for separation of hotel information.
 | (8) Ave. Daily Use value from  2011 SFPUC Water Demand Conservation Model.
 | B. MULTI-FAMILY RESIDENTIAL WATER DEMAND  (No user input needed - auto-calculated from Step 1 inputs)
 | Total Water Demand (gpd) = Flow Rate x Duration x Ave Daily Use  x No. of Occupants
 | Fixture Type (Daily Use) | Flow Rate | Unit | Duration (4) | Unit | Ave Daily Use (4) | No. of occupants | Total Water Demand (gpd) | Allowable End Use for Non-Potable? |  |  |  | Total Potable Demand (gpd) | Total Potential Non-Potable Demand (gpd)
 | Showerhead (1) | 2 | gpm | 8.2 | min | 0.65 |  |  | No
 | Bathroom Faucet (2) | 1.3 | gpm | 1.5 | min | 1 |  |  | No
 | Bath (2) | 25 | gal/bath | 1 | bath | 0.1 |  |  | No
 | Washing Machine (3) | 36.9 | gal/cycle | 1 |  | 0.31 |  |  | No
 | Toilet (Water Closet) (1) | 1.28 | gpf | 1 | flush | 4.75 |  |  | Yes
 | [NAME] (1) | 1.8 | gpm | 7.82 | min | 1 |  |  | No
 | Dishwasher (3) | 11.15 | gal/cycle | 1 |  | 0.04 |  |  | No
 | TOTAL
 | Notes: |  |  |  |  |  |  |  | Key
 | (1) Flow rate based on maximum flow rate prescribed by 2011 SF Green Building Requirements (Table 13C.5.303.2.3). |  |  |  |  |  |  |  | gpm: gallons per minute
 | (2) Flow rate from SFPUC 2011 Urban Water Management Plan (UWMP) Retail Demand  Model for New Multi-Family Residential Water Use. |  |  |  |  |  |  |  | gal/bath: gallons per bath
 | (3) Flow rate based on 2010 rate used in the 2010 UWMP Conservation Model. |  |  |  |  |  |  |  | gal/cycle: gallons per washing cycle
 | (4) Flow rate from SFPUC 2010 Urban Water Management Plan (UWMP) Retail Demand  Model for New Multi-Family Residential Water Use. |  |  |  |  |  |  |  | gpf: gallons per flush
 | Ave Daily Use for faucets are represented by total average usage per person per day (min/person/day)
 | C. HVAC/COOLING DEMAND (No user input needed, average cooling demand is auto-calculated from building gross square footage area provided in Step 1)
 | Building Gross Square Footage from Step 1: |  | GSF
 | Month | City Temperature (°F)(1) | Estimated Use (gpd/ft2)(2) | Ave. Daily Demand (gpd) | Monthly Demand (gal/mth)
 | January | 51.04 | 0.014135955736 |  |  |  | Key
 | February | 53.87 | 0.01659308455799999 |  |  |  | gpd/ft2: gallons per day per square foot
 | March | 55.21 | 0.017756530714 |  |  |  | GSF: [NAME]
 | April | 56.25 | 0.01865950385 |  |  |  | [NAME]
 | May | 57.53 | 0.019770855402 |  |  |  | gal/mth: gallons per month
 | June | 59.49 | 0.021472612466 |  |  |  | [NAME]
 | July | 59.77 | 0.021715720618
 | August | 60.61 | 0.022445045074
 | September | 62.68 | 0.024242308912
 | October | 61.78 | 0.023460889852
 | November | 57.38 | 0.019640618892
 | December | 52.03 | 0.014995516702
 | Average
 | Notes:
 | (1) Forecasted temperature for 2010-2035 based on historical average. Source: Potable Offset Investigation NPI Data Workbook, 2011.
 | (2) Estimated cooling demand for 2010-2035 based on forecasted temperature. Source: Potable Offset Investigation NPI Data Workbook, 2011.
 | Annual [NAME] (gpy):
 | D. OTHER INDOOR DEMANDS THAT CAN BE MET WITH NON-POTABLE SUPPLIES
 | User Input Instructions:
 | Please include other indoor demands in your building if applicable.
 | Indoor Decorative Water Feature:
 | E.g. indoor fountains with no contact | 100 | gpd | <--Enter the total daily demand in gallons per day for all indoor decorative water features in the building
 |  | 250 | no. of days | <--Enter the number of days in a year the decorative water features will be operational
 |  |  | [NAME]
 | Commercial Laundry:
 | I.e. commercial laundry facilities that are operated by designated staff and are not available for general public use | 17 | gal/load | <--Typical water use is 17 gals/wash load
 |  | 2 | loads/day | <--Enter estimated number of loads per day
 |  |  | gpd
 |  | 52 | no. of days | <--Enter estimated number of days in a year that laundry facilties will be used
 |  |  | [NAME]
 | Other Non-Potable Demand:
 | <Please specify here> | 0 | gpd | <--Enter estimated daily demand associated with use
 |  | 0 | no. of days | <--Enter the number of days the demand will be applicable within a year
 |  |  | [NAME]
 | >>> Please proceed on to Step 3: Calculate Indoor Non-Potable Supply