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:
  1. Projections
  2. Scoring System
Any online league worth its weight should have a set of projections and should automatically apply your leagues scoring to those projections. Your works is done... right? Well it is if you trust those projections. All of my leagues use yahoo, which I believe is a very good league manager. That being said, I don't necessarily trust Yahoo enough to be my sole source. After all, the rest of the players in my league have the same data. Where is my edge?

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.