|
Record Search Query:
An Excel Workbook for Identifying Redox Processes in Ground Water
Entry ID:
USGS_Redox
|
[
Get Service
]
|
[
Update this Record
]
Updating this record requires registration.
|
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.]
|
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
|
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
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
]
Updating this record requires registration.
|
|
Links
