Arduino meets Excel ( PLX-DAQ )

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ธ.ค. 2015
  • $2 for 2-Layer PCBs & $5 for 4-Layer PCBs: jlcpcb.com/PCH
    Start Altium designer FREE TRIAL : www.altium.com/yt/diyguychris
    ★☆★ 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/mega-das
    ★☆★ FOLLOW ME BELOW: ★☆★
    Instructables: www.instructables.com/member/M...
    Hackaday : hackaday.io/MegaDAS
    Facebook : MEG.DAS1/?fr...
    Twitter : / megadas1
    Hackster : www.hackster.io/mega-das
    Keywords:
    Microsoft Excel
    Arduino board
    Serial
    TX/RX
    PLX -daq
    data logging
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 230

  • @davidbristoll195
    @davidbristoll195 7 ปีที่แล้ว +2

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

  • @Aisongs4You
    @Aisongs4You 5 ปีที่แล้ว +2

    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

  • @haupham7379
    @haupham7379 8 ปีที่แล้ว +1

    Great! Thank you very much! :)

  • @mandelbro777
    @mandelbro777 4 ปีที่แล้ว

    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 :)

  • @thysavrin
    @thysavrin 2 ปีที่แล้ว +1

    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.

  • @victorg8815
    @victorg8815 7 ปีที่แล้ว +1

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

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

  • @jaredgibson3785
    @jaredgibson3785 5 ปีที่แล้ว +2

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

  • @mufideskanurcahya5081
    @mufideskanurcahya5081 5 ปีที่แล้ว

    Thanks you. This video is very good👍

  • @makerplot-j
    @makerplot-j 11 หลายเดือนก่อน

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

  • @nurjamahashiabdulle1711
    @nurjamahashiabdulle1711 3 ปีที่แล้ว

    Very fantastic oen!

  • @SanjeetKumar-qd7fy
    @SanjeetKumar-qd7fy 7 ปีที่แล้ว +1

    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
      @DIYGUYChris  7 ปีที่แล้ว

      Make the 2007 version the default software for Excel files

    • @SanjeetKumar-qd7fy
      @SanjeetKumar-qd7fy 7 ปีที่แล้ว +1

      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
      @DIYGUYChris  7 ปีที่แล้ว

      Just follow this video :)
      th-cam.com/video/IcufzuogY3M/w-d-xo.html

  • @effieeli5750
    @effieeli5750 6 ปีที่แล้ว

    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..

  • @mathid3012
    @mathid3012 3 ปีที่แล้ว

    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

  • @mauricioxavier6927
    @mauricioxavier6927 7 ปีที่แล้ว +4

    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
      @raulbarreto6221 7 ปีที่แล้ว

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

  • @pragyapatel7730
    @pragyapatel7730 6 ปีที่แล้ว

    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?

  • @youssefyammine1689
    @youssefyammine1689 4 ปีที่แล้ว +1

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

  • @ravelonjatovoherman1896
    @ravelonjatovoherman1896 ปีที่แล้ว

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

  • @trishafernandes8445
    @trishafernandes8445 6 ปีที่แล้ว

    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
      @masaratech 5 ปีที่แล้ว

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

  • @anbroic
    @anbroic 2 ปีที่แล้ว

    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
      @DIYGUYChris  2 ปีที่แล้ว

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

    • @anbroic
      @anbroic 2 ปีที่แล้ว

      @@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
      @anbroic 2 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  2 ปีที่แล้ว +1

      @@anbroic the change is in the Arduino code

  • @AhmedEssam-de4pp
    @AhmedEssam-de4pp 8 ปีที่แล้ว +1

    Thank you very much bro

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว +1

      +Ahmed Essam welcome ;)

    • @AhmedEssam-de4pp
      @AhmedEssam-de4pp 8 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว +1

      thank you for supporting us :)

  • @renedamgaard9604
    @renedamgaard9604 6 ปีที่แล้ว +1

    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
      @DIYGUYChris  6 ปีที่แล้ว

      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
      @renedamgaard9604 6 ปีที่แล้ว

      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
      @DIYGUYChris  6 ปีที่แล้ว

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

    • @renedamgaard9604
      @renedamgaard9604 6 ปีที่แล้ว +2

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

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

      We are using 64 bit version

  • @aryanjain9877
    @aryanjain9877 6 ปีที่แล้ว

    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.

  • @TheTamdy
    @TheTamdy 7 ปีที่แล้ว

    thank you very much, it works fine.

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว +1

      You are always welcome.

  • @harshvardhanmore4729
    @harshvardhanmore4729 6 ปีที่แล้ว

    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

  • @reynoldvallecer1065
    @reynoldvallecer1065 8 ปีที่แล้ว +1

    Thank you! help me alot

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว

      +Reynold Vallecer welcome :)

  • @vigneshwaransd2785
    @vigneshwaransd2785 3 ปีที่แล้ว

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

  • @idansagiv1920
    @idansagiv1920 7 ปีที่แล้ว +1

    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
      @DIYGUYChris  7 ปีที่แล้ว +1

      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
      @idansagiv1920 7 ปีที่แล้ว +1

      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
      @DIYGUYChris  7 ปีที่แล้ว

      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

  • @joseabraham396
    @joseabraham396 7 ปีที่แล้ว +1

    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
      @DIYGUYChris  7 ปีที่แล้ว

      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.

  • @wardimanulabrar8199
    @wardimanulabrar8199 6 ปีที่แล้ว

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

  • @ftk8644
    @ftk8644 5 ปีที่แล้ว +1

    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
      @DIYGUYChris  5 ปีที่แล้ว

      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 TH-cam channel for more awesome videos.

    • @nursakinah8561
      @nursakinah8561 5 ปีที่แล้ว

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

    • @ftk8644
      @ftk8644 5 ปีที่แล้ว

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

  • @arslanlatif8625
    @arslanlatif8625 7 ปีที่แล้ว +1

    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
      @DIYGUYChris  7 ปีที่แล้ว

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

  • @redwin1
    @redwin1 4 ปีที่แล้ว

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

  • @afiqaimanrosli5047
    @afiqaimanrosli5047 6 ปีที่แล้ว +1

    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
      @DIYGUYChris  6 ปีที่แล้ว

      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
      @afiqaimanrosli5047 6 ปีที่แล้ว

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

  • @2808drw
    @2808drw ปีที่แล้ว

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

  • @ranggamasli8974
    @ranggamasli8974 7 ปีที่แล้ว +1

    just read the manual, PLX-DAQ help file

  • @sergejvogel6080
    @sergejvogel6080 8 ปีที่แล้ว

    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
      @DIYGUYChris  8 ปีที่แล้ว

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

  • @davidizquierdogomez
    @davidizquierdogomez 5 ปีที่แล้ว

    is there the same app for MAC?

  • @theatdu9163
    @theatdu9163 4 ปีที่แล้ว

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

  • @quantum_realiti1585
    @quantum_realiti1585 7 ปีที่แล้ว +1

    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
      @DIYGUYChris  7 ปีที่แล้ว +1

      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
    @MTerkait 7 ปีที่แล้ว +1

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      Hello Mohammed,
      Sorry! no idea about this :/

  • @apurvgupta8004
    @apurvgupta8004 7 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      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

  • @salahmohamed7799
    @salahmohamed7799 8 ปีที่แล้ว +9

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

  • @sanjeetkumar-yy9fq
    @sanjeetkumar-yy9fq 7 ปีที่แล้ว

    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
      @DIYGUYChris  7 ปีที่แล้ว

      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.

  • @PatnaikUC
    @PatnaikUC 8 ปีที่แล้ว

    Excellent! Thanks

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว

      +Patnaik UC you welcome :)

  • @user-nz6ph1qo1m
    @user-nz6ph1qo1m 5 ปีที่แล้ว +1

    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
      @DIYGUYChris  5 ปีที่แล้ว

      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 ourTH-cam channel for more awesome videos.

  • @widyaparamitha65
    @widyaparamitha65 8 ปีที่แล้ว

    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
      @DIYGUYChris  8 ปีที่แล้ว +1

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

  • @espaciomaker
    @espaciomaker 7 ปีที่แล้ว +1

    thank you

  • @keby1mhr1
    @keby1mhr1 7 ปีที่แล้ว +1

    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
      @DIYGUYChris  7 ปีที่แล้ว

      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
      @keby1mhr1 7 ปีที่แล้ว

      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
      @DIYGUYChris  7 ปีที่แล้ว

      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"!

  • @SanjeetKumar-qd7fy
    @SanjeetKumar-qd7fy 7 ปีที่แล้ว +1

    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
      @DIYGUYChris  7 ปีที่แล้ว

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

    • @SanjeetKumar-qd7fy
      @SanjeetKumar-qd7fy 7 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      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.

  • @devilboii96
    @devilboii96 7 ปีที่แล้ว

    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
      @DIYGUYChris  7 ปีที่แล้ว

      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
      @devilboii96 7 ปีที่แล้ว +1

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

  • @welleslytony1287
    @welleslytony1287 6 ปีที่แล้ว

    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
      @DIYGUYChris  6 ปีที่แล้ว +2

      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
      @welleslytony1287 6 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

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

    • @welleslytony1287
      @welleslytony1287 6 ปีที่แล้ว

      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
      @DIYGUYChris  6 ปีที่แล้ว

      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.

  • @MikesPikes
    @MikesPikes 5 ปีที่แล้ว +1

    Is there an option without the peppy music?

  • @pvravi478
    @pvravi478 4 ปีที่แล้ว

    Will the PLX DAQ software work for MICROSOFT EXCEL 2016

    • @DIYGUYChris
      @DIYGUYChris  4 ปีที่แล้ว

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

  • @piece_cr
    @piece_cr ปีที่แล้ว

    i like you video thanks link plx-dax

  • @denislopesdesousa5125
    @denislopesdesousa5125 7 ปีที่แล้ว +1

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว +1

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

    • @denislopesdesousa5125
      @denislopesdesousa5125 7 ปีที่แล้ว +1

      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
      @DIYGUYChris  7 ปีที่แล้ว +1

      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
      @denislopesdesousa5125 7 ปีที่แล้ว

      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
      @DIYGUYChris  7 ปีที่แล้ว +1

      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!?

  • @miteshnaik9886
    @miteshnaik9886 8 ปีที่แล้ว +1

    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
      @DIYGUYChris  8 ปีที่แล้ว

      +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
      @amirulhadafi7071 8 ปีที่แล้ว

      +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
      @DIYGUYChris  8 ปีที่แล้ว

      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
      @amirulhadafi7071 8 ปีที่แล้ว

      +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
      @DIYGUYChris  8 ปีที่แล้ว

      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 :)

  • @rohanpawar4278
    @rohanpawar4278 7 ปีที่แล้ว +10

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

    • @MTerkait
      @MTerkait 7 ปีที่แล้ว +1

      same here

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      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
      @MTerkait 7 ปีที่แล้ว +1

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

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

    • @vigneshwaransd2785
      @vigneshwaransd2785 3 ปีที่แล้ว

      I have same problem how to solve

  • @ashwinmoi
    @ashwinmoi 8 ปีที่แล้ว

    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
      @DIYGUYChris  8 ปีที่แล้ว

      +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 :)

  • @nielslarsen1094
    @nielslarsen1094 6 ปีที่แล้ว

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

  • @supongmenwalling6929
    @supongmenwalling6929 5 ปีที่แล้ว

    how to add current date?

  • @teguhgumilar2713
    @teguhgumilar2713 4 ปีที่แล้ว

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

  • @visionstills3700
    @visionstills3700 7 ปีที่แล้ว +21

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว +1

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

    • @ddx30
      @ddx30 6 ปีที่แล้ว +2

      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
      @MrGdangles1 6 ปีที่แล้ว +1

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

    • @DracMastah
      @DracMastah 5 ปีที่แล้ว +1

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

  • @apoorvarampal8778
    @apoorvarampal8778 7 ปีที่แล้ว +1

    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
      @DIYGUYChris  7 ปีที่แล้ว

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

    • @apoorvarampal8778
      @apoorvarampal8778 7 ปีที่แล้ว +1

      microsoft excel 2007

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

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

    • @apoorvarampal8778
      @apoorvarampal8778 7 ปีที่แล้ว +1

      this is the error

    • @apoorvarampal8778
      @apoorvarampal8778 7 ปีที่แล้ว

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

  • @alhapidzteguhgumilar
    @alhapidzteguhgumilar 4 ปีที่แล้ว

    Please upload to Google drive, hard to download code

  • @boruizhan5112
    @boruizhan5112 8 ปีที่แล้ว

    I connect it to the right port, and the C icon is changed to greed. But my excel didn't show anything. I am using a Accelerometer to be the sensor.

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว

      you are using Microsoft Excel 2007 ?

    • @boruizhan5112
      @boruizhan5112 8 ปีที่แล้ว

      I am using windows 10, Is that the reason I cannot use that?

  • @michaellunt1638
    @michaellunt1638 3 ปีที่แล้ว

    Video is nice, links are blocked as malicious intrusion.

  • @absoftech5180
    @absoftech5180 7 ปีที่แล้ว +1

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      Hello!
      Try it with Microsoft Excel 2007

  • @AtlantaTerry
    @AtlantaTerry 5 ปีที่แล้ว +1

    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 TH-cam discussing "pop" filters.

  • @thgzxal3074
    @thgzxal3074 3 ปีที่แล้ว

    the link its broken.

  • @davidizquierdogomez
    @davidizquierdogomez 5 ปีที่แล้ว

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

  • @dave-in-nj9393
    @dave-in-nj9393 5 ปีที่แล้ว

    I really wish TH-cam would add a second volume button for horrible background music.

  • @hakim-cd8si
    @hakim-cd8si 4 ปีที่แล้ว

    audio na bikin ateul ceuli.

  • @jamilibrahimsalh1801
    @jamilibrahimsalh1801 6 ปีที่แล้ว +1

    Can you see the conection of crcuit

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

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

  • @carlosrubio6536
    @carlosrubio6536 7 ปีที่แล้ว +1

    How i make work with Arduino in 115200 Baud?

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      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
      @carlosrubio6536 7 ปีที่แล้ว

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

  • @shahiraeleenabintisuhaidi4084
    @shahiraeleenabintisuhaidi4084 6 ปีที่แล้ว +2

    why i cant download the source code?

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

      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.

  • @shraddhakshirsagar6630
    @shraddhakshirsagar6630 4 ปีที่แล้ว +1

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

    • @DIYGUYChris
      @DIYGUYChris  4 ปีที่แล้ว

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

    • @shraddhakshirsagar6630
      @shraddhakshirsagar6630 4 ปีที่แล้ว

      @@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

  • @basmaafify5344
    @basmaafify5344 8 ปีที่แล้ว +1

    can i use Microsoft Excel2010!!

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว +2

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

  • @kumaravelraju9362
    @kumaravelraju9362 5 ปีที่แล้ว

    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.

  • @sergejvogel6080
    @sergejvogel6080 8 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว

      +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
      @sergejvogel6080 8 ปีที่แล้ว

      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
      @sergejvogel6080 8 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว

      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
      @sergejvogel6080 8 ปีที่แล้ว

      +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....

  • @muhamadhaziq4839
    @muhamadhaziq4839 6 ปีที่แล้ว +1

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

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

      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
      @muhamadhaziq4839 6 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

      Find our contacts through the description of our TH-cam channel.

    • @muhamadhaziq4839
      @muhamadhaziq4839 6 ปีที่แล้ว

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

    • @muhamadhaziq4839
      @muhamadhaziq4839 6 ปีที่แล้ว

      I've emailed to you sir. Thank you

  • @rafimarsidek3568
    @rafimarsidek3568 6 ปีที่แล้ว +1

    the source cant be opened. please

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

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

    • @rs45888
      @rs45888 6 ปีที่แล้ว

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

  • @rezanejadzare
    @rezanejadzare 4 ปีที่แล้ว

    unfortunately, it can not run in windows10

  • @LeirbagIII
    @LeirbagIII 6 ปีที่แล้ว

    Can I export more than one data??

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

      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
      @LeirbagIII 6 ปีที่แล้ว

      MEGA DAS, thank you for your support :)

    • @LeirbagIII
      @LeirbagIII 6 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  6 ปีที่แล้ว

      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
      @LeirbagIII 6 ปีที่แล้ว

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

  • @goodthings1231
    @goodthings1231 5 ปีที่แล้ว +1

    office version?

    • @DIYGUYChris
      @DIYGUYChris  5 ปีที่แล้ว

      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 TH-cam channel for more awesome videos.

  • @brijitjo7900
    @brijitjo7900 6 ปีที่แล้ว +1

    nothing is printing only R is blinking

  • @InventionTherapy
    @InventionTherapy 7 ปีที่แล้ว

    Was this hard to learn?

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      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.

  • @farad37
    @farad37 6 ปีที่แล้ว +1

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

  • @Labol
    @Labol 8 ปีที่แล้ว

    The link not work :-(

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว +1

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

  • @cyber2244
    @cyber2244 8 ปีที่แล้ว

    doesnt work on window 10 though

    • @DIYGUYChris
      @DIYGUYChris  8 ปีที่แล้ว

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

  • @harrisg2778
    @harrisg2778 5 ปีที่แล้ว +1

    I cant open this program

  • @babahzieriq6004
    @babahzieriq6004 7 ปีที่แล้ว

    Excel 2003 ?

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      Hello Babah,
      We used Microsoft Excel 2007 in this project

  • @ayoubleboss623
    @ayoubleboss623 5 ปีที่แล้ว +1

    You're french

    • @DIYGUYChris
      @DIYGUYChris  5 ปีที่แล้ว

      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 TH-cam channel for more awesome videos.

  • @salvatorebarbaro5862
    @salvatorebarbaro5862 5 ปีที่แล้ว

    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!

  • @hieupham0811
    @hieupham0811 7 ปีที่แล้ว

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

    • @DIYGUYChris
      @DIYGUYChris  7 ปีที่แล้ว

      Hello!
      We don't post Malware here!! it's an afficial and professional TH-cam 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
      @hieupham0811 7 ปีที่แล้ว

      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!