But it all depends on that baseline, where you can generally get a 400-point center for your bench just as easily as a 300-point defender. 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.įor example, if Dougie Hamilton is expected to score 400 fantasy points and Tage Thompson is expected to score 500, it’s the latter that seems more valuable. There’s a reason 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.Įssentially, 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. There’s one more setting, but that one requires further explanation. Just make sure you go through the list to mark the players who already have known injuries, like Brandon Montour or Jack Quinn. If you’re of the mind that injuries are random, it might be better to go by a player’s projected per-game output. Then there’s “games played projections.” “No” means that every skater is projected to play all 82 games, while “yes” uses my games played estimates. I realize all of this is pretty self-explanatory when looking at the spreadsheet, but for those less fluent, I figured I would spell it out for you. This year there’s only one page for rankings as opposed to separate pages for both so this step is crucial as it makes sure the correct total fantasy point calculation is used.įor forward positions, type in “C/LW/RW” if it’s separated or “forwards” if it’s not. At the bottom under “number of teams,” type in how many teams are in your league.įor ADP data, type in which fantasy service you use.įor league type, type in “points” or “categories” depending on whichever your league uses. 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. Next, you are going to focus on the right side of the page.Īt the top, fill in how many players are in the starting lineup. 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 one and the latter categories worth less. If a goal is worth three points, type “3.” That’s it.įor category leagues, I use standard deviations to score players in each category, so simply type “1” next to whatever category your league uses. If you’re in a categories or roto league, only worry about the categories column.įor points leagues, simply type in the value next to each stat. If you’re in a points-based league, you only need to worry about the points column. On the left side is where you’ll enter your league’s scoring system. The first thing you need to do is to go to the “Settings” tab to start customizing.
#Nhl stats excel how to
How to use this fantasy hockey cheat sheet Step 1: Scoring settings With that being said, we have a second sheet for those in Fantrax leagues where the positions aren’t outrageously designated.
#Nhl stats excel update
We’re going to keep our eyes on that and update the sheet once that hopefully changes for the better. One final note: Yahoo has lost its mind with its position designations this year ( Shayna wrote a great story about it here). (Note: All patches and updates will be updated at the bottom of this story.) Underneath that, you can find instructions on how the sheet works as well as answers to some frequently asked questions.
#Nhl stats excel download
You can find download links to the sheets below (in Excel and Numbers/Mac formats). (And trust me, it pays to have projections for every stat you need, not just points.) That’s why this spreadsheet exists, to create an easy way for any fantasy hockey manager to have their own rankings that actually fit their league’s scoring system and format.
Other rankings are great for standard leagues or for research purposes, but they may not apply directly to your own league.
0 kommentar(er)
