Welcome to the tool that will help you win your fantasy football league in 2024 (or, if you're new here, hello!). A fully customizable cheat sheet generator that lets you input your league rules and settings — You can even change the stats and predictions — the end result is a set of rankings and predictions tailored to your personal fantasy football needs.
All I ask is that you read the instructions.
It's a very deep (and ultimately pretty awesome) tool with many interconnected parts, but once you've mastered it, it's surprisingly easy (and fun; you can predict Michael Pennis will play 17 games and throw for 4500 yards… if you're a little crazy). And if you get stuck, I'll help you out in the comments. Have fun… and good luck!!
To summarize:
To change any player stats or predictions, go to each team's page and scroll to the right on that page to make sure you haven't missed anything (the input fields continue down to column AH). Change only the yellow partand trust that the tools are always working in the background while you make your changes. We've also added a “Steps” tab to the sheet to keep everything in one place.
Here are a few more quick highlights:
do you have any questions? Leave your comment in the comments section, but please also take a quick scroll through previous comments or press Ctrl+F to see if your issue has already been addressed/answered.
Also: The scoring categories shown are the only ones I projected, so if there are additional categories like odd number bonuses or first downs, there is no way to take them into account.
Ranking: #Check the link
Instructions
1. Go to the individual team tab and make adjustments
This means that if you want to change Jahmyr Gibbs' fantasy points, you'll need to go to the Detroit Lions tab and adjust it there. You cannot enter new fantasy points totals in the rankings tabThat will create some problems in the future.
2. Scroll right to see the good stuff
There are a bunch of yellow cells on the right side of the Teams page, but you might have to scroll right to see them. Once you get there, the fun begins!
The way this sheet works, you can't change Travis Etienne's rushing yards or rushing attempts directly in the cells; everything is relative to one another in order for the sorting and rankings to work. Instead, if you want to change his rushing yards, you'll need to tweak some of the formulas that create “Rush Yards” (which should all be intuitive and make sense):
- Column V, “YD PER CARRY”—Adjust if you think Etienne’s YPC is better (or worse)
- Column X “TD PER CARRY” — Do you think he will score at a higher (or lower) rate?
- Column Z “YD PER RECP” — If you want to fine-tune his receiving ability
- Column AF “Edit Rush Share”—Increase backfield carries. Note: If you increase Etienne by 7%, you must decrease other players by 7%. Otherwise, you will lose “TOT SHR” (Total Share) exceeds 100% (shown in red for your convenience) and will no longer calculate correctly; more on this later.
- In the AG and AH columns, edit the Target Share and TD Share. This should make enough sense to move forward. Essentially, you change the numbers in the yellow cells and enter this to create/change your player projections.
3. Meet the “TOT SHR” in the column AF. He will be your biggest enemy if you don't get a few things right.
Look at the red “TOT SHR” box in the AF column (bottom right of the page). This number needs to be below 100 to not turn red. In the screenshot above, you can see that the W column does not adjust to the new number in AF. If you lower your AF below 100%, the W column will adjust accordingly and all will be well (see screenshot below). Essentially, your team's rush (or receptions, or whatever other stat you're manipulating) cannot go above 100%. That's all this does.
4. Adjust your pass-rush ratio
Lines 30 and 31 are pretty interesting. If you tweak these numbers, the position projections change accordingly. Notice that if you predict the Cardinals to pass 65% of the time, the rush percentage automatically drops to 35%. Therefore, the RB, WR, and QB drop accordingly.
5. Rank Tab
- POS Rank: Auto sort for new FPS changes
- OVR and VORP Ranks: Automatic sorting Players worth more than their replacementsfrom position (orange) whole All ranking types from (blue) to combined WR and TE (yellow)
- Project Rank: It will automatically sort according to new FPS changes, but also show a prediction for each player.
- Jake's rank: These are my rankings and may differ slightly from rankings based on projections (I might bet on a player who misses the first few weeks over a player who performs poorly per game). Auction values will be re-adjusted to match my rankings.
Default projection settings and notes
- Pass TD = 4pt
- All other TD = 6pt
- 25 yard pass = 1 point
- 10 yards rushing/receiving = 1 point
- Default sorting = Half PPR
- League/budget = 12 teams/$200
Updated May 29th
If you have any questions or concerns, please write them below and we'll be happy to help you.
(Top photo of Christian McCaffrey by Joe Camporial – USA TODAY Sports)
