Pipe Flow Depth calcs in Excel 1

[CiviLnSanDiego]

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.

 

[coloeng]

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

 

[RWF7437]

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

 

[CiviLnSanDiego]

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?

 

[RWF7437]

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.

 

[jartgo]

I've attached a nomograph for circular pipes, it's relatively straight forward. Hope this helps. I'd be interested to see how you get this into Excel. Keep us posted.

 

[WL123]

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.

 

[WL123]

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

 

[CiviLnSanDiego]

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

Greg

 

[TerryScan]

Here is an Excel file which computes flow base on Mannings for circular channel.

 

[CiviLnSanDiego]

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

 

[WL123]

Here is the Basic module that you have to import to excel, I'll attach the spreadsheet in the next post and tell you how to use them

 

[WL123]

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.

 

[elev8848]

Use my

http://www.hydrocalc.com

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

 

[oregonpe]

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

 

[CiviLnSanDiego]

You all love to see this spreadsheet that was what I ended up using. It works really easily. Let me know if it helps you out.

 

[WL123]

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