Section 1: Introduction
This is a step-by-step guide for the CXTFIT/Excel. The column experimental data in example Fig. 7.9 in Toride et al. (1995) are used for demonstration. Instruction is given to:- Fit 3H2O breakthrough curve
- Fit 3H2O and B breakthrough curves simultaneously
- Conduct sensitivity analysis to assess the impact of velocity, pulse, and dispersivity for the convection dispersion model equation (CDE) model prediction for 3H2O
- Propagate parameter uncertainty to prediction uncertainty for 3H2O breakthrough
- Run Monte Carlo analysis for the non-equilibrium convection dispersion equation (MIM) model for 3H2O to investigate the global sensitivity of dispersivity, mobile water fraction, and mass transfer coefficient
- Calculate response surface for 3H2O breakthrough curve simulation with MIM
- Use weighted non-linear least squares method to incorporate prior information for parameter estimates and analytical error for observations
- Use numerical integration options for non-equilibrium model with example Fig. 5.1
- Import code and configure Excel file from scratch
- Use CXTFIT/Excel in Excel 2007
It is recommended that the user start with a blank CXTFIT/Excel file. In which the CXTFIT menu is added, code is incorporated, and Solver is configured. Besides basic Excel operations to input data and formula, the key in using CXTFIT/Excel is to use the two functions (CDE and MIM) to solve the transport equations, and run the Macros through menu CXTFIT. Use of Excel names can simplify the operation but is not required. In the end, we describe the distribution file list, and how to import the code and configure the Excel file from scratch. Most of the tutorial is based on Excel 2003. Issues are addressed in the end for the use of CXTFIT/Excel in Excel 2007.