CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION
Journal Title: UNKNOWN - Year 2017, Vol 32, Issue 1
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.
Authors and Affiliations
Kristijan Posavec, Perica Vukojević, Matija Ratkaj, Tea Bedeniković
Keywords
Related Articles
- EP ID EP30131
- DOI 10.17794/rgn.2017.1.4
- Views 181
- Downloads 3
ISTRAŽIVANJE LEŽIŠTA BOKSITA IZ PODZEMNIH RUDARSKIH RADOVA
Rad prikazuje novi pristup istraživanju ležišta boksita iz podzemnih rudarskih radova u boksitonosnome području Bešpelj kod Jajca u Bosni i Hercegovini. U razmatranome području ležišta boksita istražuju se i eksploatira...
HOW TO REDUCE THE SURFACE INHOMOGENEITY EFFECTS IN RESISTIVITY SOUNDINGS
A method is shown how to reduce the effect of surface inhomogeneities on the electrical soundings. A third, distant, curent electrode is used in connection with the left, and then with the right standard electrode. The d...
Kvaliteta zraka i mikroklimatski parametri pri iskopu tunela Mala Kapela
Glavni izvori opasnih i štetnih plinova pri iskopima tunela i podzemnih prostorija su miniranje te upotreba opreme pogonjene dizelskim motorima. U radu su analizirani podaci mjerenja imisija štetnih plinova te korelirani...
PRINCIPLE ROCK TYPES FOR RADIOACTIVE WASTE REPOSITORIES
Underground geological storage of high- and intermediate/low radioactive waste is aimed to represent a barrier between the surface environment and potentially hazardous radioactive elements. Permeability, behavior agains...
COMPARATIVE REVIEW OF CROATIAN AND INDIAN AIR POLLUTION STUDIES WITH EMPHASIS ON POLLUTANTS DERIVED BY COAL COMBUSTION
Human health, the environment, and climate are being profoundly aff ected by complex pollutant interactions in the atmosphere. Almost all human activities cause the emissions of air pollutants. Their understanding and qu...