Started By
Message

re: College Basketball Program Rankings

Posted on 4/9/24 at 9:58 am to
Posted by AUTiger789
Birmingham, AL
Member since Apr 2022
1611 posts
Posted on 4/9/24 at 9:58 am to
quote:

I would add an age factor as well. Ex, last 20 years, your values are x 1. 20 years previous x .9, etc.


I thought about this. I can easily do it with the way it’s built out… difficult to figure out how to value it.

I think it could also cause for some whacky rankings like UConn being up ahead of Kentucky, etc if you go too hard.
Posted by paperwasp
11x HRV tRant Poster of the Week
Member since Sep 2014
23197 posts
Posted on 4/9/24 at 9:58 am to
quote:

College basketball is 100% all about the NCAA Tournament

I don't know if you're SOG doing a bit, or someone trying to emulate SOG and simply doing so poorly, but when he did this annually, he scored it thusly, for comparison:
quote:

> National Title - 150 points
> National Runner Up - 75 points
> Final Four Semifinal - 50 points
> Elite 8 - 25 points
> Sweet 16 - 15 points
> Round 32 - 10 points
> Round 68 - 5 points
> Conference Championship (Regular Season) - 12 points
> Conference Tournament Championship - 5 points
> Losing Season - (-5 pts)
Posted by AUTiger789
Birmingham, AL
Member since Apr 2022
1611 posts
Posted on 4/9/24 at 10:05 am to
SOG’s are interesting to look at. To each their own. But as I’ve noted I think when comparing teams from a multitude of different conferences, conference titles, wins/losses, etc muddies things up.

This post was edited on 4/9/24 at 10:09 am
Posted by swinetime
Member since Apr 2013
4479 posts
Posted on 4/9/24 at 10:30 am to
I like it. For all those saying its not including reg season....reg is just for building a resume for the tourney. Hell Ar won the SWC just about every year so im sure it would add to our numbers but the tourney performance is what you are judged on. Coaches get run off winning reg season and under performing in the tourney right cats
Posted by TheTideMustRoll
Birmingham, AL
Member since Dec 2009
8906 posts
Posted on 4/9/24 at 10:40 am to
quote:

College basketball is 100% all about the NCAA Tournament.


Then why not skip the regular season and just hold a big tournament each year?
Posted by AUTiger789
Birmingham, AL
Member since Apr 2022
1611 posts
Posted on 4/9/24 at 10:42 am to
quote:

Then why not skip the regular season and just hold a big tournament each year?


Because the regular season is what decides the Tournament Field. This is not as hard as some of you choose to make it.
Posted by Hogfan13
Member since Jul 2019
2958 posts
Posted on 4/9/24 at 10:46 am to
quote:

127. Ole Miss- 11.65


Posted by bamameister
Right here, right now
Member since May 2016
14313 posts
Posted on 4/9/24 at 10:54 am to
quote:

I like it. For all those saying its not including reg season....reg is just for building a resume for the tourney. Hell Ar won the SWC just about every year so im sure it would add to our numbers but the tourney performance is what you are judged on. Coaches get run off winning reg season and under performing in the tourney right cats


You just keep losing to your rivals and the fans will let you know how they feel. They don't spend millions on tickets to watch anything less than your best.
Posted by AUTiger789
Birmingham, AL
Member since Apr 2022
1611 posts
Posted on 4/9/24 at 10:54 am to
Some interesting notes:

Since 2020, Alabama has risen under Nate Oats from #52 to #40.

Since 2018, Tennessee has risen under Barnes from #52-43

Since 2018, Auburn has risen under Pearl from #87 to #64.

When LSU made their last Final Four in 2006, they got up to #25 at the time but have since fallen 10 spots to #35.

At the end of the 2004 season, Florida ranked #42 but have since risen to #15… mostly due to two national titles.
Posted by momentoftruth87
Member since Oct 2013
71544 posts
Posted on 4/9/24 at 10:57 am to
quote:

Meh, this is a good metric for performance in the NCAA tourney. Nothing more than that.

You need points for 20 win seasons, regular season conference titles and conference tourney championships.


if you added those I doubt it would change much
Posted by AUTiger789
Birmingham, AL
Member since Apr 2022
1611 posts
Posted on 4/9/24 at 10:59 am to
More interesting notes:

Top programs without a national title:
#17 Oklahom, #19 Purdue, #20 Illinois, #22 Gonzaga, #26 Texas

Top programs without a Final Four:
#38 Xavier, #43 Tennessee, #48 Missouri, #50 Pittsburgh, #54 BYU

Top program without an Elite 8: #79 Texas A&M
Posted by paperwasp
11x HRV tRant Poster of the Week
Member since Sep 2014
23197 posts
Posted on 4/9/24 at 11:10 am to
quote:

Some interesting notes

How are you denoting this (the change in ranking over time)?

Do you have 85 columns of calculated values for some 330-odd teams?
Posted by AUTiger789
Birmingham, AL
Member since Apr 2022
1611 posts
Posted on 4/9/24 at 11:15 am to
quote:

Do you have 85 columns of calculated values for some 330-odd teams?


I have about 150 teams’ NCAA history uploaded into a master spreadsheet. I have some XLOOKUP factors and a giant pivot table that allows me to filter by team and by year.
This post was edited on 4/9/24 at 11:17 am
Posted by HogPharmer
Member since Jun 2022
1348 posts
Posted on 4/9/24 at 11:22 am to
quote:


Meh, this is a good metric for performance in the NCAA tourney. Nothing more than that.

You need points for 20 win seasons, regular season conference titles and conference tourney championships.


The regular season is what positions you to get more of the points used in this metric. Better regular season earns you higher seeding in the tourney, which should translate to more points in this grading rubric. The regular season is (theoretically) indirectly calculated into this.
Posted by momentoftruth87
Member since Oct 2013
71544 posts
Posted on 4/9/24 at 11:24 am to
quote:

The regular season is what positions you to get more of the points used in this metric. Better regular season earns you higher seeding in the tourney, which should translate to more points in this grading rubric. The regular season is (theoretically) indirectly calculated into this.


Glad some people use their noggins.
Posted by paperwasp
11x HRV tRant Poster of the Week
Member since Sep 2014
23197 posts
Posted on 4/9/24 at 11:27 am to
quote:

XLOOKUP

Nice way to do it.

That was essentially where I was going with this, whether you had it in a spreadsheet or a database queried directly through code.

Sounds like a little bit of both, depending on the variables in your cells.

Would be cool to see one of those animations of someone's (like the SEC's) charted rankings over time.

Posted by Gordy
Fayetteville
Member since Dec 2015
1729 posts
Posted on 4/9/24 at 11:27 am to
You can definitely tell Bama fans haven't had much success in basketball historically. They always seem to be the ones bumping their chests about regular seasons.
Posted by AUTiger789
Birmingham, AL
Member since Apr 2022
1611 posts
Posted on 4/9/24 at 11:37 am to
My excel skills are certainly above average but are also not exactly stellar to say the least.
Posted by Temple of the Dog
Member since Nov 2019
368 posts
Posted on 4/9/24 at 11:38 am to
quote:


My excel skills are certainly above average but are also not exactly stellar to say the least.


Anything beyond VLookup and Pivot Table is just showing off
Posted by paperwasp
11x HRV tRant Poster of the Week
Member since Sep 2014
23197 posts
Posted on 4/9/24 at 11:48 am to
quote:

You can definitely tell Bama fans haven't had much success in basketball historically

Someone posted a ranking the other day of total program wins, with Alabama now coming in at 30th.

What you might not realize is that some of us are quite proud of that.

first pageprev pagePage 2 of 3Next pagelast page

Back to top
logoFollow SECRant for SEC Football News
Follow us on Twitter and Facebook to get the latest updates on SEC Football and Recruiting.

FacebookTwitter