The major changes to my fantasy baseball Excel spreadsheets each year usually occur prior to the first initial release. In some years, there are major tweaks and changes that continue to happen after that initial release in order to improve functionality and listen to some requests that have come in. This is one of those years.
The initial 2021 release of the cheatsheets was smooth with mostly minor bugs reported and I was happy to see that. I still wanted to smooth out the new features like multi-position eligibility and the Ohtani rule, among other things.
That brings us to today where I have an updated version of the sheets ready for release.
First, A Few Frequently Asked Questions
Q: Do these cheatsheets work on Google Sheets?
A: Sadly, no. These are designed to only work in Microsoft Excel because of the draft automation process that I built into them.
Q: Can I have the password for the cheatsheets?
A: No. It’s not that I’m being secretive about the contents of the sheet, but nearly everything you see is actually a formula referring to lots of other things and typing in the cells would break the entire sheet.
Q: Is there anything I can do to increase the speed of the cheatsheets?
A: Not that I’m aware of. I know they do run a bit slow. A lot of the work I do with these sheets is to make them compatible with as many versions of Excel as I can. That means that I often have to use slower formulas and that I hardly use any macro functionality at all, which would speed things up. I sacrifice speed for compatibility. If you have good hardware and the latest version of Excel then hopefully it should run without too much issue.
Q: Can you add The Latest Hot Prospect into the sheet? He’s not in there.
A: I likely will not be adding any additional players this year so your best bet is to choose Unlisted Player when a player gets drafted that isn’t in the sheet.
What’s New In These Versions?
Okay! So, I had implemented a long list of changes and tweaks this time around. The funny thing is that I often forget all of the changes that I’ve done because I’m just knocking out so many fixes and moving onto the next one. It only dawned on me mid-way through this process to start recording them all in a changelog. You can find the changelog here with most of the changes.
The more impactful changes are:
- You can now add a position to a player that is not being assigned to them at the moment. This is done on the Player’s Notes page and can help deal with the issue of a league giving position eligibility to a player for a position they didn’t really qualify for.
- The Positions page has been tweaked and now will respond dynamically to your league type. If your league uses directional outfielders then you will see them on that page now. If you are in an NL-Only league, you won’t see DH there anymore.
- You can now highlight players in certain colors. This is also done from the Player’s Notes page.
- Shohei Ohtani can now be split into two separate players on the Settings page under Ohtani Rule.
Those are the big changes but there have been tweaks to a lot of data calculation. For instance, auction values should calculate better than ever and many other things too. It’s a long list of tweaks that took me way longer to implement than I’d care to admit but the changes are in and this version should help you win your leagues in 2021.
How To Move Data From The Old Version
If you already entered data in version 1.00 of the cheatsheets, you’ll likely want to move that data into these sheets. It’s as simple as copying the data from the old Save & Load page and then pasting it into your new Save & Load page. It can still be a bit confusing though so here’s a short video that walks through it:
Warning About “Multiple Selections” Error
I believe this error is unique to Mac users but I’ve heard of users who get an error saying they “can’t do that to multiple selections” when trying to move data into the new sheet. Here’s a link to timestamp of that YouTube video where I specifically address that. The basic idea is that you can’t have all the columns selected on both open Excel workbooks so you need to de-select the old columns after you copy them.
Warning For Those Who Downloaded Early 1.50 Versions
I announced on Twitter the other night that you could download the 1.50 version here early but, alas, those users ended up being live beta testers. I heard about a few errors, including Player Notes being thrown off when loading 1.00 data into the sheets. I since made changes and now 1.00 data will move over seamlessly.
However, you should NOT do a Save & Load of other 1.5x versions into this 1.57 release if you have Player Notes data as it will be misaligned.
Other Info About The Sheets
In the introductory post for the cheatsheets this year, I walked through more info about the data included in these cheatsheets and their basic functionality. If this is your first time using the sheets, you may want to read over that post as well to learn more about what these sheets can do.
Download Your 2021 Cheatsheet
If you’re like me, you scrolled past all those wordy words and went right to the downloads. I get it. So, here we go…
If you play in a rotisserie league or an H2H categories league, you’ll want to download one of the roto cheatsheets below. You can choose the draft version if you have a typical fantasy draft for your league and that is found by clicking on the button below.
If your roto league conducts an auction instead of a straight draft, you can download the auction version below.
If you don’t play in a rotisserie league, you likely play in a points-based league that scores a bit like fantasy football where players are awarded points for each stat they accrue based on your scoring system. If you are in a Points league, you likely will be downloading the Points Draft sheet below.
However, you might be in an auction-based draft for your points league and, if so, this fourth option below is the sheet for you.
There’s no obligation to donate to me if you use these cheatsheets. They are completely free to use. That being said, working on these sheets and also providing support to users of the sheets basically becomes a full-time job for me this time of year. That’s why I do appreciate any tips you choose to give me whether they be big or small. Here are various ways you could do that if you so choose:
This should be the last major update of the cheatsheets for 2021! The only things that will likely get updated now are any major bugs I hear about and the data sources that are in the sheets.
Now, go on and dominate your fantasy baseball draft, my friend!