Related Experiment Video
Updated: Sep 22, 2026

Continuous Hydrologic and Water Quality Monitoring of Vernal Ponds
Published on: November 13, 2017
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
Abstract:
This note describes the use of Microsoft Excel macros (programs written in Excel's internal language, Visual Basic for Applications) to create simple onscreen animations of transient ground water data within Excel. Compared to many specialized visualization software packages, the use of Excel macros is much cheaper, much simpler, and can rapidly be learned. The Excel macro can also be used to create individual GIF files for each animation frame. This series of frames can then be used to create an AVI video file using any of a number of graphics packages, such as Corel PhotoPaint. The technique is demonstrated through a macro that animates changes in the elevation of a water table along a transect over several years.
Related Concept Videos
Design Example: Maintaining Level of an Embankment
Gradually Varying Flow
Design Example: Creating a Hydraulic Model of a Dam Spillway
Rapidly Varying Flow
Underflow Gates
Net Change Theorem

