I was wondering if anyone here would be able to assist me with creating a randomized task Rota? We have quite a few tasks and I find that it would waste half of my Monday morning assigning everybody these tasks per week, whilst also trying to eliminate people doing the same thing all the time! I found a thread on here that my work colleague and I have been manipulating to try and suit our needs, but I feel that this has gone a bit above our heads.
I am hoping that someone out there is able to help me to fix our Rota given the following criteria:
I would like for Column F to use the Names in the Help Desk Operatives table to randomly assign tasks to people, with the following restrictions in place
Any Tasks that in column E have Seniors in it, can only randomize names using 'names 1-4'
Any Tasks that in column E have ESI in it, can only randomize using 'names 8-9'
For anything else in Column E, (if a specific name is in there) that doesn't mean that person specifically has to do that job, these can all be randomized on Names 1-9 too
We are currently using column D to create stationary items in column F, if that could remain that would be great, as some tasks just have one owner and don't need to be randomized.
I have attached our workings so far, any help on this matter would be greatly received! Please feel free to manipulate the spreadsheet in any way. If the names and tasks could be added to over time as well that would be great, as this list is not exhaustive unfortunately!
I hope I'm not asking too much! I look forward to any responses I may receive.