Roster Selection
{ Posted on Wednesday, September 09, 2009
by Draft Geek
}
My final drafts are in the books. No major occurrences in either so I wont recount the details. After all.... 99.9% of the drafts are done at this point and it's time to look forward to the start of the season!
The biggest question for all of us, now that the drafts are over, is "Who do I start week 1?"
The answer to this is really no different than the decisions we had to make while organizing our drafts. The two essential parts of ranking players, whether for the season or week by week are:
Because of this, I use Yahoo's projections (and my gut) as a starting point.
I then turn to yet another of my spreadsheets. I update this spreadsheet with weekly player projections, as well as a "Settings" worksheet that contains all of my leagues scoring systems.
In this settings tab, I have a select list that contains the names of all of my leagues.
This can be done by going to data/data validation and using the following settings
The Source which is "=Leagues" is a named range I have that contains the different leagues.
Below this select list I have the scoring rules. The first column uses a HLOOKUP on the leagues and settings to retrieve the settings for the selected league:
Now that we have the current settings it is a simple matter to apply them to the projections.
With this extra set of projections I have multiple sources to consider when setting my lineup.
The biggest question for all of us, now that the drafts are over, is "Who do I start week 1?"
The answer to this is really no different than the decisions we had to make while organizing our drafts. The two essential parts of ranking players, whether for the season or week by week are:
- Projections
- Scoring System
Because of this, I use Yahoo's projections (and my gut) as a starting point.
I then turn to yet another of my spreadsheets. I update this spreadsheet with weekly player projections, as well as a "Settings" worksheet that contains all of my leagues scoring systems.
In this settings tab, I have a select list that contains the names of all of my leagues.
This can be done by going to data/data validation and using the following settings
The Source which is "=Leagues" is a named range I have that contains the different leagues.
Below this select list I have the scoring rules. The first column uses a HLOOKUP on the leagues and settings to retrieve the settings for the selected league:
Now that we have the current settings it is a simple matter to apply them to the projections.
With this extra set of projections I have multiple sources to consider when setting my lineup.