Need to log data from a Modicon Quantum PLC using OFS. Want to bring 20 values from the PLC into Excel, place them in 20 sequential columns, and sample every 50-100ms putting new data in new rows, up to a maximum number of samples as defined in the spreadsheet (ie customer puts in 50 or 100ms sample rate and how many samples to take).

Does anyone have an Excel sheet that might help me develop this? I've done some of this before, but with other vendors' PLCs and it was years ago. Need a sample to refresh my memory.

 

I have the same application but with a TSX Premium and using OFS. At the moment we have a VB program that logs the data, but we are not able to control the sample time accurately and we are not able to get near 100ms.

Any successful data logger program of info would be much appreciated. Our email is: [email protected]