hrcak mascot   Srce   HID

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 icon 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

Fulltext: english, pdf (2 MB) pages 25-32 downloads: 545* cite
APA 6th Edition
Posavec, K., Vukojević, P., Ratkaj, M. & Bedeniković, T. (2017). CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION. Rudarsko-geološko-naftni zbornik, 32 (1), 25-32. https://doi.org/10.17794/rgn.2017.1.4
MLA 8th Edition
Posavec, Kristijan, et al. "CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION." Rudarsko-geološko-naftni zbornik, vol. 32, no. 1, 2017, pp. 25-32. https://doi.org/10.17794/rgn.2017.1.4. Accessed 15 Nov. 2019.
Chicago 17th Edition
Posavec, Kristijan, Perica Vukojević, Matija Ratkaj and Tea Bedeniković. "CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION." Rudarsko-geološko-naftni zbornik 32, no. 1 (2017): 25-32. https://doi.org/10.17794/rgn.2017.1.4
Harvard
Posavec, K., et al. (2017). 'CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION', Rudarsko-geološko-naftni zbornik, 32(1), pp. 25-32. https://doi.org/10.17794/rgn.2017.1.4
Vancouver
Posavec K, Vukojević P, Ratkaj M, Bedeniković T. CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION. Rudarsko-geološko-naftni zbornik [Internet]. 2017 [cited 2019 November 15];32(1):25-32. https://doi.org/10.17794/rgn.2017.1.4
IEEE
K. Posavec, P. Vukojević, M. Ratkaj and T. Bedeniković, "CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION", Rudarsko-geološko-naftni zbornik, vol.32, no. 1, pp. 25-32, 2017. [Online]. https://doi.org/10.17794/rgn.2017.1.4
Fulltext: croatian, pdf (133 KB) pages 32-32 downloads: 110* cite
APA 6th Edition
Posavec, K., Vukojević, P., Ratkaj, M. & Bedeniković, T. (2017). KROSKORELACIJSKO MODELIRANJE INTERAKCIJE POVRŠINSKIH I PODZEMNIH VODA PRIMJENOM APLIKACIJE EXCEL. Rudarsko-geološko-naftni zbornik, 32 (1), 32-32. https://doi.org/10.17794/rgn.2017.1.4
MLA 8th Edition
Posavec, Kristijan, et al. "KROSKORELACIJSKO MODELIRANJE INTERAKCIJE POVRŠINSKIH I PODZEMNIH VODA PRIMJENOM APLIKACIJE EXCEL." Rudarsko-geološko-naftni zbornik, vol. 32, no. 1, 2017, pp. 32-32. https://doi.org/10.17794/rgn.2017.1.4. Accessed 15 Nov. 2019.
Chicago 17th Edition
Posavec, Kristijan, Perica Vukojević, Matija Ratkaj and Tea Bedeniković. "KROSKORELACIJSKO MODELIRANJE INTERAKCIJE POVRŠINSKIH I PODZEMNIH VODA PRIMJENOM APLIKACIJE EXCEL." Rudarsko-geološko-naftni zbornik 32, no. 1 (2017): 32-32. https://doi.org/10.17794/rgn.2017.1.4
Harvard
Posavec, K., et al. (2017). 'KROSKORELACIJSKO MODELIRANJE INTERAKCIJE POVRŠINSKIH I PODZEMNIH VODA PRIMJENOM APLIKACIJE EXCEL', Rudarsko-geološko-naftni zbornik, 32(1), pp. 32-32. https://doi.org/10.17794/rgn.2017.1.4
Vancouver
Posavec K, Vukojević P, Ratkaj M, Bedeniković T. KROSKORELACIJSKO MODELIRANJE INTERAKCIJE POVRŠINSKIH I PODZEMNIH VODA PRIMJENOM APLIKACIJE EXCEL. Rudarsko-geološko-naftni zbornik [Internet]. 2017 [cited 2019 November 15];32(1):32-32. https://doi.org/10.17794/rgn.2017.1.4
IEEE
K. Posavec, P. Vukojević, M. Ratkaj and T. Bedeniković, "KROSKORELACIJSKO MODELIRANJE INTERAKCIJE POVRŠINSKIH I PODZEMNIH VODA PRIMJENOM APLIKACIJE EXCEL", Rudarsko-geološko-naftni zbornik, vol.32, no. 1, pp. 32-32, 2017. [Online]. https://doi.org/10.17794/rgn.2017.1.4

Abstracts
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

[croatian]

Visits: 915 *