An Interactive Excel Spreadsheet To Calculate Time-Varying Efficiencies for Pump-and-Treat Wells
This spreadsheet is currently being used at two operating units of a contaminated site.
In the first operating unit, water levels in an unconfined aquifer respond to pumping, and fluctuating stage in a neighboring river. Here, the spreadsheet is used to calculate efficiencies for 160 pump-and-treat wells. The second operating unit is inland and not impacted by the fluctuations in the river stage. However, the pumping wells in this operating unit are periodically cleaned resulting in sudden increases in well efficiencies. The spreadsheet tool was successfully able to model the water levels and efficiencies at these pumping wells after factoring in the maintenance history.
This spreadsheet tool can be used at other contaminated sites, provided, the local geology and hydrological processes are consistent with the underlying theoretical assumptions. The interactive and visual nature of the tool enables better communication with stakeholders and regulators.