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

Control Valve Sizing Calculator (Liquid)

Size a control valve for liquid service at minimum, normal and maximum flow. The workbook calculates Kv and Cv, checks for choked flow and shows how far open the selected valve will be.

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.

Specific gravity (water = 1)1
Vapour pressure Pv (bar a)0.0317
Critical pressure Pc (bar a)220.64
Liquid recovery factor FL0.9
Rated Cv of selected valve108
Selected valveGlobe, 3", equal %
FF (calculated)0.957
Rated Kv (calculated)93.4

Sizing cases (pressures in bar a)

CaseFlow Q (m³/h)Inlet P1Outlet P2ΔP (bar)Choked ΔP (bar)Sizing ΔP (bar)Required KvRequired CvCv ratio (req ÷ rated)Flow regime
Minimum20.09.006.502.507.272.5012.614.60.14OK
Normal60.08.006.201.806.461.8044.751.70.48OK
Maximum85.07.506.001.506.051.5069.480.20.74OK
Cv ratio at maximum flow (target ≤ 0.85):OK  ·  Cv ratio at minimum flow (target ≥ 0.1):OK
Advertisement

About this Calculator

Sizing a control valve from one flow point is the most common cause of valves that hunt at low flow or run wide open at high flow. This workbook sizes the valve at three operating cases at once, applies the IEC 60534 choked flow limit and compares the result with the valve you plan to buy.

Basis: IEC 60534-2-1 liquid sizing equations for turbulent, non choked and choked flow (pipe geometry factor FP taken as 1).

How to use

  1. Enter the fluid specific gravity, vapour pressure and critical pressure (water: Pc = 220.64 bar a).
  2. Enter FL from the valve manufacturer (globe valves about 0.9, ball and butterfly lower).
  3. Fill in flow and inlet and outlet pressure (absolute) for the minimum, normal and maximum cases.
  4. Read the required Kv and Cv. If a case shows CHOKED, the sizing ΔP is limited to the choked value and the valve may cavitate.
  5. Enter the rated Cv of the valve you are considering and check the Cv ratios at maximum and minimum flow.

Formulas used

  • ΔP = P1 − P2; choked ΔP = FL² × (P1 − FF × Pv).
  • Sizing ΔP = smaller of ΔP and choked ΔP.
  • Kv = Q × √(SG ÷ ΔPsizing), Cv = 1.156 × Kv.
  • Cv ratio = required Cv ÷ rated Cv; aim for about 0.1 to 0.85 across the range.

Related tools

Advertisement

Frequently Asked Questions

How do I calculate Cv for a control valve?

For liquids, Kv = Q (m³/h) × √(SG ÷ ΔP (bar)) and Cv = 1.156 × Kv, provided the flow is not choked.

What is choked flow in a control valve?

The point where increasing ΔP no longer increases flow because the liquid is vaporising at the vena contracta. The limit is FL² × (P1 − FF × Pv).

How open should a control valve be at maximum flow?

Typically 70 to 85 % open, so there is margin for control and for errors in the process data.

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