Project Tracker
Deliverables with owner, priority, dates, progress, health and a workload view by person.
9 free project task management tracker templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 9 spreadsheets from Project Planning, Agile & Scrum and Schedules & Timelines. Start with Project Tracker, Earned Value Management Tracker and Project Budget Tracker: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Deliverables with owner, priority, dates, progress, health and a workload view by person.
Budget at completion
$820,000
Earned value
$409,350
Project CPI
0.9
PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.
Total budget
$119,000
Spent to date
$66,340
Cost performance (CPI)
0.9
Budget, commitments and actual spend by work package, with earned value, cost performance and forecast at completion.
Milestones achieved
3
Late
1
At risk
1
Key milestones with baseline and forecast dates, slippage in days and a status for each project.
Portfolio budget
$3,305,000
Spent to date
$2,027,500
Portfolio CPI
1
Every project’s budget, spend, progress and RAG status in one place, rolled up by programme.
Open bugs
5
Open critical
1
SLA breached
4
Bugs with severity, environment, owner and status, plus age, SLA breaches and time to resolve.
Pass rate
60%
Failed
2
Not run or blocked
3
Test cases with steps, expected result, pass or fail by run, linked defects and pass rate by module.
Open issues
4
To escalate
3
Average days to resolve
5
Problems that need solving now: severity, owner, age, resolution and how long issues take to close.
Updates logged
12
Open blockers
3
Average confidence
3.7
Record each person’s update, blockers and sprint confidence every day, and chase open blockers to closure.