Download My Dollar Values and Rankings Files
The completed 2018 Excel file based upon Steamer’s projections can be downloaded here (it does include a few bells and whistles not included in the book):
- 2018-Traditional-League-Rankings-and-Dollar-Values-Updated-03.15.18 (Steamer Depth Chart Projections)
- 2018-Traditional-League-Rankings-and-Dollar-Values-Updated-02.22.18 (Steamer Depth Chart Projections)
- 2018-Traditional-League-Rankings-and-Dollar-Values-Updated-01.10.18 (Steamer Projections)
- 2017-Traditional-League-Rankings-and-Dollar-Values-Updated-3.5.17 (Steamer Depth Chart Projections)
- 2017-Traditional-League-Rankings-and-Dollar-Values-Updated-3.5.17 (ATC Projections)
- 2017-Traditional-League-Rankings-and-Dollar-Values-Updated-01.25.17
- 2016-Traditional-League-Rankings-and-Dollar-Values-Updated-03.18.16
- 2016-Traditional-League-Rankings-and-Dollar-Values-Updated-03.05.16
- 2016-Traditional-League-Rankings-and-Dollar-Values-Updated-12.30.15
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…”.
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=
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.
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
Thanks for the tip, Steve. My eventual goal is to write these guides for a more widely available platform, like Google Sheets, for those that don’t have access to Excel. But it’s just a matter of finding the time.
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!
Hi Ethan. What version of Excel are you using? Are you using a Mac?
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.
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.