This repo contains the jersey allocation scripts, developed by Eusoff Hackers for use by Eusoff SMC. The objective of this script is to reduce the time cost and error rate of the annual jersey allocation process in Eusoff.

This process can be structured into two independent scripts - the normalisation.py & smart_allocation.py scripts. The normalisation.py script simply calculates the points for each sportsman (you will have to add in the wave number column yourself) and the smart_allocation.py script would allocate the jersey numbers.

To begin, simply open up your local command line (Windows) or Terminal (Mac). Some simple commands on Command line can be found here: https://arian-celina.com/windows-cmd-macos-terminal-navigation/

You will need to install Git onto your computer following which you can copy the files from the repository into your local machine. (Copy and paste, but fancier).

1. Navigate to the folder on your personal computer on which you would like to store the folder with the scripts via Cmd/Terminal

Common Commands (Mac):

ls
cd [path to folder]
cd ..

Common Commands (Windows):

dir
cd [path to folder]
cd..

2. Type this into your Cmd/Terminal (each line is followed by the enter/return key):

git init
git clone https://github.com/eusoffhackers/jersey_allocation.git

Tadah! The folder is now on your computer! Good job.

3. Now you will need to set-up python and pandas onto your computer. These are just programming tools that are used by the script. Find out how to install python here: https://realpython.com/installing-python/#step-1-download-the-python-3-installer

Install pandas by simply keying in:

pip install pandas

First, rename the csv file containing the google sheet responses as SMC_input.csv. Then, remember to add in a column named Wave and add in the wave number (1, 2, 3, 4).

In order to run the script, simply type in the following commands:

python normalisation.py

If everything works, it will show the following message, and you will find a new normalisation_output.csv created in your allocation folder.

Points computed. normalisation_output.csv created in allocation folder!

You should see a CSV file being created on your local computer with all the points calculated!

1. Change the working directory to the allocation folder using the cd command

cd allocation

2. In order to run the script, simply type in the following commands:

python smart-allocation.py

and follow the instructions on the terminal!

Notes: -2 means that you should deconflict. -1 means either the person's number is affected by a -2 or the person's numbers are all taken So fix the -2s first before running the script again!

REMEMBER!!! Always run the script in waves! And if things go wrong, you can always restart (: