Spreadsheet: 120411d1315263601-shop-floor-planning-daily-plan
Sheet: Sheet1

STAFF NAMES | Tasks
NAME 1 | task 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOOR PLAN
[NAME] 2 | task 2 |  | NAME 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME 21
NAME 3 | task 3 |  | TASK 1 |  |  |  |  |  |  |  |  | TASK 2 |  |  |  |  |  | TASK 3 |  |  |  |  |  |  | TASK 4 |  |  |  |  |  |  |  | TASK 5 |  |  |  |  |  |  |  | TASK 6 |  |  |  |  |  |  |  | TASK 8 |  |  |  |  |  |  |  |  |  | TASK 9 |  |  |  |  |  |  |  |  |  | TASK 10 |  |  |  |  |  |  |  |  |  | TASK 11
NAME 4 | task 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TASK 12 |  |  |  |  |  |  |  |  |  | TASK 13 |  |  |  |  |  |  |  |  |  | TASK 14 |  |  |  |  |  |  |  |  |  | TASK 15
NAME 5 | task 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TASK 7
NAME 6 | task 6
NAME 7 | task 7 |  | TASK 21, TASK 22 |  |  |  |  |  |  |  | TASK 20 |  |  |  |  |  |  |  | TASK 19 |  |  |  |  |  |  |  | TASK 18 |  |  |  |  |  |  |  |  |  |  | TASK 16 |  |  |  |  |  |  |  |  |  |  | NAMES 27
[NAME] 8 | task 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TASK 17
NAME 9 | task 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 Names Working on the shift doing 26  tasks
NAME 10 | task 10 |  |  |  |  | 2
NAME 11 | task 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 ON ANY OTHER ABSENCE AT ANY ONE TIME DURING THE 4 WORKING DAY, (MON, TUE,WED, THU)
NAME 12 | task 12
NAME 13 | task 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TASK 23
NAME 14 | task 14 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TASK 24
NAME 15 | task 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TASK 25
[NAME] 16 | task 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TASK 26
[NAME] 17 | task 17
NAME 18 | task 18 |  |  |  |  | The floor plan has 26 tasks that needs to be completed by 26 staff on each day from monday-thursday, and on each week there are 4 people on other leave, may that be on holiday, sick leave or awol, the problem I have is when I am selecting to fill in the tasks with names on column a, each task can be done on by any one of 30 people, and all these tasks are not one unique type of duty but completely different roles of duties, I have been filling in the names with various task for last 2 years or so,  but over the last few weeks I have been missing staff names with tasks they should be performing, and often fill in the gabs with agency or casuals staff and only finding out on the day that I have missed a staff name when he comes and ask what is his role, and everything fits in a place. What I like to do is to use excel formulas as the floor plan suggest to fill in the staff names with various performing tasks, and it will higlight on column A, all the staff names that have been selected on the floor plan. If i do select the poeple on other leave column A gets hightled with a different colour
NAME 19 | task 19
NAME 20 | task 20
NAME 21 | task 21
NAME 22 | task 22
NAME 23 | task 23
NAME 24 | task 24
NAME 25 | task 25
NAME 26 | task 26
NAME 27 | task 27
NAME 28 | task 28
NAME 29 | task 29
NAME 30 | task 30 |  |  |  |  |  | Names |  |  |  |  | 3 |  |  | A/L
Agency 1 | any task can be done by these temp staff |  |  |  |  |  | Names |  |  |  |  | 9 |  |  | S/L
Agency 2 |  |  |  |  |  |  | Names |  |  |  |  | 19 |  |  | UA
Casual 1 |  |  |  |  |  |  | Names |  |  |  |  | 21 |  |  | A/L
Casual 2 |  |  |  |  |  |  | Names |  |  |  |  | 30 |  |  | PATERNITY LEAVE
I have selcted 3 staff on the floor plan in red, and one error in purple, he is on leave, which In total of staff left to choose from column A ( total staff 30 - 5 on leave, 3 selected on the floor plan ) give 22 staff to select to fill in the tasks on the floor plan.