Instrument index and I/O list: the two lists that run an I&E job
On an instrumentation and controls job, two spreadsheets end up driving almost everything the field does: the instrument index and the I/O list. Procurement buys off the index. The panel shop builds off the I/O list. The loop drawings, cable schedule, termination drawings, loop check sheets and calibration records all key off the tag number that shows up in both. When the two lists disagree, you find out at loop check, with a client witness standing there and the startup date on the whiteboard.
The free template above gives you both lists in one workbook, tied together by tag. You enter the tag, service and range once on the index; the I/O list looks them up, so a change to a range on the index shows up on the I/O list without anyone re-typing it.
What goes on an instrument index
One row per tagged device on the P&IDs. A good index answers the questions every trade asks about an instrument without anybody pulling a drawing:
- Tag and service — PT-1001, "Inlet separator V-100 pressure". The service description should tell a tech where the device is and what it does.
- P&ID and loop number — the sheet it lives on and the loop it belongs to. Everything in one loop (transmitter, controller, valve) shares the number.
- Instrument type and make/model — pressure transmitter, Coriolis meter, GWR level, vibrating fork switch, control valve with smart positioner.
- Calibrated range — lower and upper range value and units from the datasheet. This is the range the device is set to, not the sensor limit, and it is what gets checked at loop check.
- Signal — 4-20 mA, 4-20 mA HART, discrete 24 VDC, fieldbus. It drives the I/O card type and the cable.
- Location and area classification — where it is installed and what the area classification drawing says about that spot. The device's nameplate marking has to suit it.
- Datasheet and install detail numbers — so the pipefitter and instrument hand know which hook-up detail to build.
- Status — Specified, Purchased, Received, Installed, Terminated, Loop Checked, Commissioned. The roll-up under the table turns this into a progress number for the weekly meeting.
What goes on an I/O list
One row per signal that lands on the control system. The instrument index tells you what the device is; the I/O list tells you where its wires go and what the controller does with them.
| Column | What to enter |
|---|---|
| Tag | Exactly as it appears on the index. Description, signal and range fill in automatically. |
| I/O type | AI, AO, DI or DO. A transmitter is an AI; a control valve positioner is an AO; limit switches and level switches are DIs; solenoids and motor starts are DOs. |
| System | PLC, DCS or SIS. Safety-instrumented points usually live on separate hardware and get tracked separately. |
| Controller / rack / slot / channel | The hardware address. The sheet highlights any address used twice. |
| Alarm setpoints | LL, L, H, HH in engineering units, from the alarm and trip schedule or cause-and-effect chart. |
| Field JB and marshalling terminals | Where the pair lands in the field and in the cabinet. These should match the wire list line for line. |
Tag numbering in plain words
Most US industrial and oil & gas projects use ISA-5.1-style tag letters. You don't need the whole standard to read a tag:
- First letter = what's being measured or initiating the action. P pressure, F flow, L level, T temperature, A analysis, Z position, H hand. A second letter can modify it: PD is differential pressure.
- Following letters = what the device does. T transmit, I indicate, C control, V valve, E sensing element, S switch, Y relay / converter / solenoid.
- H and L on the end mean high and low; HH and LL are usually the trip points.
So PDIT-1030 is a differential pressure indicating transmitter on loop 1030, LSHH-1004 is a high-high level switch, and ZSO-1010 / ZSC-1010 are the open and closed position switches on valve XV-1010. Your client's engineering standard sets the exact rules — loop number format, area prefixes, and how they handle letters their older P&IDs used differently. When the P&IDs and the standard disagree, write an RFI rather than inventing a tag.
Sizing spare I/O without guessing
Every control-system spec asks for spare capacity, and the wording matters: "20% installed spare" (wired and terminated), "20% spare channels" (on cards but not wired), and "20% spare rack space" (empty slots) are three different numbers and three different prices. The I/O summary in the template counts used points by type and system, applies your spare % per I/O type, and rounds up to cards at your points-per-card. Use it to check the vendor's hardware list at submittal time, and again late in the job when the owner adds "just a couple more" tags and someone needs to know whether there's room.
Common mistakes that show up at loop check
1. Two lists, two versions of the truth
The index says 0–150 psig, the I/O list (typed separately six months ago) says 0–100 psig, and the controller was configured from the I/O list. Linking the lists by tag is the fix — change the range once.
2. Re-used tag numbers
A device gets deleted and its tag is re-used for something else. Now there are two sets of datasheets, vendor docs and cal records with the same tag. Mark deleted tags Deleted and keep the row.
3. Duplicate hardware addresses
Two points assigned to rack 1, slot 3, channel 4. It happens when two people edit the list. The template turns the duplicate red.
4. Area classification checked too late
A Division 2-marked analyzer arrives for a Division 1 location. Catch it on the index when the device is purchased and again at receiving — not when the inspector reads the nameplate. The hazardous area inspection tab in our termination & tubing test template records that check, and our hazardous area classification reference explains the Class/Division and Zone systems.
Where the lists go next
Once the index and I/O list are solid, the rest of the I&E paper follows from them: the cable termination / wire list uses the JB and marshalling terminals, the loop check sheet tests each loop against the range and setpoints, and the calibration record proves each transmitter was set to the range on the index. For the power side of the job, the panel schedule template covers the UPS and instrument power panels.
When a spreadsheet stops being enough
A single index and I/O list in Excel works well for a skid package or a small unit. Once several techs are updating status at once and QC needs signed records against each loop, the spreadsheet becomes the bottleneck. Field PM's QA/QC module tracks inspections and hold-point sign-offs from the field, and QA/QC workflows step each loop through wiring, loop check and client acceptance with e-signatures. Start a free 30-day trial, no credit card required.
Related I&E templates
- Loop check sheet + calibration record
- Termination wire list, tubing pressure test & hazardous area inspection
- Panel schedule template
- Submittal log — track instrument datasheets and vendor data
- Browse all free construction templates
