Agenda Introduction Tool Basics Quick Start Advanced Setup - PowerPoint PPT Presentation

TWDB M UNICIPAL W ATER C ONSERVATION P LANNING T OOL North Texas Municipal Water District 28 January 2019

Agenda • Introduction • Tool Basics • Quick Start • Advanced Setup • Regional Applications • Wholesale Planning • Regional Planning • Next Steps

Introduction • Alliance for Water Efficiency (AWE) has an existing Water Conservation Tracking Tool for members http://www.allianceforwaterefficiency.org/Tracking-Tool.aspx • Develop a municipal water conservation planning for • 2019 Water Conservation Plan Updates • 2021 Regional Water Plans • 2022 State Water Plan • Pre-Loaded 400+ Utilities • Texas-specific measures

Introduction • Texas Water Development Board Funded Project http://www.twdb.texas.gov/conservation/muni cipal/plans/index.asp • Microsoft Excel Based tool • Macros must be enabled • Worksheets are protected but not password protected

User Guide

Terms and Definitions • Baseline Demand Projection (includes plumbing code savings) • Conservation Demand Projection (includes plumbing code and active program savings) • Passive Water Savings (plumbing code savings) • Active Water Savings (from utility conservation measures) • Pre-Defined Conservation Measure (from tool library) • User-Defined Conservation Measure (measure defined by the user) • Scenario (saved combination of measures) • ICI (Industrial, Commercial and Institutional water users)

Tool Basics • Inputs • Population • Connections (single family, multi family, ICI) • Baseline Demand • Water Loss • Pre-Defined Conservation Measures (level of activity) • User Defined Conservation Measures (level of activity, cost, savings) • What outputs • Savings Unit Cost by measure • Savings volume by measure • 5-year and 10-year and decadal savings volume estimates • 5-year and 10-year and decadal GPCD estimates • Graphs (Total Production Volume, Total GPCD, Residential GPCD)

Start Screen

1. Baseline Demand Projections

2. Conservation Measures

3. Conservation Plan

4. Plan Demand Projections

Single-Year Savings Calculator

Plumbing Fixture Inventory

Data Tables • Pre-Defined Measures • Passive Savings • TWDB Data • List and Settings • Scenarios

Quick Start 3. 2. 1.

Quick Start 2. 1.

Quick Start

Quick Start

Quick Start

Quick Start • If your entity is listed it could be this simple… • If all of your conservation programs are listed as pre-defined measures it could be this simple… • …But it is unlikely

Advanced Setup • Customizing input data • Scenarios • User-Defined Measures • Editing a Pre-Defined Measure • Twice per Week • Classroom Education • Troubleshooting • Customizing plumbing level fixture levels

Advanced Setup – Customizing Inputs 3. 2. 1. 1.

Advanced Setup – Customizing Inputs

Advanced Setup – Customizing Inputs

Advanced Setup - Scenarios 2. 3. 4. 1.

Advanced Setup - Scenarios

Advanced Setup - Scenarios

Advanced Setup – Customizing BMPs

Advanced Setup – Customizing BMPs

Advanced Setup – Customizing BMPs

Advanced Setup – Customizing BMPs

Advanced Setup – Customizing BMPs

Advanced Setup – Customizing BMPs

Advanced Setup – Customizing BMPs

Advanced Setup – Customizing BMPs

Advanced Setup – Customizing BMPs

Advanced Setup – Troubleshooting

Advanced Setup – Customizing Fixture Levels

Regional Applications • Wholesale Water Provider Example • Top down or bottom up approach • Regional Planning

Wholesale Provider – Top Down Approach

Wholesale Provider – Top Down Approach

Wholesale Provider – Top Down Approach

Wholesale Provider – Top Down Approach

Wholesale Provider – Bottom Up Approach

Wholesale Provider – Bottom Up Approach

Wholesale Provider – Bottom Up Approach

Wholesale Provider – Bottom Up Approach

MWCT Applications • 2019 WCP Updates • Annual Water Conservation Reports • Program Analysis • Regional Water Planning

Jeremy Rice jeremy.rice@freese.com / 817.735.7397