Formula to calculate percent of unit to assing resources

 

 

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 

 

 


 

 

R
Rafael Davila 👤 Member for 22 years 3 months

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.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts