×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

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!
  • Students Click Here

*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.

Students Click Here

Jobs

Pipe Flow Depth calcs in Excel

Pipe Flow Depth calcs in Excel

Pipe Flow Depth calcs in Excel

(OP)
I have a bunch of flows and diameters, that I am looking to find the flow depth and velocity.  I have ready a few other threads about how to do it but need to get the v/V, q/Q & y/Y tables.  Can someone please show me where to find them.  I want to have this in Excel and not in another program.  Thanks.  

RE: Pipe Flow Depth calcs in Excel

Most good hydraulics books have this information.  It should be easy enough to use Mannings equation to develop the tables yourself in Excel.

RE: Pipe Flow Depth calcs in Excel

For circular pipes these are published in many places including:

almost any hydraulics text book
almost any pipe handbook
King's Handbook of Hydraulics
The Hydraulics Institute Engineering Data Book and at the following Link:

http://www.efunda.com/home.cfm

good luck

RE: Pipe Flow Depth calcs in Excel

(OP)
I went to efunda and couldn't find it and I don't have access to King's Hanbook. I only have a few books and they don't have them in them.  Any other links you can pass on?

RE: Pipe Flow Depth calcs in Excel

1.If you live in or near San Diego you do have access to books at the public library or any of several university libraries.

2. Better yet, do as coloeng suggests and develop the relationships yourself using Manning' Eq. You'll learn and remember much more that way.

RE: Pipe Flow Depth calcs in Excel

You could also put mannings equation into a visual basic macro and iterate through to solve for depth and velocity. I did this with a spreadsheet with all the normal information for a piped gravity flow system. I can attach it in this thread and tell you how to use it if you want. The program I wrote is not efficient, I just did it quick to get the results in a spreadsheet. I am working on it to make it smaller.

RE: Pipe Flow Depth calcs in Excel

I just wanted to add, that the macro I wrote is accurate, the programming is not efficient (cluttered).
 

RE: Pipe Flow Depth calcs in Excel

(OP)
WL123 -
That would be great if you could attach it for me.  I would like to learn how to use the Visual Basic.

Greg

RE: Pipe Flow Depth calcs in Excel

(OP)
Thanks Terry!  This will be very helpful when I set my spreadsheet up.  Construction issue have taken me away from this design right now but soon enough I will get back on it.

Greg

RE: Pipe Flow Depth calcs in Excel

This is the spreadsheet. Open the spreadsheet, open tools, macro, visual basic editor. highlight modules, click on file, import file, and locate the visual basic module I attached in the previous post. I usually save these in my personal.xls file so it can be used on any spreadsheet, if you don't, you have to import the basic module into every sheet. Close the visual basic screen. I made a button in the toolbar and attached the macro "ManningIn", you can also, just go to tools, macro, macros and run ManningIn from there.

Here's how it works. Put your cursor in the manning spreadsheet tab "manng" over any cell in the column labeled depth, you can erase one of the cells I filled in to see it work.  After clicking on the cell, run the macro, it will fill the depth and velocity automatically. Note, the macro is set up for the way the cells are set up in this spreadsheet. If you have any other questions, let me know.

RE: Pipe Flow Depth calcs in Excel

Use my
www.hydrocalc.com

(Don't forget to select Normal depth radio button to get depth. Otherwise it calculates flow.)

RE: Pipe Flow Depth calcs in Excel

WL123

I really liked your storm drain spreadsheet. Its one of the best Ive seen. Do you mind if I modify it for my area (local intensity/duration curves, etc.)?

Thanks
Oregonpe

RE: Pipe Flow Depth calcs in Excel

oregonpe,

Glad you like it, sure modify it for your use. I've been planning a good update for it, with selectable idf curves for different areas, but I just haven't got around to it. I need more time to do everything I want to do.

WL123

 

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!


Resources