ADVERTISEMENT

Fantasy Football 2022 Cheat Sheet: Customizable Rankings and Projections for Your League Setup

ADVERTISEMENT

What you’ll find below is exactly what it sounds like from the title: a fully customizable cheat sheet that lets you input your league’s rules and settings, and even change stats and projections, ending with a set of unique rankings and projections. to your personal fantasy football needs.

All I ask is that you read the instructions.

This is a pretty deep (but ultimately very amazing) tool with a lot of interconnected parts. But once you get the hang of it, it’s surprisingly easy (and fun; you can have Geno Smith run 700 yards if you want). And if you make a mistake, I’ll be here in the comments to help you. Enjoy… and good luck!!

ADVERTISEMENT


If you want the short version, it’s this: Go to individual team pages to make changes to player stats/projections, scroll right on those pages to make sure you’re not missing anything (input fields go all the way to column AH), it only changes things in yellowand have faith that the tool is always doing its work in the background as you make changes. I’ve also added an instruction page on the sheet to help keep everything in one place for you. But here is the longer version of the primer:

Advance directive note: If you don’t have Excel, here’s a link to Office 365, which you can access for free (you may need to create an account).

UPDATES?: Yes! This fantasy football cheat sheet will be updated frequently keeping in mind all the important news and injuries. Every time there is a ranking update, we will also update this tool.) And read everything, including the introduction, because if you asked something that’s already been answered, you might get Mutombo’d.

UPDATED June 27

WHAT’S MORE: The only scoring categories I project are the included ones. So, excuse me, but if you have bonuses or additional categories as first chances, there is no way to count them.

NOTE: I’m not drafting due to injuries, but I am due to suspensions and I currently have Alvin Kamara missing six games and Deshaun Watson eight.


1. Go to individual team tabs to make adjustments

In other words, if you want to change Jameis Winston’s fantasy points, you need to go to the New Orleans tab and modify it there. You can’t just enter a new fantasy point total in the Rankings tab. That will mess up some things later.

2. Keep scrolling right to see the good stuff

A good number of yellow cells are to the right of team pages, and you may not see them if you don’t scroll to the right. Once you get there, some fun awaits.

The way this sheet works, you can’t change Devin Singletary’s rushing yards or rushing attempts directly on the cells – it’s all connected to everything else for sorting and ranking to work. Instead, if you want to change Singletary’s rushing yards, you’ll have to tweak a few things:

  1. COLUMN V “YD PER CARRY”: If you think Singletary will have a better (or worse) YPC
  2. COLUMN X “TD PER CARRY”: If you think you will score a higher (or lower) clip
  3. COLUMN Z “YD BY RECEP”: if you want to modify your receiving skill
  4. AF COLUMN “EDIT RUSH SHARE”: To give you more backfield carries. PLEASE NOTE: When you increase Singletary by 7%, you will have to reduce other people by 7%. Otherwise, it will cause “TOT SHR” (full share) to exceed 100% (I put it in red so you know) and things won’t calculate correctly. More on this below.
  5. COLUMN AG and AH to edit target percentage and TD percentage. This should make enough sense at this point to move on, right? we’re basically changing numbers in the yellow cells, and these then feed into and create/alter the player’s projections.

3. Meet “TOT SHR” in the AF column – you’ll be your own worst enemy if you don’t set a few things right

See the red “TOT SHR” box in the AF column (bottom right of page). You want that number to be less than 100 and not red. In the screenshot above, you can see how column W did not adjust to the new numbers in AF. Once we drop the AF below 100%, the W column adjusts accordingly and all is well with the world (see screenshot below). Basically, you can’t have more than 100% of a team’s runs (or receptions, or whatever stat you’re playing with). That’s all you’re doing.

4. Pass and rush percentage adjustment

Rows 30 and 31 are so much fun. Adjusting those numbers will move the positional projections accordingly. Just know that if you think the Cardinals will pass 65% of the time, that will automatically lower the rush percentage to 35%. And your RBs (and Kyler Murray’s rushing yards) will decrease accordingly.

5. Range tabs

  • POS ranges: automatically ranks with any changes made for the new FPS
  • OVR and VORP ranges: automatically sort by Value over replacement playerand goes from positional (orange), to General (blue) to combined WR and TE (yellow) for all rating types
  • Ranges w Project: automatically ranks with any changes made for new FPS, but also shows projections for each player
  • Jake’s ranks: These are MY RATINGS, which differ a bit from projection-based ratings (you might be willing to bet a player will miss the first few weeks for a player with less production per game). Auction values ​​reset for my ranks

Default projection settings and notes

  • Passing TD = 4 points
  • All other TD = 6 points
  • 25 yards passing = 1 point
  • 10 yards rushing/receiving = 1 point
  • Default Rating = Half-PPR
  • League/Budget = 12 teams/$200

Any questions or concerns, leave it below! I’m here to help!

(Photo by Ian Johnson/Icon Sportswire via Getty Images)

sniloans