1 / 31

FL ADaPT: Automated Data Review Tool for Efficient Data Processing

FL ADaPT is an Automated Data Processing Tool for Electronic Data Deliverables, validating data accuracy and completeness, streamlining lab data assessment and transfer processes. The tool enhances data integrity by performing technical consistency checks and allows for professional judgment in data review. Implementing FL ADaPT has provided stakeholders with successful data processing solutions and improved compliance with regulatory limits. Explore FL ADaPT for optimized data management.

mikkelson
Download Presentation

FL ADaPT: Automated Data Review Tool for Efficient Data Processing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automated Tool for Data Review Catherine Katsikis ckatsikis@ldcfl.com LDCFL, Inc. Certified SBA (8a) www.LDCFL.com 561-512-9956

  2. Overview • Introduction • Automated Data Processing Tool (ADaPT) • Statewide Implementation Challenges • Implementation Successes • Accomplishments • Future • Summary

  3. Introduction • Everglades Restoration, FDEP programs. • Paper Data Reporting and Inconsistent edds. • Data Assessment/Comparability. • Data Scrutiny/Level II Validation. • Data Transfer. • Data Storage. • Time consuming. Why ADaPT?

  4. ADaPTAutomated Data Processing Tool Microsoft Access application for automated data review Commercial equivalent of USACE’s Automated Data Review (ADR) software

  5. FL ADaPT FL ADaPT 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)

  6. FL ADaPT ADaPT performs an error check for correctness, and completeness of the edds. ADaPTincludes 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.

  7. FL ADaPT ADaPT 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.

  8. FL ADaPT ALLOWS FOR PROFESSIONAL JUDGEMENT The Automated Data Review evaluates the FL ADaPT 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).

  9. FL ADaPT FL ADaPT Compares results against regulatory limits and/or permit limits

  10. to FDEP Field EDD ADaPT LAB Results/QA/ Completeness check Consultant, Regulated Entity, or Lab Field Data/ Completeness check Completeness Checker ADaPT Lab EDD FL ADaPT Process Data Generation Data Submittal Data Upload To Database Sample Collection Regulated Entity or Consultant FDEP or Del. Auth. ADaPT Samples Completeness Checker Data Review ADaPT Lab EDD Data Review Sample Collection Team WQ Limits WQ Limits Field EDD • Add WACS • Field EDD • Verify WACS facilityID • and WACS test-site ID • are values populated • in “Test-site Inventory • Table” Export to WACS Trial Field Data Final data repository

  11. FL ADaPT

  12. ADaPT Valid Values • Collection Method • Matrix • Preparation Type • QC Type • Libraries • Location Code • Program Type • Projects • Analytical Methods • Analytes • Analysis Type • Analyte Type • Lab ID • Lab Qualifiers • Collection Agency

  13. ADaPT Valid Values Menufor 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

  14. Lab EDD Error Report

  15. Lab EDD Checks

  16. Technical Consistency

  17. QA/Validation Data Review

  18. Compliance

  19. 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.

  20. 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.

  21. FDEP Accomplishments

  22. FDEP Accomplishments

  23. FDEP Accomplishments

  24. Information • http://www.dep.state.fl.us/waste/categories/shw/pages/ADaPT.htm

  25. ADaPT-l - Listserv for ADaPT Software, Bureau of Labs, subscribe at: http://lists.dep.state.fl.us/cgi-bin/mailman/listinfo/ADaPT-l

  26. >1000 edds >1000 edds >1000 edds >1000 edds

  27. Other State Users • South Florida Water Management District • South West Florida Water Management District • USACE • Counties, Cities

  28. Future • Other FDEP Programs under evaluation • ADaPT. net

  29. Present ADaPT 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 ADaPT 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.

  30. 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 ADaPT generated reports • Regulatory Comparison reports. • Transfers final reviewed data to database. • Paperless.

  31. Questions

More Related