Earned value management (EVM) project tracker
Track a project's schedule and cost with planned value, earned value, SPI, CPI and an estimate at completion.
3 tabs · 1,110 formulas
Templates
Management spreadsheet templates
Templates for running projects and teams with numbers instead of impressions. Track a project's cost and schedule performance with earned value (SPI, CPI, EAC), make every task's owner explicit in a RACI matrix that flags gaps and duplicates, score objectives and key results, rank risks by probability and impact, and compare each person's weekly capacity with the work assigned to them.
The structures follow widely used practice (PMI's earned value terms, the RACI convention, 0-to-1 OKR grading, 5-by-5 risk scoring); adapt the scales to the way your organization works.
OKR scorecard with weighted key result grading
Grade each key result from its start value to its target, roll up objective scores and track weekly check-ins for a quarter.
3 tabs · 224 formulas
Project Gantt chart with dependencies and milestones
Task schedule with predecessors, lags and milestones, and a weekly Gantt that moves when dates or progress change.
4 tabs · 2,668 formulas
RACI matrix template with gap and overlap checks
Assign Responsible, Accountable, Consulted and Informed roles to each task, and flag tasks with a missing or doubled Accountable.
3 tabs · 399 formulas
Risk register with probability and impact scoring
Score each project risk by probability and impact, track its response and residual score, and see open risks on a heat map.
4 tabs · 585 formulas
Team capacity planner by week
Compare each person's weekly available hours with planned hours by project, and flag over- and under-allocation.
4 tabs · 1,982 formulas