Resouces in the layout

True,



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



Cheers



Datta

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

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.

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

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

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