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 file 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 friction factor pipe flow calculator spreadsheet has three tabs, one for head loss/frictional pressure drop calculation, one for calculating flow rate through the pipe and one for determning 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.
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. 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. 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 an annulus. The frictional pressure drop can be found for specified air flow rate, pipe diameters and length, pipe roughness, and inlet air temperature and pressure. Also, flow rate can be determined for specified pressure drop. Calculations are in U.S. 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.