AWWA Tools

This spreadsheet-based water audit tool is designed to help quantify and track water losses associated with water distribution systems and identify areas for improved efficiency and cost recovery. It provides a “top-down” summary water audit format, and is not meant to take the place of a full-scale, comprehensive water audit format.

The AWWA Cybersecurity Tool represents a voluntary, sector-specific approach for adopting the NIST Cybersecurity Framework as expressed by the Water Sector Coordinating Council. The Cybersecurity Tool generates a prioritized list of recommended controls based on specific characteristics of the utility.

Offered at no-cost to participants, the AWWA’s Utility Benchmarking Survey leverages a system of well-defined, time-tested performance indicators specific to water and wastewater systems. Survey participants receive a free customized report of the aggregated data to track their own performance and identify areas that could be improved. All individual utility data remains confidential. Benchmarking provides a valuable tool that helps utilities improve their efficiency, quality, and effectiveness to advance utility management capabilities and accountability with all stakeholders.

The Water Utility Facility Asset EUL is spreadsheet-based tool to assist in determining the effective useful life (EUL) for facility-based treatment, storage, and pumping facility assets for water utilities. Understanding the effective useful life of an asset is a key component of an asset management program as it supports an initial determination of the estimated renewal needs.

To support our utility members, AWWA has developed a web-based predictive modeling tool (Copyright 2011 AWWA) intended to provide member users with approximate guidance on the degradation of hypochlorite and levels of selected degradation byproducts at their sites.

This updated tool builds on the success of its predecessor in helping utilities calculate their system’s oxidation options for cyanotoxins, while adding new features including:

• pH range has been expanded to six to 10;
• 95%-confidence intervals added for reactions where natural microcystin mixtures may have different rates;
• Microcystin kinetics (based on MC-LR) now have suggested relative rates for some other variants; and
• Increased validation of the model’s kinetics, to be published in peer-reviewed articles.

This online interactive tool can be used in conjunction with AWWA’s Manual M11 Steel Pipe: A Guide for Design and Installation to determine the recommended torque ranges and other important flange details, gasket stresses, and bolt yield loads.