Share on FacebookTweet about this on TwitterShare on Google+

It only seems fitting that I should take up the mantle of the 2017 Fantasy Baseball War Room. I’ll be the first one to admit that the satisfaction of working up a beautiful Excel spreadsheet gives me the same kind of goosebumps as when someone utters to Grey the words…“Giancarlo Stanton”. Is it nerdy? You bet. But nerds win leagues, so let me help you win yours. Without further ado, I present the 2017 version of the Razzball War Room “Excel edition” to assist in your league-dominating draft performance. Let’s delve into the features:

First and foremost, this workbook is auto-updating. So long as you click ‘refresh data connections’, you are guaranteed to be seeing Grey’s latest and greatest projections which are updated throughout the pre-season.  To do so: click the “Data” tab in your ribbon,  and then “Refresh all”; if you don’t know what the ribbon is, then this spreadsheet version is probably not for you, and let’s hope for your sake that your league opponents don’t read Razzball or are all drafting from Android devices with no Excel in sight. Seriously, though, if you find the Excel version too daunting, be sure to check out the web version of the War Room linked from Grey’s how-to post for the online Fantasy Baseball War Room.

Features in the 2017 Excel edition include:

  • Color-coded Dashboard and Players tabs that “cross off” selected players as you enter a team name next to the player – *new in 2017* coded 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, players left;
  • Real time projected totals, along with real time projected league standings, and Goal Tracking Dashboard;
  • ‘Players’ page lists players in order of Grey’s top 500 for 2017 fantasy baseball, including Grey’s projections (stats and auction values);
  • Goal Tracking has been pre-loaded with tempporary targets for “What it takes to win a 12 team fantasy baseball league.”;
  • The “Dashboard” displays players by position in order of Grey’s rankings, colour coded by tier;
  • *new in 2017* Sortable columns for pitchers’ K/9 and ‘Ace Index’ (K/9 less BB/9), with user-selectable cutoff for each stat. Note that while the standalone K/9 stat is based off Grey’s projections, the ‘Ace Index’ is derived from K/9 and BB/9 from the Steamer/Razzball ‘rest of season’ projections since Grey does not forecast BB by player.

A few of my personal tips (also listed on the ‘Notes’ tab):

  • for auction usage: be sure to click the ‘+’ grouping button on PLAYERS tab, above columns ‘J’ and ‘AM’, to expose the salary input column
  • PRO TIP: Prior to your draft, 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);
  • PRO TIP: Also prior to the draft starting, I like to lock the values on the Player tab.  Sometimes things can get screwy if you start sorting by columns and it is still using formulas to fetch data from another hidden tab, and the last thing you want in your draft is to have Excel going nuts on you. To be safe, I lock in the Player tab’s values so that none are formulas anymore.  NEW:  a “lock Projections” button has been added to 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!). Remember: Once you do this your projections data are locked and cannot be updated live from Grey’s projections, so only do this right before your draft.
  • Use short team names on the User Input page to act fast in your draft (I use the team abbreviations from my ESPN leagues) Worst case scenario: if you fall behind during drafting, which can happen in later rounds once the lazy drafters go to autopick, just keep track of your team and put everyone else’s pick as the ‘B’ 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 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. 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 SS or SP.
  • 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, as it is enough work just trying to keep up with entering my opponents’ selections as they draft so that I’m not pining after some player who was selected five rounds earlier. But the functionality is there if you want it. One last fast trick: 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 (but this only works best if all teams on the User Input tab all start with different letters!)

Here are some screenshots of the 2017 spreadsheet in action, showing the link between Players and Dashboard tabs:

Keep checking back on this page throughout the pre-season, as I hope to update this spreadsheet as additional Razzball rankings come out. Future features that might still be added as additional sortable columns on the ‘Players’ tab this season, once released this month and next, include:

  • Closer rankings
  • Keeper rankings
  • JB’s pitcher rankings
  • prospect rankings
  • POINTS rankings per Malamoney’s data.  (once implemented, this should adjust to match what you put into the USER INPUT tab as your league’s points settings.)

Credit goes to the originator Lou Poulas and a host of other update authors who have contributed over the years. I’m pleased to join their ranks and share this latest version that includes my own tweaks and fancy color formatting added over the last couple years.

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

Fantasy Baseball War Room

(Current version V5 March 13 2017: Points, updated Dashboard tiers, big bug fix in prospect rankings on Players tab.  Remember to enable macros when prompted to be able to use “Lock Projections” button on User Input tab.  *Final version for 2017 unless a major bug comes up*)

Fantasy Baseball War Room – COMPATIBLE (“vanilla”)

Any feedback / suggestions / bug fixes?  Please leave a comment below. Good luck with your draft(s)!

 
  1. peacecoast says:
    (link)

    great work dude,

    when I add a player to my team on the Players tab, I thought they would be marked out with a writethrough line or grey out on the Dashboard tab? or was that my own addition last year? It would be some easy conditional formatting.

    • Hot Rod

      Hot Rod says:
      (link)

      @peacecoast: Thanks! Yes there is still conditional formatting on the Dashboard — but instead of being crossed out when a player is drafted, I switched it so that when a player is added to “your” team on players tab, then the dashboard highlights green with bold white text, while oppenents’ players are grey with dotted background. See example screenshot #2 (above). I did this because I find it really hard to read behind a strikethrough line, especially once half the board is drafted and it is just a mess of names and lines. The green makes it easy to see at a glance exactly how high your players rank by each position on the dashboard, and you can still read the names of players who have been drafted already by any team.

      If you want to tweak the formatting for how players show up as drafted on the dashboard, (say if you prefer the strike-through look for players that are gone, or for color-blindness compatibility etc), on that tab there are just 3 simple conditional formatting rules that are easy to modify to your liking. (A more messy conditional formatting list lives over on on the Players tab, I hope to clean up that tab’s rules for a future version but we wanted to get V1 released ASAP)

      • peacecoast says:
        (link)

        @Hot Rod: ya I started unhiding and discovered it, but the rule is not being applied in my case. In fact I am not finding any rule applied to the Dashboard cells?

      • peacecoast says:
        (link)

        @Hot Rod: also this might be quibbling but how do we eliminate all the 0’s in the owner drop down list when the league is only 12 or 15 teams? I tried deleting those cells on the User Input tab but the zeroes persist.

        I love this!

        • Hot Rod

          Hot Rod says:
          (link)

          I never actually use the drop down to click (as mentioned I just start typing team name and then hit enter after excel autocompletes), so I didn’t even see all those zeroes down at the bottom of the list! There is a better way to have Excel make the drop-down list adjust to the number of teams dynamically rather than than just using 25 items all the time by default (= resulting in those zeroes for unused ‘blank’ team names); this is a more complicated fix than simply deleting cells where the list is pulling data from, so please stay tuned for this fix in the next update, thanks.

        • Hot Rod

          Hot Rod says:
          (link)

          @peacecoast: this issue was fixed in a later version, thanks for suggestion

      • Hot Rod

        Hot Rod says:
        (link)

        @Hot Rod: Just tested from different computer and the file as hosted here is working fine for me with the rules all working. Have you clicked ‘enable editing’ at the top of Excel, or any other security warnings Microsoft might throw your way? If you open the file, enable editing, then go straight to the Players tab and type the letter ‘a’ in the blank “owner” column next to mike trout’s name – that should make Trout’s name highlight as green on the Dashboard. You do not need to unhide anything.

        • peacecoast says:
          (link)

          @Hot Rod: ah it might be an issue with my copy of excel, I will sort it out thanks!

          • Hot Rod

            Hot Rod says:
            (link)

            @peacecoast: My build uses the XLSX Excel file format, in Excel 2007 and newer (so the last 10 years). Trying to make the file compatible with the much older builds that use .XLS (‘Excel 1997-2003’) not only strips out a lot of the conditional fomatting for that fancy green colouring etc (vs strikeout conditional formatting, which can be done in .XLS), but it also crashes my Excel just trying to convert it to that older format – probably because that formatting is on nearly every cell in Players and Dashboard. Moral of the story: if your copy of Excel dates back to before Adam Lind was a call-up for the Jays, you might have to stick to the war room’s web version? :)

  2. Pine Tar Incident says:
    (link)

    Awesome man – love this thing.

  3. Test Kitchen says:
    (link)

    Awesome work on this.

    One minor error (about as minor as it gets):

    Under the “Dashboard” tab the heading for the DH players says “SS”

    • Hot Rod

      Hot Rod says:
      (link)

      @Test Kitchen: thanks for this catch, I must’ve hit full paste (instead of just ‘paste-formatting’) when I was doing the dashboard, keeping track of old vs new tiers! Will be fixed for V2.

  4. Ken Plane says:
    (link)

    Hi – I have used this in the past, but this year after enabling everything no tabs of any kind show up

  5. Josh says:
    (link)

    I’m impressed! All this without any VBA. I’ve always wanted to do my own of something similar but never been focused enough to do so.

    I would recommend you protect the Dashboard tab and allow access to everything but the objects if you don’t want us to see your closers/prospects.

    • Hot Rod

      Hot Rod says:
      (link)

      @Josh: good idea, but not really needed as the data under the ‘coming soon’ text for closers/prospects is all from last year, it’s not a spoiler of this year’s rankings. It was just quicker for me to slap a text box over those columns and leave everything intact than to have to protect or hide it. I will be updating the data and tiers for those categories only once new 2017 rankings are released. So all you power users, don’t be peeking under the “coming soon” boxes or you’re at risk of being misled by 2016 rankings! :)

  6. Lake says:
    (link)

    Will we be able to make this NL only. I struggled with that last year. Awesome job though.

    • Hot Rod

      Hot Rod says:
      (link)

      @Lake: yes and no — most of the workbook excluding Dashboard would be decently easy to do this for: the Players tab draws its data from an Import tab and that data would be decently easy to make AL/NL only: if you sorted the original Import data on the (hidden) Import tab, you could delete whatever league you don’t need, and the resulting players that are left should be the only ones who will populate the Players list. Better still, if you hard coded that Import tab before you sorted, you could keep the ranking order so that the players end up ranked in the same relative order as Grey’s total rankings. Then the stats etc would populate to the War Room page too.

      But the Dashboard would not be as easy – it would take a lot of time to make AL/NL only since the names and tiers are all hard-coded (not formula-based linking to the raw data. ), so someone would have to manually take out all the names of the opposite league. It is possible, just time consuming though

      • Hot Rod

        Hot Rod says:
        (link)

        @Hot Rod: (“delete whatever league you don’t need”: by that of course I mean sort by team, then delete teams that are not in the league you want, since the data is not imported with sortable AL/NL tag attached to it, but you could use the team column to sort and pick out the ones you don’t need…definitely hard code that before you co messing around with sorting rows in the Import tab though, it is hidden for a reason!)

  7. mikeisalegend says:
    (link)

    I really appreciate you doing this!

    • Hot Rod

      Hot Rod says:
      (link)

      @mikeisalegend: glad to be of help!

  8. MattyIce says:
    (link)

    Question in a keep forever dynasty league:

    I have the first pick in the first year player draft for the 2016 draftees, the Gurriels, etc. I’ve been offered Greg Bird and the 5th overall pick for my first overall pick. Is that enough value to slide back 4 slots? I wanted Senzel but may be willing to take Bird plus #5. Your thoughts? Thanks in advance.

    • Hot Rod

      Hot Rod says:
      (link)

      @MattyIce: Personally, I think take Bird and the 5th but I am a sucker for not wagering on the 1st overall for prospects…I’m sure 5th plus Bird is still going to look decent on your books. Especially because with prospect drafts you might still get your 2/3/4th top player with that 5th pick anyhow since you never know who someone likes more, it’s not like the top 5 of a regular draft where you are guaranteed to see Trout / Kershaw / etc. all going quick. Besides, “A Bird in the Hand…”

      In all seriousness I think this is a case of someone getting cold feet on Bird’s playing time with Carter coming in but Bird is likely the 1B of the future whereas carter is just a 1 year deal who could be moved by the deadline anyhow.

  9. swaggerjackers says:
    (link)

    This is a pretty cool tool. I tried it a couple years ago and really like the real time data. As you mentioned, the toughest part is keeping up during the draft – especially if people are drafting quickly and you happen to have the wrap around pick in a snake draft. Sadly I found that keeping up with crossing off all the players was somewhat stressful and took away from the fun of actually drafting. I have enough stress when all the guys in my queue :)

    If time allows, plugging in all the team data after the draft is a nice pat on the back though.

    • Hot Rod

      Hot Rod says:
      (link)

      @swaggerjackers: on the pace of drafting: it’s a tough spot to be in because if you spend time inputting other team’s picks you don’t have time to look ahead at your needs, but on the other hand if you fall behind then inevitably you go to grab a player and then realize he got drafted and you forgot to update the spreadsheet.

      last year my strategy, probably to the annoyance of my leaguemates, was to use my full allotted draft time – usually I would figure out who I was drafting in the 10-20 sec, queue them for auto-pick, and then spend the rest of the time catching up on past picks (if I was behind). Really it is one of the only strategies to keep up when you have leaguemates who are disinterested and turn on auto-draft which whips through picks in a hurry (especially mid to late draft when the less keen check out)

      anyhow I love and am proud of the new green highlighting (delivered by the new XLSX formatting options) because it really makes it way easier to scan the dashboard at a glance when you are pressed for time to make a pick.

      • swaggerjackers says:
        (link)

        @Hot Rod: Good call with milking the clock. It might be annoying for some but others will appreciate the time to catch up with their own drafting adjustments. Picking fast in the beginning is somewhat expected but as things move along, anyone serious about the league wants a few extra seconds to scan through available players, queue up their next batch, take a look at how other teams are shaping up, etc.

  10. BigRedLatrine says:
    (link)

    This guy, this guy right here.

    You are a gentleman and a scholar. Thanks for carrying the torch on this!

    • Hot Rod

      Hot Rod says:
      (link)

      @BigRedLatrine: high praise, much appreciated!

  11. Jake says:
    (link)

    We do an email draft that lasts several weeks. It feels like I’m straight up cheating to use this tool. Thanks so much!!

    • Hot Rod

      Hot Rod says:
      (link)

      @Jake: you are welcome! You have loads of time to plug in all the picks then, lucky you…no scrambling to switch tabs while the ESPN klaxon counts down!

      • Mike says:
        (link)

        @Hot Rod: Exactly. Any chance this could be modified in the future so it’s easier to look at every teams roster in real time?

        • Hot Rod

          Hot Rod says:
          (link)

          @Mike: like have it linked to ESPN etc? I don’t think that functionality is possible. If it is possible to scrape data from the ESPN drafting widget in a web browser, it is beyond my excel powers for sure!

  12. SixthGear says:
    (link)

    Thanks for taking care of this.

    • Hot Rod

      Hot Rod says:
      (link)

      @SixthGear: no sweat!

  13. Milarky says:
    (link)

    I am really excited to try this out. I do an in-person draft with a bunch of old friends for this, and I have always been faithful to the Razzball projections but have to use my own frankenstein concoction of spreadsheet tabs. I really look forward to trying this out.

    One question – our league has strange position rules – can I add in my own customized positions to replace the ESPN ones that are in there? I admittedly haven’t looked at the tool yet, but thought I would ask in advance.

  14. JD Hassett

    Otwins says:
    (link)

    Very Nice
    Thanks for all your work

    • Hot Rod

      Hot Rod says:
      (link)

      @Otwins: you are most welcome!

  15. LenFuego says:
    (link)

    First, terrific job on this and I look forward to the other data updates (like closers) and any other upgrades.

    Second, one minor quibble: You have room for 25 teams on the User Input sheet, but the top table of the War Room sheet only has room for 22 teams. I manually added a couple of additional rows at the bottom and everything seems to work, so I think the fix is that easy.

    Finally, this may apply to very few leagues, but you might think about a way to allocate players to a team that do not apply against the salary cap or total players taken. I am in a 12 team league that has 23 starting players which are selected by auction and 18 supplemental players which are selected by a draft once the auction is complete (and after a pizza and beer break of course!). We are allowed up to 7 regular keepers and up to 5 supplemental keepers (only players that never got moved to your starting lineup the previous season are eligible as supplemental keepers). The supplemental keepers count against only your supplemental roster – i.e., they do not count toward the 23 starting players in the auction and do not count against your salary cap. So while I do want all the protected supplemental players to appear as taken in the Players and Dashboard tabs, I do not want them or their salary to count against the tables in the War Room. (My somewhat viable workaround for this is that I have included 24 teams rather than the actual 12 in the league, with each franchise having a regular team name and a “supp” team name – e..g, I have included for my team both a “Deplorables” and “Deplorables supp” teams – then all my auction picks and keepers are on the “Deplorables” roster and all my supplemental keepers are on the “Deplorables supp” roster.)

    • Hot Rod

      Hot Rod says:
      (link)

      @LenFuego: thanks for the praise and comments! Good catch on the 22 v 25 teams, that error appears to have been in place dating back to at least last year’s war room (and likely earlier!), I guess you are the first person in Razzball history to try to load more than 22 teams into the sheet, partly due to your other issue discussed below. I will fix for future, you are right that you can add a couple rows without affecting anything else, and the other stats on the bottom of that page are all 25 rows already.

      On your other point about drafting non-salary players etc – I think the best workaround is what you have suggested – to make an alternate team for each. Just draft those supp players with zero salary and it should be fine. That way they are not entering your ‘main’ team’s stats in the war room tables too.

  16. Duda Want to Build a Snowman? says:
    (link)

    This is beautiful. Great job. Love the Ace Index.

    • Hot Rod

      Hot Rod says:
      (link)

      @Duda Want to Build a Snowman?: me too, I’m proud of that — it is great to be able to sort by that column and find some hidden gems – especially for your mid to late round pitchers.

  17. Humm Baby says:
    (link)

    This is even better than the last couple years, thank you. We do an in-person draft, so it’s a little easier to use this tool than in an online draft. Quick question – is there a way to move the bottom tabs, so that the “dashboard” and “players” tabs are directly next to each other. Sorry, I’m an excel novice.

    • Hot Rod

      Hot Rod says:
      (link)

      @Humm Baby: you’re welcome! Yes, you you can move the tabs around to your heart’s content, it doesn’t break any formulas etc. (click and hold on the tab name, drag until you see the little black arrow show where it is going to go, and then release your mouse button). If that doesn’t work for whatever reason, right click on the tab and choose “Move or Copy” and select which tab you want it in front of and then hit OK.

      • Humm Baby says:
        (link)

        @Hot Rod: Thanks! Figured it out.

  18. Akash says:
    (link)

    Great Work!

    Any idea when the points rankings will be available?

    • Hot Rod

      Hot Rod says:
      (link)

      @Akash: not sure, but when they are out I will try to have this updated as soon as I can, thanks.

  19. Jason P. says:
    (link)

    Thanks so much for this! I can’t use this at my auction, as it’s online and goes too fast, but I do use it once our keepers are picked and I can see where I am struggling and help me price out bids. That, and changing the projections is a bear. But this is a great tool.

  20. Five-On-One says:
    (link)

    Thanks for all the work on this. I have a question about the dollar values in the war room, not sure you are the right guy to ask, but I thought I would try you first.

    There are only 66 pitchers with non-negative dollar values. A 12-team league would require 108 (12×9) pitchers to be bought.
    Similar for the hitters, there are 119 hitters with a non-negative dollar value. A 12-team league would require 168 (12×14) hitters to be bought.
    Why is this?
    Lastly, adding up all of the positive dollar values, gets $2872, when one would expect $3120 (12×26).

    Is there a fundamental flaw in the dollar values in the war room, or (more likely) am I missing something?

    Either way, thanks for all the work.

    • Hot Rod

      Hot Rod says:
      (link)

      @Five-On-One: not sure – the dollar values are being pulled automatically from Grey’s rankings, but I haven’t double checked the legacy formulas that tallied up salaries etc, will have a look.

      • Five-On-One says:
        (link)

        @Hot Rod: Still having the same issues with the dollar values in the War Room. It looks like the Grey Auction Value Rankings have the same issue. What is the best way to fix this issue? Hard to use this tool without good auction values.

        • Hot Rod

          Hot Rod says:
          (link)

          @Five-On-One: Yes this issue is still known and in the list to fix; I will try to look at this over the next couple days. Had to add all the prospect stuff and fix some other formulas this go around but hopefully will have a solution for V4 (still would like to add JB Pitching, keepers, and Points rankings if possible)

  21. The Lurve Guru says:
    (link)

    You have the DH category listed as SS in the dashboard tab. Minor fix, just wanted to let ya know! Thanks for putting it together.

    • Hot Rod

      Hot Rod says:
      (link)

      @The Lurve Guru: known issue, will be fixed for V2. thanks!

  22. LaMar says:
    (link)

    Does it work with Mac

    • Hot Rod

      Hot Rod says:
      (link)

      @Five-On-One: @LaMar: I have not tested for Mac, if you have Office/Excel for Mac give it a go and let us know how it works (or maybe another razzball user here has tried it in Mac and can chime in?)

      • Lamar says:
        (link)

        @Hot Rod: It won’t open

        • Hot Rod

          Hot Rod says:
          (link)

          @Hot Rod: @Lamar: sorry to hear that. Do you have Excel for mac installed, or is it trying to convert it to fit another spreadsheet program? Is it giving you a specific error message? I am going to try tinkering with some compatibility next week, but not sure if all the features of the spreadsheet carry over to other programs. In the meantime be sure to check out the web war room page linked from http://razzball.com/fantasy-baseball-war-room-2017-edition/

          • Lamar says:
            (link)

            @Hot Rod: yeah I have excel for mac not sure of which version I’ll check when I get home.

          • LaMar says:
            (link)

            @Lamar: @Hot Rod: My excel is for mac 2011 version 14

            • Hot Rod

              Hot Rod says:
              (link)

              @LaMar: I am going to attempt to make a version compatible with older Excels like this but want to do it only after I have all the data for rankings so I don’t duplicate the effort the next time the new data comes out. Just waiting on JB Pitching, keepers, and Points. Stay tuned to this page! Thanks.

        • Hot Rod

          Hot Rod says:
          (link)

          @Lamar: just posted a ‘compatible’ version – try it and hopefully it works on your machine. It doesn’t have the bells and whistles, though, see my comment below for more on this.

          • LaMar says:
            (link)

            @Hot Rod: got it, it opened and it’s working

            • Hot Rod

              Hot Rod says:
              (link)

              @LaMar: glad to hear, enjoy!

  23. Travis says:
    (link)

    What are the chances that future updates will include customizable leagues? I play in a 6×6 with OBP and QS.

    • Hot Rod

      Hot Rod says:
      (link)

      @Travis: it is possible but would take some tweaking. Right now rankable stats are fully based on Grey’s projections (except Ace index), and Grey’s doesn’t project OBP and QS. HOWEVER, those stats that you mention ARE stats projected by Steamer and carried on the site here for 2017 projections. (http://www.razzball.com/steamer-pitcher-projections -AND- http://razzball.com/steamer-hitter-projections) So technically since I have the full import from Steamer already loaded in the war room for pitchers, to do the ‘ace index’, that means the QS data is being imported into the spreadsheet along with dozens of other Steamer projected stats that aren’t used on Players tab right now. But, I haven’t made the sheet go grab Steamer hitters data in a similar manner so would have to add that. And one would have to add OBP and QS as columns in the Players tab.

      So yes, there is more data that can be added to this, if one were to expand the ‘stats’ component to non-grey data (while keeping Grey rankings, which doesn’t really jive since his rankings are based off his data!) But it would take more work for sure. And someone else might say they want Holds or OPS or blown saves or whatever…

      one option I can think of would be to import ALL the data from steamer to the sheet, and add those categories as hidden columns on Players tab and then people can unhide the Steamer stats, pick the data they need, and hide the rest again. But setting this up would take quite a bit of time to do — add the data, link it, test it, make sure it doesn’t break the rest of sheet, etc. I am intrigued by the idea but am not sure I will have time to implement it this season – when is your draft date? Thanks for the idea.

  24. BRIAN ENGLAND says:
    (link)

    Thanks Love this excel file.
    How do you add players? And than when added make them show up on the dashboard?

  25. CTP-O says:
    (link)

    Great work on this! I look forward to the day the war room comes out like my kid looks forward to Christmas!

    One question I have…is there an easy way to combine the hitters and pitchers (and their stats) into one table on the ‘Players’ tab and still keep the functionality elsewhere? I’ve managed to combine them into one table using vlookups, but noticed now that there are a couple issues with the ‘war room’ and ‘dashboard’ tabs working as intended. Thanks for the help!

    • Hot Rod

      Hot Rod says:
      (link)

      @CTP-O: no there is no easy way to combine them – they have been separate tables for the last several years (for all time possibly?). As you point out the war room and dashboard point to each table (hitter/pitcher) separately for their data.

      If all you need is the Players and Dashboard tabs, and you don’t need the war room stats, it is a little easier – on Dashboard just unhide the columns to the right of SP/Closer/Prospect SP) and have the formulas there fetch their data from the new ‘master’ table that you created with Vlookups…then at least the dashboard will cross off appropriately. But it would be more work to tweak all the war room stats to point to that new table (though could maybe try a replace-all in the formulas, pointing to your master table instead of the Pitcher table??? there are options and if you can handle Vlookups then you probably have the skillset to delve into this!)

      • C-TPO says:
        (link)

        @Hot Rod: thanks Hot Rod. I’ve been slammed and haven’t had a chance to play around with it, but once I get some free time I’ll try the replace all that you mentioned (hopefully before actually having to draft).

        I’ve found the most useful check for me live during the draft is the ‘war room’ tab (aside from the players tab) as it allows me to quickly gauge where I am compared to other teams, my goals, etc.

        Anyways, thanks again for all the hard work on this!

  26. Giants_Fan says:
    (link)

    This is awesome! Thank you

  27. Hot Rod

    Hot Rod says:
    (link)

    V3 of the excel War Room has been posted above, now featuring Ralph’s prospect rankings on Players tab and Dashboard (and new dashboard “ETA-by-year” tiers for drafting keeper leagues vs redrafts!) Some bug fixes and feature suggestions added too (e.g. drop-down list only uses actual teams, no zeroes); please check Notes tab for changelog and known issues before commenting here. And if you are one of the few people having issues opening file (possibly due to older excel versions not playing nice with conditional formatting of .XLSX), please hang tight – I hope to do a ‘Compatible’ version shortly that is usable on older Excel versions!

    • Panko says:
      (link)

      @Hot Rod: That “compatible” version would be greatly appreciated… I’ve been using the War Room for years, was really looking forward to seeing this year’s updates– but can’t seem to open it any other way than “read-only” (on Macs, with 2008 Excel)….

      • Hot Rod

        Hot Rod says:
        (link)

        @Panko: just posted a ‘compatible’ version – try it and hopefully it works on your machine. It doesn’t have the bells and whistles, though, see my comment below for more on this.

  28. Longbeachyo says:
    (link)

    Absolutely amazing!
    Not that I want to pay, but I am kind of shocked that there is not some sort of small fee for this. I would pay $4.99 or something for sure if I had to. Great work man!

  29. LenFuego says:
    (link)

    Still loving every cell of this, Hot Rod!

    I think all the Razzball rankings have been released now, but it is not clear to me whether they are all implemented in the spreadsheet. Are there any more updates coming? If so, do you have any estimate of what will be added and when?

    The reason I ask is that at some point I am planning on adding an extension or two of my own for my auction (e.g., my own salary values based on calculations I make based on my league’s rules), which will be non-trivial for me to do (at least at my level of Excel), but I do not want to do that until I know no more Razzball goodness will be added.

    Thanks!

    • LenFuego says:
      (link)

      @LenFuego: BTW, there seems to be an issue with the “Your Selected Players” table on the “War Room” sheet – the pitchers show up just fine, but the batters are not showing up.

      • LenFuego says:
        (link)

        @LenFuego: For this issue, I think cell W3 on the Player page needs to be changed from “=U3 + V2” to “=U3”. (That cell starts the count – there is no number in cell V2 to add.)

        • LenFuego says:
          (link)

          @LenFuego: Oops – I mean cell V3 should make that change, not cell W3.

      • Hot Rod

        Hot Rod says:
        (link)

        @LenFuego: good catch! not sure how that formula got messed up since last year’s sheet but way to go hunting that bug fix amidst the hidden columns! Yes you are correct changing that first cell of V3 to just =U3 does fix this, I will have this implemented for next version too. Thanks so much!!!

    • Hot Rod

      Hot Rod says:
      (link)

      @LenFuego: Thanks for the praise! Yes there is one more update coming, should be out sometime this week.

      • Hot Rod

        Hot Rod says:
        (link)

        @Hot Rod: make that ‘at least’ one update. a new version with JB’s pitching ranks and Keeper ranks will be out later this week. Points league stuff would be added in a separate update. Thanks.

  30. Hot Rod

    Hot Rod says:
    (link)

    To anyone that had issues with the file this year: I worked up a plain ‘vanilla’ version that is simply last year’s file with the 2017 data and 2017 tiers. No bug fixes, formatting changes, or additional ranking categories (Prospects/Keepers/JB/etc) in it. You will find the ‘compatible’ file at the bottom of original article; hopefully this should fix issues a few of you had.

    That being said, I still encourage you to upgrade to the ‘main’ version. If you have an older version of Excel that can’t handle the file, a 1 month free trial of Office 365 (https://products.office.com/en-us/try) will see you through MLB opening day at no cost, and should open the file without issue. Aside from the newer and nicer formatting there are bug fixes in the main version, plus all the aforementioned additional rankings (keeper/JB/prospects/etc)

    The next update of the main file, with keepers and JB’s pitching rankings added, will be out later this week.

  31. WhatWouldTebowDo says:
    (link)

    You da man, Hot Rod! One quick question – I have the unenviable task of drafting for another team in my league who cannot participate in the draft. Is there an easy way to set up a different color coding for that second team I draft (maybe red shading) just as you did with the green for my team? Thanks!

  32. Humm Baby says:
    (link)

    When I refresh the data, the Players tab updates the rankings, but the Dashboard does not. Is there a way to update the Dashboard as well? Thank you.

    • Hot Rod

      Hot Rod says:
      (link)

      @Humm Baby: unfortunately no, the dashboard does not update automatically as it is hard coded due to being based on Grey’s tiers not the raw data table. BUT…lucky for you I have been hard at work, updating the dashboard and keeping up with (hopefully) all of Grey’s changes. The next version of the spreadsheet V4 will have the dashboard updated with tier changes. Stay tuned, should be posted here in the next day or so as V4, with some new rankings in it too! (note that only the main spreadsheet is being updated from here on out, the compatibility sheet will not be updated again this season)

      • Humm Baby says:
        (link)

        @Hot Rod: You are the man, thanks!

  33. Hot Rod

    Hot Rod says:
    (link)

    Version 4 has now been posted. Dashboard updated w/ Grey’s spring training tweaks; keeper rankings and JB’s pitcher rankings added as sortable categories on Players tab.

    **NEW FEATURE: I’ve added a single big blue ‘UPDATE’ button on the User Input tab – click this to lock projections data for the year. Save yourself the copy-paste hassle that could break formulas, and instead let this magic button do all the work (technical note: be sure macros are enabled – click to allow on whatever security prompt excel throws at you). Only click it when you are absolutely ready to lock the data and rock your draft (lock and rock?) Note file type is now .xlsm due to having this embedded macro in file, but should open in Excel just fine like .XLSX files…any issues post a comment here. Enjoy!

    • Hot Rod

      Hot Rod says:
      (link)

      @Hot Rod: to clarify: the button is not called ‘update’ but I’m sure you can’t miss it….look for the blue box called “Click here to lock projections data”

      • LenFuego says:
        (link)

        @Hot Rod: Terrific, Hot Rod. I assume this is the final version, unless there are any bugs. Or do you intend to update with further Grey spring training tweaks?

        • Hot Rod

          Hot Rod says:
          (link)

          @LenFuego: yes – assume this is the final version. I might do a Points version (w points ranking as sortable category) next week, but for Roto this is it (unless someone points out a crazy sheet-breaking bug). Drafts are starting now anyhow.

  34. The Dude says:
    (link)

    hi Hot Rod,
    Thanks for getting this put together this year. One question. I’ve downloaded the latest version and exposed the Salary columns on the players tab, then done a Data>Refresh All, but no salary information was populated before or after the refresh. Any ideas? Thanks!

    • LenFuego says:
      (link)

      @The Dude: The Salary column is an input column for use in auctions (or other formats where a player has a salary). When a player is auctioned, you enter the team that won him in the Owner column, and the winning bid amount in the Salary column – that data will feed some of the tables in the War Room sheet.

      • The Dude says:
        (link)

        @LenFuego:
        Thanks. I see now, and I will use it in that way.

        However, I seem to recall previous iterations including a salary column along with the ranking column. This is useful in determining value amongst tiers and across Pitchers/Hitters.

        • Hot Rod

          Hot Rod says:
          (link)

          @The Dude: the salary projections are there for the Players tab — see column “L” for hitters and “AO” for pitchers (this is separate from you unhiding the salary input columns H and AK respectively)

          I have not seen salary added to the Dashboard tab, at least in the few years I have been using the sheet. This is an interesting idea, I like the idea of trying to find value among tiers. Could be an idea for an ‘auction’ dashboard for next year.

  35. Stephen King says:
    (link)

    Hot Rod, I am trying to download this War Room. I had it, ran a data update and everything was off. Players were assigned to dynasty teams they did not belong to. I deleted my file. I am able to open other excel files I have. I have tried to download your latest War Room several times today and everytime I attempt to open it, it tells me the files are corrupt and cannot be opened. I have run my virus protection and do not have anything like that on my machine.
    Do you have any suggestions? Advice? Thank you. I have an earlier version of it on a tablet, but would like the new version on this laptop for a draft this coming Saturday. Thanks!

  36. Dave says:
    (link)

    I changed the points values to my leagues stats, but I don’t see the points projected on the war room tab. I see a roto scoring but not points. Thanks.

    • Hot Rod

      Hot Rod says:
      (link)

      @Dave: hi – at present the “points version” is a bonus edition that is primarily based around the Players tab, as it uses the league scoring system to generate rankings for the Players tab for drafting. It does not pull the points values for players on each team and tally them by fantasy team in the war room, but that is a good suggestion for next year’s version, thanks.

  37. Zach says:
    (link)

    is it possible to get updated $ values for different league settings? i.e 16 team with OBP and QS instead of BA and W

Comments are closed.