-
Last Value (version 26)
The Last Value function returns the most recent TVQ (timestamp, value, quality) for a set of tags. Input Range A reference to a range of cells containing a list of tag names typically generated by…
-
Value At (version 26)
The Value At function finds TVQs that meet a set of criteria for a set of tags. If found there will be one TVQ (timestamp, value, quality) for each tag.…
-
Value At (version 25)
The Value At function finds TVQs that meet a set of criteria for a set of tags. If found there will be one TVQ (timestamp, value, quality) for each tag.…
-
Value At (version 24)
The Value At function finds TVQs that meet a set of criteria for a set of tags. If found there will be one TVQ (timestamp, value, quality) for each tag.…
-
Value At (version 23)
The 'Value At' function finds TVQs that meet a set of criteria for a set of tags. If found there will be one TVQ (timestamp, value, quality) for each tag.…
-
Raw Data (version 23)
This 'Raw Data' function returns the raw data for a set of tags. The raw data is a series of TVQs (timestamp, value, quality). If the data changes, a new TVQ is generated.…
-
Raw Data (version 24)
The Raw Data function returns the raw data for a set of tags. The raw data is a series of TVQs (timestamp, value, quality). If the data changes, a new TVQ is generated.…
-
Raw Data (version 25)
The Raw Data function returns the raw data for a set of tags. The raw data is a series of TVQs (timestamp, value, quality). If the data changes, a new TVQ is generated.…
-
Raw Data (version 26)
The Raw Data function returns the raw data for a set of tags. The raw data is a series of TVQs (timestamp, value, quality). If the data changes, a new TVQ is generated.…
-
Processed Data (version 26)
The Processed Data function gives the user the ability to request aggregated/processed data from the historian, as opposed to raw data. For example, a user may want to know what the average hourly…
-
Processed Data (version 25)
The Processed Data function gives the user the ability to request aggregated/processed data from the historian, as opposed to raw data. For example, a user may want to know what the average hourly…
-
Processed Data (version 24)
The Processed Data function gives the user the ability to request aggregated/processed data from the historian, as opposed to raw data. For example, a user may want to know what the average hourly…
-
Processed Data (version 23)
The 'Processed Data' function gives the user the ability to request aggregated/processed data from the historian, as opposed to raw data. For example, a user may want to know what the average hourly…
-
Aggregate List (version 23)
Aggregates According to the OPC Foundation, aggregates "are methods that summarize data values. Common aggregates include 'average over a given time range', 'minimum over a time range',…
-
Tag List (version 23)
A 'Tag List' is a generated list of tags that will be used as the input for other functions in the Add-in, such as: Tag Properties Tag Data Context Raw Data Processed Data Value At Last Value Search…
-
Tag List (version 24)
A Tag List is a generated list of tags that will be used as the input for other functions in the Add-in, such as: Tag Properties Tag Data Context Raw Data Processed Data Value At Last Value Search…
-
Leveraging the Excel Add-in (v21)
In this session, learn how to: Build and filter tag lists Pull tag properties Recall last values Query raw data values Use aggregates and processed data
-
Setting the Endpoint in the Excel Add-in
Where does the Set Endpoint configuration get saved to?
- Answered
-
The Canary Excel Add-in
Learn how to query data within the Canary System directly from Microsoft Excel. Pull raw data values, processed data values, make Event queries, or build your own custom reports.…
-
Excel Add-in tag search
Is there a way to exclude tags from search results in the Excel Add-in?
- Answered
Welcome to the community!