Hach%20Water%20Information%20Management%20Solution%20(WIMS)%20Overview

1
Hach Water Information Management Solution (WIMS)
Overview
2
Use Data to Reduce Costs
3
Hach Water Quality Experts

• 75 years of water analytics expertise
• Industry innovator 500 patents over 130 patent
  families
• Local service, online chat, life-time technical
  support

On-line instrumentation High-quality prepared
reagents Information management software Accurate
laboratory portable devices
4
Hach Integrates Information Management
Hach LAB Cal Affordable, Effective Lab Data
Management Lab data sample scheduling and
tracking
Hach JOB Cal Easy to set up Easy to learn Easy
to use 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
5
Buried in Data?
Make it Meaningful!

• Dont get slowed down by
• Piles of paperwork
• Time-consuming reports
• Mind-numbing calculations

Hach Water Information Management Solution
6
The system has resolved our key issues of data
consolidation and integrity. It is currently
used by all treatment plant managers in their
daily analysis of plant operations and produces
all required federal and state regulatory
reports.
Bob Zinkl Information Systems Metropolitan St.
Louis Sewer District, MO
7
Make Performance Decisions Confidently

• See the complete picture of your water and / or
  waste water system
• Hach Water Information Management Solution (Hach
  WIMS)
• Tailor-made for the water industry
• Data is accurate secure
• Easy-to-understand dashboards
• Trends analysis charts
• What-if models
• Internal and regulatory reports

8
Water Industry Data ManagementCurrent Solutions
LIMS SCADA

• LIMS

SCADA

• LIMS SCADA are the most common Data Management
  systems in the Water industry
• Each is designed to manage different aspects of
  the operation
• Neither can easily provide the overall view of
  the Water operation

• Designed for process control data acquisition
• Controls processes provides excellent overview
  of data acquired from the processes
• Not designed to acquire and track data that is
  not part of the process (ex. Lab or Field data)
• Requires programming to create reports

• First created for pharmaceutical industry
• Used by Labs, not generally tied to data outside
  the Lab
• Used to organize and analyze data from a wide
  number of lab data sources
• Reports can be highly customized

Plus not all facilities need or can afford
either solution
9
Water Industry Data ManagementCurrent Solutions
- Excel

• LIMS

SCADA

• Excel

• Designed for process control data acquisition
• Controls processes provides excellent overview
  of data acquired from the processes
• Not designed to acquire and track data that is
  not part of the process (ex. Lab or Field data)
• Requires programming to create reports

• First created for pharmaceutical industry
• Used by Labs, not generally tied to data outside
  the Lab
• Used to organize and analyze data from a wide
  number of lab data sources
• Reports can be highly customized

• Commonly available software program
• Easy to manually enter data from different
  sources (lab, field, sometimes SCADA)
• Easy for standard formats that can be shared with
  others
• Can graph data without separate programming

10
Why Excel is not Good EnoughSome things to
consider

• Its easy to overwrite cells in Excel
• How are you protecting your data and formulas to
  prevent an accidental change?
• Do you have any audit trails on the data to
  indicate when and why a cell had been changed?
• Excel has limitations on the amount of data it
  can hold
• Do you have different files for your current and
  historical data?
• Excel can import data but requires advanced
  programming to format it
• How is your data added to your Excel file and how
  long does it take?
• If the data being imported needed to change, who
  will be able to make the change?
• Manipulating and reorganizing data once it is
  loaded into Excel can be difficult
• How long does it take to pull together your data
  when you need a non-standard report?
• Are you able to get all the value from your data
  because its too difficult to further analyze?
• How often do you want to look at the same data in
  different ways (e.g. different time frames,
  different comparisons)?
• Excel does not automatically back up data or
  provide version control
• What would happen if someone accidently deleted
  your file?
• How do you assure revision control?

• How do you make sure that you have and are using
  accurate information?
• How do you manage changes to the file or files?
• How much effort is needed to do a non-standard
  analysis or report?

11
Water Industry Data ManagementThe Right
Solution

• Hach Water Information Management Solution

• Designed specifically for water management with
  100 common Drinking Water and Wastewater
  calculations and report templates for the most
  common regulatory reports such as SWTR, NPDES,
  DMRs
• Data captured from all types of data sources
  including SCADA, Lab, Field
• Data secured in a centralized database that can
  be accessed locally or via a web interface
• Audit trails and historical records are safe and
  available for easy viewing
• Custom dashboards display your key information
  with shortcuts to the data and reports you need.
• Easily configure graphs for trend analysis,
  correlations, and control charting.

• LIMS

SCADA

• Excel

• First created for pharmaceutical industry
• Used by Labs, not generally tied to data outside
  the Lab
• Used to organize and analyze data from a wide
  number of lab data sources
• Reports can be highly customized

• Designed for process control data acquisition
• Controls processes provides excellent overview
  of data acquired from the processes
• Not designed to acquire and track data that is
  not part of the process (ex. Lab or Field data)
• Requires programming to create reports

• Commonly available software program
• Easy to manually enter data from different
  sources (lab, field, sometimes SCADA)
• Easy for standard formats that can be shared with
  others
• Can graph data without separate programming

12
Looking to the Next Few Years

• 45 utilities report 60 workforce retirement
  over next 5 years
• Increasing desire to optimize operations, not
  just meet regulatory compliance
• Mandates for integrated water information
  management
• Already a mandate by CH2MHill/OMI, United Water
  Veolia
• Engineering firms have engineers focused
  exclusively on data management
• Excel will not be acceptable as a primary data
  repository
• Growing need to have information (rather than
  just data) to make decisions and be proactive and
  predictive
• Instruments connected directly to PCs or
  web-hosted software to provide bi-directional
  control, data visualization, process optimization
  and reporting
• Increasing importance of water distribution
  system quality and growing prevalence of smart
  water grid

Data information management systems are better
equipped to handle these new requirements
13
Key Features Summary

• Designed to be Easy to Use
• Data entry forms designed to look just like your
  paper forms
• Templates for regulatory reports such as SWTR,
  NPDES, DMRs
• Wizards help easily design additional reports,
  forms and graphs
• Data at your fingertips
• Data readily available for reports and analysis
• No more unsecured spreadsheets, islands of data,
  duplicate entries
• WIMS automatically transfers data from SCADA and
  LIMS systems
• Powerful Business Information
• Easily monitor operations with dashboards and
  other analysis tools
• Optimize Operations with accurate historical and
  short term data
• Manage with relevant data by setting up
  exception reports

14
Integrated with Water Market Leaders

• Aligned with Leading SCADA manufacturers
• Electronic data transfers from GE, Wonderware,
  Rockwell, etc.
• Partnership with ATL Sample Master
• 30 of US LIMS water market
• Integrated with Hach Process and Lab
  Instrumentation
• Industry leader for water quality instrumentation
• Recommended and sold by ECs and SCADA
  Integrators
• Includes CDM, HDR, CH2M Hill, and IPS
• Contracts with major water companies
• Veolia, United Water, American Water, etc.

Water market leaders value comprehensive data
information management systems for comprehensive
analysis and data security
15
Hach Integrated Information Management has a
strong foundation

• Based on OPS Systems 30 years of experience
  developing software for the water industry
• The only patented web-based delivery of water
  focused information management solutions(based
  on patents acquired from WaterEye)
• Hachs wide array of instruments, water analysis
  expertise, and commitment to customer service

16
Hach Integrates Information Management
Hach LAB Cal Affordable, Effective Lab Data
Management Lab data sample scheduling and
tracking
Hach JOB Cal Easy to set up Easy to learn Easy
to use 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
17
Hach LAB Cal Lab Data Management

• Schedule and track lab samples with a visual
  calendar
• Enter data with electronic benchsheets
• Use built-in standard methods libraries

• Assure data security and secure data access
• Use Reporting analysis tools
• Get simplicity for managing lab tasks

18
LAB Cal Regulatory Laboratory Reports

• Available Reports
• Chain of Custody
• Certificate of Analysis
• Quality Analysis/Control
• Missing Sample
• Exception Reports

Reporting made easy only a mouse click away
19
Hach Integrates Information Management
Hach LAB Cal Affordable, Effective Lab Data
Management Lab data sample scheduling and
tracking
Hach JOB Cal Easy to set up Easy to learn Easy
to use 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
20
Hach JOB Cal Maintenance Scheduling Tracking

• Designed for maintenance people
• Easy to set up
• Easy to learn
• Easy to use
• Status at a glance
• Familiar format and process

• JOB Cal Basic
• Automatically builds an interactive, color-coded
  calendar for easy management of job activities
• Tracks just the basics of work order

• JOB Cal Plus
• Allows you to track more detail
• Inventory, vendors and purchasing
• Who did the work and how long did it take
• Display equipment drawings or pictures.

21
JOB Cal At a Glance Calendar Shows
Easy to understand color codes
Whats due
Whats done
Whats late
Whats really late
Skip it
22
Compile Data Easily

• More data is not better unless you can do
  something with it

23
The Hach WIMS product has been instrumental in
the collection of relevant data. Its data
capture and reporting capabilities have provided
us a comprehensive analysis of our wetlands pilot
project.
Stephanie Eisner Natural Reclamation System Proj.
Coordinator City of Salem, WA
24
See Your Whole Operation Combine Data From
Field, Lab Operations

• Instant access to data, reports, entry forms,
  audit information
• Data organized for easy interpretation
• Track dosages, flows, concentration, summarized
  data like daily average flow, 15 minute turbidity
  maxi, hourly DO min

25
Easy Data Entry Organizes Information for Fast
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

26
Accurate Information - Securely Stored

• Data comes together in a central database
• Easy access, local or over secure Web
• Safe and secure storage of historical records
• Data entered one time, minimizing errors
• Audit trails maintained

27
Automate Complex Calculations

• With 100 built-in formulas, you can stop
  worrying about making mistakes in complex
  calculations

28
We love this software. I have the time to give
this reference because I have the software!
James Grandstaff Division Director Henrico County
Water Reclamation Facility, VA  
29
You Dont Need to Be a Statistician

• Built-in equations and verification engines
• Easily add additional formulas
• Calculate and track just about anything
• Error and worry free
• Get consistent results based on EPA requirements

Error and worry free built-in calculations
provide data consistency
30
Example of Built-in Complex F-to-M Ratio
This cell result based on this formula
31
Impact of Quick Accurate Calculations

• Trust that data is accurate and consistent.
• Decisions are based on accurate data
• Troubleshoot system upsets
• Analyze cost overruns
• Check compliance issues
• Identify opportunities for cost reduction

Find errors in formulas
Edit or alter formulas if needed or required
32
Troubleshoot Issues

• Intelligent alerts, modeling tools and audit
  trails all help you resolve, predict and prevent
  disruptions

33
Hach WIMS is central to everything that the
LEWWTP does. Each system that the LEWWTP has
provides data into Hach WIMS. It is essential to
our process decisions.
Brenna Durkin DBA Specialist Littleton/Englewood
Wastewater Treatment Plant
34
Let Software do the Detective Work

• Assimilate information and find answers to
• System upsets
• Cost overruns
• Compliance issues
• Customer complaints
• Use predictive modeling tools to prevent future
  issues from occurring
• Develop "what if" scenarios
• Perform simple or complex search queries
• Find the exact information you need

35
Automatically Compare Verify All Info
Flags problems so you know exactly where they
occurred
Immediately identifies change in the system
36
Maintain Accurate Records with Audit Trails
Audit trails show who touched the data
37
Data Exception Reports Help Manage Anomalies
38
(No Transcript)
39
Event Reports Provide Highlight Key Information

• Generated automatically
• Monthly report for all violations
• QC control limit flags
• Entry limit flags

40
Monitor Improve Performance

• Get the data you need instantly in easy-to-read
  formats so you can make decisions quickly

41
Hach WIMS has fostered analysis beyond
regulatory data. Information on pumping
stations, energy usage, material usage, and cost
analysis are just a few of the trends performed
to enhance optimization. The new question is
not Can we analyze the data? but Which data do
you want to analyze?
Gwinnett County, GA
42
Get Your Data Fast for Faster Decisions

• Personalized dashboards let you monitor key data
• Immediately shows the information you need to
  know
• Provides shortcuts to other parts of the software
• Allows quick access to reports, graphs, entry
  forms
• Can be customized to the user

43
Graph Pac Provides Visual System-wide Overview
Multiple graphs for your key performance
indicators generated with a click of a button
44
Chart Data Points for Easy Analysis

• Reporting and graphing tools
• Configure graphs for trend analysis,
  correlations, and control charting
• Easily compare different sets of data to identify
  cost reduction opportunities
• Use preprogrammed templates, wizards, and
  built-in calculation tools
• Simplify report generation
• and data analysis

Ex. Raw Turbidity Daily Avg, Daily Min, Daily Max
45
Example Monthly Average Report for Specified
Variable
Automatically calculates for specified variable
for fast analysis
46
Data Views Provide Easiest Visualization
47
Prepare Regulatory Internal Reports

• Create reports in seconds and then schedule them
  to print or email automatically

48
The biggest advantage in our implementation of
Hach WIMS is the automation of our reports.
Reports that typically would take weeks at a time
to prepare, now only take us a matter of a few
hours. Additionally Hach WIMS fills a much
needed gap. Our Operations Department now has
access to data that allows them to make
adjustments within their operational parameters
in hours instead of days.
Peter Chang, System Engineer III King County, WA
49
Turn Raw Data into Actionable Information

• Eliminate reams of paper
• Create business and regulatory reports in seconds
• Schedule automatic report output to the screen,
  printed or by email
• Utilize EPA and state report templates SWTR,
  DBR, NPDES, DMR, eDMR, MOR, SDWA, CCR, industrial
  pretreatment compliance, and more
• Configure standard reports with a few keystrokes
  using templates and wizards
• Develop ad-hoc reports in minutes

50
Accurate Regulatory Process Reports Graphs
Drinking Water
Create paper and electronic reports for Waste
Water and Drinking Water for each state
51
Powerful Information at your Fingertips
Waste Water
Example Discharge Monitoring Report
Example Inflow/ Infiltration Study
52
Case Studies
53
Case 1 Improving Aeration Efficiency
Oxygen transfer efficiency is a function of
bubble size. The smaller the bubble, the higher
the efficiency. Ceramic or membrane diffusers
will foul in time, causing the bubble size to
increase. To minimize energy used and reduce
downtime, it is important to determine when
diffusers need to be cleaned.
Clients use WIMS to determine cleaning cycle by
benchmarking pounds of BOD removed per KW of
electricity used.
54
Case 2 Lowering Chemical Costs
In the chart of raw and settled water turbidity
against alum dosage (obtained by using graphing
tools in WIMS), the client recognized that
increased alum dosing (circled) did not improve
settled water turbidity. This led to an
opportunity to save up to 10 percent in alum
dosage.
55
Case 3 Real-time estimation of BOD
The time-lag in obtaining BOD results, a 5-day
lab test, make it challenging for plant
operations to adjust treatment processes to
adverse levels of BOD. By using powerful
statistical tools built into WIMS, a
site-specific correlation between on-line UV
absorbance against lab BOD measurements was
obtained. The client can now estimate BOD in
real-time, allowing for the optimization for
treatment processes and avoid potential
violations.