2022 CPHL Draft Order Thread

[TheScorpion]

This is the thread we will be using to track the order of CPHL draft selections this year.

Please be sure to post ALL 2021 draft pick transactions in here. It is not necessary to post the rest of the trade — you only need to specify the 2021 draft picks being moved.

Please include both the team trading and receiving the pick. For instance, if the Boston Bruins owned pick 276 and traded it to the Vegas Golden Knights, it would be posted like this:

276 from BOS to VGK

I hope this all goes smoothly. Please let me know if you have any questions or see any errors.

[TheScorpion]

Round 1

1. COLORADO (from FLORIDA)
2. MINNESOTA (from CALGARY)
3. PHILADELPHIA (from COLUMBUS)
4. MINNESOTA (from BUFFALO)
5. VANCOUVER
6. SAN JOSE (from COLORADO)
7. MINNESOTA (from EDMONTON)
8. MONTREAL (from ARIZONA)
9. ANAHEIM (from TAMPA BAY)
10. SAN JOSE (from TORONTO)
11. SAN JOSE (from ST. LOUIS)
12. TAMPA BAY (from DETROIT)
13. COLORADO (from SAN JOSE)
14. PITTSBURGH (from WASHINGTON)
15. PITTSBURGH (from COLORADO)
16. SAN JOSE (from NY ISLANDERS)
17. MINNESOTA (from OTTAWA)
18. MINNESOTA (from MONTREAL)
19. ANAHEIM (from LOS ANGELES)
20. PITTSBURGH (from PHILADELPHIA)
21. VANCOUVER (from ANAHEIM)
22. MONTREAL (from MINNESOTA)
23. NEW JERSEY (from CHICAGO)
24. PITTSBURGH (from DALLAS)
25. Minny (from SAN JOSE)
26. CALGARY (from NY RANGERS)
27. CAROLINA
28. SAN JOSE (from NASHVILLE)

Round 2

29. MONTREAL (from COLUMBUS)
30. NY RANGERS (from BUFFALO)
31. PITTSBURGH (from VANCOUVER)
32. PITTSBURGH (from COLORADO)
33. MINNESOTA (from EDMONTON)
34. NEW JERSEY (from CALGARY)
35. WASHINGTON (from ARIZONA)
36. MONTREAL (from FLORIDA)
37. TAMPA BAY
38. PITTSBURGH (from TORONTO)
39. VANCOUVER (from ST. LOUIS)
40. NY RANGERS (from DETROIT)
41. CAROLINA (from PITTSBURGH)
42. MINNESOTA (from WASHINGTON)
43. NEW JERSEY
44. WASHINGTON (from NY ISLANDERS)
45. MONTREAL (from OTTAWA)
46. MONTREAL
47. COLORADO (from LOS ANGELES)
48. LOS ANGELES (from PHILADELPHIA)
49. SAN JOSE (from ANAHEIM)
50. LOS ANGELES (from MINNESOTA)
51. CHICAGO
52. CHICAGO (from DALLAS)
53. COLORADO (from SAN JOSE)
54. NY RANGERS
55. CAROLINA
56. PHILADELPHIA (from NASHVILLE)

Round 3

57. LOS ANGELES (from COLUMBUS)
58. LOS ANGELES (from BUFFALO)
59. SAN JOSE (from VANCOUVER)
60. CHICAGO (from COLORADO)
61. SAN JOSE (from EDMONTON)
62. MINNESOTA (from CALGARY)
63. LOS ANGELES (from ARIZONA)
64. NY ISLANDERS (from FLORIDA)
65. PITTSBURGH (from TAMPA BAY)
66. SAN JOSE (from TORONTO)
67. MINNESOTA (from ST. LOUIS)
68. VANCOUVER (from DETROIT)
69. NY RANGERS (from PITTSBURGH)
70. MINNESOTA (from WASHINGTON)
71. SAN JOSE (from NEW JERSEY)
72. MINNESOTA (from NY ISLANDERS)
73. Minny (from OTTAWA)
74. TORONTO (from MONTREAL)
75. PITTSBURGH (from LOS ANGELES)
76. SAN JOSE (from PHILADELPHIA)
77. DETROIT (from ANAHEIM)
78. CAROLINA (from MINNESOTA)
79. CHICAGO
80. Minny (from DALLAS)
81. CAROLINA (from SAN JOSE)
82. ST. LOUIS (from NY RANGERS)
83. CAROLINA
84. OTTAWA (from NASHVILLE)

Round 4

85. Minny (from COLUMBUS)
86. CAROLINA (from BUFFALO)
87. DETROIT (from VANCOUVER)
88. MINNESOTA (from COLORADO)
89. DETROIT (from EDMONTON)
90. MINNESOTA (from CALGARY)
91. NY ISLANDERS (from ARIZONA)
92. NY ISLANDERS (from FLORIDA)
93. PITTSBURGH (from TAMPA BAY)
94. MINNESOTA (from TORONTO)
95. DETROIT (from ST. LOUIS)
96. DETROIT (from DETROIT)
97. DETROIT (from PITTSBURGH)
98. MINNESOTA (from WASHINGTON)
99. TAMPA BAY (from NEW JERSEY)
100. DETROIT (from NY ISLANDERS)
101. DETROIT (from OTTAWA)
102. NY ISLANDERS (from MONTREAL)
103. CHICAGO (from LOS ANGELES)
104. CAROLINA (from PHILADELPHIA)
105. DETROIT (from ANAHEIM)
106. TORONTO (from MINNESOTA)
107. CHICAGO
108. TAMPA BAY (from DALLAS)
109. TORONTO (from SAN JOSE)
110. TORONTO (from NY RANGERS)
111. CAROLINA
112. DETROIT (from NASHVILLE)

Round 5

113. Minny (from COLUMBUS)
114. PITTSBURGH (from BUFFALO)
115. NY ISLANDERS (from VANCOUVER)
116. NY ISLANDERS (from COLORADO)
117. MINNESOTA (from EDMONTON)
118. OTTAWA (from CALGARY)
119. MINNESOTA (from ARIZONA)
120. Minny
121. PITTSBURGH (from TAMPA BAY)
122. TORONTO
123. ST. LOUIS
124. TORONTO (from DETROIT)
125. MINNESOTA (from PITTSBURGH)
126. OTTAWA (from WASHINGTON)
127. NY ISLANDERS (from NEW JERSEY)
128. CAROLINA (from NY ISLANDERS)
129. MINNESOTA (from OTTAWA)
130. PITTSBURGH (from MONTREAL)
131. Minny (from LOS ANGELES)
132. CAROLINA (from PHILADELPHIA)
133. DETROIT (from ANAHEIM)
134. TORONTO (from MINNESOTA)
135. CHICAGO
136. MINNESOTA (from DALLAS)
137. TORONTO (from SAN JOSE)
138. NY ISLANDERS (from NY RANGERS)
139. CAROLINA
140. PITTSBURGH (from NASHVILLE)

[Swayze11]

This might be a stupid question because I never make it far in the playoffs but it looks like the draft order is being based on playoff performance? Has that always been the case? I thought it was just regular season standings based.

[Harry Lime]

Originally Posted by Swayze11

This might be a stupid question because I never make it far in the playoffs but it looks like the draft order is being based on playoff performance? Has that always been the case? I thought it was just regular season standings based.

IRL isn't it the two teams in the Stanley Cup final that get shifted? I also realize that this is a work in progress by Scorp, and will change immensely in the next few edits.

The basic order is therefore determined as follows:

The teams that failed to qualify for the playoffs.
The teams that made the playoffs but did not finish top of their division or make the Conference Finals.
The teams that finished top of their divisions but did not make the Conference Finals.
The teams that lose in the Conference Finals.
The team that lost in the Stanley Cup Finals.
The team that won the Stanley Cup.

Huh, live and learn.

[TheScorpion]

Draft order is complete.

NYI have one pick: 116

[TheScorpion]

Nevermind, ignore this order — I need to shift some things around. I forgot the CPHL draft order just follows reverse standings and not the NHL rules ... Swayze is right.

[Jiri Hrdina]

Originally Posted by Swayze11

This might be a stupid question because I never make it far in the playoffs but it looks like the draft order is being based on playoff performance? Has that always been the case? I thought it was just regular season standings based.

It is just regular season standings based.
And the top half of the draft is NOT set until the lottery.

[TheScorpion]

Will have it fixed pronto!

[TheScorpion]

Ok now it's done. Draft order set. Islanders still have just one pick: 116.

Like Jiri said, the top two picks are subject to change in the lottery. And by proxy, the first half of the first round can also change.

[Jiri Hrdina]

This is what we did last year. I intend to do the same


Ok I think I created something that works.
You can check it out by downloading here:
http://cphl.calgarypuck.com/pages/si...L_Lottery.xlsx

I would appreciate a few people checking my work.
Here's how it works

There are two draws. One for the first and one for the second overall pick.

So start with the 1st overall tab. Each cell represents a lottery ball, with each team getting a certain number of lottery balls based on the odds of that team getting the 1st overall pick as outlined here:
So Buffalo was last overall in the NHL, mapping to NJD in the CPHL. Those teams have a 16.6% chance of 1st overall so they get 166 lottery balls. The second last place team has a 12.1% chance so they get 121 balls. This would theoretically add up to 1000 total balls in the first round lottery but doesn't for us because Seattle is not included.

Cell B4 pulls one of the balls/cells randomly. This cell re-freshes anytime you change any part of the worksheet so you need to record the number. For instance I pulled #235 which maps to NYI in the CPHL. (note this designate the original team for the pick, not who may own the pick now through trades). This means the NYI pick would be first overall in the CPHL.

I then go to tab 2 - and before I run the second round I first half to remove ALL the NYI balls from the lottery. Once that is done the cell will automatically pull another ball which is your 2nd overall pick, which for me was 649 - Washington. This means the caps pick is the #2 pick.

From there the draft just carries along in reverse standings.

So it would be

1. NYI
2. Washington
3. NJ
4. CBJ
5. Tampa
6. Carolina
7. Calgary
8. Florida
9. Montreal
10. Toronto
11. Dallas
12. St. Louis
13. Ottawa
14. Vancouver
15. LA

Again those aren't the teams that own the pick - those are the original owners of each pick.

[Jiri Hrdina]

That’s the post from last year so the teams don’t match but you get the point

[MJK]

I just need to know if the revised post by Scorp is the correct one now. Good to go?

[TheScorpion]

Yes.

[Harry Lime]

Isn't the final four picks in each round missing?

[TheScorpion]

We only have 28 teams in this league. No Boston, Seattle, Vegas, Winnipeg.

[Harry Lime]

Originally Posted by TheScorpion

We only have 28 teams in this league. No Boston, Seattle, Vegas, Winnipeg.

For some reason that has never computed properly in my brain. I mean, I clearly knew that, but the count never stopped being 32. Also, I wonder if there is a story behind Boston. The others are essentially expansion teams that postdate the league...

[JonDuke]

Remind me please:
Why do we do an in-house lottery instead of following what the NHL does? I think last year it was because Seattle was heavily weighted? Didn't we just use NHL placement every other year before then though?

[Jiri Hrdina]

Originally Posted by JonDuke

Remind me please:
Why do we do an in-house lottery instead of following what the NHL does? I think last year it was because Seattle was heavily weighted? Didn't we just use NHL placement every other year before then though?

The nhl has more complex rules that don’t apply to us
And we also don’t know when it is scheduled for

[Jiri Hrdina]

Originally Posted by Harry Lime

For some reason that has never computed properly in my brain. I mean, I clearly knew that, but the count never stopped being 32. Also, I wonder if there is a story behind Boston. The others are essentially expansion teams that postdate the league...

Boston was picked for contraction as it was one of the most asset poor teams

[TheScorpion]

84 from NSH to NYI