7 Responses

  1. zdm
    zdm at | | Reply

    i followed directions but it is shading the row above the intended row — any thoughts?

    1. Tanner
      Tanner at | | Reply

      I’d double check that your first player starts in Row 6, and if they don’t, adjust accordingly. Also make sure the “Applies To” range starts on the same row as your first player. For example, the rule I applied is =$AB6″” and the “Applies To” range starts on row six too ($A$6:$AE$735). Could you have one starting on row 5 and one on row 6?

  2. Chris
    Chris at | | Reply

    Hi Tanner,

    I took it a different way, and let me know if this is totally wrong. In drafts I notice that sometimes I need to draft somebody who is better at something specific. I.E. based on my keepers for this year I know I need to make up ground in HR and AVG. So for each of the 5 categories, I conditionally formatted each players SGP based on the 168 player pool. I colored players Red if they were 3 standard deviations above the average (very few of those across all categories) colored them orange if they were 2 standard deviations above, green for one and blue if they are above average. Now I can sort by colors to look at the remaining players that will help me in AVG, or quickly look and see that, yes sure enough Altuve is red in avg, he will really help me there, but he is below average in HR. Is this viable by using their SGPs per category or should I go straight to the counting stats? Thanks so much for all your work!

    1. Tanner Bell
      Tanner Bell at | | Reply

      Hi Chris,

      Thanks for reading the site and for sharing your ideas.

      I don’t think it matters much. Just be sure you understand what you’re looking at. If you follow the process I outline in my SGP book exactly, those SGP numbers can be considered SGP above replacement level. That could be a little deceiving if the replacement level players are “specialists” of some kind (e.g. speedy players or high power low average guys). If it’s raw SGP vs. raw counting stats, I don’t think it should matter.

      Thanks, Tanner

  3. Steve
    Steve at | | Reply

    Tanner, thanks for all the awesome tools. I’m in my infancy of using excel to build rankings, cheat sheet, etc. I think with more time next year I’ll get into building my own projections (where the real “fun” is). One question regarding conditional formatting. I had no problem creating a dark grade shade to block out drafted players once I selected a team from the drop down list on my “rankings page”. Any idea how can I apply the same conditional formatting to the cheat sheet I created to simultaneously shade out the same guys? Hope that makes sense.

Leave a Reply