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

4 responses to “Step 8 — Tiers for Fears

  1. Good afternoon! What a well written guide to creating a cheat sheet! Unfortunately I use Mac’s Numbers so I was unable to follow along. Although I did go thru and read your steps all the way thru and I must say you did a great job!

    I really want to create my own sheet and you’ve given me some great ideas! Would you be willing to send me the Excel file completed? Numbers will convert it for use…

    I realize this is asking a lot but I got to throw it out there. Once again, very well written guide!

    Have a great day,
    Frank

    • Thanks so much, Frank! As my first commenter on my first blog, you’ve really made my day!

      I’ll gladly email what I have so far. You can also subscribe to the blog, and receive updates.

      I have also set up a Facebook page — Excel for Fantasy Football. If you Like it, you can get updates that way too.

      Thanks again, Frank. Enjoy your day, too.

      –John

  2. Hello. is there some instructions missing from some of the steps??

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