Excel formula for Circular Pipe Flow, given Q/Q-full, find D/D-full. 1

[TechChap]

Can anybody please help me with excel formula for the following:

1. Given are, Manning's n, Slope S, Pipe diameter D and discharge in the circular pipe Q.

2. How can I find the flow depth "D" in the for a given discharge in the pipe "Q".

Please help.

Thanks

 

[civilperson]

I would plot three or four points on a graph with the depth on the horizontal axis and the Q,(flow), on the vertical axis. Add more points near the location of the Q given and then interpolate. Land Desk and other programs have flow curves equations built in, just enter the required variables.

 

[BigInch]

Spreadsheet for pipe flow/capacity
see thread770-192109

beastmodeactivated (Civil/Environme)

has already posted one on the Engineering Spreadsheet Forum
download it here,

http://rapidshare.com/files/42529967/TrueMannings1.xls.html

http://virtualpipeline.spaces.msn.com