TriAngle: A Spreadsheet template for the Generation of Trilinear Plots

triangle01

TriAngle is a Microsoft ExcelTM spreadsheet template to create triangular plots in an easy way.

Features:

  1. Simple to handle
  2. Automatic normalisation to 100% of inserted data
  3. No use of VBA; to adapt easily the file to other desktop and mobile spreadsheet programs which do not support VBA
  4. Automatic display of apexes titles
  5. Automatic display of a legend (can be deleted if not desired)
  6. Selection of typical masks used in the daily business of geoscientists – the user has the chance to add own masks
  7. High quality of the resulting chart for direct use in documents without reformatting with a drawing software
  8. Added data are shown immediately after insertion in the table
  9. Further masks and labels can be designed and inserted by the user using a pre-defined form. A manual how to do so is included in worksheet ‘Manual’

For convenience, TriAngle is a MS ExcelTM 2007 template-file showing the extension ‘.xltx’. Further, it is write-protected. In this way the file can be distinguished from usual Excel files (‘.xlsx’) and the program gives a warning and asks to rename it during the first saving procedure to protect from overwriting current files.

NEW!!! TriAngle as LibreOffice Calc template-file offering the same functionality for Linux users and/or for people who simply prefer to use free software. This template offers the same masks and grids and the possibility to design own masks. It is a LibreOffice Calc template with .ots extension.

This template was tested on PCs running Windows XP with ExcelTM versions 2003 and 2007, Windows 7, using ExcelTM versions 2007 and 2013, as well as Mac OS with Excel for Mac 2011.

The LibreOffice template was tested on PCs running Linux Mint 17 with LibreOffice version 4.2.6.3 and Windows 7 using LibreOffice version 4.3.4.1.

In case you have no time or problems to create your own masks, just send us a figure of the mask and – if possible – the citation of the original article. We can make you a quote for the desired template.

Some example masks:

Nb-Zr-Y-Template
Nb-Zr-Y-Template
Classification and nomenclature of tuffs and ashes
Classification and nomenclature of tuffs and ashes

TriAngle 1.2.xltx (380 KB, Jul. 21, 2014)

In case of using the template in publications or other texts, please cite the following article:

Warnsloh, J.M. (2015) TriAngle: A Microsoft Excel™ spreadsheet template for the generation of triangular plots. N. Jahrb. Miner./J. Min. Geochem., 192, 1, 101-105. DOI: 10.1127/0077-7757/2014/0267

5007 Downloads
since August 24, 2014!

LibreOffice version:

TriAngle_1-2_open.ots (315 KB, Dec. 05, 2014)

In case of using the template in publications or other texts, please cite the following article:

Warnsloh, J.M. (2015) TriAngle: A Microsoft Excel™ spreadsheet template for the generation of triangular plots. N. Jahrb. Miner./J. Min. Geochem., 192, 1, 101-105. DOI: 10.1127/0077-7757/2014/0267

1865 Downloads
since December 5, 2014!

Older versions:

TriAngle 1.1.xltx (263 KB, Mar. 20, 2014)

TriAngle 1.0.xltx (188 KB, Dec. 19, 2012)

To get information about updates: