United States Environmental Monitoring July 1991 Environmental Protection Systems Laboratory Agency P.O. Box 93478 Las Vegas NV 89193-3478 } ^ ^ j ,j_ ) p \ OFFICE OF RESEARCH AND DEVELOPMENT TECHNOLOGY SUPPORT PROJECT &EPA CADRE: A Data Validation Program INTRODUCTION The Environmental Monitor- ing Systems Laboratory - Las Vegas (EMSL-LV) has developed a computer software system to aid environmental scientists and data analysts in the evalua- tion of data generated by the Contract Laboratory Program (CLP). This system, CADRE (Computer-Aided Data Review and Evaluation) assists in the validation of results from various CLP methods. CADRE provides data analysts with a quick and reliable method for examining data that will be used for decision making at hazard- ous waste sites. The pro- gram automates the phases of data validation that involve electronic-format data. The data validation process involves comparison of quality control (QC) indicators used in the analysis with pre- established data quality criteria. Non-compliant cata are qualified with appropriate codes to indicate the severity of the defect. The final assessment of the data is made by the data reviewer, using the information pro- vided by CADRE. Examples of QC parameters that are checked by CADRE are: holding time, blanks, calibration, and precision. FEATURES CADRE can read data in several CLP electronic formats. It checks for data completeness, and allow the user to edit data. After the validation is complete, CADRE reports the results. CADRE can be customized by the user to validate data collected using several methods in the CLP. Users can configure CADRE to examine different compounds, alternate quantitation limits, or varying QC parameters. Another customization of CADRE involves changing data validation criteria to meet the needs of a modified method. The user can choose, for example, to allow a longer holding time if the compound of interest is unlikely to volatilize or degrade. The ability to modify CADRE'S specific data quality codes provides the user with greater flexibility and responsibility. To protect the data from tampering and from human error, a layered security system allows each user access to the program features he or she needs. The program blends ease of use with a sophisticated screen system. Knowledge of data validation rationale and microcomputer operation are recommended for the effec- tive use of CADRE. A user's guide, training courses, and technical user support are available from the EMSL-LV. CLP ORGANIC VERSION The CLP ORGANIC version of CADRE evaluates data from CLP analysis of volatile, semivolatile, and pesticide compounds. Volatile and semivolatile organic com- pounds are analyzed by gas chromatography/ mass spectrometry (GC/MS). Pesticide analysis is a GC method. CLP ORGANIC CADRE can be customized to evaluate modified versions of these routine analyses. It can use alternate data validation criteria selected by the user. Data can be read by CLP ORGANIC CADRE from the CLP Analytical Results Database (CARD) or from Agency standard format files. Checks performed by CADRE include: • quantitation limits • holding time • GC/MS tuning • calibration • internal standards • system performance • surrogate recovery • matrix spike recovery • precision of duplicates • contamination of blanks OB82EX91.OOC.FS ------- QUICK TURNAROUND METHOD VERSION The Quick Turnaround Method (QTM) version of CADRE reviews data ob- tained by the QTM methods. There are QTM methods available for VOC, PAH, phenols, pesticides, and PCB. These methods are based on the need for fast extraction and chromato- graphic analysis within 2 days. For speed and simplicity, QTM CADRE works in conjunction with other software for electronic data transmission from the laboratory to the user through the Agency communications network. QTM CADRE is completely automated. The data re- viewer needs only to set up the system and interpret the reports. ADVANTAGES AND LIMITATIONS The use of computerized data evaluation is changing the workplace for many data reviewers. The automation of routine checks will give the individual more time to thoughtfully interpret the results. It is anticipated that in- creased accessibility of computer hardware to personnel will lead to greater demand for programs like CADRE that will streamline routine work. Currently, CADRE is being developed for inorganic methods. Advantages Fast, complete, and consistent data validation Easy customization for modified methods Reduction of human error Automated report generation Limitations Requires availability of powerful computer for efficient use Reviewer judgement needed for some decisions Available for CLP organic and QTM methods only Needs complete data set in electronic format HARDWARE REQUIREMENTS Hardware requirements for using CADRE are: • IBM PC (or compatible) • MS-DOS (or equivalent) • Hard disk drive • 640 K RAM A math coprocessor chip is recommended but not required. For easy use, a mouse pointer is recommended. REFERENCE Simon, A. W„ J. A. Borsack, S. A. Paulson, B. A. Deason, and R. A. Olivero, Computer-Aided Data Review and Evaluation: CADRE CLP Organic User's Guide, U.S. EPA, June 1991. FOR FURTHER INFORMATION <$• t .§• I echnology ° o z O ^uPP°'t 0 ^ Project £ For further information on CADRE, contact: Mr. Gary Robertson U.S. Environmental Protection Agency Environmental Monitoring Systems Laboratory P.O. Box 93478 Las Vegas, NV 89193-3478 (702) 798-2215, FTS 545-2215 For information about the Technology Support Center at EMSL-LV, contact: Mr. Ken Brown, Manager Technology Support Center U.S. Environmental Protection Agency Environmental Monitoring Systems Laboratory P.O. Box 93478 Las Vegas, NV 89193-3478 (702) 798-2270, FTS 545-2270 ------- |