You're probably long gone, but I would like to thank you for this spreadsheet. I use many myself and this only adds to my arsenal.
I used to do a similar ranking system for some of my sheets, but found that it would really push a player up or down much higher than they normally would.
For instance, say you poll 10 sites' top 50. Player X shows up around #15 on most but then on one shows up as 48th for whatever reason. Now player Y is ranked in the 52s or so, but on one he shows up as 17th. The sheet takes the average ranking, or the number of times they are ranked into the sum of the ranks they show. The first guy's average takes him to 18.3 but the second guy shows a ranking of 17 because they were only ranked once in the top 50.
Another anomoly is the fact that many sites rank their top 50 or 100 differently than they would positional rankings. A linebacker may show up higher on the top 50 based upon their athleticism but lower on a positional ranking because they were outperformed.
Overall nice job.
|