koala
09-28-2014, 12:48 AM
Hi Forum,
I am not sure if this is the correct forum for my problem. If not, please accept my apologies in advance, and kindly point me to the right forum.
I am thinking some kind of VBA loop procedure may give me the answer I need, but am not sure how to code it.
I have attached a sample spread sheet showing what I am trying to achieve.
Scenario:
I have 5 tasks, each requiring 2 workers
The tasks MUST remain static on the spread sheet
The workers cycle through the spread sheet by dropping down one line each week.
Each worker can work any TASK in any order, but can only work with the same 2nd worker once per rotation (9 weeks). (this means each worker will work each TASK twice per rotation. The same task can be worked consecutively, but not with the same worker.)
Basically, I need to place the TASK in the correct order so that all workers rotate through it, but only working with each other worker once during the cycle.
What is the correct order for the tasks
Thanks in advance for your assistance
Koala
I am not sure if this is the correct forum for my problem. If not, please accept my apologies in advance, and kindly point me to the right forum.
I am thinking some kind of VBA loop procedure may give me the answer I need, but am not sure how to code it.
I have attached a sample spread sheet showing what I am trying to achieve.
Scenario:
I have 5 tasks, each requiring 2 workers
The tasks MUST remain static on the spread sheet
The workers cycle through the spread sheet by dropping down one line each week.
Each worker can work any TASK in any order, but can only work with the same 2nd worker once per rotation (9 weeks). (this means each worker will work each TASK twice per rotation. The same task can be worked consecutively, but not with the same worker.)
Basically, I need to place the TASK in the correct order so that all workers rotate through it, but only working with each other worker once during the cycle.
What is the correct order for the tasks
Thanks in advance for your assistance
Koala