Spreadsheet Use for Pipe Flow-Friction Factor Calculations

COURSE NO: C03-022
PDH CREDIT: 3 Course Highlights

This online engineering PDH course includes discussion of the Darcy-Weisbach equation and the parameters in the equation along with the U.S. and S.I. units to be used. Example calculations are provided to illustrate the use of this equation together with the Moody friction factor. A spreadsheet for making pipe flow-friction calculations is included with this course and its use is discussed and illustrated through worked examples.

Several kinds of pipe flow calculations can be made with the Darcy-Weisbach equation and the Moody friction factor.  These calculations can be conveniently carried out with an Excel spreadsheet. Many of the calculations require an iterative solution, so they are especially suitable for an Excel spreadsheet solution.

This 3 PDH online course is intended primarily for civil engineers, mechanical engineers, chemical engineers, and environmental engineers.  After completing this course you will be able to make calculations with the Darcy Weisbach equation and the Moody friction factor equations to calculate several different unknown parameters when sufficient input data is provided.  You will also be prepared to use Excel spreadsheets to efficiently make the calculations.

Learning Objectives

This PE continuing education course is intended to provide you with the following specific knowledge and skills:

• Ability to calculate the Reynolds number for pipe flow with specified flow conditions
• Ability to determine whether a specified pipe flow is laminar or turbulent flow for specified flow conditions
• Ability to calculate the entrance length for pipe flow with specified flow conditions
• Ability to obtain a value for the friction factor using the Moody diagram for given Re and e/D.
• Ability to calculate a value for the friction factor for specified Re and e/D, using the appropriate equation for f.
• Ability to determine a value of the Moody friction factor from the Moody diagram, for given Re and e/D.
• Ability to calculate a value of the Moody friction factor for given Re and e/D, using the Moody friction factor equations.
• Ability to use the Darcy Weisbach equation and the Moody friction factor equations to calculate the frictional head loss and frictional pressure drop for a given flow rate of a specified fluid through a pipe with known diameter, length and roughness.
• Ability to use the Darcy Weisbach equation and the Moody friction factor equations to calculate the required diameter for a given flow rate of a specified fluid through a pipe with known length and roughness, with specified allowable head loss.
• Ability to use the Darcy Weisbach equation and the Moody friction factor equations to calculate the fluid flow rate through a pipe with known diameter, length and roughness, with specified frictional head loss.
Course Document

In this professional engineering CEU course, you need to review the material in the course document, "Spreadsheet Use for Pipe Flow-Friction Factor Calculations".

To view, print and study the course document, please click on the following link(s):
Spreadsheet Use for Pipe Flow-Friction Factor Calculations (2.50MB)
Pipe Flow-Friction Factor Calculations Excel Spreadsheet (93 KB)
Course Quiz
Once you complete your course review, you need to take a multiple-choice quiz consisting of fifteen (15) questions to earn 3 PDH credits. The quiz will be based on the entire document.

The minimum passing score is 70%. There is no time limit on the quiz, and you can take it multiple times until you pass at no additional cost.
Certificate of Completion

Upon successful completion of the quiz, print your Certificate of Completion instantly. (Note: if you are paying by check or money order, you will be able to print it after we receive your payment.) For your convenience, we will also email it to you. Please note that you can log in to your account at any time to access and print your Certificate of Completion.