Started By
Message
I accidentally created the (almost) perfect cfb league with excel.
Posted on 5/22/24 at 3:30 pm
Posted on 5/22/24 at 3:30 pm
I created this like 3 months ago and figured I would post it instead of letting it die. Take a look if your interested!
I was playing around with excel the other day and decided to sort every P5 school by coordinates....this is what it spit out. The powers that be would never allow something so simple and logical, but I thought you guys would like it.
I'll list details and my proposed tweaks below for the Vols, Cocks, and Commodores.
These divisions were mathematically created by sorting coordinates from East to West into 5 sections, then halving them by sorting them from North to South. You can look at it as an abstract map of the United States.
Notes:
I added Memphis and Tulane to round it out to 70, but they could be changed.
Texas Tech, Tennessee, SC, and Kentucky kind of get screwed without tweaking. Everyone else is relatively unscathed, if not improved.
Tweaks:
Vandy and Tennessee should trade spots
SC and UCF should trade spots.
Sorry UK and Vandy. (I actually think this works out well for both of you.)
Format:
*1 League - 70 Teams - 10 Conferences
*Rotating Sister/Legacy Conferences to maintain regionality (Color coded)
*Rotating Non Conference Games
*Randomized lottery games every year
*No Conference Championship games
*16 Team Playoff (10 Champs + 6 next best based on W-L and h2h)
-12 Regular Season Games Total
-6 Conference Games - Teams play all other teams in their conference
-2 Legacy Conference Games - Teams play 2 games against "sister" conference. Example: Midsouth team a plays Home&Home against 2 Southeastern teams, then rotates (7 years to cycle).
-2 Rotating Non Conference Games - Same concept as Legacy games, except you rotate every two years to a completely different conference. Think Pacific North vs. Midwest Challenge type thing that we have in basketball, but with a Home&Home format.
-2 Lottery/Rivalry games - Yearly lottery games that produce randomized opponents across the country. These game slots could also be reserved to preserve a rivalry if needed.
***Rotating matchups for Legacy and NonCon games could be totally random, based on previous year standing like the NFL, or a combination of the two. NFL style model creates more parity, compelling matchups and more meaningful games all the way down.
***Add one or two more games if you want so everyone has a G5 game(s). Could be good for all levels of cfb, G5 and P5 alike.
This isn't my wheelhouse, but profits and money distribution can be done in a lot of ways, but I'm in favor of a system that rewards the players and programs for winning and investing time and resources to be better. Reward teams based on wins and contribution to the overall product. Bonuses to players, coaches, and programs for making the playoffs and winning championships etc.
This checks all the boxes as far as I'm concerned. Regionality is preserved, rivalries are preserved, and parity is increased without punishing blue bloods, and PLAYOFFS/CHAMPIONS ARE BASED ON W-Ls.
Thanks for humoring my grand idea. Thoughts?
I was playing around with excel the other day and decided to sort every P5 school by coordinates....this is what it spit out. The powers that be would never allow something so simple and logical, but I thought you guys would like it.
I'll list details and my proposed tweaks below for the Vols, Cocks, and Commodores.
These divisions were mathematically created by sorting coordinates from East to West into 5 sections, then halving them by sorting them from North to South. You can look at it as an abstract map of the United States.
Notes:
I added Memphis and Tulane to round it out to 70, but they could be changed.
Texas Tech, Tennessee, SC, and Kentucky kind of get screwed without tweaking. Everyone else is relatively unscathed, if not improved.
Tweaks:
Vandy and Tennessee should trade spots
SC and UCF should trade spots.
Sorry UK and Vandy. (I actually think this works out well for both of you.)
Format:
*1 League - 70 Teams - 10 Conferences
*Rotating Sister/Legacy Conferences to maintain regionality (Color coded)
*Rotating Non Conference Games
*Randomized lottery games every year
*No Conference Championship games
*16 Team Playoff (10 Champs + 6 next best based on W-L and h2h)
-12 Regular Season Games Total
-6 Conference Games - Teams play all other teams in their conference
-2 Legacy Conference Games - Teams play 2 games against "sister" conference. Example: Midsouth team a plays Home&Home against 2 Southeastern teams, then rotates (7 years to cycle).
-2 Rotating Non Conference Games - Same concept as Legacy games, except you rotate every two years to a completely different conference. Think Pacific North vs. Midwest Challenge type thing that we have in basketball, but with a Home&Home format.
-2 Lottery/Rivalry games - Yearly lottery games that produce randomized opponents across the country. These game slots could also be reserved to preserve a rivalry if needed.
***Rotating matchups for Legacy and NonCon games could be totally random, based on previous year standing like the NFL, or a combination of the two. NFL style model creates more parity, compelling matchups and more meaningful games all the way down.
***Add one or two more games if you want so everyone has a G5 game(s). Could be good for all levels of cfb, G5 and P5 alike.
This isn't my wheelhouse, but profits and money distribution can be done in a lot of ways, but I'm in favor of a system that rewards the players and programs for winning and investing time and resources to be better. Reward teams based on wins and contribution to the overall product. Bonuses to players, coaches, and programs for making the playoffs and winning championships etc.
This checks all the boxes as far as I'm concerned. Regionality is preserved, rivalries are preserved, and parity is increased without punishing blue bloods, and PLAYOFFS/CHAMPIONS ARE BASED ON W-Ls.
Thanks for humoring my grand idea. Thoughts?
19
Posted on 5/22/24 at 3:31 pm to Dorsal-Fin
didn't read; no
Posted on 5/22/24 at 3:31 pm to Dorsal-Fin
Cool post nerd
Posted on 5/22/24 at 3:33 pm to Dorsal-Fin
Accidentally...then posts an entire thesis
Posted on 5/22/24 at 3:33 pm to MrJimBeam
Lol
Posted on 5/22/24 at 3:35 pm to Dorsal-Fin
When you say you used “excel” do you literally mean you typed names in boxes in excel? Lol
Posted on 5/22/24 at 3:35 pm to Wolf Shirt
My thesis followed the accident. This all came from like 15 minutes sorting towns on excel at work just to see what it would look like.
Posted on 5/22/24 at 3:36 pm to Hester Carries
quote:
When you say you used “excel” do you literally mean you typed names in boxes in excel? Lol
I created a formula that sorted P5 college towns by coordinates
This post was edited on 5/22/24 at 3:37 pm
Posted on 5/22/24 at 3:36 pm to Dorsal-Fin
You’re talking to mostly college dropouts here. Try again without excel.
Posted on 5/22/24 at 3:41 pm to Dorsal-Fin
I was actually thinking earlier today how much I wanted to be in a conference with Memphis and Tulane
ETA: Especially one without Auburn and Tennessee
ETA: Especially one without Auburn and Tennessee
This post was edited on 5/22/24 at 3:43 pm
Posted on 5/22/24 at 3:42 pm to Dorsal-Fin
quote:
Thoughts?
Posted on 5/22/24 at 4:05 pm to Dorsal-Fin
No North Carolina?
Posted on 5/22/24 at 4:10 pm to Dorsal-Fin
quote:
Thoughts?
Not my favorite overall, simply because it disintegrates too many traditional rivalries, although we're probably headed there eventually anyway (unfortunately).
I do like the idea of increasing parity, especially as it relates to scheduling, and the legacy/lottery deal is intriguing.
I also like that Tennessee's Northern conference is a labial shade of pink.
But definitely props for all of the hard work — it's certainly interesting content.
Posted on 5/22/24 at 4:11 pm to Dorsal-Fin
You can't have a division called "Southwest" with zero teams from the southwest regional of the county.
Posted on 5/22/24 at 4:11 pm to Dorsal-Fin
How the hell can you put either Vandy or Tennessee in the North? Are you a transplant and don’t understand geography and cultural history? Put your team in the North.
Posted on 5/22/24 at 4:12 pm to Dorsal-Fin
If nothing else, I appreciate the thought and effort put into this. You cast pearls before swine.
I know the frustration.
You earned my upvote.
I know the frustration.
You earned my upvote.
Posted on 5/22/24 at 4:15 pm to MyMossHangs
quote:
No North Carolina?
Damn it. You could just add them to Atlantic South, shift SC to Southeastern, Auburn to Midsouth, and remove Tulane or Memphis.
Posted on 5/22/24 at 4:19 pm to Farmer1906
I should've known we would be getting caught up with the labels. Also, if you would've read my recommendations, Tennessee would be swapped for Vandy.
Vandy being the sacrificial lamb, but also not culturally different from those schools. A lot fewer southerners than you'd think go to Vandy.
Also, Kentucky isn't in the South and we all know that.
Vandy being the sacrificial lamb, but also not culturally different from those schools. A lot fewer southerners than you'd think go to Vandy.
Also, Kentucky isn't in the South and we all know that.
This post was edited on 5/22/24 at 4:21 pm
Posted on 5/22/24 at 4:22 pm to morriscat2
quote:
How the hell can you put either Vandy or Tennessee in the North?
I'm not accusing here because I think this guy put in a lot of work, but it would be some next-level Big Game Boomer trolling to do all of this and just have like one or two really messed up features solely to make certain posters freak out.
Posted on 5/22/24 at 4:23 pm to paperwasp
quote:
Not my favorite overall, simply because it disintegrates too many traditional rivalries, although we're probably headed there eventually anyway (unfortunately).
I left room to retain those with the lottery games, but I'm honestly not seeing too many in the first place. The legacy conference pairings would solve a lot of that, albeit not every year.
What rivalries are you talking about?
This post was edited on 5/22/24 at 4:24 pm
Page 1 of 2
Popular
Back to top
Follow SECRant for SEC Football News