2019 Fantasy Baseball Excel Cheatsheets (Roto and Points Leagues) | Version 1.00

It feels a bit wild to say this but, ladies and gentleman, this is the 10th anniversary of Mr. Cheatsheet. I started publishing my fantasy baseball cheatsheets and research online to a little blog that nobody was reading ten years ago. Basically, I had the wacky idea that other people might benefit from the work I was doing to win my own leagues. Despite not getting much attention, I kept going for years and eventually people started to find me. Once that happened, I got tips, ideas and requests on ways to improve the cheatsheets in ways that helped even more people. All of the seemingly crazy requests back then pushed me to get even more creative with my Excel skills and the spreadsheets have come a long way as a result of that.

It’ll be fun to see where we’re at in another ten years. I assume the cheatsheets will just be imprinted onto your eyeballs by that time. For now, my cheatsheets are still being delivered to your computers the old-fashioned way. So, without further ado, let’s jump into the 2019 fantasy baseball season with the first version of my cheatsheets.

What Makes These Cheatsheets Special?

My goal when building these cheatsheets was to make them customizable enough that they could handle any type of fantasy baseball league possible. Whether you play in a 10×10 roto league or a custom points league, these sheets can help you during your draft. You open them up in Microsoft Excel (works for both Mac and Windows) then put in your league settings and the cheatsheets will give you player values that are catered to your very special unique league.

Once the draft gets going, you can keep track of it in the spreadsheet. You’ll be able to see projected standings and all sorts of data during your draft so that you can make educated decisions when your time to pick comes up.

If you are in a keeper league, you can enter your keepers in and the cheatsheet will take those into account. If you’re in a roto auction league, you can run it from the cheatsheet and get custom values based on your league settings that change during the draft based on your league’s inflation rates. The possibilities for what these cheatsheets can handle are (nearly) endless.

What Data Am I Pulling In?

Since this is the 10th anniversary, I’m feeling a tad reflective at the moment. Over those years, we’ve seen some projection sources disappear such as CAIRO, CHONE, MORPS, Marcel and many others. We’ve also seen ADP sources go away such as MockDraftCentral and FantasyGameday. I owe a great deal to all of them for their work that has brought us to today.

That being said, we’re in a golden age of projections and draft data. Though the sheer number of options has dwindled a bit, that’s because we have such good options nowadays. For instance, Steamer changed the whole baseball projection world and made other systems obsolete and the same can be said for FantasyPros when it comes to their work with ADP and Rankings.

I pull in lots of data for you to choose from in these spreadsheets. I have a bit of my own data in there but this spreadsheet mostly crowdsources the best baseball minds. Here’s what you can find inside this first version of the 2019 cheatsheets.

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

There will be additional data added into future updates of the 2019 cheatsheet. Notably, you’ll eventually find ZiPS projections and my Special Blend projections.

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 2019 Cheatsheet

The cheatsheets come in three different flavors. There’s a draft and auction version of the cheatsheet for roto leagues (this includes roto head-to-head leagues). If you are in a points-based head-to-head league, there’s a cheatsheet for that as well.

Download the cheatsheet for your rotisserie standard draft leagues
(Current Version: 1.75 uploaded on March 27 at 6:45 PM EST)

Download the cheatsheet for your rotisserie auction draft leagues
(Current Version: 1.75 uploaded on March 29 at 10:30 AM EST)

Download the cheatsheet for your points-based league drafts
(Current Version: 1.75 uploaded on March 29 at 11:00 AM EST)


Hopefully the cheatsheets themselves give you enough instruction inside of them to get the hang of things. If you have questions about anything though, post your questions in the comments below so I can answer for others to see.

While I did a bunch of testing on these prior to their release, it’s hard to test out every conceivable scenario so it’s possible you may encounter a bug or error that I didn’t catch. Let me know about that as well and I’ll post updates as needed. You can keep track of spreadsheet updates by following me on Twitter where I post about any minor updates that may happen.

As new cheatsheet updates are released, you’ll want to utilize the Save Or Load page in the cheatsheet to copy and paste your custom data into new updates.

If you have ideas for new features, post about those in the comments as well and I’ll see what I can do. I know there’s been an outcry for a Points Auction version of the sheets, for instance, which I will work on in addition to other feature updates that you all suggest.


I don’t like asking for money but these do take a ton of work. They are free to whoever wants to use them. There are similar resources out there that charge money and I respect that but I’ve never wanted to go down that road because I’d rather everybody has draft help if they need it. That being said, donations help keep this site afloat because storage and bandwidth and everything else costs money (and I like to think my own time working on these is valuable). Feel free to use the donation buttons below if you want to buy me a beer or a coffee… or a private island.

Have fun exploring the cheatsheets and good luck this season!

You Might Also Like

  • Chuck
    02/17/2019 at 4:57 PM

    Hi Luke,

    Great to have the sheets back for another season. I think I’ve asked this in the past. On the Teams page, could you include the team total of the initial cost for each player, maybe next to the Money Left amount? I’ve seen it written that in auction leagues, you want to draft somewhere around $330 in value with your $260. Having the value total of the drafted players up top would make it easy to keep track of that.

    • Luke Gloeckner
      02/17/2019 at 11:55 PM

      Hey Chuck. Always a pleasure to hear from you. You certainly may have suggested that in the past and I forgot about it. That’s a cool idea. I’ll give it a shot and see if I can pull it off.

    • Bryan Burmeister
      03/22/2019 at 12:30 PM

      Can I join your league where you can get that large of a “profit”? Most leagues I am in, even if you had full knowledge after the thing was over, that would be impossible.

  • Justin
    02/17/2019 at 8:19 PM

    I wish I knew how to use Excel. None of the drop downs on the settings page do anything for me on the spreadsheet when I download it, and when I search for keepers it says Player not found.

    • Luke Gloeckner
      02/17/2019 at 11:56 PM

      Which version of Excel do you have?

      • Justin
        02/18/2019 at 9:06 AM

        Excel 2003. If you email me I will send you screenshots.

  • mitch
    02/17/2019 at 8:56 PM

    Thanks so much for getting it out early this season……..

    • Luke Gloeckner
      02/17/2019 at 11:57 PM

      Yeah, this year luckily wasn’t quite as chaotic as last year so I was able to get a jump-start on it!

  • casey
    02/17/2019 at 11:26 PM

    how do I add the number of bench players in my league we are allowed?

    • Luke Gloeckner
      02/17/2019 at 11:58 PM

      For a regular roto draft? I don’t have that as an input because it doesn’t affect any of the calculations within the sheet. In a roto auction, I do have that as a setting because it affects dollars values there.

      • Chuck
        02/18/2019 at 9:47 AM

        In our league, we have a 12 round taxi draft at the end of the auction. It acts as a snake draft, with no cost applied to the picks. In my case, would it be best to set the bench number to zero since we have no values attached to these players?

        • Luke Gloeckner
          02/18/2019 at 1:41 PM

          Yup, that’s what I would do!

        • Casey C
          03/18/2019 at 3:43 PM

          I guess thats what Im asking

          We run a 23 player auction $260 – Then a 17 player keeper / dynasty bench – Can be minor league or active players

          Value attached to those picks dont effect the $260 budget so I was trying to figure out the correct setup.

          • Casey C
            03/18/2019 at 3:44 PM

            To be honest. I think thats a different casey, but reading the responses is a question I had. I just came across this site two days ago. LOL

            Well worth a donation

  • Blaize
    02/18/2019 at 2:44 AM

    Thank you so much for doing these. In the points league cheatsheet, it seems that the pitchers points arent totaling up correctly? I keep getting them to come out to negative projections.

    • Blaize
      02/18/2019 at 2:47 AM

      my apologies. i entered the wrong data haha. Thank you again for such amazing content.

  • Ken Kidd
    02/18/2019 at 8:28 AM

    Thanks for getting these out so early!!! Hello a lot with my draft prep.

  • RS Krause
    02/18/2019 at 8:34 AM

    Hi Luke, I play on a points auction league. Which spreadsheet should I use? TY

    • Luke Gloeckner
      02/18/2019 at 9:00 AM

      Ahh, unfortunately I don’t have a version for Points Auction leagues yet! I have gotten requests for that though and I’m going to try to make a version that handles that soon.

      • RS Krause
        02/18/2019 at 9:06 AM

        Looking forward to it. Thanks Luke

  • Robb
    02/18/2019 at 10:21 AM

    I think Carlos Martinez is missing from the positional rankings. Just wanted to bring it to your attention.

    • Luke Gloeckner
      02/18/2019 at 1:37 PM

      Ah, cool. I’ll check it out. Thanks!

  • Craig Shieber
    02/18/2019 at 10:33 AM

    Yes, Auction Points! Have my auction exactly 1 month from today. Please make it happen Mr. Cheatsheet

  • Will
    02/18/2019 at 12:04 PM

    Do you think you’ll make a head to head categories sheet?

    • Luke Gloeckner
      02/18/2019 at 1:38 PM

      H2H Categories is just a form of Roto so use the Roto cheatsheets for that.

  • Steve
    02/18/2019 at 12:58 PM

    I’ve imported the batters projections under the appropriate columns but am not getting a value for the total points? Does something further need to be done, to have the projections calculated into total points?

    • Luke Gloeckner
      02/18/2019 at 1:38 PM

      I’ll look into it. It may just be something I missed on my end. I’ll let you know.

      • Steve
        02/25/2019 at 8:57 AM

        Do you know if this error is on my end or your end?

        • Luke Gloeckner
          03/06/2019 at 11:07 AM

          FYI, this is fixed in the latest version (or should be!)

      • Tim
        03/02/2019 at 2:57 AM

        I am having the same issue. Imported my projections under the proper tabs but only the runs category is totaling for hitters. The pitching import worked fine. Love the tool, btw. Thanks for all your hard work!

        • Luke Gloeckner
          03/06/2019 at 11:07 AM

          Should be fixed in the latest version!

  • aaron
    02/18/2019 at 1:20 PM

    hey luke,

    many thanks for this awesome product. looks like player notes don’t copy over from version to version – any idea how i can do that? i copied the save/load section of 1.0.0 to 1.0.1, and it moved everything except the notes over correctly.

    • Luke Gloeckner
      02/18/2019 at 1:39 PM

      Ah, interesting! I’ll look into that and see what’s going on and let you know.

    • Luke Gloeckner
      03/06/2019 at 11:08 AM

      This was a good idea. While it doesn’t address old version of the cheatsheets, I released a new version today that will allow you to transfer the notes over to new version as well.

  • John
    02/18/2019 at 2:18 PM

    Thank you very making this. Gonna be my first year utilizing your sheets so am excited to try something new

    We have keepers but the sheets are coming up as protected, disallowing me to enter in player names. What would the password be to unlock? Am trying under the ‘rosters’ page


    • Nick Whitt
      02/24/2019 at 8:04 PM


      If you’re trying to enter the names of players for keepers, do it under the “Keepers” tab, not the “Rosters” tab. The Rosters tab I believe just displays the data you have entered either under the “Keepers” tab, “Draft Log” tab, or the actual draft tab.

  • Seth
    02/18/2019 at 3:17 PM

    Hey Luke – found a small bug on the settings tab when selecting pitching categories, where a dropdown option is not always available.

    In general, in the list of ordered pitching category enumerations (W, S, K, ERA, WHIP, QS, Holds, Save + Holds, K – BB, K/BB, K/9, CG, Shutouts, ER, BAA, Hits Allw, HR’s, Walks, L, IP, GS, Games, Blown Sv, Net Sv, H/9), the 10th one on the remaining list is not a selectable option.

    Example 1: Given you have the default five pitching options selected.
    When you go to select the 6th pitching option
    Then BAA is not available as an option.

    Example 2: Given you have the default five pitching options selected
    And you select Holds for 6, and K/9 for 7
    When you select the 8th pitching option
    Then 10th item on the remaining list (HR’s) is no longer an option (Hits Allw is directly next to Walks)

    Hope this helps. Thank you!

    • Doug
      02/20/2019 at 5:56 PM

      Hey Luke!
      I was wondering if there’s an ability to sort by ‘position adjusted WERTH’ for purposes of evaluating trade talks?
      Also, will there be a version of the rankings for a dynasty draft?
      Love the spreadsheets, thanks again!

    • Luke Gloeckner
      03/06/2019 at 11:08 AM

      Thanks for catching this. I was able to figure out what was going on and it is fixed in the latest version!

  • Chuck
    02/18/2019 at 3:26 PM

    Another suggestion: Allow us to define categories for the Notes. In our league, after two years, you can either sign a player to a two year contract, drop the player, or keep the player’s topper rights, meaning you can top the highest bid in the draft by a dollar to keep that player for one more year. So I’d like to have a Topper category that I could define (with a cell color also, if possible). We’re also allowed to keep up to 5 players from the previous year who were never activated. They’re called R players. Thus, I’d like to define an R category also for the notes, so I know which players are already on someone’s roster.

    • Luke Gloeckner
      03/06/2019 at 11:09 AM

      I was able to partially solve your problem in today’s update, haha. I didn’t get to the point of defining cell colors but I did open up the Note Type to allow for you to write in your own values (no more than 7 characters though). Hope this helps.

      • Chuck
        03/06/2019 at 11:14 AM

        Thanks. I’ll check it out later today. As always, I appreciate your hard work on this.

  • Warren
    02/18/2019 at 3:34 PM

    Hi Luke, thank you for this fantastic resource! I use the Positions tab the most during drafts, mostly as a way to visualize tier-breaks. When I try to use the Ctrl-F feature to search for players, I get an error message. Is there any way to be able to use the Ctrl-F Find feature with your file?

    • Luke Gloeckner
      03/05/2019 at 12:57 PM

      Hey sorry. Just noticed this particular comment. You can use Ctrl-F. When the Find box comes up, click on Options though to make sure it says “Look In: Values” (as opposed to “Look In: Formulas”).

  • Jeff
    02/18/2019 at 3:57 PM

    Here’s one more vote for the points auction excel file

  • Ken K
    02/18/2019 at 9:19 PM

    Great work, as usual, Mr Cheatsheet! One minor request, any chance you can add IP minus ER as a pitching category? I can get around this by putting in ER and IP as half categories, but having IP minus ER would make things easier. Thanks again.

    • Luke Gloeckner
      03/06/2019 at 11:10 AM

      I was able to add that in to today’s update. Thanks for the suggestion!

      • Ken
        03/06/2019 at 5:46 PM

        Awesome, thanks Luke!!!

  • Travis C
    02/19/2019 at 8:26 AM

    Can you add the option to sort by Pos Adj WERTH on the Your Roto Draft tab?

  • Wah Chan
    02/19/2019 at 10:21 AM

    Thank you again Luke for doing this for us.
    I’m in a keeper league where we trade draft picks. I know in your cheatsheet, you are set to run a snake draft order. Any way to make it easy where we can mark Team 1 to have picks 11, 17, 19 for example. Or do we have to manually go into each round and edit the pick number with right team name. Thanks

    • Wah Chan
      02/19/2019 at 10:27 AM

      Oops, also wanted to ask for keepers, can we put what round they are being kept at so when draft comes, those players aren’t taking off the top by assign to the round in the draft that they are being kept at, thanks

    • Luke Gloeckner
      02/24/2019 at 7:39 PM

      Yeah, in the cases where there have been draft pick trades, I go into the Draft Log and manually edit the picks that have been traded.

  • Eric
    02/19/2019 at 4:52 PM

    Was going to ask for the auction + points sheet but see you already addressed this. Thank you Luke

  • Dan
    02/20/2019 at 1:40 PM

    Hey Luke,
    Love the Auction Cheat Sheet my man, truly first rate stuff and a go to every year. Had a quick one about the lowest possible bid. Is there something that prevents you from allowing a Zero bid? Would love to see that ability if possible. Great work man, thank you as always for providing!

    • Luke Gloeckner
      03/06/2019 at 11:11 AM

      Great idea. I added that in as an update to the latest version that I released today.

  • Justin
    02/20/2019 at 7:17 PM

    Could you add the option to sort by Pos Adj WERTH on the ‘Your Roto Draft’ section?

    • Luke Gloeckner
      02/24/2019 at 7:38 PM

      Yeah, I can do that in the next update.

  • Chris
    02/21/2019 at 11:05 AM

    I’m sure I’m doing something wrong, but it seems that when I adjust the projection settings to use a custom combination (https://i.imgur.com/zxc9VyC.png), nothing shows up in the stats area on the Your Points Draft sheet (https://i.imgur.com/0VVXYDR.png). I downloaded a completely fresh version of the Points Draft sheet, changed just this setting, and am still having the issue. Thanks in advance for any help!

    • Luke Gloeckner
      02/24/2019 at 7:41 PM

      I’ll give it a look and get it fixed for the next update. I think there may be an issue with the custom combinations due to not all of the projections being available yet but I’ll see.

    • Luke Gloeckner
      03/06/2019 at 11:11 AM

      I was able to fix this in the latest version that was released today. Thanks for letting me know about it.

  • Nate
    02/21/2019 at 6:15 PM

    Hi Luke, will you add the option to change a player’s position in future updates? I know we’ve had it in previous years, and it’s really helpful for guys with multi-position eligibility so that you can get correct adjusted WERTH and projected standings (so the player slots into your lineup where you’ll be playing him). Thanks as always!

    • Luke Gloeckner
      02/24/2019 at 7:40 PM

      Is that not working correctly? I’ll give that a look and see what’s up.

      • Nate
        03/01/2019 at 1:37 PM

        Don’t think so, unless the method has changed? Used to be that in the “Your Roto Draft” section you could highlight a player’s position and it would allow for a dropdown menu to change the position. The option for that dropdown isn’t appearing on my sheet, and the cell is protected so I can’t type in the new position either. I play in a keeper league and my roster includes Jose Ramirez, Manny Machado, and Corey Seager, so getting them lined up at 2B/3B/SS respectively is important for me haha

        Appreciate you looking into it and all the work you do!

        • Nick
          03/02/2019 at 7:36 PM

          There is a column to the left of the players name that you can use to change their position. It does not add positions, so it doesn’t account for multiple positions, but you can use it to recalculate the WERTH based on the new position. Also, on the Rosters sheet you can change a players position by double clicking on their name.

          • J
            03/10/2019 at 12:36 PM

            Luke, thanks for the heavy lifting. Multi-position eligibility is key in my draft and it would be super helpful to have the option to assign multiple positions to players. Any chance this is a possibility? If the hurdle here relates to WERTH calculations, can we associate the highest value position for this purpose?

  • Chuck
    02/22/2019 at 4:23 PM

    I’ve got another suggestion, Luke. On the roto auction sheet, if Hide Drafted Players is selected, could it automatically hide columns A + B, also?

    And another very minor suggestion: Could you shade the pitching category column headers the same color the stats are shaded?

  • Ken
    02/23/2019 at 12:19 PM

    Does anyone know of an Excel substitute that actually works? I have tried Open Office and PlanMaker (Softmaker Free Office) and neither of them work. Open Office is a total bust and PlanMaker just ‘spins’ for like 5 minutes every time you click on anything.

  • Tony
    02/24/2019 at 9:25 AM

    Is there a way to set position rules for players? For example, J Profar played majority of his games at SS and typically under a 20 GP eligibility is a 1B, SS, 3B. The cheatsheet has him as an OF. I see that we can manually change a player but was looking to see if there was a way to put in GP minimums to create position eligibility

    • Luke Gloeckner
      02/24/2019 at 7:41 PM

      I’ve thought about that. I’ll see what I can do for a future update.

  • Frank
    02/24/2019 at 7:19 PM

    I’m trying to copy and paste some stats – less info – since the “hide” feature doesn’t work, – in a separate excel spreadsheet. But I get an error message (run-time error ‘1001’) . Is this because it’s password protected? Any suggestions? Thanks.

  • Jason Smith
    02/25/2019 at 9:51 PM

    Just curious, have you ever tried writing some criteria in the solver add in (or maybe a macro) to see if you could try to find the optimal draft using ADP and WERTH? Didnt know if this would be possible and if it could be an additional tab?

    • Luke Gloeckner
      02/27/2019 at 12:05 PM

      That’s a great idea and one I’ve messed with but hadn’t gotten it to a point that I was happy enough with the results to include in the sheet. I may give it another shot here though.

      • Jason Smith
        02/27/2019 at 10:36 PM

        I know it would be time consuming to come up with all the criteria. When you messed with it, what tools were you using? Would be invaluable if you could get it working. I always try to do it manually and just too many iterations to do legitmately by hand.

        • David
          03/14/2019 at 11:27 AM

          Luke, thank you for all of your work. I find the spreadsheet, sleeper info, rankings and cheatsheet incredibly useful.

          I am also trying to do something along these lines manually. I am curious how others are using the current spreadsheet. For the past few years I have used the spreadsheet to try to manually find the most optimal pick available based on roto category need and WERTH and a few other factors and find this to be difficult to do on the fly.

          I would be interested/curious/happy to test anything you’ve thrown together.

  • Harrison Montague
    02/25/2019 at 10:48 PM

    Love this! Quick question, my pitching points are coming in way low – do you know why this might be? I am using the head to head points section

    • Luke Gloeckner
      02/27/2019 at 12:04 PM

      I assume you put in your scoring system to mirror the points scoring in your league? Is there a category your league uses that’s not in my sheet perhaps?

  • Nathalie
    02/26/2019 at 3:21 PM

    Hi, first time using this (thanks for putting it together). Our draft is Monday March4 and I have 2 questions:

    1) I’m in a H2H categories league, I understood I need to use the Roto cheatsheet? What do I need to change in order for it to be the most useful possible for my league?

    2) Also, I input all the keepers, Alex Bregman being one of mine and he’s on the first line in the keepers tab. But for some reason he’s showing as available in the Draft tab and I only have 7 keepers assigned (I kept 8). How can I fix this? Thanks!

    • Luke Gloeckner
      02/27/2019 at 12:08 PM

      Honestly, when I’ve used it for H2H categories, I haven’t made any modifications versus the standard roto sheet. At the end of the day, it is still giving you the value on the year for a player even if you aren’t getting their “weekly” value. As far as the missing keeper issue, I noticed that the other day too and will put out a quick little fix for that soon. It’s just not carrying over that top keeper because of a little bug.

  • Mike
    02/27/2019 at 9:04 AM

    Do your rankings, draft order, etc. in your spreadsheets automatically update when you update them for different sites?

    I am wondering if it makes sense to wait and load up a cheat sheet.

    • Luke Gloeckner
      02/27/2019 at 12:03 PM

      Unfortunately, I don’t have automatic updates built into the sheet (they become too unwieldy when I do that) so I’d probably just wait a week or so for the next major update unless you have a draft sooner than that.

      • Mike
        02/27/2019 at 3:30 PM

        Thank you, good to know. How often do you update them? My draft is the 18th.

  • Hal
    02/27/2019 at 9:30 AM

    Hi Luke, please tell me you’re working on that spreadsheet for points auction leagues. Should I keep my hopes up?

    • Luke Gloeckner
      02/27/2019 at 11:32 AM

      Keep your hopes up, my friend.

  • Andrew
    02/27/2019 at 11:58 AM


    Link wont open for me – Keep spinning trying to open

    • Luke Gloeckner
      02/27/2019 at 12:03 PM

      Give it another shot. I was doing a site update behind the scenes a moment ago that may have slowed it down for a bit.

      • Andrew
        02/28/2019 at 6:00 PM

        Still not working

  • BH
    02/27/2019 at 1:25 PM

    Love the spreadsheet. Incredibly useful. My only issue is that my league uses a category not included in the sheet. Is there a way to add a custom category?

    • Luke Gloeckner
      03/05/2019 at 1:09 PM

      What’s the category? There isn’t an ability to add custom categories but if it is a stat that I can add in then I could give it a shot for the next update.

  • RS
    02/27/2019 at 9:35 PM

    Hey man thanks for taking the time to do this. It’s going to be my first season this year and I don’t know much about baseball. I’ve been playing around with the sheet and was wondering what numbers a newbie like me should be paying attention to during the draft? Do I just look to pick guys with the highest WERTH value?

  • Mike Strohmer
    02/28/2019 at 5:50 AM

    I found your spreadsheet awesome, but the problem i have is macros? I use libre office, and it tells me to retype the password as the document cannot be exported with protected items. New to this excel so if i am doing something wrong Luke i apologize. Just this popup keeps coming up to retype password. there is are multiple sheet protection that some are blocked out and others say to retype password. very top is document protection that is blocked from typing. I am not handy with computer skills but i try. Again this is on Libre Office excel and if i wrong trying to use your great cheatsheet. i apologize and will drop it…thanks,

  • AH
    02/28/2019 at 2:04 PM

    Is there a timetable for data updates closer to the season’s beginning? I know Fangraphs added ZiPS this morning.

    • Luke Gloeckner
      03/01/2019 at 12:04 PM

      Yup, I hope to do another update in the near future. I don’t have a specific timetable but I would say there will be an updated version within the next week.

      • AH
        03/01/2019 at 5:58 PM

        Awesome, thanks for all your work.

  • Brian
    02/28/2019 at 5:55 PM

    Thank you for a great cheatsheet. I have a 10×10 league and I have a couple questions…
    1. We do Net Saves + Holds as a scoring category. The Cheatsheet has Net Saves and Holds as separate categories. Is there a way I can combine these, and if not, would it affect the overall scoring/ranking if I just added them as two categories instead of one (cheatsheet sees it as a 10×11 league, but it’s actually a Yahoo 10×10). Not sure how the math works behind the scenes, so I wasn’t sure.
    2. We have Appearances as a category. This would be the same as “Games”, right?

    Thanks again, you’ve done fantastic work here!

    • Luke Gloeckner
      03/06/2019 at 11:16 AM

      I would probably just use Sv + Holds as the category since should come close to the same sort of data. And, yeah, Games would be Appearances as well.

  • Dewey
    03/01/2019 at 11:58 AM

    In the points cheatsheet, in the settings, I tried to change the projections to use to my own custom combination. I put in numbers which totaled 100. But then when I go to the “Your Points Draft” tab, there are no projected stats and no projected points for any players.

    • Dewey
      03/01/2019 at 11:59 AM

      I just realized that Chris raised this same issue above on 2/21 and on 2/24 you said you’d take a look at it.

  • Andrew
    03/01/2019 at 12:00 PM

    Still waiting to find out why I cannot open the sheets

    • Luke Gloeckner
      03/01/2019 at 12:03 PM

      I have no idea, man. It’s a link that’s been working for others. Perhaps turn off an ad-blocker or pop-up blocker or something. Unfortunately there’s not anything I can really do to troubleshoot that on my end.

  • Yaz
    03/01/2019 at 12:07 PM

    Will you be doing your “special blend” of projections again this year?

    • Andrew
      03/01/2019 at 12:09 PM

      can you send sheet via email possibly?

    • Luke Gloeckner
      03/01/2019 at 12:10 PM

      Yup, I had been awaiting the release of the ZiPS projections before I could work on them but I’m going to start work on that this weekend.

  • David
    03/01/2019 at 3:09 PM

    Thanks for this, Luke! While deleting someone from the the Auction Log I started getting a REF#! and as I add new players it keeps deleting old ones. Happy to send you my file if that’s helpful. When I went to copy my old data into a new sheet to start over it’s not populating. So I’m a little stuck. Thanks!

    • Luke Gloeckner
      03/06/2019 at 11:17 AM

      I think this should be addressed in the latest version I put out today but let me know if you still have issues.

  • john
    03/01/2019 at 6:52 PM

    can you add The Bat as a projection source–its on fangraphs?

  • Paul
    03/01/2019 at 7:10 PM

    I’m trying to input keepers, but every time I switch to a different sheet, the players disappear. I’ve tried auctioning each player to their respective teams, and I can successfully auction one player, but when I try to auction a second player, it makes the first player undrafted again. Only one player total can be drafted for some reason. Any suggestions?

  • Tom
    03/02/2019 at 2:39 PM

    I’m having trouble loading the roto in OpenOffice. Is there anything I can do on my end to help this? Thanks for any help.

  • Ryan Steffen
    03/02/2019 at 2:41 PM

    Hi, really love the spreadsheets and appreciate all your hard work. I am trying to enter in keepers, and for some reason when I try to search for Fernando Tatis Jr. in either the Roto Auction or Auction log tabs, I am unable to get him to save and stick on the appropriate team. Any suggestions? Wondering if maybe his player cell is somehow locked in the document? Thanks for your help.

    • Ryan Steffen
      03/02/2019 at 3:00 PM

      Bo Bichette and Kyle Tucker are other prospect players that I was trying to enter in as keepers and the sheet does not seem to be allowing me to enter them onto rosters like I can for most other players. Any suggestions you have are appreciated. Thanks again.

  • Ryan Steffen
    03/02/2019 at 3:37 PM

    Another question, I’m curious if CI, MI, or Bench positions could be added to the sheets, so that you can change the default position designate a player for one of those secondary positions from the start? Thanks.

  • Nick
    03/03/2019 at 3:44 PM

    How does the sheet pull ADP and Rankings from FantasyPros? I noticed that the rankings in the sheet no longer match what is on FantasyPros. I have not figured out the inner workings of the sheet, is this something I can update? Does it automatically pull the data from the website? Thanks!

    • Luke Gloeckner
      03/03/2019 at 4:01 PM

      It does not automatically pull from FantasyPros. I release updates to the sheet every so often that have the latest data at that time. You can go to the Credits page to see when those pieces of data were pulled in. There should be a new update coming in the next couple days.

    1 2