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
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.
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 Component Analysis Model (the 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 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.
The EDC Network for Water Utilities
The EDC Network for Water Utilities is an online network to promote collaboration among water utilities and improve each utility’s response to challenges posed by endocrine disrupting compounds (EDCs) and pharmaceuticals and personal care products (PPCPs). The EDC Network provides a secure website resource for utilities to share best practices, documents, other tools, and materials related to EDCs and PPCPs. The EDC Network is open only to utility professionals, regardless of whether you are a WaterRF subscriber. Please feel free to forward and invite your utility peers to participate. Visit The EDC Network today and register—your request will be reviewed and login credentials sent within 24 hours.
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 http://stage2dbpcalculator.com, 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. 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 Simultaneous Compliance Tool (SCTool) is 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 utilizes 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. The tool is currently unavailable at this time. Please check back later for a status update. The report for project #3115, which developed this tool, is available.
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.
Arsenic Decision eTree (Project 2660)
Web-based, interactive arsenic-decision-tree program. The program helps utilities identify feasible and promising treatment technologies based on the input provided by the user.