Resource skill sets

[Ian]

Using Project 2007. We have a spreadsheet where each team member
capabilities are recorded, one column per team member. There are 46
rows - each representing a specific skill set used in project
implementation contains a score of between 1 & 5. Our Project
Assistant would like to bring this information into our Resource Sheet
so that it becomes easier for her to assign resources based on project
and task requirements.

I can't think of any way we can do this - there are too many for
custom fields to handle. Is there any solution - or 3rd party add on
- that might enable us to do this, please?

 

[John]

Using Project 2007. We have a spreadsheet where each team member
capabilities are recorded, one column per team member. There are 46
rows - each representing a specific skill set used in project
implementation contains a score of between 1 & 5. Our Project
Assistant would like to bring this information into our Resource Sheet
so that it becomes easier for her to assign resources based on project
and task requirements.

I can't think of any way we can do this - there are too many for
custom fields to handle. Is there any solution - or 3rd party add on
- that might enable us to do this, please?

Ian,
If I can make the assumption that resource assignments in your project
plan are based on skill set number and independent of actual resource,
then you can create 46 resource groups, one for each skill set. The Max
Unit level for each group is the total number of resources with that
skill set. For example, let's say you have 4 individual resources that
possess the skill set represented by row 10 in your spreadsheet. You
might call the resource group, "skill set 10" and the Max Units would be
400%.

Hope this helps.
John
Project MVP