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
Member for
18 years 2 months
Member for18 years2 months
Submitted by James Barnes on Mon, 2007-11-05 05:38
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.
Member for
18 years 11 months
Member for19 years
Submitted by Ronald Romero on Mon, 2007-11-05 02:31
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
Member for
22 years 6 months
Member for22 years6 months
Submitted by DATTATREYA PADHARTHI on Sun, 2007-11-04 01:16
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.
I suggest you check P3s 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.
Member for
22 years 6 monthsRE: Resouces in the layout
True,
You can export the database in dbf & then use excel/access to prepare reports.
Cheers
Datta
Member for
18 years 11 monthsRE: Resouces in the layout
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
Member for
18 years 2 monthsRE: Resouces in the layout
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.
Member for
18 years 11 monthsRE: Resouces in the layout
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
Member for
22 years 6 monthsRE: Resouces in the layout
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
Member for
20 years 6 monthsRE: Resouces in the layout
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
Member for
18 yearsRE: Resouces in the layout
Moosa,
I suggest you check P3s 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