Excel Flowrates through Pipe calcs?
Excel Flowrates through Pipe calcs?
(OP)
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
http://bwengr.com





RE: Excel Flowrates through Pipe calcs?
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?
B+W Engineering and Design
Los Angeles Civil and Structural Engineering
http://bwengr.com
RE: Excel Flowrates through Pipe calcs?
B+W Engineering and Design
Los Angeles Civil and Structural Engineering
http://bwengr.com
RE: Excel Flowrates through Pipe calcs?
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?
RE: Excel Flowrates through Pipe calcs?
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
http://bwengr.com
RE: Excel Flowrates through Pipe calcs?
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.