Retrieve periodic numeric values

To retrieve periodic numeric values:

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

   

   Note: Datetime results can be displayed up to millisecond resolution by applying custom cell formatting, such as yy-mm-dd hh:mm:ss.000.

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.

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 cells in your spreadsheet containing datetime values for the start and end time.

6. Select the time Interval over which to retrieve values.

7. Click NEXT. The next page of the add-in displays.

   

8. Select which Values to include for each tag. You can choose to include any combination of Average, Minimum, Maximum, Total, and Count.

9. Select which Details to retrieve along with the values for the selected tags. You can choose to include any combination of Start Date Time, End Date Time, OPC Quality, and Percent Good.

   Note: In most cases you only need to display one time value to identify the interval, usually the start time.

10. Select whether to sort the data in Ascending or Descending order.

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