How to enable Javascript

Excel Add-in

All topics

Filter
Tags

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…
- 2 yrs ago
- 273
- Excel Add-in
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…
- updated 2 yrs ago
- 158
- Excel Add-in
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…
- updated 3 yrs ago
- 144
- Excel Add-in
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.…
- updated 11 mths ago
- 85
- Excel Add-in
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.…
- updated 11 mths ago
- 35
- Excel Add-in
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.…
- updated 11 mths ago
- 83
- Excel Add-in
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…
- updated 11 mths ago
- 168
- 2
- Excel Add-in
Relative DateTimes (version 23)
All of Canary's client tools (Axiom, Excel Add-in, ODBC, API) support the functionality of relative date/time when requesting data for a given start/end time as well as the aggregate interval.…
- 1 yr ago
- 54
- Excel Add-in
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.…
- updated 11 mths ago
- 49
- Excel Add-in
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…
- updated 11 mths ago
- 56
- Excel Add-in
Find Events (version 23)
The 'Find Events' function returns any events that have been pre-configured within the Canary Admin (See How To Create An Event). Event Type Will return any event type that matches the specified…
- updated 11 mths ago
- 90
- Excel Add-in
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…
- updated 11 mths ago
- 80
- Excel Add-in
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',…
- updated 2 yrs ago
- 162
- Excel Add-in

Support Center

Open a Support Ticket

Welcome to the Community!

Excel Add-in

Overview (version 23)

Set Endpoint (version 23)

Tag List (version 23)

Tag Properties (version 23)

Tag Data Context (version 23)

Raw Data (version 23)

Processed Data (version 23)

Relative DateTimes (version 23)

Value At (version 23)

Last Value (version 23)

Find Events (version 23)

AdHoc Events (version 23)

Aggregate List (version 23)

Support Center

Recent activity

Home

Support Center