# API 570 Piping Inspection Calculations Spreadsheet

## Where to Find an API 570 Piping Inspection Calculations Spreadsheet

To obtain an API 570 Piping Inspection Calculations spreadsheetclick here to visit our spreadsheet store.  This Excel spreadsheet is intended for making piping inspection calculations from API 570 and API 574.. You can buy a convenient API 570 piping Inspection calculations spreadsheet  for a very reasonable price.  This spreadsheet calculates required minimum pipe wall thickness, long term corrosion rate, short term corrosion rate, remaining life, and maximum allowable working pressure (MAWP).  It is available in either U.S. units or S.I. units.  Read on for information about using an API 570 piping inspection calculations spreadsheet.

## Formulas for API 570 Piping Inspection Calculations Spreadsheet

The required minimum wall thickness for piping  being inspected must be the greater of the calculated pressure design wall thickness and the structural minimum wall thickness.  The pressure design wall thickness is sometimes calculated with the Barlow formula and sometimes it is calculated with the ASME B31.3 formula.  Both are shown below.

In the Barlow formula and the ASME B31.3 formula, P is the design fluid pressure in psig, D is the pipe O.D. in inches, S is the allowable unit stress of the pipe material in psi, E is a longitudinal quality factor, and Y is a coefficient that is a function of the pipe material and the operating temperature.

The structural minimum wall thickness is available in API 574 Table 6 for some pipe materials.  The required minimum pipe wall thickness is the greater of the calculated pressure design wall thickness and the structural minimum wall thickness.

The long term corrosion rate and short term corrosion rate are calculated from values for the current measured pipe wall thickness, a previous pipe wall thickness or the initial pipe wall thickness and the time between the two.  The remaining life of the pipe is calculated as the difference between the current measured pipe wall thickness minus the required minimum pipe wall thickness divided by the corrosion rate.

The maximum allowable working pressure for a pipe is calculated from the formula:

MAWP = 2SEt/D

In this formula, S, E, and D are as defined above and t is the measured pipe wall thickness in inches.

## Example API 570 Piping Inspection Calculations Spreadsheet

An example API Piping Inspection Calculatons spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the required minimum pipe wall thickness, corrosion rate, remaining life, and maximum allowable working pressure (MAWP).  This Excel spreadsheet, as well as others for pipe flow calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

References:

1. American Piping Institute, AP! 570, Piping Inspection Code: In-service Inspection, Rating, Repair, and Alteration of Piping Systems, 3rd Ed, Nov, 2009

2. American Piping Institute, API 574, Inspection Practices for Piping System Components, 3rd Ed, Nov, 2009.

3. Bengtson, Harlan H., Spreadsheet for API Piping Inspection Calculations, an informational blog article at www.EngineeringExcelTemplates.com

# Compressible Pipe Flow Calculator Spreadsheet

## Where to Find a Compressible Pipe Flow Calculator Spreadsheet

To obtain a Compressible Pipe Flow Calculator Spreadsheetclick here to visit our spreadsheet store.  Look in the Pipe Flow Calculations category on the Download page.  This Excel spreadsheet is intended to calculate the frictional pressure drop, gas flow rate, or minimum required diameter for adiabatic compressible pipe flow.  You can buy a convenient compressible pipe flow calculator spreadsheet  for a very reasonable price.  Calculations may be made in either U.S. or S.I. units.  Read on for information about using a compressible pipe flow calculator spreadsheet.

## Background for Compressible Pipe Flow Calculator Spreadsheet

Compressible pipe flow calculations are needed for gas flow if the density of the gas changes during the flow through the pipe.  The fanno flow equations shown below can be used for calculations with a gas flow that has no heat transfer with surroundings.  Frictional losses are taken into account.  The fanno flow equations are shown below.

Example Compressible Pipe Flow Calculator Spreadsheet

An example compressible pipe flow calculator spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the frictional pressure drop, or the gas flow rate, or the required minimum pipe diameter.  This Excel spreadsheet, as well as others for pipe flow calculations, is available for both U.S. or S.I. units for a very reasonable price in our spreadsheet store.

References

1.  Munson, B. R., Young, D. F., & Okiishi, T. H., Fundamentals of Fluid Mechanics, 4th Ed., New York: John Wiley and Sons, Inc, 2002.

2. Darcy Weisbach equation history – http://biosystems.okstate.edu/darcy/DarcyWeisbach/Darcy-WeisbachHistory.htm

3. Bengtson, Harlan H.  Fanno Compressible Flow Calculator Spreadsheet,  An online blog article.

4. Bengtson, H.H., Pipe Flow/Friction Factor Calculations with Excel, an online continuing education course for Professional Engineers.

# Flow Through Non Circular Ducts Spreadsheet

## Where to Find a Spreadsheet for Flow Through Non Circular Ducts

To obtain a spreadsheet for  flow through non circular ductsclick here to visit our spreadsheet store.  Intended for use in calculating flow rate or frictional head loss and frictional pressure drop, you can buy a convenient spreadsheet for  flow through non circular ducts calculations for a very reasonable price.  This spreadsheet makes calculations with the Hagen Poiseuille equation for laminar flow and with the Moody friction factor and the Darcy Weisbach equation for turbulent flow for flow through an annulus and for flow through a rectangular duct.  Turbulent flow calculations can be made for a general non-circular duct with known cross-sectional area and wetted perimeter.  It is available in either U.S. or S.I. units.  Read on for information about a spreadsheet for flow through a non circular duct calculations.

## Turbulent Flow Through Non Circular Ducts

The Moody friction factor is used in the Darcy Weisbach equation for turbulent flow through non circular ducts.  The Darcy Weisbach equation is:

Where the hydraulic diameter is used for D in the Darcy Weisbach equation for flow through non circular ducts.  For further discussion of the Moody friction factor and its use in the Darcy Weisbach equation for pipe flow calculations, see the post, “Pipe Flow-Friction Factor Calculations with Excel Spreadsheets.”

## Laminar Flow Through Non Circular Ducts

For laminar flow in an annulus or laminar flow in a rectangular duct, the Hagen Poiseuille equation should be used.  For flow through an annulus, it is:

Hagen Poiseiulle equations for laminar flow through an annulus

## Example Spreadsheet for Flow Through Non Circular Ducts

A spreadsheet for flow through non circular ducts calculations is partially shown in the image below.  This Excel spreadsheet can be used to calculate the frictional pressure drop and head loss or flow rate for flow through an annulus (laminar or turbulent flow), flow through a rectangular duct (laminar or turbulent flow) or flow through a general non circular duct (turbulent flow only).  This Excel spreadsheet, as well as others for pipe flow calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

## Reference:

1. Bengtson, Harlan, “Pressure Drop in a Non Circular Duct”, an online blog article

# Spreadsheets for Turbulent and Laminar Flow in Pipes

## Where to Find a Spreadsheet for Turbulent and Laminar Flow in Pipes

To obtain a spreadsheet for  Turbulent and Laminar flow in pipesclick here to visit our spreadsheet store.  Intended for use in calculating pipe flow rate, frictional head loss, or required pipe diameter, you can buy a convenient spreadsheet for turbulent or laminar flow in pipes calculations for a very reasonable price.  This spreadsheet makes calculations with the Hagen Poiseuille equation for laminar flow and with the Moody friction factor and the Darcy Weisbach equation for turbulent flow.  It is available in either U.S. or S.I. units.  Read on for information about a spreadsheet for turbulent and laminar flow in pipes calculations.

## The Reynolds Number Criterion for Turbulent and Laminar Flow in Pipes

For flow in pipes, the Reynolds number is:  Re  =  DVρ/μ, for any consistent set of units for pipe diameter, D, flow velocity, V, fluid density, ρ, and fluid viscosity, μ.  Pipe flow will be turbulent if the Reynolds number is greater than 4000 and will be laminar if the Reynolds number for the flow is less than 2300.  If the Reynolds number is between 2300 and 4000, the flow may be either laminar or turbulent, depending on factors such as the type of pipe entrance and the roughness of the pipe wall.

## Equations for Turbulent and Laminar Flow in Pipes

For discussion of the Moody friction factor and its use in the Darcy Weisbach equation for turbulent pipe flow calculations, see the post, “Pipe Flow-Friction Factor Calculations with Excel Spreadsheets.”  For laminar flow in pipes, the Hagen Poiseuille equation is as follows:             ΔP  =  8μLQ/(Πr4 ),  where  ΔP is the frictional pressure drop in lb/ft2, μ is the fluid viscosity in lb/ft-sec, L is the length of the pipe in ft, Q is the flow rate through the pipe in cfs, and r is the pipe radius in ft.  Note that the Hagen Poiseulle equation is identical with the Darcy Weisbach equation for pipe flow with the Moody friction factor equal to 64/Re.

## Example Spreadsheet for Turbulent and Laminar Flow in Pipes Calculations

A spreadsheet for Turbulent and Laminar Flow in Pipes calculations is partially shown in the image below.  This Excel spreadsheet can be used to calculate the frictional pressure drop and head loss for known pipe flow rate, diameter and length along with fluid density and viscosity and the pipe wall roughness.  It can also be used to calculate pipe flow rate or minimum required pipe diameter if the other parameters are known.  This Excel spreadsheet, as well as others for pipe flow calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

References

1.  Munson, B. R., Young, D. F., & Okiishi, T. H., Fundamentals of Fluid Mechanics, 4th Ed., New York: John Wiley and Sons, Inc, 2002.

2. Darcy Weisbach equation history – http://biosystems.okstate.edu/darcy/DarcyWeisbach/Darcy-WeisbachHistory.htm

3. Bengtson, Harlan H.  Pipe Flow Calculations with the Darcy Weisbach Equation,  An online blog article.

4. Bengtson, H.H., Pipe Flow/Friction Factor Calculations with Excel, an online continuing education course for Professional Engineers.

5. Bengtson, Harlan, “Advantages of Spreadsheets for Pipe Flow/Friction Factor Calculations“, An Amazon Kindle e-book.

# Natural Gas Pipeline Flow Calculation Spreadsheet

## Where to Find a Natural Gas Pipeline Flow Calculation Spreadsheet

To obtain a natural gas pipeline flow calculation spreadsheet , click here to visit our spreadsheet store.  Intended for use in making natural gas pipeline design calculations, you can buy a convenient natural gas pipeline flow calculation spreadsheet for a very reasonable price.  This spreadsheet makes calculations with the Weymouth equation, the Panhandle A equation, and the Panhandle B equation, and is available in either U.S. or S.I. units.  Read on for information about a natural gas pipeline flow calculation spreadsheet.

## Choice of Equations for Natural Gas Pipeline Flow Calculations

Several different equations are used for natural gas pipeline flow calculations.  If the pressure drop across the pipe is less than 40 % of the average pipeline pressure, then the Darcy Weisbach equation is a possibility.  For longer pipelines with larger pressure drop, the three equations that are in most common use are the Weymouth equation, the Panhandle A equation, and the Panhandle B equation.  The choice among these three equations depends upon the pipeline diameter, the pipe length, and the average pipeline pressure.

## The Weymouth Equation for Natural Gas Pipeline Flow Calculations

The Weymouth equation was the first of the three to be developed and was the first equation for natural gas pipeline flow calculations that didn’t require an iterative calculation to get a value for the friction factor.  The Weymouth equation is:

Where:

• Q is the natural gas pipeline flow rate in SCFD
• E is the pipeline efficiency
• Tb is the base temperature in oR
• Pb is the base pressure in psia
• P1 is the inlet pressure in psia
• P2 is the outlet pressure in psia
• G is the specific gravity of the natural gas relative to air
• Tf is the pipeline temperature of the flowing natural gas in oR
• L is the pipeline length in miles
• Le  is the effective pipeline length in  miles
• ΔH is the height of the pipeline exit above the pipeline inlet in ft
• Z is the compressibility factor of the natural gas at pipeline T & P
• D is the pipeline diameter in inches.

## Example Spreadsheet for Natural Gas Pipeline Flow Calculations

A spreadsheet for Natural Gas Pipeline Flow Calculations is partially shown in the image below.  It can be used to calculate the natural gas pipeline flow rate with the Weymouth equation, the Panhandle A equation and the Panhandle B equation.  This Excel spreadsheet, as well as others for pipe flow calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

## References for Further Information:

1. Crane Co.,  (1988),  “Flow of Fluids through Valves, Fittings and Pipes,  Technical Paper 401.

2.  GPSA  (Gas Processors Suppliers Association),  (1988),  Engineering Data Book, 11th Ed.

3. Bengtson, Harlan H., (2016), “Natural Gas Pipeline Flow Calculations,”  available as a paperback book or as an Amazon Kindle ebook.

4.  Bengtson, Harlan H.,  (2017),   “Pipe Flow/Friction Factor Calculations with Spreadsheets“,  available as a paperback book or as an Amazon kindle e-book.

5. Bengtson, Harlan H., (2014),  “Natural Gas Pipeline Flow Calculation Spreadsheet“, a blog article at www.EngineeringExcelTemplates.com.

# A Spreadsheet for Choked Air Flow Calculation

## Where to Find a Spreadsheet for Choked Air Flow Calculation

To obtain a spreadsheet for choked air flow calculations click here to visit our spreadsheet store.  Intended for use in making fanno flow calculations with adiabatic compressible flow of air, you can buy a convenient spreadsheet for choked air flow calculations for a very reasonable price.  This spreadsheet will also calculate the frictional pressure drop, and is available in either U.S. or S.I. units.  Read on for information about a choked air flow calculation spreadsheet for compressible pipe flow.

## Conditions for Choked Air Flow Calculation with a Fanno Flow Excel Spreadsheet

For flow of air in a pipe with the frictional pressure drop less than 20% of the inlet air pressure, satisfactory results can be obtained using incompressible flow calculations with the Darcy-Weisbach equation.  For background information on that type of calculation, see the article, “Pipe Flow-Friction Factor Calculations with Excel Spreadsheets.”  If the frictional pressure drop is more than 20% of the incoming air pressure, then Fanno Flow equations should be used, as discussed here using a Fanno Flow Excel spreadsheet.

With adiabatic compressible flow conditions, the maximum air flow rate that can pass through a pipe is that which occurs when the exit Mach number is 1.0.  This is referred to as “choked flow.”

## Equations for Choked Air Flow Calculations with a Fanno Flow Excel Spreadsheet

Shown below are the primary equations used in the fanno flow excel spreadsheet being discussed here for compressible flow of air in a pipe.  These equations are for compressible pipe flow with negligible heat transfer with the surroundings, but including effects of friction in the flow.

The parameters in these fanno flow equations are as follows:

• f = Moody friction factor
• L = pipe length
• D = pipe diameter
• k = adiabatic constant for the flowing air
• M = mach number
• T = air temperature
• P = air pressure
• ρ = air density

Parameters with an asterisk refer to conditions at the “choke point” in the pipe, where the Mach number is 1.

## Screenshot for a Choked Air Flow Calculation Spreadsheet Using Fanno Flow Equations

The screenshot below shows part of a fanno flow excel spreadsheet for making compressible air flow calculations.  These calculations are for air flow in a pipe, in S.I. units. This Excel spreadsheet and others for compressible pipe flow calculations in a fanno flow excel spreadsheet are available in either U.S. or S.I. units at a very reasonable cost  in our spreadsheet store.

Reference:

Bengtson, Harlan H.,  “Compressible Flow Pressure Drop Calculator Spreadsheet,” an online blog article

# Flow Through Annulus Calculator Excel Spreadsheet

## Where to Find an Excel Spreadsheet Flow Through Annulus Calculator

For an Excel spreadsheet liquid flow through annulus calculatorclick here to visit our spreadsheet store.  Look in the “Non-Circular Duct flow Calculations” category.  Obtain a convenient, easy to use spreadsheet liquid flow through annulus calculator at a reasonable price. Read on for information about the use of Excel spreadsheets to calculate pressure drop or liquid flow rate for annulus flow.

## Friction Factor-Pipe Flow Background for a Liquid Flow Through Annulus Calculator

A liquid flow through annulus calculator spreadsheet uses calculations that are very similar to those for flow through a pipe.  The main difference is use of the hydraulic diameter for flow through an annulus in place of the pipe diameter as used for pipe flow.  For details of pipe flow calculations, see the article, “Friction Factor/Pipe Flow Calculations with Excel Spreadsheets.”

## Calculation of the Hydraulic Diameter for a Liquid Flow Through Annulus Calculator

The general definition of hydraulic diameter for flow through a non-circular cross-section is:                               DH = 4(A/P),    where:

• DH is the hydraulic diameter in ft (m for S.I. units)
• A is the cross-sectional area of flow in sq ft (sq m for S.I. units)
• P is the wetted perimeter in ft (m for S.I. units)

For a flow through annulus calculator:

• A = (π/4)(Do2 –  Di2)
• P  =  π(Do + Di)

Where Do is the inside diameter of the outer pipe and Di is the outside diameter of the inner pipe.  Substituting for A and P in the definition of  DH and simplifying gives:

DH =  Do – Di

## Equations for the Liquid Flow Through Annulus Calculator

The Darcy Weisbach equation for flow in an annulus is:  hL = f(L/DH)(V2/2g), with the parameters in the equation as follows: hL is the frictional head loss for flow of a liquid at average velocity, V, through an annulus of length, L, and hydraulic diameter, DH .  The Reynolds number for the flow (Re) and the relative roughness of the pipe (Manning roughness coefficient /pipe diameter, ε/D) are needed to get a value for the friction factor, f.  The Moody friction factor diagram and equations for calculating the friction factor, f, are presented and discussed in the article, “Friction Factor/Pipe Flow Calculations with Excel Spreadsheets.”

## Spreadsheets for the Liquid Flow Through Annulus Calculator

The Excel spreadsheet screenshot below shows a liquid flow through annulus calculator spreadsheet for calculation of the head loss and frictional pressure drop for flow of a liquid through an annulus.  Based on the input values for the annulus diameters and length as well as liquid flow rate and properties, the spreadsheet will calculate the head loss and frictional pressure drop.

For low cost, easy to use spreadsheets to make these calculations as well as similar calculations for liquid flow in an annulus or for pipe flow calculations, in S.I. or U.S. units, click here to visit our spreadsheet store.

References

1.  Munson, B. R., Young, D. F., & Okiishi, T. H., Fundamentals of Fluid Mechanics, 4th Ed., New York: John Wiley and Sons, Inc, 2002.

2. Bengtson, H.H., Pipe Flow/Friction Factor Calculations with Excel, an online continuing education course for Professional Engineers.

3.  Bengtson, Harlan H.,  Advantages of Spreadsheets for Pipe Flow/Friction Factor Calculations,  an e-book available through Amazon.com.

# Minimum Pipe Wall Thickness Calculator Excel Spreadsheet

## Where to Find a Minimum Pipe Wall Thickness Calculator Spreadsheet

For an Excel spreadsheet to use as a minimum pipe wall thickness calculator, click here to visit our spreadsheet store.  Read on for information about the use of an Excel spreadsheet as a minimum pipe wall thickness calculator.

## The Barlow Formula for a Minimum Pipe Wall Thickness Calculator

The classic Barlow formula for calculating bursting pressure for a pipe is:

P = 2S*T/Do where:

• Do is the outside diameter of the pipe with units of inches (U.S.) or mm (S.I.)
• S is the strength of the pipe material with units of psi (U.S.) or N/mm2 (S.I.)
• T is the wall thickness with units of inches (U.S.) or mm (S.I.)
• P is the fluid pressure in the pipe with units of psi (U.S.) or MPa (S.I.)

If the ultimate tensile strength of the pipe material is used for S, then P will be the bursting pressure, while P will be the pressure at which permanent deformation of the pipe begins if S is the yield strength of the material.

The Barlow formula can be rearranged to: T = /Do*P/2S to use in a minimum pipe wall thickness calculator for the pipe wall thickness for a given bursting pressure or deformation pressure.

## Calculation of Maximum Pipe Operating Pressure

The Barlow formula can be modified to calculate the maximum fluid operating pressure for a given pipe wall thickness and pipe diameter, by incorporation of a safety factor and corrosion allowance as follows:

P = 2S*(T – Tc)/SF*Do

where  SF is a safety factor (dimensionless) and Tc is a corrosion allowance in inches (U.S.) or mm (S.I.).  This equation uses the outside pipe diameter in the calculations, which is convenient, because the outside pipe diameter remains the same for all of the schedules (wall thicknesses) for a given nominal pipe size.  The calculation can be done using the outside pipe diameter (Do) in an equation based on the inside pipe diameter, by using the relationship,  Di =  Do –  2T , to give the equation:

P = 2S*(T – Tc)/SF*(Do –  2T)

## Use of Equations in a Minimum Pipe Wall Thickness Calculator

The last equation in the previous section can be rearranged to give a pipe wall thickness formula as follows:

T = (P* SF*Do + 2S*Tc)/(2S + 2P*SF)

## An Excel Spreadsheet as a Minimum Pipe Wall Thickness Calculator

The Excel spreadsheet template shown below can be used as a minimum pipe wall thickness calculator or to calculate the maximum operating pressure in a pipe if the necessary other parameters are known/specified.   Why bother to make these calculations by hand?  This Excel spreadsheet and others for pipe flow calculations are available in either U.S. or S.I. units at a very low cost in our spreadsheet store.

# Pipe Flow-Friction Factor Calculations with Excel Spreadsheets

## Where to Find Spreadsheets for Pipe Flow-Friction Factor Calculations with Excel

For spreadsheets to use for pipe flow-friction factor calculations with Excel, click here to visit our spreadsheet store.  Why read values from a Moody diagram, make iterative calculations to get friction factor, or use online calculators, when you can get a spreadsheet for pipe flow/friction factor calculations with Excel for only \$19.95?  Read on for information about the Darcy Weisbach equation and its use in an Excel spreadsheet as a friction factor/pipe flow calculator.

Excel spreadsheets are very convenient for Darcy Weisbach equation/pipe flow calculations, such as frictional pressure drop calculation or use of a friction factor calculator, at least in part because some of the calculations require iterative solutions.  The Darcy Weisbach equation is applicable to pressure flow in pipes, rather than gravity flow (as in sewer pipes), which is handled by open channel flow equations like the Manning equation.  The Darcy Weisbach equation provides the relationship among the following parameters: pipe diameter and length, pipe flow rate, and  frictional pressure drop or head loss.  Any one of these can be calculated if the others are known along with the density and viscosity of the fluid.

## A Friction Factor Calculator and the Darcy Weisbach Equation

The Darcy Weisbach equation  is hL= f(L/D)(V2/2g), with the parameters in the equation as follows: hLis the frictional head loss for flow of a fluid at average velocity, V, through a pipe of length,L, and diameter,D.  The Reynolds number for the flow (Re) and the relative roughness of the pipe (e/D) are needed to get a value for the friction factor,f.  The Moody Diagram at the right shows the nature of the dependence of the friction factor, f,  on Re and e/D.

Equations for f as a function of Re and e/D would be more convenient than a graph like the Moody Diagram for use with Excel spreadsheets making  pipe flow calculations with the Darcy Weisbach equation.  Such equations are shown in the box at the left, giving the relationships between Moody friction factor and Re & e/D for four different portions of the Moody diagram.  The four portions of the Moody diagram are:

• laminar flow(Re < 2100 – the straight line at the left side of the Moody
• smooth pipe turbulent flow(the dark curve labeled “smooth pipe” in the Moody diagram – f is a function of Re only in this region)
• completely turbulent region(the portion of the diagram above and to the right of the dashed line labeled “complete turbulence” – f is a function of e/D only in this region)
• transition region(the portion of the diagram between the “smooth pipe” solid line and the “complete turbulence” dashed line – f is a function of both Re and e/D in this region and this is not an explicit equation for f)

The table above right gives pipe roughness values for several common pipe materials.  These can be used to calculate the pipe roughness ratio, e/D.

For a low cost Moody friction factor calculator download, that will calculate f for Reynolds number above 2100, see: www.engineeringexceltemplates.com

## Frictional Head Loss and Frictional Pressure Drop Calculation

After using the Moody friction factor calculator to get a value for the friction factor, f, frictional head loss calculation is quite straightforward if the pipe length & diameter and average flow velocity are known.  You simply need to substitute values for L, D, V, and f into the Darcy Weisbach equation [hL= f(L/D)(V2/2g) ].  The Darcy Weisbach equation is a dimensionally consistent equation, so any consistent set of units can be used.  For U.S. units, hL, L, and D are typically in ft, V is in ft/sec, and g is 32.2 ft/sec2.  For S.I. units, hL, L and D are typically in m, V is in m/s, and g is 9.81 m/s2.  If volumetric flow rate, Q, is known rather than average velocity, V, then V can be calculated from:

Frictional pressure drop calculation from frictional head loss is done through the equation:

## A Spreadsheet Screenshot for Pipe Flow-Friction Factor Calculations with Excel

The Excel spreadsheet screenshot below shows a spreadsheet for pipe flow-friction factor calculations with excel that is available as part of the “Pipe Flow-Friction Factor Calculation Package,”  at our spreadsheet store in either U.S. or S.I. units at a very low cost (only \$16.95).  This spreadsheet package has three worksheets: one to calculate frictional head loss and pressure drop for known pipe diameter, length & material and flow rate; one to serve as a pipe flow rate calculator for known head loss/pressure drop, and pipe diameter, length & material; and one to calculate required pipe diameter for known head loss/pressure drop, flow rate, and pipe length & material.

References

1.  Munson, B. R., Young, D. F., & Okiishi, T. H., Fundamentals of Fluid Mechanics, 4th Ed., New York: John Wiley and Sons, Inc, 2002.

2. Darcy Weisbach equation history – http://biosystems.okstate.edu/darcy/DarcyWeisbach/Darcy-WeisbachHistory.htm

3. Source for pipe roughness values – http://www.efunda.com/formulae/fluids/roughness.cfm

4. Bengtson, H.H., Pipe Flow/Friction Factor Calculations with Excel, and online continuing education course for Professional Engineers.

5. Bengtson, Harlan H., “Pipe Flow Friction Factor Calculations with Spreadsheets,” available as an Amazon Kindle e-book and as a paperback.

# Calculate Water Flow Rate for Pipe Sizes with Excel Spreadsheets

## Where to Find Excel Spreadsheets to Calculate Water Flow Rate for Pipe Sizes

For Excel spreadsheets to calculate water flow rate for pipe sizes using the Hazen Williams equation, click here to visit our spreadsheet store.  Read on for information about the Hazen Williams equation and its use to calculate water flow rate for pipe sizes.

Excel spreadsheets are very convenient to calculate water flow rate for pipe sizes with the Hazen Williams equation.  Both U.S. and S.I. units will be used in the Hazen Williams spreadsheets and calculations discussed in this article.

## Hazen Williams Equation Limitations

The Hazen Williams equation is intended for turbulent water flow rate in pipes at normal ambient temperatures.  The turbulent flow requirement isn’t normally a problem, because most practical transport of water in pipes is turbulent flow.  The Hazen Williams formula works best for water temperature that isn’t too far above or below 60oF.  For calculation of flow rates for pipes with a fluid other than water or for water at a temperature that is far above or far below 60oF, the Darcy Weisbach equation is an alternative to the Hazen Williams equation.  For more information about this alternative, see the post, “Friction Factor/Pipe Flow Calculations with Excel Spreadsheets.”

## Forms of the Hazen Williams Equation for Water Flow Rate for Pipe Sizes

The Hazen Williams equation is sometimes expressed as an equation for velocity in the pipe and sometimes as an equation for pipe flow rate.  It also can be expressed in terms of the pipe head loss or the frictional pressure drop.  Finally, the Hazen Williams equation can be written for U.S. or S.I. units.

As an equation for Velocity, the traditional form of the Hazen Williams equation is:

in U.S. units: V = 1.318 C R0.633S0.54, where:

• V is the water flow velocity, ft/sec
• C is the Hazen Williams coefficient, dimensionless (depends on pipe material and age)
• R is the hydraulic radius, ft (R = cross-sectional area of flow/wetted perimeter)
• S is the slope of the energy grade line, dimensionless (S = head loss/pipe length = hL/L)

in S.I. units:V = 0.85 C R0.633S0.54, where the parameters are as defined above with V in m/s and R in meters.

As an equation for water flow rate for pipe that is circular, the hydraulic radius is R = A/P = (πD2/4)/(πD)  = D/4 and  Q = VA = V(πD2/4).  Substituting these equations into those for velocity give the following for the Hazen Williams equation:

in U.S. units: Q = 193.7 C D2.63S0.54, where:

• Q is the water flow rate in the pipe, gal/min (gpm)
• D is the pipe diameter, ft
• C and S are the same as defined above

in S.I. units: Q = 0.278 C D2.63S0.54, where the parameters are as defined above with Q in m3/s and D in meters.

In terms of frictional pressure drop, ΔP instead of frictional head loss, hL, the Hazen Williams equation is:

in U.S. units: Q = 0.442 C D2.63(ΔP/L)0.54, where

• Q is the water flow rate in the pipe, gpm,
• D is the pipe diameter, inches
• L is the pipe length, ft
• ΔP is the pressure difference across pipe length L, psi

In S.I. units: Q = (3.763 x 10-6) C D2.63(ΔP/L)0.54, where

• Q is the water flow rate in the pipe, m3/hr,
• D is the pipe diameter, mm
• L is the pipe length, m
• ΔP is the pressure difference across pipe length L,  kN/m2

## The Hazen Williams Coefficient – C – to Calculate Water Flow Rate for Pipe Sizes

The Hazen Williams equation can be used to calculate water flow rates for pipe sizes, only if values of the Hazen Williams coefficient, C, can be obtained for the pipe materials in use. Values of C can be found on internet sites and in handbooks & textbooks. The table at the left shows C values for some commonly used pipe materials.

Source: Toro Ag Irrigation

## A Table of Values of Water Flow Rate for Pipe Sizes and Lengths

The tables below were prepared using the equations: Q = 0.442 C D2.63(ΔP/L)0.54(U.S.) and  Q = 0.278 C D2.63(ΔP/L)0.54(S.I.) with units as given above, to calculate the water flow rates for PVC pipe with diameters from 1/2 inch to 6 inches (1 mm to 30 mm) and length from 5 ft to 100 ft (12 m to 150 m), all for a pressure difference of 20 psi (140 kn/m2) across the particular length of pipe. The Hazen Williams coefficient was taken to be 150 per the table in the previous section.

## Excel Spreadsheets to Calculate Water Flow Rate for Pipe Sizes

The table shown above can be calculated with an Excel spreadsheet like the one shown below.  It has Excel formulas entered to calculate water flow rates for different pipe sizes using the Hazen Williams equation.  This spreadsheet allows for entering the Hazen Williams coefficient for the proper pipe material, the pressure drop, and the pipe diameter(s) and length(s) of interest.  The Excel formulas then calculate water flow rates for the entered pipe sizes and lengths.  The spreadsheet shown below uses S.I. units.  This spreadsheet and a similar one using U.S. units is available from our spreadsheet store.  Those spreadsheets are also set up to calculate pipe diameter, length, or pressure drop if the other parameters are known.