Skip to the main content

Original scientific paper

https://doi.org/10.17794/rgn.2017.1.4

CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION

Kristijan Posavec orcid id orcid.org/0000-0002-5392-9329 ; University of Zagreb, Faculty of Mining, Geology and Petroleum Engineering, Pierottijeva 6, 10000 Zagreb, Associate Professor, PhD
Perica Vukojević ; Geotehnički studio Ltd. Zagreb, Nikole Pavića 11, 10090 Zagreb, Mag.Ing.Geol
Matija Ratkaj ; IHK Karlovac, Selce 25, 47000 Karlovac, Mag.Ing.Geol.
Tea Bedeniković ; University of Zagreb, Faculty of Mining, Geology and Petroleum Engineering, Pierottijeva 6, 10000 Zagreb, Graduate student


Full text: croatian pdf 133 Kb

page 32-32

downloads: 486

cite

Full text: english pdf 1.975 Kb

page 25-32

downloads: 1.184

cite


Abstract

Modelling responses of groundwater levels in aquifer systems, which occur as a reaction to changes in aquifer system boundary conditions such as river or stream stages, is commonly being studied using statistical methods, namely correlation, cross-correlation and regression methods. Although correlation and regression analysis tools are readily available in Microsoft Excel, a widely applied spreadsheet industry standard, the cross-correlation analysis tool is missing. As a part of research of groundwater pressure propagation into alluvial aquifer systems of the Sava and Drava/Danube River catchments following river stages rise, focused on estimating groundwater pressure travel times in aquifers, an Excel spreadsheet data analysis application for cross-correlation modelling has been designed and used in modelling surface water – groundwater interaction. Examples of fi eld data from the Zagreb aquifer system and the Kopački rit Nature Park aquifer system are used to illustrate the usefulness of the cross-correlation application.

Keywords

cross-correlation; Excel spreadsheet application; surface water-groundwater interaction

Hrčak ID:

172691

URI

https://hrcak.srce.hr/172691

Publication date:

20.12.2016.

Article data in other languages: croatian

Visits: 3.233 *