Retrieve detailed values

To retrieve detailed values:

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

   Note: When you select Detailed Values, a DetailedValues sheet is added to your workbook if it does not already exist, and results are placed in this sheet by default.

   

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

   Note: If you used the Tag Search page to select your tags, the range is automatically pre-selected for you.

3. Select the cell where you want to insert the results, then click beside the Results field.

4. The Conversion Units field allows you to compare values more easily by converting the retrieved data to display in the same engineering unit. Select a cell or range containing the names of target engineering units, then click beside the Conversion Units field. When tag data is retrieved, it displays in the selected unit if an appropriate conversion is available in the Engineering Unit Catalog. Otherwise, it displays in the default engineering unit for the tag.

5. Choose the Tag Direction. Select Across to retrieve the data in columns, one value per row. Select Down to retrieve the data in rows, one value per column.

6. You can choose the Time for which to retrieve the tag values 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.

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

   

8. Select which Values to include for each tag. Choosing All stored retrieves all stored values for each tag, while choosing Changes only retrieves only the values where there is a change from the previous reading.

9. Choose whether to view a single tag or all tags in each row or column of retrieved data.

   3. If you select Single Tag and the Tag Direction is Across, each row represents a specific time stamp and the values are arranged in columns by tag name.

      

   4. If you select All Tags and the Tag Direction is Across, each row represents a single value for a specific tag. If multiple tags contain values for the same time stamp, the values are listed in separate rows.

      

   5. If you select Single Tag and the Tag Direction is Down, each column represents a specific time stamp and the values are arranged in rows by tag name.

      

   6. If you select All Tags and the Tag Direction is Down, each column represents a single value for a specific tag. If multiple tags contain values for the same time stamp, the values are listed in separate columns.

      

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

11. Choose whether to sort by tag name in Ascending or Descending order.

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

    Note: A discrete tag has two states, and these tags can have labels associated with the two states. For example, for a tag representing a valve's position, the Label values might be "Open" or "Closed", the Numeric values are 0 or 1, and the Boolean values are True or False.

13. Select Static or Function to decide how to retrieve the requested data. If you select Static, the data will be retrieved and inserted directly into the report. If you select Function, a formula will be inserted instead, using the HISTORIAN.DETAIL function. If you edit the formula manually, the retrieved data will be refreshed immediately based on your changes. See Using the HISTORIAN.DETAIL Function for more information.

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