Skip to main content
U.S. Department of Energy
Office of Scientific and Technical Information

A Spreadsheet Program for Two-Well Tracer Test Data Analysis

Journal Article · · Ground Water
 [1];  [1];  [2];  [1]
  1. Oak Ridge National Lab. (ORNL), Oak Ridge, TN (United States). Environmental Sciences Division
  2. Univ. of Tennessee, Knoxville, TN (United States). Dept. of Civil and Environmental Engineering

Two-well tracer tests are often conducted to investigate subsurface solute transport in the field. Analyzing breakthrough curves in extraction and monitoring wells using numerical methods is nontrivial due to highly nonuniform flow conditions. Here, we extended approximate analytical solutions for the advection-dispersion equation for an injection-extraction well doublet in a homogeneous confined aquifer under steady-state flow conditions for equal injection and extraction rates with no transverse dispersion and negligible ambient flow, and implemented the solutions in Microsoft Excel using Visual Basic for Application (VBA). Functions were implemented to calculate concentrations in extraction and monitoring wells at any location due to a step or pulse injection. Type curves for a step injection were compared with those calculated by numerically integrating the solution for a pulse injection. The results from the two approaches are similar when the dispersivity is small. As the dispersivity increases, the latter was found to be more accurate but requires more computing time. The code was verified by comparing the results with published-type curves and applied to analyze data from the literature. In conclusion, the method can be used as a first approximation for two-well tracer test design and data analysis, and to check accuracy of numerical solutions. The code and example files are publicly available.

Research Organization:
Oak Ridge National Laboratory (ORNL), Oak Ridge, TN (United States)
Sponsoring Organization:
USDOE Office of Science (SC), Biological and Environmental Research (BER) (SC-23)
DOE Contract Number:
AC05-00OR22725
OSTI ID:
1037060
Journal Information:
Ground Water, Journal Name: Ground Water Journal Issue: 4 Vol. 50; ISSN 0017-467X
Publisher:
Wiley - NGWA
Country of Publication:
United States
Language:
English

Similar Records

A Microsoft Excel Program for Two-Well Tracer Test Data Analysis
Journal Article · Sat Dec 31 23:00:00 EST 2011 · Ground Water · OSTI ID:1047002

Tracer transport modeling of the doublet well system
Technical Report · Fri Jul 01 00:00:00 EDT 1994 · OSTI ID:34248

Multiple-peak response to tracer injection tests in single fractures: A numerical study
Journal Article · Thu Aug 01 00:00:00 EDT 1991 · Water Resources Research; (United States) · OSTI ID:5963737

Related Subjects