Application

"PLC-data in Excel" creates Excel files from any PLC variables according to your design.
You design the look directly in Excel.

Features:

• free create of the Excel-tables with formulas and formats
• Insert data records (regions) to Excel file, (as of V 2.0)
• Operation without Excel-installation
• event- and time-controlled writing per worksheet (time-/event-trigger)
• no programm in the PLC necessary
• no limit on the count of variables
• file-creation with time-stamp in the file-name
• easy parameterization
• the addresses of the PLC-variables are specified directly in the Excel table (for e.g. PLC_ADDR,DB10.DBW100,INT)

Supported PLC-types (one connection to an S7 PLC!):

• S7-1500
• S7-1200
• S7 300/400
• S7-200
• S7-SoftPLC
• Logo!-SPS
• VIPA-S7
• all S7 compatible controls

All parameters are stored directly in the XML-template-file.
The template includes all information as:

• target directory
• target-file with format-specification for the date and time
• connection-parameters to the PLC (ip-address etc.)
• addresses of the PLC-variables
• Time or event trigger for generating the target file / appending records
• This information is indicated with the help of keywords at any position in the Excel worksheet. Variables from the PLC will appear in the target file at the same position (cell), where the relevant variable address has been entered.

Example

Template:


Result:

screenshot of the configuration

program flow

Differences of license types:

Features	Standard	Advanced	Expert
Count of variables	100	unlimited	unlimited
Possibility to write data areas dynamically			x

Differences between"PLC-data logging/triggering" and "PLC-data in Excel" (Find the right product for your requirements):

Features	PLC-data logging/triggering	PLC-data in Excel
What happens in the event of a trigger event	Defined values are appended in a given file with a time stamp one file for several trigger events (infinite list)	The specified file is filled with values from the controller and saved as a new file one Excel file per trigger event
Filename	Specified by the configuration of the tool	Can be specified by the PLC, otherwise by the tool
Number of configured S7 connections	Depending on the license from 4 to 256	1 connection
Number of variables/connection	Depending on the license from 100 to 1000	Depending on the license from 100 to unlimited

Licensing process:
Free download of the complete range of functions for 14 days:
/9773-S7_sps-daten-in-excel.html/

Licensing under "License"
(mouse click on the key symbol)
Your machine-code for this PC with order by email to verkauf@process-informatik.de
You will receive a license code to enter under "License", so that the program is licensed on your PC.
With a USB-dongle, there is no machine-code, the USB dongle contains the license, comes via UPS.

All prices plus costs of delivery, shipping insurance and VAT.

All prices plus costs of delivery, shipping insurance and VAT.

PLC-software-tools

PLC – Data safety
PLC-Backup and restore for the S5- and S7-PLC

CIM - 2001
Process - Visualisation, PLC - data directly into Excel

Industrie 4.0 tools

Universal communication Industry 4.0
Universal - simple - contemporary - one platform for many purposes

OPC-Server
data recall by OPC-Server

S7-PLC exact time synchronization
Easy automatic setting of the S7-PLC-time

Products for the LOGO! - controls

S7-communication-driver
Com.-driver for the LOGO/S7-200/300/400/1200/1500 + Sinumerik 840D

OPC-Server
data recall by OPC-Server

PLC-data logging/triggering
Automated writing of data from the PLC to a file

EtherSens
Networked via LAN - WIFI - LTE
Worldwide access from any device possible
Internal and external data-storage
Simple rail-mounting

S7-LAN
smallest simatic S7 ethernet gateway with PD-socket, multifunctional, 1 adapter for all PPI, MPI and Profibus applications
with ext. 24V-connector
easy remote maintenance over internet

Sending eMail with LOGO!-Control

Sending SMS with LOGO!-Control

Process energy-data with LOGO!-Control

Data-logger
Record of PLC-variables over time

All prices plus costs of delivery, shipping insurance and VAT.