Most OKR spreadsheets are scoreboards nobody updates after week two. The scoring is manual, so it drifts. The confidence is a color someone picks by feel. By the end of the quarter the sheet says 0.8 and the program says otherwise, and everyone quietly agrees not to mention it.
This one calculates the score. You enter where the metric started, where it needs to land, and where it is now; the sheet works out how far you have travelled and clamps it between 0.0 and 1.0. That takes the argument out of scoring and puts it back where it belongs, on whether the key result was the right one.
What's inside
Scores that compute themselves
Start, target, current. The formula handles metrics going down (cycle time) as well as up (adoption), so you do not need two versions of the sheet.
A confidence column that earns its place
On track, At risk, Off track, color coded. Confidence dropping while the score holds steady is the earliest signal you get that a quarter is going sideways.
0.7 is a good quarter
The sheet colors 0.7 and above green on purpose. If every objective lands on 1.0, the objectives were targets, not stretches.
How to use it
- Write 2 or 3 objectives. Not 6. The number is the whole discipline.
- Under each, add 2 to 4 key results with a real start and target number. If you cannot name a start value, it is not a key result yet.
- Update Current weekly. It takes two minutes and it is the only reason the sheet stays honest.
- Score at quarter end, then ask the question the score cannot answer: was this the right key result to chase?
When you outgrow the free version
The full OKR Tracker ($29) adds check-in history and the quarterly reflection sheet. OKRs decide what to measure; the Roadmap Tracker ($29) sequences the work that claims to move them, and the two are different jobs. Both sit in the Outcome & Planning Pack ($59), or take all 17 tools for $99.
Questions PMs ask
Is this really free?
Yes. Email in, file out, unsubscribe anytime. No card, no trial.
Does it work in Google Sheets?
Yes. The scoring formulas, the dropdowns, and the color rules all carry over when you upload the .xlsx. Some people search for an OKR template in xls format; this is the modern .xlsx equivalent and opens in any version of Excel from 2007 on, and in Sheets.
How does the scoring formula work?
It measures how far the current value has travelled from the start value toward the target, then clamps the result between 0.0 and 1.0. Overshooting reads as 1.0, going backwards reads as 0.0. Because it subtracts rather than divides, it handles metrics that need to go down as cleanly as ones that need to go up.
What does the $29 OKR Tracker add?
Check-in history, so you can see confidence changing week over week instead of only at quarter end, and a quarterly reflection sheet that turns the scores into decisions about next quarter. The free file scores the quarter; the paid one runs it.