Page 1
Page 1
Started By
Message
locked post

College Football Schedule Spreadsheet for Win Totals Pick'em

Posted on 8/17/24 at 9:00 am
Posted by Zandor4355
Member since Nov 2023
2 posts
Posted on 8/17/24 at 9:00 am
I need a spreadsheet of the entire schedule for all D1 teams. Any suggestions on where to find this?

Context:
Every year, my friends and I do a win total pick'em. We pick a couple of teams over or under and track the aggregate delta at the end of the year for the 3-4 teams we picked. Credit to Cover 3 Mailbag for the idea. We’ve been running this for 5 years now. I'm looking to automate my highly manual process. It's been super fun.

If any fellow stat nerds have improvement suggestions, I also welcome those.

What we do today:
Manually score expected win % for each game and then track the actual win totals throughout the year. This sorta works, but my "scoring of expected win %" is pretty crude.

Inputs for Expected Win%:
- Opponent Strength (Tier 1-3) (highly subjective metric)
- Home/Away
- Expected win totals of opponent

Appreciate any thoughts or help!
Posted by lostinbr
Baton Rouge, LA
Member since Oct 2017
11666 posts
Posted on 8/17/24 at 10:18 am to
I’m not 100% clear on what you’re actually doing, but..
quote:

Inputs for Expected Win%:
- Opponent Strength (Tier 1-3) (highly subjective metric)
- Home/Away
- Expected win totals of opponent

College football win probability by point spread

This seems like a much more objective way to come up with win probabilities.

ETA:
quote:

I need a spreadsheet of the entire schedule for all D1 teams. Any suggestions on where to find this?

CollegeFootballData.com allows you to export a lot of different data in csv format.
This post was edited on 8/17/24 at 10:22 am
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on X, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookXInstagram