Knock knock. Who’s there? It’s your 2019 fantasy baseball points league draft. What are you waiting for? Open the damn door! With draft season just around the corner, I decided it was time to put together my points league spreadsheet. That and the avalanche of emails I got asking when it would be ready. Ok, perhaps avalanche was a bit of an exaggeration, but there was a small storm. Today’s post is the only post I author each year that most of you care about. Once I’ve put it out there I feel a little bit like a chick after a one night stand. However, by now I’ve come to terms with the fact that my popularity will peak early and taper off as the season progresses.

For those that have already drafted, here’s what I’ll say. Your draft was too early. I don’t think leagues should draft more than two weeks before Opening Day. Personally I schedule all of my important drafts no more than a week before. At that point you’ve got a pretty accurate picture of what’s what and have reduced the possibility of a Spring Training injury screwing up your chances before the season has even begun.

Although I’ve written as much quite often, it’s critical to recognize that all points leagues are not created equally, and as a result, rankings for one league most likely do not transfer to another. Over the course of the last twenty years of preparing for points league drafts, I found that most sources of advice only offer generic points league rankings. Last year I referred to this as the “one size fits all” solution. This works ok if you’re looking for a general view of the much bigger picture, but it’s not going to help YOU make the best decisions on draft day and thereafter. While there may be many similarities between rankings across points leagues, such as Mike Trout being the top hitter (although Mookie Betts is creeping into the conversation), why get into the batters box with a wiffle bat when Max Scherzer is on the mound? Instead, why not walk into your draft knowing exactly which player is the right pick for you each time you are on the clock.

I’m going to quote myself from last year when I quoted myself from the year before.

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.” -malamoney

There are several key factors that influence points league rankings. The most important (by far) is the scoring system, but roster composition also plays a part (especially when ranking players across positions). This spreadsheet takes these elements into account and gives you 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.

You’ll have to forgive me for what I’m about to do, but I really do not feel like reinventing the wheel with respect to how I explain how the spreadsheet works. Instead I am going to plagiarize myself. Is it considered plagiarizing if I am stealing from myself? I think I’m safe. If I’m not, does anyone know how I can sue myself. And if so, is it possible for me to actually make money doing so?

Most of the rest of this post is taken from last year’s post with a few minor updates scattered in. There aren’t many changes in functionality between last year and this year. Actually I don’t think there are any, but I do have several planned for next year. I did add tabs for “CF”, “RF” and “LF” for leagues that give a shit. Hold on, there was one change. I did add the ability to specify pitchers as just “P” instead of “SP” and “RP”, if your league is setup that way. As noted on the “Settings” tab, you can either set “P” or “SP” and “RP”. You cannot do both at the same time. It should be self-explanatory.

Ok, let’s explain the spreadsheet.

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 on the “Settings” tab 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.

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 usually doesn’t make sense to draft an RP in the first two or three rounds (maybe more). 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”.

You’ll also find a tab named “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 draft/add players. Do not edit this tab!

Here’s how you add/draft players. On the “Rankings” 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. As your draft is progressing and players are being selected, you should manually update this column. If a player is drafted by another team, enter the number one (1). If the player is 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 so be careful.

I’ve got more to say about the “Your Team” tab, but first 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 Freddie Freeman is ranked 10th and his ADP is 28, then he will have a “Draft Score” of 18. That means that if you drafted Freeman at his ADP of 28, you’d be getting him 18 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 Freeman with the 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 (league specific) ranking versus where most people are generally drafting him. In the case of Freeman, I’d definitely grab him in the second round and know I am getting value.

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.

Let’s jump 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 player’s “Drafted” column on the “Rankings” 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 still experimental indicators. Take them with a grain of salt. Whatever that means.

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 “OF” sheets. For players with multi-position eligibility, you will need to update all appropriate position tabs. Unfortunately this is a very manual process. Deal with it :-)

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 plan to do a more in-depth analysis of data contained within this spreadsheet, but in the spirit of getting it to all of you as soon as I could, you’ll have to wait until my next post for that. For now, enjoy. I hope it helps. Wisdom, Power and Courage!

 

malamoney’s 2019 Points League Spreadsheet (Updated 3/15)

 

 

Follow malamoney on Twitter at @malamoney

  1. umlriverhawk555 says:
    (link)

    I’m in a Points league and this is an absolutely fantastic excel spreadsheet, thank you for putting this together! Only concern (and it might just be me not knowing Excel to the fullest) is that I try to edit Settings for ESPN and it says that I must unprotect the sheet, and I am then asked for a password to unprotect. Any idea on the password or a way to get around this?

    • umlriverhawk555 says:
      (link)

      Ignore that, I completely blanked on the face that there’s a Custom Scoring option! Everything looks great

      • malamoney

        malamoney says:
        (link)

        @umlriverhawk555: Awesome. Let me know if you run into any snags…

  2. Urethra Franklin says:
    (link)

    Thanks for all of this work…

    My league has 5 sp slots and an rp slot, with 5 bench spots and two add/drops a week.

    We’ve lowered our sp start limit this year to 10, but on the day you hit ten you can go as far over that limit as your roster will allow.

    I’m thinking quality or quantity and having some saves guys (5 points a save, 1IP, 1K) to sit in the lineup all week. It also makes sense to save the add/drops for the end of the matchup to play defense or maximize that week’s starts.

    Anything strategy I’m missing?

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

      I play in a H2H points league with a 13 starts limit, but we don;t let people go over the max starts on the last day. With a limit at 10 starts, you probably want to get a top 5 pitcher if you can draft one (Not sure of your scoring format though so it all depends.) I’d also advise that if pitchers are more likely to accrue positive points than not, then having non closers who are very good is also a reasonable way to pick up pitching points. Also, you want to really look out for what teams are going to use an “opener” and which pitchers are coming in for them (i.e. Ryan Yarbrough last year.)

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

      I play in a H2H points league with a 13 starts limit, but we don;t let people go over the max starts on the last day. With a limit at 10 starts, you probably want to get a top 5 pitcher if you can draft one (Not sure of your scoring format though so it all depends.) I’d also advise that if pitchers are more likely to accrue positive points than not, then having non closers who are very good is also a reasonable way to pick up pitching points. Also, you want to really look out for what teams are going to use an “opener” and which pitchers are coming in for them (i.e. Ryan Yarbrough last year.)

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

      I play in a H2H points league with a 13 starts limit, but we don;t let people go over the max starts on the last day. With a limit at 10 starts, you probably want to get a top 5 pitcher if you can draft one (Not sure of your scoring format though so it all depends.) I’d also advise that if pitchers are more likely to accrue positive points than not, then having non closers who are very good is also a reasonable way to pick up pitching points. Also, you want to really look out for what teams are going to use an “opener” and which pitchers are coming in for them (i.e. Ryan Yarbrough last year.)

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

      @Urethra Franklin: I play in a H2H points league with a 13 starts limit, but we don;t let people go over the max starts on the last day. With a limit at 10 starts, you probably want to get a top 5 pitcher if you can draft one (Not sure of your scoring format though so it all depends.) I’d also advise that if pitchers are more likely to accrue positive points than not, then having non closers who are very good is also a reasonable way to pick up pitching points. Also, you want to really look out for what teams are going to use an “opener” and which pitchers are coming in for them (i.e. Ryan Yarbrough last year.)

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

      @Urethra Franklin: I play in a H2H points league with a 13 starts limit, but we don;t let people go over the max starts on the last day. With a limit at 10 starts, you probably want to get a top 5 pitcher if you can draft one (Not sure of your scoring format though so it all depends.) I’d also advise that if pitchers are more likely to accrue positive points than not, then having non closers who are very good is also a reasonable way to pick up pitching points. Also, you want to really look out for what teams are going to use an “opener” and which pitchers are coming in for them (i.e. Ryan Yarbrough last year.)

    • malamoney

      malamoney says:
      (link)

      @Urethra Franklin: This must be an ESPN league. That day you hit ten SP starts where you can go over is a loophole that they should fix. It’s not fair. I have emailed them before about it. ESPN fantasy support sucks.

      Always quality over quantity. I like the strategy…

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

        @malamoney: Holy wow. Apologies for the ridiculous multiple post. Honestly have no idea how that even happened

        • malamoney

          malamoney says:
          (link)

          Is there an echo in here? Is there an echo in here? Is there an echo in here? Is there an echo in here? Is there an echo in here? Is there an echo in here?

          • Urethra Franklin says:
            (link)

            I get the non-closer/starter aspect, but what about closers? Should they move up my list? I’ve haven’t draft one in years, I’d just shove a starter with reliever designation in there.
            I’m roughly thinking two top ten sps, a few solid rps, then some lottery ticket sps

    • Mark says:
      (link)

      Hey man!

      My ESPN league has some different scoring and I’m wondering if your sheet has the ability to compute the following stats:

      Batters:
      Game Winning RBI 3pts
      Grand Slam 3 pts
      Outfield Assist 1pt
      Errors -1pt
      Double Plays Turned 1pt

      Pitchers
      No Hitter 20pts
      Perfect Game 30 pts

      Thanks a ton, drafting tonight!

      Cheers,

      Mark

      • malamoney

        malamoney says:
        (link)

        None of those stat categories are ones I attempt to project. They are far too difficult to do. Think about it. How in the world would you project no hitters. Even game winning RBIs. It’s just not something factor into my rankings/projections.

        Good luck…

        • Mark says:
          (link)

          Touche’

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

    Thank you. This is the single best thing I look forward to on this or any other site

    • malamoney

      malamoney says:
      (link)

      @Big James A’int: Thanks. I might have to quote you in next year’s post…

      • Big James A'int says:
        (link)

        @malamoney: absolutley

  4. Jeremy says:
    (link)

    Won’t lie, seeing the projected points for Mondesi here, compared to Grey’s ranking of him and what CBS has him projected for…I cried a little bit. Thanks for completely harshing my Mondesi buzz, malamoney! You big, otherwise incredibly helpful meanie-head!

    • malamoney

      malamoney says:
      (link)

      @Jeremy: I likely will not be owning him anywhere because his hype has inflated his ADP…

    • malamoney

      malamoney says:
      (link)

      @Jeremy: Sorry, clicked post button too soon. However, it’s exactly these situations that you can take advantage of. Whoever drafts Mondesi in your league is doing you and everyone else a favor by taking him before he should be and not maximizing value with that pick. They are leaving a better player “at that spot in the draft” for the other teams…

      • Jeremy says:
        (link)

        @malamoney: Yeah, the issue is that I was going to have him as my 5th and final keeper. With Trout, Altuve, Verlander, and Rendon in rounds 1-4, he was going to be an AMAZING bargain in rd 25. But based on these projections, he’s barely even rosterable. *sad face*

        • malamoney

          malamoney says:
          (link)

          Hold on just one second there dude. According to the spreadsheet, Mondesi is a steal in the 25th round. I’m not sure of your exact scoring system, but using a generic hybrid, he is ranked around 175th. In a 12-team league that makes him 15th rounder. The main purpose of this spreadsheet is to help you figure out when and when not to draft a player to ensure you are getting (maximum) value out of that pick. Every single player is draft-able and can be a valuable pick when taken in the right draft spot.

          Mondesi is a 15th rounder. Getting him in the 25th round is a steal…

          • Jeremy says:
            (link)

            Ok, so I think what’s going on here is that I must be reading or understanding or using something wrong. When I look at the Hitters tab, Mondesi shows at #107 overall (SS 19 by rough count), and for 444 points. But when I look at the SS tab, he’s #33 at the position and projected for 335 points. Which was what led me to make my previous comment. But guys like Bregman and Lindor’s totals are the same in both tabs. So, what’s going on there?

            • malamoney

              malamoney says:
              (link)

              There’s a bug in the spreadsheet for Mondesi.

              I will try to explain how to fix it, but otherwise I see about getting an updated version available for download.

              Go to the “SS” page. Click on the cell for the player’s points that is in the row above Mondesi. Move the mouse to the little square in the lower right corner of the cell. Then double click. This should update Mondesi’s “FPTS” value and fix the rankings.

              Let me know…

              • Jeremy says:
                (link)

                It worked! Many, many thanks, sir. Sorry to be a pain, but your help is most appreciated. Because as others have said, this tool is *incredibly* helpful

                • malamoney

                  malamoney says:
                  (link)

                  No problem. That was my fault. Lots of numbers. Lot of cells. Lots of late nights…

              • Where Wallace At says:
                (link)

                Good fix. This was also the case with Jose Martinez 1B, Jeff McNeil 2B, Chris Paddack SP <—that one was nuts.

                • malamoney

                  malamoney says:
                  (link)

                  I will be pushing out an updated version later…

                  • Suby says:
                    (link)

                    Thank you again for this – and I absolutely enjoy your posts all season long ;)

                    Not sure if this is an issue, but when I use 1 point total bases in custom scoring, as opposed to putting 1 for 1b, 2 for 2b, etc. not sure it is calculating accurately. When I input for 1b, 2b, etc. it seems to give a much different (accurate?) result.

                    Thanks again!

                    • Suby says:
                      (link)

                      I see now this was addressed below, sorry.

                      Thanks again for this!

  5. Johnnyhobbes says:
    (link)

    Hey Malamoney, My excel program is telling me i need to unprotect this sheet to make changes in the settings . Is that a problem anyone else is having?

    • malamoney

      malamoney says:
      (link)

      @Johnnyhobbes: What fields/cells are you trying to change?

      • johnnyhobbes says:
        (link)

        @malamoney: any of them in the setting tab in the scoring fields.

        • malamoney

          malamoney says:
          (link)

          @johnnyhobbes: Can you change the number of players at 1B for example? How about the number of teams?

          • johnnyhobbes says:
            (link)

            I can change the number of teams and players using the drop down that is coded into your sheet. the green box then says changes detected….BUT i cant do anything about the scoring system. It says The cell or chart I am trying to change is on a protected sheet. TO make a change, unprotect the sheet. You might be requested to enter a password.

            • malamoney

              malamoney says:
              (link)

              Use the three rows labeled “Custom Scoring 1”, “2” and “3” to set your own scoring system. You cannot change the points associated with the rows labeled “Fantrax”, “CBS”, “ESPN”, “Ottoneau” or “Hybrid”…

              • johnnyhobbes says:
                (link)

                thanks, sorry for being an idiot

                • malamoney

                  malamoney says:
                  (link)

                  No worries…

                  • johnnyhobbes says:
                    (link)

                    strange and Im not going to ask you to fix this because the same problem was happening with Hot Rods war room spread sheet when i entered in values. The hitting changes seemed to make sense. The pitching again putss Edwin Diaz as the number one rated pitcher. it gets all wonky, which is disappointing. This problem is obviously on my side. Thanks for making this though

                  • johnnyhobbes says:
                    (link)

                    strange and Im not going to ask you to fix this because the same problem was happening with Hot Rods war room spread sheet when i entered in values. The hitting changes seemed to make sense. The pitching again putss Edwin Diaz as the number one rated pitcher. it gets all wonky, which is disappointing. This problem is obviously on my side. Thanks for making this though

                    • malamoney

                      malamoney says:
                      (link)

                      What are all of the settings you are using. Let me try and reproduce it on my side. Scoring and roster settings please…

  6. Brendan Horton says:
    (link)

    For changing projections, if we want to change, say, Trout, do we also need to change the projection in CF, or just Hitters and OF? Thanks!

    • malamoney

      malamoney says:
      (link)

      @Brendan Horton: Only if you care about CF, RF and LF. If you league just has OF positions, then you can ignore those tabs…

      • Brendan Horton says:
        (link)

        @malamoney: Thank you. Does the same go for the ‘P’ tab, if we only use SP/RP?

  7. Skip Mcgillicuddy says:
    (link)

    Good stuff man, very useful. One thing: My spreadsheet doesn’t seem to be calculating TB into the total points. I mean, it’s a relative stat that when counted in projections doesn’t change rankings much if at all. But i was wondering if that was something that’s consistent with this spreadsheet or if i should start over again. Thanks.

    • malamoney

      malamoney says:
      (link)

      @Skip Mcgillicuddy: I will check this out when I get home…

    • malamoney

      malamoney says:
      (link)

      @Skip Mcgillicuddy: You are correct. It seems I forgot to link in the TB column. Fortunately there is a workaround. Setting total bases to “1” is the same as setting 1B to “1”, 2B to “2”, 3B to “3” and HR to “4”.

      So if you want to set TB to let’s say 2, just set 1B to “2”, 2B to “4”, 3B to “6” and HR to “8” and so on. Sorry for the inconvenience.

      If you already have points set for 1B, 2B, 3B and HR, be sure to add those points to the TB correction value…

      • Skip Mcgillicuddy says:
        (link)

        Cool, i’m gonna go mess around again with the settings now. Thanks again!

        • malamoney

          malamoney says:
          (link)

          Aight. Let me know how it goes…

  8. Josh Atwood says:
    (link)

    Hi Malamoney,

    I’ve saved a copy to my desktop but unable to change the settings. It requires a password. Any suggestion on what to do?

    Thanks,

    • malamoney

      malamoney says:
      (link)

      @Josh Atwood: What are you trying to change?

      • Josh Atwood says:
        (link)

        I’m trying to adjust the hybrid scoring to my league settings. Is this possible?

        • malamoney

          malamoney says:
          (link)

          No, you cannot change the Hybrid scoring system. You cannot change any of the canned systems. Use the three custom scoring rows…

  9. Alex says:
    (link)

    This spreadsheet has singlehandedly won me back to back league championships – Thank you for the work!

    • malamoney

      malamoney says:
      (link)

      @Alex: Thanks. Another quote for next year’s post…

  10. Shivdaddy says:
    (link)

    WOOOOOOOOOOOOOOOOOOOOO! Been looking forward to this! Thanks Malamoney.

    • malamoney

      malamoney says:
      (link)

      @Shivdaddy: You’ve got it Shavdaddy!

  11. macio says:
    (link)

    You are awesome! Thanks for your efforts. Although this is my favorite of your posts, I do read all of them, so keep up the good work.

    • malamoney

      malamoney says:
      (link)

      @macio: Thank you for the good words. Good luck!

  12. Kevin Mench's Big Head says:
    (link)

    Good timing. Went pretty much verbatim off your spreadsheet last year during the draft, got some funny looks at the time and ended up winning the whole pot.
    Being able to weigh for CBS’s weird scoring system was the key, thanks for that.
    Excel is for nerds who like to win money during fantasy baseball season…keep up the good work!

    • malamoney

      malamoney says:
      (link)

      Thanks. I’ll take funny looks all day long if it means having a better shot at winning. Good luck!

  13. Maverick says:
    (link)

    Been waiting for this buddy!!! Been harrassing Grey to track you down lol so THANK YOU for this! Points Leagues are crazy and your AWESOME work makes my life so much easier!!! In a competitive 18 Team League and have 1st pick! WOOT! So I see Max is the undisputed #1! Thanks man!!!!!!!

    • Maverick says:
      (link)

      @Maverick: Ok so after a little more review can I get your thoughts on a draft Startegy…? 18 Team League…I draft 1st. So picks at 1 then 36/37 and 72/73 and 108/108 blah blah blah. Also I have added custom settings as pitchers are Points heavy (3 pts/IP; 5 pt/W/S; 1 pt/K, etc) So my question to you sir:
      Should I take say Trout at #1 and then 2 SP’s at 36/37 maybe? I might get Corbin/Clevinger/Marquez/Grenke possibly? Even if I get 1 of those guys and say Rys Hoskins or Votto I still have a shot at Henricks/Porecello/Wheeler at 72/73?
      This is a League thay will draft Pitchers early but mayne not as early as your rankings predict. Thoughts? Thanks!

    • malamoney

      malamoney says:
      (link)

      It was you. I knew it!

      • Maverick says:
        (link)

        LOL! Sorry but not sorry cuz I NEEDED this from you LOL! The best!! Thoughts on my ‘scenario’?

        • malamoney

          malamoney says:
          (link)

          What’s your scoring system?

          • Maverick says:
            (link)

            Sorry I DID read the “Malamoney Quote”… here it is:

            Batters Stat Category
            Runs (R) 1
            Singles (1B) 1
            Doubles (2B) 2
            Triples (3B) 3
            Home Runs (HR) 4
            Runs Batted In (RBI) 2
            Stolen Bases (SB) 2
            Walks (BB) 1
            Intentional Walks (IBB) .25
            Strikeouts (K) -1
            Grand Slam Home Runs (SLAM) 5

            Pitchers Stat Category
            Innings Pitched (IP) 3
            Wins (W) 5
            Losses (L) -3
            Hits (H) -1
            Earned Runs (ER) -2
            Home Runs (HR) -1
            Walks (BB) -1
            Hit Batters (HBP) -1
            Strikeouts (K) 1
            Wild Pitches (WP) -1
            No Hitters (NH) 15
            Perfect Games (PG) 20
            Quality Starts (QS) 5
            Saves + Holds (SV+H) 5

            Thanks for your time!!!

            • malamoney

              malamoney says:
              (link)

              First pick is Trout. No reason to get fancy. I actually prefer Betts, but I’d still take Trout with the first pick.

              At 36/37 here is who I am targeting:

              Rizzo (unlikely), Soto, Merrifield, Bryant, Stanton, Springer, Bogaerts and Votto

              at 72/73 I’d be targeting:

              Albies, Murphy, Cano and Segura

              But if you wanted a pitcher I’d be targeting:

              Price, Taillon, Flaherty, Hamels, Porcello

              • Maverick says:
                (link)

                Looks like great Advice! When I plug in my custom settings I get this…
                1 Mookie Betts OF 747.96
                2 Mike Trout OF 728.46

                You still say take Trout?

              • Maverick says:
                (link)

                Nice Advice!!! Thanks for your time!!!!
                So when I do Custom Scoring and have Betts coming ahead of Trout!? Still go Trout?
                And at 36/37 you advise going 2 hitters? Or 1 SP and 1 Hitter? This is good ‘chit’ lol! Thanks again!!

                • malamoney

                  malamoney says:
                  (link)

                  Yes, Trout. Because he’s Mike Trout.

                  I realize the need to get an SP, but at 36/37 I’m looking to take the best available players even if that is two more hitters…

                  • Maverick says:
                    (link)

                    Good stuff!! Thanks!!!!

  14. Philomath says:
    (link)

    You have a very large penis, sir. It might be as big as Grey’s. Thank you!

    • malamoney

      malamoney says:
      (link)

      I dare not challenge Lord Grey. But thank you…

  15. RyGuy_4 says:
    (link)

    This would’ve been very helpful about a week ago! haha

    Good stuff though… I play in a points league with one group of guys and an Roto league with another group. So I live and die with Grey’s rankings. I’m glad to see a points spreadsheet too. Keep up the good work.

    • malamoney

      malamoney says:
      (link)

      Sorry man. I alway put this out about two weeks before Opening Day. The reasons are mentioned above, but the main reason is because I use it for my drafts as well and if I did it sooner, I’d have a lot of re-work to do to get it where I want it for my drafts.

      You can still use it to identify players that might not have been drafted, but should have been. Aka “good waiver wire targets”…

  16. Assy says:
    (link)

    Maybe a silly question, but do we need to use the actual Microsoft excel app to edit this spreadsheet?

    • malamoney

      malamoney says:
      (link)

      Not a silly question at all considering I’m not sure of the answer.

      Have you tried any others? If they can handle processing macros, it should work.

      Keep me posted so I can make sure you get a working version…

  17. B. Rabbit says:
    (link)

    Thank you! The day Malamoney’s spreadsheet comes out is considered a holiday around these parts. Time to celebrate hard and prep for a title!

    • malamoney

      malamoney says:
      (link)

      You know just how to get me all warm and fuzzy. Ha! Good stuff man. And good luck. Keep me posted on your progress…

  18. Bitter Beerface says:
    (link)

    Malamoney,

    I asked Grey a question and he said “Son, get yo points lg questions outta here!!! Seriously, malamoney is the man for that!” And I should have come to you first, you’re the Points Lgs Man, no doubt.

    Here’s the question: I only play H2H Pts, and this year I prefer Fantrax format (cuz they pay out! CBS hoards those profits, smh…). So understanding that deep roster format, in the mid-2nd rd: Story or Lindor at the 19th pick. (Goldy also there.). A difficult choice, and one I may encounter three more times in drafts, need your guidance!

    • malamoney

      malamoney says:
      (link)

      What is your scoring system? Is it the same as I have listed for Fantrax?

      • Bitter Beerface says:
        (link)

        Close enough. Some tiny discrepancies: pitching scores differently than you have listed; for hitters, just missing HBP.

        And 5 OF in Fantrax H2H. Otherwise, close enough to use your spreadsheet. Thanks for making it btw!

        • malamoney

          malamoney says:
          (link)

          Sorry, should have asked earlier. 12 teams? Number of players per team? How many players at each position? I want to set my spreadsheet to match your league.

          • Bitter Beerface says:
            (link)

            12 teams

            1 C
            1 1B
            1 2B
            1 3B
            1 SS
            1 CI
            1 MI
            5 OF
            1 UT
            9 P
            8 Bench

            SCORING

            Hitting
            Doubles (2B) 2
            Hit By Pitches (HBP) 1
            Home Runs (HR) 4
            Runs Batted In (RBI) 1
            Runs Scored (R) 1
            Singles (1B) 1
            Stolen Bases (SB) 2
            Triples (3B) 3
            Walks (BB) 1

            Pitching
            Earned Runs Allowed (ER) -1
            Innings Pitched (IP) 1
            Losses (L) -5
            Quality Starts (QS) 3
            Saves (SV) 7
            Strikeouts Pitched (K) 1
            Wins (W) 10

            • malamoney

              malamoney says:
              (link)

              Ok, sorry for the delay. Here is who I’d be targeting with the 19th pick in order of preference:

              Lindor, Gerrit Cole, Goldschmidt, Altuve

              With your next pick at 30 I’d be targeting:

              Rizzo, Freeman, Benintendi, Nola, Carrasco, Blackmon, Soto

              I tried to take into account which players should/might be available when you pick…

              • Bitter Beerface says:
                (link)

                Thanks for getting back to me. That’s a good list. Story doesn’t fit in there or is he more of a late 2nd/early 3rd pick in this format?

                Cheers

                • malamoney

                  malamoney says:
                  (link)

                  I have Story as the 95th overall ranked player. That makes him an 8th round pick. You’re losing value by taking him in the second round. I wouldn’t take him any earlier than than the 6th round, but since someone else in the league will undoubtedly draft him before then, I won’t ever own him. And I’m good with that because I’d rather draft someone else in the 2nd, 3rd, 4th, and 5th rounds who is going to be a better valued pick.

                  I should have another post going live today which talks about this concept…

                  • Bitter Beerface says:
                    (link)

                    Did I see correctly, you have Carlos Santana ahead of Trevor Story in your rankings?

                    • malamoney

                      malamoney says:
                      (link)

                      Yes…

  19. Mickey Maloney says:
    (link)

    Wow, dude. This is great. Thanks for putting it together. I’m picking #4 in a traditional 12 team H2H league so assuming no Trout, Betts or Scherzer for me. I was leaning DeGrom, Ramirez or Acuna. Who do you think is the safest pick?

    • malamoney

      malamoney says:
      (link)

      You’re welcome. What is your scoring system?

      • Mickey Maloney says:
        (link)

        Thanks in advance. As a general rule, I feel like starting pitching was a more sure thing last year so while I traditionally go pitching early, I’m leaning hitter this year. Above all, I want safe early picks tho.

        Roster:

        C, 1B, 2B, SS, 3B, CI, MI, 3 OF, 1 UTILITY

        8 SP, 2 RP

        4 Bench

        4 DL spots

        Scoring:

        Hitting

        SINGLES 1

        DOUBLES 2

        TRIPLES 3

        HOME RUNS 4

        RBI 1

        RUNS 1

        STOLEN BASE 2

        WALKS 1

        STRIKEOUTS -1

        HIT FOR CYCLE 5

        Pitching

        INNINGS PITCHED 1

        QUALITY START 3

        WINS 5

        LOSSES -1

        SAVES 5

        BLOWN SAVE -1

        EARNED RUNS -1

        WALKS -1

        STRIKEOUTS 1

        COMPLETE GAME 5

        SHUTOUT 5

        NO HITTER 5

        PERFECT GAME 10

        • malamoney

          malamoney says:
          (link)

          Acuna? He is ranked in the 40s. That makes him a 4th round pick. Taking him in the first round would be a horrible idea. This is why I will not own him in any league. I’m will to reach a round if I really feel he’s going to help me. In some cases two rounds if it’s a keeper league. Now way I’m taking him in the first our second round of your draft. Your choices are Sale, deGrom, Ramirez, Verlander or Altuve. Altuve’s health concerns me since we are talking about your first round pick.

          Something very important keep in mind that most people will be drafting based on ADP and perhaps even more they will be drafting based on the players’ rankings in the draft software you are using. The point is, the rest of your league will not have my spreadsheet (most likley). You can use it to help you get value picks…

  20. Ron says:
    (link)

    Malamoney! I’ve been anxiously awaiting this spreadsheet like Christmas morning! Thanks for all your hard work and dedication! You really are a gem of a man!

    2 quick questions.

    1. Our league starts 2 Middle Infielders (2B/SS) & 2 Corner Infielders (1B/3B). We don’t have individual positions in the IF, is there a way on the spreadsheet to set 2B, SS, etc in settings to zero?

    2. Because I can’t set these and see a true ranking for my IF, I’m torn on my keepers.

    My scoring system is:
    (R) 1.5, (1B) 1, (2B) 2, (3B) 3, (HR) 4, (RBI) 1.5, (BB) 1, (IBB) 1, (HBP) 0.5, (SB) 2

    (IP) 2.49, (H) -1, (ER) -1.5, (BB) -1, (K) 1.5, (QS) 3, (CG) 2, (SO) 3, (W) 5, (SV) 6, (BS) -2, (HD) 2

    We can keep 5 players, 3 of any choice, 1 player that was selected off waivers last season and 1 rookie (under 600 AB).

    I drafted last year:
    Jose Altuve, Freddie Freeman, Christian Yelich, Khris Davis, Xander Bogaerts, , Trevor Story, Blake Snell, Rick Porcello, Zack Greinke

    Picked up off the waiver wire:
    Mike Foltynewicz, Scooter Gennett, Eugenio Suarez, Yasiel Puig, Roberto Osuna, Miles Mikolas

    Rookie:
    Eloy Jimenez

    I’m leaning towards this: Freeman, Yelich, Snell, Jimenez & Gennett. Should I take Altuve over Snell and hope for the best on pitchers in the draft? Is there some other obvious combo I’m missing? I pick 12th.

    Thanks!!

    • malamoney

      malamoney says:
      (link)

      There is no way for you to set the individual infield positions to zero. Not in the version I share with the public. However, by setting 1B, 2B, 3B and SS to one and 1B/3B and 2B/SS to 0.5 you will come very close to the same end result.

      How many players at the other positions?

      • Ron says:
        (link)

        Ahh… 0.5, didn’t think if that.

        We have 23 total spots, (C) 1, (2B/SS) 2, (1B/3B) 2, (OF) 3, (UTIL) 2, (P) 2, (SP) 4, (RP) 2, (BE) 5, (DL) 3

        • malamoney

          malamoney says:
          (link)

          I’d probably keep Altuve, Freeman, Yelich, Folty and Eloy, but I can see the pivot from Folty to Gennett due to Folty’s injury. Then I’d go after pitcher’s early in the draft…

        • malamoney

          malamoney says:
          (link)

          Also I’d like to add that your scoring system stinks. No negatives for strikeouts or caught stealing or losses? +1.5 for a pitcher strikeout, but only -1 for a walk. Quality starts should be eliminated all together. Garbage stat.

          Ok, good luck…

          • Ron says:
            (link)

            Totally agree! I’ve been lobbying for years to change the scoring system… just have to beat the knuckheads at their own game! Thanks again for the advice and as always for you hard work on the spreadsheet! It truly is invaluable.

            • malamoney

              malamoney says:
              (link)

              No problem. Good luck!

  21. Sagacious Sally says:
    (link)

    Bravo!! This is awesome. I look forward to this every year.

    I participate in an H2H NL Only Weekly Points League and for years have been looking for a way to calculate points for ERA and BA. For example, ERA and BA for a week range from 0-24 pts. For a pitcher, no earned runs for the week nets 24pts, 2.00-2.49=16pts, 5.00-5.49=4pts, etc. Batting Average: .576+=24pts, .301-.325=13pts, .126-.150=6pts, etc.

    Any suggestions on how to account for these two scoring stats in the projections? Both are so heavily weighted and impacts points projections, deciding on tiers, etc.

    Thanks.

    • malamoney

      malamoney says:
      (link)

      Thanks!

      The points for ERA and BA are very difficult to account for. Here’s what I’d do. For ERA, I would take a pitcher’s projected ERA for the season. There are approximately 26.5 weeks in a season, but let’s round down to 26. Let’s say Pitcher A is projected to have a 2.45 ERA. Then I’d multiply 26 by 16 and add that to the pitcher’s total. I’d follow the same process for batting average.

      The biggest potential flaw with this plan is that it looks like there are gaps in ERA and BA that do not offer points. Is this true or are they just missing from your post? For example, how many points are given to a pitcher in a week with an ERA of 3.00?

  22. tdub says:
    (link)

    Malamoney you are the man.

    Studying up and wondered where you would slot Bieber and Kakuchi?

    Didn’t see them on your spreadsheet and Donkey and/or Grey seem high on them?

    Thanks for all you do!

    • malamoney

      malamoney says:
      (link)

      Thanks man. I will be releasing an updated version with a few minor fixes (missing players) tonight or tomorrow. A few players always fall through the cracks, but I just figured out a way to curb that from happening (most of the time). Thanks for the heads up…

  23. T Cole Anderson says:
    (link)

    Mala, once again, thank you. I unfortunately already drafted sunday night but going through it and seeing how I screwed up in my draft (very bad in the second half) I noticed that when you mark a player drafted on the position pages, it does not transfer to the ranking pages.

    Thanks again, and yes I do not believe we should draft this early but we had to this year due to multiple conflicts later in the month. love the sheet.

    • malamoney

      malamoney says:
      (link)

      You need to mark them drafted on the “Rankings” tab. It works the other way. The intent is to mostly stay on the “Rankings” tab during your draft while swapping to the other tabs occasionally to check things out…

      • T Cole Anderson says:
        (link)

        gotcha, as it gets to the later rounds and your projections are usually different than the fantasy sites, it can get hard to find someone on the rankings. as someone in my league may choose someone that ranks highly on CBS but much lower on your spreadsheet. we do an online snake draft and it can get hard to keep up. It is easier for me to find them on the individual page and I thought if I checked “1” there it would transfer to the Rankings tab. Maybe next year.

        Thank you again, knowing enough about and working with spread sheets enough to know that what you create is very time consuming and know that you are greatly appreciated.

        • malamoney

          malamoney says:
          (link)

          ctrl-F is your friend…

          • Cole says:
            (link)

            learn something new everyday. I will try for sure and saw the post on this further down

            • malamoney

              malamoney says:
              (link)

              Cool…

  24. holyscheisse says:
    (link)

    This yearly post is one I look forward to every season. The work and effort you put into it is outstanding. To that I say thank you very much sir!

    A quick question, I’m trying to determine best use of this and/or the war room spreadsheet. One of my main leagues is a 12-team h2h auction points league. In your spreadsheet, there’s no auction values, so sometimes I turn to the War Room spreadsheet for auction values as they’re listed in it.

    Does the User Input tab (yellow boxes) for points leagues on the War Room sheet use your info and data? I’m curious because several rows show “…not supported in 2017…2018…2019…due to using Steamer projections”.

    I’m just trying to find a good balance to work my auction points league. Thanks for any help!

    • holyscheisse says:
      (link)

      Another question just noticed:
      The spreadsheet only allows up to 26 players and we have 29. Is there a way to adjust this to 29 without messing anything up?

      Or should I just set to 26 on the spreadsheet and not worry about it? Thanks!

      • malamoney

        malamoney says:
        (link)

        I am going to release an updated version with a few fixes. I will include the ability to have up to 29 players. Probably won’t be until tomorrow…

    • malamoney

      malamoney says:
      (link)

      I am not familiar with the war room spreadsheet. As far as I know it is not compatible with my points league sheet. As for auction values, that is not a feature I include in this spreadsheet. Auction values are certainly doable, but you’re going to have to come up with that one on your own. I can’t give away all of my secrets. Sorry :-)

      • Roger Anderson says:
        (link)

        the War Room spreadsheet is the one Rudy Gamble does and is available with Streamonator etc..

        • malamoney

          malamoney says:
          (link)

          I misspoke a bit. I am familiar with the war room, but it is in no way related to this spreadsheet. There is no integration points between the two. They are two entirely separate tools…

  25. jose says:
    (link)

    I get nervous this wont come out in time every year and every year you deliver!

    A. Just to refresh my memory…I we can roster 25 guys with 22 starters and 3 bench slots, I still use a roster size of 25 correct?

    B. Is there any way to account for 3 util slots instead of only 2?

    C.

    D. If we use 1 starter of each of LF, CF, and RF, I just want to double check the OF rankings back against the LF, CF, RF rankings to see where each guy climbs and falls correct?

    Can’t thank you enough for these!

    • jose says:
      (link)

      One last question. What is FPTS and and should it change based on my league settings?

      • malamoney

        malamoney says:
        (link)

        FPTS stands for fantasy points. And it should definitely change as you change you league settings…

    • malamoney

      malamoney says:
      (link)

      We’ve got you covered jose!

      A. Yes

      B. Not on this version make available to the public (I will consider adding that when I release an updated version tonight/tomorrow with a couple of other fixes)

      C.

      D. While there is a separate tab for CF, RF and LF, only the OF values are considered when generating the “Rankings” tab. Those others are just for reference. The closest you can get would be to set the number of OF players to 3. It’s still not going to be right, but it will be in the ballpark.

      You’re welcome…

  26. Roger Anderson says:
    (link)

    MAL – Fantastic work once again.

    However – I noticed you are still using a keyboard, “How quaint” but also VLOOKUP which is only slightly less quaint. On my overworked spreadsheets, I have migrated to INDEX, MATCH, MATCH which is a much more powerful way to do these kinds of lookups. It is my understanding that MS is going to discontinue V & HLOOKUP at some point.

    BTW -0 You can even get crazy and use INDEX, MATCH, MATCH, MATCH, MATCH to have 2+ criteria for Row and Column choices.

    There is ONE reason to keep VLOOKUP and that is when you want only the last record versus the first.

    If you would like to explore this further I would be happy to work with you. It takes a bit of time to get the hang of the new way, but once you get it, you do not want to go back.

    • malamoney

      malamoney says:
      (link)

      Thanks. Yeah, I don’t profess to be any sort of Excel expert. I speak JavaScript and Python which is how all of my stuff works locally. I only put together the spreadsheet so I can share the content and functionality with the rest of you.

      I’m more likely to put a web-based user interface on top of my scripts than to spend time getting better at Excel and re-working the spreadsheet.

      Certainly appreciate the offer however…

      • Roger Anderson says:
        (link)

        If I may ask a few “inside” questions at some point, I might try it. I didn’t dig too deep but there are some threads I could not follow.

        On my spreadsheet, I import data from Razzball and sometimes the columns move. IMM helps me deal with that. I use my sheet to predict how the rest of the season will go based on YTD and ROS values. Helps me relax or see where I need to fix things.

        Also, you forgot the Oxford comma on the Settings tab “Wisdom, Power, and Courage”

        Thanks again for doing this spreadsheet. It is a massive amount of work that you share so freely. A true devotee of the art.

  27. Roger Anderson says:
    (link)

    Any chance I could get teh password to unlock the hidden sheets? my twitter is @drrogera if you want to/care to DM me.

    • malamoney

      malamoney says:
      (link)

      Same chance that Dee Gordon leads the league in homers this season. Sorry…

      • Roger Anderson says:
        (link)

        That is quite understandable, the secret sauce is yours and I should not have asked. I have about 90% “Macro-Free” the rest I will figure out in a way that works for me.

  28. Thank you! What a thing of beauty! I really appreciate your hard work here and thanks for getting it done before my draft! I look forward to your posts! Keep them coming Points League Sensei!

    • malamoney

      malamoney says:
      (link)

      Thank you. My plan is to keep them coming. Should be another one real soon…

  29. Johnnyhobbes says:
    (link)

    Hey I got my scoring issue settles, Just curious- I may have deleted him by accident but is Shane Bieber in the file?

    • malamoney

      malamoney says:
      (link)

      No, he was an accidental omission with a few other players. I will be releasing an updated spreadsheet today or tomorrow with the missing players and a few other minor fixes…

  30. Gringo says:
    (link)

    Awesome work… Thank you. Just a note, I can’t find Felipe Vasquez.

    • malamoney

      malamoney says:
      (link)

      Thanks. Yes, I am aware. He was an accidental omission with a few other players. I will be releasing an updated spreadsheet today or tomorrow with the missing players and a few other minor fixes…

      • Gringo says:
        (link)

        Follow up, in your spreadsheet in the rankings tab you have Buster Posey at 17 overall and Gary at 19, this is my 1st year playing H2H points and want to know if I should be targeting with my next pick? Round 8 on a 10 man league? For info only JT has been drafted.

        • malamoney

          malamoney says:
          (link)

          Not exactly sure what you are asking. I will not own Sanchez in any league because I think Posey is just a valuable (slightly more) and he is going a few rounds later. I’d need to know your scoring system to know your league specific rankings to know approximately who to target in specific rounds, etc…

  31. Jay says:
    (link)

    I might be doing something wrong, but when I’m in the rankings tab, I do a Ctrl+F to find a player quickly on the list, it doesn’t not find the player name. I’ve tried it with multiple players. Is the find ability disabled?

    • Jay says:
      (link)

      *it doesn’t find the player

    • macio says:
      (link)

      Me too. After you Ctrl+F, hit the “options” button which will take you to a new find screen that works. I found that I need this extended version of the find screen to locate players using this spreadsheet. Hope this works for you.

      • Jay says:
        (link)

        I figured it out, I needed to unclick “match case” & match entire cell contents” under the options screen on Ctrl + F. Thanks for the help.

    • malamoney

      malamoney says:
      (link)

      I don’t even think you can disable ctrl-F.

      When you press ctrl-F check the following values:

      Within: this can be “Sheet” or “Workbook”
      Look in: this should be set to “Values”
      Make sure that “Find entire cells only” is not checked
      Make sure that “Match case” is not checked as well

      Let me know…

  32. JessicaF says:
    (link)

    Finally a spreadsheet/information/prep that I can use! I’ve been making my own for years and it doesn’t compare to this beast.

    I’m in a H2H Daily Points League/26 man roster/1100 innings limit/7 keepers. To top it off, you keep your guys in the round you drafted them the year before, with them inflating 2 round spots after their first kept year. For example: I have Trea Turner in the 11th and Severino in the 13th. It makes values, trades, and keeper decisions much more interesting and complicated. Also makes traditional prep almost impossible.

    Thank you for making my life easier this year!

    • malamoney

      malamoney says:
      (link)

      You’re welcome. Good luck…

  33. Louis V says:
    (link)

    Awesome malamoney! Got my points draft on Sunday so this is just in time! In our league the pitching is 5 SP, 2 RP, 3 P spots.. then 3 Bench spots. Which usually teams are keeping 1-3 SP’s on their bench. The SP tab only goes up to 7. Should I just set that to 7, or should I use the P tab and just enter like 10 there? Typically just punt closers in this league so targeting SP’s with RP eligibility. Thanks for your work Money!

    • malamoney

      malamoney says:
      (link)

      Just set SP to 7 and RP to 2. It will get you close enough. You can try setting P to 9 and compare as well…

      • Louis V says:
        (link)

        Thanks MM!

        • malamoney

          malamoney says:
          (link)

          You’re welcome…

  34. Cramerica Industries says:
    (link)

    I plugged in custom league scorings, which are just a tweak of standard yahoo, but I’m getting the sense something is wrong because catchers are ranked extremely high.
    -Realmuto at #9
    -Sanches at #23
    -Posey at #40
    -Molina at #43

    Did I screw something up to make catchers more valued? Or is there a better way to sort to get accurate overall rankings? Thanks!

    • malamoney

      malamoney says:
      (link)

      The thing to remember is that catcher is a position just like 1B. Getting the best player at a position is going to give you an advantage at the position. Having the best catcher is most often going to be better than having the 5th best 2B because the difference between the best catcher and the middle tier catchers is going to be greater than the 5th best 2B and the next several 2B. That is just an example.

      Obviously I would not take Realmuto in the first or second rounds, but the point of the spreadsheet is to give you league specific rankings and show you what a player is really worth to your team in relation to players at other positions.

      This also manifests itself with RP, but I saw that as a bigger problem and introduced the concept of “Reduce RP Weight” which drops the comparable FVARz value of each RP to give them a more realistic overall ranking.

      My suggestion is to look at ADP and than compare it to “Rank” to help you make a decision…

  35. Roger Anderson says:
    (link)

    The Standard Dev on OF seems to give a different value than the same formula for the other positions? Is that secret sauce or ? thanks

  36. oldmanoldman says:
    (link)

    hello.

    many thanks for the great resource.

    your adp is pulled from….espn? my draft is in yahoo. was wondering if you had a suggestion for best or easiest way in import yahoo adp into your rankings tab, so i can calculate draft score with this data instead. gotta know when to pull me some trigger on carlos santana, NA’MENE?!

    also, i love you.

    oldman

    • malamoney

      malamoney says:
      (link)

      ADP is pulled from a couple sources and averaged together. Not a lot of H2H ADP sources out there.

      There is no easy way for you to import your own ADP. Sorry…

      • Oldmanoldman says:
        (link)

        I love u2

        • malamoney

          malamoney says:
          (link)

          Love you too old man…

  37. Noah Warren says:
    (link)

    Hi, I’m a first time viewer of the spreadsheet and I have to say it looks quite incredible. Great Job. I am having one issue though. I’m sure it is something really easy and stupid that I am missing but for the life of me I do not see “calculate rankings” in the settings tab. I also do not see any movement of players when I change if they were drafted in the rankings tab.

    Really want to use this great spreadsheet this year.

    • malamoney

      malamoney says:
      (link)

      My first suggestion is to go to my post that went live today and use the spreadsheet there as it has updates and fixes.

      https://razzball.com/points-leagues-adp-its-as-easy-as-123/

      There is a “Calculate Rankings” button on the “Settings” tab. It’s kinda in the middle of the page.

      Players don’t move when you mark them as drafted. Instead they are highlighted in “red” or “green” depending on if you drafted them or another team. Players you draft will also appear on the “Your Team” tab.

  38. Blake Somerville says:
    (link)

    is there an updated version of the spreadsheet? or is the one up top the most recent?

  39. Ari_Balls says:
    (link)

    How do you properly update the FVARz on the rankings tab after updating position eligibility? Got my draft this afternoon.

    • malamoney

      malamoney says:
      (link)

      You don’t. You just stick with the position eligibility listed in the sheet.

      Who did you change?

Comments are closed.