VTScada - Data Retrieval

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.

Use of this add-in requires the purchase of VTScada with Remote Data Access enabled. All features of this add-in are available at no additional cost to customers with the Remote Data Access capability in VTScada. Due to technical limitations certain features are not available in older versions of Excel, including all MSI packaged versions of Office 2016. Excel with support for ExcelApi version 1.7 is required for full functionality.