PLX-DAQ v2.11 Dual Trace Transfer Tips to Excel

Using a TTL 555 timer chip as a pulse generator to send a dual channel signal to Excel in Windows 10.

 

This is my second installment on using PLX-DAQ as an easy method of sending data from an Arduino or any AVR related MCU to Excel. Here I will be showing you how to process the data into a graphical chart for plotting it’s values…the easy way 🙂

I set up a simple pulse generator using a TTL 555 timer chip, we will be utilizing pins 3 ( Output) and 5 (Control) as our dual signal trace, in this way we can use PLX-DAQ as a very cheap “Oscilloscope,” and transfer that data into excel and plot the data.

Ok, lets go…

1st the pulse generator;

Pulse generator1

2nd, setting up PLX-DAQ so you can receive both signals;

code chart2 In the highlighted area use the “unsigned long int” expression to avoid any overflow, this should be fine since our variable is only 5/1023

Next;

code chart1

Included with PLX-DAQ is a beginners quick start guide that has a pretty good outline on setting up various data types, I’m using the easiest example here because it is straight forward. The highlighted area is the most important because it sets up the labeling for your columns and rows.

code chart3

This is where you put your main code into, I used the ReadAnalogVoltage sketch in the Arduino IDE and modified it so PLX-DAQ can read and transfer both channels into excel. The most important part of this section is the “Data,Time,” milli_time and “,” in that sequence, the last part is a delay between 3 and 100 millisec. Why? If you don’t excel just can’t process the data fast enough no matter how much you may want to tweak the page file on your PC, believe me, I just found that a delay of 50 and a baud rate of 19200 transfers data very smoothly with no problems and looking at the video I think you may agree with me.

code chart4

Lastly, for our second channel that’s easy, just rename the sensor value’s and float value to 1 and so on, and use the same delay factor and your done!

Ready to transfer to excel!!

For a more detailed analysis and schematical view, please visit my project site @ Retro-City

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s