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

Animating ground water levels with Excel.

Steven G Shikaze1, Allan S Crowe

  • 1EarthFX Inc., 3363 Yonge St., Toronto, Ontario, Canada M4N 2M6. steve@earthfx.com

Ground Water
|July 23, 2003
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

Anthropogenic impacts on a bedrock aquifer at the village scale.

Ground water·2013
Same author

An Excel macro for generating trilinear plots.

Ground water·2007
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
Same journal

Simulating the Impacts of Deep Geothermal Development on Shallow Hydrothermal Resources in a Rocky Mountain Rift Valley.

Ground water·2026
Same journal

Discharge-Targeted Hydraulic Tomography to Quantify and Locate Aquifer Discharge.

Ground water·2026
See all related articles

This study introduces Microsoft Excel macros for animating transient groundwater data, offering a cost-effective and simple visualization method. The technique generates GIF and AVI files for dynamic data presentation.

Area of Science:

  • Environmental Science
  • Hydrogeology
  • Data Visualization

Background:

  • Specialized software for visualizing transient groundwater data can be expensive and complex.
  • There is a need for accessible and user-friendly tools for hydrological data analysis.

Purpose of the Study:

  • To demonstrate the utility of Microsoft Excel macros for creating onscreen animations of transient groundwater data.
  • To present a cost-effective and simple alternative to specialized visualization software.

Main Methods:

  • Developing macros using Visual Basic for Applications (VBA) within Microsoft Excel.
  • Utilizing macros to generate individual GIF frames for each animation step.
  • Employing graphics software (e.g., Corel PhotoPaint) to compile GIF frames into AVI video files.

Related Experiment Videos

Main Results:

  • Successful creation of simple onscreen animations visualizing changes in water table elevation over time.
  • Generation of individual GIF files representing animation frames.
  • Capability to produce AVI video files from the generated GIF sequences.

Conclusions:

  • Microsoft Excel macros provide a cheap, simple, and rapidly learnable method for animating transient groundwater data.
  • This technique enables the creation of dynamic visualizations, enhancing the understanding of hydrological processes.
  • The generated animation files (GIF, AVI) can be easily shared and integrated into presentations or reports.