I am building a test system that measures the output of a sensor as a voltage with a Picolog 1216 (using one input channel). The device being tested is put through its paces by a pneumatic actuator driven by a PLC. The PLC also generates a trigger signal to another channel on the Picolog. I am running PLW Recorder and calculating a third data output from the input voltage. (Actually measuring a gas pressure).
The test runs for 26 seconds, taking 2600 readings which are transferred to the Pico spreadsheet window at the end of the test and displayed as four columns of readings (Time, trigger voltage, sensor voltage, pressure) in the spreadsheet window. The user then copies and pastes the data to another excel spreadsheet for analysis.
I'd like to automate the data transfer process but I'm not a software engineer. I can use DDE to transfer live data to one excel cell but haven't got it to tranfer the whole formatted data array. Is there a simple application that can do this for me or am I going to have to learn to write software?