Share on FacebookTweet about this on TwitterShare on Google+

In case you live under a rock, which is actually Billy Butler in a boulder costume, and it wasn’t as obvious as the fact that Jose Fernandez and Yordano Ventura are going to combine for zero fantasy points this season, fantasy baseball draft season has begun. And in case I wasn’t aware of it, the unending requests for my rankings has surely served as a reminder. Last year I received quite a few emails in anticipation, some of which were rather entertaining. This year, however, one person has topped them all. The email read something like this. “Can you tell me when your rankings will be released? It’s the only post you write that I really care about. My draft is on the 12th.” To that guy I replied with a link to last year’s rankings. I wonder how his draft went. I hope his league gives points for honesty…

Razzball Commenter Leagues are open! Play against our contributors and your fellow readers for prizes. Join here!

Another email that stood out was the following. “I love your work on points league. You’re my go to source. Thanks, Matthew Berry.” I’ve got to be honest, I’m not sure whether this email actually came from The Talented Mr. Roto or not, but I’m doing my best to convince myself that it was. So far I’m leaning towards the conclusion that there is a better chance that it came from Matthew Dingleberry. Either way, I’ll take it. With such a small fanbase, beggars cannot be choosers.

Before we dive into my rankings, I want to talk a little about points leagues rankings. Never trust a man with two first names, especially if one of them’s a woman’s. Shelley Duncan, Shannon Stewart, Casey Blake, Babe Ruth and of course Bryce Harper, all have full names which fit the bill. I know, what in the world am I getting at? 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. It’s like a lawyer trying a case without all of the facts. How could they possibly compare Chris Davis to Starling Marte unless they know how many (if any) points your league deducts for strikeouts and awards for stolen bases. Based on my 2017 estimations, in a league that penalizes one point for a strikeout and gives two points for a stolen base, Davis is projected to score 329 points while Marte puts up 333. But in a league that does not subtract any points for strikeouts and only gives one point for a stolen base, Davis will score 528 points as compared to Marte’s 413. In this second league Davis is a top twenty hitter. In the first example he’s number 70. You see what I am getting at here? Fantasy advice in points league’s is entirely dependent on the points distribution of league in question. Generic rankings are pointless (pun intended). You might as well ask the slow adult in the red shirt working the register as your local Target. No offense to Target.

Here is a link to ESPN’s top 300 in head-to-head points leagues. What scoring system are they basing this on? This list is about as useful as a one armed trapeze artist with an extra itchy ass (quote found online). Or perhaps in better context, it’s about as useful as drafting Alex Reyes in a redraft league. Thanks for letting me know that Clayton Kershaw, Mike Trout and Mookie Betts were in the top three. For the most part the top ten or so players are consistent across most leagues, it’s players ten through one hundred that make the difference on draft day.

Personally I like the fantasy baseball guys over at CBS. I’ve had the pleasure of participating in several mock drafts this season with them and they do know their fantasy baseball. I respect their knowledge, but their generic head-to-head rankings are suspect to say the least. I realize that no one wants to be the guy that takes Kershaw with the first pick, but in certain scoring systems, that is the right move. Regardless, in any sane scoring system he is a top five-ish pick. These rankings have him at the ten spot!

Go ahead and do your research. Look around. What you will find is that most people act like points leagues do not exist, or that they are the red-headed step child of fantasy baseball. While the latter might be true, it doesn’t change the fact that there are thousands of points leagues in play. These leagues need love (and advice) too.

But who has the time to consider all the angles and potential combinations of scoring systems? That would be me. I actually do not have the time, but I do it anyway. Razzball High School Football rules! Can anyone name the movie from which I bastardized that last quote?

Now let’s get the part that you actually care about. As for those of you that skipped the previous seven paragraphs, you’re going to need to go back and read them to find the password to access the rankings.

This year I have made some significant enhancements to my spreadsheet. The most notable is the dynamic league-specific rankings feature. You now 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. I know, that’s awesome, right?!

Here’s how it all works. The spreadsheets contains a tab for hitters, pitchers and then one for each individual position. There is also a tab labeled “Rankings”. This is the sheet that hosts the actual rankings. The last tab is the “Settings” tab. This is where you tell the spreadsheet about your league. Just like the estimations spreadsheet from last week, this 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 systems there is a dropdown that allows you to select the active scoring system to be used by the spreadsheet. When you change scoring systems, the spreadsheet will automatically generate the new rankings and update (re-sort) each sheet. While I’d love to call it magic, it’s really just macros.

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.

Lastly you will see something labeled “Reduce RP Weight” at the bottom. No, this is not a diet program for fat relief pitchers (aka Bobby Jenks). 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 Jansen 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.

A few more things to mention…

  • If you see a bunch of zeros and #DIV/0! it likely means the scoring system you have told the spreadsheet to use is full of zeros. If this is not the case then you are probably trying to generate rankings for an unsupported league configuration. Unsupported configurations include any configuration that matches a money league I play in personally. Sorry, but I can’t exactly be handing over the exact cheatsheets I will be using at my drafts/auctions to my opponents.
  • Every time you make a change to the “Settings” tab, it recalculates everything. It takes a second or so to do this, so be patient when making multiple changes. You will likely notice this most when you are initially configuring your custom scoring system. Don’t lose your cool if you make a change and it seems like the spreadsheet is frozen for a second.
  • The “Calculate Rankings” button is mostly for show as they should be automatically calculated for you. However, if for some reason they do not appear to be updated, just press this button.

That’s really all there is to it.

In previous seasons I’ve listed rankings, but just like the lists I criticized earlier, those rankings were tied to a specific scoring system. At least in my case I shared the exact system being used. However, the results were likely not applicable to most readers. So instead of posting another pseudo generic list of players that might be more misleading than helpful, I’m going to let you get your hands on the spreadsheet and generate your own.

2017 Points League Rankings

 

 

You can follow malamoney on Twitter at @malamoney.

   
  1. Blake says:
    (link)

    thx Malamoney!

    Had a question though – I can start 7 pitcher regardless of Starting or relieving. my scoring settings for pitchers are

    15 pts for a W, 7pts for a S, and 1 pt for a SO

    do I just select 4 SP and 3 RP?

    • malamoney says:
      (link)

      @Blake: I’d probably do 5SP and 2RP.

      • Blake says:
        (link)

        @malamoney:

        it still shows K Jansen in the top 10 when you use FVARz. Is that correct?

        I then rank on FVARz to get my rankings though right? my top 20 hitters are over 500 points and my top pitcher (kershaw)
        only hits 475. Shouldnt I go with top point producers regardless or FVARz during each round?

        • malamoney says:
          (link)

          @Blake: Did you set “Reduce RP Weight” to “true”?

          Picking a player comes down to several things. The round, how many players your already have at a position and which players are left at the positions you have yet to fill. In the first two (maybe three) rounds I will usually grab the player projected to score the most points. But let’s say I already have Paul Goldschmidt and my choices are between Edwin Encarnacion and Robinson Cano. Edwin is projected to score 40 more points, but I don’t have a 2B. If I don’t have a 1B/3B, UTIL or DH spot for Edwin, then I am probably better off taking Cano and helping my active lineup. If I have a DH spot, then I will probably grab Encarnacion. But let’s say I look at the remaining 2B and I think the by the time my next pick comes around that the best 2B available will be Dustin Pedroia, then I might reconsider taking Cano.

          By default, the “Rankings” tab is sorted by FVARz, because that accounts for position adjustments. If you want to draft based on points, then re-sort by the “FTPS” column.

          • Blake says:
            (link)

            @malamoney:

            OK, was just wondering HOW I should draft? use total points vs ADP? or positional adjustments?

            • malamoney says:
              (link)

              @Blake: I usually rank by FVARz which accounts for positional adjustment. When it’s my turn I look to see which player it says is the best. Then I check that player’s ADP. If we are in the 3rd round, but the player’s ADP is 7th round, then I’m not going to take that player now. I will look at the next player on the list and so on. Also keep in mind that if you already have a SS and you only start one, then I usually will move to the next player.

              • Blake says:
                (link)

                @malamoney:

                thx! I always get confused!

                I was also curious about your W projections for pitchers. The site I use (CBS) has 19 wins projected for the top 6 pitchers.

                Was curious why yours are lower across the board?

                • malamoney says:
                  (link)

                  @Blake: One only knows how CBS comes up with their projections. Let’s be honest, 19 wins is quite the projection. Sure, there are going to be a few pitchers that reach 19+ wins, but I find it’s always better to be conservative. Especially with pitchers.

                  If you take Kershaw for example, CBS projects 19 wins. Steamer has 16, Zips has 14, Clay has 15 and FantasyData has 15. My projections are for 15.9 wins. Which source is the outlier?

                  If you read my post about my projections where I discuss my process, I do not include CBS in my calculations.

                  • Blake says:
                    (link)

                    @malamoney:

                    ok, thx for the clarification

                    When you add ADP, will it just be a new column on the rankings tab?

                    And are you getting ADP from Points league drafts?

                    • malamoney says:
                      (link)

                      @Blake: Probably add it to rankings tab.

                      And yes, I am trying to compile ADP based on points leagues. It’s not easy though…

                  • Blake says:
                    (link)

                    Thanks for answering all of my questions!

                    Looking forward to the ADP update, My draft is this sunday march 26th so hopefully it will be out before then?@malamoney:

                    • malamoney says:
                      (link)

                      @Blake: You’re welcome. The plan is this week.

  2. robmack1111 says:
    (link)

    I may or may not have squealed like a little girl when I saw this post. My coworkers are trying to understand what I’m so happy about.

    Thanks for all the time and hard work on this.

    • malamoney says:
      (link)

      @robmack1111: Never be ashamed to squeak…

  3. Smallwine says:
    (link)

    Thanks for all the research and hardwork. I play in a points league so this information is awesome.

    • malamoney says:
      (link)

      @Smallwine: You are welcome. Hope it helps!

  4. Jose says:
    (link)

    Malamoney! This is great!

    Quick question…I’m in a league that gives points for XBHs. Is there a way to add that or did I miss it somewhere?

    Thanks,

    Josh

    • malamoney says:
      (link)

      @Jose: There are a few indirect ways to do this. Go to the “Settings” tab and add a point to 2B, 3B and HR. So if a 2B is worth 2 points, make it 3. Make sense?

      • Jose says:
        (link)

        @malamoney: That’ll work just fine. Thanks again

        • malamoney says:
          (link)

          @Jose: You’re welcome. Let me know how it goes.

  5. Shivdaddy says:
    (link)

    I hit refresh on Razzball.com at least 50 times this week waiting for this! Thank you Mala.

    • malamoney says:
      (link)

      @Shivdaddy: You’re welcome. Call me malamoney…

  6. Joe says:
    (link)

    Malamoney,
    Great projections, as usual. I think the changes (additions) you made to the spreadsheet are very useful. Thanks for your efforts. Few things to note. The point settings that you show for FANTRAX are different than the points allocations for the head-to-head points leagues. They award 1-pt for singles, 2-pts for 2B, 3-pts for triple, 4-pts for HRs, 1-pt for RBIs, 1-pt for BB, 2-pts for steals, 1-pt for HBP; 10-pts for Ws, -5 pts for Ls, 7-pts for saves, 1-pt for Ks, 1-pt for IPs, -1 pt for ERs and 3pts or QSs. I could use a custom scoring for this. The bigger problem is that the spreadsheet doesn’t allow enough entries per position. In 12-team H2H pts leagues, the maximum roster size is 30 (as opposed to 26): 22 active players 1 -C, 1-IB, 1-2B, 1-SS, 1-3B, 1-CI, 1 MI, 5-OFs, 1-UT and 9-Pitchers (any) plus 8 reserves (any positions).

    • malamoney says:
      (link)

      @Joe: That’s the scoring system I found for Fantrax last week or so. Haven’t confirmed it, but as you said, you can just use the custom scoring entries.

      As for number of players at each position, you should only be entering the number of players that you start at each position. Max roster size actually isn’t really used. At least not in this version of the spreadsheet. I have a slightly more complex version that I use for my personal drafts/auctions.

      You are correct that it only supports 4 OFs. I intentionally put some limitations on the spreadsheet. You can use 4 OF and set Util to 2. For pitchers set SP to 7 and RP to 2. Using these values will get you very, very close to exact for your league. Closer than any other source out there…

  7. clear says:
    (link)

    Great stuff!
    One thing I have never understood though. Why does everyone have to carry out fantasy point estimates two decimal places?
    Really????

    Malamoney, why don’t you start a new trend and round off projected fantasy points to whole numbers?

    • malamoney says:
      (link)

      @clear: But that wouldn’t be precise! My projections process deals with averaging, so the decimals are expected. Feel free to ignore them…

      • clear says:
        (link)

        @malamoney:

        Thanks!

        To make your point projections even more precise, I extended the decimals to 16 places. This will be a HUGE improvement for my draft selections. LOL

        • malamoney says:
          (link)

          @clear: I never considered 16 decimal places. I am going to try 18 as soon as I get home!

    • Mantis Toboggan MD says:
      (link)

      @clear: are you seriously coming to the math guy (with rudy) and telling him to be less precise since you have an aversion to 2 extra numbers to look at? round off whatever you want. he cares about getting things accurate.

  8. Carson says:
    (link)

    Great work! I’d like to enter my league settings but I’m having trouble running the rankings.

    I think I figured out your password, but have no clue where to enter it on the spreadsheet. Any tips?

    Thanks!

    • malamoney says:
      (link)

      @Carson: You don’t need a password. What trouble are you having? Just go to the “Settings” tab and enter your scoring in the row for “Custom Scoring 1”. Then select “Custom Scoring 1” from the dropdown right below the section where you entered the scoring. The spreadsheet will automatically update. You can press the “Calculate Rankings” button if it doesn’t seem to be updating, but it should…

  9. ebudz says:
    (link)

    any idea why it shows “#NAME?” in the FVARz & Z-Score coloumns in all the Positional tabs and in the FVARz column of the Rankings tab?

    • malamoney says:
      (link)

      @ebudz: What scoring system have you entered? And are you sure you didn’t try (or accidentally) change any fields other than in the “Settings” tab?

      • ebudz says:
        (link)

        @malamoney: i don’t understand what i’m doing wrong! i got that error before i tried to change anything… i was able to enter my scoring system into your last spreadsheet without any problems? i get that error no matter how many times i try to download your spreadsheet and then open it in excel or upload to it google docs…

        if it help, my league and scoring system is as follows:

        10 team (3 keeper) ESPN H2H Points (weekly 12 start pitcher limit)

        Hitter Scoring: HIT (+1), RUN (+1), RBI (+1), 2B (+1), 3B (+2), HR (+3), BB (+1) SB (+1)
        Pitcher Scoring: WIN (+3), LOSS (-3), IP (+3), K (+1), BB (-1), SAVE (+3), HOLD (+1), ER (-2), HIT (-1), SO (+3), NH (+10), PG (+15)

        (1) C
        (1) 1B
        (1) 2B
        (1) SS
        (1) 3B
        (3) OF
        (1) UT

        (4) SP
        (3) RP

        (5) Bench total

        • malamoney says:
          (link)

          @ebudz: It works fine for me. I would suggest downloading the spreadsheet again and starting from scratch to ensure you have no rogue errors anywhere in the spreadsheet.

          Let me know how that goes.

          • ebudz says:
            (link)

            @malamoney: like i said i’ve tried downloading it several times but each time i get that error every time i “enable editing” in excel

            not sure if the the macros are causing the issue with my version of excel? anyway you can make a google docs version so i can try that? because i’m not having any luck when i try uploading the .xlsm file that i download each time

            • malamoney says:
              (link)

              @ebudz: What do you mean “enable editing”?

              Unfortunately there will not be a Google Docs version. Sorry.

  10. Big James A'int says:
    (link)

    Settings tab on rankings sheet is password protected. Any suggestions?

    • malamoney says:
      (link)

      @Big James A’int: The only fields you need to change are the values associated with “Custom Scoring 1”. Then you can change the dropdown telling the spreadsheet which scoring system to use. Set that to “Custom Scoring 1”. You can also change the numbers of players. You don’t need to, and shouldn’t be, changing any other fields. It is password protected for a reason. But those fields I mention above are not not locked.

      Let me know…

      • Big James A'int says:
        (link)

        @malamoney: I was trying to copy and paste my other two league points systems from the estimations sheet to the rankings sheet. I only got it to work when I put just the points in, and did not try to change Custom Scoring 1 and 2 to the names of my leagues as I was able to on the estimations sheet. Things look good now. Thanks

        • malamoney says:
          (link)

          @Big James A’int: Cool. Keep me posted if you have any other issues…

  11. Ante Galic says:
    (link)

    Malamoney!

    Many thanks for this colossal effort.

    Now the question that begs asking and I think the answer for which will give our fellow readers the edge in their leagues this year.

    How do you account for guys like Yu Darvish, Ivan Nova, Folty, Jon Gray, Jorge Polanco, Eric Thames to name a few who could outscore their projected points predictions? Just by being doing the research etc or is there a way to say at this point in the draft (round 5 for example) Yu Darvish is available – go get him! Not really sure if I’m being clear with the question.

    There are players that I like and players that I don’t like or feel will be injured etc., etc. I have bolded out the players I like in the rankings tab and italicized the players I don’t like or don’t think will reach the points projected for them or will not be worth the draft choice at that point in the draft.

    Cheers,
    Ante

    • malamoney says:
      (link)

      @Ante Galic: There are a couple of things you can do. You can always edit the player’s projections. If you are going to do so, do this on the position specific tab. You can do it on the “Hitters” tab too, but it’s the position specific one that the rankings are generated from.

      Next week I will be adding ADP to each player. Using ADP vs ranking, you can get an idea of when a player will need to be drafted if you don’t want someone else to snatch him first. This will also help identify bargains and over priced players based on your custom rankings.

      As you have already done, you can highlight guys directly in the spreadsheet so that they stick out.

      Not sure if this answers your question, but if not, please feel free to ask more. Thanks.

      • Ante GALIC says:
        (link)

        @malamoney: Malamoney!

        Thanks for the in-depth, much appreciated!

        Reply is crystal clear.

        Cheers,
        Ante

        • malamoney says:
          (link)

          @Ante GALIC: You’re welcome.

    • Shivdaddy says:
      (link)

      @Ante Galic:

      No way Thames out hits his projections! He is already ranked 52nd overall in my league!

      • malamoney says:
        (link)

        @Shivdaddy: Yeah, he is a little high. His projections might be better than to be expected. I guess we’ll see, but that’s where you have to use your judgement…

  12. Ghostface says:
    (link)

    Thanks for this, very helpful for my leagues unique statistics. We only implemented points last season and I’m trying to figure out how to draft again. The best hitters far outweigh the pitchers, with about a 100 point difference between their point totals. However, the point difference between the best hitter vs. 10th best is about 100 points versus 150 points versus the pitchers. So essentially, the best pitchers are highly valued vs. offensive players I can get in later rounds that aren’t far off from higher drafted offensive players. This goes against everything I’ve ever done, as I’ve always drafted pitchers late.

    • malamoney says:
      (link)

      @Ghostface: In H2H points leagues you need to grab at least one top pitcher early. Hope this help you!

      • Ghostface says:
        (link)

        @malamoney: Definitely. We keep 3 players so I’m trying to figure out who I should keep. 10 teams. My no doubts are Odor in the 8th round and Yu in the 12th. I’m trying to pick between Archer in the 13th or Carlos Santana in the 11th. I know that seems like a no brainer, but with our scoring system, even projected with your tool, Santana is the 22nd best player (24th last season so it’s accurate) vs. Archer who would be about 160th. 622 points vs. 424 points. Since practically all the teams are keeping top offensive players, the top talent is gone vs. pitching so I’m thinking keeping Santana and taking a top pitcher.

        • malamoney says:
          (link)

          @Ghostface: That sounds like the right move.

        • malamoney says:
          (link)

          @Ghostface: Also keep in mind ADP. If you didn’t keep either of them, when would they be drafted. Which do you have the best chance of getting in the draft?

          • Ghostface says:
            (link)

            @malamoney: Depends if people notice how valuable Santana is, which I imagine they would after one season with these points. Santana, based on these projections, becomes a 1st rounder since so much of the top players are being kept. If I’m lucky enough to get a 1-3 pick I can get Trout, Goldschmidt or Harper but it falls off after that. I’d rather keep Santana and if I don’t get a top pick, take a Kershaw, Bumgarner, Scherzer in the 1st. I think that makes sense.

            • malamoney says:
              (link)

              @Ghostface: If you keep Santana, do you still have a shot at Trout?

              • Ghostface says:
                (link)

                @malamoney: Sure. Santana would be an 11th round keeper. So if I get the #1 draft pick, I can draft Trout.

                • malamoney says:
                  (link)

                  @Ghostface: Sounds like the plan to me.

  13. Steve Rosenbaum says:
    (link)

    Kudos Malamoney! This writing is spot-on. Love the spreadsheet. In a world that worships roto formats, it is very pleasing to see an old-fashioned, astute recommendation as to how to approach points leagues. Personally, I love the head-to-head points leagues. They are truly different from roto, but since I enjoy math and strategic thinking, I usually do pretty well. Thank you for your outstanding work. Rosie (Go Rangers!)

    • malamoney says:
      (link)

      @Steve Rosenbaum: Thanks Rosie! I appreciate the kind words.

  14. Illuminatty says:
    (link)

    great content as always,

    playing in h2h points league. better duo to pair with Mike Trout since i have first pick.
    Votto/ Lindor, Freeman/ Lindor or Votto/ Story, Freeman/ Story. If you have any other suggestion let me know thanks.

    • malamoney says:
      (link)

      @Illuminatty: What’s your scoring system?

    • Shivdaddy says:
      (link)

      @Illuminatty:

      Assuming you mean pick 24 and 25? If so, you will not want any of those combos, according to the magic sheet.

      According to my league’s (custom) settings, Votto is 37, Lindor 49, Story 78, Freeman 59. I was surprised as well seeing freeman and story so low.

      • malamoney says:
        (link)

        @Shivdaddy: I mean, send me your scoring system so I can plug it in an look for myself. How man points for each category?

        • Illuminatty says:
          (link)

          @malamoney: My league manager is yet to reactivate the league, since the draft date is not till the 30th. Just to give you a little more info it’s a 10 man H2H points league. I’m drafting first and 99.9% I’m taking Trout. From what I remember doubles, triples and homeruns are a decent amount of points.. wish I can give you actual digits.

          • malamoney says:
            (link)

            @Illuminatty: Can you get to last year’s data? I’m sure the scoring system is the same. What site is it hosted on?

            • Illuminatty says:
              (link)

              @malamoney: it’s an ESPN Fantasy League.

              • malamoney says:
                (link)

                @Illuminatty: It’s a pay league? If not, you should be able to look at previous seasons and get the scoring system that way.

                • Illuminatty says:
                  (link)

                  @malamoney:

                  Singles (1B): 3
                  Doubles (2B): 6
                  Triples (3B): 12
                  Home Runs (HR): 9
                  Walks (BB): 2
                  Runs Scored (R) : 3
                  Runs Batted In (RBI): 4
                  Stolen Bases (SB): 4
                  Strikeouts (K): -1
                  Intentional Walks (IBB) 1
                  Hit by Pitch (HBP) 2
                  Hitting for the Cycle (CYC): 40
                  Grand Slam Home Runs (GSHR): 8
                  Outfield Assists (OFAST): 10
                  Errors (E): -2

            • Illuminatty says:
              (link)

              @malamoney:
              Singles (1B) 3 Doubles (2B) 6
              Triples (3B) 12 Home Runs (HR) 9
              Walks (BB) 2 Runs Scored (R) 3
              Runs Batted In (RBI) 4 Stolen Bases (SB) 4
              Strikeouts (K) -1 Intentional Walks (IBB) 1
              Hit by Pitch (HBP) 2 Hitting for the Cycle (CYC) 40
              Grand Slam Home Runs (GSHR) 8 Outfield Assists (OFAST) 10
              Errors (E) -2

              • malamoney says:
                (link)

                @Illuminatty: I will do this in an hour…

              • malamoney says:
                (link)

                @Illuminatty: What about pitching?

                • Illuminatty says:
                  (link)

                  @malamoney:

                  Innings Pitched (IP) 6
                  Earned Runs (ER) -3
                  Wins (W) 10
                  Losses (L) -10
                  Saves (SV) 23
                  Blown Saves (BS) -3
                  Strikeouts (K) 1
                  Walks Issued (BB) -1
                  Shutouts (SO) 10
                  Complete Games (CG) 15
                  Quality Starts (QS) 6
                  No Hitters (NH) 50
                  Perfect Games (PG) 75

                  Thoughts on who should i take for my ace.. Arrieta, Lester, Verlander or Yu Darvish.. like i said before i want to have a combo of Votto/ Lindor, Freeman/ Lindor or Votto/ Story, Freeman/ Story to be with my first pick Trout. If you have any other suggestions let me know. thanks for your help.

                  • malamoney says:
                    (link)

                    @Illuminatty: This scoring system is outrageously absurd. But so be it.

                    Here’s the thing. Unless your league mates read this site, then they are not likely to have this rankings. Therefore, like everyone else, they will be drafting with the canned cheatsheets and ADP. My post this week will explain how to use this to your advantage. But the crux of the concept is that you can use these rankings to figure out who the real best player is. Let’s say it’s your turn and these rankings say to next best player is Buster Posey. Let’s say it is the 2nd round, but Posey’s ADP isn’t until the 5th round. Well it would be silly to pick him now. Go down to the next guy and find the next best guy with an ADP around round 2. Then grab Posey in the 4th round.

                    Based on the rankings for your league, I see:

                    Votto is 45th
                    Lindor is 47th
                    Freeman is 59th
                    Story is 85th

  15. Webelos Willie

    Webelos Willie says:
    (link)

    I have found that shouting “San Dimas Football rules!” is a great way to end any speech. Bill and Ted’s baby!

    My 12 team H2H categories league is switching from K to K/9 this year. Any advice? Other cats- QS, ERA, WHIP, Saves, Holds. 30 IP Minimum each week.

    • malamoney says:
      (link)

      @Webelos Willie: If I had a prize you’d have won it. I’ll have to think about the K to K/9 switch. I guess it slightly discourages more IP, but I’m not sure. I will try and look at some sample data.

      I hate the current concept of a quality start. First of all 3 earned runs in 6 innings is a 4.50 ERA. How is that quality?

  16. Jason Morgan says:
    (link)

    This is great. Thank you!

    Based on the points I entered it says has Betts and Trout just about even with Betts a few fractions ahead. I still think I will take Trout. Is this a bad move?

    • malamoney says:
      (link)

      @Jason Morgan: Thanks!

      I’d probably do the same thing. Remember, my spreadsheet is to act as a guide and it is completely tied to the numbers. While I find it important to be able to separate the emotion from decisions, there is still a place for gut decisions. Especially when they are that close in the rankings. Remember, it’s your team.

      Personally, I’d take Trout too. While it is unlikely he will finish the season as the top hitter in points leagues, his track record says he has the best chance. Good luck.

      • Jason Morgan says:
        (link)

        @malamoney: Cool. I’m taking Trout. I’ll probably be bugging you with questions about my later picks. Be warned

        • malamoney says:
          (link)

          @Jason Morgan: Not a problem.

  17. S.Head says:
    (link)

    Great Stuff.
    Rankings have Eric Thames above Corey Seager, with Correa 20 spots above both. While my league only penalizes .5 per hitter K, I’d be as surprised as a Redneck on Christmas if Thames ended up more valuable than Seager.

    • malamoney says:
      (link)

      @S.Head: Thanks. Like I said to another commenter above, his Thames’s projections ended up a bit optimistic. You can always manually lower them. Just do so on the “OF” tab. Then go to “Settings” and press the “Calculate Rankings” button.

      Do Rednecks get surprised on Christmas? Is that a thing?

    • Shivdaddy says:
      (link)

      @S.Head:

      I am pretty sure if you go by Value added from draft position that Thames will be more valuable. Thames 278, Seager 24.

      • malamoney says:
        (link)

        @Shivdaddy: That will likely be true, but these rankings do not yet consider ADP

  18. Ron says:
    (link)

    Hey Malamoney,

    I really appreciate all the hard work you put into this! One thing, I think I’m running a computer from the middle ages and can’t seem to open a .XLSM file. Is there a way to convert this?

    Thanks!

    • malamoney says:
      (link)

      @Ron: Sure. Drive to Best Buy and buy a new computer. If that doesn’t work for you then I’m not sure. Most versions of Microsoft Excel should do the job.

      The “m” at the end means that the spreadsheet contains macros. That’s the code that does all the fancy rankings…

  19. Mickey Maloney says:
    (link)

    Dude, this is awesome. Thanks for doing. Trying to determine rankings for my Points league has been tough. No league really matched up with our system. Not that I go directly by a cheat sheet, but it helps you get an idea how to value pitchers vs hitters, power vs speed etc. Well done!

    • malamoney says:
      (link)

      @Mickey Maloney: Thanks, and you’re welcome. Let me know if you have any questions.

      This spreadsheet is meant only to serve as a guide…

      • Mickey Maloney says:
        (link)

        @malamoney: Thanks again. I had a question re: RP. I notice Duffy is quite high on your rankings, is that because he has SP and RP eligibility? Assuming starting a SP in a RP spot could be a huge advantage.

        Final Q: In a 12 team league, when do you generally select a RP? Or who is your top target factoring in ADP?

        • malamoney says:
          (link)

          @Mickey Maloney: Duffy’s high ranking is using him as an RP. He has the potential to lead all RP in points. As an SP, his value is lower. If you are interested in how much lower, look for the value of an SP projected to score the same amount of points.

          I haven’t gotten to my ADP research yet. I probably won’t touch an RP until rounds 6-10. But it depends on what the rest of the teams are doing.

          • Mickey Maloney says:
            (link)

            @malamoney: Thanks! I had my first draft of the season last night and first H2H Points draft ever. Here’s how I did:

            12 Teams
            Voght
            Jose Abreau
            Zobrist
            Russell
            Bregman
            Logan Forsythe (MI)
            Santana (CI)
            Harper
            Polanco
            Bautista
            Puig
            Belt (U)

            Bumgarner
            Lester
            Samardzja
            Manaea
            Joe Ross
            Gray
            Giles
            Robertson

            Bench:
            Folty
            Mike Montgomery
            Leake
            Bucholz
            Ed Rodgriguez
            Domingo Santana

            • malamoney says:
              (link)

              @Mickey Maloney: Looks good. Be nice to see Puig bounce back and Bautista stay healthy.

              Is that Sonny or Jon Gray?

              I don’t care for Bucholz or Leake much.

  20. Alex says:
    (link)

    Why do Buster Posey and Gary Sanchez get ranked so high?

    • malamoney says:
      (link)

      @Alex: Similar concept as with RP. I considered adding a “Reduce C Weight”, but the fact of the matter is that if you draft Posey, you are going to have a nice advantage in points at the catcher position over the majority of your opponents. So when you factor value of replacement at position, the top catchers rise up the overall rankings.

      If you’ve read my posts over the last two years you will have read that I realize Posey (and now Sanchez in many leagues) is ranked high. That doesn’t mean you need to draft him that early. Use ADP as your guide. If you rankings have him as a second round pick, but his ADP has him in the 5th round, take him in the 4th, and know you are getting good value out of that pick.

      Getting solid production out of your C spot while every else scrapes by, gives you a small advantage, and it’s those small advantages that you need to add up to win…

  21. Adrian Dantley says:
    (link)

    Hi Malamoney,

    Thanks for the awesome points customization. I’m fired up but can’t figure out how to find the dropdown that allows you to select the active scoring system to be used by the spreadsheet.

    I’ve loaded my custom league settings in the Custom Scoring 1 sheet but can’t find any drop downs that make it my default scoring system. Thoughts?

    A.D.

  22. Adrian Dantley says:
    (link)

    Eureka! Figured it out. Thanks!

    • malamoney says:
      (link)

      @Adrian Dantley: No problem. Let me know if you have any issues.

  23. A-Mesh says:
    (link)

    This workbook is a lifesaver. One thing I did to tweak is default all SP/RP’s to just SP and change the vlookup to the SP table. In my scoring, Duffy was showing as the top rated player but shifting the lookup to the SP table normalized it.

    • malamoney says:
      (link)

      @A-Mesh: Cool. That makes sense. Especially in leagues that just start pitchers as opposed to SP and RP.

  24. Oranje says:
    (link)

    My draft is slowing starting…it’s a keeper league with an average of 7 guys coming back either as contracted players or as keepers. I have little pitching help, Matz, Wainwright, and Urias…do with my first pick I took Arrieta ($9). This meant I passed on a bat I really wanted…Odor ($20). The guy who drafted Odor offered him to me for Arrieta. Make that trade?
    Current offense: Baez, Russell, Machado, Harper, Stanton, Heyward, Hosmer, and Belt. Thanks.

    • malamoney says:
      (link)

      @Oranje: No, I’d keep Arrieta, but I’d need to see your points system to be sure…

      • Oranje says:
        (link)

        @malamoney: thanks. Points are 5×5 stats where I play h2h against every team in the league each week.

        • malamoney says:
          (link)

          @Oranje: So it’s a head-to-head roto league?

  25. Scrotchs says:
    (link)

    I love the points rankings. Great tool. The rankings seem about right but the total points seem off when I enter my leagues scoring system.

    Every year the top point totals go to pitchers in my league, normally by quite a bit. When I enter in my system it has trout scoring about 100 points more then Kresge and many other hitters outscoring the top pitchers. I double checked the entries and they seem right. Any reason why that you can think of that they may be off? The top pitcher and hitter of 2016 along with top projections below

    2016 scherzer had 716 points then porcello with 663
    2016 betts had 653 then trout with 636

    8 pitchers had over 600 and 5 hitters

    For 2017 projections it has 6 hitters projected for over 700 points and trout the top with 760. Probably 20 hitters projected over 600 points

    For 2017 pitchers top guy is kershaw with 642 and he is the only pitcher projected over 600.

    It just seems off. Let me know what you think.

    Thanks

    • Shivdaddy says:
      (link)

      @Scrotchs:

      Projections for top SP are a little lower than what the top SP will have at end of year. Projections for hitters are much closer to their end of year stats. I think the variance for SP is much higher than hitting, so it does not make sense to project SP at their top end.

    • malamoney says:
      (link)

      @Scrotchs: Send me your points system and I will look.

      Also, who in the world is Kresge. If that is Kershaw, then you my friend have just won an award for the worst mangling of a player’s name since ever…

      • Scrotchs says:
        (link)

        @malamoney: @malamoney:

        Haha auto correct!

        Custom Scoring copy and paste

        1 1 2 3 4 1 1 -0.5 1 1 2 -1 0 0 1 0 0 6 -5 3 8 0 0.5 -1 -1 -1 4 0 0 -1 0 0 0

        • malamoney says:
          (link)

          @Scrotchs: I get 760.45 for Trout and 642.47 for Kershaw…

          • Scrotchs says:
            (link)

            @malamoney:

            That’s what I got too. Just thinking from past years hitters are being overvalued when compared to year end totals

            • malamoney says:
              (link)

              @Scrotchs: The thing is that hitters are more consistent and easier to project.

              • Scrotchs says:
                (link)

                @malamoney:

                Makes sense…thanks a ton!

                • malamoney says:
                  (link)

                  @Scrotchs: You’re welcome!

  26. Cram It says:
    (link)

    Hey man. Who do you like more at OF in a keep forever points league? Piscotty or Mazara?

    • malamoney says:
      (link)

      @Cram It: Piscotty this season. Mazara going forward…

  27. Jerry says:
    (link)

    Hey, Malamoney. Choo, Peralta or Span to have biggest bounceback in a head to head points league this year? Thanks!

    • malamoney says:
      (link)

      @Jerry: I’ve always liked Span in points leagues. Not sure Choo plays enough. Which Peralta?

  28. Jerry says:
    (link)

    David

    • malamoney says:
      (link)

      @Jerry: I’m probably taking my changes with Peralta as Span is getting on in age…

  29. Jerry says:
    (link)

    Sounds good. Thanks again!

    • malamoney says:
      (link)

      @Jerry: No problem.

  30. Ante GALIC says:
    (link)

    Malamoney!!

    Still there for comments?

    What do you think of this team? 10-team, H2H, points, CBS?

    Player Position Round Drafted Overall Pick Projected Fantasy Points

    Hedges, Austin C 22 211 228.5
    Goldschmidt, Paul 1B 2 11 540
    Hernandez, Cesar 2B 11 110 361
    Arenado, Nolan 3B 1 10 547.5
    Machado, Manny SS 3 30 467.5
    Piscotty, Stephen OF 14 131 421
    Springer, George OF 5 50 459
    Stanton, Giancarlo OF 6 51 423.5
    Herrera, Odubel U 19 190 406.5

    Bumgarner, Madison P 4 31 601.5
    Darvish, Yu P 9 90 496.5
    Duffy, Danny P 12 111 440.5
    Kluber, Corey P 7 70 605.5
    Lester, Jon P 8 71 599.5
    Osuna, Roberto P 13 130 442
    Verlander, Justin P 10 91 591.5
    Chapman, Aroldis P 15 150 406.5
    Gonzalez, Gio P 21 210 358
    Nola, Aaron P 20 191 359
    Nova, Ivan P 17 170 398
    Pineda, Michael P 16 151 409
    Velasquez, Vince P 18 171 364

    For info, there were four (4) other humans in the mock draft room!!!

    Cheers,
    Ante

    • malamoney says:
      (link)

      @Ante GALIC: Trying to figure out how you managed to get Goldschmidt, Arenado, Machado and Bumgarner. Oh, and Kluber. Heck of a team, but doesn’t seem realistic.

  31. Pete says:
    (link)

    Great update to your sheet this year!

    I’m having a tough time with a keeper decision this year. I need to pick 2 of the following:
    Encarnacion (round 2), Story (round 8), and Gary Sanchez (round 14). The K’s are a killer on Story (we do -1 points), so I’m actually thinking of not keeping him. The ranks in your spreadsheet for each of the players are 21, 117, and 41, respectively.

    Would you keep Encarnacion and Gary Sanchez? I’m doubtful Encarnacion would be there for my first pick and I have a feeling it will be slim pickings. We can keep 5 overall (Arenado, Blackmon, and Kluber are my others).

    • malamoney says:
      (link)

      @Pete: Thanks.

      Sanchez is a no-brainer. I like E5 over Story. And if my rankings have Edwin ranked as a second round player, then you are getting him at the right value.

  32. Daniel mansoor says:
    (link)

    Hey great stuff on here. So glad I found something like this for points league. I can’t seem to find the calculate rankings button and they don’t seem to be refreshing

    • malamoney says:
      (link)

      @Daniel mansoor: The button is on the “Settings” tab at the bottom, but it shouldn’t be needed. The spreadsheet auto refreshes when you make changes to the “Settings” tab.

      • Daniel mansoor says:
        (link)

        @malamoney: ya for some reason it won’t change at all. My league uses the cbs points format

      • Daniel mansoor says:
        (link)

        @Daniel mansoor: I’m b@malam@malamoney: I’m not the greatest with computers. I Justin opened it up for the website. Do I need I download a program or something?

  33. RicoSuave says:
    (link)

    AWESOME MALAMONEY!

    Thanks so much… Great work man!

    Cheers

    • malamoney says:
      (link)

      @RicoSuave: Thanks Rico! And you are welcome.

  34. You Know Nothing, J.T. Snow says:
    (link)

    Thanks again for all of the hard work. I’ve used your rankings and projections every year. Usually I like the team I’ve assembled after the draft, but I’m not so sure this year. I took your advice and didn’t keep David Price. 12 team H2H with scoring 1B:1, 2B:2, 3B:3, HR:4, TB:1, RBI:1, R:1, SB:1, K:-1, BB:1, CS:-1, GIDP:-.5. Pitchers W:5, L:-5, IN.:3, ER:-2, BB:-1, K:1, QS:3, SV:5, HLD: 3. What do you think?

    C – Matt Wieters
    1B – Pujols
    2B – Matt Carpenter
    3B – Donaldson
    SS – C. Seager
    LF – Zobrist
    CF – AJ Pollock
    RF – Bautista
    OF – Melky
    Util – Kendrys Morales
    Util – Thames

    SP – deGrom
    SP – McCullers
    SP – Maeda
    SP – Matz
    SP – Paxton
    RP – Colome
    RP – Neris

    Bench – Rodon
    Bench – T. Walker
    Bench – Joe Ross
    Bench – D’Arnaud
    Bench – David Dahl

    • malamoney says:
      (link)

      @You Know Nothing, J.T. Snow: You seem to have done well (according to the rankings) at each position. I’m not a huge fan of relying on Pujols and Bautista, but if they come through and Thames can come somewhat close to projections, your bats are going to be good.

      I think you are missing a true ace. You are going to have to hope that deGrom performs like one. You do have a lot of high upside guys in McCullers, Maeda, Matz, Paxton and Rodon.

      Your team might not jump off the paper as an awesome team, but it has definite potential based on the numbers. Remember, it’s rarely ever the team with all the big names that wins the league. All you need to do is get enough points each week to beat your opponent.

      Nice work.

      • You Know Nothing, J.T. Snow says:
        (link)

        @malamoney: Thanks. I am worried about pitching. I know I mentioned before that I had a chance at darvish or verlander, but I couldnt get them and degrom was the next best option so I went with him and upside and am hoping for the best. Not ideal with Pujols and Bautista, but Pujols is ranked really low in ESPN and I was able to get pretty late. Thames I took around 220 and figured why not

        • malamoney says:
          (link)

          @You Know Nothing, J.T. Snow: I would have preferred Darvish, but deGrom is not far off and could be better. That’s a great spot to grab Thames. Little risk at 220.

  35. Maestro says:
    (link)

    Great work, Malamoney –

    Question: Can I delete columns without affecting columns B (FPTS), C (PPPA) and D (PPG)? For example, I don’t need columns for AB, H, SO (not in my scoring system), SF, etc.

    I’m trying to get all columns applicable for my league’s scoring system on one page.

    Thanks, Mike

    • malamoney says:
      (link)

      @Maestro: It’s possible, but not sure it’s simple. Try deleting one column, such as the “AB” column and look. If things looks messed up, then undo (Control-Z).

      The other thing you can do is this. Once you have everything set based on your league’s scoring system and you do not plan to make any other changes, you can go into each tab and select all (Control-A) and then chose the option for Pasting (values). It’s not the normal (Control-V) option. You have to look in the submenus. This will get rid of any formulas. Then you can delete any column you want. You will have to do this on each tab.

      Let me know how it goes…

  36. TheConsigliere says:
    (link)

    Hi malamoney,
    Thanks heaps for the spreadsheet, I’m sure it will be a great help.

    Just a quick question – is there a reason why the total Hits projected for each player doesn’t equal 1B + 2B + 3B + HR? I would have thought these should add up?

    • malamoney says:
      (link)

      @TheConsigliere: You’re welcome. That’s a good catch. The reason for that is probably because of my projections creation process. I generate my own projections. Then I average them with 10 other trusted projection sources. Then I take those results and average them with mine again too.

  37. james says:
    (link)

    When I enter my league scoring into Custom 1 and then go to the updated rankings, some of the rankings and FVARz have a green triangle in the top left corner of the cell. Any idea why?

    • malamoney says:
      (link)

      @james: That’s probably just indicative of the fact that that cell is determined by a formula linked to another sheet.

      • james says:
        (link)

        @malamoney: thanks! great work

        • malamoney says:
          (link)

          @james: Thank you.

  38. Dan S says:
    (link)

    I participated in my first pts league last year and your spreadsheet was invaluable – thanks a ton. I was competing well until Kershaw got injured, and Heyward sucking didn’t help me. I have a strategy question for you. The league has weekly lineup settings, so I found that 2-start pitchers were invaluable in trying to rack up pts. Also, you start 5 SP and 2 RP, and starting pitchers who have RP eligibility also invaluable. There are 9 bench spots, and last year I basically used all my bench spots for pitchers to try and maximize 2 start guys each week. In terms of pts, the hitting is pretty standard and Pitchers are 10 pts win, 1 IP, 1 K, -5 loss, 5 save, -1 BS, 3 QS, 4 CG, 10 SO, -1 ER, 2 Hold.

    I am thinking of drafting almost all starting pitchers early and trying to just run out tons of 2 start pitchers every week, and maybe take Duffy in the 2nd or 3rd round since he has RP eligibility. Any thoughts? Thanks!

    • malamoney says:
      (link)

      @Dan S: Every year I struggle how to approach this. Some years I load up on the RP/SP pitchers and run as many two-start pitchers out there. Some times it pays off and other times it flops. It depends on the pitchers and the points system. In one of my leagues where wins and saves are both 10 points I found that RP average between 25 and 35 points a week. Let’s say 30 points. Two-start pitchers got me around 15 on a crappy week and 50 on a good week. The RP was a more consistent 30 points each week and in H2H points leagues consistency is key. So now in that league unless I have a top quality pitcher like Duffy with two starts, I usually go with the RP.

      However, in your league a save is only 5 points. This lends itself heavily to going with the two-start pitcher. Your scoring system is skewed, but so be it. You work with what you have.

      Unless your league is all over this same approach, I think the 2nd and 3rd round is too early for Duffy. Based on the data I can find, his ADP in points league is about 70. In a 12-team league that’s the 6th or 7th round. Don’t for Dylan Bundy. Be sure to filter/sort the RP tab in the spreadsheet to find other candidates…

  39. Danny Boy says:
    (link)

    Thanks for the detailed response! I forgot to mention my league is 14 teams, which maybe pushes Duffy up a round or so. I had a lot of fun with the pts league last year and am hoping to do better this season!

    • malamoney says:
      (link)

      @Danny Boy: Yes, with 14 teams, he is a 5th rounder. Did you use my spreadsheet to generate rankings? If so, where does it have Duffy?

      • Danny Boy says:
        (link)

        @malamoney: wow, it has Duffy 12th overall, ahead of Harper! Sounds almost crazy – thoughts?

        • malamoney says:
          (link)

          @Danny Boy: Go to the “Settings” tab and set “Reduce RP Weight” to “true” and see how that affects his ranking.

          • Danny Boy says:
            (link)

            @malamoney: I had already flipped that to yes, if I switch it to no he drops 1 spot to 13th

            • malamoney says:
              (link)

              @Danny Boy: Is he the top ranked RP?

              • Danny Boy says:
                (link)

                @malamoney: yes by far – he is 13th, Jansen is 33rd and Chapman is 48th

                • malamoney says:
                  (link)

                  @Danny Boy: Sounds about right considering your points system. I’d probably grab Duffy in the 4th.

  40. james says:
    (link)

    Is there a document like this for 5×5?

    • malamoney says:
      (link)

      @james: Not that I know of. Or I should say I have not made mine public. I might release my 5×5 roto rankings later this week which would be based on the same concept, but I haven’t decided on that yet. Depends on how busy I am. However, I will not be releasing a spreadsheet.

  41. Illuminatty says:
    (link)

    Hey Mala,

    i was curious to get your take on this stragtey, drafting currently 1st in a 10 man h2h points league. I’m thinking of going offense ( OF, 1B, SS ) first 3 picks and then going ( SP, SP ) for picks 40 and 41. If I go ( SP , SP ) I’m thinking of grabbing Y. Darvish, J. Verlander, Arrieta, or Cueto. Which 2 of this pitchers would you combo with each other? Or would you grab one of these possible pitcher and pair them with an offense player, instead of going (SP, SP) go (SP, Hitter)?

    *If my question is confusing I apologize. Thanks for your help.

    • malamoney says:
      (link)

      @Illuminatty: This questions feels a little like a word problem I had to solve in math class back in grade school.

      My strategy with points leagues is generally to draft the player that is going to get me the most points regardless of position. The only factor I account for is ADP. I hate ADP, but the fact remains that it’s a thing. If it’s my turn the best player available (according to my rankings and projections) has an ADP of a few rounds later, why take him now. Grab another guy that won’t be there at your next turn and grab this guy later.

      Unless you can get Kershaw, you should likely grab a bat in the first round. But if you can get Bumgarner or Sale in the second round, I’d go for it. But I’d probably want an SP by the third round. If you think those pitchers will all be available in the 4th round then I’m ok with your strategy. Your 4th and 5th picks will be the 40th and 41st picks of the draft. However, based on ADP, I’d expect them all to be gone by then.

  42. James says:
    (link)

    When someone has dual eligibility, how do you see their value over replacement for the different positions? For instance Kris Bryant at 3b vs OF?

    • malamoney says:
      (link)

      @James: You can go to the tab for the specific position to see the position specific FVARz values. However, when a player such as Bryant was above the replacement player at more than one position I picked the position with the highest FVARz to include in the overall rankings. I couldn’t have more than one entry for a player other wise he’d be double or triple (Matt Carpenter) counted against the total.

  43. AussiePepe says:
    (link)

    Great big Thanks to you malamoney.
    First year of a points league and have found your words, spreadsheet and replies a great source of help getting ready for draft. I see that you will be doing an update with ADP. really looking forward to that to complete the puzzle.

    • malamoney says:
      (link)

      @AussiePepe: It should be out this afternoon.

      • AussiePepe says:
        (link)

        @malamoney: Got it and am now looking forward to Draft on Sunday. Great resource and again thanks

        • malamoney says:
          (link)

          @AussiePepe: No problem.

  44. Cole says:
    (link)

    Mala my league has -2 for GDP and -1 for E. I know this is not on your list and did not know if it is even projected anywhere. I guess my question is, is GDP something that can be tracked by player? if so should it have bearing on certain hitters?

    thanks,

  45. Rhinoballer says:
    (link)

    I’m in a 10-team H2H that is 7×7:
    H
    R
    HR
    RBI
    AVG
    NSB
    OPS

    W
    L
    NSV
    ERA
    WHIP
    K
    K/9

    How would I set up custom rankings for these settings using your spreadsheet?

    • malamoney says:
      (link)

      @Rhinoballer: This spreadsheet if for points leagues. It is not intended for roto leagues. Sorry.

  46. Cha Boy says:
    (link)

    Thanks so much for doing this! Fyi, the WHIP column doesn’t appear to be calculated correctly; should be a very quick fix for the next version.

    • malamoney says:
      (link)

      @Cha Boy: Appears to be a cut and paste flop…

  47. Frank the Tank says:
    (link)

    Thanks for the valuable information provided to those who play in a points league! The spreadsheet has a max of 16 teams and our league has 18 teams. We auction 21 total players with 16 players starting (9 hitters & 6 pitchers), 5 bench spots, and also have 10 MiLB spots. What are your suggestions on tweaking the total teams and roster size? Thanks again! You’re my boy Blue!

  48. Ben says:
    (link)

    Need to choose one of the below options for my H2H Points Keeper League:

    #1: Jon Lester, Mark Trumbo, Alex Bregman

    #2 Brian Dozier, Alex Bregman, David Dahl

    Thanks!

  49. cable says:
    (link)

    Mike Mal……12 team h2h points snake style draft tomorrow (Sat)…cant seem to get player rankings from your spreadsheet, if I give you my scoring can your run mine out & if not thats ok..thanks
    BATTING NAME SETTINGS
    1B Singles 1 point
    2B Doubles 2 points
    3B Triples 3 points
    BB Walks (Batters) 1 point
    CS Caught Stealing -1 point
    CYC Hitting for the Cycle 5 points
    HP Hit by Pitch 1 point
    HR Home Runs 4 points
    R Runs 1 point
    RBI Runs Batted In 1 point
    SB Stolen Bases 2 points
    PITCHING NAME SETTINGS
    BBI Walks Issued (Pitchers) -.5 points
    BS Blown Saves -3 points
    CG Complete Games 5 points
    ER Earned Runs -1 point
    HA Hits Allowed -.5 points
    HB Hit Batsmen -.5 points
    INN Innings 2 points
    K Strikeouts (Pitcher) 1 point
    L Losses -5 points
    NH No-Hitters 10 points
    PG Perfect Games 10 points
    S Saves 8 points
    SO Shutouts 5 points
    W Wins 10 points

    • Terry says:
      (link)

      So what does FVARz stand for? Fantasy Value A? Rankings z? Thanks
      Im guessing it has something to do with a players value according to the position he plays.
      Thanks

Comments are closed.