-
Set Endpoint (version 23)
Before the user can request data from the Historian, the client must point their add-in to the Views service residing on the historian server. This initial set up should only need configured once…
-
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…
-
Overview (version 24)
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…
-
Overview (version 25)
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 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.…
-
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 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…
-
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 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 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.…
-
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.…
-
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…
-
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…
-
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.…
-
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…
Welcome to the community!