Premium
A Visual Basic Spreadsheet Macro for Recession Curve Analysis
Author(s) -
Posavec Kristijan,
Bačani Andrea,
Nakić Zoran
Publication year - 2006
Publication title -
groundwater
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.84
H-Index - 94
eISSN - 1745-6584
pISSN - 0017-467X
DOI - 10.1111/j.1745-6584.2006.00226.x
Subject(s) - recession , macro , matching (statistics) , series (stratigraphy) , computer science , visual basic , stage (stratigraphy) , econometrics , nonlinear system , statistics , mathematics , geology , economics , macroeconomics , programming language , paleontology , physics , software , quantum mechanics
A Visual Basic program for an Excel spreadsheet was written to construct a master recession curve (MRC), using the adapted matching strip method, for recession analysis of ground water level time series. The program uses five different linear/nonlinear regression models to adjust individual recession segments to their proper positions in the MRC. The program can also be used to analyze the recession segments of other time series, such as daily stream discharge or stage. Some examples of field data from Croatia are used to illustrate the usefulness of its application.