Fully Automated Objective-Based Method for Master Recession Curve Separation

The fully automated objective-based method for master recession curve (MRC) separation was developed by using Microsoft Excel spreadsheet and Visual Basic for Applications (VBA) code. The core of the program code is used to construct an MRC by using the adapted matching strip method (Posavec et al....

Full description

Saved in:
Bibliographic Details
Published in:Ground water 2010-07, Vol.48 (4), p.598-603
Main Authors: Posavec, Kristijan, Parlov, Jelena, Nakić, Zoran
Format: Article
Language:English
Subjects:
Automated
Codes
Croatia
Flow rate
Fresh Water
Groundwater
Mathematical models
Recession
Separation
Software
Spreadsheets
Statistics
Water Movements
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:The fully automated objective-based method for master recession curve (MRC) separation was developed by using Microsoft Excel spreadsheet and Visual Basic for Applications (VBA) code. The core of the program code is used to construct an MRC by using the adapted matching strip method (Posavec et al. 2006). Criteria for separating the MRC into two or three segments are determined from the flow-duration curve and are represented as the probable range of percent of flow rate duration. Successive separations are performed automatically on two and three MRCs using sets of percent of flow rate duration from selected ranges and an optimal separation model scenario, having the highest average coefficient of determination R², is selected as the most appropriate one. The resulting separated master recession curves are presented graphically, whereas the statistics are presented numerically, all in separate sheets. Examples of field data obtained from two springs in Istria, Croatia, are used to illustrate its application. The freely available Excel spreadsheet and VBA program ensures the ease of use and applicability for larger data sets.
ISSN:0017-467X
1745-6584
DOI:10.1111/j.1745-6584.2009.00669.x