clock menu more-arrow no yes

Filed under:

2017-2018 NCAA Women's Hockey Pairwise Rankings Calculator

It’s Pairwise season!

John Quackenbos, BC Athletics

Welcome to the 2017-2018 NCAA Women's Hockey Pairwise Calculator! Using this tool, you can play around with the results of this year's women's college hockey season and see its effect on the Pairwise Rankings.

When it's conference tournament time, check back here to find our annual Tournament Predictor: You'll be able to enter your predicted results for the conference tournaments in an easy-to-use bracket setup and see the resulting Pairwise Rankings. You can see last year's version here.

Simple instructions to get you started:

  1. To edit game results, go into the “Results" tab. You'll see a line for every game of the season. You can edit the score for any past game(s), or enter a score for any future game(s).
  2. Once you've changed your results in "Results," pull up the “PWR” tab to see the resulting Pairwise Rankings.

And that's it!

A few important notes and tips:

  • This year, six D-I and D-II independents enter the fray and will technically be eligible for NCAA tournament selection as they will meet the minimum requirements as set out in the NCAA tournament manual. You can read more about it here. However, the committee has made changes to the selection criteria which gives them additional flexibility on whether they will actually select one of these teams for the tournament even if they’re in the top 8 of the Pairwise. Our calculator includes a switch at the top that will allow you to include or exclude these teams from the rankings. If you exclude them, all games against these teams will count, but they will all be moved to the bottom.
  • The “Grid” tab will show you the familiar Pairwise Comparison grid. However to make things a little easier, on the “PWR” tab, we’ve also included a matchup calculator that will allow you to easily see the comparisons between two selected teams. Just select two teams, and the comparisons will populate.
  • Score margin in games does not affect the rankings — only win/lose/tie.
  • To remove results, you need to double click on the cells with scores in them and delete everything in the cell for both team's scores. The sheet reads non-blanks as a score: for example, two blanks is "no game," but two [space]'s will be read as a 0-0 tie.
  • To add a game, just add a line in the “Results" tab like the rest of the lines. Just make sure you spell each team name exactly the same as the rest.
  • Actual game results do not update automatically. I will be periodically updating throughout the week. The spreadsheet will then update with the new results if you refresh the page. You can see which games are included at the top of the calculator.
  • Once you change results in the "Results" tab and switch over to the "PWR" tab, give it a second. The results will update, but not instantaneously. It's a pretty big spreadsheet.

If you have any questions, comments, or bugs to report, I can be reached at grant dot salzano at gmail dot com.

Enjoy!