Hi,
I would like to seek help if anyone can help me to create a pageant judging criteria. Because we will be having a pageant this coming January 2025 and we want it to be automated rather than traditional papers and manual computation of results. This time it will be output in google sheet after the judge press their scores in numeric keypad it will appear in the google sheet based on the criteria, it would really help a lot if someone already done this before.
Thank you
Maybe Arduino can help with recording the scores, but how can it help with the criteria?
Yes the scores only needed to be input by the judges using the keypads. For the criteria we I will include it to the code so judges can see it in the lcd screen..
Ah, so the Arduino will display each criteria, as text, on a screen and the judges will enter their scores against each one?
Will the criteria be held as text in the Google sheet? Or will they not change, so they can be hard-coded in the Arduino sketch?
Putting the detail of the data aside, it sounds like you will need a keypad, 3x3 or 3x4, and perhaps a 16x2 character LCD. These can be wired to the Arduino as shown in many projects. 7 or 8 pins will be needed for the keypad and a further 6 for the LCD, although it might be possible to share some pins between the keypad and LCD.
The choice of Arduino model is also important. In order to be able to connect to Google sheets, the Arduino will require internet access via a LAN connection which could be either WiFi or Ethernet cable.
My favourite Arduino compatible board with WiFi is the Wemos D1 mini. However, this has only a small number of pins, so I would probably connect the LCD and keypad via i2c adapters.
Yes the criteria will be displayed as a text and the judges will only input their scores.
Yes the criteria is also held in google sheet like the rfid attendance system once you scan rfid it will be recorded in the google sheet
So RFID scanners will also be needed for security to identify the judges?
No rfid scanner needed only the numeric keypad is needed for the scores inputs
So how will the RFID tags be read?
Is the LCD screen also not needed? How will the criteria be displayed to the judges?
Rfid is not needed to the project.
LCD is included in the project for the judges can see the criteria
In post #7 you mentioned scanning RFID tags and recording them in a Google sheet, I assume togehter with the scores. Now you are saying no RFID. This is confusing!
Please try to be consistent in the way you describe the project, and take care not to introduce ideas that are not needed. Otherwise things will get very confused!
Oh, sorry for that I just make an example embodiment n how it will be recorded using google sheet. But RFID tag is not really included in the project
Thank you. All I need now is the code to be use in the proect.Is it also possible to use ESP8266 module for the wifi connection?
Indeed!
Start simple, connecting perhaps only the LCD and it's adapter to the D1 mini and get an example sketch working. Then add the keypad and adapter and, again, get an example sketch working.
After that comes the fun of connecting the D1 mini over WiFi/internet to Google docs. I have never done this, but I'm sure other forum members will have done so.
Yes
You may also find something useful here: Project now uploads to Google Sheet monthly for a year!
Thank you. Do you have any idea on how I can make a code for this. I watch some projects to have an idea on coding but what I only see are Voting machine.
Don't expect that the perfect code for your project is out there somewhere. You could search for the rest of your life and not find it. The code you need is unique because your design and choice of components is unique.
You may find parts of what you need in other code. Example sketches that are in the IDE or that come with useful libraries are good places to look. But in order to use code from examples and other web sites, you need to understand each piece of code. If you simply copy & paste them without understanding, it will not work.
Follow my advice from post #16. This will help you know that each component is working correctly, and that you can successfully read/write to Google sheets. Keep all these separate sketches because you will need to use them, or refer to them again later.
Next, make a "story board" showing each step of how a judge will interact with the LCD/keypad, what they will see and how they will respond.
Thank you very much. It will help very much..
Here is Random Nerds Tutorial for loggging data to Google Sheets:
ESP32 Datalogging to Google Sheets (using Google Service Account)
William
