Automated report generation and data analysis software firm SyTech has introduced XLReporter Version 10.0 that comes with two new components, data entry management and reporting from text files.
The data entry component turns Microsoft Excel into a ‘design studio’ to create data entry forms, database design and linkage of the forms to the databases, without any programming.
XLReporter then validates the data and stores it in a secure, central database, making it available for reports from local or remote client stations.
XLReporter’s list of interfaces has been expanded to include text files, enabling direct reporting from data loggers.
The data entry component, Interactive Forms, is designed to place the entire application in the familiar environment of Excel. It also supports most databases, including Microsoft SQL Server and Access, ensuring that Interactive Forms can be used in large or smal industryl.
XLReporter’s reporting component, the File Cabinet, addresses obstacles users face when creating reports from text files.
The File Cabinet technology enables the user to integrate the data from disparate files into a single entity to produce reports that go beyond each text file.
It also creates and maintains a list of tag names so tags can be simply selected by XLReporter’s tag browsers.
It features filtering and sorting together with analytic calculations such as the average for each hour of a day. Analytic calculations are also provided for historians.
SyTech CTO Peter Kaprielian said producing reports that incorporate manually entered data with production data is a challenge for industry.
"With this version of XLReporter, these challenges are met in one package,"Kaprielian said.
