Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

Visual Basic programs for spreadsheet analysis.

Bruce Hunt1

  • 1University of Canterbury, Christchurch, New Zealand. b.hunt@civil.canterbury.ac.nz

Ground Water
|February 25, 2005
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Re: Pumping-induced drawdown and stream depletion in a leaky aquifer system.

Ground water·2008
Same author

Pumping test evaluation of stream depletion parameters.

Ground water·2006
Same author

"Analytical model for aquifer response incorporating distributed stream leakage," by Garey A. Fox, Paul DuChateau, and Deana S. Durnford, July-August 2002 issue, v. 40, no. 4: 378-384.

Ground water·2004
Same journal

PSO-Optimized Ensemble Learning with SHAP for Seasonal Groundwater Quality Prediction.

Ground water·2026
Same journal

Computing Flow-Field Distortion Coefficients from Well-Construction and Formation Properties.

Ground water·2026
Same journal

Leaky Sewers Hydraulically Disconnect from Groundwater: A Proof-of-Concept.

Ground water·2026
Same journal

Python-Based Model Emulation Workflows with PEST.

Ground water·2026
Same journal

Hydrogeology in the Age of AI and Climate Change.

Ground water·2026
Same journal

Aquifer Thermal Energy Storage: Groundwater for Efficient Data Center Cooling in the United States.

Ground water·2026
See all related articles

This study presents Function.xls, a Visual Basic program collection for groundwater calculations. It offers tools for mathematical functions and analytical solutions in groundwater hydraulics and contaminant transport, with examples provided.

Area of Science:

  • Hydrogeology
  • Environmental Engineering
  • Computational Science

Background:

  • Groundwater calculations require specialized tools for accuracy.
  • Existing methods can be complex and time-consuming.
  • Spreadsheet-based solutions offer accessibility and ease of use.

Purpose of the Study:

  • To introduce Function.xls, a Visual Basic program suite for groundwater analysis.
  • To provide accessible computational tools for hydrogeology and contaminant transport.
  • To demonstrate the utility of spreadsheet programs in solving groundwater problems.

Main Methods:

  • Development of Visual Basic programs integrated into a spreadsheet format (Function.xls).
  • Inclusion of functions for mathematical calculations relevant to groundwater.

Related Experiment Videos

  • Implementation of programs for evaluating analytical solutions in groundwater hydraulics and contaminant transport.

    • Main Results:

    • Function.xls provides a versatile collection of tools for groundwater modeling.
    • The programs facilitate the calculation of complex mathematical functions.
    • Analytical solutions for groundwater hydraulics and contaminant transport are readily evaluated.

    Conclusions:

    • Function.xls enhances the efficiency and accessibility of groundwater data analysis.
    • The spreadsheet-based approach simplifies the application of hydrogeological models.
    • This program collection serves as a valuable resource for researchers and practitioners in groundwater science.