Banger leagues score for PIMs, hits, and blocked shots. The top defensemen in such leagues are different than those that make most of the published rankings, except that Cale Makar is still #1.
Please note that this ranking _does not_ adjust for total number of games played, so that those who were injured last year, such as Ekblad, are penalized in this ranking for the games they missed.
Also note that some statistics (such as goals) are rarer than others. As you'll see, I tried to adjust for that. I do not understand why no player received 10 fantasy points in several categories (I asked ChatGPT to explain why and it stated, Each stat is scaled so that the player with the top raw value gets 10 points.
Example: Cale Makar’s 62 assists were the most, so he earns 10 A points; everyone else is scaled to that).
Note that Weeger and Makar get similar scores for dominating different categories.
Here's the prompt:
Twelve teams are drafting at least four defencemen each for
the NHL fantasy season. For each of the top 50, use the attached spreadsheet.
The significant statistics are in the following 9 columns: G
(goals), A (Assists), PPP (power play points), PIM (Penalties in Minutes), +/-,
SHOTS, HITS, and BS (blocked shots)
Each statistic is worth up to 10 fantasy points
For each player and for statistic except +/-, find the
player who is listed in the table who has the highest score in that statistic,
which we will call HIGHEST SCORE. Use the following formula to derive fantasy
points: ([player’s score] / [HIGHEST SCORE]) * 10.
For +/-, the HIGHEST SCORE is the highest positive number.
The LOWEST SCORE is the largest negative number. The fantasy points number is: (([player’s
score + (-1 * LOWEST SCORE)) / (HIGHEST SCORE + (-1 * LOWEST SCORE))) * 10
Rank players by total fantasy points. Produce a table with
the following columns:
[Rank] [player name] [team] [G] [G points] [A] [A points]
[PPP] [PPP points] [PIM] [PIM points] [+/-] [+/- points] [Shots] [Shots points]
[Hits] [Hits points] [BS] [BS points] [Total fantasy points]
Make the table exportable to excel.
Here's the table:
|
Rank
|
Player name
|
Team
|
G
|
G points
|
A
|
A points
|
PPP
|
PPP points
|
PIM
|
PIM points
|
+/-
|
+/- points
|
Shots
|
Shots points
|
Hits
|
Hits points
|
BS
|
BS points
|
Total fantasy points
|
|
1
|
Cale Makar
|
COL
|
30
|
10
|
62
|
10
|
35
|
10
|
14
|
1.94
|
28
|
9.47
|
246
|
8.26
|
51
|
2.29
|
128
|
6.67
|
58.62
|
|
2
|
Mackenzie Weegar
|
CGY
|
8
|
2.67
|
39
|
6.29
|
21
|
6
|
33
|
4.58
|
18
|
8.13
|
184
|
6.17
|
223
|
10
|
192
|
10
|
53.85
|
|
3
|
Zachary Werenski
|
CBJ
|
23
|
7.67
|
59
|
9.52
|
25
|
7.14
|
31
|
4.31
|
12
|
7.33
|
298
|
10
|
19
|
0.85
|
131
|
6.82
|
53.64
|
|
4
|
Rasmus Dahlin
|
BUF
|
17
|
5.67
|
51
|
8.23
|
21
|
6
|
54
|
7.5
|
11
|
7.2
|
200
|
6.71
|
100
|
4.48
|
98
|
5.1
|
50.89
|
|
5
|
Moritz Seider
|
DET
|
8
|
2.67
|
38
|
6.13
|
24
|
6.86
|
40
|
5.56
|
-5
|
5.07
|
162
|
5.44
|
210
|
9.42
|
181
|
9.43
|
50.56
|
|
6
|
Victor Hedman
|
TBL
|
15
|
5
|
51
|
8.23
|
26
|
7.43
|
30
|
4.17
|
18
|
8.13
|
181
|
6.07
|
39
|
1.75
|
133
|
6.93
|
47.7
|
|
7
|
Evan Bouchard
|
EDM
|
14
|
4.67
|
53
|
8.55
|
26
|
7.43
|
32
|
4.44
|
14
|
7.6
|
235
|
7.89
|
31
|
1.39
|
108
|
5.62
|
47.59
|
|
8
|
Darnell Nurse
|
EDM
|
5
|
1.67
|
28
|
4.52
|
2
|
0.57
|
72
|
10
|
11
|
7.2
|
188
|
6.31
|
161
|
7.22
|
136
|
7.08
|
44.57
|
|
9
|
Quinn Hughes
|
VAN
|
16
|
5.33
|
60
|
9.68
|
29
|
8.29
|
29
|
4.03
|
2
|
6
|
192
|
6.44
|
13
|
0.58
|
67
|
3.49
|
43.84
|
|
10
|
Jakob Chychrun
|
WSH
|
20
|
6.67
|
27
|
4.35
|
15
|
4.29
|
52
|
7.22
|
17
|
8
|
179
|
6.01
|
59
|
2.65
|
87
|
4.53
|
43.71
|
|
11
|
Josh Morrissey
|
WPG
|
14
|
4.67
|
48
|
7.74
|
22
|
6.29
|
22
|
3.06
|
17
|
8
|
172
|
5.77
|
49
|
2.2
|
113
|
5.89
|
43.6
|
|
12
|
Brandon Montour
|
SEA
|
18
|
6
|
23
|
3.71
|
11
|
3.14
|
70
|
9.72
|
-22
|
2.8
|
231
|
7.75
|
84
|
3.77
|
100
|
5.21
|
42.1
|
|
13
|
Jake Sanderson
|
OTT
|
11
|
3.67
|
46
|
7.42
|
30
|
8.57
|
12
|
1.67
|
-14
|
3.87
|
195
|
6.54
|
38
|
1.7
|
163
|
8.49
|
41.93
|
|
14
|
Mikhail Sergachev
|
UTA
|
15
|
5
|
38
|
6.13
|
23
|
6.57
|
32
|
4.44
|
-8
|
4.67
|
132
|
4.43
|
61
|
2.74
|
140
|
7.29
|
41.27
|
|
15
|
Lane Hutson
|
MTL
|
6
|
2
|
60
|
9.68
|
26
|
7.43
|
34
|
4.72
|
-2
|
5.47
|
91
|
3.05
|
40
|
1.79
|
123
|
6.41
|
40.55
|
|
16
|
Neal Pionk
|
WPG
|
10
|
3.33
|
29
|
4.68
|
12
|
3.43
|
44
|
6.11
|
21
|
8.53
|
123
|
4.13
|
113
|
5.07
|
101
|
5.26
|
40.54
|
|
17
|
Thomas Harley
|
DAL
|
16
|
5.33
|
34
|
5.48
|
15
|
4.29
|
16
|
2.22
|
32
|
10
|
171
|
5.74
|
33
|
1.48
|
110
|
5.73
|
40.27
|
|
18
|
Adam Fox
|
NYR
|
10
|
3.33
|
51
|
8.23
|
18
|
5.14
|
32
|
4.44
|
9
|
6.93
|
135
|
4.53
|
40
|
1.79
|
108
|
5.62
|
40.03
|
|
19
|
John Carlson
|
WSH
|
5
|
1.67
|
46
|
7.42
|
14
|
4
|
22
|
3.06
|
17
|
8
|
167
|
5.6
|
49
|
2.2
|
131
|
6.82
|
38.77
|
|
20
|
Shayne Gostisbehere
|
CAR
|
7
|
2.33
|
38
|
6.13
|
27
|
7.71
|
52
|
7.22
|
1
|
5.87
|
122
|
4.09
|
40
|
1.79
|
66
|
3.44
|
38.59
|
|
21
|
Thomas Chabot
|
OTT
|
9
|
3
|
36
|
5.81
|
8
|
2.29
|
24
|
3.33
|
17
|
8
|
179
|
6.01
|
58
|
2.6
|
145
|
7.55
|
38.59
|
|
22
|
Jake Walman
|
EDM
|
7
|
2.33
|
33
|
5.32
|
8
|
2.29
|
42
|
5.83
|
4
|
6.27
|
164
|
5.5
|
57
|
2.56
|
145
|
7.55
|
37.65
|
|
23
|
Dougie Hamilton
|
NJD
|
9
|
3
|
31
|
5
|
15
|
4.29
|
30
|
4.17
|
8
|
6.8
|
186
|
6.24
|
73
|
3.27
|
85
|
4.43
|
37.19
|
|
24
|
Shea Theodore
|
VGK
|
7
|
2.33
|
50
|
8.06
|
19
|
5.43
|
26
|
3.61
|
18
|
8.13
|
128
|
4.3
|
6
|
0.27
|
82
|
4.27
|
36.41
|
|
25
|
Jackson LaCombe
|
ANA
|
14
|
4.67
|
29
|
4.68
|
9
|
2.57
|
28
|
3.89
|
0
|
5.73
|
134
|
4.5
|
69
|
3.09
|
129
|
6.72
|
35.85
|
|
26
|
Devon Toews
|
COL
|
10
|
3.33
|
34
|
5.48
|
3
|
0.86
|
26
|
3.61
|
30
|
9.73
|
138
|
4.63
|
40
|
1.79
|
103
|
5.36
|
34.81
|
|
27
|
Noah Dobson
|
NYI
|
10
|
3.33
|
29
|
4.68
|
12
|
3.43
|
28
|
3.89
|
-16
|
3.6
|
196
|
6.58
|
56
|
2.51
|
126
|
6.56
|
34.58
|
|
28
|
Aaron Ekblad
|
FLA
|
3
|
1
|
30
|
4.84
|
11
|
3.14
|
53
|
7.36
|
11
|
7.2
|
106
|
3.56
|
90
|
4.04
|
64
|
3.33
|
34.47
|
|
29
|
Brandt Clarke
|
LAK
|
5
|
1.67
|
28
|
4.52
|
9
|
2.57
|
46
|
6.39
|
13
|
7.47
|
131
|
4.4
|
22
|
0.99
|
121
|
6.3
|
34.29
|
|
30
|
Bowen Byram
|
BUF
|
7
|
2.33
|
31
|
5
|
2
|
0.57
|
46
|
6.39
|
11
|
7.2
|
94
|
3.15
|
74
|
3.32
|
117
|
6.09
|
34.06
|
|
31
|
Colton Parayko
|
STL
|
16
|
5.33
|
20
|
3.23
|
1
|
0.29
|
8
|
1.11
|
12
|
7.33
|
125
|
4.19
|
92
|
4.13
|
149
|
7.76
|
33.37
|
|
32
|
Seth Jones
|
FLA
|
9
|
3
|
27
|
4.35
|
19
|
5.43
|
22
|
3.06
|
-24
|
2.53
|
129
|
4.33
|
96
|
4.3
|
109
|
5.68
|
32.68
|
|
33
|
Erik Karlsson
|
PIT
|
11
|
3.67
|
42
|
6.77
|
15
|
4.29
|
20
|
2.78
|
-24
|
2.53
|
191
|
6.41
|
29
|
1.3
|
94
|
4.9
|
32.64
|
|
34
|
Noah Hanifin
|
VGK
|
10
|
3.33
|
29
|
4.68
|
10
|
2.86
|
14
|
1.94
|
8
|
6.8
|
145
|
4.87
|
42
|
1.88
|
106
|
5.52
|
31.88
|
|
35
|
Mattias Ekholm
|
EDM
|
9
|
3
|
24
|
3.87
|
7
|
2
|
30
|
4.17
|
11
|
7.2
|
143
|
4.8
|
42
|
1.88
|
95
|
4.95
|
31.87
|
|
36
|
Vince Dunn
|
SEA
|
11
|
3.67
|
28
|
4.52
|
12
|
3.43
|
33
|
4.58
|
-3
|
5.33
|
137
|
4.6
|
29
|
1.3
|
79
|
4.11
|
31.54
|
|
37
|
Morgan Rielly
|
TOR
|
7
|
2.33
|
34
|
5.48
|
14
|
4
|
21
|
2.92
|
-8
|
4.67
|
126
|
4.23
|
21
|
0.94
|
131
|
6.82
|
31.39
|
|
38
|
Justin Faulk
|
STL
|
4
|
1.33
|
28
|
4.52
|
12
|
3.43
|
30
|
4.17
|
-9
|
4.53
|
124
|
4.16
|
78
|
3.5
|
108
|
5.62
|
31.26
|
|
39
|
Brady Skjei
|
NSH
|
10
|
3.33
|
23
|
3.71
|
10
|
2.86
|
42
|
5.83
|
-24
|
2.53
|
156
|
5.23
|
51
|
2.29
|
93
|
4.84
|
30.63
|
|
40
|
Filip Hronek
|
VAN
|
5
|
1.67
|
28
|
4.52
|
7
|
2
|
40
|
5.56
|
0
|
5.73
|
83
|
2.79
|
89
|
3.99
|
75
|
3.91
|
30.15
|
|
41
|
Ivan Provorov
|
CBJ
|
7
|
2.33
|
26
|
4.19
|
3
|
0.86
|
31
|
4.31
|
11
|
7.2
|
100
|
3.36
|
28
|
1.26
|
127
|
6.61
|
30.12
|
|
42
|
Jared Spurgeon
|
MIN
|
7
|
2.33
|
25
|
4.03
|
9
|
2.57
|
14
|
1.94
|
8
|
6.8
|
107
|
3.59
|
53
|
2.38
|
119
|
6.2
|
29.85
|
|
43
|
Alex Pietrangelo
|
VGK
|
4
|
1.33
|
29
|
4.68
|
2
|
0.57
|
16
|
2.22
|
11
|
7.2
|
123
|
4.13
|
41
|
1.84
|
139
|
7.24
|
29.21
|
|
44
|
Roman Josi
|
NSH
|
9
|
3
|
29
|
4.68
|
17
|
4.86
|
18
|
2.5
|
-26
|
2.27
|
150
|
5.03
|
42
|
1.88
|
95
|
4.95
|
29.17
|
|
45
|
Matt Grzelcyk
|
PIT
|
1
|
0.33
|
39
|
6.29
|
15
|
4.29
|
16
|
2.22
|
-6
|
4.93
|
94
|
3.15
|
43
|
1.93
|
101
|
5.26
|
28.41
|
|
46
|
Luke Hughes
|
NJD
|
7
|
2.33
|
37
|
5.97
|
16
|
4.57
|
16
|
2.22
|
-9
|
4.53
|
121
|
4.06
|
19
|
0.85
|
60
|
3.12
|
27.67
|
|
47
|
Cam Fowler
|
STL
|
9
|
3
|
31
|
5
|
8
|
2.29
|
14
|
1.94
|
12
|
7.33
|
88
|
2.95
|
8
|
0.36
|
87
|
4.53
|
27.41
|
|
48
|
Darren Raddysh
|
TBL
|
6
|
2
|
31
|
5
|
9
|
2.57
|
14
|
1.94
|
9
|
6.93
|
108
|
3.62
|
38
|
1.7
|
68
|
3.54
|
27.32
|
|
49
|
Owen Power
|
BUF
|
7
|
2.33
|
33
|
5.32
|
6
|
1.71
|
16
|
2.22
|
-13
|
4
|
139
|
4.66
|
26
|
1.17
|
109
|
5.68
|
27.1
|
|
50
|
Mason Lohrei
|
BOS
|
5
|
1.67
|
28
|
4.52
|
16
|
4.57
|
16
|
2.22
|
-43
|
0
|
92
|
3.09
|
25
|
1.12
|
103
|
5.36
|
22.55
|