- List 6-III
- Excel
- Pressure equipment
List 6-III: building your pressure equipment list from Excel
Columns to include, PS, volume, fluid group, category and common pitfalls: turn your spreadsheet into a reliable list of pressure equipment.
By cDESP team7 min read
Why start from your existing Excel file
Almost every refrigeration site already has a spreadsheet somewhere: a survey made at commissioning, an export from the CMMS (GMAO), a list kept by the previous maintenance contractor. It is a good starting point, provided you put it back in order before using it as the regulatory list.
This list is not optional. Article 6, paragraph III, of the arrêté du 20 novembre 2017 (French ministerial order of 20 November 2017 on in-service monitoring of pressure equipment) requires the operator (exploitant) to keep an up-to-date list of the fixed pressure vessels, steam generators and piping covered by the order, including laid-up equipment or installations (au chômage). For each item of equipment, the list states at least:
- the type of equipment;
- the monitoring regime (with or without an inspection plan, and under which guide or professional technical code);
- the dates of the last and next periodic inspection (IP, inspection périodique);
- the dates of the last and next periodic requalification (RQ, requalification périodique).
The operator keeps it available to the officials responsible for supervising pressure equipment. The professional technical code (CTP, cahier technique professionnel) "Systèmes frigorifiques sous pression" (pressurised refrigeration systems), whose version of 8 April 2026 was approved by BSERR decision No. 2026-002 (BSERR: Bureau de la sécurité des équipements à risques et des réseaux, a ministry office), may specify the expected content of this list for installations monitored under that CTP: check it in the version you apply.
The columns to include
The regulatory minimum is not enough for day-to-day work. For a row to be verifiable and useful, these are the columns we recommend.
| Column | Why it matters | Where to find the information |
|---|---|---|
| Site, installation, tag | Find the equipment on site without ambiguity | Refrigeration diagram, site labelling |
| Type (vessel, piping, safety accessory...) | Required by article 6-III, determines the monitoring | Instructions, nameplate |
| Manufacturer, model, serial No. | Identify the equipment uniquely | Nameplate, EU declaration of conformity |
| Year of manufacture | Traceability reference | Nameplate |
| Refrigerant | Determines the fluid group | Installation nameplate, refrigerant log |
| Fluid group (1 or 2) | Determines the thresholds and the category | Refrigerant safety data sheet |
| PS (bar) | Basis of the whole classification | Nameplate, instructions |
| TS min / max (°C) | Design limits | Nameplate, instructions |
| Volume V (L) or DN | Calculation of PS x V or PS x DN | Nameplate, instructions |
| PED category (DESP) | Conformity assessment procedure applied | EU declaration of conformity, instructions |
| Monitoring regime | Required by article 6-III | Inspection plan, CTP applied |
| Last / next IP | Required by article 6-III | Inspection reports |
| Last / next RQ | Required by article 6-III | Requalification certificates |
| Subject to commissioning declaration (DMS, déclaration de mise en service) | Find the proof of filing | LUNE online service, operating file |
| Status (in service, laid up, removed) | Laid-up equipment stays on the list | Operations |
The definitions of PS, TS, V and DN are those of article 2 of Directive 2014/68/EU (the Pressure Equipment Directive, PED). Pressure there is gauge pressure (relative to atmospheric), and the volume V is the internal volume of each chamber, including connections up to the first connection or weld.
Which equipment goes on the list
The order applies to the equipment covered by article R. 557-14-1 of the code de l'environnement (French Environmental Code). For vessels and piping containing a gas (refrigerants are concerned), the thresholds are, in summary:
| Equipment | Group 1 fluid | Group 2 fluid |
|---|---|---|
| Vessel | PS x V > 50 bar.L (except V ≤ 1 L and PS ≤ 200 bar) | PS x V > 200 bar.L and PS > 4 bar (except V ≤ 1 L and PS ≤ 1,000 bar) |
| Piping | DN > 100 or PS x DN > 1,000 bar (except DN ≤ 25) | DN > 100 and PS x DN > 3,500 bar |
This table summarises the text, it does not replace it. Reread the article on Légifrance before deciding a borderline case, and rely on your competent person (personne compétente) or your authorised inspection body (organisme habilité) when in doubt. Our free tool VerifDESP helps with a first sort based on PS and V.
A practical tip: also keep the non-covered equipment in your file, with a column that says so explicitly. On inspection day, showing that you examined a vessel and concluded it was below the thresholds is better than letting it look as though it was forgotten.
Fluid group and category: two notions not to confuse
The fluid group is defined by article 13 of Directive 2014/68/EU on the basis of the hazard classes of the CLP Regulation: group 1 includes in particular flammable fluids and certain toxic fluids, group 2 everything else. The DREAL Hauts-de-France leaflet on refrigeration systems (DREAL: the French regional environment authority) points out that most refrigerants fall into group 2, but that ammonia (R717), isobutane (R600a) and R1234yf are group 1. The reflex: read the hazard statements in section 2 of the safety data sheet.
Note that the fluid group is not the safety class of standard NF EN 378 (A1, A2L, B2L...). The two classifications follow different logics.
The category (I to IV) is determined by the manufacturer using the tables in Annex II of the directive, according to the type of equipment, the fluid group, PS and V (or DN). It determines the conformity assessment procedure. Do not recalculate it from memory: take the one from the EU declaration of conformity or the instructions, and report any apparent inconsistency to the competent person.
The classic pitfalls of an inherited Excel file
One row per system instead of one row per item of equipment. The list covers each vessel and each item of piping concerned. A single "medium-temperature refrigeration unit" row is not enough.
The wrong pressure. PS is neither the operating pressure, nor the test pressure PT, nor the relief valve set pressure. On the same system, the PS on the high-pressure side and on the low-pressure side are often different: each item of equipment keeps its own.
Units. Gauge bar versus absolute bar, MPa, psi on imported equipment: convert, and put the unit in the column header, never in the cell.
Dates in the wrong format. A "03/04/2025" can become 4 March depending on the computer that opens the file. Use real Excel dates or the YYYY-MM-DD format.
Damaged serial numbers. Excel removes leading zeros and turns long numbers into scientific notation. Format the column as text before pasting.
Merged cells and subtotals. They break any sorting and any import. One row, one item of equipment, one value per cell.
The refrigerant changed but not the list. After a retrofit, the fluid group may change, and with it whether the equipment is covered or its due dates. Update the row and record the work in the log.
Laid-up equipment deleted. Article 6-III explicitly includes it. State its status rather than deleting it.
A five-step method
- Freeze a copy of the original file, then work on a clean version.
- Normalise: one row per item of equipment, units in the header, dates and serial numbers in the right format.
- Fill in the gaps (PS, V, serial No.) on site by photographing each nameplate.
- Classify: fluid group, whether the equipment is covered, category taken from the manufacturer's documents.
- Have the list reviewed by the competent person before treating it as the reference.
And in cDESP?
cDESP provides an Excel template to fill in, organised by assembly: one row for the assembly or installation, followed by its equipment, with columns for type, manufacturer, model, year, serial number, refrigerant, volume, DN, PS, test pressure, relief valve set pressure, pressure switch settings and tag. Import is free on all plans. The fluid group is taken from the application's list of fluids, a category and an indication of whether a commissioning declaration applies are suggested from PS, the volume or the DN (to be checked against the manufacturer's documents), the equipment is added to the site, and the schedule of inspections and requalifications takes over with email reminders. Illegible or missing nameplates can then be completed by photo, thanks to automatic nameplate reading.
The groundwork described above is still needed: an import does not correct a wrong PS. But once the list is clean, it stays up to date instead of ageing in a shared folder.
To try it with your own file, create an account or see the pricing.