PDA

View Full Version : [SOLVED] How to automatically rotate through task



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

Aussiebear
09-28-2014, 04:08 AM
Try this

koala
09-28-2014, 04:41 AM
Aussiebear,

Thanks for your help.

Unfortunately the worker can only move down 1 slot each week.

Attached is where I have managed to get to.

As you can see from the gettingthere page, The error has a distinct pattern, however I am not sure what it is telling me to do.

Thanks
Koala

koala
09-28-2014, 06:07 AM
Aussiebear,

I figured it out.

Attached is the end result, which if tasks are scheduled in this order allows all workers to work with each other during the full rotation.

Thanks for your help.

Regards
Koala