Project Tracker
Deliverables with owner, priority, dates, progress, health and a workload view by person.
12 free trackers project templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 12 spreadsheets from Project Planning, Construction Project Management and Agile & Scrum. Start with Project Tracker, Project Budget Tracker and Freelance Client & Project 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.
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.
Paid this year
$6,800
Awaiting payment
$9,200
Ready to invoice
$3,200
Every project with client, fee, hours logged, effective hourly rate, deadline and invoice status.
Milestones achieved
3
Late
1
At risk
1
Key milestones with baseline and forecast dates, slippage in days and a status for each project.
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.
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.
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.
Open bugs
5
Open critical
1
SLA breached
4
Bugs with severity, environment, owner and status, plus age, SLA breaches and time to resolve.
On hire now
3
Hire cost to date
$6,374
Long hires to review
1
Owned and hired equipment by site with hire days and cost (stopping at off-hire), long-hire reviews, service due dates for owned kit, and totals by site.
Committed
$208,350
Paid to date
$62,535
Retainage held
$6,276
Subcontract values with approved change orders, value earned from percent complete, retainage held, payments logged and the amount due now, with over-payment warnings.
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.
Warranties tracked
10
Expiring within 90 days
4
Expired
0
Every warranty on a completed building with start date, term, expiry countdown, documents on file and a claims log.