Skip to main content

VTScada - Data Retrieval

Trihedral Engineering Limited

1.0 (1)

Retrieves historical data from VTScada applications for ad hoc analysis and building custom reports

The VTScada add-in for Excel allows you perform ad hoc analysis and build custom reports by providing a simple method for retrieving historical data from your VTScada application. Harness the full power of Excel to analyze and present your data.

The add-in provides

  • a hierarchical tag browser for selecting your tags
  • customizable relative and fixed time ranges
  • raw or calculated data retrieval with lots of calculation types like average, min, max, total, runtime, starts
  • lots of output options

Tag selections and time ranges are reusable to make your queries faster to build. The data queries you create are refreshable, so the query you configure for "last month" will always be for the last month relative to when you refresh your report. Your queries are saved in the Excel document, so once you share your document with others in your company, the data can be refreshed by colleagues with the proper sign-on credentials. The VTScada add-in uses a secure connection to your VTScada server, so your data is always safe.

The VTScada add-in works with Excel 2016, 2019, 365, iPad and Online. It connects to any secured VTScada version 12.0+ server.

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474849272/Product_42949683550/Asset_eab58812-49d1-49c4-a556-6958cc6dd81c/Primary.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474849272/Product_42949683550/Asset_eab58812-49d1-49c4-a556-6958cc6dd81c/Primary.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474849272/Product_42949683550/Asset_a2171204-3354-4e88-8e14-b15a467c8369/Secondary1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474849272/Product_42949683550/Asset_8cad5587-8590-4530-92a2-11d9a6a6d673/Secondary2.png