title: Animating ground water levels with Excel.
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.
authors.affiliation: EarthFX Inc., 3363 Yonge St., Toronto, Ontario, Canada M4N 2M6. steve@earthfx.com
authors.forename: Steven G
authors.initials: SG
authors.lastname: Shikaze
authors.forename: Allan S
authors.initials: AS
authors.lastname: Crowe
mesh_terms: D003196:Computer Graphics; D008962:Models, Theoretical; D012984:Software; D012987:Soil; D014872:Water Movements
chemical_list: D012987:Soil