Contractor Progress Roll-Up ALPHA
You hold a summary (L2) programme; your contractor holds a detailed (L3/4) one, progressed to their data date. Map each of your activities to a date span in their programme (two anchor activities) and this tool derives your percent complete, actual start, and a calendar-corrected remaining duration so your activity lands on the contractor's dates, through an accept/reject review, with an auditable report and an updated XER.
🔒 Both files are parsed in your browser and never uploaded.
1 · Load schedules
Your XER and the contractor's are required. Baselines are optional and drive the integrity checks.
2 · Dates & roll-up settings
3 · Baseline integrity
4 · Map activities to anchor spans
Pick one of your activities, then pick a start and end anchor in the contractor schedule (click a contractor row, then Set start / Set end). The window is the start anchor's start through the end anchor's finish. When the window looks right, press Add / update mapping below the table to save the anchor span. Click a column heading to sort; the tables scroll sideways for the full detail.
What do these controls and figures mean?
Population scope limits which contractor activities count toward the roll-up, so a wide window doesn't sweep in unrelated parallel work. Whole schedule uses every activity in the window; WBS branch of anchors keeps only activities under the same WBS branch as your anchors.
Overlap rule decides how an activity qualifies for the window. Overlaps (default) counts any activity whose dates touch the window; Fully inside counts only activities that start and finish within it.
In the summary line: Window is the anchor date span; population is the count of contractor activities contributing; source is how many take their percent from physical vs duration; ΣW is the total of the weights applied; Rolled % is the weighted-average percent complete; remaining is the duration in your activity's own calendar needed to finish on the anchor's date.
My activities
Contractor schedule
5 · Mappings
Coverage: unmapped contractor work
6 · Review: every change is a decision
7 · Outputs
The updated XER changes only accepted rows and only progress fields. In P6: import, then schedule (F9) to your target data date. The tool proposes inputs; P6's scheduler produces the dates.
Save your roll-up profile so you can reuse these mappings next period without rebuilding them.
Why a calendar correction?
P6 derives dates from remaining duration on each activity's own calendar when you schedule (F9). Your summary activity and the contractor's detail often run on different calendars: a 5-day/8-hour week versus a 6-day/10-hour one. The same finish date is a different number of working hours on each. This tool computes the remaining duration in your calendar so that scheduling from your data date lands your activity on the contractor's date, rather than copying a duration number that would put it weeks out.