Here it is, the 2015 Fantasy Baseball War Room.  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 2015 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 2015 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 2015: Color Coded Tiers in the Dashboard Tab.

A quick look into the document: 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.  If you see anything that needs to be changed/updated, leave me a comment below, and I will fix it 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 2015 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 2015 Fantasy Baseball War Room <– Snake Draft, newest Excel, optimal download

Download the 2015 Fantasy Baseball War Room <– Snake Draft, Excel 2003; some formatting might be lost

Download the 2015 Fantasy Baseball War Room <– Auction Draft, newest Excel, optimal download

Download the 2015 Fantasy Baseball War Room <– Auction Draft, Excel 2003; some formatting might be lost

 
  1. Blake says:
    (link)

    Thanks! have been waiting for this! a Couple of questions:

    1) My 12 team pts league favors power hitters, has no negative pts for K’s, etc). It looks like I need to move up power hitters a bit in the rankings. How do I do that?

    2) I am using CBS sports to host my league – when I do the online draft I have to manually draft the players in the excel sheet for each league mate correct? so I can accurately get a sense on what I need to do when it is my pick?

  2. Mat says:
    (link)

    Thanks! I have a similar sheet I’ve used over the years, but always struggled to incorporate tiers. Love the way you’ve done that. Do you issue updates to this spreadsheet as changes are made to auction values and/or tiers over the coming weeks?

    • Nico says:
      (link)

      @Mat: Glad you’re a fan! We plan to do our best with updating the files at least once before the majority of drafts start, unless, of course, not much changes.

  3. Hadouken says:
    (link)

    Thanks for posting…Ryu’s stat line is off (looks like copy/paste error).

  4. Frankiejay says:
    (link)

    I don’t know if it’s because I’m using old excel or what but when I download any of them (including the 2003 excel ones), the moment I make a single change to the file–even just changing the file name–everything comes back as errors.

    • Nico says:
      (link)

      @Frankiejay: That’s interesting, and not in a good way. I fiddled around with it some more and couldn’t seem to reproduce that result. I’m guessing it has to do with the old excel. Do you use Google Drive?

      • Frankiejay says:
        (link)

        @Nico: I have Google Drive, though that doesn’t seem to help. I may just wait and do this on my laptop, which runs Excel 2010, when I get a chance, but I’d be curious to know if others have a similar problem. It could just be this computer as well. I’m no expert on how these excel file links work.

        • Nico says:
          (link)

          @Frankiejay: Interesting. I seem to have made it work in a limited capacity (the only function so far that doesn’t work is the grey/cross out function in the Dashboard tab). If you have anymore issues let me know. If you want me to share my Google Drive version with you, I can do that also.

        • Frankiejay says:
          (link)

          @Frankiejay: The error I’m getting seems to be that an _xlfn. prefix is added because the IFERROR function is not supported in Excel 2003. I’m assuming that something is amiss there.

  5. birrrdy! says:
    (link)

    God bless you, Nico. The highlight of every Spring for me is the posting of this page. Thank you, thank you.

    • Nico says:
      (link)

      @birrrdy!: Ha! I have to say it’s my highlight as well! Enjoy!

    • birrrdy! says:
      (link)

      @birrrdy!: IF I want to convert the auction doc into an NL-only war-room, is it sufficient to just delete AL players from the Players page, or do I need to delete in other places? Will it screw up all the formulas and functionality? thx!

      • Nico says:
        (link)

        @birrrdy!: Things do get a little whacky when customizing this. I think the easiest way to do this is:

        1. Go to Players tab
        2. Highlight Team column header
        3. Go to Data –> Filter in excel
        4. Click on the arrow in the Team column header and filter out AL teams

        Unfortunately, it won’t renumber your rankings, but it still keeps things in order. It also won’t update anything in the Dashboard. It will still be a useful reference point in the Players/War Room tabs, however.

  6. the swinging says:
    (link)

    Espn is back up

  7. Hawk says:
    (link)

    Hey Nico,

    First – thanks for this, this is great!

    Is there a way to change the scoring to reflect a 10-team league? I don’t see anything on the User Input page that would allow me to set that option.

    Thanks!

    • Nico says:
      (link)

      @Hawk: Hey Hawk – You’re more than welcome. Under the User Input tab, delete the names of Team’s 11 and 12. I then use my 10-team league’s stat history (averages) to update my personal team goals.

      • Hawk says:
        (link)

        @Nico:

        Hi Nico,

        There is nothing in those fields. I’ve populated team names 1-10 but 11 and 12 are blank.

        Other ideas?

        • Nico says:
          (link)

          @Hawk: Sorry. Misunderstood what you meant. Yes there is a way, and I wish I could make this easier, but here goes. In your War Room tab, make sure all your formulas go from 71 to 80 (i.e. C$71:C$80) for R, HR, RBI, SB, AVG, ERA, WHIP, W, S, K. Make sure your “Team Rank” formulas go from cells 27 to 36. Drag all of these formulas down from Row 27 to Row 36 (or your 10 team spots). Let me know if I need to be clearer.

  8. gobiggreen says:
    (link)

    I’ve been filling this in for my keeper league, guessing who might be kept by the other teams. I noticed after I assigned CATCHERS to a few teams, the Dashboard did not update itself. They were the only group and looks like all other players transferred.

    • Nico says:
      (link)

      @gobiggreen: Yup, you are correct. I will get that fixed. Slipped through the cracks, my apologies.

  9. mookie says:
    (link)

    I’m not seeing an column to enter in the auction/keeper SAL for Pitchers?

  10. Buge Hoobs says:
    (link)

    Nico,

    Thanks so much. I love it! However, in timed drafts I sometimes have difficulty finding a name on the player page. Could you recommend a way to search the name so I can quickly assign to the correct team? I’ve tried “Find” (Crtl+F) but it doesn’t seem to work.

    • Nico says:
      (link)

      @Buge Hoobs: Happy to help! When you use Ctrl+F, hit Options, Look in: Values. Then try searching again. I’m not sure why this defaults to that setting.

    • Nico says:
      (link)

      @Buge Hoobs: I have the same problem, so CTRL+F is my lifeline.

      • Bugs Hoobs says:
        (link)

        @Nico: MUCH appreciated! Will do that tomorrow and see (fingers crossed)

        • Buge Hoobs says:
          (link)

          Ahhhhh, much better!
          Not sure if it’s the same for both, but I’m using a Mac and had to change the “Search” field to ‘columns’ as well. Thanks again!

          • Nico says:
            (link)

            @Buge Hoobs: I have a Mac as well, but I don’t do the updating on there bc things can get real weird, real fast. Someone needs to tell Apple we have a War Room to run and fantasy leagues to win.

            • Buge Hoobs says:
              (link)

              @Nico: On it!

  11. mookie says:
    (link)

    although I simply added the column and amended the formula. so its all good.

    • Nico says:
      (link)

      @mookie: The column is actually just hidden! Must have screwed that up when I went from snake to auction. I’ll have an updated one for you guys soon.

  12. Fireball Feliz says:
    (link)

    War Room! It’s 78 Degrees outside in Texas! Wooooo!! So long winter, you miserable bitch

  13. Mookie Wilson 1 says:
    (link)

    Hey Nico,

    Great work, this will definitely come in handy! I’m in the auction spreadsheet and on the players page I don’t see a column for pitchers salaries or am I overlooking something? Thanks for putting this together!

    • Nico says:
      (link)

      @Mookie Wilson 1: Re-download the spreadsheet. That error should be fixed now! Sorry about that!

  14. Boomer19 says:
    (link)

    Wow. Great job. Now I’ll never get any work done today!

    • Nico says:
      (link)

      @Boomer19: My job here is done!

  15. Mason says:
    (link)

    Hi Nico,

    Great tool for using at the auction. On the “War Room” tab what is the best way to add more players under the batter section? We have 30 players which usually breaks down to 21 batters and 9 pitchers. If I add extra rows how do I add the formulas?

    • Nico says:
      (link)

      @Mason: The War Room is set up so that your best 13 hitters and 9 pitchers’ stats are averaged. The idea is to only put the starters in there. Now, if you’re saying you have 21 starting batters, that’s cray! haha but I’ll look into it and get back to you.

  16. Funke says:
    (link)

    @Nico – great service you’re providing – thanks! I really have to 2nd the notion that it would be really helpful if we could get an AL or NL version or some kind of macro to remove all the players from a league. I tried the sorting thing and it gets hokey.

    Keep rocking the war room!

    • Nico says:
      (link)

      @Funke: I’ll see what I can do to help out the process. If you don’t mind, give me a few days, and I’ll try a few things out.

      • Funke says:
        (link)

        @Nico: No problem – love that Razzball experts actually read and respond to its users.

        Funke

  17. Jack says:
    (link)

    This looks awesome. If I were in a standard 5×5 12 teamer, it’s would give me a HUGE advantage = no brainer.

    The problem is I’m in a 10 team league that uses OBP instead of AVG so my ranks and stats are different than Grey’s. I was going to use Razzball’s adjusted Steamer projections and rankings. Can you give us specific instructions on how to replace Grey’s ranking & projections with are own? I looked at the Players tab and there are what looks to be very complicated VLOOKUP type formulas in there where that stats are. Maybe I’m looking in the wrong place. If so, where do the raw stats go? And can I just replace AVG with OBP and AB with PA?

    Once I get my raw stats and ranking in the right place will your spreadsheet automatically rank the positions?

    Side note: I know I’d have to re-figure the position tiers, would I just do that by looking at calculated auction values and grouping players by where they cluster?

    • Nico says:
      (link)

      @Jack: I definitely understand where you’re coming from. Unfortunately, the War Room is better as a guide than an exact science. Making those changes will require quite an effort, although I am trying to see what I can do to make the transition from 12 to 10 teams easier (and more clear). I wish it was easier. My apologies.

  18. dem ribbies says:
    (link)

    This is seriously awesome. Thanks!!

    In one of my auction leagues the budget is $200 and these salaries are based on $260. To account for this, I’m adding in a hidden column on the User Input tab to be used as a scaling factor. Calculated as 260/C27, in my case the factor is .77. Back on the player tab I’ve modified the $ formula

    from
    =IFERROR(VLOOKUP($C3,Import!$B$3:$L$434,5,FALSE),””)
    to
    =IFERROR(ROUNDUP(‘User Input’!$C$28*VLOOKUP($C3,Import!$B$3:$L$434,5,FALSE),0),””)

    Just thought I’d share in case it helps anyone.

    • Nico says:
      (link)

      @dem ribbies: You’re seriously awesome! You’re welcome!

      Very cool. I wouldn’t have thought of factoring off the bat. Smart move.

  19. Mike says:
    (link)

    I love this tool more than my wife and children

    • Nico says:
      (link)

      @Mike: I love it more than your wife and children too!

      • Mike says:
        (link)

        @Nico: hahaha thank god

  20. SheVegas says:
    (link)

    I am looking for starting pitchers who are RP eligible on yahoo, do you have a ranking of those types anywhere. I won my league last season, not drafting a true RP, but went with all starters. Thank You

    • Nico says:
      (link)

      @SheVegas: Not a formal ranking, but look for information on that in the weekly pitcher posts. Shoot this question by Sky also. He might have a better answer.

  21. bill says:
    (link)

    it looks like it’s just my problem but i downloaded both spreadsheets and they look the same – both for auctions. i’m not seeing a snake draft version.

    • Nico says:
      (link)

      @bill: The only difference is that in the “Players” tab, there is a column for “Salary” (in gray) for you to fill in.

  22. zhooker says:
    (link)

    fucking eh lovely. quick q’s:

    1) I’d prefer to see totals, not averages, in the War Room Goal Tracking. I should simply remove the divisors in the User Input-linked goals and then replace my team averages with the team totals you have autocalculating lower on the worksheet, correct?

    2) I’m in a Y! 12-man 5×5 SV+H. From what I gather the quickest way for me to convert the SV default is to manually update/change the SV projections to SV+H for relevant RPs (from your Steamer Projections) and then re-title columns as needed, yes?

    If there would be a quicker way, or a way to replace SV with SV+H and maintain live updating for those affected RPs, show me the way oh wise one.

    PS. Using Google Drive.

    Kisses!

    • Nico says:
      (link)

      @zhooker: Haha yeah that sounds about right. Let me know if you hit a snag.

  23. Erik says:
    (link)

    Is there a way to input team keepers and to readjust everyone’s personal draft budget because we trade draft cash so everyone has a different amount going to the draft?

    • Nico says:
      (link)

      @Erik: For Keepers, I would just assign them to the appropriate team before the draft starts. For the budget, here’s what you can do:

      1. In the War Room tab, Column N, put in each team’s budget
      2. Replace “‘User Input’!$C$27” with the corresponding budget cell in Column N. (i.e. Change the formula in K3 from “=’User Input’!$C$27-G3” to “=N3-G3” and so on down the line.

      Let me know if that works.

      • Erik says:
        (link)

        @Nico: Sorry I’m new to this and can’t even figure out how to assign players to teams, is it merely just typing in their names? and I don’t see where the other team’s in my league empty rosters are.

      • Erik says:
        (link)

        @Erik: @Nico: NVM figured it out.

  24. Swfcdan says:
    (link)

    Great stuff Nico (Bellic)!.

    Cheers

    Roman

    • Nico says:
      (link)

      @Swfcdan: Ha, cheers!

      • Swfcdan says:
        (link)

        @Nico: Haha glad you got the GTA reference there.

  25. Josh says:
    (link)

    Nico this is fantastic! I was working in the Snake Draft (newest Excel) sheet yesterday and noticed the C issue that was previously mentioned. SO today I downloaded the updated one and C did work in the War Room tab. However 1B and 2B were then off… I work with Excel formulas pretty regularly so I attempted to correct it myself. For some reason it was graying out players 1 cell above the 1 in hidden cells and for the life of me cannot figure out how the conditional formatting is off? Any assistance would be greatly appreciated!

    • Nico says:
      (link)

      @Josh: Wow, I’m totally screwing this up aren’t I? Let me take a look!

  26. Grant says:
    (link)

    a couple things. One technical, how did you do the cross out on the dashboard page. I was unhiding columns to get how you got the names, but didn’t see a formula or anything that would cross out the players, I am not sure how to do this, and I find myself to be pretty good at excel.

    Second, I like how you had the DH column, but I guess didn’t decide to include it and just hid it away.

    Thanks

    • Nico says:
      (link)

      @Grant: I used conditional formatting. Under the Excel Home tab at the top, there’s Conditional Formatting off to the right. Click Conditional Formatting, then Manage Rules and make sure you’re showing formatting rules for: This Worksheet. After that, it’s a simple formula function with formatting attached to it. The reason DH isn’t really utilized is because now the utility spot is more common than the DH spot. Therefore, I kept the column hidden. Feel free to set it up and use it as you’d like, though!

  27. Nico says:
    (link)

    All technical issues on the Dashboard tab should be resolved!

  28. Johnny Drama says:
    (link)

    First off, thanks for doing this. I may have over looked this comment. If so, please ignore. I’m using the Auction version.

    War Room: The Salaries are pulling Grey’s projected salaries (I and AF) and not actual salaries (E and AB).

    Thanks again!

    • Nico says:
      (link)

      @Johnny Drama: Should be fixed in the update!

  29. John says:
    (link)

    Do you guys plan on doing web app version like last year?

    Thanks again for all the work great tool!!

  30. Ben says:
    (link)

    Thanks for all the work… much appreciated. In the “Input” tab, are the # of pitchers and # of hitters per team intended to include bench spots or just “starters”?

    • Nico says:
      (link)

      @Ben: It’s aimed at the starters, since some flyer draft picks and such could really bring down your averages.

  31. JC says:
    (link)

    Using Numbers on a Mac here. When I populate the players under the “Players” tab, it doesn’t cross off the names on the “Dashboard”. Anyway I can fix this? Thanks for the awesome tool regardless!

    • Nico says:
      (link)

      @JC: hmmm, my guess is it’s a formula issue that doesn’t translate to Numbers. I’m not quite sure how to get around that. However, if you know how to do some sort of Conditional Formatting in Numbers, that’s how we got it to work in Excel.

    • Tyler says:
      (link)

      @JC: Would definitely be interested if you figure this out…being able to run the War Room from numbers on my Ipad would be really helpful.

      • Nico says:
        (link)

        @Tyler: I’m pretty unfamiliar with Numbers. Does the web-based draft app work on your iPad? That might be an easier format to work in.

        • Tyler says:
          (link)

          @Nico: Hey Nico! I tried to run it during a mock last year, and from what I remember it DID work, but was really slow. I also haven’t used numbers yet, but realized that it works with the ipad and need a secondary monitor/software for my draft besides the live yahoo draft room software that I will run on my laptop. Will you actively run the War Room on draft day, or do you use it more as a prep to see how you need to build your team?

          • Nico says:
            (link)

            @Tyler: I typically use the excel sheet bc there are always custom modifications I’ll make just before draft day (i.e. highlighting upside pitchers or good relievers, noting major ADPvRanking differences, etc). I usually don’t have the time to check everything during the draft, so I do some prep beforehand to smooth things out.

            • Tyler says:
              (link)

              @Nico: Nice, thanks for the info!

  32. jbird669 says:
    (link)

    Nico,

    This is great. Any way to get a war room without projections so we can add our own?

    • Nico says:
      (link)

      @jbird669: You can edit the stats in the sheet by unhiding the “Import” tab and changing Grey’s projections. There might be some formula issues, however. I haven’t tried that out yet.

      • jbird669 says:
        (link)

        @Nico:

        Thanks, I’ll try that out!

  33. sturock578 says:
    (link)

    Pregunta: if I overwrite with my own auction values (trying to convert this to NL-Only) will that screw everything up?

    • Nico says:
      (link)

      @sturock578: I would edit them in the “Import” tab, which is currently hidden. That would probably provide a smoother transition throughout the sheet.

  34. Jimmy says:
    (link)

    Will this work with Numbers on a Macbook?

    • Jimmy says:
      (link)

      @Jimmy:
      Oops sorry…just read the above posts. Will the Grey’s updates work on Numbers. How do I check?

      • Nico says:
        (link)

        @Jimmy: Unfortunately, I don’t have any experience with Numbers. I’m sorry!

  35. David Sheely says:
    (link)

    Is draft auction value inflation supported?

    • Nico says:
      (link)

      @David Sheely: If you’re good with Excel, pretty much ANYTHING can be modified. The challenge is explaining it on here in detail. The key tab to this spreadsheet is the hidden “Import” tab, which has all of Grey’s rankings imported into it. you can modify that as you wish, but just make sure all rankings and such stay the same.

  36. BigRedLatrine says:
    (link)

    I wait for this every year. I can’t draft without it. Thanks Nico!

  37. Chris says:
    (link)

    Hey Nico,

    I was hoping to use this in Google Drive but when I import it into there and try to open it, I get a message saying, “Whoops! There was a problem previewing this document.”

    What am I doing wrong?

    Thanks!

  38. greg says:
    (link)

    I’m not good at excel…..how do you “draft players” with this spreadsheet. Thanks

    Please keep it simple

Comments are closed.