I constructed the attached worksheet for partially full open channel flow in a pipe using the Manning's and Colebrook-White equation, the problem is that the calculation proceeds as would be expected if the pipe diameter is 2 m but if one changes the diameter to be small or bigger than 2 m (change the highlighted yellow value) then the whole calculation gives very unexpected results and in some cases division by zero errors. Can some of the more learned users examine this worksheet and explain to me why this is the case?
Thanking you in advance.
Kind regards, Mark Buckton
Solved! Go to Solution.
I hope this WebSheets will be useful for your pipe calculation:
Thank you for this insight, I was not aware of this work around for empirical formulas hense why I have given the normally unitless Manning's n units of m^-1/3/sec^-1. I will file your suggestion for later use. However this workaround does not answer the specific problem i.e. why does the answer "blow up" (as seen in the graphs) for pipe diameter values less than or bigger that 2m.