Skip to content

Resouces in the layout

Moosa AliMember for 21 years 6 months
Created
7
2
0

Dear friends,
I have one doubt. One of our consultants asked me, the no of laborers that put in to the corresponding activity to be shown in the layout. Means he want one additional column in layout showing the laborers used to the each activity. I am getting the total only.
Means if one activity there is 1500 carpenter, 1500 helper, 900 Masons, 200 steel fixers I can show the total 4100 only. But consultant wants it by separate.

How it is possible? Pls help

Regards
Moosa

7 replies

Oldest first
  1. 0
    Larry Rino ·
    Moosa,

    I suggest you check P3’s Help and search the topic about
    "Resource Assignment command (Insert menu)". Assign the resources individually.

    This is possible, as a fact, if you check P3 sample project HWY1 and click Resource/Cost Table this would show: asphalt, base, carpenter, comp., concrete, crane, etc. including various Labour Resources.

    Cheers
  2. 0
    Moosa Ali ·
    That is ok.
    But How can I show this in the layout,the different resources used to complete one activity in an additional column?

    Not Possible?

    Regrads
    Moosa
  3. 0
    Dattatreya Padharthi ·
    Sorry Moosa,

    This is not possible in P3 or in any software having this kind of database. Your key/unique parameter is activity which has > 1 resources & is shown in a single line, Even if you filter for only one resource, other resources are bound to appear as this is not resource exclusive.
    But you can use the resource profile curve/spreadsheet to show resource either by activity or by project.

    Cheers
    Datta
  4. 0
    Ronald Romero ·
    Ali,

    It is possible if you make a customize columns for each resource that you have. So it will appear on the printout. Just limit your manpower resource categories so it is possible to print them in your layout.

    Cheers,

    ronnie
  5. 0
    James Barnes ·
    OK, the answer afaik is yes and, erm, no with a dash of sorta

    in FORMAT>COLUMNS you can add a column with the data item "Units per time period". This will then report the number of resources against each activity, BUT;

    1. You need to have your resource units the same as your planning units. Otherwise you will show Man-hours per day, for example
    2. If there is more than one resource on the activity (Labourer and Welder, for example) then the entry will show the total team size (welders+labourers) If you add another column with the data item "resource" then you will get a list of the resources you have assigned (EG; W, L), but not a split of quantities.
    3. Be prepared for fractional answers (3.5 labourers) and the daft questions that your PM will ask you about this.
    4. For an activity in progress, I believe the calculation uses the RD (remaniing duration) and Qty to complete figures to calculate the team size
    5. Once the activity is progressed 100%, the figure shows as zero

    To split out the data for each resource, it is possible, there are 2 ways;

    1. Export the activities to .DBF then bring into Excel (TOOLS>PROJECT UTILITIES>EXPORT). This will give each resource on an activity a different line in excel. You can quickly produce a list of activities and resources / team sizes.
    2. Use report writer (TOOLS>TABULAR REPORTS>REPORT WRITER) This is a steep learning curve though and gives a rather oldskool style text report

    Neither of these produces a bar chart, sadly.
  6. 0
    Ronald Romero ·
    Ali,

    If your using P3.1 just like me then go to tools>Tabular Reports> Resource Loading and export it into a CSV format which you can import to Excel from there you can produce columns for each resources and manipulate it . From there you can have a detail resource by trade for each activity of your schedule.

    Cheers,

    Ronnie
  7. 0
    Dattatreya Padharthi ·
    True,

    You can export the database in dbf & then use excel/access to prepare reports.

    Cheers

    Datta

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?