Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Resource Loading

13 replies [Last post]
Thu, 2003-05-01 02:32
Nishikant Choudhary
User offline. Last seen 20 years 26 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 25
Groups: None
Planners ,

Q1. Please can u tell me the easiest and fastest way for loading resources and cost into the P3 schedule.
do i need to have additional tools to enter the information .

Q2. How can i get all the activities to have a common resource loading, so that it becomes easier to assess the progress .Cos , what is happening is some of the quantities are assessed based on the quantities completion while others are related to cost, which are manually fed to the P3 sheet , after updating the Excel information.
Top

Replies

Wed, 2003-07-30 04:09
#1
Neeraj Agarkar
User offline. Last seen 5 years 38 weeks ago. Offline
Joined: 25 Jul 2003
Posts: 61
Groups: None
another way for loading resources and costs.

Create Activities table in Database along with Bill of Quantity and unit of measurement.

Create a standard material and labour resources table with its cost.

Assign material and labour resources to activities.

Use P3 batchloader to import into P3. All resources will also be copied into P3. In P3, plan durations and linkages. and you have your Plan ready.

Everytime you want to update, mark actual workdone in Database and use batchloader to see result in p3. The progress % will be based on Actual Qty / BOQ Qty.

On creating further tables like Indirect costs, Advances, retention terms, Liquidated damages conditions, credit period for payments etc. you can have automatic cashflows generation every time you update P3 schedule.

This is timetaking but we also use the same database for tendering, purchase, accounts and human resources.

I too really wish if one software was able to do all of this. Saves a lot of programming headache.
Neeraj
Top
Fri, 2003-07-18 07:13
#2
Se de Leon
User offline. Last seen 3 years 8 weeks ago. Offline
Joined: 15 May 2001
Posts: 321
Groups: None
Hi guys,

The postings here concluded my experiences that entering resource data to P3 is very tedious as what my buddy Jorge(pare si Se de Leon to remember me?) wrote in one of his posts.

It is my belief that computer softwares should should make our life easier not giving us problems like studying other programming techniques or other database softwares. Why cant we have one software to do all of these? Just asking.

My idea here is to have a software which we can prepare a productivity database/gang database within the software and using only a copy paste procedure when preparing the activities with assigned resources already.

Se de Leon.
Top
Thu, 2003-07-17 04:08
#3
Zq qz
User offline. Last seen 12 years 37 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Yes, thanks
Top
Thu, 2003-07-17 04:05
#4
Steven Oliver
User offline. Last seen 11 years 45 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Moises,

My apologies, I misinterpreted your original post. In my terms "distribution" is the allocation of the resource value over time. Allocation would be the method of attaching a resource to an activity.
Top
Thu, 2003-07-17 03:48
#5
Zq qz
User offline. Last seen 12 years 37 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Steve , actually MS access will only distribute the resource per Craft,descipline etc. from a cetain budget quantity / cost. but distribution along the duration of the task or activity will be done in P3 upon complete importing data from access.
Top
Thu, 2003-07-17 03:39
#6
Steven Oliver
User offline. Last seen 11 years 45 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
But how, in MS Access do you accomodate different working patterns, holidays, resource lags, constraints etc?.

Whilst P3 isnt the best Tool for manipulation of resources at least it does give credible and interrogatable results.

If a properly resource loaded plan is what you want, then it is worth the effort to have all the info in P3 and then take advantage of all the advanced features available.

Top
Thu, 2003-07-17 03:20
#7
Zq qz
User offline. Last seen 12 years 37 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Hello there specially my kabayan>>>>>
You can use access database to load resource faster and easier by using unique code. But first, make a standard table for the standard distribution of resources for a certain kind of task/ activity then assign it with a unique code. example: Concreting :Code is "CO" , Resources : Mason (30%), Labor (60%),etc.... =100%. this % will be multiplied with the budget MDays or man-hours etc....but access will do the distribution.
Top
Fri, 2003-07-11 04:58
#8
Jorge Taguinod
User offline. Last seen 2 years 41 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Sorry, buddy. I cant do that as the spreadsheet is a property of the company. I have given you the detailed idea how this works, though and you could probably develop the spreadsheet yourself.

Goodluck.

Jorge
Top
Wed, 2003-07-09 22:51
#9
Nishikant Choudhary
User offline. Last seen 20 years 26 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 25
Groups: None
Thanks guys for the response to my querry.
But could you confirm to me that i will not be losing any Successor / Predecesssor relationship in between exporting and importing the quantities.

Jarge
, Could you send me on sample spreadsheet , cos i do not think i have got you completely on this X-Y Spreadsheet updating and quantity filling.

would appreciate if you send it to my Rediffmial account,
nishikantvc@rediffmail.com

Thanks again.

Nishi
Top
Tue, 2003-07-08 23:57
#10
Jorge Taguinod
User offline. Last seen 2 years 41 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
Managing resources in P3 is a very common problem --- its tedious. Thats why we developed a resource loading spreadsheet matrix.

The procedure for this is:
1. We export P3 activities into the spreadsheet. The activities are then listed vertically at the left part of the spreadsheet.

2. We perform batch processing to export the defined resources in from the resource dictionary. We place these resources at the top part of the spreadsheet.

3. In an X-Y axis perspective, the X-axis lists the activites and the Y-axis lists the resources. Clear?

4. Using this matrix, we then just put in the BQ of each resource required by each activity. We then run a little macro to convert this data into P3 format and import it back into P3.

Limitations:
1. Make sure that matrices are not mixed up. Meaning, if youre putting in labor, be consistent and just put in labor and use the field UPT (units per timeperiod). You can also use UPS for equipment and facilities. But when youre loading material quantities, then the values should correspond to BQ (budgeted quantities) and not with UPT.

2. For activities that are level of effort types, such Project Management, wherein the resources loaded are not really divided among detailed activities but are carried throughout the project, (e.g., Project Mangement needs resources: PM, secretary, field engineers, etc.), just assign resources to one common activity since assigning a PM onto each and every activity will give you an overwhelming BQ.

Advantage:
You can check your spreadsheet if your resource quantities balance evern before you import it back into P3. This ensures that what you are putting into P3 is correct.

Goodluck!

Jorge
Top
Tue, 2003-07-08 23:57
#11
Jorge Taguinod
User offline. Last seen 2 years 41 weeks ago. Offline
Joined: 8 Jul 2003
Posts: 139
Groups: P6-IAP Jedis, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
[ Message removed - duplicate entry (see above post) ]
Top
Fri, 2003-05-02 07:28
#12
Forum Guest
User offline. Last seen 10 weeks 18 hours ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
I would be careful about exporting resource information as if you export resource without cost codes (that have been assigned) when importing back in, it will add a new instance and not overwrite existing information.

I would suggest global change as being the best way to update the best method to use across a large number of activities
Top
Thu, 2003-05-01 04:28
#13
Tara Muddappa
User offline. Last seen 17 years 24 weeks ago. Offline
Joined: 17 Dec 2002
Posts: 26
Groups: None
Hi Nishant,

Once you create/Add resource in P3 and then export to .dbf or .wk1 format.Now against each activity in excel fill the budgeted quantity (i.e mandays,quantity or cost).Now Import this back to P3.

I presume this is the easiest way.

Top