Catherine Katsikis ckatsikisldcfl com LDCFL Inc Certified SBA
Catherine Katsikis ckatsikis@ldcfl. com LDCFL, Inc. Certified SBA (8 a) www. LDCFL. com 561 -512 -9956
Overview • • Introduction Automated Data Processing Tool (ADa. PT) Statewide Implementation Challenges Implementation Successes Accomplishments Future Summary
Introduction Why ADa. PT? • • Everglades Restoration, FDEP programs. Paper Data Reporting and Inconsistent edds. Data Assessment/Comparability. Data Scrutiny/Level II Validation. Data Transfer. Data Storage. Time consuming.
ADa. PT Automated Data Processing Tool Microsoft Access application for automated data review Commercial equivalent of USACE’s Automated Data Review (ADR) software
FL ADa. PT is a computer application that processes Electronic Data Deliverables (EDDs) based on field elements defined by the Florida DEP • Laboratory Data Deliverable, (LDD) – (includes Lab data with QC and Error check) • Program specific - Laboratory Receipt Deliverable – (includes Lab Receipt and some Field information) • Program specific - Field EDD (FDD) – (includes field methods and Error check)
FL ADa. PT performs an error check for correctness, and completeness of the edds. ADa. PT includes a technical consistency utility that performs the following cross and reversal checks: nutrients, total vs. dissolved, charge balance calculation, major ions vs. conductivity, TDS vs. conductivity, and analyzed TDS vs. calculated TDS.
FL ADa. PT performs a data review on the Laboratory Data Deliverable (LDD) that measures the integrity of sample results against associated laboratory quality control, holding times, and method detection limits.
FL ADa. PT The Automated Data Review evaluates the FL ADa. PT LDD and applies Validator’s data review qualifiers to sample results based on laboratory quality control results reported in LDD and project specific data review criteria specified in a project library, (Electronic QAPP). ALLOWS FOR PROFESSIONAL JUDGEMENT
FL ADa. PT Compares results against regulatory limits and/or permit limits
FL ADa. PT Process Sample Collection s e pl Data Generation Data Submittal LAB Regulated Entity or Consultant Results/QA/ Completeness check m a S Completeness Checker ADa. PT Lab EDD Sample Collection Team Fi eld ADa. PT Field EDD Da ta Consultant, Regulated Entity, or Lab Field Data/ Completeness check Data Review Data Upload To Database FDEP or Del. Auth. ADa. PT Completeness Checker Data Review WQ Limits Export to WACS Trial Add WACS Field EDD to FDEP Verify WACS facility. ID and WACS test-site ID are values populated in “Test-site Inventory Table” Field EDD ADa. PT Lab EDD Final data repository
FL ADa. PT
ADa. PT Valid Values • • Projects Analytical Methods Analytes Analysis Type Analyte Type Lab ID Lab Qualifiers Collection Agency • • Collection Method Matrix Preparation Type QC Type Libraries Location Code Program Type
ADa. PT Valid Values Menu for Solid Waste Field EDD • Storet Code – – – Client Analyte ID Parameter Name Units Total or Dissolved Field Measure Matrix • Field Parameter Qualifier Code • Report Type • Collection Method (Sample type code) • Solid Waste Testsite Inventory – – – WACS Facility ID WACS Facility Name County Number County Name District WACS Testsite ID WACS Testsite Name Status Well Type Water Classification Latitude Longitude
Lab EDD Error Report
Lab EDD Checks
Technical Consistency
QA/Validation Data Review
Compliance
Implementation Challenges • Stakeholders buy-in – Regulators, Laboratories, Consultants. • Laboratories – Most of the work, LIMS conformance/translations, learning curve, misconceptions, window looking into lab’s world. • Consultants – Misconceptions, learning curve, eye opener. • Regulators – We have always done this way, eye opener.
Implementation Successes • • Implemented in stages, giving labs time to comply. Successful implementation helped labs optimize and correct procedures. Training and technical support offered to labs and Data Users. Consultants, regulators become familiar with method requirements, regulations. Consistent naming conventions. Consistent edd submittals. Validated (Level II) data in databases.
FDEP Accomplishments
FDEP Accomplishments
FDEP Accomplishments
Information • http: //www. dep. state. fl. us/waste/categories/sh w/pages/ADa. PT. htm
ADa. PT-l - Listserv for ADa. PT Software, Bureau of Labs, subscribe at: http: //lists. dep. state. fl. us/cgi-bin/mailman/listinfo/ADa. PT-l
Accutest >1000 edds Jupiter Environmental Laboratories Inc. Advanced Environmental Laboratories Inc. - Orlando Florida Testing Services LLC dba Xenco Laboratories - Miami Test. America Tallahassee EMSL Analytical Inc. - FL Test. America Pensacola Kappa Laboratories Inc. II The Water Spigot Palm Beach Environmental Laboratories Inc. Analytical Services Corporation Test. America - Savannah Environmental Conservation Laboratories Inc. (ENCO) - Jacksonville Test. America - Mobile Columbia Analytical Services Inc. - FL Xenco Laboratories - Houston Test. America Orlando GEL Laboratories LLC Flowers Chemical Laboratories Test. America - North Canton Florida Radiochemistry Services Inc. Test. America Laboratories Inc. Pace Analytical Services-Florida >1000 edds Columbia Analytical Services Inc. - WA Environmental Conservation Laboratories Inc. (ENCO) - Orlando XENCO Laboratories - Atlanta PC&B Environmental Laboratory Inc. Environmental Science Corporation - TN Florida Analytical Inc. PACE Analytical Services Inc. - New Orleans Southern Analytical Laboratories Inc. Environmental Conservation Laboratories Inc. - Cary Benchmark Enviro. Analytical Inc. PACE Analytical Services Inc. - Huntersville PEL a division of Spectrum Analytical featuring Hanibal Technology Test. America Denver Test. America - Tampa Summit Environmental Technologies Inc. Sanders Laboratories Inc. - Nokomis Gulf Coast Analytical Laboratories Inc. Sun. Labs Inc. - Central Laboratory Environmental Testing and Consulting Inc. Lakeland Laboratories L. L. C. Pace Analytical Services Inc - Green Bay #1 Pace Analytical Services-Tampa Bay County Laboratory Services Short Environmental Laboratories Inc. Reedy Creek Improvement District Environmental Services Florida-Spectrum Environmental Services Inc. Lake County Water Resource Management Laboratory Everglades Laboratories Inc. Collier County Pollution Control and Prevention Department Laboratory >1000 edds Florida Testing Services LLC dba Xenco Laboratories - Boca Raton Kennedy Space Center Environmental Microbiology Laboratory Florida Testing Services LLC dba Xenco Laboratories - Miramar JEA Laboratory Services
Other State Users • South Florida Water Management District • South West Florida Water Management District • USACE • Counties, Cities
Future • Other FDEP Programs under evaluation • ADa. PT. net
Present ADa. PT Users • Receiving the Data • Validating the Data • Delivering the Data Is it easier? YES!!!!!!! Most of the manual Level II Data Validation is done by ADa. PT Naming Conventions, Methods, Units, Analytes, Project Requirements, Holding Times, Qualifiers, Method QC Requirements, MDLs/PQLs, Certified Lab ID, Dilutions, Sampling Dates, Lab Received Dates, Batch IDs, Consistency, Field methods, Comparison Reports, etc.
Summary ü The laboratory has met the requirements of the project. ü Level II QC is reported electronically with sample results. ü Awareness of QC requirements. ü Technical/balance review (Total vs. Dissolved, etc. ) ü Evaluates sample results based on linked QC results reported in the EDD. ü Able to control naming conventions (analytes etc. ) and keep consistent in data base. ü Able to check if all the methods and analytes were reported for the project. ü Applies validator’s qualifiers. ü Reduces data review costs. ü Able to pdf. or email ADa. PT generated reports ü Regulatory Comparison reports. ü Transfers final reviewed data to database. ü Paperless.
Questions
- Slides: 31