With the raw fantasy football stats converted into a PivotTable in Step 3, we can begin building our cheat sheet for the big draft.
First, create a new worksheet, by right-clicking any worksheet tab and selecting Insert. Select Worksheet in the Insert window, and click OK.
Double-click the tab of the new worksheet, and change its title to “RB Cheat Sheet.”
Now, we could Copy and Paste all of the RB’s from the RB FP Year worksheet. However, that’s over 200 RB’s to consider (and I’m not really interested in Xavier Omon’s performance on the field). Instead, I’ll Copy and Paste only the starting RB’s, using a depth chart from thehuddle.com.
Type the column header “Avg. FP/Yr.” into cell C1. Then, select cell C2, and click the Insert Function button (fx)…