I have a weekly roster, with 6 tasks and 2 worker on each task (ie 12 workers) I have a sample spreadsheet but i am not sure how to upload it here
I want the tasks to be set in such a way that each week every worker works with a different worker than previously worked with.
The tasks remain static in the roster location, but each week the workers move down one task
By the time they rotate through the entire roster (12 weeks) they will have worked with every other worker once. (they will always need to work with one worker twice because they cant work with themselves.)
I have achieved this with my old 10 worker roster (5 tasks) but am not able to work it out for the 12 worker (6 tasks) roster
(in the 10 worker roster the tacks are in this order D, B, C, A, E, A1, B1, E1, C1, D1.)
The tasks can be in any order however preferably not consecutive ie Task A is not followed by Task A1 etc, as this will mean a worker works the task two weeks running
Is anyone able to assist?