NASA Home Page Goddard Space Flight Center Home Page
NASA Logo - Goddard Space Flight Center   + Visit NASA.gov
a directory of Earth science data and services Global Change Master Directory Web site
header 2 bullet Links bullet FAQ bullet Contact Us bullet Site Map
Home Data Sets Data Services Learn about GCMD_legacy's portal collaborations. Add new dataset or dataservice records to GCMD_legacy What's New Participate Calendar About GCMD_legacy
 
Record Search Query:

An Excel Workbook for Identifying Redox Processes in Ground Water
Entry ID: USGS_Redox
[ Get Service ]
[ Update this Record ]


Summary
Abstract: The reduction/oxidation (redox) condition of ground water affects the concentration, transport, and fate of many anthropogenic and natural contaminants. The redox state of a ground-water sample is defined by the dominant type of reduction/oxidation reaction, or redox process, occurring in the sample, as inferred from water-quality data. However, because of the difficulty in defining and applying a systematic redox framework to samples from diverse hydrogeologic settings, many regional water-quality investigations do not attempt to determine the predominant redox process in ground water. Recently, McMahon and Chapelle (2008) devised a redox framework that was applied to a large number of samples from 15 principal aquifer systems in the United States to examine the effect of redox processes on water quality. This framework was expanded by Chapelle and others (in press) to use measured sulfide data to differentiate between iron(III)- and sulfate-reducing conditions. These investigations showed that a systematic approach to characterize redox conditions in ground water could be applied to datasets from diverse hydrogeologic settings using water-quality data routinely collected in regional water-quality investigations.

This report describes the Microsoft Excel workbook, RedoxAssignment_McMahon&Chapelle.xls, that assigns the predominant redox process to samples using the framework created by McMahon and Chapelle (2008) and expanded by Chapelle and others (in press). Assignment of redox conditions is based on concentrations of dissolved oxygen (O2), nitrate (NO3–), manganese (Mn2+), iron (Fe2+), sulfate (SO42–), and sulfide (sum of dihydrogen sulfide [aqueous H2S], hydrogen sulfide [HS–], and sulfide [S2–]). The logical arguments for assigning the predominant redox process to each sample are performed by a program written in Microsoft Visual Basic for Applications (VBA). The program is called from buttons on the main worksheet. The number of samples that can be analyzed is only limited by the number of rows in Excel (65,536 for Excel 2003 and XP; and 1,048,576 for Excel 2007), and is therefore appropriate for large datasets.

[Summary provided by the U.S. Geological Survey.]

Related URL
Link: GET SERVICE > GET SOFTWARE PACKAGE
Description: Redox Processes Workbook XLS.

Link: VIEW RELATED INFORMATION
Description: Redox Processes report.
Service Citation
Originators: Jurgens, B.C., McMahon, P.B., Chapelle, F.H., and Eberts, S.M.
Title: An Excel Workbook for Identifying Redox Processes in Ground Water
Release_Date: 2009
Provider: U.S. Geological Survey
URL: http://pubs.usgs.gov/of/2009/1004/
ISO Topic Category
GEOSCIENTIFIC INFORMATION
Access Constraints
None
Use Constraints
None
Service Provider


Service Provider Personnel
Name: CALIFORNIA WATER SCIENCE CENTER
Phone: 916-278-3000
Contact Address:
6000 J Street, Placer Hall
City: Sacramento
Province or State: CA
Postal Code: 95819
Country: USA
Distribution Media
Distribution_Media: Online
Distribution_Size: 549 KB
Fees: No fees
Personnel
BRYANT JURGENS
Role: TECHNICAL CONTACT
Email: bjurgens at usgs.gov

DIRECTOR, CALIFORNIA WATER SCIENCE CENTER
Role: TECHNICAL CONTACT
Email: dc_ca at usgs.gov
Contact Address:
U.S. Geological Survey
6000 J Street, Placer Hall
City: Sacramento
Province or State: CA
Postal Code: 98519
Country: USA

TYLER B. STEVENS
Role: SERF AUTHOR
Phone: (301) 614-6898
Fax: 301-614-5268
Email: Tyler.B.Stevens at nasa.gov
Contact Address:
NASA Goddard Space Flight Center
Global Change Master Directory
City: Greenbelt
Province or State: MD
Postal Code: 20771
Country: USA
Creation and Review Dates
SERF Creation Date: 2012-08-21
SERF Last Revision Date: 2012-08-21
[ Update this Record ]
USA dot gov - The U.S. Government's Official Web Portal NASA
Webmaster:  Monica Holland
Responsible NASA Official:  Lola Olsen
Last Updated:  August 2014