用于衰退曲线分析的Visual Basic电子表格宏。

A visual basic spreadsheet macro for recession curve analysis.

作者信息

Posavec Kristijan, Bacani Andrea, Nakić Zoran

机构信息

Faculty of Mining, Geology and Petroleum Engineering, Department of Geology and Geological Engineering, University of Zagreb, Pierottijeva 6, Zagreb, 10000, Croatia.

出版信息

Ground Water. 2006 Sep-Oct;44(5):764-7. doi: 10.1111/j.1745-6584.2006.00226.x.

DOI:10.1111/j.1745-6584.2006.00226.x

PMID:16961500

Abstract

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.

摘要

编写了一个用于Excel电子表格的Visual Basic程序，以使用改进的匹配带方法构建主衰退曲线（MRC），用于地下水位时间序列的衰退分析。该程序使用五种不同的线性/非线性回归模型将各个衰退段调整到MRC中的适当位置。该程序还可用于分析其他时间序列的衰退段，如日流量或水位。使用克罗地亚的一些现场数据示例来说明其应用的实用性。