Template · Management
OKR scorecard with weighted key result grading
Grade each key result from its start value to its target, roll up objective scores and track weekly check-ins for a quarter.
Downloads are included in the $19.85 yearly membership. Sign in
XLSXCSVODSXMLNumbers| OKR scorecard with weighted key result grading | |||||||||||
| Example data — replace the blue input cells with your own. | |||||||||||
| OVERALL SCORE (WEIGHTED BY OBJECTIVE) | KRS ON TRACK | KRS OFF TRACK | |||||||||
| 0.61 | 3 | 1 | |||||||||
| Settings | |||||||||||
| Team | Example Operations team | ||||||||||
| Quarter | 2027 Q1 | ||||||||||
| Quarter start date (week 1 of the check-ins) | Jan 4, 2027 | ||||||||||
| On track: score at or above | 0.70 | Common convention for 0-to-1 OKR grading; set the bands your team uses | |||||||||
| At risk: score at or above | 0.40 | Below this score the item is Off track | |||||||||
| Objectives | |||||||||||
| Obj ID | Objective | Objective weight | Score | Status | Key results | Weighted score | KR weights | ||||
| O1 | Ship orders on time | 40% | 0.66 | At risk | 3 | 0.265 | 100% |
Showing the first 16 of 48 rows and 12 of 12 columns. Cells with formulas show the formula on hover.
| Weekly check-ins | |||||||||||
| One row per key result, in the same order as the Scorecard. Enter the measured value each week; leave later weeks blank. | |||||||||||
| Weekly values (blue cells are inputs; latest value and week are formulas) | |||||||||||
| KR ID | Key result | Jan 4, 2027 | Jan 11, 2027 | Jan 18, 2027 | Jan 25, 2027 | Feb 1, 2027 | Feb 8, 2027 | Feb 15, 2027 | Feb 22, 2027 | Mar 1, 2027 | Mar 8, 2027 |
| KR1.1 | On-time shipment rate | 89.0 | 90.5 | 91.0 | 92.5 | 93.0 | 94.0 | 94.5 | 95.5 | ||
| KR1.2 | Orders shipped the same day | 72.0 | 74.0 | 75.0 | 76.0 | 78.0 | 79.0 | 80.0 | 81.0 | ||
| KR1.3 | Average hours from order to dock | 8.6 | 8.4 | 8.4 | 8.1 | 7.9 | 7.6 | 7.4 | 7.2 | ||
| KR2.1 | Picking errors per 1,000 picks | 11.2 | 10.8 | 10.1 | 9.6 | 9.0 | 8.4 | 7.9 | 7.1 | ||
| KR2.2 | Inventory count accuracy | 95.0 | 95.4 | 95.9 | 96.2 | 96.8 | 97.0 | 97.4 | 97.9 | ||
| KR2.3 | Returns processed within 48 hours | 62.0 | 63.0 | 61.0 | 65.0 | 64.0 | 66.0 | 68.0 | 67.0 | ||
| KR3.1 | Cost per order | 4.7 | 4.7 | 4.7 | 4.6 | 4.6 | 4.5 | 4.5 | 4.4 | ||
| KR3.2 | Overtime as a share of paid hours | 13.5 | 13.0 | 12.6 | 12.1 | 11.8 | 11.2 | 10.9 | 10.4 | ||
| KR4.1 | Weekly report published by Monday 10:00 | 60.0 | 70.0 | 75.0 | 80.0 | 85.0 | 90.0 | 90.0 | 95.0 | ||
| KR4.2 | Team members with a data skills plan | 3.0 | 3.0 | 4.0 | 4.0 | 5.0 | 5.0 | 6.0 | 6.0 | ||
Showing the first 16 of 25 rows and 12 of 17 columns. Cells with formulas show the formula on hover.
| OKR scorecard with weighted key result grading |
| Notes: what this workbook does, how to use it and the method behind it. |
| What it does |
| Grades each key result from its start value toward its target, rolls the key results up into objective scores, and gives a team an overall score for the quarter. |
| How to use it |
| 1. On the Scorecard tab, enter the team, the quarter name and the quarter start date, and set the grading bands. |
| 2. List up to five objectives with their weights, and give each objective's key results an objective ID. |
| 3. Enter each key result's start value, target value, unit and weight. A decreasing target, such as cost per order, is entered the same way. |
| 4. On the Check-ins tab, enter the measured value in the week column it belongs to, one row per key result. |
| 5. Read the progress, status and objective scores on the Scorecard; the tiles at the top give the overall score and the counts. |
| Formulas and method |
| Progress = (current value - start value) / (target value - start value), limited to the range 0 to 1. The same formula works for an increasing and a decreasing target. |
| Current value: the latest value on the Check-ins tab, or the start value when a key result has no check-in yet. |
Showing the first 16 of 34 rows and 1 of 1 columns. Cells with formulas show the formula on hover.
What does this template do?
An OKR scorecard tracks a team's objectives and key results through a quarter. It is for team leads and managers who review progress each week and want one scale for every key result.
Each key result has a start value, a target and a weight. Progress is the position of the current value between the start and the target, limited to 0 to 1, so it works for targets that go down as well as up. The current value is the latest weekly check-in. An objective score is the weighted average of its key results, and the overall score is weighted by objective. Each key result is graded On track, At risk or Off track against bands you set; the defaults are 0.7 and 0.4.
The Check-ins tab holds thirteen weeks of values for up to twenty key results, with week start dates counted in steps of seven days from the quarter start. The example is a fictional operations team with four objectives, twelve key results and eight weeks of data.
What’s inside
- Progress from start to target, limited to 0 to 1, for increasing and decreasing targets
- Current value taken from the latest weekly check-in, or the start value when there is none
- Objective scores as weighted averages of key results, and an overall score weighted by objective
- On track, At risk and Off track grades against bands you set
- Thirteen weekly columns with one row per key result
Which tabs does the workbook have?
| Tab | What it holds |
|---|---|
| Scorecard | Team and quarter settings, objective scores, key results with progress, status and weights, and checks. |
| Check-ins | Thirteen weekly columns for each key result, with the latest value and the week it was entered. |
| Notes | Purpose, steps, formulas used, assumptions and limits. |
What formulas does this template use?
This template holds 224 formulas in 465 cells across 3 tabs, so 48% of its cells calculate. They use 14 distinct functions; the longest formula is 312 characters and 81 of them read from another tab.
| Function | Uses | What it does |
|---|---|---|
IF | 359 | one result when a test is true, another when false |
COUNT | 80 | counts numeric cells |
INDEX | 40 | value at a position in a range |
MAX | 20 | largest value |
MIN | 20 | smallest value |
SUMIF | 12 | adds values meeting one condition |
SUMIFS | 10 | adds values meeting several conditions |
COUNTIF | 9 | counts cells meeting one condition |
OR | 5 | true when any test is true |
COUNTIFS | 4 | counts cells meeting several conditions |
SUM | 3 | adds numbers |
SUMPRODUCT | 2 | multiplies matching entries, then adds them |
The 12 most used of 14 functions. Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.
How do you use it?
- On the Scorecard tab, enter the team, the quarter and the quarter start date.
- List up to five objectives with their weights, then add up to twenty key results with start, target and weight.
- On the Check-ins tab, enter each key result's measured value in the week it belongs to.
- Read the progress, status and objective scores; the tiles give the overall score and the counts.
What is it good for?
- Weekly review of quarterly OKRs for one team
- Comparing objective progress across teams that use the same scale
- Preparing an end-of-quarter OKR summary
- Tracking a cost or error-rate key result that should go down
Questions about this sheet
Can a key result have a target below its start value?
Yes. Progress is measured from start to target in either direction, so a cost or error-rate key result works the same way as a growth one.
What is the current value before the first check-in?
The start value, so progress is zero until a check-in is entered.
Why are 0.7 and 0.4 the default grade bands?
They are a common convention for 0-to-1 OKR grading, not a standard. Change them on the Scorecard tab to match your team.
Does the workbook detect a gap in the check-ins?
No. The latest value is the last value entered from left to right, so enter the weeks in order.