×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*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.

# Pipelines, Piping and Fluid Mechanics engineering FAQ

## Flow in Pipe

 Spreadsheet for Friction Factors by quark faq378-1237 Posted: 20 Apr 06 As I prepared an excel spreadsheet to calculate various friction factor expressions (both implicit and explicit), I thought to share it with you guys, not because it is too difficult to do this but to avoid wastage of your time in writing those lengthy expressions and also the subsequent wastage of time in finding out which brace() we missed out.ProcedureEnter values of Reynolds Number in æC4Æ and e/D in æF4ÆFor Churchill Equation, enter the code of A =POWER(-2.457*LN((POWER((7/C4),0.9)+(0.27*F4))),16) in æC16 and of B =POWER((37530/C4),16) in æC17ÆEnter the code of f =8*POWER(((POWER((8/C4),12))+(1/(POWER((C16+C17),1.5)))),(1/12)) in æC18ÆFor Sherghides equationA =-2*(LOG((F4/3.7)+(12/C4))) in æC30ÆB =-2*(LOG((F4/3.7)+(2.51*C30/C4))) in æC31ÆC =-2*(LOG((F4/3.7)+(2.51*C31/C4))) in æC32ÆAnd f =POWER((C30-((POWER((C31-C30),2))/(C32-(2*C31)+C30))),-2) in æC33ÆFor Moody EquationF =(5.5/1000)*(1+(POWER(((2*10000*F4)+(1000000/C4)),1/3))) in æC39ÆFor Wood Equationa =-1.62*(POWER(F4,0.134)) in æC46Æand f =((0.094*(POWER(F4,0.225)))+(0.53*F4)+(88*(POWER(F4,0.44))*(POWER(C4,C46)))) in æC47ÆFor Jain Equationf =1/(POWER((1.14-(2*LOG(F4+(21.25/(POWER(C4,0.9)))))),2)) in æC54ÆFor Chen EquationA =LOG(((POWER(F4,1.1098))/2.8257)+(5.8506/(POWER(C4,0.8981)))) in æC62Æf =1/(POWER((-2*LOG((F4/3.7065)-(5.0452*C62/C4))),2)) in æC63ÆFor Zigrang and Sylvester EquationA =LOG((F4/3.7)-((5.02/C4)*(LOG((F4/3.7)+(13/C4))))) in æC71Æf =1/(POWER((-2*LOG((F4/3.7)-(5.02*C71/C4))),2)) in æC79ÆFor Colebrook EquationEnter initial f value as 0.02 in æC85ÆAnd copy the following formulae =1/(POWER((-2*LOG((F4/3.7)+(2.51/(C4*(POWER(C85,0.5)))))),2)) in æD87Æ =1/(POWER((-2*LOG((F4/3.7)+(2.51/(C4*(POWER(D87,0.5)))))),2)) in æE87Æ =1/(POWER((-2*LOG((F4/3.7)+(2.51/(C4*(POWER(E87,0.5)))))),2)) in æF87Æ =1/(POWER((-2*LOG((F4/3.7)+(2.51/(C4*(POWER(F87,0.5)))))),2)) in æG87Æ =1/(POWER((-2*LOG((F4/3.7)+(2.51/(C4*(POWER(G87,0.5)))))),2)) in æH87ÆGenerally G87 and H87 will have equal values(i.e Colebrook's equation generally converges after 4th step of iteration) and this is your friction factor for the given Re and e/DOnce you are done with making the spreadsheet, you can safely delete all those redundant rows from the spreadsheet.Please let me know in case of any technical problem. Back to Pipelines, Piping and Fluid Mechanics engineering FAQ Index Back to Pipelines, Piping and Fluid Mechanics engineering Forum

#### Resources

Case Study - Brand spirits leader digitizes its business operations with the SIMATIC IT suite
Using Siemens technology, Gruppo Campari has created a unified repository for all product specifications and increased the efficiency of product development and manufacturing processes. Download Now
White Paper - A Guide to 3D Printing Materials
When it comes to using an FDM 3D printer effectively and efficiently, choosing the right material at the right time is essential. This 3D Printing Materials Guide will help give you and your team a basic understanding of some FDM 3D printing polymers and composites, their strengths and weaknesses, and when to use them. Download Now
White Paper - Multidisciplinary Simulation and Design Exploration in the Chemical and Process Indust
Simcenter STAR-CCM+ makes simulation accessible to process engineers with limited simulation experience but strong process knowledge. This flood of knowledge and skills will make the industry more cost efficient, less polluting and ultimately more innovative. Download Now
White Paper - Multidisciplinary Simulation and Design Exploration in the Oil and Gas Industry
The need to reduce exploration and development costs has never been more important to the future of the oil and gas industry. In this special report we present how engineers and scientists from leading oil and gas companies are deploying Siemensâ€™ simulation software in the design and operation of a range of oil and gas products and systems. Download Now

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!