2023 Fantasy Baseball Cheatsheets for Drafts and Auctions

There are only so many ways that I can introduce my annual fantasy baseball cheatsheets. Trust me, I know because I’ve written such introductions for nearly fifteen years on this site. As far as the internet goes, this site is considered ancient but it’s still hanging around here in the year 2023, much like Rich Hill.

This year, I am going to keep the preamble short though. I feel that most people who have landed on this page know what they are getting into.

That being said… for the people who landed here without any past experience with my work, this post is announcing the release of my 2023 fantasy baseball cheatsheets.

These sheets are professional spreadsheets made for Microsoft Excel (desktop). There are four cheatsheets. They’re first broken into whether you’re conducting a standard fantasy draft or holding a fantasy baseball auction. From there, there are two sheets to choose from depending on whether you are in a roto league or a points-based league.

The main reason these cheatsheets are great is that they generate custom player values based on whatever unique settings your league may have. You’ll enter your league information, and you’ll choose what data you’d like to use, and then you’ll have a list of unique values for every single player you may draft. You can then conduct your draft from the spreadsheet itself because it’ll track the projected standings for your league as you go. That’s handy because then you can make adjustments to your draft strategy as needed, especially in rotisserie leagues.

That’s the idea! I think the spreadsheets are pretty great and I hope you’ll think so too. So, let’s get on with it.

Warning: These Are For Microsoft Excel On Your Computer
I’m just pointing this out to say that these spreadsheets do not work in any other program other than Microsoft Excel at the moment. They also do not work on the web or mobile version of Excel. You need to use these on your laptop or computer in Microsoft Excel itself.

Fantasy Baseball Draft Cheatsheets

There are four types of cheatsheets that you can download here so let’s figure out which cheatsheet is for you first.

The first question to answer is about your draft type.

Your league is either conducting a standard fantasy draft or they’re having an auction. A standard draft contains multiple draft rounds and you make a pick each round. An auction would be where each player is put up for bidding and you can use fictional dollars to get the players you want. These first two cheatsheets are for the standard drafts. If you’re in an auction, skip past these.

The second question you need to answer is about what type of scoring your league uses.

The two common formats are either roto or points-based. A roto league is where you are ranked from first to last in various statistical categories, either each week or for the whole year. A points league is more like fantasy football where you get X number of points for each thing a player does and you try to get more points than your fantasy opponent.

So, if you’re in a roto league that’s conducting a fantasy draft then here is the spreadsheet that you want to download:

Download the Excel file
Current version: 1.25
March 25 at 2:00 PM EST

If you didn’t download that file but you’re still here then that likely means that you’re in a points league. The points league is where you get individual points for each statistic and try to get the most points each week.

If that’s your league type and your league is holding a standard draft then download this spreadsheet to win your league:

Download the Excel file
Current version: 1.25
March 25 at 2:00 PM EST

Perfect! If you’re in a fantasy baseball draft then you should be good to go now. You can skip to the end if you want to read any final thoughts. Now, for the rest of you…

Fantasy Baseball Auction Cheatsheets

If your league is not conducting a standard multi-round draft and you are bidding on players to put onto your team then, yes, you need a different spreadsheet than what I have above. You need my auction spreadsheets.

You just need to ask yourself which type of league you’re in before you download one of these two sheets.

To quote myself from just a minute ago, “the two common formats are either roto or points-based. A roto league is where you are ranked from first to last in various statistical categories, either each week or for the whole year. A points league is more like fantasy football where you get X number of points for each thing a player does and you try to get more points than your fantasy opponent.”

If you’re in a roto league that is holding an auction-style draft then here is the spreadsheet that you want to download:

Download the Excel file
Current version: 1.25
March 25 at 2:00 PM EST

That leaves one final cheatsheet. The points league is closer to fantasy football as each player’s stat is assigned a specific point value and you try to get the most points each week. If that’s your league and it’s holding an auction-style draft then download this spreadsheet:

Download the Excel file
Current version: 1.25
March 25 at 2:00 PM EST

There you have it! Now you can win your fantasy leagues.

Need Help Using These?

You may open these up and find yourself asking a lot of questions. First, I’d check out this FAQ-style post to see if your issue is mentioned in the post. Secondly, I’d search the site to see if the issue has been mentioned before. Thirdly, I’d ask the question in the comments below here and I’ll get back to ya. One of those methods should get you to a solution but I’d start by checking out that post I linked to first.

Found A Bug?

Yeah, that’s definitely going to happen. I’m just one person making these and there are four different spreadsheets to maintain so there may be human error at times. If your cheatsheet is acting strange and you think there’s a bug, contact me or post in the comments below so I can fix it.

Cheatsheet Updates

There will be at least one or two updates to the cheatsheets before the season starts. When a new version comes out, you can copy your league’s data to the new sheet by using the Save & Load tab.


Donations

One icky matter to discuss here is the fact that these gigantic spreadsheets are all free to use. That’s a personal choice that I made a long, long time ago and it’s a choice that I still stand behind. I’m not trying to get rich here; I’m trying to make you all richer though by helping you win your fantasy leagues. It’s a cool feeling without needing to attach dollar values to it.

But, this isn’t free for me to make. This requires a ton of manhours that I don’t get paid for and it requires paying for web hosting and domains and all that fun stuff. As a result, it would mean a lot to me if you would consider donating to the site and the cause itself so that I can keep doing this each year.

If you are in a position to do so, you can submit donations through Venmo or PayPal, or you can buy me coffees.

No pressure at all. You do what you feel comfortable with.

A Personal Note

Before I wrap up this post, I did want to address some things I talked about last year on this site. I noted some personal health/life issues that had popped up at that time. In all honesty, there’s a bit of a vulnerability hangover after talking about all of that publicly as I generally like to keep my life fairly private. Last year was a bit of a nightmare though and some of that personal stuff came up on here as a result.

While things continue to be challenging, this is a fantasy baseball site and we want to win fantasy baseball leagues and that’s what I’m keeping the focus on here. I appreciate all of the kind words from everyone very much though, and I thank you for caring about my health and well-being.

Good Luck!

Hey, you’ve got an awesome spreadsheet that has all the data you’ll ever need for your fantasy baseball draft. Now it’s up to you to go out there and win your league. Just keep in mind that there’s always a matter of luck involved in this game. There will be unexpected injuries and weird things throughout the season that could ruin a great draft. So, I say this sincerely before we go:

Good luck, and have fun.

You Might Also Like

  • Kurt Seiberling
    03/10/2023 at 10:28 AM

    Can anyone download? When I click download nothing happens.

    • Luke
      03/10/2023 at 10:40 AM

      Seems to be a browser issue based on the comments. I’ll look into ways to override that later. I’m not able to recreate it on my end so it’ll take me a little time to figure out.

      • Steven Nawara
        03/10/2023 at 11:00 AM

        I was able to get it by using Microsoft Edge. The file was renamed as “unconfirmed download” and I then changed the file extension manually back to .xlsm and it opened fine.

        • Jonny D
          03/10/2023 at 11:50 AM

          This method worked for me too!

    • Jason Regelski
      03/10/2023 at 1:24 PM

      Same here

    • Luke
      03/10/2023 at 3:18 PM

      Should be fixed if you refresh the site now.

  • Warren Shinnamon
    03/10/2023 at 10:33 AM

    Thank you for everything you do, Luke! So glad this is happening.

    I’m also having the same issue. Clicking the download button is doing nothing for me.

    • Luke
      03/10/2023 at 10:41 AM

      Seems to be a browser issue based on the comments. I’ll look into ways to override that later. I’m not able to recreate it on my end so it’ll take me a little time to figure out.

    • Luke
      03/10/2023 at 3:18 PM

      Should be fixed if you refresh the site now.

    • Luke Magnaghi
      03/18/2023 at 12:28 PM

      Tysm this is so useful!!!

  • Ryan
    03/10/2023 at 10:35 AM

    i breifly read this as im at work, but which type of spreadsheet would be best for head to head?

    • Harrison
      03/10/2023 at 10:37 AM

      I typically use the Roto. Ultimately in H2H we’re trying to accumulate as many stats in the categories.

      • ryan
        03/10/2023 at 11:15 AM

        good point, thanks

  • Anonymous
    03/10/2023 at 10:36 AM

    You can inspect the page and click link to download

    • Kurt Seiberling
      03/10/2023 at 10:39 AM

      Thanks for the workaround

  • John Lewis
    03/10/2023 at 12:23 PM

    Thank you so much for putting this out Mr CheatSheet! You are truly the best.

    In my “Your Points Draft” tab, and then also when selecting keepers, some player are not populating. such as Vladdy Jr, Yordan Alverez. Could be an issue on my end

    • Luke
      03/10/2023 at 12:32 PM

      Ah yes, that makes sense. I know what is happening there and I will put a fix in later today. I’ll tweet when fixes are loaded but you can refresh this page later today or tomorrow and look for a version that is later than version 1.00.

      • Benjamin Boyd
        03/10/2023 at 4:38 PM

        Best time of year when Mr. Cheatsheet posts his spreadsheets! I’m attempting to import my own projections and am running into similar sorting issues as John above on the Draft tab. I assume it’s supposed to recalculate Werth based upon the new projections? Thanks!

        • Luke
          03/10/2023 at 5:17 PM

          I ended up loading a new version that’s version 1.01 to fix John’s issue. Do you know if it is happening on that version?

          • Benjamin boyd
            03/10/2023 at 6:24 PM

            It happened in the updated version, yes. In other words, the draft tab was displaying the players in the same order as they were imported on the projections page.

  • Kings Ginger
    03/10/2023 at 12:31 PM

    You da man, Mr. Cheetsheet!

    Issue- On the draft tab, when sorting by anything other than ADP, it appears a good percentage of players get dropped out of sorting and are sorted alphabetically.

    For example, if sorting by Points Above Replacement, Will Smith drops to the bottom of the list.

    • Luke
      03/10/2023 at 12:33 PM

      I will put a fix in later. I’ll tweet when fixes are loaded but you can refresh this page later today or tomorrow and look for a version that is later than version 1.00.

  • Loyal MrCheatSheet User
    03/10/2023 at 12:52 PM

    Thank you SO much for these. This is easily the best fantasy resource for baseball. I do have a few questions:

    1) I notice that Yahoo isn’t included on the “Site Auction Values” on the Settings page. Was that on purpose?
    2) Can you explain the “Don’t change team names after draft starts” statement a little more? If I enter team names as they stand today and put in keepers for those teams (either on Your Roto Auction tab or Auction Log), doesn’t that technically mean the draft already started? So in that case I shouldn’t change any team names after doing that?

    • Luke
      03/10/2023 at 1:03 PM

      As for the Yahoo values, good catch. The site that I used to get Yahoo’s auction values was taken down by Yahoo and I could not find any other resource for it. So, I made the decision to drop them and add in NFBC and Razzball values in Yahoo’s place. If you find a site that has Yahoo’s values still, let me know.

      As for changing team names after the draft starts, I’m pretty sure it could cause some reference issues once you start drafting because the sheet will lock in the picks under a certain team name. So, if you change it, it doesn’t change their past picks to reflect that. As a result, it might cause issues if you change a team name midway through the draft. I’m just saying this off the top of my head though; I put in that note years ago so I’d have to double-check the functionality.

  • Austin Bristow
    03/10/2023 at 2:12 PM

    Hey Luke,
    Thanks so much for putting out THE BEST draft sheet in the industry yet again! I think I may have found a glitch. When I sort by projected points all players Tucker Davidson (alphabetically by first name) do not sort. Instead they stay at the bottom of the sheet still alphabetically.

  • Tom Vaclavek
    03/10/2023 at 3:19 PM

    I love your predictions and cheat sheets. Thanks so much! Some of your rankings are so different than others and really stand out. Not a huge fan of Bobby Witt Jr. eh?

    • Luke
      03/10/2023 at 3:22 PM

      It’s all data-driven projections and data that already exists elsewhere, depending on what settings you choose. I don’t have any of my own personal rankings in there but I’ll do my own rankings before the season starts.

  • Jesse
    03/10/2023 at 4:05 PM

    Couple of player omissions on Your Roth Auction tab for the Auction Cheatsheet (so far);
    Reid Detmers SP | LAA
    Luis Garcia SP | HOU

    Also – Values aren’t showing up for OF or RP on the positions tab.

    FWIW my settings are for 9 team AL only 28 man roster standard roto cats.

  • Jesse
    03/10/2023 at 4:06 PM

    That should be *Roto Auction tab

  • Wah
    03/10/2023 at 9:28 PM

    Hey Luke,
    problem with my sheet. I entered all relevant info such as settings and draft team. I also inputted in the Draft Log the different Team in different rounds (we trade picks in my league) as well as the Player Picked for the specific round. Sheet Saved and closed. Now everytime I opened the sheet, it just crashes once i click on any field. Sheet closes and I open it again, trying to move to a different tab such as Your Toto Draft, i click on Show Drafted Players and it’ll crash. This is the same if I try to make changes or do sort of selection. Thank you for help

    • Wah S Chan
      03/13/2023 at 9:41 AM

      Thank for updated sheets, seems to be fixed with current version 1.06…thanks

  • sek
    03/11/2023 at 9:33 AM

    Hi Luke…glad to hear you’re doing well. A minor request. How can I unlock the sheet to change the font and/or increase the font size? I like to print a couple of the sheets to have nearby (especially the Positions sheet) but cannot alter the Ariel 9 font so it prints larger. Thanks.

  • BJ
    03/11/2023 at 10:09 AM

    Hello, thank you for this great work! Can you define these for me?

    Projected value, vs inflated value, vs inflated site value

    • Luke
      03/11/2023 at 4:10 PM

      Projected value is the dollar value based on projections. Site value is based on the site that you chose on the Settings page. Inflated value is the value that changes throughout the draft based on who is left and how much money is left.

  • Matt
    03/11/2023 at 4:06 PM

    It looks like you are missing some key stats for scoring system in the Settings tab. Can you add OPS, AVG, WHIP, K/9 or is there a way for me to manually add these in?

    • Luke
      03/11/2023 at 4:09 PM

      You’re using the wrong type of sheet for your league then. Download the roto sheet. Those stats can’t be used in Points leagues so you might have mixed yourself up.

  • Warren Shinnamon
    03/12/2023 at 12:17 AM

    Hey Luke! Funky issue in version 1.06. When I go to Your Roto Auction and filter to only show RP players, I’m seeing a bunch of other players from other positions.

    • Warren Shinnamon
      03/12/2023 at 1:12 PM

      In fact, sorting by any position on that sheet is giving bizarre results. Bringing in lots of players from other positions.

      • Luke
        03/12/2023 at 1:46 PM

        Good find. It seems like it was only affecting the Roto Auction cheatsheet. I just loaded version 1.07 to the site here for that sheet and it should fix that issue.

  • O
    03/13/2023 at 3:50 AM

    I never know what I like more – the cheatsheets or your design sensibility.

    Glad you’re back! Hoping things are better in your life, we’re cheering you on from the sidelines from Bangkok.

  • Frank
    03/13/2023 at 3:49 PM

    Hi Luke:

    On the “settings” tab, I set SS to 0, 2B to 0, and MI to 3, as that is how my league is structured. When I do this though, after I go to “positions” tab, I notice it removes 2B and SS. Is there a quick fix for this? I could just add a value of 2 for both SS and 2B, but I’m not sure if that will impact any calculated values.

    • Luke
      03/13/2023 at 4:19 PM

      The positions tab is just a display tab, and if you’re not required to start a player at a certain position then the positon doesn’t show on that page based on the current design but I hadn’t included MI/CI columns because it got kinda messy in my attempts to include them in the past. Changing your league settings to have that page display differently would affect the calculated values though, yeah. So, while I can look into changing the functionality of that page for that specific situation so that it adds an MI column if there are 0’s in SS & 2B, I can’t guarantee that it would be something I’m able to implement in a quick manner. Sorry, I’ll see what I can do when I’m able to work on updates again though. It probably can be in a future update this season but not sure when.

  • Ben
    03/13/2023 at 5:15 PM

    Thanks for the great resource! I have a question about using the Roto Auction sheet in a league where we have 5 minor leaguers that can be kept for free. It seems $0 bids aren’t accepted in the spreadsheet. What I’ve done is to increase the number of Reserves by the number of minor leaguers, and I’ve increased team’s draft budget from $260 to $265, while inputting minor leaguers as $1 each.
    1) Do you think that’s the best way to go about setting up the sheet or will this have some effect on calculation of inflation?
    2) Is there a way I can force these minor league players to the Reserve positions in the Rosters tab? Otherwise during the auction, it will be a little tough to keep track of positional needs by team.

    • Luke
      03/13/2023 at 5:36 PM

      Hmm, that’s tricky. An idea you could try is to put the keepers in as being won at $0.01 (or even .00001 if you want). It’ll make it like they’re basically free at least so the values are represented correctly.

      As for not wanting to count minor league players towards teams… maybe the best solution would be put them in as the “Unlisted Players” that are at the bottom of the sheet because those won’t count towards any position requirements. Just an idea because I don’t currently have a “don’t count this player” type of option for drafted players.

      • Ben
        03/13/2023 at 10:56 PM

        Thanks, I hadn’t even thought to use cents but that will work.

        How do I put players names in as unlisted players? The ones at the bottom of the Your Roto Auction tab aren’t editable since it’s a locked sheet, but I’d like to give that a shot, at least for those minor leaguers who are likely to remain in the minors.

        • Mike Heffner
          03/19/2023 at 10:46 PM

          I was wondering this as well, since I was trying to log the auction for pitcher Will Smith (TEX) – who’s not on the sheet – he just has to be “Unlisted Player 1” and I have to remember who that is offline? While I can assign “Unlisted Player 1” to that owner for x dollars, the Your Roto Auction line entry doesn’t change to reflect the drafting – and there’s no way to add pitcher Will Smith to the cheatsheet, correct?

          • Luke
            03/19/2023 at 11:04 PM

            Right, he’s not in there as he wasn’t on a roster when I made those sheets. When I do an update to the sheets, I may add him in but no promises as I’ve got a busy week outside of this site so not sure when I’ll get to any updates. The unlisted player entry keeps the budgets intact though, yes.

  • Osmodius
    03/15/2023 at 2:20 AM

    Hi, I have noticed that some of my players stats that i can see projections for in the team section in v 1.08 (couldnt see them at all in v 1.00). They are all in my starting lineup. But they don’t register/calculate into my stats in the Projected Standings(in either version). Brice Turang, Jeremy Pena, Luis Urias, Nico Hoerner. All 4, their stats aren’t being added into the projected standing stats.

    • Luke
      03/15/2023 at 9:25 AM

      Good catch, version 1.09 will ensure that those SS get their stats counted too.

  • scott
    03/15/2023 at 2:16 PM

    Hi, Luke. Thanks for these…great stuff!! Was wondering if AB’s can be added to the Roto categories for hitters, in order to see them on the Your Roto Auction tab?

    • Luke
      03/15/2023 at 2:28 PM

      Hmm, I hadn’t thought of altering the display of that page to include a stat like that… There’s a domino effect from changes like that in the spreadsheet so I’d have to play with it to see if I could do it without causing an issue, but I’ll add it as a note for a possible future update one day.

      • Scott
        03/15/2023 at 2:51 PM

        Thanks….I appreciate it. I guess a workaround could be to use your upcoming projections, match the player names from the Auction tab, then sort to include AB’s (I assume they will be on your projections).

        • Luke
          03/15/2023 at 3:11 PM

          Yeah, sure, something like that could work.

          On the cheatsheet side of things, those columns on that Your Roto Auction tab have gigantic hidden formulas as they are responsive to the choices on the Settings page. Adding in new columns would affect the current formulas and how they’re working, so I’d have to think about how to re-format and re-program all of those formulas. It’s a house-of-cards situation as one small change in a very complex spreadsheet creates issues, which is often why people point out bugs that I didn’t catch. So, yeah, I’ll look into it when I’m doing my next round of updates but it’ll just take some time so I can’t give promises. I see the value in your suggestion though.

          • Scott
            03/15/2023 at 4:10 PM

            No worries. Not a big deal…especially considering it could disrupt a lot of other (more important) stuff. Thanks for the back and forth.

  • Andrew
    03/15/2023 at 5:02 PM

    Hey Luke, I’m running into an issue with my draft order getting messed up after I enter future picks for keepers. After I go through and assign all the keepers to their respective rounds in the Draft Log sheet, once I start the draft from pick 1, it starts changing the draft order in the later rounds every time I click “Make Pick” from the Your Points Draft sheet. I have found that just entering the all picks from the Draft Log sheet works fine, but sometimes it can be a bit tedious to scroll through the list to find certain players. FYI I’m using the Points Draft 1.07 and I’m able to reproduce the issue by choosing one player in a later round from the Draft Log sheet and then making a pick from the Your Points Sheet. Thanks!

    • Luke
      03/15/2023 at 5:32 PM

      Ah crap, okay. That Draft Log sheet is a major headache behind-the-scenes from a coding standpoint, so I’m not surprised something broke on it this year during the updates. That sheet is a tough one for me to troubleshoot because of its complexity so it’ll take me a little bit to figure out, but I’m going to look into it tonight. Thanks for the info.

      • Andrew
        03/15/2023 at 6:33 PM

        No worries, appreciate you looking into it!

    • Luke
      03/15/2023 at 6:29 PM

      Okay, awesome, I was able to get it figured out. I’m glad you brought this one up. Version 1.10 of the Points Draft sheet is on the site and will resolve the issue.

      • Andrew
        03/15/2023 at 6:34 PM

        Oh wow awesome, thanks for the quick response. Glad I could help!

  • Chris
    03/15/2023 at 6:33 PM

    On Roto 1.06…I input keepers and traded picks via the Draft Log. Vinnie P. never showed up on either the Rosters or Teams tab. Once enough players got taken (and filled most starting positions), Shohei stopped showing up on either tab as well. I’m sure it’s more players, but these are two on my team that I noticed immediately.

    • Luke
      03/15/2023 at 6:47 PM

      I’m not able to recreate that error when I add him in via the Draft Log myself so there must be other things going on in your sheet that are causing the issue. Email me a copy of your sheet. Send it to lgloeckner at gmail dot com.

      • Chris
        03/15/2023 at 7:43 PM

        Done

  • Mike Y
    03/15/2023 at 9:06 PM

    Hey Luke, first time user here so maybe I’m doing something wrong. I’ve downloaded the sheet twice for use in two different leagues had this issue both times. When I input the roster size settings for the league on the ‘settings’ page then go to the ‘draft log’ page and scroll to the end, it shows 2 more rounds of the draft than there should be. Same thing happens if I zero out all of the positions to show a roster of zero…it will show 2 rounds of draft on the draft log page. Seems whatever calculates the total number of rounds based on roster composition is adding 2 to the total.

    • Mike Y
      03/15/2023 at 9:08 PM

      This is in roto draft v1.07, btw.

    • Luke
      03/15/2023 at 9:34 PM

      Yeah, I built it to have two extra draft rounds in case you’re in a league with unique situations like certain keeper rules, draft pick trades or weird IL rules. Because of a variety of reasons, I’ve just had a few drafts of mine that don’t go the exact amount of rounds that you’d think. So, while it doesn’t affect everyone’s draft, I just have it show two extra rounds as a buffer even though most drafts won’t need them. You’re just being observant and noticing it but it doesn’t end up actually affecting anything within the sheet. It’s just a display thing.

      • Mike Y
        03/16/2023 at 6:53 AM

        ok, great, thanks.

  • Emilio
    03/16/2023 at 11:14 AM

    Great stuff! Hoping the search for NARCO drops before Saturday (aka my draft day!).

  • Ben
    03/18/2023 at 11:09 AM

    I’m in a league using Saves+Holds and was going to import my projections, but Holds isn’t a stat category. Do I need to add saves and holds manually, and then put that into the saves column?

    • Luke
      03/18/2023 at 2:38 PM

      Resolved this one over email with Ben.

      • Matt
        03/20/2023 at 12:49 AM

        I’m in the same situation, what was the solution?

        • Luke
          03/20/2023 at 12:56 AM

          Not every projection system has holds projected, so holds are individually calculated in the sheet outside of the projections. Each year, I take the systems that do project holds and find the percentage of games that are expected to be a hold for a pitcher and that’s how Holds are calculated once you import your projections.

          • Joe
            03/21/2023 at 8:25 PM

            Also in the same situation, and just making sure I follow – so if I’m adding projections, I’m not adding projections that say, “Player X will get # holds.” I’m adding projections that say, “Player X will appear in # games” and then your sheet extrapolates how many of those will be a hold. Is that how it works?

            My league actually uses Net Saves+Holds. If I were to drop my projected NSVHs on the import tab under S, then set my category as Saves, would that work? The downside being that if I change Projections to Use, now I’m not capturing any Holds data.

  • Steve
    03/18/2023 at 2:16 PM

    Hi – how can I permanently change players’ main positions? For example, I don’t want to see Spencer Strider, Zach Eflin, Garrett Whitlock as RP. My leagues do not have SP/RP slot distinctions. I changed the Games as RP to qualify way up and these pitchers are still shown as RP in the Positions sheet.

  • Steve
    03/18/2023 at 2:19 PM

    Also, your total auction dollars seem too high. For my 14-team league with $260 per, total auction dollars should be $3,640, but I think your total dollars was $4,000. I will likely overwrite with my own values, but curious why this is.

    • Matt Hilgenkamp
      03/22/2023 at 10:23 AM

      Just noting that I’m also seeing this.

      • Luke
        03/22/2023 at 10:24 AM

        Check the settings on the Settings page. I explained this in a recent tweet and some messages within the comments, I believe. You are seeking the Experimental setting instead of the Standard setting for the way it calculates available money since you are more concerned about having it precisely match the remaining dollars.

  • Matthew Shaffer
    03/19/2023 at 6:03 PM

    Thank you so much for the sheets. I might have missed this somewhere but is it possible to edit specific projections? For example, if Jacob DeGrom is projected for 192 strikeouts, but looking at Baseball Prospectus, they have him projected for 172, is there a way to change that within the sheet. Again, really really appreciate the work you put in here and have enjoyed your sheets for years it feels like.

    • Luke
      03/19/2023 at 6:08 PM

      You can choose a different projection system on the Settings page. You can cycle through the projections at any point during your draft and find one that works best for you. If you prefer to use a projection system that’s not already in the sheet then go to the Import Projections page and use that format for bringing in a different source.

      • Matthew Shaffer
        03/20/2023 at 1:06 AM

        Thanks I meant more if there was a specific part of the projections I wanted to change, not all of them. So my earlier example, if I felt the projection was too high for his strikeouts, is there a way just to change that specific projection without having to import all of my own?

        • Matt Hilgenkamp
          03/22/2023 at 10:14 AM

          The best way to do this would be to export his Special Blend projections from his other post, paste them into the “Import (Projections)” tab, select Import Your Own Projections on the Settings tab, and adjust the projections on the Import (Projections) tab as you please.

  • BB
    03/19/2023 at 6:40 PM

    I have Ohtani as one player, but the auction value still has him as only $41 for 843 pts. Soto is at $65.

    • Luke
      03/19/2023 at 7:03 PM

      That’s so weird. I know I had worked on that specific issue before these were published but my workaround wasn’t in that sheet. Sorry about that. I uploaded v1.07 of the Points Auction sheet and it should work in there.

  • Loyal MrCheatSheet User
    03/20/2023 at 11:39 AM

    It appears that in the Roto Auction 1.10a sheet, the Ohtani hitter isn’t showing any stat projections. I currently have “Make him two separate players” selected on the Settings tab.

    • Luke
      03/20/2023 at 11:55 AM

      Handling this over e-mail as I can’t recreate the error.

  • Sam
    03/20/2023 at 12:05 PM

    Is there a password to unprotect the sheets. I want to make some customizations for personal preference.

    • Luke
      03/20/2023 at 12:10 PM

      You can’t alter the pages themselves as it is all formula-driven so the sheet can and will break when those are changed. You can add your own extra tabs to have additional info in there if you want to add more stuff, I think.

      • Sam
        03/20/2023 at 12:16 PM

        I’m not trying to alter the formulas or anything you created. I just want to highlight some rows on the your points draft sheet. Possibly add some type some notes in the far right white column space as well. Is this possible?

        • Luke
          03/20/2023 at 12:18 PM

          On the Player Notes page, you can choose what color you want to highlight a player’s row with and you can add notes there that would be available on the main draft page. The part about Player Notes here talks about it if you have trouble: https://mrcheatsheet.com/2023/03/13/cheatsheets-faq/

          • Sam
            03/20/2023 at 12:31 PM

            Thank you. I like the highlight feature. 2 other questions. I’m trying to add another column to show the difference between ADP and PAR rank to show where the biggest “steals” might be. Is this possible for me to do? Also, is it possible to mark if a player is drafted right on the “Your points draft” sheet. I have 60 seconds between picks and would like to minimize flipping between different sheets (this was the main reason, I’d like to be able to highlight and edit that page directly). Thanks again.

          • Luke
            03/20/2023 at 12:35 PM

            Perhaps use the “Hide Drafted Players” option at the top of the page so players automatically get hidden when drafted.

  • Dylan
    03/20/2023 at 2:24 PM

    My auction league uses 50 cent increments for bids. Noticed under the projected standings tab the max bids are all off by a few dollars.

    • Luke
      03/20/2023 at 2:51 PM

      Hmm, that seems weird and I can’t match the error in my brief testing. I’ll send you an email so I can look at your sheet and you can tell me more info if needed.

  • Brent Troop
    03/20/2023 at 4:25 PM

    Will there be any additional updates to the Projections in the spreadsheet? The last update was on March 9th and there have been some major injuries since then. If not, no worries and thank you for building this incredible tool!

  • Jon C
    03/21/2023 at 11:00 AM

    Thanks for this amazing work. However, I am noticing that the “draft log” and “teams” tab are adding 2-3 more rounds/players than indicated on the roster size in settings. For example, I put 5 bench spots in settings, but the teams tab shows 8 with the draft log having an additional two rounds. Thanks.

    • Luke
      03/21/2023 at 5:19 PM

      I guess I gotta change how that displays because you’re not the first person to bring that up this year. I add two extra draft rounds at the end to account for leagues that use a lot of IL spots or have draft pick trading that leads to more rounds. It’s just a buffer. The amount of draft spots displayed will have no effect on anything.

  • Jason Regelski
    03/21/2023 at 6:50 PM

    I’m trying to import my own auction values in the “Import (Values)”, but it is giving me the error stating that the sheet is projected. I’m trying to paste my projections in cell B2. Any advice?

    • Luke
      03/21/2023 at 6:54 PM

      The cells in columns B and C should allow you to paste in them. The only thing I can think is that maybe you are trying to paste something with more columns than that. Or, maybe it’s too many rows. I’m not sure without looking at the sheet but I’d try to make sure it’s only 2 columns or try it with fewer rows of data and see if that works.

      • Jason Regelski
        03/21/2023 at 7:12 PM

        Yup, too many rows. Thanks.

  • Matt Hilgenkamp
    03/22/2023 at 10:18 AM

    On the 1.10a Roto Auction sheet, I’m seeing some strange value calculations. Nothing looks off on individual players, but if I pull the $ values for all guys with a Pos Adjusted WERTH value of 0.0 and above, I end up with $3,709 of value. But I have my league settings set up with 13 teams and a budget of $260 per team, so I should only be seeing $3,380 of value spread across the players above replacement level. Am I thinking about things wrong? Or is there a potential bug in the calculations?

    • Luke
      03/22/2023 at 10:20 AM

      I forget how the setting is labled but there’s a setting on the Settings page where you can switch inflation calculation types. It sounds like you are seeking the Experimental setting there as that is designed to not have any wiggle room with the remaining money. “Experimental” tries to have total player dollars 100% match your league’s available money. “Standard” has more flexible player values so it may not match the league’s remaining money but the values may look better. Use whichever one gives you the values that look best to you. Everybody’s auction is different, you know your league best.

      • Matt Hilgenkamp
        03/22/2023 at 10:29 AM

        Hmmmm. I tried switching that and all it did was break Ohtani, who was properly set at $50, but is now ~$33. Everyone else’s dollars stayed the same. At what level are the calculations being rounded to the integer values we see in the $Value columns? Wondering if it’s an Office-Space situation where the fractional dollars being rounded up are adding more $’s on the aggregate? I’d love to be able to extend the $ values into the decimals to get more specific values.

        • Luke
          03/22/2023 at 10:30 AM

          Sorry, I won’t have time to troubleshoot your observation but thanks for the feedback!

          • Matt Hilgenkamp
            03/22/2023 at 10:35 AM

            No worries, thanks for putting these together!

          • Matt Hilgenkamp
            03/22/2023 at 10:48 AM

            I actually think I might have identified the issue. If I update my Minimum Bid to $0.00, I get almost exactly the $3,380 I’m looking for across all players with a value of $1 or greater. So it might be that you aren’t removing the $1 minimum bid from the available “above replacement level” value. This is how I have it handled in my personal Python value generator:

            dollars_per_rating = (((260-total_roster_slots) * num_teams) / (batter_ratings[“pos_Rating”].sum() + pitcher_ratings[“pos_Rating”].sum()))

            .assign(Value = lambda df: (df.pos_Rating * dollars_per_rating) + 1)

          • Luke
            03/22/2023 at 10:52 AM

            If you download the latest version of the auction sheets, I believe the Experimental values are working in there so it may better match your use case. The standard auction values are working as intended on my end but, based on over 10 years of emails from people in auction drafts, I certainly know everybody’s league and needs are different! Since you are concerned about whether the values exactly match, the Experimental feature is what you need. It wasn’t working in some earlier versions of the sheet but should work in the latest versions. I won’t have time this year to do troubleshooting to address this level of feedback though, my apologies!

  • Jason
    03/22/2023 at 12:22 PM

    Hi Luke,

    You do such fantastic work! Wondering if there will be an update coming for the ’23 ROTO Draft Sheet? Just wanted to check before I start configuring. Thanks much!

    • Luke
      03/22/2023 at 12:23 PM

      Yup, hoping to have a data update at some point today so all of the ADP data and projections are as current as they can be.

  • TImothy Peichel
    03/22/2023 at 12:39 PM

    Hey Luke,
    In Roto Draft sheet 1.10a, Bard is not getting a Special Blend price and is not showing up with a Projected Value

    • Luke
      03/22/2023 at 12:45 PM

      That’s correct. He does not have a Special Blend projection because one of the projection systems used in the Special Blend did not have a projection for him.

  • Mike Y
    03/23/2023 at 7:00 AM

    Will Smith (RP) is behaving oddly in v1.20 of the Roto Draft sheet. He jumps to the top of the list in the “Your Roto Draft” tab if I sort by expert ranks, even though he’s got an expert rank of 362, if I sort by WERTH, even though he’s got a total WERTH of -6.5, and if I sort by Pos Adj WERTH, even though his PAW is -3.1.

    • Luke
      03/23/2023 at 8:06 AM

      Try downloading v1.21. I think that should fix what you’re talking about. Somebody pointed out something similar with about Will Smith being displayed weirdly when Ohtani was split into two players and then I applied some fixes last night in that version. So that may do it.

      • Mike Y
        03/25/2023 at 11:16 PM

        Something similar to the Will Smith issue is happening in v1.25. Luis Garcia (RP) has an ADP of 0 so he jumps to the top of the list when sorting by ADP.

        • Luke
          03/25/2023 at 11:25 PM

          Is it something that makes the cheatsheet unusable? I’m not home at the moment so don’t know how much your issue breaks the sheet. What sheet is this in?

          • Mike Y
            03/26/2023 at 9:30 AM

            No, not an issue, just bringing it up. Rot draft v 1.25

  • Mike
    03/23/2023 at 10:49 PM

    My first time back in roto league in quite a while. Your cheatsheets are amazing and quite a find. My question is is there a way to combine offensive categories to be counted as 1 category? My league has 1 offensive category that is total bases + walks + HBP and although separate categories in offensive drop down in Roto Auction Cheatsheet, I don’t see a way to combine as 1 category. Thanks for your help.

    • Luke
      03/23/2023 at 10:56 PM

      Unfortunately, there is no way to create custom categories like you’re describing in the current version of the cheatsheet.

  • Steve
    03/24/2023 at 12:28 AM

    Is there a way to find a player within the sheet? (AKA: I want to find a player using ctrl + f in a sheet to quickly see where they are ranked but it seems like the excel rankings won’t let me do that) Thanks!

    • Luke
      03/24/2023 at 12:32 PM

      I don’t know which sheet you are using or which tab you are doing a search on. But, there is a “Search for Player” button at the top of the Your Roto Draft page.

    • Joe
      03/24/2023 at 7:27 PM

      If you’re looking in the Positions sheet, you can also make sure that A) “Look in” is set to Values, and B) “Match entire cell contents” is unchecked. Not sure if it’s my machine or the spreadsheet, but the default for those seems to be Formulas and checked.

  • Warren Shinnamon
    03/24/2023 at 12:15 PM

    Hey Luke! Just noticed something funky in the Roto Auction spreadsheet. We treat Shohei Ohtani as two different players, a DH and an SP. His DH listing displays no projections for his batting stats. Do I maybe have it set up wrong?

    • Luke
      03/24/2023 at 12:31 PM

      I’m not able to replicate that on my end. Are you using the 1.20 version of the Roto Auction sheet? Where are you not seeing a projection for his batting stats? What tab?

      • Warren Shinnamon
        03/24/2023 at 12:50 PM

        Yes, it’s the 1.20 version. Weird. When I download it from your site, everything looks fine and his hitter stats show up. But when I paste in my data from a previous spreadsheet, his projected stats disappear from the Your Roto Auction tab, along with his WERTH and everything.

        • Luke
          03/24/2023 at 12:53 PM

          Ah weird. Guess it must be something with Save & Load from a certain past sheet. I’m swamped over the upcoming days so likely won’t be able to look into it why that happened precisely… so hopefully, it’s not a huge deal to manually re-enter your info in the updated sheet.

          • Warren Shinnamon
            03/24/2023 at 12:56 PM

            No worries, thanks for everything!

  • Jason
    03/24/2023 at 4:45 PM

    Hey Luke. For some reason my Positions tab stopped filtering by value. Every adjustment I’ve made hasn’t fixed it. Tips?

    • Luke
      03/24/2023 at 5:17 PM

      Hmm, I’m not sure what “stopped filtering by value” means. Could you explain in a little bit more detail and say which sheet you are using?

  • Jason
    03/24/2023 at 5:38 PM

    I’m using an auction roto sheet. In the “Positions” tab it shows value, Werth and player name. This would normally be filtered high-to-low by value, but I’m finding players scattered all throughout the sheet. I’ve tried to resort in every tab to try to reset this, but can’t get it to change (and I obviously can’t drop in a filter).

    Thanks.

    • Luke
      03/24/2023 at 5:53 PM

      I can’t recreate the error. I’ll send you an email in a moment so that you can send me a copy of your sheet and I can maybe see what setting is causing that.

  • Joe
    03/24/2023 at 8:05 PM

    Hi Luke,

    I’m using the Roto Draft 1.21. Our league has Shohei as two separate players, and the sheet is set up accordingly. Both versions of him are being kept by the same team, but on the Rosters tab, only the DH version is appearing.

    I tried using the Keepers tab and also tried drafting them manually, and got the same result.

    Not a HUGE deal, but any thoughts on how to get Shohei the SP to appear on that team’s roster?

    Thanks!

    • Luke
      03/24/2023 at 8:27 PM

      No solution off the top of my head. Just a scenario I never accounted for but should have thought of. I will add it to my list of updates though it’s not something I plan on fixing at the moment. Thanks for bringing it to my attention.

      • Joe
        03/27/2023 at 1:33 PM

        I just tried again with 1.25 and it’s working. Might have been user error – I think I might have been using imported projections, but failed to include the (SP) in his name under Pitcher Name on that tab. All good now.

  • Matt
    03/29/2023 at 7:24 PM

    Is it possible to unlock the position tab at all? My league uses a single assigned position for each player, so I’d like to set that and remove the multi-position eligibility, but the position cells are locked and a password is needed to unlock the sheet.

    • Luke
      03/29/2023 at 7:27 PM

      If you go to the Settings tab and change the position eligibility rules by increasing the minimum number of games played for players then you should be able to get that page to look as you’re describing.

  • Matt
    03/30/2023 at 6:44 PM

    I updated the settings for multi-position eligibility to 50 and it eliminated most of the multiple positions, but I’m still not able to set specific positions. Tatis is a SS and OF (due to me adding OF) whereas in my league he is only eligible at OF. Is there a way to set this?

    • Luke
      03/30/2023 at 7:16 PM

      Hmm, I’m not sure I have any way for you to do that much positional manipulation within what I built. What you’re asking for more makes sense but that’s the first time I had a request like that so it’s not something I’ve taken the time to try to tackle yet. Sorry about that.

      • Matt
        03/30/2023 at 8:19 PM

        Appreciate the response, I think I can work through it since the system doesn’t appear to be calculating a by-position replacement level which would throw things off (I moved Mike Trout to catcher and he was 5.5 there and still 5.5 at OF).