PID Report

From SysCAD Documentation
Jump to navigation Jump to search
Warning! Page you're reading is outdated or was archived and very likely is referring to older version of the software.

Navigation: User Guide -> Example Projects -> Examples - SysCAD Excel Reports

Tutorial Tutorial Videos Getting Started Modelling Guideline
& Check List
Example Projects Example Reports Example PGM Files

Related Links: Steps in Creating a Report, Report Types


Project Criteria Report Project Report Sensitivity Analysis PID Report

PID Report

File Location

This file is stored in ..\SysCAD93\Examples\01 Reports\PID Report.xlsm

Please note that this report has been removed in Build138, the PID report is now part of the default report 04DetailedReport.xlsx.

Brief Description

This is a PID report template, it will collect information from the View | Controls Access window List Tab, which is only available in SysCAD version 9.3 Build136.19056 or later.

Excel Worksheet Tab


The PID report creation will take 2 or 3 steps:

  1. Enter the Total PID Count in the project to first set up the SysCAD reporting tags. This can be done by manually entering the value in Cell D6 or run the report once to fetch this value. Note the report may not be correct a this point.
  2. Use the Clear Table Value macro button to clear the table. This step is optional, only required if the current report has more PID reported than what is the project.
  3. Once the correct Total PID count value is entered, save the workbook then run the report from SysCAD to populate the table.

The report uses outline to hide some columns, please extend to level 2 to view the full report including the SysCAD_TagList and SysCAD_TagTable input(Column C and Row 9).

PID report.png

Note that the PID report has been set up to report upto 500 PIDs in the project, for projects with larger number of PIDs than this, please extend the report. This include:

  1. PID index so that Column C will fill down to return the correct tags.
  2. Conditional formatting so that inactive PID will be presented in a different colour.
  3. extend the Clear Table Value macro to cover the larger area.