## Gravity Pipe Flow - Manning's Equation

Description:
Calculation Preview

Gravity pipe flow of a partially filled pipe.

Hydraulic radius is calculated and all hydraulic properties of the pipe are calculated in a table.

Three charts are provided to highlight maximum and special conditions for hydsraulic radius (R), flow rate (Q) and velocity (V).

Manning's n, hydraulic radius, slope and velocity can also be calculated for existing conditions.

GRAVITY PIPE FLOW - PARTIALLY FILLED PIPE

BY MANNING'S EQUATION

References:

Gravity Flow in Pipes - The Manning Formula, William C. Dunn PE

Manning Equations,  Robert Pitt & Shirley Clark

Validation:

Worked through  book examples & hand calculations.

Some variables in manning's equations have interesting properties

shown in the table & Charts on the Calcs sheet, providing a method

of self validation. Place cursor on dots on the charts to get values.

Calcs Sheet:

Determine the hydraulic radius based on water depth in pipe.

Input is US or SI; use the units of your choice, the rest are

converted automatically.

Output is in US & SI units.

A Table based on percent of water depth points out some

interesting properties of hydraulic radius, flow rate and

velocity.

Charts show visually the properties of hydraulic radius,

flow rate, and velocity plotted against percent of water

depth in the pipe.

Find Depth of Flow -- Q, n, S, r Known.  Enter n, S and r. Take a guess at d.

Keep incrementing or decrementing d until Q = known value. You have found

d.

n-Value Sheet:

Provides a Table of Manning's cofficient n.

Slopes Sheet:

Explains visually how slopes are determined.

n,R,S,V Sheet:

Helps to solve for n, R, S, V for existing conditions.

Provides calculations to determine pipe diameter with

known design requirements of  Q, Vallowable, Smin, and n.

Calculation Reference
Gravity Pipe Flow

Piping Calculations

Manning's Equation

Version History
Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
08 Sep 2017
Submitted By:
tony.only
File Date:
07 Sep 2017
File Author:
Tony DiRocco
File Version:
1.0
File Size:
183.27 Kb
File Type:
xlsm
53
Rating:
HTML Window:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

#3 tony.only 2018-11-02 16:30

Here's a link to my Dropbox. I'll leave it there for a week.
https://www.dropbox.com/s/70pdp7huy5xdz0f/Gravity%20Pipe%20Flow%20-%20Mannings%20Eqn.xlsm?dl=0

#2 WTJones 2018-11-02 15:39
The worksheet downloaded fine but it seems none of the equations are in the calc cells. Am I missing something?

A great debut calculation Tony I have awarded a free 6 month XLC Pro subscription by way of thanks.