Hach Water Information Management Solution TM (WIMS TM ) Overview

1. Hach Water Information Management SolutionTM (WIMSTM) Overview October 2010

2. Make it Meaningful! Buried in Data? Don’t get slowed down by: Piles of paperwork Time-consuming reports Mind-numbing calculations Hach Water Information Management Solution

3. Hach WIMS Allows You to Make Performance Decisions Confidently Hach WIMS provides a comprehensive view of your entire water and wastewater operations • Tailor outputs to meet your specific needs • Ensure accurate and secure data • Review easy-to-understand dashboards • Utilize trend analyses charts • Conduct what-if models • Develop internal and regulatory reports • Integrate all water system • data in ONE place • Get accurate data easily • Quickly analyze and • compare results • Easy calculations for • reports

4. Organize Data for Immediate Access and Analysis Manual Data Entry: • Built-in templates for data entry • Screens that match spreadsheet , daily log and benchsheet formats • Automated Data Entry: • SCADA • Dataloggers • LIMS • Commercial Laboratory Reports • Download data from portable field devices

5. Ensure Informed Decisions with Accurate Information • Collects data in a central database • Access to data provided locally or over secure Web • Guarantees safe and secure historical records • Eliminates multiple data entries • Tracks inputs through audit trails

6. Monitor Organization Performance • Personalized dashboards allow you to: • Track the information specific to your use • Obtain quick retrieval of reports, graphs, and entry forms • Access shortcuts to other areas of the software

7. Chart Data for Comprehensive Analysis • Integrated reporting and graphing tools allow you to: • Simplify report generation and data analysis • Configure graphs for trend analysis, correlations, and control charting • Easily compare various sets of data to identify cost reduction opportunities Ex. Raw Turbidity Daily Avg, Daily Min, Daily Max

8. Turn Raw Data into Actionable Information • Create business and regulatory reports instantly • Schedule automatic report output to the screen, print or email • Utilize built-in EPA and state report templates (SWTR, DBR, NPDES, DMR, eDMR, MOR, SDWA, CCR, industrial pretreatment compliance, and more) • Quickly configure standard reports using templates and wizards

9. Case Studies

10. Case Study 1: Provide Data Consistency Throughout Organization • Challenge • In 2006, United Water purchased an enterprise license for OPS SQL™ to use as its data management tool for 335 of its facilities • In 2007, United Water purchased the water activities of 225 additional facilities • All facilities used an OPS product, though different versions and in varying degrees • The variation of captured data made it difficult to effectively compare the performance of the facilities

11. Case Study 1: Provide Data Consistency Throughout Organization • Solution • All facilities migrated to the comprehensive Hach WIMSTM system (successor to the OPS versions) • The use of Hach WIMS became a corporate initiative, which allowed the organization to • evaluate the performance of each operation using consistent metrics • automatically consolidate data from all facilities • produce regulatory and internal compliance and key performance indicator reports. • United Water deployed a customized training curriculum to ensure all entities utilized the product consistently

12. Case Study 2: Maintain Process Control • Challenge: • The LEWWTP required a data management tool to provide critical operational reports on an hourly, weekly, monthly, and quarterly basis • As a recipient of an EPA Excellence in Wastewater Management award, LEWWTP desired an industry-leading software product to fulfill their extensive data management and reporting needs

13. Case 2: Maintain Process Control • Solution: • The Hach WIMS system informs the executive management team on the progress of the plant and provides reports to enable each of LEWWTP’s departments to gauge their daily, weekly, monthly, and quarterly performance • The system has been used as a project management tool to assist in the monitoring of the facility expansion, maintaining statistics throughout the construction, testing, and transition of the plant

14. Case Study 3: Conduct ‘Green’ Initiative • Challenge: • The City of Salem embarked on a multi-year pilot project to determine if a Natural Reclamation System (constructed wetland) could treat wastewater by using natural systems to polish the effluent • The project demanded data to qualify the use of full-scale wetlands and illustrate the benefit of the NRS to both the community and the environment • A data management product was required that could capture data from multiple sources, store the significant amount of data, and report the data in a format that could be easily used for numerous analyses

15. Case Study 3: Conduct ‘Green’ Initiative • Solution: • The City of Salem previously utilized Hach WIMS to collect existing operations and treatment process information to ensure compliance with federal and state regulations • With minimal modifications, Hach WIMS captured the necessary wetlands data to allow complete analysis and preparation of required reports (e.g. Water Pollution Control Federation permits) • Data collected included the amount of ammonia entering and exiting the wetlands; the levels of phosphorous, biochemical oxygen demand (BOD), metals, e-coli and annual sediment sampling; as well as many others including monitoring well data

16. Case Study 4: Integrate Multiple Systems • Challenge: • The City of Columbus stored laboratory and operations data in multiple locations and in various electronic formats • Staff dedicated numerous labor hours to manually prepare state regulatory compliance reports • Data was cumbersome to trend and use for predictive analysis • The City sought to improve data usage and operational efficiency and provide greater access of environmental data by other entities within the entire Department • A data management solution was required that satisfied the technical and informational objectives, as well as the stakeholders from the eight entities (laboratories, plants, and IT department)

17. Case Study 4: Integrate Multiple Systems • Solution: • The City of Columbus purchased Hach WIMS to integrate SCADA and laboratory data to automate the regulatory reporting process • Regulatory reporting time has been reduced by almost twelve (12) days through data provided via the Hach WIMS interface and its access to the Ohio EPA online report • Additionally, the system has enhanced the relationship between the entities and their stakeholders

18. Case Study 5: Utilize Commercial Product • Challenge: • MSD desired to replace their manual entry system with an automated system to collect data from all of the wastewater treatment plants, the associated SCADA and control systems, and their central Laboratory Information Management System to produce their federal and state regulatory reports • MSD contemplated paying for custom development, but needed an automated system immediately and without the burden of long-term maintenance of the software code

19. Case Study 5: Utilize Commercial Product • Solution: • After an extensive procurement process, MSD selected Hach WIMS based on its substantial reporting capabilities and its ability to interface with multiple systems • Complementing the system is the access to both online and personal customer support services, providing the ability to address issues in a timely manner

20. Summary of Hach WIMS Key Features System Designed for Ease of Use • Data entry forms created to look just like your organization’s paper forms • Templates provided for regulatory reports (SWTR, NPDES, DMRs, etc.) • Wizards available to generate additional reports, forms and graphs Data Available at your Fingertips • Readily accessible data for reports and analysis • Automatically transferred data from SCADA and LIMS systems • No more unsecured spreadsheets, islands of data, duplicate entries, etc. Access to Powerful Business Information • Operations easily monitored with dashboards and other analysis tools • Relevant data managed by set up of ‘exception’ reports • Operations optimized with accurate historical and short-term data

21. Hach WIMS is the Foundation of a Comprehensive Suite of Products Hach LAB Cal Lab data sample scheduling and tracking Hach JOB Cal Maintenance scheduling and tracking Hach WIMS Accurate Information Informed Decisions Data from automated and manual sources in a central, secure repository providing easy regulatory and ad hoc reporting, analysis and monitoring