+ Reply to Thread
Results 1 to 5 of 5

Moody's f (friction factor)

  1. #1
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Moody's f (friction factor)

    Hi guys,

    I have found an excel worksheet with the following formula:
    Moody's f = 0.001375*(1+(20000*Pipe Roughness factor 'k'/(Pipe Diameter)+1000000/Reynolds)^(1/3))

    I haven't been able to find the reference to the formula.
    I want to replace it with a formula that I can get a reference too, however every formula I have found is recursive (or requires reading off charts), I would like to find a formula that isnt recursive like the one above.

    Thanks!
    Last edited by 6StringJazzer; 05-11-2021 at 07:41 AM. Reason: corrected placement of apostrophe
    Thanks,

    JimmyWilliams

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Moody's f (friction factor)

    The formula you showed is not recursive. Can you be more specific about the issue? Can you provide the Excel worksheet you are talking about?

    What do you mean by a reference? Do you mean a source that provides and explains a formula? I was able to find this: https://www.sciencedirect.com/topics...riction-factor The references to Moody seem to more along the lines of a type of graph rather than a scalar factor.

    Your question is a pretty esoteric engineering question rather than an Excel question, so you may have better luck on engineering forums.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Moody's f (friction factor)

    Quote Originally Posted by 6StringJazzer View Post
    The formula you showed is not recursive. Can you be more specific about the issue? Can you provide the Excel worksheet you are talking about?

    What do you mean by a reference? Do you mean a source that provides and explains a formula? I was able to find this: https://www.sciencedirect.com/topics...riction-factor The references to Moody seem to more along the lines of a type of graph rather than a scalar factor.

    Your question is a pretty esoteric engineering question rather than an Excel question, so you may have better luck on engineering forums.
    The formula you showed is not recursive.
    yes, but it does not provide a source or reference. I would like to use a formula that is also not recursive, but with a reference.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Moody's f (friction factor)

    I would like to use a formula that is also not recursive, but with a reference.
    I don't know that any of us here know fluid dynamics well enough to tell you which equation (and what the reference will be for that equation) that calculates friction losses in a pipe and is not recursive. My internet search mostly found the Darcy-Weisbach equation, and that one, like yours, is also recursive.

    I know there are many engineering calculations that are recursive and there is no good way around the need for recursion. If you are certain that a non-recursive equation exists, you are more knowledgeable than we are and more likely to be able to find that equation. Once you know the equation, then you can bring it back here and we can help you program that into Excel.

    If it helps, I found this tutorial specific to putting the Darcy Weisbach into Excel (complete with equations for Moody's friction factor): https://www.cedengineering.com/userf...th%20Excel.pdf

    Also if it helps, I have a tutorial here that talks about programming iterative/recursive equations into Excel: https://www.excelforum.com/tips-and-...ind-roots.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Moody's f (friction factor)


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Factor Up and Factor Down Values Formula
    By alive555 in forum Excel General
    Replies: 6
    Last Post: 08-14-2015, 12:01 PM
  2. Selecting Lowest of the 3 Credit Ratings (S&P, Moodys, Fitch)
    By farriola in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-31-2014, 12:17 PM
  3. [SOLVED] Remove friction's value if less then 5 other wise round it
    By ihtesham in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-29-2014, 01:08 PM
  4. Friction Factor calculation function
    By Gustonian in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-06-2013, 01:31 PM
  5. The 'WOW' Factor
    By Hopefull in forum Excel General
    Replies: 1
    Last Post: 09-11-2011, 04:07 PM
  6. Excel 2007 : Friction loss calculation help
    By trager551 in forum Excel General
    Replies: 2
    Last Post: 03-04-2010, 04:53 PM
  7. IF FACTOR?
    By Bernadette in forum Excel General
    Replies: 2
    Last Post: 06-08-2006, 09:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1