This spreadsheet bundle contains the U.S. version of all seven 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, 6) Min Pipe Wall Thickness-Max Pressure, 7) API 570-API 574 Piping Inspection Calculations.

This spreadsheet bundle contains the S.I. version of all seven 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, 6) Min Pipe Wall Thickness-Max Pressure, and 7) API 570-API 574 Piping Inspection Calculations.

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.

Pipe Flow Pressure Drop Calculator

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.

Pipe Flow Rate Calculator

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.

This Fanno Flow Calculator Excel spreadsheet workbook carries out adiabatic compressible flow calculations for turbulent or laminar gas flow through a pipe, including minor losses.   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.

Fanno Flow Calculator Spreadsheet

This Fanno Flow Calculator Excel spreadsheet workbook carries out adiabatic compressible flow calculations for turbulent or laminar gas flow through a pipe, including minor losses.   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 S.I. units.

compressible pipe flow calculator spreadsheet

 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.

This Excel spreadsheet makes piping inspection calculations as described in API 570, API 574, and ASME B31.3.  The calculations made in this spreadsheet workbook include pressure design wall thickness, required minimum wall thickness, long term corrosion rate, short term corrosion rate, remaining life, and maximum allowable working pressure (MAWP). Calculations are in U.S. units.

This Excel spreadsheet makes piping inspection calculations as described in API 570, API 574, and ASME B31.3.  The calculations made in this spreadsheet workbook include pressure design wall thickness, required minimum wall thickness, long term corrosion rate, short term corrosion rate, remaining life, and maximum allowable working pressure (MAWP). Calculations are in S.I. units.