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

This was author and innovator Lou Poulas’ introduction, “While Grey and Rudy do a great job of breaking down everything you need to know for 2012 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 2012 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

Unfortunately, Lou and Simply Fred (who took the reins last year) were inundated with the real world but were kind enough to allow me to make updates for 2012.  My quick two cents:  I 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 have been a fantasy baseballer for a long time. The first team I drafted my ace pitcher was suppose to be Steve Stone. He had won the Cy Young the year before. He sucked the year I had him. When I ran out of money I bought two cheap young pitchers, Fernando Valenzuela and Mike Norris. I have been hooked ever since. The only reason I tell you how long I have been doing this is to support the following compliment. Razzball is the best source for fantasy baseball information that I have ever used. The combination of humor and analysis is unmatched. I read it daily but do not comment often. I thought I would update the War Room as I hope it helps the site in some small way.  I did not spend a lot of time debugging the sheet. I figured the daily posters will do that for us, the Razzball community. I will look for your comments to see if there’s anything I can help with.

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

  1. The Players page lists players in order of Grey’s top 300 for 2012 fantasy baseball with Grey’s projections (and his auction values on the auction draft worksheet). FanGraphs stepped up to the plate and graciously provided projections for players unranked by Grey.
  2. AB (At-Bats, i.e. playing time) provided by FanGraphs.
  3. Goal Tracking has been pre-loaded with temp targets for “What it takes to win a 12 team fantasy baseball league.”
  4. The “Dashboard” displays players by position in order of Grey’s rankings.
  5. 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.
  6. Up to 25 players may be drafted per team (allocations set by the user via the ‘User Input’ page).
  7. 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 2012 Fantasy Baseball War Room <–Snake Draft

Download the 2012 Fantasy Baseball War Room <–Auction Draft

(UPDATE 2/21:  1. – You can add more than 12 teams – Just had to change a setting. 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.  2. Corrected the misspellings  3. I color coded the tiers in the catchers. It does not look that good but it may be helpful. You can color code your tiers by changing the color of the letters. Do not change the color of the cells it breaks  the cross off feature.  Just change the color of the lettering.  4. Fixed the formatting in a few bad cells.

UPDATE 2/25:  Ryan Braun projections and ranking updated.)

Download the 2012 Fantasy Baseball War Room <–Point Shares and Point Shares Auction Values included (NOTE FROM GREY: This will be provided once Rudy finishes Point Shares in the next few days.  Go to his latest post and bug him to finish faster.  Oh, and thanks to JD for doing this!)

195 Responses

  1. neogonzo mourning says:
    (link)

    whoa

  2. Jerry says:
    (link)

    Ok so I’m new to this…how do I load this into Excel?

    Thanks!

    • JD Hassett

      JD Hassett says:
      (link)

      @Jerry,
      I see you figured it out but I thought we would post the instructions if someone else needs them.
      Right click either link the Snake draft or Auction
      Click on Save Target as
      Add .xlsx to File Name – so it is 2012-War-Room-Auction.xlsx
      Change the save as type box from Compressed to All files
      Hit Save Then Open

  3. AStue says:
    (link)

    You guys are my heroes for this

  4. Bourne says:
    (link)

    Okay, so I had not used this in previous years. First to answer Jerry, you just click the download button in the link. You don’t have to import anything into word. What you maybe wondering is it is currently in xlsx format, so older versions of word are not compatible. You can use this if that is the case: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3

    As to using it, I didn’t understand the notes until I read them a few times. There is tab 5 (user input). You simply name teams there. You can use your friends’ team names, or just use “team x”. After that, go to the Players tab. there is a drop down with the team names in the “owner” column. pick the team that gets each player. If you are just looking at your team players, you can do that too. Third, goto the War Room tab. This has the list of players you have selected, and also data analysis of your team and the other teams too.

    I first tried to enter my team into user input, but that didn’t work. I also took a little while to find that the owner column was a drop down. Once I had those figured out, it made a lot more sense.

  5. Jerry says:
    (link)

    Thanks for the help!

  6. AL KOHOLIC says:
    (link)

    great job,and Simply Fred is awesome with his research and annalysist,thanks all

  7. Big Mike says:
    (link)

    won’t open in Excel. Don’t see a “download” button in the link, only open & save.

  8. Chase Muttley says:
    (link)

    When I download this file it only has a bunch of folders with .xml files. No .xlsx files or Excel formats. Any ideas?

  9. Nate says:
    (link)

    Thsi sounds cool and all, but have no idea how to open the files, the author said its an excel file, the poster above said its a word file. The zip file has a whole bunch of .xml files in there and I have no clue what to open or what im supposed to look at. What is the main file im supposed to open first and what program am I useing to open the file?

  10. Bruce Boachy says:
    (link)

    Nasty Nate is right. Having the same issues, son.

  11. Steve says:
    (link)

    Nate and Bruce – what happens when you guys click on the link?

    It’s working fine for me (in Firefox). I get asked whether I want to save it or open it using Excel.

  12. Bourne says:
    (link)

    I actually said you don’t have to use word (or excel). However, I can click on the links and both give me a save as option for xlsx format (excel 2007 or later).

    I don’t use office. I use openoffice.org calc program. I was able to save and open both links just fine. I was able to open it on firefox. Using IE, I get a zip file too. It works great in Firefox though. I just try not to use IE when possible.

  13. Jerry says:
    (link)

    OK I figured it out!

    -Right click Save Target as…
    -Under the Save as type drop down, choose all files
    -Change the .zip to .xlsx, and BOOM! Your Excel file.

    Thanks to Bourne for the help!
    And Razzball for this awesome tool!

    • Steve says:
      (link)

      @Jerry, Yeah – I just tested this and it definitely does work. Nice one.

      That’s IE for you…

  14. Big Mike says:
    (link)

    @Jerry … BOOM! Worked like a charm … thanks.

  15. Nate says:
    (link)

    Thanks Jerry got it working.

  16. Jim says:
    (link)

    Two issues that I have come across so far:

    1- When you add a player and his stats to the “Players” page (say Bryce Harper for example) and then put his name in a yellow slot on the Dashboard, that player does not show up in the War Room roster when drafted…any thoughts?

    2- Say that the league is an 8 or a 10-team league. Is there a way to make the War Room scoring reflect ranks on a non-12-point-scale?

    Thanks for all this stuff guys…great work.

    • Bourne says:
      (link)

      @Jim, you don’t add players to the yellow spots. It should do that automatically when you change the owner of the player (drop down) to your team.

    • JD Hassett

      JD Hassett says:
      (link)

      @Jim,
      1.I started with last years sheet and I cut and pasted a lot of stats. I had to repair some cells to get them to total correctly. May have missed a few. You may want to try a different cell. I added him right below Guerrero on the players tab and right below Travis Snyder on the dashboard and it worked.

      2. I am in a 21 team league so what i did was go to the War room tab where it displays projected Batting Ranks and in the cell under Runs,HRs,RBI’s and SB’s I changed the range in the formula in the cell. IE under runs for the first team which is cell B27 I changed the range to C$91 so it was Rank(c71,C$71:c$91,1)- cut+paste to the others. I did not design the sheet so I am sure there is a more graceful way to do this but it worked. You just adjust the range for the size of your league.

      • Chris says:
        (link)

        @JD Hassett,
        I am in a 15-team league. With regard to point 2 above, what should I change the range to?
        Thanks in advance!

        • Chris says:
          (link)

          EDIT – never mind, I just figured it out, thanks to your original comment!

      • Jim says:
        (link)

        @JD Hassett, I tried to change the formula to fit my 8 and 10 tram leagues, but still haven’t been able to make it work…what would I change those formulas to to reflect the desired range?

    • JD Hassett

      JD says:
      (link)

      @Jim,
      Going down to an 8 or 10 team league worked better than going up for larger leagues. I will check what I did last year.

  17. William says:
    (link)

    Cool piece of software, thanks

    Note that the outfielders didn’t get crossed off as picked so I had to copy just the formatting over from shortstop which fixed it.

    thanks again

    • JD Hassett

      JD Hassett says:
      (link)

      @William,
      Thanks for pointing that out. If you have a different version of excel some of the cells and formula’s do break. You did excatly what you should. Find one that works and copy to those that broke.

    • Sy says:
      (link)

      @William,

      How do you copy only the formatting? Thx Sy

  18. mt says:
    (link)

    Any way of changing the number of teams to 14?

    • JD Hassett

      JD Hassett says:
      (link)

      @mt,

      Check my answer to Jim’s comment under #2 and see if that helps.

    • JD Hassett

      JD says:
      (link)

      @mt,

      Going down to 8 or 10 teams seems to be working better than going up. I will have to check and see what I did last year.

  19. chata says:
    (link)

    looks like a wonderful tool .
    no problem down-loading the content .
    just wish there was a tutorial … for the slow learners .
    simple stuff like :
    a) how do i start ?
    b) how do i select a player ??
    c)
    d) are you guys actually inputting every player chosen , while the
    draft is in progress ???
    e) am assuming that i can take this for a test drive (mock draft) ,
    erase it , and start anew .
    is this correct ????

    • JD Hassett

      JD Hassett says:
      (link)

      @chata,

      I will tell you how I use it.
      a. I start at the User input tab and put in the team names, number of batters and pitchers and team goals

      b. To select a player go to players tab and click on the cell to the right of the players name. The drop down box will have the names of the teams. Just click on which team selected the player. That will cross the player off the dashboard and update the war room totals.

      c. I love c

      d. I have input every player but I usually don’t. I like to drink beer too much. If you do use CTL F when you are in the players tab and it will pop up a find box and help locate the players. I really like it for my keeper leagues. I put the keepers in before the draft and then print the sheets and cross off selections by hand. It does not help as much but is less work.

      e. When you are done putting in your mock draft just select an empty cell in the owners row and copy and paste to all the cells that have owners listed. That wipes out all the selections. If you wish to save the results of the mock draft just do a save as on the spreadsheet and give it a different name.

  20. Vito says:
    (link)

    Wow, this is really cool. Thanks.

  21. Howard says:
    (link)

    Wow, this is awesome. I wish I could figure out how to get the cross outs to happen though (the formula, that is).

    • JD Hassett

      JD Hassett says:
      (link)

      @Howard,
      If you do let me know how they work. I originally color-coded the dashboard by using different colored cells for different tiers. It broke the cross off feature. I did go back and change the color of the names – not the cells for the different tiers so you know when a tier ends. That seems to be working.

  22. Adam says:
    (link)

    Hosmer’s stats appear to be blank other than ABs under the player tab. Other than that, fantastic!!

    • JD Hassett

      JD Hassett says:
      (link)

      @Adam,

      Good catch – grey predicted 85 -25-95-10 and .280

      I have the first pick in a keeper league and I am between hosmer and lawrie – I wonder if this is an omen

  23. Rags says:
    (link)

    This looks like a fantastic tool, but one request for modifications for next year: if possible, some way to limit the player pool for AL and NL only leagues? You guys should talk to the guy at lastplayerpicked.com. He has an amazing dynamic pricing system set up, it’s just missing all your war room dashboard stuff. If you could somehow join forces, you’d probably have the best tool for drafting around. I’d happily pay for something like that.

    • JD Hassett

      JD Hassett says:
      (link)

      @Rags,

      It is not hard to seperate AL + NL players. I did it for a guy last year. I put AL or NL before the rank – Put the cursor on the 1 next to Cabrera and add AL before the 1 – do that for each player – use the sort and filter towards the top right hand side and sort it largest to smallest to list the NL on top. I think I added numbers to the players over 300 also

  24. mike says:
    (link)

    love this fantastic job

  25. Tony says:
    (link)

    I’ve got the whole deal up. I’m not sure how it works though, i agree with chata, some instructions for dummies would be nice.

    Do I have to enter every player I draft during the draft?

    Does the software do that for me? Or do I just click somewhere, that adds the guy and we move on?

    I’m semi-confused.

    • Steve says:
      (link)

      @Tony, Once you’ve entered your team name on the ‘User Input tab, click on a player name on the Players tab. You’ll see a dropdown. Click on that and select your team name from the dropdown.

      Now look on the Dashboard tab against the player you selected. you’ll see it’s crossed out.

      Now look on the ‘War Room’ tab under ‘Your Selected Players’…

      • chata says:
        (link)

        @Steve,

        was all set to thank you profusely for the step-by-steps ,
        but when i went to the user tab , i couldn’t type in my name .

        since position #1 (<—- your team) has the letter "a" ,
        and i couldn't erase it ,
        i scrolled down to type my name on the line for team #12 .

        no luck doing that , either .
        even tried the always tricky "right-click" , to no avail .

        • Steve says:
          (link)

          @chata, You can’t just click in the cell and then overtype?

          • chata says:
            (link)

            @Steve,
            nope .

        • VinWins

          VinWins says:
          (link)

          @chata, Did you save it or just download? Maybe it is still “read only.”

          • chata says:
            (link)

            @VinWins,
            i think i did both .

            • VinWins

              VinWins says:
              (link)

              @chata, Well, I’m out of ideas.

              • chata says:
                (link)

                @VinWins,
                sounds like i’m out of luck .

                let me ask you this ==> how did you get rid of that “a” ?

                • VinWins

                  VinWins says:
                  (link)

                  @chata, I just clicked on that line and started typing. At first when I tried it I couldn’t type anything, and then I noticed it said “Read Only,” which is why I suggested that. But once I saved it (I don’t have Excel; I use Open Office) I could input team names.

                • JD Hassett

                  JD Hassett says:
                  (link)

                  @chata,
                  Change the team name in user input

  26. VinWins

    VinWins says:
    (link)

    I think during the draft you go to the “player” tab. When a player gets drafted, you clickon the box to the right of the player’s name, under the heading “owner.” Then you click on the arrow that appears, and a list of owners which you have input (or just your name if that’s all you want to track) drops down. You click on the owner that drafted that particular player, and it will be recorded.

    That’s how I understand it, anyways.

    • VinWins

      VinWins says:
      (link)

      @VinWins, Or what Steve said, more succinctly.

  27. sean says:
    (link)

    Anyone try using this with Numbers?

  28. Jim says:
    (link)

    I still have been unable to get a custom added player who is not on the original list to appear in the “your selected players” list in the War Room. I can list them as on my roster and they appear crossed out on the Dashboard…just not in the War Room.

    • JD Hassett

      JD Hassett says:
      (link)

      @Jim,
      Can you let me know which player and where you were putting them. I had this comment earlier and I think I have a few broken cells.

  29. Micah says:
    (link)

    Great work, guys. One question: is it possible to add players you haven’t ranked? I’m in a pretty deep league, very dynasty-oriented so younger guys get picked all the time. Can I just paste him and his stats into the Players tab and have it work out?

    Also, it would be great if it computed auction values based on the number of teams. Thankfully it’s easy to do the math to convert 12-team values to 16-team.

    • JD Hassett

      JD Hassett says:
      (link)

      @Micah,
      Add players and their stats to the players tab first and then add them to the dashboard. Make sure the spelling is exactly the same.

      • Micah says:
        (link)

        @JD Hassett, Ahh, excellent. I thought they went to the dashboard automatically. Thanks!

  30. wiudavis says:
    (link)

    I used this last year and it was great. Thanks again for all the work.
    Last year I was able to get my hands on the sheets that you guys used to calculate the projections. Is there any chance that you could email them to me this year? Thanks again.

  31. Hawk says:
    (link)

    This is superb. I can’t even tell you how much time this saved me. Well…I could tell you if I wanted to calculate it but I don’t feel like doing that.

    Thanks guys!

  32. King Wank says:
    (link)

    Worked like a peach for me. My bro (and co-owner) has been begging me to “go paperless” for years. I guess I’ll finally come out of the stone age…even if I worry about loss of power.

    • Steve says:
      (link)

      @King Wank, Heck of a username.

  33. Citymouse says:
    (link)

    When I add to team slots 13,14,15… on the user input page something isn’t registering. I can’t assign players to any of the teams in those slots and they don’t show up as options in the dropdown list. Anyone have any ideas?

    Awesome tool, though. Thanks.

    • JD Hassett

      JD says:
      (link)

      @Citymouse,
      I just checked last years and it allows more teams. I will try and figure out how I broke it.

    • JD Hassett

      JD says:
      (link)

      @Citymouse,
      I fixed it and will e-mail to you and Grey. Thanks for de-bugging.

      • Jamo says:
        (link)

        @JD, Can i also get a copy? I tried adding 2 teams on the User page but they don’t appear in the Drop down menu in the players page. Thanks!

      • mannofsandd says:
        (link)

        @JD, Is there any way I could get a copy as well? I can’t assign anyone to teams 13 or 14. Thank you!

  34. SOB says:
    (link)

    I have been running a very similiar spreadsheet for about the last ten years. It is my most valuable tool.

    I would suggest any new people using this to take a few dry runs with it. I play very deep auction leagues and time is an element. The fact this is still totally customizable is the shizz. This is a great gift that every reader on this page should take advantage of.

  35. Lava says:
    (link)

    I found a pretty simple way to increase the number of teams. I haven’t played around with it too much to see whether the equations are all correct, but hopefully this will start people on the correct direction.

    This assumes you are using the new version of excel. The principles should stay the same in older versions, but it wont be the same step for step.

    Put in all the teams in your league under the user input tab, as you normally would. You’ll notice that any more teams you enter after 12 don’t show up on the ranks section of the War Room tab. To fix this portion of the sheet, simply highlight the row with the last team (starting from the team name to the left, and ending the highlight to the right on Team Rank). Then pull down on the box in order to copy these cells down for as many more teams after 12 you need. You may need to create space in between the batting and pitching per player areas.

    The second portion that needs to be fixed is the ability to add the extra teams to the drop down menus in the Players tab. To do this, highlight the top cell in the Owner column (to the right of Miguel Cabrera) and go to the Data tab in Excel. Under Data Tools find the Data Validation option, and click Data Validation under the dropdown. Under the settings tab you should see Source, and it should say =$AY$1:$AY$12 Increase the 12 to however many teams you have, and, provided that you entered the team name into the user input tab, they should appear in the dropdown menu.

    Hope this is helpful to everyone! This is certainly one of my favorite tools, and I appreciate the work that was put into it on all counts.

    • Fatwater Fewl says:
      (link)

      @Lava, For those of us using Open Office, or Libre Office, follow Lava’s instructions for the War Room tab. But to add extra teams to the drop down menus in the Players tab, select and highlight all the cells in the Owners column (starting to the right of Miguel Cabrera and ending at Gerado Parra), and go the Data menu in Open Office, find the Validity… option, click it and in the Source box on the Criteria tab it should say $AY$1:$AY$12. Change the 12 to the number of teams you need.

      Don’t forget to do the same thing with the Owners column for the pitchers (highlight all cells from Hallady to Garcia)!

      • theguarantee says:
        (link)

        @Fatwater Fewl,

        Thanks for this!

        Is there an easy way to get it on Open Office to cross off the outfielders names? If not, it really isn’t a big deal, but it would make things a bit neater which never hurts after about 7 hours of a fantasy draft.

        • theguarantee says:
          (link)

          @theguarantee,

          Actually , the more I’ve played around with this more importantly would be a way to get the extra four teams into the “projected team rankings” section. You can see their totals below so it’s not exactly necessary, but would be nice…

          • Fatwater Fewl says:
            (link)

            @theguarantee, Sorry, I haven’t been able to figure an answer to either of those. Maybe they’re fixed in the new version that JD Hassett sent to Grey?

    • roadbeef says:
      (link)

      @Lava,

      Thanks man, I would have never figured this out and the draft is just a few days away

  36. Dingbat says:
    (link)

    I think I know the answer to this from playing around in previous years, but there’s no simple way to add stat categories, is there? My league is 7×7, with H, OPS, K/BB, and QS added.

    • JD Hassett

      JD Hassett says:
      (link)

      @Dingbat,

      I did not design the spreadsheet. I am strictly a user. But I think it would be easy to add the columns in the players tab but you would have to re-do the war room tab pretty extensively.

      • dingbat says:
        (link)

        @JD Hassett, Yeah, that’s pretty much what I ended up doing.

  37. BostonEagle5 says:
    (link)

    Thanks again for this. Used it exclusively last year, worked like a charm!

  38. The Talented Mr. Dope Man says:
    (link)

    This is awesome… Thanks so much!

  39. Dann says:
    (link)

    So I was able to change the league number to 15 teams, but when I started inputting the keepers, only the teams in slots 1-12 were able to register the player. Team 13, 14, and 15 produced an error message of “The value you entered in not from the required list”. How do I remedy this?

    Cool stuff, by the way.

    Thanks

    • dingbat says:
      (link)

      @Dann, See Lava’s post above.

  40. dingbat says:
    (link)

    First off, this is awesome, and thanks so much for putting it together.

    Secondly, if anyone is trying to link the players in the War Room spreadsheet to other spreadsheets (to add stats or modify projections, for example), there are a few name typos in the spreadsheet:

    1. Rafael Furcal and Rafael Betancourt are spelled “Raphael”
    2. Corey Hart is spelled “Corey”
    3. Jayson Werth is spelled “Jason”
    4. Shin-Soo Choo is spelled “Shin-Shoo”
    5. Jon Jay is spelled “John”
    6. Salvador Perez is spelled “Salavador”
    7. Jordan Zimmermann is spelled “Zimmerman”
    8. Mat Latos is spelled “Matt”
    9. Not a typo, but Michael Morse may be called “Mike Morse” in other spreadsheets.

    There may be more, but those are the main ones I found. Remember that if you change any names in the spreadsheet, you have to change the names in both the “Players” sheet and the “Dashboard” sheet for the links to work properly.

    • The Talented Mr. Dope Man says:
      (link)

      @dingbat, thanks for that man.

    • JD Hassett

      JD Hassett says:
      (link)

      @dingbat,
      Thanks – I corrected the spelling will send to Grey

  41. Have been waiting for this file for a couple of weeks…love this tool…one question….last year you guys posted personal goals for the 5X5 categories (HR,SB, etc)….you guys gonna post personal goals again this year or are the numbers already in the file the numbers you recommend?

  42. The Talented Mr. Dope Man says:
    (link)

    If anyone puts together a spreadsheet, that includes the “player” listing from the war room, but expands it for additional players (using another sites projections or whatever). Please share.

    In my deep AL / NL only leagues, there are a lot of players that aren’t included on this list.

    Greatly appreciated.

    DOPPPEEEEEEEEEE

  43. I need a refresher. Last year when I tried this for the first time..I couldn’t see all the tabs at the bottom of the page. In fact, I didn’t know they were there until later on. I’ve downloaded the snake draft….but I don’t see a dashboard at all or a list of players by position. Can somebody remind me how to get to those pages..thanks

    • JD Hassett

      JD Hassett says:
      (link)

      @Tom Ryan,
      I would make sure you did not download a read only copy. If you do not have the tabs at the bottom I would follow the steps under the 2nd comment and reload the spreadsheet

      • @JD Hassett, It’s something with my Excel on my desktop that won’t allow me to see the tabs….because I can see them fine on my laptop…I’m going to keep fooling with it to see if I can figure it out…any suggestions would be appreciated.

  44. AStue says:
    (link)

    Im not sure what the difference is between the two spreadsheets? I have them both (and both work amazingly), but I am not seeing a difference? Let me know what I’m missing here please

  45. Where do you find the dashboard….

  46. trick dad says:
    (link)

    what list feeds the “owner” drop down in the players tab?

    its only showing the first 12 teams as options.

    • JD Hassett

      JD Hassett says:
      (link)

      @trick dad,
      The team names are on the user input tab. If you look at comment # 35 Lava explains how to add more than 12 teams. I did update the spreadsheet but I just sent it to Grey.

      • trick dad says:
        (link)

        @JD Hassett, sorry i missed that comment, thanks!!!

      • Fatwater Fewl says:
        (link)

        @JD Hassett, do you know if the revised spreadsheet you sent to Grey is available for download yet?

  47. Double A Ron says:
    (link)

    This is even greater than Daisuke’s gyroball. And it actually exists.
    Seriously though, thanks

  48. John says:
    (link)

    Wow… awesome work. One question, my league is a 6×6 roto we use QSs and OPS as additional categories. Anyway for me to add those into the equation?

    If not no worries. Thanks again.

  49. Matt Damon says:
    (link)

    THANK YOU FOR POSTING THIS!! Used this last year, won my roto league by 12 points. No joke, baby. MDDL (Matt Damon Don’t Lie).

  50. Tony002 says:
    (link)

    This excel has a lot of work done for you. I use a modified version of last years, updated for 2012, and added stat categories. Can’t wait for the draft!

  51. Sixth Gear says:
    (link)

    Thanks a lot for all the great work and the effort required.

    Was just briefly looking at the war room and noticed that Prince Fielder’s projected stats are not the same as Grey’s projections in the top 10.

    Have not looked at one other player yet. The same stats are being used, right?

  52. ML610 says:
    (link)

    I don’t think it messes up any other parts of the spreadsheet (though I haven’t delved too deeply), but the ERA calc in column AH of the player tab looks to be incorrectly calculating total earned runs allowed by the pitcher. Shouldn’t be ERA times IP (**need to divide by 9)

  53. Murner says:
    (link)

    Is there any way to expand the rosters to more than 23? I don’t know anything about coding or Excel gadgetry, so I’m not going to assume that this is easily done, but it would be great. Maybe have the option to go up to 40 players (since you’re kind of buddying up on this with Fangraphs and Ottoneu goes up to 40)?

    Just a thought from a dude who doesn’t own any rosters smaller than 25.

    • JD Hassett

      JD Hassett says:
      (link)

      @Murner,
      Go to the User Input tab to change the number of batters per team and the numbers of pitchers. If you go above 16 pitchers or 16 hitters you will need to insert a few rows on the war room tab on line 25 to list more Batters and Pitchers on your selected team.

  54. Hi Guys, i work in IT so I am always looking to tweak the spreadsheets so I offer this up to anyone who wants to use this for their War Room spreadsheets.

    I had to split the Hitters and Pitchers to make it possible to reference with as little vba code as possible.

    This version I am making available offers a few adjustments
    1) A “Teams” sheet that is dynamically pulling drafted players to help keep track of who has drafted what.

    2) The dashboard is completely dynamic so if you like to modify rankings it will automatically adjust the position rankings.

    3) From using this in the past, you want to be on one sheet as much as possible so I made the dashboard the centerpoint and added the ability to draft directly from this sheet. You will notice a Player to Draft section which shows the currently selected player and below that you need to choose a team to draft that player to. From that point you can select the Draft button or a shortcut of “Ctrl + Q”. If a mistake was made you can clear the highlighted player or shortcut with “Ctrl + E”.

    4) The dashboard shows rank as well as all other stats for selected player and top 5 hitters and pitchers available.

    I have modified my sheet since my leagues only use 10 teams and use OPS instead of HR, but its easy to adjust that information.

    Let me know if you find a bug or if you have any questions.

    http://www.mediafire.com/?bj8cfw6s5s38x82

    • Nate says:
      (link)

      @wallywojo, Thanks man this is an awesome modification to an already awesome resource. Is there an easier way to change OPS to HR in your spreadsheet, other than manually entering all that information?

      I wouldn’t want to screw up any of the formulas or anything, but my league uses HR instead so it would be great to switch over to that.

      Thanks!

      • @Nate, If you really want HR i’ll go through the top 300 and switch it to that if are interested. Just let me know.

          • Nate says:
            (link)

            @wallywojo, Thanks! that’s fantastic I really appreciate that.

            • @Nate, please see updated link below. BadaBing pointed out a defect

              • Nate says:
                (link)

                @wallywojo, Thanks for the update(s)!

          • Buge Hoobs says:
            (link)

            @wallywojo,

            Took a quick peek and liked, but now the link doesn’t work?

              • Buge Hoobs says:
                (link)

                @wallywojo,
                Any reason why Sean Rodriquez is slotted as everyone else’s 2B? How do I fix it without compromising the integrity of the sheet?

                  • eightysixants says:
                    (link)

                    @wallywojo, Great modification! Especially with the Team tab added in. I did notice that names aren’t being crossed off in the Dashboard when drafted, even though the Top Hitter/Pitcher box gets updated. Also, is there any way to add stat categories? Doubles, triples, walks, strikeouts? Thanks.

                    • @eightysixants,
                      That should be easy to add, but one thing you have to be aware (I learned after making additions the hard way) of when making modifications on the war room sheet is hidden columns. As long as you are mindful of that it will not be an issue.

    • Bada Bing says:
      (link)

      @wallywojo, Just want to point out that by removing IP and AB from your formulas, you are going to get inaccurate values for team BA, ERA, and WHIP. A 2.5 ERA from a reliever who throws 60 innings carries the same weight as a starter who throws 200 in your spreadsheet.

        • Clyde says:
          (link)

          @wallywojo,

          First, your format modifications are great. I had to customize to make it work for 12 owners, but I think it makes the tool much more user friendly.

          Second, how many stat changes did you make from the original spreadsheet? League and Santos shot to the top of the closer rankings after I built in a “player rater” formula and re-sorted the players. And they have much more optimistic numbers than the original spreadsheet.

          • @Clyde, thanks for pointing that out. I’ve fixed that part for next time.

            • Tom says:
              (link)

              @wallywojo, Have you done a new one with the ranking adjusted for Braun’s appeal being granted? I know Grey moved him to number 1 now. Any plans to update? I tried doing it myself but I cant figure out how to get the rankings to reformulate once I corrected his numbers for the year…any help? Thanks!

                • Jamo says:
                  (link)

                  @wallywojo, This is amazing. Thank you! Although the buttons Draft on Clear on the dashboard don’t work. Is this an issue with running macros?

                  • @Jamo, thanks. If they are not working it might be that security is enabled to ensure macros do not run. Here is how to change that:
                    http://office.microsoft.com/en-us/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx

                    The better way to use the macros is through their keyboard shortcuts of Ctrl-Q to draft and Ctrl-E to clear. I used this for my draft this sunday and could easily keep up with all the picks as well as preparing for my upcoming pick.

                    • Jamo says:
                      (link)

                      @wallywojo, I enabled macros but get the following error when I use the Ctl-Q command:

                      Compile Error: expected function or variable. In the code below the [Salary] text is highlighted.

                      Any help would be much appreciated. Thanks!

                      ‘ check if hitter first, so you know which sheet to assign value to
                      If [h_rank] “” Then
                      l = Application.WorksheetFunction.Match([activecell_contents], Worksheets(“Hitters”).Range(“C1:C170″), 0)
                      ‘MsgBox [activecell_contents]

                      Worksheets(“Hitters”).Range(“Q” & l).Value = [draftee]
                      Worksheets(“Hitters”).Range(“R” & l).Value = [Salary]

                    • Steve-O says:
                      (link)

                      @wallywojo,

                      My league uses a 6 x 6 format with HR, OBP, AVG, R, SB, RBI and on the pitching side: ERA, WHIP, SV, K, WINS, HOLDS.

                      Is it possible to add these easily? Any direction you can give me would be much appreciated!

                    • @Steve-O, sure, you will need to add the category on the player data sheets (Hitters, Pitchers), probably add those categories to the information box below player to draft on the dashboard, and the war room sheet. The War Room Sheet will be the most complicated as there are multiple places where additions need to be made and you will have to make a lot of formatting changes to make it look nice with the borders and coloring. The one thing i pointed out above for a similar question is to be mindful of hidden columns. When you start to make these mods just save as a copy the original in the event your warroom is not calculating things correctly you can just go back and correct the top most entries in each box and fill down. I’ve found that it really is a clean sheet meant for easy modification.

                    • Tom says:
                      (link)

                      @wallywojo, Im trying to make this work with 12 teams. Ive added 2 more teams on the input page but I still cant add players to 11 or 12 and it doesnt show 12 teams on the team page. What am I doing wrong? Again, your help is greatly appreciated!!!

                • Buge Hoobs says:
                  (link)

                  @wallywojo,

                  Any quick easy way to make it work for an 11 team league? I went to the User Tab and added another team, but that doesn’t seem to follow through to the other tabs’ drop boxes for team owner.

                  Also, many of the boxes on your dashboard have green triangles in them. (Inconsistency Error messages if I am remembering correctly.) If I “ignore formula”, will it ruin the integrity of the worksheet?

                  Really love your adjustments and want to try using for my daft this weekend!

                    • Tom says:
                      (link)

                      @wallywojo, I am trying to make this work with my 12 team auction league. I have added a 12th team but in the drop down on the player pages it only comes up with 10 teams. Would you be so kind to let me know what I need to change to get that part to work? THanks!

  55. Misses His Old Glasses says:
    (link)

    Great spreadsheet, appreciate all the hard work that went into it. Will definitely be a useful tool.

    Quick question though, I’m trying to upload this to google docs so my partner and I can use this for an in-person draft. I seem to keep getting a server error when I try this. Anyone else give this a shot and/or have any tips for success?

  56. Jason says:
    (link)

    Hey Guys – the VLOOKUP to correctly add hitter salaries (auction sheet) and pull in projected savings/expenditures doesnt work properly!!!!

  57. Jerry G says:
    (link)

    I have created a better version of this sheet. IF anyone is interested let me know.

      • Fatwater Fewl says:
        (link)

        @Jerry G, I’m interested, will email.

    • atrain says:
      (link)

      @Jerry G,
      definetly interested, please send me a copy.

    • barrtrek says:
      (link)

      @Jerry G,
      Please send it my way.

  58. Double A Ron says:
    (link)

    I am still unable to get Outfield, 2B, and C to cross off when selected. I’ve tried copying from a working column and pasting the format, but that doesn’t seem to work. Any suggestions?

    • Double A Ron says:
      (link)

      Actually I think I have it fixed, it’s due to the extra columns next to C, 2B, and OF. Why do some positions need an extra column of input to cross out and others (1B, 3B, SS) not need that extra column?

  59. Jays Fan says:
    (link)

    Having a hard time getting a value for projected ranks in WHIP and ERA any suggestions?

  60. Jays Fan says:
    (link)

    never mind I figured it out, I hadn’t assigned pitchers to each team yet.

  61. Nate Curtis says:
    (link)

    How do I add reserve slots that can be either pitchers or batters? My league has a 3 person bench that must be filled at the draft and counts towards our cap.

    • JD Hassett

      JD Hassett says:
      (link)

      @Nate Curtis,
      It is not easy to add columns in the War Room tab without breaking some on the other formula’s. One “work around” would be to add 3 batters and 3 pitchers to the # of batters per team and the # of pitchers per team on the User Tab. Then put the amount you can spend on the team budget line.

  62. Tmac says:
    (link)

    Is there an AL only version of this? Know I used it in 2010 (had a year off last year due to family vacation – yeah, bad planning on my part) and it was AL only.

  63. Mike says:
    (link)

    This is great – loved this tool for last couple of years.

    But it would be even better as a Google Docs spreadsheet so I don’t have to keep transferring it between computers… ;)

  64. Wake Up says:
    (link)

    Headsup… it looks like Rasmus #’s are off

  65. Clodbuster says:
    (link)

    Hey, thanks for the sweet tool! How do we change it for 10 team leagues please? I looked through and saw it mentioned but never resolved. Thanks!

  66. barrtrek says:
    (link)

    Hey there… love the draft spreadsheet but in the war room tab, it isn’t adding up the bid or proj totals for the batters. I’ve looked at it but haven’t been able to figure out the problem.

  67. MacDaddy says:
    (link)

    Dashboard OF do not match up with owner. Is it VLOOKUP?

  68. Patrick R says:
    (link)

    Not a bug but could be helpful to some. If you are looking to link this with say other projections like Yahoo, here are two formulas to help with the different nomenclature for the names.

    First I created a column on “Players” tab off to the side showing last name and team with this starting with Braun. =LEFT(B3,FIND(“,”,B3,1)-1)&” “&E3

    For yahoo nomenclature created this formula:
    =TRIM(MID(B2,FIND(” “,B2,1),FIND(” “,MID(B2,FIND(” “,B2,1)+1,99))))&” “&TRIM(MID(B2,FIND(“(“,B2,1)+1,3))

    B2 is where I have the players name as it is copied directly from Yahoo ie: Ryan Braun (Mil – OF).
    So both should equal Braun Mil allowing you to do lookups and other things easily.

  69. Patrick R says:
    (link)

    Looking at this more closely, when the A’s move back to Philly? You used
    PHA and PHI.

  70. Patrick R says:
    (link)

    Very Minor but Napoli, Mike is on Rangers not LAA anymore.

  71. jason P says:
    (link)

    there seems to be an error in the code; when you populate players to team owners under the player’s tab; the corresponding OF’s in the Dashboard scratches out an additional OF that is still on the board. At 1st glance, I noticed the formula in the entire AB column was one cell off for each…example: AB2 showed =VLOOKUP($Z3, …) instead of $Z2. I fixed the whole column, but when I assign Jose Bautista to an owner, the player below him gets scratched out and assigned to no team owner…

    • Patrick R says:
      (link)

      @jason P, simple fix. It looks like Adam Either was moved or added as there are Ref errors in column AC and this caused the conditional formatting error. To fix highlight Column Z and bring up “Manage Rules” under “Conditional Formatting” (2007+ & I forgot how to do this in 2003 or earlier). Delete the rule for cell z38 and change the range to “=$Z$2:$Z$460″ instead of “=$Z$39:$Z$460,$Z$2:$Z$37″ This should fix it.

      • jay says:
        (link)

        @Patrick R, that did the trick! Braun doesn’t get greyed out/scratched out, but I think I can make due with that minor discrepancy lol

      • Mac D says:
        (link)

        @Patrick R, I tried it but did not have any luck

  72. Patrick R says:
    (link)

    I updated the War Room section “Your Selected Players” to now work as a drop down so you can view the different teams in your league. It doesn’t use columns labeled “A” “B” “C” in the players tab so if anything else uses those columns in a spreadsheet wouldn’t be affected. If you want it reply below

    • Big Mike says:
      (link)

      @Patrick R, I do ineed want a copy of the updated War Room. How to get it?

    • igmacgregor says:
      (link)

      @Patrick R, I’ll take the updated war room, if it’s still available.

      Thanks,

      Ian

    • Mac D says:
      (link)

      @Patrick R, If you are still offering an updated War Room I am interested. I have not been able to fix stuff as easily as it sounds.
      Thank you
      mcguirel@usd332.com

    • Jeff says:
      (link)

      @Patrick R, thanks in advance for the update.

  73. jay says:
    (link)

    @Patrick R: I’d love a copy of the updated war room.

  74. jay says:
    (link)

    I’d like to make a few suggestions for changes to the spreadsheet. After running through a mock draft with a 2min timer, I think these changes…if possible…would help the user navigate the sheets/players faster.

    1. Can the players in the Players Tab be sorted via position? It makes it easier & faster to find them when assigning them to teams.

    2. When choosing players to assign to teams in the drop-down, can the window for the dropdown be re-sized to accommodate however many teams you have in your league. Saves time having to scroll.

    3. In the user’s tab, can we change where “Your team” can be located? I’d like to be able to place my team in the position I’m drafting out of. It also makes it faster when assigning players to teams via the drop-down menu.

    Regardless of what you can or cannot do, thanks for all you guys provide! Your tools are best on the web, bar-none!

    • JD Hassett

      JD Hassett says:
      (link)

      @jay,
      I use the CTL F button to search for players. It will pop up a search box.

  75. Tom says:
    (link)

    Question on the auction sheet. My league is $260 rather than $280. It doesnt appear that when changing the team budget to $260 that the auction projected numbers go down to reflect the lack of $20 for each team. Can this be adjusted? If so, how?

    Awesome service. Loving the excel sheet!

  76. mike mesko says:
    (link)

    Come on, your stats don’t even have Jared Weaver on the right team…unless Angels traded him to the Dodgers and I didn’t here about it!

  77. DK says:
    (link)

    I have been studying and preparing for my draft and loving the War Room! I have been preparing for a 12 team 5×5 H2H league and just found out that it is actually a 10 team 5×5 H2H (apparently 2 decided not to return). How much adjustments in position rank will I have to make going from 12 team to a 10 team? My guess is the tiers stay pretty close to the same. I still plan on punting C. In 12 team planned on SP around 5th round is that still true in 10 team? I know how other teams draft helps to determine some of who is taken when. With 10 teams there should be plenty of waiver opportunities. I read the article that talked about what is needed to win in a 10 team league. I have those numbers plugged into my War Room.

    Because of keepers, only Miggy, A.Gonzalez, and Cano are available in the top 17 of the War Room player ranks. I have first pick this year so I am planning on taking Miggy, with Bautista being my keeper for the 2nd round. 3rd/4th round looking at Best OF (1st option), Best 2B (2nd option) or best SS (3rd option) avail. My thought is that I should be able to land Hamels, Bumgarner, Greinke? in round 5. Then SS in round 6 or so..

    Trying to think this through….

  78. Richard Kenno says:
    (link)

    I am trying to do the spreadsheet for 14 teams. I have added two extra lines and teams on the hitting and pitching category ranking matrix on the War Room worksheet and expanded the data retrieved, (e.g. m$73:m$84 to m$73:m$86) for the ten categories and 14 teams. However the dropdown or popup when selecting an owner for a given player on the Players worksheet only shows the first 12 teams. What do I need to do to show all 14 teams on the dropdown?

    Thanks.

  79. Richard Kenno says:
    (link)

    Please ignore my earlier comment 10 minutes ago. I just found Lava’s instructions and used them and they work fine. Thanks for the work and putting out a useful tool.

  80. Zachary Neugut says:
    (link)

    I havent read the comments so i dont know if someone asked, but i was wondering is there anyway to change the rankings based on the projected amount of win shares by the projected stats? Also, is there any way to change the money worth of each player based on the worth of those projected win shares over a replacement player? And lastly, does anyone know what the goal statistics should be in a ten person league?

    And thank you so much for making this, it’s awesome.

    • Tom says:
      (link)

      @Zachary Neugut, +1 Im interested too!

  81. stanley says:
    (link)

    Do you have an NL only excel doc?

  82. Trevor

    Derek says:
    (link)

    Would u mind updating War Room for the closers and the up-to-date Grey Rankings? Thank you, it is very much appreciated!

  83. Rob says:
    (link)

    Can we get an updated War room with all the bugs fixed? This is great, but I’m not excel savvy enough to perform the fixes on my own (I’ve tried… and sadly failed).

    My issues are that I can’t get the names to cross off the player lists consistently and I can’t get the bidding column for my hitters to populate correctly in the war room. Thanks!

  84. Marty Brennaman says:
    (link)

    Thank you guys for taking the time to put this together. I look forward to utilizing it in my upcoming drafts.

    For those wanting this, that, and the other thing: each league is unique, so you’re best off customizing it to fit your needs.

  85. Tom says:
    (link)

    Im trying to figure out how to fix the values. I thought they were going to be point shares but I have a 12 team essentially yahoo settings auction league and the values are way low. $40 for Braun rather than $45 for instance on the 160/100 plan.

    I readily admit that I suck at excel but is there a way to get those point shares values into the spreadsheet without manually altering each and every one?

    Thanks again for the war room. It is sweet!

  86. Mark says:
    (link)

    Guys,
    Fantastic sheet, the only thing I am struggling with is that on the dashboard when a player is drafted the team name appears beside the proper player but for OF’s only the next player down gets crossed out rather than the player selected. It only happens for OF’s, the rest of the columns work correctly. Anyone know how to fix? Email me at mdickie15@hotmail.com if you have the fix. Thanks.

    • Mark says:
      (link)

      Does anyone know where the setting is for the strikethroughs, I’m still getting the strikethroughs coming one column below the player they should be for OFs. Thanks.

  87. Big Nate says:
    (link)

    @Richard Kenno,

    On the “Players” tab, start in cell C3 next to Braun and find the Data Validation command in your toolbar. Once you are there, you have to set the source data to from =$AY$1:$AY$12 to =$AY$1:$AY$14.

    You’ll have to then copy that formulas all the way down the Owner column and then repeat the same process for pitchers.

    Hope this helps.

  88. Mike says:
    (link)

    I have a 13 team league, where can I change the formula to allow the 13th team to show up in the pull down menu under the “players tab”? Thanks

  89. Mike says:
    (link)

    ok never mind. I see the updated version. Unless you want to satisfy my curiousity?

  90. Pacho says:
    (link)

    Awesome job on the projections.

    Can you update the projections for Sean Marshall, given that he will be the new Reds closer (or is expected to share this duty).

    Thanks

  91. Zach says:
    (link)

    This inspired me to do a similar idea except for fantasy football. It’s a much more basic spreadsheet, but I like the gray cells on the dashboard below some of the columns. As hard as I tried I can’t get it to do what I want…and obviously you didn’t just change the color and add the strikeout effect, because in yours the cells have the same yellow color as those above. Could you possibly explain how you did this?

  92. Zach says:
    (link)

    And I’ve noticed in the spring when trying to add new players for fantasy baseball it keeps crossing out my writing. How do I turn this off without completely screwing up the auto-updating?

  93. Nick says:
    (link)

    Hey guys is there going to be another update with the 2013 projections? If so does anyone know when that will happen. Thank you for the spreadsheet. It looks amazing

    • Grey

      Grey says:
      (link)

      Yeah, will happen in the beginning of the year…

Comments are closed.