Abstract
HydrogeoEstimatorXL is a free software tool for the interpretation of flow systems based on spatial hydrogeological field data from multi-well networks. It runs on the familiar Excel spreadsheet platform. The program accepts well location coordinates and hydraulic head data, and returns an analysis of the area flow system in two dimensions based on (1) a single best fit plane of the potentiometric surface and (2) three-point estimators, i.e., well triplets assumed to bound planar sections of the potentiometric surface. The software produces graphical outputs including histograms of hydraulic gradient magnitude and direction, groundwater velocity (based on a site average hydraulic properties), as well as mapped renditions of the estimator triangles and the velocity vectors associated with them. Within the software, a transect can be defined and the mass discharge of a groundwater contaminant crossing the transect can be estimated. This kind of analysis is helpful in gaining an overview of a site’s hydrogeology, for problem definition, and as a review tool to check the reasonableness of other independent calculations.
Résumé
HydrogeoEstimatorXL est un logiciel libre d’accès pour l’interprétation des systèmes d’écoulement basés sur des données hydrogéologiques spatiales de terrain provenant de réseaux de multiples puits. Il fonctionne sur l’environnement familier du tableur Excel. Le programme accepte les coordonnées de la localisation des puits et les données des charges hydrauliques, et renvoie à une analyse du système de l’aire d’écoulement en deux dimensions selon (1) un seul plan d’ajustement de la surface piézométrique et (2) des estimateurs à trois points, c’est-à-dire triplets de points supposés relier des sections planes de la surface piézométrique. Le logiciel produit des sorties graphiques comprenant des histogrammes de l’amplitude et de la direction du gradient hydraulique, de la vitesse d’écoulement des eaux souterraines (basée sur les propriétés hydrauliques moyennes du site), ainsi que des rendus cartographiques des triangles de l’estimateur et des vecteurs de vitesse qui leurs sont associés. A l’aide de ce logiciel, une section transversale peut être définie et la décharge massique de contaminants des eaux souterraines recoupant cette section peut être estimée. Ce type d’analyse est utile pour obtenir une vue générale de l’hydrogéologie d’un site, pour la définition du problème et comme outil d’évaluation pour vérifier le caractère raisonnable d’autres calculs indépendants.
Resumen
HydrogeoEstimatorXL es una herramienta de software libre para la interpretación de sistemas de flujo basados en datos hidrogeológicos espaciales de campo a partir de redes de pozos múltiples. Se ejecuta en la conocida plataforma de hoja de cálculo de Excel. El programa acepta las coordenadas de ubicación del pozo y los datos de la carga hidráulica, y devuelve un análisis del sistema de flujo del área en dos dimensiones basado en (1) un mejor plano de ajuste de la superficie potenciométrica y (2) estimador de tres puntos, por ejemplo, se asume que el terceto de pozos se unen a secciones planas de la superficie potenciométrica. El software produce salidas gráficas incluyendo histogramas de magnitud y dirección del gradiente hidráulico, velocidad del agua subterránea (basada en las propiedades hidráulicas promedio de un sitio), así como representaciones mapeadas de los triángulos estimadores y los vectores de velocidad asociados con ellos. Dentro del software, se puede definir un corte transversal y se puede estimar la descarga de la masa de un contaminante de agua subterránea que cruza dicho corte. Este tipo de análisis es útil para obtener una visión general de la hidrogeología de un sitio, para la definición del problema y como una herramienta de revisión para comprobar la razonabilidad de otros cálculos independientes.
摘要
水文地质估算者XL是一款免费软件工具,这款工具根据多井网络的空间水文地质野外数据解译水流系统。它在人们所熟悉的Excel电子表格平台上运行。程序接受井的位置坐标及水头数据,并且基于(1)单个等势面最佳匹配面及(2)三点估计量,即假定限定等势面的平面部分的三井返回进行二维分析该区域的水流系统。软件得到图形输出,包括水力坡度幅度和方向的柱状图、地下水速度(基于现场平均水力特性)以及绘出的估计量三角形结果和与其相关的速度矢量。在软件内,可以定义横断面,可以估算穿过横断面的地下水污染物的大量排泄。这种分析对于问题定义、获取现场水文地质的概况非常有用,作为一个检阅工具来检查其他独立计算结果的合理性也是非常有用。
Resumo
HydrogeoEstimatorXL é um software livre para interpretação de sistemas de fluxo baseado em dados hidrogeológicos espaciais de campo de redes multipoços. Ele opera na plataforma familiar de planilha Excel. O programa aceita as coordenadas de localização dos poços e dados de carga hidráulica, e retorna uma análise do sistema de fluxo da área em duas dimensões baseado em (1)plano de melhor ajuste único da superfície potenciométrica e (2)estimadores de três pontos, p. ex., supondo que tripletas de poços amarrem as sessões planares da superfície potenciométrica. O software produz saídas gráficas incluindo histogramas da magnitude e direção do gradiente hidráulico, velocidade das águas subterrâneas (baseada nas propriedades hidráulicas médias locais), como também interpretações mapeadas dos triangulos de estimação e os vetores de velocidade associados a eles. No software, pode-se definir um transceto e estimar a massa de águas subterrâneas contaminada descarregada cruzando o tranceto. esse tipo de análise é útil em obter uma visão geral de uma situação hidrogeológica, para definição de problema, e como uma ferramenta de revisão para checar a razoabilidade de outros cálculos independentes.
Similar content being viewed by others
Avoid common mistakes on your manuscript.
Introduction
The most common method of estimating groundwater discharge, Q (L3/T), specific discharge, q (L/T), velocity, v (L/T), or contaminant (advective) mass flux, J (M/L2T) is based on Darcy’s Law (Eq. 1),
where A is the area cross-sectional to flow (L2), K is hydraulic conductivity (L/T), h is total hydraulic head (h = z+Ψ), z is elevation head (L), Ψ is pressure head (L), x is distance in the direction of flow (L), and C is contaminant concentration (M/L3). The terms L, M, T are generalized units referring to distance, mass, and time, respectively. Typically, site investigations concerned with groundwater flow begin with evaluations of K and the hydraulic gradient (∆h/∆x). The evaluation of K has received enormous attention over the years. It was a chief motivation for the development of field methods including pumping tests (Kruseman and de Ridder 1991), slug tests (Butler 1997), direct push-based techniques (Butler et al. 2002, 2007), flow meters (Molz et al. 1989), and geophysical techniques including ground penetrating radar (Knight 2001) and nuclear magnetic resonance (NMR; Legchenko et al. 2002). It was also connected to laboratory techniques including grain size analyses (summarized in Devlin 2015) and permeametry (Freeze and Cherry 1979). However, while K is essential to know for a complete description of a site’s hydrogeology, including predictions of groundwater speed, it is not essential to know for mapping the general steady-state patterns of flow at a site, i.e., flow directions. Patterns of steady-state flow across an area depend on the variations in hydraulic gradient, and these develop with an inherent accounting of aquifer heterogeneity that does not depend on a specific knowledge of K, at least as a first approximation.
Misleading interpretations of groundwater velocity can result from errors that commonly occur in hydraulic head data sets, and are propagated through gradient estimations. Examples were described by Silliman and Frost (1998); Zemansky and Devlin (2013) and Schillig et al. (2016), and arise from a variety of causes (see “Example case 1” section). The purpose of this article is to introduce an Excel-based tool, HydrogeoEstimatorXL, for evaluating hydraulic gradients as either single plane surfaces or more complex surfaces characterized by three-point estimators, i.e., well triplets each defining a separate planar surface. The calculations performed in HydrogeoEstimatorXL are well known and generally accepted for characterizing groundwater flow from field data. Therefore, the contribution here comes from the creation of a free tool that assembles the calculations into an easy-to-use package within a spreadsheet platform that is widely used and readily accessible to practitioners. Further, the graphical displays preset in HydrogeoEstimatorXL help users assess general trends in flow direction and magnitude and to identify the presence of unrepresentative data points, providing hydrogeologists with a simple, preliminary means of examining water level data and maintaining quality assurance in hydrogeological datasets. The analysis can be completed by personnel without a lot of training in groundwater flow modeling, yet the results may be useful for model validation by highly trained modelers. The software is available free of charge at the University of Kansas (USA) Scholarworks site (see KU ScholarWorks (2016), and at the author’s website (Devlin 2016).
Background
A common method of determining the hydraulic gradient is to plot measured values of hydraulic head on a map, contour the data, and then measure the approximate distance (∆x) between selected contours representing a known head drop (∆h). These quantities are combined to give the gradient used in Eq. (1). The subjectivity of measurements on a contoured map (contoured by hand or by automated methods) can be eliminated if more rigorous mathematical approaches are used. Heath (1983) presented a graphical method for solving the three-point problem in which the potentiometric surface is defined by water levels in three piezometers that form the vertices of a triangle. Pinder et al. (1981) and Devlin and McElwee (2007) presented purely mathematical solutions for the three-point problem. Kelly and Bogardi (1989) and Devlin (2003) presented spreadsheet methods for calculating the hydraulic gradient assuming a planar potentiometric surface with any number of wells in the network. Pinder et al. (1981) noted that piezometric surfaces are commonly more complex surfaces than a simple plane. They proposed that such a surface might be more usefully described by a suite of three-point estimators, defined by well triplets, each representing a plane in a subsection of the total study area. Local departures from site-wide planarity would be revealed by variations in the smaller three-point estimators. Silliman and Frost (1998) carried forward the three-point estimator idea and developed a data analysis approach in which all possible three-point estimators in the network were identified and calculated. The scatter in hydraulic gradients diminished as the size of the estimators increased, until there was convergence on a site-wide average gradient, both in magnitude and direction. They showed that this analysis could be helpful in identifying wells with unrepresentative hydraulic heads. However, for geometrical reasons, all three-point estimators in a network are not of equal value—for example, some are formed by triangles with excessively high, or low, base to height ratios that can introduce relatively high uncertainty into the associated gradient estimates. McKenna and Wahi (2006) proposed that only estimators with base to height ratios between 0.5 and 5.0 should be considered for best results, though somewhat wider ranges could be useful, depending on the tolerance of the project. The preceding work was primarily geared at representing two-dimensional (2-D) groundwater flow. Abriola and Pinder (1982) extended the idea of estimators to three-dimensional flow. Biljin et al. (2014) used the solution method of Devlin (2003) to solve the three-point problem for the analysis of time series data. HydrogeoEstimatorXL is a complimentary tool that adopts the 2-D approach of Pinder et al. (1981), the solution method of Devlin (2003), and the analysis method of Silliman and Frost (1998), subject to the estimator size constraints of McKenna and Wahi (2006), to provide hydrogeologists with a package for preliminary spatial evaluations of hydraulic head data sets and hydraulic gradients across study sites.
Theory
Calculation of the hydraulic gradient
Given the equation of a plane (Eq. 5), where x and y are map directions and z is the hydraulic head (water level), the hydraulic gradient in the x-direction is obtained by differentiating z with respect to x, and the gradient in the y-direction is obtained by differentiating z with respect to y.
The magnitude of the overall hydraulic gradient is given by
and the direction of the gradient, measured counter clockwise from the x-axis, is given by (Devlin 2003),
According to Kelly and Bogardi (1989) and Devlin (2003), Eq. (5) can be written for each well in a network assuming they are completed at similar depths in the same aquifer, and are well connected hydraulically. If the network consists of n wells, then the following system of equations can be written in matrix form
or, more succinctly
where the matrix [A] contains the coefficients for the equation of the plane. The matrix [D] contains the elevation of the water table where x = y = z = 0. However, for the purposes of calculating the gradient and direction of flow, this elevation is not important (note the absence of D in Eqs. 6 and 7). Therefore, a common, arbitrary, non-zero value can be used for D 1 through D n in the [D] matrix; HydrogeoEstimatorXL uses a value of 1.0. The solution to Eq. (9) is
which can be solved in Excel using the methods described in detail by Devlin (2003). This equation is solved for a site-wide best fit plane to describe the piezometric surface, and for each of the three-point estimators generated in the software. The assumption of planarity may be challenged in the case of unconfined aquifers, especially where the site-wide best fit plane is concerned. However, as previously mentioned, examination of the hydraulic gradients in the local scale three-point estimators can reveal serious departures from linearity.
By default, Eq. (6) is evaluated by Excel to give angles between +90° and −90° from the x-axis, i.e., only vectors with a flow component in the positive x-direction are returned by Excel. If the flow direction is in the negative x-direction, an angle between +90° and −90° will be reported that is 180° from the true flow direction. HydrogeoEstimatorXL overcomes this limitation by determining the highest and lowest head values at selected locations on the x-axis, and on the y-axis using the equation of the plane from Eq. (10). From these, the general flow direction can be deduced and the flow angle automatically corrected by 180°, if necessary.
Acceptance and rejection of estimators
Estimators are accepted if
-
1.
Their base to height ratios are within a range specified by the user. By default, the range of 0.5 to 5.0 is entered in HydrogeoEstimatorXL, as recommended by McKenna and Wahi (2006).
-
2.
Either the base or the height is within a length specified by the user. This criterion permits users to screen out estimators of excessive size.
-
3.
If the difference between maximum and minimum head values in the estimator exceeds the measurement error by a prescribed amount set by the user.
In order to calculate a base to height ratio (base/H) of an estimator, the lengths of each side of the triangle are calculated from
where the terms in Eqs. (11)–(13) are defined in Fig. 1.
The areas of the estimators are calculated using Heron’s Formula (Beyer 1973),
and heights (H) are calculated from
The second criterion for acceptance depends on the maximum head drop across the estimator and the measurement error. If the measurement error exceeds the observed change in head across an estimator, then the hydraulic gradient within that estimator is too low to measure. This might occur, for example, in estimators formed from closely spaced wells. Estimators with no measurable gradient in them are screened out of the analysis by HydrogeoEstimatorXL. To put this into practical terms, typical water level measurements can be acquired with accuracies of about ±1 cm, though slight improvements on this can be realized with well-calibrated pressure transducers (Devlin and McElwee 2007). Higher uncertainties may occur depending on the skill of the operator, or the condition of the wells. If ±1 cm is representative of the measurement standard deviation, then the uncertainty envelope it defines contains the true water level with about 68% confidence. Similarly, ±2 cm would define an envelope with a 95% confidence of including the correct value, and ±3 cm would include the correct value with 99% confidence. Since the acceptance criterion is based on a difference in water levels across an estimator (maximum – minimum), the uncertainty must be propagated through the calculation.
where σ ∆WL is the uncertainty on the difference and σ WL is the uncertainty on the measurement. From this calculation, the ∆WL to achieve a confidence level of 68% is ±1.4 cm, 95% is ±2.8 cm, and 99% is ±4.2 cm. In HydrogeoEstimatorXL the user can specify both the measurement uncertainty (σWL) and the confidence level desired for estimator acceptability on the Input sheet. The uncertainty on ∆WL is computed during the program execution.
Graphical displays
HydrogeoEstimatorXL displays the results of the analysis in several ways. A map view of the study area with the locations of up to 20 wells in a network plotted to scale, and up to 24 three-point estimator triangles plotted on the site map (more estimators renders the graphic too busy to read easily), a vector map showing the location of the estimator centroids with vector tails indicating the flow direction and the distance an unretarded solute would travel in a time specified by the user, histograms of the gradient (for magnitude and direction), and groundwater speed (based on user-provided site-wide values of K and n, and Eq. 3), and a Silliman and Frost (1998) style estimator graphic plotting gradient magnitude, calculated from Eq. (6), against estimator area. With the exception of the vector map, all the graphics plot values calculated from the equations presented above.
The vector map is generated as follows. Centroids of the estimators are calculated from
where x i , y i are the map coordinates of the estimator vertices. The vector tails are plotted as straight lines of length determined by the average distance water would travel from the centroids in time τ. The coordinates of the vector tail termini are calculated from
where θ is the angle from the x-axis to the flow direction (measured counter-clockwise), grad is the magnitude of the estimator gradient, K is the bulk hydraulic conductivity for the site and n is the effective porosity of the aquifer.
Mass discharge across a transect
In addition to solving for the hydraulic gradient of each three-point estimator, HydrogeoEstimatorXL calculates the site-wide gradient using the water level data from all wells simultaneously (Devlin 2003). For a transect cutting across the site between points (x 1, y 1) and (x 2, y 2), a parallel transect that passes through the origin of the coordinate grid can be calculated by subtracting (x 1, y 1) from both end points, leading to the vector \( \overrightarrow{O} \) with endpoint (x 2 – x 1, y 2 – y 1).
A vector normal to this transect, \( \overrightarrow{N} \) can be obtained by rearranging the dot product as follows
where x 3 and y 3 are the coordinates of the normal vector. The value of x 3 can be arbitrarily selected in Eq. (22) to solve for y 3. The equation of the site-wide potentiometric surface plane (Eq. 5) can then be used to determine the hydraulic heads at (0,0) and (x 3, y 3), from which the hydraulic gradient perpendicular from the original transect can be calculated. The advective mass flux, J, and the mass discharge, M Q, of a solute crossing the transect can be determined from
where C is the concentration of the solute crossing the transect (M/L3), K is the site bulk hydraulic conductivity (L/T), grad is the hydraulic gradient perpendicular to the transect, and A is the area of the transect. If a transect is constructed from several segments, these calculations can be performed on each segment and the corresponding equations become
where the subscript i refers to each individual segment of the overall transect, and m is the number of segments.
Overview of HydrogeoEstimatorXL
HydrogeoEstimatorXL is an Excel workbook consisting of eight worksheets (Table 1). To begin using the software, the user enters the well names, location coordinates, and water levels into the table in the Input sheet (Fig. 2). Access to the analysis functions is gained through the dashboard. The dashboard is made available by clicking on the “Launch Dashboard” button above the input table. The dashboard offers several options including ‘Clear’ that resets the workbook but leaves the input table unaltered, ‘Clear All’ that resets the workbook and clears the input table, ‘Calculate…’ that generates the estimators and performs all related calculations, ‘Update…’ that refreshes the histogram graphics, ‘Choose Estimators’ that opens a dialogue box prompting the user for well triplets to plot, useful for simplifying the graphics or examining specific estimators, and ‘Default Estimators’ that returns the graphics to the default displays. The software was developed with Excel 2013 and the histogram plots require that users have the Analysis Tool Pak add-in active in the workbook. Without the add-in, errors involving “ATPVBAEN.XLAM!Histogram” may result. Excel 2010 suffers the same error affecting histogram generation, but operates normally with regard to the other functions. Earlier versions of Excel have not been tested. Histograms can still be generated manually in the event of the above error.To illustrate the use of HydrogeoEstimatorXL, two example data sets from the literature are examined in the following.
Example case 1
To illustrate the use of HydrogeoEstimatorXL, the dataset recently presented by Schillig et al. (2016) is re-examined (Figs. 2 and 3). The data were obtained from the Woodstock site in Ontario, Canada, where a glacial outwash aquifer contaminated with nitrate was tested for possible remediation by in situ denitrification. The input data and settings can be found in Fig. 2. In this example, the base to height ratio criterion for the estimators was set to 0.2 < B/H < 8, for illustrative purposes. A site-wide geometric mean hydraulic conductivity of 244 m/day and a porosity of 0.35 were assumed, based on Critchley et al. (2014). The analysis performed by HydrogeoEstimatorXL indicated a hydraulic gradient across the site ranging from 1.5 × 10−3 to 3.5 × 10−3, leading to estimated average groundwater velocities between 1.0 and 2.5 m/day (Fig. 3b) and flow directions ranging from 45° south of east to 7° north of east (Fig. 3d), with two groupings: those that indicate eastward flow and those that indicate south-eastward flow.
The estimators associated with specific vectors can be identified on the ‘Estimator Graphs’ sheet. An examination of these associations reveals that all the estimators with predominantly eastward trending flow are associated with well WO75S, located on the south side of the site. The consistency of the vector lengths in Fig. 3d indicates the water table is relatively planar; systematic changes in the vector lengths would indicate a nonplanar water table. Repeating the analysis without the WO75S well leads to a subset of estimators with a similar overall range of gradients and estimated groundwater velocities, but with two important updates to the analysis (Fig. 4):
-
1.
The uniformity of the flow directions improves markedly with an overall trend changing from eastward to the southeastward, in agreement with independent experimental evidence (see Schillig et al. 2016). This result strongly suggests that WO75S was in poor hydraulic connection with the remainder of the network and that it biased the analysis.
-
2.
The number of estimators in the analysis decreased by half, from 17 to 8. This occurred because the location of WO75S made it possible to construct numerous estimators with favorable base to height ratios. The large number of estimators with WO75S increased the weighting of that well on the overall assessment of flow at the site. Therefore, identification of the well as problematic, and its removal from the analysis was very important for improved accuracy of the analysis, particularly where flow direction was concerned.
A well may be associated with an anomalous water level (compared to the other wells in a network) for several reasons, including firstly, poor hydraulic connection due to geological reasons—for example a well might be completed in geologic stratum with a weak or absent hydraulic connection to the sediment(s) hosting the remainder of the network. This could occur in association with heterogeneous sediments and be exacerbated by large horizontal or vertical separation distances between wells. Secondly lack of hydraulic equilibrium—for example poor well screen development or low-permeability media around the well—could prevent timely water level equilibration. Foreign objects in a piezometer could isolate the standing water column from the screen, delaying the development of equilibrium water levels. Thirdly, transience in the flow system—outside influences, such as pumping—might affect one well in a network disproportionately during a coincident water level collection effort. Fourthly, operator or data handling errors could also have an affect—for example, an error could be made reading the depth to water with a sonde and tape, or a transducer might fall out of calibration; errors could occur in the surveying of a well, resulting in an inaccurate elevation assigned to the top of casing and subsequently to calculated water level elevations.
HydrogeoEstimatorXL provides a means of identifying a well or wells that might suffer from one or more of the aforementioned problems, but does not identify the specific cause. Users must decide from other information, or professional judgement, whether or not discarding data from a particular well is justified. The results of the analysis of the already mentioned Woodstock data are in agreement with the findings reported by Schillig et al. (2016), who used independent, custom software (also executed in Excel) to come to the same conclusion. This analysis augmented the previous one with graphical displays of ranges of velocity, gradient, flow direction, mapped renditions of the estimators themselves, and the velocity vectors associated with them. The additional graphics provide a rapid means of acquiring an intuitive understanding of a flow system. As illustrated in the preceding, this can be very useful in identifying issues requiring further scrutiny.
Example case 2
A metal-processing plant in central Denmark was found to have discharged tetrachloroethene (PCE) into a sewer line that was subsequently discovered to be leaky (Fjordboge et al. 2012). Some of the PCE entered the underlying water-table aquifer comprising layered sands, silts and clays. A plume developed that carried PCE and anaerobic degradation products, including 1,2 dichlorothene (12DCE) eastward through the town of Skuldelev. Since the year 2000, over 200 monitoring wells were installed in and around the source area to delineate the contaminated area and gain insight into the hydrogeology of the site. A control transect consisting of multilevel wells was established across the plume on the east side of source area, with the aim of determining the advective mass flux of contaminants leaving the site. Using water level data reported by Lange et al. (2011), and concentrations of c12DCE reported by Troldborg et al. (2012), HydrogeoEstimatorXL was used to estimate the flux of c12DCE across the control transect (Fig. 5a).
Troldborg et al. (2012) examined the distribution of c12DCE with multilevel monitors along the transect, and more than 100 water analyses, and found that indeed most of the contaminant did cross the transect within about a 38 m2 zone between 0 and 3.5 m above sea level. The various methods used to estimate the contaminant discharge across the transect yielded values ranging from 4.3 ± 1.8 kg/year to 7.1 ± 6.3 kg/year.
HydrogeoEstimatorXL calculated that the majority of the mass crossing the transect does so at segment 4 (orange line between W7 and W8), which was assumed to be 11 m long with an effective concentration of 30 mg/L based on the plume figure presented by Troldborg et al. (2012, Fig. 7, pg. 12; Fig. 5a). The total mass discharge across the transect was estimated to be on the order of 2.1 kg/year/m of depth. If the depth range of importance, based on the multilevel data and Fig. 3 in Troldborg et al. (2012), was about 3.5 m, the HydrogeoEstimatorXL estimate becomes 7.4 kg/year. This estimate is comparable with the range reported by Troldborg et al. (2012), discussed in the preceding. The relatively simple assumptions built into the HydrogeoEstimatorXL calculations means that they should not be substituted for field data. Nonetheless, the fact that preliminary estimations of mass discharge are suitable for problem identification is demonstrated by the favorable results.
Conclusions
HydrogeoEstimatorXL is a convenient tool freely available to professionals to assist with the interpretation of water level data. The graphical output, in the form of velocity vector maps and histograms of the hydraulic gradient, flow direction, and approximate groundwater velocity, can be instrumental in gaining an intuitive understanding of the groundwater flow through an area, and in identifying wells that might not be well connected with the monitoring or piezometric network. HydrogeoEstimatorXL also permits users to define a transect, with unit depth, across the study area, and then estimate the mass discharge of dissolved substances across the transect plane. Data of these kinds are likely to be useful in the early stages of site investigations and with problem definition. They may also be useful in reviews and quality control checks on flow and transport characteristics, calculated independently by other means.
References
Abriola LM, Pinder GF (1982) Calculation of velocity in three space dimensions from hydraulic head measurements. Ground Water 20(2):205–213
Beyer WH (1973) CRC standard mathematical tables, 25th edn. CRC, Boca Raton
Biljin M, Ross RR, Acree SD (2014) 3PE: a tool for estimating groundwater flow vectors. EPA 600/R-14/273, US EPA, Washington, DC. www.epa.gov/ada. Accessed September 2014
Butler JJ (1997) The design, performance, and analysis of slug tests. CRC, Boca Rotan, FL
Butler JJ Jr, Healey JM, McCall GW, Garnett EJ, Loheide SP (2002) Hydraulic tests with direct-push equipment. Ground Water 40(1):25–36
Butler JJ, Dietrich P, Wittig V, Christy T (2007) Characterizing hydraulic conductivity with the direct-push permeameter. Ground Water 45(4):409–419
Critchley K, Rudolph D, Devlin JF, Schillig PC (2014) Stimulating in situ denitrification in an aerobic, highly permeable municipal drinking water aquifer. J Contam Hydrol 171:66–80
Devlin JF (2003) A spreadsheet method of estimating best-fit hydraulic gradients using head data from multiple wells. Ground Water 41(3):316–320
Devlin JF (2015) HydrogeoSieveXL: an Excel-based tool to estimate hydraulic conductivity from grain-size analysis. Hydrogeol J 23:837–844
Devlin JF (2016) J.F. Devlin Homepage: Professor, Department of Geology, University of Kansas, Lawrence, KS. http://www.people.ku.edu/~jfdevlin/Software.html. Accessed December 2016
Devlin JF, McElwee CD (2007) Effects of measurement error on horizontal hydraulic gradient estimates. Ground Water 45(1):62–73
Fjordboge AS, Lange IV, Bjerg PL, Binning PJ, Riis C, Kjeldsen P (2012) ZVI-Clay remediation of a chlorinated solvent source zone, Skuldelev, Denmark: 2. groundwater contaminant mass discharge reduction. J Contam Hydrol 140–141:67–79
Freeze RA, Cherry JA (1979) Groundwater. Prentice Hall, Englewood Cliffs, NJ
Heath RC (1983) Basic ground-water hydrology. US Geol Surv Water Suppl Pap 2220
Kelly WE, Bogardi I (1989) Flow directions with a spreadsheet. Ground Water 27(2):245–247
Knight R (2001) Ground penetrating radar for environmental applications. Annu Rev Earth Planet Sci 29:229–255
Kruseman GP, de Ridder NA (1991) Analysis and evaluation of pumping test data, 2nd edn. International Institute for Land Reclamation and Improvement, Publication 47, Wageningen, The Netherlands
KU ScholarWorks (2016) HydrogeoEstimatorXL: an Excel-based tool for estimating hydraulic gradient magnitude and direction. http://hdl.handle.net/1808/22049. Accessed Nov 2016
Lange IV, Troldborg M, Santos MC, Binning PJ, Bjerg PL (2011) Kvantificering af forureningsflux i transekt ved Skuldelev. Datarapport et samargjdsprojekt mellem, DTU Miljø og Region Hovedstaden [Quantification of contaminant flux in transects at Skuldelev. Data Report of a joint project between DTU Environment and the Capital Region], Copenhagen, Denmark
Legchenko A, Baltassat JM, Beauce A, Bernard J (2002) Nuclear magnetic resonance as a geophysical tool for hydrogeologists. J Appl Geophys 50:21–46
McKenna SA, Wahi A (2006) Local hydraulic gradient estimator analysis of long-term monitoring networks. Ground Water 44(5):723–731
Molz FJ, Morin RH, Hess AE, Melville JG, Guven O (1989) The impeller meter for measuring aquifer permeability variations: evaluation and comparison with other tests. Water Resour Res 25(7):1677–1683
Pinder GF, Celia M, Gray WG (1981) Velocity calculation from randomly located hydraulic heads. Ground Water 19(3):262–264
Schillig PC, Devlin JF, Rudolph D (2016) Upscaling point velocity measurements to characterize a glacial outwash aquifer. Groundwater 54(3):394–405
Silliman SE, Frost C (1998) Monitoring hydraulic gradient using three-point estimator. J Environ Eng 124(6):517–523
Troldborg M, Nowak W, Lange IV, Santos MC, Binning PJ, Bjerg PL (2012) Application of Bayesian geostatistics for evaluation of mass discharge uncertainty at contaminated sites. Water Resour Res 48:W09535. doi:10.1029/2011WR011785
Zemansky G, Devlin JF (2013) Point velocity probe technology transfer. GNS Science Consultancy Report 2013/199, August, GNS, Lower Hutt, New Zealand
Acknowledgements
Gil Zemansky and Poul Bjerg are acknowledged for helpful comments in early drafts of this manuscript.
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Devlin, J.F., Schillig, P.C. HydrogeoEstimatorXL: an Excel-based tool for estimating hydraulic gradient magnitude and direction. Hydrogeol J 25, 867–875 (2017). https://doi.org/10.1007/s10040-016-1518-4
Received:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10040-016-1518-4