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

▶
agenda
SMART_READER_LITE
LIVE PREVIEW

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

Jan 17, 2023 217 likes •724 views

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

slide-1
SLIDE 1

TWDB

MUNICIPAL WATER CONSERVATION PLANNING TOOL

North Texas Municipal Water District 28 January 2019

slide-2
SLIDE 2

Agenda

  • Introduction
  • Tool Basics
  • Quick Start
  • Advanced Setup
  • Regional Applications
  • Wholesale Planning
  • Regional Planning
  • Next Steps
slide-3
SLIDE 3

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
slide-4
SLIDE 4

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

slide-5
SLIDE 5

User Guide

slide-6
SLIDE 6

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)
slide-7
SLIDE 7

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)
slide-8
SLIDE 8

Start Screen

slide-9
SLIDE 9
  • 1. Baseline Demand Projections
slide-10
SLIDE 10
  • 2. Conservation Measures
slide-11
SLIDE 11
  • 3. Conservation Plan
slide-12
SLIDE 12
  • 4. Plan Demand Projections
slide-13
SLIDE 13

Single-Year Savings Calculator

slide-14
SLIDE 14

Plumbing Fixture Inventory

slide-15
SLIDE 15

Data Tables

  • Pre-Defined Measures
  • Passive Savings
  • TWDB Data
  • List and Settings
  • Scenarios
slide-16
SLIDE 16

Quick Start

1. 2. 3.

slide-17
SLIDE 17

Quick Start

1. 2.

slide-18
SLIDE 18

Quick Start

slide-19
SLIDE 19

Quick Start

slide-20
SLIDE 20

Quick Start

slide-21
SLIDE 21

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
slide-22
SLIDE 22

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
slide-23
SLIDE 23

Advanced Setup – Customizing Inputs

1. 2. 3. 1.

slide-24
SLIDE 24

Advanced Setup – Customizing Inputs

slide-25
SLIDE 25

Advanced Setup – Customizing Inputs

slide-26
SLIDE 26

Advanced Setup - Scenarios

2. 1. 3. 4.

slide-27
SLIDE 27

Advanced Setup - Scenarios

slide-28
SLIDE 28

Advanced Setup - Scenarios

slide-29
SLIDE 29

Advanced Setup – Customizing BMPs

slide-30
SLIDE 30

Advanced Setup – Customizing BMPs

slide-31
SLIDE 31

Advanced Setup – Customizing BMPs

slide-32
SLIDE 32

Advanced Setup – Customizing BMPs

slide-33
SLIDE 33

Advanced Setup – Customizing BMPs

slide-34
SLIDE 34

Advanced Setup – Customizing BMPs

slide-35
SLIDE 35

Advanced Setup – Customizing BMPs

slide-36
SLIDE 36

Advanced Setup – Customizing BMPs

slide-37
SLIDE 37

Advanced Setup – Customizing BMPs

slide-38
SLIDE 38

Advanced Setup – Troubleshooting

slide-39
SLIDE 39

Advanced Setup – Customizing Fixture Levels

slide-40
SLIDE 40

Regional Applications

  • Wholesale Water Provider Example
  • Top down or bottom up approach
  • Regional Planning
slide-41
SLIDE 41

Wholesale Provider – Top Down Approach

slide-42
SLIDE 42

Wholesale Provider – Top Down Approach

slide-43
SLIDE 43

Wholesale Provider – Top Down Approach

slide-44
SLIDE 44

Wholesale Provider – Top Down Approach

slide-45
SLIDE 45

Wholesale Provider – Bottom Up Approach

slide-46
SLIDE 46

Wholesale Provider – Bottom Up Approach

slide-47
SLIDE 47

Wholesale Provider – Bottom Up Approach

slide-48
SLIDE 48

Wholesale Provider – Bottom Up Approach

slide-49
SLIDE 49

MWCT Applications

  • 2019 WCP Updates
  • Annual Water Conservation Reports
  • Program Analysis
  • Regional Water Planning
slide-50
SLIDE 50

Jeremy Rice

jeremy.rice@freese.com / 817.735.7397