Share on FacebookTweet about this on TwitterShare on Google+

Here it is, the 2016 Fantasy Baseball War Room.  This was original author and innovator Lou Poulas’ introduction, “While Grey and Rudy do a great job of breaking down everything you need to know for 2016 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 2016 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 2016: Color Coded Tiers in the Dashboard Tab.

A quick look into the document: The pitching and hitting totals look like they are broken until each team has at least one hitter and one pitcher. I used this tool for my first draft about 5 years ago and I have been consistently winning leagues ever since. If you are someone that hates dealing with Excel, I feel for you. I was the same way but in all seriousness, War Room is very easy to use. I am almost certain that once you use War Room for one draft you will continue to use it year after year. Razzball is the best source for fantasy baseball information that I have ever used. The combination of humor and analysis is unmatched.  If you see anything that needs to be changed/updated, leave me a comment below, and I will fix it ASAP.

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

  1. The Players page lists players in order of Grey’s top 500 for 2016 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 2016 Fantasy Baseball War Room <– Snake Draft, newest Excel, optimal download

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

 
  1. Hot Rod

    JimmyBond says:
    (link)

    Awesome stuff. I have my own tweaked version that has more conditional formatting. I am happy to share it if there is interest, once I update with your tiers this weekend (I already grabed the 2016 data but I didn’t want to duplicate your efforts loading Grey’s new tiers for 2016 on the Dashboard page since I knew your version was coming out) As far as I know no one else in my leagues uses the Razz War Room so I think I am safe to share, for the benefit of the site :)

    for instance – I found that I use the players tab more than the dashboard in my draft so in mine the Players tab is customized with more info and more formatting. I.e. a player you pick in the PLAYERS tab gets highlighted green on that sheet, a player someone else picks gets highlighted red. so it is easy to see at a glance who is taken. I also made it sortable so that you can sort by rankings, and once JB puts out his pitcher rankings I’ll add it as a column (so you can sort pitchers by his rankings instead of Grey’s, etc).

    It was good when I got introduced to fantasy baseball, but it was GREAT when I discovered how I could meld a love of using spreadsheets all day every day for everything (from work projects to TV buying) into something to benefit my fantasy teams!

    • Boomer19 says:
      (link)

      I am interested!

      • Hot Rod

        JimmyBond says:
        (link)

        @Boomer19: okay! Let me tweak this tomorrow and Sunday, and I’ll figure out how to share my ‘modded’ version.

    • Nico says:
      (link)

      @JimmyBond: I’d definitely be up for checking it out!

    • JSB says:
      (link)

      @JimmyBond: I, too, would be interested!

    • Robby Rob says:
      (link)

      @JimmyBond:

      sounds awesome. I want to check this out when your done.

    • Hot Rod

      Jimmy Bond says:
      (link)

      @JimmyBond: glad for the interest. work’s done…guac beside me, beer in hand, and appropriately Don Henley’s ‘Boys of Summer’ playing on the radio. time to work on some baseball stats.

      • Count de Minetball says:
        (link)

        @Jimmy Bond: interested here too!

      • Stephen says:
        (link)

        This is great. Thanks. I have a simple tracker I use to see position by position requirements by team that I’ve tried to integrate so that when getting to the back end of an auction/draft, you know whether a certain position can be left until the end cause your opponents can’t bid or draft said position. I can send to you if you’d like?

        • Hot Rod

          Jimmy Bond says:
          (link)

          @Stephen: sure! Send it through if you like ([email protected]) and I can tinker around and add it. That’s an interesting idea.

          I was thinking today how if the sheet was saved in multiple view format you could have the players list, the dashboard, and the war room all in the same screen…might be a neat option too.

      • J_Ceol says:
        (link)

        @Jimmy Bond: All of these excel sheets are somehow missing Russell Martin completely from them… Can we get a double check on all positions because there are apparently missing players from these rankings. It is very misleading

        • Hot Rod

          JimmyBond says:
          (link)

          @J_Ceol: Martin is in the spreadsheet on the PLAYERS page but not on the Dashboard – that does need to be corrected.

          PLAYERS TAB: in both mine and official Razz excel sheets, Russell Martin is on the players sheet, row 156, corresponding with his location as 154th hitter overall in Grey Hitter rank.

          you are correct he is missing from the dashboard – the dashboard is manually entered so there must have been some human error there. I just copied mine from the official Razz one without proofing it.

          The PLAYERS tab data is auto-generated from the razz website, as long as you allow data connections to be enabled, which is why it is more accurate.

          based on his position in the overall ratings Martin would slot in between Mesoraco and Hundley on the dashboard

          for some reason on my sheet (not on Razz official one) Giles ended up in the hitters column. what should have been hardcoded as formula in IMPORT tab was hardcoded as H. so mistakes happen.

          • Hot Rod

            JimmyBond says:
            (link)

            @JimmyBond: and my version wasn’t pulling Ken Giles’ FantasyPros ranking because they chose to call him ‘Kenneth’ in their database. don’t they know only his mom calls him that

          • Hot Rod

            JimmyBond says:
            (link)

            @JimmyBond: travis d’arnaud wasn’t pulling its fantasypros rank because the apostrophe used in his name was a different style between the Razz table and the Fantasypros table. Excel can be stupid.

        • Nico says:
          (link)

          @J_Ceol: Oversight on my part. Will fix and re-upload.

          • J_Ceol says:
            (link)

            @Nico: Much appreciated the both of you, I was just really pointing it out as to make sure everyone is listed in each area. I like to look at tiers more than anything and having that accurate is kinda been what I’ve been trying to do personally. Just wanted to keep eyes out for any other errors.

            I also caught that Ken Giles hahaha was like wonder if he really can hit!? lol

  2. Boomer19 says:
    (link)

    Thank you! I know how much work theses are to put together!

    • Nico says:
      (link)

      @Boomer19: Not a problem!

  3. Pine Tar Incident says:
    (link)

    Incredible. Look forward to this every year and was hoping it would be up today so I could spend some time this weekend on it! Thank you!

    • Nico says:
      (link)

      @Pine Tar Incident: Sure thing! I look forward to it every year as well.

  4. Cram It says:
    (link)

    I don’t get it. haha.

    How do you populate the player you chose/cost on the War Room tab? Typing it in doesn’t do anything.

    • Nico says:
      (link)

      @Cram It: Did you assign players to teams in the players tab?

      • Cram It says:
        (link)

        @Nico: Ahhhh, got it. Thanks brah!

        • Nico says:
          (link)

          @Cram It: Ha no prob. You really had me worried there for a second!

          • Cram It says:
            (link)

            @Nico: Sorry! It’s just me…I’m an Excel novice.

  5. Pager24 says:
    (link)

    Hey Nico,
    look forward to this every year! great work! I was wondering how you calculate your personal goals? Was wanting to update them to reflect a 10 team league

    Thanks!

    • Nico says:
      (link)

      @Pager24: If you have a history of your league, I’d go back and average those stats out. If not, a little googling might be in order. I’ll see if I can be more helpful with a little searching.

  6. Dave F says:
    (link)

    Nico:

    This looks awesome. Are we able to customize this to a 10 team league with unique stat categories?

    • Nico says:
      (link)

      @Dave F: I would say the customization to unique stat categories could get a little complicated, but have at it if you can figure it out! For 10 teams, just make sure to set it up that way in the user input tab.

  7. Hal Incandenza says:
    (link)

    I’d like to keep an eye out for this. If these could be submitted and deemed approved by Razzball, maybe some user-tweaked variations could be made available via the site downloads.

    Thanks for the current version, Nico!

    • Hal Incandenza says:
      (link)

      @Hal Incandenza: I intended that to be a reply to Jimmy Bond’s posting.

  8. Robby Rob says:
    (link)

    Nico, you da man homie!

    • Nico says:
      (link)

      @Robby Rob: glad you like it!

  9. Bwyce Hawpo says:
    (link)

    Any easy solution to change AVG to OBP?

    • Nico says:
      (link)

      @Bwyce Hawpo: The only way I can think of off the top of my head is putting in a formula in the players tab to change average to OBP, but I think it might get more complicated than that. I’d have to take some time to see how that would work.

      • Robert says:
        (link)

        @Nico: Maybe just add in another blank column that is formatted for the user to add in their own stat category if possible instead of a formula to change stats. I’m in a 7×7 that counts Ks and BBs for hitters and would love the flexibility to add my own projections in on top of your 5×5 ranks. I’m still playing around with the spreadsheet as I’m excel illiterate, but this tool will be invaluable in real time and I can’t thank you enough. Keep up the amazing work

  10. Smokey

    Smokey says:
    (link)

    Wurd, Nico, wurd

    • Nico says:
      (link)

      @Smokey: yo boiii

  11. Count de Monetball says:
    (link)

    U da man!

  12. peacecoast says:
    (link)

    dudes,

    that excel file is a fucking work of art.

    • Nico says:
      (link)

      @peacecoast: glad you like it!

  13. J_Ceol says:
    (link)

    Where is Russell Martin at? lololol

  14. tyler daniels says:
    (link)

    so starting a dynasty league…in a snake draft when do players like seager and buxton make sense to start drafting?

    • Nico says:
      (link)

      @tyler daniels: Sorry to say that I’m the wrong guy for that question! Don’t want to lead you astray! Ask the Fantasy Master Lethario aka Grey!

  15. Running Frog says:
    (link)

    So I had a chance to test this out today, in my first draft of the season, an ESPN 12-teamer with the usual complement of *cough* fantasy experts *cough*. Drew pick 1 for the first time in about 40 drafts. I have to say, the war room was AWESOME… until around the 16th round. It reached a point for me where the ESPN peeps were picking too fast for me to search for the player (since they were often picking guys who weren’t even in the top 300), flag the appropriate team, and switch back to the browser. I wound up in a position where I used the first 60 seconds of my 90 second clock just trying to catch up on data entry every round.

    The ESPN projections had me in 10th place which I took as a fantastic sign. I went nearly 100% off Grey’s rankings, with a couple minor adjustments for positions, and one stupid auto-pick when I lost internet for 3 minutes.

    Results:

    1 – Trout
    24- Betts
    25 – Marte
    48 – Upton (yes, four outfielders in a row)
    49 – JoFer
    72 – Polanco (yes, 5 OF in 6 rounds…)
    73 – Thor
    96 – Belt
    97 – Odor
    120 – Liriano
    121 – Familia
    144 – Raisel Iglesias
    145 – Pineda
    168 – Castro
    169 – Capps (ESPN projects him at 32 saves in 30 IP… that would be something to see)
    192 – Schoop (99 picks after Grey’s ranking)
    193 – Taijuan Walker
    216 – Castellanos (by this point I couldn’t keep up with the War Room entry…)
    217 – Adams
    240 – David Hernandez
    241 – V Mart (stupid lost internet autopick…)
    264 – Hammel
    265 – Will Smith
    288 – Semien
    289 – catcher always last… Wellington Castillo

    I have a feeling Grey predicts I will stomp this league, no matter what the ESPN projections say. I wish I could tell you what the War Room projections are… but I would have to pull the draft recap and redo the entries for the last 9 rounds. Maybe tomorrow…

    Thanks for the AWESOME spreadsheet. Seriously. It was fantastic. There’s just no way to keep up if the ESPN sheeple start picking every 8 seconds…

    • Nico says:
      (link)

      @Running Frog: I’m happy to hear this feedback!

    • Hot Rod

      Jimmy Bond says:
      (link)

      @Running Frog:
      number one rule for speed – (I almost listed this in my spreadsheet). CTRL-F ‘find’ is your friend. But you have to set it up properly – after you press CTRL-F, click “options” and in bottom left dropdown of “LOOK IN:” choose ‘VALUES” (it will be default to formulas, usually).

      Now you can close the search, and anytime you press CTRL-F to search, just start to type the player name then hit enter – e.g. SPRING for george springer takes you right to him, and highlights his name in the cell, so then close the search dialog and you can can quickly enter that someone has drafted him and get back to your own research. No need to spend time scanning the spreadsheet by eye to find his name.

      I will add this to my V2 spreadsheet notes, when I have JB’s rankings

      • Running Frog says:
        (link)

        @Jimmy Bond: I was actually doing that starting with round 5 or so (first four rounds scanning by eye was frankly faster since everyone was picking guys I knew exactly where they were on the sheet.

        My issue wound up being with similar names, typing Cast and not recognizing there would be five players in the sheet who match that… that sort of thing. If my opponents took even 15 seconds a piece I think I would be fine. But heaven help you if three guys in the draft go autopick on you. Yes, it’s great that they are picking guys you don’t want (yet), but there’s no chance you get them entered on the sheet fast enough.

        One suggestion I would make, or it may be a modification I make on my own… is to add conditional formatting to the rows so that if there is a data entry in the “owner” column, the rest of the section for that player goes 70% grey. I would make it much easier to quickly eyeball twenty rows at a time and see who the highest two or three remaining names are. I’ve used similar formatting on draft sheets in the past and it makes a big difference.

        All in all, though, it’s a great spreadsheet.

        • Hot Rod

          Jimmy Bond says:
          (link)

          @Running Frog: as opposed to doing the red/green you mean? yeah I looked at doing that. could still do player names red/green but the stats in dark grey. easily tweakable if you know your way around the conditional formatting menu, I made mine extend the full width/height for those rows so you could just make a new one that is grey for them and remove them from the red/green rules.

  16. BigRedLatrine says:
    (link)

    Aw yea. Nico doing yeoman’s work. Thanks buddy!

    • Nico says:
      (link)

      @tyler daniels: Sorry to say that I’m the wrong guy for that question! Don’t want to lead you astray! Ask the Fantasy Master Lethario aka Grey!

      • The Great Knoche says:
        (link)

        @Nico: Rookie Move Bro!

        • The Great Knoche says:
          (link)

          @The Great Knoche: And now that I read my razz, I put it on the wrong comment….sheesh.

    • Nico says:
      (link)

      @BigRedLatrine: No idea how that last comment got under here. I’m just doing my part, my friend! Glad to help.

  17. I got $100 for groceries, $1400 for liquor, and $6,000 for you to bail a couple of shit puppets out of jail says:
    (link)

    2 things on war room.
    first it’s not listed in “tools”. i can still find it by going to the post for war room so this isn’t big concern.
    2nd forsythe (Grey
    s 28th 2B in top 500) isn’t listed, yet guys after him are (travis, harrison and the rest)

    this is for the non-excel War Room (although i suppose forsythe is missing from the excel one too if he’s missing from the website one)

    • Grey

      Grey says:
      (link)

      Thanks for the heads up! I’ll add it back into Tools… Logan is in the top 500, that’s really odd, let me look into it

    • Grey

      Grey says:
      (link)

      Forsythe is listed, I added War Room under Tools too

      • I got $100 for groceries, $1400 for liquor, and $6,000 for you to bail a couple of shit puppets out of jail says:
        (link)

        @Grey: thanks.

  18. lake says:
    (link)

    2 questions .
    I can’t find familia. cant find him
    If i go ahead and save this excel with dynasty owners of certain players already. Will i be able to update forecast stats. Or will i need to wait to download before draft and put in correct owners with the latest updated stats.

    • Hot Rod

      Jimmy Bond says:
      (link)

      @lake: @lake: whether on my version or the official one above, Familia is there. He is row 32 in the pitcher side in the official auction sheet (link at top), row 31 in mine.

  19. lake says:
    (link)

    I am using the auction price one. I am NL only, and have deleted the AL teams. Familia is on the dashboard, but not on the players tab.
    Also, is there an easy delete of AL players on dashboard

    • Hot Rod

      Jimmy Bond says:
      (link)

      @lake: whether on my version or the official one above, Familia is there. He is row 32 in the pitcher side in the official auction sheet (link at top), row 31 in mine.

      • Dude Just Wants His Rug Back says:
        (link)

        @Jimmy Bond: this isn’t in reference to Familia just the easiest way for you to see it…

        You have Ken Giles listed on the Hitter Side…Line 63. Just trying to help. I do like the look of your…. sheet? Spread? Which do I say? They both sound pretty bad….

        • Hot Rod

          Jimmy Bond says:
          (link)

          @Dude Just Wants His Rug Back: yes thanks I caught that and mentioned in earlier comment, not sure how Giles got hard coded as a hitter instead of being formula based but I will correct for Version 2. Thanks.

  20. lake says:
    (link)

    I’ve figured it out. If I deselect the AL teams in the hitter’s side, the pitcher across from that hitter is erased regardless if he is NL or AL. I’m needing to make the list NL only.

    Also , if i save this excel will i be able to update it with the updated forecasted stats

    • Hot Rod

      JimmyBond says:
      (link)

      @lake: the easiest way to do this would be to have two PLAYERS tabs, one for hitting and one for pitching, but then the formulas for crossing out players on dashboard would need to be corrected for pitching. But then you could filter and when the rows were removed (filtered) they would not hide the hitter/pitcher in same row arbitrarily.

      • lake says:
        (link)

        @JimmyBond: I’ve copied and pasted another players list tab. So now I have a hitters and pitchers. How can I format so that both will mark out names on dashboard and add players and cost on war room? I know. I’m being obnoxious. Just need it. NL only. Ha

        • Hot Rod

          Jimmy Bond says:
          (link)

          @lake: it is a lot of formula changing, probably an IF formula tied to two VLOOKUPs, one for each player sheet. If you want to give it a go and are comfortable in excel just unhide the columns beside the player lists in the dashboard, and tweak those formulas.

          Another solution I thought of is that you could copy-paste the pitchers BELOW the hitters. lots of scrolling, but at least that way your lookups for the dashboard to cross out players would all be tied to the same sheet. Only thing is I don’t know the range that the Dashboard looks up (like how many rows deep), I try to make my formulas encompass more than I need to allow ‘expansion’ room but those ones were original so I’d have to check

          I will tinker around this week and see if I can come up with a better way, or an NL/AL only version. I am assuming you don’t have a draft before the weekend?

          • lake says:
            (link)

            No my NL auction draft is on March 18th. It would be much obliged. Thanks for any help.

            • Hot Rod

              Jimmy Bond says:
              (link)

              @lake: I’ll have something before then for sure. might try and get a V2 fixed up by weekend.

            • Hot Rod

              Jimmy Bond says:
              (link)

              @lake: I also looked into it and there is no way to prevent excel from hiding the whole row if you use the filter feature. So implementing an AL/NL only might be easiest if we stack hitters and pitchers instead of having them side by side. but could still do a dual-pane view to show both at once…

              • Syllogism says:
                (link)

                @Jimmy Bond: @Jimmy Bond: @Jimmy Bond:

                Try ….

                1) Make separate “Players” tab – name it Player-Pitchers
                2) Rename “Players” tab to “Player-Hitters”
                3) In Player-Hitters – delete all Pitcher entries (but not the column headers)
                4) In Player-Hitters – delete the rows of all AL hitters
                5) In Player-Hitters – select the Hitter data and “sort” to remove the blank lines
                6) In the Player-Pitchers tab – do the same … delete all hitter data, delete the rows for all AL pitchers, select the pitcher data and sort to remove the blank rows
                7) Select and copy the pitcher data from the Player-Pitcher tab
                8) Paste the data into the (empty) pitcher-side of of the Player-Hitter tab
                9) Delete the Player-Pitchers tab**
                10) Rename Player-Hitters back to Player

                Definitely a few extra steps (like the tab-name changes) – but it helps me make sure to keep my tabs and data straight.

                “Brute force” method, really – not as elegant as updating the formulas, but in this instance, it seems to be much easier than trying to rewrite all the formulas.

                ** You might just want to hide the Player-Pitchers tab (instead of deleting) in case you are anticipating having to rinse and repeat for updated data.

                Just a thought. :o)

    • Hot Rod

      Jimmy Bond says:
      (link)

      @lake: on updating stats – normally you should be able to update them by choosing data tab and clicking “refresh all”. BUT…there is an issue that needs to be fixed first – right now column A in the (hidden) Import tab disappears when the data updates, as it is not part of the downloaded table, but there are other columns relying on the numbers that were apparently typed into that column. So when excel does the download of data, it overwrites those numbers resulting in Total Rank columns all changing to zeros. The hitter and pitcher ranks are still fine.

      So there needs to be a formula fix in the TOTAL RANK column. I will do that with mine when I update to V2. Maybe someone from Razz will do with their version? not sure. it definitely needs to be fixed.

      PS I’m not trying to take over the war room entirely, I just love tweaking excel spreadsheets so it’s a challenge now to make it optimized as best I can for my purposes (and if I can help out some others on here, great)

      • lake says:
        (link)

        @Jimmy Bond:
        Yeah. I’m struggling with it. Everytime I try to remove the blank.spots on hitters side. It puts Trout again right below and lists the rankings again.. thanks for your help.

      • Hot Rod

        Jimmy Bond says:
        (link)

        @Jimmy Bond: I can’t duplicate what you are seeing happen, but I will have a new version this weekend after JB puts out his pitcher ranks Friday. I can maybe also release a ‘hard coded’ version so that you can play around with it without the formulas/rankings getting messed up. If you need sooner, Syllogism kindly offered to do a custom version – his email just above this.

  21. J_Ceol says:
    (link)

    I’m still confused as to why Russell Martin isn’t in the TIERs section……..

    • Nico says:
      (link)

      @J_Ceol: Oversight on my part. Tiers are put in by hand, so it happens sometimes.

  22. Dude Just Wants His Rug Back says:
    (link)

    Gotta say I love the War Room and everything it provides. I’ve been an avid user since year 1 and consider War Room day somewhat of a holiday. Having said that I am having an issue with sorting hitter columns in that it doesn’t sort. I get a different issue with each column. I’ve tried everything in my (limited) knowledge to fix it and I can’t seem to resolve the issue. I even dl’d Bond’s version and it’s doing the same thing. The pitcher side seems to be fine tho. It’s odd…

    • Hot Rod

      JimmyBond says:
      (link)

      @Dude Just Wants His Rug Back: that’s definitely weird. I see what you mean, I hadn’t tried sorting those stats columns since I assumed they would behave.

      I realized why it is doing it, the cell references for grey’s rankings are getting screwed up if you sort hitting stats, due to being formula-derived. this is true both in mine and the official version.

      the way to fix (which I labeled in mine but apparently didn’t implement yet, oops!) is to HARD CODE the Grey Hitter and Grey Pitcher columns. So those columns should be numbers, not formulas based on the first row. In main razz sheets this is columns A/X, in my sheet (v1) it is A / AB (the red box column headers). If you hard code these entire columns, then when you sort by the hitting stats it will sort appropriately. If you sort larges to smallest will still bring up ‘blank’ rows first as the largest, but just ignore these, there should only be 3 at present. Excel probably thinks those blank values are infinite or something like that.

      the easy way to hard code these yourself is to right click on column letter at top, CTRL-C to copy, then paste values (right click column letter and press ‘S’ then ‘V’) Or you can wait til I fix this in my v2, will post later today if I get a chance.

      as I mentioned before, that hard coded Grey Hitter /Pitcher rank is like your ‘home’ button – just sort that column smallest to largest to bring everything back to original order.

  23. David Sheely says:
    (link)

    Where’s DH’s?

    • Nico says:
      (link)

      @David Sheely: Those are typically not included in the sheet. I’ll see if I can add them and update everything before the season begins.

  24. Lake says:
    (link)

    This thing is awesome. Thanks
    will these projected stats be updated?
    If so, will I need to redownload?

    • Nico says:
      (link)

      @Lake: Grey doesn’t normally make sweeping changes in his projections, but if there are changes, I will do my best to provide an updated sheet for you guys.

  25. lake says:
    (link)

    What does the T and C lines mean on the Goals blurb?
    I’m just wanting an updates stats of what I have so that I can know where I’m at in hitting my goal?

    • Nico says:
      (link)

      @lake: T – is the Total average per player in that stat category, and C – is the Current average of your players in that stat category.

  26. The Dude says:
    (link)

    First off, thanks for making this happen each year. I’ve been using it since Lou introduced it like 7-8 seasons ago and although Grey’s rankings/commentary and Rudy’s fastidious analysis are the greatest commodities on this site, w/out this spreadsheet on Draft Day much of that value would be lost in the fast pace of names as they fly off the board. This sheet is what takes all that value and makes it applicable in real time. So again, muchas gracias!

    If I wanted to supplant my own rankings (actually Rudy’s OBP/QS rankings) into the spreadsheet what would be the process? Just overlay the Players Tab? I see those values are derived from a vlookup, will that break the entire sheet?

    How will doing that effect the Dashboard?

    Also question @JimmyBond: Love the conditional formatting you’ve added, are you going to provide the same for the Auction version of the spreadsheet?

    • Hot Rod

      JimmyBond says:
      (link)

      @The Dude: I don’t do auction drafts so I thought that making the salary tab optional in my base spreadsheet was enough, click the ‘+’ symbol above columns ‘I’ and ‘AK’ and you should be able to input salary for an auction format, the war room will track your spend etc.

      on adding your own rankings – without getting really messy, the EASIEST way to do this is to forgo having the ability to update Greys’ forecasts automatically. In return, you’ll have a static version of the spreadsheet that you can re-order to your heart’s content. to do that, select all on the players tab (the little box above row 1), then CTRL-C and then paste values by right clicking and pressing ‘V’. now all the names and stats are hard coded into the Players sheet, and you can go through and make your own column to rank guys according to how you want. I even had a couple columns pre-set for this purposes, they are hidden as D/E and AF/AG. if you highlight columns C-F and then right click and choose “unhide”, they will show up.

      • The Dude says:
        (link)

        @JimmyBond: Thanks Jimmy, I hadn’t noticed those ‘+’ symbols. That should cover me for my auction.

    • Hot Rod

      JimmyBond says:
      (link)

      @The Dude: PS – to your other question – if you do this hard-coded Players tab, the dashboard will remain *unaffected* – it will still keep looking for a name match in the appropriate column in the PLAYERS tab.

      technically you could add a column in PLAYERS and put your own rank in now, but without doing the hard coded values your rankings could be associated with the wrong player if the spreadsheet ever updates its data and the official ranks have changed. this helps protect against that.

      a side note – I might try tweaking the dashboard to highlight green if it’s my player, grey+crossed if someone else’s…another one to try and add in V2/(V3?)!

  27. CadeWTM says:
    (link)

    Dear God I love this spreadsheet, been using it for years in my live draft as the perfect cheat sheet.

    I’m certainly no Excel wiz by any means, and I know this is setup for the Razzball leagues so this may be a stupid question, but is there a reason why it is only configured for hitters and pitchers without any bench spots? My league has 10 hitter spots and 8 pitcher spots with 5 bench spots. If I input 10 and 8 then all the numbers just configure for 18 man rosters as opposed to the 23 man rosters we have.

    I’m sure this is an easy fix, but any help is appreciated by this non-excel wiz

    • Hot Rod

      Jimmy Bond says:
      (link)

      @CadeWTM: this is a good idea. you’d need a lot of IF formulas to check whether a certain position was full and if yes then that the next player from that same position is now a bench player

  28. Nico says:
    (link)

    Hey Mr. Bond, good looks on the responses.

    The War Room is set out to be a general plan for everyone, but most people I know do their own tweaking. I conditionally format and insert “ADP” and “ADP v Grey Rank” columns in my players tab to see where players might be drafted VS how Grey values those players. Unfortunately, it’s impossible to customize this main sheet for everybody’s situation, however, I encourage each person to tweak it for his or her benefit. Anyway, thanks for hopping on those questions.

  29. Syllogism says:
    (link)

    Exceptional work. Of the (rare) kind that goes with “geeze – I wish I’d done that”.

    The frustrating thing about having customizable leagues is, well, having customized rankings. While our 7 x 7 league adds (TB|OBA) and (Holds|K/9), there are far too may 7×7 variations to rationally expect to find rankings for this particular set. Even if out there, *finding* the website is almost a non-starter – even using boolean searches. And just to add one more layer … much of the analysis is spent on auction, and, later, DFS) $values instead of simple draft rankings, making the search for customized-stat *draft* rankings an even rarer bird.

    Even so – does anyone have any advice (aside from “CHANGE YOUR CATEGORIES”) on –
    – any sites or tools which don’t simply include TB, OBA, H, K/9 but can *rank* players based on customizable choices
    – any rankings that are *close* for hitters/pitchers
    – any notionally conceptual suggestions on how to frame/re-rerank standard 5×5 categories to factor in TB, OBA, H, K/9? (noting that Holds is the category least likely to be in an overall *draft* ranking system and problaby the category easiest to make mental adjustments for).

    I think I might be able to sort out how to modify the spreadsheet. The hardest part is getting the kind of ranking data to help with the approaching 7×7 draft.

    Again – fabulous work! Thanks for sharing it!

    • Did you check out the ‘Other Hit’ and ‘Other Pitch’ player raters I added yesterday?
      razzball.com/playerrater-preseason-hittercategories-espn/
      razzball.com/playerrater-preseason-hittercategories-yahoo/
      razzball.com/playerrater-preseason-pitchercategories

  30. Roger Podacter says:
    (link)

    Hey thanks again for this amazing tool.

    I noticed that Russell Martin is absent from the dashyboard FYI

    Thanks again!

  31. Syllogism says:
    (link)

    @Jimmy Bond:

    A couple of things I’m trying to wrap my head around with this.

    Adding, in my case, data columns for OBP, TB, Holds and K/9 is only useful if I’m able to adjust whatever dataset rankings are being imported. So if Grey is 5×5, his rankings really don’t account for additional stat categories. So one is confronted with one of figuring out some rough mathematical co-related impact that these stat categories may have in adjusting Grey’s ratings, or finding a closest approximation using another’s rankings (the 6×6 OBP and then sorting out the effect of TB for example) or coming up with one’s own ranking formula. *sigh*

    There are some constraints in the spreadsheet structure that I’m going to see if I can modify and offer back out – for example – the Roster Size … (noted to be “25”, but you do seem to be able to draft beyond that as your team’s projected stats don’t cap) … Roster Position Requirements (2C leagues, CO+MI, or UT, Benches) … an easy(ish) way for you to autotrack positions you need to fill and have handy the flex-positions you’ve already drafted.

    I’ve started to wonder about if the projected “roster value” (Batting/Pitching ranks; Goal Tracking) maps out in Head-to-Head Category leagues and how to make the mental adjustment – if any.

    And in a similar vein, the Projected category performance seems to presume that you will get the benefit of 100 % of the projected stats for *all* of your players for the year. Trying to come up with a formula to adjust for the fact that we count only 9 hitters on any given day is a bit of a head scratcher. Pitching adjustments would be a bit different – since starters don’t play daily, you might get most, if not full, stats for more of them than you would for hitters.

    Trying to get a handle on each of our own league’s quasi-unique scoring and roster shape is just crazy. Even so … I really do like our +OBA+TB+Holds+K/9 format. Sigh.

  32. Neil says:
    (link)

    Can you add ages into the War Room Excel file? I realize it is not a category that counts towards fantasy scoring, but it matters. Especially when you get late in the draft and have to quickly decide between two players ranked similarly, one young one with upside and one old as sh!t. Grey references players ages all the time in developing the tiers, but it would be great to have in the file.
    Thanks.

  33. Hot Rod

    Jimmy Bond says:
    (link)

    I have updated my version of the War Room spreadsheet to V2. Lots of changes, including Prospect Rankings from Top 100 (Ralph Lifshitz) now sortable columns in Hitter/Pitcher in war room. Also did some data fixes for dashboard (name typos etc), and some new formatting per board suggestions here.

    Haven’t worked on AL/NL version yet, but workaround mentioned by someone here is one way to handle it…will try to do that too if I get a chance. Will be updateing for V3 anyhow with JB rankings.

    Download here: https://docs.google.com/uc?authuser=0&id=0ByY40Vu3ttWQellubVZNYzRHUUE&export=download

    • Hot Rod

      Jimmy Bond says:
      (link)

      @Jimmy Bond: I should clarify – I realize that the prospects that Grey didn’t rank in his top 500 are not listed listed in the order he might pick even though they have ‘grey hitter rank’ beside them, but they had to get on the spreadsheet somehow and plunking them as the ‘bottom’ of the Grey hitting/pitching order was easiest. Any true Grey rankings end at Josh Hamilton for hitting and at Vogelsong for pitchers. After that, prospects are listed in Ralph’s order (as you can see from the Prospect column), but remember that any prospects Grey ranked are already slotted in their appropriate ranking, higher up e.g. Tim Anderson at 181st hitter (and stats pulled for Grey’s picks too, otherwise stats will be blank)

  34. Hot Rod

    Jimmy Bond says:
    (link)

    who knew the keepers would be out just after I published V2?

    Version 3 of my War Room now available, with some small tweaks and including the J-FOH keeper rankings as sortable columns for hitters and pitchers. I also added K/9 as a sortable item, based on Grey’s projections from the Razz database.

    will update as V4 when JB pitching ranks are out.

    download here, remember to enable editing and enable data connections:

    https://docs.google.com/uc?authuser=0&id=0ByY40Vu3ttWQOGF2WTRycExxX28&export=download

  35. Clueless Exceller says:
    (link)

    Hey everyone,

    I’m trying to download the auction spreadsheet. It downloads, but upon opening, it tells me that the file may have been damaged or modified from its original format, and cannot be opened.

    I am using Excel 2008 for Mac, 12.1.0.

    Any ideas on how to fix this?

    Thanks!

  36. Matchgrade says:
    (link)

    Hi Nico,

    If you change the formulas to use index/match instead of vlookup you can circumvent the error you’re getting with importing the data. Just fixed my war room

    If you want, I can email you the formula I used and/or a copy of the spreadsheet

  37. birrrdy! says:
    (link)

    anxiously awaiting the NL-only auction version… any progress or an ETA? Great stuff.

    • Hot Rod

      Jimmy Bond says:
      (link)

      @birrrdy!: I’m going to try to work on something this weekend, I am waiting for the JB pitching ranks to be posted which I think might be tomorrow/Friday?

Comments are closed.