Transient groundwater modelling using spreadsheets for education and model prototyping
AnkorMartin
2019
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.