What?! The RB Cheat Sheet in Step 4 (Figure 5-1) shows Chris Johnson outranking LeSean McCoy?
Maybe “back in the day”, but surely not after last season (2011).
Figure 5-2 shows how Johnson is trending downward, while McCoy is trending upward:
So, we’ll take this into account by weighting last season more heavily.
Let’s get back to the RB Cheat Sheet. On the right of the column header “Avg. FP/Yr.”, enter another column header “2011 FP” for last season’s fantasy points. Below that cell, insert another VLOOKUP function, using the Insert Function button (fx)….