Development of a spreadsheet-based model for transient groundwater modelling

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.
Updated: 9/5/19 - Updated title to match the paper.

本补充数据集包含论文中评估的四款模型的电子表格文件。论文涉及的模型包括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日：清理部分术语与单位表述，移除冗余宏按钮。
2018年8月8日：添加教程。
2019年5月9日：更新标题以匹配论文要求。