Spreadsheet: 28edd9bb-ba73-4940-8e20-af1b7e7cbb1e
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.  A future version of the tool will allow for the inclusion of  hotel guest demands
 | along with the typical commercial demand assumptions and calculations.
 | 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