Pipe Flow/Friction Factor Calculations using Excel ...

← Back to document page

pipe Flow/Friction Factor Calculations using Excel Spreadsheets Harlan H. Bengtson, PE, PhD Emeritus Professor of Civil Engineering Southern Illinois University Edwardsville Table of Contents Introduction Section 1 The Basic Equations Section 2 Laminar and Turbulent Flow in Pipes Section 3 Fully Developed Flow and the Entrance Region Section 4 Obtaining friction Factor Values Section 5 calculation of Frictional Head Loss and/or Frictional Pressure Drop Section 6 A Spreadsheet for calculation of pipe Flow Rate Section 7 A Spreadsheet for calculation of Required pipe Diameter Summary References Introduction The darcy - weisbach equation or the Fanning equation and the friction Factor (Moody friction Factor or Fanning friction Factor ) are used for a variety of pressure pipe flow Calculations . Many of these types of Calculations require a graphical and/or iterative solution. The necessary iterative Calculations can be carried out conveniently through the use of a spreadsheet.

The Darcy-Weisbach equation or the Fanning equation and the friction factor (Moody friction factor or Fanning friction factor) are used for a variety of pressure pipe flow calculations. Many of these types of calculations require a graphical and/or iterative solution. The necessary iterative calculations can be carried out conveniently through the

  Using, Factors, Excel, Flows, Pipe, Calculation, Friction, Darcy, Weisbach, Pipe flow friction factor calculations using excel