Compressible Flow in Pipe Spreadsheets

These spreadsheets recalculate fluid properties and velocity for 10 intervals down the length of the pipe.

Results for 16 different pipe sizes are displayed.

You can examine the spreadsheet to see how the calculating is done. Darcy-Weisbach equation and friction factor are calculated.

There are no macros, no VBA.

You can copy and modify these spreadsheets for your own purposes.

Flow of Natural Gas in pipe ("w.c.):

This is preloaded with natural gas (as 100% methane) data, and preloaded with scfh and "w.c. (inches water column) units:

081_Flow_of_Natural_Gas_100pc_Methane_in_pipe_inch_wc_v02.xls

11/23/13

Flow of Natural Gas in pipe (psig):

This is preloaded with natural gas (as 100% methane) data, and preloaded with scfh and psig units:

082_Flow_of_Natural_Gas_100pc_Methane_in_pipe_psig_v02.xls

11/23/13

Flow of Steam in pipe:

This is preloaded with saturated steam data, and preloaded with lbs/hr and psig units:

078_Flow_of_Steam_in_pipe_v03.xls

Flow of Vacuum in pipe:

These are for light and moderate vacuum where viscous flow dominates, not deep laboratory vacuum where molecular diffusion dominates.

Vacuum using absolute pressure (direct scales):

This is preloaded with vacuum data, and preloaded with scfm and "HgA units.

079_Flow_of_Vacuum_in_pipe_direct_scales_v03.xls

Vacuum using gauge pressure (inverse scales where larger numbers mean less absolute pressure):

This is preloaded with vacuum data, and preloaded with scfm and "HgV units.

080_Flow_of_Vacuum_in_pipe_inverse_scales_v03.xls

9/29/13, 11/17/13, 11/23/13