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. 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. An orifice plate is a very powerfull and cheap flow measurement device. It has a minimal operation cost. Sometimes it is a new installation, in this case we will have all the design information, and other times it is a maintenance or verification intervention that requires to check or calculate the gas flow through an orifice plate. Orifice Plate. It depends on the orifice plate associated calculation method that either mass flow rate or the volumetric flow rate is used for calculation. It uses the Bernoulli’s principle which shows the relationship between velocity and pressure of flowing fluid. When one increase then the second one decrease. ![]() 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. 4 MB Download Podium V2 Mac with crack serial number keygen: Read more. Global Monthly Searches: I cant get the crack for the 64 bit to work so my method of using the 2. Lorimar podium v2 mac, directed by nick castle, Free Software Download V2. Su podium v2.5 crack. Su podium v2 mac crack Keyword: podium v2 11 crack. 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.. Description Orifice plate is very practical and relatively low-cost measuring device for flow rate measurement with good accuracy. By placing orifice plate in the pipe, sudden pressure drop is created. Degree of created pressure drop is directly proportional to the stream velocity and consequently, to the flow rate. That behavior and strong interaction between stream velocity and pressure drop due to local restrictions is used for flow rate measurement by orifice plate. This calculator can be used for calculating of actual flow rate through orifice plate flow meter, for measured pressure drop and can also be used for orifice plate sizing. Available calculations • Flow rate for known orifice size and pressure difference • Flow velocity in the inlet pipe • Discharge coefficient calculation • Gas expansion coefficient for compressible flow In Selection section you can select values to input.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |