Action item tracker
Keep action owners, due dates, completion dates, and overdue days in one working register.
2 tabs · 186 formulas
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.
Keep action owners, due dates, completion dates, and overdue days in one working register.
2 tabs · 186 formulas
Separate proposed cost changes from approved cost changes and track the effect on a project baseline.
2 tabs · 187 formulas
Record project decisions, decision owners, planned review dates, and review completion dates.
2 tabs · 186 formulas
Track a project's schedule and cost with planned value, earned value, SPI, CPI and an estimate at completion.
3 tabs · 1,110 formulas
Track open hiring requisitions, target fill dates, offer acceptance dates, elapsed days open, and days past target.
2 tabs · 186 formulas
Estimate person-hours per session, single-session cost, and monthly recurring cost from attendee count, duration, and loaded hourly rates.
2 tabs · 246 formulas
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
Task schedule with predecessors, lags and milestones, and a weekly Gantt that moves when dates or progress change.
4 tabs · 2,668 formulas
Track active project issues with owners, opened dates, target dates, and an explicit resolution date.
2 tabs · 186 formulas
Compare baseline milestone dates with current forecasts and actual completion dates.
2 tabs · 186 formulas
Assign Responsible, Accountable, Consulted and Informed roles to each task, and flag tasks with a missing or doubled Accountable.
3 tabs · 399 formulas
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
Record stakeholder ownership, last contact, desired contact interval, and the next contact date.
2 tabs · 186 formulas
Compare each person's weekly available hours with planned hours by project, and flag over- and under-allocation.
4 tabs · 1,982 formulas
Compare assigned training hours with completed hours for each employee and course.
2 tabs · 186 formulas
Track supplier renewal dates, required cancellation notice periods, notice cutoff dates, and days remaining before notice is due.
2 tabs · 186 formulas
Total daily hours by person and project, separating billable hours through an explicit input flag.
2 tabs · 186 formulas