Pico Technical Support and Discussion Forum

Guest · Posted: Tue Mar 25, 2008 2:17 pm Post subject: Importing PicoLog Data Into Excel

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!

Regards,
Jason.

picojohn · Site Admin Joined: 11 Jun 2007 Posts: 371

Hello Jason,

Please try the attached DDE Excel macro for multiple channel export.

Regards
John

Guest · Posted: Wed Mar 26, 2008 1:37 pm Post subject:

Thanks for that!
Displays all the data and the calculated parameters too.
Now I'm just working on trying to make Excel deal with the data how I want.

Pico Technology

Pico Technical Support and Discussion Forum