TonyTheTiger20
#SOAR
The 2014-2015 Pairwise Predictor is LIVE
NEW! Click the link below to access the Pairwise Predictor online:
http://www.bcinterruption.com/2014/12/15/7398979/PairwisePredictor
-------------------
I'm basically going to use this thread as my own personal excel spreadsheet playground. The posters poll will go here each week along with other fun things I'm doing using the spreadsheet I built last year to calculate the Pairwise.
Some things you'll see in here include:
--The weekly USCHO Posters Poll
--A few 'what-ifs' from the week that was (Would Lindenwood be a TUC had they not lost 14-0 to Minnesota? Will a win against Clarkson this weekend be enough to put Cornell at the top of the Pairwise? etc.)
--A conference tournament predictor, similar to what USCHO does on the men's side at the end of the regular season, that will calculate the season-ending Pairwise *exactly* given whatever results you plug in
--Any other fun things you or I can think of that I can run on an Excel spreadsheet
To kick things off, wwhyte asked me last night if it was possible for me to approximate a strength of schedule for each team based on their 2014-2015 schedule and last year's RPI numbers. It was, and I did, and here are the results.
A couple caveats:
--This is a VERY rough approximation, as it's running off last year's rankings, but that's obviously all we have. I could run this off any other ranking people want other than RPI (i.e. Rutter) but that's what I had readily available.
--For games where we don't know the final round matchup (Nutmeg Classic and Beanpot) I assumed that the higher-ranked teams win the first round games.
--Yale has a regular season game against Sacred Heart? I didn't have Sacred Heart's RPI so I just assigned them the same RPI as the last place team, Penn State. It doesn't make much of a difference anyway.
Also St. Lawrence being #1 makes you scratch your head until you realize they play Harvard, Cornell, Clarkson, and Quinnipiac in conference, and play BC, Mercyhurst, Robert Morris, Minnesota, twice *each* out of conference, plus another two with Clarkson.
---------
NEW! Click the link below to access the Pairwise Predictor online:
http://www.bcinterruption.com/2014/12/15/7398979/PairwisePredictor
-------------------
I'm basically going to use this thread as my own personal excel spreadsheet playground. The posters poll will go here each week along with other fun things I'm doing using the spreadsheet I built last year to calculate the Pairwise.
Some things you'll see in here include:
--The weekly USCHO Posters Poll
--A few 'what-ifs' from the week that was (Would Lindenwood be a TUC had they not lost 14-0 to Minnesota? Will a win against Clarkson this weekend be enough to put Cornell at the top of the Pairwise? etc.)
--A conference tournament predictor, similar to what USCHO does on the men's side at the end of the regular season, that will calculate the season-ending Pairwise *exactly* given whatever results you plug in
--Any other fun things you or I can think of that I can run on an Excel spreadsheet
To kick things off, wwhyte asked me last night if it was possible for me to approximate a strength of schedule for each team based on their 2014-2015 schedule and last year's RPI numbers. It was, and I did, and here are the results.
Code:
[B][I]Conf Rank SOS[/I][/B] (Includes both conf. and non-conf. games)
WCHA 1 0.5168
ECAC 2 0.4998
HEA 3 0.4904
CHA 4 0.4869
[B][I]Team Rank SOS[/I][/B]
St. Lawrence 1 0.5268
St. Cloud State 2 0.5260
Minnesota State 3 0.5254
Bemidji State 4 0.5237
Minnesota-Duluth 5 0.5174
North Dakota 6 0.5174
Ohio State 7 0.5160
Wisconsin 8 0.5092
Princeton 9 0.5057
Dartmouth 10 0.5051
Cornell 11 0.5040
Harvard 12 0.5012
Lindenwood 13 0.5006
Minnesota 14 0.4994
Boston University 15 0.4994
Colgate 16 0.4993
Penn State 17 0.4991
Clarkson 18 0.4988
Northeastern 19 0.4949
Syracuse 20 0.4938
Brown 21 0.4936
Yale 22 0.4934
Quinnipiac 23 0.4932
Maine 24 0.4924
New Hampshire 25 0.4921
Boston College 26 0.4911
Rensselaer 27 0.4904
Providence 28 0.4898
Connecticut 29 0.4886
Union 30 0.4866
RIT 31 0.4785
Robert Morris 32 0.4768
Vermont 33 0.4752
Mercyhurst 34 0.4725
A couple caveats:
--This is a VERY rough approximation, as it's running off last year's rankings, but that's obviously all we have. I could run this off any other ranking people want other than RPI (i.e. Rutter) but that's what I had readily available.
--For games where we don't know the final round matchup (Nutmeg Classic and Beanpot) I assumed that the higher-ranked teams win the first round games.
--Yale has a regular season game against Sacred Heart? I didn't have Sacred Heart's RPI so I just assigned them the same RPI as the last place team, Penn State. It doesn't make much of a difference anyway.
Also St. Lawrence being #1 makes you scratch your head until you realize they play Harvard, Cornell, Clarkson, and Quinnipiac in conference, and play BC, Mercyhurst, Robert Morris, Minnesota, twice *each* out of conference, plus another two with Clarkson.
---------
Last edited: