Scheduling · XER, XML or Excel file exchange
Primavera P6 activity mapping for billing
Map Primavera P6 activities to BOQ items, then compare measured progress with the schedule and send quantities back for the progress update.
Data that moves each way
Only these items move, only for the work orders you turn on.
- From Primavera P6
Activity list with IDs, names and WBS, from an XER, XML or Excel export
In - To Primavera P6
Measured quantity to date per activity, as an Excel sheet for the progress update
Out - To Primavera P6
Billed value per WBS element, for the planning team
Out
Field mapping. Tatha Vastu to Primavera P6.
| Tatha Vastu | Primavera P6 |
|---|---|
| BOQ item | Activity ID |
| Work order section | WBS element |
| Measured quantity to date | Actual units |
| Per cent of BOQ executed | Physical per cent complete |
| Certified value to date | Earned value column |
Setup in 4 steps
- Export the project from Primavera P6 as XER, XML or Excel, and upload it under Integrations.
- Map each activity to one or more BOQ items. Tatha Vastu suggests matches by name and WBS.
- Each month, download the progress sheet with measured quantity and per cent complete per activity.
- Import the sheet in Primavera P6 to update progress, then upload the new export when the schedule is revised.
- 1. Export the project from Primavera P6 as XER, XML or Excel, and upload it under Integrations.Done
- 2. Map each activity to one or more BOQ items. Tatha Vastu suggests matches by name and WBS.Done
- 3. Each month, download the progress sheet with measured quantity and per cent complete per activity.Done
- 4. Import the sheet in Primavera P6 to update progress, then upload the new export when the schedule is revised.Now
Is the link with Primavera P6 live?
No. It works through the files P6 already exports and imports: XER, XML and Excel. No server connection is needed.
Can one BOQ item feed several activities?
Yes. Split the item's quantity across activities by location, for example by floor or by chainage.
What happens when the schedule is revised?
Upload the new export. Mapped activities keep their links; new activities are listed for mapping.
Does billing depend on the schedule?
No. Bills come from approved measurements. The schedule link is for planning and progress reports.