2018 Fantasy Baseball Cheatsheets for Excel (Roto and Points Leagues) | Version 1.50

The initial release of my spreadsheets came out a few weeks ago but things have changed since then in the baseball world. Times were simpler in early March. We still didn’t know where Lance Lynn would play and we all were probably a few pounds lighter and happier. But, hey, things have changed now. For instance, Jake Arrieta is Philadelphia Phillie, Madison Bumgarner has an injured hand and everybody stopped eating Tide Pods. With drafts happening this weekend, you all need a new spreadsheet with the latest info so let’s do it.

This post is where I’m dropping my latest spreadsheet joint. It’s basically a data update so you have the latest average draft position (ADP), projections, auction values and rankings data. This will ensure you don’t look like a fool this draft weekend. I mean, you still could look like a fool by wearing your shirt backwards or something but that’s not the fault of these spreadsheets. This spreadsheet also has some new notes about injuries and sleepers added in just because I want to help you. So, check it out and make sure your shirt is on the right way this weekend.

Let’s give a recap for the newcomers about what these spreadsheets are about. For the Mr. Cheatsheet veterans, you can jump down to the bottom and get downloading though.

What Makes These Cheatsheets Special?

Gosh, that’s a good question. At their heart, they are designed to accommodate almost any off-the-wall variation of a fantasy baseball league that you play in. Do you play in a 10×10 roto league with lots of wacky categories? Yeah, this will cover that and cover basically any league you throw at it. The spreadsheet takes your league settings and generates player values based on your league so you know what a player is worth in that league world. Once the draft gets going, you can keep track of it in the spreadsheet and it will update projected standings and rosters for you so you can analyze the crap out of your league in real-time.

Also, there’s just tons of options in this spreadsheet when it comes to different projections to look at or auction values or whatever you want to know from various places around the internet.

What’s Changed From Past Years?

For those that missed last year’s updates, here are some of the highlights:

  • For straight drafts, the cheatsheet tracks draft order now. As you enter picks, it automatically will fill in who thinks has the next pick based on your settings. This allows for there to be a draft history in a tab now. This also means you can trade draft picks within there.
  • Since the cheatsheet tracks draft picks and order, you can also now enter keepers in separately so they don’t affect draft order.
  • During the draft, instead of scrolling around, you can enter all picks at the top of the page now by choosing the teams and players drafted and clicking Make Pick. Or, you can enter picks into the Draft Log directly if you wanted. You’ve got a few options.

What Data Am I Pulling In?

There’s a ton of data in here and most of it isn’t mine. So I owe a big thanks to all of these sources.

  • Projections Sources: Steamer, ZiPS, Fangraphs, Clay Davenport
  • Average Draft Position Sources: FantasyPros, CBS, ESPN, Fantrax, Yahoo, NFBC
  • Auction Values Sources: FantasyPros, CBS, Yahoo, RotoChamp
  • Expert Rankings Sources: FantasyPros, Yahoo, CBS, ESPN

WERTH Values (Roto Leagues)

If you’re playing in a roto league, you may notice that these cheatsheets have a WERTH value for each player. These are essentially z-scores in each roto category based on your league setting. The cheatsheets calculate who the projected league starters would be and then use that to calculate league averages and standard deviations in each category. Using that data, it then says how far above average each person is in that category (z-score) so a positive WERTH value means that player will contribute positively for your team. This is all dependent on your league settings which makes these values completely unique to your league.

Download Your 2018 Cheatsheet

Without further ado, pick your flavor of cheatsheet from the options below. Go out there and kick some butt in your fantasy leagues!

Download the cheatsheet for your rotisserie standard draft leagues
(Current Version: 1.55 uploaded on March 25 at 12:35 PM EST)

Download the cheatsheet for your rotisserie auction draft leagues
(Current Version: 1.55 uploaded on March 25 at 12:35 PM EST)

Download the cheatsheet for your points-based league drafts
(Current Version: 1.55 uploaded on March 25 at 12:35 PM EST)

Troubleshooting

Hopefully these cheatsheets are where they should be now so you probably won’t see any changes before Opening Day aside from me dropping my rankings in there soon and maybe a few other minor tweaks. You can keep track of my spreadsheet updates by following my Twitter where I’ll let you know when updates happen.

Donations

It’s kind of stupid that I put these out for free. I run this site by myself which is good for you because any person with business sense would advise me to charge money for my work. But, hey, I’m a dummy and don’t do that so you can benefit with these free sheets. At the end of the day, I’m happy to just help people out in their leagues. That being said, money is a great motivator to keep me doing this each year and donations help keep this site afloat as well so I’d appreciate any small donations you’d give to buy me a coffee or whatever for my work. If you’re cool with that, punch the donate button below to donate via PayPal (or click here if Venmo is your thing):

I’m done talking now so go out, draft your teams and win some money this year. Peace out!

You Might Also Like

22 Comments

  • Reply
    Alex
    March 24, 2018 at 2:02 pm

    Great work!! I love using your spreadsheet. I had a draft last week and added all the players manually. plan to use new update on a draft this Monday.
    One question. I know this is more for draft help, but I like the projections and roster tabs and would like to know if there’s a way to add and remove players as teams make waiver, free agent moves or trades.

    Thanks for all you do, Alex

  • Reply
    Clinton
    March 24, 2018 at 3:27 pm

    I downloaded the new version & now every time I try to pick a player it gives me the following error: “Run-time error ‘1004’: The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization.” Any help would be greatly appreciated. My draft is in 2 hours.

    • Reply
      Clinton
      March 24, 2018 at 3:44 pm

      Also, I noticed that it will not allow me to click a player to move it up to the draft box.

      • Reply
        Luke Gloeckner
        March 24, 2018 at 4:18 pm

        Which sheet is this happening in?

        • Reply
          Clinton
          March 24, 2018 at 4:48 pm

          Points

          • Luke Gloeckner
            March 24, 2018 at 5:18 pm

            Thanks for pointing this out. I fixed the issue. Try downloading again. It should be Version 1.51 now.

  • Reply
    Clinton
    March 24, 2018 at 5:44 pm

    Works great now! Thanks! One side note: I noticed in both this version & the very first version that when you try to “Only Show: RF” it is not an option that is available. All the other positions are available to “Only Show.” Thanks again!

  • Reply
    Chuck
    March 24, 2018 at 10:09 pm

    Hey Luke,

    On the Roto Auction sheet, I’ve put in the keepers in our league, and three of them were put into bench spots. On the Rosters page, I was able to move one of them to the active lineup, but the other two wouldn’t change. One is Tyler Austin, who I want to put into an OF slot. The team he is on only has one other OF slot filled, so there’s room. The other player is Jose Peraza. He needs to go into an OF slot also. After not being able to move him in there, I changed his position on the Roto Auction page to OF, then when back to the Rosters page, but was still unable to put him into an OF slot.

  • Reply
    jason
    March 24, 2018 at 10:14 pm

    Having trouble getting customized date to import into new sheet. I get a run time error. This is the roto auction cheatsheet, trying to import keepers and customized budgets, team names, categories etc. Have any suggestions?

  • Reply
    Adam
    March 25, 2018 at 12:24 am

    Luke,
    FYI, it appears that the roster size is locked at 26 with version 1.5 of the Roto Auction cheatsheet. Version 1.0 allowed me to change the roster size to 23 to match my league settings.
    Adam

    • Reply
      Adam
      March 25, 2018 at 1:07 am

      Nevermind. It must have been user error since starting over fixed the auto-calculations.

  • Reply
    Marcus
    March 25, 2018 at 12:48 pm

    Hey Luke,

    I downloaded both the Points and Roto cheatsheets and both of my leagues are keeper leagues. I entered all teams keepers and then locked them in. When I go to the “Your Roto/Points Draft” tab and selected “Hide drafted players”, it doesn’t seem to remove the keeper players. Is there something I’m doing wrong? How do I remove the keepers from the available player list? Thanks in advance!

    • Reply
      Luke Gloeckner
      March 25, 2018 at 12:51 pm

      Are they not being shown as drafted? Maybe go back to the Keepers tab, hit the “Reset Draft” button, wait a second and then hit the “Officially Assign Keepers” button again. I’ve seen where sometimes that “Officially Assign Keepers” button doesn’t work on the first try. Let me know if that doesn’t work though.

  • Reply
    Benjamin
    March 26, 2018 at 9:20 am

    Hi Luke! Is it possible to get the raw projections, rather than the cheat sheet? My league’s scoring structure is… interesting. It’s easier for me if I plug the numbers into my own spreadsheet that has formulas built in.

    • Reply
      Luke Gloeckner
      March 26, 2018 at 9:27 am

      Good call. I usually post them as in a Google Doc. I’ll do that in a little bit and let you know when it’s ready.

      • Reply
        Benjamin
        March 27, 2018 at 11:54 am

        Just following up to see if you posted the Google Doc! Thanks for all you do, Luke!

  • Reply
    Kevin Jenson
    March 26, 2018 at 4:43 pm

    I love all your content and sheets, unfortunately for me I can’t use them since I’m in one of those Auction Points Leagues with Keepers. I’m on the outside looking in.

  • Reply
    DC
    March 26, 2018 at 4:50 pm

    Thank you for all the hard work you put into this. I really enjoy your Excel spreadsheets. I am encountering an issue though with the “Your Roto Draft” section. Every time I make a pick, it seemingly takes anywhere from 3-5 seconds, sometimes longer for the pick to register and move forward. I’ve tried this on a couple different machines (Win 10 i5 PC, Macbook Pro i7) and not much difference.

    Any suggestions or know why the lag? It just makes it a little tougher to keep up if picks come in kind of rapid fire.

  • Reply
    Kyle
    March 26, 2018 at 5:20 pm

    Any good way to transfer player notes from an older version to the new one? Thanks!

  • Reply
    Nick
    March 26, 2018 at 5:51 pm

    Our league is as old or older than me and everything about it is kind of weird. For the sake of using your excellent sheets, the only weirdness that matters is the fact that we use a $26.00 salary cap instead of the standard $260 and our minimum bids are $0.10 instead of the standard $1.00. I am able to change these limits in the ‘Settings’ worksheet, but on the ‘Projected Standings’ sheet it only shows whole numbers for $ Spent Per Player, $ Left Per Player and Total Spent, and for some reason shows numbers in the -$100 to -$200 range for Max Bid by team after I’ve entered all keepers.

    The ‘Rosters’ page appears to display the numbers correctly accounting for our league budget and shows values to the tenth for more visibility.

    The ‘Teams’ sheet also only goes to the whole number and makes it more difficult for me to see what I’m working with as bids in our league are very rarely at an even dollar amount.

    Is there a setting somewhere else that I missed or is something else i can change? The sheet is protected (for obvious reasons) so I can’t just change the format to allow for the extra decimal place.

  • Reply
    Deak
    March 28, 2018 at 3:06 pm

    How do you guys prefer to sort your rankings? I was thinking starting with StDev Above Avg then switching over to total pts or potentially switching between the two during the draft. Thoughts?

  • Reply
    Lance Lynn Fantasypros | News Of USA
    August 1, 2018 at 9:20 pm

    […] 2018 Fantasy Baseball Cheatsheets for … – This post is where I’m dropping my latest spreadsheet joint. It’s basically a data update so you have the latest average draft position (ADP), projections … […]

  • Leave a Reply