When beginning hydrologic investigations, a first action is often
to gather existing sources of well information, compile this
information into a single dataset, and visualize this information
in a geographic information system (GIS) environment. This report
presents tools (macros) developed using Visual Basic for
Applications (VBA) for Microsoft Excel 2007 to assist in these
tasks. One tool combines multiple datasets into a single worksheet
and formats the resulting data for use by the other tools. A second
tool produces summary information about the dataset, such as a list
of unique site identification numbers, the number of water-level
observations for each, and a table of the number of sites with a
listed number of water-level observations. A third tool creates
subsets of the original dataset based on user-specified options and
produces a worksheet with water-level information for each well in
the subset, including the average and standard deviation of
water-level observations and maximum decline and rise in water
levels between any two observations, among other information. This
water-level information worksheet can be imported directly into
ESRI ArcMap as an 'XY Data' file, and each of the fields of summary
well information can be used for custom display. A separate set of
VBA tools distributed in an additional Excel workbook creates
hydrograph charts of each of the wells in the data subset produced
by the aforementioned tools and produces portable document format
(PDF) versions of the hydrograph charts. These PDF hydrographs can
be hyperlinked to well locations in ArcMap or other GIS
applications.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!