Solving Groundwater Flow Inverse Problem Using Spreadsheet Solver
Publication: Journal of Hydrologic Engineering
Volume 16, Issue 5
Abstract
A simple spreadsheet cell-oriented methodology is proposed for solving a groundwater flow inverse problem. Initially, the numerical simulation of the groundwater flow process is carried out by using an embedded optimization approach and spreadsheet solver. The result of the simulation is compared with the result of a GMS MODFLOW simulation. The comparison shows that the result of the spreadsheet simulation is similar to the result of the GMS MODFLOW simulation. Two groundwater inverse problems are then solved using the proposed methodology. The first problem estimates the unknown pumping rates of an aquifer, and the second problem estimates the aquifer transmissivity. Using the spreadsheet method, it is easy to define boundary conditions and to initialize starting values as well as their visualization. The methodology is simple in concept and can be used for solving graduate- and undergraduate-level groundwater simulation and inverse problems. The methodology may also be used by the practicing engineer for solving small-scale groundwater problems.
Get full access to this article
View all available purchase options and get full access to this article.
References
Ayvaz, M. T., and Karahani, H. (2008). “A simulation/optimization model for the identification of unknown groundwater well locations and pumping rates.” J. Hydrol. (Amsterdam), 357(1–2), 76–92.
Bhattacharjya, R. K. (2010). “Discussion of evolutionary algorithms for the determination of critical depths in conduits.” J. Irrig. Drain Eng., 136(3), 221–223.
Gabrow, G. L., and McCornick, P. G. (2007). “Planning for water allocation and water quality using a spread-sheet based model.” J. Water Resour. Plann. Manage., 133(6), 560–564.
Hegazy, T., and Ersahin, T. (2001). “Simplified spreadsheet solutions. II: Overall schedule optimization.” J. Constr. Eng. Manage., 127(6), 469–475.
Huddleston, D. H., Alarcon, V. J., and Chen, W. (2004). “Water distribution network analysis using Excel.” J. Hydraul. Eng., 130(10), 1033–1035.
Jewell, T. K. (2001). “Teaching hydraulic design using equation solvers.” J. Hydraul. Eng., 127(12), 1013–1021.
Weiss, P. T., and Gulliver, J. S. (2001). “What do students need in hydraulic design projects?” J. Hydraul. Eng., 127(12), 984–991.
Information & Authors
Information
Published In
Copyright
© 2011 American Society of Civil Engineers.
History
Received: Mar 9, 2009
Accepted: Sep 16, 2010
Published online: Oct 1, 2010
Published in print: May 1, 2011
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.