First, if I need to capture data (counting parts and tracking downtime) from 18 PLC's, would it be better to use a single spreadsheet and move the data from a live spreadsheet to a different sheet (same workbook) titled the machine name, or just use multiple workbooks, each with a livedata sheet and a captured data sheet?
Second, is it possible to use a log data trigger from the PLC? When the machine is stopped/Faulted I start a timer to determine downtime and what I want to do is log downtime once the machine has started. Is there a way to set up handshakes?
Thanks for your time