| Homepage | Research | Publications | Software | Teaching | Prospective Students | KU Hydrogeology |
Page Contents
- Disclaimer
- Spreadsheet for calculating piezometric surface gradient and direction
- Compiled fortran programs using simplex optimization for biodegradation kinetics
- Excel spreadsheet to calculate and compare approximations of the error function
- Excel spreadsheet that performs Monte Carlo simulations on a 3D plume
- Excel spreadsheet to assist PVP data processing
Disclaimer
The software available for download on this page is provided free of charge on an "as is" basis. Users may copy,
and distribute the software for free, but they may not sell it. The software comes with no written or implied
guarantees and the author accepts no responsibility for any errors or other problems that arise from its use.
To download, right click on the filename and and select 'Save Target as' or 'Save Link as' from the menu.
| Gradient.xls |
Description:
Excel file containing a spreadsheet that calculates hydraulic gradient and direction of a piezometric surface or water table head data from up to 20 wells, assuming a planar surface. |
|
Published reference:
Devlin, J.F. 2003. A spreadsheet method of estimating best fit hydraulic gradients using head data from multiple wells. Ground Water, v. 41, no. 3, 316-320. |
|
Compiled Fortran Programs Using Simplex Optimization for Biodegradation Kinetics
| Miki.txt |
Description:
Zip file containing DOS based executables for fitting microbial kinetic data. Download the file and rename it Miki.zip to access the contents. Fitting routines are given for Michaelis Menten kinetics Monod kinetics, logistic kinetics, and more. The routines use simplex optimization for fitting, and a bisection routine to permit the integrated solutions to be solved directly for concentration. |
|
Published reference:
Goudar, C.T., Devlin, J.F. 2001. Nonlinear estimation of enzyme and microbial kinetic parameters from progress curve analysis. Water Environment Research, 73, 260-265. |
|
Excel spreadsheet to calculate and compare approximations of the error function
| erfCompare.xlsm |
Description:
Excel file (XL2010) containing spreadsheets that calculate the error function using 7 different approximations, including the erf function that comes with Excel, compares them against the series expansion approximation and then demonstrates their utility in a transport equation. Instructions for use are given in the workbook. |
|
Published reference:
Devlin, J.F., Brookfield, A., Huang, B., Schillig, P. 2011. Using the Domenico Solution to Teach Contaminant Transport Modeling. Submitted to the Journal of Geoscience Education. |
|
Excel spreadsheet that performs Monte Carlo simulations on a 3D plume
| DomenicoFullMonteCarlo.xlsm |
Description:
Excel file (XL 2010) containing a spreadsheet that calculates and displays 2D plumes using The Domenico Solution. The spreadsheet contains visual basic code that permits the calculation of up to 1000 realizations of the plumes accounting for the uncertainties of up to 5 transport parameters (Co, x-, y-, z-dispersivities, and velocity). Histograms of concentrations at up to 4 locations in the plume are automatically generated. Instructions for using the spreadsheet are given in the file. |
|
Published reference:
Devlin, J.F., Brookfield, A., Huang, B., Schillig, P. 2011. Using the Domenico Solution to Teach Contaminant Transport Modeling. Submitted to the Journal of Geoscience Education. |
|
Excel spreadsheet to assist PVP data processing
| VelproPack.zip |
Description:
Excel file with VBA code to assist with the processing of PVP data collected with a Cambpell Scientific CR1000 data logger. Data from individual channels (PVP detectors) are parsed into columns in individual worksheets, the data fitted with the transport equation to estimate apparent velocities on the probe surface, and the apparent velocities are converted to ambient groundwater velocities in a final summary worksheet. The various steps are interactive and include useful features such as a baseline correction to facilitate data processing. A user manual can be obtained upon request from the program author, Peter Schillig. |
|
Published reference:
Schillig, P.C. 2011. VelProbePE: An Automated Spreadsheet Program for Interpreting Point Velocity Probe Breakthrough Curves. Submitted to Computers in Geoscience. |
|
Please refer to the Information for Prospective Graduate Students link on the KU Hydrogeology page for additional information about support and how to apply. Contact Yolanda Davis with your general questions; her contact information is on that linked page. If you have more specific questions or concerns about any of this information, or your qualifications for graduate school in the KU hydrogeology program here, I would be very pleased to hear from you. Please contact me at your convenience.