You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.

Gravity Pipe Flow - Manning's Equation
This location is for Registered Users Only.
Perhaps you need to login or register.

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 Flow in Pipes - The Manning Formula, William C. Dunn PE

Manning Equations,  Robert Pitt & Shirley Clark


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


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


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

Submitted By:
Tony DiRocco (tony.only)
Submitted On:
08 Sep 2017
File Size:
183.27 Kb
File Version:
File Author:
Tony DiRocco
Total Votes:2
Comments: 4
mcguiry03 3 months ago
good day sir... where is the download link?
tony.only 11 months ago
Try downloading again. Everything worked when the calcs were accepted.

Here's a link to my Dropbox. I'll leave it there for a week.
WTJones 11 months ago
The worksheet downloaded fine but it seems none of the equations are in the calc cells. Am I missing something?
JohnDoyle[Admin] 2 years ago
A great debut calculation Tony I have awarded a free 6 month XLC Pro subscription by way of thanks.

We have 189 guests and 5 members online

Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. News RSS.