Premium
A User Interface for the Kansas Geological Survey Slug Test Model
Author(s) -
Esling Steven P.,
Keller John E.
Publication year - 2009
Publication title -
groundwater
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.84
H-Index - 94
eISSN - 1745-6584
pISSN - 0017-467X
DOI - 10.1111/j.1745-6584.2009.00571.x
Subject(s) - fortran , macro , slug test , computer science , interface (matter) , graphical user interface , programming language , code (set theory) , visual basic , simple (philosophy) , variable (mathematics) , computer graphics (images) , engineering drawing , simulation , software , geology , operating system , engineering , geotechnical engineering , mathematics , mathematical analysis , philosophy , set (abstract data type) , bubble , epistemology , maximum bubble pressure method , aquifer , groundwater
The Kansas Geological Survey (KGS) developed a semianalytical solution for slug tests that incorporates the effects of partial penetration, anisotropy, and the presence of variable conductivity well skins. The solution can simulate either confined or unconfined conditions. The original model, written in FORTRAN, has a text‐based interface with rigid input requirements and limited output options. We re‐created the main routine for the KGS model as a Visual Basic macro that runs in most versions of Microsoft Excel and built a simple‐to‐use Excel spreadsheet interface that automatically displays the graphical results of the test. A comparison of the output from the original FORTRAN code to that of the new Excel spreadsheet version for three cases produced identical results.