J
Jose Lopes
I have a table of employees, skills and machine centres. Almost everyone
rotates through all the machines but some are more skilled than others in
some of those machines. In some cases one or two workers only know how to
operate with one or two machines. I’m trying to create a random shift
according to those skills but that, at the same time, will allow everyone to
rotate even those more skilled, at least from time to time. That may depend
on the quantity of work to be done at each day e.g. more work - less rotation.
Skill grades
Name M1 M2 M3
Worker 1 1 3 5
Worker 2 3 5 1
Worker 3 5 1 3
Work pressure: grade from 1 to 5
Day n (low work pressure – skill grades influence less)
Worker 1 M1
Worker 2 M2
Worker 3 M3
Day n+1 (heavy work pressure – skill grades influence more)
Worker 1 M3
Worker 2 M2
Worker 3 M1
Can someone be imaginative enough to point me some directions to follow? I
believe that this must be a very complicated situation only solved by VBA and
if that’s the case I will forget about it…
Thanks in advance.
rotates through all the machines but some are more skilled than others in
some of those machines. In some cases one or two workers only know how to
operate with one or two machines. I’m trying to create a random shift
according to those skills but that, at the same time, will allow everyone to
rotate even those more skilled, at least from time to time. That may depend
on the quantity of work to be done at each day e.g. more work - less rotation.
Skill grades
Name M1 M2 M3
Worker 1 1 3 5
Worker 2 3 5 1
Worker 3 5 1 3
Work pressure: grade from 1 to 5
Day n (low work pressure – skill grades influence less)
Worker 1 M1
Worker 2 M2
Worker 3 M3
Day n+1 (heavy work pressure – skill grades influence more)
Worker 1 M3
Worker 2 M2
Worker 3 M1
Can someone be imaginative enough to point me some directions to follow? I
believe that this must be a very complicated situation only solved by VBA and
if that’s the case I will forget about it…
Thanks in advance.