How to use

1. Copy this template
2. Create google forms for each day sheet with Timestamp, Email, Team Number, Start time, and Leg Times (ensuring columns match correctly with the template)
3. Install Python 3 and Git
4. git clone Green-Thanos/MOR
5. cd MOR
6. pip install -r requirements.txt
7. Get a creds.json for your google account with the google sheets (instructions below)
8. Edit any column values if you need to change the format in app/columnValues.json
9. Format column values for ALL times in Open/Mixed to be "Duration"
10. python app/function.py to update the leaderboard automatically

Steps to get a google sheet service account (from gspread docs)

Enable API Access for a Project Head to Google Developers Console and create a new project (or select the one you already have).

In the box labeled “Search for APIs and Services”, search for “Google Drive API” and enable it.

In the box labeled “Search for APIs and Services”, search for “Google Sheets API” and enable it.

For Bots: Using Service Account A service account is a special type of Google account intended to represent a non-human user that needs to authenticate and be authorized to access data in Google APIs [sic].

Since it’s a separate account, by default it does not have access to any spreadsheet until you share it with this account. Just like any other Google account.

Here’s how to get one:

Enable API Access for a Project if you haven’t done it yet.

Go to “APIs & Services > Credentials” and choose “Create credentials > Service account key”.

Fill out the form

Click “Create” and “Done”.

Press “Manage service accounts” above Service Accounts.

Press on ⋮ near recently created service account and select “Manage keys” and then click on “ADD KEY > Create new key”.

Select JSON key type and press “Create”.

You will automatically download a JSON file with credentials. It may look like this:

{ "type": "service_account", "project_id": "api-project-XXX", "private_key_id": "2cd … ba4", "private_key": "-----BEGIN PRIVATE KEY-----\nNrDyLw … jINQh/9\n-----END PRIVATE KEY-----\n", "client_email": "473000000000-yoursisdifferent@developer.gserviceaccount.com", "client_id": "473 … hd.apps.googleusercontent.com", ... } Remember the path to the downloaded credentials file. Also, in the next step you’ll need the value of client_email from this file.

Very important! Go to your spreadsheet and share it with a client_email from the step above. Just like you do with any other Google account. If you don’t do this, you’ll get a gspread.exceptions.SpreadsheetNotFound exception when trying to access this spreadsheet from your application or a script.

Copy the downloaded file to app/creds.json

NOT RECOMMENDED Move the downloaded file to ~/.config/gspread/service_account.json. Windows users should put this file to %APPDATA%\gspread\service_account.json.

Hosting

In progress

python app/server.py to run development server with automatically updating spreadsheet leaderboard at http://localhost:5000 post credentials in .env

render.com for python (clone git repo)

TODO

• Hosting Web Server
• Automation Refreshing
• Compiling into app/adding settings to app ui