Download 2022 Fantasy Baseball Draft Buddy

2022 Fantasy Baseball Draft Buddy

We’re back! Back and optimistic MLB and MLBPA will come to an agreement to, play ball! Don’t let the latest news that MLB cancels spring training games through March 4th discourage you too much. Surely, a new CBA is forthcoming to give us baseball, and in turn, an opportunity to play 2022 fantasy baseball.

The fantasy baseball community seems to agree, as drafts are well underway. I did a 40 round, 12-team best ball at Fantrax last week. There is plenty of fantasy baseball draft chatter on Twitter. Showcase leagues RazzSlam starts Monday and TGFBI starts in a week.

What is Draft Buddy?

Draft Buddy is a Microsoft Excel-based tool that creates custom cheat sheets for your fantasy league, and helps track your draft. It is ready to download for the 2022 fantasy baseball season, and includes the following sets of projections:

  • ATC by Ariel Cohen
  • THE BAT by Derek Carty
  • Steamer by Jared Cross, Dash Davidson, and Peter Rosenbloom
  • Zeile by FantasyPros
  • Draft Buddy in-house projections by our own Chris Spencer

Draft Buddy also has player stats from the prior three seasons, and ADP from NFBC and FantasyPros. That is a lot of data packed into one spreadsheet, making it worth the download even without its’ functionality to build your custom cheat sheets and track your draft.

When you open Draft Buddy, fill in your league settings on the rules and scoring tabs, go to the action tab, and click Compile Cheatsheets. Voilà, you have player rankings for your draft. There are many other features and options you can explore.

Ready to draft? Draft Buddy helps track your draft as it progresses. Simply select a player name from any of the cheat sheet or supporting tabs, and click a Draft Player button to copy that player to the draft report tab. Draft Buddy marks the player off the cheat sheets, and other tabs update such as rosters.

If your league uses Fantrax, then you can update the draft results straight on the draft report tab with the push of a button. I hope to add more league management integration features in the future.

Download Draft Buddy

To download Draft Buddy, click the button. Download, open in Excel, and get started. The website is a bit of a transition-mess right now. In the interest of KISS, no registration required, the download is freely available. No strings attached.

However, if you would like to receive notifications when Draft Buddy is updated for new projections, ADP, feature improvements, and bug fixes, then register a new member account or login to your existing account, and sign up or renew Fantasy Baseball Draft Buddy. That will add you to the mailing list.

Whether you are a new or veteran user, if you have any questions then drop me a email. Hope you enjoy using Draft Buddy for your 2022 fantasy baseball drafts.

49 Comments on “Download 2022 Fantasy Baseball Draft Buddy”

  • Wyatt

    says:

    Where is Will Smith (C)?

    • Mike

      says:

      Hi Wyatt. Thanks for checking in. I realized that I guess after I uploaded the file and forgot to fix the upload, but if you go to the position data tab near the end, click that update button, it fixes both Will Smith’s to Will Smith (C) and Will Smith (P). Then Compile Cheatsheets (action tab), and they should both be in the rankings.

  • figrex

    says:

    This is great! Thanks so much. Needed something to help with a custom roto league I’m in and this is perfect. Do you think you could add Holds as a category?

    • Mike

      says:

      Thanks, glad you found it! Holds is in there as an available category, but not in the Chris’ Draft Buddy projections. If you switch over to ATC or THE BAT projections, they do include holds. Go to the options tab, switch the default allocation key to one of the others, and on the action tab click Compile Cheatsheets to regenerate the cheatsheets for the different projections.

  • Jeff

    says:

    Mike,

    Are you going to have the “depth” tab with all of the MLB teams listed with their starters like in years past?

    • Mike

      says:

      So funny Jeff you ask, I hid that tab, wasn’t planning to update it – haven’t found it overly useful myself, and it takes a lot of time to update. Not that I had the most work to do for it, as Kevin did most of the updates. You like it for late in the draft? I wonder if some sort of projected playing time chart might be more beneficial.

      • Jeff

        says:

        We have an old school league and I find it very helpful to see which MLB teams do not have a lot players drafted from their rosters. At the end of our draft we select MLB teams to use as farm teams so there are no free agents

        • Mike

          says:

          Interesting rule. There are so many unique rules in baseball leagues. Much more than football it seems. Let me connect with Kevin, see if he can help out with that again.

      • Jory

        says:

        Any update on the depth chart update? I am one of the weird ones that liked it too. Haha.

        • Mike

          says:

          Sorry Jory, haven’t been able to do it. Are you able to help out? The depth tab is still in Draft Buddy – and should work (pretty sure). You could unhide the depth tab and update the names. I find Roster Resource at Fangraphs the best depth charts around.

          • Jory

            says:

            I’ll see what I can do. If I do, I´ll be sure to send you the file with the update so you can update the sheet.

  • Phil

    says:

    Will you be able to get a projection pal done for this year? If not, no worries.

    • Mike

      says:

      I hope so Phil. Work’s been busy! Can you hold on this week, and I should be able to do it and post it by Friday.

  • Buzz

    says:

    Our league is using Fantrax, do I have to do anything special this year to import my leagues details into the DraftBuddy system (like I had in the past) to run the compile against?

      • Mike

        says:

        There may still be some mismatched players from Fantrax to my database. These will come up as ?? when you sync draft results. If you notice anything, then let me know and I’ll update the database.

  • Ryan

    says:

    Hey Mike,
    Never had a problem with DB before, but for some reason the Pitcher valuations are not coming out right for me. If the “Valuation Methodology” is set to Draft Buddy, the values are all sky-high ($93 Daniel Bard??) If I change it to LPP (and add in the data from the online tool), all pitchers are valued at $1.

    Not sure what I’m doing wrong. I have tried different projections, etc. Has anyone else had this issue?

    Thanks for everything!

    • Mike

      says:

      Hey Ryan. Send me your copy of Draft Buddy and I’ll check the settings. Maybe your league uses a category I have mislabeled? Easier to diagnose if I have it in front of me.

      • Gray

        says:

        I’m having this same issue

        • Mike

          says:

          Hi Gray. What we figured out with Ryan is that the pitcher positions needed to be updated. Many SP and RP listed as P were messing things up. Try going to the position data tab near the end, and click the button to update positions. Now from the action tab, run Compile Cheatsheets again. Did that fix it for you?

  • Tom

    says:

    Hey Mike,

    I’ve just discovered Draft Buddy, wish I had found this amazing tool years ago! Thank you so much for your hard work putting this together.

    I have encountered a few issues in trying to get this up and running.
    First, for each macro that connects to the internet, I’m getting a Runtime error 1004: An unexpected error has occurred. Compile Cheatsheets works fine, but Update Projections/ADP have this issue. I double checked my internet/macro permissions in Excel and made the document trusted, and still run into this problem. Any advice? If it helps, I am running O365 on Windows 10.
    Second, I noticed the reference to Projection Pal to add in custom projections, but any link I found to download the helper tool doesn’t seem to work. Is there somewhere I can find this? Somewhat related, I would like to incorporate personal projections in a spreadsheet I have. Is there a way that I can look up my own spreadsheet in place of one of the web sources? I went to do this manually but saw that ‘compile_hitters’ explicitly says not to make changes!

    Again, thank you for all your hard work on this tool. It is clear that this is a long-standing project with years of tweaks and enhancements, it’s very impressive!

    • Mike

      says:

      Thanks very much Tom for the kind words. Glad you found us – finally! Ha ha. Are you strictly fantasy baseball player or both baseball and football?

      Not sure what to say on the runtime error. Send me your file, and I will see if it works over here. Feel like this was an issue with the football version. Will investigate what we did about that.

      Projection Pal is not done yet. It is on my to-do list. It will help pull projections from your personal spreadsheet into Draft Buddy to align the projections with the right players… um, as long as you have full player name in your spreadsheet. You can also adjust projections right in Buddy if you like, but do so in the yellow highlighted sections on the hitters data or pitchers data tabs, as long as you don’t update again (which would wipe out your changes). Definitely don’t alter the compile_hitters/pitchers tabs… those are supposed to be hidden 🙂

      I will post here when Projection Pal is ready to download.

  • Nate

    says:

    Any recommendation for my league that uses INF instead of MI/CI for an additional hitter? Thinking about just adding another slot and seeing how the numbers look as if we had an extra hitter. Probably going to mess up all my rankings. I tried going to the hitters-data tab but I think there is another formula for MI/CI when I need one that covers both.

    • Mike

      says:

      While not perfect you could put one-half in each of CI and MI to account for the extra hitter. By the time you are through the required starters, required CI and MI (if used), then it is probably pretty even the value of the next best player whether he qualifies at CI or MI. Also, Last Player Picked includes an IF position, so you can run that to see the results. If you like those results better you can even import them into Draft Buddy to use in replace of the Draft Buddy methodology.

  • Kevin

    says:

    Hi Mike! I love your stuff! But where is Kris Bryant?

    • Mike

      says:

      Thanks Kevin! Believe he signed in Colorado… 🙂

      • Mike

        says:

        j/k. Is he really not there in Draft Buddy? I wonder if his position got messed up. Let me check.

    • Mike

      says:

      In the download file with Steamer as the default projections, he’s the 14th 3B and 46th OF. What projections are you using? From his player page it indicates all five different sources have projections for him (as there should be).

  • Jake

    says:

    Love this tool. Where are you aggregating rankings from? I’m in a dynasty league with 6 keepers, so its a balance of future and now. Just curious

    • Mike

      says:

      Thanks Jake! We get projections from a variety of sources. “Draft Buddy” projections are by my friend Chris Spencer. His third year doing them and super-knowledgeable baseball guy. Then we also have projections from each of Steamer, ATC, THE BAT, and Zeile (FantasyPros). You can mix and match up to three of these using the options tab. FYI, ATC and Zeile are already aggregate projections.

  • Bob

    says:

    Mike,

    I downloaded the program today for the first time this year. Upon opening it, I get the error:

    Excel found unreadable content in Draft Buddy

    Is this normal?

    Thanks

    Bob

    • Mike

      says:

      Hi Bob. Definitely not normal. Maybe something happened to the file during the download. Did you try it a second time?

  • Adam

    says:

    Awesome spreadsheet. I am trying to get comfortable using it for the first time and the one thing I am struggling with is the DH spot. Our league does not use a DH spot and assigns everyone a position. When I am looking for players like Cruz or Ohtani on the Top 25, they aren’t listed. I tried to update their positions on the hitter tab but it didn’t update the Top 25. What am I missing?

    • Mike

      says:

      Hi Adam. Thanks! I should probably remove that DH position, as it doesn’t seem very many leagues use that at all. Do you have any starters set for UT position? That should ensure Ohtani and Cruz are included in the player pool, even with DH at zero, and then ranked in the overall.

      • Adam

        says:

        Unfortunately we don’t use UT either. Everyone is designated with a specific position. Is there a certain tab that needs the position updated so it reflects on all of the other tabs?

        • Mike

          says:

          Oh, weird. So what position is Ohtani? You can change the position for any player. Do it on the hitters data tab. That should not change unless you update projections.

          • Adam

            says:

            Ohtani will be an OF. I changed him to OF in the hitters data and saved the spreadsheet but he is still not showing up on my hitters tab under OF. Anything else I need to do for that to happen? Thanks for all your help sorry to be a pain

          • Mike

            says:

            No trouble at all Adam, I should have been more clear. The cheatsheets get updated after hitting Compile Cheatsheets on the action tab. So, if you changed his position already, then Compile again, he should be in the OF now.

          • Adam

            says:

            I tried and am still having some issues. I changed Ohtani from DH,SP to DH,SP,OF and when I hit compile cheat sheets it undos my chances and takes him back to DH,SP

          • Mike

            says:

            Ah, okay, I think I got it. Told you to change his position one step too late. Go to the position data tab (near the end). Find Ohtani, the one without the (P) after his name. Change his positions to OF all the way across. Go to action tab and hit Compile Cheatsheets. Now I see him with my OF on the hitters tab, ranked 4th in default roto. Are you getting the same? If you update projections then it will update the position data tab, so you’d need to make the change again after updating.

  • Troy

    says:

    Hi. I have 1 MI, 1 CI, and 1 UT set in the rules tab. I am using 10 games and “or Yahoo” for position eligibility. I have updated projections, updated positions, and compiled cheatsheets multiple times over my prep phase. However, MI, CI, and UT are not appearing in the position dropdowns, such as on the auction report tab. Trying to add a player such as Seth Beer, who is coming through as Util is difficult. Since I can’t select a position other than C,1B,2B,3B,SS,OF,SP,RP in the dropdown, I can load him into the Player Name dropdown. If I select him in the hitters tab, for example, and select Draft Player, then I get #REF! in the Team display at it is trying to lookup “_Util_2_Detail” and this does not seem to exist as a Name or region. Any suggestions?

    • Troy

      says:

      *CANNOT load Beer into the Player Name dropdown (accidentally said the opposite originally)

      • Mike

        says:

        Hi Troy. I read “cannot” the first time – which is the only thing that really made sense. I see on the position data tab it says “Util” for his position, and it really should be “UT”. However, I also see that still doesn’t work because of no UT lookup. I need to make some changes to this process, but here is what should work in the meantime… on the position data tab, under Yahoo, change “Util” to “DH”. Then Compile Cheatsheets, he should now be selectable with the drop-downs by selecting DH position. And, he might even show up on the cheatsheets now under DH.

      • Troy

        says:

        I had some random luck choosing Nominate Player from the hitters tab. My original issue report should have said I was selecting Draft Player in the hitters data tab. Using Nominate, Beer will appear in the auction report with position DH and I can add his draft value. However, he still isn’t changing the amount spent for the selecting team in the summary tab and doesn’t appear among the teams players in the rosters tab.

        • Troy

          says:

          The “Change Yahoo Util to DH” trick helped “Beer” show up in more lists to nominate from (I just like mentioning beer). However, he still doesn’t register salary in the summary tab or appear in the rosters tab, as before. There may be other issues I haven’t tripped over yet. Thanks for getting me one step closer.

  • Troy

    says:

    Final reply (until the next one)… I hardcoded ‘rosters’!DD15 to _Pos3 and it included the DH position for viewing. This means “Seth Beer” now appears in the roster list for his fantasy team and also his salary contributes to summary. I hope I didn’t break anything by accident.

    • Mike

      says:

      Nicely done. You clearly know your way around Excel.

Leave a Comment

Your email address will not be published.

To top