Welcome to the third part of the “Create Your Own Fantasy Baseball Rankings” series. If you missed an earlier part, you can find it here. You can start at the beginning of the series or if you want to start here at Part 3, you can download the Excel file created during part 2 here.
Please note that this six part series has been adapted into a 10 part book that also shows you how to convert standings gain points into dollar values and how to calculate in-draft inflation.
A few notes about the series:
- It was originally written before the 2013 MLB season. The screenshots and player references you see might refer to things from that time frame, but the same approach will work today.
- If you register as SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book
- Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used
- Some of the formulas used in the series do not work in Excel for Mac computers. I apologize for this. I don’t understand why Excel isn’t built to operate the same on that platform.
In this third part of the series we will use Excel formulas and functions to start pulling player information (name, position, team) and projection information in order to eventually calculate our own rankings. Strap in… This is a long one.
Excel Functions and Formulas In This Post
Below are the Excel functions and formulas used in this part of the series. If you’re already familiar with what these are, you can skip ahead. (more…)