Excel / Google Sheets Template
Project Health Command Center
A free Excel & Google Sheets dashboard that automatically scores your project's health across 10 weighted dimensions, flags your top attention areas, and rolls it all into a live executive dashboard — no setup, no formulas to build.
Free
Is Your Project Really on Track?
Most project trackers just list tasks and dates. The Project Health Command Center tells you the truth: an automatic, weighted health score across 10 dimensions of your project — so you know exactly where things stand before your stakeholders ask.
Rate each dimension Green, Amber, or Red, and the workbook does the rest — calculating your Overall Health Score (0–100), your RAG status, and your Top 3 Attention Areas automatically. Everything rolls up into a live executive dashboard with 5 charts, updating instantly as you fill in the other tabs.
Built for project managers, small business owners, and anyone running a project who wants real visibility without the cost or learning curve of enterprise PM software.
What’s inside (8 tabs)
- 01 Start Here — a 4-step quick-start guide plus the scoring-band legend, so you’re productive in your first minute.
- 02 Project Input — the basics (project name, dates, budget, % complete, status) that feed every other tab automatically, plus quick checks for budget used, time elapsed and progress vs time.
- 03 Health Check — rate 10 weighted dimensions (Scope, Schedule, Budget, Resources, Quality, Risks, Dependencies, Stakeholders, Communication, Delivery Readiness) Green / Amber / Red. Your Overall Health Score, RAG status, and Top 3 Attention Areas calculate automatically — this is the engine behind the whole workbook.
- 04 RAID Log — track Risks, Assumptions, Issues, and Dependencies with automatic IDs, a severity score on one 1–9 scale, overdue-review flags and a breakdown chart.
- 05 Milestones — plan key delivery dates and track status (On Track / At Risk / Delayed / Complete), with forecast variance, automatic overdue flags and roll-up counts.
- 06 Dashboard — your one-screen executive view: overall score, RAG status, budget utilization, 5 live charts, and your Top 3 Attention Areas.
- 07 Weekly Snapshot — log up to 4 weekly checkpoints and watch your health trend move over time, with a live “this week” row to copy from.
- 08 Gantt — a high-level, auto-populating Gantt chart spanning a full year — enter a Start Week and End Week per phase and the timeline bar draws itself, with the current week highlighted.
Works everywhere. Every formula, chart, and conditional format is built to render identically in Microsoft Excel and Google Sheets — no macros, no add-ons, no Apps Script.
See It In Action
Want the Complete System?
The Advanced Project Planner brings full planning, Kanban, Gantt, budget tracking, RAID management and reporting together in one workspace. Managing capital and operating spend? CapGate Pro tracks CapEx and OpEx with approval gates.