I didn’t expect that I’d be publishing this post this year. As I alluded to in a post a little while ago, I have been in a health and life crisis lately and I did not see a scenario in which I could publish my fantasy baseball cheatsheets for 2022. Yet, here we are.
So, what happened, you may ask?
You all happened. The emails, the tweets, the direct messages, the Reddit posts, the comments, and so many kind words happened. You took a beaten-down Mr. Cheatsheet and lifted him up with your support. While my health and life issues remain, I found a renewed spirit to power through and publish an update of last year’s cheatsheets.
If you want to picture this all in your head, imagine Michael Jordan’s flu game. It’s kind of like that except obviously my cheatsheets are much more important than whatever Michael Jordan was playing for.
But, really, the point is that I do have cheatsheets for you all. They are the exact same version as last year’s cheatsheets but with updated data. There are no additional bells or whistles. There will be no troubleshooting of these sheets on my end unless people find egregious errors or something causing the cheatsheet to be unusable (I’m not discounting that possibility, due to my limited testing of these this year).
So, yes… maybe, just maybe you can win another fantasy baseball championship this year.
A Quick Favor
I’ve mentioned this in all of my posts this year, but I am a filmmaker in my daily life. I have a chance to get a good budget to make a neat short film about North Carolina and my experience of moving here. In order for me to get that budget, I need to a win public voting contest though. So, please take two seconds to vote for my film idea called The State That Heals on this site here: VisitNC Firsts That Last Film Festival. You can vote once every 24 hours too if you so choose.
Thanks!
What Makes These Cheatsheets Special?
I’ve played fantasy sports for nearly three decades and nothing compares to fantasy baseball as far as complexity and variety of league formats. There are rotisserie leagues and points-based leagues and auctions and drafts, and nearly every single league is set up in a unique way. There isn’t one “standard” fantasy baseball league. On top of that, there are keepers and dynasty leagues and draft pick trades and so many things.
These cheatsheets handle all of that.
You take a few minutes to put in your league settings and then you’ll see custom rankings and values for your league format. If you have keepers, you can take a few minutes to put those in and your draft is ready to go. These cheatsheets are special because they handle nearly any type of league you throw at it.
After you have the sheet set up, you can completely run your draft from within it and see estimations for how valuable each player is in your league type. It also will keep you updated on how each of the owners in your league is doing in their drafts so you know how to alter your strategy as you go.
The only caveat I’d say is that this requires manual work during the draft on your end. That’s not a problem in most leagues, but in leagues with short pick clocks, it’s hard to keep up. My advice is to not be in leagues where you get less than a minute or two to make a pick. That type of league shows a lack of love for fantasy baseball, decision-making, and the whole wonderful draft process. That’s my opinion at least!
What Can You Find In The Sheet?
You will see lots of data options within the sheet. For the average user, you can just keep the defaults and you’ll be fine. But, hey, most people reading this love to have all of the data that they can. Here are the various data sources that make these sheets what they are:
- Projections Sources: Steamer, The BAT, ZiPS, Clay Davenport, Mr. Cheatsheet’s Special Blend
- Average Draft Position Sources: FantasyPros, ESPN, CBS, Fantrax, NFBC
- Auction Values Sources: FantasyPros, CBS, ESPN, Yahoo, RotoChamp
- Expert Rankings Sources: FantasyPros, Yahoo, ESPN, RotoChamp
What are WERTH Values?
If you’re playing in a roto league, you may notice that these cheatsheets have a WERTH value for each player. These values essentially show you how far above or below average a player is in comparison to the replacement level for your league. A positive WERTH value in a category for a player means that they will perform better than the replacement level in that category for you. This is all dependent on your league settings but that is where the cheatsheets show their power by doing all of the calculations for you. For the data-minded folks, the WERTH values are combined z-scores for the chosen roto categories.
Download Your 2022 Cheatsheet
Hello to those of you who scrolled past the mumbo-jumbo to get right to the sheets! Don’t worry, I get it. I do that sort of thing too. So, let’s get on with it…
Roto Leagues
If you play in a rotisserie league or a H2H categories league, you’ll want to download one of the roto cheatsheets below. You can choose the draft version if you have a typical fantasy draft for your league, as opposed to an auction format. Punch the image below to download the draft sheet in that case. If this opens up in any web-based spreadsheet app, it will not work in that. You need to download this sheet and open it in Microsoft Excel.
Current version: 1.10
The current version was uploaded on April 2 at 7:25 PM EST
If your roto league conducts an auction instead of a straight draft, you can download the auction version below.
Current version: 1.10
The current version was uploaded on April 2 at 7:30 PM EST
Points Leagues
If you don’t play in a rotisserie league, you likely play in a points-based H2H league that scores a bit like fantasy football where players are awarded points for each stat they accrue based on your scoring system. If you are in a Points league, you likely will be downloading the Points Draft sheet below. If this opens up in any web-based spreadsheet app, it will not work in that. You need to download this sheet and open it in Microsoft Excel.
Current version: 1.10
The current version was uploaded on April 2 at 7:55 PM EST
However, you might be in an auction-based draft for your points league and, if so, this fourth option below is the sheet for you.
Current version: 1.10
The current version was uploaded on April 2 at 7:40 PM EST
Troubleshooting
The instructions within the cheatsheet should help answer most questions. If you are having errors in the sheet, there’s a button to push on the Instructions page of the sheet to ensure that data is updating.
An issue that I’ve encountered in my own testing on very rare occasions involves buttons disappearing in the sheets. If that happens to you, just save the sheet then close it and re-open it. I’ve found that resolves it.
Some caveats for this 2022 version, due to my current health issues:
- I will not be updating data in the sheets this year.
- I will not be adding any new features this year.
- I will not be adding missing players or data.
- Unless there is a major issue that is affecting everyone and causing a cheatsheet to be unusable, I will not be updating the cheatsheets at all after today.
- That being said, if you find a major issue that you think would affect everyone, still contact me or comment below.
Why Are These Free???
Because I love fantasy baseball, and I love doing this. Money would only complicate things. Some people are in free leagues. They should still have access to tools that help them win their league. I make these for you all; not to make a profit.
That being said… If you do feel so inclined and are in a position to do so, I do take donations through the methods below to compensate me for the work here. No pressure at all. You do what you feel comfortable with.
Donation Options
I can’t begin to thank you all for all of the support through a weird time for me this year. If I have not responded to your email or tweet or comment on the site, please know I have read them and just haven’t had the time yet. I’ve appreciated them all.
Before I close up shop for the season, if you hadn’t seen my message at the start of this article, make sure to vote for my film idea called The State That Heals in this contest here: VisitNC Firsts That Last Film Festival.
Thanks for everything, everyone. Have a great fantasy baseball season!
Erick
04/01/2022 at 10:54 AMOh man! Luke you’re awesome and I wish you all the best… get well brother.
Luke Gloeckner
04/02/2022 at 1:35 PMThank you!
Wah
04/01/2022 at 7:19 PMThank you again and godspeed…
Luke Gloeckner
04/02/2022 at 1:35 PMThank you! And thanks for all the support over the years, Wah.
derspete
04/02/2022 at 12:25 AMwell you got a proper gasp of elation from me. bless you and be well!
Luke Gloeckner
04/02/2022 at 1:35 PMHappy to hear it! Enjoy the sheets!
Josh
04/02/2022 at 1:29 PMShould the Roto Draft Sheet be v1.01? Only reason I ask is Mondesi is showing 25 and he is 26, Which makes me wonder if it is still point to 2021 data.
Thanks again get well!
Luke Gloeckner
04/02/2022 at 1:32 PMNo, v1.01 was just meant to fix an issue with those specific sheets. There very well may be ages that are off or other things that are off. This is not my finest work, for reasons I’ve noted on the site… it’s just a quick version of the cheatsheets to help people this year. I didn’t double-check the source where my age data came from. Just use the sheets as a guide, not as the absolute truth this year.
Vince
04/02/2022 at 4:43 PMOutstanding job and thank you. One issue that I noticed is that if your league has Shohei Ohtani as two separate players, then he comes up as a pitcher for Houston with no data and an ADP of 416. His DH data is fine. The issue is only w/ the pitcher version of Ohtani.
Luke Gloeckner
04/02/2022 at 7:57 PMI made a fix for this, please download version 1.10 of your sheet and it’ll work correctly.
Dana
04/03/2022 at 11:58 AMLuke, I’m a first time user and so far I’m beyond impressed. Great job! Especially when dealing with health issues, I truly hope you get better!! One issue I’m encountering is I’m trying to enter draft rounds for keepers in the Draft Log tab as instructed but, the tab is password protected. Is there somewhere to obtain the password or is it protected in error? Thank you so much!
Luke Gloeckner
04/03/2022 at 12:17 PMI’ll check it out when I get home later but, though the sheet is locked, you should still be able to edit the key fields on Draft Log page so that you can use the drop downs to select a team and player that belong in the various pick slots. If it is not letting you use the drop downs, let me know which specific sheet you’re having the issue with.
Dana
04/03/2022 at 1:19 PMI am on the draft log tab and I am trying to update the round that the players were drafted in that I have assigned as keepers. I assigned the keepers on the keepers tab and the instructions said I should be able to go to the draft log to update what round they are being retained in so it shows up on the Roto draft tab correctly. Unless I’m missing something it seems I should be able to add the round on the draft log page but it tells me it’s password-protected. Thanks Luke!
Luke Gloeckner
04/03/2022 at 1:27 PMYou don’t use the Keepers tab at all if you A are entering keepers into specific draft spots, in that case what you need to do is start with a blank draft log and manually enter in the keepers into the pick slots that they should be kept. I can explain in more detail later if you need
Dana
04/03/2022 at 4:52 PMI’m good now. Thanks Luke!
Zack
04/03/2022 at 1:52 PMThis is amazing! Coming from a big league – 600+ players get drafted…Looks like the Draft Log stops at 552. Is there any way to extend this? Thanks again!
Luke Gloeckner
04/03/2022 at 2:04 PMI’m not at home so can’t check for a bit. To save me time, is that Roto or Points?
Zack
04/04/2022 at 12:53 PMApologies for the delay – this was for Roto. Not a huge deal if it can’t be fixed. Sheet was protected to I couldn’t try myself.
Luke Gloeckner
04/04/2022 at 1:13 PMSorry, I forgot I had built a way to do that into the sheets. You need to increase the Bench size on the Settings page and it will add more draft rounds to the Draft Log page.
Zack
04/04/2022 at 9:02 PMSeems like no matter how many teams or bench spots I add, the Draft Log stops at 552 picks. Not to worry though, I can work around it. Not a big deal. Thanks for all you do!
Dave
04/03/2022 at 2:42 PMLuke, great job. Wishing you a quick and full recovery. Going to miss the ADP tier chart of yours in my draft. It really helps in a fast draft (which you think should be outlawed). All the best.
Mike D
04/03/2022 at 6:15 PMLiterally have posted on a well known fantasy message board that my usual “go to” isn’t happening this year (and was seeking something new to use) & then I saw THIS! WOOOO!
Thank you my friend – dealing with health issues is no fun….
Jim W
04/03/2022 at 7:50 PMWow, amazing! Was thrilled to see these up after resigning myself to fumbling through my drafts without them. You’ve made my day!! Best of luck dealing with your health issues.
Doug
04/04/2022 at 5:23 PMThanks Luke for the amazing work! I’m trying to update postions on players according to Yahoo (Mookie 2B for example) and when I right-click on the Player Notes tab it asks for a password to unprotect it.
Luke Gloeckner
04/04/2022 at 6:21 PMGo to the Settings page and change the Position Eligibility requirements to match your league and then Mookie will have 2B eligibility.
Doug
04/04/2022 at 7:12 PMThank you! Perfect!
Rob
04/04/2022 at 11:43 PMthanks Luke. I voted for your film, and I’ll send a donation. One thing I noticed is that in v1.10 Points Draft, the column Points Above Replacement doesn’t sort properly for OF
Tom
04/07/2022 at 2:28 PMHi Luke….This is amazing…….How do you change the position of a drafted player to another eligible position? It’s protected on the roster sheet from moving the player to another position. Wasn’t sure if I could assign him to another eligible position when drafting…….Thank you……..
Luke Gloeckner
04/07/2022 at 2:30 PMProbably the quickest way is to change the position eligibility requirements on the Settings page to match your league’s position requirements.
Tom
04/07/2022 at 2:43 PMI’m still a bit confused…..Austin Riley was drafted with a main position of 1B. He was also listed as eligible to OF/3B. I’m not sure how to now put him at 3B instead of 1B on the associated roster….
Luke Gloeckner
04/07/2022 at 2:45 PMSorry, I am not in a position this year to do troubleshooting of specific issues like that. It could be a bug.
Tom
04/07/2022 at 2:59 PMNo problem….Thanks for your time…
Jason C.
04/08/2022 at 11:16 AMAwesome job! Just curious… what is the password to make edits to protected sheets? I need to add players to the list. Thank you.