Step 8 — Tiers for Fears

<–Step 7        SECRET WEAPONS–>

Segmenting our cheat sheet by tiers helps us to make decisions quickly during the draft.  It simply lumps comparable players together.  This gives us an idea of how much fantasy point potential we lose by not drafting the last player available in their tier.

Figure 8-1 gives us a distribution of average fantasy points for RB’s.  The order of players will change each season.  Nonetheless, this shows where we can expect point drop-offs between tiers.

Drop-offs in fantasy point potential are usually quite obvious between the 1st and 2nd tiers.  Stud players (the top three or four RB’s) tend to drastically outclass everyone else.

 excel fantasy football spreadsheet nfl draft cheat sheet tier

Figure 8-1

Select the range of values in the Blend column.  They should already be Sorted from Smallest to Largest…

 excel fantasy football spreadsheet nfl draft cheat sheet tier

Figure 8-2

Learn more Excel for Fantasy Football, now available in paperback and e-book.  Order now, before the draft!

<–Step 7        SECRET WEAPONS–>

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