Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Excel Flowrates through Pipe calcs?

Excel Flowrates through Pipe calcs?

I was curious if anyone had a good excel spreadsheet they could share that solves for the Q through circle and rectangular pipes of different sizes (~4"-12") and materials (ABS, PVC and Iron).

B+W Engineering and Design
Los Angeles Civil and Structural Engineering

RE: Excel Flowrates through Pipe calcs?

Not an excel spreadsheet but a program called 'SF Pressure Drop 7.0' available from Software-Factory.  It is free to try and costs a little over $100 (US.  Program was made by Nobert Schmitz (Germany).  Allows pipe expansions, contractions, etc. Allows elements to be ganged together and estimate flow and pressure drop. It also seems to have a good database for materials.

Can't swear to the accuacy, but I guess it's as good and any other calculator and resonably priced.  

RE: Excel Flowrates through Pipe calcs?

Thanks, that's really nice.  Especially since it has a mobile version!

B+W Engineering and Design
Los Angeles Civil and Structural Engineering

RE: Excel Flowrates through Pipe calcs?

After looking at that site closer, I was looking for something that is gravity flow through pipes, not forced pressure piping.

B+W Engineering and Design
Los Angeles Civil and Structural Engineering

RE: Excel Flowrates through Pipe calcs?

Are you looking for full flow discharge?  If so, this equation (Manning's) is easy to code.

Qff = 0.4644/n * D^2.67 * S^0.5

Vff = 0.5913/n * D^0.67 * S^0.5

From FHWA HEC22.

For Partial Flow you can use a lookup routine and code a partial flow nomogragh in table form or actually compute the partial flow using the Manning's equation and the area and perimeter for a partial circle.

I coded this into visual basic for my calculator.  It is pretty straight forward and the excel solver could be used within a spreadsheet. I can upload the partial full pipe geometric equations if you'd like.

RE: Excel Flowrates through Pipe calcs?

oops should have noted that the "D" is in feet and Q in cfs

RE: Excel Flowrates through Pipe calcs?

Yes Full Flow Discharge is exactly what I am looking for, I should have been more specific.  Putting that into excel would be my goal.  Though putting that on my HP48 would be nice too.  

Any idea how to do this for a rectangle pipe?  Example 3" height x 5" width?  And D=FT and Q=CFS is what I need.

I have been working nonstop on some rush projects that last 2 weeks and can't think straight outside of the designs I am working on.


B+W Engineering and Design
Los Angeles Civil and Structural Engineering

RE: Excel Flowrates through Pipe calcs?

Brandonbw - for rectangular shapes just use Manning's equation.  

Q=1.487/n * A * R^(2/3) * S^0.5
Where: A = H x W (ft^2)
       R = A/P (ft)
       S (ft/ft)
       Q (cfs)

Area and perimeter are geometric functions of your shape (rectangular) the coding into excel is straight forward.

You will need to obtain the roughness coefficient for your pipe material but there are many sources for that.  Another equation to use woiuld be the Chezy equation; you can look that up in any hydraulics text.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


White Paper: Agile Product Engineering and Improved Product Outcomes
Today’s product development cycle is fraught with difficulties. Increased demands for complex functionality and reduced product development windows cause engineering teams to borrow practices from the IT industry, swapping outdated serial workflows for a more flexible and collaborative design method known as Agile Product Engineering. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close