1 / 18

2008 RETS REMP Conference Charlotte, NC June 23 – 25, 2008 Eric Darois, CHP

A Comprehensive Computer Application for Managing Sample Planning, Electronic Data Manipulation and Data Validation and Verification in Support of the MARLAP Principles. 2008 RETS REMP Conference Charlotte, NC June 23 – 25, 2008 Eric Darois, CHP Radiation Safety and Control Services, Inc.

brasen
Download Presentation

2008 RETS REMP Conference Charlotte, NC June 23 – 25, 2008 Eric Darois, CHP

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. A Comprehensive Computer Application for Managing Sample Planning, Electronic Data Manipulation and Data Validation and Verification in Support of the MARLAP Principles 2008 RETS REMP Conference Charlotte, NC June 23 – 25, 2008 Eric Darois, CHP Radiation Safety and Control Services, Inc. Stratham, NH 03885 www.radsafety.com

  2. The Problem • Your project starts off slow and grows exponentially • Sample results are flying in • Data kept in 5 different spreadsheets by 5 different people • Everybody is hand typing in results • The Chaos Grows…

  3. Where’s my Data ?!@#$ I think it’s here somewhere…

  4. MARLAP Iterative Data Life Cycle • Integration Impacts Cost and Success

  5. MARLAP Principles • Directed Planning • Analytical Protocol Specifications (APS) • Data Quality Objectives, DQOs • Measurement Quality Objectives, MQOs • Implementation • Sampling & Analysis • Data Quality Assessment, DQA • Verification • Validation

  6. Analytical Protocol Specifications, APS • Developed for each analysis type as a “short” document • Contents of Document • Required Analytes • Applicable Matrix (water, soil, vegetation, etc) • QC Frequency • COC Requirements • Applicable MQOs • Allows for effective V&V and DQAs

  7. Measurement Quality Objectives, MQOs • Considered the analytical portion of the DQOs • Project Specific (i.e. REMP may be different than GW Investigations) • Examples • Required Uncertainty at a defined Action level (i.e. at 200 pCi/L, 1 sigma uncertainty must be <20%) • MDA at Background • Detectability in the presence of interfering nuclides • Range of measurement • Report All Results (+ or -) with Uncertainty • May be Quantitative and Qualitative Statements

  8. MARLAP Roadmap

  9. MARLAP Implementation May Be Challenging To Implement For Large Continuous Projects RSCS Analytical Data Management System Designed to Manage MARLAP Principles

  10. Software/Database Environment • SQL Database • Coded in Visual Basic .net 2.0 framework • User-Friendly Screens • Adaptable to any sampling and analysis regimen RETS, REMP, NPDES, Chemistry, CERCLA, FSS, etc. • Manages data from multiple sites and multiple projects • Reports generated by Crystal Reports • Hierarchy of user access privileges protection on a site level • Tracks all changes made to old and new data • Stand-alone or fully networked computer installation • Automatic updates

  11. ADMS and MARLAP • Specify Quantitative DQOs and MQOs • Analytes/Labs/MDAs/DL -APS • Action Levels and Notifications • Alpha and beta error rates by project • Multiple Labs with different capabilities • Directed Sample Planning • Project Specific or Recurrent Scheduling (date or frequency weekly, monthly, quarterly, etc.) • Assigns Unique Sample ID • Collection Information (Who, What, When, Where) by Media Class • Chain of Custody Records (Fully Electronic) • Store ANY file into DB (pdf, html, doc, etc)

  12. ADMS and MARLAP • Data Quality Assessment, DQA • EDD Import (any CSV format!) • No more data input, No more typos • Data Verification on Import • Missing Analytes & Samples • Data Validation Reports • Sample Schedule Adherence • Analyte Trend Reports • RMU Reports • Individual & Group • Statistical Reports

  13. ADMS Standard Reports • Admin Reports • Action Level and Discrimination • Analysis Codes Summary Report • Lab Summary Report • Location Summary Report • Sample Reports • Sample Results • Chain of Custody • Assigned Sample Plan • Generate Barcodes Report • Histogram Report • Sample Plan (Uncollected Samples) Missed Frequency Report • Sample Status Report • Trend Report • Regression Analysis Report

  14. Histogram Reports 6 Bins 21 Bins, Same Data

  15. ADMS Barcode Report

  16. ADMS Key Additional Features • GPS Coordinates Optional – Each Sample Location • >800 Nuclides and Chemicals Pre-Loaded • Unit Conversions – Import and Unit and Convert to Desired Base • Duplicate Results Utility • Unlimited Action Level Types by Media • Fully Supports Sample Barcode Labels • Custom Import Format • Outputs suitable for export into reports or Spreadsheets

  17. Future Changes • Develop Separate Software for Field Collection • Current Version allows for Planned Samples to be “Assigned” for Collection • “Paperless” Environment

  18. Life with ADMS

More Related