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
RE: Pipe Flow Depth calcs in Excel
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
RE: Pipe Flow Depth calcs in Excel
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
RE: Pipe Flow Depth calcs in Excel
RE: Pipe Flow Depth calcs in Excel
RE: Pipe Flow Depth calcs in Excel
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
RE: Pipe Flow Depth calcs in Excel
Greg
RE: Pipe Flow Depth calcs in Excel
RE: Pipe Flow Depth calcs in Excel
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
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
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
RE: Pipe Flow Depth calcs in Excel
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