### Calculate Erosional Velocity with Excel

This Excel spreadsheet helps you calculate erosional velocity in Excel.  The offshore oil industry often requires the transport of liquid, gas and solids in long distance pipelines.  This causes the pipe surface to erode, with the rate of erosion increasing with the flow velocity.

The American Petroleum Institute have guidelines (see API RP14E) for the flow velocity below which erosion damage is minimized.  This maximum flow velocity is a function of velocity and density, and given by this equation.
where ρ is the gas/liquid density at the flow temperature and pressure, C is an empirical constant, and V is the maximum recommended velocity. This equation is only valid for horizontal flow with shear stress as the limiting factor

If ρ is in lb ft−3 and V is in ft s−1, then C has units of lb0.5 ft−0.5 s−1. API RP14E recommends that C=100 lb0.5 ft−0.5 s−1 for continuous service of liquid with solids, or C=125 lb0.5 ft−0.5 s−1 for intermittent service (or values of up to 200 lb0.5 ft−0.5 s−1 if the pipelines are corrosion resistant).

However, recent studies have recommended that higher C values are used, with values of 887 for 13Cr piping for "clean gas service" (see the paper "Improved Procedures for Estimating the Erosional Rates in High Offtake Gas Wells: Applications of University of Tulsa Flow Loop Derived Correlation" for more detail).

This Excel spreadsheet implements the API RP14E equation to calculate erosional velocity.  If you enter the specific gravity of the liquid and gas components, the gas/liquid volume ratio, the the absolute temperates and pressures, and the compressibility factor, the Excel spreadsheet will calculate the mixture density for you.  Note that the spreadsheet expects all values to be in SI units, including the erosional velocity coefficient C (a conversion factor is supplied in the spreadsheet).