Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

A visual basic spreadsheet macro for geochemical background analysis.

Zoran Nakić1, Kristijan Posavec, Andrea Bacani

  • 1Faculty of Mining, Geology and Peteroleum Engineering, Department of Geology and Geological Engineering, University of Zagreb, Pierottijeva 6, Zagreb, 10000, Croatia. znakic@rgn.hr

Ground Water
|September 1, 2007
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Method and Excel VBA Algorithm for Modeling Master Recession Curve Using Trigonometry Approach.

Ground water·2017
Same author

Fully automated objective-based method for master recession curve separation.

Ground water·2010
Same author

A visual basic spreadsheet macro for recession curve analysis.

Ground water·2006
Same journal

Computing Flow-Field Distortion Coefficients from Well-Construction and Formation Properties.

Ground water·2026
Same journal

Leaky Sewers Hydraulically Disconnect from Groundwater: A Proof-of-Concept.

Ground water·2026
Same journal

Python-Based Model Emulation Workflows with PEST.

Ground water·2026
Same journal

Hydrogeology in the Age of AI and Climate Change.

Ground water·2026
Same journal

Aquifer Thermal Energy Storage: Groundwater for Efficient Data Center Cooling in the United States.

Ground water·2026
Same journal

Simulating the Impacts of Deep Geothermal Development on Shallow Hydrothermal Resources in a Rocky Mountain Rift Valley.

Ground water·2026
See all related articles

This study introduces a Visual Basic macro, BACKGROUND, for calculating geochemical background and threshold values. It automates the analysis of chemical parameters using statistical methods within MS Excel.

Area of Science:

  • Geochemistry
  • Environmental Science
  • Data Analysis

Background:

  • Geochemical data analysis often requires objective methods to distinguish background values from anomalies.
  • Manual calculation of these values can be time-consuming and prone to error.

Purpose of the Study:

  • To develop an automated tool for calculating geochemical background and threshold values.
  • To integrate advanced statistical methods into a user-friendly platform.

Main Methods:

  • Development of a Visual Basic macro named BACKGROUND.
  • Implementation of the iterative 2-sigma technique.
  • Integration of the calculated distribution function method.

Main Results:

Related Experiment Videos

  • The macro automates the processing of geochemical data.
  • Automated generation of background ranges and threshold values for chemical parameters is achieved.
  • Objective, model-based methods are made accessible via MS Excel.

    • Conclusions:

    • The BACKGROUND macro provides an efficient and accessible solution for geochemical data analysis.
    • It enhances the ability to identify anomalies in geochemical datasets.
    • The tool facilitates objective interpretation of geochemical parameters.