I am a school teacher and we have kids going on a school trip to the snow.
Each child has picked 3 preferences for their "bus buddy".
I am after a way to put this data into excel and run a query against it to tell me which matches work best based on the kids' preferences.
Example below (each child is represented by a letter):
<tbody>
</tbody>
and so on for all 100 children that we have going.
I realise this is similar to the Stable Roommates Problem - except that we have not asked kids to rank every child going on the excursion! I have struggled to find the code for this algorithm and be able to run it.
Any thoughts/spreadsheet examples/code etc would be greatly appreciated!
Brett
Each child has picked 3 preferences for their "bus buddy".
I am after a way to put this data into excel and run a query against it to tell me which matches work best based on the kids' preferences.
Example below (each child is represented by a letter):
Student | Pref#1 | Pref#2 | Pref#3 |
A | C | D | A |
B | G | E | A |
C | E | A | F |
D | G | B | A |
E | A | B | C |
<tbody>
</tbody>
and so on for all 100 children that we have going.
I realise this is similar to the Stable Roommates Problem - except that we have not asked kids to rank every child going on the excursion! I have struggled to find the code for this algorithm and be able to run it.
Any thoughts/spreadsheet examples/code etc would be greatly appreciated!
Brett
Last edited: