Pipe Flow-Friction Factor Calculations with Excel
Credits: 3 PDH
PDH Course Description:
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 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 and sample Excel spreadsheets for making the calculations are also included.Topics:
- The Reynolds number for determining if pipe flow is laminar or turbulent
- Calculation of the entrance length for pipe flow
- Using the Moody Diagram to get a value for the friction factor
- Using the Moody friction factor equations to calculate the friction factor
- The Darcy Weisbach equation, its parameters and U.S. & S.I. units
- Calculation of frictional head loss and frictional pressure drop for known Q, D, L, pipe roughness, and fluid properties
- Calculation of required pipe diameter for known Q, L, head loss, pipe roughness, and fluid properties
- Calculation of fluid flow rate for known D, L, head loss, pipe roughness, and fluid properties
To take this course:
1.) Enroll in Course: Click below to enroll:
(must be logged into your user account)
Download the Study Guide
3.) Test: Once you've thoroughly read the course materials, please click below to take the final examination.
Take the final exam
4.) Certificate: A passing grade of 70% or higher on the exam, is required to receive the certificate of completion for this PDH course.
NOTE: After the exam is completed, you will need to return to this page, in order to print (download) the certificate of completion.
Print the Certificate of Completion
Intended Audience: 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.
Publication Source: Harlan H. Bengtson, Phd, PE
Print the Certificate of Completion
Intended Audience: 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.
Publication Source: Harlan H. Bengtson, Phd, PE
Harlan Bengtson PhD, PE