Criteria & Weights: Making Them Add Up to 100%
This lesson is part of the course
In this lesson
You turn the steering group's importance points into weights, repair a manager's weight set that adds up to 105% and add a validation rule that blocks any weight above 40% for Larkfield Outdoor's warehouse-software selection.
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
- Criteria & Weights: Making Them Add Up to 100% Locked
- Scoring Scales & Normalisation: Min-Max, Higher vs Lower Is Better Locked
- Weighted Score with SUMPRODUCT, RANK.EQ & a SORTBY Leaderboard Locked
- Must-Have Knock-Out Criteria with IF and AND Locked
- Pairwise Comparison Weights (AHP-Style Row Averages) Locked
- Sensitivity: How Far Must a Weight Move to Flip the Winner? Locked
- Multiple Evaluators: Averages, Spread & Disagreement Flags Locked
- Final Decision Dashboard: Score, Rank, Budget Cut-Off & Sorted Bar Chart Locked