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.xlsxwith:
- 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.*
---
More in Excel templates
- Instrument Calibration Certificate & Log – Excel Template (4-20 mA / HART, As-Found / As-Left)
- Instrument Index & I/O List – Excel Template (ISA Tag List, Tag Validation, I/O Count & Spare Capacity)
- Instrument Datasheet Templates – Excel (Pressure, DP Flow, Temperature, Level, Control Valve, On/Off Valve)