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

Some of us like our Fantasy Baseball War Room’s like we like our women, so I would’ve thought Grey would’ve went with the old school one.  Oh, well.  If you’re not cool with the new fantasy baseball war room, here’s your alternative — the downloadable Excel spreadsheet.  This was original author and innovator Lou Poulas’ introduction, “While Grey and Rudy do a great job of breaking down everything you need to know for 2013 Fantasy Baseball, drafts still trip me up.  I’ve been lamenting my inadequacies from the past 3+ 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.”

Presenting the free 2013 Fantasy Baseball 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.
  • Real time projected totals, along with real time projected league standings.
  • Goal Tracking Dashboard
  • New for 2013: Color Coded Tiers in the Dashboard Tab. This includes comments inserted at the beginning of each tier from Grey’s rankings.

A quick look into the document: John Hassett added notes 4+5 on the Notes Tab under user steps. It just explains how to add a player and a note about when the pitching and hitting totals update.  The pitching and hitting totals look like they are broken until each team has at least one hitter and one pitcher.  I used this tool for my first draft about 5 years ago and I have been consistently winning leagues ever since. If you are someone that hates dealing with excel, I feel for you. I was the same way but in all seriousness, War Room is very easy to use. I am almost certain that once you use War Room for one draft you will continue to use it year after year. Razzball is the best source for fantasy baseball information that I have ever used. The combination of humor and analysis is unmatched. I created this document this year as a backup to Grey’s War Room so there may be some bugs and/or mistakes that I have made. If you see anything that needs changed/updated, just leave me a comment below and I will fix ASAP.

This year’s version has been slightly customized to Razzball:

  1. The Players page lists players in order of Grey’s top 400 for 2013 fantasy baseball with Grey’s projections. Grey’s auction values will be added to a different War Room document that will be added very soon.
  2. Goal Tracking has been pre-loaded with temp targets for “What it takes to win a 12 team fantasy baseball league.”
  3. The “Dashboard” displays players by position in order of Grey’s rankings.
  4. The ‘Team Rank’ box (League Standings) is limited to no more than 12 teams. Projected ‘Batting Totals’ and ‘Pitching Totals’ extend up to 25 teams.
  5. Up to 25 players may be drafted per team (allocations set by the user via the ‘User Input’ page).
  6. I have left the spreadsheet ‘unprotected’ so you may overlay with your own projections if you like.

The value of the War Room, for me, is to load the picks of a draft to determine which categories I am falling short in.  In this manner, I can keep adding/deleting targeted players until I consistently get a strong team.

Click on the ‘Notes’ tab for instructions for how to load league team names, etc.  Put questions and comments in this post and I’ll do my best to answer them.

Download the 2013 Fantasy Baseball War Room (newest Excel, optimal download) <–Snake Draft

Download the 2013 Fantasy Baseball War Room (Excel 2003; some formatting might be lost) <– Snake Draft

Download the 2013 Fantasy Baseball War Room <–Auction Draft (newest Excel, optimal download)

Download the 2013 Fantasy Baseball War Room <–Auction Draft (Excel 2003; some formatting might be lost)

91 Responses

  1. This is great that it’s in excel. Just curious as to how long it’ll be to have one for auctions?

  2. Trevor

    Trevor says:
    (link)

    John and I will be working on it throughout the week and over the weekend. I’d say by Monday at the latest. We are currently entering auction values and we are entering these values for each player so it’s takes some time.

    • Rags says:
      (link)

      @Trevor: Is there going to be a way to calculate inflation for keeper leagues? Because that would be awesome…

      • Trevor

        Trevor says:
        (link)

        @Rags: Hmm. That seems very difficult to do in this War Room but I will ask John.

      • Paddyman says:
        (link)

        @Rags: @Rags: I second that!

      • Paddyman says:
        (link)

        @Rags: I second that motion! Twould be a great tool for dynasty leagues if possible

    • @Trevor: Great! Can’t wait to see it!

    • joet says:
      (link)

      trevor,

      When I put a second team in, the BAVG blows up.

      Is the formula incorrect? (Field G72 in the War Room).

      • Trevor

        Trevor says:
        (link)

        @joet: what do you mean by putting in a second team?

        • joet says:
          (link)

          My draft has been completed. I’m just looking to obtain the category totals for my 14 offensive players.

          When I input a competitor’s offensive team (Team b), it totals everything correctly, but the BAVG goes bonkers.

          • Trevor

            Trevor says:
            (link)

            @joet: I think I understand now. You may have to insert every team’s pick to accurately calculate the batting average. Try the first two rounds and tell me what it does.

            • joet says:
              (link)

              Just found the problem.

              Victorino has been given a BAVG of 272.00

              The second team I put in had Victorino.

              A quick look at the offensive players seems to indicate that he was the only aberration.

              • Trevor

                Trevor says:
                (link)

                @joet: nice find! Thanks for the heads up.

  3. birrrdy! says:
    (link)

    Sweet… looking forward to the auction tool. Praying for NL only compatibility. =)

  4. Josh says:
    (link)

    I can’t download the excel sheet, it saying that the file is corrupt. Is it just me??

    • Bill_Buckner says:
      (link)

      @Josh:

      I’m having a similar issue. It’s saying it appears that the file is not an Excel file and asking me if I want to use Excel to open it anyway. When I select yes, I get all types of weird code and nothing else…

      • Trevor

        Trevor says:
        (link)

        @Bill_Buckner: looking into it. It may be a compatibility issue.

        • Bill_Buckner says:
          (link)

          @Trevor:

          Thanks for your efforts. Much appreciated!

          • Trevor

            Trevor says:
            (link)

            @Bill_Buckner: What version of Excel do you have?

            • T2R9 says:
              (link)

              @Trevor: Same issue here with Excel 2000 and 2003

              • Grey

                Grey says:
                (link)

                @T2R9: As the post says above, some formatting might be lost in the older version of Excel, but I uploaded one for it…

          • Grey

            Grey says:
            (link)

            @Bill_Buckner: Some formatting might be lost in the older version of Excel, but I uploaded one for it… It’s in the post above under 2nd download…

            • @Grey: @Grey: @Bill_Buckner: @Trevor: Found a simple workaround for the “file is corrupt issue. I’m using LibreOffice and got that message. Fixed it by changing the file extension from .xls to .xlsx … works on both the new format and the old format. And don’t forget, you still have to change Victorino’s BA from 272.00 to .272.

    • Trevor

      Trevor says:
      (link)

      @Josh: sent via e-mail.

    • Grey

      Grey says:
      (link)

      @Josh: Some formatting might be lost in the older version of Excel, but I uploaded one for it… It’s in the post above under 2nd download…

      • Tom says:
        (link)

        @Grey: “some formatting may be lost” — I downloaded 2003 and started a draft by having the first 2 teams pick players. These players were not crossed off on the Dashboard. Is this because of 2003? If so, do you know if Open office or anything else would bring that feature back. It is key.

        • Trevor

          Trevor says:
          (link)

          @Tom: Try Open Office. Others are saying that it will work.

  5. Scott says:
    (link)

    Any way to filter for AL/NL-only leagues? Obviously I can do it in my brain, but if it’s really easy that’s preferable :)

    • Trevor

      Trevor says:
      (link)

      @Scott: I think that is something we can implement next year. Depending on the league, the entire rankings and dashboard tiers would change. Best thing to do now is to do it in your head.

      • Scott says:
        (link)

        @Trevor:

        I figured as much. Appreciate the reply, anyway.

  6. Ferga says:
    (link)

    Awesome!

    Thanks for all the hard work you guys do over hear. Its a catch 22 for me though, I would love to spread the word on this site…but I kinda don’t want my league mates to know about it…

    • Trevor

      Trevor says:
      (link)

      @Ferga: ha! That’s sometimes how I feel. It’s a big Internet world though.

    • donkeycorner says:
      (link)

      When you google “fantasy baseball rankings” you get over 37 million results. Since razzball is on the first page, it’s going to be hard to hide it from your league… @Ferga:

  7. Slapweasel says:
    (link)

    We have a Straight Draft. You know, no faygs allowed. Okay, they’re allowed, but we ruffle their hair and say things like, “You liek doods, ya’ lil’ scamp!”

    …Will Hooked on Phonics work for me?

  8. letsgobravos says:
    (link)

    This sounds like a great tool, but unfortunately I’m on a mac. I DL’d it to see what it would do in numbers and i got a document that looks like its in klingon…haha.

    • inertiatic says:
      (link)

      @letsgobravos: open office (dot) org works, and its free. Google’s can show you the way!

  9. Mike Adamson says:
    (link)

    I’m using Libre Office and the newest excel link didn’t work for me but the 2003 link did. So there you go.

  10. Brandon says:
    (link)

    How do you expand the settings so it can count for a 16 team league?

    • Trevor

      Trevor says:
      (link)

      @Brandon: I will have another War Room coming out that will accommodate leagues that have more than 12-teams soon.

      • Nick says:
        (link)

        @Trevor: The War Room is awesome! Thanks for all the hard work. Do you have an ETA of when you will have a spreadsheet that accommodates 16 team leagues? I’m not an excel wizard, and when I try to assign players to teams, the drop down menu only includes the first 12 teams and I don’t know how to change that…The other comment didn’t seem like it would fix that issue.

    • Trevor

      Trevor says:
      (link)

      @Brandon: Found this in the archives. Give it a try.

      – You can add more than 12 teams – If you want to rank more than 12 teams you need to insert rows to the bottom of the projected Batting and Pitching Ranks. Then go to the cells for the categories and change the range of cells that it is ranking. IE. The formula for ranking runs in cell B27 is currently RANK(C71,C$71:C$82,1) – Just change it to RANK(C71,C$71:C$86,1) if you have added 4 rows to make it a 16 team league. Do the same for HRs RBI SB +avg. + the pitching categories.

  11. mike says:
    (link)

    could break it out by leagues?
    I do an NL only 4×4 and this would make alot easier.

    • Trevor

      Trevor says:
      (link)

      @mike: Unfortunately, we do not have separate league War Rooms right now. We will definitely do it next year. You can still use it for your NL only league. Just Strike through all of the AL players in the rankings and tiers.

  12. Stephen says:
    (link)

    Thanks for the great work as always. I have an excel document that I think could be incorporated into the war room that focuses on the following information which is not captured in the above;

    1. A breakdown of each team’s players (which I can only assume most people have when going through a draft or auction)
    2. A team by team breakdown of positions still not drafted/purchased. This really helps when identifying your competition for players at the back end of the draft/auciton. ie; if you know that nobody else needs a catcher, why waste a draft pick or save money to spend on a catcher…

    The war room identifies max bids, and total players still required, but this gives the next level of insight…

    Who do I send this too? I currently use in in conjunction with the war room, have not had the time to merry the two files into one master war room.

    Stephen

    • Trevor

      Trevor says:
      (link)

      @Stephen: I’ll take a look at it. I just sent you an e-mail.

      • Stephen says:
        (link)

        Did you get a chance to look at the file? Any thoughts?

  13. Matt Whelan says:
    (link)

    Wow, this is awesome. Hate to ask, but anyway to swap out AVG with OBP?

    • Trevor

      Trevor says:
      (link)

      @Matt Whelan: I’ll look into it and see what we can do. I am writing some notes on a lot of the requests for next year’s War Room.

      • Matt Whelan says:
        (link)

        I also unsuccessfully imported to Google Apps. I’m not done trying, if successful, I will see if I can provide that for others.

        I would also probably be able to easily replace AVG with OBP by adding another sheet & swapping a lookup function into the AVG field. I could probably already do this with the normal spreadsheet, just prefer to work with Google Apps.

  14. ML says:
    (link)

    great job. thank you

  15. Trevor

    Trevor says:
    (link)

    ***** Be sure to change Shane Victorino’s BA to .272*****

  16. Charlie says:
    (link)

    First and foremost, this spreadsheet is the sexiest thing I’ve ever laid my eyes on!!! My gf def takes a backseat to this. Wow.

    Secondly, my 10 team league has 25 roster spaces (10 offensive, 8 pitching, 2 dl, 5 bench)

    Under the # of batters per team I used 10 and # of pitchers I used 8. Is this correct? Should I disregard the dl and bench spaces I have alloted to my team?

    Also, I’m not entirely sure what numbers to use for “personal team goals” for runs, hr, rbi, sb, avg, era, whip, w, sv, and k. What is the general rule of thumb for a 10 team, 25 roster team? Thanks again!!!!

    • Cheese says:
      (link)

      @Charlie: Regarding your question about personal team goals, Grey/Rudy usually post a blog at some point before the season starts of certain goals to set (based on categores, number of teams, etc.). So if you stay tuned, I’m sure they’ll be posted in the near future!

    • Trevor

      Trevor says:
      (link)

      @Charlie: For personal team goals, use the Online War Room drafting tool. You will enter the number of teams and positions and it will automatically calculate the personal team goals. After that, you can just enter those numbers into the correct spots in the Excel document.

  17. Cheese says:
    (link)

    I’ve adjusted mine for extra stat categories in my league (SLG, BB, H) if anyone is curious at taking a look.

    Also, there is a small glitch in the rankings. For example, if two teams tie with the most HR, it gives both teams 15 points rather than 15.5. To fix this, change the formula in B27 of “=RANK(C75,C$75:C$86,1)” to “=(RANK(C75,C$75:C$86,-1)+COUNTIF(C$75:C$86,”<="&C75))/2". Then copy this formula down and across for relevant stat categories.

    Overall, this is a great tool and I can't wait to use it for all of my drafts!

    • jeff resnick says:
      (link)

      This tool is awesome! Question from a horrible Excel person – I’m in an NL only league. Is there an easy way to delete all the AL players without having to go line by line? Thanks!

      • Trevor

        Trevor says:
        (link)

        @jeff resnick: I wish I knew of one because it would be a lot easier to create different AL and NL war room’s for others but right now that’s the only way I know how to do it… i know, it will take some time.

    • Isaac says:
      (link)

      @Cheese: Can you email the spreadsheet you spun up with other categories? My email is isaac _ 2004 at yahoo

  18. Grilled Cheese Please says:
    (link)

    Hate to ask but is there any way to reduce teams to 8? Unfortunately we have to operate a smaller league this year. Thanks!

    • Trevor

      Trevor says:
      (link)

      @Grilled Cheese Please: If you only enter 8 teams into the user input it should still do the same calculations that you would need. You would just have to ignore the last four slots in the War Room tab.

  19. BigRedLatrine says:
    (link)

    Love the war room! There is a stirring in my loins.

  20. Mike says:
    (link)

    Does the war room keep track of the draft results in a snake draft ?

    • Trevor

      Trevor says:
      (link)

      @Mike: No, but most likely any draft should send you the results in an e-mail.

  21. donkeycorner says:
    (link)

    The User Input and War Room tabs allow for 25 teams. We have a 12 team league so I deleted teams 13-25 on both tabs. The only place I can’t figure out how to change is the drop down on the Players page. It shows the 12 teams but then 13 more entries for an invalid reference. Where can I edit the drop down box?

    • Trevor

      Trevor says:
      (link)

      @donkeycorner: This is meant for a 12-team league. No need to delete the other teams if you aren’t using them. The other entries are at 0 because they aren’t used.

  22. Camden says:
    (link)

    Auction war room coming out today?

    • Trevor

      Trevor says:
      (link)

      @Camden: Yes sir

  23. Josh says:
    (link)

    My league uses .5 increments for our auction salaries. The auction spreadsheet automatically rounds any salary ending in .5 to the next whole number, is there any way to account or .5 increments?

    • DC says:
      (link)

      @Josh:

      edit the column/cells for more decimal places.

  24. Charlie says:
    (link)

    Is there a way to change the rankings of the players under the “players” and “dashboard” tabs without breaking the whole workbook? I have a different set of rankings due to the fact that my league has OPS. Thanks.

    • Trevor

      Trevor says:
      (link)

      @Charlie: No just adjust the players tab and dashboard tab as you please. It should still cross off like you want it to.

      • Charlie says:
        (link)

        @Trevor:

        When I change the order in the players tab (for instance I moved Mike Trout from 4 to 1) and then choose my team as “owner” it puts Mike Trout under my selected players in the war room tab. However, it does not update under # of players taken in the war room tab nor does it cross him off in the dashboard tab.

        However, if you just change the rankings in the dashboard tab, the workbook seems to function correctly.

        Is there a way after I change my rankings in the dashboard to also change rankings in the players tab and still have the workbook function correctly?

        • Trevor

          Trevor says:
          (link)

          @Charlie: First change the the projections and players tab by ranking. Make sure you select expand the selection when it asks you to confirm the move. Then you can go ahead and move the dashboard rankings. Make sure you select the cell first and then make sure you are getting the crossbars icon from your mouse. (put your mouse over the border). Once you get that you can select the whole cell and move it. You may have to move it in another category at first to make room but I just tried it and it worked.

          • Charlie says:
            (link)

            @Trevor:

            I tried this by changing Trout’s ranking in the Players tab to 1 and Miggy’s to 4 (switched them). Then I selected the whole A column. Selected Sort under data. Made sure Expand the selection was clicked and hit sort. Sorted by Rank. It re sorted it (flipped Trout and Miggy).

            I selected my team in Mike Trout’s drop down. It crossed his name off the dashboard tab, updated # of players taken in the war room tab.

            However, it did not add Mike Trout to the “your selected” section on the war room tab.

          • Charlie says:
            (link)

            @Trevor:

            I’ve also noticed if you change just the offensive players rankings and sort it sorts them correctly. However, if you change the pitching ranks at all and sort by rankings it does not rank the pitchers correctly (by rank number). Hmmm any idea what to do about this? And what to do about getting the players posted to the “your selection” area of the war room worksheet? Thanks!

  25. ForWhomGeorgeBellTolls says:
    (link)

    Thanks for putting up the Auction spreadsheet; looks amazing, can’t wait to try it out this year. Just playing around with it briefly, and the only issue I’ve noticed so far is that in the “Your Selected Players” part of the War Room it does not seem to be automatically pulling up the Projected Auction $ (next to the Bid $) for my batters… Is it just me, or is there a small glitch in the spreadsheet? (Probably just me.)

  26. Is there an issue with the workbook functioning if I change the projections? I.E. Will it still cross off players and add them to my team?

    • Trevor

      Trevor says:
      (link)

      @jbird669: No, first change the the projections and players tab by ranking. Make sure you select expand the selection when it asks you to confirm the move. Then you can go ahead and move the dashboard rankings. Make sure you select the cell first and then make sure you are getting the crossbars icon from your mouse. (put your mouse over the border). Once you get that you can select the whole cell and move it. You may have to move it in another category at first to make room but I just tried it and it worked.

    • Trevor

      Trevor says:
      (link)

      So@jbird669: Sorry that was to Charlie but you can do that. If you want to know how, It’s right here ^

  27. NATE says:
    (link)

    Not sure if I messed something up but the Projected Pitching Ranks for ERA and Whip are reading #Div/o! for all teams. My Pitching per Player doesn’t seem to be displaying right either for W, S and K’s. Batting is fine though. Any suggestions as to what is going on?

  28. NATE says:
    (link)

    Please ignore last post, all is working fine, thanks for the spreadsheets, very nice job!

  29. Lenn Sakata says:
    (link)

    There was an iPad version (using Numbers) available last year that worked great. I tried importing both versions of the Excel doc in Numbers and got a “too many formulas” error.

    Can you guys either upload a file that will work in Numbers or point me in the direction of what was modified to make it work?

    Much appreciated.

  30. Tchaikovsky08 says:
    (link)

    I am unable to download the “Auction Draft (newest Excel, optimal download).” It just brings me to a page of gibberish. I have the most recent version of Excel on my computer.

    In lieu of the most current one, I downloaded the 2003 version. However, after inputting the 14 teams in my league, only 12 of the teams appear in the drop-down menu on the “players” tab. Am I doing something wrong?

    • Nick says:
      (link)

      @Tchaikovsky08: It’s only for 12 teams right now I believe. I asked earlier when it would be able to accommodate at least 16…

      • Tchaikovsky08 says:
        (link)

        @Nick:

        Ah ok. Strange, because there are spots for 25 teams. It’s only the player drop-down menu functionality that seems to be impaired.

  31. Tom says:
    (link)

    Hello,

    Are Shelby Miller and Dylan Bundy really projected to pitch only 47 Innings?

    Thanks for the great job on the War room sheet

    Tom

Comments are closed.