Hello all,
I guess what I´m trying to achieve is impossible but as there are so many bright people on this forum I´ll give it a try.
I'm looking for a way check if all tasks on a particular shift are occupied.
Each task requires a special competency. Whether a person has this competency is shown with a "x".
Although some people have multiple competencies, they can only do 1 task per shift, so other tasks should be occupied by other people.
Except for tasks 1a, 1b and 1c which can be done by one person. This is also true for 2a,2b and 2c.
B18:C26 shows how many people is needed per task.
E18:F26 is where I would like to calculate the actual number of people occupying each task.
Here is a link to the sheet.
http://cid-e7c6bf41aa4a9275.skydrive.live.com/self.aspx/Public/Forum/Book2.xls
I guess what I´m trying to achieve is impossible but as there are so many bright people on this forum I´ll give it a try.
I'm looking for a way check if all tasks on a particular shift are occupied.
Each task requires a special competency. Whether a person has this competency is shown with a "x".
Although some people have multiple competencies, they can only do 1 task per shift, so other tasks should be occupied by other people.
Except for tasks 1a, 1b and 1c which can be done by one person. This is also true for 2a,2b and 2c.
B18:C26 shows how many people is needed per task.
E18:F26 is where I would like to calculate the actual number of people occupying each task.
Here is a link to the sheet.
http://cid-e7c6bf41aa4a9275.skydrive.live.com/self.aspx/Public/Forum/Book2.xls