OdysseyGPT

Free template

Instrument index template (Excel and CSV)

For skid and package builders: one row per instrument tag, tying the P&ID to the datasheet, the loop, the vendor and the calibration certificate.

By Ademola Afolabi, Founder, New Odyssey Ltd · Last reviewed:

The short answer

An instrument index, or instrument list, is the master list of every instrument on a plant or package. This free Excel template has one row per tag: service, instrument type, P&ID and loop number, location, range and units, signal type, datasheet number and revision, calibration certificate number, any specified SIL requirement, vendor, model and status.

Key Takeaways

  • The P&ID is the source of tags. Every tag on the drawing gets a row, and no row exists without a tag on the drawing.
  • Range, units and signal come from the datasheet at the revision shown in the index.
  • Record a SIL requirement only where the customer's documents state one. The index does not assign it.
  • The example has 12 instruments on an invented dosing skid (PO-EX-7015), two of them on hold.

Download the instrument index

Both files are free under CC BY 4.0, with no form to fill in. The XLSX opens in Excel, Google Sheets, LibreOffice and Numbers. The CSV carries the table only; the header block is in the XLSX.

What an instrument index does

Instrument data is spread across the P&ID, the datasheets, the loop diagrams, the vendor's order and the calibration certificates. The instrument index is the one table that joins them by tag number. Start it as soon as the first P&ID is issued, at tender stage if the enquiry includes one, and keep it alive until the calibration certificates are filed.

  • Instrument and control engineers, who own the index and the datasheets behind it.
  • Buyers, who order from the vendor and model column.
  • Document controllers, who use it to see which datasheets and certificates are still missing from the record book.

A large project keeps this data in an engineering database. For a skid with a dozen or a few hundred tags, a spreadsheet is enough. If the customer specifies its own index format or tag numbering rule, use that. See also instrumentation manufacturers.

Header block

Header block fields, with the invented example values
FieldExample
ProjectExample Chemical Dosing Skid (fictional)
CustomerExample Water Company Ltd (fictional)
Purchase orderPO-EX-7015 (fictional)
PackageDosing skid SK-7015 (fictional)
P&ID(s)PID-EX-7015-01 Rev C
Tag numbering ruleCustomer specification PS-INS-003 section 4 (fictional)
Index no.II-EX-7015
RevisionB
Date2027-02-18
Prepared byInstrument engineer
Checked byLead engineer

Example rows: twelve instruments on a dosing skid

Invented example rows for index II-EX-7015 (some columns omitted)
TagServiceTypeLoopRangeSignalDatasheetCal. cert.SIL requirementStatusRemarks
PT-101Dosing pump discharge pressurePressure transmitterP-1010 to 16 bar g4-20 mA, HARTDS-EX-PT-101 Rev BCAL-EX-1101Not specifiedCalibrated
PI-102Dosing pump discharge pressure, localPressure gauge-0 to 25 bar gLocalDS-EX-PI-102 Rev ACAL-EX-1102Not specifiedCalibrated
PT-103Dosing pump suction pressurePressure transmitterP-103-1 to 5 bar g4-20 mA, HARTDS-EX-PT-103 Rev BNot specifiedReceivedCalibration booked with the other transmitters.
FT-104Dosing flow to processElectromagnetic flowmeterF-1040 to 500 L/h4-20 mA, HARTDS-EX-FT-104 Rev CCAL-EX-1104Not specifiedCalibrated
FV-104Dosing flow controlControl valve with positionerF-1040 to 100 % travel4-20 mADS-EX-FV-104 Rev BNot specifiedOrderedStroke check planned at the FAT.
LT-105Storage tank levelRadar level transmitterL-1050 to 2000 mm4-20 mA, HARTDS-EX-LT-105 Rev BCAL-EX-1105Not specifiedCalibrated
LSHH-106Storage tank high-high level, stops the fill valveLevel switchL-106Set point 1900 mmVolt-free contactDS-EX-LSHH-106 Rev BSIL 2, per customer's safety requirements specification SRS-EX-7015 (fictional)HoldVendor's certificate for the SIL requirement not yet received. Datasheet stays at Rev B until it is.
LSLL-107Storage tank low-low level, pump dry-run protectionLevel switchL-107Set point 150 mmVolt-free contactDS-EX-LSLL-107 Rev ANot specifiedOrdered
TT-108Storage tank temperatureResistance thermometer with transmitterT-1080 to 100 °C4-20 mADS-EX-TT-108 Rev ACAL-EX-1108Not specifiedCalibrated
PDT-109Suction strainer differential pressureDifferential pressure transmitterP-1090 to 1 bar4-20 mA, HARTDS-EX-PDT-109 Rev ANot specifiedDatasheet openRange to be confirmed against the strainer datasheet.
AT-110pH of dosed streampH analyser with sensorA-1100 to 14 pH4-20 mADS-EX-AT-110 Rev BNot specifiedDatasheet approved
ZS-111Tank fill valve XV-111 open and closed positionLimit switch boxL-106Open / closed2 volt-free contactsDS-EX-ZS-111 Rev ASIL 2, per SRS-EX-7015 (same function as LSHH-106)HoldOn hold with LSHH-106.

The file also has columns for P&ID number, location and vendor and model. The two SIL entries are an invented customer's requirement, quoted from an invented safety requirements specification; they show where the requirement is written down, nothing more. Every example value is invented: the project, customer, bidders, purchase order, prices and every document, certificate, serial and report number do not exist. Standards are named but not quoted.

Status values

StatusUse it when
Datasheet openThe tag exists on the P&ID but its datasheet is not yet approved.
Datasheet approvedThe datasheet is approved at the revision shown, and the instrument can be ordered.
OrderedThe instrument is on order from the vendor named.
ReceivedThe instrument has arrived and been checked against its datasheet and nameplate.
CalibratedA calibration certificate for this tag or serial number is on file and its number is in the index.
HoldSomething stops the row moving on: a P&ID change, an open query or a missing certificate. Say what in Remarks.

Columns and what to write

ColumnWhat to write
Tag no.The instrument tag, exactly as it is on the P&ID. One tag per row.
Service descriptionWhat the instrument measures or does, and where in the process.
Instrument typeThe kind of instrument, for example pressure transmitter, level switch or control valve.
P&ID no. / revThe P&ID the tag is on, with its revision.
Loop no.The loop the instrument belongs to, or a dash for a local instrument with no loop.
LocationLine, equipment or panel where it is mounted.
Range and unitsCalibrated range or set point, with units. Take it from the datasheet, not from memory.
Signal typeOutput or input signal, for example 4-20 mA, a volt-free contact or a fieldbus. Write Local for a gauge.
Datasheet no. / revThe instrument datasheet number and its current revision.
Calibration certificate no.The certificate number once the instrument is calibrated. Leave blank until then.
SIL requirement (if specified)The safety integrity level the customer's documents require for the function this tag belongs to, with the document that says so. Write Not specified if none is stated. Do not assign one yourself.
Vendor / modelManufacturer and model number, once chosen.
StatusDatasheet open, Datasheet approved, Ordered, Received, Calibrated or Hold (drop-down). Hold rows turn amber.
RemarksOpen queries, P&ID changes or anything the next reader needs.

How to build the index

  1. Fill in the header block: the package, the P&ID numbers and revisions the index was built from, and the specification that sets the tag numbering rule.
  2. Walk each P&ID and add one row per tag, exactly as drawn. Include local gauges and switches, not only the transmitters.
  3. Add the service description, instrument type, loop number and location for each tag.
  4. Take the range, units and signal type from the instrument datasheet, and enter the datasheet number and revision.
  5. Fill in the SIL requirement only where the customer's documents state one, and name the document. Write Not specified otherwise. The index records the requirement; it does not determine it.
  6. Add the vendor and model when the instrument is chosen, and the calibration certificate number when the certificate arrives.
  7. Keep the status up to date. Hold rows turn amber. When a P&ID is revised, check every tag on it and raise the index revision.
  8. Before the FAT and before the record book is issued, filter for rows without a calibration certificate number and for rows on Hold.

Checking datasheets against the customer's instrument specification

The index tells you which datasheet belongs to which tag. It does not tell you whether that datasheet meets the customer's specification. In OdysseyGPT's Tender & Quotation module, Document Review reads the customer's specification package and your datasheets and lists each requirement beside what your documents say, quoting the source page. Datasheet Comparison (beta) sets a datasheet against the specification line by line. Your instrument engineer decides every status. Tools marked beta are open on request, and we onboard each team ourselves.

See how OdysseyGPT reviews a tender

Tell us how your team reviews tenders today. We can walk through an example together.

Book a call

New templates by email (optional)

Your download does not depend on this.

We use your email only for this. See our privacy policy.

Frequently asked questions

What is an instrument index?

A table listing every instrument on a plant, unit or package by tag number, with the key data and document references for each. It is the cross-reference between the P&IDs, the instrument datasheets, the loop diagrams and the calibration records.

Is an instrument index the same as an instrument list?

In everyday use, yes. Some companies call the short version a list and the version with document references an index. Use whichever name your customer's specification uses.

Should control valves and on-off valves be in the index?

Usually tagged control valves and the switches and positioners on actuated valves are included, because they belong to loops. Manual valves normally are not. Follow the customer's specification if it says what to include.

Who decides the SIL requirement in the index?

Not the index. The requirement comes from the customer's hazard study and safety requirements specification. Copy it in with the document reference, and leave the cell as Not specified where nothing is stated.

What should I do when the P&ID is revised?

Check every tag on the revised sheet against the index: added tags get a row, deleted tags are struck through or marked deleted rather than removed, and changed ranges go back to the datasheet. Then raise the index revision.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages