If you just happened to stumble upon this site (hopefully a Google search for fantasy baseball spreadsheet brought you here), you’re probably thinking to yourself, “How can I trust a fantasy baseball website that has only published one article since January 2016?”.
And that’s a fair question.
Instead of going it alone, as I’ve done the last three years (has it really been that long already???), I’m now writing at the Rotographs section of Fangraphs. For the near future, you should be able to find a new article there, from me, every Friday morning. You can see an archive of what I’ve already written here.
Is SFBB Shutting Down?
No! While it will be difficult for me to continue posting here at the same pace, the site isn’t going anywhere. I do hope to add more spreadsheet tips and analysis here, and you will also be able to find that in my writing at Rotographs.
I’ve already snuck in a couple of Excel pieces over there and haven’t gotten fired yet!
SmartFantasyBaseball will also be my home for the tools, spreadsheets, and guides that I create. The Player ID map and any serious “how to” lengthy series (like my standings gain points and points league series) will be here.
One major benefit of the Rotographs shift is that I will be publishing something EVERY WEEK! I used to aim for only twice a month.
My Work So Far at Rotographs
Here’s a short summary of the pieces I’ve already published over there:
A Look at 2015 AL-Only Standings Data – Thanks to the fine folks at OnRoto, an analysis of 76 different 12-team AL-only leagues, including the average final standings, statistical category targets to shoot for, standings gain points calculations, and average hitter and pitcher stats for each roster spot. Click here to read the article. Includes a link to an Excel file download and a Google Sheet document of the raw data.
A Look at 2015 NL-Only Standings Data – OnRoto provided the data for 51 different 12-team NL-only leagues. I converted that information into category targets to shoot for, SGP calculations, and average stats required from each hitter and pitcher. This one also includes a link to an Excel file and a Google Sheet of the raw standings information.
Why You Should Aim for Third Place – This sounds rather defeatist, but I took 30 NFBC leagues’ standings data and charted out all of the results. What I found is that aiming to finish in third place in each rotisserie category looks to be the optimal use of your resources during the draft.
Making Simple Edits to Projections for R, RBI, and PA – Have you ever wondered what the effect of hitting in different spots in the lineup has on runs and RBI? Well what if the player is in the AL? Does that matter? Or what if he’s on a team projected to score 650 runs? What if he’s traded to a team that will score 750? This post comes with a series of handy charts that can help you quickly answer questions like these.
How to Create a Position Cheat Sheet in Excel – Step-by-step instructions on how to add a cheat sheet, like the one shown below, to your Excel file.
Properly Valuing Hitters with Injury Risk – Follow along as I attempt to value players, like Giancarlo Stanton, perceived to have a large amount of injury risk associated with them. What is the proper way to make this adjustment? How big of an affect does it really have?
How Does Batting Order Affect Stolen Bases – A closer look at how stolen base attempts are affected by where a player hits in the lineup. Do you need to worry if your speedster is being moved to third in the lineup? Can you expect a slow base runner to steal more if he’s moved into the leadoff spot? Answers to these questions and more!
How to Add Player Page Links to Your Draft Spreadsheet – Another handy feature to add to your draft spreadsheet. Adding these clickable links to your file will help you look up players on Fangraphs quickly and easily during the pressure-filled draft.
- Tanner Bell’s 10 Bold Predictions for 2016 – Making player predictions and going out on a limb for guys is not my M.O. But it was fun participating in one of my favorite annual Fangraphs traditions. Gerardo Parra, Jose Altuve, Marcell Ozuna, Lorenzo Cain, and more (some good, some bad)!
Best of luck this season. Be sure to follow me on Twitter so we can keep in touch and so you can be kept up-to-date on new tools and articles.