Last Value (version 23)

  • updated 8 mths ago

The 'Last Value' function returns the most recent TVQ (timestamp, value, quality) for a set of tags.

A reference to a range of cells containing a list of tag names typically generated by the Tag List function. This range is automatically set to the cells that are pre-selected when the button for this function is selected. The range can be adjusted by editing the range or selecting a new range of cells then clicking the 'Set' button. Adjusting the input range will automatically update the output location.

This option will display a heading for each 'Display Field' included in the output.

If the 'Display Field' name is checked, that field will be included in the output results. The order of the display field names determines the order in which they are outputted. To rearrange the order, click a field and then press the up/down buttons along the right side. You can also drag-and-drop fields to rearrange them.

  • TimeStamp as Text - timestamps are returned as as formatted string down to one second resolution (10/4/2018 12:00:00 AM).
  • TimeStamp as Number - timestamps are returned as an Excel DateTime number (needs to have Excel formatting applied to make it readable).
  • Value if Good - The TVQ value if the quality is good, otherwise blank.
  • Value - The TVQ value, regardless of quality.
  • Data Type - The TVQ value data type.
  • Decimal Quality - The TVQ quality in decimal format (i.e. 192, 0, 64, 32768).
  • Hex Quality - The TVQ quality in hexadecimal format (i.e. C0, 0, 40, 8000).
  • Readable Quality - The TVQ quality - in a readable format - of the different bit meanings (i.e. Good, Bad, Uncertain, No Data).

This option transposes the output columns and rows.

This is the location where the output will be written to. It is the cell in the upper left corner of the result. The number of cells needed for the result will depend on the input parameters. The number of columns and rows returned is dependent on the number of tags and display fields. The default output location cell is set to the cell just below the left most cell of the input range (if the input range is horizontal) or just to the right of the top most cell of the input range (if the input range is vertical.)

When using input parameters referencing other cells, if the input cell changes it will automatically update the resulting data.

The Input Pane can be closed at any time by clicking on the X in the upper right corner. To re-open the Pane, click on the Canary Ribbon "Last Value" button. If the cell containing an existing Canary function has the focus and the user selects the corresponding function button from the Canary Ribbon, the input controls in the Pane will be set according to the parameters of the Canary function.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular