IntroductionWe implemented the widely-used CXTFIT code in Excel to provide flexibility in analyzing multiple tracers experiment data, and added sensitivity and uncertainty analysis functions to facilitate multi-model analysis. We are adding more analytical solutions (e.g., two-well test, pumping tests) for contaminant fate and transport studies.
- CDE and MIM to solve 1d equilibrium/non-equilibrium convection dispersion equation (Tang et al. 2010)
- LMRM and LMRMT to calculate leaching mass ratio (Shackelford and Glade 1997)
- CXRTCylinder to solve 3d diffusion equation for a cylinder (Anders et al. 1978). Download the implemented Excel file in Excel 2003 or Excel 2007 or application to Spalding and Brooks 2005 Excel 2003 or Excel 2007 for leaching data analysis.
- CXYTPatch to solve 2d convection dispersion equation for a patch source (Cleary and Ungs 1979; Javandel et al. 1984). Download .
- CEWT and CXYT to calculate concentration in the extraction well and a monitoring well due to injection in an injection well (Welty and Gelhar 1994, Tang et al. 2011 ) Download
- CNAPL to calculate DNAPL concentrations with depleting source, biodecay, and violatilization (Parker et al. 2008)
- IslandMounding to calculate transient mounding in circular island water table aquifer (Basak 1982). Download the implemented Excel file for Excel 2003 or Excel 2007.
- Finite difference solution for saturated flow (MODFLOW). Download Examples in Anderson and Bair 2001 .
- Optimize: minimizes objection function by adjusting values in the parameter range using Solver
- Analyze: calculates and outputs Jacobian (if selected), standard deviation, and correlation matrix
- Solve: combines Optimize and Analyze
- GetJacobianMatrix: calculates and outputs Jacobian matrix
- Propagate: calculates parameter error propagation predictions using the first order method
- CalculateResponse: calculates response surface for two selected parameters
- MonteCarloAnalyze: calculates the objective (or merit) function values for a large number of selected parameter values
- Multiple tracer data can be simultaneously analyzed for multiple locations and times
- Any parameter with any transformations can be analyzed with uncertainty and sensitivity quantification
- Observation errors can be incorporated into the weighted non-linear least squares method
- Prior information can be included as a penalty function in the objective function
- Users are able to change selected parameter values and view the results via embedded graphics
The code was verified by comparing with a number of forward and inverse solutions in CXTFIT 2.0
The code was applied to reanalyze data from the literature as well as new data
Although we are comfortable with sharing these spreadsheets and codes, we cannot guarantee that they are free of error. If you find what appears to be an error, please contact us at your earliest convenience. You are welcome to regularly check the web site for updates and/or corrections.
last modified: 12/20/2012