Abstract
An add-on for Microsoft Excel is described. The program includes several functions to automatize the routine operations used commonly in mineralogical and geochemical data processing, such as abundance normalization, calculation of mineral formulas, and statistical treatment of analyses.
Similar content being viewed by others
REFERENCES
Bernhardt, H.J., MINCALC-V5 a non EXCEL based computer program for general electron-microprobe mineral analyses data processing, Acta Mineral.–Petrogr. Abstr. Ser., 2010, vol. 6.
Brandelik, A., CALCMIN – an EXCEL™ Visual Basic application for calculating mineral structural formulae from electron microprobe analyses, Comp. Geosci., 2010, vol. 35, no. 7, pp. 1540–1551. https://doi.org/10.1016/j.cageo.2008.09.011
Ersoy, E.Y. and Helvacı C., FC-AFC-FCA and mixing modeler: A Microsoft ® Excel© spreadsheet program for modeling geochemical differentiation of magma by crystal fractionation, crustal assimilation and mixing, Comp. Geosci., 2009, vol. 36, no. 3, pp. 383–390. https://doi.org/10.1016/j.cageo.2009.06.007
Lodders, K., Palme, H., and Gail, H.-P., Abundances of the elements in the Solar System, in Landolt-Bornstein, Group VI: Astronomy and Astrophysics, 2009, vol. 4B, pp. 712–770. https://doi.org/10.1007/978-3-540-88055-4_34
Myshenkova, M.S., Zaitsev, V.A., and Thomson, S., et al., Thermal history of the Guli pluton (North of the Siberian Platform) according to apatite fission-track dating and computer modeling, Geodynam. Tectonophys., 2020, vol. 11, no. 1, pp. 75–87.
Palme, H. and O’Neill, H.St.C., Cosmochemical estimates of mantle composition, Treatise on Geochemistry, 2014, vol. 3, pp. 1–39.
Petrelli, M., Poli, G., Perugini, D., and Peccerillo, A., PetroGraph: a new soft ware to visualize, model, and present geochemical data in igneous petrology, Geochem., Geophys., Geosyst., 2005, vol. 6, no. 7, pp. 1–15. https://doi.org/10.1029/2005gc000932
Putirka, K., Geothermometry and geobarometry, in Encyclopedia of Earth. Sci. Ser., Springer, 2017, pp. 597–614.
Putirka, K., http://www.fresnostate.edu/csm/ees/faculty-staff/putirka.html. Cited December 1, 2021
Rusyaeva, E.A., Teoriya matematicheskoi obrabotki geodezicheskikh izmerenii: Ucheb. posobie. Ch. I. Teoriya oshibok izmerenii (The Theory of Mathematical Processing of Geodetic Measurements. Part 1. Theory of Measurement Errors), Moscow: MIIGAiK, 2016.
Schaefer, L. and Fegley, B., A thermodynamic model of high temperature lava vaporization on Io, Icarus, 2004, vol. 169, pp. 216–241.
Su, Y., Langmuir, C.H., and Asimow, P., PetroPlot: a plotting and data management tool set for Microsoft Excel, Geochem., Geophys., Geosyst., 2003, vol. 4, no. 3. https://doi.org/10.1029/2002GC000323
Yavuz, F., Winpyrox: a Windows program for pyroxene calculation classification and thermobarometry, Am. Mineral., 2013, vol. 98, no. 7, pp. 1338–1359.
Zaitsev, V.A., Elizarov, D.V., Bychkova, Y.V., et al., First data on the geochemistry and age of the Kontay intrusion in Polar Siberia, Geochem. Int., 2018, vol. 56, no. 3, pp. 211–225.
Zhou, J. and Li, X., Geoplot: an Excel VBA program for geochemical data plotting, Comp. Geosci., 2006, vol. 32, no. 4, pp. 554–560.
Funding
The work was carried out within the State Assignment for the Institute for Geochemistry and Analytical Chemistry, Russian Academy of Sciences.
Author information
Authors and Affiliations
Corresponding author
Ethics declarations
The author declares that he has no conflicts of interest.
Additional information
Translated by A. Rylova
About this article
Cite this article
Zaitsev, V.A. Geochemical Functions: Add-ins to MS Excel for Geochemical and Mineralogical Data Processing. Moscow Univ. Geol. Bull. 77, 411–417 (2022). https://doi.org/10.3103/S0145875222040111
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.3103/S0145875222040111