Home
Return Button
Home

WATER Power Tools™ v1.0 for Microsoft Excel®


Resource MANAGEMENT Pages

This section of WATER Power Tools™ contains tools and programs to help you manage the various assets that make up your water system. The Resource Management tools have been selected and designed to help you better understand, control, and predict the resources and capacities within your system. You will also gain new insight into current and future demands as WPT™ guides you through a systematic analysis of every element of your municipality. A sample of some of the questions you will be able to answer include -

How many water sources do you have? How are they maintained? What are their capacities? What would be the impact on your system if one of your sources was compromised?

What are the current demands on your system? How will new demands impact your system? How can you estimate what future demands may be?

WATER Power Tools™ will help you answer these questions and many more as you input your system information into the WPT™ Resource Management Section. A summary listing of the individual pages in this section follows this paragraph. Where there are sections with similar pages, only one representative example may be shown.


A1.0 System Capacity Assessment
 
A1.1
  Assessment Report
 
A1.2
  Capacity Assessment Issues
 
A1.3
  Information Needs Report
 
A1.4
  License
A2.0 Basic Standards for Your State
A3.0 State I rrigation Zone Map
A4.0 Water Mechanics
 
A4.1
  Definitions Used in Water Mechanics
 
A4.2
  Water Mechanics Executive Summary
 
A4.3
  Level of Service Standard and ERC Assumptions (Water Mechanics)
 
A4.4
  Current Water Source Production Data
 
  A4.4.1 Current Water Source Production Chart
 
A4.5
  Current Water Consumption Data
 
  A4.5.1 Current Water Consumption by AREA Chart
 
  A4.5.2 Current Water Consumption by TYPE Chart
A5.0 Fixture-Based Demand Calculations and Meter Sizing
 
A5.1
  Water Fixture Flow Chart
 
A5.2
  Water Meter Standards Table
 
A5.3
  Report
 

A5.4

  Service Information & Demand Worksheet
 
A5.5
  License
A6.0 System Source and Facility Sizing
A7.0 Non-Typical User Conversions to Peak Day Demand and ERC Units
A8.0 O & M Management System
 

A8.0d

  Description
  A8.1   Operation Management System
  A8.2   Emergency Response Plan
  A8.3   Scheduled Maintenance Management System
  A8.4   Operations (OPS) and Maintenance Log
  A8.5   Work Order - Normal
  A8.6   Work Order - Emergency
 
A8.7
  License Agreement
A9.0 Emergency Resource Contact List
  A9.1   Master Directory
      A9.1 List 1
      A9.2 List 2, etc.
      License Agreement
A10.0 Water System Audit
A11.0 Supply and Demand Planning Analysis
 
A11.1
  Supply and Demand Analysis
 
A11.2
  Supploy and Demand Graph
 
A11.3
  Definitions
 
A11.4
  License Agreement
A12.0 System or User Profile and Demand Curve
A13.0 Annual Water Source Production Logs and Reports
  A13.1   [Well #1] YrX Supply and Operations Daily Log
      A13.1.1 Chart of Daily Supply and Performance
      A13.1.2 Chart of Weekly Supply and Performance
A14.0 10 Year Source Production Logs and Reports
  A14.1   Source Summary Production Tables
      A14.1.1 Chart of Total Source Production by Month
      A14.1.2 Total Source Production Chart
      A14.1.3 Cumulative Source Production Chart
  A14.2   Monthly Water Source Supply Log for [source #1]
      A14.2.1 Source Water Monthly Average Availability & Utilization
A15.0 Employee Management Forms
  A15.1   Hourly Employee Time Sheets
  A15.2   Employee Reimbursable Expense Sheets
  A15.3   Planned Performance - Work Planning and Specification
  A15.4   Planned Performance - Review, Redirection, & Development
 
A15.5
  License Agreement
A16.0 Employee Attendence
  A16.T   Attendance Log Template
  A16.1   Employee:_________________
A17.0 Water Quality Reporting System
 
A17.1
  Water Quality Definitions
 
A17.2
  Water Quality Summary Sheet
 
A17.3
  Sampling Plan - Locations and Procedures
 
A17.4
  Sampling Matrix
 
A17.5
  Water Analysis Summary (CCR Style)
 
A17.6
  Consumer Confidence Report - CCR
 
A17.7
  Microbiological Analysis Ledger
 
A17.8
  Nitrate Analysis Ledger
 
A17.9
  Turbidity Analysis Ledger
 
A17.10
  Lead and Copper Analysis Ledger
 
A17.11
  Inorganic Analysis Ledger
 
A17.12
  Secondary and Unregulated Analysis Ledger
 
A17.13
  Radiological Analysis Ledger
 
A17.14
  Volatile Organics (VOC) Analysis Ledger
 
A17.15
  Synthetic Organics Analysis Ledger
 
A17.16
  Chlorine Products Analysis Ledger
 
A17.17
  Total Organic Carbon (TOC) Analysis Ledger
 
A17.18
  Local Parameters Option Analysis Ledger
 
A17.19
  License Agreement
A18.0 Developing a Dynamic Strategic Plan
 
A18.1
  Process Page
 
A18.2
  Principle List
 
A18.3
  Principle Ranking
 
A18.4
  Issues List
 
A18.5
  Issues Ranking
 
A18.6
  Goals List
 
A18.7
  Goals Ranking
 
A18.8
  Strategies List
 
A18.9
  Strategies Ranking
 
A18.10
  Conclusion Page
 
A18.11
  License Agreement
A19.0 Detailed Water System Inventory
  A19.1   Water Rights or Contracts(Paper Source)
  A19.2   Water Source Infrastructure (Wet Source)
  A19.3   Distribution and Transmission Pipelines
  A19.4   Service Laterals and Meters
  A19.5   Valves
  A19.6   Pressure and Flow Regulating Valves
  A19.7   Air or Vacuum Valves
  A19.8   Fire Hydrants
  A19.9   Blow-offs and Test Hydrants
  A19.10   Storage Resevoirs
  A19.11   Boosting and Pumping
  A19.12   Treatment and Disinfection
  A19.13   Backflow Devices (Non-Residential)
  A19.14   Other Facilities
 
A19.15
  Summary of Assets


Some of the sections listed above may have more pages that those listed above. The list shows an example of each type of page. The menu page for each section gives a full list of all of the pages in that section.

NOTE: the features and specifications of WATER Power Tools™ are subject to change at any time without notice. GeoAnalytica, Inc. is not responsible for any consequences resulting from changes in the features or functionality of WATER Power Tools™.