Orifice and Venturi Meter Calculations with Excel Spreadsheet Formulas Excel spreadsheet formulas can be conveniently used to make calculation for differential pressure flow meters, like an orifice flow meter, a venturi meter, or a flow nozzle meter. Dio della mia lode pdf to docs. The following sections in this article present three Excel templates for such calculations. The first Excel template is for calculating the flow rate, based on a measured pressure difference and information about the meter, the fluid, and the pipeline. In case the flowing fluid is a gas, the second Excel template allows calculation of the gas density from its molecular weight and values for the gas temperature and pressure, using the Ideal Gas Law.
Orifice plate flow rate calculator. Coefficient used for compressible flow calculation C - coefficient of discharge Coefficient used for orifice plate based on ISO 5167 R eD - upstream Reynolds number Reynolds number calculated in front of the orifice K - resistance coefficient. Calculate The information, including any recommendations, set forth at this website is offered free of charge and is designed for a variety of audiences. Certain parts of the information are intended for use by persons having technical skill.
If the flow meter is an orifice meter with one of the, then the third Excel template can be used to calculate a value for the orifice discharge coefficient. Calculation of Flow Rate from Orifice, Venturi or Flow Nozzle Meter Data.
Function of both temperature and pressure, so a means of determining the density of the gas at the pipeline temperature and pressure is needed. The ideal gas law, in the form ρ = (MW)P/RT, can be used for this purpose. See the article, ' for more details. The image at the left show the Excel spreadsheet formulas to calculate gas density for specified gas molecular weight, temperature, and gage pressure. Note the the value of the Ideal Gas Law constant, R, for the units used in this Excel template is 345.25 psia-ft 3/slugmole- oR.
The image at the right shows an example set of calculations using the Excel formulas for air (MW = 29), temperature = 80 oF, and pressure = 10 psig.. Calculation of Orifice Meter Coefficient Using ISO 5167. Terms of the pressure tap locations, L 1 and L 2; the diameter ratio, β; the pipe diameter, D 1; and the pipe Reynolds number, Re. See the article, ',' for more details about ISO 5167, the standard pressure tap configurations, and the following equation for calculating the orifice coefficient in terms of the diameter ratio, β, the pipe Reynolds number, Re, the pipe diameter, D, and pressure tap location parameters, L 1 and L 2: C = 0.5959 + 0.0312 β 2.1 – 0.1840 β 8 + 0.0029 β 2.5(10 6/Re) 0.75 + 0.0900(L 1/D)[β 4/(1 – β 4)] – 0.0337(L 2/D)β 3 The Excel formulas for calculation of the orifice coefficient are shown in the image at the left. The image at the right shows an example set of calculations using this Excel template. The calculations in the example and in the downloadable Excel templates are for 'flange taps,' which have L 1 = L 2 = 1'.
See the the article referenced above for more details on other pressure tap configurations. Note that this is an iterative calculation. The Reynolds number is needed to calculate the orifice coefficient, C, but the velocity in the pipe (needed for the Reynolds number) can’t be determined until C is known.
The iterative approach that works well with this Excel template is to initially assume a value for the Reynolds number. A value of Re = 10 5 is typically a good starting point.
With the assumed value for Re and values for the other input parameters shown, the orifice coefficient can be calculated and then Q and V can be calculated. The calculated value of pipe velocity, V, is then used to calculate the Reynolds number (Re = D 1Vρ/μ). If the calculated value is different from the assumed value for Re, then use the calculated Re as the new assumed value and repeat the calculation. This procedure converges quite rapidly. Usually one or two iterations is all that is needed..
I have a valid serial number copy of Adobe CS6 Master. Actinver windows xp en mode sans echec crackers. Get and download free Mac Adobe Illustrator CC 2014 for OS X full crack/serial. FILTERiT4 4.6.5 CS6. Logged into Adobe Illustrator. Just install the software at trial version then use.
When is this calculator relevant? The calculator is suitable for liquids and perfect gases, a subsonic flow of single phase fluid. It is not applicable for pulsating flow. The pipeline should be circular. The calculator is not applicable for rectangle pipes. When is this calculator not relevant?
This calculator is not suitable for multiphase fluids, like a flow of liquids that contain solid particles or flow of liquids that contain undissolved gases. Also, it is not suitable for gases that are not ideal, i.e., gases that don't relate to the ideal gas law. What has to be understood to perform the calculation? To calculate flow rate, you have to enter the orifice plate throat diameter as well as pipe interior diameter, together with fluid properties - density and viscosity. For a gas as flowing fluid, instead of the density, you can enter gas constant, pressure and temperature at actual conditions. Density is then calculated using a perfect gas state equation.