Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to set up a monthly work roster for 4 or 5 people | Excel Worksheet Functions | |||
Generating a repeating list of names from an ever changing roster. | Excel Worksheet Functions | |||
need a roster that 3 kids can work to day by day? | Excel Worksheet Functions | |||
work roster setup | Excel Programming | |||
Scramble names | Excel Programming |