Datalogging directly to Excel

dermot

I am designing a project which requires datalogging (max,min and average values) at various intervals. I wish to display this on a LCD (this is not a problem) but I also want to display it realtime on an excel sheet on a PC.

I am using a P8x32a programming in spin.

Each time a sample is taken I wish to transfer the max,min and average value on a opened excel sheet. I wish to do this by RS-232 comms if possible.

Which is the best approach?? Is there any an objects available on obex for something like this.

Bean

The easiest was to do this is to use the FTDI drivers on the PC. As long as you are using the parallax USB-to-Serial adapter it will work (or any of the boards with USB built-in like the Quickstart).

Then just a small bit of VBA code is required to poll the Propeller and get the data.

There is also a free program that does this that Parallax supports (I can't remember the name right now, maybe someone else can chime in).

Bean

Bob Lawrence (VE1RLL)

Robot Basic (free)
http://www.robotbasic.org/2.html

Example For the Propeller chip

http://www.robotbasic.org/resources/RobotBASIC_To_PropellerChip_Comms.pdf


Option 2:

AN018: Communication with a PC Application

---

http://www.parallaxsemiconductor.com/an018

Duane Degn

Another alternative is to use an application Phil wrote.

ElectricAye

Bean wrote: »

...

There is also a free program that does this that Parallax supports (I can't remember the name right now, maybe someone else can chime in).....

Perhaps you are thinking about the PLX-DAQ:

http://www.parallax.com/tabid/393/Default.aspx

sylvie369

I believe that PLX-DAQ will be the easiest way to do this. It's pretty well documented, and easy to use.

Bean

ElectricAye wrote: »

Perhaps you are thinking about the PLX-DAQ:

http://www.parallax.com/tabid/393/Default.aspx

Thanks, Yes that is the program I was thinking of...

Bean

Bob Lawrence (VE1RLL)

@Bean

re:Perhaps you are thinking about the PLX-DAQ:

http://www.parallax.com/tabid/393/Default.aspx

Great thanks! I don't remember seeing that before. I downloaded it to have a look and it's nifty.