On tiers:
For those not familiar: For years we operated a projection system that used tiers where each team was expected to win all of their home games except those against teams two or more tiers higher and lose all of the road games except those against teams two or more tiers lower.
This ended up serving a few functions for us:
- It gave us a reasonably accurate projection of where all the teams would finish, and
- It helped us to avoid the "talking head trap" of thinking that a team on a streak was Great/Terrible without looking at the schedule to realize that they were actually on a streak because they had a particularly easy/tough stretch.
As an example, Michigan finishes the regular season on a six game stretch of:
- AT Purdue
- vs DOOK in DC
- vs Minnesota
- AT Illinois
- AT Iowa
- vs MSU
That is brutal. To be honest, 3-3 would be pretty good, 4-2 would be very good, and anything better than that would be amazing. Now if they end up going 2-4 that honestly isn't all that bad but I guarantee that there will be talking heads shouting "What is wrong with Michigan?" Well the answer would be that nothing is "wrong", they just played a REALLY tough stretch of games. No reason for wailing and gnashing of teeth among the Wolverine fans.
Now the problem. It has gotten awfully big for me to try to manage it. What I used to do was to assign tiers then use that to calculate a mathematical projected record on a double-round-robin. Then I'd back out the games not played to come up with a mathematical projection before upsets. Then I'd add in positive upsets and subtract out negative upsets to come up with a final mathematical projection. Then I had each game with either a result or an assigned projection and used that to come up with a separate projection and I double-checked the two projections against each other to make sure I had everything entered right.
Back when we had 14 teams and 20 games each team only had six "games not played" so this was manageable. Now that we have 18 teams and 20 games each team has 14 games not played so it is a data-entry nightmare.
I just thought I'd throw this out there to get suggestions. One thought I have is that I could make it a Google Sheet and then share it with a few of you guys and that way we could split up the data entry. I'd make the "shell" and then just pass it along for others to enter games not played and individual games.
Thoughts?