Spreadsheets for Geothermal Water and Gas Geochemistry

Jump to: navigation, search

OpenEI Reference LibraryAdd to library

Conference Paper: Spreadsheets for Geothermal Water and Gas Geochemistry


Two Excel spreadsheets released with this paper support many of the common graphical analyses of water and gas chemistry used to interpret hot spring, fumarole and well samples in geothermal exploration and development. Cross-plots and ternary diagrams are generated from measured concentrations of chemical species using formulas based on equilibrium reactions and empirical relationships. Typical applications include geothermometry, fluid and gas space and time trend characterization, and data quality assessment. The spreadsheets provide charting capability compatible with all versions of Excel from 1997 to 2007.

The Liquid Analysis Spreadsheet takes tabulated water chemistry data input in ppm weight and stable isotope data in per mil and tabulates geothermometers and quality assurance parameters. Explanations for the calculations are referenced. Charts include the ubiquitous Giggenbach Na-K-Mg geothermometer ternary, three temperature "geoindicator" cross-plots, δ18O-δD, Cl-enthalpy, and four commonly used trace element ternary plots. Brief outlines of applications reference publications that provide more detailed case histories.

The Gas Analysis Spreadsheet takes gas analyses from steam samples in a variety of commonly reported units, makes an air correction (if needed) and plots four common ternaries, three3 “YT” gas geothermometer grids and two gas ratio geothermometer grids, mainly derived from the work of Werner Giggenbach. Typical applications of the graphical analyses provided in this gas spreadsheet are briefly summarized based on an earlier paper.

These spreadsheets are offered as freeware, without warranty of fitness for any purpose under the GNU General Public License 3, subject to users’ reference

to this paper in initial publications of work based on these spreadsheets.

Tom Powell and William Cumming

Thirty-Fifth Workshop on Geothermal Reservoir Engineering; Stanford, CA; 2010/02/01

Stanford University, Stanford Geothermal Program, 2010

Not Provided
Check for DOI availability: http://crossref.org

Internet link for Spreadsheets for Geothermal Water and Gas Geochemistry


Tom Powell and William Cumming. 2010. Spreadsheets for Geothermal Water and Gas Geochemistry. In: Proceedings, Workshop on Geothermal Reservoir Engineering. Thirty-Fifth Workshop on Geothermal Reservoir Engineering; 2010/02/01; Stanford, CA. Stanford, CA: Stanford University, Stanford Geothermal Program; p. 408-417

Related Geothermal Exploration Activities
Activities (1)

Areas (1)
  1. Any
Regions (0)