ADaPT (Automated Data Processing Tool) is a Microsoft Access application used by the Division of Waste Management (DWM) to evaluate
analytical chemistry data from water, soil, and air samples. It checks for the completeness of data using method specific Quality
Control (QC) elements specified in the DWM library, and then further evaluates the data. For example, ADaPT evaluates all QC data reporting,
all QC that falls outside specific QC limits, and compares all lab quality control accuracy and precision information reported in the
Electronic Data Deliverable (EDD) against the criteria established in the DWM library. Further, it evaluates holding times and looks for
contamination in the samples collected for field equipment blanks. If QC problems (outliers) exist, and the laboratory has not assigned or
has incorrectly assigned the appropriate qualifiers, then ADaPT will add the necessary qualifiers to the associated sample results.
The following information and resources are applicable to all program areas within the DWM.
Download and install the latest version of the ADaPT software
DWM ADaPT Library of analytical methods and valid values
- Division of Waste Management Master Library (last updated 08/19/2014) -
The library contains DWM appropriate analytical methods for matrices and analytes, method required QC elements, and method specific QC element control limits.
- DWM Library Additions document -
provides details on the procedure for adding appropriate methods and analytes to the library
- DWM Library History -
provides a complete list of library modifications and additions
- Division of Waste Management Valid Values (last updated 08/19/2014) -
Valid values are used to validate data and identify methods, matrices, unique Client Analyte IDs, analyte names and QC elements specified in the DWM library,
and also contains all DWM Project Numbers (site/facility IDs) and Project Names (site/facility names), and all Florida Department of Health NELAC certified
laboratories and sample preparation methods. To update the valid values, right click the link and save to local drive.
- ADaPT DWM User Guide (working copy subject to change) -
contains information on how to install ADaPT, import data, check the data for completeness (and error check), evaluate data QC,
evaluate the data against various standards and criteria and prepare the data for export to upload to FDEP Oracle Databases
including REDD and WACS. The ADaPT Users Guide also includes reference information along with responsibilities and uses of ADaPT
by labs, consultants, permittees, and DEP staff.
- ADaPT FAQ
- ADaPT Error Check Guidance
Training and information resources
- ADaPT-L Listserv -
All ADaPT users should sign up for this list serve to automatically receive notifications on updates to ADaPT and
the DWM Library and stay up-to-date on any issues and changes. Notifications will direct you to the ADaPT homepage
so you can download new versions of ADaPT and/or changes to the DWM Library.
- ADaPT Training Video
provides a brief introduction of EDD processing
- ADaPT Training Opportunities
are available from LDC (Laboratory Data Consultants). This link is provided for informational purposes only. No
mandatory third party ADaPT training is required to use ADaPT, but some may find it helpful.
- For technical assistance with ADaPT software installation or troubleshooting, please contact:
Clark Moore, Operational and Program Performance
The DWM is comprised of three program areas: Permitting and Compliance Assistance, Petroleum Restoration, and Waste Cleanup.
Although there are many components of ADaPT that are applicable to the entire DWM, each program has its own requirements for
submittal of ADaPT deliverables. Specific requirements are given in the appropriate section of the ADaPT DWM User Guide referenced
above. Additional program-specific resources are provided below.
- Solid Waste ADaPT Program Requirements -
Guidance on preparation and submittal of EDDs to comply with Solid Waste Program requirements
- FDEP URLs for Solid Waste
- Hazardous Waste ADaPT Program Requirements
- ADaPT Field EDD Utility -
provided as a tool to help create corresponding ADaPT Field EDDs for ADaPT Lab EDDs submitted to the SW, HW, and UIC programs when
importing into the WACS Oracle database. This tool can help you create new Field EDDs, retrieve required information from imported
Lab EDDs, or modify existing Field EDDs. After the Field EDD is created, you can perform a data integrity check and export the
properly named Field EDD. Context sensitive help screens are available to guide the user through the process.
- Field EDD Worksheet -
provided as a tool that can be used for manually creating field EDDs and contains drop down menus and mouse-over messages helpful
in populating each data field. Please refer to the
on how to produce a field EDD using this spreadsheet.
- WACS Solid and Hazardous Waste Testsite Inventory
(Right click and save to local drive.)
Solid Waste Contact:
To be determined
Hazardous Waste Contact:
Camille Stein, Hazardous Waste Program & Permitting