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.)

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

    Thanks again for all your hard work!

    • gobiggreen says:
      (link)

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

      • Grey

        Grey says:
        (link)

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

          • Grey

            Grey says:
            (link)

            No problem

  2. Harry says:
    (link)

    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.

    • Hot Rod

      Hot Rod says:
      (link)

      @Harry: you’re most welcome!

  3. Bryce Krispie Treats says:
    (link)

    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.

    • Hot Rod

      Hot Rod says:
      (link)

      @Bryce Krispie Treats: I don’t handle tech support for the other war rooms on the site, just this file, but for what it’s worth the online war room (https://razzball.com/war-room/) works for fine in my browser, running Firefox 65.0.1; sorry to hear you are having issues.

  4. Perfect Game says:
    (link)

    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?

    • Hot Rod

      Hot Rod says:
      (link)

      @Perfect Game: hi welcome to the game of fantasy baseball! This is not integrated with ESPN or Yahoo etc., it lives on its own in Excel separate from the browser you will be drafting in.

      There is no way to import these stats or rankings automatically. If you wanted to go to the effort you can technically change your pre-draft rankings on many of these sites. Personally I do not think it is worth the time to do that. Just keep this excel sheet open during your draft and keep updating it with picks as guys get drafted . The good players at the top of your Razzball war room file will show as available in excel, and then search them by name and draft them. Hopefully at the same time your counterparts will be drafting the duds you don’t want and they will be removed from the board anyhow.

      I would suggest you do a mock draft in ESPN and use the war room at the same time, so you can get a feel for both the draft situation and switching between draft room and war room.

  5. Asst2RegionalMgr says:
    (link)

    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.

    • Hot Rod

      Hot Rod says:
      (link)

      @Asst2RegionalMgr: Cool! I’m always interested in seeing people’s tweaks, you can post a link here or send an email to: jimmybond009 at gmail.com.

  6. Mike says:
    (link)

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

    • Hot Rod

      Hot Rod says:
      (link)

      @Mike: good question honestly I don’t know,. When I took over updating it I kept all the auction features from previous iterations but I don’t have any auction leagues so I haven’t put that side through it’s paces. Any power users who have used the war room to draft for auction leagues want to chime in? Thanks!

    • LenFuego says:
      (link)

      @Mike:Unfortunately, they do not.

  7. Ghost of Grady Little says:
    (link)

    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!

    • Hot Rod

      Hot Rod says:
      (link)

      getting pretty nerdy going hunting for those hidden tabs… :) Answer is “it depends but probably yes”. You can technically use any of the stats already downloaded from Razz, and all the categories you have asked about are in there (but some aren’t like Blown Saves, etc). You would find the raw data you want mainly in the HIT and PITCH tabs. However, as the Players tab isn’t directly connected to data on those tabs, it all funnels through the IMPORT tab first and that place is the key for the changes you would do (see example below). Ideally you could take a column you don’t use on the players and Import tabs and change them, rather than adding columns because that tends to mess things up (especially the formatting on Players). E.g. If you don’t use Points now there are several columns you could repurpose.

      **************
      For example: Let’s add Quality Starts for pitchers to the Players tab. Right now, Players columns AP/AQ/AR are being driven from Import columns AX / AZ / BA. So we can use one of these without messing up the sheet and adding columns – let’s swap in Quality Starts into Players AP and thus Import AX…right now Import AX is pulling its data, total fantasy points, from Pitch tab. It is referencing the 35th column to the right of the player names in my data over on Pitch (35th column on Pitch is column AJ). On the Pitch tab, Quality Starts are listed as column 8 to the right of the player names. So, the formula we are going to edit to grab the new data and display it on Players is the formulas in the Import tab. Change the formulas in Import column AX to reference column 8 instead of 35 within that pitcher data range, and it will pull QS (e.g. use formula “=IFERROR(VLOOKUP($X3,PITCH!$B$182:$AP$2000,8,FALSE),0)” in cell Import!AX3 and note the 8 instead of 35 before the ‘FALSE’ at the end meaning we are now grabbing data from that 8th column instead of 35th). Then copy that formula down the whole column. Lastly, change the name of column headers for Import AX and Players AP so you know what the heck the data set is you are looking at. At the end, you will see that the Players AP tab now uses the Quality Starts data. Use same type of approach to pull other data (OPS is column 27 on HIT data range, HLD is column 14 on PITCH data range, etc.)

      It isn’t easy, but once you know your way around and how the tabs are interconnected it is totally doable.
      ***************

      Hopefully this brief look under the hood was an eye opener about the time that goes into updating this each year with the latest stats for Razzball’s adoring audience. But I can’t personally draft without it, so I may as well do it for the good of us all! ?

      • Ghost of Grady Little says:
        (link)

        @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.

        • Hot Rod

          Hot Rod says:
          (link)

          @Ghost of Grady Little: no problem! my reply is admittedly dizzying in its own right, as I look at it again…but makes more sense with the spreadsheet open, looking at the formula bar! :)

  8. Johnnyhobbes says:
    (link)

    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

    • Hot Rod

      Hot Rod says:
      (link)

      @Johnnyhobbes: I can’t replicate that error. If you are sorting pitchers by points league rankings, make sure you are be clicking the dropdown arrow inside Players tab cell AP2 (“PTS_TOT_RANK”). In my version of excel when I do that, the first two options that pop up in the context menu are ‘sort smallest to largest’ then ‘largest to smallest’, and if I click the first one (small to large) it sorts appropriately. What version of excel?

      • johnnyhobbes says:
        (link)

        @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.

        • Hot Rod

          Hot Rod says:
          (link)

          @johnnyhobbes: ok, if you still have issues can you send me your copy of spreadsheet to jimmybond009 at gmail.com and maybe take a screenshot showing it too? Thanks!

        • Hot Rod

          Hot Rod says:
          (link)

          @johnnyhobbes: Ok I looked at it more. For some reason some of my ranking columns are GENERAL and others NUMBER format. Specifically for what you are trying to sort, PTS_TOT_RANK is set as format ‘general’ while PTS_Total_PTS and PPG beside it are both ‘number’ (?!?) Not sure how that happened as most of the other ranking columns are all Number, but anyhow…my version of excel still sorts appropriately, but if yours is acting up try this to fix it:

          – Highlight column AP, right click and FORMAT CELLS,
          – choose category ‘Number’ at left, and set decimal places to zero at right,
          – then click ok….hopefully that fixes it.

          In fact, you could even do this for all of columns A to K and AK to AR . Bulk select them to change all those columns to numbers with zero decimals first, then fix the PPG columns afterward to be 1 decimal place instead of zero.

          Let me know if this works for you. If it doesn’t break things for me to convert all of them over to number I will aim to do that for next version

          • Johnnyhobbes says:
            (link)

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

            • Hot Rod

              Hot Rod says:
              (link)

              @Johnnyhobbes: I did some testing here and it seems to work ok for me, hopefully it solves your issue. It may still say sort alphabetically though even if they are numbers…let me know what happens.

  9. JD Hassett

    JD Hassett says:
    (link)

    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.

    • Hot Rod

      Hot Rod says:
      (link)

      @JD Hassett: You are welcome! and you are not alone – I definitely don’t use the war room tab ‘live’ in the draft. I basically spend my whole draft flipping between Dashboard and Players. Sometimes I will even set up my monitor so that right half of monitor is my ESPN or yahoo window, and left half is excel which is split into windows so top (upper left of monitor) is Dashboard tab and bottom (lower left of monitor) is Players tab, so they are all open at same time. This really works on my 24″ widescreen, but probably does not work on a small laptop screen.

      My biggest issue is keeping up with data entry for sure. Most of my leagues are 45sec picks, snake mode, so a couple people going auto-draft for a bathroom break or lack of interest means the ESPN bot picks 4 guys in a blink instead of the 3 minutes that could otherwise take.

      Also – my leaguemates don’t know this but during the draft I am almost always ready with a pick when my turn comes around bu I will almost always use my full time… not to find a name but to go back and enter some picks I missed that round into the spreadsheet ;) just make sure you have your actual choice already queued up to auto-pick for when the time is up.

      I think the key is really having a few guys already in the queue before you start. When I enter the draft lobby I spend some time pre-loading a bunch of my favorites and prospects, not just stars but guys farther down the list. That way the if time expires the auto-pick will always be using someone I selected rather than ESPN auto-choice. You just need to be prepared for a lot of beeping when guys come off the board, that’s like the siren song of March. :)

  10. The Scrant Dog

    The Scrant Dog says:
    (link)

    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!

  11. knucks says:
    (link)

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

    • Hot Rod

      Hot Rod says:
      (link)

      @knucks: I appreciate the help doing the first pass on tiers, Knucks, thanks to you too!

  12. Jason P. says:
    (link)

    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.

    • Hot Rod

      Hot Rod says:
      (link)

      @Jason P.: Yes, here is me quoting me with cell reference updated for 2019:
      “yes, this is definitely possible if you have some Excel expertise. To start, I would lock projections (use the handy macro button I provided) as this will eliminate the data connections to import projections from the web. NEXT IS FOR PROS ONLY: Unhide the IMPORT worksheet, and change your stats on there. The data from Grey’s projections right now is from [2019: IMPORT B3:R575, as of v1 2019 it goes to Tony Wolters]. I added extra prospects after so they can be draftable, but as you will see they have no Grey stats. Anyhow – I would suggest to you set up your own projections in a similar column order like outlined in IMPORT B2:R2. Then you could just copy paste to that data over to B3:R575 (maybe paste values, to be safe), and now the workbook will pull your stats into the Players tab. Or if you just want to tweak certain players, use what is already there and just edit it. **Note that the tiers on the Dashboard tab will not be updated with your rankings as they are hard coded.”

      for 2019 I would add: the above assumes you only want to be updating projections for the main categories Grey uses. These are the only ones displayed and sortable on the Players tab, and that data is pulled from B3:R575 on Import tab. If you want to project more exotic stats like QS, HLD, etc., you could manually edit those those projections under their columns on the HIT/PITCH tabs, reference them on Import, and then pull them into Players like I suggested for the other commenter above. But that is way more work. I really would try to use the columns and categories already in place on the Import tab. If possible, just change values (pure numbers) and don’t change formulas or add/remove columns anywhere.

      • Jason P. says:
        (link)

        @Hot Rod:

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

        • Hot Rod

          Hot Rod says:
          (link)

          @Jason P.: then I would say just lock projections first and then go to town on tweaking ‘Import’ columns B to R with your own data…enjoy!

  13. Pine Tar Incident says:
    (link)

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

    • Hot Rod

      Hot Rod says:
      (link)

      @Pine Tar Incident: your kind comments are much appreciated, you’re welcome!

  14. Plesh says:
    (link)

    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.

    • Hot Rod

      Hot Rod says:
      (link)

      @Plesh: you’re welcome! Glad to be of help.

  15. Mike says:
    (link)

    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?

    • Hot Rod

      Hot Rod says:
      (link)

      @Mike: Don’t be shy folks, we can still improve this by crowdsourcing from Razzball commenters!

    • LenFuego says:
      (link)

      @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.

      • Hot Rod

        Hot Rod says:
        (link)

        @LenFuego: Len just so you know I will have a v2 with minor fixes etc by the end of the weekend, if you can hold off on your changes til then.

        • LenFuego says:
          (link)

          @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.

  16. Mike says:
    (link)

    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?

    • Hot Rod

      Hot Rod says:
      (link)

      @Mike: the stats come from various sources. If you unhide the tabs Hit / Pitch / OPS / OBP, at the top of each data set I tried to include the URL where they are grabbing the data, though for Import apparently I forgot and for OBP I listed the wrong link (but the data is correct in both!) For Import, it is the Grey projections.

      While there are a lot of projections available here on Razzball, here are the various sources this excel War Room is using:
      Import (main stats + rankings): https://razzball.com/projections-grey
      Hit (for points calculations only): https://razzball.com/steamer-hitter-projections
      Pitch (for points calculations only): https://razzball.com/restofseason-pitcherprojections
      OPS (for OPS ranks only): https://razzball.com/playerrater-preseason-espnmlb12-6X6OPS
      OBP: (for OBP ranks only): https://razzball.com/playerrater-preseason-espnmlb12-6X6obp

      • Mike says:
        (link)

        @Hot Rod: Thanks!

      • LenFuego says:
        (link)

        @Hot Rod: Hi Hot Rod. Thanks for doing this again for this year. I made a bunch of changes to my copy of this spreadsheet for use in auctions last year – I did not share them because many of them were peculiar to my particular league and situation. I am looking at making similar changes this year and if I do I am going to try to make them useful more generally so that I could share them with you for potential incorporation into the spreadsheet for at least future years (if not this year).

        It would be really helpful if you could point out to me where in the spreadsheet you do the import from Grey’s projections. I have unhidden most of the sheets (including IMPORT, HIT and PITCH), and expected to find cells with formulas that referenced a Razzball web page with Grey’s projections, but I cannot seem to find any.

        • Hot Rod

          Hot Rod says:
          (link)

          @LenFuego: Hi Len! The Grey projections are pulled in on the Import sheet. It is not using a formula, technically it is a web query that goes and grabs the whole web page on Razz and then copies it into excel. Brute data scraping, for columns B to K, from Trout down through the last player before my extra prospects (so row 575, Tony Wolters in the current version) It pulls the headers too, so in this version v1 you can trust that Grey data is in Import B2 to R575. Note that it is a dynamic query so if Grey adds a guy to his stats tonight, then upon refresh it would bump the data set to extend to row 576 or if he removes a guy it might shrink to 574, etc. but it will only do that if you click to refresh existing connections like in the instructions. If you lock projections that will not happen again. There are roughly 40+ more guys being rated this year (good job Grey!) because last year I think the prospects started around ~530 or so.

          On HIT/PITCH/OBP/OPS I am doing a similar simple query for the data sets but I left the website header info in (or at least largely hid it by grouping rows) On Import it is more cleaned up since I do a lot more on that tab and didn’t want all that stuff cluttering up the page. OCD even though no one sees it except the nerds who unhide worksheets! :)

          I’m always up for new suggestions, feel free to share your copy to jimmybond009 at gmail.com when it’s ready

          • LenFuego says:
            (link)

            @Hot Rod: Thanks for the quick response and info, Hot Rod. That was very helpful. After some investigation and experimentation, I think I see how you are importing the data.

            One question (for now): I noticed that for the PITCH sheet, for example, you seem to have added some extra formula calculations in columns at the end (between columns AD and AL). If Grey adds or subtracts a few pitchers to his stats, what happens to the cells in those columns? Do they just get seemlessly updated? Will the formulas in those columns also be applied to the new pitcher rows? (Also, would the same answer apply if I add some calculations at the bottom of rows? Would those be negatively affected if Grey adds some additional pitcher entries?)

            Thanks!

            • Hot Rod

              Hot Rod says:
              (link)

              @LenFuego: yes I have added extra formulas to derive the points rankings and my ‘ace index’ calculations. if they add or remove players it changes the rows not the columns. if they added or removed a CATEGORY of stats, then it affects the columns, but I think it would bump my formulas over (the same as if they add players to the Grey stats; when this happens it doesn’t overwrite my Prospects on Import it just expands the full Grey range of players and then the Prospects start after that) As to whether new *rows* have the formulas, the answer is yes (unless they got added to the very end, maybe not then), I haven’t ever seen it where I hit update and then there is a gap in the formula rows.

              Each year I have to double check the formulas because they do sometimes add or remove categories but not usually mid-season (or mid ‘pre-season’) And I generally double check everything after I update it all.

              I will be working on this Sunday to provide a new version (bug fixes, minor tier fixes, etc.)

              I would say that if you do your own calculations at the bottom of all the rows (ie at the bottom of the dataset), you MAY have to double check your calculations afterwards. The safer option as I have used elsewhere might be that if you add your formulas underneath, incorporate a buffer of extra rows (even hide them if needed). E.g. if data goes row 1-500 now, make your formula sum or average 1-600 and hide rows 500-600, so that you have 100 rows buffer in anticipation of future expansion.

              • LenFuego says:
                (link)

                @Hot Rod: Thanks Hot Rod.

                What I decided to do was copy all the imported data from the “Import” sheet to a new sheet by adding a simple formula in each cell of the new sheet (e.g., cell A1 of the new sheet is “=Import!A1” and, e.g., cell AB613 of the new sheet is “=Import!AB613”), and then making all my formula changes to the new sheet. If the data gets mucked up in the Import page with a refresh, I should be able to fix it on the new sheet without too much trouble without losing any data or formulas.

                • Hot Rod

                  Hot Rod says:
                  (link)

                  @LenFuego: excellent idea!

  17. The Dude says:
    (link)

    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 says:
      (link)

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

    • Hot Rod

      Hot Rod says:
      (link)

      @The Dude: on Muncy: good catch, thanks. Knucks had highlighted something about Muncy but I didn’t look into it.

      On Acuna: this happened last year and I forgot to double check. for any player who has “Jr.”, “Sr.”, “Esq.”, etc, they need to be identical for it to match. In this case the Dashboard tiers for Acuna do not have the ” Jr.” after the name so that is why it isn’t getting marked off. I will fix this for V2, for now if you go to dashboard and type ” Jr.” afte rhis name in cell V5 (note the space between Acuna and Jr.), then it will work

  18. JB says:
    (link)

    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…

    • Hot Rod

      Hot Rod says:
      (link)

      @JB: Excel war room day = laundry day. Enjoy.

  19. Five-on-One says:
    (link)

    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?

    • Hot Rod

      Hot Rod says:
      (link)

      @Five-on-One: “For auctions: be sure to click the ‘+’ grouping button on PLAYERS tab, above the TEAM columns, to expose the salary input column”

      The place to enter salary is on Players tab as noted above, and then after that you should be able to track amount spent per team on the War Room tab in the orange ‘finances’ section.

  20. The Dude says:
    (link)

    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!

    • Hot Rod

      Hot Rod says:
      (link)

      @The Dude: as long as it is data on the site regularly accessible, not behind the paywall, then hypothetically yes. Can you give me the URL of the data you want? Is it different than here: https://razzball.com/playerrater-preseason-espnmlb12-6X6obp
      the sheet already grabs the $ values from that data set and uses it for the sortable OBP rankings
      I don’t play OBP leagues so steer me towards the data you are after

      • The Dude says:
        (link)

        @Hot Rod: Thanks! I’m a Yahoo man, and for hitters this is my preferred source:

        https://razzball.com/playerrater-preseason-yahoomlb12-5X5obp/

        This league also uses QS in place of Wins, but Rudy does not offer this particular set of categories, the closest is the 6x6QS:

        https://razzball.com/playerrater-preseason-yahoomlb12-6X6qs/

        My follow-up question will be, if you are kind enough to add those rankings to the spreadsheet, how would one go about replacing and resorting the Players tab?
        Thanks again!

        • Hot Rod

          Hot Rod says:
          (link)

          @The Dude: let me see what I can do without mucking up all the other formatting. If this is added I will probably still keep a single column for OPS/OBP but try and link it to the proper data set…I have an idea how to do this and keep it simple for users. When is your draft?

          • The Dude says:
            (link)

            @Hot Rod: March 15, but honestly if it’s just for me it’s not worth your time.

        • Hot Rod

          Hot Rod says:
          (link)

          @The Dude: ok here is relatively easy workaround version for now (and for anyone with alternate datasets they want to use espn5x5, yahoo7x7, whatever…there are many combinations on this site!)
          If I updated to include the ones you wanted, all I would be pulling in the dat from those pages to get one figure – the dollar value to do rankings, since there are no other stats carried into the Players list besides the Grey stats.

          Since Rudy’s data can all be downloaded as a CSV file and then opened by excel, you could technically get this done yourself fairly simply. Download it as CSV, and then copy-paste the data for the first few columns into the OBP or OPS hidden sheets in my War Room. At the very least, just copy-paste over the name and the $ columns (B and F) Then the rankings that get sent through to Import and then to the Players tab will be for your particular version (change the column header in Players so you don’t get confused).

          Just make sure that the player name is in column B and the dollar value in column F on the OBP or OPS sheet, and it should work, because it looks at the $ value in column F, and the other tabs use the name to find the ranking and doesn’t use any other stats from those OBP/OPS data sets.

          • Hot Rod

            Hot Rod says:
            (link)

            @Hot Rod: in your case I would copy the yahoo 5x5obp name and $ into the OBP sheet, and the yahoo 6x6qs into the OPS sheet. Then the rankings for each of those datasets will be carried over into Players, and just change the column headers in Players sheet so you know what you are looking at. You will have the two rankings you need, without having to mess around with adding columns or changing formulas etc.

          • Hot Rod

            Hot Rod says:
            (link)

            @Hot Rod: @Hot Rod: oops what I said will work for hitters. For the 6x6QS, you would need tp put data in the Pitcher sheet. I do not have a pure ranking there, however you could turn the Points ranking into one. First, copy-paste the 6x6QS data into the Points tab (at least names and $, again make sure names in B and $ goes in column F). Then, as it is column AJ that is getting ranked, just make column AJ (‘FPts”) point to column F,. e.g. in cell AJ182 instead of the long points formula you would just have “=F182″, and copy that formula all the way down column AJ (so AJ182 would be ‘=F183”, etc). Then the ranking should be ranking the $ values, which is same order that you imported the data anyhow since Rudy’s already ranks it highest-to-lowest in Rudy’s data anyhow.
            But by doing this, the magic behind the scenes to carry those ranks through to the Players tab, where the player order is NOT necessarily the same, will happen, and thus you can sort there by the dataset you want.

          • Hot Rod

            Hot Rod says:
            (link)

            @Hot Rod: dang that won’t work either, as then the data you want will be compared to the regular points rankings – I took out the pure ‘pitcher only’ points rankings this year since I didn’t think they were relevant! Oops.

            ok, I will make a change in V2 to allow this. it is not hard but I may as well do it on the main version…stay tuned. sorry to overcomplicate this. You can do the hitter one now but for the pitcher one stay tuned

            • Hot Rod

              Hot Rod says:
              (link)

              @Hot Rod: see my comment below, added new sorting ranking options.

              • The Dude says:
                (link)

                @Hot Rod: Thanks!

  21. El Jefe says:
    (link)

    The War Room excel file is awesome – Thanks!

    • Hot Rod

      Hot Rod says:
      (link)

      @El Jefe: glad you like it!

  22. NeilB says:
    (link)

    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.

    • Hot Rod

      Hot Rod says:
      (link)

      @NeilB: yes and no – but mostly no.
      if he is injured in time for the grey rankings to be updated then refreshing the stats will pull a current stat line and also probably move the player in the Grey rankings. But that will not update the tiers since they are hard coded.

      So you still have to pay attention, if you are in ESPN or Yahoo at least they might give the little ambulance red cross symbol next to the player.

  23. Ryan Jennaro says:
    (link)

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

    • Hot Rod

      Hot Rod says:
      (link)

      @Ryan Jennaro: I upped it to 25 teams last year, how deep are these leagues?!?!? :)

      while it is technically possible to add more yourself but it would take some work in multiple places in Excel including some hidden cells/ranges on a couple of tabs. I could try adding to 30 when I do a revision, but for now consider it officially supported up to 25 teams

    • Hot Rod

      Hot Rod says:
      (link)

      @Ryan Jennaro: in v2 available now, I expanded it to 30 teams, enjoy!

  24. Hot Rod

    Hot Rod says:
    (link)

    Hi all, V2 is posted above. Bug fixes and some new sorting features. After much clamoring for additional ranking options, I figured out an easy way to do it with the data already being brought into the war room. Check it out!

    The eagle-eyed among you might notice a new column in the hitters and pitchers sections of the Players tab in columns I and AT. The cells that control this ranking are blue in the first row, cells I1 and AT1. Click on these to see a drop-down menu with all the rankable data. (which for you nerds is hosted on the HIT and PITCH tabs). This includes:

    **HITTERS**
    G PA AB R HR RBI SB H 1B 2B 3B TB SO BB HBP SF SH CS AVG OBP SLG OPS

    **PITCHERS**
    $ G GS QS TBF IP W L SV HLD H ER K BB HBP HR ERA SIERA WHIP GB% LD% FB% BABIP

    Pro: any Steamer stats are now sortable. You want to sort by SLG or QS? Go for it!
    Con: if a player is rated by Steamer but not by Grey, he won’t show up on the Players tab. So while you can trust that the rankings are correct in their order they won’t be incremental. Also, there is no filter for minimums, so a player who is projected for one stellar game in a category and riding the pine the rest of the season will skew the stats. Because many of these won’t be ranked by Grey, the sheet does filter itself to some degree. But others sneak through… for instance if I sort by SLG the best hitter in that category is Bobby Bradley, 5th overall, due to his projected 2.3 SLG on an extremely small sample size (outstanding work, Bobby!)

    You can choose how to use this, hopefully it has enough flexibility for everyone’s leagues being able to draw on all the Steamer categories. Bear in mind that these rankings are based on STEAMER not on Grey projections; you can still sort by the Grey categories as usual if he has your category covered.

    Finally – if you want to overwrite with your own projections on HIT and PITCH, just make sure you keep the data under the same columns/categories (don’t change the headers) and the rankings will carry through to these new sortable columns on Players tab.

    • The Dude says:
      (link)

      @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!

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

      • Hot Rod

        Hot Rod says:
        (link)

        @The Dude: this is a bug, I will figure it out. QS is in there and in the raw data Degrom / scherzer / Sale+Kluber should be 1 2 3.

        I tested some data categories and it worked fine, let me figure this out. Every innovation tends to work on the second version! :)

        • Hot Rod

          Hot Rod says:
          (link)

          @Hot Rod: yup a couple dollar signs got removed to lock the row in the formula at some point when I was cleaning up, that’ll do it

      • Hot Rod

        Hot Rod says:
        (link)

        @The Dude: Ok I think I fixed it. Try it now, Dude. I even left the pitcher one set to QS as a default for you :)

        Side note for all: I am having issues downloading the newest version using Firefox (65.0.2), despite my best efforts and I would certainly consider myself tech-savvy. The file hosted on Razz is accurate but my browser keeps wanting to serve me the old version even if I change the file name on save. Anyhow, while this is probably a local browser cache or temp file issue on my PC but it goes to show that anyone downloading should always check the Notes tab inside the spreadsheet to make sure their version matches what is listed above – for instance, in this newest one the Notes tab says ‘This version: 2019 V3’. If it doesn’t say that, you are out of date so try downloading with a different browser like Chrome. As the files largely look similar from version to version so it is sometimes hard to tell otherwise.

  25. BadFantasyManager says:
    (link)

    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?

    • Hot Rod

      Hot Rod says:
      (link)

      @BadFantasyManager: weekly H2h points or roto/categories? If h2h points, use the points rankings with your points settings. if roto, contiune to refer to the War Room rankings to see how your hitting and pitching looks vs opponents, and adjust future picks from that to improve in categories (for this to be accurate, you need to be inputting everyone’s picks by team)

      • BadFantasyManager says:
        (link)

        @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!

  26. Mike says:
    (link)

    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?

    • Hot Rod

      Hot Rod says:
      (link)

      @Mike: Hi – this acted up last year when I hid a bunch of columns on right side of the Players tab, oops. This year I tried to clean up the look and forgot about Excel being finnicky like that with hidden columns…sorry for the hassle.

      The easy fix is to unhide a chunk of columns on the Players sheet. I will have this already done for a future version but for now you can do this yourself in 5 seconds and fix it:

      on Players tab:
      – scroll to right you can see the right-most column, it should be Column BY, with just grey area to the right of that.
      – highlight Column BY and drag your mouse to the right over that grey area. In doing this, you are highlighting all the hidden columns you can’t see.
      – right-click on column BY and choose “unhide” – a whole bunch of columns should appear to the right since they are no longer hidden.
      – it should all work now, but 3 columns CK-CL-CM that were previously hidden have some top secret data in them – this is how the War Room gets team names to use for the drop down team names column so you DO NOT want to delete any of the formulas in these columns even by accident. To be super safe I would re-hide them (leftclick+drag over the top of columns CK-CL-CM to highlight them, then right click on that column header and choose ‘HIDE’.)

      With all the extra blank columns exposed to the right, you should have no trouble hiding the unnecessary ranking or stat columns on the Players sheet.

  27. Ghost Ride the WHIP says:
    (link)

    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?

    • Hot Rod

      Hot Rod says:
      (link)

      @Ghost Ride the WHIP:
      1) yes if you refresh the data the order will update automatically. I just tested this myself, and looking at K’s as a category when I posted V3 Luis Severino shows on Players tab column AT as ranked 11th for K’s but now after the refresh he is only ranked 19th., and all I did was click ‘refresh’. It works, hallejulah! :)

      If something changes in the amount of data on the website above the player rankings we might have an issue but usually that only happens with year-to-year changes not in the month pre-season (e.g. if the Razzball web crew adds extra stuff to the top part of the webpage, Excel sees that as additional rows when copying the site to excel, and the data for players on that tab might get bumped to start in row 190 instead of row 182.)

      2) you can hide the player column you don’t need beside batters and hitters, eg. on Players tab columns R-S and AZ-BA. Right click on the column you don’t need and and then all it will show on the drafting screen is the site you want. However, the tier rankings I think are just ESPN. I will add that each year sorting by position gets more complicated with the extra multi-position eligibility of more players. Data on positions is downloaded into the spreadsheet as a single position, for instance a guy who is “1B / 2B / 3B” shows up a a single position not each of those positions individually.

  28. Ray says:
    (link)

    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?

    • Hot Rod

      Hot Rod says:
      (link)

      @Ray: see 2 comments up for my reply on this issue, sorry for the error. Will be corrected in a future version but is easily fixable by users of the War Room if you follow the steps above.

Comments are closed.