Spreadsheet Use for Pipe Flow-Friction Factor Calculations
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.
This P.Eng. 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.
In this professional engineering CEU course, you need to review the material in the course document, "Spreadsheet Use for Pipe Flow-Friction Factor Calculations".
Pipe Flow-Friction Factor Calculations Excel Spreadsheet (93 KB)
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.