Laserfiche WebLink
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 <br />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. <br />Auditors are strongly encouraged to refer to the most current edition of AW WA M36 Manual for Water Audits <br />for detailed guidance on the water auditing process and targetting loss reduction levels <br />The spreadsheet contains several separate worksheets. Sheets can be accessed using the tabs towards the bottom of the screen, or by clicking the buttons below. <br />Please begin by providing the following information <br />Name of Contact Person: ITodd Yamello <br />Email Address: ityamello@cityofpleasantonca.gov <br />Telephone (incl Ext.): 1925-931-5519 <br />Name of City / Utility: ICity of Pleasanton <br />City/Town/Municipality: IPleasanton <br />State / Province: lCalifornia (CA) <br />Country: jUnited States <br />Year: I 2019 I Calendar Year <br />Audit Preparation Date: 7/7/2019 <br />Volume Reporting Units: IMillion gallons (US) <br />PWSID / Other ID:ICA0110008 <br />mqp— <br />Instructions <br />The current sheet. Enter <br />contact information and <br />basic audit details (year, <br />units etc) <br />Grading Matri <br />Presents the possible <br />grading options for each <br />input component of the <br />audit <br />The following guidance will help you complete the Audit <br />All audit data are entered on the Reaortina Worksheet <br />Value can be entered by user <br />0 Value calculated based on input data <br />These cells contain recommended default values <br />Use of Option Pcnt: Value: <br />(Radio) Buttons: 1 0.25% <br />11 <br />Select the default percentage To enter a value, <br />by choosing the option button choose this button and <br />on the left enter a value in the cell <br />The following worksheets are available by clicking the buttons below or selecting the tabs along the bottom of the page <br />AW WA Free Water Audit Software v5.0 Instructions 1 <br />Re'g <br />Comments <br />Water Balance <br />Dashboard <br />Worksheet <br />P mance <br />Enter the required <br />Enter comments to explain <br />nj{ <br />%%n,,icators <br />The values entered in <br />A graphical summary <br />data on this <br />how values were calculated or <br />Review the <br />the Reporting <br />of the water balance <br />worksheet to <br />to document data sources <br />performance <br />Worksheet are used to <br />and Non -Revenue <br />calculate the water <br />balance and data <br />indicators to <br />populate the Water <br />Water components <br />grading <br />evaluate the results <br />Balance <br />of the audit <br />] <br />Loss Control <br />` <br />Service,onnection <br />Definitions <br />Planning <br />ExamaleAudits <br />Acknow ledaements <br />Diagram <br />Use this sheet to understand <br />Use this sheet to <br />Reporting Worksheet <br />Acknowledgements for <br />the AWWA Free Water <br />Diagrams depicting <br />the terms used in the audit <br />interpretults <br />erpret the <br />validity <br />and Performance <br />Audit Software v5.0 <br />possible customer <br />process <br />score and <br />Indicators examples <br />service connection <br />performance <br />are shown for two <br />line configurations <br />indicators <br />validated audits <br />If you have questions or comments regarding the software please contact us via email at: wlc(cDawwa.ora <br />AW WA Free Water Audit Software v5.0 Instructions 1 <br />