Print Page   |   Contact Us   |   Sign In   |   Register
03/28/13 Using the AWWA Water Audit Spreadsheet (Moline, IL) IEPA#5246
View Registrations Tell a Friend About This EventTell a Friend
03/28/13 Using the AWWA Water Audit Spreadsheet (Moline, IL) IEPA#5246

When: Thursday, March 28, 2013
Registration begins at 8:30 am
Where: Moline Public Library
3210 41ST ST
Moline, Illinois  61265
United States
Contact: Lisa Hoffhines

Online registration is closed.
« Go to Upcoming Event List  

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
Moline, IL


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.

The software can be downloaded for free HERE - click on the link to view the terms of acceptance of use, click at the bottom of that form, and then agree to terms of use....and an excel spreadsheet will open and you can save it to your hard drive.

PRESENTER: John Van Arsdel, M.E. Simpson Company

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 non members

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.

Membership Software Powered by YourMembership  ::  Legal