Whether you invest early or opt to look for bargains later, you're going to need production from this spot to have a chance to win. This template is available in English and is designed for Excel 2016+ for Windows, Mac, and Excel for the web.Like it or not, your running backs are probably going to make or break your Fantasy Football team. We wish you the best of luck in your fantasy league, and hope this template helps you draft a successful team!
The schedule shows the bye weeks and locations for the different teams so you can factor this into your draft decision-making.įor example, TB (Tampa Bay) has a string of away games from Week 4 through Week 9, which might be a series of tough games for players during those weeks. View the entire season’s schedule on the Schedule sheet. Tip #2: Sorting the "All" sheets list of players will change the order of the drop down on the draft board! In the upper left corner of the Position sheets you’ll see what percentage of FPTS is left for that position. In the upper left corner of the All Players sheet you’ll see how many players have been picked overall in the draft so far. Already-picked players show up grayed-out in the list. ) has more detailed stats for each player in that position. Tip #1: if you’re looking for players that aren’t in a particular bye week, just CTRL + click that week to remove it from the current set!Įach Position sheet (QB, RB, WR.
The header drop downs for each column will allow you to quickly sort and filter a column.There are two ways to quickly sort and filter this data: Use the All Players tab to sort and filter all the players by key stats from last season and availability. The count of players for each team in your league is also updated at the top use that to predict what position each team still needs and what they might pick next!Īs players are chosen, the workbook is updated with player availability so you can see who’s the “best of the rest”.
Points are calculated using the previous year’s stats with the scoring system filled out on the setup sheet. Use the drop downs to pick the players, or start typing a player name for auto-complete to kick in.Īs players are picked, their data is pulled in. Use the Draft Board to track your league’s picks! Run the league draft from here or follow along with your league to track player availability. If you want to follow (or run!) your league’s draft in this template, enter your league’s team names in draft order. The Setup sheet allows you to configure your league settings, which will update the FPTS (fantasy point) totals throughout the template. Follow your league’s scoring system to calculate the fantasy points per player or team defense, and keep track of available players as they’re picked. This Draft template is filled out with rich player data ready to sort and filter as you research the best picks. Now that the NFL preseason is off and running, fantasy leagues are starting up! Get the edge with our player analysis sheets or run the entire draft from Excel with this fantasy football template!Ĭlick here to get the template, you will have the option to use it for free on Excel for the Web, or download it to your desktop.