I'm using an ADC-20 to log data from a circuit to measure the resistance of a coil of wire. The Pico software is working fine, but what I really need is to export the data from the logger software directly into Excel in real-time. I can then set up a template sheet in Excel with input columns and graphs to automatically deal with the data and do what I want with it, which is draw graphs, use moving averages and create alarms depending on differences between two sets of moving averages (I'm comparing the coil resistance over a moving average of 30 samples to a moving average of 3 samples, and if the difference between the two values is above a set threshold then it triggers an alarm).
Having had a look through the help files I found the input to the cell to collect some data from the software, =PLW|Current!Value (and !Units and !Name), and this seems to work to an extent but this only takes data from the first input channel and I can't work out how to make Excel read the data values from the other input channels. I have 4 input channels, and from these values a host of other calculated parameters.
Now I am probably missing something very obvious but I don't have a vast knowledge of programming so I apologise if the answer is an obvious one!