Erice
Pre-takeoff checklist
I am supposed to come up with six sets of three groups of 13 people so that each person is with each of the 38 other people on the list in at least one of those sets. Basically, this is a campout where I have 39 kids coming, and we have six different activities. There will be 3 groups of 13. I want to make sure each kid can be with every other kid in at least one of those activities.
Is there an algorithm that can help make this happen? I have used Excel, given each kid a random number, then sorted the column of random numbers to shuffle the names into groups. But making sure each kid is with every other kid at least once is the hard part. I end up moving kids by hand from one list to the other, but eventually I end up moving someone who "worked" to accommodate one person, only to find out when I complete the list, that my moving made it not work again.
It is kind of hard to explain ...
I wonder how flight dispatchers and/or crew schedulers do it ???!
There must be a way to leverage technology to help me with this. Any suggestions would be appreciated.
Is there an algorithm that can help make this happen? I have used Excel, given each kid a random number, then sorted the column of random numbers to shuffle the names into groups. But making sure each kid is with every other kid at least once is the hard part. I end up moving kids by hand from one list to the other, but eventually I end up moving someone who "worked" to accommodate one person, only to find out when I complete the list, that my moving made it not work again.
It is kind of hard to explain ...
I wonder how flight dispatchers and/or crew schedulers do it ???!
There must be a way to leverage technology to help me with this. Any suggestions would be appreciated.