ฝัง
- เผยแพร่เมื่อ 11 ม.ค. 2019
- Arduino | Arduino to excel Communication (PLX-DAQ) | Combination with RFID RC522. In this project video i use Microsoft Office Excel 2007.
Arduino to excel Communication (PLX-DAQ) Combine with RFID RC522 Project : drive.google.com/open?id=1hCJ...
Arduino and RFID RC522 Read Tags : • Arduino | How to use A...
***********************************************
Thanks for watching & don't forget to like, comment and Subscribe...
***********************************************
For other video tutorials on this channel, please see this playlist:
- Basic4Android (B4A) Tutorials : • Basic4Android (B4A) | ...
- Electronics Tutorials : • 3 LED Flip Flop
- Arduino Tutorials : • Arduino | Scrolling Te...
- Great Cow Basic Tutorials : • Great Cow BASIC with A...
- Bascom Avr Tutorials : • Bascom Avr | How to Se...
- VB .NET Tutorials : • Visual Basic .NET | ...
***********************************************
Arduino IDE : www.arduino.cc/en/Main/Software
***********************************************
Download Fritzing : fritzing.org/home/
***********************************************
Download PLX-DAQ version 2 : forum.arduino.cc/index.php?top...
Download PLX-DAQ version 2.11 : forum.arduino.cc/index.php?top...
***********************************************
Arduino Uno image source : pixabay.com/en/arduino-arduin...
Excel image source : www.iconfinder.com/icons/2993...
***********************************************
Music Background :
Song: Ikson - Do It (Vlog No Copyright Music)
Music promoted by Vlog No Copyright Music.
Video Link: • Video
Wake Up by MBB / mbbofficial
Creative Commons - Attribution-ShareAlike 3.0 Unported - CC BY-SA 3.0
creativecommons.org/licenses/...
Music promoted by Audio Library • Wake Up - MBB (No Copy...
Spring by Ikson / ikson
Music promoted by Audio Library • Spring - Ikson (No Cop...
*********************************************** - วิทยาศาสตร์และเทคโนโลยี
Thanks a lottt....Was looking for this for sooo long.💯💯🙏🙏
You're welcome 🙂.
very good
Excellent 👍
Thank You🙂.
thank you for tutorial, hope u can teach and help many peoples..
You are welcome :-)
thank you for this video. you saved my day
you are welcome :-)
Why is it that when I uploaded it 7:01 it says "MFRC522.h No such file or directory" will goes? Please help me, Asap
sir insted of RFID tag i want to use fingerprint sensor to take the attendace... so pls can you tell me the what changes should i do in the coding part...
Thanks, it works 100%
You're welcome :-)
How can I add code to be displayed in lcd i2c and how to write student name??? Reply quick.
Muchas gracias excelente video tutorial
De nada :-)
i can't find the Only_Read _UID even though i see the video description, please help, asap...
Thanks, and more thanks, and more thanks!!!!
You're welcome :-)
merci b
i have a question sir, can you add a name and address category in the row and it will show it to the excel?
thank you so much for this video i am anable to find the solution for this thank you so much sir
You're welcome :-)
Bro, how about Fingerprint Sensor to PLX-DAQ?
Hi sir In this data is getting appended on the same cell 1 after another when u show the RFID card....How can i do a overwrite and display the card detail in the same cell each time i show a card......
May i know what is the circuit connections of this project when i combine RFID and Fingerprint which means two Identification before the attendance being recorded in excel and what is the source code pls tq (doing this for my final year project)
how to keep the data without PLX-DAQ reset it when we change to new port sir (without closing the excel)?
Hey,
How I can do this for circuit
Arduino Uno
RFID RC 522
Buzzer
Servomoteur
Led green led red
Please hope me !
i follow the mechanics but it says error compling for board arduino/genuino uno how to fix this??
I have a problem, when i can't add more tags, just recognize 2, I tried add 2 more, but just recognize the first two. Can u help me pls?
Kalo mw mengubah ID menjadi nama di Excelnya gimana caranya ya Pak? Apa perlu ubah Di RFID Write dulu?
Hi..
This code is working fine..
But there is 1 more requirement , if i want to add some more details about the scanned card, like for a specific card i want to save the extra information like class, batch etc. And the saved information must be write in the excel format as with the date,time and the RFIDs .
I'm no expert in MS Excel. I don't know if MS Excel can do that. Because Arduino Board only sends data and MS Excel processes it. Maybe you can ask this in MS Excel forums or to someone who is an expert in MS Excel.
Really good!!
Can you put this working with a multireader?
Thanks.
Thank you :-)
What do you mean by "multireader" ?
@@utehstr In the MFRC522 library we have an example called "ReadUidMultireader",
this uses 2 or more tag readers.. so my question is if this working with a 2 or more readers.
Thanks.
Do we have to buy microsoft office
bro please mention the connections of rfid and Arduino please 🙏😢
Bang buat proyek RFID attendance dengan perecord sensor Suhu MLX dong. simpannya ke Google sheet atau excel saja : Terimakasih
Wow ! great tut man thx.İ am trying to get distance from HC-sr04 sensor.i can see the values when i choose to display direct debug but excel is not writing them down on the colums.Do you have any idea why.thx in advance.
Thank you :-)
Sorry I don't understand what you mean, can you explain in more detail.
@@utehstr problem is solved mate . It was all about modifying the arduino sketch cheers
bisa gak input data dari rfid masuk ke excel ??
13 to gnd,12 to sck, 11 to miso,10 to mosi,9 to sda
thanks for useful video!!🤗
I have question ‘no way for control writing speed for excel?’
for your information,
I built a system writing down data instantly and referenced your video however there was a problem that data can b written 2 second cycle time only how can get this speed more faster??
You are welcome :-)
Try increasing the baud rate
I already had tried that from9600 to 11300 baud on the code of arduino but it didnt work.. so I tried correct baud set on header which I download at github, I cannot sure I corrected right way though😂
In conclusion, it didnt work but there is chance that i made it incorrectly.
In my point of view, I should find out the way to control writing speed to excel, not data bus speed isnt it?
@@yh1217 If you change the baud rate on the Arduino code you also have to change the baud rate on PLX. Baud Rate must be the same value between Arduino code and PLX.
I did change baud rate on plx-daq as well but it still wrote every 2seconds..
@@yh1217 Can you show your code here ? or send to this email channel.
we cant use Microsoft Office Excel 2010
How about Lcd module
how to change the card number into someone's name
ok
not able to connect buzzer also
Is there a way for the arduino to be in a stand alone project box and not connected to a computer but still transfer data to excel?
Do you mean by wireless or something else ? Can you explain in more detail.
Yes can the arduino be powered by a powersource and not be hooked up to a computer but transfer the data wirelessly into excel?
Why is it that when I uploaded it 7:01 it says "MFRC522.h No such file or directory" will goes? Please help me, Asap
Bro what should l have to do to read RFID names from the EXCEL sheet to arduino for further programming ???
I do not understand what do you mean. Can you explain in more detail ?
@@utehstr, i want to analyse the data which are fed in excel sheet ,for that purpose i need to get the data back to the arduino ide .. especially i want to analyse a particular column of a excel sheet.
Ok, it seems like i understand what you mean, i'm not so very good at Excel, my knowledge is a bit in Excel and also I don't really learn more about this PLX-DAQ communication with Arduino. So I'm sorry I can't help you. Maybe you can ask this in the Arduino forum, there are many more skilled people who can answer your questions.
please please please mention the connections it's urgent
sir, is it possible that i can monitor the late attendance? for example fix time is 9:00 to 9:20.
9:21 will be late. is there any way to figure out in the system that 9:21 is already late.
To be honest I am not very good at using Microsoft Excel, but it seems like it can be done. Maybe you can ask this in the ms excel forum, or you can also ask this in the Arduino forum, because if I'm not mistaken the makers of this system are there.
@@utehstr okay sir, thankyou very much for your reply.
@@jamesonepis-an6722 You are welcome :-)
i can't find the Only_Read _UID even though i see the video description, please help, asap...
Is Mac ok with it? Since I can't find the port number in Mac.
I don't know about that because I have never tried this on Mac. Try asking this in the Arduino forum, because if I'm not mistaken the builder of this application is there.
friend a question, for a company how many people can I add to the database?
Sorry I don't understand what you mean, can you explain in more detail.
@@utehstr I am doing a project for my company, and I need to make a database whose people have access to activate a dispenser. as a restriction each person has access each month and hence my question how many people can I add since in my company there are more than 200 people
Hey great job. I would like to ask you about VBA code . I have connected everything and works great but i want to change the code if you can help me.
How to code vba in Excel to count from the latest column after restarting or disconnecting usb? Becuase now when a usb disconnects or we close excel,, the RFID tags starts to write from column 1. I want to start from the latest blank column. Thank you and appreciate your work.
How many times, that tools ccan record the data?
Sorry I don't understand your question, can you ask more specifically?
hi guys,i have a question : when i uses PLX-DAQ ,i must always connect arduino with PC??
Yes, when you use PLX-DAQ your computer must always be connected to Arduino
tuan, bagaimana caranya untuk kita connect database excel ke vb?
Lihat disini : th-cam.com/video/bToTJ1xbCEQ/w-d-xo.html
Why is it that when I uploaded it 7:01 it says "MFRC522.h No such file or directory" will goes? Please help me, Asap
Have you installed the MFRC522 library ?
Where to install that one?
@@Indomitable_official Look here : th-cam.com/video/hJhnAZ-oDN0/w-d-xo.html
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
the circuit, please!!!!!!!
i can't find the Only_Read _UID even though i see the video description, please help, asap....
Only_Read _UID is available in the description of this video : th-cam.com/video/hJhnAZ-oDN0/w-d-xo.html
how about Fingerprint Sensor to PLX-DAQ?
Do you already know the answer because i need that too thanks!
Sir Uteh Str how to apply this in VB
See here: th-cam.com/video/EQpflovuJgw/w-d-xo.html
Why is it that when I uploaded it 7:01 it says "MFRC522.h No such file or directory" will goes? Please help me, Asap
Bhai isko LCD ke sth connect karke video mil sakta hai
Nahi
Hey, after i upload the codes, and was about to connect the PLX-DAQ, there was an error saying "The system cannot find the file specified. Aborting!" and now i'm so confuse how it works, what do you think could be the problem? And please help me solve it, asap. Thanks
This error is usually shown when the COM port is busy due to another application. Might be that you have:
--the SerialMonitor windows open from ArduinoIDE?
--Or you are uploading new software to your Arduino while already clicking "Connect"?
--Or you haven't closed PLX DAQ correctly (e.g., due to an Excel crash) and the connection is still open from previous times? In that case: just disconnect your Arduino from the power source, wait a few seconds and plug it in again (or pull USB cable from PC and put back it)
From the Arduino Forum, see here: forum.arduino.cc/index.php?topic=437398.150
@@utehstr Thanks for the said solutions, but after i tried all the solutions above, it still ended with the same error. I dont know what to do now :(
@@utehstr [update] ITS ORKING NOOOOOW, THANK YOU SO MUCH
You are welcome :-)
@@utehstr hmm can i have a favor? Im just new n programming so its so confusing for me, can you teach me how to put names in ID? If u got what i mean... i appreciate any answer, thanks
can we use other inputs besides using RFID RC522 ?
Of course, if you look at this video in full you will see me sending random data values to Excel.
Bisa gak ya kalo data di Excel disave terus diterusin besok harinya lagi? Saya coba tapi data lama tertindih data baru. Mohon bantuannya kalo bisa
saya belum pernah coba yang seperti itu, tapi nanti akan saya coba dan kasi tau caranya kalau berhasil.
Why is it that when I uploaded it 7:01 it says "MFRC522.h No such file or directory" will goes? Please help me, Asap
Sir Where do I find Only_Read_UID files?TIA
Look at the video description
Thanks!
@@jerickmanlangit6653 You are welcome
Why is it that when I uploaded it 7:01 it says "MFRC522.h No such file or directory" will goes? Please help me, Asap
sry but can i make a button to disable receiving data and how ?
Do you mean to make a button on Arduino ?
@@utehstr no in excel using macro can I disable receiving data?!
@@abahoub You can use the connect and disconnect buttons to enable and disable data reception. For more information you can ask this in the Arduino forum because if I'm not mistaken the builder of this application is there.
@@utehstr ok thx man
@@abahoub You are welcome :-)
Please Code Here
Please help me 🙏🏻🙏🏻
A
how to download google drive? because it can't be opened
The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.
or wattapp no