Oil Remediation Tracking Database for Superfund Soil Compliance

Last updated: April 2026
An environmental soil remediation company was tracking a Superfund site cleanup across hundreds of spreadsheets with no unified system for depth analysis, removal amounts, or chain of custody documentation. Government agencies required certified reports at every step of the process. PCG converted the spreadsheet data into an empirical Microsoft Access database covering every square foot of the site, with full remediation tracking, removal documentation, and compliant reporting for regulatory submission.
Project requirements

Depth analysis of soil contamination. Recording and tracking of soil removal amounts. Chain of custody documentation for government reporting.

Languages and database

Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA).

Company size

Small business.

Industry

Environmental compliance / regulation.

❓ What problem did this project solve?

Superfund site remediation is one of the most documentation-intensive environmental compliance processes in the United States. Every square foot of contaminated soil has a testing history, a contamination depth estimate, a removal record, and a chain of custody that has to be maintained from excavation through disposal. The government agencies overseeing the cleanup require certified reports at each stage, and those reports have to match the physical record precisely.

This client was managing that entire process across hundreds of individual spreadsheets. The testing data, the depth calculations, the removal tracking, and the reporting were all separate. There was no single view of the site, no automated formula application across the matrix of plotted areas, and no way to produce a compliant government report without manually pulling data from multiple files. As the remediation progressed and the data volume grew, the spreadsheet approach was not going to hold.

🛠️ What PCG built

PCG imported the hundreds of existing spreadsheets into a structured Microsoft Access database, creating formulas and analytical programming that applied consistently across the full site matrix. The result was an empirical database covering every square foot of the Superfund site with complete remediation data: contamination depth estimates, soil removal amounts, removal tracking, and chain of custody documentation linked through the full process.

The reporting layer produced the certified documentation government agencies required at each step of the remediation. Removal and remediation accreditation data was tied directly to the underlying database records, so every report reflected the actual physical progress of the cleanup rather than a manually assembled summary. For a process this heavily regulated, that link between the operational data and the official record is not optional. It is what makes the certification defensible.

🔍 Technology used

Microsoft Access Microsoft Excel Visual Basic for Applications (VBA) Spreadsheet to database migration Chain of custody tracking Government compliance reporting Site matrix data management
Managing environmental remediation, compliance tracking, or government reporting in spreadsheets that are no longer keeping up? PCG has built environmental compliance systems since 1995. The $2,500 diagnostic engagement scopes the problem before any development begins.
Talk to PCG

PCG founded 1995. All project details drawn from PCG's internal documentation. Client identity withheld at client request.

Frequently Asked Questions

Yes. PCG built an empirical database covering every square foot of a Superfund site for an environmental soil remediation company. The system tracked depth analysis, soil removal amounts, chain of custody documentation, and generated the formal government reports required at every stage of the remediation process. If your operation needs custom tracking software for an environmental remediation project, the first step is a free 30-minute consultation.
Yes. That was exactly the starting point for this project. Hundreds of spreadsheets had to be imported, formulas created, and data stored in a structured database for analytical processing. PCG handles the full conversion: importing the spreadsheet data, mapping it to a relational database structure, validating that the formulas and calculations carry over correctly, and building the reporting layer on top. The result is a single system where the data is accurate, traceable, and ready for government reporting.
In a Superfund remediation context, chain of custody documentation tracks contaminated soil from the point of removal through transport to its final disposal location. Every transfer is recorded with dates, quantities, responsible parties, and destinations. The system PCG built created a traceable record for every cubic yard of soil removed from the site, producing the certified documentation government agencies required to verify that remediation was performed correctly and completely.
Superfund sites operate under EPA CERCLA regulations, which require documentation of site assessment, remedial action, soil removal quantities, disposal records, and ongoing monitoring. State environmental agencies typically have parallel reporting requirements. The system PCG built generated formal reports for every step of the removal process, providing the certified results multiple government agencies required to confirm that remediation accreditation standards were met.
Yes. PCG migrates Access and Excel-based environmental compliance systems to modern .NET platforms regularly. For remediation tracking specifically, the migration preserves the full historical record of the site, all chain of custody documentation, and all calculation logic. The government reporting outputs the system currently produces are rebuilt and validated in the new platform before the old system is retired. Nothing in the compliance record is lost or altered during the transition.

Related Projects

Regulation Compliance Projects - EPA Title V Air Quality Management Application
EPA Title V Air Quality Management

Regulation Compliance/