Fantasy Football Draft Geek

Probably the single most important thing you need in order to help you win your fantasy league is a set of good projections. How else are you going to rate a players performance???

As stated in a previous post, I decided to use several sources for my projections. This, in my mind, helps for a couple reasons:

1. Certain sources tend to go on a hunch in the hopes they are right and recognized the next year as the "go to" source. In reality, that player may be deserving of a slight bump, but not to the degree that the source is claiming.
2. If I tend to agree with one source more than another I can easily weight the averages.

Here comes the geeky stuff:
I take the projections I gather from various sites and import them into my excel spreadsheet on a new tab (one for each source). I then create a formula to calculate that players projected points using that particular source and my selected leagues scoring.


On each position tab I then do a lookup in the projection tabs and return the result.


As you can see this gives me a quick and easy view of the players projected points using each of my sources and an average. I have also added a "Quality of Projection"(QOP) score. If the projections are fairly consistant for a particular player it will have a higher QOP score. If the projections vary wildly then the QoP will be lower.

This can be important in deciding how risky of a pick you are making. If all of the sources project about the same number of points it is a safer bet that the player will produce around those numbers. If the projections are very different there is more uncertainty on how that player will perform.

I personally tend to go with more of the safer bet, but you have to go with your gut sometimes.

Projections are at the root of just about all analysis I do... which is why they are so important. Are they always right? Absolutely not... but there has to be a starting point, and this is it.