One size fits all is bullshit. I’m 5 foot 7, one hundred forty pounds. You mean to tell me the same shirt that’s supposed to fit a dude 6 foot 4, two-sixty is going to fit me comfortably. What in the world does any of this have to do with fantasy baseball? That’s simple. There is no “one size fits all” set of rankings. Think about a league that penalizes you one point when a hitter strikeouts versus a league that does not. This would greatly affect the value of players such as Joey Gallo and Aaron Judge. How does that single set of rankings you’re using from [insert favorite website] account for this difference? Unfortunately it does not. Every, well nearly every, league is different in the points league universe. The number of different combinations of points per stat category is staggering. But at the end of the day there’s only one that matters to you.

This spreadsheet is an attempt to provide you with the most accurate rankings based on your league specific settings. More about that in a moment. Please note these are not projections. They are estimations.

As I play around with different combinations of scoring systems, there are two players that consistently leap frog each other for the top spot. If you like guessing games I’ll give you a clue. One is from New Jersey and the other is from Chesterfield, Missouri. If you were going to try and figure it out, you probably should not read this next sentence where I tell you that the players are Mike Trout and Max Scherzer. Well now that the cat is out of the bag. Wait, why was there a cat in a bag to begin with? Do people keep cats in bags? Never mind. As I focus a bit closer at the numbers, it seems that Trout has the slightest of edges on Scherzer in most points leagues. So if I had to give you a one size fits all rankings it would look something like the following.

Mike Trout
Max Scherzer
Chris Sale
Nolan Arenado
Corey Kluber
Jose Altuve
Mookie Betts
Joey Votto
Clayton Kershaw
Francisco Lindor

Now before you go getting all crazy about that list, keep in mind that it really shouldn’t matter to you. First of all, you have no idea what scoring system on which I am basing those rankings.

I’m going to quote myself from last year.

If you ask an expert for advice on your points league and they don’t ask you what your scoring system is then they are going to give you a mediocre response.” -me

Now I’m going to paraphrase myself from last year.

Circling back to the example in my intro about Joey Gallo for a moment. If you don’t know how many points a league deducts for a strikeout, how can you possible compare Gallo to say Justin Turner. In a league that subtracts one point for a strikeout, Gallo is estimated to score 291 points. Turner is looking at 384, making Turner the better pick. However in a league that does not care about strikeouts, Gallo is estimated to score about 498 points while Turner is 467. See what just happened there. One key takeaway here is that in leagues that do not deduct for whiffs, Gallo should be reasonably considered.

How about a bit of honesty. I make this spreadsheet for one reason. To help myself construct teams on draft day. However, since I love Razzball Nation I share it with you.

With this spreadsheet you have the ability to enter not only your league’s scoring system, but also the number of players you start at each position so that the spreadsheet can customize rankings based on your league specific settings.

The spreadsheet contains a tab for hitters, pitchers and one for each individual position. There is also a worksheet (tab) labeled “Rankings”. This is the sheet that displays the actual rankings. The next tab is the “Settings” tab. This is where you tell the spreadsheet about your league. The spreadsheet comes preloaded with the scoring systems of the major fantasy baseball sites. It also provides the ability for you to enter three separate custom scoring systems. This is where you will enter your league’s scoring system, unless you are using one of the predefined.

Under the “Scoring System” label there is a dropdown that allows you to select the active scoring system to be used by the spreadsheet. When you change scoring systems, or make any other change to the “Settings” tab, you will need to click the “Calculate Rankings” button to generate the new rankings and update (re-sort) each sheet. When the spreadsheet detects a change to the “Settings” tab it will let you know and tell you to click the “Calculate Rankings” button when you are done making changes. This is a difference from last year. Last year’s version automatically recalculated the rankings after every change. I found this to cause the spreadsheet to perform poorly. Now you have to click a button. If that bothers you, close the spreadsheet, right-click, and select “delete”. Problem solved.

The “Settings” tab will also allow you to specify the number of teams in your league, the number of players on each team and the number of players that are started at each position. I need this data in order to figure out the replacement level player at each position in order to generate the position-adjusted rankings.

At the bottom of the “Settings” tab you will see two options that directly affect the ranking results. The first is “Reduce RP Weight“. By default my rankings treat the RP position equal to the rest of the positions. As a result, you will see some RP in the top twenty. While mathematically this might be the case, in reality it doesn’t make sense to draft even an elite RP in the first two or three rounds (maybe more). But my spreadsheet isn’t human and doesn’t think like an irrational baseball fan. Everything is a one or a zero as far as it’s concerned, and the numbers say that Kenley Jensen has first round-ish value. By setting “Reduce RP Weight” to true my algorithm will lower the FVARz scores for relief pitchers, pushing them down a bit in the overall position-adjusted rankings. This feature is enabled by default.

The second is the “Hitters Advantage” option. Here’s what this does. When set to “yes” it will give all hitters a slight boost. It actually accomplishes this by giving all starting pitchers a slight reduction. This does not apply to relief pitchers. You can use “Reduce RP Weight” for that cause. The reason for this feature is because it is a popular strategy to draft strong hitters by focusing on the hitters in the early rounds. Many believe hitters win championships because hitters are more consistent. If you feel this way, or something like it, set “Hitters Advantage” to “yes”. It defaults to “no”.

New this year is a tab labeled “Your Team“. This will begin empty. You’ll find a section for hitters and pitchers. Each section will have headers and rows for totals and averages. These will likely contain zeros and #DIV/0! initially. Don’t worry, this is fine and expected. They will go away once you add players.

How do you add players? I’m glad I pretended you asked. On the “Rankings” worksheet (tab), you will see a column labeled “Drafted” at the far right. Initially it should be filled with the number zero (0). This means that the player has not yet been drafted. I’m hoping this spreadsheet can help a bit more on draft day. As your draft is taking place and players are being selected, you can manually update this column for the appropriate players. If they are drafted by another team, enter the number one (1). If they are drafted by you, enter the number two (2). This will result in the players being color coded and will also automatically move your players to the “Your Team” tab.

Clicking the “Clear Draft Picks” button will set all values in the “Drafted” column back to zero (0). You cannot undo this action.

Before I explain a bit more about the “Your Team” tab, let me quickly mention the “Draft Score” column on the “Rankings” sheet. This value is determined by subtracting a player’s rank from his ADP. For example, if Francisco Lindor is ranked 9th and his ADP is 25, he will have a “Draft Score” of 16. Here’s what that means. It means that if you drafted Lindor at his ADP of 25, you’d be getting him 16 picks after where he would be picked if everyone in your league picked based on your league-specific rankings.

This does not mean you should take Lindor with the 9th or 10th pick, but it serves as a gauge to let you know what kind of value you are getting from a player based on his true ranking and where he is to be drafted. In the curious case of Lindor, I’d definitely grab him in the second round.

Players with a negative “Draft Score” mean that if you draft them at their ADP, you are not getting good value. They will not be on any of my teams. Not unless they slip into a more profitable draft position.

Back to the “Your Team” tab. This is where you can see the players you have marked as drafted to your team. That means you entered a “2” (no quotes) in the players “Drafted” column on the “Rankings” tab.

Modifying Estimations

If you feel the urge to modify a player’s estimation, you will need to do so in two places. Let’s say you are convinced that Rhys Hoskins is going to hit 50 home runs. You need to edit his HR total on both the “Hitters” and “1B” sheets. And since Hoskins is listed as having OF eligibility you will also have to update the “OF” tab. Unfortunately I did not have the time to sync these up automatically.

Again, back to the “Your Team” tab. As players are added the “Totals” and “Averages” rows will populate. Also, each player’s FPTS (fantasy points) column will be highlighted with one of the following colors: Green, Purple, Orange or Red. Here’s what they mean. Green indicates that the current player is estimated to score a decent amount of more points than the average player. The set of players used in this comparison is only players that are above the replacement level player.

Green: A fair amount better than average
Purple: Pretty much about average. Maybe a little over
Orange: Less than average
Red: A fair amount less than average

Keep in mind that these are experimental indicators.

If there was one bit of advice I could give you it would be this. Notice this is in bold. Do not change anything on any tabs other than “Settings” and “Rankings”. On the “Settings” tab enter your league details. Then click “Calculate Rankings”. Then go to the “Rankings” tab. Here you can indicate which players have been drafted. That’s all you need to do. If you start making changes and end up in some funky state, you should just download a fresh copy and start over.

While you can set multiple (up to three) different custom scoring systems, if you are going to use this on draft day, I suggest you create a copy of the file for each different league. It’s will just be a lot simpler to keep track of each league’s drafted players.

If you find an issue, please let me know. If you realize that a player is missing (entirely possible), let me know.

I hope this spreadsheet can bring you one step closer to a championship. In the meantime, have fun watching The Walking Dead while playing around with this spreadsheet.

Wisdom, Power and Courage!

malamoney’s 2018 Points League Spreadsheet

 

 

Follow me on Twitter at @malamoney

   
  1. Steve Kooker says:
    (link)

    Great job!

    Our points league also is a keeper league (7 keepers) and an auction league.

    All you need for perfection (for me) is a spreadsheet that will inflate auction values after keepers are factored in. I would pay money for this.

    Thank you for all you do for us in points leagues!

    • malamoney

      malamoney says:
      (link)

      @Steve Kooker: I do have a spreadsheet for auction values, but it’s not something I share or sell. As far as not auction drafts are concerned, there are two schools of thought here. At least in my mind.

      You could just delete the keepers from the player pool. Meaning delete them from the spreadsheet. This will recalculate FVARz for everyone.

      Or you don’t do anything because even though they are kept, there is really no difference from being kept and drafted other than the fact that you had no chance to actually draft them…

  2. Stickball Al says:
    (link)

    I belong to a H2H 12 man money league that deducts -1 point for a strikeout in our league. When you look to draft players you look first at K’s vs BB. If you subtract the BB from the K’s and it go’s over a 100 then those players are almost useless. Before you even start the season the player is minus 100 fanasty points. Only elite players who hit for power and average, despite the K’s are useful. So that eliminates 20% of the player pool. I actually won this league last year and still lobbied the league to make K’s -1/2 point instead so we could use these other players. Got shut down though.

    • malamoney

      malamoney says:
      (link)

      @Stickball Al: Yes, K-BB is one of the metrics I use for players. It is very useful. I think strikeouts should be minus one full point. Making it just a half point to make those players more useful seems wrong to me. Why not making stolen bases 2 or 3 points so that guys like Billy Hamilton are usable. I like having “useless” players in the pool. If you can identify them, as you have, you just avoid them. And when you opponents draft one of them, you just sit back and laugh. Great comment!

      • Stickball Al says:
        (link)

        @malamoney: You are so right about that. We just had our draft yesterday and every time someone drafted one of those guys I said a silent “Thank You” under my breath…

    • Disenfranchised says:
      (link)

      @Stickball Al: IMO, Ks shouldn’t be a factor unless the aim is to differentiate the quality of a PA based on BBs and Ks. Then the scoring should be focused on giving a + or – score based on the average player. The last time I checked the average BB:K ratio was about 1 BB to 4 Ks so a scoring system based on that would be 1 pt per BB and – 0.25 per K. Otherwise I don’t overly understand why people want to penalize a K. It’s just an out.

      • malamoney

        malamoney says:
        (link)

        @Disenfranchised: A strikeout is pretty much the worst out you can make. It’s entirely unproductive. You don’t advance the runners. Making a strikeout -0.25 because the BB:K ratio average is about 1:4 doesn’t seem right to me either. Why are we normalizing the strikeout with respect to the walk?

        • Disenfranchised says:
          (link)

          @malamoney: It’s not the worst out though, GIDP is.

          How often is an out based on contact actually productive too? You’re making assumptions that someone will even be on base. And you’re also probably not including all the possible outcomes, like IFF and foul flyouts.

          To say a K is 1 whole point worse than an out is extreme, imo. First, Ks and walks somewhat go hand in hand as indicators of plate discipline and pitch recognition ability. Taking away 1 point for a K totally negates the ability to draw a walk and in a lot of cases can totally negate some singles. That is why I prefer normalizing K to BBs.

          • malamoney

            malamoney says:
            (link)

            @Disenfranchised: I’m going to have to think about this a bit deeper. I will definitely get back to you and might do a whole post about this. Thanks for the solid comments!

        • The Harrow says:
          (link)

          @malamoney: this also isn’t true, an eye of .25 (BB to K ratio) isn’t league average, certainly if he’s saying it is where is he getting that. i DO like the idea of normalizing this to league average though.

          • malamoney

            malamoney says:
            (link)

            @The Harrow: Like I said, I like this topic and plan to dive into it with a full post. I don’t want to rush and not do it justice with a quick comment here…

            • The Harrow says:
              (link)

              @malamoney: of course. i was critiquing his claim that a batting eye of .25 is “league average” which was HIS claim, sorry i put the response to you.

              • malamoney

                malamoney says:
                (link)

                @The Harrow: All good…

  3. rob.mack says:
    (link)

    Thank you so much for this. This post is Christmas Day and it is certainly the best present.

    • malamoney

      malamoney says:
      (link)

      @rob.mack: Well then… Merry Christmas. Although I prefer “Happy Points League Day”…

  4. Jason Morgan says:
    (link)

    Awesome. My favorite post of the year. This spreadsheet is invaluable to points league players. I just hope the rest of my league doesn’t know about it…

    • malamoney

      malamoney says:
      (link)

      @Jason Morgan: Thanks man. Hope it helps. Great to see the real Jason Morgan back in action on GH.

  5. Von Hayes says:
    (link)

    Dude, thanks for this, nice work

    • malamoney

      malamoney says:
      (link)

      @Von Hayes: You’re welcome. Good luck!

  6. Steven says:
    (link)

    One question concerning a custom scoring setting. Once the rankings get readjusted, how Should you view someone’s draft score vs their fvarz? Which stat should carry more importance when deciding whom to draft?

    • malamoney

      malamoney says:
      (link)

      @Steven: FVARz dictates a player’s value compared to the rest of the players. So when choosing between two players, use FVARz. Draft score is just indicator as to whether you are getting good value at the pick. However, I’d always take the player with the higher FVARz regardless of draft score.

      However, we shouldn’t ignore FTPS (fantasy points) as this is ultimate stat. FVARz allows you to compare players across positions. A catcher that is estimated to score less FPTS than a 1B might still have a higher FVARz because of position scarcity. It would probably be better to skip on Anthony Rizzo and take Buster Posey and then grab Edwin Encarnacion two rounds later. The difference between Rizzo and Encarnacion will be slimmer than Posey and let’s say Yadier Molina. It’s really a balancing act.

      What I really use draft score is to make sure I draft a player while his draft score is still positive. So if Chris Archer has an ADP of 53 and a ranking of 30, that means he has an initial draft score of 23. If you pick him in with the 4th pick of the 4th round of a 12-team league, you have drafted Archer with the 40th overall pick. That means his final draft score was +10 and that’s good. That means you got him ten picks after where he should have been picked if everyone was drafting based on your league specific rankings.

      Hope this helps.

  7. AL KOHOLIC says:
    (link)

    great job thanks

    • malamoney

      malamoney says:
      (link)

      @AL KOHOLIC: Thanks. Hope it helps…

  8. Bluemeenie says:
    (link)

    Malamoney,

    My league has 18 teams but your spread sheet only goes up to 16. How can I update it for the extra 2 teams.

    Also we are a keeper league so I am just going to assume that I need to mark a 1 for the players already reserved on the other teams so I get my best options for what is available.

    Thanks in advace.
    Bluemeenie

    • Bluemeenie says:
      (link)

      @Bluemeenie: I also noticed you don’t have anything for No-hitters or Perfect Games or Releif Wins. If I wanted to add that how would I go about it?

      • malamoney

        malamoney says:
        (link)

        @Bluemeenie: I don’t include stat categories that are are impossible to predict such as NH and PG. Relief wins would be the wins column for RP. If you are saying the relief wins are not equal to the same number of points as a starter win, well you can’t using that spreadsheet.

        This spreadsheet covers nearly all the bases. Are there some league characteristics that it doesn’t sure, but it’s not too bad for a free tool.

        As for the 18 teams, if you send me an email at [email protected], I can send you a version that will support 18 teams.

  9. Shivdaddy says:
    (link)

    Happy Points Day! I was just looking at phone and saw you post on Twitter it’s up! Thanks again Malamoney!

    • malamoney

      malamoney says:
      (link)

      @Shivdaddy: No problem Shivdaddy!

  10. TheConsigliere says:
    (link)

    Hi malamoney, thanks heaps for this! I guess the key question is what projections are you using as the base for your spreadsheet? Is it your own projections or are you using a particular set of projections like Steamer etc?

    • malamoney

      malamoney says:
      (link)

      @TheConsigliere: Great question as I forgot to mention this. Here’s what I do. I generate my own projections/estimations. Then I take those projections and average them with 8 other trusted projections sources. Then I take that averaged results and average it once more with my original projections to give mine more weight and the final result is what you see in the spreadsheet.

  11. Justin says:
    (link)

    Thank you very much for all the great work you do. There really is no other resource like this for points leagues out there on the internet.

    I am in a league where we start 3 starting pitchers and 1 relief pitcher and that is all for pitcher spots. Our lineups also lock weekly. Our pitchers get 2.5 for a win, 5 for QS and -2.5 for a loss, 2 for K and -1 BB, -1ER. Our hitting is your standard 1 for 1B, 2 for 2B, 3 for 3B and 4 for HR, -1 for K, 1 for BB, 2 for steal, -1 Caught stealing.

    Would the fact that our lineup locks weekly and we can only start 3 SP per week affect your draft strategy? Like if I have the choice between the elite hitter like Arenado, Betts, Votto, Altuve or a pitcher like Kluber, Kershaw or Sale would you lean towards the elite pitching over hitting in this type of format?

    Thanks in advance your response! I have only played fantasy baseball for a couple years so I am just now learning about how much variability there is between all the different types of formats and this site has helped me immensely.

    • malamoney

      malamoney says:
      (link)

      @Justin: You’re welcome. Just need to clarify a few things?

      1. Do pitchers get any points for IP?
      2. How many teams in your league?
      3. How many players do you start at each hitter position?

      • justin says:
        (link)

        1. We get 1.5 per inning pitched (so .5 per out),

        2. We have 10 teams in our league.

        3. We have 11 batter spots. 1 C, 1 1B, 1 2B, 1 3B, 1 SS, 1 IF (can be any type of infielder), 4 OF, 1 UTL. Our rosters are a total of 20 players so we have 5 bench spots available.

        Thank you again!

        • malamoney

          malamoney says:
          (link)

          @justin: My strategy is the same in every league. Pick the player that is going to best help my team. I know, what does that really mean.

          FVARz dictates a player’s value compared to the rest of the players. So when choosing between two players, use FVARz. However, we shouldn’t ignore FTPS (fantasy points) as this is ultimate stat.

          At the end of the day you need to fill every roster spot on your team. The most important ones are the starting spots. So just because you only start 3 SP doesn’t make any of those SP spots more important than your starting 2B for example. You want to fill both (all) starting spots with the best players possible. When it’s my turn to pick I look for the best player available at a position for which I have not already drafted a player.

          If you think about your question about is drafting an SP more important in your league because you only start 3 SPs. Well wouldn’t the same line of thinking have you asking if drafting a catcher was more important since you only start one, making it super important to get Posey or Sanchez. There is an argument to be made there which is why you will see Posey near the top of the rankings. By drafting Posey, you are giving yourself a big leg up a one position (catcher) over the rest of the teams in your league.

          One thing I will say is that your scoring system is heavily skewed towards pitchers. Unless you forgot to tell me about some missing points, I see that Chris Sale is estimated to score 837 points while Trout is at 334. That is pretty uneven.

          However, according to my rankings, Trout is the top ranked player in your league. How can this be? That’s because compared to the rest of the outfielders, the difference between him and the rest of the OF is more impactful.

          At the end of the day, unless there is a crazy run of players being drafted at the same position between your picks, the difference between a player at one position and the next ranked player at the same position will likely be similar across positions.

          • justin says:
            (link)

            Sounds good thanks for taking the time to reply.

            I should have mentioned our entire hitting system is 1-1B, 2-2B, 3-3B, 4-HR, 1-RBI, 1 for run, 1-BB, -1 for K. So last year to give an example Joey Votto and Charlie Blackmon were the two best hitters at 625 and 605 Points. The top 2 pitchers last yr for our league were Chris Sale at 882.5 and Kluber at859 Points.

            We also give bonus points for hitting a grand slam, the cycle, errors and outfield assists and game winning RBI but those are random stats that are hard to predict on a year to year basis.

            This year Trout is predicted at 557(with our hitter scoring system) using your spreadsheet so without those random “bonus” stats being factored in I would say your spreadsheet is a pretty accurate model and predictor of fantasy stats!

            I do agree our system is too skewed still towards pitching and I have mentioned that. I feel decreasing k’s for pitchers to 1.5 or 1 instead of 2 will bring things more in line a bit across all positions.

            Thanks for the advice, I look forward to reading your weekly articles throughout the season!

            • malamoney

              malamoney says:
              (link)

              @justin: Any time. Yeah, I’d definitely drop pitcher strikeouts to 1 point.

              Good luck. And if you have any topics you’d like me to address, let me know and I will try my best.

  12. Blake says:
    (link)

    I have 7 slots for pitchers – doesn’t matter if they are starting pitchers or relief pitchers. I can start whoever, I get 15 pts for a W, 7 pts for a S and 1 pt for SO’s. How do I rank pitchers using your spreadsheet? you have the RP and SP …

    • malamoney

      malamoney says:
      (link)

      @Blake: Yeah, unfortunately that is not supported. Let me take a look at what it would take do support it…

      • Blake says:
        (link)

        @malamoney:

        so use favrz to draft based on value? I have always been told not to draft those top pitchers early. in your rankings most of the top 10 pitchers are really high.

        Do I just use ADP and then fvarz so I know when to draft? especially when drafting for value?

        • malamoney

          malamoney says:
          (link)

          @Blake: I used a combination of my rankings and ADP. Let’s say my rankings say that Stephen Strasburg is ranked 15th, meaning he should be picked 15th, but his ADP is 40. This is just a made up example. Well I’m not going to take him with the 15th pick just because my rankings say so. I will take him with around pick 30 to make sure I get him and when I do, I know that I got him at a bargain since technically he should have been picked 15th.

          This is where “draft score” can help.

          As for not drafting pitchers early, was this advice for a H2H points league?

          But if you really want to focus on hitters early on, then I suggest you enable the “Hitters Advantage” feature on the “Settings” tab. This will give hitters a boost in the rankings…

          • Blake says:
            (link)

            @malamoney:

            I guess what I am saying – wont pitchers like Servino, Ray, carlos Martinez, verlander and darvish put comparable numbers as the pitchers above them but can get them much later?

            • malamoney

              malamoney says:
              (link)

              @Blake: Yes they will. Or at least some of them will. I will not own any of the main four (Scherzer, Sale, Kluber or Kershaw) because I will be taking hitters. That’s because of two reasons.

              1. Hitters are more consistent
              2. I can hopefully get two of the guys you mention above

              • Blake says:
                (link)

                @malamoney:

                So even though those pitchers are ranked where they are and you could get them a the proper draft slot – ie, if one of them is ranked 8 overall and when your turn comes around at 8, you would not draft them?

                I have done this the last 4 years where I load up on hitters until round 3 or 4 and get then get a pitcher. however, my hitters haven’t come around. My league settings are:

                1B-1pt
                2b-2pts
                3b-3pts
                HR-4pts
                R-1pt
                RBI-1pt
                BB-1pt
                SB-1pt

                W-15pts
                S-7pts
                SO-1pt
                CG-5pts

                no negative pts – so judge I guess should be ranked higher?

                • Blake says:
                  (link)

                  @Blake: \\i

                  I have finished in the mid pack each year, also – I only get 15 pickups all year.

                • malamoney

                  malamoney says:
                  (link)

                  @Blake: I’m probably not drafting a pitcher in the first round because there will be a hitter close enough in ranking value.

                  If part of your strategy is to lean on hitters early, then enable the “Hitters Advantage” feature on the “Settings” tab…

      • Blake says:
        (link)

        @malamoney:

        and HOT Rod did a spreadsheet much like yours – what is the difference?

        • malamoney

          malamoney says:
          (link)

          @Blake: I am not familiar with Hot Rod’s spreadsheet. Can you send me a link?

            • malamoney

              malamoney says:
              (link)

              @Blake: Oh, the War Room. If I’m being honest I really haven’t played with it much. I just gave it a look at it seems like it calculates each player’s points based on a customizable scoring system. However, and I could be wrong, it doesn’t calculate rankings. I do see a column labeled “PTS_TOT_RANK”, but it has Jose Ramirez as number one and I can’t see that being the case in any format. But as I said, I haven’t really played around with it.

              Use them both and decide for yourself…

      • Blake says:
        (link)

        @malamoney:

        too much tinkering to fix this issue? do I hit reduce RP weight? I don’t do that because all we care about it points, right? or RP to unpredictable?

        • malamoney

          malamoney says:
          (link)

          @Blake: What issue?

          Aside from the stud RP, there is often enough turn over at RP each year to be able to grab more than one more than serviceable RP off waivers. Even though, based on the numbers, a guy like Kenley Jensen is that high ranked, I’m still not going to end up drafting him. I always enable the “Reduce RP Weight” feature.

          • Blake says:
            (link)

            @malamoney:

            Sorry – I can start 7 pitchers regardless of SP or RP. So how would I adjust the rankings for that?

  13. Charles says:
    (link)

    Am I doing something wrong?
    The settings tab is protected and can’t be unprotected without a password.
    My CBS settings are a bit different than the default so I’d like to alter a few.
    Thanks!

    • malamoney

      malamoney says:
      (link)

      @Charles: Nope, that is expected. Use one of the rows labeled “Custom Scoring”.

      Then be sure to set the “Scoring System” dropdown to choose that one…

      • Charles says:
        (link)

        @malamoney: Wow i’m an idiot. Thanks for your amazing work, going for 3 years in a row and your spreadsheets have been my gold source

        • malamoney

          malamoney says:
          (link)

          @Charles: No worries. Here’s to a three-peat!!!

  14. Jekuthiel says:
    (link)

    Thank you Malamoney for your time and work!! I have used this the last two years and have won my league and made the playoffs both times.

    Also, I did click on your link for your league, but it said not found. Did you fill up?

    By the way just to brag a little, I am in a keeper league that keeps 4. I am keeping Jose Altuve, Nolan Arenado, Mookie Betts, and Max Sherzer. Pretty good start!

  15. Bobby McGee says:
    (link)

    This is fantastic. Thank you! I’m new to Razzball but digging it already! Quick question that I may have missed above: where are the projections that the custom rankings are based on coming from? one of the projection systems? your own? is last year waited very heavily? for instance, Syndergaaaaaaard seems much lower than I’d think.
    Thanks again.

    • Bobby McGee says:
      (link)

      @Bobby McGee: weighted, not “waited”. D’oh.

    • malamoney

      malamoney says:
      (link)

      @Bobby McGee: Seems I forgot to mention this. Here’s what I do. I generate my own projections/estimations. Then I take those projections and average them with 8 other trusted projections sources. Then I take that averaged results and average it once more with my original projections to give mine more weight and the final result is what you see in the spreadsheet.

      • Bobby McGee says:
        (link)

        @malamoney: thanks for the quick reply! now if you can only average in something that will justify me considering Thor at 19 overall, lol.

        • malamoney

          malamoney says:
          (link)

          @Bobby McGee: You could manually edit his projections if you think they are low…

          • Bobby McGee says:
            (link)

            @malamoney: nah, that was just a joke based on my previous comment. Plus, the reason I really appreciate this is b/c a dope like me with no excel skills is able to use this spreadsheet. Thanks again, good luck this season.

            • malamoney

              malamoney says:
              (link)

              @Bobby McGee: We are all dopes. Just at varying degrees on different topics. I’m actually not much of an Excel person. I’m a software engineer that was able to stumble his way through writing some VBA macros to do what I needed. If I had the time I’d make this a web app.

              Good luck and let me know if you have any questions…

  16. brian says:
    (link)

    This is an awesome resource. I’ll definitely be using this on draft day and research leading up to it. Thanks.

    • malamoney

      malamoney says:
      (link)

      @brian: You’re welcome. Good luck. And let me know if you have any questions…

  17. Thatguy says:
    (link)

    this is awesome. Cant wait to use this spreadsheet for my draft! Another job well done sir

    • malamoney

      malamoney says:
      (link)

      @Thatguy: Thanks. That means a lot coming from “that guy”…

  18. Thatguy says:
    (link)

    never in my life did i think i’d see Gary Sanchez sandwiched in between Kershaw and Arenado but according to FVARz that right where he is

    • malamoney

      malamoney says:
      (link)

      @Thatguy: What are you league settings that generate that?

  19. Von Hayes says:
    (link)

    Hey all, I have a new league idea, wondering if anyone can help. The idea is that it would be a 10 team h2h points league, but an auction, and also you’d draft an AL- and NL-only team. It would operate as 2 leagues essentially, an AL and an NL. The top 4 would go to the playoffs in each league, culminating in the World Series between the two league champs. I’ve been a CBS guy for almost 20 years and pretty sure this wouldn’t work with them. Anyone know if a format exists like this or a site that might support it? Thanks!

    • malamoney

      malamoney says:
      (link)

      @Von Hayes: I actually did this a bunch of years back, but it was a very manual process…

      • Von Hayes says:
        (link)

        @malamoney: Was there a site that allowed you to draft 2 teams? We did it through onroto a few years ago but it was just roto scoring not head to head. Your category points combined from both leagues.

        • malamoney

          malamoney says:
          (link)

          @Von Hayes: No. I setup two separate leagues. When the playoffs came around the World Series matchup wasn’t in one league. You had to go to each league to see how each team was doing. But the concept worked…

          • Von Hayes says:
            (link)

            @malamoney: Cool makes sense, I’d have to choose a free site to avoid the double fee, thanks man.

            • malamoney

              malamoney says:
              (link)

              @Von Hayes: No problem. Let me know how it goes. I thought about resurrecting my league, but I’m just too busy. When I did it several years back it was a cool idea. Still is…

  20. Brian Chrzanowski says:
    (link)

    I have 12th pick in 12 team, most standard categories. Quick question. Who would be my better 1st pick? Correa or Machado?

    • malamoney

      malamoney says:
      (link)

      @Brian Chrzanowski: I’d go with Machado. My spreadsheet might have Correa ranked a little bit higher, but that’s based on position scarcity. It looks like Machado will be playing SS so once he’s SS eligible that would actually put him ahead of Correa. Plus he’d be dual position eligible at that point…

  21. Shivdaddy says:
    (link)

    Hey Malamoney,

    How do you take away a players position elgibility (for the purpose of FVARz & Z-Score recalculating) ? Matt Carpenter only has 1B eligibility at CBS yet he qualifies for multiple positions. If it is a long process just say so and dont waste your time explaining it =P. Thanks!

    • malamoney

      malamoney says:
      (link)

      @Shivdaddy: To do it pixel perfect it would be a bunch of work. But you really don’t need to. When I created the “Rankings” sheet I deleted duplicate players. Duplicate players happen when a player is eligible at multiple positions because I cut and paste each position page into the “Rankings” page. Then I sort by name and remove dupes.

      His value is going to be somewhat similar. I will look at it and see what it would take to get ‘er done…

  22. Macio says:
    (link)

    Wow, this is incredible stuff! Can’t thank you enough for your time on this. I read through the above comments. My only question is the Rank vs. FPTS columns. Come draft time, should I sort via FPTS since that is the primary adjustment based on my scoring system?

    • malamoney

      malamoney says:
      (link)

      @Macio: Thanks. I would sort by “rank” which correlates to the FVARz column. That is how I ultimately determine overall position adjusted rankings.

      When you do this you will see players ranked below others that are estimated to score more points that the higher ranked player. This is because each players FVARz is based on the replacement level player at his position.

      Now this doesn’t mean that drafting the lower ranked player that is estimated to score more points is the wrong or right move. It all depends on a couple of factors. I think the biggest factor is who have you already drafted. I like to fill my starting spots with the best players available at each position. So when it’s my turn to pick I find the highest ranked player at a position I do no currently have a player. But, at the same time, if there is a stud 1B sitting there for some reason and I already have a 1B, I’ll probably grab him.

      Hope this helps…

      • Macio says:
        (link)

        This is really helpful. Thanks again for all your time on this.

        • malamoney

          malamoney says:
          (link)

          @Macio: You are welcome…

  23. Mikey says:
    (link)

    Great stuff, Malamoney. I used at last year’s draft and had great results. I was wondering how I should “Define Starters” for my NL-only league. For example, the active weekly lineup is 16; 10 Hitters: 1-C, 1-1B, 1-2B, 1-3B, 1-SS, 3-OF’s + 2DHs (any fielding position), 6 Pitchers: 3-SP, 2-RP, 1SP or RP. Will leave the draft with 26 players (Roster Size) but will be able to pick up two players off the wire during the season.

    Also, since I don’t draft for another week or so will player projections/stats be updated between now and then, especially since position battles will have been determined, etc.?

    • malamoney

      malamoney says:
      (link)

      @Mikey: There is currently isn’t a way to do AL or NL-only. However, I am looking into it. Technically you could just delete all of the AL players, but that might take you some time. And it would get messy. I don’t recommend trying that.

      I am also seeing how to add support for the P (SP or RP) position.

      As for projection updates perhaps I will release an updated version next week, but it’s not something I plan to do regularly as it’s a lot of work in spreadsheet form.

      I will keep you posted…

      • Mikey says:
        (link)

        @malamoney: Thank you. Again, great stuff as always.

        • malamoney

          malamoney says:
          (link)

          @Mikey: Thanks.

  24. S.Head says:
    (link)

    My points league just shifted to a daily moves league. We can make one transaction a week as well as shuffle in and out the three players from our bench. Also, there is a 15 start cap for our 5sp/1rp pitching staff.
    5pt per W and 5pt per QS, everything else pretty standard.
    Do I go SP heavy to maximize matchups or draft quality SPs and get some closers to fill the empty slots on a daily basis.

    • malamoney

      malamoney says:
      (link)

      @S.Head: Well I’d certainly be trying to make sure I hit that 15 starts per week to maximize points. I hate the whole quality starts stat, but at 5 points per, you want to try and nail as many of those as you can.

      If you go SP heavy then you are likely sacrificing bats. I’d go quality SP.

      You can put closers in your SP spots?

      • S.Head says:
        (link)

        @malamoney: yep. I can put closers in those spots, but that could make hitting the 15 starts a bit tricky.

        • malamoney

          malamoney says:
          (link)

          @S.Head: How is that allowed? If the position is “SP”, how can you put an “RP” there? Or is the position actually “P”?

          • S.head says:
            (link)

            @malamoney: it’s a p

  25. MD says:
    (link)

    Your WHIP column looks off (way too high)….I think you can back into the right # using the BBs, H and IP columns. Unless I’m completely off one what WHIP means, not sure how anyone can have WHIP at 41.45 (Max Scherzer). etc.

    Might want to address and re-upload for benefits of those using the sheet. Thanks for putting together!

    • malamoney

      malamoney says:
      (link)

      @MD: You are correct. I will get it updated as soon as I can.

      Fortunately the WHIP column has no bearing on points leagues. Walks, hits and IP do, but those are correct in their individual columns.

      Thanks for pointing this out…

  26. Ron says:
    (link)

    Awesome job on this! Seriously. I have a question and it mostly has to do with the terrible league I’m in. So it’s a 12 team, h-2-h points league where the hitter are vastly overvalued over the pitchers. For instance, according to your spreadsheet with my league settings, Charlie Blackmon scored 1,000 points last year while Max Scherzer only scored 400. I know it’s horrible but aside from a hostile takeover of the points system or fleeing the league altogether I’m not sure how to value pitchers here. Is it worth drafting a pitcher in the first 5 rounds?? The spreadsheet has Chris Sale as the number one player off the board but he’s going to score 600 points less than Trout! Help!

    • malamoney

      malamoney says:
      (link)

      @Ron: Well it has to do with how many points Sale will score compared to the next bunch of hitters. And for hitters, it’s actually the next bunch of hitters at the same position. And to get more precise it’s really relative to the number of points that replacement player will score at each position.

      I’m guessing Posey is ranked high too?

      The reason is because by drafting Sale or Posey you are giving yourself I nice advantage at those positions. If you don’t get one of the top 3 hitters, the next 10 are all still relatively good. The gap is likely not as big. And those next 10 are also still a lot better than the replacement player.

  27. mark says:
    (link)

    Slap ya mama this is awesome! Found it not a minute too late.. drafting tonight in 3 hours!

    Couple questions:

    1. Is FPTS 2018 projections or 2017 points?
    2. What is FVARz?
    3. Can you provide a little more strategy around using the draft score? Should I just use it as a tie breaker between 2 players? Should I simply target the highest value draft scores and avoid all negative ones? How do you factor that score into your personal drafting?

    Thanks a ton bud!

    Mark

    • malamoney

      malamoney says:
      (link)

      @mark: See below…

  28. mark lowen says:
    (link)

    Slap ya mama this is awesome! Found it not a minute too late.. drafting tonight in 3 hours!

    Couple questions:

    1. Is FPTS 2018 projections or 2017 points?
    2. What is FVARz?
    3. Can you provide a little more strategy around using the draft score? Should I just use it as a tie breaker between 2 players? Should I simply target the highest value draft scores and avoid all negative ones? How do you factor that score into your personal drafting?

    Thanks a ton bud!

    Mark

    • malamoney

      malamoney says:
      (link)

      @mark lowen: Thanks!

      1. It’s 2018 projections. There’s a separate tab for Hitters 2017 and Pitchers 2017

      2. It stands for fantasy value above replacement. It shows how much more value a player is than the replacement player at his primary position. The replacement player is considered the player that you would find on the wire. A simple example is if you are in a 10-team league and you start only one 2B, then your league really only cares about 10 second basemen. The 11th 2B is considered the replacement 2B. It’s a little more complicated than that in that we probably care about 12 second basemen, but it should give you the idea.

      3. Stealing my answer from another comment on this one.

      FVARz dictates a player’s value compared to the rest of the players. So when choosing between two players, use FVARz. Draft score is just indicator as to whether you are getting good value at the pick. However, I’d always take the player with the higher FVARz regardless of draft score.

      However, we shouldn’t ignore FTPS (fantasy points) as this is ultimate stat. FVARz allows you to compare players across positions. A catcher that is estimated to score less FPTS than a 1B might still have a higher FVARz because of position scarcity. It would probably be better to skip on Anthony Rizzo and take Buster Posey and then grab Edwin Encarnacion two rounds later. The difference between Rizzo and Encarnacion will be slimmer than Posey and let’s say Yadier Molina. It’s really a balancing act.

      What I really use draft score is to make sure I draft a player while his draft score is still positive. So if Chris Archer has an ADP of 53 and a ranking of 30, that means he has an initial draft score of 23. If you pick him in with the 4th pick of the 4th round of a 12-team league, you have drafted Archer with the 40th overall pick. That means his final draft score was +10 and that’s good. That means you got him ten picks after where he should have been picked if everyone was drafting based on your league specific rankings.

      Hope this helps.

  29. Justin says:
    (link)

    Is there anyway if my league has an IF (infield spot) instead of the 1B/3B or 2B/SS spot, that I could enter that as an option in the settings tab for “define rosters”?

    Would it even make much of a difference in the overall rankings if I had that option to enter that in the spreadsheet?

    Thanks for your time!

    • malamoney

      malamoney says:
      (link)

      @Justin: It’s unlikely to make much of a difference. What it would do is very slightly affect the number of players considered at each infield position that would be considered “above replacement”.

      I am looking at the spreadsheet now. I think if I enable setting 1B/3B and 2B/SS positions to halves it will work. For instance if you wanted to add one IF spot you could just add 0.5 to both 1B/3B and 2B/SS spots. I see if I can push an update soon.

      When’s your draft?

      • Justin says:
        (link)

        I draft on Saturday the 17th… I mean if it is a lot of work I understand you probably have tons of other commitments this time of year and answering a flood of questions on your blog. If it is easy to complete that would be fantastic though so I dominate my draft!

        Thanks!

  30. Men On Grass says:
    (link)

    Hey, I am probably ashing a stupid question BUT….Is there a password necessary to modify cells? Everytime i get “this is read only” Thanks!!.

    • malamoney

      malamoney says:
      (link)

      @Men On Grass: What cell are you trying to modify? Some are indeed locked from editing…

      • Dennis says:
        (link)

        @malamoney: The seting tab. The one where I enter my league settings.

        • malamoney

          malamoney says:
          (link)

          @Dennis: Right, but which field specifically?

          • Dennis says:
            (link)

            @malamoney: Right now R2
            Wins points. I am trying to add my ESPN league spacific numbers

            • malamoney

              malamoney says:
              (link)

              @Dennis: You cannot change the canned scoring systems. If you league’s scoring system differs you need to use the rows for Custom Scoring. Then change the “Scoring System” dropdown to use the one you’ve edited…

  31. ReleasetheMcKraken says:
    (link)

    this is awesome. how do you search for players in the rankings tab? cntrl-f seems not to return any results…

    • ReleasetheMcKraken says:
      (link)

      @ReleasetheMcKraken: nvm, match entire cell contents was checked off in the find options

      • malamoney

        malamoney says:
        (link)

        @ReleasetheMcKraken: You beat me to the punch. Good luck…

  32. coup says:
    (link)

    @malamoney I am not seeing a “calculate” button on the settings tab. Am I missing something.

    P.S. This is some solid work my man.

    • coup says:
      (link)

      @coup: Solved it. Google docs doesn’t have it, but if I open in Excel it does. Thanks for the hard work man.

      • malamoney

        malamoney says:
        (link)

        @coup: No problem. Glad you figured it out…

    • malamoney

      malamoney says:
      (link)

      @coup: Thanks.

  33. Jose says:
    (link)

    This is great. Our league is so custom I can’t get this exact, but it’s close enough. Biggest problem is the Define Starters tab. We actually use 3 UTIL slots along with 1 of each:C, 1B, 2B, 3B, SS, LF, CF, RF. I instead just use 0 in the UTIL slot and add and extra to the OF slot and 1 each to the SS/2B and 1B/3B slot as that’s how I like to draft those util slots anyway.

    Would you do it any different?

    • malamoney

      malamoney says:
      (link)

      @Jose: It will get you close enough. We are talking about decimals most likely. I can send you a version that allows for 3 Utils spots, but as for the individual OF positions, I didn’t support that this year. Next year for sure…

      • Jose says:
        (link)

        @malamoney:
        I think we’re good. I checked the 2017 totals against the top 20 hitters and pitchers and they were all there. Some were just in a slightly different order.

        The hitters are going to be different regardless, as we use a few categories not listed.

        Extra Base Hits +2 ( I just added two points to doubles, triples, and home runs), Game Winning RBI (not really predictable anyway), Grouded Into Double Play (Same), Cycle (Same), Grand Slam Home Run ((Same) also really overvalued Justin Upton who had 6! last year)

        All in all, it works just fine. The hardest thing for me to get over is how high it values Catchers. I usually just punt catchers and sometimes just carry an extra pitcher instead of a catcher. May try to grab Contreras, but if he goes too soon. I will probably just punt again.

        • malamoney

          malamoney says:
          (link)

          @Jose: That is the correct approach for extra base hits. Maybe next year I will add a “Reduce Catchers Weight” like I have for RP for those that like to punt on catchers. However, it should be noted that having a top catcher like Posey or Sanchez over a bottom of the barrel catcher really gives you an advantage at the catcher position…

  34. Kyle Eberth says:
    (link)

    My League has 2 “P” spots, 3 Sp spots, and 3 RP spots. I don’t know why but it is what it is…
    We are limited to 7 SP starts per week.

    Any thoughts on how to best account for that in the league settings and rankings.

    Alos this worksheet is incredible, I hope you’ve been paid many many dollars for all your time and effort; it is staggering to me.

    Thanks!

    • Kyle Eberth says:
      (link)

      @Kyle Eberth: correction 5 sp spots, 2 p spots, 3 rp spots. Limited to 7 SP starts per week.

Comments are closed.