A VISUAL BASIC SPREADSHEET MACRO FOR ESTIMATING GROUNDWATER RECHARGE

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.