Excel workbook (.xlsx)

Loop Check & Commissioning Pack – Excel Template (AI / AO Control Valve / DI / DO Loop Sheets, Punch List, Progress Dashboard)

Printable loop check sheets for transmitters, control valves, switches and solenoids, plus a punch list and a commissioning dashboard that shows % complete per area and system. No macros.

Description

Stop rebuilding loop sheets for every project. This Excel pack gives you print-ready loop check sheets for the four loop types you test on every job, plus the tracking you need to report progress to the client: a loop register, a punch list with A / B / C priorities and a dashboard with % complete per area and per system.

Built by an independent instrumentation engineer who commissions HART transmitters, control valves and SIS loops in the field.

What it does for you

  • Analog input (4-20 mA / HART): 5-point loop test from transmitter to DCS. Expected mA and expected DCS value are calculated, with linear or square-root (DCS) scaling and an optional separate DCS range. Errors in % of span and PASS / FAIL per point.
  • Alarm set points converted back from DCS units into the transmitter input you need to apply, linear or square-root.
  • NAMUR NE 43 failure-signal checks (≤ 3.6 mA / ≥ 21 mA).
  • Analog output / control valve: stroke test at 0-25-50-75-100 % up and down, mA at the positioner, travel deviation, DCS position feedback, hysteresis, opening and closing stroke time against the limit, fail-safe action and limit switches. Handles 4 mA = closed or 4 mA = open.
  • Digital input / switch: as-found and as-left trip point and reset point, with deviation and deadband PASS / FAIL. Functional test of the DCS state, including wire-break and short-circuit detection for line-monitored (NAMUR) inputs.
  • Digital output / solenoid: coil resistance check (DC coils, V² / P), coil voltage when energised, functional test, response time and safe state on loss of power.
  • Overall result on every sheet: PASS, FAIL, or INCOMPLETE while a check is still empty.
  • Loop register (500 rows): status is calculated as Complete, Tested, Retest, Late or Not started. Open punch items are counted per loop.
  • Punch list (500 rows): category A / B / C, status, target date, days open and an OVERDUE flag, with counters at the top.
  • Commissioning dashboard: loops tested and complete, % per area, per system and per loop type, with data bars and open punch items A / B / C.
  • Hard to break: formulas are protected (no password), and there are dropdowns everywhere. Frozen headers, filters and print areas are set (A4).

What's included

  • Loop_Check_and_Commissioning_Pack.xlsx with:

- Instructions - AI Loop Check, AO Valve Loop Check, DI Switch Loop Check, DO Solenoid Loop Check: blank sheets, ready to use - EXAMPLE AI / AO Valve / DI Switch / DO Solenoid: fully filled-in examples (DP flow transmitter with square-root, globe control valve, NAMUR level switch, SIS solenoid) - Loop Register, Punch List, Dashboard: blank, plus EXAMPLE versions with a 30-loop, 15-punch-item sample project - Lists: editable dropdowns (areas, systems, signal types, punch status …)

  • Example_Loop_Check_Pack_PREVIEW.pdf: the example sheets as printed.

Who it's for

  • Instrument and E&I commissioning engineers and technicians
  • E&I contractors and system integrators doing loop checks for clients
  • Site and project engineers who need to report commissioning progress
  • Maintenance teams re-commissioning loops after a turnaround

Compatibility

  • Microsoft Excel 2016, 2019, 2021 and Microsoft 365 (Windows and Mac)
  • LibreOffice Calc 7+ (free)
  • Google Sheets works for data entry, but sheet protection is not imported.
  • No macros, no add-ins, no subscription.

Licence

Single user / single company. Use and edit it for your own projects and your customers. Reselling or redistributing the template is not allowed.

*This template supports your commissioning records. It does not replace your project procedures, device manuals, hazardous-area or functional-safety requirements, or the judgement of a competent person.*

---

Buy on Gumroad

More in Excel templates