2022 Fantasy Baseball Cheatsheets | Roto or Points Drafts & Auctions

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.

Download the cheatsheet for your rotisserie standard draft league
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.

Download the cheatsheet for your rotisserie auction draft league
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.

Download the cheatsheet for your points-based league draft
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.

Download the cheatsheet for your points auction draft
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

You can tip me via Venmo!
Or PayPal!
I’m also trying out a new service where you can use whatever payment you want to buy me my next coffee.

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!

You Might Also Like

33 Comments

  • Reply
    Erick
    April 1, 2022 at 10:54 am

    Oh man! Luke you’re awesome and I wish you all the best… get well brother.

  • Reply
    Wah
    April 1, 2022 at 7:19 pm

    Thank you again and godspeed…

    • Reply
      Luke Gloeckner
      April 2, 2022 at 1:35 pm

      Thank you! And thanks for all the support over the years, Wah.

  • Reply
    derspete
    April 2, 2022 at 12:25 am

    well you got a proper gasp of elation from me. bless you and be well!

  • Reply
    Josh
    April 2, 2022 at 1:29 pm

    Should 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!

    • Reply
      Luke Gloeckner
      April 2, 2022 at 1:32 pm

      No, 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.

  • Reply
    Vince
    April 2, 2022 at 4:43 pm

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

    • Reply
      Luke Gloeckner
      April 2, 2022 at 7:57 pm

      I made a fix for this, please download version 1.10 of your sheet and it’ll work correctly.

  • Reply
    Dana
    April 3, 2022 at 11:58 am

    Luke, 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!

    • Reply
      Luke Gloeckner
      April 3, 2022 at 12:17 pm

      I’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.

  • Reply
    Dana
    April 3, 2022 at 1:19 pm

    I 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!

    • Reply
      Luke Gloeckner
      April 3, 2022 at 1:27 pm

      You 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

      • Reply
        Dana
        April 3, 2022 at 4:52 pm

        I’m good now. Thanks Luke!

  • Reply
    Zack
    April 3, 2022 at 1:52 pm

    This 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!

    • Reply
      Luke Gloeckner
      April 3, 2022 at 2:04 pm

      I’m not at home so can’t check for a bit. To save me time, is that Roto or Points?

      • Reply
        Zack
        April 4, 2022 at 12:53 pm

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

        • Reply
          Luke Gloeckner
          April 4, 2022 at 1:13 pm

          Sorry, 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
            April 4, 2022 at 9:02 pm

            Seems 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!

  • Reply
    Dave
    April 3, 2022 at 2:42 pm

    Luke, 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.

  • Reply
    Mike D
    April 3, 2022 at 6:15 pm

    Literally 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….

  • Reply
    Jim W
    April 3, 2022 at 7:50 pm

    Wow, 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.

  • Reply
    Doug
    April 4, 2022 at 5:23 pm

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

    • Reply
      Luke Gloeckner
      April 4, 2022 at 6:21 pm

      Go to the Settings page and change the Position Eligibility requirements to match your league and then Mookie will have 2B eligibility.

  • Reply
    Doug
    April 4, 2022 at 7:12 pm

    Thank you! Perfect!

  • Reply
    Rob
    April 4, 2022 at 11:43 pm

    thanks 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

  • Reply
    Tom
    April 7, 2022 at 2:28 pm

    Hi 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……..

    • Reply
      Luke Gloeckner
      April 7, 2022 at 2:30 pm

      Probably the quickest way is to change the position eligibility requirements on the Settings page to match your league’s position requirements.

  • Reply
    Tom
    April 7, 2022 at 2:43 pm

    I’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….

    • Reply
      Luke Gloeckner
      April 7, 2022 at 2:45 pm

      Sorry, I am not in a position this year to do troubleshooting of specific issues like that. It could be a bug.

  • Reply
    Tom
    April 7, 2022 at 2:59 pm

    No problem….Thanks for your time…

  • Reply
    Jason C.
    April 8, 2022 at 11:16 am

    Awesome job! Just curious… what is the password to make edits to protected sheets? I need to add players to the list. Thank you.

  • Leave a Reply