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 Concept Videos

Response Surface Methodology01:16

Response Surface Methodology

Response Surface Methodology (RSM) is a collection of statistical and mathematical techniques used to develop, improve, and optimize processes. It is particularly valuable when many input variables or factors potentially influence a response variable.
The process of RSM involves several key steps:
Mechanistic Models: Compartment Models in Algorithms for Numerical Problem Solving01:29

Mechanistic Models: Compartment Models in Algorithms for Numerical Problem Solving

Mechanistic models play a crucial role in algorithms for numerical problem-solving, particularly in nonlinear mixed effects modeling (NMEM). These models aim to minimize specific objective functions by evaluating various parameter estimates, leading to the development of systematic algorithms. In some cases, linearization techniques approximate the model using linear equations.
In individual population analyses, different algorithms are employed, such as Cauchy's method, which uses a...
One-Compartment Open Model: Wagner-Nelson and Loo Riegelman Method for ka Estimation01:24

One-Compartment Open Model: Wagner-Nelson and Loo Riegelman Method for ka Estimation

This lesson introduces two critical methods in pharmacokinetics, the Wagner-Nelson and Loo-Riegelman methods, used for estimating the absorption rate constant (ka) for drugs administered via non-intravenous routes. The Wagner-Nelson method relates ka to the plasma concentration derived from the slope of a semilog percent unabsorbed time plot. However, it is limited to drugs with one-compartment kinetics and can be impacted by factors like gastrointestinal motility or enzymatic degradation.
On...
First Derivative Test: Problem Solving01:25

First Derivative Test: Problem Solving

Imagine an asset price that crashes to a low point, rebounds sharply as bargain-hunters step in, and then gradually declines. Such behavior can be modeled with a smooth function whose turning points represent locally overvalued and undervalued regions. A convenient example that captures rebound followed by decay is:The high and low points of this curve are identified using the first derivative test, which determines where the function changes from increasing to decreasing or vice versa. To...
Area Between Curves: Problem Solving01:27

Area Between Curves: Problem Solving

A region can be enclosed by three curves: a square root function, a reflected cube root function, and a linear function. The linear function intersects each of the other two curves, and these intersection points determine where the boundary of the enclosed region changes. Because different curves serve as the upper and lower boundaries in different parts of the graph, the area cannot be found using a single setup over the entire interval.To compute the area, the region is first divided into two...
Calibration Curves: Linear Least Squares01:20

Calibration Curves: Linear Least Squares

A calibration curve is a plot of the instrument's response against a series of known concentrations of a substance. This curve is used to set the instrument response levels, using the substance and its concentrations as standards. Alternatively, or additionally, an equation is fitted to the calibration curve plot and subsequently used to calculate the unknown concentrations of other samples reliably.
For data that follow a straight line, the standard method for fitting is the linear...

You might also read

Related Articles

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

Sort by
Same author

Tracing nitrate contamination sources and dynamics in an unconfined alluvial aquifer system (Velika Gorica well field, Croatia).

Environmental science. Processes & impacts·2024
Same author

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

Ground water·2017
Same author

A visual basic spreadsheet macro for geochemical background analysis.

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

Related Experiment Videos

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

Kristijan Posavec1, Jelena Parlov, Zoran Nakić

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

Ground Water
|January 27, 2010
PubMed
Summary
This summary is machine-generated.

A new automated method uses Excel and VBA to separate master recession curves (MRCs), simplifying hydrological analysis. This tool enhances the accuracy and efficiency of recession flow analysis for researchers.

Related Experiment Videos

Area of Science:

  • Hydrology
  • Water Resource Management
  • Environmental Science

Background:

  • Master recession curves (MRCs) are crucial for understanding groundwater and surface water interactions.
  • Traditional MRC separation methods can be subjective and time-consuming.
  • Objective and automated approaches are needed for efficient hydrological analysis.

Purpose of the Study:

  • To develop a fully automated, objective-based method for master recession curve (MRC) separation.
  • To implement the method using Microsoft Excel and Visual Basic for Applications (VBA).
  • To provide a user-friendly tool for hydrological data analysis.

Main Methods:

  • Developed an automated MRC separation method using an adapted matching strip approach.
  • Integrated flow-duration curve analysis to establish separation criteria.
  • Utilized VBA code within Excel for automated separation and optimal model selection based on R(2).

Main Results:

  • Successfully automated the master recession curve separation process.
  • Identified optimal separation scenarios with the highest average coefficient of determination (R(2)).
  • Presented separated MRCs graphically and statistics numerically, demonstrating ease of use with field data.

Conclusions:

  • The developed Excel/VBA tool provides an efficient and objective method for MRC separation.
  • The automated approach simplifies complex hydrological analyses, making it applicable to large datasets.
  • Freely available software facilitates wider adoption in hydrological research and practice.