Schedule Baseline vs Actual Dashboard Template (Excel) — Multi-Project Construction Schedule Performance + Portfolio Reporting System (SPI, Delays, Risks, Milestones & Change Orders)
If you manage multiple construction projects and need one clear view of what was planned vs what actually happened, this Schedule Baseline vs Actual Portfolio Dashboard gives you a complete, executive-ready system to track schedule performance, progress variance, delays, risks, milestones, change orders, and resource loading in one connected Excel workbook
.
Built for PMs, Planners, PMOs, Site Teams, Owners’ Reps, and Contractors, this template turns daily updates into real portfolio insights—so you can spot problems early, prioritize recovery actions, and report schedule status with confidence.
What this template helps you do (Schedule Control + Portfolio Visibility)
✅ Compare Baseline vs Actual for every project and activity
✅ Track Start/Finish variances and duration variance (days) automatically
✅ Monitor Earned Schedule / SPI and progress performance week by week
✅ Log delays with root cause, critical path impact, cost impact, and recovery actions
✅ Manage schedule risks with probability, impact, risk score, mitigation, and contingency plans
✅ Track critical milestones with baseline vs forecast vs actual dates + health status
✅ Control scope changes via a Change Orders log including schedule impact (days) + approvals
✅ Monitor resource allocation (hours/week, utilization %, rates, and weekly cost) across projects
✅ Produce an executive dashboard with health distribution, status breakdown, and portfolio KPIs
Portfolio Dashboard (Executive-Ready Reporting)
The dashboard consolidates key portfolio indicators such as:
✅ Total projects and active projects
✅ Average portfolio completion %
✅ Portfolio SPI (Schedule Performance Index)
✅ Open delays requiring action
✅ Active risks and high-priority items
✅ Milestones completed / at risk
✅ Baseline vs Actual % complete by project (visual comparison)
This makes it easy to present a clean weekly or monthly schedule report to leadership—without rebuilding slides every time.
What’s Included (14 Excel Sheets)
✅ Instructions — quick start and usage guidance
✅ Dashboard — portfolio view (health, status, KPIs, charts, summary table, alerts)
✅ Project List — master index for all projects
✅ Schedule Baseline — original planned schedule (activities, dates, duration, float, critical path flags, weights, planned value)
✅ Schedule Actual — real progress tracking (actual dates, % complete, variances, delay reasons, recovery actions)
✅ Milestone Tracker — critical dates monitoring (baseline vs forecast vs actual + variance days)
✅ Variance Analysis — schedule performance deep dive by project (root causes and recovery plans)
✅ Weekly Progress — earned schedule tracking (planned vs actual, SPI, accomplishments, blockers, next week plan, health)
✅ Delay Log — comprehensive delay register (days delayed, cumulative days, critical path impact, recovery targets, cost impact, lessons learned)
✅ Resource Allocation — workforce & equipment tracking (utilization, rates, weekly costs, availability notes)
✅ Risk Register — schedule risk management (probability, impact, score, mitigation, contingency, owner, status, review date)
✅ Change Orders — scope changes impacting schedule (schedule impact days, approval status, implementation status)
✅ Chart Data — backend chart calculations (do not edit unless advanced)
✅ Settings — lists and configuration to keep dashboards consistent
Who This Template Is For
✅ Construction Project Managers and Site Engineers
✅ Project Controls Engineers and Planners (Primavera/MS Project users who want an Excel reporting layer)
✅ PMOs managing multi-project portfolios
✅ Owners’ Representatives and Consultants
✅ Contractors, Subcontractor Managers, and Operations Leaders
✅ Any team that needs baseline vs actual schedule reporting without complex tools
How It Works (Simple Workflow)
✅ Step 1: Add your projects in Project List
✅ Step 2: Enter baseline activities in Schedule Baseline (IDs, dates, durations, weights, milestone flags)
✅ Step 3: Update progress in Schedule Actual (actual dates, % complete, reasons, actions)
✅ Step 4: Maintain your logs (Delays, Risks, Change Orders, Milestones, Resources, Weekly Progress)
✅ Step 5: Review the Dashboard for portfolio KPIs, health, alerts, and reporting tables
Key Benefits (Why teams use it)
✅ Faster reporting: one workbook replaces scattered trackers
✅ Better decisions: highlights where days are being lost (weather, materials, labor, permits, scope changes)
✅ Stronger accountability: owners, due dates, and status fields for actions and recovery
✅ More control: change orders, risks, and delays tied back to schedule impact
✅ Portfolio clarity: compare projects consistently using the same schedule performance logic
Requirements & Notes
✅ File type: Excel (.xlsx)
✅ Macro-free (no VBA)
✅ Works best in Microsoft Excel (desktop) for full formatting and chart behavior
✅ You can import into Google Sheets, but complex formatting/charts may need minor adjustments depending on your environment
