The SFBB Excel tools are updated and ready to help you prepare for the 2025 season! If you’re looking to build skills and develop your own methods for ranking and valuing players, these are for you!
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 five 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.
The SFBB Excel tools are updated and ready to help you prepare for the 2024 season! If you’re looking to build skills and develop your own methods for ranking and valuing players, these are for you!
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 five 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.
The SFBB Excel tools are updated and ready to help you prepare for the 2023 season! If you’re looking to build skills and develop your own methods for ranking and valuing players, these are for you!
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 five 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.
This year’s edition of The Process contains many exciting new updates, studies, standings, and SGP data. Visit thefantasybaseballprocess.com to read many more details.
The SFBB Excel tools are updated and ready to help you prepare for the 2022 season! If you’re looking to build skills and develop your own methods for ranking and valuing players, these are for you!
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 five 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.
Looking to get a jump on the 2021 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 2021 season.
We are sorry to announce that there will not be major updates to The Process for the 2021 edition. Among other things, the shutdown and restarting of the season, the rule changes, the odd schedules, and the seven-inning games would have us questioning the validity of any innovative research.
With that in mind, we’ve decided to offer two editions this year, so our readers can choose the version that’s right for them.
2021 Appendix Edition (PDF) – $7.99
This is the edition for owners that have previously read the 2020 edition and are now looking for updated 2021 appendix data. This slimmed-down version contains just the 65-page appendix containing SGP analysis, Steamer projections, standings data for 2018-2020, and Jeff and Tanner’s thoughts on how to use the standings data from the 2020 season. Click here to purchase the Appendix Only 2021 Edition in a PDF e-book format for $7.99.
Full 2021 Edition (PDF) – $17.99
If you have not previously bought the book, this is the edition for you. The body of this book is the same as the 2020 edition, with an updated appendix. The appendix is updated for various leagues’ standings gains points (SGP), 2021 Steamer projections with the SGP, projected handedness splits, and others. Click here to purchase the Full 2021 Edition in a PDF e-book format for $17.99.
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.
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.
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.
You can have tailored rankings and dollar values within minutes using the Automated SGP Rankings Tool.
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.
I partnered Jeff Zimmerman (Fangraphs, Rotowire, Fantrax, multiple-time Tout Wars Champ) to write this comprehensive e-book guide (PDF) that outlines the start-to-finish process we go through during a fantasy baseball season. Please click here to buy The Process e-book.
How to Win Your League
The book is a chronological guide through the fantasy baseball season, with the main goal being to help you win your league. The topics covered are:
Use of Projections
How to Adjust Projections
How to Convert Projections to Values/Rankings
How to Adjust Values and Rankings
Draft & Auction Preparation
Draft & Auction Strategy
In-season Management & Strategy
End-of-season Management & Strategy
Wrapping Up the Season
Player valuation and how it is determined are big themes in the book.
As you read through that list, you may be thinking, “I already know that topic,” or, “What more could be said about that?” But that is what I’m most proud of. I think we managed to provide unique perspective, insights, and studies that have not been seen before.
If you’re not an experienced owner and you’re looking for a place to start, The Process can help you too. It is a comprehensive guide, but we also present shortcuts and alternate ways of doing things. You can pick and choose the topics or areas in which you want to expand your game. Adding one or two new strategies or tactics to your own process each season is a great way to improve over time.
I’m also very proud of the way we were able to weave in a lot of theory, so owners are not just presented with a way of doing things, but can also understand the “why”, so it can be applied to similar situations in the future.
Cognitive biases and other decision-making concepts are also sprinkled throughout the book. We believe this combination of process, theory, and decision-making tactics makes The Process a unique tool for fantasy owners.
Tell Me More About What’s Included
One of the more interesting studies included in the book is around the concept of weekly player values. Much of the research and decision-making fantasy owners do centers around annual valuations for players. Yet outside of draft and hold leagues, we don’t make decisions on an annual time horizon. Most owners must make decisions on a weekly or even daily basis. A study of weekly player valuations sheds light on how well we capture value in the preseason, what kinds of players create weekly value, and when new value appears during the season.
This table is one of many in a study of how well fantasy owners do at capturing weekly hitter and pitcher value.
The book also includes average standings data and standings gain points calculations for many popular league variations. Save hours of time having to calculate these yourself!
Example AL-Only OBP Average League Standings Data
This data is provided for the following league types:
15-team, Standard League (14 hitters, 9 pitchers)
15-team, 1-Catcher League (2 utility hitters)
15-team, OBP League (instead of batting average>
15-team, Draft and Hold League (no in-season pickups)
12-team, Standard League
12-team, OBP League
12-team, AL-only Standard League
12-team, NL-only Standard League
12-team, AL-only OBP League
12-team, NL-only OBP League
What Do Others Have to Say?
You don’t just have to take my word for it. Some of the minds I most respect in the fantasy baseball community have taken the time to read the book and offer their feedback (Rob Silver, Rudy Gamble, Eno Sarris, Mike Podhorzer, Mike Gianella). You can see what they had to say here.
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.
Most of the concepts used in the standings gain points process of valuing players are straightforward. If there’s one facet of the process that causes the most confusion, it’s the handling of ratio statistics like batting average and WHIP. In the piece that follows, I’ll revisit the basics of what makes ratios statistics different and then I’ll get into two very specific and more complicated questions I often see.
How do you determine the baseline (or league average) ratio to compare the player pool to?
What if you don’t use an accurate measure for that baseline?
A player cannot hit a “negative home run” or “lose strikeouts”. Each counting stat helps you move closer to the next team in the standings. So when we are calculating SGP for a player, the counting stats all evaluate out to a positive number. For example, if we determine based on 2017 standings that it takes 8.526 home runs to move up one spot in the standings, Dee Gordon’s two home runs still calculate out to 0.2346 standings gain points. They’re still beneficial in an absolute sense.
Ratio Stats are Messy
When it comes to rotisserie scoring of ratio stats, we are not judged in that same manner. A player with a poor batting average or a bad earned run average can lower your score within those categories. You can have negative ratios that cause you to lose points or fall in the standings. A player can have a negative SGP for a ratio category.
How Do We Calculate SGP for Ratio Stats?
NOTE: This part is a refresher. If you already have a general understanding of how this works, skip down to the next bolded heading.
If we assume a league of 12 teams and 14 hitters on each team (adjust for your roster size), that is 168 players (12 * 14). In the Steamer projections, the top 168 major leaguers are projected for an average of about 509 at bats per player.
This means the average team in this fantasy league will have approximately 7,126 at bats (14 players * 509 at bats). According to Razzball, the average rotisserie batting average in 12-team leagues was .267. This means the average team had approximately 1,902 hits (7,126 * .267). And the average player had 136 hits (1,902 team hits / 14 players).
To find the impact of Trout we need to remove one “average” player from the team and then add in Trout’s projections. We can do the same for Tulowitzki.
13 “average” players * 509 at bats = 6,617
13 “average” players * 136 hits = 1,768
Before I start getting into the intricacies of that process, it’s important to understand that the approach we use to calculate SGP for ratio stats is to find an individual player’s effect on that ratio stat for an AVERAGE team in the standings.
Here’s a closer look at how you would do this for batting average:
Step
Description
1.
You first need to know what your fantasy league’s average batting average was. In this example, let’s say it’s .267.
You then need an approximation of how many at bats it took to generate that average. In this example, I determined that 168 players (12 teams * 14 players per team) would average 509 at bats. (more on how this was determined later!)
4.
Using that information, derive the number of hits the average player had. Knowing the league average and the number of at bats, we can easily figure out that the average player would have had 136 hits (.267 * 509 = 135.9).
5.
Next, you extrapolate the 136 hits and 509 at bats per player to team totals. But not a full team of players. ONE LESS PLAYER THAN A FULL TEAM (PER YOUR LEAGUE’S SETTINGS). We’re trying to figure out what an average team looks like without the one player we’re trying to rank.
In this example of a 14-player roster, we’ll use 13 players (one less than a full team). This means the average team (minus one player) would have 1,768 hits (13 * 136) and 6,617 at bats (13 * 509).
It’s CRITICAL that these two numbers hold true to your league average stat. Notice that 1,768 divided by 6,617 is still .267.
6.
Then, you add in the projection for the player being evaluated and DETERMINE THE TEAM’S RATIO STAT WITH THAT PLAYER. Assume a player is projected for a .300 average on 200 hits and 667 at bats. The calculation would be:
= (1,768 hits + 200 hits) / (6,617 at bats + 667 at bats)
= 1,968 hits / 7,284 at bats
= .27018 AVG
7.
Finally, determine the effect of the individual player by subtracting the average team’s ratio (from step 1 above) from the recalculated team ratio with the player, then divide by the SGP factor.
In our example, this calculation would be:
= (.27018 – .267) / 0.0019
= 1.6737 SGP
Instead of using a player with a .300 average, assume we used a player that dragged the team average down to .264. For this player, the SGP calculation would be:
= (.264 – .267) / 0.0019
= -1.5789 SGP
Negative standings gain points! I said this cannot happen with counting stats… But it CAN AND WILL HAPPEN with ratio stats.
How Do You Determine the Baseline (or League Average) Ratio to Compare the Player Pool to?
When you read through that description above, things generally make sense. But when you actually try to reperform that process, you’ll quickly realize I skipped some steps and take some liberties…
Here are the Excel tools and books I have available for the 2018 season. You won’t find draft lists or player profiles here. But if you’re looking to build skills and to 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 2018 season.
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.
“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.
