Letter Grades: Mapping Scores with an Approximate VLOOKUP
This lesson is part of the course
In this lesson
You convert scores into letter grades with an approximate-match lookup, find each company's band number and the points it needs for the next grade, and count the companies at BBB or better.
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
- Raw ESG Indicators & Data Coverage: Counting What Is Really Reported Locked
- Normalisation: Min-Max, Z-Score and Percentile Rank Locked
- Direction: Turning Lower-Is-Better Indicators into Scores Locked
- Pillar Scores: Averaging Indicators into E, S and G, Then Weighting Locked
- Industry Materiality: Sector Weights with a Lookup Locked
- Controversy Deductions: Penalties, a Floor at Zero and a Watchlist Locked
- Letter Grades: Mapping Scores with an Approximate VLOOKUP Locked
- Weight Sensitivity & Rating Disagreement: Ranks, CORREL and a Scatter Locked