Exporting process data from the SIMATIC S7 to Excel
The graphic Windows application, also known as the "S7-to-Excel tool", records and logs every available date in the desired format according to specifications in the specially defined Excel template. The evaluations automatically created in this way thus become – without post-processing – directly part of the process chain and can provide, for example, daily current forecasts and much more without manual intervention.
While the desired data type, its formatting and coding can be defined for each data area, all data areas can be specifically logged according to certain specifications. Triggers are available for logging after a certain interval, after an edge and after a certain condition.
In addition, the free definition of recurring regions based on the assignment of data areas to table areas enables extended evaluations, which thus also allows, for example, a simple comparison of processes. This extension of the worksheets is thus possible dynamically in horizontal and vertical direction.
Feature | Standard | Advanced | Expert | Evaluation |
---|---|---|---|---|
Trigger based log file creation | x | x | x | x |
Maximum number of channels | 1 | 1 | 1 | 1 |
Maximum number of triggers | 1 / Sheet | 1 / Sheet | 1 / Sheet | 1 / Sheet |
Interval trigger | x | x | x | x |
Value change trigger | x | x | x | x |
Boolean trigger | x | x | x | x |
Conditional / Edge Trigger | x | x | x | x |
Expand worksheet with region(s) | x | x | ||
Maximum number of variables | 100 | ∞ | ∞ | ∞ |
A licence is purchased once for a specific installation or as a dongle and is valid for an unlimited period (= unlimited licence lifetime). In addition, our top level support by our developers as well as updates including new functions can be purchased for 12 months.
Shortly before the support expires, it is possible to extend it for at least another 12 months for 10% of the current list price. Updates and new functions can only be obtained with valid support. Support requests can still be submitted, but will be processed on a priority basis depending on their scope. Up to one month before the expiry of active support, we will notify you of the possibility of support renewal. A support renewal is possible at any time in the first year after expiry of the support for 10% + 20% for each started quarter (since expiry of the support) of the current list price. After the first year, a new licence must be purchased for the support renewal.
SIMATIC LOGO! / SIMATIC S7-200 / SIMATIC S7-300 / SIMATIC S7-400 / SIMATIC S7-1200 / SIMATIC S7-1500
Inputs, outputs, flags, data blocks, timers and counters
High-performance logging of consistent data
constant connections through automatic reconstruction
Identifiers in SIEMENS and IEC syntax format
1 to 8, 16, 32 and 64 bit data length - also as ARRAY OF
BYTE, WORD, DWORD, INT and DINT - also as ARRAY OF
REAL and DOUBLE - also as ARRAY OF
TIME, S5-TIME, DATE and DATE_AND_TIME
CHAR to S7-STRING - also via BYTE with own encoding
Windows