A Visual Basic program for an Excel spreadsheet was written to construct a master recession curve (MRC), using the adapted matching strip method, for recession analysis of ground water level time series. The program uses five different linear/nonlinear regression models to adjust individual recession segments to their proper positions in the MRC. The program can also be used to analyze the recession segments of other time series, such as daily stream discharge or stage. Some examples of field data from Croatia are used to illustrate the usefulness of its application.

This paper presents a conceptual model of the Zagreb aquifer system. The conceptual model can be applied to groundwater status risk assesstnent and pollution risk assessment at the local seale, thus satisfying both environmental and preventative/limitation objectives of the Water Framework Directive (WFD) and Groundwater Directive (GWD). Its main purpose is to apply a risk assessment procedure, according to the WFD requirements, and to serve as a foundation for setting up a numerical model of flow in both the saturated and unsaturated zones in order to identify pressure and impact effects on groundwater quality. The model is divided into two parts, taking into account the WFD requirement to assess a risk for a wide range of source-pathway-receptor relationships. The Global Conceptual Model (GCM) provides insight into the processes and pressures at the level of the groundwater system. It contains the geological and hydrogeological characterization of the Zagreb aquifer system and the description of the most significant point and difilise sources and pathways of pollution and processes influencing pollutant behaviour in saturated and unsaturated zone of the groundwater system. The main pollutants of the Zagreb aquifer system are potentially toxic metals, nitrates, pesticides, pharmaceuticals and chlorinated aliphatics. A Local Conceptual Model (LCM) supports parameterization of the whole groundwater system through the description of heterogeneities and flow and solute parameters of the system components at two sites representing local conditions in the saturated (Stara Loza) and unsaturated (Kosniea) zones. This concept can be regarded as an effective tool for groundwater management of the groundwater system and its compartments and for communicating the conditions in complex groundwater systems with experts, policy makers and general public in an understandable way.

No abstract

A Visual Basic macro entitled BACKGROUND calculates geochemical background values of chemical parameters and estimates threshold values separating background data from anomalies. The macro uses two statistical methods, the iterative 2-sigma technique and the calculated distribution function, and integrates these model-based objective methods into a widely accessible platform (i.e., MS Excel). The macro offers the possibility for automated processing of geochemical data and enables an automated generation of background range and threshold values for chemical parameters.

The fully automated objective-based method for master recession curve (MRC) separation was developed by using Microsoft Excel spreadsheet and Visual Basic for Applications (VBA) code. The core of the program code is used to construct an MRC by using the adapted matching strip method (Posavec et al. 2006). Criteria for separating the MRC into two or three segments are determined from the flow-duration curve and are represented as the probable range of percent of flow rate duration. Successive separations are performed automatically on two and three MRCs using sets of percent of flow rate duration from selected ranges and an optimal separation model scenario, having the highest average coefficient of determination R(2), is selected as the most appropriate one. The resulting separated master recession curves are presented graphically, whereas the statistics are presented numerically, all in separate sheets. Examples of field data obtained from two springs in Istria, Croatia, are used to illustrate its application. The freely available Excel spreadsheet and VBA program ensures the ease of use and applicability for larger data sets.