Using Solver to Estimate Aquifer Parameters for Non-Leaky and Leaky Unsteady Confined Aquifer Tests

被引:3
|
作者
Brown, Christopher J. [1 ]
机构
[1] Univ N Florida, Sch Engn, Jacksonville, FL 32224 USA
来源
关键词
Aquifer Testing; Groundwater Hydrology; Solver; Excel; Optimization; Modeling; PUMPING TESTS; MODEL; TRANSMISSIVITY; FLOW;
D O I
10.2113/gseegeosci.19.3.253
中图分类号
X [环境科学、安全科学];
学科分类号
08 ; 0830 ;
摘要
Aquifer testing of confined aquifers has been used for many years to aid with the determination of the key aquifer parameters, including transmissivity, storativity, and leakance. A myriad of published methodologies have been previously developed. Some of these solutions have led to the development of expensive, proprietary software. Others require development of complex numerical models, while still others require complex calculus using inverse Laplace transforms or numerical inversion. Two common aquifer testing problems are the determination of aquifer parameters for non-leaky and leaky confined aquifers. A simple alternative approach using new computer tools can be used to estimate the aquifer parameters for both non-leaky and leaky confined aquifers given transient drawdown data from a nearby observation well. The proposed alternative methodology uses Microsoft Excel and Solver to inverse model likely best-fit aquifer parameters. The approach does not require Visual Basic or Visual Basic Assistant (VBA) programming or numerical inversion. It adapts recently published analytical approaches and uses a simple least-squares error minimization approach using the sum of square terms in combination with the evolutionary genetic solution algorithm available in Solver. It is particularly useful for teaching undergraduate geoscience or engineering majors due to its accessibility. The results provided compare favorably to other published methods.
引用
收藏
页码:253 / 263
页数:11
相关论文
共 50 条
  • [11] Approximation of Well Function and Identification of Leaky Aquifer Parameters
    Singh, Sushil K.
    JOURNAL OF IRRIGATION AND DRAINAGE ENGINEERING, 2008, 134 (06) : 864 - 871
  • [12] An analytical solution of groundwater response to tidal fluctuation in a leaky confined aquifer
    Jiao, JJ
    Tang, ZH
    WATER RESOURCES RESEARCH, 1999, 35 (03) : 747 - 751
  • [13] General well function for pumping from a confined, leaky, or unconfined aquifer
    Perina, T
    Lee, TC
    JOURNAL OF HYDROLOGY, 2006, 317 (3-4) : 239 - 260
  • [14] Improvement of routine method to define influential radius in leaky confined aquifer
    Jiao Ying
    ROCK AND SOIL MECHANICS, 2008, 29 (10) : 2779 - 2782
  • [15] Low velocity non-Darcian flow to a well fully penetrating a confined aquifer in the first kind of leaky aquifer system
    Meng, Xianmeng
    Shao, Junyu
    Yin, Maosheng
    Liu, Dengfeng
    Xue, Xianwu
    JOURNAL OF HYDROLOGY, 2015, 530 : 533 - 553
  • [16] Simple Method for Quick Estimation of Leaky-Aquifer Parameters
    Singh, Sushil K.
    JOURNAL OF IRRIGATION AND DRAINAGE ENGINEERING, 2010, 136 (02) : 149 - 153
  • [17] Non-Darcian flow to a well in a leaky aquifer using the Forchheimer equation
    Wen, Zhang
    Huang, Guanhua
    Zhan, Hongbin
    HYDROGEOLOGY JOURNAL, 2011, 19 (03) : 563 - 572
  • [18] UNSTEADY FREE-FLOW TO AN OBSERVATION WELL FROM A SEMICONFINED LEAKY AQUIFER
    ONYEJEKWE, OO
    ADVANCES IN ENGINEERING SOFTWARE, 1994, 19 (03) : 173 - 175
  • [19] Analytical Solution of Tidal Loading Effect in a Submarine Leaky Confined Aquifer System
    Song, Zongzhong
    Li, Hailong
    Ma, Qian
    Zheng, Chunmiao
    Jiao, Jiu Jimmy
    Li, Shaohong
    GEOFLUIDS, 2019, 2019
  • [20] Groundwater response to tidal fluctuations in a leaky confined coastal aquifer with a finite length
    Zhao, Zhixue
    Wang, Xiaoguang
    Hao, Yonghong
    Wang, Tongke
    Jardani, Abderrahim
    Jourde, Herve
    Yeh, Tian-Chyi Jim
    Zhang, Ming
    HYDROLOGICAL PROCESSES, 2019, 33 (19) : 2551 - 2560