AVG Draft Position
I spent a little bit of time making a grid of the FOUR DobberEntry leagues.
This shows the Top50 picks, by average pick.
(I only have the top 60 picks of the Patrick to work with... c'mon league - get me a copy/paste to work with!)
It's kind of neat.
I made a HIGH-LOW and AVERAGE column.
My first 3 picks are in red and I got them all later than their ADP.
On a later day, I may include the Pro & Expert leagues for comparison.
I learned to use the VLOOKUP function in Excel for the first time and feel quite smart.
A couple interesting notes:
1. The top 8 were the top 8 in all four leagues: Crosby/Malkin/Stamkos/Ovechkin/Giroux & Lundqvist/Quick/Rinne.
2. The #9 pick was completely WILD and inconsistent including Erik Karlsson, Jimmy Howard, and Pat Sharp. I suppose the #9 spot will go down as the toughest draft position of 2012!
3. Despite not being a consensus #9 pick... Corey Perry was the 9th pick by average: selected at 10th/10th/10th/13th. Those teams must have been salivating for Perry in the 10-spot.
4. The most consistent range player appears to be Luongo - despite his uncertainty - he was picked in a 15-player range (31-45).
Enjoy.
(EDIT: The column headers for the Adams & Patrick are switched. Needs to be fixed.)
Last edited by Pengwin7; 10-16-2012 at 09:31 AM.
Reason: WRONG DIVISIONS
|
