Transient groundwater modelling using spreadsheets for education and model prototyping

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.本补充数据集包含本文所评估的四款模型的电子表格文件。本文涉及的模型包括K2005A、适用于承压与无压含水层的A2016，以及嵌入A2016无压模型的A2016STA。此外还纳入了K2005B——该模型采用算术平均值而非调和平均值计算单元间水力传导度。 数据集S1（DS01）：为同时包含K2005A与K2005B模型的电子表格模型。两款模型共享绝大多数工作表标签，核心差异在于单元间水力传导度的平均计算方式：K2005A使用调和平均值，K2005B则采用算术平均值。对应文件为：ds01_Transient Groundwater K2005A_K2005B 数据集S2（DS02）：为同时包含K2005B模型及其改进版本K2005M的电子表格模型，其中K2005M引入了含水层厚度变量与初始水头值。两款模型的数据集共享多数工作表。对应文件为：ds02_Transient Groundwater K2005M_K2005B 数据集S3（DS03）：为基于Modflow的数学框架与结构、并通过宏实现时间步控制的承压含水层A2016模型电子表格。对应文件为：ds03_Transient Groundwater A2016_confined 数据集S4（DS04）：为基于Modflow的数学框架与结构、并通过宏实现时间步控制的无压含水层A2016模型电子表格。该电子表格还附带可用于指定厚度近似计算的相关数据。对应文件为：ds04_Transient Groundwater A2016_unconfined 本数据集更新于2018年7月30日：清理了部分术语与单位表述，移除了冗余的宏按钮。