1. Prepare data visualisation using google sheets
Every data submitted will be recorded in google sheets
Generate the visualisation using the feature inside google sheet
2. Prepare google script to register new data
In source code, include GScript URL to fetch the data and add it into google sheets
New row will be added with the new values
3. Prepare calculation evaluation sheet
Formula will be insert into the columns
Sort the rows using the final score
Can be done for both preliminary and final round
4. Get participants that did not register
sign up an account but did not enter registration details
Email address only available on auth while in the database there are no data about the register
5. Get judges that not yet evaluate
After the end of preliminary round submission, judges will evaluate submissions therefore need to notify the judges about the evaluation
Need to consider getting total number of submission and evaluated submissions
6. Get top 20 teams’ details
After preliminary round finish, get all top 20 preliminary round winners detail