Excel workbook (.xlsx)

Instrument Datasheet Templates – Excel (Pressure, DP Flow, Temperature, Level, Control Valve, On/Off Valve)

Six print-ready A4 datasheets for field instruments and valves, in an ISA-20 / IEC 60534-7 style layout, with the engineering checks built in: required Cv, choked flow, beta ratio, DP level range, RTD / TC tolerance and actuator torque. No macros.

Description

Specify instruments faster and catch mistakes before the purchase order. Each datasheet has a header and revision block, min / normal / max process data, and a grey "check" line that turns green OK or red CHECK – reason as you type.

Built by an independent instrumentation engineer (HART, Yokogawa and Emerson field instruments, control valves).

The six datasheets

  1. Pressure transmitter: range, span, URL and turndown. It checks that the operating pressure is inside the calibrated range and the design pressure is below the overpressure limit.
  2. DP flow (orifice + transmitter): beta ratio d / D with the ISO 5167-2 orifice limit check (0.10–0.75), and DP and % of span at min / normal / max flow (DP ∝ Q²).
  3. Temperature (RTD / TC + thermowell + transmitter): element tolerance at the normal and maximum temperature per IEC 60751 (class AA / A / B) and IEC 60584-1 (types K, N, J, T, class 1 / 2). It also checks insert length and calibrated range.
  4. Level (radar / GWR / DP): DP calibration LRV / URV from the level elevations, tap elevations and SGs, for a dry leg or a wet leg / capillary seals.
  5. Control valve: ΔP, choked ΔP = FL² (P1 − FF·Pv), choked-flow flag, required Cv at min / normal / max, % of rated Cv and estimated travel (linear or equal %).
  6. On/off valve: required actuator torque = break-out torque × safety factor, compared with the actuator output, plus SOV, limit switches and SIL fields.

What's included

  • Instrument_Datasheet_Templates.xlsx: Instructions, 6 blank datasheets, 6 EXAMPLE datasheets (red tabs) and Lists (editable dropdowns and the tolerance table)
  • Example_Instrument_Datasheets_PREVIEW.pdf: the six examples as printed

Who it's for

  • Instrument engineers writing specifications and requisitions
  • EPC and engineering firms that need a clean, consistent datasheet set
  • Plant engineers replacing instruments and valves
  • Students learning instrument specification

Compatibility

Excel 2016 / 2019 / 2021 / 365 (Windows and Mac) and LibreOffice Calc 7+. No macros. Protected formulas (no password).

Limitations (also stated in the file)

Control valve sizing is liquid only, with FP = 1 and turbulent flow. There is no gas / steam sizing and no noise or cavitation prediction, and final sizing should come from the vendor. DP level ignores vapour density. Layouts follow common practice; they are not copies of ISA / IEC forms.

Licence

Single user / single company. Reselling or redistributing the template is not allowed.

---

Buy on Gumroad

More in Excel templates