Title: Using the AWWA Water Audit Spreadsheet
Webinar Type: Technical Webinar
Delivered on: 11/20/12
IEPA #: 5247
Credit hours for water operators & engineers: HOURS: 1.00
Total Hours: 1.00
Presented By: John Van Arsdel, M.E. Simpson Company
Description: The Water Audit Spreadsheet based tool contains worksheets in a
spreadsheet file used to help track water usage and calculate levels of
performance for tracking water losses. Instructions for using the
spreadsheet tool are included in the spreadsheet. The spreadsheet
prompts the user to enter standard water supply information such as the
volume of water supplied, customer consumption (metered and unmetered),
quantities of losses, and other distribution data used to calculate the
operational efficiency indicators.
Knowing that many water
utilities don’t typically tabulate all of this data, the spreadsheet
allows the user to enter either known (measured) or estimated
(quantities that must be approximated) values. There is a grading matrix
available that helps establish the confidence of the data entered. The
software then calculates a variety of performance indicators which are
useful in making performance comparisons among water utilities as well
as help with short term and long range planning.
This 1 hour
webinar will review the spreadsheet-based water audit tool which is
designed to help quantify and track water losses associated with water
distribution systems and identify areas for improved efficiency and cost
The software can be downloaded for free HERE -
click on the link to view the terms of acceptance of use, click at the
spreadsheet will open and you can save it to your hard drive.
Cost: Illinois Section AWWA Members: FREE; Nonmembers: $30.00
you have purchased the archived webinar, you will receive an email
confirmation. This email will include a link to the directions on how to
view the webinar and obtain your training credit hours and certificate.
John Van Arsdel, M.E. Simpson Company
John H. Van Arsdel is Vice President with M.E. Simpson Co., Inc. He is a
graduate of Valparaiso University with a B.A. in Geography. He has
completed water operators’ classes and seminars on water filtration and
distribution. He has over 23 years’ experience directing projects for
water utilities concerning water loss, water audits, mapping programs,
metering programs, condition assessment programs, and flushing programs.
He has presented seminars for water operators for over fifteen years.
This includes various topics for the ISAWWA Education Committee, several
papers at Illinois, Wisconsin and Michigan AWWA Section meetings, as
well as papers at ACE in 2007, 2009, 2012 and a paper at the 2010, 2011,
2012 AWWA Distribution System Symposium. He has maintained an active
role in local and state water works organizations including holding
offices on various boards and committees. As Vice President of M.E.
Simpson Co., Inc., John serves as the main point of contact for client
development and customer relations for the eastern U.S.