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

Member for

8 years 2 months

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.

Member for

16 years 3 months

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 

Member for

10 years 2 months

Dear Johannes,

Thanks for the link.

Ali

Member for

10 years 2 months

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?

Member for

10 years 2 months

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?

Member for

16 years 3 months

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.

 

Member for

15 years 11 months

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?