Download the instrument index
XLSX
Instrument index (Excel)
Header block, 14 columns, a status drop-down, Hold rows in amber, frozen header row, filters and a How to use sheet.
CSV
Instrument index (CSV)
The example rows as plain CSV (UTF-8), for Google Sheets or any other tool.
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
| Field | Example |
|---|---|
| Project | Example Chemical Dosing Skid (fictional) |
| Customer | Example Water Company Ltd (fictional) |
| Purchase order | PO-EX-7015 (fictional) |
| Package | Dosing skid SK-7015 (fictional) |
| P&ID(s) | PID-EX-7015-01 Rev C |
| Tag numbering rule | Customer specification PS-INS-003 section 4 (fictional) |
| Index no. | II-EX-7015 |
| Revision | B |
| Date | 2027-02-18 |
| Prepared by | Instrument engineer |
| Checked by | Lead engineer |
Example rows: twelve instruments on a dosing skid
| Tag | Service | Type | Loop | Range | Signal | Datasheet | Cal. cert. | SIL requirement | Status | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|
| PT-101 | Dosing pump discharge pressure | Pressure transmitter | P-101 | 0 to 16 bar g | 4-20 mA, HART | DS-EX-PT-101 Rev B | CAL-EX-1101 | Not specified | Calibrated | |
| PI-102 | Dosing pump discharge pressure, local | Pressure gauge | - | 0 to 25 bar g | Local | DS-EX-PI-102 Rev A | CAL-EX-1102 | Not specified | Calibrated | |
| PT-103 | Dosing pump suction pressure | Pressure transmitter | P-103 | -1 to 5 bar g | 4-20 mA, HART | DS-EX-PT-103 Rev B | Not specified | Received | Calibration booked with the other transmitters. | |
| FT-104 | Dosing flow to process | Electromagnetic flowmeter | F-104 | 0 to 500 L/h | 4-20 mA, HART | DS-EX-FT-104 Rev C | CAL-EX-1104 | Not specified | Calibrated | |
| FV-104 | Dosing flow control | Control valve with positioner | F-104 | 0 to 100 % travel | 4-20 mA | DS-EX-FV-104 Rev B | Not specified | Ordered | Stroke check planned at the FAT. | |
| LT-105 | Storage tank level | Radar level transmitter | L-105 | 0 to 2000 mm | 4-20 mA, HART | DS-EX-LT-105 Rev B | CAL-EX-1105 | Not specified | Calibrated | |
| LSHH-106 | Storage tank high-high level, stops the fill valve | Level switch | L-106 | Set point 1900 mm | Volt-free contact | DS-EX-LSHH-106 Rev B | SIL 2, per customer's safety requirements specification SRS-EX-7015 (fictional) | Hold | Vendor's certificate for the SIL requirement not yet received. Datasheet stays at Rev B until it is. | |
| LSLL-107 | Storage tank low-low level, pump dry-run protection | Level switch | L-107 | Set point 150 mm | Volt-free contact | DS-EX-LSLL-107 Rev A | Not specified | Ordered | ||
| TT-108 | Storage tank temperature | Resistance thermometer with transmitter | T-108 | 0 to 100 °C | 4-20 mA | DS-EX-TT-108 Rev A | CAL-EX-1108 | Not specified | Calibrated | |
| PDT-109 | Suction strainer differential pressure | Differential pressure transmitter | P-109 | 0 to 1 bar | 4-20 mA, HART | DS-EX-PDT-109 Rev A | Not specified | Datasheet open | Range to be confirmed against the strainer datasheet. | |
| AT-110 | pH of dosed stream | pH analyser with sensor | A-110 | 0 to 14 pH | 4-20 mA | DS-EX-AT-110 Rev B | Not specified | Datasheet approved | ||
| ZS-111 | Tank fill valve XV-111 open and closed position | Limit switch box | L-106 | Open / closed | 2 volt-free contacts | DS-EX-ZS-111 Rev A | SIL 2, per SRS-EX-7015 (same function as LSHH-106) | Hold | On 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
| Status | Use it when |
|---|---|
| Datasheet open | The tag exists on the P&ID but its datasheet is not yet approved. |
| Datasheet approved | The datasheet is approved at the revision shown, and the instrument can be ordered. |
| Ordered | The instrument is on order from the vendor named. |
| Received | The instrument has arrived and been checked against its datasheet and nameplate. |
| Calibrated | A calibration certificate for this tag or serial number is on file and its number is in the index. |
| Hold | Something 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
| Column | What to write |
|---|---|
| Tag no. | The instrument tag, exactly as it is on the P&ID. One tag per row. |
| Service description | What the instrument measures or does, and where in the process. |
| Instrument type | The kind of instrument, for example pressure transmitter, level switch or control valve. |
| P&ID no. / rev | The 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. |
| Location | Line, equipment or panel where it is mounted. |
| Range and units | Calibrated range or set point, with units. Take it from the datasheet, not from memory. |
| Signal type | Output or input signal, for example 4-20 mA, a volt-free contact or a fieldbus. Write Local for a gauge. |
| Datasheet no. / rev | The 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 / model | Manufacturer and model number, once chosen. |
| Status | Datasheet open, Datasheet approved, Ordered, Received, Calibrated or Hold (drop-down). Hold rows turn amber. |
| Remarks | Open queries, P&ID changes or anything the next reader needs. |
How to build the index
- 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.
- Walk each P&ID and add one row per tag, exactly as drawn. Include local gauges and switches, not only the transmitters.
- Add the service description, instrument type, loop number and location for each tag.
- Take the range, units and signal type from the instrument datasheet, and enter the datasheet number and revision.
- 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.
- Add the vendor and model when the instrument is chosen, and the calibration certificate number when the certificate arrives.
- 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.
- 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.
