Fantasy football 2022 cheat sheet: Customizable rankings and projections — Tim Patrick Update

What you may discover under is precisely what it seems like within the title: a completely customizable cheat sheet that lets you enter your league guidelines and settings — and even change stats and projections — and find yourself with a set of rankings and projections distinctive to your private fantasy football wants.

All I ask is that you just learn the directions.

This is a reasonably deep (however in the end very superb) device with plenty of interconnected elements. But when you study it, it is strikingly straightforward (and enjoyable — you possibly can have Geno Smith run for 700 yards if you happen to so select). And if you happen to get tripped up, I’ll be right here within the feedback to assist. Enjoy… and good luck!!


If you need the condensed model, it is this: Go to the person workforce pages to make any modifications to participant stats/projections, scroll to the appropriate on these pages to be sure you aren’t lacking something (the entry fields go all the best way to column AH), solely change stuff in yellow, and have religion that the device is all the time doing its job within the background as you make modifications. I added an directions web page within the sheet, as properly, to assist hold every part in a single place for you. But this is the longer model of the primer:

Pre-Instruction Note: If you do not have Excel, here’s a hyperlink to Office 365, which you’ll be able to entry at no cost (it’s possible you’ll must create an account).

UPDATES?: Yes! This fantasy football cheat sheet might be up to date regularly accounting for all main information and accidents. Every time there is a rating replace, we’ll replace this device, as properly). And please learn every part, together with the intro, as a result of if you happen to requested one thing already answered, you may get Mutombo’d.

UPDATED August 4

ALSO: The solely scoring classes I venture are those included. So, apologies, however you probably have bonuses or additional classes like first downs, there is not a method to account for these.

NOTE: I do not venture for missed time as a consequence of accidents, however I do for suspensions and at present have Alvin Kamara lacking six and Deshaun Watson eight video games.


1. Go to the person workforce tabs to make tweaks

In different phrases, if you wish to change Jameis Winston’s fantasy factors, you need to go to the New Orleans tab, and tweak him there. You can’t simply enter a brand new fantasy factors complete on the Rankings tab. That’ll mess some issues up down the road.

2. Keep scrolling proper for the good things

A very good quantity of yellow cells are off to the appropriate of the workforce pages, and it’s possible you’ll not see them if you happen to do not scroll to the appropriate. Once you get there, you are in for some enjoyable.

The approach this sheet works, you possibly can’t change Devin Singletary’s dashing yards or dashing makes an attempt instantly within the cells — every part is related to every part else in an effort to make the sorting and rating work. Instead, if you wish to change Singletary’s dashing yards, you may need to tweak just a few issues:

  1. COLUMN V “YD PER CARRY” — if you happen to imagine Singletary can have a greater (or worse) YPC
  2. COLUMN X “TD PER CARRY” — if you happen to assume he’ll rating at the next (or decrease) clip
  3. COLUMN Z “YD PER RECP” — if you wish to tweak his receiving prowess
  4. COLUMN AF “EDIT RUSH SHARE” — to offer him extra of the backfield carries. PLEASE NOTE: When you deliver Singletary up by 7%, you are going to need to deliver another individuals down by 7%. Otherwise, you may trigger “TOT SHR” (complete share) to go over 100% (I made it flip crimson so you may know) and issues will not compute appropriately. More on this under.
  5. COLUMN AG and AH to edit goal share and TD share. This ought to make sufficient sense at this level to maneuver on, proper? we’re principally altering numbers within the yellow cells, and these then feed into and create/alter the participant projections.

3. Meet “TOT SHR” in Column AF — he might be your worst enemy if you happen to do not modify some issues correctly

Check out the crimson “TOT SHR” field in column AF (backside proper of the web page). You need that quantity to be beneath 100 and not crimson. In the screenshot above, you possibly can see how column W didn’t modify to the brand new numbers in AF. Once we deliver AF all the way down to beneath 100%, column W adjusts accordingly, and all is properly on the earth (see the screenshot under). Basically, you possibly can’t have greater than 100% of a workforce’s rushes (or receptions, or no matter stat you are messing with). That’s all that is doing.

4. Adjusting go and rush %

Rows 30 and 31 are a number of enjoyable. Tweaking these numbers will transfer the positional projections accordingly. Just know that if you happen to assume the Cardinals will go 65% of the time, that may routinely transfer the frenzy% all the way down to 35%. And your RBs (and Kyler Murray’s dashing yards) will go down accordingly.

5. Ranks Tabs

  • POS Ranks: auto-sorts with any modifications made for brand new FPS
  • OVR & VORP Ranks: auto-sorts by Value Over Replacement Playerand goes from positional (orange), to general (blue) to mixed WR and TE (yellow) for all rating varieties
  • Ranks w Proj: auto-sorts with any modifications made for brand new FPS, but additionally reveals the projections for every participant
  • Jake’s Ranks: These are MY RANKINGS, which differ considerably from projection-based ranks (I could be prepared to gamble on a participant lacking the primary few weeks over a much less per-game-production participant). The public sale values ​​re-adjust for my ranks

Default Projections 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-teams/$200

Any questions or issues, drop them under! I’m right here to assist!

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

Leave a Comment