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 recession curve analysis.

Kristijan Posavec1, Andrea Bacani, Zoran Nakić

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

Ground Water
|September 12, 2006
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 geochemical background analysis.

Ground water·2007
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

A new Visual Basic program for Excel simplifies groundwater recession analysis. It constructs a master recession curve (MRC) using regression models for accurate time series analysis.

Area of Science:

  • Hydrogeology
  • Environmental Science
  • Data Analysis

Background:

  • Groundwater level time series analysis is crucial for water resource management.
  • Traditional methods for constructing master recession curves (MRCs) can be complex and time-consuming.
  • Accurate recession analysis aids in understanding aquifer dynamics and predicting water availability.

Purpose of the Study:

  • To develop a user-friendly Visual Basic program for Excel to automate the construction of a master recession curve (MRC).
  • To apply adapted matching strip methods and multiple regression models for robust recession analysis of groundwater level data.
  • To demonstrate the program's versatility in analyzing other hydrological time series, such as stream discharge.

Main Methods:

  • Development of a Visual Basic for Applications (VBA) program integrated within Microsoft Excel.

Related Experiment Videos

  • Implementation of the adapted matching strip method for segmenting recession data.
  • Utilizing five distinct linear and nonlinear regression models to fit recession segments to the MRC.
  • Application of the program to field data from Croatia for validation.

    • Main Results:

    • Successful construction of MRCs for groundwater level time series using the developed program.
    • Demonstrated ability of the program to accurately adjust individual recession segments via regression analysis.
    • Validation of the program's effectiveness with real-world hydrological data.
    • The program's flexibility in analyzing stream discharge and stage time series was confirmed.

    Conclusions:

    • The developed Visual Basic program offers an efficient and effective tool for groundwater recession analysis.
    • The integration of multiple regression models enhances the accuracy and reliability of MRC construction.
    • The program's applicability extends beyond groundwater, proving useful for other hydrological time series analysis.
    • This tool can significantly aid researchers and practitioners in hydrogeology and water resource management.