Sites and equipment
Import the 6-III list
Create all the systems and equipment of a site at once from your 6-III list in Excel format.
3 min read
The 6-III list is the list of pressure equipment (PE, "ESP" in French) of an installation that the operator keeps up to date, under article 6-III of the French order of 20 November 2017. If you already have it in an Excel file, cDESP can read it and create the site's systems and their equipment in one go.
Before you start
- The site must already exist. See Create and manage a site.
- Use a computer: the import button does not appear on a phone.
- Accepted formats:
.xlsx,.xlsand.xlsm. - Depending on your subscription, the button may be missing if your account can only view sites.
Prepare the file
cDESP only reads the first sheet of the workbook. Rows 1 to 3 are kept for titles: reading starts at row 4 and stops at row 109.
The columns must be in this order. Type values are written in French, exactly as below:
| Column | Content | Required |
|---|---|---|
| A | Type: Ensemble, Installation, Récipient, Tuyauterie, Accessoires de sécurité or Equipement | Yes |
| B | Manufacturer | Yes |
| C | Model | Yes |
| D | Year | No |
| E | Serial number | No |
| F | Refrigerant fluid | Yes |
| G | Volume (litres) | No |
| H | DN (nominal diameter) | No |
| I | PS (maximum allowable pressure) | No |
| J | PT (test pressure, in bar) | No |
| K | Set pressure | No |
| L | Pressure switch or thermostat setting | No |
| M | Tags | No |
A row of type Ensemble (assembly) or Installation starts a new system. The following rows are its components, up to the next Ensemble or Installation row. So always start the list with an Ensemble or Installation row.
Import the file
- In the left menu, click My sites.
- On the site's row, click the arrow at the start of the row. The All systems list opens below the table.
- Click Import a list from Excel.
- Choose your file.
- Wait for the import to finish: the button shows "Importing in progress...".
The message "Your Excel file has been successfully uploaded." confirms the import. The new systems appear in All systems.
What cDESP creates
- One system per
EnsembleorInstallationrow, with the model (also used as its designation), the manufacturer, the serial number, the year and the fluid. If cDESP knows the fluid, the fluid group, the toxicity and the requalification periodicity are filled in automatically. - One component per following row, with all the values of the row. The chapter, the risk category and the need for a commissioning declaration (DMS) are suggested automatically when the type, fluid, PS, DN and volume allow it.
The file holds no dates. Then open each system with Edit (depending on your subscription) to enter the initial visit (VI) date, the commissioning date, the last periodic inspection (IP) and the last periodic requalification (RQ). cDESP can then calculate the next due dates. See Systems and equipment and Deadlines and reminders.
Check the result
- Open each system with the arrow of its row and check its components.
- Correct a value with Edit. If your subscription does not show this button, report the correction to the DCRR team.
- To review the full list, at the top of My sites, click Export, choose List 6-III (PDF format), then the site, and click Export as PDF.
If something goes wrong
- "An error occurred during the import": check the file format, then try again.
- Rows are missing: a required column is empty, or the rows are before row 4, after row 109 or on another sheet.
- The fluid group or toxicity are empty: cDESP did not recognise the fluid name. Open the system with Edit and choose it in Refrigerant fluid.
- The problem persists: in All systems, click the button that starts with Request for to write to the DCRR team.