-
Overview (version 23)
The following is a brief description for each function contained within the Excel Add-in. Tag List - creates a tag list to be used in other add-in functions Tag Properties - returns all property…
-
AdHoc Events (version 23)
The 'AdHoc Events' function allows the user to search for events on the fly that are not already configured within Canary's Calcs & Events service. View Select an available 'View' from the drop down…
-
AdHoc Events (version 24)
The AdHoc Events function allows the user to search for events on the fly that are not already configured within Canary's Calcs & Events service. View Select an available View from the drop down list.…
-
AdHoc Events (version 25)
The AdHoc Events function allows the user to search for events on the fly that are not already configured within Canary's Calcs & Events service. View Select an available View from the drop down list.…
-
Tag Data Context (version 24)
The Tag Data Context function returns the following four fields for a set of tags: latest timestamp, latest value, latest quality, and oldest timestamp.…
-
Tag Data Context (version 25)
The Tag Data Context function returns the following four fields for a set of tags: latest timestamp, latest value, latest quality, and oldest timestamp.…
-
Tag Data Context (version 23)
The 'Tag Data Context' function returns the following four fields for a set of tags: latest timestamp, latest value, latest quality, and oldest timestamp.…
-
Tag Properties (version 23)
The 'Tag Properties' function returns the properties and property values for a set of tags. A tag can have any number of properties defined by the logging source or coming from an external database.…
-
Tag Properties (version 25)
The Tag Properties function returns the properties and property values for a set of tags. A tag can have any number of properties defined by the logging source or coming from an external database.…
-
Tag Properties (version 24)
The Tag Properties function returns the properties and property values for a set of tags. A tag can have any number of properties defined by the logging source or coming from an external database.…
-
Last Value (version 24)
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…
-
Last Value (version 25)
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…
-
Last Value (version 23)
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 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.…
-
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.…
-
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 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.…
-
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…
-
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…
-
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…
Welcome to the community!