> For the complete documentation index, see [llms.txt](https://help.auxalia.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.auxalia.com/plant-tools/plantexpresstools/how-to-use/off-page-connector-manager/usage/additional-use-cases/exporting-the-opc-status-to-excel.md).

# Exporting the OPC Status to Excel

This chapter describes how you export the status of all OPCs in the project to an Excel file.

With the export you can answer questions like "How many OPCs are connected?" or "Which properties differ between two connected OPCs?" outside of Plant 3D, for example in Excel or Power BI. The file contains the state the OPC Manager currently shows. If the drawings have changed since you opened the OPC Manager, click on **Refresh** first.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-0f35e7728bea28e3e753ed52b472c5fcd694b701%2FPET-OPCM-Export-001.png?alt=media)

To start the export you click on the **Export to Excel** button in the toolbar of the OPC Manager.

Now you choose where to save the file. The suggested name contains the project name and the date and time of the export. Click on **Save**.

The OPC Manager collects the data and opens the file in Excel. The file has three sheets: **Summary**, **OPCs** and **Inconsistencies**.

Remark: If PlantTools runs in German, the sheets and columns have German names.

### <mark style="color:blue;">Summary</mark>

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-9047ef6e4ceae9c4727dafa3c4fffae1fd6d7ef3%2FPET-OPCM-Export-003.png?alt=media)

The Summary sheet contains one row per figure. Every row repeats the project name and the export time. This way you can append several exports in Excel or Power BI and follow the progress over time.

| Column    | Content                                  |
| --------- | ---------------------------------------- |
| Project   | Name of the project.                     |
| Exported  | Date and time of the export.             |
| Category  | Overview, Status or Additional states.   |
| Item      | Name of the figure, see the table below. |
| Count     | Number of OPCs.                          |
| Share (%) | Share of the evaluated OPCs in percent.  |

The rows are:

| Category          | Item                    | Content                                                                                                      |
| ----------------- | ----------------------- | ------------------------------------------------------------------------------------------------------------ |
| Overview          | OPCs evaluated          | All OPCs of the project, without the OPCs a filter expression excludes.                                      |
| Overview          | Connected in total      | OPCs which are connected to at least one other OPC, including the connections with inconsistencies.          |
| Overview          | Not connected           | OPCs without a connection.                                                                                   |
| Overview          | With inconsistencies    | Connected OPCs where at least one property with 'Check for Inconsistency' differs.                           |
| Status            | (one row per state)     | Number of OPCs per state, with the state names of the OPC Manager. User defined states get their own row.    |
| Additional states | Flow Direction Conflict | OPCs with a conflict in the flow direction.                                                                  |
| Additional states | Attribute Flow TaskList | OPCs with a pending task in the AttributeFlow task list.                                                     |
| Overview          | Excluded by filter rule | OPCs a filter expression excludes. They are not evaluated, so their share refers to all OPCs of the project. |

### <mark style="color:blue;">OPCs</mark>

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-1e204cd65cc50915c39ab088bca8f496c8ed89d6%2FPET-OPCM-Export-004.png?alt=media)

The OPCs sheet lists every OPC of the project, sorted by folder, drawing and name. The OPCs a filter expression excludes are listed as well.

| Column                  | Content                                                            |
| ----------------------- | ------------------------------------------------------------------ |
| OPC                     | Name of the OPC as shown in the trees.                             |
| Folder                  | Project folder of the drawing.                                     |
| Drawing                 | Drawing of the OPC.                                                |
| Class                   | Class of the OPC.                                                  |
| Direction               | Outgoing, Incoming or Unknown Flow Direction.                      |
| Status                  | State of the OPC.                                                  |
| Connected               | True if the OPC is connected to at least one other OPC.            |
| Partner OPC             | Connected OPCs, separated by semicolons.                           |
| Partner drawing         | Drawings of the connected OPCs.                                    |
| Flow Direction Conflict | True if the OPC has a conflict in the flow direction.              |
| Attribute Flow TaskList | True if the OPC has a pending task in the AttributeFlow task list. |
| Excluded by filter rule | True if a filter expression excludes the OPC.                      |
| PnPID                   | ID of the OPC in the project database.                             |

### <mark style="color:blue;">Inconsistencies</mark>

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-2120430831d06e0e3294896cedf40faeb878a343%2FPET-OPCM-Export-005.png?alt=media)

The Inconsistencies sheet contains one row for each property that differs between two connected OPCs. Only properties with the option 'Check for Inconsistency' in the mapping are checked, see [Tree Settings & Mapping](https://help.auxalia.com/plant-tools/plantexpresstools/how-to-use/off-page-connector-manager/setup/tree-settings-mapping.md).

| Column          | Content                        |
| --------------- | ------------------------------ |
| OPC             | Name of the OPC.               |
| Folder          | Project folder of the drawing. |
| Drawing         | Drawing of the OPC.            |
| Partner OPC     | Name of the connected OPC.     |
| Partner drawing | Drawing of the connected OPC.  |
| Class           | Class of the property.         |
| Property        | Property which differs.        |
| Value           | Value at the OPC.              |
| Partner value   | Value at the connected OPC.    |

Each connection is listed once. If the flow direction is known, the OPC column shows the outgoing OPC.

Remark: The export only reads the project. Unlike **Update OPC Properties** it does not change any property of the OPCs.

Remark: If the Excel file is still open, the export cannot overwrite it and shows a message. Close the file in Excel or choose another file name.
