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 250, 50 ;
NHL Preview 2024-25 143 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  
251
Col
LW
29
54
28
25
53
0.98
5
22
50
19
18
37
+
252
CBJ
RW
21
42
6
10
16
0.38
-2
10
80
17
20
37
+
253
Fla
C
31
80
12
27
39
0.49
26
34
82
13
24
37
254
VGK
D
34
64
4
29
33
0.52
-5
24
75
9
28
37
+
255
TB
D
28
82
6
27
33
0.40
-3
21
82
7
30
37
256
Tor
RW
23
56
14
13
27
0.48
4
4
71
19
17
36
Z
257
Det
LW
25
75
13
20
33
0.44
8
47
76
15
21
36
258
Car
LW
32
10
2
2
4
0.40
-3
4
65
13
23
36
$ +
259
VGK
C
30
81
15
20
35
0.43
-6
38
82
13
23
36
260
Col
C
24
74
8
19
27
0.36
4
33
78
12
24
36
Z
261
Pit
RW
25
52
5
15
20
0.38
4
6
74
10
26
36
262
Ana
D
20
63
4
24
28
0.44
-20
24
76
7
29
36
+
263
NYI
LW
34
81
20
17
37
0.46
2
68
80
19
16
35
264
AHL
LW
28
68
18
14
32
0.47
-13
32
63
17
18
35
$ +
265
Det
RW
28
82
14
22
36
0.44
16
26
82
17
18
35
$
266
Edm
W
26
82
18
22
40
0.49
9
69
82
16
19
35
$
267
Bos
RW
26
76
17
22
39
0.51
6
28
78
15
20
35
$
268
CBJ
W
21
77
13
19
32
0.42
-4
46
80
15
20
35
269
Tor
C
27
70
13
28
41
0.59
8
29
80
15
20
35
+
270
Mtl
LW
25
78
12
18
30
0.38
-5
38
78
13
22
35
271
Car
D
24
80
8
22
30
0.38
5
49
81
10
25
35
$
272
Wsh
LW
23
78
6
23
29
0.37
-3
8
80
9
26
35
273
StL
D
32
60
2
28
30
0.50
-2
39
77
8
27
35
+
274
Col
D
39
82
10
33
43
0.52
19
20
82
8
27
35
$
275
Wsh
C
22
51
8
14
22
0.43
-1
4
75
13
21
34
$ Z
276
StL
LW
27
72
11
24
35
0.49
-4
51
79
13
21
34
+
277
Min
LW
34
78
11
19
30
0.38
-15
22
74
12
22
34
$
278
Phi
C
25
59
6
12
18
0.31
-8
0
75
12
22
34
$ +
279
Nsh
C
33
76
16
19
35
0.46
-1
54
79
12
22
34
280
Pit
RW
23
41
7
13
20
0.49
-6
25
70
10
24
34
Z
281
Phi
C
31
74
11
27
38
0.51
-10
29
76
10
24
34
282
Car
D
31
81
10
46
56
0.69
-16
16
77
9
25
34
283
Mtl
D
20
2
0
2
2
1.00
-2
0
79
6
28
34
284
Uta
D
26
54
0
17
17
0.31
1
12
70
3
31
34
$ Z
285
Ana
LW
20
1
0
1
1
1.00
1
0
71
20
13
33
286
Sea
C
20
8
4
1
5
0.63
1
0
73
15
18
33
287
Tor
LW
28
63
18
14
32
0.51
19
60
75
15
18
33
+
288
Car
C
24
79
12
15
27
0.34
-4
36
81
15
18
33
289
Chi
C
29
82
22
13
35
0.43
4
43
80
14
19
33
290
Cgy
D
27
24
3
4
7
0.29
-2
8
75
12
21
33
Z
291
Fla
D
28
51
4
14
18
0.35
27
50
77
10
23
33
$ +
292
Wpg
LW
31
78
11
26
37
0.47
17
37
75
9
24
33
$
293
Mtl
C
28
82
7
21
28
0.34
-1
24
82
9
24
33
$
294
Ana
D
21
26
2
7
9
0.35
-6
4
73
6
27
33
Z
295
TB
D
24
80
5
21
26
0.33
-5
35
81
6
27
33
296
Bos
D
30
73
3
23
26
0.36
18
63
80
5
28
33
297
StL
D
32
81
5
34
39
0.48
-36
24
82
5
28
33
298
LA
RW
22
81
12
11
23
0.28
-14
46
82
17
15
32
$
299
Tor
RW
28
56
15
9
24
0.43
13
52
70
16
16
32
+
300
Col
RW
31
0
—
—
—
0.00
—
—
41
14
18
32
+