Started By
Message

College Football Schedule Spreadsheet for Win Totals Pick'em
Posted on 8/17/24 at 8:59 am
Posted on 8/17/24 at 8:59 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 9:00 am to Zandor4355
Any good bookie should have this.
Posted on 8/17/24 at 9:27 am to Zandor4355
Don't know what'll give you all that info at once. Might be easier to search for future schedules earlier in the year so it's not a rush job at the season start.
Back to top
2






