· PlcExcel reads and writes data from/to PLCs, displays data in Excel and logs data into a SQL Server database.
· PlcExcel queries and retrieves data from the SQL server database used for logging the data.
· PlcExcel communicates with PLCs via Ethernet and supports several PLC types in a network.
· PlcExcel tags to log and monitor are configured in an Excel configuration file.
· PlcExcel has one mode of logging: continuous logging (frequency based).
· PlcExcel supports most of the Rockwell's Logix series PLCs (1756,1769), Micro850 cip (in preview) and most of the SLC505 (1747) Ethernet PLCs.
· PlcExcel also supports several S7 Siemens Ethernet PLCs like S1500, S1200, S200, S200Smart, S300, S400.
· PlcExcel auto creates the database PlcExcelDb and required logging and error tables.
· PlcExcel is an excel Add-in application. It adds one Add-in for PLC tags monitoring and writing and a second Add-in for Database
queries to fetch data from the database used for logging.
· PlcExcel is indeed smart as it recovers from most network errors.
· PlcExcel diagnostics are via an auto generated custom event log (AclLogs), an error table in the database and an auto generated daily text
file to log errors. Errors are also displayed in a status add-in group.
· PlcExcel is free but the number of tags is limited.
· PlcExcel has been designed for PLC programmers, System Integrators and for consumers that require an easy to configure and reliable monitoring and data logging system for diagnostics.
· Being part of the Smart-Tools® series PlcExcel is up and running in a matter of minutes after configuration, saving huge costs.
