SELECT nhl_players.last_name , nhl_players.first_name , nhl_players.player_id , nhl_players.birth_date , FLOOR(DATEDIFF('2024-10-10', nhl_players.birth_date) / 365) AS age , nhl_players.rookie , IF(nhl_players.player_id in (0), 'UFA', nhl_teams.team_code) AS team_code , nhl_positions.position_abbreviation , nhl_career_stats_skaters.team_code_finished , spofo_mag_projections.mag_top400_rk AS db_rank , ed_sportscodes.tsf_global AS tsf_global , (spofo_mag_projections.g + spofo_mag_projections.a) AS predicted_points , spofo_mag_projections.g AS predicted_goals , spofo_mag_projections.a AS predicted_assists , spofo_mag_projections.gp AS predicted_GP , IF(nhl_career_stats_skaters.gp IS NULL, '0', nhl_career_stats_skaters.gp) AS actual_GP , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.g) AS actual_goals , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.a) AS actual_assists , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.pts) AS actual_points , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.plus_minus) AS actual_plus_minus , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.pts / nhl_career_stats_skaters.gp) AS actual_pts_per_gp , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.pim) AS actual_pim , spofo_mag_projections.injury_concern , spofo_mag_projections.must_draft , spofo_mag_projections.contract_year , spofo_mag_projections.fantasy_tags_gte FROM spofo_mag_projections LEFT JOIN nhl_players on nhl_players.player_id = spofo_mag_projections.player_id LEFT OUTER JOIN nhl_career_stats_skaters ON nhl_career_stats_skaters.player_id = spofo_mag_projections.player_id AND (nhl_career_stats_skaters.date_desc = '2023-24' AND nhl_career_stats_skaters.league = 'NHL' AND nhl_career_stats_skaters.date_sort = '2023.9' AND nhl_career_stats_skaters.line_desc = 'normal') LEFT JOIN ed_sportscodes ON spofo_mag_projections.player_id = ed_sportscodes.tsf AND ed_sportscodes.league_id = 'hockey' LEFT JOIN nhl_positions ON nhl_players.position_1 = nhl_positions.position_id LEFT JOIN nhl_teams ON nhl_players.team_id = nhl_teams.team_id WHERE TRUE AND spofo_mag_projections.season = '2024-25' AND spofo_mag_projections.gp IS NOT NULL AND spofo_mag_projections.mag_top400_rk < 401 AND nhl_positions.position_abbreviation != 'G' ORDER BY spofo_mag_projections.mag_top400_rk ASC LIMIT 150, 50 ;
NHL Preview 2024-25 141 SportsForecaster.com
Top 400 Skaters
Get spreadsheets at SportsForecaster.com

$→ Contract year • +→ Injury concern • K→ Must-draft player • Z→ Sleeper • R→ Rookie

Ages as of October 10, 2024

2023-24 2024-25 Forecast
  Name Team Pos Age GP G A P P/GP +/- PIM GP G A P  
151
Ott
C
23
41
9
18
27
0.66
9
14
82
25
25
50
152
TB
C
27
79
20
25
45
0.57
2
38
80
22
28
50
153
Cgy
C
25
71
13
28
41
0.58
4
22
77
20
30
50
$ Z
154
CBJ
C
32
82
25
35
60
0.73
-2
38
82
20
30
50
155
Bos
D
26
74
12
35
47
0.64
4
86
75
10
40
50
156
Ana
LW
30
82
37
23
60
0.73
-20
85
82
29
20
49
$
157
Chi
LW
29
80
21
22
43
0.54
2
53
75
26
23
49
158
StL
LW
22
77
27
11
38
0.49
-16
21
80
25
24
49
$
159
Tor
RW
21
80
15
20
35
0.44
9
45
80
21
28
49
$
160
Uta
LW
24
33
3
7
10
0.30
-13
26
72
17
32
49
+
161
-
W
25
75
18
36
54
0.72
-44
23
77
17
32
49
$
162
Nsh
D
30
80
13
34
47
0.59
15
40
81
13
36
49
163
VGK
D
27
80
13
34
47
0.59
19
24
81
11
38
49
164
TB
D
34
82
10
42
52
0.63
-7
40
80
10
39
49
165
CBJ
RW
28
82
20
27
47
0.57
19
35
80
24
24
48
166
SJ
LW
29
81
22
31
53
0.65
22
54
78
20
28
48
167
Mtl
C
31
78
17
30
47
0.60
12
18
80
19
29
48
168
Ana
C
19
55
12
17
29
0.53
-11
16
72
18
30
48
169
Det
LW
29
77
19
29
48
0.62
-5
34
79
16
32
48
170
Sea
RW
34
78
17
27
44
0.56
1
17
80
16
32
48
171
LA
D
34
82
15
35
50
0.61
15
44
77
11
37
48
172
Pit
D
37
82
10
41
51
0.62
13
62
75
9
39
48
173
CBJ
RW
24
78
23
19
42
0.54
-5
14
80
25
22
47
Z
174
SJ
C
18
0
0.00
78
24
23
47
K
175
-
LW
29
81
19
36
55
0.68
-19
57
82
22
25
47
Z
176
-
RW
25
81
16
25
41
0.51
-15
24
82
22
25
47
Z
177
NYI
LW
33
82
20
26
46
0.56
-22
56
77
19
28
47
178
Uta
RW
27
81
23
19
42
0.52
-7
36
80
25
21
46
Z
179
Det
RW
31
18
6
9
15
0.83
4
14
68
24
22
46
+
180
Min
LW
32
78
30
24
54
0.69
19
76
80
24
22
46
181
CBJ
C
30
83
26
33
59
0.71
-1
12
76
18
28
46
182
Ana
C
32
69
12
48
60
0.87
-23
32
72
10
36
46
$ +
183
Col
D
30
82
12
38
50
0.61
28
18
80
10
36
46
184
Uta
D
26
34
2
17
19
0.56
-16
16
75
9
37
46
+
185
Phi
LW
22
77
20
13
33
0.43
0
32
80
25
20
45
$
186
-
LW
31
82
26
16
42
0.51
-4
20
80
24
21
45
187
-
C
34
82
24
27
51
0.62
9
37
74
23
22
45
188
Sea
C
30
75
16
35
51
0.68
-9
25
80
17
28
45
189
Dal
D
23
79
15
32
47
0.59
28
18
81
12
33
45
190
Ott
D
22
79
10
28
38
0.48
8
23
81
12
33
45
191
NYR
D
25
76
9
32
41
0.54
-1
63
77
10
35
45
192
Min
D
22
82
8
39
47
0.57
-1
26
82
9
36
45
193
Wsh
LW
31
58
22
13
35
0.60
-8
28
74
24
20
44
+
194
NJ
RW
22
82
20
13
33
0.40
-26
29
82
22
22
44
195
Wsh
RW
30
74
18
17
35
0.47
-19
133
76
21
23
44
196
Nsh
RW
23
80
24
12
36
0.45
23
51
81
21
23
44
$ Z
197
Chi
RW
28
75
14
26
40
0.53
7
47
82
19
25
44
$
198
Wsh
C
26
82
16
24
40
0.49
-9
70
80
18
26
44
199
-
RW
36
76
17
30
47
0.62
-12
55
78
16
28
44
200
Ott
RW
29
49
7
9
16
0.33
-15
14
70
15
29
44
+