Environmental Data Management Web Development Network Security IT Solutions

<< Back to previous page

Case Study 1

Quarterly Report for the Groundwater Monitoring Program

Client: Westinghouse Savannah River Company (WSRC)

Client Problem
The client needed to compile and publish the data resulting from the activities of the Savannah River Site (SRS) groundwater monitoring program. These data comprise hundreds of thousands of analytical results each quarter.

ExR Solution
We produced these reports quarterly, providing
    • A record of all program activities
    • Field notes on conditions affecting samples
    • A review of the analytical data to detect anomalies
    • A record of the flagging criteria
    • A list of the methods and detection limits used by the analytical laboratories
    • Statistical analysis and discussion of quality assurance/quality control results
We enhanced the production of these reports by
    • Outlining and implementing a process for automatically generating data tables from several data sources
    • Eliminating duplicate data entry
    • Developing macros to automate repetitive steps in data presentation and document formatting