NHL Franchise Boys

From Rookies to Veterans: 31 Years of Memories

Skip to: Content | Sidebar | Footer

Header

Draft Lottery 2017

31 August, 2017 (11:07) | HOCKEY TALK | By: Nick

     DRAFT ORDER 

.   1st – Joe D (10%)
.   2nd – Mike (22%)
.   3rd – Joe L (30%)
.   4th – Steve (17%)
.   5th – Giac (8%)
.   6th – Claudio (13%)
.   7th – Johnny
.   8th – Nick
.   9th – Louis
. 10th – Paolo

 

Draft Lottery Process: A spreadsheet was created to generate generate a random number between between 1 and 100. It uses an Excel function called RANDBETWEEN. The number generated falls within a range that corresponds to one of the Franchises based on the percentage odds where they ranked at the end of the season (see below).  Once the first pick is drawn, the Franchise (and its factor) to whom the 1st pick was awarded, is removed from the process and the cumulative factors for remaining Franchises are recalculated thus producing new ranges, and so on.

Rank Odds Range Franchise
10 30% 01 to 30 Joe L.
9 22% 31 to 52 Mike
8 17% 53 to 69 Steve
7 13% 70 to 82 Claudio
6 10% 83 to 92 Joe D.
5 8% 93 to 100 Giacomo

 

Important Dates to Note:

Draft Day: Sunday October 1st, 2017

Final Protect List: Friday September 22nd, 2017 at 12 noon

Preliminary Protect List: Friday September 15th, 2017 at 12 noon

 

Write a comment