Oil Remediation Tracking
Depth analysis of soil contamination. Recording and tracking of soil removal amounts. Chain of custody documentation for government reporting.
Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA).
Small business.
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
PCG founded 1995. All project details drawn from PCG's internal documentation. Client identity withheld at client request.
