Tools for Water Audit Analysis
Water Audit Software and Compiler
The AWWA Free Water Audit Software© (Audit Software) was first released in 2006, and has been through several generations. It includes a data-grading capability that allows the auditor to rate the overall degree of validity of their water audit data. Guidance on loss control planning is given based upon the credibility of the data and the measure of losses displayed by the water audit. The current version of the Audit Software is Version 5.0, published in 2014. Highlighted features of Version 5.0 include a visual dashboard for graphical display of nonrevenue water components, a comments feature for capture of essential notes, and improved overall user experience.
The AWWA Water Audit Compiler© (Compiler) was launched in 2011 and can be utilized to quickly assemble water audit data from multiple water utilities; allowing for comparisons of data across water utilities. The Compiler can also be used to compile multiple years’ of water audit data for a single utility; allowing the water efficiency history of a water utility to be viewed at a single glance. The current version of the Compiler (Version 5.0) was released in 2014.
Like the Audit Software, the Compiler was created in a Microsoft Excel® spreadsheet format and the Compiler works hand-in-hand with the Audit Software. The Compiler was developed to improve the management of water audit datasets containing multiple water audits in small or large number. It was originally devised to help state and regional water resources agencies to easily aggregate and analyze large datasets and to provide trending and analysis tools to guide the process.
During data assembly in the Compiler, different units of measurement can be automatically converted to other units to facilitate direct comparisons (a new feature in Version 5.0). If some of the water audit data of a group of utilities is given in metric volumes (megalitres), while the majority of utility data is given in gallons, the Compiler can convert the metric units to gallons so that all of the data gathered into the Compiler is in consistent units for analysis. Once data is assembled in the Compiler, graphics can be displayed and sorted easily with any of the audit inputs and outputs. The data gathered into the Compiler can also be exported to a separate Microsoft Excel® spreadsheet where the user can conduct further analysis of their own design.
Leakage Component Analysis Model
In 2014, the Water Research Foundation, with support from the US Environmental Protection Agency, published the final report and spreadsheet software tool for Project 4372a entitled Real Loss Component Analysis: A Tool for Economic Water Loss Control. The purpose of research project 4372a was to identify the best methods for conducting a leakage component analysis to be used to set a cost-effective leakage control strategy in a water utility. The project was also charged to employ these best practices in the creation of a spreadsheet software tool that works in complimentary fashion with the Audit Software. The key project deliverable was the Leakage Component Analysis Model (LCA Model).
Since the water audit results provide an annual real loss volume that is determined as a catch-all quantity remaining after all of audit components are input, very limited insight is given for leakage control purposes when compiling the water audit. The LCA Model was designed to pick up where the AWWA Free Water Audit Software leaves off, in terms of leakage assessments. The LCA Model provides the water industry with an easy-to-use spreadsheet tool to conduct a leakage component analysis, determine the water utility’s failure frequency analysis, provide guidance to set the economic leakage control intervention strategy, and display key water loss performance indicators.
Project 4372b entitled Water Audits in the United States: A Review of Water Losses and Data Validity summarizes state regulations on water loss reporting and analyzes 4,575 water audits (that follow AWWA water audit methodology) submitted to the California Urban Water Conservation Council, Georgia EPD, Texas Water Development Board, Tennessee Comptroller of the Treasury, and the Delaware River Basin Commission from 2011-2014. The results provide a national snapshot of water loss reporting, including an assessment of water audit validity and median results for key performance indicators.
Validated Water Audit Data
The AWWA Water Loss Control Committee has been collecting and validating water audit data from up to 30 North American utilities using the IWA/AWWA Water Loss Methodology from 2011 to 2017. In the inaugural year, water loss findings from 21 North American utilities were presented in an analysis report, and validated audits have been added to the North American dataset each subsequent year.
A subsequent analysis and peer-reviewed article was developed in 2016 for Journal AWWA. This project is known as the Water Audit Data Initiative (WADI), and was sunset in 2017. Data from all seven years of the WADI can be downloaded from the links below. The AWWA Water Loss Control Committee wishes to thank all utility participants over the years for contributing to the data set.