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 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.
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.
These Excel spreadsheets calculate the head loss and pressure drop for flow through an annulus between two pipes, for flow of a liquid through the annulus. Inner and outer pipe diameters, pipe length, and pipe roughness must be specified, along with volumetric flow rate, liquid density and viscosity. There is also a worksheet to calculate flow rate of the liquid through the annulus when the other parameters are specified. Calculations are in U.S. units.
These Excel spreadsheets calculate the head loss and pressure drop for flow through an annulus between two pipes, for flow of a liquid through the annulus. Inner and outer pipe diameters, pipe length, and pipe roughness must be specified, along with volumetric flow rate, liquid density and viscosity. There is also a worksheet to calculate flow rate of the liquid through the annulus when the other parameters are specified. Calculations are in S.I. units.
This Excel spreadsheet makes compressible flow (Fanno Flow) calculations for air flow through a non-circular duct. There are worksheets for flow through an annulus, flow thru a rectangular duct and for flow through a nonicircular duct in general. For each of these,the frictional pressure drop can be found for specified air flow rate, pipe diameters (or duct dimensions) and length, surfaace roughness, and inlet air temperature and pressure. Also, flow rate can be determined for specified pressure drop. Each of the worksheets calculates the conditions for "choked" flow to show the limits for user input parameters. Calculations are in U.S. units.
This Excel spreadsheet makes compressible flow (Fanno Flow) calculations for air flow through a non-circular duct. There are worksheets for flow through an annulus, flow thru a rectangular duct and for flow through a nonicircular duct in general. For each of these,the frictional pressure drop can be found for specified air flow rate, pipe diameters (or duct dimensions) and length, surfaace roughness, and inlet air temperature and pressure. Also, flow rate can be determined for specified pressure drop. Each of the worksheets calculates the conditions for "choked" flow first to show the limits for the user input parameters. Calculations are 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 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.
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.