Size a control valve for liquid, gas or steam in up to six cases: required Cv or Kv, cavitation, choking and flashing checks, percent open, valve size check against your valve table, rangeability and a noise-risk flag.
USD 39 one-time purchase

What it does
Required Cv or Kv per case
Up to six cases for liquid, gas or steam, aligned with the publicly documented IEC 60534-2-1 / ISA-75.01 method, with the piping geometry factor of reducers.
Liquid checks
Choked-flow limit, cavitation index against the valve's incipient-cavitation limit, flashing check and the viscous Reynolds-number correction.
Gas, vapour and steam
Expansion factor, choked-flow limit, pressure drop ratio against choking and outlet Mach number; steam density from IAPWS-IF97.
Percent open
Opening from a linear, equal-percentage or quick-opening inherent characteristic, checked against your upper and lower opening limits.
Valve size check
Every valve in your table judged suitable, too small, too large or larger than the line, with the smallest suitable valve named and a rangeability check.
Noise-risk flag
Low, moderate or high screening flag from the flow state, outlet velocity and pressure drop ratio, plus a design-margin what-if on the largest case.
Built for engineers
- Visible formulas — nothing hidden, so you can check every step.
- Fully referenced — methods from the standard references, checked against their published worked examples.
- Safe to share — sheets are protected against accidental edits, with an open password so you can still customise.
- Built-in input checks — clear warnings for impossible inputs and values outside typical ranges.
For engineering estimates; verify against site data. Code-based methods are aligned with the publicly documented procedure; they are not a licensed reproduction or a certification.
Preview the workbook
An illustration of the sheet layout of this workbook, not a screenshot of calculated results. Select the image to enlarge it. For questions before you buy, email [email protected].
Specification and checks
| Format | Excel workbook (.xlsx), no macros |
| Version | v1.0 |
| Works in | Excel 2010 or later, Windows and Mac |
| Units | SI, US and British, mixed freely |
| Includes | Guide tab with method and references, calculator, print-ready report |
| Checked against | An independent Python model that solves the forward flow equations by root finding (IAPWS-IF97 reference implementation for the properties): the default case, all 36 combinations of the service, characteristic, Cv/Kv and liquid-property selectors, SI, US and British unit variants with every input and result unit switched, and edge cases (blank, zero, negative, text and invalid inputs give a clear message and blank results, never an error value). |
| Free version | Try the free control valve Cv calculator |
Compatibility, licence and support
| File | Excel workbook (.xlsx), no macros, version v1.0; works in Excel 2010 or later on Windows and Mac. Sheets are protected against accidental edits, with an open password so you can customise. |
| Licence | Single user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms. |
| Updates | Updates to this major version are included; download them again from the link in your receipt. |
| Support | Email [email protected] with your order number — questions on the method, your inputs or your results are welcome. |
| Refunds | If the tool does not work as described, or has an error we cannot fix, email [email protected] with your order number within 14 days of purchase and we will refund you in full. Refunds are not offered for a change of mind once a file has been downloaded. Read the full refund policy. |
Field guide: Safety Valves, Control Valves and Flare Made Simple