Transcript Slide 1
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 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 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 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 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 – iFix (formerly Intellution) • Wonderware – InTouch • Rockwell – RsView 32, RsView SE Systems are usually implemented by System Integrators who program the PLC’s, connect 4-20MA, 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. 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? 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 Hach WIMS Accurate, useful information Useable, Actionable, Reportable, Supportable Calculation Engine Field data Other • CMMS • USGS • EPA Third Party • Commercial Lab • Engineering Firms 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 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. 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 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 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 Maximo- IBM DatastreamSynergen 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 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 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 learn…Easy 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… 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.