I have a 600 hundred students and 10 classrooms. 10 different subjects are taught in 10 classrooms. Each class can have only 60 students. Each student can have 3 options, according to their percentage classrooms have to be allocated.
I have a sheet having cells:
Name Choice1 Choice2 Choice3 Percentage
A subject1 subject7 subject4 87
B subject5 subject3 subject8 74
600 students information is in this sheet.
10 new sheets have to be created like: subject1,subject2....subject10.
These student rows have to be moved to respective subjects(classrooms) according to their choices and percentages.
Sort the rows according to their first choice and then sort according to their percentages.
If subject1 is the first choice of 70 students, the top 60 students of these 70 have to be allocated subject1(these student rows should be moved to subject1 sheet).
Likewise, all the students' first choices are carried out.
If any student rows are remaining second choice is carried out in the same manner.
If there are any students whose choices are all filled, they have to be allocated some other classroom where there is vacancy.
For example,
student 560:
choice 1: subject 5
choice 2: subject 9
choice 3: subject 2
if all the subjects are filled, then to some other sheet, this row has to be moved where there is vacancy.
Since there are 10 subjects(classrooms) and 600 students.
Every student row is moved to some sheet or the other.
Please help me. Thanks in advance.
Bookmarks