ESPERE: estimating effective rainfall and aquifer recharge by different methods

ESPERE v1.5: Home page and data input page.
© BRGM
New - April 2020 - ESPERE Version 2
ESPERE is a Microsoft Excel 2016© application which allows to apply several commonly-used methods to rapidly and simultaneously estimate groundwater recharge. According to the available data, the user can apply and compare the results of three empirical methods (Guttman, Turc and Kessler), three slightly different water budget methods (Thornthwaite, Dingman and Edijatno & Michel), the water table fluctuation (WTF) method and three hydrograph separation algorithms (Wallingford, Chapman and Eckhardt).
The first version of ESPERE (v1.52) can be freely downloaded on the BRGM website since 2016. To account for user feedbacks, ESPERE has been recently improved and new facilities were added. A new release is now available (v2.44 available in April 2020) which includes the following developments:

ESPERE v1.5: Results page.
© BRGM
- WTF method implementation accounts for the continuously aquifer drainage (correction for the unrealized recessions are added to the water level rise);
- ESPERE version 2 proposes automatic estimation of several parameters such as the effective precipitation infiltration ratio for water budget methods, the specific yield for WTF, the recession coefficient and BFImax for the hydrograph separation algorithms;
- The Edijatno & Michel water budget method was added in ESPERE version 2;
- Missing values in water level time series and discharge time series are automatically filled in.
A User Guide is provided with this new release of ESPERE. It is a short translation of the detailed report BRGM/RP-69538-FR (in french). The User Guide rapidly describes the new facilities included in ESPERE version 2. It also comprises a step-by-step tutorial to run a simulation with ESPERE version 2. Finally, all the improvements and corrections implemented since the release 1.52 are listed in Annex.
Publication
-
S.Lanini, Y. Caballero, J.-J. Seguin, J.-C. Maréchal (2015).ESPERE, a multi-method Microsoft Excel application for estimating aquifer recharge
-
User guide for ESPERE version 2(PDF, 1 MB)
-
Lanini S. and Caballero Y. (2020) ESPERE, a Tool for Multimethod Aquifer Recharge Estimation: What's New with Version 2? Groundwater
Practical information
- Latest version : 2.44, 03/24/2020
- Operating system: Windows
- Programming language: VBA Excel
- Languages: French and English
