Where to Find a Hydraulic Grade Line – Energy Grade Line Calculator Spreadsheet

To obtain a  hydraulic grade line – energy grade line calculator spreadsheet for calculating and plotting HGL and EGL, click here to visit our spreadsheet store.  Intended for use in calculating and plotting HGL and EGL for up to 10 points of stormwater flow along a storm sewer line, you can buy a convenient spreadsheet to make HGL and EGL calculations and plots for a very reasonable price.  This spreadsheet is available in either U.S. or S.I. units.  Read on for information about a storm sewer hydraulic grade line – energy grade line calculator spreadsheet.

Equations for Hydraulic Grade Line and Energy Grade Line

The equations for the Hydraulic Grade Line and Energy Grade Line (EGL) are:

Where:    HGL

HGL = hydraulic grade line in ft                EGL = energy grade line in ft

P = pressure in psf                                        γ = specific weight in lb/ft³

h = elevation in ft                                         V = velocity in ft/sec

g = acceleration of gravity in ft/sec²

Example Spreadsheet for Hydraulic Grade Line – Energy Grade Line Calculator Plots

A screenshot for a Hydraulic Grade Line – Energy Grade Line calculator  spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate and plot the energy grade line and hydraulic grade line.  This Excel spreadsheet, as well as others for stormwater management calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

Reference:

Bengtson, Harlan H., Hydraulic Grade Line Calculation Spreadsheet, an informational blog article