Jean-Christophe Maréchal Hydrogeologist Karst Fractured

Tool: XL Karst for the classification of karst springs

XLKarst’s features: application of correlative and spectral methods, analysis of flood receding and recessions of karst outlets and analysis of recorded flow-rate data, developed by Vincent Bailly-Comte

The XLKarst interface is a list of menus in the Excel add-ins menu bar that allow you to activate different spreadsheets for:

the statistical description of the flow-rate series, with:
- the calculation of the most common statistical descriptors,
- the calculation of statistical parameters specific to karst hydrogeology according to the methods proposed by Mangin (1984), namely the memory effect from the autocorrelation function and the regulation time from the spectral analysis,
- the calculation of the Base Flow Index (BFI) with a time step of one day, using several methods
- the ability to process multiple datasets in one run.
correlation analysis and simple and cross-correlation spectral analysis
the analysis of recessions according to Mangin's method and the associated classification.
analysis of recorded flow rates, to highlight changes in hydrodynamic behaviour associated for example with the activation of overflow systems.

Download XLKARST on BRGM website

Tool: ESPERE code for the evaluation of aquifer recharge

ESPERE is a Microsoft Excel 2016© application which allows to apply several commonly-used methods to rapidly and simultaneously estimate groundwater recharge, developed by Sandra Lanini. 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).

Based on various approaches that make use of different types of data, ESPERE provides both an estimate of aquifer recharge and a confidence interval on the results. ESPERE has been designed to limit as much as possible the number and type of parameters to be provided by the user, so that it can be applied in a large number of contexts, including those where knowledge is limited.