Excel based finite difference modeling of ground water flow
Abstract
This paper presents a simple ground water modeling spreadsheet template developed in Excel with macros written in Visual Basic for Applications (VBA). It is based on Finite Difference method and can be used to model an aquifer of any shape and size. The given template can be expanded to build ground water flow models of virtually unlimited number of nodes. The final modeled heads, at each node, can be output as XYZ file, which can be girded by any contouring software to produce contour maps and 3D surfaces.
References
Anderson, M.P., Woessner, W.W., 1992. Applied Groundwater Modeling, Academic Press, USA, 20-21. Chiang, W.H., Kinzelbach, W., 1998. (PMPATH 98). An advective transport model for Processing Modflow and Modflow.
El-Sheimy, N., Valeo, C. Habib, A., 2005. Digital Terrain Modeling, Acquisition, Manipulation and Applications, Artech House Inc., 22-24.
McDonald, M. G., Harbaugh, A, W., 1988. A modular three-dimensional finite difference ground water flow model. Modeling Techniques, Book 6, USGS open-file report, 83-875.
Neuman, S. P, 1973. Calibration of distributed parameters groundwater flow models viewed as a multiple- objective decision process under uncertainty. Water Resources Research 9(4), 1006 – 1021.
Prickett, T.A., 1975. Modeling Techniques for groundwater evaluation. In advance in Hydroscience. New York, Academic Press, 1-113.
Wang, H.F., Anderson, M.P., 1982, Introduction to groundwater modeling – finite difference and finite element methods. W.H. Freeman and Company, 2-3.
