mikeisasking
IS-IT--Management
I'm creating a plan for a university, which looks at resource time not in hours but as a percentage of time available to the project when doing their planning. I can't figure out how to do this. Here are the details:
>The total number of hours available for the year is 1950 (which I addressed by creating a calendar for all project resources to use)
>Resource 'Z' has been assigned to the project and it will take 33% of his time - doing the math that would be 643.5 hours
>Task 3.1.1 has a fixed duration of 13 weeks
>Resource 'Z' is to be assigned to Task 3.1.1 to use 9% of HIS time - doing the math 57.9 hrs
I would like for the project admin to be able assign resources and enter the percent instead of doing the math each time. If you enter the percentage when assigning the resource (in this case 9%) MSProject will take the duration, convert that to hours (in this case 13wks * 37.5hrs = 487.5hrs) and then use the 9% to determine Work hours (in this case 43.875 hrs).
How can I get it to use the 9% based on the Resource total project hours and not the task total project hours?
>The total number of hours available for the year is 1950 (which I addressed by creating a calendar for all project resources to use)
>Resource 'Z' has been assigned to the project and it will take 33% of his time - doing the math that would be 643.5 hours
>Task 3.1.1 has a fixed duration of 13 weeks
>Resource 'Z' is to be assigned to Task 3.1.1 to use 9% of HIS time - doing the math 57.9 hrs
I would like for the project admin to be able assign resources and enter the percent instead of doing the math each time. If you enter the percentage when assigning the resource (in this case 9%) MSProject will take the duration, convert that to hours (in this case 13wks * 37.5hrs = 487.5hrs) and then use the 9% to determine Work hours (in this case 43.875 hrs).
How can I get it to use the 9% based on the Resource total project hours and not the task total project hours?