The Production of a Microsoft Excel Tool to Assist in the Teaching of the Use of Venturi Tubes to Calculate Mass Flow Rates and Their Associated Uncertainties

Abstract

This paper describes the use of venturi tubes and the calculations involved in their use; it also introduces a new spreadsheet tool developed to assist in the teaching of the subject. The tool is easy to use and allows the user to calculate liquid or gas mass flow rates. This is done by the user entering the values of required variables and choosing the applicable units of measurement from embedded drop-down lists. Non-SI units can be selected, as the tool makes the necessary conversions within hidden cells and tabs. In addition to calculating mass flow rates, the tool also calculates their associated uncertainty. The tool can be used by lecturers as part of undergraduate teaching or by practising engineers who use venturi tubes or have an interest in them.

Keywords

spreadsheets venturi tubes uncertainty teaching tool

Get full access to this article

View all access options for this article.

References

International Organization for Standardization, Measurement of Fluid Flow by Means of Pressure Differential Devices Inserted in Circular Cross-Section Conduits Running Full, ISO 5167-1:2003(E), 2nd edn (March 2003).

British Standards, Measurement of Fluid Flow in Closed Conduits, BS 1042: Section 1.1 (1992).

Bissell

C. C.

, ‘Spreadsheets in the teaching of information engineering’, Enging. Science Education J., 3(2) (April 1994), 89–96.

Antar

M. A.

Mokheimer

E. M.

, ‘Spreadsheet modelling of transient three dimensional heat conduction with various standard boundary conditions’, Int. J. Mech. Enging. Educ., 30(1) (2003), 17–34.

Antar

M. A.

Mokheimer

E. M.

, ‘On the use of spreadsheets in heat conduction analysis’, Int. J. Mech. Enging. Educ., 28(2) (2000), 113–139.

Antar

M. A.

, ‘A simplified numerical solution of unsteady heat conduction problems with an application to a short cylinder’, Int. J. Mech. Enging. Educ., 28(3) (2000), 201–212.

Tai

, ‘Integrated design optimization and analysis using a spreadsheet application’, Int. J. Mech. Enging. Educ., 27(1) (1999), 29–40.

Dye

R. C. F.

, ‘A computer-generated “pseudo-experiment” in fluid mechanics’, Int. J. Mech. Enging. Educ., 31(2) (2003), 143–149.

Campo

Chikh

, ‘Reproduction of the fin efficiency diagram for annulus fins of uniform thickness by solving systems of up to four algebraic equations’, Int. J. Mech. Enging. Educ., 34(1) (2003), 85–92.

10.

International Organization for Standardization, Guide to the Expression of Uncertainty in Measurement, ISO GUM (1993).

11.

Taylor

B. N.

Kuyatt

C. E.

, Guidelines for Evaluating and Expressing the Uncertainty of NIST Measurement Results, National Institute of Standards and Technology (NIST), Technical Note 1297 (1994).

12.

Moldover

M. R.

Trusler

J. P. M.

Edwards

T. J.

Mehl

J. B.

Davis

R. S.

, ‘Measurement of the universal gas constant using a spherical acoustic resonator’, J. Research National Bureau Standards, 93(2) (1988), 85–144.

13.

Flinn

R. A.

Trojan

P. K.

, Engineering Materials and Their Applications (Houghton Mifflin, New York, 1986).