3 Responses

  1. How to Use Excel to Web Query DFS and Other Fantasy Baseball Data | Smart Fantasy Baseball

    […] I’m designing a reusable spreadsheet, the initial hurdle is just to get all the information into the file. We can then use VLOOKUPS and […]

  2. rocky colavito
    rocky colavito at |

    Thought: change all DH identified players in the ID map to some other position to make it easier to deal with replacement level players and position scarcity calculations with the RSGP. I do it manually, but then have to re-do it every time the ID Map refreshes, and to leave them as DH screws up the formulas. There are usually only 12 or so of these guys, so it doesn’t make a lot of sense to keep them as DH only. (people can always make a note or color code them on their rankings tabs to indicate their limited position eligibility for their particular league if need be).

    1. Tanner Bell
      Tanner Bell at |

      Hi Rocky,

      That’s an interesting suggestion. The way I handle DH is by putting a line for “DH” directly into the replacement level table. Just like it’s any other position. I make the formula for the SGP relating to that position equal to the MAX of the totals above. So after I’ve entered the replacement level for 1B, 2B, SS, etc., the DH replacement is calculated automatically as the highest of any single position’s replacement level.

      My reasoning is that you would not select a “DH-only” player if there were other players available still with higher expected SGP. Therefore, replacement level for a DH player has to be the highest level of all other positions.

      I think tracking that a player is considered “DH-only” is important information in the Player ID Map.

Comments are closed.