Skip to content
ProjectControls.com
Microsoft Project

Formula to calculate percent of unit to assing resources

In the Open Standard
Jhorbam Baena OrozcoMember for 17 years 1 month
Created
3
5
0

 

 

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 

 

 


 

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Rafael Davila ·
    #1

    I do not use MSP but always

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

    Percent (%) Allocation fields

    Good Luck

    Report
  2. 0
    Jhorbam Baena Orozco ·
    #2

    Thanks, I'll try it

    Thanks, I'll try it

    Report
  3. 0
    Rafael Davila ·
    #3

    Please be reminded

    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.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?