PLC-data in Excel

ARTNR	#	€
sum:	0,- €

ARTNR	#	€
sum:	0,- €

Karl Roll GmbH & Co. KG
Mühlacker - Enzberg
www.karl-roll.de

Application

"PLC-data in Excel" creates Excel files from any PLC variables according to your design.
For Windows 32/64-bit (XP, 7/8/8.1/10/11)
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.

support-service:

SUP-9773-S7
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard single-license