A user interface for the Kansas Geological Survey slug test model

Area of Science:

• Hydrogeology
• Geophysical Well Logging

Background:

• The Kansas Geological Survey (KGS) developed a semianalytical solution for slug tests.
• The original FORTRAN model had a text-based interface with rigid input requirements and limited output options.

Purpose of the Study:

• To re-create the main routine for the KGS slug test model as a Visual Basic macro.
• To build a user-friendly Excel spreadsheet interface for graphical results display.

Main Methods:

• Developed a Visual Basic macro within Microsoft Excel.
• Created an Excel spreadsheet interface for data input and graphical output.
• Validated the macro against the original FORTRAN code.

Main Results:

• The Excel macro successfully replicated the functionality of the original FORTRAN code.
• Graphical results are automatically displayed, enhancing usability.
• Identical results were obtained when comparing the FORTRAN and Excel versions for three test cases.

Conclusions:

• The new Excel-based tool provides a user-friendly alternative to the original FORTRAN code.
• This enhanced tool simplifies the analysis of slug tests, incorporating complex hydrogeological parameters.
• The validated macro offers reliable simulation for confined and unconfined aquifer conditions.