Testing Data Automated Template

US ARMY CORPS OF ENGINEERS SAN FRANCISCO DISTRICT

The Dredged Material Management Office (DMMO) is a multi-agency organization responsible for making suitability determinations for dredged material proposed for disposal in San Francisco Bay. Exa has led several phases of a long-term project to develop a website that could be used by multiple agencies to make regulatory decisions (http://www.dmmosfbay.org/). The first phase was to conduct and develop a Mission Needs Statement (MNS). Using the Needs Assessment as the foundation for the project, Exa worked on a multi-disciplinary team to design and develop the website, database, and supporting tools.

Exa designed, created and tested templates for the submittal of chemistry and bioassay data to the DMMO. These templates included automated QAQC routines to allow data providers to identify and repair data of unacceptable quality. The automated routines generate detailed error reports to allow data providers to review and repair errors. Additionally, the templates have functionality to automatically generate a report that summarizes QAQC results for the purpose of assessing data acceptability/quality during DMMO review of the data.