Tools

Here’s a list of the available Smart Fantasy Baseball tools.  Leave a comment if you download any of these.  Please let me know what you like.  What you don’t like.  Or what else you’d like to see.  Thanks!

Tool Information
Player ID Map Excel Spreadsheet
(download Excel file)
(view PLAYERIDMAP on web)
(PLAYERIDMAP CSV)
(view Change Log on web)
(Change Log CSV)
Click here to see last update.

An Excel file that lists player name, birth date, handedness info, Baseball-Reference ID, Fangraphs ID, MLB ID, CBS ID, Retrosheet ID, ESPN ID, Yahoo ID, NFBC ID, Baseball Prospectus ID, Davenport ID, FanDuel Name, FanDuel ID, Draft Kings name, and more. Useful for joining information from different sources.

These posts highlight practical uses of the Player ID Map:

PLAYERIDMAP
Projecting X 2.0 Excel Template (read more)

The Projecting X 2.0 Excel template comes bundled with Mike Podhorzer’s book, “Projecting X 2.0”, when purchased here at the site. Podhorzer’s book is an incredible introduction to the topic of developing your own projections. The process outlined in the book can be time consuming and the Excel file greatly streamlines the process by pulling information directly from Fangraphs and Baseball-Reference.

This Excel file is some of my best work ever. You can check it out in the video below.

Projection Aggregator (read more) The Projection Aggregator is an Excel template that will help you to easily combine and average up to three different projection sets into one more accurate set of projections.

It has other beneficial features like the ability to weight the projection system you like most and the ability to enter in your own playing time estimates if you disagree with those from the projection sets (but it keeps the “averaged” rate of performance from the projections and multiplies that rate by your playing time estimate.

Click here to read more about the Projection Aggregator and see detailed screenshots

The Aggregate Hitter Projection tab contains the averaged stats for each player and is where you can override plate appearances for any hitter.
SGP Slope Calculator Spreadsheet (download) Enter your league’s standing history into this Excel file and it will calculate the SGP factors (denominators) specifically based on that league history. Read more about the tool and how to use it in this post.

Customizeable for anywhere from 8 to 16 teams. Allows up to eight hitting and eight pitching categories to be logged.

This spreadsheet will also calculate the target rotisserie points and category totals you need to win your league.

SGP_CALCULATOR

UPDATE: After doing research on relative standings gain points, I’ve now added a line on the Slope Calculator to display the relative calculations below the traditional SGP denominator.Relative

MLB Team Abbreviation Map (link to CSV)

Have you ever tried to join or use a VLOOKUP to combine information from different sites, only to realize that the White Sox are abbreviated “CHW” on one site and “CHA” on another? Or the Giants are “SF” on a site and “SFG” on another?

Honestly, this doesn’t happen to me often. But it will occasionally. I figured it might be helpful to document the team abbreviations used on the major sites and make it easily available for download.

The map currently has team abbreviations for the following sites:

  • Fangraphs
  • Baseball Reference
  • Yahoo
  • ESPN
  • Baseball Prospectus
  • Rotowire
  • Fantasy Pros
  • Baseball Press
  • FanDuel
  • Draft Kings
  • Roster Resource URL
Downloadable MLB team abbreviation map
Different sites use different abbreviations for MLB teams.

Read more about how you can make use of this tool here.

7 Responses

  1. Bryan Curley
    Bryan Curley at | | Reply

    Tanner, the ID map is a fantastic idea. I’m ashamed I didn’t think of it first!

  2. Tanner Bell
    Tanner Bell at | | Reply

    Thanks! I believe they say necessity is the mother of invention. I do need to update it for things that transpired during the season and for those expected to play during 2014. I have already started and hope to have it uploaded here soon.

  3. Jason Prugar (@jprug)
    Jason Prugar (@jprug) at | | Reply

    Hi Tanner, thank you so much for this! It’s great. You may want to look into updating it some more. For example, you have Bobby Abreu in there and he retired.

    1. Tanner
      Tanner at | | Reply

      Hi Jason, I agree that it seems odd for me to have players like that in there. Abreu is not even the worst example. He has at least played last season. If you look close enough I think you’ll see guys like Barry Bonds and Trevor Hoffman. I keep them in there because I will occasionally do studies where I look back in time to test theories and strategies. So I need their player IDs for those purposes.

      If a player is obviously retired I try to put “N/A” for their team. But I should go through and update that some because you’ll see Abreu still shows as having a team.

      If having these retired players in there is causing problems in your spreadsheets, let me know. I can probably explain a way around it.

      1. Jason Prugar (@jprug)
        Jason Prugar (@jprug) at | | Reply

        It’s not an issue at all, just saves time. At first I thought I was doing something wrong when those retired players had no values coming back! This is a great tool. Thanks!

  4. Chris Mitchell
    Chris Mitchell at | | Reply

    Can you add Runs Produced? I see you have added other categories over time. Great spreadsheet.

    1. Tanner
      Tanner at | | Reply

      Hi Chris,

      I am assuming you mean to the “SGP Slope Calculator”? I just uploaded a new version that has Runs Produced in the drop downs. If you already have another version that you started to fill out, you can add this yourself pretty easily so you don’t need to start over. Just right-click on any of the tabs in the Excel file and choose the “Unhide” option. Then unhide the tab called “Drop Down Menus”. Then just add whatever category you want to the applicable spot on that tab and it should show up on the drop down menus elsewhere.

      Thanks. Tanner

Leave a Reply