earth_america
user_standard Anmelden
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
Ratgeber

Ratgeber


Produkte: AS-B, Enterprise Server, AS-P
Funktionen: Technik
Produktversion: 3.2, 3.3, 2022
15.10.2020

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.

Mehr zeigen
action_close

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. Für weitere Informationen siehe Configuring a Trend Log Series in a Multi Trend Log List  .

Hinweis

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.

Hinweis

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. Für weitere Informationen siehe 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.

Für weitere Informationen siehe 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.

Für weitere Informationen siehe Calculation Methods .

Hinweis

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.

Für weitere Informationen siehe 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

     
    action_zoom_plus_stroke
    .

  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.

Siehe auch

  • Multi Trend Log Lists
  • Exporting a Multi Trend Log List to .XML 
  • Exporting a Multi Trend Log List to .CSV 
  • Multi Trend Log List Toolbar