A VISUAL BASIC PPREADSHEET MACRO FOR ESTIMATING GROUNDWATER RECHARGE

Abstract

A Visual Basic spreadsheet macro was written to automate the estimation of groundwater recharge from stream or spring hydrographs using the adapted Meyboom’s method. The program fits exponential regression model available in widely accessible platform (i.e. MS Excel) to baseflow recessions that precede and follow groundwater recharge, and uses regression equations to calculate recharge volume that occur between these recessions. An example of field data from Croatia (Bulaž spring) is given to illustrate its application.

Keywords

• groundwater recharge
• adapted Meyboom’s method