Skip to content

Resource usage spreadsheet

Mahmoud mohamedMember for 18 years 4 months
Created
1
4
0
Hi
In P6 the resource usage spreadsheet show me the resource’s quantities distributed within the activity duration – I need to show the data as percentage within the duration

1 reply

Oldest first
  1. 0
    Arnold Puy ·
    Hi Mahmoud,

    You can do this by using the spreadsheet option --> Calculate Average.

    Example: Total qty of your manhour is 20,000 hrs. divide the total qty by 100 which is equals to 200.

    Write the 200 in "Divide interval totals by" & under the "Unit of Measure" put the % symbol.

    Try this exercise.

    Arnold

Log in or join to reply

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

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