Projections Available

I have posted my projection spreadsheet on Google docs. I can't figure out how to get it to post with the formulas instead of values, so if one of you is smarter than me, please don't hesitate to clue me in.

Anyway, a quick key.


The first several columns are the actual projection info:

Column A - player name.
Column B - position
Column C - team
Column D - Completions
Column E - Passing attempts
Column F - Passing yards
Column G - Passing TDs
Column H - Interceptions
Column I - Passing yardage variance %
Column J - Passing TD variance %
Column K - Receptions
Column L - Receiving Yards
Column M - Receiving TDs
Column N - Receiving Yardage Variance %
Column O - Receiving TD Variance %
Column P - Rushes
Column Q - Rushing Yards
Column R - Rushing TDs
Column S - Fumbles
Column T - Rushing Yard Variance %
Column U - Rushing TD Variance %

The next group are the yardage adjustments for variance. If you disagree with how I use variance, these are some columns you could change to create your own customized ratings.

Column W - Adjusted passing yards (passing yards minus 1 passing yard variance)
Column X - Adjusted passing TDs (passing TDs minus 1 passing TD variance)
Column Y - Adjusted receiving yards (receiving yards minus 1 receiving yard variance)
Column Z - Adjusted receiving TDs (receiving TDs minus 1 receiving TD variance)
Column AA - Adjusted rushing yards (rushing yards minus 1 rushing yard variance)
Column AB - Adjusted rushing TDs (rushing TDs minus 1 rushing TD variance)

The next group are the points per categories. This section should be customized to reflect your league's rules.

Column AD - Points per pass completion
Column AE - Points per passing yard
Column AF - Points per passing TD
Column AG - Points per interception
Column AH - Points per reception
Column AI - Points per receiving yard
Column AJ - Points per receiving TD
Column AK - Points per rush
Column AL - Points per rushing yard
Column AM - Points per rushing TD
Column AN - Points per fumble


Column AP - Fantasy points. This is a formula with the points per category in the previous section times the projected or adjusted projected value for that particular category.

Column AQ - ADP. This is the average draft position, according to ESPN live drafts.