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 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
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.
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!
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.
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.
It’s time! Are you getting the itch to start thinking about fantasy baseball again? Are ready to take on a new challenge this year and calculate your own rankings or create your own projections? All spreadsheet templates have been updated for the upcoming 2017 season. Take a look at the available books and tools below.
The Projecting X 2.0 Bundle comes with Mike Podhorzer’s instructional guide to creating your own baseball projections, as well as an accompanying Excel template to help save you hours and hours of time as you work through the projection process.
(NOTE: the Excel template requires you to enter certain formulas from the book, Projecting X 2.0. If you purchased the bundle prior to the 2016 season, this is being offered to save you the time of having to manually update the player names, teams, and positions in the spreadsheet in order to start projecting the 2017 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.
After over a year of working on this and getting feedback from a very helpful group of SFBB readers, the “Projection Aggregator” Excel file is finally ready!
The Projection Aggregator is an easy to use Excel spreadsheet that can combine (or average) up to three different projection sets to give you the best possible set of projections to use for the upcoming season. You can use just about any well known projection source you have at your disposal. Download your favorite projections, fill out some settings, and you’re done.
No complicated formulas. No VLOOKUPs. Just download your projections, bring them in to the Aggregator, and you’ll have better projections in minutes. Click here to find out more.
I’ll also give brief explanations of how you can work around these challenges in Excel. At the end I’ll discuss an Excel template I’m working on that will do these calculations for you automatically and how you can get your hands on it.
I love Your Feedback
If you’re a SFBB Insider you might recall that after you sign up, the very first e-mail I send you asks you to reply with any fantasy baseball topics you’d like to know more about or difficulties you’re having (if you’re not, you can register here. I like to think it’s worth your while).
I Read All Of Those Responses
I’ve been fortunate enough to have nearly 500 people register, and I read every single response that comes in from that question. One of the most frequent areas of interest is how to average, or aggregate, multiple sets of projections into one usable set of information.
More Difficult Than I Originally Thought
These requests started to roll in during the off-season, and I even replied to several people saying that I thought this was going to be easy and that I’d have guidance coming out soon on how to do this.
… And here I sit months later having never written on the topic yet.
In theory, averaging a set of three numbers in Excel is easy. If one system says 25 HR, one says 30 HR, and another says 35 HR, Excel’s AVERAGE formula can easily respond with the average of 30.
But I quickly ran into some big problems that greatly complicated things.
Problem 1 – Lining Projections Up To Do The Averages
In order to aggregate multiple projection systems into one, we need a method of “lining up” the projections from one system with those of another system. Perhaps Giancarlo Stanton is projected to hit 20 HR the rest of the season by Steamer and 22 HR by PECOTA.
We can use formulas in Excel (e.g. VLOOKUP) to pull Stanton’s Steamer projection and place it next to his PECOTA projection. But you can run into some complications in doing this. What if one projection system lists him as “Stanton, Giancarlo” and the other as “Giancarlo Stanton”.
Using names to pull data also opens you up to inconsistencies in the name being used. Is it Jonathan Singleton or Jon Singleton? AJ Burnett or A.J. Burnett?
If you have taken on the challenge of creating your own rankings, you know that we’ve dealt with this problem before, but on a smaller scale. In my rankings spreadsheets I use a consistent playerID to pull information between the different tabs. I prefer to use the Baseball-Reference playerIDs because you can tell who a player is (Stanton is “stantmi03” because there were two other Mike Stanton’s before him).
But seemingly every major baseball site has their own player ID system. Fangraphs says Stanton is “4949”, Baseball Prospectus uses “57556”, ESPN says “30583”, etc.
This is why I maintain the SFBB player ID map Excel file. The map allows for this translation or “lining up” to happen. It’s the bridge that can easily help you take Stanton’s projection from one system and place it next to his projection from another.
“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.