Cookies helfen uns bei der Bereitstellung unserer Dienste. Durch die Nutzung unserer Dienste erklären Sie sich damit einverstanden, dass wir Cookies setzen.
Cookies help us in providing our services. By using our services, you agree that we set cookies.
OK
PLC-data in Excel - Process Informatik Entwicklungsgesellschaft mbH

PLC-data in Excel


Create with the S7-PLC Excel-files

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

more...
on request
plus VAT. and shipping
ARTNR: 9773-S7
PLC-data in Excel-tool, single-license
quantity
Recommended accessories
+
9773-DO PLC-data in Excel license-dongle AddOn on request



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.
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)
Differences of license types:
Features Standard Advanced Expert
Count of variables  100  unlimited  unlimited
Possibility to write data areas dynamically      x

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 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
All prices plus costs of delivery, shipping insurance and VAT.

accessories:

9773-DO
PLC-data in Excel license-dongle AddOn
USB-dongle with license-key instead of software-key Only for Win7/8/8.1 and Win10
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

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

Einzel-Lizenz

9773-S7-A
PLC-data in Excel-tool, advanced, single-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

9773-S7-E
PLC-data in Excel-tool, expert, single-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

Folge-Lizenz

9773-S7-2
PLC-data in Excel-tool, subsequent-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template limited for 100 variables
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

9773-S7-A-2
PLC-data inExcel-tool, advanced, subsequent-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

9773-S7-E-2
PLC-data in Excel-tool, expert, subsequent-license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

Standort-Lizenz

9773-S7-3
PLC-data in Excel-tool, site / company license
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template limited for 100 variables
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

9773-S7-A-3
PLC-data in Excel-tool, advanced, state / comp.lic.
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

9773-S7-E-3
PLC-data in Excel-tool, expert, state / comp.lic.
for Windows 32/64-bit writing Simatic S7 Processdata to Excel file by XLS-Template count of variables unlimited all possibilities of enhancement
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

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
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-2
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard subsequent-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-3
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard site-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-A
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced single-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-A-2
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced subsequent-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-A-3
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced site-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-A-DO
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel advanced single-license with dongle-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-DO
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel standard single-license with dongle-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-E
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a S7-To-Excel expert single-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-E-2
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel expert subsequent-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-E-3
Software Update & Support service
Automatical Upgrade for innovations incl. technical support for 12 months for a PLC-data in Excel expert site-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

SUP-9773-S7-E-DO
Software Update & Support service dongle-version
Automatical Upgrade for innovations incl. technical support for 12 months for a S7-To-Excel expert single-license with dongle-license
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

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

9773-DO
PLC-data in Excel license-dongle AddOn
USB-dongle with license-key instead of software-key Only for Win7/8/8.1 and Win10
INFOMAIL
by e-mail
price on request
plus VAT. and shipping
Stück

9352-LANCON
S7-LAN connector for Siemens S7 PLC controller
Simatic S7 network adapter for PPI-MPI-PROFIBUS / network for every S7 controller in less than 3 minutes
Quickbestellung INFOMAIL
by e-mail
399,- €
plus VAT. and shipping
Stück

9352-ALF-WLAN-SET
ALF-WLAN-SET for S7-PLC
Service-case for coupling to a S7-PLC over WLAN
Quickbestellung INFOMAIL
by e-mail
599,- €
plus VAT. and shipping
Stück

0,- €
plus VAT. and shipping
Stück

9636-TCPIP.1M
Patch-cable 1m, Cat5e, shielded
RJ45 plug <=> RJ45 plug, 1:1
Quickbestellung INFOMAIL
by e-mail
14,- €
plus VAT. and shipping
Stück

9636-CROSS
Cross-cable 3m Cat5+, shielded
RJ45 plug <=> RJ45 plug, twisted pinning
Quickbestellung INFOMAIL
by e-mail
10,- €
plus VAT. and shipping
Stück

Automatic-mode

Other downloads

Extension

Support-videos