Excel Spreadsheet Tools for Analyzing Groundwater Level Records and Displaying Information in ArcMap

Tillman, Fred D

Abstract:

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.

Genre:

USGS Numbered Series

ProdID:

97713

Citation Author:

Tillman, Fred D

Citation Contributing Office:

Arizona Water Science Center

Citation Datum:

Citation Day:

Citation Edition:

Version 1.0

Citation Editor:

Citation End Page:

Citation Issue:

Citation Keywords:

Citation Language:

ENGLISH

Citation Larger Work Title:

Chapter 1 of Section F, Groundwater, of Book 4, Hydrologic Analysis and Interpretation

Citation LatN:

Citation LatS:

Citation LonE:

Citation LonW:

Citation Month:

Citation No Pagination:

Citation Number Of Pages:

Citation Online Only Flag:

Citation Phsyical Description:

Report: vi, 59 p.; Spreadsheet Tools

Citation Projection:

Citation Public Comments:

Citation Publisher:

U.S. Geological Survey

Citation Series:

Techniques and Methods

Citation Series Code:

Citation Series Number:

4-F1

Citation Search Results Text:

Excel Spreadsheet Tools for Analyzing Groundwater Level Records and Displaying Information in ArcMap; 2009; TM; 4-F1; Chapter 1 of Section F, Groundwater, of Book 4, Hydrologic Analysis and Interpretation; Tillman, Fred D