Excel workbook (.xlsx)

Hazardous Area (ATEX / IECEx) Ex Equipment Register & Inspection Checklist – Excel Template (IEC 60079-17)

Ex register with automatic EPL, gas / dust group and temperature-class checks, inspection due dates from a defect log, and a printable Detailed / Close / Visual checklist based on IEC 60079-17. No macros.

Description

Keep your Ex inventory and inspection programme in one auditable workbook.

What it does

  • Ex register (500 items): zone → required EPL (0/1/2 → Ga/Gb/Gc, 20/21/22 → Da/Db/Dc). Checks the equipment EPL, gas / dust group (IIC ⊇ IIB ⊇ IIA; IIIC ⊇ IIIB ⊇ IIIA) and temperature (T-class for gas, °C for dust) and gives an overall *SUITABLE / NOT SUITABLE / INCOMPLETE*. It also records the Ex marking and certificate number.
  • Due-date tracking: last inspection date and grade are taken from the log automatically. Next due = last + interval (default 36 months, per-item override). Status *OK / DUE SOON / OVERDUE / NOT INSPECTED*, with open defects counted per item.
  • Inspection log & defect list (1,000 rows): grade, type (initial / periodic / sample / after repair), result, finding, action, priority, open / closed, days open. Flags tags that are not in the register.
  • IEC 60079-17 checklist: printable, one item per sheet, with the details pulled from the register. 42 check items (equipment, installation, intrinsic safety, environment) with D / C / V applicability. Choose the grade and the *Required* column follows. Result: *PASS*, *FAIL – n defects* or *INCOMPLETE*. Includes signature block.
  • KPIs: items, not suitable, overdue, due soon and open defects.

What's included

  • Hazardous_Area_Ex_Equipment_Register_and_Inspection.xlsx

- Instructions sheet (with check logic) - Blank sheets: Ex Register, Inspection Log, Inspection Checklist - EXAMPLE versions of all three (tank farm, pump bay, analyser house, powder silo), with deliberate errors: a Gc device in Zone 1, IIA in a IIB area, T3 in a T4 area - Lists

  • Example_Ex_Register_PREVIEW.pdf

Who it's for

Ex inspectors, E&I maintenance supervisors, instrumentation contractors and plant engineers responsible for ATEX / IECEx installations (chemical, oil & gas, pharma, food / grain, wastewater).

Compatibility

Excel 2016 / 2019 / 2021 / 365 (Windows / Mac), LibreOffice Calc 7+. No macros. Formula cells are protected without a password. The file has frozen headers, filters, dropdowns and print setup.

Important

The checklist is an abridged paraphrase of IEC 60079-17 Tables 1 and 2, not a copy of the standard. Always work to the edition and tables that apply to your site. The standard, the equipment certificates (including "X" specific conditions of use) and your national ATEX rules are authoritative. Inspections must be carried out by competent persons. This template supports that work but does not replace it.

Licence

Single user / single company. Reselling or redistributing the template is not allowed.

---

Buy on Gumroad

More in Excel templates