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:
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:
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:
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:
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.
Kurt Seiberling
03/10/2023 at 10:28 AMCan anyone download? When I click download nothing happens.
Luke
03/10/2023 at 10:40 AMSeems 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 AMI 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 AMThis method worked for me too!
Jason Regelski
03/10/2023 at 1:24 PMSame here
Luke
03/10/2023 at 3:18 PMShould be fixed if you refresh the site now.
Warren Shinnamon
03/10/2023 at 10:33 AMThank 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 AMSeems 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 PMShould be fixed if you refresh the site now.
Luke Magnaghi
03/18/2023 at 12:28 PMTysm this is so useful!!!
Ryan
03/10/2023 at 10:35 AMi 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 AMI 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 AMgood point, thanks
Anonymous
03/10/2023 at 10:36 AMYou can inspect the page and click link to download
Kurt Seiberling
03/10/2023 at 10:39 AMThanks for the workaround
John Lewis
03/10/2023 at 12:23 PMThank 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 PMAh 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 PMBest 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 PMI 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 PMIt 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 PMYou 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 PMI 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 PMThank 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 PMAs 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 PMHey 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 PMI 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 PMIt’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 PMCouple 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 PMThat should be *Roto Auction tab
Wah
03/10/2023 at 9:28 PMHey 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 AMThank for updated sheets, seems to be fixed with current version 1.06…thanks
sek
03/11/2023 at 9:33 AMHi 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 AMHello, 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 PMProjected 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 PMIt 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 PMYou’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 AMHey 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 PMIn 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 PMGood 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 AMI 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 PMHi 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 PMThe 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 PMThanks 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 PMHmm, 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 PMThanks, 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 PMI 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 PMRight, 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 AMHi, 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 AMGood catch, version 1.09 will ensure that those SS get their stats counted too.
scott
03/15/2023 at 2:16 PMHi, 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 PMHmm, 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 PMThanks….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 PMYeah, 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 PMNo 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 PMHey 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 PMAh 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 PMNo worries, appreciate you looking into it!
Luke
03/15/2023 at 6:29 PMOkay, 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 PMOh wow awesome, thanks for the quick response. Glad I could help!
Chris
03/15/2023 at 6:33 PMOn 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 PMI’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 PMDone
Mike Y
03/15/2023 at 9:06 PMHey 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 PMThis is in roto draft v1.07, btw.
Luke
03/15/2023 at 9:34 PMYeah, 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 AMok, great, thanks.
Emilio
03/16/2023 at 11:14 AMGreat stuff! Hoping the search for NARCO drops before Saturday (aka my draft day!).
Ben
03/18/2023 at 11:09 AMI’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 PMResolved this one over email with Ben.
Matt
03/20/2023 at 12:49 AMI’m in the same situation, what was the solution?
Luke
03/20/2023 at 12:56 AMNot 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 PMAlso 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 PMHi – 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 PMAlso, 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 AMJust noting that I’m also seeing this.
Luke
03/22/2023 at 10:24 AMCheck 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 PMThank 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 PMYou 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 AMThanks 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 AMThe 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 PMI 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 PMThat’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 AMIt 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 AMHandling this over e-mail as I can’t recreate the error.
Sam
03/20/2023 at 12:05 PMIs there a password to unprotect the sheets. I want to make some customizations for personal preference.
Luke
03/20/2023 at 12:10 PMYou 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 PMI’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 PMOn 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 PMThank 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 PMPerhaps 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 PMMy 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 PMHmm, 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 PMWill 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 AMThanks 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 PMI 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 PMI’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 PMThe 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 PMYup, too many rows. Thanks.
Matt Hilgenkamp
03/22/2023 at 10:18 AMOn 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 AMI 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 AMHmmmm. 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 AMSorry, I won’t have time to troubleshoot your observation but thanks for the feedback!
Matt Hilgenkamp
03/22/2023 at 10:35 AMNo worries, thanks for putting these together!
Matt Hilgenkamp
03/22/2023 at 10:48 AMI 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 AMIf 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 PMHi 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 PMYup, 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 PMHey 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 PMThat’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 AMWill 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 AMTry 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 PMSomething 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 PMIs 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 AMNo, not an issue, just bringing it up. Rot draft v 1.25
Mike
03/23/2023 at 10:49 PMMy 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 PMUnfortunately, 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 AMIs 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 PMI 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 PMIf 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 PMHey 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 PMI’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 PMYes, 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 PMAh 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 PMNo worries, thanks for everything!
Jason
03/24/2023 at 4:45 PMHey 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 PMHmm, 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 PMI’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 PMI 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 PMHi 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 PMNo 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 PMI 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 PMIs 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 PMIf 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 PMI 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 PMHmm, 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 PMAppreciate 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).