Water

1
Water Wastewater Data Management
AWPCA 2009 Conference July 28st, 2009 John
Dorner, PE Hach Company
2
Q What do you do for data management?

3
A We use excel!

4
Elements of the old style data management system
are
SCADA/HMII

Black hole
LIMS

• Operator log sheets

5
Typical black hole looks like this
Excel
Reports
Reports
Excel
SCADA/HMI
Excel
Analysis
Reports
LIMS
Excel
Reports
Operator log sheets
6
Water Wastewater Data Management

• Water and Wastewater Utilities need to analyze
  and report on a wide range of data sources
  including
• Lab (LIMS, outside Labs)
• Process (SCADA and historians)
• Field (Operator clipboards and log books)
• Plant Maintenance (CMMS)
• Miscellaneous (USGS, Weather, EPA )

7
Sources of data
Other
Field (30)
Third party
WIMS 20 calculated data
LAB (30
SCADA (15)
8
Laboratory Information Management System (LIMS)

• Typically produces 20 - 40 of the data for the
  Utility
• Sample Scheduling
• Sample Login and Tracking (Chain of Custody)
• Enter/Verify Results
• Report Results (Certificate of analysis)
• Instrument Interfacing
• QC Analysis

9
Commercial Off The Shelf (COTS) LIMS Vendors

• ATL SampleMaster, Bulldog http//www.atlab.com
• Perkin Elmer Labworks www.labworks.com
• LabVantage Sapphire www.labvantage.com
• Several others including Tribal, Labsoft, etc
• Based on the need to log in and track a large
  number of random samples from multiple sources
  referencing projects, quotes, purchase orders,
  promise dates
• Typically 100,000 to 500,000

10
Affordable LIMS for water utilities

• Databases MS SQL, Oracle, MSDE
• Bench sheets
• QC package
• 140 Math Toolbox functions
• Data qualifiers
• Sample notes
• State federal reporting

• Sample scheduling
• Interface to OPS
• One time reports invoicing
• Custom reports
• Chain of custody

11
Affordable LIMS for water utilities

• Hach LAB Cal LIMS

Based on the need to log in and track a known
number of scheduled samples. Typically 10,000
to 20,000
12
SCADA (Supervisory Control And Data Acquisition)

• Collects data from field devices such as
  PLCs/RTUs
• Allows Users to control devices, change set
  points in PLCs.
• Human Machine Interface (HMI) gives users a real
  time view of the process
• Alarms on real time conditions
• Logs data to Historians

13
SCADA HMI Example

• Collects data from field devices such as
  PLCs/RTUs
• Allows Users to control devices, change set
  points in PLCs.
• Gives users a real time view of the process

14
SCADA Vendors

• GE Fanuc iFix (formerly Intellution)
• Wonderware InTouch
• Rockwell RsView 32, RsView SE
• Systems are usually implemented by System
  Integrators who program the PLCs, connect
  4-20MA, and design the HMI Screens
• Typically 50,000 to 500,000.

15
Historians

• Logs Raw Data down to the millisecond from the
  SCADA system
• Offers open database for retrieval and
  analysis.
• Official record that cannot be changed.
• Buzzwords SQL, ODBC, OLE DB, Data Compression
• Typically comes with the HMI software

16
Water Information Management

• Combining the data from other systems which are
  typically islands or silos of data
• Perform calculations
• Produce regulatory and process analysis reports
• Ability to export to Excel
• Database management systems such as Oracle,
  Microsoft SQL Server, Access are the better
  approach

17
Spreadsheets vs Databases

• Spreadsheets have no multiuser ability
• Spreadsheets have no audit trail
• Difficult to perform calcs with data qualifiers,
  moving averages, etc
• Databases have an unlimited capacity (analyzing
  years of data is easy)
• Users spend hours copying/reentering data,
  preparing reports, troubleshooting data

18
There is no data integrity in a spreadsheet.

• Where did this number come from?
• Who changed my number?
• Why is this number different in this report?
• Am I liable for errors in regulatory reports?

19
WIMS Vendors

• Hach WIMS (formerly OPS SQL)
• Operator 10

20
Hach Water Information Management Solution (Hach
WIMS)
Accurate Information Informed Decisions
21
A central, secure repository for data from
multiple sources

• Reports and charts turn the raw data into
  information
• Accurate Information Informed Decisions

22
Your personalized dashboard
Provides your KPIs and commonly used tools.
23
More than 140 water specific functions in the
math tool box and look-up tables, CT, waste load
allocation
24
Save Time
Typical analyst can spend up to 10 days/month
chasing data.

• Who has the relevant data I need?
• Has it been verified?
• Does it correlate with all the other data
• Is everyone here to answer my questions
• I need nontraditional information to optimize,
  run efficient operations, projects, troubleshoot

Portland, Maine Data Scott Firmin
25
Improves your process
Its not just the instrument. Its the
combination of data from instruments and other
sources, combined in unique ways, that provides
insight

• Hach Sonatax can tell you the blanket height.
  WIMS can show you the relationship between
  blanket height, clarifier capacity, sludge age,
  wasting,
• Hach LDO Probes can tell you the aeration basin
  DO. WIMS can show when you fine bubble aeration
  has fouled by plotting BOD removed/KWHr.
• Hach 1720E Turbidimeter can tell you the filter
  turbidity.. WIMS can calculate the possible
  exceedance applying the EPA confirmation rule of
  two consecutive 15 minute readings above a
  threshold.

26
Summary

• Designed to be Easy to Use
• Data entry forms can be designed to look just
  like your paper forms.
• Templates for regulatory reports such as SWTR,
  NPDES, DMRs
• Additional reports, forms and graphs can be
  designed with easy to use wizards
• Data at your fingertips
• Reports and analysis data is readily available to
  the people who need it
• No more unsecured spread sheets, islands of data,
  duplicate entries
• Everyone has secured access to the data they need
• WIMS automatically transfers data from SCADA and
  LIMS systems
• Powerful Business Information
• Easily monitor operations with dashboards
• Optimize Operations with accurate historical and
  short term data
• Secure, easy access to trusted data
• Manage with relevant data by setting up
  exception reports
• Accurate regulatory reports

27
Hach Integrated Information Management Waste
Water, Drinking Water, Industrial Applications
OPS Systems, now a part of the Hach family, has
been helping you manage your data for 30 plus
years gt2000 water wastewater plants
Hach WIMSTM (Water Information Management
SolutionTM ) based on OPS SQL 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
28
Computerized Maintenance Management System
(CMMS)

• Work orders
• Work cost history
• Inventory purchasing
• Labor
• Instructions drawings
• Work requests
• Resource planning
• Asset management

29
Commercial Off The Shelf (COTS) CMMS Vendors

• Maximo- IBM
• Datastream-
• Synergen
• Many others including City Works, etc
• Based on the need for sophisticated management
  reporting and assuming strong technical support
  staf
• Typically 100,000 to multi-million

30
Affordable CMMS for water utilities

• Work orders
• Work cost history
• Inventory purchasing
• Labor
• Instructions drawings

31
Affordable CMMS for water utilities

• Hach JOB Cal

Based on the need to see what needs to be done
and keep a record of what is done. Typically
1,400 to 3,000
32
Hach Integrated Information Management Waste
Water, Drinking Water, Industrial Applications
Hach Water Information Management SolutionTM
(Hach WIMSTM) 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
Hach Computerized Maintenance Management
Solution (Hach JOB Cal ) Easy to set up Easy
to learnEasy to use Maintenance Scheduling and
Tracking Solution
Hach Laboratory Data Management Solution (Hach
LAB CalTM LIMS) Affordable, Effective Lab Data
Management Sample Scheduling and Tracking
Solution
With new interfaces to Hach Instruments LBOD, pH
33
Interactive, Color-coded Calendar

• A simple calendar easily manipulated
• Flexible scheduling of preventative work orders
• Track corrective work orders

34
Generate Work Orders

• Incorporate graphics, detailed instructions,
  manuals
• Print for all or just for specific workers
• Add as many details as you need
• Use portables for accuracy and flexibility

35
Document Your Work

• Document what you need to
• Who
• What
• Parts used
• Parts cost
• Labor hours

36
Generate Maintenance and Business Reports

• Equipment History
• Top Ten List
• Open work orders
• Equipment list
• ???

37
Questions
Go to http//www.opssys.com/instantkb/article.as
px?id12438 To download or review a copy of this
presentation.