Skip to main content
SpringerLink
Log in

HNC-Plot: an excel VBA for visualization of helium, nitrogen and CO2 isotope data of crustal and mantle gases

  • Software Article
  • Published:
Earth Science Informatics Aims and scope Submit manuscript

Abstract

We present HNC-Plot, an Excel Visual Basic Application (Excel VBA) that can easily be used to create graphical plots of fluids associated with volcanic gases or geothermal manifestations, based on their helium, nitrogen and CO2 isotope data. HNC-Plot has been designed in a simple way; all the user has to do is to input data in an Excel spreadsheet. The spreadsheet also contains buttons which have links to Excel VBA codes that generate plots. Once, the respective button is clicked, and all required variables are defined, Excel VBA generates a plot with labels and axes. Based upon the user preferences, additional tasks such as construction of mixing lines between mantle and crustal gases or calculation of end-member proportions can also be performed. We sincerely believe geoscientists can quickly and easily create these plots, free of charge, with this application. This study also presents previously published data from related literature to show the foundations of the application and to present sample plots created with it.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13
Fig. 14
Fig. 15

Similar content being viewed by others

References

  • Clark ID, Fritz P (1997) Environmental isotopes in hydrogeology. Lewis Publishers, New York

    Google Scholar 

  • Clarke WB, Jenkins WJ, Top Z (1976) Determination of tritium by mass spectrometric measurements of 3He. Int J Appl Radiat Isot 27(9):515–522. doi:10.1016/0020-708X(76)90082-X

    Article  Google Scholar 

  • Craig H, Lupton JE, Horibe Y (1978) A mantle helium component in circum Pacific volcanic glasses: Hakone, the Marianas and Mt Lassen, In: Alexander EC, Ozima M (eds), Terrestrial Rare Gases Japan Science Society Press, Tokyo, 3–16.

  • Fischer TP, Hilton DR, Zimmer MM, Shaw AM, Sharp ZD, Walker JA (2002) Subduction and recycling of nitrogen along the central American margin. Science 297(5584):1154–1157. doi:10.1126/science.1073995

    Article  Google Scholar 

  • Giggenbach WF, Sano Y, Wakita H (1993) Isotopic composition of helium, and CO2 and CH4 contents in gases produced along the New Zealand part of a convergent plate boundary, Geochim Cosmochim Acta, 57(14), 3427–3455, doi:10.1016/0016–7037(93)90549-C.

  • Karakuş H, Şimşek Ş (2013) Tracing deep thermal water circulation systems in the E–W trending Büyük Menderes Graben, western Turkey. J Volcanol Geotherm Res 252:38–52. doi:10.1016/j.jvolgeores.2012.11.006

    Article  Google Scholar 

  • Mutlu H, Güleç N, Hilton DR (2008) Helium–carbon relationships in geothermal fluids of western Anatolia, Turkey. Chem Geol 247(1–2):305–321. doi:10.1016/j.chemgeo.2007.10.021

    Article  Google Scholar 

  • O’Nions RK, Oxburgh ER (1988) Helium, volatile fluxes and the development of continental crust, Earth and Planet. Sci Lett 90(3):331–347. doi:10.1016/0012-821X(88)90134-3

    Google Scholar 

  • Piper AM (1944) A graphic procedure in the geochemical interpretation of water-analyses. EOS Trasn Am Geophys Union 25(6):914–923. doi:10.1029/TR025i006p00914

    Article  Google Scholar 

  • Sano Y, Marty B (1995) Origin of carbon in fumarolic gas from island arcs. Chem Geol 119(1–4):265–274. doi:10.1016/0009-2541(94)00097-R

    Article  Google Scholar 

  • Sano Y, Wakita H (1985) Geographical distribution of 3He/4He ratios in Japan: implications for arc tectonics and incipient magmatism. J Geophys Res 90(B10):8729–8741. doi:10.1029/JB090iB10p08729

    Article  Google Scholar 

  • Sano Y, Takahata N, Nishio Y, Fischer TP, Williams SN (2001) Volcanic flux of nitrogen from the earth. Chem Geol 171(3–4):263–271. doi:10.1016/S0009-2541(00)00252-7

    Article  Google Scholar 

  • Weiss RF (1971) Solubility of helium and neon in water and seawater. J Chem Eng Data 16(2):235–241. doi:10.1021/je60049a019

    Article  Google Scholar 

  • Wiersberg T, Süer S, Güleç N, Erzinger J, Parlaktuna M (2011) Noble gas isotopes and the chemical composition of geothermal gases from the eastern part of the Büyük Menderes Graben (Turkey). J Volcanol Geotherm Res 208. doi:10.1016/j.jvolgeores.2011.09.009

Download references

Acknowledgments

The authors would like to thank the two anonymous reviewers for the valuable review, comments, and suggestions which improved the manuscript.

Availability and requirements

HNC-Plot program can be requested via an e-mail to the authors, without any charge. (huseyin.karakus@dpu.edu.tr, harun@yyu.edu.tr). HNC-Plot is a macro-enabled Microsoft Excel (HNC-Plot.xlsm) file compatible with Windows 7 (or higher), and can be applied in Microsoft Excel 2007 or higher.

Author information

Authors and Affiliations

  1. Department of Geological Engineering, Dumlupınar University, Kütahya, Turkey

    Hüseyin Karakuş

  2. Department of Environmental Engineering, Yüzüncü Yıl University, Van, Turkey

    Harun Aydin

Authors
  1. Hüseyin Karakuş
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Harun Aydin
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Hüseyin Karakuş.

Additional information

Communicated by: H. A. Babaie

Electronic supplementary material

ESM 1

(XLSM 2614 kb)

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Karakuş, H., Aydin, H. HNC-Plot: an excel VBA for visualization of helium, nitrogen and CO2 isotope data of crustal and mantle gases. Earth Sci Inform 10, 115–125 (2017). https://doi.org/10.1007/s12145-016-0272-4

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s12145-016-0272-4

Keywords

Search

Navigation