Looking for options to write data to Siemens PLC.
Looking for something closest to way we were doing it with AB PLC and excel sheet.
Old way.
Excel sheet with Macros that would use RS Linx to connect to PLC and directly write values from Excel to the PLC arrays.
Arrays of configuration data for example
Input[x].EU
Input[x].RawMin
Input[x].RawMax
Input[x].EUmin
Input[x].EUmax
+++ a lot more
x could be in range from 1-2000
Data in excel sheet is (col names --- Array, Rawmin, Rawmax, EUmin, EUMax) Each row is a different array ID (x) in this example above)
For Siemens I don't see anyway to directly write via macro from excel sheet to Siemens 1500 (redundancy)
Looking at Kepware but from what I can tell only way to do that would be to build the tags in Kepware (PLC tags and Excel tags) then script the excel tags to watch for change and update PLC tags when Excel tags change... Problem with that is that most of the data is static and we don't want something constantly monitoring. But we want to be able to say Update array [56] - [125] and it updates the values in the PLC with the values from the excel sheet from those rows.
Looking for something closest to way we were doing it with AB PLC and excel sheet.
Old way.
Excel sheet with Macros that would use RS Linx to connect to PLC and directly write values from Excel to the PLC arrays.
Arrays of configuration data for example
Input[x].EU
Input[x].RawMin
Input[x].RawMax
Input[x].EUmin
Input[x].EUmax
+++ a lot more
x could be in range from 1-2000
Data in excel sheet is (col names --- Array, Rawmin, Rawmax, EUmin, EUMax) Each row is a different array ID (x) in this example above)
For Siemens I don't see anyway to directly write via macro from excel sheet to Siemens 1500 (redundancy)
Looking at Kepware but from what I can tell only way to do that would be to build the tags in Kepware (PLC tags and Excel tags) then script the excel tags to watch for change and update PLC tags when Excel tags change... Problem with that is that most of the data is static and we don't want something constantly monitoring. But we want to be able to say Update array [56] - [125] and it updates the values in the PLC with the values from the excel sheet from those rows.