Welcome to Planning Planet, checkout the Guild of Project Controls Knowledge CAR

Formula to calculate percent of unit to assing resources

3 replies [Last post]
Jhorbam Baena Orozco
User offline. Last seen 5 days 3 hours ago. Offline
Joined: 14 Sep 2009
Posts: 70
Groups: None

 

 

Hi Everyone.

Although I have used project for a long time, I have always been difficult to allocate resources. In spring I use man hours and assign them in numbers and not in percentages. This has been my lesson with Project, when assigning by percentage.

Is there any way to calculate or transform the man hours that are taken for budget and to be able to convert it to percentage according to the amount of man hours that the activity requires?

I leave and excel sample data file 

 

 


 

 

Replies

Rafael Davila
User offline. Last seen 3 hours 4 min ago. Offline
Joined: 1 Mar 2004
Posts: 4225

Please be reminded that:

  1. Resource quantity and effort are not the same.
  2. Leveling for effort is not the same as leveling for resource quantity and can yield unfeasible results.
  3. The need for separate fields for resource quantity and effort is not just a matter of convenience it is also a matter of getting reliable resource overload visibility and resource leveling.

Cpm schedules - resource quantities and workloads from Rafael Davila
Jhorbam Baena Orozco
User offline. Last seen 5 days 3 hours ago. Offline
Joined: 14 Sep 2009
Posts: 70
Groups: None

Thanks, I'll try it

Rafael Davila
User offline. Last seen 3 hours 4 min ago. Offline
Joined: 1 Mar 2004
Posts: 4225

I do not use MSP but always look to understand the basics of it.  Try the following.

Percent (%) Allocation fields

Good Luck