Log on to rate and give feedback    1 2 3 4 5 Log on to rate
0
How to How to 10/15/2020
Products: AS-B, Enterprise Server, AS-P
Functionalities: Engineering
Product version: 3.2, 3.3, 2022

Exporting a Multi Trend Log List to .XLSX

You export a multi trend log list to view the multi trend log list in an editor that opens the .XLSX format.

Hide
Show More

You configure a multi trend log list to display values from multiple trend logs in one list. You compare values in a multi trend log list when you commission or validate an EcoStruxure BMS.

For example, on a b3 BACnet device, there are two inputs: SpaceTemp and SpaceHumidity. Both inputs have logs set up intrinsically. You want to print the last 3 days of history for these inputs. You create a multi trend log list for both inputs. You can export the multi trend log list to a .CSV file or an .XML file, or .XLSX file, and then use an external editor to compare the values.

If a trend log has no available value for a given time stamp in a multi trend log list, then the trend log displays an empty cell for that specific time. You can fill that empty cell with the latest known value.

You can change the column order in the multi trend log list and save the change.

You can add, edit, or remove trend logs from the multi trend log list at any time. You can also edit how trend logs are displayed in the multi trend log list. For more information, see Configuring a Trend Log Series in a Multi Trend Log List  .

Tip:

You can add a trend log to a multi trend log list using drag and drop.

You can configure the individual trend log series in a multi trend log list.

Important:

All configurations on individual trend log series are overriden if you configure the multi trend log list.

Temporary multi trend log list

You can view a group of trend log lists in a atemporary multi trend log list without creating a multi trend log list. For more information, see Viewing Trend Logs in a Temporary Multi Trend Log List  .

Multi trend log lists in WebStation

Multi trend log list can be created and viewed in WebStation. Note that the setting Log space (records) is disregarded by WebStation. When viewed in WebStation, WebStation will always display all values in the multi trend log list regardless of the Log space (records) setting.

Time Zone Modes in a Trend Log List

​In a trend log list, you can present the records of a trend log in different time zones: local time zone, EcoStruxure BMS server time zone, and UTC time zone.

For more information, see Time Zone Modes in a Trend Log List .

Calculation Methods

​Use a calculation method to process the records of the trend log before presenting them in a trend log list or a trend chart. The original records in the trend log are not affected by the calculation method. The calculation method is applied to the trend log records grouped by a specific time interval.

For more information, see Calculation Methods .

Important:

If you have selected a calculation method on a series, event icons are not displayed on that series in the multi trend log list.

Floating Point Values NaN, INF, and -INF

In the EcoStruxure Building Operation software, the floating point values “Not a Number”, positive infinity, or negative infinity may be displayed in the Basic property tab, in a trend log list, or a trend chart.

For more information, see Floating Point Values NaN, INF, and –INF .

To export a multi trend log list to .XLSX
  1. In WorkStation, in the System Tree pane, select the multi trend log list you want to export to .XLSX.

  2. Click the Export to .XLSX button .

  3. Select where to save the .XLSX file.

  4. Click Save .

The .XLSX file is saved in the selected location and can be opened from an editor that can read .XLSX files.

Community Content

Product version

Language