-
Clone this GitHub repository or download the zip file.
-
Edit the group size (default: 4).
-
Download pip if you need to.
-
Open Terminal or Command Prompt and navigate to the directory with the program files.
-
Run
pip install -r requirements.txt. -
Create a Google Form with the following questions. NOTE: ENABLE THE
Collect email addressesOPTION. QUESTIONS MARKED REQUIRED(*) ARE REQUIRED FOR THE PYTHON PROGRAM. QUESTIONS MUST MATCH THE CASE AND THE WORDING AS SHOWN IN THE IMAGE.
- Check the corresponding Google Sheet and ensure all the fields present in the following image are the the same as yours.
-
Download the CSV file of the spreadsheet.
-
Run
python main.py <CSV file path>. NOTE: Replace<CSV file path>with the path to the CSV file of the spreadsheet.
After the program runs successfully, a new file called rooms.csv will be generated with the room assignments.