5 Responses

  1. Ryan B
    Ryan B at | | Reply

    Now if only there were a way to automatically populate the info on which teams draft who during an online draft! If someone found a way to grab that data from the big online drafts (Yahoo, ESPN, etc.) that’d be a killer app.

    1. Tim
      Tim at | | Reply

      I don’t think there is a way to run a spreadsheet with that data off a draft app in real time, but you can use a macro and a combo box to populate the spreadsheet automagically in tandem with a draft app.

      1. Tanner Bell
        Tanner Bell at | | Reply

        There are some online options, like FantasyPros, which will sync to a live draft. But I don’t know of a way to set this up to do it yourself with a spreadsheet. I use the manual approach above.

  2. How to Create a Position Cheat Sheet in Excel | FanGraphs Fantasy Baseball

    […] How to Track Drafted Players in a Spreadsheet – This set of instructions guides you through adding a drop down menu that lists each team in your league. You can quickly use this drop down during the draft to mark off drafted players and assign them to teams in the league. We added something similar to this in the first edition of the Rotographs Rankings Spreadsheet. […]

  3. How To Calculate Projected Standings For Your Draft | Smart Fantasy Baseball

    […] wrote about how to track drafted players in a spreadsheet last January.  If you haven’t read that yet, please do.  The instructions that follow pick […]

Leave a Reply