XLKarst rapidly implements various methods classically used in karst hydrology for the hydrodynamic characterisation of karst systems.

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).

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.

XLKarst software partners

XLKarst software partners.

© BRGM

References

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.

Installation of a measuring station, Jura

Form for downloading XLKarst

Please complete the form below. You will then receive an email with a link to download the software.
* Indicates required field

Your need

Your message

Please tick the boxes for the type of information you would like to receive

Your contact details

Validate the form

To validate this form, read our data protection policy and validate the security test to confirm that you are a human user.

About the personal data collected on this form

  • Purpose of the form: enable BRGM to reply to you following a request for information on its software, or to enable you to download software made available by BRGM.
  • Users of the data provided: the departments in charge of communication and user of information systems reception, support and assistance, and software management, who may share the data with persons or departments concerned by your request in-house at BRGM and/or with subcontractors or service providers.

Your rights

Within the limits of the Regulation, in particular Articles 15 to 22 of the GDPR and having provided proof of identity, you have:

  • the right of information and access to your personal data,
  • the right to have your personal data rectified,
  • the right to delete or limit processing of your personal data.

To exercise these rights, please contact our data protection officer at: dpo@brgm.fr.
Any request that constitutes an abuse of current laws and regulations may be rejected.
More information on the policy for third-party personal data protection