Skip to content

Resources - P3 or Excel

Allison RobbMember for 21 years 2 months
Created
8
4
0
I have a question about resources and the reports P3 is able to generate.

Our requirement is to show resources required for each work package with number of days per month. Is this achievable in P3

8 replies

Oldest first
  1. 0
    Steven Oliver ·
    How have you loaded the resource quantity ? Hours or days ?

    As far as I recall, P3 will generate a distribution based on this value.
  2. 0
    Raja Izat Raja Ibrahim ·
    Hi
    U can use - "Tubular report > resource > loading" from there u can see distribution resource by month day hrs etc and u can roll up as per WBS or detail activities. Its will show as per schedule
  3. 0
    Sukumaran Subaramaniyan ·
    Allison,

    Else, go to Resource Table. Use the Resource Profile/Table dialog box to specify the requirement and filter the resources according to you preference.

    Regards.
  4. 0
    Martin Emmanuel Raj ·
    Allison,

    Try this...

    In the Resource Loading Report, In Tab Timescale - choose unit as "DAY"

    your output will be in days which is your requirement.

    Additionally In Tab Format - choose export to csv format. The output file created can be easily handled through Excel.

    Hope this helps!!!

    found any other way? pl. have your say.....

    Good Luck,

    Martin
  5. 0
    Charleston-Joseph Orbe ·
    Hi Allison,

    Please take note the PPeers that response to your thread comes from an environment outside IT.

    Im not from IT and I can imagine the resources required in IT will be that big as that in building works, heavy civils or petrochemical/oil & gas.

    I would suggest generate your resources using excel. It is simple and it is not complicated.

    Regards,

    Charlie
  6. 0
    Charleston-Joseph Orbe ·
    Hi Allison,

    correction from my previous post

    "... I can imagine ..." should be "... I can’t imagine ..."

    Im sorry for the inconvenience.

    Cheers

    Charlie
  7. 0
    Oscar Wilde ·
    Is there any way when you have a long duration for your resources say 18 months to print the resources on the graph per day I know you can point and get the number but any other way

    Oscar
  8. 0
    Manulal Inasu ·
    Hi Oscar,

    If your question is about graphs in excel, it is quite possible. Go to Chart options> Datalabels > and check values. you will have the values also on the bar.

    Regards,

    manu.

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?