Looking to get a jump on the 2020 season? Here are the Excel tools and books that are updated and ready to help you prepare for the upcoming season. If you’re looking to build skills and develop your own methods for ranking and valuing players, these are for you! All of the spreadsheet tools listed below have been updated for the 2020 season.
Co-authored with Jeff Zimmerman, this is our comprehensive guide of the process we use to succeed during a fantasy baseball season. From preseason preparations, the draft, and all the stages of the season, it’s everything we know about playing this game. The book is available in a PDF e-book for $17.99 here or in paperback form at Amazon here.
You can read a comprehensive writeup of all that’s included in the book here, including the foreword by Clay Link, the full table of contents, and testimonials by fantasy analysts like Rob Silver, Rudy Gamble, Eno Sarris, Mike Podhorzer, and Mike Gianella.
The Automated SGP Ranking Tool will help you convert your favorite projection set (Steamer, The Bat, Razzball, RotoWire, PECOTA, etc.) into Excel-based rankings and dollar values tailored to your own league’s settings. The process takes only minutes. No messy Excel formulas. Just load your projections into the file, adjust a few settings, and standings gain points rankings are calculated automatically. Click here to read more about the tool.
Powered by the same concepts as the Automated SGP Ranking Tool, the Automated Points League Ranking Tool does all the same things, just for nearly any imaginable points league. The tool works with any popular projection set and allows you to enter your league’s unique point scoring system, then instantly converts those projections into tailored point totals and dollar values. The process take minutes and will give a huge advantage over owners that are not tailoring rankings specifically to the league scoring system. Click here to read more about the points league tool.
An easy-to-use Excel spreadsheet that can combine (or average) up to three different projection sets. The aggregator can use just about any well-known projection set you can find on the web (if you find one that doesn’t work, let me know!). Simply download your favorite projection sets, fill out some settings, and you’re done. No complicated formulas or VLOOKUPS for you to add.
Ever wanted to create your own rotisserie rankings? This is my instructional guide written specifically to show you how to create customized rotisserie player rankings, dollar values, and inflation dollar values, in Microsoft Excel, tailored to your own league. No more downloading rankings from the web, hoping they apply to your unique league. 10, 12, or 15-team league? $260 or $300 budget? AL-only or mixed league? 10 hitters or 14? It doesn’t matter. This book will guide you through the process of developing rankings for just about any kind of rotisserie league.
My step-by-step guide to building custom rankings, dollar values, and inflation dollar values, in Microsoft Excel, for your points league. This book will guide you through the process of developing rankings for just about any point-based scoring format.
This year’s edition of The Process is now available!
About the Book
A very thorough and detailed write-up of what’s included in the book is available here. At a high level, this book is everything Jeff Zimmerman and I know about how to play rotisserie baseball (and even points leagues). Regardless your level of experience, I guarantee it includes pages and pages of unique ideas, research, and data you have never seen before. We continue to pour our new ideas, new research, and recent realizations into it. The e-book is 265 pages and includes 58 additional pages of appendices full of projections, statistics, and helpful information.
The paperback edition of the book can be purchased from Amazon.com by clicking here.
Keep reading for details on all that was added to this 2020 edition, but my favorite addition is a detailed study that performed on the 2018 NFBC Main Event, including all the player adds, player drops, and final standings of all 34 leagues and 510 teams. The study sought to confirm if the advice and strategies in the book can be observed and corroborated in the actions of the game’s best managers. The NFBC Main Event, with its $1,700 buy in, prestigious name, and overall competition aspect, offers the best laboratory to study this.
That new study delves into many topics:
How much does draft position affect the chances of winning a league?
Do better owners just accrue more playing time? Or are their players also accumulating more stats per AB and per IP? How much more?
How many free agent transactions do the best teams make?
How do these better owners spread their transactions throughout the season?
How do these better owners allocate their FAAB spending?
What bidding patterns can be observed from winning teams?
How do these owners allocate transactions between hitters and pitchers?
How often do these owners acquire two-start pitchers? Closers?
How much season-long value do these owners acquire and drop during the season?
How much weekly value do these owners acquire and drop during the season?
For example, here’s a table of data in the section analyzing how owners finish in the standings and the amount of moves spent on closer speculation.
A Personal Note
I’m really proud of this book. Or shall I say, this annual publication that we’ve started. But the intent to have annual editions creates a significant challenge. The book’s main strength is its long-term nature. Much of what we discuss are fundamental concepts to success at rotisserie baseball. Those ideas are not going to change much from year-to-year. It’s certainly going to be a test to keep the book relevant and worthy of your time and money. We understand that.
I am confident we can do this. Afterall, I’ve been writing on this site for several years now, exclusively with a long-term slant to my analysis. I don’t have much time to write. So I choose to focus my efforts doing research, writing instructions, and building tools that will have long-term benefits. I simply don’t have time to devote to writing short-term pieces that will be irrelevant within weeks or even days. Despite blogging for several years and having written a handful of books, I still feel as though we’re finding new ways to play and think about rotisserie baseball. I see no shortage of strategy-related questions to research.
You can see this in the topics we expanded in this year’s book. Among the higher-level strategy questions approached in this year’s book are:
Are rookies more volatile than established hitters? Does a rookie’s upside offset the possible downside? Do rookie projections differ from the projections of MLB regulars?
How much does a player’s previous levels of fantasy-production affect their future performance? Do these players offer a higher return on investment than those that have never before attained a given production level?
What are the key differences owners should know about the SGP and z-score player valuation models? Where are these systems similar?
How does the cost of closers during the draft compare to their cost in free agency (FAAB)? How does the cost of starting pitchers differ?
How much value should multi-position eligibility add to a player’s valuation? (Note: This topic was included last year, but we expanded our thoughts)
Having studied how weekly values appear in 12-team leagues during the 2017 season, how much did things change in 2018? How does the appearance of weekly values change in a 15-team league?
What do average weekly statistics lines look like for players? For example, what does a $30-35 weekly hitter line look like? What do valuable weekly pitcher statistics look like?
What strategies and behaviors can we observe from the NFBC’s amazing data (standings, adds, drops, etc.)? What behaviors lead to success? What beliefs about how to best play rotisserie baseball can we confirm by studying this data?
On top of all this, Jeff and I continue to evolve the way we play the game and we share those changes and decisions with you. Here are the new discussions of strategies, tips, and tools included this year:
We co-owned a team together this season. We share what we learned from this experience, both during the draft and in-season. Our general recommendation is that partnering is very helpful, especially for leagues where there is a grind of weekly transactions.
To that end, we outline the weekly FAAB process we went through together on that shared league. Having a consistent weekly routine is the key to uncovering valuable players and to avoiding under- or over-bidding. We share the process that works for us.
We outline the specific tools we use to identify FAAB targets and two-start pitchers. We also share the process we go through for setting lineups and finding important last-minute MLB news.
We explored different approaches to dealing with catchers this past season. We share the results of those strategies.
We share a FAAB binning strategy that helps owners stay disciplined about overbidding and maintaining a healthy weekly budget.
Do you have to read through the entire book hunting for what’s new? No! We kept track for you. You can see a full list of changes and jump right to the updated content. Here’s what that list looks like.
Please Click the ‘Buy Now’ Button Below to Purchase the e-Book for $17.99
After clicking the “Buy Now” button, you’ll be taken through an online checkout process using PayPal. There is also an option to pay with a debit or credit card. After completing the purchase, a link to download the PDF book will immediately be e-mailed to you. You can read the PDF on any mobile device, PC, or tablet.
Or Click Below to Buy the Paperback Edition at Amazon for $22.99
I’m a firm believer that using customized projections and running those through a valuation system, like standings gain points, is the single biggest leap a fantasy owner can take in improving at fantasy baseball. The problem with taking that step is it’s a significant hurdle to get over.
It’s complicated. It takes learning advanced Excel skills. It’s time consuming. It’s not for everyone.
I’ve been hard at work to help solve these problems. It’s taken several years, but I’m finally able to announce the new Automated SGP Rankings Excel Tool. With this Excel tool, you’ll be able to calculate rankings and dollar values from your favorite projection set within minutes. You can use Steamer, any other Fangraphs projection set, Rotowire, Mastersball, and even PECOTA. Whatever projection set you have access to should work.
Interested in learning more about this tool? Watch the following video or click here to read all about its features.
The Automated SGP Rankings Excel Tool is now available for the 2019 season! This tool will save you huge amounts of time. You won’t be stuck troubleshooting Excel formulas. You can focus on player research and forming your own opinions about players. You’ll have custom dollar values to make decisions from. Those values will be tailored to your league’s specific settings. It’s a great step toward winning your league this upcoming season.
The Excel tool currently works with the following rotisserie categories:
Hitting Categories
Pitching Categories
Runs (R)
Wins (W)
Home Runs (HR)
Saves (SV)
Runs Batted In (RBI)
Strikeouts (K)
Stolen Bases (SB)
Earned Run Average (ERA)
Batting Average (BA)
Walks + Hits per Inning Pitched (WHIP)
On Base Percentage (OBP)
Quality Starts (QS)
Slugging Percentage (SLG)
Holds (HD)
On Base Plus Slugging (OPS)
Saves + Holds (SV+HD)
Click here to read more about its features and to purchase the tool.
“The Process”, My Latest Book, with Jeff Zimmerman
The 2024 edition of The Process, by Jeff Zimmerman and Tanner Bell, is now available! Click here to read what folks like John Pausma, Phil Dussault, Eno Sarris, Clay Link, Rob Silver, Rudy Gamble, and others have to say about the book.
The Process is your one-stop resource for better drafting, in-season management, and developing strategies to become a better manager. The book is loaded with unique studies, tips, and strategies you won't find anywhere else. Click here for more details.