Python Script to automate the Guikema Family NFL Pool

Based on being elected Commissioner of the Family Football Pool against my will (damn you democratic process!), I decided to automate the process a bit.

Here is how I use the script:

1. Update the schedule: sudo python /usr/local/lib/python2.7/dist-packages/nfldb/update.py

2. Run the script with the current week, generating a csv with the schedule in the csv/sched directory:

   python debug.py <week>

3. Update schedules into Drive account; use create_form.gs to create forms from these files

4. Download the results as Week #.csv in the csv/score directory

   cp ~/Downloads/Week#\ \(Responses\)\ -\ Form\ Responses\ 1.csv csv/score/Week\ #.csv

5. Once the week is completed, run the script again, which will compare each person's picks against the actual results, then output the score for the week and the season's results

chrisguikema@ubuntu:~/nfl$ python nfl.py 2
Calculating Score!
----------------------
 2017 Week 2 Results
----------------------
Katie 11
Laura 10
Curt 10
Chris 10
Tyler 9
Sam 8
Amy 7
Troy 7
---------------------
 2017 Season Results
---------------------
Laura 21
Chris 20
Katie 20
Tyler 19
Sam 18
Amy 18
Curt 17
Troy 16
---------------------

• Determine how to use the go compiler to use the skicka tool in order to grab the csv from Drive automatically. Information for skicka can be found here
• Find out how to create a google form from a csv to take all manual work out of things
  • Done in commit 20cb1e6 with create_form.gs