Premium
A Spreadsheet Method of Estimating Best‐Fit Hydraulic Gradients Using Head Data from Multiple Wells
Author(s) -
Devlin J.F.
Publication year - 2003
Publication title -
groundwater
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.84
H-Index - 94
eISSN - 1745-6584
pISSN - 0017-467X
DOI - 10.1111/j.1745-6584.2003.tb02600.x
Subject(s) - hydraulic head , head (geology) , table (database) , water table , computer program , planar , matrix (chemical analysis) , plane (geometry) , geology , mathematics , geometry , geotechnical engineering , computer science , groundwater , computer graphics (images) , materials science , data mining , geomorphology , composite material , operating system
Hydraulic gradients from planar water tables, or piezometric surfaces, and horizontal flow regimes can be quickly and conveniently calculated from data sets involving numerous wells. The matrix-solving functions of a modem spreadsheet program (Excel) were used to determine the equation of a water-table plane, Ax + By + Cz - D = 0, and the equation coefficients were then used to determine the magnitude of the hydraulic gradient, according to gradient = square root of A2 + B2/C2, and its direction, according to alpha = arctan B/A, where alpha is the angle measured from the x-axis. A pre-prepared Excel file constructed to handle data from up to 20 wells at once is available for free downloading at www.geo.ku.edu/hydro/KUHydro.html.
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom