- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message

College Football Schedule Spreadsheet for Win Totals Pick'em
Posted on 8/17/24 at 9:00 am
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!
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 on 8/17/24 at 10:18 am to Zandor4355
I’m not 100% clear on what you’re actually doing, but..
College football win probability by point spread
This seems like a much more objective way to come up with win probabilities.
ETA:
CollegeFootballData.com allows you to export a lot of different data in csv format.
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
Popular
Back to top
