Google Sheets: TRANSPOSE, arrays, Randomize Ranges
Random Combinations Without Repetition Using Arrays, TRANSPOSE and Randomize Ranges
Say you have a list of 30 people and a 30 list of groups. After every half hour for six hours the people must change to another group, but they cannot go back to a group they have already been in.
How can we schedule 12 sessions where every person can randomly go to another group without going to the same group twice?
This is pretty much the same issue I face when scheduling my teachers to proctor exams randomly each quarter for different classes. The rules I need to follow are:
- No teacher should proctor the same class twice.
- Assignment to proctor a class should seem random.
- The teacher that teaches the class cannot proctor their own class.
- Each week has an exam over the term. The term runs for 8 weeks plus a final requiring a total of 9 proctor sessions.