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.…

  • 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 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.…

  • 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 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.…

  • 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.…

  • 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.…

  • 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 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…

  • 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…

  • 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.…

  • 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.…

  • 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.…

  • 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 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.…

  • 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.…

  • 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…

  • 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 22)

    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…

  • 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',…

  • 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',…

  • 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…

  • 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…

  • 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…

  • 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

1 2 3

Content aside

Recent activity