Q What do you do for data management

Q: What do you do for data management?

A: We use excel!

Elements of the old style data management system are: SCADA/HMII LIMS Operator log sheets Black hole

Typical black hole looks like this: Excel… SCADA/HMI LIMS Operator log sheets Excel… Reports Excel… Analysis Reports Excel Reports

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 …)

Sources of data Other Field (30%) Third party WIMS 20% calculated data SCADA (15%) LAB (30%

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

Commercial Off The Shelf (COTS) LIMS Vendors q. ATL – Sample. Master, Bulldog http: //www. atlab. com q. Perkin Elmer – Labworks www. labworks. com q. Lab. Vantage – Sapphire www. labvantage. com q. 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

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

Affordable LIMS for water utilities q 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

SCADA (Supervisory Control And Data Acquisition) • Collects data from field devices such as PLC’s/RTU’s • Allows Users to control devices, change set points in PLC’s. • Human Machine Interface (HMI) gives users a real time view of the process • Alarms on real time conditions • Logs data to Historians

SCADA HMI Example • Collects data from field devices such as PLC’s/RTU’s • Allows Users to control devices, change set points in PLC’s. • Gives users a real time view of the process

SCADA Vendors • GE Fanuc – i. Fix (formerly Intellution) • Wonderware – In. Touch • Rockwell – Rs. View 32, Rs. View SE Systems are usually implemented by System Integrators who program the PLC’s, connect 4 -20 MA, and design the HMI Screens Typically $50, 000 to $500, 000.

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

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

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

There is no data integrity in a spreadsheet. q. Where did this number come from? q. Who changed my number? q. Why is this number different in this report? q. Am I liable for errors in regulatory reports? 18

WIMS Vendors • Hach WIMS (formerly OPS SQL) • Operator 10

Hach Water Information Management Solution (Hach WIMS) Accurate Information … Informed Decisions Lab Data • LIMS • Benchsheets • Commercial Lab Process data • • SCADA / Historian OPC, MODBUS, etc Dataloggers Operator logs • • Portables Log sheets Field data Other • CMMS • USGS • EPA Third Party • Commercial Lab • Engineering Firms Hach WIMS Accurate, useful information Useable, Actionable, Reportable, Supportable Calculation Engine Compliance & Verification Engine Dashboards

A central, secure repository for data from multiple sources Reports and charts turn the raw data into information Accurate Information … Informed Decisions

Your personalized dashboard… Provides your KPI’s and commonly used tools.

More than 140 water specific functions in the math tool box and look-up tables, CT, waste load allocation…

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 non–traditional information to: optimize, run efficient operations, projects, troubleshoot *Portland, Maine Data Scott Firmin

Improves your process It’s not just the instrument. It’s 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 1720 E 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.

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

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 >2000 water & wastewater plants Hach WIMSTM (Water Information Management Solution. TM ) 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

Computerized Maintenance Management System (CMMS) ü Work orders ü Work & cost history ü Inventory & purchasing ü Labor ü Instructions & drawings ü Work requests üResource planning üAsset management

Commercial Off The Shelf (COTS) CMMS Vendors q. Maximo- IBM q. Datastreamq. Synergen q. 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 $$$$

Affordable CMMS for water utilities üWork orders ü Work & cost history ü Inventory & purchasing ü Labor ü Instructions & drawings

Affordable CMMS for water utilities q 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

Hach Integrated Information Management Waste Water, Drinking Water, Industrial Applications Hach Water Information Management Solution. TM (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 learn…Easy to use Maintenance Scheduling and Tracking Solution Hach Laboratory Data Management Solution (Hach LAB Cal. TM LIMS) Affordable, Effective Lab Data Management Sample Scheduling and Tracking Solution With new interfaces to Hach Instruments: LBOD, p. H…

Interactive, Color-coded Calendar • A simple calendar easily manipulated • Flexible scheduling of preventative work orders • Track corrective work orders

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

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

Generate Maintenance and Business Reports • Equipment History • Top Ten List • Open work orders • Equipment list • ? ? ?

Questions Go to: http: //www. opssys. com/instantkb/article. aspx? id=12438 To download or review a copy of this presentation.