Tasks done
30%
Overdue tasks
1
Hours logged
15.5
Group Project Contract and Task Tracker
Agree team rules up front, assign and track tasks, and see each member’s share of the work before anyone feels it is unfair.
8 free task tracker templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 8 spreadsheets from Project Planning, Agile & Scrum and Study Planning. Start with Group Project Contract and Task Tracker, Project Tracker and Follow-up Cadence Tracker: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Tasks done
30%
Overdue tasks
1
Hours logged
15.5
Agree team rules up front, assign and track tasks, and see each member’s share of the work before anyone feels it is unfair.
Deliverables with owner, priority, dates, progress, health and a workload view by person.
Active prospects
6
Overdue follow-ups
5
Gone quiet (14+ days)
4
Plan the next touch for every prospect so no lead goes quiet, with overdue follow-ups on top.
Open bugs
5
Open critical
1
SLA breached
4
Bugs with severity, environment, owner and status, plus age, SLA breaches and time to resolve.
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.
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.
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.