Using Google Sheets API to compute the winner of a Ranked Choice Voting Election, then makes a Sankey Chart to show the calculations.
Plotly is used to make the output look nice and fancy. Make an an account and get
the INSERT_PLOTLY_USERNAME and INSERT_PLOTLY_API_KEY values from https://plot.ly/settings/api.
SpreadSheetID can be found by looking at the URL for the spreadsheet and finding: d/<SpreadSheetID>/edit
This is generated for you by google :) just log in at https://console.developers.google.com/apis/credentials and set up a project, and add a service account with permissions and download the json file.
More info can be found here: https://gspread.readthedocs.io/en/latest/oauth2.html
You will need to add the Sheets API and maybe the Drive API to the project from the developer console.
Copy the JSON File into creds.json.
All of the emails from the sign in forms, including weekly and IP/IG sign ins, need to get copied into the signin.txt form. The Head of Research should be keeping a list of presenters and their emails. Copy those emails into presenters.txt.
Make sure that Members.txt is empty before running Create_Roster.py
Set up the google service account, share the spreadsheet with the account.
Install the requirements: pip3 install -r requirements.txt
Run create_roster.py, then run rcv.py.
The script will print out the results of each round. If plotly is fixed, it will also create a pretty graph and output a url for where the graph is located