Premium
Animating Ground Water Levels with Excel
Author(s) -
Shikaze Steven G.,
Crowe Allan S.
Publication year - 2003
Publication title -
groundwater
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.84
H-Index - 94
eISSN - 1745-6584
pISSN - 0017-467X
DOI - 10.1111/j.1745-6584.2003.tb02390.x
Subject(s) - macro , computer science , computer graphics (images) , microsoft excel , graphics , animation , ms excel , visualization , table (database) , software , data visualization , frame (networking) , engineering drawing , database , operating system , programming language , software engineering , data mining , engineering , telecommunications
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.