It’s that time of year again, the one time of year when people are clamoring for a new spreadsheet. Draft season is nerds’ time to shine, and I’ve got you covered as usual. Looking to go beyond the copious 2019 fantasy baseball draft tools and online fantasy baseball war room? Do you yearn to have the ultimate drafting tool, to track goals and keep track of how other teams are doing? Want rankings based on points/OPS/etc instead of just plain old roto? Aiming to fill your roster with not just stars but also the occasional diamond in the rough, still available far beyond a reasonable ADP? Look no further – the downloadable 2019 fantasy baseball Excel war room is here!

If you plan to skip most of the info below, take this one tip with you: bookmark and keep checking this page throughout the pre-season. A few bugs usually pop up, and I may add features too. The most up-to-date version will always be posted at the bottom of this post, before the comments.

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 – green 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 2019 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 in tiers (not just closers) -> 89 total RP this year, roughly the top 3 relievers per team.
  • Supporting up to 25 teams per league

 

*New for 2019*

  • more players ranked by Grey than past years
  • WAY more players with multi-position eligibility, expanding the tiers on the Dashboard. Feels like every player in the league has OF eligibility when you scroll down.
  • Points leagues: I have made the sorting a standard “all” column instead of splitting hitters vs pitcher. Both hitters and pitchers feature a total points and points per game column too.
  • Ohtani is listed *only as a hitter*, due to his surgically repaired super-elbow and lack of any pitching projections for him by Grey for 2019. Keep this in mind in case you have a league that makes him use an SP slot for some reason.

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!).
  • 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’!)

Credit goes to the originator Lou Poulas and a host of other update authors over the years, and I’m proud of the features and colorful interface that I’ve implemented over the last few of years to make the tool more usable to navigate in a fast paced, high-pressure draft. Thanks to Knucks for assembling the Tiers data for 2018 and 2019.

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 5th 2019)

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.)
(Current version V2 – Mar 3 2019 – bug fixes, updated Dashboard tiers, additional sortable rankings for more hitter and pitcher categories)
(Current version V3 – Mar 5 2019 – bug fix for new sortable rankings)

(Current version V4 – Mar 17 2019 – fix for hiding columns on Players tab)

 

Fantasy Baseball War Room – COMPATIBLE

(“vanilla” version – NO MACROS so clickable buttons won’t work. This is for people who have older versions of Excel that struggle to keep up with the sheer awesomeness of newer formatting. Use normal version if at all possible, as some functionality is not in the Compatibility version so wonky things may happen.)

94 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
Ray
Ray
3 years ago

Thanks for the amazing work, Hot Rod!

I’m also getting the “can’t push objects off the sheet” error when trying to hide certain columns. Any ideas?

Ghost Ride the WHIP
Ghost Ride the WHIP
3 years ago

Hot Rod,

Thanks as always for this. If i am sorting by using the 6×6 steamer projections, will the order of these also update with a ‘Refresh All’? Also, if there any way to tailor the Dashboard to specific website eligibility, ie ESPN?

Mike
Mike
3 years ago

I’m having trouble hiding columns on the Players page. When I attempt to do so, I’m getting a dialog box that says “Can’t push objects off the sheet.” Any suggestions?

BadFantasyManager
BadFantasyManager
3 years ago

Thanks very much for this useful tool! I am preparing for my fantasy that is weekly H2H. I want your opinion on how would you recommend to modify the spreadsheet for this type of fantasy?

BadFantasyManager
BadFantasyManager
Reply to  Hot Rod
3 years ago

@Hot Rod Sorry I didn’t specify, it would be categories but you reply helped a lot! I will use this to ace the fantasy. Thanks!

The Dude
The Dude
Reply to  Hot Rod
3 years ago

@Hot Rod: Hi Hot Rod, I’m just now getting a chance to play with your new feature. Thanks for taking the time to implement it!

I found the User Rank columns, and immediately see the issue you described about projections being skewed for players with a low amount of appearances. I suppose it’s not easy to implement a PA or IP minimum or you would done it?

I first noticed that when I sort for many of the Pitching Stats, the result is not as expected. QS, for example shows Scherzer, DeGrom and Sale as ranked 581, 576 and 587 respectively. After some quick investigation, it appears that Steamer does not project QS which likely explains the results.

This leaves me wondering what Rudy’s rankings are based on if not Steamer projections for his QS leagues.

In any case, this is still a very useful enhancement, thanks again!

Rudy Gamble
Reply to  The Dude
3 years ago

i project QS (as well as Saves, Holds, Runs, RBI)

Ryan Jennaro
Ryan Jennaro
3 years ago

Is it possible to get the maximum team input up to 30 teams or is that something I can adjust on my own?

NeilB
NeilB
3 years ago

Hot Rod – have you considered adding injuries to the file? I have had a couple years where a guy “fell to me” only for me to realize after I drafted him that he was injured.

El Jefe
El Jefe
3 years ago

The War Room excel file is awesome – Thanks!

The Dude
The Dude
3 years ago

Hi Hot Rod,
I forgot to thank you for building this amazing piece of technology and releasing it for free! So, thanks! I’ve been using it faithfully since it’s first iteration about 7 years ago (and 4 authors ago), and you’re contributions have made it much more intuitive and useful.

I noticed your response above about changing the categories to include things like OBP, QS, etc. Is there a way to import Rudy’s OBP rankings and replace them with Grey’s? Don’t get me wrong, I like Grey’s stuff as much as the next guy, but when you’re in an OBP league it’s nice to see where value can be gained against the schmucks using AVG based rankings. Plus, Grey himself has said he uses Rudy’s rankings for OBP leagues!

Five-on-One
Five-on-One
3 years ago

How does the War Room track actual auction dollars spent/remaining for all teams? Is there a spot to enter in not only the team that bought that player but also the amount they spent?

JB
JB
3 years ago

Jaheesus Christmas – I just ruined my favorite boxer briefs. GFM, but thank you – I might have hit the ceiling if I had time to drop trow…

The Dude
The Dude
3 years ago

Hey Hot Rod,
I noticed the spreadsheet has Muncy listed as OF eligible with a note saying “In Yahoo Only”. This is actually not the case. Muncy was OF eligible last year in Yahoo, but dropped that eligibility for 2019.

Yahoo requires 10 appearances or 5 starts to qualify at a position. Muncy had only 6 appearances and 0 starts.

The Dude
The Dude
Reply to  The Dude
3 years ago

@The Dude: Also, Acuna isn’t getting marked off on the “Dashboard” when marked as drafted on the “Players” tab.

Mike
Mike
3 years ago

It says that the projections come from Grey and Steamer’s projections. But when I click on the projections page on this site, there are differences. Do you have a link to where the projections comes from?

Mike
Mike
3 years ago

Any Excel nerds have any advice on a way to have the auction values update for inflation as people are drafted or when keepers are inserted? Perhaps a formula to insert on the auction values?

LenFuego
LenFuego
Reply to  Mike
3 years ago

@Mike: Hi, Mike. Last year I spent an inordinate amount of time taking the 2018 spreadsheet and made a LOT of changes largely for use in auction drafts. My changes did adjust for inflation for keepers but not “on-the-fly” during the draft.

I am looking at doing the same thing this year though I am daunted by the size of the task – I will probably only do it if I can make the changes easily reusable for future years. If I do make those changes I will post the resulting spreadsheet here.

LenFuego
LenFuego
Reply to  Hot Rod
3 years ago

@Hot Rod: Thanks for the heads up. I am working on the logic/math part to work out the kinks rather than the nitty gritty and formatting – will have to repeat some work but not a lot.

Plesh
Plesh
3 years ago

Thank you, thank you, thank you! This is the best draft tool ever, and the best day of the year for a fellow Excel nerd.

Pine Tar Incident
Pine Tar Incident
3 years ago

You are a golden god. Seriously, I love this thing and I know it takes a lot of work.

Jason P.
Jason P.
3 years ago

Thank you so much for this! Is there a way to enter my own projections in here? I know you posted something similar last year about it.

Jason P.
Jason P.
Reply to  Hot Rod
3 years ago

@Hot Rod:

Thank you! My league is a standard 5×5, so no need to get that crazy.

NUX
NUX
3 years ago

My man… nothing but love for my favorite excel sheet assassin. Well done sir. Thanks for doing this again.

The Scrant Dog
The Scrant Dog
3 years ago

I’m too slow to use either this or Rudy’s War Room for on the fly draft, but these are both pretty neat for slow drafts!

JD Hassett
3 years ago

Thanks Hot Rod- I have been putting in the keepers for a league I am in and it seems to work great. Glad to see you mention that you do not use the war room much during the draft. I thought I just wasn’t smart enough to keep up but I do not either. I mainly use the player listing with the tiers. It has been a great tool for a number of years. Thanks again for keeping it updated.

Johnnyhobbes
Johnnyhobbes
3 years ago

Hot Rod thank you so much for making this- I am going to bet this is due to user error but when I try to sort the pitchers according to points league rankings- it only gives me options to sort alphabetically- could you check that out?Thanks

johnnyhobbes
johnnyhobbes
Reply to  Hot Rod
3 years ago

@Hot Rod: PTS_TOT_RANK is only filterable a to z or z to a for me…. yet PTS_Total_PTS , for example, is filterable smallest to largest… I am using a very updated version of excel. all other drop downs are sort-able by small to large where there are numbers to sort on the spread sheet. I will download again and see if it the problem replicates.

Johnnyhobbes
Johnnyhobbes
Reply to  Hot Rod
3 years ago

@Hot Rod: thanks HotRod, I’ll jump into this and report back after I am the only one awake in my house

Ghost of Grady Little
Ghost of Grady Little
3 years ago

Hey guys,

Question: Is there a way to track additional categories (OPS, QS, HLDs)? I see the raw data in the HIT and PITCH tabs, but I’m not sure if/how I’d add it to the War Room.

Thanks for the awesome free tools!

Ghost of Grady Little
Ghost of Grady Little
Reply to  Hot Rod
3 years ago

@Hot Rod:

Awesome! You’re explanation was even more detailed than I was hoping for. I really appreciate it (and hope others out there do as well)!! Enjoy the season.

Mike
Mike
3 years ago

Do auction values adjust throughout the draft, or reflect inflation if I put in keepers pre-draft?

LenFuego
LenFuego
Reply to  Mike
3 years ago

@Mike:Unfortunately, they do not.

Asst2RegionalMgr
Asst2RegionalMgr
3 years ago

I have some enhancements I did a while ago for the war room. The main issue I found was being able to quickly keep track of all the other picks while not losing focus on my plan for the draft. I have added macros to the dashboard to make it easy to change who is drafting someone and a macro for drafting the active cell player. this made everything flow much better. Also, I needed to swap out HR for OPS but wanted to use grey’s projections of HR to factor in the projected OPS so that is in my war room as well. If you are interested in these reply and I can arrange to post it to a shared link and you can check out the vbs code for it.

Perfect Game
Perfect Game
3 years ago

Somewhat new to Fantasy Baseball. Never used a draft tool like this before, so forgive me in advance if these are stupid questions.

Do I import this list into my ESPN live draft room so I’m using your player rankings/projections instead of their crappy one and the spreadsheet will automatically show the players taken/available by me and the other teams during the draft? Or do I need to make adjustments to the list manually?

Bryce Krispie Treats
Bryce Krispie Treats
3 years ago

Why wont the normal war room work on a desktop? Nothing shows up. Everything on the page (ads, top bar, Razz logo) is there, but the actual spreadsheet does not load. I have tried on multiple computers and cleared cookies. Works perfectly on my phone though.

Harry
Harry
3 years ago

OH YEAH!
My favorite time of year indeed. Thanks for the work you guys put into this masterful tool of the trade.
Side Note: Please consider stocking GREY or White T-shirts.
Not everyone likes to look like they just came from a poison concert / monster truck rally.

lingeron
3 years ago

Am I crazy, or is there no hyperlink where it says “click here to download”.

Thanks again for all your hard work!

gobiggreen
gobiggreen
Reply to  lingeron
3 years ago

@lingeron: you are crazy, but you are also correct

Grey
Admin
Reply to  gobiggreen
3 years ago

@gobiggreen: Haha, sorry guys, was my bad, fixed now

lingeron
Reply to  Grey
3 years ago

@Grey: Thanks so much!

Grey
Admin
Reply to  lingeron
3 years ago

No problem