Category: Google Sheets Basics

How do I Randomly Assign People to a Group Without Doubling Up on the Same Group in Google Sheets

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:

  1. No teacher should proctor the same class twice.
  2. Assignment to proctor a class should seem random.
  3. The teacher that teaches the class cannot proctor their own class.
  4. Each week has an exam over the term. The term runs for 8 weeks plus a final requiring a total of 9 proctor sessions.

Continue reading “How do I Randomly Assign People to a Group Without Doubling Up on the Same Group in Google Sheets”