There is a newer version of the record available.

Published February 6, 2022 | Version 1.1

REE diagram and "spidergram" template for Excel

Authors/Creators

  • 1. KIT

Description

Excel template to plot normalized trace element (including rare-earth element) abundances. The user can quickly switch between normalizations. Requires trace element data (of rocks or minerals). To minimize clutter the input is limited to 20 samples.

August 11, 2022: major changes on the data input sheet; correction of an error in the display of the standard REE diagram

May 10, 2023:

– changes to the REE plots: If you have INAA data that usually lack Pr and Gd, hypothetical values for these elements can be interpolated between La and Nd, respectively between Sm and Tb to help recognize Ce and/or Eu anomalies;

– changes to the spider diagram that plots normalized concentrations as a function of ionic radii: missing elements in a dataset will no longer cause Excel to construct unwanted connecting lines between different groups of elements, for example HFSE and REE

Notes

Tested with Excel 2019 for Mac and Windows.

Files

Files (7.5 MB)

Name Size Download all
md5:7bd49e236118224dc9e0ef100dab3a54
2.7 MB Download
md5:765c9fcf75fdff4ce743374a2d6e587a
2.0 MB Download
md5:952e769ad98e6797ffb966ff9365e480
2.8 MB Download