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
RW
30
82
37
23
60
0.73
-20
85
82
29
20
49
$
157
Chi
RW
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
CBJ
LW
21
80
15
20
35
0.44
9
45
80
21
28
49
$
160
Uta
C
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
C
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
Tor
LW
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
Phi
LW
29
81
19
36
55
0.68
-19
57
82
22
25
47
Z
176
NYR
LW
25
81
16
25
41
0.51
-15
24
82
22
25
47
Z
177
NYI
C
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
LW
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
Wpg
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
LW
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
Dal
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
+