Carmel YKD - thanks for the question. Most of the work is in the set up at the beginning and I find that waiting until week 6 to start the projections means there is not much work week to week to change projections as cal-rep rankings are proving out to be about 85% accurate. There are five point columns
1. Schedule - This moves very little. All CCS teams are set as A, B or C teams at the beginning of the year. Most non-CCS teams are pretty clear whether they are an A, B or C team. There are always a couple of bubble non-CCS teams that I have to track manually every year that hover between some of the categories.
2. Wins - I project this out after week six and every week there are usually 6-8 "upsets" that require adjustments. The bigger ripple is where an upset just doesn't reverse a win or a loss for the two teams involved but rankings change enough to change the projections for a handful of teams going forward for the end of the year.
3. League Championship Points - Part of the projections are projecting out the 13 CCS league champions. If these stay stable there are no adjustments, but when the projection of a league champion changes then I have manually adjust which opponents lose or gain points. Another hard part here that takes some time is checking non-CCS opponents that project to be league champions. For example McLymonds forfeit means that they are now a likely OAL co-Champion instead of easily projected Champion and Riordan and St. Francis loss 0.5 points from the original projection.
4. Top 100/150 bonus points - Again once you get to week 6 this stays pretty stable, but I do check the changes in the list from week to week of both CCS teams and Non-CCS opponents of CCS teams. So as teams on the border go in and out of the top 100 or top 150 points get adjusted accordingly. There are usually only a few teams that go back and forth or out of the rankings this late in the season.
5. CCS Calpreps ranking - Every week I do this. With the top and bottom rankings staying pretty stable but there is usually a lot of change between 11-30 and these cause changes in seeding or division placements.
All in all it takes about 3 hours to set up in Week 6 and then about an hour to 1.5 hours. week after that to track the changes - much is automated, but tables have to be changed manually