Excel LADZ
patreon
Warren Nolan - College Basketball ELO Model
🕑 Added 2024-11-17 23:04:49 +0000 UTCG'day, lads! Attached is a model which uses the College Basketball ELO Ratings compiled by the website "Warren Nolan". Here is a link to their website: https://www.warrennolan.com/basketball/2025/elo
In this model, all I've done is import each team's ELO Ratings using a Power Query in Excel. To refresh this data, and bring in each team's most updated ELO Rating, go to the 'Data' tab and select the "Refresh All" icon.
Then, select two teams from the drop-down list in the "Dashboard" worksheet. Each team's ELO Rating is compared and the home team is given a 100 point ELO advantage. The following formula determines the Win % for each team:
"Ea" represents the probability of "Team A" winning, with "Ra" their ELO Rating and "Rb" the opposition's ELO Rating.
If you have any questions lads, let me know in the comments below!
Comments
Excel LADZ
Hello, Cody! These rankings are done by the Warren Nolan website. I've just used these in conjunction with the ELO Win % formula to come up with a simple model 👍
Cody
when you refresh all on the data the rankings don't line up with the ap poll or the coaches poll. just curious as to what the ranking system is accurate with.
