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
RW
29
80
21
22
43
0.54
2
53
75
26
23
49
158
StL
RW
22
77
27
11
38
0.49
-16
21
80
25
24
49
$
159
Tor
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
SJ
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
Wsh
D
34
82
10
42
52
0.63
-7
40
80
10
39
49
165
Van
RW
28
82
20
27
47
0.57
19
35
80
24
24
48
166
Sea
LW
29
81
22
31
53
0.65
22
54
78
20
28
48
167
LA
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
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
Nsh
LW
29
81
19
36
55
0.68
-19
57
82
22
25
47
Z
176
Sea
RW
25
81
16
25
41
0.51
-15
24
82
22
25
47
Z
177
StL
W
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
Bos
RW
31
18
6
9
15
0.83
4
14
68
24
22
46
+
180
Cgy
RW
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
W
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
VGK
LW
31
82
26
16
42
0.51
-4
20
80
24
21
45
187
Edm
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
Uta
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
CBJ
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
Van
LW
23
80
24
12
36
0.45
23
51
81
21
23
44
$ Z
197
Edm
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
Ott
LW
36
76
17
30
47
0.62
-12
55
78
16
28
44
200
Chi
RW
29
49
7
9
16
0.33
-15
14
70
15
29
44
+