Introduction — It’s a Numbers Game

<–Epilogue           Step 1–>

Fantasy Football is about stats.

Okay… it’s also about drinking beer while watching and discussing football, and especially about trash-talking with friends and coworkers using terribly graphic metaphors of severe pain and humiliation that they will suffer from your ingenious lineup.  But, I digress.

In regards to the mechanics of fantasy football, weekly player stats are converted into fantasy points, which are then totaled.

Those point totals determine who won their match-up.

Wins and Losses are tallied.

Fantasy teams with the most Wins advance to the playoffs.

In the playoffs, there is room for only winners.  Losers get to watch.

However, let’s remember that statistical analysis is no substitute for qualitative judgment.  Statistical analysis simply organizes NFL stats into useful information.  With this information, we can apply our judgment to make sound decisions.  For example, which player do you draft? When do you draft him?  Whom do you start?

After all, we’re attempting to predict the future performance of 300 different players over a 17 week period.  Never mind that we still get caught in the rain without an umbrella.  In fantasy football, we don’t need to predict the future perfectly, just better than our opponents predict it.  Do you think they are using PivotTables, VLOOKUP functions and blended RANKings for their draft?  Probably not.  But you can, by following the steps in this book.

Team Managers use stats as weapons.  Let cheerleaders support the local team.  These steps will show you how to organize NFL stats.  (NFL stats are available for FREE at  With these steps, you will develop a strategic ranking of players for your draft.  After applying your own judgment to the rankings, you will have built a powerfully customized cheat sheet of you own.  Once completed, guard that cheat sheet with your life.  You worked hard on it.  Your opponents can make their own.

Although the following steps are applied to ranking RB’s, the same process can be applied to QB’s and WR’s.  I don’t bother using this extensive ranking process with TE’s, DEF’s or K’s; the return on effort is minimal.

Most importantly, if you’re new to PivotTables and the VLOOKUP function, you will gain marketable job skills by following these steps.  Yes, these skills are high in demand.  And yes, you can put these skills on your resume.

<–Epilogue           Step 1–>

fantasy football cheat sheet Excel spreadsheet pivottable vlookup rank tier raw data stats statisticsfantasy football cheat sheet Excel spreadsheet pivottable vlookup rank tier raw data stats statisticsExcel Fantasy Football Book iBook iBookstore iTunes iPad Cheat Sheet NFL


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s