scramble names on work roster
 

Hi all..

I got this roster on a excell work book. Could you please help me to get
the following.

the names on the first collumn has to be put random in the grid below the
roster. but first check and see if
the person work morn shift. only if person 4 is working morning on monday
18 may then his name can be added to the grid below
every week i print one of these rosters. these names must be scrambled
every week on the below grid.
the last condition is that the names must be duplicated as littel as
possible
From time to time i add or take away names.




Geen uitruilings sal gedoen word. Geen veranderings
May 22 20:17 18-May 19-May 20-May 21-May 22-May 23-May 24-May
Mon Tue Wed Thu Fri Sat Sun m n d
station 3
person 1 night off night morn night morn night 2 4 0
person 2 off off off off off off off 0 0 0
person 3 off off off off off off off 0 0 0
person 4 morn night morn off morn night morn 4 2 0
person 5 night morn night morn night off off 2 3 0
person 6 morn night off o-c morn night morn 4 3 0
person 7 off o-c morn night morn night morn 4 3 0
person 8 night morn night off night morn night 2 4 0
person 9 morn off morn night night morn night 3 3 0
9 3 3 3 3 3 3 3
3 3 3 3 4 3 3
0 0 0 0 0 0 0
station 2
person 10 off morn night morn night morn night 3 3 0
person 11 night morn night off night morn night 2 4 0
person 12 morn night morn night morn off off 3 2 0
person 13 o-c off morn night morn night morn 4 3 0
person 14 morn o-c off morn night morn night 4 3 0
person 15 off off off off off night morn 1 1 0
person 16 night off morn night morn night morn 3 3 0
person 17 off night night morn night morn night 2 4 0
0 0 0
0 0 0
0 0 0
8 3 3 3 3 3 4 3
3 3 3 3 4 3 4
0 0 0 0 0 0 0
station 1
person 18 morn night off morn night morn morn 4 2 0
person 19 off morn night night morn night night 2 4 0
person 20 night off morn night night morn night 2 4 0
person 21 night night night off morn night morn 2 4 0
0 0 0
4 1 1 1 1 2 2 2
2 2 2 2 2 2 2
21 0 0 0 0 0 0 0
105.5 105.5 105.5 105.5 127 118.5 119.5


additional roster

18-May person 6 person 12 person 18
19-May person 8 person 10 person 19
20-May person 4 person 13 person 20
21-May person 1 person 14 person 17
22-May person 7 person 16 person 21
23-May person 9 person 11 person 8
24-May person 15 person 13 person 4