Download Excel workbook · September 2026 / v1.0 · No account required
Before you start
Use for a compact project or portfolio milestone review. Calendar-day variance is an indicator; assess driving logic and contractual calendars in the native schedule.
- Approved baseline and revision reference
- Current forecast schedule and data date
- Milestone definitions and responsible owners
- Actual completion evidence and agreed actions
How to use it
Keep a stable comparison
Identify each milestone by its native schedule ID and retain the approved baseline reference. Do not overwrite the baseline simply to remove unfavorable variance.
Explain date movement
Record the current forecast or actual completion date. The calculated variance uses actual completion where present, otherwise forecast, less baseline; positive values mean later in calendar days.
Connect variance to decisions
Explain the driving cause and the next action. Preserve approved baseline changes through the project's change procedure and retain the prior record.
Fields included
- ID
- Milestone / completion criteria
- Owner
- Baseline date
- Forecast date
- Actual date
- Variance (calendar days)
- Status
- Cause / next action
- Schedule / evidence reference
Forecast followed by actual completion
Illustrative example: a milestone baselined for 18 November is forecast for 25 November, a positive seven-calendar-day variance. Once actual completion on 23 November is entered, the register shows five days. The schedule remains the source for logic and contractual time analysis.
Before issue
- Baseline dates match the identified approved revision.
- Actual completion is supported by evidence.
- Positive variance is understood as later, not better.
- Calendar-day comparison is distinguished from working-day entitlement.
Practice references
- GAO Schedule Assessment Guide, GAO-16-89G
Original Kairos working templates informed by common project-controls practice. Adapt them to your contract, project procedure and approval authority. They are not official standards-body forms or a certification of compliance.
Editorial standards