Re: Fun With Numbers '14-'15: USCHO Posters Poll, Pairwise What-Ifs, and Other Goodie
The 2014-2015 Pairwise Calculator is LIVE
Last year's calculator is available for the 2014-2015 season in the form of a massive (42 MB) Excel spreadsheet. I will put this in the first post in the thread as well.
Here is the link:
http://tinyurl.com/wih1415pwr
Instructions:
1) Download the file to your computer. You can't play with it on Google docs because it's too big.
1a) No, it does not have any viruses.
2) Let the file open. It will take a while, possibly a couple minutes. Let it do its thing, even if it looks like it's frozen.
3) When the file opens it will ask you if you want to update the links to external data. Click yes and this will update the scores for all of the games already played.
4) There are tabs on the bottom. The tabs "PWR," "RPI," and "Composite" are the ones you'll want to play with.
-"Composite" is where you'll go to change any results. Find the game you want and change the score as you see fit. Do not change the name of the teams, only change the scores. Margin of victory, obviously, doesn't matter.
-"RPI" will show you the RPI based on the scores in the "Composite" tab. Note that right now all of the Ivies have errors because they haven't played, so they are all screwed up with divide-by-zero errors. To play around with it now I would just change the RPI to 0 for those teams. That should give you workable RPI/PWR tabs. Just make sure you don't save the file that way for later on.
-"PWR" will show you - surprise! - the PWR based on the scores in the "Composite" tab. Sometimes the rankings don't automatically sort after the composite tab is updated which is far as I can tell is just an annoying glitch. Save and reopen the file (and click 'no' on the next open when it asks you to update external data) and it should fix itself.
Note that anytime you click "yes" when it asks to update external data, the "Composite" tab will reset to all of the real scores for all of the games already played and will delete any others. In short, clicking yes will give you the most current PWR.
Have fun with it and let me know if you have any problems. It's fun to play with to see "what if" later in the year. For example, come December or so it will be interesting to see how much this weekend's ties hurt Minnesota/BC, etc. But for now with so few results there's not really enough data to play with just yet.