Spreadsheet: 2128d001-83e4-4dcb-88d0-1a337a0ecf0c
Sheet: Readme

Introduction to the Non-Potable Water Calculator
 | PURPOSE OF THE CALCULATOR TOOL
 | The SFPUC has developed this tool to estimate a building's onsite:
 | A) Non-potable water demands
 | B) Onsite supplies that can be generated through collection and reuse of rainwater, stormwater, graywater, blackwater, and/or foundation drainage
 | This calculator is designed primarily for the following new building types which make up the majority of projected future development in the San Francisco Planning Department's Pipeline Report: ● Multi-family residential ● Mixed Use (e.g. residential uses and multiple commercial uses are present within a building) ● Typical urban commercial uses (e.g. office, retail, services, restaurants and hotels)
 | This calculator may also be applied in other building uses not listed above; however buildings with unique water use profiles (e.g. significantly high water demands or specific water quality requirements for end uses) should conduct an independent water accounting analysis.
 | Note that this calculator is meant for water budget accounting purposes only and should not be used as a design or optimization tool.
 | The NP Calculator is intended to help generate initial estimates. The [NAME] should verify the assumptions provided when generating specific
 | project demands and update assumptions as appropriate.
 | The NP Calculator will be updated as more user feedback is collected.  Users are encouraged to make adjustments to the calculator as appropriate to more accurately reflect onsite demands and supplies for building types that are not shown in the calculator or for building types that are shown but do not represent expected building demands and supplies. For example, hotel developments can be added to the calculator by using the "Commercial Use Breakdown" table in sheet "1. Building Information". Hotel demands from FTEs and Transient FTEs can be estimated by entering Space Type, Description, Gross Area, and GSF per Occupant in one of the rows reserved for additional building types (Rows 75-77). Hotel guest demands can be estimated, using the same sheet, by adjusting the "Residential" inputs for Persons per Household Unit and # of Residents (Rows 87 and 89). Industry standard documents, such as U.S. Green Building Council's "Water Use Reduction Additional Guidance" (July 6, 2012), can be used to calibrate inputs to achieve the estimated demands and supplies.
 | HOW TO USE THE CALCULATOR TOOL
 | 1. Use the tabs at the bottom of the pages to navigate from step to step.
 | 2. DO NOT SKIP STEPS.
 | 3. Worksheets requiring user input have instructions highlighted in red at the top of each page and before each section.
 | 4. Results of the project analysis are shown on Steps 6 and 7.
 | 5. Backup data used in the calculations are located after the "Calculator Backup" tab for reference.
 | CALCULATOR LAYOUT
 | This calculator is laid out in seven (8) worksheets. The worksheets are summarized below:
 | Worksheet No. | Description
 | Step 1 | Enter Project Information
 | Step 2 | Calculate Indoor Water Demand (Indoor Fixtures and Fittings)
 | Step 3 | Calculate Indoor Non-Potable Supply (Graywater, Blackwater, Foundation Drainage)
 | Step 4 | Calculate Outdoor Water Demand (Landscape Irrigation, Outdoor Water Features)
 | Step 5 | Calculate Outdoor Water Supply (Rainwater and Stormwater Harvesting)
 | Step 6 | Summary of Building Potential
 | Step 7 | Define Project Non-Potable Demands and Supplies
 | Step 8 | Printable Summary of Building Information, Site Demands, and Site Supplies
 | CALCULATOR USE ASSUMPTIONS
 | 1. It is assumed that the main users of this calculator will be designated project team members (e.g. project engineer or manager) and SFPUC review staff with basic knowledge of Microsoft Excel.
 | 2. The level of detail required for building information inputs into the calculator assumes that the project is at a schematic or design development phase.
 | 3. The estimated level of effort for a user to enter information in this calculator is approximately 4 to 6 hours, depending on the complexity of the project. Note that this estimate does not include the time taken to consolidate relevant building information, or conduct external analysis of other specified demands or supplies not included in the default calculations provided in the calculator.
 | >>> Click on the next tab "1. Building Information" to begin