The XLKarst software was developed by BRGM, the French geological survey, as part of the Resource project in GEOERA, more specifically within Work Package 5 “Typology of karst aquifers and recommendations for their management” handled by BRGM.
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
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 the method of Lyne and Hollick (1979) and the procedure of Ladson et al. (2013),
- the ability to process multiple datasets in one run.
- correlation analysis and simple and cross-correlation spectral analysis according to the method of Jenkins and Watts (1968) adapted to karst hydrology by Mangin (1984).
- the analysis of recessions according to Mangin's method (1975) and the associated classification.
- analysis of recorded flow rates (Mangin, 1975), to highlight changes in hydrodynamic behaviour associated for example with the activation of overflow systems (Marsaud, 1997).
Examples of calculations made with XLKarst
Daily flow-rate record of the Fontaine de Nîmes and calculation of the associated baseline flow-rate according to the method of Lyne and Hollick (1979) and the procedure of Ladson et al. (2013).
Example of an autocorrelation function calculation (simple correlogram) for a daily rainfall and flow-rate record for the Fontaine de Nîmes karst system, with associated memory effect values.
Example of calculation of a cross-correlation function (cross-correlogram) for a daily rainfall and flow-rate record of the Fontaine de Nîmes karst system, with the values (offset and correlation) relative to the correlation peak.
Example of a power spectrum function calculation for a 15 min. time step flow-rate record of the Fontaine de Nîmes karst system, highlighting the period beyond which the spectrum characterises a random phenomenon.
Example of the result of the recession analysis (flood recession + drying up) according to the Mangin method (1975) applied to the Fontaine de Nîmes.
Consortium behind the XLKarst software
XLKarst was developed by BRGM in the framework of the CHAlk and KArst Aquifer (CHAKA) working group of the GeoERA RESOURCE project (H2020 ERA-NET), with the collaboration of several European geological surveys.
Bailly-Comte, V., Ladouche, B., Charlier, J.B., Hakoun, V., Maréchal, J.C., 2023. XLKarst, an Excel tool for time series analysis, spring recession curve analysis and classification of karst aquifers. Hydrogeology Journal 31, 2401–2415.
Jenkins, G. M. and Watts, D. G. (1968) Spectral Analysis and Its Applications Holden-Day. San Francisco, 243-238.
Hakoun, V., Bailly-Comte V., Charlier JB., Herms I., Hickey C., Pardo-Igúzquiza E., Stroj A., Van Vliet M., Vernes R., Maréchal, JC. (2020) Karst typology in Europe: state of the art, GeoERA Report, 42.
Ladson, A. R., R. Brown, B. Neal and R. Nathan (2013) A standard approach to baseflow separation using the Lyne and Hollick filter. Australian Journal of Water Resources 17(1): 173-18
Lyne, V. and Hollick, M. (1979) Stochastic time-variable rainfall-runoff modelling. In: pp. 89-93 Institute of Engineers Australia National Conference. Perth.
Mangin, A. (1971) Etude des débits classés d’exutoires karstiques portant sur un cycle hydrologique, Annales de spéléologie, t 26, 2, pp 283,329.
Mangin, A. (1975) Contribution à l‘étude hydrodynamique des aquifères karstiques, PhD thesis, Université de Dijon, Dijon, France, 1975. https://hal.archives-ouvertes.fr/tel-01575806
Mangin, A. (1984) Pour une meilleure connaissance des systèmes hydrologiques à partir des analyses corrélatoire et spectrale, J. Hydrol., 67, 25–43, https://doi.org/10.1016/0022-1694(84)90230-0, 1984.
Marsaud, B. (1997) Structure et fonctionnement de la zone noyée des karsts à partir des résultats expérimentaux. Université Paris XI Orsay.