Skip to content

Latest commit

 

History

History
42 lines (32 loc) · 2.7 KB

README.md

File metadata and controls

42 lines (32 loc) · 2.7 KB

NEISA-rankings

Set Up:

Create 2 google sheets, following this structure:

  1. A sheet with all the schools in NEISA with the header "Schools" at the top.
    Follow this model: https://docs.google.com/spreadsheets/d/e/2PACX-1vQfU-xYwtTc9nlW_tpsEmk-TMlUqsvzLooC8m3tcFnS7ig3lvWkA_b_2BxzUNGik8zq6IV-Lg9BwGSV/pub?output=csv

  2. A sheet with each regatta and the type of that regatta. The type is denoted using the same structure we have used in the past. Follow this model exactly: https://docs.google.com/spreadsheets/d/e/2PACX-1vQfeyC1LeMtdi0qIz-GWxke3jPQ1jJzp72YNi_I9YXF1f73HXUBRTG7AqePHI_L5X54HVwAofxueTiO/pub?output=csv

Note: The google sheets you should use is the link you get when going to File > Publish to Web. Change the Web Page setting to CSV using the dropdown. You should get a link from doing this.

In the Runner.py file, paste in the two links and specify two CSV files to output the results to. Put each of these between quotes (like the way it is now). For the way it is currently set up, the results will be contained in the rankings.csv file and the component_scores.csv file. When everything is set, run the Runner.py script (python3 Runner.py from the neisa directory).

For Mike to Run the Python File:

NOTE: Capitals matter in the following commands.

  1. Open Terminal
  2. Type cd ~/Desktop/NEISA-rankings-master
  3. Type python3 Runner.py
  4. Files will appear in Finder under Desktop/NEISA-rankings-master

To Get Updated Code:

  1. Save the links that are at the top of Runner.py somewhere (e.g. Notes)
  2. Come to this page! Congrats.
  3. Hit the green Code button in the upper right corner of the page.
  4. Hit Download ZIP
  5. The zip should download. Double click the download to unzip it into a folder. (Finder should open). Drag that folder into your Desktop. If it asks you to replace the existing one, say yes.
  6. VERY IMPORTANT: Make sure the folder is called NEISA-rankings-master. Make sure there's no (1) or (2) at the end.
  7. Update the links at the top of Runner.py if they are not correct.
  8. See above to run it!

To Generate Scoring Tables:

  1. Open Terminal
  2. python3
  3. import rank_calculator
  4. rank_calculator.calculate_score_table(9, 9, "C") (or whatever you want the parameters to be, see below) Type exit() to get back to the main terminal.

Format of the call: rank_calculator.calculate_score_table(maximumNumberOfTeams, minimumNumberOfTeams, "regatta_type") It will print out to your console the scoring tab. For example, calling rank_calculator.calculate_score_table(18, 18, "A"), will print out the scoring table for A 18 teams. rank_calculator.calculate_score_table(18, 16, "A") it would print out the same thing but for A 18, A 17, and A 16 teams.