Welcome to the “Create Your Own Fantasy Baseball Rankings” series, a step-by-step guide to help you create your own projection-based rotisserie baseball rankings using the Standings Gain Points method.
I Believe This Is The Best Resource Available For Ranking Players
You can find a link to each of the first six parts in the series below. Or if you prefer the same information in an easy-to-use free 60+ page e-book that you can download and refer to at any time, just register below.
At the end of each part is an Excel file you can download to refer to, use to double-check formulas, etc. The Excel files include the 2013 projection information originally used to develop and write the guide, but you can follow this same process with 2018 information (or in any future season).
Familiarity with Excel is recommended, but you don’t need advanced skills… I’ll teach you what you need to know. Some of the formulas used in the series require Excel 2007 or greater.
- Part 1 – Download Free Projection Data
- Part 2 – Understanding Player IDs
- Part 3 – VLOOKUP, Excel Tables, Named Range
- Part 4 – Pitcher Rankings
- Part 5 – Understanding Standings Gain Points
- Part 6 – Accounting for Replacement Level and Position Scarcity
Want To Know How To Convert These Rankings Into Dollar Values?
Even if you don’t participate in an auction, converting projections and rankings into dollar values is helpful tool for comparing hitters to pitchers (I would not suggest simply comparing a hitter’s SGP to a pitcher’s).
If you do participate in an auction then dollar values are critical. And if you play in a league with keepers, you then have to calculate the effect of inflation on your dollar values. This forced me to realize that the rankings guide was not yet complete, and I have since completed Parts 7 – 10 that take the final steps of calculating dollar values and incorporating calculations for inflation.
Please click here to read all about the additions to the guide and how to purchase your copy. With the additional segments on calculating dollar values and calculating price inflation, the guide becomes an incredible 150+ page resource and what I believe to be the best step-by-step process to valuing fantasy baseball players available anywhere.
Other RElated Posts
- How Do I Calculate SGP for OBP?
- How Do I Calculate SGP for SLG?
- How Do I Calculate SGP for OPS?
- A Warning About Calculating Replacement Level
IMPORTANT NOTE ABOUT EXCEL FOR MAC USERS
Please note that some of the formulas used in this book do not work on Excel for Mac. I apologize for this. I don’t understand why Excel is not designed to work the same on all platforms.
