Welcome to the glamorous “anniversary edition” of the downloadable Razzball Excel War Room. Has it really been ten years already? Google tells me a tenth anniversary is traditionally marked with tin or aluminum, but I’m going digital instead…hope you like spreadsheets!

Credit goes to the originator Lou Poulas and a host of other update authors over the decade. Time flies, as this marks my fifth year updating and tweaking the file (!), I’m proud of the features and colorful interface that I’ve implemented to make the tool more usable to navigate in a fast paced, high-pressure draft. Thanks also to Knucks who jumped in starting in 2018 for tedious data compilation for the dashboard tiers and has done so through 2020.

This file supplements the copious 2020 fantasy baseball draft tools and online fantasy baseball war room available on Razzball. I used to claim it was the “ultimate drafting tool” to track goals and keep track of how other teams are doing, but that was before Rudy made his own draft-dominating war room spreadsheet available for subscribers. Rudy’s version is geared towards roto leagues, so you may still find this Excel war room more closely suited to your league’s format – for example, points leagues with custom scoring are easily accommodated here.

If you plan to skip most of the info below, take this one tip with you: check out the 2020 changes, then bookmark and keep checking this page throughout the pre-season. A few bugs usually pop up, and I try to address these as they come up. The most up-to-date version will always be posted at the bottom of this post, before the comments.

*What’s new for 2020*

  • Color scheme changed – picks for you and your team are now highlighted in ORANGE, instead of green, to try and be more accessible to color-blind users (8% of men). Dashboard colors updated for everyone’s benefit, to no longer offend retinas with (garish) orange/yellow/blue text. A more modern blue subdued color scheme is accented with orange and grey highlights (more aligned with popular data visualization software) as you and opponents draft.
  • More prospects added to incorporate top 200 prospects for 2020 by The Itch. Note that ETA year is shown exactly as listed in the Top 200, so that means some players listed as 2018/2019 even though this is the 2020 season (presumably they should be playing this year?!?)
  • Ohtani remains an enigma, since hitter and pitcher. For simplicity, I have left him as-is from Grey’s stats list which means that he is listed in both categories independently. When you select him as ‘drafted’, you will need to do this twice – for Ohtani on hitter side AND Ohtani on Pitcher side. But for other calculations, the file is aggregating his total stats (e.g. for points leagues, the war room aggregates hitter and pitcher points which is why each of the Ohtani’s shows as the number 2 overall player in points ranking, it is adding the points for Hitter Ohtani and Pitcher Ohtani.)

KNOWN ISSUE: When is Will Smith not Will Smith? When one plays for the Braves as pitcher and the other for the Dodgers as catcher (a baseball version of Gemini Man?) The fresh prince is displayed with the same name across Razzball, creating a tiny issue in the Excel file based on how I currently have lookups coded to get data from the site. To fix permanently I would have to change the lookup formulas for most of the Players tab; for now, as a workaround, I temporarily changed the pitcher to display as “Will Smith PITCHER” across the war room. This will work just fine if you leave things as are and don’t update data connections. However, if you refresh data connections, the dashboard RP ‘Will Smith’ will not cross off properly and the Players tab will not pull pitching stats for pitching edition of Will Smith. But it will still keep two distinct Will Smith, one hitter and one pitcher. If you are updating stats you probably aren’t as concerned about the dashboard accuracy since tiers are hard coded and do not update anyhow.

The usual snazzy features of the Razzball Excel War Room:

  • Color-coded Dashboard and Players tabs that “cross off” selected players as you enter a team name next to the player – orange if player is on your team, and grey if on opponents’ teams, making it easy to see at a glance who you drafted and who is off the board;
  • Team by Team analysis of players taken, and players left;
  • Real time projected totals, along with real time projected league standings, and Goal Tracking Dashboard;
  • ‘Players’ tab lists players in in order of Grey’s top 500 for 2020 fantasy baseball, including Grey’s projections (stats and auction values);
  • ‘Dashboard” tab displays players by position, using Grey’s rankings (color coded by tier!);
  • Points columns in the Players tab: includes both a ‘total rank’ based on points values (input your custom league scoring in ‘user input’), and also shoes the total points and PPG as sortable columns. Uses Steamer projections.
  • OBP and OPS rankings in the Players tab, both 6×6. Uses Steamer projections;
  • Sortable columns for pitchers’ K/9 and ‘Ace Index’ (K/9 less BB/9), with user-selectable cutoff for each stat.
  • Dynamically updated team rankings
  • Multiple RP (not just closers)
  • Supporting up to 30 teams per league

A few of my personal tips:

Before drafting:

  • simplify columns on the Players tab– you won’t need all of them so just click to hide (click the minus button above, or for those without a minus button right-click on the column header and choose ‘HIDE’) Also, hide whatever site ESPN/Yahoo that you don’t need (e.g. if you are an ESPN league, hide Yahoo position columns)
  • For auctions: be sure to click the ‘+’ grouping button on PLAYERS tab, above the TEAM columns, to expose the salary input column
  • On PLAYERS tab, press CTRL-F to enter “Find” mode, and select LOOK IN: “VALUES”, otherwise you will get a result that says ‘no data found’ since searching formulas will get you nowhere; once you have this enabled searching VALUES, though, you can quickly find a player in your draft by pressing CTRL-F and searching their name (while on this tab/worksheet);
  • I like to lock the values on the Player tab (converts all the formulas to values, to prevent any Excel glitches) To help with this, a “lock Projections” button is on the “User Input” tab– click it to lock projections (be sure you have macros enabled in Excel, since this feature is a macro to copy-paste all the proper columns and save you the trouble!). Note that if you do this, the User Rank option in columns I and AT gets disabled. If you need this, pick your favorite (SLG, etc) before locking.
  • Use short team names on the User Input page to act fast in your draft (I use the 3-letter team abbreviations from my ESPN leagues) Or for speedy drafts just call yourself ‘A’ and put everyone else’s pick as team ‘B’ all lumped on the same team. Sure, you won’t have the team by team analysis correct but that isn’t as important as knowing who is still available if you are in a league that drafts fast (and league analysis is moot once the real life games start anyhow!)
  • Once you type a team name beside a player in the Players tab, the next time you go to type that team name Excel will try to autocomplete the name, which can really save you time to just type the letter and then hit enter (note: this works best if all teams on the User Input tab all start with different letters!)

During the draft:

  • If you really want to be a power drafter, do split-screen multi-pane view (or even nerdier, multi-monitor!) and have the dashboard up next to the Player page.
  • If you are really quick, you can click the top of the position column to filter by ESPN or Yahoo position – which can be helpful if you are missing a player in a certain position. Note: this is hard with multi-position eligibility for so many players. Or, better still, flip over to the Dashboard tab and see which position column needs more ‘green’ – a quick scan will tell you if your next pick should be a hitter or pitcher (or a gamble on a prospect!)

In all honesty, everyone will use this spreadsheet differently. I personally never look at the ‘War Room’ tab during the draft, only the Dashboard and Players tabs, sometimes it is a slog just keeping up with drafted selections (especially with any auto-draft picks!) But the functionality is there if you want it, and in a slow draft you can really maximize the analysis.

  • Prospects who AREN’T projected by Grey can be found all the way at the bottom of the Hitter and Pitcher list (or, ideally, sort by Prospect ranking to bring them to the top!)
  • We don’t have an AL/NL specific version, but try this as a workaround….first, LOCK PROJECTIONS. Then, say you want NL-only: start by making a fake team #25 named ‘z’; go to Players tab and sort hitters column L to only show AL teams and draft them all by ‘z’, then clear the column filter for hitter teams so you are showing all teams again. Then, do same for pitcher side (filter to just American League teams in column AO, only, draft all those players by team ‘z’, and then clear the team filter to show all) [NOTE: if things look messed up after doing this, get back to original order by sorting Hitter/Pitcher by Grey rankings (columns A and AF)]. Now, all the players in American League are drafted and unavailable and crossed off on dashboard too, meaning anybody that is left is National League and fair game to draft. I realize league team rankings will be messed up, but at the end of your draft just reverse the process and delete the ‘z’ drafted players and you can evaluate how you stand versus your real peers (and not team ‘z’!)

Feedback / suggestions / bug fixes?  Comments welcome below! Good luck with your draft(s)!

The newest version will always be hosted here on this page, click here to download:

Fantasy Baseball War Room 

(Current version V3 – March 11th, 2020)

Remember to enable macros / enable content if prompted by Excel security warnings, to be able to use “Lock Projections” button on User Input tab and other features.)

 
  1. Brad Cote says:
    (link)

    Hot Rod, I look forward to this every year. Thank you again for your hard work on this…it is greatly appreciated.

  2. bamabterry says:
    (link)

    I second that.

    • dr chym says:
      (link)

      I third that.

      Excel is awesome.

      • johnnyhobbes says:
        (link)

        Fourth!

  3. JD Hassett

    JD Hassett says:
    (link)

    Thanks for sharing your work. I did it several years ago to keep it going. I love this tool.

  4. JD Hassett

    JD Hassett says:
    (link)

    Thanks for sharing your work- This is great. I use it every year.

  5. detroit_kozak says:
    (link)

    This is a great tool – thanks!

  6. Long Balls says:
    (link)

    AWESOME, thanks again for putting this together, Hot Rod

  7. allstoked13 says:
    (link)

    Thanks for doing this! Works great with my keeper league.

  8. Duuuuuuuuuuuuude says:
    (link)

    First time trying this and it looks great. Maybe I’m dumb but I can’t figure out how I can get a 2nd pitcher added to my team in the War Room. I can add it on the Players tab but they don’t show up on my roster.

    • Humm Baby says:
      (link)

      There was a similar glitch last year in the first version and Hot Rod fixed. Maybe same deal this time.

    • bterry says:
      (link)

      Same glitch for me

      • Hot Rod

        Hot Rod says:
        (link)

        Oops! I do quick bug testing but something always slips through.

        I’m on the road, and will fix by Tues night. (Mar 3) In meantime try the fix below by Pants. Thanks!

      • Hot Rod

        Hot Rod says:
        (link)

        this issue fixed, download V2 at link above comments ^ ^ ^ ^ ^ ^

        I made a tweak so that it hopefully won’t happen next time it is updated.

  9. Joseph Reilly says:
    (link)

    Look forward to this every year. Thank you thank you.

  10. Humm Baby says:
    (link)

    Thank you again. Have used this for 5 years, have won for 5 years running. You the man.

  11. NUX says:
    (link)

    Our hero, Hot Rod.

    Thx as always brother, just happy to be a bit helpful in some way. Cheers to our inevitable 2020 victories!

  12. Pants Mulliniks says:
    (link)

    Amazing as always, Hot Rod. Much obliged!!! Sometimes I find it moderately disturbing when I consider the fact that I think of these spreadsheets as magnificent works of art… But what can I say: they’re masterpieces!

    I noted that issue with pitchers in the War Room as well. Pretty easy to fix: On the Players’ sheet, you have to unhide the columns that come after the predicted stats (around BI:BU). You should see three columns in the middle (named A10, B11, C12)… It’s the middle one (B11) that needs to be corrected. Start with the second pitcher listed (deGroem): change the formula in BN4 to =BM4+BN3 (ie. adding the cells immediately above and to the left). Then just drag/copy the formula from that cell down the column, and everything should work properly.

    For the record: Everything– and I mean EVERYTHING– I know about Excel I learned from Fantasy Baseball. Who says fantasy baseballing is a waste of time! (Aside from my wife/kids/parents/most upstanding members of society, of course.)

    • Hot Rod

      Hot Rod says:
      (link)

      Oops! I do quick bug testing but something always slips through.

      I’m on the road, and will fix by Tues night. (Mar 3) In meantime I appreciate the workaround. Thanks!

    • Hot Rod

      Hot Rod says:
      (link)

      this issue fixed, download V2 at link above comments ^ ^ ^ ^ ^ ^

      Also, thanks Pants Mulliniks for pointing me in the right direction…indeed that was the spot (plus similar on the Hitters side too) so in a busy week it made it quick for me to go in and fix it!

      I made a tweak so that it hopefully won’t happen the next year the file is updated. Also with the tweak, now people can do a column sort of different rankings without locking projections and that formula *shouldn’t* break

  13. Fooched says:
    (link)

    Yep, yep…… thanks man! This spreadsheet is the best draft tool on the internet (albeit I haven’t seen Rudy’s).

  14. Nate says:
    (link)

    Any particular reason for the $ values getting lighter? Noticed last year’s highest priced player (Mike Trout) was $48, but this year he’s third at $37 and this year’s highest price tag is Acuna Jr at $39.

    • Hot Rod

      Hot Rod says:
      (link)

      I have no idea on how $ values are generated per player. For this war room they are pulled into Excel straight from Razzball databases, so that is a question for Grey or Rudy as to why they are lighter overall compared to other years.

      • Nate says:
        (link)

        Sounds good, thanks! Great work w/ this tool, has helped me a lot for many years now!

  15. johnnyhobbes says:
    (link)

    Hey Hot Rod- I don’t see Lucas Giotto on the most recent version of the spread sheet.

    • Hot Rod

      Hot Rod says:
      (link)

      do you mean Lucas Giolito? He is in the Players sheet, see number 10 ranked pitcher by grey rankings (column AL) at least as of last update. If you are searching using CTRL-F make sure you change it to ‘Look in: VALUES’ (not formulas)

      If you mean Lucas Giotto, not only is he not in the war room but I’ve never heard of that player.

      • johnnyhobbes says:
        (link)

        yep, im a dummy

        • Hot Rod

          Hot Rod says:
          (link)

          on this site I usually just assume someone is in a way deeper league than mine, requiring the drafting of all sorts of players I’ve never heard of :)

  16. Humm Baby says:
    (link)

    Is there a way to see the projected hitter stats in the Players tab? I see pitcher stats only. I’m sure it’s something I’m not doing correctly or there is a hidden column?

    • Hot Rod

      Hot Rod says:
      (link)

      when I saved the file for V2 I must have left the stats closed but easy fix, as the stats columns are grouped so that so that you can choose to see them or not with a single click.

      For hitter stats: On Players tab, look for a “+” symbol above column AB, click that and it will expand to show the stats (which are in columns V through AA).

      For Pitching stats (in case it gets closed by accident), the “+” is above column BJ, and the stats are in BD through BI

      • Humm Baby says:
        (link)

        Thanks Hot Rod, fixed!

  17. Jon says:
    (link)

    Love this spreadsheet!. On the User Input, I changed the points to match Razzball best ball draft I am doing today. I was surprised to see Stanton now at 786 pts, but when I calculate manually I come up with only 603 pts. Are the points calculated from different projections that are shown on the spreadsheet or are my manual calc just off. Thanks

    • Hot Rod

      Hot Rod says:
      (link)

      Good eye. In short: the Players tab is a hybrid of Grey rankings and Grey projections (shown) and Steamer data to derive SLG/OPS/Points (not shown).
      ==========================
      Long answer:
      on the Players tab, the stats shown there and the Grey’s Rankings are all generated from Grey’s projections at : https://razzball.com/projections-grey/

      However, Grey does not project some of the datapoints used in points leagues (or SLG/OPS). To accommodate more types of ranking styles and to allow for the Points rankings, I started to pull pitching and hitting from the Steamer projections into the spreadsheet too. It is buried somewhere in my notes that these are from steamer and not from Grey.

      So, for points totals (and thus points rankings), the Grey projections/rankings are basically set to the side and disregarded (sorry Grey!). Instead the War Room is deriving these rankings from Steamer projections.
      For hitters, that data is pulled from https://razzball.com/steamer-hitter-projections/
      For pitchers, data is at https://razzball.com/restofseason-pitcherprojections

      If you want to get really nerdy, unhide the sheets HITTER and PITCHER and you will see the exact data used in these calculations, along with the points totals at right of table. If you calculate your Stanton stats manually from his line in there (row 251 on Hitter tab, if you haven’t updated data since V2) hopefully they tally to 786 and match what the formula is doing.

  18. Gareth says:
    (link)

    Love this tool every year.. so thank you. Know how to use it, but not to troubleshoot it.

    Issues I am having are with the War Room tab:

    1. After entering team names, they are not populating on the drop down menu in “players” tab. (ie. they are still a, b, c, d, etc.)

    2. Total players taken by all teams remains at zero, regardless of how many players drafted in “players” tab.

    3. Goal tracking is not updating to correspond with players drafted.

    Any clues?

    • Hot Rod

      Hot Rod says:
      (link)

      1) TEAM NAMES: using V2 posted above, I can’t replicate this error error. The place you need to change team names is USER INPUT tab (fields C1 through C30 dep. on number of teams); if I chagne team names here they populate throughout. Everything points to these cells so if you are trying to change names anywhere else it won’t work. (e.g. on the war room tab the names are being pulled from USER INPUT, so it’s the wrong spot to change them here)

      will have a look at others

    • Hot Rod

      Hot Rod says:
      (link)

      2) TOTAL PLAYERS: I can’t replicate this either. If I download V2 above, and enable editing, it works for me whether I am doing a-b-c-d as team names or if I have done custom names like ‘hot’ ‘rod’ ‘war’ ‘room’. In all cases, the sheet is counting how many players are taken on Players tab by each team, sending that to D13:D42 on War Room tab, and the total field in D9 just adds up whatever’s in D13:D42

      All I can think of is make sure to Enable Editing?

    • Hot Rod

      Hot Rod says:
      (link)

      3) GOAL TRACKING: I’m 0 for 3 (or 3 for 3?) Can’t replicate your error here either. Using file V2, the “Current” goals is updating properly for me as I choose players on Players tab for team 1 (whether team name is default “a”, or custom name as input in C1 on User Input)

      I would try with latest file above, ensure you click yes on whatever prompts Excel gives you (enable editing, enable content, enable macros, etc) and go from there. Reply here again if you continue to have issues and we can troubleshoot further…thanks!

  19. Nate says:
    (link)

    If I add columns between U/V and BC/BD, will that impact any of the formulas or screw the spreadsheet up in anyway? I’m looking to add $ values from other sites while keeping the razzball values unchanged. Thanks!

    • Hot Rod

      Hot Rod says:
      (link)

      One big key is to lock projections first. The broader list is getting populated from Grey’s rankings, meaning that if you update data connections and his rankings change after you manually add values you are going to have a bunch of hardcoded $ values you added that are in the wrong spot.

      After locking projections:
      In general I would work with the columns in place rather than adding/removing. There is space here to do that – after locking, I recommend that instead of adding columns you just type the $ values you want into columns U and column BD. Currently they are greyed out but usable; remove the shading and widen the column and now you have a perfectly usable column (in fact it would work as is even shaded). I would not “copy-paste formatting” from T and BB even though they look similar because that sometimes makes the conditional formatting working behind the scenes go screw; columns U and BD are already covered by conditional formatting so they will highlight if your pick (or greyed out if not).

      If you want $ values from more than one additional site, then you would need to add columns. Add a column (or more) to the right of U and BD by right clicking the top of W or BE and choosing “insert”, it should add one that looks similar to the first one. It SHOULDN’T break anything else, as Excel should recalculate cell references everywhere else, but I can’t guarantee it as the spreadsheet has many references going all over the place.

      In summary: After locking projections, and adding your $ values, you can then sort by the drop down in row 2 at the top of those columns (U, BD, or new ones added), just like any other existing ranking. Enjoy!

      • Nate says:
        (link)

        Great, thank you! Appreciate everything you do each year.

  20. Hot Rod

    Hot Rod says:
    (link)

    I have updated all the data/stats to March 11, and fixed some other minor bugs. Grey is projecting a few more prospects than at start of season so they have stats now.

    Check it out at V3 download link above comments ^^^^^^^^^^^^^^^

    Barring any major issues or bugs (possibly introduced by me updating this today!), V3 will be the final version for 2020.

    I would urge you if possible to just use the projections as-is and lock them from this download, rather than refreshing, because if guys get added or removed from Grey’s rankings then some of the formulas need some tweaking.

    Only real remaining issue is pitcher Ohtani showing with incorrect stats (same exact name, so it pulls hitter stats on that side resulting in zeros rather than his pitching stats for pitching side); for those tracking stats closely I apologize for this. However, for Points leagues the TOTAL POINTS ranking is correct, since the war room is correctly adding his hitting and pitching points together (making him top-ranked points player overall, as of V3).

Comments are closed.