Objective Score as a Weighted Average of Key Results
This lesson is part of the course
In this lesson
You weight nine key results by importance, roll them up into three objective scores with SUMIF ÷ SUMIF, and combine the objectives into one OKR score.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- KPI Definitions as Formulas: Ratios, Rates and Averages Locked
- Targets & Thresholds: Red, Amber, Green with IFS Locked
- Scoring Key Results 0–1: Linear Progress from Baseline to Target Locked
- Objective Score as a Weighted Average of Key Results Locked
- Cascading Team OKRs to Company Level with SUMPRODUCT Locked
- Leading vs Lagging Indicators: CORREL with a Lag Locked
- Trend & Variance vs Target over the Months Locked
- Metric Quality Checks: Completeness and Outliers Locked