7 Responses

  1. Dan J
    Dan J at | | Reply

    Can you pull the data from Hitter’s Rank and Pitcher’s Rank into one table so you can have a complete all inclusive list?

    1. Tanner
      Tanner at | | Reply

      Hi Dan, I don’t have a very elegant way to do this, but this seems to work.

      1. Start a new tab. In cell A1 put a header for “PLAYERID” and in cell B1 a header for “$VALUE.
      2. In cell A2, put the formula ='Hitter Ranks'!A6 (this should correspond to the very first ID of the very first hitter listed on the Hitter Ranks tab).
      3. In cell B2, put the formula =IFERROR(VLOOKUP(A2,MYRANKS_H,COLUMN(MYRANKS_H[$VALUE]),FALSE),0)
      4. Copy these formulas down for 700-800 rows (enough to list out all the hitters on the Hitter Ranks tab.
      5. Once the last hitter name appears, let’s say in row 800, in cell A801, put the formula ='Pitcher Ranks'!A2 (again, this should correspond to the very first ID of the first pitcher on the Pitcher Ranks tab).
      6. In cell B801, put the formula =IFERROR(VLOOKUP(A801,MYRANKS_P,COLUMN(MYRANKS_P[$VALUE]),FALSE),0)
      7. Copy the formulas in cells A801 and B801 down far enough to list out all of the pitchers.
      8. You can then convert this into a table and sort by dollar value in descending order.

      Hope that helps.

      Tanner

  2. Roger
    Roger at | | Reply

    For some reason the stats don’t show up for some players like Mike trout in the hitters rankings.
    I probably put something where it shouldn’t, IDK.
    Thanks

  3. Chris Petersen
    Chris Petersen at | | Reply

    Hey Tanner,

    Loving this tool so far. Extremely helpful to give a leg up on the guys in my league who i am positive are not doing anything like this.

    My question is that my pionts league awards a point for total bases. Is there a way I can use the fangraphs projections to figure total bases?

    Thanks,
    Chris

    1. Tanner Bell
      Tanner Bell at | | Reply

      Hi Chris,

      Thanks! I agree, thinking through projections and rankings like this is a huge advantage on many levels.

      I think the formula for total bases would be =1*HITS+1*2B+2*3B+3*HR

      I know that looks a bit odd, but if you assume one base for each hit, then you’d only add one more base for a double (for a total of two bases). Or a home run would be one base for the hit, then three more for the “extra bases”, for a total of four bases.

      To do this, I think you’d pull H, 2B, 3B, and HR from the projections onto the Hitter Rankings tab. Then add a column to calculate total bases using that formula from above. Then add a column for determining the point value you get from the total bases.

      Hope that helps.

      Tanner

Leave a Reply