Retrieve single values

To retrieve single values:

1. Select Single Value from the AVEVA Historian add-in menu. If the add-in is already displayed, you can also select Single Value from the hamburger menu . The AVEVA Historian add-in panel displays.

   

2. To choose the list of tags to retrieve information for, click beside the Tags field, and select a range of cells containing a list of tag names.

3. Click beside the Results field, and select the cell where you want to insert the results. Normally, you will select a range adjacent to the tag list or tag information results to build out your report.

4. Select Down to list the results in rows by tag name, or Across to list the results in columns by tag name.

5. You can choose the Time to retrieve the tag values for in two ways:

   1. Select Time selection, and choose a time value from the drop-down list.

   2. Select Cell reference, and choose a cell in your spreadsheet containing a datetime value.

6. Select which Values to retrieve from the following options:

   3. Interpolated - If there is no data point stored at the exact time requested, the add-in retrieves interpolated values. The interpolation is dependent on the server-side tag configuration for interpolation type.

   4. Previous - The add-in retrieves the first value on or before the requested date/time.

   5. Next with time - The add-in retrieves the first value after the requested date/time, but replaces the timestamp with the date/time requested by the add-in.

   6. Previous with time - The add-in retrieves the first value on or before the requested date/time, but replaces the timestamp with the date/time requested by the add-in.

7. Select which Details to retrieve along with the values for the selected tags. You can choose to include any combination of TagName, Date/Time, and OPC Quality.

8. Select whether to display Discrete Values in Label format, Numeric format, or Boolean format.

9. Click FINISH. The selected tag information is retrieved and copied to your spreadsheet.