Transient groundwater modelling using spreadsheets for education and model prototyping
datasetposted on 19.07.2019 by Martin Ankor
Datasets usually provide raw data for analysis. This raw data often comes in spreadsheet form, but can be any collection of data, on which analysis can be performed.
The supplementary data consists of spreadsheet files for the four models assessed in the paper. Models included from the paper are K2005A, A2016 (for both confined and unconfined aquifers) and A2016STA (included in the A2016 unconfined model). In addition, K2005B, which uses average instead of harmonic mean to determine cell to cell hydraulic conductance is included. Data Set S1 (DS01). Spreadsheet model containing both K2005A and K2005B models. Both models use many of the same tabs, with the main differences being how hydraulic conductivity is averaged between cells. In K2005A the harmonic mean is used. K2005B uses the arithmetic mean. File: ds01_Transient Groundwater K2005A_K2005B Data Set S2 (DS02). Spreadsheet model containing both the K2005B model, and a modified version – K2005M – which incorporates an aquifer thickness variable and initial head values. Both models use many of the same sheets for their datasets. File: ds02_Transient Groundwater K2005M_K2005B Data Set S3 (DS03). Spreadsheet model A2016 for confined aquifers based on the mathematics and structure of Modflow and using macros for timestep control. File: ds03_Transient Groundwater A2016_confined Data Set S4 (DS04). Spreadsheet model A2016 for unconfined aquifers, based on the mathematics and structure of Modflow and using macros for timestep control. This spreadsheet also includes data to allow for the application of the specified thickness approximation. File: ds04_Transient Groundwater A2016_unconfined Updated: 30/07/2018 - Cleaned up some terminology and units. Removed redundant macro button. Updated: 8/8/18 - Added tutorial.