Related Experiment Video
Updated: Sep 25, 2026

Parameterizing V-notch Weir Equations for Flow Monitoring in a Drainage Control Structure
Published on: April 25, 2025
A spreadsheet method of estimating best-fit hydraulic gradients using head data from multiple wells
1Geology Department, University of Kansas, 1475 Jayhawk Blvd., Lawrence, KS 66045, USA. jfdevlin@ku.edu
Abstract:
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.
More Related Videos
08:09Wastewater Irrigation Impacts on Soil Hydraulic Conductivity: Coupled Field Sampling and Laboratory Determination of Saturated Hydraulic Conductivity
Published on: August 19, 2018
07:21Measurements of Soil Water Potential and Conductivity based on a Simple Evaporation Experiment using a Hydraulic Property Analyzer
Published on: August 9, 2024
Related Concept Videos
Design Example: Creating a Hydraulic Model of a Dam Spillway
Weir: Problem Solving
Gradually Varying Flow
Energy Line and Hydraulic Gradient Line
Hydraulic Jump: Problem Solving
Typical Model Studies