Forum Sponsor:

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

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.

WHAT IS A TECHNIQUE FOR QUICK RESOURCE LOADING IN PRIMAVERA FOR A COMPLEX PROJECT? HOW TO POPULATE PRIMAVERA EXPORTED EXCEL FILE

9 replies [Last post]
Ali Murtaza
User offline. Last seen 2 years 38 weeks ago. Offline
Joined: 19 Aug 2015
Posts: 30
Groups: None

Consider the case of a complex project with 20,000 construction phase activities. I need to do the following:

1. Load BOQ cost in my Primavera schedule (Non labor resource “BOQ cost” is defined in resource directory).

2. Load Resources for each activity in my primavera schedule (different trades of labor resources are defined in resource directory).

3. Load BOQ Quantities for each activity in my primavera schedule (different material resources are defined in resource directory).

I am familiar with native excel export/import process. In excel exported file we need to populate BOQ budgeted units for each resource ID and then import back to primavera.

For Example:

BOQ ITEM#

Description

Qty

Cost

090001

Floor Marble

10,000m3

600,000

 

 

 

 

 

In primavera schedule floor marble is distributed to 10 floors and we need to assign budgeted unit for material quantity resource, labor resource and BOQ cost non labor resource to primavera schedule.

Likewise, we have 20,000 activities in schedule so my question is what is the quick/fast way of loading each activity with these resources. i.e. How to populate primavera exported excel file with required budgted units?

Hope you understand my question.

You response will be highly appreciated.

Replies

Kemal KAHRAMAN
User offline. Last seen 2 years 13 weeks ago. Offline
Joined: 14 Aug 2017
Posts: 2
Groups: None

I prefer Nomitech CostOs cost estimator software. You can be Primavera activities with resources from CostOs BOQ items automaticly. CostOs using Primavera API integration successfully.

Khuong Do
User offline. Last seen 43 weeks 2 days ago. Offline
Joined: 21 Feb 2010
Posts: 114
Groups: None

Hi,

P6 give a function to quickly populate resource unit. You can refer to this article:

How does “Top Down Estimation” in Primavera P6 work? : https://doduykhuong.com/2016/07/08/how-does-top-down-estimation-in-primavera-p6-work/

Zoltan Palffy
User offline. Last seen 1 day 20 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2452
Groups: None

you will have to talk to who ever did the takeoff and made the Budget categories to see what was put into what bucket.

there has to be a basis for this estimate somewhere with sufficeint detail to get the budget numbers

is your company using and estimating tool ? if so you can probally get a detailed export out of it to excel and use that 

Ali Murtaza
User offline. Last seen 2 years 38 weeks ago. Offline
Joined: 19 Aug 2015
Posts: 30
Groups: None

Dear Johannes,

Thanks for the link.

Ali

Johannes Vandenberg
User offline. Last seen 1 day 20 hours ago. Offline
Joined: 21 Jan 2010
Posts: 222

Hi Ali

I found this link on the internet. 

http://www.planningengineer.net/super-cost-and-resource-loading-excel-tool/

Hopes that this helps

 

Ragards Johannes

Ali Murtaza
User offline. Last seen 2 years 38 weeks ago. Offline
Joined: 19 Aug 2015
Posts: 30
Groups: None

Dear Zoltan Palffy, as you said, “Copy/Paste” Activity ID & Activity Description, into the Resource tab TASKRSRC and then populate with budgeted units using resource name - Very nice I agree, But,

My question here is, in BOQ we have very few items, but, in primavera schedule its huge number of activities. What technique/template do you use to populate this huge Task List (Activity IDs) with resource budgeted units (BOQ).

How do I distribute a single BOQ item to a number of activities in primavera schedule?

Ali Murtaza
User offline. Last seen 2 years 38 weeks ago. Offline
Joined: 19 Aug 2015
Posts: 30
Groups: None

Dear Zoltan Palffy, as you said, “Copy/Paste” Activity ID & Activity Description, into the Resource tab TASKRSRC and then populate with budgeted units using resource name - Very nice I agree, But,

My question here is, in BOQ we have very few items, but, in primavera schedule its huge number of activities. What technique/template do you use to populate this huge Task List (Activity IDs) with resource budgeted units (BOQ).

How do I distribute a single BOQ item to a number of activities in primavera schedule?

Zoltan Palffy
User offline. Last seen 1 day 20 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2452
Groups: None

1st create the required resources

create a dummy actviity and right click and select assign resources and assign ALL of your labor and non laor resource to this dummy activity.

next export to excel the activities AND the Resource and Resource assignments

when exporting the file to excel make sure to include the resource type and budgeted units and activity name 

you will now have 2 tabs one for the activities called TASK and the other for the resource called TASKRSRC

now copy the activity id and description into the Resource tab TASKRSRC

now use the resource name from the dummay activity to populate the TASKRSRC tab with th ebudget units labor and on labor

Each resource will have to be on a seperate line. So the the same activity maybe listed seversl times.

 

Raymund de Laza
User offline. Last seen 4 days 14 hours ago. Offline
Joined: 22 Nov 2009
Posts: 716

There are no Shortcuts but there would be workaround between Excel and P6.

BTW, what type of Projects? A mass Housing Project or Tower Building?