Allocate students by preferences - script
Budget: $30 – $250 USD
I have a spreadsheet with a class of students and need to allocate them in a given number of groups: ex 30 students in 5 groups.
The spreadsheet has information on the students they want and don't want to be in a group with, as well as their level for the activity (range from 1 to 5).
The script needs to perform an allocation of students to groups taking into account these constraints.
Need to use the google solver.
Demo data:
https://docs.google.com/spreadsheets/d/137_38A__aQFqT3Efd06Fto9tIr6DRQda/edit?usp=sharing&ouid=100170418917974854494&rtpof=true&sd=true
The spreadsheet has information on the students they want and don't want to be in a group with, as well as their level for the activity (range from 1 to 5).
The script needs to perform an allocation of students to groups taking into account these constraints.
Need to use the google solver.
Demo data:
https://docs.google.com/spreadsheets/d/137_38A__aQFqT3Efd06Fto9tIr6DRQda/edit?usp=sharing&ouid=100170418917974854494&rtpof=true&sd=true