Excel workbook and PDF
Control Valve Toolkit: IEC 60534 Sizing, Test Records & Field Guide (Excel + PDF)
Size control valves for liquid, gas and steam to IEC 60534-2-1, check the actuator, and record stroke tests, PST/FST and overhauls in one macro-free workbook. Comes with a 14-page vendor-neutral field guide.

Description
One file for the whole life of a control valve: size it, check the actuator, test it, maintain it and track it. The workbook does the IEC 60534-2-1 maths and keeps your field records consistent. The PDF field guide explains what the numbers mean on a real valve.
Written by an independent industrial instrumentation engineer for people who specify, commission and maintain control valves.
What it does for you
- IEC 60534-2-1 sizing for liquid, gas/vapour and steam, with min / normal / max cases side by side:
- Required Kv and Cv - Choked-flow check: FL and FF for liquids; xT, Fγ and Y for gases - Piping geometry factor Fp for reducers - Valve Reynolds number check - Estimated % opening for linear and equal-percentage trims, with a rangeability input - Cavitation indicator for liquids, using xFz
- Steam properties built in. IAPWS-IF97 saturation temperature and superheated density are calculated in the sheet, so you don't need steam tables.
- SI and US units. Choose bar/kPa/psi, m³/h, kg/h, lb/h, gpm, Nm³/h, scfh, °C/°F and more from dropdowns. Conversions happen automatically.
- Actuator force and spring-range check. For spring-diaphragm actuators (air-to-open or air-to-close): seat load, closing margin, and whether the supply can stroke the valve.
- Stroke / calibration test record. 0-25-50-75-100 % up and down, as-found / as-left:
- deviation in % - hysteresis and deadband - PASS / FAIL against your tolerance - stroke times
- PST / FST log for on/off and ESD valves:
- next due date and days left - status: OK / Due soon / Overdue / FAILED – action - superseded tests are ignored automatically
- Maintenance and overhaul record: packing, trim, parts replaced, and a seat leakage test:
- allowable leakage calculator for IEC 60534-4 / ANSI/FCI 70-2 classes II to VI - includes the class VI bubble table
- Valve register. 250 rows, with a combined maintenance flag for overdue stroke tests and overhauls.
- Validated. The calculations were checked against the published IEC 60534-2-1 worked examples and against an independent calculation. A Validation sheet shows the results (27 / 27 checks pass).
- Hard to break. Formula cells are protected without a password, input cells are shaded light blue, and dropdowns cover units, fluids, characteristics and results.
- Print-ready. Every sheet has a defined A4 print area (the register prints on A3 landscape).
What's included
Control_Valve_Toolkit.xlsx:
- an Instructions sheet - a filled example (clearly marked EXAMPLE) and a blank copy for each tool: Liquid, Gas and Steam Sizing; Actuator Check; Stroke Test; PST-FST Log; Maintenance; Valve Register - a Validation sheet with four check sheets - a Fluid Data sheet with typical FL / xT / Fd values
Control_Valve_Field_Guide.pdf: 14 pages, A4. It covers:
- the control valve assembly - valve types and selection - flow characteristics (inherent and installed) - sizing in practice - cavitation, flashing and noise - fail-safe positions and actuator action - vendor-neutral positioner setup and autotune - diagnostics and valve signatures - stroke testing, PST and FST - a troubleshooting table (hunting, sticking, not closing, seat leakage, slow stroke and more) - a seat leakage classes summary
Control_Valve_Toolkit_Examples_PREVIEW.pdf: the printed example sheets.
Who it's for
- Instrument and E&I technicians who commission, test and overhaul control valves
- Process and instrumentation engineers who need a quick, transparent sizing check before or alongside vendor software
- Maintenance planners and reliability engineers who track stroke tests, PST/FST and overhauls
- Small valve service companies and commissioning contractors
- Students and trainees learning control valves
Compatibility
- Microsoft Excel 2016, 2019, 2021 and Microsoft 365 (Windows and Mac)
- LibreOffice Calc 7+ (free)
- Google Sheets: the calculations work, but sheet protection is not imported
- No macros, no add-ins, no subscription. It is a plain .xlsx file and a PDF.
Licence
Single user or single company. You can use and edit it for your own work and for your customers. You may not resell or redistribute the files.
*The sizing results are for preliminary sizing and for checking. Always confirm the final valve selection, noise and actuator sizing with the valve manufacturer's data and software. The guide is general and vendor-neutral. Always follow the manufacturer's instructions and your site procedures.*
---
More in Bundles
- Instrumentation Contractor Toolkit – 10 Excel Templates for Calibration, Commissioning, Ex Inspection, Maintenance & SIL Proof Testing
- Instrument Technician Field Reference Pack – 7 PDF Guides & Checklists (HART, 4-20 mA, Temperature, FDT/DTM, Commissioning, Pressure, Valves)
- Instrumentation Contractor Toolkit – 10 Excel Templates for Calibration, Commissioning, Ex Inspection, Maintenance & SIL Proof Testing