2017 Fantasy Baseball Cheatsheets [Version 2.0]

I unveiled my majorly updated 2017 fantasy baseball cheatsheets just a couple weeks ago. Since then, new data has been released, including my own projections, and there’s also been lots of ideas, suggestions and bug fixes coming up in the comments here. It goes without saying that a big update was due and today is that day!

First off, no, I sadly didn’t get every single request in. There were a lot. Many of them were great ideas but were things that would have required too many hours to be able to accomplish so they’ll likely have to wait until next year’s version. I’m still pretty pleased with what got into this 2.0 version of the 2017 cheatsheets though and I think you’ll dig them too.

What’s New In Version 2.0?

All of the sheets now have updated projections and now have my Special Blend projections included in them. All of the roto sheets now have a few extra categories to choose from too (Extra Base Hits, Net Saves, Blown Saves being some of the big ones). But, aside from that, the Roto Auction sheet had some big tweaks:

  • In the Roto Auction sheet, you can now choose whether you want your projected draft values to be inflated based on player position or not. In the past, catchers (or other weak positions) typically got a boost because, well, everyone has to draft a catcher so even the weak ones have value. This resulted in values being “position-adjusted” but that might not be what works for everyone. So, on the Settings page, you can now choose whether you want your values to have that adjustment or not.
  • You can also set individual team budgets in the Roto Auction sheet. I’ve heard of some keeper leagues that involve sacrificing future draft dollars thus resulting in teams entering the year with different draft budgets to begin with. Now, you can reflect that in the sheets with custom team budgets.

Those are probably the biggest feature changes of everything. But, there were numerous reported bugs that were fixed included an issue with Net Stolen Bases causing some wackiness.

Cheatsheet Options

If you haven’t used this cheatsheet before, you’ll see that it is designed to accommodate nearly any type of fantasy baseball league imaginable. And, believe me, there’s more league variations than you could even imagine. That being said, it can be a bit overwhelming to see so many options for a new user. To get started, I’d just enter your league settings on the Settings page and leave most things with their default settings and dive in. If you don’t like the data you’re seeing, go back to the Settings page and maybe try some other Projections or Rankings on there until it looks good to you.

Once the draft is going, enter your picks into the sheet and see your Standings and data start to adapt and change for your specific league. The idea is that the cheatsheet will give you data and values that are completely unique to your specific league type.

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

Without further ado, pick your flavor of cheatsheet from the options below.

Download the cheatsheet for your rotisserie standard draft leagues
(Current Version: 2.58, uploaded on March 28 at 4:45 PM EST)

Download the cheatsheet for your rotisserie auction draft leagues
(Current Version: 2.58, uploaded on March 28 at 4:45 PM EST)

Download the cheatsheet for your points-based league drafts
(Current Version: 2.55, uploaded on March 28 at 4:45 PM EST)

Troubleshooting

At this point, draft season is in full swing and there likely won’t be major changes to the cheatsheets from now until Opening Day. That being said, if there are things not working correctly, let me know in the comments so I can fix them and upload a new version. I’ll also likely upload another minor update or two with up-to-date projections and data.

Also, for Points Leagues, there will be an update coming soon that will add in a few more point category options. I didn’t have the time to get those added into this update.

Keep checking back here to see the latest version available though.

Donations

I said it in my initial release but, ho boy, these cheatsheets take a lot of work to create. Between creating them and responding to everyone’s issues at times, it becomes a full-time job for me in February and March even though I opt to put these out here for free. I appreciate anyone who is willing to donate a couple bucks as a way of saying thanks for this work. It helps me keep the site online and gives me the motivation to keep making these each year. You certainly don’t have to though because I want these to be free! Regardless, later on, let me know if you win your leagues because I always love hearing that too! But if do you want to buy me a coffee or a beer, the donate button is below:

Have a great draft weekend everyone!

You Might Also Like

148 Comments

  • Reply
    Eric L.
    March 16, 2017 at 6:38 am

    On the Roster page, it still only shows projected stats for batters and nothing for pitchhers using v2.0

  • Reply
    Luke Gloeckner
    March 16, 2017 at 7:47 am

    I’ve never been able to recreate that issue so I assume there must be a specific setting causing it. Can you send a copy of your sheet with the issue to luke at mrcheatsheet.com?

    • Reply
      Eric L.
      March 16, 2017 at 5:18 pm

      It has been sent and I think I found the problem in the settings which I included in the email. If you set SP and RP to 0 with P at 9 as my league only cares you have 9 pitchers total, the pitching projections to not transfer over to the Teams tab

      • Reply
        Luke Gloeckner
        March 16, 2017 at 5:48 pm

        Okay. I probably won’t have a chance to look at it until tomorrow but that makes sense. Should be able to quickly fix that.

        • Reply
          Chuck
          March 16, 2017 at 8:23 pm

          That’s the same problem I’ve been having, and I set the SP and RP to 0 and the P to 9 also.

  • Reply
    Wah Chan
    March 16, 2017 at 10:17 am

    thanks again Luke for your generous hard work.

    • Reply
      Luke Gloeckner
      March 16, 2017 at 12:48 pm

      No problem, man! Thanks for the kind words. It makes me happy to see people appreciating the sheets!

  • Reply
    AB
    March 16, 2017 at 10:45 am

    Is ‘Hits’ available as a Pitching stat category?

    • Reply
      AB
      March 16, 2017 at 1:03 pm

      It looks to have disappeared in the (Roto) update…

      • Reply
        Luke Gloeckner
        March 16, 2017 at 1:28 pm

        It’s there, I just made a slight name change to it so it could better fit in the columns. It is now called ‘Hits’. If you are loading previous settings, you may need to select that again on Settings page.

        • Reply
          AB
          March 16, 2017 at 1:31 pm

          Reloaded the sheet and it’s there! So strange. Thanks for all of your hard work!!!

          • AB
            March 16, 2017 at 2:24 pm

            I worked out what happened. When I selected ‘Hits’ as a Batting category, it removed the ‘Hits’ option from the Pitching category. Thus, I manually typed it in. Hope that works OK.

          • Luke Gloeckner
            March 16, 2017 at 5:48 pm

            Ah yes. That makes sense. I need to tweak something in there. I’ll take a look at it tomorrow

  • Reply
    matt
    March 16, 2017 at 12:22 pm

    Thanks for the sheet! Is there a way to sort by pos adj werth instead of total?

    • Reply
      Luke Gloeckner
      March 16, 2017 at 12:50 pm

      Unfortunately not. I tried to add it into this version but it causes some nasty data loops. I may be able to get it to work in a later version but I was stumped at the time.

  • Reply
    Randy
    March 16, 2017 at 12:33 pm

    Is there any chance that we could, or you could, bold the projected points column to make it stand out a bit more? Thanks for all your hard work! Won my third championship last year in 6 years last year. That makes 2 flags that you have helped me with!

    • Reply
      Luke Gloeckner
      March 16, 2017 at 12:53 pm

      Not a bad idea! But I generally try to avoid bolding things because I don’t want to force people’s attention somewhere since everyone uses the sheet differently (I had somebody recently say the sheet was unusable for them because they could SEE projected values and they wanted to draft blindly without those, for instance). I think you should be able to highlight that column and press Ctrl+B to make it bold on your own though. Not sure if that would work but I was trying to open up the ability for people to highlight things like that if they wanted in this version.

      • Reply
        KT
        March 16, 2017 at 6:12 pm

        Hi Luke. Formatting does still seem to be unavailable on the latest version of the points sheet (sorry, hate to bother you about the same thing again). I can’t do any bolding, highlighting, notes, etc. Any chance this is coming in another version, or should I start working on a new sheet strategy? Thanks.

        • Reply
          Luke Gloeckner
          March 16, 2017 at 6:28 pm

          I tried for this update but there’s some complexity to the request because of the way the cheatsheet handles sorting on the main sheet (nobody is ever really assigned to a specific cell so it’s hard to carry formatting with them as the sheet updates). I still have it at the top of my list but wanted to get out this update regardless. I’ll continue to think it over and hopefully come up with something.

          • KT
            March 16, 2017 at 6:49 pm

            Either way, thanks for trying. I’ve been in the money the last two years using your sheets with my formatting, so I’m afraid to change anything!

  • Reply
    Greg
    March 16, 2017 at 12:40 pm

    Im in a points auction – anything for values for that? I can never find any.

    • Reply
      Luke Gloeckner
      March 16, 2017 at 12:54 pm

      I’ll see if I can make one in the next week or so but I’m not sure if I can get it all done in time. There seems to be a growing demand for it in recent seasons.

  • Reply
    chris
    March 16, 2017 at 1:56 pm

    Hi, thanks for the update! Just a quick bug, using the special blend, I noticed Carlos Carrasco stats disappeared in this round (they were there in the prior version). Thanks again!

    • Reply
      Luke Gloeckner
      March 16, 2017 at 5:49 pm

      He doesn’t have a Special Blend projection (CAIRO did not project him for some reason). Try Streamer or another protection to see his value for the time being.

  • Reply
    Eric L.
    March 16, 2017 at 5:40 pm

    Is there a way to “force” players into a Bench slot? My league doesn’t have Bench slots but we do have Minors slots where we can keep 4 players as long as they meet certain requirements. Less than 150 carrear plate appearences/50 innings pitched.. Some players, like Lucas Giolito, were drafted to a Minors contract a few years ago and qualify to keep the Minors tag to start the year. Using him as an example, If he wasn’t kept but was still in AAA at the end of last season, but he was expected to start the season in the majors, he is eligible to be drafted in the Majors part of the draft. Because of this, I am trying to find a way to add the players with the Minors tag to their current teams as a way to remove them from the draft sheets. Sorry it’s a long winded post but hopefully it’s somewhat understandable what I’m trying to say 🙂

    • Reply
      Luke Gloeckner
      March 16, 2017 at 5:52 pm

      I haven’t figured out a way to accomplish this quite yet. It’s on my list of potential improvements but there’s some factors that make it pretty tricky for me to accomplish without some major tinkering.

      • Reply
        Eric L.
        March 16, 2017 at 5:55 pm

        Totally understandable. I’ll probably just have a sheet of paper next to me with the players with the Minors contract next to me.

  • Reply
    Matt
    March 16, 2017 at 6:22 pm

    Dumb question, but can you rename teams?

  • Reply
    Steve
    March 16, 2017 at 7:01 pm

    Hi Luke thanks so much for this. What an awesome tool! I did have a couple questions.

    i. In the ‘Positions’ Tab, so I am understanding this correctly, the score assigned in the ‘WTH’ Column is the z score in terms of position, adjusted for the categories you selected in ‘Settings’ Tab? (Roto version)? Also, if that is the case, how come some players in weak positions are still a negative z score? The majority of C are negative WTH.

    ii. One category in my league is H/AB. What included stat do you feel would be most appropriate for a proxy? Just plain H?

    iii. To ensure I am using this tool most effectively, I should draft players with high WTH regardless of position (while still ensuring all positions end up filled)? Is the thinking something like: While you may have the 1st rated catcher ( Posey) your team would benefit more from an 8th rated SP for example?

    Thank you so much!!

  • Reply
    Chuck
    March 16, 2017 at 8:27 pm

    I also just noticed on the Auction sheet that the option to show projected stats or points isn’t functioning for me. This might be related to the Positions Drafted not working. I’ll sent you my sheet. I’m using the default projections, values and rankings, so it must have something to do with my league settings.

  • Reply
    Michael
    March 16, 2017 at 9:00 pm

    Is there a reason you don’t do a Points Auction Cheatsheet? Not asking to be snarky, just curious if Im missing something. Last year I used your Points draft cheatsheet and had auctions values pulled seperatley.

    Again, just thought I’d ask. These are awesome, BTW.

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:52 pm

      I hadn’t heard of anyone in a Points Auction league until last year so wasn’t aware they existed until then, nor the demand for them

  • Reply
    Steve
    March 16, 2017 at 11:12 pm

    First off, many thanks for all of your work on these tools! I’ve downloaded the Points Draft Cheatsheet and according to your instructions, I should be able to change player positions on the “Your Points Draft” tab. However, when I try to make an edit it’s requiring me to enter a password to unlock the sheet.

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:45 pm

      It’s the column to the left of the player’s names for changing positions.

      • Reply
        Steve
        March 17, 2017 at 4:48 pm

        Super, thanks!

  • Reply
    Ryan G
    March 17, 2017 at 3:27 am

    It seems like you added the ESPN auction values in this update based off the Credits page, but it looks like you forgot to add them as an option on the “Site Auction Values” drop-down.

    Thanks a lot for making these by the way; you do a great job.

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:44 pm

      Ah, yeah, that could be. I won’t have a chance to do any updates for the next day or so but I’ll keep that in mind.

  • Reply
    Wah Chan
    March 17, 2017 at 9:28 am

    Hey Luke, i know this was asked but i totally forgot. For H2H leagues, you would use the Points Draft cheatsheet correct?
    Also, another question, how come in Settings tab, when i change the Projections to Use, there doesn’t seem to be any changes in the rankings (Your Points Draft tab), no matter which one i choose.
    Thanks

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:43 pm

      If you’re in a H2H points league then, yeah, I’d do the Points Draft sheet. As far as Rankings, they are based on which Expert Rankings you choose on the Settings page.

  • Reply
    Rob
    March 17, 2017 at 11:32 am

    Hey man, thanks for this. When I enter an NL only league. the projected value goes blank. Am I doing something wrong?

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:42 pm

      Is the related to one specific projection (you have 10 to choose from)? Which sheet is this happening in?

  • Reply
    Brian Silvestri
    March 17, 2017 at 11:55 am

    Hello, I plan to use your auction tool based upon a recommendation of another owner in my league. There are some constraints that I am finding, that I would like clarification on. For background, my league is a 10 category AL auction league. We have 9 pitchers. I set the SP and RP to 0 and P to 9, and the Projected Standings are not calculating for ERA and WHIP and the stats for the RP are not showing on the Teams tab. In addition, due to the depth of the league (12 teams with 2 C required per team), I need more players in my pool than available. I am having trouble importing more players. Can you explain the process to do this? I would like my player pool to be every player on an AL roster.

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:42 pm

      Hey, yeah, I’ve heard about some people having issues with setting 0 SP and 0 RP. I haven’t had a chance to do a fix yet but I’ll try to get it fixed soon. As far as using more players, it doesn’t have that ability (there would be no projection data for them in there). I can try to get more guys added in for my next update if you want to give me a list of guys that you can add. Not sure how many I’ll be able to add in though since it takes a bit of work on my end for each player to add in with adding in all of their projections and calculations and such. It certainly wouldn’t be every single player on an MLB roster though. Sorry about that.

  • Reply
    David S
    March 17, 2017 at 2:10 pm

    Hey Luke

    There seems to be something up with the Imported Projections for Pitchers. For example, if I put a projected value for BB in Column T in the Import (Projections) tab, the sheet is reading that as the K value on the Your Roto Auction tab.

    Also, I know that it’s a pain to add new categories but if you had a minute to add H/9 as a pitching stat.

    Thanks!

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:35 pm

      Ahh, yes, I think I might know what’s going on with that. I’ll check it out when I get a chance and hopefully update it tomorrow maybe. I’m not around today unfortunately.

  • Reply
    Sal
    March 17, 2017 at 2:32 pm

    Hi – It seems that some of the DH’s that appear on the roto position tiers are missing from the cheatsheet.

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:30 pm

      They should all be in the cheatsheet (same source of data for both) but you likely don’t see them on the Positions tab. Just the Draft/Auction tab itself.

  • Reply
    JSK19
    March 17, 2017 at 3:02 pm

    Hi, how do I get errors to count? I’ve selected them in settings as one of my roto categories. Doesn’t look like anyone does projections so I was going to use 2016 stats. This sheet is what Ive been looking for, thanks!

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:30 pm

      Yeah, unfortunately, I hadn’t found any projections for them this year. The source I had in the past didn’t do projections this year. So, I’ve still been hunting for them. At the moment, there aren’t any error projections in there.

      • Reply
        Jsk19
        March 18, 2017 at 10:33 am

        Too bad. I was just going to use last years errors as an approximation. How would I add them? Thanks

        • Reply
          Luke Gloeckner
          March 19, 2017 at 12:51 pm

          I’d have to add them in during an update. I think I will add last year’s values into the sheet for an approximation, like you said. I’ve been travelling so haven’t been able to do updates but I’ll do that in my next update here (my apologies if your draft already happened though).

          • Jer
            March 22, 2017 at 11:53 am

            That will be awesome. Draft is this coming Sunday 🙂

  • Reply
    AB
    March 17, 2017 at 3:05 pm

    It looks like quite a few of the DH’s (Encarnacion, Cruz, Trumbo, etc.) aren’t appearing in the Positions tab?

    • Reply
      Luke Gloeckner
      March 17, 2017 at 4:29 pm

      Yeah, that’s correct. The DH doesn’t have a column in the Positions tab at the moment.

  • Reply
    Sly
    March 17, 2017 at 9:42 pm

    I was able to change the position from one player and then the option stopped working. If I select another position for a player I see the sheet trying to compute but nothing changes at the end.

    • Reply
      Luke Gloeckner
      March 19, 2017 at 12:49 pm

      Interesting. I’ll check it out. I haven’t had that happen to me so I’ll have to see what variables might cause something like that for others. I have been travelling this weekend so haven’t had been able to investigate yet.

      • Reply
        Sly
        March 21, 2017 at 6:58 pm

        Ok I found the problem, when you change the position from a player you need to wait for the change to apply, if you click anywhere on the sheet it will cancel the operation.

  • Reply
    Newell
    March 18, 2017 at 10:27 am

    Love your work, thanks!!
    On the Draft Log page, is it possible to shade the cell whenever the draft order is manually changed? It is a minor, if not tiny, thing, however I like that visual reminder that a change in the order is upcoming. There are a fair # of picks involved in our leagues off season trade and if I am able to highlight changes to a draft order in any particular round its a visual reminder to take an extra moment and consider who is making a pick out of order and consider what team/player’s they are known to favour who may not last until a later round.

    • Reply
      Luke Gloeckner
      March 19, 2017 at 12:50 pm

      I like that idea! I’ll add that in for my next update here (I’ve been travelling so haven’t been able to do updates this weekend so I apologize if your draft already happened).

      • Reply
        Newell
        March 20, 2017 at 9:53 pm

        Great, Thanks, and no need to apologize!

    • Reply
      Sly
      March 21, 2017 at 6:42 pm

      Ok I found the problem, when you change the position from a player you need to wait for the change to apply, if you click anywhere on the sheet it will cancel the operation.

  • Reply
    Eric L.
    March 18, 2017 at 12:30 pm

    Currently doing the auction roto draft and the max bid is short by $1 for example…

    Columbus Scharks $52 12 $17 $41

    So 52-11 does equal 41, however, one of those 11 gets an extra dollar to make max bid actually $42

    • Reply
      Chuck
      March 18, 2017 at 12:50 pm

      If you have $52 and 12 players left to get, you can only bid up to $41 on the next player. Then you’d have $11 left for 11 players. If you got that player for $42, you’d have $10 left for 11 players, which doesn’t work.

      • Reply
        Eric L.
        March 18, 2017 at 12:59 pm

        The 12 players that show , however, is the number of players currently drafted, not the number still needed to be drafted. So for a team of 23 players, you subtract the 12 to get 11 players left to draft. Hence, the Max bid is still off. So it’s easy to see…

        Previous example
        Columbus Scharks $52 12 $17 $41

        Current example
        Columbus Scharks $30 13 $18 $20

        As you can see, Avail $ went down, # players went up, Spent went up, Max Bid went down. So now that there are 13 players on the team, only 10 are left to be drafted. Subtract 9 from 30 leaves $21 for the Max Bid.

  • Reply
    Ray
    March 18, 2017 at 3:23 pm

    Obviously Fantastic work!! Couple of issues I see.
    1. – For the Roto Sheets / On the Your Roto Draft Tab / Viewing Options for “Show Werth Values” – Seems to be using the “Show Neither Function” or is not working.
    2. – Looks like your special blend is missing projections for a few players – Carrasco (SP Indians) is noticeable, but see it for a few others.
    3. – Question more than a statement – Related to Settings for Roster Size for Pitchers “P” which is presumably similar for “DH”. When I set that to the Max for our league which is 3 it greatly devalues the Relief Pitchers. However, if I switch it so that figure is 0 and RP is 3 they go to the max. My question is does the Werth based on settings take into cosideration that you could have 3 closers. I suspect not.

    Thanks again!!

    • Reply
      Thanks Very Much!!
      March 18, 2017 at 5:14 pm

      Sorry One More – Ideally in the Roto Draft “Your Roto Draft Column” – You should be able to sort by “Pos Adj WERTH”??

      • Reply
        Luke Gloeckner
        March 19, 2017 at 1:01 pm

        Yeah, I’ve tried to add ability to sort by Pos Adj WERTH buuuut there’s some issues with that. One of the tricky things with these sheets is there’s always a high risk for creating Circular References when doing certain things. Sorting by Pos Adj WERTH is one of those examples. I haven’t had time to address what could get around that Circular Reference to allow for that sorting but it’s on my list, yeah.

    • Reply
      Luke Gloeckner
      March 19, 2017 at 12:59 pm

      Good notes. I’ll check out to see what’s up with the Show WERTH Values. I should be able to fix that fairly quickly when I get a chance. The Special Blend projections cannot project a player if one of the six projections doesn’t have a projection for him so CC and a bunch of closers aren’t included. I may do a version that has some sort of different method for those players but have been swamped with stuff so haven’t had a chance.

      The WERTH values do account for that. It calculates the optimal league starters based on your settings. So, with 12 teams and 5 SP, 1 RP and 3 P… it would go through and plug in the top valued players for 60 SP, 12 RP and the next 36 highest-valued Pitchers and those would be the starters. Replacement-level would be based off that for Position-Adjusted values. Now, the values of course vary based on league settings and roto categories and such.

    • Reply
      Ken
      March 20, 2017 at 11:39 pm

      I am in an auction league, 24 players per team, budget 270, if I bid 247 on player 1 then max bid should show $1, but shows $0 so I think there is an issue there

  • Reply
    Jacob
    March 18, 2017 at 11:10 pm

    I have been using cheatsheets for a coupe of years, but for some reason, I cannot unlock this one. I did just get a new Mac computer last month and can’t figure out how. Can anyone help me out?

    Thank you

    • Reply
      Luke Gloeckner
      March 19, 2017 at 1:01 pm

      Hmmm… Interesting. What do you mean by unlock? What are you trying to do that is not working?

    • Reply
      Thanks!!
      March 20, 2017 at 11:21 am

      Happy to help with the projections if you want, it should be fairly easy to update that to ignore blanks or to develop a proxy if,then,else for proxying a missing projections… – Good News is it only impacts about 20 players – And I really don’t want any of them…

  • Reply
    Patrick Kelly
    March 19, 2017 at 8:01 pm

    Loving using this so far! One question though. I’ve changed the positions for several players on the “Your Points Draft” tab, but they aren’t showing up in those positions in the roster tab. Some of them I changed after the draft started, not sure if that’s the issue or if I’m doing something wrong!

  • Reply
    Wade
    March 20, 2017 at 2:24 pm

    Awesome sheet for a noob to fantasy baseball like myself. Thanks for the hard work! RAY above mentioned “1. – For the Roto Sheets / On the Your Roto Draft Tab / Viewing Options for “Show Werth Values” – Seems to be using the “Show Neither Function” or is not working.”

    I also encountered this issue. It only shows overall and ADJ Werth values, not individual stat Werth values. Then I tried transferring my data from the 1.05 edition over to the 2.0, but the “Show Werth Values” then just gives each player the same Werth values across the board. For example, Miguel Cabrera has 2’s under every category, even Steals, which seems odd.

  • Reply
    Tom
    March 20, 2017 at 3:56 pm

    I keep getting an error message on the Your Roto Auction tab, “Compile error in hidden module: Sheet23” Any tips?

    • Reply
      Tom
      March 20, 2017 at 4:07 pm

      This is on the roto auction cheatsheet

    • Reply
      Luke Gloeckner
      March 20, 2017 at 4:56 pm

      Good catch. I got it fixed, if you download again.

  • Reply
    Hunter
    March 20, 2017 at 5:09 pm

    First off, thanks for all your hard work. I’m having an issue of getting a Compile error in hidden module: Sheet23. Happens when I go to Save and Load and when I click around in the Your Roto Auction. I’m using the Roto Auction Cheatsheet. Any thoughts? Thanks!

    • Reply
      Luke Gloeckner
      March 20, 2017 at 5:11 pm

      I just uploaded a new version about 10 minutes ago that should fix this. Was this in Version 2.10 or 2.11 (I just uploaded 2.11)?

      • Reply
        Hunter
        March 20, 2017 at 5:36 pm

        2.10. Must have downloaded it just before you went to the new version :P. I’ll grab that one then. Thanks so much!

        • Reply
          Luke Gloeckner
          March 20, 2017 at 5:40 pm

          Cool! Let me know if you’re still having troubles with this new one! And, make sure you close out of Excel altogether before opening this new one. If the old one is still open, it may cause some weirdness, I think.

  • Reply
    Hunter
    March 20, 2017 at 5:44 pm

    Can confirm. No errors popping up in 2.11. Thanks again!

  • Reply
    The Hospitaller
    March 20, 2017 at 5:53 pm

    The 2.0 update is tight, Luke. Thanks!

  • Reply
    Chuck
    March 20, 2017 at 7:17 pm

    If you get a chance, could you please add the ability to show total projected stats to the Projected Standings page? I’m pretty we had a choice of stats or points in an earlier version. Right now we can only see the points

  • Reply
    Ethan Koch
    March 21, 2017 at 10:48 am

    Prepping for my divisions dynasty fantasy baseball draft. Stumbled upon this gold mind, and now I’m a believer. This is a great resource. Thank you for your time and energy put into such a great product. I have a question. We get 10 keepers per team this season. Some of the teams decided to keep prospects that are not in the system. How do I account for those players so that way each team has 35 players on the roster? Thanks man!

    • Reply
      Luke Gloeckner
      March 21, 2017 at 3:57 pm

      Good question. You should be able to enter “Unlisted Player” for those teams that have players not in the sheet. I’m going to try to do an update this week that should have some additional players in it but I’m sure you’ll still have some missing so I’d do the Unlisted Player option for those.

      • Reply
        Tony G
        March 22, 2017 at 1:23 pm

        Hi Luke,

        I used the Unlisted Player option (Unlisted Player 1). The “Your Roto Auction” and “Auction Log” updated correctly, however, the Unlisted Player did not get added to the player counts on “Projected Standings” and “Rosters” nor is the $ amount paid being taken into the calculations for amounts remaining and such. Unlisted Player also does not show up in the list on “Teams”
        Thanks again for all your hard work. The more I play around with this, the more I bow down to your Excel prowess. Mr. Excel who?

  • Reply
    Nate Wiltse
    March 21, 2017 at 3:49 pm

    Thanks for all your hard work Luke! I am trying to put this on paper like I have in years past and get rid of a few categories so I can see it all on one page. It’s asking for a password, can you give us this or no?

    • Reply
      Luke Gloeckner
      March 21, 2017 at 4:00 pm

      Are you trying to hide columns on the Draft/Auction page? I believe you should be able to do that. You shouldn’t be able to delete columns though because it’ll break a lot of formulas based on column numbers and such. I guess, what do you specifically mean by “get rid of a few categories”?

      • Reply
        Nate Wiltse
        March 21, 2017 at 4:18 pm

        Just wanted to hide the drafted by column so I can see the 5 category projections. When I try to hide the column it says it’s protected and read only. I never remember having a problem in years past.

        • Reply
          Luke Gloeckner
          March 21, 2017 at 4:26 pm

          Ah, okay. I’ll check it out. I thought I had enabled the ability to hide columns in these 2.0 versions but maybe I missed it.

          • Nate Wiltse
            March 21, 2017 at 4:49 pm

            Looks like it’s just the roto cheatsheet. The others I am able to hide columns.

  • Reply
    Bart
    March 21, 2017 at 4:16 pm

    First of all thank you so much for the time and effort you’ve put into this from the Netherlands! I’ll be playing in a ESPN Head-to-Head: Most Categories league with 12 teams. Can you advise on what scores to enter in the Points Draft Cheatsheet? Should I just put more ‘weight’ on the categories I’d like to emphasize? Keep up the good work, all the best from Holland!

    • Reply
      Luke Gloeckner
      March 21, 2017 at 4:30 pm

      Hi Bart! I’ve always wanted to visit the Netherlands. It looks like a wonderful place. I’m not completely familiar with that league type but I *think* it is a H2H roto league actually. So I’d download the Roto Draft cheatsheet and choose whichever categories your league uses on there! Try that out and let me know if I can further assist.

  • Reply
    Tony G
    March 21, 2017 at 4:26 pm

    I love the excel techniques you deployed here, beyond exceptional. Particularly a fan of the last name alphabetical sort of players in drop down lists, but the format is first name last name. Thank you for your hard work.

    I am having an issue with the pitcher auction values loading in the “Your Roto Auction” wks Projected value columns and the Positions wks Auction value columns for pitchers. Any tips on what settings are preventing these calculations?

    • Reply
      Luke Gloeckner
      March 21, 2017 at 4:45 pm

      Well, first off, thank you! I’m always happy to hear that people can appreciate all of the little things that went into these sheets, even as “minor” as the unique sorting options like that. So, are you saying that the pitcher auction values are not loading on either sheet there? Or am I misunderstanding the issue?

      • Reply
        Tony G
        March 21, 2017 at 4:56 pm

        I went back and read some of the earlier comments and it is tied to the fact that for projections I was using the custom option and included CAIRO projections in there. When I selected a singular projections option, all the projected $ values populated on both sheets. Thank you.

        • Reply
          Luke Gloeckner
          March 21, 2017 at 4:59 pm

          Ahh, yes. I saw some comments about that but I’ve been out of town and haven’t had a chance to really look into that bug yet. Hope to have it fixed ASAP though.

          • Matt
            March 23, 2017 at 1:57 am

            Yeah, i’m seeing blank projected value for pitchers when the projection systems are Fangraphs – Fans, Special Blend, or Custom Combination. I’m not sure it’s tied to CAIRO. Hope this helps.

  • Reply
    Steve
    March 21, 2017 at 10:18 pm

    Do you think you will be creating a Points Auction Cheatsheet this week, based on the # of requests?

  • Reply
    Trevor
    March 21, 2017 at 11:02 pm

    Luke, first off, great work on this spreadsheet! As someone who lives in Excel on a daily basis this is awesome! My league is strange in that it operates on a 26,000,000 budget with 50,000 being the minimum for a player. That being said on the Players tab as well as the Projected Standings tab the number is too large and I get the “#####” in the cell. Same thing if I try to to set the league budget at 26,000 and 50 minimum. I do all that rambling to ask is there a way to unlock those sheets to allow for formatting of column widths or formatting of cells?

    • Reply
      Chuck
      March 22, 2017 at 7:43 am

      Have you tried setting it to $260, and the minimum to $0.50?

      • Reply
        Trevor
        March 22, 2017 at 9:13 am

        Yes, and that works somewhat. Going that route I would like for the number to go out to the first decimal place which would still require some formatting.

        • Reply
          Chuck
          March 22, 2017 at 10:00 am

          Easy enough. Just format the cells, using Currency, and set the number of decimals to whatever you want. I just tested it on v 2.11, and there’s no protection preventing you from doing that.

          • Trevor
            March 22, 2017 at 4:55 pm

            I am still not able to do this on the “Players” tab or the “Projected Standings” tab. I can format the cells on the “Your Roto Auction” which I think is what you are referring to here.

  • Reply
    Will
    March 22, 2017 at 2:21 pm

    Is there a way to add players to the pool of available players to draft? I am in an NL only keeper league, and there are a few keepers and other MILB players that will be drafted that aren’t in the player pool.

    • Reply
      Luke Gloeckner
      March 22, 2017 at 2:25 pm

      Unfortunately not a way to add new players to the pool at the moment. I’d suggest to choose Unlisted Players for the time being if there is somebody you want to put in that aren’t in the sheet (the Unlisted Players should be at the bottom of your sheet or drop-down list of players to draft).

  • Reply
    DAVEN
    March 23, 2017 at 12:42 am

    Hi. First year trying your cheat sheet out. Just curious, is there anyway to add more rounds to the draft section. I play in a 16 man league with 25 rounds. The picks seems to end after pick 327? Am I doing something wrong? Can I update it manually somehow?

    Thanks

    • Reply
      Luke Gloeckner
      March 23, 2017 at 12:45 am

      Which sheet are you using and which page is only showing 327 picks? The Draft Log should go up to 600 picks.

      • Reply
        DAVEN
        March 23, 2017 at 2:24 am

        Oh I figured it out. It didn’t put the keepers in during rounds, it put them in automatically. So the first is effectively our 18th in this case (17 keepers). That makes sense. Thanks.

        Also, is there a way to manually assign draft spots – we had a lot of draft pick trading. For the purpose of a draft only it doesn’t matter, what ever player is picked is a player that I can’t have, but it would have been nice to track who took who during the draft.

        Thank you so much.

        • Reply
          Luke Gloeckner
          March 23, 2017 at 2:31 am

          Yup, you can change draft picks on the Draft Log tab to match up with draft pick trades.

  • Reply
    DAVEN
    March 23, 2017 at 3:39 am

    Thanks so much Luke.

  • Reply
    Chad carreira
    March 23, 2017 at 7:49 am

    Is there a way to assign a draft round value to a keeper?

    • Reply
      Luke Gloeckner
      March 23, 2017 at 10:28 am

      Yes but it’s a little tricky right now. Instead of entering them on the Keeper tab, you’d go to the Draft Log tab and put the keeper into that spot of the draft instead. The spreadsheet logic will know to skip that future pick now. I plan to make that process a little bit easier in the future but that’s the way to go about it for now.

  • Reply
    Andre Newell
    March 23, 2017 at 7:35 pm

    Hi Luke, will you be updating your spreadsheet anytime soon – to account for recent changes like David Price, Carlos Carrasco etc??

    • Reply
      Luke Gloeckner
      March 23, 2017 at 9:20 pm

      I’m working to get an update done for tomorrow! Wish me luck 🙂

      • Reply
        ANDRE NEWELL
        March 23, 2017 at 9:35 pm

        Thanks Luke! I’ve got my draft tomorrow, that would be perfect timing!

  • Reply
    Chuck
    March 23, 2017 at 8:13 pm

    Luke,

    Could you please restore the selection of the total stats on the Projected Standings page for the Auction sheet? Pretty please? With sugar on top? 🙂

    And if you get a chance, could you possibly implement the suggestion I sent you for the Rosters page?

    A donation will be forthcoming soon. (Not to be construed as a bribe)

    • Reply
      Luke Gloeckner
      March 23, 2017 at 9:22 pm

      What was the suggestion about the Rosters page (sorry, I get tons of e-mails every day so it starts to blend together)? If it was freezing the frames, I put that into the 2.20 update the other day (along with the ability to change positions from that page). I’ll check out the Standings issue before the next update, yeah.

      • Reply
        Chuck
        March 23, 2017 at 9:25 pm

        I’ll resend the email to you in the next couple minutes.

  • Reply
    paul
    March 23, 2017 at 9:10 pm

    Hey Luke, these updates have been amazing. Any chance of adding in the Special Blend (including Steamer substitutions) for the points sheet? Much appreciated!!

    • Reply
      Luke Gloeckner
      March 23, 2017 at 9:23 pm

      Yup! Hope to have an update tomorrow with that in it.

  • Reply
    Aaron
    March 23, 2017 at 10:59 pm

    Hey man. Love your work!!! I feel like this has been answered before because it’s so simple, but how do you handle bench positions in the roto draft sheet? Our league has 6 bench positions available.

    • Reply
      Luke Gloeckner
      March 23, 2017 at 11:02 pm

      Hey Aaron. I don’t ask for bench info in the Draft sheets because value is only based on starters so you shouldn’t need to enter that info in! Just your starters!

  • Reply
    Mike F
    March 24, 2017 at 9:34 am

    what is the basis for eligible position in the Points League Excel worksheet? Is there a way to modify defined position for given players. I am especially interested in players labeled as DH. There are multiple draftable players (eg. Encarncian and Pujols) that are assigned DH as a position that can be 1B in our league. As a minimum, is there a way to get a list of all DH designated players. When I go to the Points Draft list and sort by DH, I get every hitter not just those labeled as DH.

    Thanks for all the hard work.

    • Reply
      Luke Gloeckner
      March 24, 2017 at 9:39 am

      To the left of the player’s name, there is a Change Position column. You can use that to change a player’s designated position.

  • Reply
    Jonathan
    March 24, 2017 at 9:46 am

    Hey There, How can I update the ADP Rankings for espn, and fantasypros in the sheet? When I select the different adp rankings they don’t seem to change in the your roto draft tab. Even if I put in custom rankings on that tab they don’t come through on the roto draft page.

    Thoughts?

    • Reply
      Luke Gloeckner
      March 24, 2017 at 9:51 am

      Are you talking about ADP or Rankings because those are two different options in the Settings page. The ADP sites drop-down would change the numbers in the ADP and ADP Rd columns on the Draft page. The Rankings drop-down would change the numbers in the Exp Rank column. Let me know if I’m misunderstanding your question though.

      • Reply
        Jonathan
        March 24, 2017 at 10:00 am

        Was referring to the ADP. It does seem like it’s working, I just reloaded the excel sheet. I see fantasypros and others have updated over the past 72 hrs, anyway I can update the rankings on the back end?

        • Reply
          Luke Gloeckner
          March 24, 2017 at 10:02 am

          I’m working on an update that would have the latest data. Should be up in the next couple hours.

          • Jonathan
            March 24, 2017 at 10:20 am

            Awesome!!! Thanks.

            How difficult would it be to update manually? I am excel savvy ….just curious

        • Reply
          Luke Gloeckner
          March 24, 2017 at 10:23 am

          It would just be a matter of copy/pasting into the Imported ADP page and then choosing Imported ADP on the Settings page.

          • Jonathan
            March 24, 2017 at 10:27 am

            Cool! I don’t see that in my settings in dropdown for ADP in settings. I’ll just wait for the new version to come out for my draft tonight!

            Thanks so much

  • Reply
    Dylan
    March 24, 2017 at 10:28 am

    Hey Luke,

    I’m trying to add an unlisted player to someone’s team. When I click the make pick tab, it updates the auction log and draft tab but it does not add the player to the teams roster or reflect in the budget.

    Love the cheatsheet!

  • Reply
    David
    March 24, 2017 at 5:33 pm

    Thanks for all your hard work! Newbie here. Add the scoring settings of your individual league then edit your league’s pre-draft rankings based WERTH values? WERTH adjusts the player values based on your league category settings? TIA!

    • Reply
      Luke Gloeckner
      March 24, 2017 at 5:37 pm

      Hey David. Thanks for the kind words. The WERTH does change value based on your league settings. It determines what replacement level is for your league and then adjusts player’s values based on that and the scoring settings you choose!

  • Reply
    Mark Chamerlik
    March 27, 2017 at 10:47 am

    Is there a way to add Hit by pitch for batter and Hit batter for pitchers in points league?

    • Reply
      Luke Gloeckner
      March 27, 2017 at 1:13 pm

      HBP is there for batters in the latest version. I’m not sure if I have any projections for HBP for pitchers though… I’ll look into it and let you know if I am able to add it in.

  • Reply
    Seb
    March 31, 2017 at 8:07 am

    Hi Luke, I got my biggest draft on Sunday; do you plan on releasing new versions today or tomorrow..?
    Just to know if I work on the version I have now, or wait and use the new ones.. 🙂
    Keep up the great work!

  • Reply
    Scott Trapani
    March 31, 2017 at 10:10 am

    Is there a password to unprotect each sheet? I am unable to modify.

    • Reply
      Luke Gloeckner
      March 31, 2017 at 12:06 pm

      Hi Scott. You shouldn’t need a password in order to use the sheet. The only things that are protected are cells with formulas that would break the sheet if modified. What are you trying to do in there that you are unable to do without a password?

      • Reply
        Scott Trapani
        March 31, 2017 at 12:17 pm

        I’m trying to enter team names and keeper players into each of the rosters.

        • Reply
          Luke Gloeckner
          March 31, 2017 at 12:20 pm

          Go to the Settings page, type in the Team Name into the Team Names section. Then, go to the Keepers tab and choose the players and teams there and then click the button to assign keepers when you are done.

          • Scott Trapani
            March 31, 2017 at 1:08 pm

            Thanks for explaining. Moving along now. How do I add a player- Miguel sanu?

            Thanks for the help.

          • Luke Gloeckner
            March 31, 2017 at 3:51 pm

            He’s in there though his name is spelled Miguel Sano so if you search for that then you should find him.

    Leave a Reply