Hi, here are a few thoughts, some, all, or none of which might be of use.
1) The folks at Parallax have a free application, PLX DAQ (earlier StampDaq) that directly takes in data from the serial port and inserts them in a spreadsheet; you might have to play around with the data frame structures;
http://www.parallax.com/tabid/393/Default.aspx If you use the CDC mode, the app might be able to take your data directly from the virtual com port, eliminating a USB-to-serial chip / adapter.
2) As Dave pointed out, again using CDC, you could spit out the data in your 3 columns in a 31 iteration loop, grab it on the PC with a terminal emulator (one that recognises virtual com ports), and simply copy-paste it into Excel. This technique I have tried (not with USB, with serial) to plot the discharge curve of a battery and works fine.
3) Take a look at Windmill software,
http://www.windmill.co.uk/ as also another product from Parallax,
http://www.parallax.com/ProductInfo/...1/Default.aspx
Regards,
Anand
Bookmarks