A visual basic spreadsheet macro for recession curve analysis.
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.
Posavec
Kristijan
K
Faculty of Mining, Geology and Petroleum Engineering, Department of Geology and Geological Engineering, University of Zagreb, Pierottijeva 6, Zagreb, 10000, Croatia. kposavec@rgn.hr
Bacani
Andrea
A
Nakić
Zoran
Z
D000465:Algorithms; D017523:Croatia; D008962:Models, Theoretical; D012044:Regression Analysis; D012984:Software; D014872:Water Movements; D014881:Water Supply