Skip Links

USGS - science for a changing world

U.S. Geological Survey Techniques and Methods 4-F1

National Water Availability and Use Pilot Program

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

By Fred D Tillman

2009

ABSTRACT

Thumbnail of and link to report PDF (6.1 MB)

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.

Front cover: Illustration of the path from raw water-level data to useful groundwater information

Last modified March 9, 2010
First posted July 23, 2009

  • This report is available only on the Web.

For additional information contact:
Office information, Arizona Water Science Center
U.S. Geological Survey
520 N. Park Avenue
Tucson, AZ 85719
http://az.water.usgs.gov/

This report is presented in Portable Document Format (PDF); the latest version of Adobe Reader or similar software is required to view it. Download the latest version of Adobe Reader, free of charge.


Suggested citation:

Tillman, Fred D, 2009, Excel(R) spreadsheet tools for analyzing groundwater level records and displaying information in ArcMap(TM): U.S. Geological Survey Techniques and Methods 4-F1, 59 p. [http://pubs.usgs.gov/tm/tm4f1/].



Contents

Abstract

Introduction

Acknowledgments

Data Requirements

Spreadsheet Tools

Displaying Results in ArcMap

Summary and Conclusions

References Cited

Appendix: Program Listings


Accessibility FOIA Privacy Policies and Notices

Take Pride in America logo USA.gov logo U.S. Department of the Interior | U.S. Geological Survey
URL: http:// pubs.usgs.gov /tm/tm4f1/index.html
Page Contact Information: USGS Publications Team
Page Last Modified: Wednesday, 09-Jan-2013 15:54:23 EST