ARMADILLO_VolcaNorm is a versatile, user-friendly, open-source, macro-enabled spreadsheet that can rapidly calculate CIPW normative mineralogy (viz., "a norm") and classify volcanic rocks following IUGS recommendations entirely within the Microsoft ExcelTM environment. The program can process up to 10,000 major-element analyses of volcanic rocks, with the user specifying whether total iron is reported as FeO* or Fe2O3* and selecting one of seven methods of re-partitioning iron (or providing a custom value), including options that incorporate temperature, pressure, redox buffer, and offset. ARMADILLO_VolcaNorm outputs the FeO/FeO* ratio for each sample, computes the normative mineralogy, and applies total alkali-silica (TAS) and norm-based criteria for accurate classification. It can also generate customizable TAS diagrams with labeled samples. Unlike previous tools, ARMADILLO_VolcaNorm operates seamlessly within Excel, enabling simple copy-and-paste workflows and enhancing reproducibility and accessibility in igneous petrology.

ARMADILLO_VolcaNorm: An open-source, macro-enabled VBA for Excel™ spreadsheet for calculation of CIPW norms and IUGS igneous rock classification for volcanic rocks

Lucci, Federico
2026-01-01

Abstract

ARMADILLO_VolcaNorm is a versatile, user-friendly, open-source, macro-enabled spreadsheet that can rapidly calculate CIPW normative mineralogy (viz., "a norm") and classify volcanic rocks following IUGS recommendations entirely within the Microsoft ExcelTM environment. The program can process up to 10,000 major-element analyses of volcanic rocks, with the user specifying whether total iron is reported as FeO* or Fe2O3* and selecting one of seven methods of re-partitioning iron (or providing a custom value), including options that incorporate temperature, pressure, redox buffer, and offset. ARMADILLO_VolcaNorm outputs the FeO/FeO* ratio for each sample, computes the normative mineralogy, and applies total alkali-silica (TAS) and norm-based criteria for accurate classification. It can also generate customizable TAS diagrams with labeled samples. Unlike previous tools, ARMADILLO_VolcaNorm operates seamlessly within Excel, enabling simple copy-and-paste workflows and enhancing reproducibility and accessibility in igneous petrology.
File in questo prodotto:
Non ci sono file associati a questo prodotto.

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11586/569761
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo

Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus ND
  • ???jsp.display-item.citation.isi??? 0
social impact