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, 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, 4) Hazen Williams Pipe Flow Calculations Package, 5) Moody Friction Factor Calculator, and 6) Min Pipe Wall Thickness-Max Pressure.
FREE DOWNLOAD! Try this Excel spreadsheet to calculate the frictional head loss and pressure drop for specified flow rate, pipe diameter, pipe length, pipe roughness, liquid density and viscosity, and the value of the Moody friction factor. U.S. and S.I. 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 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 calculation of natural gas properties, such as compressibility factor, density and viscosity. It has worksheets to calculate 1) natural gas flow rate, 2) required pipeline diameter, 3) outlet pressure, or 4) inlet pressure using the Weymouth Equation, the Panhandle A Equation, and the Panhandle B Equation. 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 calculation of natural gas properties, such as compressibility factor, density and viscosity. It has worksheets to calculate 1) natural gas flow rate, 2) required pipeline diameter, 3) outlet pressure, or 4) inlet pressure using the Weymouth Equation, the Panhandle A Equation, and the Panhandle B Equation. S.I. units are used in the calculations.
These Fanno Flow Calculator Excel spreadsheet workbooks carry out adiabatic compressible flow calculations and incompressible flow calculations for turbulent gas flow through a pipe, including minor losses. The incompressible flow calculations are satisfactory if the frictional pressure drop is less than 10% of the incoming gas pressure. The Fanno flow calculator portion of the spreadsheet is needed if the frictional pressure drop is greater than 10% of the incoming gas pressure. There are worksheets for calculating frictional pressure drop, gas flow rate, or minimum required pipe diameter. The worksheets each calculate "choked flow" conditions first to show the limits for the user input parameters. Needed gas properties are available in the workbook for 23 gases (acetylene, air, ammonia, argom. carbon dioxide, carbon monoxide, chlorine, ethane, ethylene, helium, hydrogen, hydrogen chloride, hydrogen sulphide, krypton, methane, methyl chloride, neon, nitric oxide, nitrogen, nitrous oxide, oxygen, sulphur dioxide, and xenon. ) Also the user may enter the needed gas properties for any other gas. Calculations use U.S. units.
These compressible pipe flow calculator Excel spreadsheet workbooks carry out Fanno flow calculations (for compressible, adiabatic flow) and incompressible flow calculations for turbulent gas flow through a pipe with the capability to include minor losses. The incompressible flow calculations are satisfactory if the frictional pressure drop is less than 10% of the incoming gas pressure. The compressible pipe flow calculator (fanno flow) portion of the spreadsheet is needed if the frictional pressure drop is greater than 10% of the incoming gas pressure. There are worksheets for calculating frictional pressure drop, gas flow rate, or minimum required pipe diameter.The worksheets each calculate "choked flow" conditions first to show the limits for the user input parameters. Needed gas properties are available in the Excel workbook for 23 gases (acetylene, air, ammonia, argon, carbon dioxide, carbon monoxide, chlorine, ethane, ethylene, helium, hydrogen, hydrogen chloride, hysrogen sulphide, krypton, methane, methyl chloride, neon, nitric oxide, nitrogen, nitrous oxide, oxygen sulphur dioxide, and xenon.) Also the user may enter the needed gas properties for any other gas. 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.