Using the AWWA Water Audit Spreadsheet
PLEASE NOTE: In order to accommodate a larger amount of attendees, we have moved this training to a NEW location:
Moline Public Library
3210 41st Street
TARGET AUDIENCE: This seminar is best fit for management-level staff.
LAPTOP COMPUTER: It is optional for participants to bring a lap top to this seminar.
SUMMARY: 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 3 hour seminar will review in detail 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 recovery.
PRESENTER: John Van Arsdel, M.E. Simpson Company
REGISTRATION & HOURS:
Registration begins at 8:30am. The training will start at 9:00am and will conclude by 12:00pm. Earn up to 3PDH’s or RTC hours. Continental Breakfast included
Early Bird Registration: $25.00 Illinois Section AWWA Members • $35.00
for non members
Onsite Registration: $45.00 Illinois Section AWWA Members • $55.00 for
John Van Arsdel
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.