Excel workbook (.xlsx)

Instrument Index & I/O List – Excel Template (ISA Tag List, Tag Validation, I/O Count & Spare Capacity)

A clean, ISA-style instrument index that checks every tag as you type, plus an I/O summary with used, installed and spare channels per controller and card. No macros.

Description

One tag list. Every tag checked. This Excel template gives you a 1,000-row instrument index in the familiar ISA layout and an I/O summary that answers the question every client asks: *how much spare I/O do we have?*

Built by an independent instrumentation engineer who works with HART, DCS and SIS projects in the field.

What it does for you

  • ISA-style index: tag, service, P&ID, instrument type, range and units, signal, I/O type, controller / card / channel, junction box, cable, location, vendor, model and remarks.
  • Tag check on every row: LETTERS-NUMBER format with an optional suffix letter (PT-1001, LSHH-1102, FV-2105A). It flags missing separators, lower case, unknown letter codes (checked against an editable list of 85+ ISA codes), the wrong number of loop digits (set your own min / max) and duplicate tags.
  • Channel check: flags a controller + card + channel that is used twice.
  • I/O summary per controller: AI / AO / DI / DO used, installed and spare %, coloured against your spare target (default 20 %).
  • Card table: used and spare channels per card, status OK / Below target / OVER-ALLOCATED, and a count of tags with the wrong I/O type on a card.
  • Counts per signal type: 4-20 mA HART, NAMUR, 24 V DC, FOUNDATION Fieldbus, PROFIBUS PA and more.
  • Dropdowns for instrument type, signal, I/O type and units. Frozen headers, filters, print areas (A4 landscape) and protected formulas (no password) are all set.

What's included

  • Instrument_Index_and_IO_List.xlsx with:

- Instructions - Instrument Index and IO Summary: blank, ready to use - EXAMPLE Index and EXAMPLE IO Summary: a 44-tag sample project with three controllers (PLC, DCS, SIS). It includes deliberate errors so you can see the checks work. - Lists: editable dropdowns and ISA letter codes

  • Example_Instrument_Index_PREVIEW.pdf

Who it's for

  • Instrument and control engineers on projects and revamps
  • System integrators preparing I/O lists and cabinet I/O counts
  • E&I contractors and maintenance engineers keeping the plant's instrument index up to date
  • Students learning ISA-5.1 tagging

Compatibility

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

Licence

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

*The tag check is a format check based on common ISA-5.1 practice. It does not replace your project's tagging procedure.*

---

Buy on Gumroad

More in Excel templates