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
Tags
Excel Add-in
Filter
Active
Newest
Popular
Most likes
Most replies
Most views
Tag Data Context (version 22)
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 yrs ago
27
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
6 mths ago
31
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
6 mths ago
72
Excel Add-in
Tag Properties (version 22)
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.…
2 yrs ago
57
Excel Add-in
Last Value (version 22)
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…
2 yrs ago
43
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
6 mths ago
44
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
6 mths ago
42
Excel Add-in
Value At (version 22)
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 yrs ago
30
Excel Add-in
Raw Data (version 22)
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
2 yrs ago
67
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
6 mths ago
72
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
135
Excel Add-in
Aggregate List (version 22)
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
165
Excel Add-in
Tag List (version 21)
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 yrs ago
74
Excel Add-in
Tag List (version 22)
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 yrs ago
109
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
2 yrs ago
133
Excel Add-in
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
2 yrs ago
169
Previous Coaching Sessions
Setting the Endpoint in the Excel Add-in
Where does the Set Endpoint configuration get saved to?
Big_Bird
Hi everyone! I post questions for the Canary Team to answer.
Big_bird
2 yrs ago
1
reply
66
Last reply
Steve Mason
2 yrs ago
Questions & Answers
Answered
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.…
updated
2 yrs ago
616
Canary Academy
Excel Add-in tag search
Is there a way to exclude tags from search results in the Excel Add-in?
CanaryBot
Tweet tweet, I'm a bot
canarybot
2 yrs ago
1
reply
43
Last reply
CanaryBot
2 yrs ago
Questions & Answers
Answered
Answered
1
2
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 23
Getting Started
System Admin Duties
Client Tools
Version 22
Getting Started
System Admin Duties
Client Tools
Version 21
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
View Support Ticket Status