Geochemical functions Add-In to MS Excel for geochemical and mineralogical data processing
https://doi.org/10.33623/0579-9406-2022-3-54-60
Abstract
«Geochemical functions» is a new free Add-In to MS Excel for geochemists and mineralogists. It implements useful functions for routine operations in geochemical and mineralogical calculations: abundance normalization, calculations of empirical formula coeffi cients from chemical and EMPA analyses, statistical operations with partial and unequal data.
About the Author
V. A. Zaitsev
V.I. Vernadsky Institute for geochemistry and analytical chemistry RAS
Russian Federation
Russian Federation
Victor A. Zaitsev
Moscow
References
1. Русяева Е.А. Теория математической обработки геодезических измерений: Учеб. пособие. Ч. I. Теория ошибок измерений. M.: МИИГАиК, 2016. 56 с.
2. Bernhardt H.J. MINCALC-V5 a non EXCEL based computer program for general electron-microprobe mineral analyses data processing // Acta Mineralogica-Petrographica. Abstr. Ser. 2010. Vol. 6. P. 869.
3. Brandelik A. CALCMIN — an EXCEL™ Visual Basic application for calculating mineral structural formulae from electron microprobe analyses // Computers & Geosci. 2010. Vol. 35, N 7. P. 1540–1551. DOI: 10.1016/j.cageo.2008.09.011
4. Ersoy E.Y., Helvacı C. FC-AFC-FCA and mixing modeler: A Microsoft ® Excel© spreadsheet program for modeling geochemical diff erentiation of magma by crystal fractionation, crustal assimilation and mixing // Computers & Geosci. 2009. Vol. 36, N 3. P. 383–390. DOI: 10.1016/j.cageo.2009.06.007
5. Lodders K., Palme, H., Gail H.-P. 4.4 Abundances of the elements in the Solar System. Landolt-Börnstein — Group VI // Astronomy and Astrophysics. 2009. Vol. 4B. P. 712–770. DOI: 10.1007/978-3-540-88055-4_34
6. Myshenkova M.S., Zaitsev V.A., Th omson S. et al. Th ermal history of the Guli pluton (North of the Siberian platform) according to apatite fi ssion-track dating and computer modeling // Geodynamics & Tectonophysics. 2020. Vol. 11, N 1. P. 75–87.
7. Palme H., O’Neill H.St.C. 3.1 — Cosmochemical estimates of mantle composition// Treatise on Geochemistry. 2014. Vol. 3. P. 1–39.
8. Petrelli M., Poli G., Perugini D., Peccerillo A. PetroGraph: A new soft ware to visualize, model, and present geochemical data in igneous petrology // Geochem., Geophys., Geosystems. 2005. Vol. 6, N 7. P. 1–15. DOI:10.1029/2005gc000932
9. Putirka K. URL: http://www.fresnostate.edu/csm/ees/faculty-staff/putirka.html (дата обращения: 01.12.2021).
10. Putirka K. Geothermometry and Geobarometry // Encyclopedia of Earth Sci. Series. Springer. 2017. P. 597–614.
11. Schaefer L., Fegley B.Jr. A thermodynamic model of high temperature lava vaporization on Io // Icarus. 2004. Vol. 169. P. 216–241.
12. Su Y., Langmuir C.H., Asimow P. PetroPlot: A plotting and data management tool set for Microsoft Excel // Geochem., Geophys., Geosystems. 2003. Vol. 4, N 3. P. 2002GC000323
13. Yavuz F. WinPyrox: A Windows program for pyroxene calculation classification and thermobarometry // Amer. Mineral. 2013. Vol. 98, N 7. P. 1338–1359.
14. 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. Intern. 2018. Vol. 56, N 3. P. 211–225.
15. Zhou J., Li X. GeoPlot: An Excel VBA program for geochemical data plotting // Computers & Geosciences. 2006. Vol. 32, N 4. P. 554–560.
Review
For citations:
Zaitsev V.A. Geochemical functions Add-In to MS Excel for geochemical and mineralogical data processing. Moscow University Bulletin. Series 4. Geology. 2022;(3):54-60. (In Russ.) https://doi.org/10.33623/0579-9406-2022-3-54-60
Views:
454
Email this article 
