This post is specifically for anybody who has downloaded one of my fantasy baseball cheatsheets but found that it did not work as expected, or if the cheatsheet left you confused. I’ll walk through some solutions to the most common issues that I’ve heard about and some tips on how to best use the sheet.
There are a lot of features packed into the cheatsheets and some features go unnoticed despite them being super helpful, so I’ll make sure to highlight a few things to try out when playing around in these spreadsheets.
First Things First
Open the spreadsheet in Excel
As far as I know, you can only use this spreadsheet in a desktop version of Microsoft Excel on a Mac or a PC. There is custom code built into the spreadsheet that does not work in Google Sheets or Excel Online or any other spreadsheet software that may exist as of the time of this post.
Notice the pop-ups after you open the spreadsheet
Once you do open the sheet in Excel, there are a couple of hurdles to overcome. You may first get a pop-up that has an “Enable Editing” button that you need to press. That’s easy enough.
Then, you may get a second pop-up, as you see below, that says macros are disabled because you downloaded the file from the internet. Read more about this from Microsoft or just try one of the solutions below:
- Solution 1: Go to the file, right-click on it and choose Properties and then check Unblock at the bottom.
- Solution 2: For a long-term solution, search Internet Options on Windows, then choose the Security tab, then select Trusted Sites and add https://mrcheatsheet.com to the sites there. Uncheck the box at the bottom then save those settings. This will ensure all files downloaded from this site work in the future.
- Or, check out the replies to this tweet to see if anybody has other ideas.
Getting Your Sheet Set Up
The DH/UT spot
When customizing the sheet to fit your league, one setting that trips people up is the DH/UT spot within the starting lineups. That’s because Yahoo calls it a Utility spot and other sites call it a DH spot. But, the idea with the cheatsheet’s DH roster spot is that any hitter could occupy that spot regardless of position.
Finding your league’s stat categories
Another potential issue is that some people download the wrong sheet. If you open up the sheet but can’t find your league’s scoring categories on the Settings tab, you may be in a Points spreadsheet when you should be in a Roto spreadsheet. Try downloading the other style of cheatsheet and see if that resolves your issue.
Check out the ‘Player Notes’ tab
I have a feeling that the Player Notes tab is an underlooked feature of the sheets so I do encourage you to check it out. There are three things I want to point out about this tab:
- When you write a note for a player, that note will appear as a shortcut on the main draft page next to the player. On the main draft page, if you click on a player’s note then a pop-up will appear that will show the note that you wrote. This allows a quick way to give yourself more info about a player.
- You can use the highlight feature on the Player Notes tab to make it so certain players stand out more on your main draft page. If you choose a red highlight for a player then their row will be highlighted in red on the main page. This is a great way to draw attention to sleepers or players that you want to avoid.
- When a player is suddenly injured and out for the season prior to your draft, you can remove their data from the sheet by putting “Yes” in the Remove Player Data column on this page. The player will still be in the sheet but their stats will be removed so everything calculates more accurately.
How to handle keepers
There’s not one set way of dealing with keepers because every league is different. So, here are your options:
- If you’re in an auction, go to the Auction Log or your main draft tab and enter the keepers in as if they were auctioned-off players.
- If you’re in a draft and your keepers take the place of certain draft picks then enter the keepers on the Draft Log tab in the draft spot that they were kept.
- Most commonly, if you’re in a draft and keepers don’t affect the draft order then enter the keepers on the Keepers tab.
Traded draft picks
If you’re in a draft and the league allows draft picks to be traded, you can makes changes to the draft order on the Draft Log tab.
How to solve a player like Ohtani
As a baseball fan, I love Shohei Ohtani. As a cheatsheet creator, I feared Shohei Ohtani because I knew he was going to change the game of fantasy baseball when he arrived.
I tried out a lot of different solutions to address the idea that some teams may draft Ohtani and choose whether to start him as a hitter or a pitcher each time they set their lineup. Ultimately, I decided that the best way to handle it in the sheets would be to make it so you choose whether the team gets his hitting or pitching stats for those leagues.
I’m only commenting on the Ohtani options because I’m open to feedback on this in the future. If you feel the cheatsheet isn’t using Ohtani in the best way for your league, leave a comment below.
It’s Draft Time
Conducting your draft
Clicking on a player’s name on the main draft page will automatically move the player to the box at the top. Then, if you’re in a draft, you just need to click the Make Pick button for the draft to move to the next team in the draft order.
Oops, I messed up the picks
If you picked the wrong player to be drafted, the easiest solution is to go to the Draft Log and clear out that pick. When you go back to the main draft tab then you can put in the correct pick.
Don’t forget to check the projected standings frequently during the draft so you can alter your strategy if needed.
I also recommend looking at the standings and then going to the Settings page and changing the projections to something else and looking at the standings again. Sometimes, one set of projections can give you too biased of a look so it helps to see how you’re doing across a few projections.
If you end up reading through this and still have issues using the cheatsheet, drop a reply in the comments with your issue. I’ll try to keep this updated by adding in any other issues that do get brought up.