Hi Everyone
This is my first time using an Arduino and need some help.
Im looking to do an access control system for a parking lot using QR code. The QR code is read by a camera and the text is than put into "cell A1" on excel spreadsheet where if the QR code is recognized against the database it will open an electric sliding gate.
I was thinking of wiring up the hand held 433Mhz remote that the security guard carries to the relay to open the gate.
(seems like the easiest option)?
The QR code will be generated and printed on a 'Receipt' in the office for the driver to show at the gate for access.
This QR code has an expiry date which will be input into the spreadsheet upon printing of the receipt.
The QR code database will be kept in the excel spreadsheet for easy adding and deleting.
I haven't found any projects done this way and it might not be the most efficient but we are comfortable with using excel as data capturing and processing from there is quite easy.
Is there any way to have excel trigger the relay in order to open the gate this way?
If anyone has code that I can use or any suggestions on what would work best, please feel free to comment.
Thanks in advance.
Wesley