Microsoft EXCEL spreadsheet-based program for calculating equilibrium gas speciation in the C–O–H–S–Cl–F system

https://doi.org/10.1016/j.cageo.2003.10.006Get rights and content

Abstract

A high-temperature gas is a relatively simple mixture of gas species in homogeneous equilibrium. Volcanic gases are composed of the elements C, O, H, S, Cl and F along with trace amounts of other components. We present an Microsoft EXCEL spread sheet and add-in for calculation of homogeneous equilibrium in this system. This EXCEL extension allows users to calculate equilibrium species fugacities at 1bar for any volcanic or laboratory gas mixture in the C–O–H–S–Cl–F system. Homogeneous equilibrium is calculated using the RAND algorithm based on the assumption of ideal mixing of 66 molecular gas species. This is implemented as a hierarchy of class objects written in C++. This computation engine is compiled into a dynamically linked EXCEL add-in which can be accessed by any EXCEL spread sheet. An easy to use spread sheet is provided which implements this add-in.

Introduction

Volcanic gases are the medium by which volatile elements are transferred from the lithosphere to the hydrosphere and atmosphere. As such, they play a pivotal role in global cycling of these elements and the maintenance of life on Earth. Volcanic gases are composed primarily of the elements C, O, H, S, Cl and F. Other elements generally comprise only a trace portion of the volcanic gas phase. At a given temperature and pressure, the equilibrium gas phase in this six-component system will be composed of a mixture of a much larger number of molecular gas species in homogeneous equilibrium. The abundances of each of these molecular species, and thus both their chemical potentials and fugacities, will be a function of temperature, pressure, and bulk composition. In this contribution, we describe the thermodynamics of homogeneous equilibrium for C–O–H–S–Cl–F gases at atmospheric pressure (or below) and an efficient and robust algorithm for its calculation. We provide an easy to use EXCEL add in that implements this algorithm for general use.

Section snippets

Geometry and thermodynamics

We consider an n component system with mole numbers in vector cn. At T and P these n components form a homogeneous mixture of mn gas species in vector ςm. Components and species are related through an n×m formula matrix A, whose columns consist of the component stoichiometry for a given species. For example, a gas in the C–O–H system with the species CO2, CO, O2,H2, CH4,H2O and COH would have the formula matrix:A=110010121200110002421.As this example shows, it is not necessary that any of the

Algorithm

Smith and Missen (1991) present several efficient algorithms for calculating homogeneous speciation. For equilibrium in gas species at low pressure, we have found the RAND algorithm (Smith and Missen, 1991, p. 123) to be particularly robust and effective. The RAND algorithm as presented in Smith and Missen (1991) is a modification of an approach originally presented by White et al. (1958). This algorithm is an iterative procedure that uses the method of Lagrange multipliers to impose mass

C++ class

The C–O–H–S–Cl–F solution is implemented as a class object COHSClFGasSol in the C++ language. The COHSClFGasSol class is a member of a hierarchy of objects, as displayed in Fig. 1. All objects in this hierarchy are child classes of the Phase object and thus must implement a collection of standard Phase methods. These include methods returning the Gibbs free energy, entropy, temperature, heat capacity, setting temperature or pressure, etc.

The COHSClFGasSol class is a child of the Solution class,

Availability

Shared libraries and Excel add-ins are available for download from the MELTS web site, http://ctserver.uchicago.edu and the Brimstone web site, http://ctserver.ess.washington.edu. Both Microsoft Windows and Macintosh versions are included. The Windows version has been tested under Windows 95, 98, NT and 2000 running Excel 97, 98 and 2000. The Macintosh version has only been tested under OS X, but OS 8/9 versions are also available. Much of the source code is available from the above sites, or

Acknowledgements

The first author is indebted to Denton Ebel for pointing out errors in tabulated ΔGf values for S2O, C2H2 and HS in the two latest JANAF compilations. Reviewers Alexei Fedkin and Denton Ebel provided valuable and constructive reviews. Undergraduate researchers Lori Greene and Richard Green helped with data input and testing. The initial implementation of this code was written at the Geophysical Laboratory under the NSF sponsored Center for High Pressure Research (CHIPR). Refinements and

References (8)

  • D.S. Ebel et al.

    Condensation in dust-enriched systems

    Geochimica et Cosmochimica Acta

    (2000)
  • Chase, M.W.J., 1998. NIST-JANAF Thermochemical Tables, Journal of Physical Chemistry Reference Data, Vol. 9, 4th...
  • Chase, M.W.J., Davies, C.A., Downey, J.R.J., Frurip, D.J., McDonald, R.A., Syverud, A.N., 1985. JANAF Thermochemical...
  • V.C. Kress

    Thermochemistry of sulfide liquids Ithe system O–S–Fe at 1bar

    Contributions to Mineralogy and Petrology

    (1997)
There are more references available in the full text version of this article.

Cited by (25)

  • Redox dependent behaviour of molybdenum during magmatic processes in the terrestrial and lunar mantle: Implications for the Mo/W of the bulk silicate Moon

    2017, Earth and Planetary Science Letters
    Citation Excerpt :

    Oxygen fugacity was imposed by mixing CO–CO2 in different proportions using Mykrolis mass flow controllers. The CO–CO2 proportions required for the equilibrium gas species fugacities at 1 bar were calculated using an Excel macro as described in Kress et al. (2004). The effective values of fO2 inside the furnaces were checked and calibrated using a CaO–Y2O3-stabilized ZrO2 electrolite cell.

  • The effect of titanium on the partitioning behavior of high-field strength elements between silicates, oxides and lunar basaltic melts with applications to the origin of mare basalts

    2016, Chemical Geology
    Citation Excerpt :

    Oxygen fugacity of each experiment was established by mixing CO–CO2 in different proportions using Mykrolis mass flow controllers. The amount in SCCM (Standard Cubic Centimeters per Minute) required for the equilibrium gas species fugacities at 1 bar was calculated using an Excel macro as described in Kress et al. (2004) at the target temperature of each run. The effective values of fO2 inside the furnaces were checked and calibrated using a CaO–Y2O3-stabilized ZrO2 electrolite cell (see Chase, 1998; Laurenz et al., 2010).

  • Chemical Thermodynamics and the Study of Magmas

    2015, The Encyclopedia of Volcanoes
  • Redox controls on tungsten and uranium crystal/silicate melt partitioning and implications for the U/W and Th/W ratio of the lunar mantle

    2014, Earth and Planetary Science Letters
    Citation Excerpt :

    Gas flows were measured using Mykrolis mass flow controllers with ranges of 5–500 SCCM (standard cubic centimeters per minute) for CO and CO2 and of 0.15–15 SCCM for O2. The fO2 for each run was calculated from the thermodynamic data for gas species using an open-source Microsoft Excel spreadsheet (Kress et al., 2004). Oxygen fugacities set by gas mixing were regularly checked using a CaO stabilized ZrO2 solid electrolyte cell, and were found to be within 0.2 log units of the calculated values.

View all citing articles on Scopus

Code available from server at http://www.iamg.org/CGEditor/index.htm

View full text