The pipe flow calculations spreadsheets and spreadsheet packages in this category include the following:
Scroll down for descriptions of these spreadsheets in either U.S. units or S.I. units.
This spreadsheet bundle contains the U.S. version of all six of the spreadsheets described below in this category, that is: 1) Pipe Flow Calcns-Incompressible Laminar or Turbulent Flow, 2) Natural Gas Pipeline Flow Calculations, 3) Compressible Pipe Flow-Fanno Flow Calculator - Air, 4) Hazen Williams Pipe Flow Calculations Package, 5) Moody Friction Factor Calculator, and 6) Min Pipe Wall Thickness-Max Pressure.
This spreadsheet bundle contains the S.I. version of all six of the spreadsheets described below in this category, that is: 1) Pipe Flow Calcns-Incompressible Laminar or Turbulent Flow, 2) Natural Gas Pipeline Flow Calculations, 3) Compressible Pipe Flow-Fanno Flow Calculator - Air, 4) Hazen Williams Pipe Flow Calculations Package, 5) Moody Friction Factor Calculator, and 6) Min Pipe Wall Thickness-Max Pressure.
This Excel spreadsheet makes pipe flow/friction factor calculation for either laminar or turbulent flow conditions. The spreadsheet has three tabs, one for head loss/frictional pressure drop in pipe calculation, one for calculating pipe flow rate and one for determining required pipe diameter. All three are for liquid flow and all are set up to include the effects of straight pipe losses and/or minor losses. This package includes the friction factor calculator. Calculations use the Darcy-Weisbach/friction factor equation and are in U.S. units.
This Excel spreadsheet makes pipe flow/friction factor calculation for either laminar or turbulent flow conditions. The spreadsheet has three tabs, one for head loss/frictional pressure drop in pipe calculation, one for calculating pipe flow rate and one for determining required pipe diameter. All three are for liquid flow and all are set up to include the effects of straight pipe losses and/or minor losses. This package includes the friction factor calculator. Calculations use the Darcy-Weisbach/friction factor equation and are in S.I. units.
This Excel spreadsheet for natural gas pipeline flow calculations will carry out several pipeline flow calculations for natural gas, including calculations of natural gas properties, such as compressibility factor, density and viscosity. It has a worksheet to calculate natural gas flow rate using the Weymouth Equation, the Panhandle A Equation, and the Panhandle B Equation. It also has worksheets to calculate required pipeline diameter and outlet pressure using the same three equations. U.S. units are used in the calculations.
This Excel spreadsheet for natural gas pipeline flow calculations will carry out several pipeline flow calculations for natural gas, including calculations of natural gas properties, such as compressibility factor, density and viscosity. It has a worksheet to calculate natural gas flow rate using the Weymouth Equation, the Panhandle A Equation, and the Panhandle B Equation. It also has worksheets to calculate required pipeline diameter and outlet pressure using the same three equations. S.I. units are used in the calculations.
These Fanno Flow Calculator Excel spreadsheets carry out compressible flow calculations and incompressible flow calculations for air flow through a pipe. The incompressible flow calculations are satisfactory if the frictional pressure drop is less than 20% of the incoming air pressure. The Fanno flow calculator portion of the spreadsheet is needed if the frictional pressure drop is greater than 20% of the incoming air pressure. There are worksheets for calculating frictional pressure drop, air flow rate, or minimum required pipe diameter. The worksheets each calculate "choked flow" conditions first to show the limits for the user input parameters. Calculations use U.S. units.
These compressible pipe flow calculator Excel spreadsheets carry out Fanno flow calculations and incompressible flow calculations for air flow through a pipe. The incompressible flow calculations are satisfactory if the frictional pressure drop is less than 20% of the incoming air pressure. The compressible pipe flow calculator (fanno flow) portion of the spreadsheet is needed if the frictional pressure drop is greater than 20% of the incoming air pressure. There are worksheets for calculating frictional pressure drop, air flow rate, or minimum required pipe diameter.The worksheets each calculate "choked flow" conditions first to show the limits for the user input parameters. Calculations use S.I. units.
This Excel spreadsheet package includes capability to calculate pipe flow rate, diameter, pressure drop, or length with the Hazen Williams equations, if the other parameters are specified. Calculations are in U.S. units
This set of Excel spreadsheets can calculate pipe flow rate, diameter, pressure drop, or length if the other parameters are specified, using the Hazen Williams equation in S.I. units.
This handy Excel spreadsheet will calculate the Moody friction factor for specified pipe diameter, length, roughness, and flow rate, along with fluid density and viscosity. An iterative solution of the Colebrook equation is used and the equations are shown on the spreadsheet, so you can see how the friction factor value is determined. Calculations are in U.S. units.
This handy friction factor calculator is an Excel spreadsheet that will calculate the Moody friction factor for specified pipe diameter, length, diameter, roughness and flow rate along with fluid density and viscosity. An iterative solution of the Colebrook equation is used and the equations are shown on the spreadsheet, so you can see how the friction factor value is determined. Calculations are in S.I. units.
This Excel spreadsheet will calculate the minimum required pipe wall thickness for specified fluid pressure, pipe O.D., yield strength of the pipe material, safety factor, and corrosion allowance. Also the maximum operating pressure and bursting pressure can be calculated for a specified pipe wall thickness. A table of O.D., wall thickness, and I.D. for schedule 10, schedule 40 and schedule 80 pipes is also included.These calculations use U.S. units.
This Excel spreadsheet will calculate the minimum required pipe wall thickness for specified fluid pressure, pipe O.D., yield strength of the pipe material, safety factor, and corrosion allowance. Also the maximum operating pressure and bursting pressure can be calculated for a specified pipe wall thickness. A table of O.D., wall thickness, and I.D. for schedule 10, schedule 40 and schedule 80 pipes is also included.These calculations use S.I. units.