Animating Ground Water Levels with Excel

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 m...

Full description

Saved in:
Bibliographic Details
Published in:Ground water 2003-07, Vol.41 (4), p.548-549
Main Authors: Shikaze, Steven G., Crowe, Allan S.
Format: Article
Language:English
Subjects:
Computer Graphics
Groundwater
Models, Theoretical
Software
Soil
Technology application
Water Movements
Water, Underground
Citations: Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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.
ISSN:0017-467X
1745-6584
DOI:10.1111/j.1745-6584.2003.tb02390.x