Summary
The ‘Read Time Series’ taskpane helps the user configuring the ‘=APTIMESERIES(…)’ function in a very user-friendly way. This function reads an archive time series of a given tag and displays it in any desired Excel array. Before a tag can be used in Excel, the tag must first be configured in Automation Portal Historian.
The user can open the ‘Read Time Series’ taskpane by clicking the ‘Read Time Series’ button in the Automation Portal Excel Add-in ribbon.
Arguments
Tag – Specifies the tag name of the desired tag. The tag name must be exactly the same as configured in the Automation Portal ‘Historian’. The user can also search the tag via the ‘Search Tag’ panel. To make use of the ‘Search Tag’ panel, click the magnifying glass next to the tag field.
Start – Specifies the start timestamp of the desired time series from the archive. The user can also make use of dynamic timestamp expressions. The easiest way to select a timestamp or create a dynamic timestamp expressions is using the ‘Timestamp’ panel. To make use of the ‘Timestamp’ panel, click the clock next to the timestamp field.
End – Specifies the end timestamp of the desired time series from the archive. The user can also make use of dynamic timestamp expressions. The easiest way to select a timestamp or create a dynamic timestamp expressions is using the ‘Timestamp’ panel. To make use of the ‘Timestamp’ panel, click the clock next to the timestamp field.
Mode – Specifies the retrieval mode of the archived time series. Following options are possible:
- Raw Data – Returns all the available datapoints in the given start to end range.
Header – When this checkbox is checked, a header with column titles is added to the top of the time series array.
Timestamp – When this checkbox is checked, the timestamp of the shown values in the time series are added to the left of the values.
Quality – When this checkbox is checked, the quality of the values are added to the right of the values.
Procedure
1. First open the taskpane by clicking the ‘Read Time Series‘ in the ribbon.
2. Secondly, click the magnifying glass, the ‘Search Tag‘ panel appears.
3. Next, select the desired tag from the list and click ‘OK‘, the tag name will appear in the tag textbox.
4. Click the start clock, the ‘Timestamp‘ panel will appear.
5. Then, choose the start timestamp or dynamic time expression and click ‘OK‘.
6. Click the end clock, the ‘Timestamp‘ panel will appear.
7. Then, choose the end timestamp or dynamic time expression and click ‘OK‘.
6. Select the desired ‘Mode‘.
7. Thereafter, check the desired ‘Header’, ‘Timestamp’ and ‘Quality’ options.
8. Then, select the desired cell where the time series array should be displayed in the spreadsheet.
9. Finally, click ‘OK’, the time series array will appear in the spreadsheet.
Example
