Using SGP to Rank and Value Players – Example Excel Files

Download My Dollar Values and Rankings Files

The completed 2017 Excel file based upon Steamer’s projections can be downloaded here (it does include a few bells and whistles not included in the book):

Please keep in mind that this is configured assuming a 12-team mixed rotisserie league using standard 5×5 categories and a traditional lineup structure (14 hitters, 9 pitchers, no bench).  Tailor the information on the “Settings” tab and then determine “Replacement Level” for your league’s roster settings (as discussed in Part 6 of the guide).

Example Download Files, Parts 1 through 10

See below for a completed Excel file from the end of each Part of “Using SGP to Rank and Value Fantasy Baseball Players” (e.g. “Example-Part-7.xlsx” below is the Excel file as it should appear at your completion of Part 7).

Right-click on any file you wish to download and select the option to “Save Target As…” or “Save Link As…”.

8 Responses

  1. TDC, Esq. (@FloundOfPesh)
    TDC, Esq. (@FloundOfPesh) at | | Reply

    This looks like an awesome resource, but it is sad for me since I don’t have excel and none of my excel-substitutes (google docs, libreoffice, numbers for osx) seem to be up to the task of translating the [ ] syntax you use. I don’t think I have the time or know-how to pick through the whole thing and fix it so that I can use it. D=

  2. Tanner Bell
    Tanner Bell at | | Reply

    Sorry about that. This represents a difficult decision I had to make. I chose to use this specific syntax because I felt it to be more transparent and easier to understand for those that don’t have extensive experience with Excel, but the problem is that this syntax does not translate to the other Excel-substitutes you mention (or even Excel for Mac). I will refund your purchase, but if you want to continue to work through translating the formulas, feel free to e-mail me with any questions.

  3. stevemryan
    stevemryan at | | Reply

    I see you have osx as an option. You might try Dropbox. I have saved Excel files to Dropbox and I can open them for viewing on my iPad. From there I can also open in several free apps on the iPad and edit from there. Not totally sure how well they work with the Excel specific syntax, but it might be worth a try. – Steve

  4. Ethan S
    Ethan S at | | Reply

    As soon as I make a change to a formula (including with respect to the Replacement Level), all the Ranks/$Value turn into “#NAME” and I’m not sure how to get the sheet to re-calculate. Any ideas? I’m also not exactly sure how to use this tool within my draft (snake draft).

    Any input would be helpful!

    1. Tanner Bell
      Tanner Bell at | | Reply

      Hi Ethan. What version of Excel are you using? Are you using a Mac?

    2. David
      David at | | Reply

      I have the exact same issue. Worked at work with excel 2013 now I m at home on 2007 and i get name? THis is worthless if it dont work.

  5. Tanner Bell
    Tanner Bell at | | Reply

    Ethan and David, I believe I’ve figured out the issue you were experiencing. I used the formula “RANK.EQ” in the book and various example Excel files. After learning that David was having an issue only on Excel 2007, I was able to figure out that RANK.EQ was just added in Excel 2010. You can fix any Excel files you have by simply changing the “RANK.EQ” formula in your files to “RANK”. The formula should be in column W of the “Hitter Ranks” tab and column Y of the “Pitcher Ranks” tab.

    RANK was replaced by RANK.EQ in Excel 2010, but RANK should work for everyone because it is still available for backwards compatability. I have also rewritten the explanation for the RANK.EQ formula on page 84 of the book. Please e-mail me if you’d like an updated copy of the PDF.

Leave a Reply