RPI Excel Workbook Library

Created July 2023

This page provides links to a number of Excel workbooks that I have created, related to NCAA Division I women’s soccer. I am making them available for two reasons:

Since I advocate for Division I women’s soccer to change from using the RPI version it currently uses to using the Balanced RPI, I think it is only fair to make the workbooks I rely on for my advocacy available to anyone who wants to see them; and
At some point I will retire from my RPI and NCAA Tournament at large selection and seeding work and I want to make the workbooks I have created available in case anyone wants to do similar work for future years.

For each workbook, I will provide a link. Here is how to download a workbook:

Click on the link. This will bring up a Google Sheets document, but you will not be able to use it directly as the underlying Excel workbooks are too complex for Google Sheets to handle.

On the Google Sheet, in the upper left, click on File. This will bring up a drop-down menu.

In the drop-down menu, hover your cursor over Download and in the resulting drop-down menu, click on Microsoft Excel (.xlsx).

This will download the Excel workbook.

Alternatively if your clicking on the link does not bring up a Google Sheets document:

When you click on the link, it will bring up a page that says Couldn’t Preview File.

On the Couldn’t Preview File page, click on the Download button or on the Download icon in the upper right.

This will download the Excel workbook.

Note: Many of these workbooks are large and complex and will take some time to open after you first click on a link. It thus will take both time and patience to access and download them.

Once you have downloaded the workbook, you only will be able to view the workbook pages and, if you click on a cell, a formula if the contents of the cell are determined based on a formula. If you want to be able to use the workbook as though it were your own, in the Protected View banner at the top, click on Enable Editing.

You may see a Security Warning banner about Automatic Update of Links. You do not need to worry about this, as I have deleted any links in the workbooks before uploading them. If you want to get rid of the banner, click on Enable Content. (Within my own computer, I use a lot of linked workbooks, so many of the workbooks in the library are linked to each other. I have deleted all of the links so that you do not have to download all of the workbooks in order to make the ones you are interested in work.)

Things to be aware of: Although a few of the workbooks, as their first pages, have User Guides, most of them do not. Eventually, I may prepare a master User Guide for the workbooks that do not have them, but that is a big project that will take time. In the meantime, you will be on your own trying to figure out how I have constructed the workbooks. Some of them are complex, and I constructed them piece by piece over time, so they may not be as efficient and easy to use as they would be if I were re-constructing them today.

Some of the pages, in Column A, are in alphabetical order from A to Z or in numerical order from 1 to higher. And, of those pages, some are used as Lookup sources for formulas on other pages. In order for the Lookup function to work, the orders in Column A of those pages must be A to Z or 1 to higher. So, if you change how those pages are sorted for some purpose, always put them back in the A to Z or 1 to higher order (and re-compute, if necessary) when you are done.

Some of the workbooks are archival in nature, meaning that I do not update them from year to year. This is true of all of the Master Data and Ratings workbooks. Some of the workbooks, however, are based on data from various starting points to the present and I do update them yearly. For those workbooks, all are updated through the 2022 season.

If you have problems with any workbook or questions about how it works, you can email me at cpthomas@q.com.

LIBRARY CATALOG

2024 Documents

Team Histories and Simulated 2024 Balanced RPI Ranks

Comparing the Current NCAA RPI to the Balanced RPI

Going forward, Division I women’s soccer will be operating under the no overtime rule that went into effect beginning with the 2022 season. Because of this, what matters from a rating perspective is how the current NCAA RPI performs as a rating system when there are no overtimes as compared to how the Balanced RPI performs. In order to have enough data to make that comparison, I converted results for all seasons since 2010 to what they would have been if there had been no overtimes -- in other words, I treated all games that went to overtime as ties. (Based on comparing the percentage of overtimes during those years to the percentage of ties in 2022, it appears reasonable to treat games that went to overtime in the past as ties.) Based on those games, I determined what the details of the Balanced RPI formula should be. Then, for each year I computed what the current NCAA RPI and Balanced RPI ratings would have been. Next, I used my Correlator system to see how well each performed as a rating system, in order to to be able to compare their performance. For a description of how I set up the Correlator system, go to the RPI: Measuring the Correlation Between Teams’ Ratings and Their Performance page.

The following documents are part of the comparison process:

2010 Master Data and Ratings No Overtime Without Links

2011 Master Data and Ratings No Overtime Without Links

2012 Master Data and Ratings No Overtime Without Links

2013 Master Data and Ratings No Overtime Without Links

2014 Master Data and Ratings No Overtime Without Links

2015 Master Data and Ratings No Overtime Without Links

2016 Master Data and Ratings No Overtime Without Links

2017 Master Data and Ratings No Overtime Without Links

2018 Master Data and Ratings No Overtime Without Links

2019 Master Data and Ratings No Overtime Without Links

2021 Master Data and Ratings No Overtime Without Links

2022 Master Data and Ratings Without Links

ARPI 2015 HAN Test No OT Without Links

Balanced RPI HAN Test No OT Without Links

ARPI 2015 Correlation Test No OT Without Links

Balanced RPI Correlation Test No OT Without Links

CPT Rating Formulas Without Links

Strength of Schedule Ratios Without Links

Strength of Schedule Problem No OT Since 2013 Without Links

No OT Summary Without Links

Committee Decisions and Rating Systems No OT Without Links

Results Not Matching Ratings Without Links

Comparing Actual Committee Decisions Using the Current NCAA RPI to Likely Decisions Using the Balanced RPI

The Committee has made its past NCAA Tournament decisions based on actual game results, including the results of overtime games. Because of this, in order to compare the decisions the Committee actually made to the decisions it likely would have made if it had used the Balanced RPI, it is necessary to use data based on actual game results (rather than what the results would have been without overtimes). For information on the decisions the Committee is likely to make based on the data it considers, go to Tournament Decisions Resource.

The following documents are part of the comparison process:

2007 Master Data and Ratings Without Links

2008 Master Data and Ratings Without Links

2009 Master Data and Ratings Without Links

2010 Master Data and Ratings Without Links

2011 Master Data and Ratings Without Links

2012 Master Data and Ratings Without Links

2013 Master Data and Ratings Without Links

2014 Master Data and Ratings Without Links

2015 Master Data and Ratings Without Links

2016 Master Data and Ratings Without Links

2017 Master Data and Ratings Without Links