NDLI: HydrogeoEstimatorXL: an Excel-based tool for estimating hydraulic gradient magnitude and direction

Content Provider	Springer Nature Link
Author	Devlin, J. F. Schillig, P. C.
Copyright Year	2016
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. 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. 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)三点估计量,即假定限定等势面的平面部分的三井返回进行二维分析该区域的水流系统。软件得到图形输出,包括水力坡度幅度和方向的柱状图、地下水速度(基于现场平均水力特性)以及绘出的估计量三角形结果和与其相关的速度矢量。在软件内,可以定义横断面,可以估算穿过横断面的地下水污染物的大量排泄。这种分析对于问题定义、获取现场水文地质的概况非常有用,作为一个检阅工具来检查其他独立计算结果的合理性也是非常有用。 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.
Starting Page	867
Ending Page	875
Page Count	9
File Format	PDF
ISSN	14312174
Journal	Hydrogeology Journal
Volume Number	25
Issue Number	3
e-ISSN	14350157
Language	Portuguese
Publisher	Springer Berlin Heidelberg
Publisher Date	2017-01-03
Publisher Institution	International Association of Hydrogeologists
Publisher Place	Berlin, Heidelberg
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Contamination Groundwater flow Groundwater monitoring Spreadsheet analysis Hydraulic gradient Hydrogeology Hydrology/Water Resources Geology Water Quality/Water Pollution Geophysics/Geodesy Waste Water Technology Water Pollution Control Water Management Aquatic Pollution
Content Type	Text
Resource Type	Article
Subject	Earth and Planetary Sciences Water Science and Technology

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

HydrogeoSieveXL: an Excel-based tool to estimate hydraulic conductivity from grain-size analysis

Groundwater arsenic contamination and its health effects in India

Preface: Optimization for groundwater characterization and management

Future research needs involving pathogens in groundwater

Simulation-optimization model for water management in hydraulic fracturing operations

Review: Mathematical expressions for estimating equivalent permeability of rock fracture networks

The groundwater management plan: in praise of a neglected ‘tool of our trade’

Overview of groundwater for emergency use and human security

Preface: Hydrogeology and human health

HydrogeoEstimatorXL: an Excel-based tool for estimating hydraulic gradient magnitude and direction

Similar Documents

HydrogeoSieveXL: an Excel-based tool to estimate hydraulic conductivity from grain-size analysis

Groundwater arsenic contamination and its health effects in India

Preface: Optimization for groundwater characterization and management

Future research needs involving pathogens in groundwater

Simulation-optimization model for water management in hydraulic fracturing operations

Review: Mathematical expressions for estimating equivalent permeability of rock fracture networks

The groundwater management plan: in praise of a neglected ‘tool of our trade’

Overview of groundwater for emergency use and human security

Preface: Hydrogeology and human health

HydrogeoEstimatorXL: an Excel-based tool for estimating hydraulic gradient magnitude and direction