2024 fantasy football cheat sheet: A fully customizable rankings and projections generator (2024)

Welcome back (or, nice to meet you, new arrivals!) to a tool to help win all your 2024 fantasy football leagues: a fully customizable cheat sheet generator that allows you to input your league rules and settings — and even change stats and projections — the end result being a set of rankings and projections unique to your personal fantasy football needs.

Advertisement

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 Michael Penix to start 17 games and throw for 4500 yards… if you are a bit crazy). And if you get tripped up, I’ll be here in the comments to help. Enjoy… and good luck!!

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:

QUESTIONS? I’ll be in the comment section, but please give a quick scroll-through 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)

  • My 2024 fantasy football positional rankings
  • Dynasty ranks (including rookie only)? They’re here

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. Keepscrollingright 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.

2024 fantasy football cheat sheet: A fully customizable rankings and projections generator (1)

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

2024 fantasy football cheat sheet: A fully customizable rankings and projections generator (2)

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.

2024 fantasy football cheat sheet: A fully customizable rankings and projections generator (3)

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, WRs and QBs will go down accordingly.

2024 fantasy football cheat sheet: A fully customizable rankings and projections generator (4)

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

Got it? Let’s go! Download the fully customizable 2024 projections and ranks sheet

Updated Aug 14

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

(Top photo of Christian McCaffrey: Joe Camporeale-USA TODAY Sports)

2024 fantasy football cheat sheet: A fully customizable rankings and projections generator (5)2024 fantasy football cheat sheet: A fully customizable rankings and projections generator (6)

Jake Ciely is rankings: Fantasy Football, Fantasy Baseball, candy, movies, video games, cereal... anything! Truly, Jake is a ranking prodigy. Oh, he's also the senior fantasy writer for The Athletic, an award-winning analyst and loves DuckTales. Make sure you #CheckTheLink and #BanKickers ... woo-oo! Follow Jake on Twitter @allinkid

2024 fantasy football cheat sheet: A fully customizable rankings and projections generator (2024)

FAQs

How to print fantasypros cheat sheet? ›

When you're editing or viewing your cheat sheet, you'll see a download icon and a print icon. Click on the corresponding option to perform your desired action.

What is the most accurate fantasy football projection? ›

Who are the best fantasy football predictors? The best fantasy football predictors are Draft Sharks. They've won multiple accuracy awards since 1999 – including the Multi-Year Projection Accuracy Award from Fantasy Pros. That's a competition that measures player prediction accuracy over 3 seasons.

What is the best customizable fantasy football site? ›

One of the best fantasy football sites for free players is Sleeper Fantasy Football. It has an easy setup and you can customize scoring and rosters. There are great advanced scoring methods and plenty of other fantasy sports features. It's one of the top league hosts for new players.

How to make a fantasy football tier list? ›

To create Tiers, simply click on “Edit Rankings” from the Cheat Sheet Creator. When you mouse over rankings, you'll see a link appear between rows called “create a tier” – simply click on this link to create a tier. You'll also be able to drag-and-drop the tier or delete it once it's created.

Is FantasyPros draft assistant free? ›

The Manual Draft Assistant and the Draft Assistant w/ Sync are included with our MVP, HOF, and GOAT subscriptions. Both Draft Assistants include our enhanced Draft Simulator, Cheat Sheet Creator, and Draft Analyzer. The MVP subscription starts as low as $5.99/mo.

What is statistically the best draft position in fantasy football? ›

In 12-Team Half-PPR, the best draft position is pick No. 1 or 2. Drafting optimally from the No. 1 or 2 spot in 12-team half-PPR drafts lands you on the same team through six rounds -- and a whopping 328.6 3D Value points.

Who should go #1 in fantasy football? ›

Round 1, Picks 1-12: Draft a wide receiver or Christian McCaffrey. Anyone with the top overall pick should take McCaffrey with little hesitation. He scored over 100 more PPR points than any other running back last season and has the perfect combination of talent, opportunity and situation.

What is the most efficient football prediction site? ›

EaglePredict is the best football prediction site in the world with over 89.9% accuracy rate in our football betting tips.

Who gives the best fantasy football advice? ›

Draft Sharks earned our ranking as the best fantasy football site for advice.

What is the number one fantasy football app? ›

For league hosting and drafting, we rate Sleeper as the top fantasy football app. They have all the features and customizable scoring you'll need — even in their app.

What is the best website for fantasy football data? ›

The Huddle provides the most complete resource of fantasy football statistics available anywhere.

What is the best number of teams for a fantasy football league? ›

Trades are more frequent because teams can build depth at certain positions, which allows them to trade starting quality players without giving up their most important players. No league size is perfect, but 12 teams is the standard most leagues try to achieve.

How do I dominate my fantasy football league? ›

Fantasy Football Draft Strategy 2024
  1. Load up on running backs.
  2. Know the league rules.
  3. Know the ADPs of players during the draft.
  4. Wait on Tight Ends.
  5. Anchor your team with an ace QB.
  6. Balance your roster.
  7. Always back yourself up with depth.
  8. Be picky and use the “CUDDY” System when drafting.
Aug 11, 2024

How do you draft a perfect fantasy football team? ›

The best fantasy football strategy boils down to drafting for value in every round of your draft. If you get guys who over-perform their ADP, you'll be a consistent winner. If not, you'll constantly be near the bottom of your league.

How to print paper in Hunter College? ›

Go to print.hunter.cuny.edu;
  1. Enter your NetiID username and password, Log In.
  2. Upload your document from your phone.
  3. Wait for your document to process.
  4. Select your document.
  5. Select Print Options: Black & White or Color. Select pages per side: 1 or 2. Select single sided or double sided. Number of copies.

How do I use FantasyPros extension? ›

How do I use the FantasyPros Browser Extension with my Yahoo live and mock drafts?
  1. Install one of the following browsers. Chrome. ...
  2. Allow third-party cookies. ...
  3. Install and activate the FantasyPros Chrome Extension. ...
  4. Access your Yahoo draft using your browser.
  5. Have the FantasyPros Browser Extension active during your draft.
Jun 2, 2023

How do I sync my FantasyPros with ESPN? ›

Install and activate the FantasyPros Chrome Extension. After installation, you should see the FantasyPros browser extension active in Chrome to the right of the address bar. Go to the league sync page, select ESPN, and click the Start League Sync button. At this point, you'll be redirected to ESPN.com.

Top Articles
Latest Posts
Recommended Articles
Article information

Author: Kimberely Baumbach CPA

Last Updated:

Views: 5678

Rating: 4 / 5 (41 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Kimberely Baumbach CPA

Birthday: 1996-01-14

Address: 8381 Boyce Course, Imeldachester, ND 74681

Phone: +3571286597580

Job: Product Banking Analyst

Hobby: Cosplaying, Inline skating, Amateur radio, Baton twirling, Mountaineering, Flying, Archery

Introduction: My name is Kimberely Baumbach CPA, I am a gorgeous, bright, charming, encouraging, zealous, lively, good person who loves writing and wants to share my knowledge and understanding with you.