Фэнтези лигийн оролцогчид өөрсдийн лигийн дүрэм болон онооны системд тохируулан тоглогчдын чансааг өөрчлөх боломжтой боллоо.
NHL-ийн шинэ улирал эхлэхтэй холбогдуулан fantasy хоккейн менежерүүдэд зориулсан тусгай хүснэгтүүдийг танилцууллаа. Эдгээр файл нь Yahoo болон Fantrax платформуудын онцлогт тохируулан тоглогчдын статистик, ирээдүйн гүйцэтгэлийг урьдчилан таамаглах, лигийн өвөрмөц тохиргоог нэвтрүүлэх боломжийг олгож байна. Менежерүүд өөрсдийн лигийн онооны систем, бүрэлдэхүүний бүтэц, тоглогчдын байрлалыг оруулах замаар хамгийн оновчтой чансааг гаргах боломжтой.
Энэхүү загвар нь тоглогчдын “Value Over Replacement” буюу орлуулах тоглогчоос давуу байх үнэлгээнд суурилан чансааг тодорхойлдог. Тоглогч бүрийн ирээдүйн гүйцэтгэлийг сүүлийн гурван жилийн статистик, насны онцлог, мөсөн дээр өнгөрүүлсэн хугацаа болон багийн бүрэлдэхүүний өөрчлөлтөд үндэслэн тооцоолсон байна. Жишээлбэл, Коннор Макдэвид 81 тоглолтод 131 оноо авах магадлалтай ч бодит гүйцэтгэл нь 122-140 онооны хооронд хэлбэлзэх боломжтойг шинжээчид анхаарууллаа.
Менежерүүд тоглогчдын чансааг тохируулахдаа “boom or bust” баганын тусламжтайгаар өөрийн таамаглалыг нэмэх боломжтой. Мөн өнгөөр ялгасан үзүүлэлтүүд нь багийн хуваарь, нас, гэрээний хугацаа, тооны давуу байдал дахь үүрэг зэргийг харьцуулан харахад тусална. Эдгээр зөвлөмжүүд нь менежерүүдэд тоглогчдыг хэзээ сонгох, хэрхэн зөв стратеги баримтлах талаар цогц мэдээллийг өгч байна.
Дэлгэрэнгүйг эх сурвалжаас харах
↓Эх сурвалжийг нээх ↓
The hockey season is just around the corner, which means we’re back for another edition of our fantasy hockey cheat sheet. It’s time to start prepping for your drafts!
If this isn’t your first time, you know what to do: The rankings are below for you to download, in big bold letters. For the folks who are new, here’s the deal: We have a fancy spreadsheet that creates fully customizable rankings tailored to whatever strange way your league is set up.
There’s no real standardized hockey league, and the best way to get ahead is having rankings that take into account your league’s specific settings. Your league is not the same as the next person’s — a critical point when it comes to research and rankings. In fantasy hockey, there’s no one-size-fits-all ranking. Depending on any single set of rankings — no matter how smart the ranker — might already be your first mistake.
While other rankings can work for standard leagues or research purposes, they probably don’t apply directly to your league’s quirks. That’s the point of this spreadsheet: to create an easy way for any fantasy hockey manager to tailor rankings to their league’s scoring system and format. (And trust us, it pays to have projections for every stat you need, not just points).
You can find download links to the sheets below (In Excel and Numbers formats). Instructions on how the sheet works as well as answers to some frequently asked questions are underneath. (All patches and updates will be noted at the bottom of this page.)
Microsoft Excel download link (Yahoo)
Microsoft Excel download link (Fantrax)
Numbers download link (Yahoo)
Numbers download link (Fantrax)
How to use this fantasy hockey cheat sheet
Step 1: Scoring settings
The first thing you need to do is to go to the “Settings” tab to start customizing. On the left side is where you’ll enter your league’s scoring system. If you’re in a points-based league, you only need to worry about the points column. If you’re in a categories or roto league, only worry about the categories column.
For points leagues, simply type in the value next to each stat. If a goal is worth three points, type “3.” That’s it.
For category leagues, I use standard deviations to score players in each category, so simply type “1” next to whatever category your league uses. This weights each category equally. If you would like to add more weight to certain categories (goals, assists, shots) over others (PIM, hits, blocks) based on scarcity, you can make the former categories worth more than 1 and/or the latter categories worth less.
Step 2: League settings
Next, you’ll focus on the right side of the page.
At the top, fill in how many players are in the starting lineup. If you’re in a league that doesn’t separate forwards by position, just make sure all three positions add up to the total amount of forward positions. At the bottom under “number of teams,” type in how many teams are in your league.
For ADP data, type in which fantasy service you use.
For league type, type in “points” or “categories,” depending on whichever your league uses. There’s only one page for rankings, so this step is crucial to make sure the correct total fantasy point calculation is used.
For forward positions, type in “C/LW/RW” if separated or “forwards” if not. We realize all of this is pretty self-explanatory from looking at the spreadsheet, but for those less fluent, we figured we would spell it out for you.
Then there’s “games played projections.” “No” means that every skater is projected to play all 84 games, while “yes” uses our games played estimates. If you’re of the mind that injuries are random, it might be better to go by a player’s projected per-game output. Just make sure you go through the list to mark the players who already have known injuries.
There’s one more setting, but it requires further explanation.
Step 3: Establishing a baseline
There’s a reason that you’re asked to fill out league size and starting lineup size above, and that’s so the spreadsheet can calculate each player’s value over replacement — the key to the rankings.
Essentially, each player has a projected fantasy point rate, but that number needs the added context of what position he plays and what other players at the position are expected to do. Generally, this is to control for the fact that there’s an abundance of strong scoring centers and not as many capable wingers or defenders.
For example, if Rasmus Dahlin is expected to score 420 fantasy points and Jack Eichel is expected to score 500, it’s the latter that seems more valuable. But it all depends on that baseline, where you can generally get a 400-point center just as easily as a 320-point defender. That makes them equally valuable. There’s a column in the settings sheet so you have an easy view at what that baseline is for each position.
Now, here’s where things get tricky: How do you actually establish the baseline?
Previously, it was established with an automatic calculation based on league size and starting lineup, combined with how players are normally drafted within the top 100. That generally made defenders more valuable, but for some, it doesn’t go far enough — the need for four defensemen in a standard league makes them even more valuable than the calculation suggested. For some users and leagues, the positional requirement using the starting lineup multiplied by team size as the baseline – essentially, the true definition of replacement — works best.
Using the draft to dictate the process helps account for the fact that people don’t normally draft defensemen super high (though they are starting to) even if they should, but perhaps it’s not cognizant enough of the reality of defensemen needs. With most teams now opting for a 4F1D power play, finding a good defender is more difficult than it’s ever been.
It’s for that reason that there’s an option for establishing the baseline: “draft” (the default, which is based off top-100 selections), “position” (based off starting lineup and league size) and “blend,” which mixes both together. As long as you’re not reaching for targets and drafting along ADP, any choice you make should be fine.
Step 4: Creating the ranking
All of that work sets up your rankings, but once you go to “The List” page, you will see that everything is probably out of order. All you need to do now is sort. In Apple Numbers, just double-click the top of the rank column and press “Sort Ascending.” In Excel, click the arrow at the top of the rank column and then click “Sort Ascending.” The rank is based on each player’s VORP, so alternatively you can sort by that as well. If you’re in a league that uses a salary cap, the “/$” column compares VORP to a player’s salary, so alternatively you can sort by that.
For keeper leagues, use the “keep” column to denote any player who is a keeper. You can then filter them out using the arrows above in Excel or the filter option under “Organize” in the sidebar in Numbers.
Step 5: Projection Customization
The final step is disagreeing with us. We know you probably will and that’s OK! We’ve even made that process easier with a specific column for adjusting called “boom or bust.”
The gist is that we know a model, no matter how good, is not infallible. Human intuition is important, and we wanted to include some adjustments based on our feelings and disagreements with the model’s output. This is especially helpful for younger players who look ready to break out or players who have switched teams — two instances the model has historically struggled with.
We went through each projection and debated whether a player deserved to be a little higher or lower. On the actual list page you can see a “+” or “-“ denoting exactly which players we tinkered with, making it easy to see exactly where our subjective judgement came into play.
This is also where your disagreements come into play. On the sheet there’s a column labelled “ADJ” that’s already filled with adjustments made by Shayna Goldman and I, but you can change those or add your own. It’s as simple as adding a “+” or “-“ for small adjustments, or “+ +” and “- -“ for bigger adjustments (not recommended for goalies). Don’t be afraid to use your gut instinct.
Step 6: Drafting
The final step is actually drafting your team. Here’s what we usually do: Once a player is drafted, we use the “keep” column as a way to denote which players are taken already. If they were drafted, we might type a “Y” in that column, and then you can use the filters above the column to automatically hide players who are selected as it happens.
It’s also worth keeping track of your team while you draft, and that’s where the “Team Comparison” tab comes in. Type in the players you draft as it happens and the table will auto-populate their projections. If you have time, you can also type in the other teams as well for an instant comparison of where your team stands.
FAQ
How do these projections work?
First and foremost, it starts with Evolving Hockey. We don’t know where we would be without that site, but all the data that goes into creating the projections comes from there.
After that, it’s a relatively simple marcel projection that uses the past three years of data for each stat, weighted by recency, regressed to the mean, and age-adjusted. That’s done on a per-minute level and applied to time-on-ice projections based on each player’s ice time last season, adjusted for where they’ll likely fit on the depth chart this year (with the help of the NHL beat writers).
How accurate are these projections?
This is always a very important question. While the projections themselves look absolute, the reality is that there are margins of error. A player projected to hit 80 points really means “somewhere between 70 and 90 points.” Worst case, he’s on the low end; best case, he’s on the high end — with some exceptions to the rule that end up way higher or lower. I didn’t go through last year’s projections, but the general rule of thumb is points are usually off by 9-10 points, while shots are usually off by 25.
Do you really believe Connor McDavid will score exactly 131 points?
Not exactly, and it goes back to the point made above. Think of a projection as a probability and the figure shown as an average of that probability. The likeliest point total for McDavid next year is 131 points in 81 games, but as we saw above, the average error for projections is about nine points in a normal season. So really, that’s saying he’ll likely score between 122 and 140 points in a season, give or take. It’s a ballpark figure where the goal is to be less wrong. A projection model will do that better than just guessing, and a good projection will do better than a bad one.
Once I have customized rankings, should I blindly follow the list that was generated for me?
No, and it comes down to the range discussed above. If Rasmus Dahlin is at 420 fantasy points and Matthew Schaefer is at 410 points, both players are well within each other’s error bounds. Dahlin is probably the better bet, but if you want to argue for Schaefer, that’s an important debate to have while making selections.
Context won’t be explicitly included in a projection like this. That’s why it will be helpful to read all the other fantasy hockey draft content coming down the pipeline to become more informed about the players who might underperform or overperform their projections.
In general, it’s best to follow the rankings, but it’s fair to squabble when players are very close to each other. In those cases, you’re usually splitting hairs.
Why is there a mediocre goalie ranked so high?
Fair enough! For points leagues, start volume is the key for goaltenders, and often when you see a goaltender ranked higher than expected here, it’s because of that reason alone. In a league that’s veering more and more toward tandem situations, it pays to have a legitimate starter likely to play in 70 percent of their games, as those players are few and far between.
Explaining our color-coded context
Knowing a player’s expected output going into a draft is crucial, but it’s not the only thing worth considering — especially if you’re stuck picking between two equal-ish players. We have a few color-coded indicators that can help with a legend on the settings page. Basically, blue is good, red is bad.
Team: This is a double-whammy with two things to consider: strength-of-schedule and fantasy scheduling itself.
On the first front, we’ve colored teams with the weakest average defensive opponents blue and the strongest in red. Basically, the more games against the Pacific division the better.
On the second front, we also looked into which teams play the most off-days (Monday, Wednesday, Friday, Sunday). Those teams are in bold and are especially good targets lower in the draft as they’ll be much easier to fit into lineups. It’s a way to get more out of your bench, as a player sitting there doesn’t do much good.
Age: The projections are already age-adjusted, but it’s worth being mindful of players who may take bigger jumps, up or down, due to age. Blue is anyone who isn’t in their prime yet (95 percent of peak age production) and could breakout. Red is anyone who is likely past their prime.
Salary: If you’re a believer in contract-year hype, we’ve got you covered. Any player with one year left on his deal is highlighted in bold blue.
ADP Difference: This is one we’ve already had for years, but there’s a slight tweak this year. Now, bold means anyone who is a two-round difference or more, while the normal weight (but colored) is anyone between 1-2 rounds off where we have them.
Knowing who to draft is only half the battle. Knowing when to draft them is the other, and this slight tweak should be helpful when it comes to figuring out where to target players.
TOI: One of the foundations of these projections is projecting which players should see an increase and decrease in ice time. Now those changes will be easier to spot, as anyone who is expecting to see a one-minute difference from last year, or higher, is highlighted.
PPP: Going hand-in-hand with role is knowing which players will have a coveted job in the top power play. It’s especially true for defensemen, where there’s usually only one spot available. Getting that right — especially for teams where there’s uncertainty — can be the difference between winning and losing. This year we’ve highlighted exactly who we expect to get those roles in blue, with bold names likely to get over 60 percent of the available power-play ice time.
In some cases, we’re making an educated guess, with some names looking like serious sleepers as a result (hello, Luca Cagnoni in San Jose). But in a few cases, there’s still some uncertainty leading to a 50-50 split.
As things become more clear during training camp, we will provide updates, but the knowledge of who we have in those roles should be helpful — especially if you disagree.
