×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Pipe Depth of Flow

Pipe Depth of Flow

Pipe Depth of Flow

(OP)
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.

Tony
Senior Design Tech

RE: Pipe Depth of Flow

Not sure what you are asking? Depth of flow at a given Q, like with Mannings Eq. or what?

RE: Pipe Depth of Flow

(OP)
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.

RE: Pipe Depth of Flow

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.

http://www.eng-tips.com/viewthread.cfm?qid=227242

RE: Pipe Depth of Flow

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.

RE: Pipe Depth of Flow

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources