MAJOR UPDATE:
There have been several suggestions to organize the spreadsheet in a more "statistically relevant" and less subjective way to make it more useful for this class and for people in the future. As I aim to please, this has been done--the admittedly brilliant "POWER SCORE" is no more. It will be missed.
It was decided that the only really statistically significant categories are the mean ROL ranking and the percentage of the interview class that has answered the survey (as a measure of confidence in the spreadsheet; i.e., the more people from any program's interview class that have contributed, the more confident we can be in the ROL average). The spreadsheet is now sorted by ROL program average, with a column next to the mean stating the percentage of the interview class for an individual program has participated in the spreadsheet (I pulled the actual interview #s from FREIDA from last year). For programs that did not list their interview #s on FREIDA, I estimated based on the average interviews/position of the programs that did post their info (which averaged 12 interviews per spot). The more people that post their ROLs, the higher the confidence in the mean will be. This should make the information more relevant to next year's class.
Certain programs already have almost 15% of their entire interview class represented, which I think is pretty cool!
To keep it interesting, I added a column that projects the number of people that theoretically have ranked a particular program first based on the current info in the spreadsheet. This of course is the single number that would be the coolest to know. The higher percentage of a program's interviewees that participate, the closer that projection will be to reality.
If you have ranked a program that doesn't have a lot of rankings yet, please PM me your list or post it on the ROL thread!
Here is the link:
https://docs.google.com/spreadsheet/ccc?key=0AnzZUifXW_SgdHZobW5UbUpzMEZuQmNPNnB3enAyS3c#gid=0
Let's keep any discussion of the spreadsheet in the dedicated thread--just wanted to update the ROL thread of the new compilation format.