Criteria & Weights: Making Them Add Up to 100%
All lessons
- Criteria & Weights: Making Them Add Up to 100%Free
- Scoring Scales & Normalisation: Min-Max, Higher vs Lower Is Better Pro
- Weighted Score with SUMPRODUCT, RANK.EQ & a SORTBY Leaderboard Pro
- Must-Have Knock-Out Criteria with IF and AND Pro
- Pairwise Comparison Weights (AHP-Style Row Averages) Pro
- Sensitivity: How Far Must a Weight Move to Flip the Winner? Pro
- Multiple Evaluators: Averages, Spread & Disagreement Flags Pro
- Final Decision Dashboard: Score, Rank, Budget Cut-Off & Sorted Bar Chart Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Loading the spreadsheet…