geolmsuВЕСТНИК МОСКОВСКОГО УНИВЕРСИТЕТА. СЕРИЯ 4. ГЕОЛОГИЯMoscow University Bulletin. Series 4. Geology0579-9406Издательский Дом МГУ10.33623/0579-9406-2022-3-54-60geolmsu-497Research ArticleСтатьиGeochemical functions — надстройка для обработки минералого-геохимических данных в Microsoft ExcelGeochemical functions Add-In to MS Excel for geochemical and mineralogical data processingЗайцевВ. А.ZaitsevV. A.

Виктор Анатольевич Зайцев

Москва

Victor A. Zaitsev

Moscow

va_zaitsev@inbox.ruИнститут геохимии и аналитической химии имени В.И. Вернадского РАН (ГЕОХИ РАН)РоссияV.I. Vernadsky Institute for geochemistry and analytical chemistry RASRussian Federation202215122022035460Copyright © Зайцев В.А., 20222022Зайцев В.А.Zaitsev V.A.Данная работа распространяется под лицензией Creative Commons Attribution 4.0.This work is licensed under a Creative Commons Attribution 4.0 License.https://vestnik.geol.msu.ru/jour/article/view/497

Представлено описание программы-надстройки для Microsoft Excel, содержащей ряд функций для автоматизации рутинных операций, часто встречающихся при обработке минералогических и геохимических данных: нормировании величин, расчете формул минералов и статистической обработке анализов.

«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.

Microsoft Excel Add-insкомпьютерная программагеохимические вычислениярасчет формул минераловобработка неполных геохимических данныхобработка неравноточных результатовMicrosoft Excel Add-insgeochemical calculationscalculations of empirical formulas of mineralsprocessing of incomplete datathe weighted average of measurements with unequal errorsРабота выполнена в рамках темы по государственному заданию ГЕОХИ РАНReferencesРусяева Е.А. Теория математической обработки геодезических измерений: Учеб. пособие. Ч. I. Теория ошибок измерений. M.: МИИГАиК, 2016. 56 с.Русяева Е.А. Теория математической обработки геодезических измерений: Учеб. пособие. Ч. I. Теория ошибок измерений. M.: МИИГАиК, 2016. 56 с.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.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.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.011Brandelik 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.011Ersoy 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.007Ersoy 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.007Lodders 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_34Lodders 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_34Myshenkova 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.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.Palme H., O’Neill H.St.C. 3.1 — Cosmochemical estimates of mantle composition// Treatise on Geochemistry. 2014. Vol. 3. P. 1–39.Palme H., O’Neill H.St.C. 3.1 — Cosmochemical estimates of mantle composition// Treatise on Geochemistry. 2014. Vol. 3. P. 1–39.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/2005gc000932Petrelli 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/2005gc000932Putirka K. URL: http://www.fresnostate.edu/csm/ees/faculty-staff/putirka.html (дата обращения: 01.12.2021).Putirka K. URL: http://www.fresnostate.edu/csm/ees/faculty-staff/putirka.html (дата обращения: 01.12.2021).Putirka K. Geothermometry and Geobarometry // Encyclopedia of Earth Sci. Series. Springer. 2017. P. 597–614.Putirka K. Geothermometry and Geobarometry // Encyclopedia of Earth Sci. Series. Springer. 2017. P. 597–614.Schaefer L., Fegley B.Jr. A thermodynamic model of high temperature lava vaporization on Io // Icarus. 2004. Vol. 169. P. 216–241.Schaefer L., Fegley B.Jr. A thermodynamic model of high temperature lava vaporization on Io // Icarus. 2004. Vol. 169. P. 216–241.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. 2002GC000323Su 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. 2002GC000323Yavuz F. WinPyrox: A Windows program for pyroxene calculation classification and thermobarometry // Amer. Mineral. 2013. Vol. 98, N 7. P. 1338–1359.Yavuz F. WinPyrox: A Windows program for pyroxene calculation classification and thermobarometry // Amer. Mineral. 2013. Vol. 98, N 7. P. 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. Intern. 2018. Vol. 56, N 3. P. 211–225.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.Zhou J., Li X. GeoPlot: An Excel VBA program for geochemical data plotting // Computers & Geosciences. 2006. Vol. 32, N 4. P. 554–560.Zhou J., Li X. GeoPlot: An Excel VBA program for geochemical data plotting // Computers & Geosciences. 2006. Vol. 32, N 4. P. 554–560.

The authors declare that there are no conflicts of interest present.