XLKarst, an Excel tool for time series analysis, spring recession curve analysis and classification of karst aquifers

Journal article

Vincent Bailly-Comte, Bernard Ladouche, Jean-Baptiste Charlier, Vivien Hakoun, Jean-Christophe Maréchal
Hydrogeology Journal, vol. 31, 2023 Dec, pp. 2401--2415

DOI: 10.1007/s10040-023-02710-w

Cite

APA Click to copy
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. https://doi.org/10.1007/s10040-023-02710-w

Chicago/Turabian Click to copy
Bailly-Comte, Vincent, Bernard Ladouche, Jean-Baptiste Charlier, Vivien Hakoun, and Jean-Christophe Maréchal. “{XLKarst}, an {Excel} Tool for Time Series Analysis, Spring Recession Curve Analysis and Classification of Karst Aquifers.” Hydrogeology Journal 31 (December 2023): 2401–2415.

MLA Click to copy
Bailly-Comte, Vincent, et al. “{XLKarst}, an {Excel} Tool for Time Series Analysis, Spring Recession Curve Analysis and Classification of Karst Aquifers.” Hydrogeology Journal, vol. 31, Dec. 2023, pp. 2401–15, doi:10.1007/s10040-023-02710-w.

BibTeX Click to copy

@article{bailly-comte2023a,
  title = {{XLKarst}, an {Excel} tool for time series analysis, spring recession curve analysis and classification of karst aquifers},
  year = {2023},
  month = dec,
  journal = {Hydrogeology Journal},
  pages = {2401--2415},
  volume = {31},
  doi = {10.1007/s10040-023-02710-w},
  author = {Bailly-Comte, Vincent and Ladouche, Bernard and Charlier, Jean-Baptiste and Hakoun, Vivien and Maréchal, Jean-Christophe},
  month_numeric = {12}
}

Abstract
Karst aquifers are complex hydrogeological systems that require numerous in-situ measurements of hydrological and physico-chemical parameters to characterize transfer processes from the recharge area to the karst spring. Numerous graphical, statistical or signal processing methods have been developed for decades to interpret these measurements, but there is no simple and standardized tool that can be used for this purpose, which is necessary for a rigorous comparison of results between case studies. In this context, the XLKarst tool addresses the main issues related to the characterization of the hydrodynamic behavior of a karst aquifer by gathering and standardizing various methods in a single tool. This tool allows (i) analyzing time series based on correlation and spectral analysis and, for discharge measurements, the use of other statistics and baseflow separation, (ii) computing cumulative distribution function to build spring discharge probability plot and (iii) analyzing karst spring discharge recession. These methods are first described by providing some theoretical foundations and the key elements of their use and interpretation. Finally, an application to the Fontaine de Nîmes karst system highlights the ephemeral behavior of this system that is prone to Mediterranean flash floods.