Excel Add-in Support

Taskpane: Read Archive Value

Summary

The ‘Read Archive Value’ taskpane helps the user configuring the ‘=APARCHVAL(…)’ function in a very user-friendly way. This function reads an archive value of a given tag and displays it in any desired Excel cell. Before a tag can be used in Excel, the tag must first be configured in Automation Portal Historian.

The user can open the ‘Read Archive Value’ taskpane by clicking the ‘Read Archive Value’ 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.

Timestamp (field) – Specifies the timestamp of the desired datapoint 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 value in case an exact timestamp match can’t be found in the archive. Following options are possible:

  • Closest Value – Returns the closest available value to the given timestamp.
  • Previous Value – Returns the closest available value before the given timestamp.
  • Next Value – Returns the closest available value after the given timestamp.

Header – When this checkbox is checked, a header with column titles is added to the top of the shown value cell.

Timestamp (checkbox) – When this checkbox is checked, the timestamp of the shown value is added to the left of the current value.

Quality – When this checkbox is checked, the quality of the shown value is added to the right of the current value.

Procedure

1. First open the taskpane by clicking the ‘Read Archive Value‘ 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 clock, the ‘Timestamp‘ panel will appear.

5. Then, choose the 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 value should be displayed in the spreadsheet.

9. Finally, click ‘OK’, the value will appear in the cell.

Example