Don't be shellfish...Share on FacebookTweet about this on TwitterShare on Google+

Over at FBHOF.com, I’ve been lamenting my inadequacies from the past 2+ years which resulted in an inordinate amount of time number crunching in Excel.  My quest – a draft day “war room” that allowed me to keep my finger on the pulse of the league while minimizing my effort.  I don’t know about you, but I prefer to keep track of more things as opposed to fewer, this path can ultimately take precious minutes away from thinking about your next pick.

Presenting the Fantasy Baseball Hall of Fame War Room.   It’s an auto-updating Excel workbook that keeps track of all the necessaries:

• Color Coded Dashboard that “crosses off” selected players
• Team by Team analysis of players taken, players left.
• League wide finances – how much was spent, how much can still be spent, and that all important “Max Bid”
• Real time projected totals, along with real time projected league standings.
• “Traffic Light” Goal Tracking Dashboard
• Auto updating Draftee List for you team, that includes both the projected dollar amount and winning bid amount so you can keep track of your value gained or lost.

There is a more on the project here, including screen shots and instructions on how to download. It’s free too, though that might not live up to the grand prize of $50 dollars worth of stomach pain and quick moving bowels.

31 Responses

  1. Steve says:
    (link)

    First Grey’s Top 300 and now this?

    I’m going to have to go and have a lie down.

  2. Grey

    Grey says:
    (link)

    @Steve: The Vernon Wells injury post didn’t put you over the edge?

  3. Steve says:
    (link)

    @Grey: Nah. Did make me a little light-headed though.

  4. Grey

    Grey says:
    (link)

    @Steve: I wonder how people feel about going to three posts a day for the month leading up to Opening Day. I’m never sure if it’s information overload.

  5. Steve says:
    (link)

    @Grey: The more the merrier, I say, since you guys do it in such a way that there’s more than just baseball to your work.
    I think it depends to an extent on the posts, though. For example, something like the Top 300 takes some digesting, so to drop something like a “Grey’s 50-Point Plan For Fantasy Baseball Domination” over the top of it might be a little much.
    But if you’re talking about posts like the VW post appearing more regularly, then I say bring it.

  6. Grey

    Grey says:
    (link)

    @Steve: Yeah, agreed. Thanks for filling out the suggestion card.

  7. sean says:
    (link)

    @FBHOF: any way we get a ten-team version? I’ve been involved with a pay service that charged a pretty penny for the same thing — except it sucked.

    @grey: more content is always appreciated unless it results in more visitors, resulting in me getting hosed on draft day.

  8. Lou Poulas

    Lou says:
    (link)

    @sean: There are multiple league type versions. There is a link on the left hand side of the screen in the menu.

  9. Iceman says:
    (link)

    When’s the middle reliever rankings list? Brutha’s gotta get some hizzolds up in this league!

    Gracias

  10. peter says:
    (link)

    It’s a fantastic spreadsheet – it clearly took *a lot* of work. Also, nice to have included spreadsheets for straight drafts, 12 and 14 team (links on the left).

    I’d definitely pick it up for my drafts (I’m only doing straight this season, no auction) but for one thing: it doesn’t slice bread.

    Which is to say, it was designed for auction drafts – so it doesn’t track a straight draft as it progresses. You can’t see who has current/upcoming picks, and you can’t see who was taken and when. Also, I prefer to not spend time looking up players (to cross them off) during a draft; if you can just type a name in or something (and then that name is removed from the player pool), then you’re cooking w/ gas.

    But, again, this sheet wasn’t designed for straight-drafts. For auctions, it looks very, very good.

  11. Lou Poulas

    Lou says:
    (link)

    Yeah, it’s not a great straight draft tool, agreed. Designed for auctions, jerry rigged for straight drafts. At a minimum, I thought the ability to cross players off a draft list automatically would be of use to some straight drafters.

  12. peter says:
    (link)

    @Lou: Oh, absolutely it’s useful to straight-drafters. Like I said, it’s a great spreadsheet. And open/available to the public, no less!

  13. Steve says:
    (link)

    @Lou: I may have missed this, but whose projections have you used? Or are they an amalgam of various sources?

  14. Lou Poulas

    Lou says:
    (link)

    Various sources

  15. Martin says:
    (link)

    hey what do u think of kevin slowey this year? I think big numbers

  16. peter says:
    (link)

    @Lou: One thing I noticed… Ryan Braun is still listed as a 3B – I don’t think he played any games there last year, but I could be wrong.

  17. Lou Poulas

    Lou says:
    (link)

    @peter: Thanks! I will update

  18. redmann says:
    (link)

    Lou this is the best spreadsheet I have seen so far. Thanks for posting it for everyone to use.

    Any chance of doing one for larger leagues? I would love this in a 18 team format.

    Could you just design like a 20 team one and people in smaller leagues could just not use all the team spaces? Just a thought.

  19. Lou Poulas

    Lou says:
    (link)

    @redmann: I think I will create a generic format for large leagues. I couldn’t do the projected team rankings, but that is a nice to have instead of a must. Give me a day or so.

    Thanks for the kind words!

  20. AJ says:
    (link)

    Just when the news of Adriana Lima eloping threatened to ruin my day, Grey fires off this referral. Simply razztastic! I agree, any way to get a leg up and not waste precious seconds between picks is priceless. Thanks G…

  21. Grey

    Grey says:
    (link)

    @AJ: No worries, it’s all Lou.

  22. Ian says:
    (link)

    Hi All

    This is great ….. alas I don’t have Excel 2007 and my PC is chucking a wobbly trying to play around with it.

    I have used this software and is also pretty good …. I have used it and won one league and finished second in another : http://mlbmockdraftsoftware.blogspot.com/

    It’s all free though donations to the programmer are not a bad idea.

    You can import different sets of stats depending which ones you favour.
    Its pretty flexible as well, so for our comp which has a modified H2H snake draft it allows me to track its progress well.

    Love the site, the writing style, and will keep coming back.

    Keep up the great work, Ian (Sydney Australia)

  23. TBone says:
    (link)

    I’m dizzy with excitement and kiddy like a school girl.

  24. G says:
    (link)

    so how do you use the excel thing? i downloaded it and everything but how do you know the dollar values for each player and do I have to type it in my self? appreciate the help

  25. Lou Poulas

    Lou says:
    (link)

    @Ian: Thanks Ian, I will check out that site too. New ideas are always welcome!

    There are Excel 2003 versions on the left hand menu as well, hopefully this works out for ya.

  26. Lou Poulas

    Lou says:
    (link)

    @G: Hey G. Not 100% sure I get the question, but will do my best to answer. The salaries are meant for auction drafts – so, as a winning bid is made, all you have to do is go to the Players tab and put the team name and wining bid amount next to the player chosen.

    If you don’t have an auction draft, either skip the salary entry or download one of the straight draft tools.

  27. G says:
    (link)

    @Lou: Yeah im not in a auction draft so how do I download the regular ones. I downloaded the excel but where do I go from there?

  28. Lee says:
    (link)

    First of all this is a great tool. Thanks for putting this together and making it free ;)
    Is there an AL only version?

  29. redmann says:
    (link)

    Thanks for the generic version Lou. Can you create one that still keeps track of the salaries of all the teams? The category rankings are a nice to have but keep track of the salaries still available is almost a must.

Comments are closed.