Canary's excel add-in is designed to allow a seamless transition from Canary to excel. After it is installed it will create a tab at the top of the sheet labeled Canary labs. Under the Canary tab are multiple points labeled:
Get Endpoint: This will return a text in the specified cell stating the end point of the Canary Views Web Service.
Set Endpoint: This is used to set up the path to the data source. It will populate a box with a drop down arrows for the historian, type of login, and port number(if it is a specific user, the ID and password box will need filled out.
Version Info: This function gets the current version of the Views Web Service.
Aggregate List: This function gets a List of Aggregates supported by the Views Web Service.
Views list: Gets a List of the current Views within the Views Web Service.
Tag List: Populates a list of the tags in the historian and data set requested.
Tag Properties: Are the properties and property values for a set of tags. There are 7 default properties that a tag will have when it is logged via the standard Canary Logger. The properties are description, engineering units, high scale, low scale, high limit, low limit and sample interval. However, a tag can have other properties define by the logging source.
Tag Data Context: Is the data context for a set of tags. The data context information consist of four fields: latest timestamp, latest value, latest quality, and oldest timestamp.
Raw Data: Will read 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. If the tag's were pulled for updates every one second, but the value only changed every 2 minutes, there would be a TVQ every 2 minutes and not every second. When getting data from multiple tags, the timestamp sequence for each tag will be different.
Processed Data: Calls the processed data for a set of tags. The processed data is a series of TVQs (timestamp, value, quality) and there will be a TVQ for each aggregate interval between the StartTime and EndTime. The timestamp column(s) will be common across all tags.
Value At: This 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.
Last Value: Returns the most recent TVQ for a set of tags.
Find Events: Returns events based on search criteria.
AdHoc Events: Searches for Events and returns ones matching the search criteria.
Relative Time Format
The format for the relative time is: keyword+-offset+-offset where keyword and offset. White space is ignored. The time string must begin with a keyword. Each offset must be preceded by a signed integer that specifies the number and direction of the offset. If the integer preceding the offset is unsigned, the value of the preceding sign is assumed positive (beginning default sign is positive). The keyword refers to the beginning of the specified time period. DAY means the timestamp at the beginning of the current day (00:00 hours, midnight), MONTH means the timestamp at the beginning of the current month, etc.
Demo of using Excel Add-In