Issue
How to create a proper XLSX/Excel template under Alarm Triggered Notification of EcoStruxure Building Workstation, in order to receive the Multi trend logs report in the XLSX/Excel format.
Product Line
EcoStruxure Building Operation
Environment
EcoStruxure Building Workstation
Cause
Additional information is needed to create a template for presenting multi-trend log information in Excel XLSX format.
Resolution
Below screenshot shows where users can select the Report format and XLSX template.
The multi trend log containing four Interval Trend Logs 1 to 4 with their time stamp is shown as below as an example
In order to get the XLSX multi trend log report in XLSX/Excel format upon receiving a trigger, the following XLSX template needs to be used containing two rows:
- The first header row contains the column headers from the trend log.
- The second row include the <Multi Log List> command
Here is final report in Excel/XLSX format:
