Pipe Flow Rate Orifice Meter Spreadsheets

This includes the U.S. versions of both of the gas flow spreadsheet workbooks described below, one uses ISO 5167 equations for large bore pipes (2 inch to 40 inch diameter) and the other uses ASME equations for small bore pipes (1/2 to 1 1/2 inch diameter).

This includes the S.I. versions of both of the gas flow spreadsheet workbooks described below, one uses ISO 5167 equations for large bore pipes (50 mm to 1000 mm diameter) and the other uses ASME equations for small bore pipes (12 to 40 mm diameter).

This includes the U.S. versions of both of the liquid flow spreadsheet workbooks described below, one uses ISO 5167 equations for large bore pipes (2 inch to 40 inch diameter) and the other uses ASME equations for small bore pipes (1/2 to 1 1/2 inch diameter).

This includes the S.I. versions of both of the liquid flow spreadsheet workbooks described below, one uses ISO 5167 equations for large bore pipes (50 mm to 1000 mm diameter) and the other uses ASME equations for small bore pipes (12 to 40 mm diameter).

This Excel spreadsheet package includes the U.S. versions of the gas flow and liquid flow spreadsheet workbooks as described below for flow through large bore pipes (2 inch to 40 inch diameter).  ISO 5167 - 1: 2003 equations are used for calculation of the orifice coefficient.

This Excel spreadsheet package includes the S.I. versions of the gas flow and liquid flow spreadsheet workbooks as described below for flow through large bore pipes (50 mm to 1000 diameter).  ISO 5167 - 1: 2003 equations are used for calculation of the orifice coefficient.

This Excel spreadsheet package includes the U.S. versions of the gas flow and liquid flow spreadsheet workbooks as described below for flow through small bore pipes (1/2 to 1 1/2 inch diameter).  ASME MFC-14M-2001 equations are used for calculation of the orifice coefficient.

This Excel spreadsheet package includes the S.I. versions of the gas flow and liquid flow spreadsheet workbooks as described below for flow through small bore pipes (12 to 40 mm diameter).  ASME MFC-14M-2001 equations are used for calculation of the orifice coefficient.

This collection of Excel spreadsheet workbooks includes the U.S. version of all the orifice meter spreadsheets described in this section, including those for gas flow & liquid flow and for small bore & large bore pipes.

This collection of Excel spreadsheet workbooks includes the S.I. version of all the orifice meter spreadsheets described in this section, including those for gas flow & liquid flow and for small bore & large bore pipes.

This downloadable Excel spreadsheet package uses ISO 5167-2:2003 in three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for gas flow through an orifice meter.  These three spreadsheets use ISO 5167-2:2003 to calculate the orifice coefficient and the expansion coefficient as part of the calculation. The pipe diameter may range from 2 inches to 40 inches.  (The orifice meter must have one of the three standard ISO 5167 pressure tap configurations).   Calculations are made with U.S. units.

This downloadable Excel spreadsheet package uses ISO 5167-2:2003 in three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for gas flow through an orifice meter.  These three spreadsheets use ISO 5167-2:2003 to calculate the orifice coefficient and the expansion coefficient as part of the calculation. The pipe diameter may range from 50 mm to 1000 mm.  (The orifice meter must have one of the three standard ISO 5167 pressure tap configurations).   Calculations are made with S.I. units.

 This downloadable Excel spreadsheet package uses ISO 5167-2:2003 equations in three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for liquid flow through an orifice meter.  These three spreadsheets use ISO 5167-2:2003 to calculate the orifice coefficient as part of the calculation. The pipe diameter may range from 2 inches to 40 inches.  (The orifice meter must have one of the three standard ISO 5167 pressure tap configurations).   Calculations are made with U.S. units.

This downloadable Excel spreadsheet package uses ISO 5167-2:2003 equations in three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for liquid flow through an orifice meter.  These three spreadsheets use ISO 5167-2:2003 to calculate the orifice coefficient as part of the calculation. The pipe diameter may range from 50 mm to 1000 mm.  (The orifice meter must have one of the three standard ISO 5167 pressure tap configurations).   Calculations are made with S.I. units.

 This downloadable Excel spreadsheet package contains three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for gas flow through an orifice meter for small bore pipes.  These three spreadsheets use ASME MFC-14M-2001 equations to calculate the orifice coefficient and the expansion coefficient. The pipe diameter may range from 1/2 inches to 1 1/2 inches.  (The orifice meter must have corner taps or flange taps).   Calculations are made with U.S. units.

 This downloadable Excel spreadsheet package contains three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for gas flow through an orifice meter for small bore pipes.  These three spreadsheets use ASME MFC-14M-2001 equations to calculate the orifice coefficient and the expansion coefficient. The pipe diameter may range from 12 mm to 40 mm.  (The orifice meter must have corner taps or flange taps).   Calculations are made with S.I. units.

 This downloadable Excel spreadsheet package contains three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for liquid flow through an orifice meter for small bore pipes.  These three spreadsheets use ASME MFC-14M-2001 equations to calculate the orifice coefficient. The pipe diameter may range from 1/2 inches to 1 1/2 inches.  (The orifice meter must have corner taps or flange taps).   Calculations are made with U.S. units.

 This downloadable Excel spreadsheet package contains three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for liquid flow through an orifice meter for small bore pipes.  These three spreadsheets use ASME MFC-14M-2001 equations to calculate the orifice coefficient. The pipe diameter may range from 12 mm to 40 mm.  (The orifice meter must have corner taps or flange taps).   Calculations are made with S.I. units.

This Excel spreadsheet package has Excel templates for calculation of i) orifice, flow nozzle or venturi flow rate, for measured pressure difference across the meter and known discharge coefficient, C;  ii) density of a gas of known molecular weight, temperature, and pressure.  Calculations are done with S.I. units.

The screenshot at the right shows part of the first spreadsheet in this package.

 This Excel spreadsheet package has Excel templates for calculation of i) orifice, flow nozzle or venturi flow rate, for measured pressure difference across the meter and known discharge coefficient, C;  ii) density of a gas of known molecular weight, temperature, and pressure. Calculations are done with U.S. units.