Zandor4355
| Favorite team: | |
| Location: | |
| Biography: | |
| Interests: | |
| Occupation: | |
| Number of Posts: | 2 |
| Registered on: | 11/15/2023 |
| Online Status: | Not Online |
Recent Posts
Message
College Football Schedule Spreadsheet for Win Totals Pick'em
Posted by Zandor4355 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!
1
College Football Schedule Spreadsheet for Win Totals Pick'em
Posted by Zandor4355 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!
Popular
9
