Weighted Score with SUMPRODUCT, RANK.EQ & a SORTBY Leaderboard
This lesson is part of the course
In this lesson
You weight the five normalised vendor scores, rank them, build a live leaderboard with SORTBY and measure how close the race is.
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