Resources Web Tools

Web- and software-based applications that help professionals understand and apply research results are one of the fastest growing types of project deliverables resulting from WaterRF research. Web Tools come in a variety of forms ― ranging from spreadsheets and databases to risk calculators and planning guides. Explore the following Web Tools to find new ways to help you in your daily work and planning.

Access LevelTitleIntroduction
Opportunities and Barriers for Renewable and Distributed Energy Resource Development at Drinking Water and Wastewater Utilities: Electronic Supplements

​These electronic supplements were created as part of project 4625, Opportunities and Barriers for Renewable and Distributed Energy Resource Development at Drinking Water and Wastewater Utilities. They include an Annotated Bibliography (ES1); a Catalog of DER Barriers (ES2); a Catalog of DER Regulations (ES3); and the Regulatory Drivers- Linked Overview, a visual map of regulations that highlights a complex and intersecting regulatory environment (ES4).

Pilot-Scale Demonstration of the Water Footprint Concept for Sustainable Decision Making

​Project 4652 developed a Water Footprint Assessment Tool that can be used as a guide on how to conduct a water footprint assessment. The tool includes functionality for evaluating water scarcity and water quality degradation impacts (local freshwater and marine eutrophication). An additional workbook provides an example of how the water footprint assessment can be calculated and tailored by a water utility using the tool. Guidance on using the tool can be found in Chapter 5 of the project 4652 report.

Guidance on Implementing an Effective Water Loss Control Plan: WADI Plus Database
Project 4695 developed an expanded database, WADI Plus, comprised of validated water loss audits conducted between 2009 and 2017. These audits include those compiled in the WADI and audits submitted by utility participants in this research project. The WADI Plus outputs included in this Excel file can be used by water utilities for benchmarking purposes by comparing their key performance indicators to those of water utilities included in the WADI Plus database.

Forging Powerful and Sustainable Relationships Between Clean Water Agencies and the Community: Self-Assessment Tool
Developing strong customer relationships based on a deeper understanding of customer needs is a highly valuable strategic
move for clean water agencies (CWAs), and can create long-term value for both the water industry and local communities. A strategic framework is needed to guide CWAs towards the actions that will be the most impactful in enhancing customer relationships.

This self-assessment tool, developed under project 4678, assists CWAs in understanding their current levels of progress towards a strategic framework consisting of three key stages: (1) building awareness, (2) establishing common ground, and (3) creating engagement.

Integrating Master Planning and Condition Assessment: Tools
​These tools were developed, as part of project 4656, to allow utilities to (1) assess their readiness to apply the road map, (2) initiate risk unitization, and (3) determine the cost-effectiveness of condition assessment in relation to specific risks. The tools are designed for use with the road map, but may also be used independently. They are also useful for high performing utilities that have adopted use of condition assessment and advanced asset management practices.
Intelligent Water Systems Considerations Matrix
​Project 4670 inventoried the different types of information sources currently being used by water utilities, along with the associated communication media and protocols. Security risks associated with each information source and its communication approach were assessed. This Intelligent Water Systems Considerations Matrix presents general and security considerations for communication methodologies used by the most common information systems as identified through project 4670.
A Framework for Assessing the Costs and Benefits of Managing Compounds of Emerging Concern in Surface Water: Appendices K and L
​Project 4494 evaluated management plans for compounds of emerging concern that have been employed, or are being considered, in North America, Europe, and Australia. This web tool includes two appendices:
  • Appendix K: CEC Removal Efficiencies
  • Appendix L: Summary of Aquatic and Human Health CEC Hazardous Indices
Joining-Up Urban Water Management with Urban Planning and Design
Project SIWM5R13/4853 investigated the key inhibiting and enabling factors in coordinating efforts across the urban planning, design, and water management sectors. This zip file contains two appendices:
  • Appendix C: Barriers-to-Bridges Matrix
  • Appendix D: Map of Connections
Integrating Water Efficiency into Long-Term Demand Forecasting
Project 4495 provides a discussion of the impacts of efficiency standards and codes on water demand, as well as practical guidance on incorporating water efficiency improvements into long-term demand forecasts. This tool contains Appendices D-F:
  • Appendix D: Water Conservation and Efficiency Standards
  • Appendix E: Device Lifetime and Flow Ratings
  • Appendix F: Relevant Water Use Studies Reviewed
Collaborative Utility Benchmarking in North America: Appendices E and F
​Project 4659 investigated the feasibility of further consolidation of the primary benchmarking approaches being used in North America (EUM tool, AWWA metrics, ISO 55000, and the AMCV tool). Appendix E provides the complete list of metrics with mapping to AMCV Functions and Processes and EUM attributes. Appendix F provides the mapping of each AMCV Sub-Process to relevant AWWA standards.

Scott Haskins and Priscilla Bloomfield, CH2M
Alternative Source Water Assessment Tool
​As part of project #4665, the Alternative Source Water Assessment Tool (A∙SWAT) was developed to aid utilities in screening the treatability of their stormwater and/or treated wastewater at a conventional drinking water treatment plant, and to calculate water quality requirements based on finished water goals and conventional water treatment plant performance. The A∙SWAT establishes a relative suitability for treatment of local stormwater or treated wastewater based upon site-specific water quality and typical conventional treatment performance. The A∙SWAT provides high-level screening of source water quality based upon the 14 stormwater or 11 treated wastewater water quality contaminants that are most commonly cited in prior studies at concentrations that are higher than those in more traditional source waters.

An A∙SWAT User Guide was developed and is both included with the webtool and available as Appendix C of the project #4665 research report.
Monash Tool
​The Monash Tool is an Excel-based pipe stress prediction tool developed for large-diameter cast iron water pipes. The tool provides a deterministic approach to assess 1) nominal (hoop) tensile stress, 2) stress concentration factor (SCF) and maximum tensile stress for fracture initiation, 3) critical crack length for pipe burst, and 4) remaining life to initiation of local failure leading to a leak. In addition, the probability calculation of the pipe failure prediction and remaining life is also being incorporated.

Explanatory notes and a set up guide were also developed and are included with the tool.
Multiblend Model
​This Excel-based web tool accompanies the 2001 AwwaRF report, Water Quality Impacts from Blending Multiple Water Types. The Multiblend Model allows users to make predictions of the resulting water chemistry after blending two or more waters. It also allows blend ratios to be determined from basic system hydraulics. The Multiblend Modol also allows the user to determine the cost of a blend and the contributions to it from different sources. 
Integrating Land Use and Water Resources: Planning to Support Water Supply Diversification: Literature Review Sources and Case Study Interview Database
​Project #4623 explored current and future opportunities to diversify water supplies through better coordination between water utilities and the land use planning and development community. Findings from the literature review and interview stages of the research were compiled into a Microsoft Excel® database. This resource includes all the details of these efforts, allowing the user to search and filter results and explore the specific findings of individual resources in more detail.
Pipeline Inspection Decision Analyzer
​Project #4553 developed a framework for water utilities to guide and select the most appropriate strategy to determine a cost-effective course of action to schedule the next inspection/condition assessment for a high consequence pipe or a group of pipes, given available knowledge of historical performance, environmental, and operational conditions. The entire approach was coded into a user-friendly, interactive, and simple-to-use Excel-based application, Pipeline Inspection Decision Analyzer (PIDA) Framework. A detailed User’s Manual, a Data Guide, and Case Studies were also developed and are included with the Framework web tool.
Preparedness and Response Practices to Support Water System Resilience: Fundamentals, Good Practices, and Innovations
Project 4601 identified practices and procedures in published literature or in use at utilities around the country that can be shared to help all utilities better prepare for, and respond to, emergencies. This worksheet summarizes the literature review results, which focused on identifying practices from other sectors and industries that might be applicable to the water sector.
Social Media Posting Skills Checklist
As part of project #4638, the research team developed a tool to help utility staff prepare quality content for their social media accounts. With explanatory videos, this tool shows users how to apply social media best practices to their posts.
Data Collection Workbook
An Excel-based Data Collection Workbook was developed as part of project #4451. The workbook is designed to help collect information on the full cost of a major water main break. One copy of the workbook should be used for each water main break considered. The desire is to have a full accounting of costs associated with the break, not only for the utility, but for society as a whole. The cost categories are arranged in a TBL fashion in order to capture the full range of financial, social, and environmental costs of a main break.
Cr(VI) Treatment Design & Costing Tool
The Cr(VI) Treatment Design and Costing Tool was developed as part of WRF project #4561. This tool, along with the report, can serve as an initial step for a utility in planning a hexavalent chromium removal project. By using the tool with project specific flow rates and water quality parameters, utilities can assess basic design options and costs associated with the various wellhead hexavalent chromium treatment options. Even though the tool is tailored for specific water qualities, the findings and results of the tool should be verified by bench and/or pilot testing prior to full-scale consideration. The tool was programmed as a series of Microsoft Excel spreadsheets to prompt the user for input and conduct calculations.
Download the Webtool
Biofilter Conversion Assessment Tool
This Excel-based tool allows users to input utility-specific data to aid in biofilter conversion decision making. The tool provides industry-wide experience on biofilter conversion, which can help utilities evaluate the suitability of converting to biofilters at a particular facility.
New and Emerging Financing Decision Support Tool
This interactive decision support tool was created to assist utility finance managers in assessing the potential applicability of the various new and emerging financing alternatives highlighted in this research report. The tool is Microsoft Excel-based, and is a supplementary deliverable of WRF project #4617.
Green Energy Life Cycle Assessment Tool, Version 2 (GELCAT 2)
This tool helps utilities determine the economic viability and energy, environmental, and social costs and benefits of select renewable energy technologies including solar PV systems, wind turbine generators, hydro turbine generators, and geothermal heat pumps at water and wastewater utilities. The tool is a new version of the 2014 GELCAT software, and includes two new modules: micro hydro turbines and geothermal heat pumps.
Renewable Energy in the Water/Wastewater Industries: Excel-based Tool
This Excel-based model provides a step-by-step systematic approach to determining the potential to derive maximum benefits from future projects by analysis of the pitfalls, successes, and opportunities applicable to past renewable energy generation projects in the UK. The ZIP file contains the Excel model and a User Guide. Please note that this tool is geared toward the UK water sector.
Proformance: Biofiltration Performance Tracking Program
This interactive biofiltration performance tracking tool is an Excel-based program used to compile raw biofilter data and generate Excel files representative of biofilter performance.

This web tool is a supplemental deliverable for project #4525.
Residential End Uses of Water 1999 Access Database
This database contains all data collected during the REU1999 study, including historic water billing records, survey response data, and individual end use water data.
Source Catchment Investment Analysis Tool

This analysis tool helps users estimate the costs and benefits of source catchment investments.

This tool is a supplementary deliverable for project #4570.

Source Value Transfer Database
This searchable database contains 220 estimates of the economic value of source catchments as water quality treatment assets. This tool is a supplementary deliverable for project #4570.
Rate Case Visualization Tool
This interactive visualization tool provides an easy-to-understand and visually-pleasing snapshot of a utility’s financial and operational performance, which can be used in communicating with officials, governing boards, and other key decision-makers. This framework helps communicate the salient metrics of a proposed rate change in a transparent, consistent and explicable way. Creating and sharing rate-request information through an interactive dashboard capitalizes on the fact that many people are visual or kinetic, hands-on learners. Dashboards also provide a mechanism for condensing large amounts of data and information into easily digestible communication aids.


Cr(VI) Compliance Planning Decision Support Tool
This Excel-based tool is a supplemental deliverable for WRF project #4445, a Tailored Collaboration project with Coachella Valley Water District (CVWD). The tool is intended to guide utilities to group wells for treatment and select appropriate treatment technologies.
Residential End Uses of Water, Version 2 Access Database
This database contains all of the end use water events recorded during the 2016 study, along with the survey response data, historic billing data, and other data obtained for each study site. The database also contains summary results from other end use studies. This resource can be utilized by researchers and WRF subscribers as a jumping off point for further research.

Non-subscribers who are interested in receiving a copy of the Access Database should email their request to

Energy Efficiency Tool for Pumping Systems
This software tool was developed to assist pump station designers and operators in making energy efficient selections. The tool enables the user to select energy improvement alternatives from a list built into the software. The goal of the tool is to allow the user to evaluate different energy efficient alternatives for existing pump stations (existing operation versus two other alternatives) and new pump stations (two design alternatives). The comparison of alternatives is based on annual energy savings, GHG emissions reduction, and life cycle cost analysis results.
Water Treatment Chemical Risk Assessment
The Water Treatment Chemical Risk Assessment spreadsheet can be used to quickly identify chemicals most at risk from supply shortages based on responses to a series of related factors. The spreadsheet can be used to identify the general risk of chemical shortages or the risks for specific water treatment works and treatment processes.
Localized Control of DBPs by In Tank Spray Aeration TTHM Removal Self-Assessment Tool
The purpose of this spreadsheet tool is to aid engineers in designing in-tank spray aeration systems by providing an estimate of the number and type of nozzles required to reduce TTHM to the desired levels in water storage tanks. The desired TTHM level leaving the tank, nozzle, and tank characteristics are the inputs for the tool. The outputs are the required nozzle quantity and total flow through the aeration system.
No Disruption Repair Decision Support Tool
This Decision Support Tool allows the user to compare costs for technically valid no disruption repair options for certain specific scenarios (as defined by input values—repair type, pipe material, size, operating pressure, pipe condition, etc.). The user also inputs the number of people/connections to be cut-off with a traditional technique and assigns a £ value per property affected (domestic, commercial, and sensitive).
Biological Stability Analysis Tool
A biostability assessment tool (BSAT) was developed as part of project #4312. The tool is a Microsoft© Excel-based macro developed for Excel 2007 or later versions. The tool is intended to allow utilities to (1) track historical data, (2) benchmark data against results from this project, (3) assess system stability over time, and (4) identify controlling factors influencing biological stability on a site-specific basis. With this tool, the user can select specific water stability metrics to evaluate, such as disinfectant residual stability, biofilm formation rate, and corrosion rate. The user can then determine which factors are most associated with instability in their own system, and what threshold values are important. This will allow the utility to identify potential instability causes and to develop meaningful operational criteria to achieve their own stability goals. A User’s Guide is also available to download.
U.S. Pipe Library
The U.S. Pipe Library contains a list of standard pipe characteristics such as type, diameters, thickness, classes, and years of manufacture.
Video Animations Of 2D- and 3D-flows In A UV Reactor
Three dimensional flows in a UV reactor can be visualized using the 3DLIF (Laser-Induced Fluorescence) technique at a high resolution (corresponding to millions of sampling points), which is not possible with traditional dye tracer test techniques. These animations and images were obtained from a 3DLIF experiment performed with dye injected at the point in the center of the y-z plane.
DORIS—Energy Consumption Calculator for Seawater Reverse Osmosis Systems
Doris, the developed seawater reverse osmosis (SWRO) energy consumption software, is a versatile Java-based tool which establishes a standard framework for energy consumption estimation and leads the user to identify all energy consumption elements within a facility, review guidance provided, and clearly define the basis for assumptions used. The versatility of the application, through its user friendly interface, extensive built in default numbers, and thorough guidance makes it usable in many branches of the industry, from planners to municipal agencies, design engineers, and operators.
Demo for an Advanced Real-time Monitoring and Decision Aide (ARMADA)
An alternative, “multi-site approach” is demonstrated here using an experimental computer program called the Advanced Real-time Monitoring And Decision Aide (ARMADA). The concept is that water quality signals at a “target site” can be “filtered” to remove variability due to known (measured) causes. The causes are represented by data that describes incoming water quality from upstream sites, and hydraulics operations such as pumping and tank cycling. The filtering is performed by empirical (curve fitting) models that predict target water quality from known causes, thereby accounting for their effects. The models’ prediction errors (the differences between the target’s measured and predicted water quality values) represent variability due to unknown causes, such as a contamination event that originates between sites. A statistically large prediction error causes a notification.
Online Water Quality Sensors and Monitors Compendium
This compendium is intended to help the water industry learn how to most effectively use online water quality monitoring instrumentation from the experience of current users. The compendium was created by the Water Environment Research Foundation (WERF), on behalf of the Global Water Research Coalition (GWRC), of which WRF is a member. **As of October 2016, the compendium is offline and undergoing a major restructuring. The updated compendium will go live by January 2017. Thank you for your patience.
Database of Drinking Water Qualities in the United States and Canada
Project 4191 was designed to identify and prioritize key water quality characteristics and changes that might adversely impact the performance and leaching of nonleaded brasses in drinking water distribution systems over typical component lifetimes. The formation of the passivating layers, and thus the corrosion and metal-release behavior, is mainly driven by material property and water quality. To cover both of these factors, it was necessary to identify so-called “corner waters,” which represent a high percentage of the drinking water distributed in North America. Based on statistics and the experiences of water utilities and other drinking water specialists, five corner waters were identified that were used to perform the long-term migration experiments (see Chapter 2). In this context, a database was created in which the distributed water qualities in the large cities and metropolitan regions of the United States and Canada were summarized.
North American Biofiltration Knowledge Base
The Knowledge Base is intended to capture the experiences and best management practices from North American water utilities currently in the process of implementing or operating high rate aerobic biofilters. The Knowledge Base contains information from facilities broken into four phases of implementation—planning, evaluation, design, and operation.
Leakage Component Analysis Model
The Leakage Component Analysis (LCA) Model was developed to provide the water industry with a computer-based model for leakage component analysis, failure frequency analysis, economic leakage control intervention strategy evaluation, and display of key water loss performance indicators. The LCA Model is a complementary analysis tool to the AWWA Free Water Audit Software and was designed using a standard Microsoft Office Excel software program. The model was developed with the needs of utility users in mind to provide a water loss analysis software tool that is accessible, user-friendly, and has a reasonable level of complexity.
Leak Repair Data Collection Guide
The Leak Repair Data Collection Guide is an open source MS Office Excel spreadsheet designed to aid the industry in collecting consistent failure data. This tool offers guidance to water utilities in the form of a standardized format to document failure events; thereby generating the appropriate data to execute a reliable leakage component analysis. Utilities that carefully document all failure events have a means to define failure trends occurring in their system.
RHI Calculator Spreadsheet Model Tool

​The Relative Health Indicator (RHI) tool generates RHI values as output when chemical, microbiological, and water system information are input. The tool is anticipated to be useful to water utilities in multiple ways. Beyond compliance with MCLs, this tool allows utilities to identify contaminants in their treated drinking water that pose the highest remaining health risks in terms of RHI. Utilities may also compare RHI values from various water sources, or the effectiveness of various potential treatment technologies using this tool.

Workforce Health and Safety: Worksheet Models
Four prototype models were developed to support and drive Prevention through Design initiatives. A Task Categorization Model (TCM) identifies facility features or task characteristics that affect the ongoing costs of performing tasks safely and thereby provides guidance to facility planners on how to lower operating costs. The Relative Cost of Safety for Tasks (R-CoST) model is a quantitative tool for comparing alternative designs and task methods within each of five areas (referred to as task groups). The Total Cost of Safety for Tasks (T-CoST) model is a tool that aims to account for ongoing costs in a more comprehensive manner. Lastly, the Material Handling Cost (MHC) model incorporates an adaptation of the T-CoST model approach specifically for manual material handling tasks. The TCM, R-CoST, T-CoST, and Material Handling models are designed to aid in deciding among alternatives based on credible differences in ongoing costs.
Effective Utility Management Benchmarking Tool
The Water Research Foundation has developed a tool to help water and wastewater utilities evaluate their current and desired levels of performance related to the 10 attributes that were identified in the EPA report, Effective Utility Management: A Primer for Water and Wastewater Utilities (2008). The tool is aligned with the Primer, identifies practice areas used by the water sector to support each attribute, and provides a structured process benchmarking exercise to help water utilities conduct a self-assessment of any or all of the 10 attributes that they want to improve to meet their goals. The tool is accompanied by (1) a recommended approach for a utility to conduct a self-assessment (4313a) and (2) a User’s Guide (PowerPoint presentation) that will help water utilities use the tool.
Weather Modeling of Leakage and Bursts
This spreadsheet allows users to review the model using example data or to apply company-specific data. The example data is drawn from one of the sample companies and uses weather data from a different company.
Water Utility Customer Assistance Program Cost Estimation Tool
This tool was developed to help utilities assess the costs and benefits of implementing a customer affordability program in their service area. Using information from the U.S. Census Bureau and water and wastewater rates inputted by the user, this interactive instrument incorporates information about the eligibility threshold to qualify for an affordability program, annual assistance offered per customer, percent of customers responsible for bad debt, among other fields. By adjusting the appropriate fields, the results provide insight into design considerations and program costs. A tutorial video is also included to guide the user.
Water Utility Revenue Risk Assessment Tool
This tool allows utilities to quickly determine the proportion of residential revenues from water sales at risk of loss when demand patterns change, based on the utility's own rate structure, customer demand profile, and weather conditions. The tool requires only minimal data and uses simplifying assumptions based on actual customer behavior. It focuses exclusively on revenue projections and assessments and allows the user to compare two different rate structures and assess which one offers greater revenue resiliency. A tutorial video and example spreadsheet are also included to guide the user.
Water Quality Impacts of Extreme Weather Events (WaterQIEWE) Tool
The Microsoft Excel-based Water Quality Impacts of Extreme Weather Events (WaterQIEWE) Tool was designed to provide a means of quickly sorting and accessing case studies that may be relevant to a particular utility. Case studies can be sorted based on various criteria including geographic location, weather, water quality, year of event, and water source.
Pipe Risk Screening Tool
The purpose of this tool is to prioritize your water distribution and transmission pipes for renewal projects. This prioritization will identify the set of pipes most at risk for failure and with the greatest cost-based consequences for inclusion in your capital improvement program (CIP).

Download the Tool (32mg zip file)
Files must be extracted to your local system.
How to extract files.
Earthy/Musty Taste and Odor Decision Tool
The Earthy/Musty T&O Decision Tool will help utilities characterize their E/M T&O problems, identify reasonable goals for geosmin and MIB control, and develop alternative scenarios for meeting these goals. The tool is based in Microsoft Excel. Two example scenarios illustrating the use of this tool are also included, one a “high-geosmin odor events” example, and the other a “moderate on-going MIB and geosmin levels” example (Example 1_E-M TnO Mgmt Tool.xls and Example 2_E-M TnO Mgmt Tool.xls, respectively).
Reminder: This tool is intended to facilitate the planning process, but is not intended to replace a detailed Study, Pre-Design and/or Master Plan.
Water Utility Workforce Needs
This Website is one of the products of the research project on “Competency Model Development and Application to Meet Water Utility Workforce Needs” (Foundation project #4244.) A competency model is a detailed, behaviorally specific description of the skills and traits that employees need to be effective in a job.​ Go to the Water Utility Workforce Needs Website
Business Continuity Plan Training: Video Modules
To further enhance an understanding of the Business Continuity Planning process, a series of video training modules were developed to accompany the BCP guidance document and template. These modules correspond to the various sections of the written materials. Users may view the entire video or select individual modules, as appropriate to their needs.
Stage 2 D/DBP Compliance Calculator
The Stage 2 D/DBP Compliance Calculator can help utilities work through the decision process and provide them with specific options based on their system characteristics. The tool streamlines the data entry, calculations, and compilation of results. This allows the user to easily compare the reduction potential and costs of a variety of different possible combinations of compliance alternatives.
The tool, available at, is open to everyone with the only requirement being that users register and create a login and password.
Cost Calculator for Cr(VI) Removal From Groundwater
This cost estimation tool was developed to help drinking water systems estimate a range of potential costs to remove Cr(VI) from their water based on system-specific information about the impacted well, water quality, and residuals handling.
Rehabilitation of Cast Iron Tool
The Rehabilitation of Cast Iron Tool (RoCIT) is a decision support tool designed to assist asset managers to make rehabilitation decisions for small diameter cast iron pipes. This is achieved through six modules that help the user decide whether to renovate or replace the pipe(s). Details of how to use the software tool can be found in the associated Guidance Manual, which can also be downloaded here.
Water Utility Tool For Responding To Emerging Contaminant Issues
This Web tool will help drinking water utilities to address emerging contaminant challenges, especially Endocrine Disrupting Compounds (EDCs) and Pharmaceuticals and Personal Care Products (PPCPs).
Knowledge Base of Chloraminating Utilities’ Experiences with Section 8 and 9 Devices
A compilation of the pertinent data from a survey, case studies, and historical information and data on chloraminating utilities’ experiences with Standard 61 devices were incorporated into this Microsoft Excel spreadsheet. This information constitutes a current “knowledge’ base” of chloraminating utility experiences with Section 8 and Section 9 devices.
Asset Data Templates
These Microsoft Word documents include a generic asset hierarchy list, performance indicators for drinking water assets, performance indicators for wastewater assets, and a glossary related to key drinking water and wastewater system assets, including above and below ground assets. The reader should view these four Word products as templates and modify the content to meet their unique asset management programs, goals, and objectives. Please review the Introduction to learn more about these templates.
Control Charts Program from Project #4286, Distribution System Water Quality Control Demonstration
A Microsoft Excel® add-in is provided with this project so that the reader can begin to work with Shewhart control charts on data taken over time. The add-in calculates Shewhart control chart statistics and creates graphs of time-series data with the associated statistics.
Database of Best Practices for Energy Efficiency
This electronic tool is an easy-to-use searchable database of energy efficiency best practices based on a comprehensive literature review.
Conservation Planning Models
Included with Project #4175 are a number of Conservation Planning Models. The Decision Framework Model will help direct planners and managers to information, models, and planning tools for planning and implementing conservation programs. Also included are a WaterRF Drought Response Tool, WaterRF Benefit-Cost Tool (revised from 2007), and information on WUE programs.
Supplemental Materials for Evaluation of Analytical Methods for EDCs and PPCPs Via Interlaboratory Comparison
Project #4167 includes the following Supplemental Materials:
- A summary of the methods found in the literature review
- Summaries of questionnaire responses for each laboratory/method
- Detailed analysis of each compound for each interlaboratory comparison
- Master data spreadsheets containing raw data from all three interlaboratory comparisons
- SOP of method 18CD that was validated during the project
Supplemental Services Guide
The Supplemental Services Guide is an Excel-based tool designed to guide utilities in their decision-making regarding supplemental service offerings that meet their organization’s goals and objectives. The Supplemental Services Guide is provided to users as a matrix of supplemental service choices, with columns of the matrix representing different target audiences for whom utilities may want to provide supplemental services (i.e., utility customers, the broader community, other utilities, other businesses).
Decision Support System (DSS) Software Tool
The report, Decision Support System for Sustainable Energy Management (project #4090) created a Decision Support System (DSS) software tool that will guide a utility through the process of developing a portfolio of options to meet their goals for reductions in energy use, GHG emissions, energy cost, and increasing the percentage of renewable energy.
Grand Central Model
Methods specifically developed for water infrastructure failure have been combined in spreadsheets developed for this project #2607. The “Grand Central” model are what-if spreadsheets that enable comprehensive assessment of the costs of infrastructure failures for water utilities.
Knowledge Management Toolkit
The Knowledge Management Toolkit is a virtual resource for planning and implementing the organizational change needed to support implementation of a KM strategy in drinking water utilities. It contains a five-phase process, as well as downloadable resource documents to support second-order learning.
Desalination Intake Decision Tool
The decision process developed in project 4080 was turned into this software tool. The software walks the reader step-by-step (tab-by-tab) through the evaluation process. The user is prompted to answer a series of questions. Most queries have “Note” sections where the user can add additional documentation related to the questions as desired. As the decision tool is targeted at developing an intake development plan, it is assumed that the user has already determined the desalting process scenario to the extent that he/she knows the volume of feed water the process will need.
If intake design options are deemed unfeasible at any point in the process, they are eliminated from further consideration. This process delivers technically defensible options that help a user evaluate and select which options are best for the application.
Guidelines for Implementing Seawater and Brackish Water Desalination Facilities (PIM)
As part of project 4078, Guidelines for Implementing Seawater and Brackish Water Desalination Facilities, this planning issues matrix (PIM) and user’s guide were developed to assist users in understanding the broad range of issues and complexities associated with planning a desalination facility.
Source Water Protection Cost-Benefit Webtool
Developed from project #4143, the Webtool is designed for immediate application by source water professionals. The Getting Started section assists users in identifying source water protection project options. Once an option is identified, users can use the cost/benefit tool to evaluate and compare the triple bottom-line costs and benefits of that option. An editable report can be generated which can be used for presentation to stakeholders.
Minimizing Water Treatment Residual Discharges to Surface Water Decision Support Tool
As part of project 4086, Minimizing Water Treatment Residual Discharges to Surface Water, this decision support tool and guidance video on how to use the tool were developed to assist users in evaluating residuals minimization, treatment, and reuse options.
High-Rate Spent Filter Backwash Water Treatment Information Tool (SFBW)
This Web tool allows users to review findings from project 3114.
Computational Fluid Dynamics-based Software (CFD)
Developed as part of project 2977, the Computational Fluid Dynamics-based software calculates log inactivation and reduction equivalent UV dose (RED) with four UV reactors representative of commercial drinking water technologies, all as a function of flowrate, UV transmittance, lamp on/off status and power setting, and microbe UV sensitivity. The software is limited to four UV reactors as described in Chapter 7 of the report, Design and Performance Guidelines for UV Sensor Systems, Order No 91236.
Simultaneous Compliance Tool (SCTool)

The tool is now unavailable but may be updated at a future date. The report for project #3115, which developed this tool, is available.

The Simultaneous Compliance Tool (SCTool) was intended to assist utilities in evaluating appropriate technology choices to comply with multiple and/or conflicting water quality goals, with particular attention toward challenges posed by the source water, treatment and distribution system conditions/limitations. The SCTool utilized a framework of technology-based rules to identify potential unintended consequences and simultaneous compliance conflicts associated with a particular solution - in the context of system-specific water quality, treatment, operational, and management characteristics.

Sustainable Infrastructure Management Program Learning Environment (SIMPLE), Foundation Project #4013
The Water Research Foundation, in collaboration with the Water Environment Research Foundation (WERF), has expanded the Web-based knowledge management system originally built for wastewater utilities (called SIMPLE: Sustainable Infrastructure Management Program Learning Environment) to include information for drinking water utilities. The updated Web site is called SIMPLE version 1.1 and will replace SIMPLE. This work was performed through project #4013. Research partner: WERF. Completed in 2008.
Energy Benchmark Metric Score Sheets
Energy benchmark metric score sheets and the raw survey data from the CD-ROM included in the report package for the Foundation project 3009, "Energy Index Development for Benchmarking Water and Wastewater Utilities". The metric files are Microsoft EXCEL spreadsheets, containing user instructions within the spreadsheets.
LT2ESWTR TOOLBOX Guidance Program - Version 2
The LT2ESWTR Microbial Toolbox - Version 2, updated in early 2007, is a Web tool that can help utilities meet requirements of the Long-Term 2 Enhanced Surface Water Treatment Rule by determining which treatment is most suitable for their water treatment plant. The Toolbox serves as a decision tree tool that will guide you through several steps to attain Cryptosporidium credits associated with the LT2ESWTR.
The Service Line Information Tool (SLIT)
The Service Line Information Tool (SLIT), developed by Project #2927, is a user-friendly web-based tool designed to inform utilities about service line maintenance. The web tool provides information on the latest technologies as well as on traditional and alternative service line maintenance options.
Integrating UV Disinfection Into Existing Water Treatment Plants - MBAT and UVDIT web tools
Two interactive decision web tools have been developed by Malcolm Pirnie, Inc. and Hazen and Sawyer for Foundation project 2861. Their purpose is to provide guidance to utilities in evaluating the implementation of UV disinfection into existing water treatment plants (WTPs) by helping utilities evaluate their existing treatment strategy and retrofit issues associated with UV disinfection.
Taste and Odor Self-Assessment and Decision Tree
This webtool contains the Taste and Odor Self-Assessment Tool and the Taste and Odor Decision Tree.

The Self-Assessment Tool is designed to give a utility an indication of how well-prepared it is for a taste and odor event.


Water Treatment Plant Infrastructure Assessment Manager, Version 1.2.0
This ZIP file contains the Water Treatment Plant Infrastructure Assessment Manager software, version 1.2.0, for WRF project #2921. This software allows users to enter information about infrastructure (e.g., residual value, age, remaining useful life) that can be used in financial statements or exported to other applications.