Transient groundwater modeling using spreadsheets

Authors:
Halil Karahan;M. Tamer Ayvaz
Affiliations:
Department of Civil Engineering, Faculty of Engineering, Pamukkale University, 20017 Denizli, Turkey;Department of Civil Engineering, Faculty of Engineering, Pamukkale University, 20017 Denizli, Turkey
Venue:
Advances in Engineering Software
Year:
2005

Citing 3
Cited 0

Numerical solutions for the one-dimensional heat-conduction equation using a spreadsheet

Computers & Geosciences
Mixed-finite element and finite volume discretization for heavy brine simulations in groundwater

Journal of Computational and Applied Mathematics
Spreadsheet Solution of Partial Differential Equations

IEEE Transactions on Education

Quantified Score

Hi-index	0.00

Visualization

Abstract

This study proposes a transient groundwater modeling using spreadsheet simulation (TGMSS) model for solving groundwater problems. TGMSS may be considered as a practical method and introduction to groundwater modeling that uses spreadsheets instead of conventional groundwater model codes. Irregular aquifer geometry, variable boundary conditions and sinks and/or source values, heterogeneous aquifer parameters (conductivity, storage capacities), may be evaluated in the TGMSS. Different management scenarios may be analyzed by obtaining the groundwater level of different times. Two hypothetical examples are tested with TGMSS and verified with MODFLOW. Results showed that the TGMSS and MODFLOW results were in good agreement in terms of resulting values of hydraulic heads in all cases.