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

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 2014 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 2014 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 2014: 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 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 2014 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 2014 Fantasy Baseball War Room <– Snake Draft, newest Excel, optimal download

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

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

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

181 Responses

  1. Mike says:
    (link)

    BEST
    TOOL
    EVER

    • Shake N Bacon says:
      (link)

      @Mike: I second that!

    • L'ville Jim says:
      (link)

      @Mike: The late John Holmes may disagree.

  2. Shake N Bacon says:
    (link)

    You even color coded the tiers. Sumbitch! This is awesome!

    • macgyver

      macgyver says:
      (link)

      @Shake N Bacon: Thanks! Glad you enjoy it.

  3. Count de Monetball says:
    (link)

    Macgyver, thank you and the moons gravitation pull.

  4. Shake N Bacon says:
    (link)

    One suggestion would be to make the columns sortable on the players sheet for the less Excel savvy out there. So you can sort by position or K’s or whatever category suits your fancy.

    I just made that quick change and I don’t think it’ll mess with any of the macros.

    I can’t believe I didn’t use this bad boy last year.

    I’ve tried to do this a few years ago with my own craptastic excel sheets and the draft was going too quickly for me to copy and paste all of the information. This is the ticket.

    • macgyver

      macgyver says:
      (link)

      @Shake N Bacon: Wanted to make this as simple as possible by just having the rankings straight up.

      There shouldn’t be any macros on the spreadsheets so making the rankings a list shouldn’t be an issue.

    • Mack says:
      (link)

      Click Data, then Sort, it is quick and very easy. Just practice a minute or two before hand.

  5. Jacob says:
    (link)

    There are cell formula errors in cells K46, L46, and M46 in the ‘War Room’ tab. You’ll need to recopy the cell formulas from the cells above in Line 45 and drag them down to fix this issue.

    • Count de Monetball says:
      (link)

      @Jacob: Nice catch Jacob

    • claw dog says:
      (link)

      @Jacob: I’m confused as to where that error is? I see information that I am not sure why its there in those cells but I don’t see the problem in the formulas

      • macgyver

        macgyver says:
        (link)

        @claw dog: Good catch Jacob. Having the issue fixed now.

        Jacob is referring to Cells K46-M46 on the “War Room page”. The formula is giving wrong results because it’s referencing the wrong cells. To fix this, highlight cells K45-M45

        • macgyver

          macgyver says:
          (link)

          @macgyver: and then drag down til the end of the table.

          Any more issues, you can state them here.

  6. claw dog says:
    (link)

    this is my first time trying to use this tool as last year I found out about razzball a few months into the season. I’m just curious, will this also work for a keeper league? Like can I just fill in the first 8 rounds with each teams 8 keepers? sorry if this is a dumb question, I’m just trying to figure out this tool that everyone seems to praise.

    • Shake N Bacon says:
      (link)

      @claw dog: Yeah this will work. Just did it for my keeper league.

      • macgyver

        macgyver says:
        (link)

        @claw dog@Shake N Bacon: Yup. You can add players before the draft to see how your team would look with certain players and so forth.

        Enjoy the site!

  7. Brandon says:
    (link)

    In the dashboard is it possible to move players around to make it our personal cheatsheet? personally I’ve been trying to make my own on excel but it doesnt look as wonderful as this

    • macgyver

      macgyver says:
      (link)

      @Brandon: Yes, it shouldn’t be a problem. However, it’s best if you do not cut (or drag) any of the cells when you’re doing this. Otherwise it will mess up the crossing out feature.

      Just overwrite the cells when you want to change them.

  8. RandomItalicizedVoice says:
    (link)

    Great to see it back. Been using it for years. Love it, love it, love it, love it.

    Cheers to all involved in keeping it going this year.

  9. Shake N Bacon says:
    (link)

    For everyone,

    On the Dashboard sheet:

    1) Change “Ramirez, Hanley” to “Hanley Ramirez” so that box will strike through when Hanley is picked.
    2) Change “Joe Altuve” to “Jose Altuve” so that box will strike through when Altuve is picked.
    3) Change “Fernando Rodne” to “Fernando Rodney”

    This excel sheet is a thing of beauty. Mucho gracias!

    • claw dog says:
      (link)

      @Shake N Bacon: Willin Rosario to Wilin Rosario as well

      • macgyver

        macgyver says:
        (link)

        @Shake N Bacon@claw dog:

        No problem.

        Yes, those issues should be fixed in the future.

        • John says:
          (link)

          @macgyver: @macgyver: Johnathan Lucroy to Jonathan Lucroy

  10. Ryan B says:
    (link)

    For me, the real drag of using these sorts of tools during drafts is I spend a lot of time searching the sheet for players as they’re drafted, and not enough time thinking about who I’m going to draft next. Anyone have any tips for remedying that? Any ways to automatically populate the info into Excel as players are drafted from an ESPN draft?

    • Count de Monetball says:
      (link)

      @Ryan B: My thought is the war room is good for figuring out the balance of the teams you get through mocking. I tried to use the war room during a draft, but stopped after the 2nd round due to the reasons you noted. Also, do the draft room again after your draft and it will guide you to your strengths and weaknesses (as projected by the mastachio’d one). As far as the auto pop thing, like Jesus said to Tebow when he had to play the Patriots, dude you are on your own… http://www.youtube.com/watch?v=09T8AUspQN0

      • macgyver

        macgyver says:
        (link)

        @ Ryan B@Count de Monetball:

        Ha, that was funny.

        I find it best to first practice using it during 3-4 mocks so you can get down the best process of how to use it quickly. If the drafts are still going too quick for you, then only worry about filling in your team vs the goals.

        As far as automatically populating the players, that’s tough. Most of this is just user entry.

  11. RandomItalicizedVoice says:
    (link)

    Maybe it’s because I’m using a Mac, but I can’t currently get the search function to work.

      • Baberaham Lincoln says:
        (link)

        @macgyver: Works fine for me

      • pager24 says:
        (link)

        @macgyver:
        under “Find there are 3 categories “within” “search” and “look in”
        Be sure it looks like this:
        Within – sheet
        Search- by rows
        look in- values

  12. Terrible Ted says:
    (link)

    Anyone tried it with OpenOffice? Can’t seem to get the “Players” tab to work…

    • Terrible Ted says:
      (link)

      @Terrible Ted: C’mon guys (and one girl), I’m cheap!

  13. RandomItalicizedVoice says:
    (link)

    I’ve got all the teams with at least one pitcher…still no calculation for ERA/WHIP rankings. Somethings not working there.

    • macgyver

      macgyver says:
      (link)

      @RandomItalicizedVoice:

      Are you talking about cells I43:M54 or I71:M82?

      Just tried adding all SPs, 1 to each team and it works fine.

  14. Matt says:
    (link)

    How easy is it to add new categories, such as OPS? Would that all have to be manually input I guess?

    • macgyver

      macgyver says:
      (link)

      @Matt: Yes, adding new categories would require a bit of movement all around the spreadsheet, and must be done manually.

  15. Eblock says:
    (link)

    Yeah, I had difficulty trying to use the “ctrl-F” search feature while in the players tab; it seems to work perfectly fine in all other tabs. Also, I did a mock draft and I think the ERA calculation is off. It lists my team with a 4.49 ERA while none of the players on the team have this high of a projected ERA to begin with. Unless I’m missing something I think that has to be a mistake.

    Looks great though, thanks for all the time and effort put in.

    • macgyver

      macgyver says:
      (link)

      @Eblock:

      Yes, this issue was referred to earlier in the comments. To fix this, highlight cells K45-M45 and drag down to the end of the table to fix the ERA problem.

      The ctrl+F feature seems not to pick up players because the players are imported from Grey’s rankings. To make this work, after you hit ctrl+F, click on the place where it says “Options>>”, and change Look in: Formulas -> Values. That should fix the issue.

      If you still have problems, leave a comment and I’ll get to it as soon as I can.

  16. DD'd says:
    (link)

    Thank you — a useful tool!

    • macgyver

      macgyver says:
      (link)

      @DD’d: Cheers!

  17. Ferga says:
    (link)

    I appreciate the hard work, but it might me best to wait for the update. I am having problems with columns adding up, relief pitchers being added to the war room page and many of the total columns showing errors after entering in my leagues keepers for the season.

    • macgyver

      macgyver says:
      (link)

      @Ferga:

      What issues are you having with the columns adding up?

      When adding the new relievers to the war room page, are you also adding them to the players tab?

      Please elaborate, thanks.

      • Ferga says:
        (link)

        @macgyver: Been trying to mess with it. I added my leagues keepers, 5 per team and I am having a few problems(making sure to include at least 1 pitcher).

        First, after adding David Robertson and Koji Uehara to my team, the do not show up in my war room at all.

        Second, I am getting a lot of #ref errors in the war room. They seem to be stemming for the projected pitching totals table. Specifically I71,J71 and I77-J77 and others. Will keep tinkering, let me know if you have any ideas.

        • Ferga says:
          (link)

          @Ferga: The problem seems to be coming with certain pitchers. When I remove Koji and Robertson, for example. My teams war room pitching stats correct themselves. But other teams are still having errors. I will look for the others…

          • Ferga says:
            (link)

            @Ferga: Honestly, finding tons of problems. After removing Wacha from another team that was getting an error in pitching cats and replacing with Glen Perkins…the error corrected itself, but now his team era is 8.00 and whip is 3.00 and that is his only pitcher.

            • Jedd Jerko says:
              (link)

              @Ferga:

              It also appears that the rankings for the pitching categories are reversed. Lowest projected ERA gets the worst ranking, highest ERA gets the #1 spot

              • Brian England says:
                (link)

                How do I get Avg, ERA, & WHP cells to calculate on the war room tab starting with Line 27?

                • macgyver

                  macgyver says:
                  (link)

                  @Brian England: Those cells aren’t really supposed to be touched. Populate the teams (make sure every team has at least one pitcher) and the spreadsheet should start calculating them.

              • macgyver

                macgyver says:
                (link)

                @Jedd Jerko: Didn’t see this problem, the standings seem to be working fine for those two categories.

              • Brian England says:
                (link)

                I’m having this same problem. I have the lowest ERA & WHIP currently but am scored with a 1 instead of 12.
                How do I get these 2 columns to sort rank correctly?

                • Brian England says:
                  (link)

                  Went & downloaded a newer version & after entering all my data it works correctly

    • Ferga says:
      (link)

      @Ferga: Just tossed the old file and downloaded your new one. Seems to have fixed the things I talked about. Its possible I screwed something up myself before entering in players. Thanks!

    • Ferga says:
      (link)

      @Ferga: Actually just figured it out. For some reason, if you change the user input for team name after already entering information as team “a” it splits the data. So I entered Koji and David Robertson as team “a,” then I entered my team name of “Isotopes” and entered Jose Fernandez etc. Well Koji and David Robertson do not transfer over. Long story short, input user names for teams before assigning any players.

      • macgyver

        macgyver says:
        (link)

        @Ferga: No you weren’t incorrect. The old files did have #ref problems that a later user mentioned below. Must’ve been when I was cutting players and moving people around. As you said the new spreadsheet should’ve fixed all these problems.

        Yes, the first page that should be updated is the team page name, and then the players page.

        Thanks for catching errors! Hope it helps.

  18. Nick says:
    (link)

    I was literally going to ask this morning when you were going to release this.

    Congrats on being able to read my mind!

    • macgyver

      macgyver says:
      (link)

      @Nick: Enjoy!

  19. Jon says:
    (link)

    This is awesome! Thanks for the hard work. I also loved the online war room last year. Any chance of that coming back?

    • macgyver

      macgyver says:
      (link)

      @Jon: I didn’t work on last year’s war room. What was this online war room about?

      • Red Barons says:
        (link)

        @macgyver: It was a more friendly version of the Excel spreadsheet with a nice GUI. You could click [I think] a plus sign next to a name to add it to your roster or the x if another team drafted that player. It didn’t evaluate other teams in your league (or how you ranked among them), but you could say that you are in a Yahoo 12-team 5×5 league and it gave you what your personal goals should be. You gave up comparing your team with the rest of the league, but it was quicker than the spreadsheet so it could easily be used during the draft.

        • macgyver

          macgyver says:
          (link)

          @Red Barons: Hmmm, that sounds very interesting. I didn’t see it last year nor worked on it, so unless some other commentator can figure out how to do it, I don’t know if we’ll have it this year.

  20. Joe says:
    (link)

    Great spreadsheet. I did find a REF error when I select Masahiro Tanaka on a team. The War room pitching categories REF out.

    • macgyver

      macgyver says:
      (link)

      @Joe: Thanks. Good catch, it’s being updated now.

  21. Awesome that this is still in use!

    • macgyver

      macgyver says:
      (link)

      @Lou Poulas: Best tool in the business, of course!

  22. macgyver

    macgyver says:
    (link)

    To all:

    The new spreadsheet with the errors that were found are fixed now. Please use this one.

    Thanks

  23. RPither says:
    (link)

    Thank you for the awesome work! Looks great! Q: How do I just have the spreadsheet show NL only? When I delete AL players on the player tab, I lose the overall draft ranking. Any thoughts?

    • macgyver

      macgyver says:
      (link)

      @RPither:

      Thanks! Right now, there’s no rankings for NL or AL only leagues so far this year. When they get set up, then you can change the connection to the right link. So in order to do so, I’m afraid you’re gonna have to manually erase the players and re-rank them yourself for now.

  24. Wake Up says:
    (link)

    Thanks for this…

    Any advice on downloading this to Open Office Calc?

    • Wake Up says:
      (link)

      @Wake Up: Looks like the “Players” page is just showing Name? ##MACRO…

      • macgyver

        macgyver says:
        (link)

        @Wake Up: Unfortunately, I don’t have any experience with Open Office so I can’t help you, sorry. Hopefully one of the other commentators can help you.

          • Shake N Bacon says:
            (link)

            @Shake N Bacon: Not sure if that’ll work. I give up…until someone figures it out :)

            • TysonFrozenChicken says:
              (link)

              @Shake N Bacon: The error is related to the worksheet’s need to import data from a link.

              The source file given is http://razzball.com/projections-grey. The element listed is HTML_neorazzstatstable.

              Does that help anyone figure this problem out?

              • Terrible Ted says:
                (link)

                @TysonFrozenChicken:

                I got it. You need to change the formula from something like this: =iferror(VLOOKUP(A270;$Import.$V$3:$X$419;3;0);””)

                To something like this: =(VLOOKUP(A270;$Import.$V$3:$X$419;3;0)

                Change the first formula in each column accordingly then drag it down. Unfortunately it looks like you have to do this for each column on the “player” page. You also have to fiddle with some of the formulas on the “war room” page depending on how many players in your league.

                • Wake Up says:
                  (link)

                  @Terrible Ted: Thank you!!! That worked.

                • TysonFrozenChicken says:
                  (link)

                  @Terrible Ted: That works!

                • macgyver

                  macgyver says:
                  (link)

                  @Wake Up: Guess it must be that Open Office doesn’t work well with the If error function. I’ll put that in the back of my brain if I ever run into that issue again. Thanks for helping all.

                  • Wake Up says:
                    (link)

                    @macgyver: I do not know my way around a spreadsheet at all…but…last year it opened in Open Office correctly…not sure if that helps you…

                    • macgyver

                      macgyver says:
                      (link)

                      @Wake Up: Yeah, last year didn’t have the real-time update feature that this year’s did. That’s why it worked last year and not this year.

        • Wake Up says:
          (link)

          @macgyver: Thank you for doing this!

          • macgyver

            macgyver says:
            (link)

            @Wake Up: You’re welcome! Hope it helps!

  25. RicoSuave says:
    (link)

    Can I use this for H2H points league? if not, what changes should I make?
    Thanks

    • macgyver

      macgyver says:
      (link)

      @RicoSuave: You can still use the sheet for projections and keeping track of rosters, but there’s no place to put what each category would be worth. In order to use this for a points league, you would have to change the entire Players Tab, and at that point, it might not be worth it….

  26. Tbill says:
    (link)

    OK, First time I’m seeing this tool. I’m not sure how the drafting works or how to identify the players selected by the teams. Which page do I use for that? Is is a drag and drop function?

    Sorry, if I missed this somewhere:(

    • macgyver

      macgyver says:
      (link)

      @Tbill:

      The first page should give you a general idea of what to do, but in simple layman’s terms:

      On the last tab, put in the 12 teams in your league before the draft. While the draft is going on, go to the Players page, and next to each drafted player, put the team who drafted them.

      That’s all you need to do. Everything else should be populated automatically. Then use the War Room page to see your projected standings, up to the pick.

      • goodfold2 says:
        (link)

        @macgyver: i understood how to use the last year’s one. how do you take a player’s name and add it to the team who drafted him? do i actually have to type it in myself, or is it some version of copy and pasting i’m not getting?

        • macgyver

          macgyver says:
          (link)

          @goodfold2: It should work exactly the same as last years. Input the team names, and then right next to the player on the players page, there should be a list of the team names. Just assign the right team to the right player.

          There should be no copy/paste needed.

          • goodfold2 says:
            (link)

            @macgyver: the one i knew how to use last year was the non-excel version (i’m not sure if i attempted to use the excel version last year or not). didn’t know it was imperative to put in team names first, and didn’t know the moving of a player to the team he was drafted by all happens on the same page, the player page.

  27. Giacomo says:
    (link)

    For an auction, is it going to screw it up if we overwrite the “$” column with what is actually paid for a player on the Players tab?

    • macgyver

      macgyver says:
      (link)

      @Giacomo: There should be an auction war room coming soon, but no that “$” column is only Grey’s projected value. You can change that to your heart’s content.

  28. Fungazi says:
    (link)

    Cool stuff. Going to actually try and use it this year. Especially like how it’s laid out that anyone can add their own custom edits. For example, I cut the Goal Tracking rows P27 on the War Room tab and placed them in the frozen panes above the corresponding stats (R, HR, etc) for the average stats per team and on my team. It seems like if I’m going to have to track everyone’s pick, this will avoid having to constantly check if those numbers are changing on a separate tab. If that makes sense at all.

    • Fungazi says:
      (link)

      @Fungazi: Moved the Goal tracking from War Room tab to Players tab. Forgot that small detail.

      • macgyver

        macgyver says:
        (link)

        @Fungazi: Yup, the primary function is just a simple spreadsheet that lets people keep track of their own goals, but like you said, it’s customizable (to an extent) to what you might need.

        Hope it helps you this year!

  29. Z-man says:
    (link)

    How do I modify this to be AL or NL only?

    • macgyver

      macgyver says:
      (link)

      @Z-man: Right now, there’s no feature for that except to remove the players manually. Until the rankings for AL/NL only leagues are setup, the table that the projections are grabbing from are picking up all players.

  30. ¿WhoAmI? says:
    (link)

    Is it possible to change the player rankings and projections?

    • macgyver

      macgyver says:
      (link)

      @¿WhoAmI?: Yes. Right now everything is synced to Grey’s projections, but if at any time you want to change them you can.

      Just make sure you overwrite the cell manually, and don’t cut (or drag the cells) or else the #REF issues former members have mentioned will cause the War Room to break.

  31. Brian England says:
    (link)

    How do I get Avg, ERA, & WHP cells to calculate on the war room tab starting with Line 27?

    • Brian England says:
      (link)

      Never mind figured it out. each team has to have at least one hitter & one pitcher to correctly calculate

  32. Dubbs says:
    (link)

    Anyone know how to pull steamer data into excel? I can pull Grey’s rankings/projections using the Data>From Web option in excel 2007 but the steamer data I am trying to pull from fangraphs does not seem to be in a compatible table format. I know I can just export that data into excel but I would prefer to have that data linked so that when projections are updated I won’t have to go back and recopy/paste everything. I think Rudy will have a similar table to Grey’s that contains steamer data so I could probably just wait…but I have things rolling now and don’t really want to stop. Thanks!

    • macgyver

      macgyver says:
      (link)

      @Dubbs: Yup there’s no real easy way to do this unless you wait for the table to have the same format. Otherwise if you do a straight import the cells won’t match up properly.

  33. Greg says:
    (link)

    When I download the excel 03 spreadsheet, the players tab is all errors …=_xlfn.IFERROR(VLOOKUP(A3,Import!$V$3:$X$419,3,FALSE),””)

    I didn’t have this issue last year…any advice?

    • macgyver

      macgyver says:
      (link)

      @Greg: Did you enable data connections? What we changed this year is to have updates to the Players page to have the current projections (as Spring Training goes along) by Grey.

      If you’re still having this issue if you enabled data connections, please let me know.

      • Mike Adamson says:
        (link)

        @macgyver: I’m having the same issue with the 03 Excel version. If the update function is included in the file then maybe Excel 03 isn’t picking it up? I can add a data source manually…any suggestions?

      • Greg says:
        (link)

        I have never done this before. Any suggestions on help? @macgyver:

          • Greg says:
            (link)

            whats the password? @Grey:

            • Grey

              Grey says:
              (link)

              Try it again

  34. Charlie says:
    (link)

    Thanks for having this done!!! You sir are awesome!!!

    Does anyone know what I should enter for goals for R, HR, RBI, SB, AVG, ERA, WHIP, W, SV, K for a 10 team league? Grey had mentioned this last year but I forgot. Thanks.

    • Stock says:
      (link)

      Agreed. Could we use the numbers(goals) from last year?

      • macgyver

        macgyver says:
        (link)

        @Stock: You could for now, but I’m sure with the influx of pitching, the goals for hitters should be slightly lower.

        • TysonFrozenChicken says:
          (link)

          @macgyver: Correct me if I’m wrong, but if you want to change the goals for a different league size other than 12, it all comes down to the number of batters/pitchers you start.

          For instance, it’s set up for 13 batters, so if you’re in a 16-team league that starts 10 batters, you divide each batting by 13 to get the recommended stats per batter, then multiply by 10 (the actual number of starters in your league).

          I don’t know how accurately the per-player recommendations translate across leagues, but it’s an inexact science to begin with. Am I on the right track, MacGyver?

    • macgyver

      macgyver says:
      (link)

      @Charlie: Cheers! Glad you enjoy it! Rudy should have the goals later on in the preseason.

  35. MattTruss223 says:
    (link)

    Absolutely the best tool in the biz right here, thanks for saving me the time of updating my older version for this year. I’ve got enough time into my other spreadsheets as it is, haha. Thanks a ton man, you’re the shizz!

  36. Ryan says:
    (link)

    Thanks, Razz-guys, for everything! I can’t wait to toy with this software and see how it helps me construct teams. I made a small donation just now to cover all of the help you all have given me, including winning my first fantasy championship ever in football this year!!

    Any suggestions on how to use War Room quickly and efficiently while doing live drafts with, say, minute and a half selection clocks? Practice makes perfect, I’m sure, but what are you focusing on in War Room while actually doing a draft?

    Thanks again!!
    -Ryan

    • macgyver

      macgyver says:
      (link)

      @Ryan:

      Thanks!

      Just speaking for myself, after about 4-5 mocks using it, I’m pretty much in tune on what to do, but the main focus as always is your team.

      Depending on fast your league drafts, you might have time to slot certain players you expect to be around to see how it fits your team vs the goals. If you don’t, again main purpose is for your team to see what you’re lacking in, so don’t worry too much about filling the other teams in (there will always be a 3-4 min lull sometime during the draft that you can). Worry more about how to make your team better first.

  37. Brian England says:
    (link)

    Figured everything out but on the user input page: # of batters / pitchers My total roster size is 25 of which we start 12 Hitters & 7 pitchers.

    Do I put Batters 12 & Pitchers 7 or include the 6 BN spots as well?

    • Charlie says:
      (link)

      @Brian England:

      I’ve only been including starting roster spots. So my totals don’t include my bench spots.

      • Brian England says:
        (link)

        Thanks

        • macgyver

          macgyver says:
          (link)

          @Charlie@Brian England: Usually the tool is used just for starters. The reason being some teams might have 3 hitters and 3 pitchers while others have 5 hitters and 1 pitcher. That’ll throw off the standings quite a bit.

          • Brian England says:
            (link)

            Thanks Thought so but was making sure. Appreciate this tool. NICE

            • macgyver

              macgyver says:
              (link)

              @Brian England: Sounds good! Glad it helps.

  38. Peter Nincompoop says:
    (link)

    Thank you for putting the time into this. An extremely valuable tool.

  39. Mike says:
    (link)

    This is the best tool for mixed league drafts. Helped me come in first place last year. This year, I am in an NL Only League, and need help… Please create NL and AL Versions.

    Thank you

    • macgyver

      macgyver says:
      (link)

      @Mike: Once the NL only and AL only projections come out, I think I should be able to tweak the spreadsheet to do this. For now, removing the players should work, but must be done manually.

  40. Tyler says:
    (link)

    Is this designed for roto leagues only? And is it designed for any specific roster composition ?

    I play in a 12 team h2h points league, I’m not too sure how helpful/accurate this tool will be.

    Thanks

    • fantasyfriend says:
      (link)

      @Tyler:

      Under the input tab, you can add your league’s roster set up (e.g. 15 hitters, 10 pitchers, etc.)

    • macgyver

      macgyver says:
      (link)

      @Tyler: Yes the tool is mostly based on roto leagues. It’s not necessarily designed for specific roster composition but the dashboard page is there for you to see the different tiers of positions if you ever feel like it’s the tail end of a run and you’re missing a guy.

      You can still use this for a H2H league as if you’re building a team specific to certain categories, you can compare how your team stacks vs. another.

      This isn’t very useful for points leagues I’m afraid though. Because the projections don’t break down TB and BBs, it’s hard to project those.

  41. Fungazi says:
    (link)

    Thought I would let you know, not sure if someone else already pointed it out. There are a ton of players on the Dashboard tab that will not cross off. This is because their names are misspelled from the Import tab i.e. Brett Lowrie. Easiest way to locate them all is unhide the lookup formulas to the right of the names and look for the broken ones.

    • macgyver

      macgyver says:
      (link)

      @Fungazi: Yup, typing 405 players is tough!

  42. BigDeal says:
    (link)

    Should I only enter starting hitters on this spreadsheet? Won’t backup hitters skew the overall numbers for each category and the rankings if one team has 15 hitters compared to another team only having 10 hitters?

    • macgyver

      macgyver says:
      (link)

      @BigDeal: Yup, the war room is used only for starters. Otherwise once you start adding bench players, the standings will get skewed.

      • BigDeal says:
        (link)

        @macgyver:

        Cool – thanks.

  43. BERK! says:
    (link)

    This is so great! Was there also a post last year that highlighted the biggest differences in value between ESPN’s & Grey’s projected value? As in ESPN ranks Kung Fu Panda at $25 but Grey says $20 so stay away? And then also the inverse, providing guys to target and be willing to “overpay” for when the rest of the suckers in your league are going by the value ESPN gives? Thanks again.

    • macgyver

      macgyver says:
      (link)

      @BERK!: You’re welcome. There will be a post later on in the preseason (if last couple of years is an indicator) that Grey will compare rankings vs Y!, but don’t think he does it for auction values.

  44. fantasyfriend says:
    (link)

    anybody have any tips on how to quickly input a player on a team?

    Picks are going way faster than I’m able to add them. And it simply isn’t even close. The “Control +F” command doesn’t work either because the names of he players are all formulas.

    Love the idea of this spreadsheet, just looking for tips on how to utilize it to its full potential.

    Thanks — the hard work here is much appreciated.

    • macgyver

      macgyver says:
      (link)

      @fantasyfriend:

      To fix the Ctrl+F method, when you hit Ctrl+F, click on the place where it says Options >>>, and then where it says Look in: Formulas, change this to values and it should work fine.

      As for the speed of the draft, keep practicing with mocks. Took me 4-5 mocks before I got everything down. You don’t need to update other teams picks real-time, keeping a piece of paper next to year and jotting down names that are gone and go back.

      The tool is more for your teams vs the goals you’re trying to hit rather than other teams.

      If it’s still too quick for you, again, fill in your picks only and while other teams are drafting, try to pick and choose some players to see how they’ll help you with your projections, and keep them on queue.

      Hopes this helps.

      • fantasyfriend says:
        (link)

        @macgyver:

        Changing “look in” to values pretty much solved my entire issue. Thank you!

        • macgyver

          macgyver says:
          (link)

          @fantasyfriend: You’re welcome! Glad to help.

  45. matt says:
    (link)

    Undoubtedly this is a great tool. Unfortunately im on a mobile phone so it’snot to.work.

    • matt says:
      (link)

      @matt: my war room is the top 400 players on a good ol piece of cardboard. Lol

  46. Jon says:
    (link)

    Did I hear a rumor about an iPad app? Or was there one last year or something?

  47. Donkeycornered says:
    (link)

    Awesome tool Mac and it seems to get better each year. We used it for money finishes the first two years and probably would have last year except we spent high picks on Greinke and Stanton. Keep up the good work!!

    • macgyver

      macgyver says:
      (link)

      @Donkeycornered: Thanks! It’s helped me tons in my two biggest leagues as well. Just a tool almost everyone can use.

  48. Owen says:
    (link)

    i’m using OpenOffice & after making the adjustments to all the formulas on the players page to make everything show up as it should, I now cannot get the dashboard page to cross off correctly. It wants to cross off the players just after the first player in each position

    Selecting Mike Trout in Players –> Andrew McCutchen crossed off on Dash
    Robinson Cano –> Jason Kipnis
    Kershaw –> Darvish

    Any ideas what I might have done here?

    • macgyver

      macgyver says:
      (link)

      @Owen: Don’t know much about Open Office, but playing around with the formulas must’ve messed up the dashboard.

      Open up the dashboard sheet and unhide all cells. Then check for each section, it must’ve moved everyone down one.

      For example, cell AB2 should be checking Z2, and AC2 should be checking if AB2> 0.

      Let me know if this works, if not I’ll get back to you.

      • yah says:
        (link)

        @macgyver:
        I have the same exact problem. The formula looks like this on Dashboard: =VLOOKUP($AO3;$Players.$Z$3:$AA$1425;2;FALSE())
        A03 matches with the player in cell A03, but it still crosses off the player one cell below.

      • yah says:
        (link)

        @macgyver:
        Also, it correctly inputs the team next to the player in dashboard, but then still crosses out the player below the one that has the team name next to him. ANy ideas?

      • Jayrod Ceol says:
        (link)

        @macgyver: Ever get back to this issue? I don’t want to mess with any of the formulas and screw it up. I don’t exactly understand where its trying to pull the info from.

        • macgyver

          macgyver says:
          (link)

          @yah@Jayrod Ceol: From my limited googling and touching Open Office a bit, I might have figured out what went wrong when you changed some of the formulas.

          The problem isn’t with the hidden cells, if what yah says is true. The problem is with your conditional formatting. I used the regular spreadsheet and it worked fine, so something must have changed there.

          Go to Cell Z2 (Mike Trout) and go to Format->Conditional Formatting.

          It should say in Condition 1, Formula is : AC2>0
          Z3 (McCutchen) should say AC3>0

          I think what must’ve happened (I assume) is that it somehow changed Trout to AC1>0 and McCutchen AC2>0 and so forth for every cell.

          Let me know if that’s the issue. The problem is I don’t know how to do this for every cell all at once (like in Excel). I only have found that you have to do it manually for every cell in Open Office.

  49. Tehol Beddict

    Tehol Beddict says:
    (link)

    THere is no better fantasy baseball tool. I’ve scoured this puny in earth in search for decades and this is the only thing worth my time.

    • macgyver

      macgyver says:
      (link)

      @Tehol Beddict: Glad you enioy it!

  50. Tim B says:
    (link)

    Is there anyone to personalize the stat categories. Ex. (Using BB instead of Runs or Hits instead of AVG. or QS instead of Wins) If so, does anyone have a plausible goal values for BB’s, Hits and QS.

    Also, should you alter your goal if your league has only 10 starting hitters, and 8 starting pitchers; since bench players should not be used.

    • macgyver

      macgyver says:
      (link)

      @Tim B: Yes, the headers are only there for default leagues. You can change any of those headings and put in your own projections.

      Rudy will have the full post of what each goal means later in the preseason I believe.

  51. ForWhomGeorgeBellTolls says:
    (link)

    Great work. Used this last year and loved it. macgyver, help yourself to one or two of the daiquiris I just bought Grey in thanks!

  52. Casey Jones says:
    (link)

    This is phenomenal! Thank you so much. Is it possible to add a category for obp? For some reason my league is allergic to avg. Thanks again for this great tool.

    • macgyver

      macgyver says:
      (link)

      @Casey Jones: Adding a category is tough because you would have to manuever all the cells (hidden and unhidden) in the players tab. If you want to replace AVG with OBP, that you can do just by overwriting the cells where AVG is.

      • Casey Jones says:
        (link)

        @macgyver: Great. Thank you so much!

  53. Goose says:
    (link)

    I’m getting a #REF! error on the War Room sheet in 11th team slot in the I and J columns and its breaking the sheet. Seems like it starts on I81 but I don’t know enough about excel to fix it.

    • Goose says:
      (link)

      @Goose: I should mention I downloaded the most recent Excel snake draft version

      • macgyver

        macgyver says:
        (link)

        @Goose: This must’ve happened when you added a player that has a reference problem. Go back to each pitcher that you added to that team and remove them. Add them back one by one and see which pitcher caused this problem, and then can you let me know? Thanks.

  54. brent says:
    (link)

    long time reader but I have never used this. Must say, it is real nice. Well done.

    • macgyver

      macgyver says:
      (link)

      @brent: Thanks!

  55. Cheese says:
    (link)

    Any chance anyone could email the newest version for snake draft to me? My work blocks this site :( jessemarchese@gmail.com

    If there are any kind souls out there!

    Thanks in advance :)

  56. birrrdy! says:
    (link)

    Great tool. Is there a latest download with all the bug fixes, or a single post with all the corrections I can make myself? Also, what’s the best way to convert the auction spreadsheet into an NL only version?

    Many thanks,
    Birrrdy!

    • Goose says:
      (link)

      @birrrdy!: If you have the latest Excel (or probably in the 2003 version, too) you can go to the players page, click filter, go to the team column and filter out the AL teams.

    • macgyver

      macgyver says:
      (link)

      @birrrdy!: The version that you can download should have all the bug fixes known as of now.

      The best way is to remove the players manually, but then the ranks get all screwed up. If you want the ranks to stay in tact, the best move is to create a new worksheet and just copy paste the rankings over, and remove the players manually.

  57. Yanksss says:
    (link)

    Typo in the dashboard which causes the link to break, domonic brown is spelt dominic

    • macgyver

      macgyver says:
      (link)

      @Yanksss: Thanks for catching this!

  58. Isaac says:
    (link)

    Is there a formula to calculating the goals? I have a league with a whole bunch of categories, so I am altering the War Room to work with that. I know Rudy will put them up at some point, but is there a fast and quick formula to use to get for all categories?

  59. Benson says:
    (link)

    Hopefully this hasn’t been asked already, but I’ve noticed a lot of conversation focused around how to use this during the live draft. Many are having some trouble keeping up with tracking every single team’s pick, and the advice is to prioritize your moves and look at your actual-to-goal stats to help you stay on track.

    I was wondering if the drop-down select tool used on the Players tab could be modified to a Teams page that lists the Teams in the top row, which you could arrange in draft order, and the draft rounds in the left column. Then players would be listed in the drop-down box using some type of autocomplete feature, so you can just start typing in their name (a fix may be needed for names with accent marks, etc.), select them for a given team in a round then just tab to the next team’s choice. This would be impossible to use by manually selecting players to a team because of many many players would be listed, but if you can simply type in the player’s name then it might be possible to use this rather effortlessly during your draft. I would love everyone’s thoughts on this or whether it’s been tried already.

    Now I have to learn how to do it (an autocompeleting drop-down tool); I think this video’s discussion on combo box is the way to go at the moment.

Comments are closed.