2023 fantasy football cheat sheet generator: Customizable rankings and projections tool


Share post:

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

All I ask is that you read the instructions.

This is a very deep (and ultimately pretty amazing) tool with lots of interconnected parts. But once you learn it, it’s strikingly easy (and fun — you can project Trey Lance to start 17 games and run for 700 yards… if you so choose). And if you get tripped up, I’ll be here in the comments to help. Enjoy… and good luck!!

Read more: 2023 fantasy football draft kit: Rankings, cheat sheet, player projections, mock drafts and more

If you want the condensed version, it’s this: Go to the individual team pages to make any changes to player stats/projections, scroll to the right on those pages to make sure you aren’t missing anything (the entry fields go all the way to column AH), only change stuff in yellow, and have faith that the tool is always doing its job in the background as you make changes. I added an “instructions” tab in the sheet, as well, to help keep everything in one place.

A couple more quick hits:

UPDATES: This fantasy football cheat sheet will be updated frequently, accounting for all major news and injuries. You’ll have to come back and download new versions, so check back before you draft!

QUESTIONS? I’ll be in the comment section, but please give a quick scrollthrough of the previous comments or CTRL-F to see if your issue has already been addressed/answered.

ALSO: The scoring categories you see are the only ones I project. So if you have odd bonuses or extra categories like first downs, there isn’t a way to account for those.

RANKINGS: #CheckTheLink(s)

The instructions

1. Go to the individual team tabs to make tweaks

In other words, if you want to change Jahmyr Gibbs’ fantasy points, you have to go to the Detroit Lions tab, and tweak him there. You cannot input a new fantasy points total on the Rankings tab. That’ll mess some things up 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 may not see them if you don’t scroll to the right. Once you get there, you’re in for some fun.

The way this sheet works, you can’t change Travis Etienne’s rushing yards or rushing attempts directly in the cells — everything is connected to everything else in order to make the sorting and ranking work. Instead, if you want to change his rushing yards, you’ll have to tweak a few things in the formula that creates “rushing yards” (which is all intuitive and should make sense):

  1. COLUMN V “YD PER CARRY” — adjust if you believe Etienne 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 tweak his receiving prowess
  4. COLUMN AF “EDIT RUSH SHARE” — to give him more of the backfield carries. PLEASE NOTE: When you bring Etienne up by 7%, you’re going to have to bring some other people down by 7%. Otherwise, you’ll cause “TOT SHR” (total share) to go over 100% (I made it turn red so you’ll know) and things won’t compute correctly. More on this below.
  5. COLUMN AG and AH to edit target share and TD share. 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 projections.

3. Meet “TOT SHR” in Column AF — he will be your worst enemy if you don’t adjust some things properly


Check out 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 didn’t adjust to the new numbers in AF. Once we bring AF down to under 100%, column W adjusts accordingly, and all is well in the world (see the 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 all this is doing.


4. Adjusting pass and rush %

Rows 30 and 31 are a lot of fun. Tweaking 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 move the rush% down to 35%. So your RBs (and running QBs and Deebo Samuel types) will go down accordingly.

6 7 second

5. Ranks Tabs

  • POS Ranks: auto-sorts with any changes made for new FPS
  • OVR & VORP Ranks: auto-sorts by Value Over Replacement Player, and goes from positional (orange), to Overall (blue) to combined WR and TE (yellow) for all ranking types
  • Ranks w Proj: auto-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 some from projection-based ranks (I might be willing to gamble on a player missing the first few weeks over a less per-game-production player). The auction 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-team/$200

Updated August 16

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

(Top photo: Thearon W. Henderson/Getty Images; Joel Auerbach/Getty Images; Mitchell Leff/Getty Images)

Source link

Alexandra Williams
Alexandra Williams
Alexandra Williams is a writer and editor. Angeles. She writes about politics, art, and culture for LinkDaddy News.

Recent posts

Related articles

49ers mailbag: Who does Brock Purdy remind you of? Where does SF rank in QB pressures?

Wait a second: How good is Brock Purdy exactly?There appears to be a touch of hesitance among...

Angels GM Perry Minasian signals more changes possible after another losing season

Angels general manager Perry Minasian often doesn’t like to reveal too much about his or the team’s...

How can Penn State become more explosive? 13 takeaways from Mike Yurcich, Manny Diaz, more

STATE COLLEGE, Pa. — Penn State offensive coordinator Mike Yurcich knows that much of what has fans...

Manchester United 2-3 Galatasaray: Defensive woes continue despite Hojlund’s goals

Manchester United lost a second successive game in the Champions League this season to leave them bottom...

What’s the best way to deal with Nick Saban’s fiery coaching? Alabama football players explain

TUSCALOOSA, Ala. — As Terrion Arnold jogged off the field, he saw a look that was all...

Iowa QB Cade McNamara out for season with ACL injury: What does it mean for Hawkeyes?

IOWA CITY, Iowa — Quarterback Cade McNamara will miss the rest of the season with an ACL...

NWSL seeking new media rights deal: What the league should expect

The NWSL is at a crossroads. The league’s three-year media rights deal with CBS wraps up at...

Why it’s past time for the Bears to move on from Chase Claypool

Less than a year after trading a second-round pick for him, the Chicago Bears have told Chase...