Fantasy Football Cheat Sheet: 2022 customizable rankings and projections – Update 8/25 – The Athletic

Fantasy Football Cheat Sheet: 2022 customizable rankings and projections - Update 8/25 - The Athletic

What you’ll find below is exactly what it sounds like in the title: a fully customizable cheat sheet that lets you enter your league rules and settings — and even change stats and projections — and end up with a set of rankings and projections that are unique. to your personal fantasy football needs.

I just ask that you read the instructions.

This is a pretty deep (but ultimately very awesome) tool with many interconnected parts. But once you learn it, it’s remarkably easy (and fun — you can make Geno Smith run for 700 yards if you want). And if you stumble, I’ll be here in the comments to help. Enjoy…and good luck!!


If you want the condensed version, here it is: Go to the individual team pages to make any changes to player stats/projections, scroll right on those pages to make sure you’re not missing anything (the entry fields go up to column AH), change only items in yellow, and trust that the tool is always doing its work in the background while you make changes. I’ve added an instruction page in the sheet as well, to help keep everything in one place for you. But here is the longer version of the introduction:

Pre-Teaching Note: If you don’t have Excel, here is a link to Office 365which you can access for free (you may need to create an account).

Updates?: Yes! This fantasy football cheat sheet will be updated frequently with all major news and injuries. Every time there is a rankings update, we will update this tool as well). And please read everything, including the introduction, because if you ask something that’s already been answered, you might get Mutombo’d.

Updated August 25

ALSO: The only scoring categories I project are the ones included. So, apologies, but if you have bonuses or extra categories like first downs, there is no way to calculate those.

NOTE: I don’t project for missed time due to injuries, but I do for suspensions and currently have Alvin Kamara missing six games and Deshaun Watson eight games.


1. Go to the individual team tabs to make adjustments

In other words, if you want to change Jameis Winston’s fantasy points, you have to go to the New Orleans tab, and adjust him there. You can’t just enter new fantasy points in the Rankings tab. That’s going to screw up a few things down the line.

2. Keep scrolling right for the good stuff

A good amount of yellow cells are off to the right of the team pages, and you might not see them if you don’t scroll to the right. When you get there, you have fun.

The way this sheet works, you can’t change Devin Singletary’s rushing yards or rushing attempts directly in the cells – everything is linked to everything else for the sorting and ranking to work. Instead, if you want to change Singletary’s rushing yards, you’ll need to adjust a few things:

  1. COLUMN V “YD PER CARRY” – if you believe Singletary will have a better (or worse) YPC
  2. COLUMN X “TD PER CARRY” — if you think he’ll score at a higher (or lower) clip
  3. COLUMN Z “YD PER RECP” – if you want to adjust his receiving skill
  4. COLUMN AF “EDIT RUSH SHARE” — to give him more of the backfield. PLEASE NOTE: When you raise Singletary by 7%, you will have to lower some other people by 7%. Otherwise, you will cause “TOT SHR” (total share) to exceed 100% (I’ve made it red so you know) and things won’t compute correctly. More on this below.
  5. COLUMN AG and AH to edit target part and TD part. This should make enough sense at this point to move on, right? we basically change numbers in the yellow cells, and these then feed and create/change the player projections.

3. Meet “TOT SHR” in Column AF — he’ll be your worst enemy if you don’t get some things right

Look at the red “TOT SHR” box in column AF (bottom right of the page). You want that number to be under 100 and not red. In the screenshot above, you can see how column W has not adjusted to the new numbers in AF. Once we lower AF below 100%, column W adjusts accordingly, and all is well in the world (see screenshot below). Basically, you can’t have more than 100% of a team’s rushes (or receptions, or whatever stat you’re messing with). That’s what this does.

4. Adjusting pitch and speed %

Rows 30 and 31 are very funny. Changing those numbers will move the position projections accordingly. Just know that if you think the Cardinals will pass 65% of the time, that will automatically move the rushing percentage down to 35%. And your RBs (and Kyler Murray’s rushing yards) will drop accordingly.

5. Ranks Tabs

  • POS ranks: automatically sorts with any changes made for new FPS
  • OVR and VORP ranks: automatically sorts by Value Above Replacement Playerand goes from position (orange), to All in all (blue) to combined WR and TE (yellow) for all rank types
  • Ranks w Pros: automatically sorts with any changes made for new FPS, but also shows the projections for each player
  • Jake’s ranks: These are MY RANKINGS, which differ a bit from projection rankings (I might be willing to bet on a player who misses the first few weeks over a less per-game productive player). The auction values ​​readjust for my ranks

Default Projection Settings and Notes

  • Passing TD = 4pt
  • All Other TD = 6pt
  • 25 yards passing = 1pt
  • 10 yards rushing/receiving = 1pt
  • Default Sort = Half-PPR
  • League/Budget = 12 team/$200

Any questions or concerns, drop them below! I’m here to help!

(Photos by Andy Lyons/Getty Images — Julio Aguilar/Getty Images)

Leave a Reply

Your email address will not be published.