Gravity Pipe Flow - Manning's Equation

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

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
| Find on | Find on | Find on | Find on | Find on |
Piping Calculations
| Find on | Find on | Find on | Find on | Find on |
Manning's Equation
| Find on | Find on | Find on | Find on | Find on |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. 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:
File Date:
07 Sep 2017
File Author:
Tony DiRocco
File Version:
File Size:
183.27 Kb
File Type:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
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
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.
#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?
#1 JohnDoyle[Admin] 2017-09-08 16:12
A great debut calculation Tony I have awarded a free 6 month XLC Pro subscription by way of thanks.

Please sign in or register to add a comment.

We have 15 guests and 38 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics