Loading...
Quick Links

Reply To: Managing multiple (100's) of repetitive tasks

Home Forums Discussion Managing multiple (100's) of repetitive tasks Reply To: Managing multiple (100's) of repetitive tasks

#440069

200 inspectors completing 1/10th of a task a day.
I can simplify. Pretty much the only unique thing will be something to ID the “car” in the summary task.

I’m afraid some sort of macro would be needed.

The example below shows only 3 cars and 4 sub task (actual schedule will have 200 cars w/ 20+ same sub tasks each)

Task Name Duration Start Finish Predecessors Resource Names
ATP 0 days Thu 8/27/20 Thu 8/27/20
Car 1 40 days Thu 8/27/20 Wed 10/21/20
inspect a 10 days Thu 8/27/20 Wed 9/9/20 1 Art
inspect b 10 days Thu 9/10/20 Wed 9/23/20 3 Art
inspect c 10 days Thu 9/24/20 Wed 10/7/20 4 Art
inspect d 10 days Thu 10/8/20 Wed 10/21/20 5 Art
Car 2 40 days Thu 8/27/20 Wed 10/21/20
inspect a 10 days Thu 8/27/20 Wed 9/9/20 1 Bob
inspect b 10 days Thu 9/10/20 Wed 9/23/20 8 Bob
inspect c 10 days Thu 9/24/20 Wed 10/7/20 9 Bob
inspect d 10 days Thu 10/8/20 Wed 10/21/20 10 Bob
Car 3 40 days Thu 8/27/20 Wed 10/21/20
inspect a 10 days Thu 8/27/20 Wed 9/9/20 1 Chuck
inspect b 10 days Thu 9/10/20 Wed 9/23/20 13 Chuck
inspect c 10 days Thu 9/24/20 Wed 10/7/20 14 Chuck
inspect d 10 days Thu 10/8/20 Wed 10/21/20 15 Chuck
Finished 0 days Wed 10/21/20 Wed 10/21/20 16,11,6