How To Create Your Own Rotisserie Fantasy Baseball Rankings

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 2014 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.

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.Dollar_Value_Calculation

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


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.

7 Responses

  1. Tanner Bell
    Tanner Bell at | | Reply

    Please post your questions or suggestions to improve the rankings system in the comments here.

  2. Andrew
    Andrew at | | Reply

    Hey Tanner,

    Do you know if I can use Numbers on Mac or Google Spreadsheets?



    1. Tanner
      Tanner at | | Reply

      Hi Andrew,

      Thanks for visiting the site. My instructions are written specifically with Excel 2007 or greater in mind. The same general concepts can be used on Numbers or Google Sheets, but the exact formulas and instructions would need to be tweaked for those programs.

      I talk about VLOOKUP, which is not unique to Excel. But I do often use “table references” or “structured references” in Excel, which do not exist on those other platforms, to my knowledge.


  3. Klepack (@AdamKlepack)
    Klepack (@AdamKlepack) at | | Reply

    Tanner –

    When calculating the SGP for rates how many pitching spots should I assume if my league permits 10 pitchers to start at one time but 4 reserves? Should I factor in reserve players into the number of hitter/pitcher spots since those players are drafted also? Thanks.

  4. Stephen
    Stephen at | | Reply

    Tanner – Would you use the same SGP ranking method in a head-to-head league?

    1. Tanner
      Tanner at | | Reply

      Hi, Stephen. If your H2H league uses the exact same categories as a standard rotisserie league, I think using SGP and the denominators/factors above will be a very close approximation. But my ideal recommendation would be to look into the z-score method or the percentage valuation method for ranking players. I hope to address these topics one day… But I’m not there yet.

Leave a Reply