TY - JOUR AU - Posavec, Kristijan AU - Vukojević, Perica AU - Ratkaj, Matija AU - Bedeniković, Tea PY - 2016/12/17 Y2 - 2024/03/29 TI - Cross-correlation Modelling of Surface Water – Groundwater Interaction Using the Excel Spreadsheet Application JF - Rudarsko-geološko-naftni zbornik JA - Rud.-geol.-naft. zb. VL - 32 IS - 1 SE - Geology DO - 10.17794/rgn.2017.1.4 UR - https://hrcak.srce.hr/ojs/index.php/rgn/article/view/4444 SP - 25-32 AB - <p>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.</p> ER -