I have two scheduling resources available for teams, both in the form of Excel workbooks:
Team Histories and Simulated 2022 Ranks
This is a resource that lets you review, for each team:
Its RPI rating and rank history, plus its Massey rank history;
Its history in terms of its rank as a contributor to opponents’ strengths of schedule;
Its history in terms of the average ranks of its opponents.
It also includes a trended RPI rating and rank I have assigned each team going into the 2022 season, based on its rank history, as well as its expected rank as a contributor to opponents’ strengths of schedule.
The workbook has a User Guide that explains in detail what is in the workbook and how to use it as part of your scheduling process.
This is a very large workbook, with a page for each team as well as additional resource pages. Because of its size, it is not practical to use it on line. Rather, you will need to download it using the following link: Team Histories and Simulated 2022 Ranks. I have found that it takes the following steps to download it:
When you have clicked on the link, a page will come up in your browser with a rotating circle. You may have to wait a while because of the size of the workbook.
A black page will come up with a rotating circle. On the upper right, there will be a download icon. Click on the icon (even if the circle still is rotating). Again, you may have to wait a while.
A black page may come up again with a rotating circle. You also may see some of the text of the User Guide page of the workbook. Wait until a download box appears at the bottom left. Click on the carat mark to open the box. Then click on Open.
At this point, the Excel file should open. Use Save As to save the file to your computer with whatever name you want to assign it.
If you have trouble downloading the file, email me at cpthomas@q.com and I will email a copy to you.
Team Scheduling Tool
This is a Tool custom set up for each team that wants one. It lets the team try out different schedules to see where the team is likely to end up in terms of its RPI rating and rank and also in terms of several factors related to NCAA Tournament at large selections and seeds. It contains a User Guide that explains what is in the Tool and how to use it.
I also can set the Tool up for use by a conference to see how scheduling by the individual teams affects the conference teams’ RPI ratings and ranks and NCAA Tournament prospects.
I will set up a tool for any team that wants one. If you want one, simply email me at cpthomas@q.com. In order to set up the tool, it will work best for me and for you if you will send me your conference’s entire in-conference schedule as well as your proposed non-conference schedule (I do not need game dates, but I do need game locations). Once I have the needed information, I will set up the Tool and send it to you.
