Although I play in keeper leagues this strategy works for seasonal formats as well. I recommend you give yourself room at the draft as you will have several key reports in front of you at all times.
The first spreadsheet you will need is a list of all team owners listed horizontally across the top (listed in draft order). Down the vertical column you will list positions QB, RB, WR, TE, K, and DEF. This is obviously determined by your league starting roster rules and how many of each position you will need. This is the MOST important spreadsheet you have. This will allow you to maximize drafting position as the draft unfolds. It will also keep you from being swept away in runs on certain positions.
Let’s assume a 10 team league that starts 1 QB, 2 RB, 3 WR, 1 TE, 1 K, and 1 DEF. As each draft pick is announced you enter it under the team name and position drafted. You are able to quickly see what each team needs and what each team doesn’t need. This keeps you from picking players too high and pick up some real steals later in the draft.
For example, you are team 8 in a 10 team snake draft. It’s round 3 and you’ve already picked RB and QB with your first two picks. You know you need that second RB but you see that teams 9 and 10 already have 2 running backs. It is highly unlikely either team will use either of their next two picks on running backs. Therefore, you take a top WR and pick up that second running back in round 4. You’ve now made a great value pick and not reached for the running back that would be there anyway.
The next spreadsheet in front of you should be a player rankings report. It doesn’t matter if it is one you created or ripped from a magazine. Fantasysharks printable cheat sheet is ideal because it will eliminate the third spreadsheet of bye weeks. As the draft progresses you can cross reference your possible player selections with how each team is drafting on the first spreadsheet.
Finally, you need a report listing each player’s bye weeks. I write it next to the player I draft as I fill in the first spreadsheet. This guarantees I don’t have a team full of players out in any given week. It also helps making difficult decisions between two comparable players. Every year I look back and notice owners not paying attention and pray to god I play them that week. This is a no brainer for serious team owners.
Being prepared for a draft is the best thing you can do towards winning a championship. Certain elements, such as injuries, of fantasy football are beyond your control. Making smart draft decisions is not one of them.