|Player ID Map Excel Spreadsheet
(download Excel file)
(view PLAYERIDMAP on web)
(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:
|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
|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.
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.
|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:
Read more about how you can make use of this tool here.
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!