Attention auction enthusiasts

I am fired up today because we just reached an agreement with a company to produce for us an excel-based Auction Draft tool that I think will be totally bad ass. We will have more details to come, and this will take probably 2-3 weeks to complete, but here’s the basics of this new tool that will, of course, be free for subscribers.

  1. Before your draft, you will enter all the basic info for your league (scoring system, number of players in your league, number of players at each position, etc.).
  2. At the start of the draft, the tool will have an estimated “highest bid” for each player. In addition to using our projections as the baseline for dollar values, we’ll actually be incorporating Mike Horn’s 2013 Price Tiers for the various positions into this tool, so it will have 2013-specific auction intelligience built into the tool.
  3. As people get drafted, you enter the bid amount and the team they went to.
  4. The tool would then do real-time update values for players (based on our projections), adjusting for factors like: owners over or under-bidding for players (adjusts value of other guys left), whether people have filled their slots for starters and likely reserves, and other key stuff. It will essentially give you updated “best bids” based on how the draft has gone so far.

The challenge for me with these computer programs has always been accounting for the human element in fantasy drafts and auctions, and I believe we will actually have a tool that will do that. This should be a robust and fun tool that will greatly help those in the heat of the action in an auction. If you’re completely out of your realm even using excel, the good news is this tool will help us generate much more accurate Auction $ values that we will published statically.

Unfortunately, we’re getting a late start on this, but with seven weeks before opening day, we should have the tool done four weeks before the season starts, which is obviously in time for most auctions. I’m sure in 2014 we’ll be looking to move this tool into an app and online program, so this looks to be just the start.

If you’re not a subscriber and this tool intrigues you, you should definitely check out our “What you get” page to see everything you can receive as a 2013 subscriber. Also, there’s a 5-minute flash movie at that has a comprehensive overview of all the benefits to subscribing.

Category: News


20 Responses

  1. david says:

    will it have IDP?

  2. Jimmerz says:

    Great news. I actually suggested a tool like this a couple years ago. Good to see auctions finally get some Guru love.

  3. John says:

    It is about time we get Guru into auctions. Any guy with a cheatsheet can do a draft, not so with an auction

  4. John Hansen says:

    I see no reason why it can’t/won’t include IDP

  5. John Hansen says:

    My bad, as of now it won’t have IDP, but possibly after release we can add.

  6. Jeff says:

    Will you be able to enter the salary cap number? Or will it be based on 100 million cap?

  7. John Hansen says:

    Catering it to the cap is a big part of this, so yes.

  8. Jimmerz says:

    I wonder if this will be sort of a “permutation drafting” tool for auctions. has an auction tool called RoboAuction that is a great concept (and seems similar to what you’re trying to do), but unfortunately their user interface is horrendous and their implementation is almost as bad. Might be worth checking out though for ideas.

  9. Joey says:

    My auction is scheduled for August 31- should I expect this tool to be available before then??

  10. Bobby says:

    Will the auction tool let us put in keepers before the draft and subtract values from the cap?

  11. Billy says:

    Sounds great John. Question though: Alot of us including yours truly are in auction leagues where we keep players. Will this new tool take into account players that won’t be available because they are being kept?

  12. Ken says:

    Based on what it sounds like, I think we’d be able to enter keepers before the draft. If we are supposed to enter in the values of players as they are purchased, I don’t see why we couldn’t start it off with the keeper players and their values.

  13. John Hansen says:

    I’m not sure about keepers. This was a last-minute thing as we finally found a guy who could do it. It does sound entirely possible, but I don’t know for sure. It might be something that can be added after initial release, which should be in about a week or so.

  14. John Hansen says:

    OK, this is from the developer:

    While I haven’t built in any special keeper logic to the tool, it should still be easy to handle keepers – Ken who commented on your blog post has it right – you can just start off by entering the keeper players and their values. What’ll be cool is it’ll then increase the price of other players accordingly – if you have, say, Adrian Peterson and pay $3 for him, then it increases the demand for everyone else (since lots of money has been saved by getting Peterson for so cheap).

  15. Jimmerz says:

    Sounds good. That’s exactly how it should work.

  16. Tom says:

    Sounds like a great idea! Any idea when we could expect it out?

  17. Jess says:

    amped to see this spreadsheet.

  18. John Hansen says:

    We “soft launched” it today, which means we put it up without any promotion in case we find bugs. Call it a beta launch if you’d like, but it’s here

  19. Jimmerz says:

    So how do you customize the rankings with this bad boy? The rankings seem to be pulling from some hidden data source. Does it update from the website or something?

  20. bill says:

    has anybody had any luck with this outside of ms excel? I’m having issues with mac numbers and google docs. am i the only one?

Leave a Reply