Introduction — It’s a Numbers Game

<–Epilogue           Step 1–>

Fantasy Football is about stats.  That’s it.

(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 and then totaled.

Those totals determine who won their match-up.

Wins and Losses are tallied.

Teams with the most Wins advance to the playoffs.

However, let’s remember that statistical analysis with Microsoft Excel is no substitute for qualitative judgment.  Such quantitative analysis simply organizes the massive amounts of data (NFL stats) into useful information.  With this information, we can apply our judgment to make sound decisions.  For example, Which player do we draft?  When do we draft him?  Whom do we start?

After all, we’re attempting to predict the future performance of 300 different players over a 17 week period.  Never mind that we get caught in the rain unprepared, and stuck behind traffic accidents.  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.

These steps will show you how to organize the mountain of NFL stats available (provided as a FREE download at excelfantasyfootball.wordpress.com).    Using these steps, you will turn that swirling sea of numbers into a detailed ranking of players for your draft.  After applying your own judgement 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.

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.  During an interview, should you volunteer that your Excel skills were gained from playing fantasy football?  Maybe.  Maybe not.  As a hiring manager myself, I would would have delighted in that fact.  As for other hiring managers, proceed at your own risk.

Lastly, I’ve been working feverishly fast to get this manual ready in time for this season.  As a result, I admit that minor errors remain, which I plan to correct by the next edition.  I sincerely appreciate your patience and understanding.  Moreover, I would appreciate your honest feedback.  Feel free to contact me at my blog (excelfantasyfootball.wordpress.com) or by emailing me at john@upgradient.com.  I look forward to hearing from you.

Good luck!  Have a good draft!  And, have a great season!

<–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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s