mineralogical spreadsheet download page

Below you can download our mineralogical spreadsheets. These can be used to recalculate mineral stoichiometry based on electron microprobe analysis. All you have to do is enter your major element analysis into the first column and let the spreadsheet do all the hard work for you. There is an individual spreadsheet for each of the major mineral species (e.g. feldspar, olivine, pyroxene), and many species will have multiple spreadsheets, some of which will include slots for unusual elements (e.g. Zr in pyroxene). Many of the spreadsheets will also calculate the most common species end-member percentages (e.g. An, Ab and Or in feldspars).

We also have a number of other spreadsheets available that can be used to calculate a whole range of useful geochemical and geological parameters, such as the density of a magma from it's whole-rock major element composition, or bulk trace element KD values of a specimen given the it's mineralogical make-up.

All the spreadsheets are free to download and distribute. All we ask is that you acknowledge our hard work in any thesis or publication that you use the spreadsheets for. To download the spreadsheets, simply click on the file icon below and the sheet should automatically open in your favourite spreadsheet application. Alternatively right-click the icon and select the most appropriate menu option for your operating system and browser.
For alkali feldspars. Includes BaO.
Stacks Image 14
For plagioclase feldspars.
Stacks Image 15
For olivine. Calculates Fo, Fa and Tp end members, along with the FeO/MgO ratio of the liquid in equilibrium with an olivine of that composition.
Stacks Image 16
For micas. Includes Cl and F.
Stacks Image 17
For garnets. Calculates Py, Alm, Gro, and Sp endmembers.
Stacks Image 18
For pyroxenes. Calculates FeO and Fe2O3 from FeOt.
Stacks Image 19
For apatite. Includes Cl, F and LREE.
Stacks Image 20
For cordierite.
Stacks Image 21
For spinels. Calculates FeO and Fe2O3 from FeOt
Stacks Image 22
For rutile. Includes Nb2O5
Stacks Image 400
For epidote.
Stacks Image 328
For ilmenite. Includes Nb2O5 and calculates FeO and Fe2O3 from FeOt
Stacks Image 510
For amphibole assuming 13 cations excluding Ca,Na & K. Suitable for many calcic amphiboles.
Stacks Image 408
For amphibole assuming 15 cations excluding Na & K. Suitable for Fe-Mg amphiboles & coexisting calcic amphiboles
Stacks Image 410
For amphibole assuming 16 cations assuming no A - site vacancies. Suitable only for amphiboles with full A - sites
Stacks Image 414
For calculating the name of amphibole according to the classification of Leake et al.
Stacks Image 412
For calculating trace element bulk KD values given the mineral make-up of a sample.
Stacks Image 23
For calculating the density of a magma from it's major element composition.
Stacks Image 396