Does anyone know how to created a formula for depth of flow in a circular pipe in excel? I am trying to create this formual in autocad with expressions. Any help will be greatly appreciated.
yes at a given Q like mannings equation. What i have is the velocity, friciton slope, slope, size of pipe,n, and capacity worked out but i cant figure out how to write a formula for depth of flow in a pipe in excel. If i can write the formula in excel i'm pretty sure i can do it with an autocad expression for a pipe label.
You can also look at this thread from last year. I posted a spreadsheet that calcs the flow depth and velocity for any flow. The macro is in Visual Basic and runs in the excel spreadsheet. Instructions are in the tread.
Wish I knew how to edit my comment above, The macro might be a little confusing, it basically iterates through Manning's equation to solve for the depth of flow. The Macro can be reduced in size, I just jammed it together to get it to work fast.
You can easily use goal seek in excel. No macro needed, but my way would be a one-by-one calculation - not a batch calculation for a long list of pipe.
Basically, you are putting manning's equation in one cell, with references to other cells for n, R, and S. You'll need R as a function of depth in order for this to give you depth. So you would be using your area and wetted perimeter in terms of d.
Draw a picture of the cross-section of pipe to help with the equations. Let me know if you need more help. I have done this myself.