Arduino meets Excel ( PLX-DAQ )

$2 for 2-Layer PCBs & $5 for 4-Layer PCBs: jlcpcb.com/PCH
Start Altium designer FREE TRIAL : www.altium.com...
★☆★ OUR LATEST PROJECT 🏅🤖 ★☆★
👉 Getting started with Arduino Portenta : • Getting started with A...
In this video you will find all the necessary tools to establish a serial communication between Arduino board and Microsoft Excel file directly using your USB cable.
The data will be uploaded from your Arduino to Microsoft Excel file then you can use that file for your documentation like making Graphes, Plans, etc... The project is based on a main software which is the PLX-DAQ that use can download FOR FREE.
Feel free to contact us through a comment or private email if you need to know some additional information about the project.
★☆★ download PLX-DAQ ★☆★
ouo.io/rYUpr
★☆★ Order your Arduino now from Amazon ★☆★
Arduino Mega2560 : amzn.to/2LAWJTO
Arduino Nano : amzn.to/2NqZJDF
Arduino Uno : amzn.to/2MxwHWK
★☆★ download The source code ★☆★
ouo.io/i5779
★☆★ SUPPORT US WITH A SIMPLE TIP ★☆★
TiP here : en.tipeee.com/...
★☆★ FOLLOW ME BELOW: ★☆★
Instructables: www.instructabl...
Hackaday : hackaday.io/Me...
Facebook : www.facebook.c...
Twitter : / megadas1
Hackster : www.hackster.i...
Keywords:
Microsoft Excel
Arduino board
Serial
TX/RX
PLX -daq
data logging

[@makerplot-j]

As the original author of the software - thanks, nice video.

[@davidbristoll195]

Awesome! Thanks for sharing! Looking forward to having some fun with this.

[@thysavrin]

Hello! I don't know wrong with my machine. When I open PLX_DAQ this message "Could not load an object because it is not available on this machine." comes out and I cannot use it. I could not identify what is object.

[@youssefyammine1689]

the link will only show ads. It won't get me the plx-daq file

[@mandelbro777]

Cheers! Just what I was looking for (VBA fluent lazy person who can't be arsed learning C# just yet ... and I say this every year :)

[@Jabba_the_Kench]

I've been using an accelerometer and want to upload data to excel I've used an program that allows me to connect the port to excel and upload data. But when i connected port sometimes data doesn't upload and the letter "R" blinks red. I was wondering does it have anything to do with the code. Do you like have to include something so arduino can comunicate with excel. Because I've tried different codes for different projects and sometimes it doesn't work

[@jaredgibson3785]

Can you please show how to store data from excel into the arduino?

[@mauricioxavier6927]

I am getting the same message: "cannot find 'C:\Programm(x86)\Parallax-Inc\PLX-DAQ.xls'. Check the spelling of the filename , and verify that the file location is correct."

[@raulbarreto6221]

Solo ha compartido el acceso directo ... por eso ocurre ese mensaje is a shortcut file...

[@2808drw]

Great But how can I log/sample let say 24 hours with sampling rate every 10 second ?

[@rohanpawar4278]

it is not printing anything on excel but R is blinking in red

[@MTerkait]

same here

[@DIYGUYChris]

Hello Mohammed Make sure that you activate the macros for the spreadsheet, then try the same code that I provided in the description of the video. Let us know if we can farther assist you

[@MTerkait]

Lol the ground pin wasn't fully in. which made the serial transfer not work but arduino blink.

[@DIYGUYChris]

It's important to check the wiring connection ;) Happy that you solved the problem Keep up and good luck

[@vigneshwaransd2785]

I have same problem how to solve

[@mathid3012]

I can't open the PLX window, it shows an error. While opening the excel it says that, could not load some object bcz they are not available on this machine. Can you give any solution? mine is windows 10. Thank you

[@MikesPikes]

Is there an option without the peppy music?

[@ranggamasli8974]

just read the manual, PLX-DAQ help file

[@vigneshwaransd2785]

Sir i am using a switch to increment data but it is not working for me...how can i resolve it....

[@salahmohamed7799]

The download file only contains shortcuts and not the actual files. This video is useless without the necessary software.

[@ravelonjatovoherman1896]

Awesome!Thanks for sharing!Excel is a software ,is it abble to stock DataBase of Fingerprint,? an exemple to use in Com

[@aryanjain9877]

The excel is not taking data,when I connect to the PLX-DAQ ,only R button is blinking,what should I do? Please help me out Sir.

[@user-nz6ph1qo1m]

I download this before 4 months and its worked wonderful but since this months its didnt works. there is an update? or its not available mor? THANKS.

[@DIYGUYChris]

Hello There is no updates! what did you miss exactly !? the source code ? Let us know if we can further assist you. Do not forget to subscribe ourKZbin channel for more awesome videos.

[@haupham7379]

Great! Thank you very much! :)

[@nielslarsen1094]

Nice video, but much better if the music had been omitted. It' s a rry Disturbing factor.

[@pragyapatel7730]

In this in arduino file name is saved by plx-daq , how we can link it?? if our file name is different. you don't show how to save file? have u save the file in plx-daq?

[@effieeli5750]

is this software can be use for fpga board? if no, can u recommend any software like this that can be use for fpga board? please help..

[@piece_cr]

i like you video thanks link plx-dax

[@AtlantaTerry]

You seem to be yelling into your microphone so loudly that your voice is distorted. Move the mic closer to your mouth. Also, put a "pop" filter between you and the microphone so when you expel letters such as a "p" the microphone won't record it as it would wind blowing over it. You can find videos here on KZbin discussing "pop" filters.

[@arslanlatif8625]

hie, am receiving data on serial moniter, after i verfified that am receving the data , i quit the serail moniter and directly connect from PLX daq but receive no data their, just connect message display and R led start blinking , whats the problem, waiting for ur kind reply, thnx - via YTPak(.com)

[@DIYGUYChris]

Hello Arslan, Probably you should use Microsoft Office 2007 to solve this.

[@absoftech5180]

showing error --stampDAQ could not connect... How to solve?

[@DIYGUYChris]

Hello! Try it with Microsoft Excel 2007

[@joseabraham396]

Sending data from excel vba to arduino, for example to flick a led or to turn on and turn off it, have you an example?

[@DIYGUYChris]

Hello Jose I am sorry to tell you that I'm not familiar with the Excel VBA, But using the PLX-Daq you can only upload data to your Excel file, it means you can not used to read data from Excel file.

[@SanjeetKumar-qd7fy]

PLX daq software has been installed successfully.but I am not getting the data in excel sheet even status is showing connected.I have followed all instruction that has been shown in video but still I am not getting.For kind of information I am currently using 2003 ms office as well as 2007 ms office. so plz help me to get this solution.

[@DIYGUYChris]

Hello sanjeet, Did you use my code to test your project!? Let us know if we can further assist you.

[@SanjeetKumar-qd7fy]

I have used my own project code.Is there any additional program modification in arduino to fetch data from arduino to excel sheet?

[@DIYGUYChris]

Sure there is some specific lines to add, so you need to download the code that I used and find out what you missed in your code.

[@keby1mhr1]

It said 'stampDAQ could not connect, check port setting' when i selected the right port number. But it is connected once I close the arduino. I reopened the arduino but error appear as I tried to upload the code. help!

[@DIYGUYChris]

Hello Mohammad! The first thing to verify is the baud rate, it should be the same baud configured in your code and PLX-Daq as well, then try to check if the right port number (follow the steps in the video) is selected in the PLX-Daq interface and you get the (c) icon turn from red to green when you click the connect button.

[@keby1mhr1]

I did exactly that, its just the port wont be connected at the same time with arduino and PLX-Daq. I can only connect one at a time, for example, if the port connected with arduino, PLX-Daq ask me to check port setting. OR. if the port connected with the PLX-Daq, the arduino code wont converge due to its not connected. any idea?

[@DIYGUYChris]

Before making a Serial communication you should know first how it operates like the port configuration the baud rate etc... But what you mean by "port wont be connected at the same time"!

[@visionstills3700]

I really wish I could understand what you are saying. Please don't use music, it is ruining the video.

[@DIYGUYChris]

Hello VisionStills Sorry for the vedio quality, you can ask me if you want to know something!

[@ddx30]

Man, I so really like your videos, just discovered them, but the music is SOOOO anoying I can't watch them till the end...

[@MrGdangles1]

i agree, it makes it harder to understand. other than that the information is very appreciated

[@DracMastah]

I would add to this that the microphone is really saturated. good content though

[@SanjeetKumar-qd7fy]

one more thing I had to ask that If I have both version of ms office 2003 and 2007 but after opening the PLX daq excel sheet,It automatic redirected to the excel 2003.Is there any flexibility to change the excel version for this particular application.

[@DIYGUYChris]

Make the 2007 version the default software for Excel files

[@SanjeetKumar-qd7fy]

But how we can make excel 2007 as default when excel 2003 version also present in pc.Plz tell me the step to make 2007 excel default software keeping 2003 ms office also.?

[@DIYGUYChris]

Just follow this video :) kzbin.info/www/bejne/f5TYl62rpMyMaa8

[@michaellunt1638]

Video is nice, links are blocked as malicious intrusion.

[@harshvardhanmore4729]

Hello there....I downloaded the PLX DAQ but instead of the spreadhseet it is showing me shortcut to spreadshit....plz guide me what to do...or any alternative link

[@sanjeetkumar-yy9fq]

I have install PLX-DAQ but after opening the plx-daq spreadsheet file one message is displayed"could not load an object because it is not available on this machine".plz help me to solve this problem.

[@DIYGUYChris]

Hello sanjeet, I often receive this kind of issues from those who use Microsoft Excel 2010 or higher, I advise to use Excel 2007 because it runs with no problems. Let us know if we can further assist you.

[@miteshnaik9886]

hey thanxzz a lot for this video i tried this, when i open spreadsheet and enable that plx-daq after clicking connect on plx-daq window that C & T go green and R start blink red but nothing comes on my plx-daq spreadsheet.. plzz help me............

[@DIYGUYChris]

+mitesh naik verfy the Arduino source code you can find the code that i used it in this tutorial through the link bellow ----------------------------------------------------------------------------------------------------------------------------------------------www.mediafire.com/download/8prj3e6mg9y13i7/plx_daq_serial.ino

[@amirulhadafi7071]

+MEGA DAS hye, i cannot compile the code, do i need any library for this ? it says Error compiling for board Arduino/Genuino Mega or Mega 2560.

[@DIYGUYChris]

kim taeroll hey first tell me what arduino board are you using! Them did you tried the code in which there are an LCD instructions !! Please tell us if you solve the problem, thank you :)

[@amirulhadafi7071]

+MEGA DAS hye, problem solved! i want to add more data into the excel for example weight, and temperature, any idea how to do it? thanks! :)

[@DIYGUYChris]

sure you can :) just get back to the source code and modifie the number of collums in the setup function please tell us if there is another problem thank you :)

[@ftk8644]

After I used this program, I have a problem where every time i open my laptop and try to use the arduino ide, it show s me that " com port busy", do you face this problem?

[@DIYGUYChris]

Hello yap yoonheng Never faced that issue before. Just google it and you will find some guidance on how to free a com port. Let us know if we can further assist you. Do not forget to subscribe to our KZbin channel for more awesome videos.

[@nursakinah8561]

perhaps did you open the serial monitor at the same time?

[@ftk8644]

I disconnect and reconnect my FTDI, then the problem solve edy, tq.

[@victorg8815]

thanks for sharing bro! your help has given me a whole new hope pal!! this is awesome!!!

[@DIYGUYChris]

Hello Victor You are welcome! feel free to ask us if there is any problem !

[@nurjamahashiabdulle1711]

Very fantastic oen!

[@quantum_realiti1585]

Hello Mega Das, We need the data of R305 finger print sensor data which is connected to arduino uno board into the excel sheet?? and the code we used #adafruit library

[@DIYGUYChris]

Hello Sudheer! I'm not sure that you can make it with an Arduino Uno if you are using the Serial Pins (TX/RX) for Fingerprint sensor because these Pins are connected to the USB-to-TTL Serial chip, as I know the finger print sensor use a Serial protocal to transfer data to the Arduino board so in this case you need to use the SoftwareSerial library that allows serial communication on any of the Uno's digital pins and let the TX/RX pins free for the USB transmission. Let us know if we can further assist you.

[@MTerkait]

do you know how can i print on a second worksheet depending on serial input?

[@DIYGUYChris]

Hello Mohammed, Sorry! no idea about this :/

[@sergejvogel6080]

I cant use your version of PLX-DAQ, the excel tells me : cannot find 'C:\Programm(x86)\Parallax-Inc\PLX-DAQ.xls'. Check the spelling of the filename , and verify that the file location is correct. I do it same way

[@DIYGUYChris]

+Sergej Vogel i just downloaded the file and there is no problem with it !

[@mufideskanurcahya5081]

Thanks you. This video is very good👍

[@pvravi478]

Will the PLX DAQ software work for MICROSOFT EXCEL 2016

[@DIYGUYChris]

I'm not sure.. But I used 2007 version and it was perfect for the macros..

[@devilboii96]

Why is it that everytime i use the DATA,TIME the time that is shown on my computer is different than that of the one recorded into the Excel by PLX-DAQ? It shows 0.65 which doesnt even make sense

[@DIYGUYChris]

TIME is the header of the column not the current time, but to do so you should have an RTC module for arduino which allows you to have the right time then send it to that column for sure if time is what you want to get

[@devilboii96]

If you're talking about RTC modules, can't the PLX-DAQ just extract the date and time from the computer by itself?

[@dave-in-nj9393]

I really wish KZbin would add a second volume button for horrible background music.

[@redwin1]

Terimakasih banyak. Saya coba di proyek fire alarm dan pompa hydrant berjalan baik.

[@farad37]

Music makes this unwatchable for more than 10 seconds. Plus - adjust your mic gain path to stop horrible clipping distortion

[@wardimanulabrar8199]

Help, i cant download the source code because the link is has been blocked. Thank you

[@rezanejadzare]

unfortunately, it can not run in windows10

[@reynoldvallecer1065]

Thank you! help me alot

[@DIYGUYChris]

+Reynold Vallecer welcome :)

[@idansagiv1920]

Hello, I am trying to use a PLX-DAQ in order to get some data from my Arduino, Unfortunately, I get an "Unable to load some objects because they are not available on this machine" (Microsoft Message) Is it stems from the fact that I'm using Excel 2016? (Anyway, I tried to enable macros but it didn't work also) should I download Excel 2013 (will it work?) or Windows 10 maybe cause the issue I have (In this case, I have nothing to do) Thanks!

[@DIYGUYChris]

Hello Idan, PLX-DAQ can intract with Microsoft Excel 2007 only, we still don't know why the macros can't be enabled in the higher versions, but you can upload data to your Excel File if you use the 2007 version. Let us know if we can further assist you.

[@idansagiv1920]

Hey again, I ran this little program: double x; void setup() { Serial.begin(9600); Serial.print("CLEARDATA"); Serial.print("LABEL,Current time,Sensor value"); } void loop() { x = 10*sin( 2.0*PI*( millis() / 5000.0 ) ); Serial.print("DATA,TIME,"); Serial.println(x); } I opened the PLX-DAQ SRL EXCEL 2007 but now I can't see incoming data into the excel software (and probably not even a graph). (PORT and BAUD is O.K) What to do?

[@DIYGUYChris]

Try to replace these instruction lines: Serial.print("CLEARDATA"); Serial.print("LABEL,Current time,Sensor value"); by the following instructions: Serial.println("CLEARDATA"); Serial.println("LABEL,Current time,Sensor value"); Then add a delay of 1 second "delay(1000);" in the loop function and tell me if it worked I added in the description of the video the source code that I used i this project

[@theatdu9163]

Link for download PLX - DAQ died. Can you help me?

[@ashwinmoi]

Dear Mega Das, I am receiving the following error: "StampDAQ could not connect. Please check Port Settings". I am sure that my Arduino Uno is in COM3 and I have chosed Port 3 in the DAQ. Yet, I have this error. Could you please help resolve the same. Thanks and Regards, Ashwin

[@DIYGUYChris]

+ashwinmoi check the port number from the peripheral manager as shown in the video them make sure that u r using the right port in PLX-DAQ please tell me if it works or not :)

[@TheTamdy]

thank you very much, it works fine.

[@DIYGUYChris]

You are always welcome.

[@davidizquierdogomez]

just a bit annoying to download the files with all this pub etc etc but the app is very cool. Thanks

[@shahiraeleenabintisuhaidi4084]

why i cant download the source code?

[@DIYGUYChris]

Hello Sheera We've just apdated the link for the source code, just skip the ad and you will get the download link. Do not forget to subscribe to our channel for more awesome videos. Let us know if we can further assist you.

[@trishafernandes8445]

I have a small problem that I can't figure out. I'm using an esp8266 microcontroller and the DHT11 temperature & humidity sensor. I tried the same method as you did. I am able to get the data on excel but I have two problems: 1. I'm not able to store more than one sensor data in different columns (i.e. I want to print both humidity & temperature data but excel takes this as one value. eg. if temp =28, humidity = 40, the data is shown as = 2840.00 and it doesn't work if I add a 'space'. 2. I am not able to get the column names. Please help me with this. If you want to see my code, I can email it to you.

[@masaratech]

you can make use of the PC part of this video..

[@renedamgaard9604]

Hi would this program work, when i design my arduino code to display the measured values in the serial monitor? (Still Serial.print();) I'm also getting the warning that file is not compatible with the version of windows i'm running. The spreadsheet and help file is just shortcuts and the actual files are not found as long as the program is not installed... Can you helt me?

[@DIYGUYChris]

Hello Rene, As I understand, you want to use the code to display values on your serial monitor ! so its the same and it will work fine. About the file! which one are you talking about, and which windows version are you using?

[@renedamgaard9604]

I'm running Windows 7, tried setting the install file to compatible for windows 2003 SP1 - no sucess. i used the download of the .zip file in the description to download PLX-DAQ

[@DIYGUYChris]

On that video we were using win7 and as you see PLX-Daq is running with no problems

[@renedamgaard9604]

Okay how about 32 or 64 bit versions? Are both avaliable?

[@DIYGUYChris]

We are using 64 bit version

[@akshares128]

please help me to log temperature in PLX-DAQ my code is below const int sensor = A1; // Assigning analog pin A1 to variable 'sensor' float tempc; //variable to store temperature in degree Celsius float tempf; //variable to store temperature in Fahreinheit float vout; //temporary variable to hold sensor reading void setup() { pinMode(sensor, INPUT); // Configuring pin A1 as input Serial.begin(9600); } void loop() { vout = analogRead(sensor); vout = (vout * 500) / 1023; tempc = vout; // Storing value in Degree Celsius tempf = (vout * 1.8) + 32; // Converting to Fahrenheit Serial.print("in DegreeC="); Serial.print("\t"); Serial.print(tempc); Serial.println(); Serial.print("in Fahrenheit="); Serial.print("\t"); Serial.print(tempf); Serial.println(); delay(1000); //Delay of 1 second for ease of viewing } PLX-DAQ showing connected but no data logging.

[@apurvgupta8004]

after getting these values can we draw the graph of the data and find it's area??

[@DIYGUYChris]

after getting the data you turn off the connexion between your Arduino and the PLX-DAC and you start using the array stored in your Excel file the way you want

[@widyaparamitha65]

hey please help. i already connect it and the C icon already changed. but in my excel didn't show anything. i'm using excel 2013. please answer. thanks

[@DIYGUYChris]

you should activate macros in Excel 2013 ( i advice you to download and use Excel 2007 )

[@anbroic]

Great video. I have a question. Can you disable continuous data acquistion on PLX-DAQ. I just want it to send data to excel when a sensor goes high. I am currently using data streamer and it is acquisitioning every few milliseconds (I can edit this). Or is there a better way?

[@DIYGUYChris]

Update the code to suit your need, remove the delay and make the data transmission as an event

[@anbroic]

@@DIYGUYChris Thanks for the quick reply. I am new to PLX-Daq I will try that. Finger crossed I can get it to work

[@anbroic]

@@DIYGUYChris Sorry Chris is it in Arduino code I change to event driven or PLX-daq?

[@DIYGUYChris]

@@anbroic the change is in the Arduino code

[@davidizquierdogomez]

is there the same app for MAC?

[@basmaafify5344]

can i use Microsoft Excel2010!!

[@DIYGUYChris]

yes but you should be able to activate macros (we advice you to use Microsoft Excel 2007 to avoid any problem)

[@alhapidzteguhgumilar]

Please upload to Google drive, hard to download code

[@AhmedEssam-de4pp]

Thank you very much bro

[@DIYGUYChris]

+Ahmed Essam welcome ;)

[@AhmedEssam-de4pp]

+MEGA DAS i subscribed this great channel , keep going bro

[@DIYGUYChris]

thank you for supporting us :)

[@supongmenwalling6929]

how to add current date?

[@shraddhakshirsagar6630]

Sir...great video...where can i get code?

[@DIYGUYChris]

Hi Just check the video description section and there you will find the download link for the code

[@shraddhakshirsagar6630]

@@DIYGUYChristhanks ..but it gave me error...But i copied it from video...thanks a lot...i tried this from last month...but your one video gave hope

[@jamilibrahimsalh1801]

Can you see the conection of crcuit

[@DIYGUYChris]

Hello jamil ibrahim salh Sorry but I can't understand what you want to say !

[@thgzxal3074]

the link its broken.

[@carlosrubio6536]

How i make work with Arduino in 115200 Baud?

[@DIYGUYChris]

Hello Antonia! Configure the PLX-Daq baud rate to 115200 then configure your arduino serial baud rate over your code: " Serial.begin(115200); " Tell us if you have more questions!

[@carlosrubio6536]

PLX-DAQ dont have that rate, or i change(128000 to 115200) it in programmer mode in Excel?. Thanks for reply

[@teguhgumilar2713]

please upload code in google drive to make it easy to be downloaded.

[@espaciomaker]

thank you

[@DIYGUYChris]

You are welcome!

[@denislopesdesousa5125]

Boa tarde, estou querendo manda um comando do arduino para o PLX-DAQ para salva os dados, tipo CTRL + S. Tem possibilidade??

[@DIYGUYChris]

Hello Denis Could you please write your question in English!?

[@denislopesdesousa5125]

Sorry. I am wanting to send an arduino command to PLX-DAQ EXCEL(WINDOWS) to save the data, type CTRL + S. Is it possible ??

[@DIYGUYChris]

Hello Denis, this is better now we can understand you :) So what I understand that you want to make a control on the data transmission! I mean you want it to be send by an event that you make, like clicking on a button or something like that?

[@denislopesdesousa5125]

This can even be a button or automatic. I wanted the Arduino to send a command to PLX-DAQ automatic save. Is there a possibility? Thanks for the help :)

[@DIYGUYChris]

Actually the Arduino don't send instructions to PLX-Daq but it sends data, and the PLX-Daq is always waiting for data to come and when it comes then PlX place it into the Excel file, so if you want to stop PLX from uploading data just stop the Serial data transmission from your Arduino and if you want to give PLX-Daq the data just send it through the Serial port. I don't know if I gave you the desired answer or not!?

[@apoorvarampal8778]

i am getting a message, "this app can't run on your pc, to find a version of pc, check with a software publisher" so what should i do, i am using 64-bit original window. How can i use this software?

[@DIYGUYChris]

Hello apoorva, What Microsoft Excel version are you using!?

[@apoorvarampal8778]

microsoft excel 2007

[@DIYGUYChris]

Could you make a screenshot for the error message and post it here,

[@apoorvarampal8778]

this is the error

[@apoorvarampal8778]

can u send me your email id as i am not able to post it here

[@PatnaikUC]

Excellent! Thanks

[@DIYGUYChris]

+Patnaik UC you welcome :)

[@welleslytony1287]

Hi MEGA DAS, first of all im not sure if my explanation will be clear enough for you so bear with me please. I have an IMU sensor connected to the arduino which will produce 3 sets of data, the accelerometer values, gyro values and the magnetometer values. Now each of these data is represented with an x, y and z value, which means each sets has 3 columns of data. So on each row i will have 9 columns of data. And when i connect the PLX DAQ to the serial port it doesnt print anything but R is blinking. And im not sure how to configure this table of data. PLEASE HAALP

[@DIYGUYChris]

Hello Wellesly Tony, I've got the point you want to share, actually all what you need is creating the necessary labels for your data by changing the following instruction lines in the code that I provided in the description of the video : Change this : Serial.println("LABEL,Current time,Sensor value"); By : Serial.println("LABEL,Accelerometer X,Accelerometer Y,Accelerometer Z,Gyro X,Gyro Y,Gyro Z,Magnetometer X,Magnetometer Y,Magnetometer Z,"); Then when you want to send data to the appropriate cell just do this : Serial.print("DATA,"); // Now send data of Accelerometer variables Serial.print(Accelerometer_X); Serial.print(","); Serial.print(Accelerometer_Y); Serial.print(","); Serial.print(Accelerometer_Z); Serial.print(","); // Now send data of Gyro variables Serial.print(Gyro_X); Serial.print(","); Serial.print(Gyro_Y); Serial.print(","); Serial.print(Gyro_Z); Serial.print(","); // Now send data of Magnetometer variables Serial.print(Magnetometer_X); Serial.print(","); Serial.print(Magnetometer_Y); Serial.print(","); Serial.print(Magnetometer_Z); Serial.print(","); Note : about recieving data in PLX_daq make sure that you are configuring the same baudrate for both Arduino(Serial.begin(9600); )and PLX_daq. Let us know if we can further assist you.

[@welleslytony1287]

MEGA DAS omg youre a life saver thank you so much!

[@DIYGUYChris]

Happy to hear this from you Tony. You are welcome.

[@welleslytony1287]

Sorry but one more thing MEGA DAS, how do i get the excel to display elapsed time instead of time of day? cos what im getting in excel now is the time of day instead of time in minutes and seconds.

[@DIYGUYChris]

Hello Wellesly Sorry for the very late reply, what you are asking about is a pure Excel configuration so there is no need to include Arduino in this, but I can suggest to use the "millis ()" fuction of Arduino in order to get the elapsed time then send it to you Excel file Make a research about millis function Let us know if we can further assist you.

[@muhamadhaziq4839]

why i cant download the source code form that link,? tq

[@DIYGUYChris]

Hello Muhamad The download link is just updated so you can download the source code now. Do not forget to subscribe to our channel for more awesome videos. Let us know if we can further assist you.

[@muhamadhaziq4839]

Thank you sir, can i have your email sir? I want to ask some help.

[@DIYGUYChris]

Find our contacts through the description of our KZbin channel.

[@muhamadhaziq4839]

I've email you, I hope you can help me friends. Thank you

[@muhamadhaziq4839]

I've emailed to you sir. Thank you

[@brijitjo7900]

nothing is printing only R is blinking

[@vigneshwaransd2785]

I am also having this issue

[@InventionTherapy]

Was this hard to learn?

[@DIYGUYChris]

Hello Invention Therapy Well electronic developing and embedded system programming is not hard to learn but it depends on your will. Let us know if we can further assist you.

[@rafimarsidek3568]

the source cant be opened. please

[@DIYGUYChris]

Hello Rafi Sorry for the late reply, the source code link has been updated. Let us know if we can further assist you.

[@rs45888]

Hello DAS, thank you for the video.. but the source code cannot be downloaded again! It says blocked due to violation of rules..

[@sergejvogel6080]

can you help me, I do not know how to do it with the DHT22 Sensor :(

[@DIYGUYChris]

+Sergej Vogel the first thing to do with the DHT22 sensor is getting the value from it and it should be correctly done or you will not be satisfied by what you will get with PLX-daq ok so tell me if you already did that or not (to make me undestand how to help you ) ;)

[@sergejvogel6080]

Hello, I have a Temperature sensor DHT22 and a programm in Arduino software from this site: forum.arduino.cc/index.php?topic=168317.0 there they want to do the same like me my problem is that the PLX-DAQ shows no reaction. nothing....I dont know why ....the seriellmonitor on arduino sofware shows me that all is right, but on excel nothing.... I dont know what to do :(

[@sergejvogel6080]

I have Excel 2010 but without product key, maybe the problem is that version or that I dont have a product key

[@DIYGUYChris]

sorry to tell you this but the PLX-daq module that i posted don't run with Excel 2010 it works only with 2007 version ( try to download the 2007 version from internet and solve the problem ;) )

[@sergejvogel6080]

+MEGA DAS hey, i installed Excel 2007, I had PLX-DAQ from an other site: www.parallax.com/downloads/plx-daq but there stays I need Excel 2001, 2002 or Excel 2003 so I wanted to install from the site u posted. But it does not work. I installed it like u, but I cannot open it like u in 6:47....

[@goodthings1231]

office version?

[@DIYGUYChris]

Hello We are using Office 2007 in this project video and it is highly recommended to avoid any sort of marco problems. Let us know if we can further assist you. Do not forget to subscribe to our KZbin channel for more awesome videos.

[@hakim-cd8si]

audio na bikin ateul ceuli.

[@cyber2244]

doesnt work on window 10 though

[@DIYGUYChris]

+cyber2244 personally i avoid using windows 10 because most of the softwares doesn't work on it

[@LeirbagIII]

Can I export more than one data??

[@DIYGUYChris]

Hello Gabriel Sure you can do upload more than one data just the way I did in this video I've exported temperature and humidity data Let us know if we can further assist you.

[@LeirbagIII]

MEGA DAS, thank you for your support :)

[@LeirbagIII]

MEGA DAS, the downloaded RAR file only contains shotrcuts to the spredsheet, but no the fil itself. I can't use it :(

[@DIYGUYChris]

What do you mean by "fil itself"? If you want to change the columns labels you can do this through the code or just after getting the data from Arduino Let us know if we can further assist you.

[@LeirbagIII]

my bad. I meant "the file itself". I can't open the spreadsheet. A window says there is no such file.

[@salvatorebarbaro5862]

The download file only contains shortcuts and not the actual files. This video is useless without the necessary software. THIS IS A FAKE INFO . IT IS NOT NECESSARY TO USE THIS SOFTWARE TO SEND DATA FROM THE SERIAL PORT TO AN EXCEL SHEET!

[@Labol]

The link not work :-(

[@DIYGUYChris]

+Marc Bolduc try it again now and tell me if you still have the same problem

[@harrisg2778]

I cant open this program

[@ayoubleboss623]

You're french

[@DIYGUYChris]

Hello Ayoub 212 Non je ne suit pas françé ;) Let us know if we can further assist you. Do not forget to subscribe to our KZbin channel for more awesome videos.

[@babahzieriq6004]

Excel 2003 ?

[@DIYGUYChris]

Hello Babah, We used Microsoft Excel 2007 in this project

[@hieupham0811]

Your link for download is MALWARE !!!!!!!!!!!!!!!!!!!!

[@DIYGUYChris]

Hello! We don't post Malware here!! it's an afficial and professional KZbin Channel, just a link to an Adf.ly website where you have to wait for 5 seconds and then you it will automatically take you to the mediafire link for downloading. Feel free to tell us if there is any problem with the link. Regards

[@hieupham0811]

Ok. Sorry you I want to say that your file in link for download is Malware. when I double click, it auto setup and send many virus to my computer. You should check this file before post!

[@afiqaimanrosli5047]

hello sir. i'm using excel 2007 with windows 10. But, i'm having a little problem. When, i click connect on plx-daq it says that 'StampDAQ could not connect. Please help me with this. tq '

[@DIYGUYChris]

Hello afiq aiman aiman From what you said, it is a macro security level so just try to configure the Excel macro security level to LOW and then if the problem remain the same then probably it is due to the Excel 64 bit version that you use since PLX-DAQ play its macro with an office 32 bits (not always) I just advice you to install a parallel desktop with windows 7 and Office 2007 and you will get no problems. Let us know if we can further assist you. And do not forget to subscribe to our channel for more awesome videos.

[@afiqaimanrosli5047]

MEGA DAS thank you for the response sir. It’s very kind of you. Really appreciate it!