Advertisements

Arduino Data Transfer to Excel 2016 PLX-DAQ Protocol

 

 

 

 

UPDATE 5/30/2017 10:06:AM

I have just tested this program on my Atmega 1284P Development board and it works perfectly and the Arduino Mega 2560 🙂

I have Excel 2016 and Windows 10, two powerful platforms in my humble opinion, well thanks to an individual named Net^Devil over at the Arduino forums, he has a very clever program that I think perhaps has in large part solved a problem for me.

I needed an alternative way of importing my CCD data directly into Excel, his program PLX-DAQ v2 does this and is completely open sourced. I have modified the sketch of the test program which makes it a lot more stable on the Excel data side (this may not be an issue for earlier versions of windows but is for windows 10).

PNG closeupmay29

The chart below is the GUI panel for PLX-DAQ in Excel

PIC4

Here is the PLX GUI panel opened in Excel, on my Mega 2560 my com port is 3 and my baud rate is 14400 (right now any faster and excel stops working? don’t know yet)

The documentation is good and easy to set the program up.

PLX-DAQ v2

Random number generator program running

PLX-DAQ v2 pic2

All data has been imported from the Atmega 2560 into Excel, you can see the data to your left in columns A and B.

Excel chart number 2

You an see here in the zoomed in view, that it makes life a lot easier when manipulating data and constructing charts all in one shot 🙂

 

 

 

PIC5

This is the test code for the random # generator for the Mega 2560, I’ve added the #include <util/delay_basic.h> lib, because I needed to incorporate a few delay functions to give Excel some time to catch it’s breath. Using the demo sketch by itself Excel, at least in Windows 10 will crash, so I increased millis() delay to at least (75) and added a couple of “do nothing” cycles, and it did the trick (but only at baud 14400).

Still all in all, this is very promising and I hope to modify it so it is adaptable to my Atmega1284P MCU…Any help out there would be greatly appreciated!

My project moves ever forward! 🙂

Advertisements

2 thoughts on “Arduino Data Transfer to Excel 2016 PLX-DAQ Protocol

  1. I have installed plx-daq but I couldn’t find my sensor data in its spread sheet but output is present in serial monitor.

    case 1:
    I executed below code
    int x = 0;
    int row = 0;
    void setup() {
    Serial.begin(9600); // opens serial port, sets data rate to 128000 bps
    Serial.println(“CLEARDATA”);
    Serial.println(“LABEL,Time,x,sin(x)”);
    }

    void loop() {
    Serial.print(“DATA,TIME,”); Serial.print(x); Serial.print(“,”); Serial.println(sin(x*PI/180));
    row++;
    x++;
    if (row > 360)
    {
    row=0;
    Serial.println(“ROW,SET,2”);
    }
    delay(100);
    }

    this code output is present in both serial monitor as well as in PLX-DAQ spreadsheet.

    but when I run another simple code for led blink like below code

    void setup() {
    // make pin 13 an output pin
    pinMode(13, OUTPUT);

    // open Serial communication port
    Serial.begin(9600);
    Serial.println(“CLEARDATA”);
    Serial.println(“Time,status”);
    }

    void loop() {
    // make pin 13 HIGH (5 V) so that LED comes on
    digitalWrite(13, HIGH);
    // print message to serial port that LED is on
    Serial.println(“TIME,on”);
    // wait for 1 second
    delay(1000);

    // make pin 13 LOW (0 V) so that LED goes off
    digitalWrite(13, LOW);
    // print message to serial port that LED is off
    Serial.println(“TIME,off”);
    // wait for 1 second
    delay(1000);
    }

    Its output is present in serial monitor but cannot be fetched in PLX-DAQ spreadsheet

    Please help me out ….

    Liked by 1 person

    • Hello MIMI, are you using Windows, and if so, is it Windows 10? if it is, 1st thing to do is run a simple test, run the # generator program example I have above (remember to include the library; #include) it’s all about the buffer stream in excel, I have only been able to get excel to accept data at 14400 baud rate so far.

      Problem 2, you can’t have the serial monitor open at the same time as Plx-Daq.

      Try these things 1st and let me know 🙂

      Like

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

El sabañon

Blog de Adrián Gastón Fares, director de cine y escritor argentino (nacido en Buenos Aires, Lanús)

TheKushOfficial

Thoughts Explorer

Sara in LaLaLand

Welcome to my world.

Happiness Between Tails by da-AL

Arts + Cooking + Dancing + Joy + Writing + Tales + Tails

Servants of Charity

The Whole World is Your Homeland

thinkinkadia

Challenging ideas are explored to see new actionable perspectives on relevant social issues, in this traveler space.

Bozziy

Reviews, recipes and photography...

Travel to Russia

Alex Markovich, 39 y.o. male living in Russia. A photographer, writer, and lecturer, as well as translator. A regular guest on “Radio of Russia” and other radio stations. Main subjects of the programs: “Traveling through Russia” and “Photo Art” (Alex arranges photo exhibitions in various Russian towns and cities, as well as abroad). E-mail: travel.with.markovich AT gmail.com

%d bloggers like this: