Free engineering calculators and unit convertersceo@instrumentationblog.in
Flow and Control Valves · Free Excel Calculator

Control Valve Sizing Calculator (Gas and Vapour)

Size a control valve for gas or vapour at three flow cases. The workbook calculates inlet density, pressure drop ratio, expansion factor Y, choked flow, Kv and Cv, and compares them with the selected valve.

Excel (.xlsx)Worked exampleWorks offlineFree, no sign up

Download

  • Calculator sheet with a worked example
  • How to Use sheet with steps
  • 25 built in formulas, no macros
  • Yellow input cells, grey results
  • Calculation sign off block
  • Excel, Google Sheets and LibreOffice

Worked Example

These are the results of the example already filled in the workbook. Replace the yellow cells with your own data.

Molecular weight (kg/kmol)18
Specific heat ratio γ1.3
Compressibility Z0.98
Pressure drop ratio factor xT0.72
Rated Cv of selected valve46
Selected valveGlobe, 2", equal %
Fγ (calculated)0.929
Choked x = Fγ × xT0.669

Sizing cases (pressures in bar a)

CaseMass flow W (kg/h)Inlet P1Outlet P2T1 (°C)ρ1 (kg/m³)x = ΔP ÷ P1Sizing xYRequired KvRequired CvCv ratio / regime
Minimum40010.008.50407.050.1500.1500.9254.95.60.12 OK
Normal1,00010.008.00407.050.2000.2000.90010.812.50.27 OK
Maximum1,5009.507.00406.700.2630.2630.86915.517.90.39 OK
Cv ratio at maximum flow (target ≤ 0.85):OK  ·  Cv ratio at minimum flow (target ≥ 0.1):OK
Advertisement

About this Calculator

Gas valves are sized differently from liquid valves because the gas expands through the valve and the flow chokes at a pressure drop ratio set by xT. This workbook applies the IEC 60534 compressible flow equations at three operating cases at once, the same method as the online gas valve sizing calculator.

Basis: IEC 60534-2-1 compressible flow equations with mass flow: Kv = W ÷ (27.3 × Y × √(x × P1 × ρ1)), Fγ = γ ÷ 1.4, choked at x = Fγ × xT (pipe geometry factor FP taken as 1).

How to use

  1. Enter gas molecular weight, specific heat ratio and compressibility at inlet conditions.
  2. Enter xT from the valve manufacturer (globe valves about 0.7, ball and butterfly lower).
  3. Fill mass flow, inlet and outlet pressure (absolute) and temperature for the three cases.
  4. Read Y, Kv and Cv. CHOKED means the outlet pressure no longer affects flow.
  5. Enter the rated Cv of your valve and check the Cv ratios.

Formulas used

  • ρ1 = P1 × M ÷ (Z × R × T1).
  • x = (P1 − P2) ÷ P1; sizing x = smaller of x and Fγ × xT.
  • Y = 1 − x ÷ (3 Fγ xT).
  • Kv = W ÷ (27.3 Y √(x P1 ρ1)); Cv = 1.156 Kv.

Related tools

Advertisement

Frequently Asked Questions

What is the expansion factor Y?

A correction for the change in gas density from the inlet to the vena contracta. It falls from 1 at small pressure drops to 2/3 at choked flow.

What is xT?

The pressure drop ratio factor of the valve at choked flow, given by the manufacturer; it depends on valve style and trim.

Why use mass flow?

Mass flow avoids confusion between standard and actual volume units, which is a common source of gas sizing errors.

You May Also Like

Learn more on the blog

Control valve flow coefficient (Cv and Kv)

A practical guide on instrumentationblog.in that explains the engineering behind this workbook.

Read Full Article

More Excel Calculation Tools