Excel workbook (.xlsx)
Instrument Engineer's Calculator Toolkit – Excel (Control Valve Cv / Kv Sizing, 4-20 mA, Square-Root Flow, Tank Volume)
Four everyday instrumentation calculators in one Excel file: liquid control valve sizing with a choked-flow check (simplified IEC 60534-2-1), 4-20 mA ↔ engineering units with NAMUR NE 43 status, square-root DP flow and tank level-to-volume with strapping tables. No macros.

Description
The calculations you do every week, done right and documented. Each sheet is a printable A4 calculation with inputs in light blue, results in bold and a clear statement of the method.
Built by an independent instrumentation engineer for field and project work.
Calculators
- Control valve sizing – liquid (Cv / Kv): units of your choice (m3/h, l/min, l/s, US gpm; bar, kPa, MPa, psi; gauge or absolute). Calculates FF = 0.96 − 0.28 √(Pv / Pc), choked ΔP = FL² (P1 − FF·Pv), the flow regime (non-choked / CHOKED / FLASHING), required Kv and Cv, % of rated Cv and the estimated travel for linear or equal-percentage trim.
- 4-20 mA ↔ engineering units: PV → mA, mA → PV, % → mA. Includes 1-5 V across 250 Ω and NAMUR NE 43 status (valid 3.8–20.5 mA, failure ≤ 3.6 / ≥ 21 mA), plus a quick table.
- Square-root flow: DP → flow, flow → DP, mA of a linear DP transmitter → flow, with a low-flow cut-off and a % flow vs % DP table.
- Tank level ↔ volume: vertical or horizontal cylinders with flat, 2:1 ellipsoidal, hemispherical or custom-depth heads (exact geometry). Gives volume, % volume, ullage, mass and a 21-point strapping table.
Verified
Every EXAMPLE sheet has a reference check block. The valve examples reproduce the liquid sizing examples in IEC 60534-2-1 (non-choked: Kv ≈ 165 m3/h; choked: Kv ≈ 238 m3/h). The other calculators are checked against hand calculations.
What's included
Instrument_Engineers_Calculator_Toolkit.xlsx: Instructions, 4 blank calculators, 5 EXAMPLE sheets with reference checks, Lists (units, typical FL values)Example_Calculator_Toolkit_PREVIEW.pdf
Compatibility
Excel 2016 / 2019 / 2021 / 365 (Windows / Mac), LibreOffice Calc 7+. No macros. Protected formulas (no password).
Limitations (stated in the file)
Liquid only, turbulent flow (FR = 1), valve = pipe size (FP = 1). Flashing is flagged but not sized. No gas / steam sizing, no noise or cavitation index. For estimates and checks; final valve sizing should come from the manufacturer.
Licence
Single user / single company. Reselling or redistributing the template is not allowed.
---
More in Excel templates
- Instrument Calibration Certificate & Log – Excel Template (4-20 mA / HART, As-Found / As-Left)
- Loop Check & Commissioning Pack – Excel Template (AI / AO Control Valve / DI / DO Loop Sheets, Punch List, Progress Dashboard)
- Instrument Index & I/O List – Excel Template (ISA Tag List, Tag Validation, I/O Count & Spare Capacity)