Canary Community
Search
How to enable Javascript
Sign Up
Login
Welcome to the Community!
Search the community
Feedback
Forum
Knowledge Base
Explore & Learn
Roadmap & Releases
Home
Knowledge Base
Version 24
Client Tools
Excel Add-in
All topics
Feedback
Issues and Bug Report
Bugs or Issues
Product Ideas and Feature Requests
Data Logging
Virtual Views
Calculations & Events
Axiom
Data Connectivity
Excel Add-in
Forum
Latest News
Axiom Showcase
Questions & Answers
Knowledge Base
Version 24
Getting Started
System Admin Duties
Client Tools
Version 23
Getting Started
System Admin Duties
Client Tools
Version 22
Getting Started
System Admin Duties
Client Tools
Explore & Learn
Upcoming Events
In-Person Events
Coaching Sessions & Webinars
On Demand Learning
RFP Common Responses
Canary Academy
Previous Coaching Sessions
Project Boot Camp
Roadmap & Releases
Roadmap
Canary System Release Notes
Ignition Module Release Notes
Distributor Release Links
Filter
Tags
Follow
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…
updated
3 mths ago
260
Excel Add-in
Getting Started (version 24)
Installing the Add-in Run the CanaryInstaller-*.*.*.exe and select Custom Install. Select Excel Add-in and deselect any other components if only wishing to install the Add-in.…
updated
2 mths ago
168
Excel Add-in
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…
updated
2 mths ago
148
Excel Add-in
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.…
updated
2 mths ago
78
Excel Add-in
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.…
updated
2 mths ago
37
Excel Add-in
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.…
updated
2 mths ago
82
Excel Add-in
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…
updated
2 mths ago
160
2
Excel Add-in
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.…
updated
2 mths ago
50
Excel Add-in
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…
updated
2 mths ago
51
Excel Add-in
Find Events (version 24)
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 event…
updated
2 mths ago
82
Excel Add-in
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.…
updated
2 mths ago
80
Excel Add-in
Aggregate List (version 24)
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
1 mth ago
5
replies
226
Last reply
Patch Hyland
1 mth ago
Excel Add-in
Set Endpoint (version 24)
The Set Endpoint function allows the user to choose which Historian to connect to as well as the time zone in which to present data. The endpoint must be set before any requests can be made.…
updated
2 mths ago
12
Excel Add-in
Support Center
Open a Support Ticket
Recent activity
Home
Feedback
Issues and Bug Report
Bugs or Issues
Product Ideas and Feature Requests
Data Logging
Virtual Views
Calculations & Events
Axiom
Data Connectivity
Excel Add-in
Forum
Latest News
Axiom Showcase
Questions & Answers
Knowledge Base
Version 24
Getting Started
System Admin Duties
Client Tools
Version 23
Getting Started
System Admin Duties
Client Tools
Version 22
Getting Started
System Admin Duties
Client Tools
Explore & Learn
Upcoming Events
In-Person Events
Coaching Sessions & Webinars
On Demand Learning
RFP Common Responses
Canary Academy
Previous Coaching Sessions
Project Boot Camp
Roadmap & Releases
Roadmap
Canary System Release Notes
Ignition Module Release Notes
Distributor Release Links
View all topics
Support Center
Open a Support Ticket