Excel Add-in Support

APARCHVAL | Read Archive Value

Summary

Retrieve an archive value from a given tag. This function is available via the taskpane as well as directly via the cell “=APARCHVAL(…)”.

We recommend configuring this formula using the ‘Read Archive Value‘ task pane.

Return Value

The function returns the archive value of a given tag and timestamp. The tag must be configured in the Automation Portal Historian before the tag can be read in Microsoft Excel.

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’

Mode – Specifies the retrieval mode of the archived value. 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.

Timestamp – Specifies the date and time of the desired archive value.

Options – Specifies custom options given by the task pane. Default value is 0.

Example