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.