It’s that magical time of year again, when players report to spring training and nerds report to their keyboards with dreams of drafting an all-star fantasy team. Looking to go beyond the copious 2018 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 – it’s here… the downloadable 2018 fantasy baseball war room!

The 2018 Razzball Commenter Leagues are now open! Free to join with prizes! All the exclamation points!

Standard features of the Excel war room (if you are new to the site):

  • 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 2018 fantasy baseball, including Grey’s projections (stats and auction values);
  • ‘Dashboard” tab displays players by position, using Grey’s rankings (colour coded by tier!);
  • Points rankings auto-update based on custom league scoring.
  • Sortable columns for pitchers’ K/9 and ‘Ace Index’ (K/9 less BB/9), with user-selectable cutoff for each stat.

 

**NEW FOR 2018**

  • “Can you add rankings for my ____ league?” -> OBP, SLG, and OPS rankings are now integrated into Players tab as sortable columns, (based on Steamer, not Grey projections, just like the Points rankings) – if you don’t need to use them, just click the minus button above to hide them!
  • “Go big or go home” -> now supporting up to 25 teams per league!
  • “Go big or go home…Part Deux!” -> the list of ‘Your players’ has been expanded to allow 30 hitters & 30 pitchers for your team. (click the ‘+’ button beside row 38 on Dashboard to see the extra slots)
  • “Does 12 mean I am the best or the worst?” -> New option allows you to invert the [dynamically updated!] league team rankings (i.e. use number 1 as best, instead of worst).
  • Dashboard has additional RP in tiers (not just closers) -> 84 total RP, so roughly the top 3 relievers per team. 

     A few of my personal tips:

  • For auction usage: be sure to click the ‘+’ grouping button on PLAYERS tab, above columns ‘L’ and ‘AO’, to expose the salary input column
  • 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);
  • Also prior to the draft starting, 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!). 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 if you are the type that likes to stay current.
  • 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 just call yourself ‘A’ 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 are in a league that drafts fast (and league analysis is moot once the real life games start anyhow!)
  • 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 harder in 2018 with multi-position eligibility for so many players (I’m looking at you, Rizzo). 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, as it is enough work just to keep up with entering my opponents’ selections as they draft so I’m not pining after a player who was taken five rounds earlier. 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’!)
  • 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 (note: this works best if all teams on the User Input tab all start with different letters!)

Here are some screenshots of the 2018 spreadsheet in action, showing the link between Players and Dashboard tabs, and the revamped War Room tab (click for full size):


Keep checking here throughout the pre-season, as the war room will be updated if required to fix any major bugs that crop up. I hope to add Keeper rankings too, when published. While credit goes to the originator Lou Poulas and a host of other update authors over the years, I’m proud of the features and colorful interface that I’ve implemented over the last couple of years to make the tool more usable to navigate in a fast paced, high-pressure draft. I hope you enjoy it too – any feedback / suggestions / bug fixes?  Leave a comment below (for feature requests, please check the existing Feature Request list on the Notes tab in the Excel file before posting suggestions here). 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 V5 – Mar 6 2018 —Fixed “Lock Projections” macro disabling some formulas, resulting in ‘Your Players’ not getting populated properly (note: rankings and team data was otherwise unaffected, just the yellow ‘your players’ box)

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

Fantasy Baseball War Room – COMPATIBLE  (“vanilla” version – for those who have older versions of Excel that struggle to keep up with the sheer awesomeness of the newer formatting. I recommend using regular version if at all possible.)

  1. CheckOutTanakasOnHer says:
    (link)

    Keeper help? Yahoo 10-team mixed auction league with OPS/KperBB as extra cats. Standard $260 budget.

    Five keepers per team. I have Votto ($30), Benintendi and Bregman (both $11), Corey Seager ($16), Paxton ($9) and Rhys Hoskins and Luis Castillo (both $6).

    The other team offered me Machado ($27), Just Dongs ($22), and one of Willson Contreras ($11) or Felipe Rivero ($6). He wants Rhys and Beni.

    Obviously the talent coming my way is superior. But should I hesitate at all because all my keepers would be close to actual cost? In an auction league, I thought keeper decisions must involve value as much as talent. If I take the deal, do I avoid keeping Votto at $30? Or do I try to trade Corey Seager so I can keep Bregman and have SS covered.

    • LenFuego says:
      (link)

      @CheckOutTanakasOnHer: This is hard to answer without knowing the rules for keeping players in future years. For example, do you have to throw a player back after one year as a keeper? Is there some other limit on how long you can keep a guy? Can you keep Rhys forever at $6, or is there some increase that gets applied year to year?

      • CheckOutTanakasOnHer says:
        (link)

        @LenFuego: My bad. Keep players indefinitely, but salaries increase by $5 every year.

        • LenFuego says:
          (link)

          @CheckOutTanakasOnHer: Your notion that value counts over talent in an auction league is spot on – because you can always bid on a guy and win him if he will go in the auction at around the same price at which you would keep him. In theory, the simple equation for the value you get out of each guy is ExpectedAuctionValue – ActualKeeperSalary and you want the five highest values. In practice though, you want to lean on the side of younger guys on the upswing because you may be able to squeeze value out of them over multiple years.

          The add $5 salary per year rule should favor young talent that has already broken out at a cheap price even more than usual. Guys like Bellinger, Judge and Rhys should be extremely valuable keepers (especially with OPS) because they were obtained recently at a cheap price and appear to have shown already that they will be top performers for years to come. If Rhys is a top 40 type talent now and grows to a top 10 or 15 type over the next year or two (which he very well might), you would be able to keep him for up to 5 or 6 years and squeeze a ton of value out of him along the way. Castillo is another young cheap guy who you may end up extracting enormous value over several years (but you have to be leery about keeping pitchers based on multiple year value because of the risk of injury).

          I would be tempted to see what Votto and Seager would fetch in trade value and keep Rhys, Benitendi, Bregman, Paxton and Castillo. That said, it partly depends on what kind of prices all these guys would go for in the auction, and I do not have a good feel for that in a 10 team league with your league rules. If Votto would go for $45 or more and Seager would go for $30 or more, then it might well be worth keeping them over Paxton and maybe even Castillo.

          • CheckOutTanakasOnHer says:
            (link)

            @LenFuego: Just wanted to say thanks for your thoughtful advice. I’ll probably go with the high-risk, high-reward cheap-o youngsters. Good luck to your teams!

  2. knucks says:
    (link)

    You are a hero to many. Thanks brother.

    • Hot Rod

      Hot Rod says:
      (link)

      @knucks: I appreciate your work in doing the tiers, as it saved me time on updating the Dashboard tab since all I had to handle was the formatting. Team effort!

      • knucks says:
        (link)

        @Hot Rod: Nice! I didn’t realize you used it. When I saw it in the War Room I was all “damn… wish we had communicated, I could have saved HR time”.

        I’ll do that again next year for you if you end up doing this War Room for us again.

        Grey/Jay will have my email if you need it

  3. Pager24 says:
    (link)

    Thanks man! this really is the best draft prep tool available. Thanks for all the work you put into this. The new additions are gunna make this thing even better

    thanks again!

  4. Nightpandas says:
    (link)

    You da man!

  5. bravesfanintheUK says:
    (link)

    This is awesome. Thanks so much!!

  6. Another Dan says:
    (link)

    Excellent stuff, thanks. It’s just what I have been waiting for, found it incredibly useful last year. Grey let it slip that it was being released today, been checking every half hour.

    It may be me (old version of Excel, lacking in ICT skills) but I have found a couple of problems
    A) when I select my players it lists batters in both the batters and pitchers section of the War Room tab
    B) Ohtani is listed twice in the pitching side of the players tab (22 and 25 in Grey’s ranks)
    C)there is no C

    Best wishes,

    Another Dan

    • Bstov says:
      (link)

      @Another Dan: I’m having the same problem with the pitchers list on the War Room tab. It looks like the VLookup table in the pitchers section needs to be updated.

      This thing is great. Many thanks.

    • Daniel Moran says:
      (link)

      @Another Dan:

      Ohtani might be listed twice because as one he’s just a pitcher, the other he’s both pitcher and hitter

    • Hot Rod

      Hot Rod says:
      (link)

      @Another Dan: these are both good error catches, thanks. Will fix the war room players list. also Ohtani is not meant to be on SP side twice. Will have this fixed for V2.

      • Hot Rod

        Hot Rod says:
        (link)

        @Hot Rod: fixed now, will be in Version 2. If you can hang tight til tomorrow morning, I might wait til tomorrow to give another 24hrs for other bugs to pop up so we can hit them all in one version. If you are nerdy and want to fix it yourself for tonight: on War Room tab, change the formula in cells Z8 and AA8 to reference Players!$BD$3:$BF$997 instead of Players!$Z$3:$AB$997; then copy cells Z8 and AA8, then paste-formulas down that column (all the way to the hidden Z37 and AA37). That will fix it.

        This one resulted from how I was playing around with the Players list for this 2018 version to make blanks when a slot wasn’t drafted yet (instead of “N/A” everywhere), and in doing so I accidentally copied over the Hitters formula to the Players column so it was pulling hitters in both columns (and pitchers in none), oops!

        • Hot Rod

          Hot Rod says:
          (link)

          @Hot Rod: we got this posted tonight, with the fix, see V2 at the download link above ^^^

        • DAVID BEVIS says:
          (link)

          @Hot Rod: Great work, really appreciate the effort. Just a double check on correction– Column AA may need to change index reference in the formula as well – from 2 to 3 to get $value and not player name

          • Hot Rod

            Hot Rod says:
            (link)

            @DAVID BEVIS: Hi David – the $ value column AA already has 3 in the formula (even in the broken version V1 that was grabbing the hitter data range). So, as long as the person changes just the ranges as highlighted above then it should be okay. Easier still, Version 2 posted above should work correctly as-is (and in which column AA appears to be pulling salaries for pitchers correctly); if you have issues with Version 2 then let me know. Thanks!

          • Hot Rod

            Hot Rod says:
            (link)

            @DAVID BEVIS: version 1 is still posted, sorry, looking into it. V2 will correct this when it is up.

            • Hot Rod

              Hot Rod says:
              (link)

              @Hot Rod: correct version 2 should be available now at the link above

    • Hot Rod

      Hot Rod says:
      (link)

      @Another Dan: looking closer: the reason Ohtani is showing twice is because he is listed in Grey’s rankings 3 times: “He’s ranked 3 times… As hitter, as pitcher, as hitter/pitcher” (https://razzball.com/projections-grey/#comment-2752882). Right now the way I have it set up it looks at position and he has both the Pitcher and Hitter/Pitcher listed as SP, resulting in the dual entry. I will think of how to do the formula to exclude the duplicate entry – for now if someone drafts ohtani then you need to select him in 3 places.

      • Hot Rod

        Hot Rod says:
        (link)

        @Hot Rod: I will also add that for all the work Ohtani has been in doing this year’s version, I am sure glad I own him on one team.

  7. Daniel Moran says:
    (link)

    Was there plans for a feature that would show you how likely a player would be drafted by the time you picked again in snake drafts? Using ADP info, what other positions team have filled thus far, etc

    • Hot Rod

      Hot Rod says:
      (link)

      @Daniel Moran: that would be great, I like the concept, but this sheet doesn’t include ADP values. I put in ADP one year just for myself (since from non-razz source) but my draft went too fast to really use it….if it was a slow draft maybe would help more. I rely more on guesstimates myself and eyeballing the ‘top of the list’ – usually if your leaguemates are half savvy then the next guys to go should be whoever is still available towards the topmost of the Players tab. On your turn then ideally you too should be taking whoever is left at the top of the current list.

      I find my advantage usually is that I am in points leagues and the points ranking is different than the roto/grey’s/ESPN ranking so guys going off the draft room default (ESPN) end up missing some gems.

      • Daniel Moran says:
        (link)

        @Hot Rod: I’m playing in Public Yahoo Pro leagues so there are quite a few Razz gems that slip pretty far. My strategy so far has been to edit the Pre-Draft rankings, then comparing their ADP when making draft choices. I’ve been able to snag Hosmer, Puig, Wacha, Acuna & Bauer rounds and rounds after their Razzball rating.

        • Cheese Eating Surrender Monkey says:
          (link)

          @Daniel Moran: every year shandler’s bible has an excel formula that can be input for this. all you need is the ADP, and highest drafted number and lowest drafted number (for it to compute the standard deviation range for each player’s drafted slot). then at pick X you can find out what % of the time that player will be around still. i wish i used excel or knew the longer by hand way to compute this formula.

  8. LenFuego says:
    (link)

    Thanks for marshalling this again this year, Hot Rod!

  9. MarinerPlayoffHopes........ says:
    (link)

    New to Fantasy Baseball. Did a mock draft how do you think this went? I am in a 2 player keeper league. Not sure how to word it but for hitters it is H, R, HR, RBI, SB, BB, AVG, XBH. Pitching is W, L, SV, SO, HOLDS, ERA, WHIP and BLOWN SAVES. New to your site so been reading and trying to learn. Thanks for any advice. Here is how I drafted with having the 7th overall pick.
    Mookie Betts
    Francisco Lindor
    Maddison Bumgardner
    Brian Dozier
    Andrew Benintendi
    A.J. Pollock
    Jonathan Schoop
    Eric Hosmer
    Roberto Osuna
    Chris Taylor
    Rich Hill
    Travis Shaw
    Trevor Bauer
    Danny Salazar
    Andrew Miller
    Arodys Vizcaino
    Drew Pomeranz
    Wilson Ramos
    Trey Mancini
    Eugenio Suarez
    Jonathan Villar
    Paul DeJong
    Trevor Williams
    I drafted based off our league settings and from what I have been learning on here. Thanks for any help/advice.

  10. Hal_Incandenza says:
    (link)

    I’ve been waiting for this post — thanks for your work on it. Huzzah!

  11. Humm Baby says:
    (link)

    Thanks again, you’re the man!

  12. Ray says:
    (link)

    We have an unusually early draft this year because of managers with parental duties throughout March. So we’re drafting this weekend and this is a god damn lifesaver. HOT ROD FOR FANTASY BASEBALL EMPEROR.

  13. dude says:
    (link)

    I’m seeing a #DIV/0! for AVG, ERA, WHIP after I enter the keepers for my team.

    We keep 15 and draft 17, so I put 17 hitters and 15 pitchers for league settings. Does it have anything to do with not having a full roster? My plan is to use this pre-draft to get a feel for what to go after and not everyone will be keeping the same mix of pitchers and hitters.

    • Hot Rod

      Hot Rod says:
      (link)

      @dude: are you talking about the AVG/ERA/WHIP in the rankings? (War Room row 42?) If all you are entering is your own team data for now, that will stay DIV/0 due to the other teams not having any entries (there is nothing to rank against unless they all have at least 1 hitter and 1 SP). The ranking table really isn’t valuable unless you have other player teams entered. For now, since you don’t know what the other drafters will be keeping, the ranking part is a moot point. Once your league locks keepers and you can enter their keepers on the Players tab, the rankings section should all work fine (as long as they have at least one hitter and one pitcher) Another workaround is to delete all the other team names on the User Input tab so you just have team 1 “a”, you will see that this fixes the DIV/0 error.

      But really – if all you are working with is your own team’s true stats – Look at the top “goal tracking” (Top of War Room tab) or farther down on row 71 (also War Room tab), and you can see what your current AVG/ERA/WHIP are based on your actual players/keepers, and just ignore rankings for now.
      ==============
      side note: I didn’t get around to fixing all the DIV/0 errors in the Ranking table this time around, it is a legacy piece and I am slowly moving it over to my style like other pieces of this sheet. Might fix it for a future revision or next year as they bug me but not enough to delay the release of this to fix! :) At least for this year I made the ‘Your Team’ row teal so you can see your team at a quick glance.

      • dude says:
        (link)

        @Hot Rod:

        Thanks! Yea, don’t lock for another 2 weeks, so haven’t entered any others. Everything looks great in this version. Thanks for all the time and effort you put into this.

        • Hot Rod

          Hot Rod says:
          (link)

          @Hot Rod: @dude: no problem! I just fixed these ranking columns in V3 so if not everyone has drafted a pitcher they show “N/A” instead of DIV/0 (a little cleaner anyhow)and put a reminder that all teams need to draft 1 hitter and 1 SP for rankings to work. I think by accident I still have your 17/15 split in there as default player count so a good reminder to always to check the User Input settings before starting! :)

  14. Pine Tar Incident says:
    (link)

    I was just wondering when this would hit. Big thanks, love this and use it every year.

  15. Jason P. says:
    (link)

    This is amazing, thanks! What do you suggest I do in the file for my league roster size on the user input tab? We start 12 H, 9 P, but draft an additional 5 bench players. I try not to draft bench bats, but my leaguemates do. Should I do 13 of each in total roster size? Or another combination?

    • Hot Rod

      Hot Rod says:
      (link)

      @Jason P.: good question, and a good feature request. Right now it is set up for explicit pitcher vs hitter, and not a bench slot that can be either. I think it would be a decent idea to add a third ‘bench’ player type for the war room that can accommodate either hitter/pitcher for the remaining bench slots. I will look to add this in a future version.

      But as it is set up now, the player count is tied to that original user input of how many pitchers and hitters. so for now I would just do 13 and 13, knowing that the count will be screwed up on ‘Players left’ (depending on if picking 14 hitters, etc), but at least you can do your 26 TOTAL player countdown properly. Someone else on here might have a good inteirm workaround suggestion?

    • Hot Rod

      Hot Rod says:
      (link)

      @Jason P.: thanks again for this feature request, I have now added bench spots for my latest revision V3 (downloadable now). You can now assign # Bench players in the User Input page, and then when drafting it will track how many bench you still have available on the War Room page (and use either Hitter/Pitcher as a bench player once you go over your cap on each of those categories). Check it out, I think the formulas are working properly but would appreciate some outside testing too! :)

      • Jason P says:
        (link)

        @Hot Rod:

        Excellent, Thanks!

  16. Mike says:
    (link)

    Loved using this in the past, but always wondered if there was anyway to import your own projections into this? Not that Grey’s are terrible, of course. :)

    • Jason P. says:
      (link)

      @Mike: I am intrigued by this possibility as well.

    • Hot Rod

      Hot Rod says:
      (link)

      @Mike: 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 (don’t mess with this sheet if you are a casual user, move on to the next comment): Unhide the IMPORT worksheet, and change your stats on there. The data from Grey’s projections right now is from IMPORT B3:R534 (as of current version it goes to Craig Stammen as final player). 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:R534 (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.

  17. Blake says:
    (link)

    Question – I am in a 12 team pts league:

    here is my scoring:
    Hitting
    (1pt-1B, 2pts-2B, 3pts-3B, 1pt-BB, 4 pts-HR, 1pt-R, 1pt-RBI, 1pt-SB, 10pts for hitting for cycle)

    Pitching
    (15pts -Win, 7pts-Save, 1pt-SO, 5pt for CG, 10pts for a NH)

    Can I use your excel tool for a league like mine?

    • Blake says:
      (link)

      @Blake:

      it looks like it can but how do I do ADP and use that for my actual draft? My board might show a player that I should take next however I could get him 2 rounds later – correct? it looks like you do not do ADP?

      • Blake says:
        (link)

        @Blake:

        Also – I have always struggled with the rankings of razzball and my league details of scoring. I care about points and my scoring doesn’t value SB’s so I am always trying to figure out how to rank my players. it is always grey’s advice to not draft the top 10 starters and wait till the 2nd tier of starters. is that what I do with my league scoring?

    • Hot Rod

      Hot Rod says:
      (link)

      @Blake: I do not have ADP listed in here. As mentioned in another comment, I have used it before but did not implement it here as I used to get it from other sites and tried to stick to Razz/grey/Steamer data here. I have some ideas on how to implement it in a future version though, to highlight value picks.

      For your league, I would input your custom scoring into the yellow boxes on the USER INPUT tab; this year I am using the Steamer projections to generate this, and Steamer does not forecast CG or NH so it won’t calculate values for that. But the rest is covered. Then, I would click blue button on that same User Input tab to lock projections (I like to do this anytime before I sort in case things go wonky). Next, on Players tab click the red box in cell E2 and sort-ascending to rank your HITTERS by Points rank, and then do the same over in Cell AK2 on the pitchers side to rank them by points too. Note that these are HITTER rank and PITCHER rank, not by OVERALL rank for points league – that is something I might add to the next version since I think it could be useful. also, I would ‘ungroup’ column E on Players and then hide those OBP/SLG/OPS since you don’t need them.

      Personally I agree on drafting SP a little higher in Points leagues – at least to have 1 ace on team (or maybe 2). Depends on if it is a keeper or redraft too.

      • Blake says:
        (link)

        @Hot Rod:
        Oh – so we don’t have an overall rank so when we draft we know the next best player to get?

        • Hot Rod

          Hot Rod says:
          (link)

          @Blake: there is an overall rank but right now the only one is column A – ranking Greys projections (= roto). Maybe I should just make the Points/OPS ones a total rank instead of a hitter/pitcher rank, I can see how that is confusing

          • Blake says:
            (link)

            @Hot Rod:

            I would appreciate it, roto does not compare to points as my settings devalue certain things.

        • Hot Rod

          Hot Rod says:
          (link)

          @Blake: I have improved a few things for Points in my new version 3 (downloadable above ^^) .First big change is points rankings – I am now showing points TOTAL rank in the hitter/pitcher section, not the rank of only hitters and only pitchers. Also, in case it can help nab some gems, I added a column to show what the projected total points for the season is based on projected stats and your custom league scoring, and another column to show Points Per Game (PPG) for both hitters and pitchers. Check it out!

  18. Humm Baby says:
    (link)

    Maybe someone already mentioned this, but looks like when adding hitters to my team, in the war room, it shows those hitters listed under hitters and pitchers in the “your selected players” box. But when adding pitchers to team, those pitchers are not listed anywhere under “your selected players” in war room.

    • Hot Rod

      Hot Rod says:
      (link)

      @Humm Baby: yes, that bug has been fixed in V2 – download it via link at bottom of post ^^^^ (same filename as before).

    • Hot Rod

      Hot Rod says:
      (link)

      @Humm Baby: for some reason it is only V1 posted there, let me check into it as the new file was supposed to be posted. sorry!

      • Humm Baby says:
        (link)

        @Hot Rod: No worries at all, thank you.

        • Hot Rod

          Hot Rod says:
          (link)

          @Humm Baby: the correct version 2 should be downloadable at the link above now

  19. JD Hassett

    Otwins says:
    (link)

    Thanks for your work on this. My favorite draft tool

  20. OBP League says:
    (link)

    Where in the world did these OBP rankings come from?!?!?! The War Room has Arenado at 34 overall in OBP rankings…. one spot behind Jesse Winker who’s ranked 33 lol

  21. Stephen King says:
    (link)

    I do not see Jason Vargas. Is he a FA or just left off?

    • Hot Rod

      Hot Rod says:
      (link)

      @Stephen King: he is not on here because he is not projected by Grey (or in his top 500). the stats and player names are derived from those projections, except for additional prospects from the top 50 prospects which I have added in…you would have to add Vargas manually if you want to track that you have him as a keeper etc.

      • Stephen King says:
        (link)

        @Hot Rod: thanks for getting back to me!

        • Hot Rod

          Hot Rod says:
          (link)

          @Stephen King: no problem – I just updated the file to V3. One addition is that way at the bottom of the hitter and pitcher list you will see some yellow spots called <> – you can type in a player here who isnt on the usual list and then ‘draft’ them and they will be tracked in your player list (albeit with no stats and not on the dashboard). So you can type in Vargas for instance. I thought this might help with ppl who have keepers that aren’t in the top 500, and it is a less intimidating way to add players manually without breaking any formulas or having to find the hidden import data sheet. Check it out!

          • Stephen King says:
            (link)

            @Hot Rod: Thanks Hot Rod! I also appreciate the update on bench availability. I am in a dynasty league, with 41-42 spots, since we may salary cut a player for a half season. I keep filling in a war room assigning players to teams I believe they will be keeping. I should really wait till you all work out the bugs.

          • LenFuego says:
            (link)

            @Hot Rod: Can one add as many of those yellow spots as they want by just cutting and pasting more rows?

            Speaking as someone who is in a pretty deep league (12 teams, 41 roster spots), I would be thrilled if there was a seamless way to add more players on both the Dashboard and Player tabs. E.g., it would be nice if the Dashboard was coordinated with Player tab entries, so that adding a player in the Player tab would add them to the appropriate position rankings column(s) in the Dashboard tab. Even nicer would be something like an option to add X additional players to both tabs from Rudy’s Razzball/Steamer projections, or alternatively by NFBC ADP, so one would not have to add them manually at all.

            Last year, I edited both of those tabs to include more players, but it was time-consuming and kloogy and I ended up overlooking some guys (e.g., Charlie Morton).

            But I realize those are not easy upgrades.

            • Hot Rod

              Hot Rod says:
              (link)

              @LenFuego: A live update dashboard, though a good idea, would be a lot of work. It would have to scrap the tiers, and also you would need to have formulas to strip and parse out the positions from multi position guys so that for instance Cody Bellinger who is 1B/OF gets put into both the 1B and OF dashboard columns, even though he is only one row of data imported.

              we have 616 players included here, I would hope that covers the bulk of your league’s 492 spots! ;)

              technically yes you should be able to add more players below the yellow ones I’ve done. I would probably insert rows right after the last player in the bottom, to keep formatting consistent. The war room searches all the way down to row 800-900 depending on formula, the conditional formatting on Players only goes to row 600. You might have to unhide rows after 388 which I hid this year to prevent scolling down into infinity in the middle of a draft.

              • Hot Rod

                Hot Rod says:
                (link)

                @Hot Rod: *scrolling

              • LenFuego says:
                (link)

                @Hot Rod: Yeah, I realize from playing around with it last year that implementing this kind of “deep league” extension is a challenge. I would just suggest that care be taken to accommodate manually adding players to the Players and Dashboard tabs as development continues, because based on the comments it does appear that users out there do want to be able to do that.

  22. InferiorHippo says:
    (link)

    Ryan McMahon is on the player list twice. I’m assuming that is by accident?

    This is so great by the way, thanks so much for putting it together

    • Hot Rod

      Hot Rod says:
      (link)

      @InferiorHippo: you are welcome! Thanks for mcmahon – he is there twice in error. I have a conditional formula so I can eyeball if guys are duplicated in greys top 500 and my manual prospect adds, but it wasn’t working for some rows (oops!) so he slipped in a second time. Will fix for V3. For now, use the higher ranked McMahon and ignore the one towards the bottom in the ‘prospect bunch’

  23. NeilB says:
    (link)

    I have a very simple but powerful suggestion that will help tremendously with getting all the owners correctly filled in FAST. This works great as long as it is not an Auction draft. Instead of filling in all of the team names at each and every pick that requires way too much work, use vlookups off a draft order list.

    Add in a tab that has “DraftOrder” and label all the picks that will be made by each team. For a 12 team snake draft: the team that gets pick #1, also gets pick #24 and #25, etc. Team 2 gets picks #2, #23, #26 etc.
    Then add in a column on the hitters, right before current column J, and on the pitchers, right before current column AM, that is used to track the pick #. In the Owner columns do a vlookup that shows when Mike Trout goes pick #1 (in column I), then the team name gets is filled in correctly in the Owner column.
    Make sure to fill in nothing “” if the pick # is blank. =IFERROR(VLOOKUP(I5,’Draft Order’!$D$1:$E$362,2,0),””)
    This will allow all the team names to be accurately filled in and helps with the team by team comparisons on the “War Room” Tab.

    Someone with more patience and time can make this dynamic so it works with snake drafts or non-snake with varying numbers of teams.

    I also added a Max of the two Pick# columns in my file so that I know what pick # is coming next.

    Hopefully you can easily add this into future versions.

    Thanks. Love the file.

    • Hot Rod

      Hot Rod says:
      (link)

      @NeilB: while I usually just stick to short abbreviations for speed like a-b-c, or 3-letter team names like listed in my tips above, at a fast draft it is possible to fall behind and this idea could help. I am interested to play around with this – rather than starting the formulas from scratch, can I see a copy of your file with the lookup and Max formulas etc in place? if you don’t mind sharing, send it to [email protected] . thanks!

      • LenFuego says:
        (link)

        @Hot Rod: If you incorporate something like that, don’t forget to make sure it accommodates auction leagues — in fact, I am working on something similar for an auction format.

        I have added a tab called Rosters that includes a grid with team rosters organized by position (team names across the top, roster positions down the left), and filled in keepers with salaries at the appropriate team and position on the grid. As the auction proceeds I intend to simply enter the player name and salary in the appropriate grid spot. The Players tab will get updated through formulas in the Owner and Salary fields similar to those suggested by Neil B. In theory, the War Room and Dashboard will be updated accordingly as well.

        One nice thing about it is that you can see at a glance how each team’s roster is filling up (or not) by glancing vertically down the roster, and how each position is proceeding by glancing horizontally across the position.

        I am still playing around with it because of some peculiarities of my league (e.g., we can keep up to 5 “developmental” players that do not count against the total salary budget) and the inevitable peculiarities of Excel (e.g., I cannot seem to get rid of “N/A” in the Owner tab for players that have not yet been selected). If I get it through beta testing, I could send it to you if you want.

        • NeilB says:
          (link)

          @LenFuego:

          Len – as I said above, I made sure to fill in nothing “” if the pick # is blank. =IFERROR(VLOOKUP(I5,’Draft Order’!$D$1:$E$362,2,0),””).
          This fixed the N/A for me.
          You might have to add another team name that is called ” ” and is undrafted, or un-bought in your auction case.

      • NeilB says:
        (link)

        @Hot Rod:

        I just sent you an email. Sorry for the delay.

        • Hot Rod

          Hot Rod says:
          (link)

          @NeilB: cool, thanks! I will have a look.

  24. Bobblehead says:
    (link)

    When is version 3 coming out?!?! Can’t wait to get those OBP rankings!

    • Hot Rod

      Hot Rod says:
      (link)

      @Bobblehead: posted now! See link above ^^^, OBP is fixed!

  25. Hot Rod

    Hot Rod says:
    (link)

    To anyone following this thread via comment updates: just got version 3 posted. There are numerous big changes, I encourage you to read the change log. Here is more commentary on the changes, which include:

    – proper OBP/OPS rankings;

    – added bench slots – enable these in User Input and then it will draw on them in the War Room if you have maxed your Hitters and Pitchers;

    – Points leagues: big changes to the usability for points people (my people!)
    ** sortable points rankings changed to use total overall player rank, not separate hitter rank and pitcher rank.
    ** added ‘total points’ per player as sortable columns
    ** added Points Per Game (PPG) as sortable columns in hitter and pitcher side – maybe this will help find a decent bench stash SP. Also I know some people in points (my leaguemates) will look for guys that are a “3+ point hitter”, etc.
    ** points tip: – If you update data connections yourself, it might pull in Jose Ramirez pitcher for ATL and add his points to Jose Ramirez the batter and show him as higher in rankings, I manually fixed this for V3 but it will be overwritten if data connections are refreshed.

    – I still can’t figure out the best way to handle Ohtani’s multi entries (due to how he is listed multiple times in razz data with same name – see comments above on this.) For now, pre draft you could lock projections and then manually just delete the ‘extra’ Ohtanis on the players list (just delete the data, don’t delete or remove a row since the hitter/pitchers share the same rows!)…I realized that if you ‘draft’ him 3 times either for you or an opponent it messes up the team projections/rankings, so best to just have 1 Ohtani!

    – layout changes on Players tab – added more groupings and some divider columns, now letting you pick and choose more of what you want to hide. Greys total rank and the prospect ranks are not ‘clickable’ to hide, but Grey positional rank, Points, OBP, OPS can be hidden by clicking the ‘-‘ minus button above each. Also you can hide the actual player stats (under the green ‘AVERAGES’ header) if you don’t use them. Basically – I know the Players page is really busy with all these rankings and data, and now you can clean it up to only show what you need. Are you a roto player who wants hard core stats for every category and wants to hide all the Points stuff? No problem. Playing in a points league and all you want is points rankings/data and player names? (and hide category stats and roto/OBP/OPS rankings?) We have you covered too.

    It all should work fine but let me know if you find a bug or two. I can’t stress enough that when you are ready to go I would suggest to click the button on User Input to LOCK PROJECTIONS, which turns all the formulas on the players tab into values. (that being said, in my haste to get this V3 out I forgot to check the macro with the added points/OBP/OPS columns so hopefully it is working still to lock the Player sheet, if not I will note here when it is fixed…it is a convenience more than anything, as of course you can still copy+’pasteValues ‘ manually too)

    Enjoy!

    Hot Rod

  26. Mike says:
    (link)

    Is there an easy way to pull in Rudy/Steamer rankings and Projections instead? I have a deeper league where I’d prefer to just overwrite Grey’s rankings/projections for consistency rather than adding the additional.

    Thanks for pulling this together.

    • Hot Rod

      Hot Rod says:
      (link)

      @Mike: Is there a way? Yes. Is it easy? No, but if you have excel chops you can do it. The Steamer projections are already there in the worksheet – hidden as tabs “HIT” and “PITCH” (you need to unhide to see them). But there are many more categories than the Grey projections use, so you can’t just bulk copy-paste over to the Import tab. With some work you could do it. One idea would be to break the data connection on Import tab, so as to not use the Grey projections from online, and instead set up all those Grey stat columns to look up the player (and that stat) instead over on the HIT and PITCH tabs; could maybe use a similar VLOOKUP formula for that as I have already set up on Import to go grab the Points values on those tabs. So not easy, but possible.

      Someday we could maybe look at doing a ‘deep league’ version that has all the players in Steamer (I think ~2100?) but the Players tab would have to be tweaked to allow MANY more players as I think it only goes to ~300 or so rows right now on each side. This is the first year I pulled in the Steamer projections, to do Points calcs, it’s a start!

  27. Milarky says:
    (link)

    Hey Rod, curious if you can think of a creative/simple way to have players linked to a team, but to not be considered in the War Room calculations. In our league we all have 3 prospects per team, so some of the prospects that are further away can throw off the numbers, making it hard to know how your team’s starting lineup compares to everyone else’s. Basically I’m thinking of excluding some of the prospects from the calcs.

    One idea I had was to just create an extra team and dump them all into that team – I guess that’s a quick and dirty way to do it.

    • LenFuego says:
      (link)

      @Milarky: Hi Milarky. My 12 team league has the same type of rule – we can keep up to five “developmental” players as long as they never made it into a starting lineup the previous year, and they do not count against the total salary budget. Obviously it is important that they not be included in the War Room calculations.

      What I did last year was create a second “-DP” team for *each* franchise that I put those developmental keepers into – so, e.g., “Milarky” and “Milarky-DP” and “LenFuego” and LenFuego-DP”. It is not the best of solutions, but I think it more or less worked.

      I do wish there was a more integrated solution. I make my own extensions to the spreadsheet and will probably continue to look for a better solution, so if I come up with something that works seamlessly and can be easily integrated into the spreadsheet, I will pass it on to HotRod for potential inclusion.

      • Milarky says:
        (link)

        @LenFuego: that’s helpful, thanks! The trick for us is that we have a prospect draft every year where each team picks three guys with no mlb appearances, but you get to keep theee for up to three years. So some guys have valuable players rolling over that have already got mlb time but are still considered prospect keepers. So I need to figure out how to reflect the fact that I have Kyle tucker as a prospect while someone else has Acuna or even Benintendi.

        • LenFuego says:
          (link)

          @Milarky: Our league rules are a little different but have essentially the same effect. For instance, I did not start Rafael Devers at all last year so I get to keep him this year as one of my “developmental keepers”, and he will not count against my $260 auction budget. (Another owner has Cody Bellinger as a DK!)

          I want the tool I use during the auction to ignore Devers from a budget perspective, but not from a roster perspective. (Obviously third base is a less urgent need for me during the auction even though I still have full budget for it.)

          If you create a second team for each franchise named the way I suggested, I believe everything works in the spreadsheet (I think even the shading for your developmental keepers on the Players page) other than the War Room calculations and the War Room roster. There is no easy way to get the War Room calculations to work (and I actually prefer that they not incorporate the developmental keepers), but you can get your roster looking right by simply overwriting the entries for several bench spots with your developmental keeper names.

  28. Hot Rod

    Hot Rod says:
    (link)

    For anyone keeping updated via comment subscription: new V4 posted today…the only change from V3 is that I fixed columns BH/BI on dashboard which had wrong formulas so were not getting crossed off if a player was drafted (e.g. Alex Reyes).

    if you have been working in V3 with keepers entered, it is easy to fix this yourself and stick with V3 and not lose your work:
    a) go to Dashboard tab
    b) highlight columns BH-to-BN, right click on column header or somewhere on that selection and choose UNHIDE from menu
    c) select the two cells to right of Kopech’s name (BJ3:BK3), and press CTRL-C to copy [or mac equiv]
    d) select the two cells to right of Reyes all the way down to Espinoza (so BJ4:BK35), and press CTRL-V to paste [or mac equiv] – it will paste them and might look similar…the broken version had hard coded zeroes for some reason instead of formulas.
    e) now click the column headers of BJ-BI, right click and choose HIDE.

    if you want to test if it is working, try drafting Alex Reyes – he should go green or get crossed off now in BH-BI

    • LenFuego says:
      (link)

      @Hot Rod: How many more versions do you think will come out, on what date, and with what changes? Just trying to figure out when to grab a final version for using at my auction.

      • Hot Rod

        Hot Rod says:
        (link)

        @LenFuego: I hope this V4 is the last one, barring any crazy bug that gets found, because we are into draft season now! (I discovered this particular bug doing keepers for my first draft.) I thought about adding top 100 keepers but we have so many other rankings covered this year, it is data overload so I will leave it be…really you can make your top 100+ with what is in here for roto/OPS/pts depending on how your league is set up.

        But if something comes up that requires fixing (not adding a feature request), then I will try and address it ASAP.

        • LenFuego says:
          (link)

          @Hot Rod: OK, cool. Thanks again – great job on this.

  29. Hot Rod

    Hot Rod says:
    (link)

    There is an issue with my Lock projections macro. Apparently it didn’t update ranges properly to incorporate the new ranking columns this year so it is copy-pasting values in some hidden columns that results in the “Your selected players” section not updating correctly. All other stats and rankings I believe are unaffected, just the list of players doesn’t work right.

    Sorry about that. I am working to do a new macro that will fix this. In the meantime, if you haven’t locked projections like I urge everywhere, then don’t for now.

  30. Hot Rod

    Hot Rod says:
    (link)

    Ok, figured it out. a fixed version is going up shortly. Side note: I realized in fixing this that anytime you re-sort the rankings, even if projections locked, it messes up the formulas used to fill the “your selected players” boxes. So for now, that yellow “your players” section on war room tab will only be fully correct if you have sorted by greys rankings. If you choose Points/OPS/OBP/etc, then it likely won’t fill it correctly. STATS AND RANKINGS ARE UNAFFECTED BY THIS ISSUE, only the yellow box that fills with player names of hitters and pitchers.

    Next year maybe I will figure out a better way to accomplish this, the formulas filling the yellow box of ‘your players’ is a legacy piece that I inherited and hadn’t really paid attention to before now…maybe the IndexMatch formulas proposed here by others would work better for that. Anyhow, at least now you can lock projections and not mess up your named player list (but you might mess it up by resorting anyhow!)

    • Hot Rod

      Hot Rod says:
      (link)

      @Hot Rod: new version 5 posted to address this.

      If you already had keepers entered, one way to address it might be to set your team names in V5, then sort your old sheet by grey’s rankings (since they didn’t change version to version) and then copy-paste values over into the team name section of V5.

  31. Blake says:
    (link)

    thanks for updating your sheet! When rankings get edited does your spreadsheet automatically update? or do I need to download it again?

  32. Hot Rod

    Hot Rod says:
    (link)

    @Blake: If you refresh data connections, then the Grey rankings should be updated and refreshed.

    The Points/OPS/OBP are calculated off the Steamer projections which also update if you refresh data connections.

    note that the Dashboard cannot be automatically updated by this, just the rankings on the Players tab

  33. there seem to be some players missing, Carlos Gonzalez & Chris Tillman i noticed. any reason why they were left out?

    • Hot Rod

      Hot Rod says:
      (link)

      @anthony_rootbeer: at the time the sheet was made, they were not in Grey top 500. If you refresh data connections it should pull Cargo in, since he is now at 316 on grey’s current ratings (https://razzball.com/projections-grey/) but Tillman still isn’t on there so you would have to type him in manually.

      Note that the same is true for any FA who are just now getting signed – they may not have been in rankings to start.

      Note that if you refresh it now, there are a few guys who have been REMOVED from grey’s rankings too…and because there is a different number of guys, there is a weird glitch where the ‘blanks’ at the bottom of the Players sheet are somehow pulling that they are #12 overall for points. not sure why, since there is no data on the Import sheet relating to these slots, but please just ignore this if you sort by points column. (there will be 3 blank hitter slots all tied for 12th!)

        • Hot Rod

          Hot Rod says:
          (link)

          @anthony_rootbeer: sorry to hear that, I have not experienced that error personally but thanks for reporting it in detail.

          That particular URL is what is driving the stats for pitchers for Points rankings.

          If you just play roto, then one option is to get rid of those extra stats for Points/OBP/OPS:

          – right click on any tab at bottom,
          – choose UNHIDE, and then unhide sheets: HITTER, PITCHER, OBP, OPS.
          – then once those four are visible/unhidden, right click on each of those tabs HITTER, PITCHER, OBP, OPS, at bottom and choose to DELETE them.

          If you do this, the only data connection back to razzball should be the Grey projections that are located on the (hidden) Import tab, which power the main ‘roto’ rankings.

          • anthony_rootbeer says:
            (link)

            @Hot Rod: Thank you again. None of the data connections refresh for me, i get 4 or 5 errors, but i do appreciate the detailed explanation of how to get rid of that issue.

            • Hot Rod

              Hot Rod says:
              (link)

              @anthony_rootbeer: not sure why the issue, but could be Excel version, security settings or something (excel trying to use internet browser and having issues, etc)…lots going on with this sheet and a million configurations out there!

              In any case, the latest version posted here always has the current stats as of that date – so you can at least get March 6th above and not need to refresh. I doubt things have changed much in a week to affect your draft (even Cargo missing etc isn’t that big of a deal, and you can just type him in).

  34. Blake says:
    (link)

    so Mahoney did a spreadsheet kind of like yours – so what is the difference?

Comments are closed.