The equations implemented in the spreadsheet are sourced from ASME MFC-14M-2001 and are given below.

The notation is given below.

- C is the discharge coefficient. D
_{1}must be supplied in m. The equation differs for flange taps and corner taps, but a menu in the spreadsheet allows you to pick between the two. - D
_{1}and D_{2}are the diameter of the pipe and orifice respectively (m) - A
_{1}and A_{2}are the cross sectional areas of the pipe and orifice (m^{2}) - ΔP is the pressure drop across the orifice (Pa)
- ρ is the density of the liquid (kg m
^{-3}) - V
_{1}is the liquid velocity in the pipe(m s^{-1}) - Re
_{1}is the Reynolds Number in the pipe - β is the diameter ratio
- μ is the liquid viscosity (Pa s)
- Q is the volumetric flowrate (m
^{3}s^{-1})

The correlations for the Flange Taps and Corner Taps discharge coefficient are only valid for the following configurations.

The equations are only valid under the following conditions

- Corner Taps: 0.1 < β < 0.8
- Flange Taps: 0.15 < β < 0.7
- 25 mm < D
_{1 }< 50 mm - 6 mm < D
_{2} - Re > 1000

The Excel spreadsheet will also calculate the static pressure loss and the head loss from a distance D

_{1}upstream and 6 D

_{1}downstream of the orifice.

The spreadsheet is free, and none of the cells are hidden, locked or password protected. Please visit this website regularly for more exclusive, professionally prepared Excel spreadsheets for engineering.

Download Excel Spreadsheet to Calculate Liquid Flow from a Small Bore Orifice Meter

Download Excel Spreadsheet to Calculate Liquid Flow from a Small Bore Orifice Meter

## 0 comments:

## Post a Comment