Please use this identifier to cite or link to this item:
Scopus Web of Science® Altmetric
Type: Journal article
Title: Development of a spreadsheet-based model for transient groundwater modelling
Author: Ankor, M.
Tyler, J.
Citation: Hydrogeology Journal, 2019; 27(5):1865-1878
Publisher: Springer Nature
Issue Date: 2019
ISSN: 1431-2174
Statement of
Martin J. Ankor, Jonathan J. Tyler
Abstract: Understanding and modelling the passage of groundwater is important for a wide range of environmental and earth science disciplines. The science of groundwater modelling is mature, and advanced modelling algorithms are routinely implemented, for example via the widely used MODFLOW software. However, for the non-specialist scientist or student, the fundamentals of such software can be difficult to comprehend, whilst the algorithms are arguably too complex to be easily applied for many applications which require integration of a groundwater model with climate, surface-water, soil or ecological data. In this context, a spreadsheet-based groundwater model (A2016), capable of solving transient groundwater behaviour in multiple spatial dimensions, was developed. Inter-comparison tests investigating nine transient groundwater scenarios were performed between MODFLOW, A2016 and the Time-dependent Groundwater Modeling using Spreadsheet Simulation (TGMSS) model. Results demonstrated that A2016 is directly comparable to MODFLOW, with identical hydraulic heads in all model experiments. TGMSS was not able to accurately simulate hydraulic heads for any of the model experiments. A groundwater–lake interaction scenario was identified for which MODFLOW will produce unrealistic results, due to the way conductance beneath lakes is determined. Applying a specified saturated thickness approximation for the region beneath the lake resulted in improved lake–groundwater interactions. A2016 is potentially useful for educational purposes and as a tool for groundwater experiments by non-specialists, as it is modular in nature and incorporates MODFLOW terminology and techniques.
Keywords: Spreadsheets; general hydrogeology; transient; numerical modelling; education
Rights: © Springer-Verlag GmbH Germany, part of Springer Nature 2019
RMID: 0030120303
DOI: 10.1007/s10040-019-01996-z
Appears in Collections:Geography, Environment and Population publications

Files in This Item:
There are no files associated with this item.

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.