Welcome to the fifth part of the “Create Your Own Fantasy Baseball Rankings” series. If you missed an earlier part, you can find it here. You can start at the beginning of the series or if you want to start here at Part 5, you can download the Excel file created during part 4 here.

Please note that this six part series has been adapted into a 10 part book that also shows you how to convert standings gain points into dollar values and how to calculate in-draft inflation.

A few notes about the series:

- It was originally written before the 2013 MLB season. The screenshots and player references you see might refer to things from that time frame, but
**the same approach will work today**. - If you register as SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book
- Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used
- Some of the formulas used in the series do not work in Excel for Mac computers. I apologize for this. I don’t understand why Excel isn’t built to operate the same on that platform.

In this fifth part of the series we will discuss the concept of Standings Gain Points (SGP), a method of evaluating and ranking players. At the end of this part, we’ll actually have some primitive rankings in place. But we have quite a few concepts to go over before we jump into Excel.

## THE DIFFICULTY IN RANKING PLAYERS

Which player is worth more and should be ranked higher?

- Player A – .280, 65R, 30HR, 95RBI, 0SB
- Player B – .265, 100R, 10HR, 55RBI, 40SB

Or how about this?

- Player A – .280, 65R, 30HR, 95RBI, 0SB
- Player C – 5W, 40SV, 75SO, 2.50ERA, 1.10 WHIP

How do you rank different types of players (speed/average vs. power/RBI)? Or even worse, how do you evaluate the worth of a hitter against the worth of a pitcher? Enter the concept of Standings Gain Points.

## STANDINGS GAIN POINTS – MY INTERPRETATION

The end goal of rotisserie fantasy baseball is to accumulate the most points in the standings. The Standings Gain Points approach to valuing players is to convert a player’s statistics into the number of rotisserie points those statistics are worth.

Let’s use some example statistics from a real 12-team 5×5 rotisserie league to illustrate:

POS | HR | RBI | W | ERA |
---|---|---|---|---|

1 | 291 | 1,054 | 108 | 3.359 |

2 | 287 | 1,027 | 107 | 3.365 |

3 | 281 | 1,017 | 93 | 3.477 |

4 | 274 | 1,003 | 92 | 3.678 |

5 | 272 | 998 | 88 | 3.815 |

6 | 267 | 973 | 88 | 3.857 |

7 | 263 | 968 | 84 | 3.946 |

8 | 261 | 965 | 82 | 4.096 |

9 | 244 | 945 | 82 | 4.097 |

10 | 239 | 921 | 81 | 4.177 |

11 | 234 | 920 | 81 | 4.284 |

12 | 191 | 792 | 78 | 4.361 |

The first place finisher in Home Runs accumulated 291 HR for the year. The last place finisher accumulated 191. That leaves a spread of 100 HR from the first place team to the last place team (291 – 191 = 100).

In this 12-team league, there are 11 standings points that can be gained (even the last place team gets 1 point, the first place team 12, so 11 points can be gained).

This means that **it takes roughly 9.1 home runs** **to move up one position in the home run standings** (100 HR gap / 11 positions to move). Pick just about any position in the home run list, add 9 HR, and you can see that you do move up about 1 spot.

Running the numbers for the other statistics, we get:

RBI: (1,054 – 792) / 11 = 23.82

W: (108 – 78) / 11 = 2.73

ERA: (3.359 – 4.361) / 11 = -0.091

## A Better Method of Calculating

The weakness in the calculation method outlined above is that it really only considers the first place team and the last place team. The ideal calculation would consider all teams’ final stat totals. Fortunately, Microsoft Excel offers the SLOPE function that allows us to consider each team, not just the first and last place finishers. You can read more about how to use this formula in a three part series here (Part I, Part II, Part III).

## Do I have to calculate these myself?

You could. It would probably be best to calculate using your league’s specific history. Or Razzball has calculations from their average 12-team fantasy league you can review here (or if you really want to rub geek juice all over your body, check this out). For what it’s worth, I’ve been calculating this for my long-time standard mixed 12-team roto league ($260 auction budget, 14 hitters, 9 pitchers) and the results come amazingly close to Razzball’s findings:

Category | Razzball (based on 48 12-team leagues in 2012) | My League (based 9 year history, 12-teams) |
---|---|---|

R | 24.6 | 22.02 |

HR | 10.4 | 8.87 |

RBI | 24.6 | 22.31 |

SB | 9.4 | 8.19 |

AVG | .0024 | .0017 |

W | 3.03 | 2.96 |

SV | 9.95 | 5.70 |

SO | 39.3 | 31.62 |

ERA | -.076 | -.088 |

WHIP | -.015 | -.0152 |

## CALCULATING SGP FOR A PLAYER – COUNTING STATS

Steamer’s Projections predict 26 HR for Mike Trout. If I conclude to use Razzball’s calculation that every 10.4 HR is equal to a one position increase in the rotisserie standings, then Mike Trout’s HR equal a 2.5 point increase in the standings (26/10.4 = 2.5). **Or 2.5 Standings Gain Points**.

Other statistics similar to HR, where players simply accumulate or “count” the statistics one-by-one are referred to as “counting stats”. These are easy to calculate SGP for. Simply take the number of the counting stat (Trout’s 42 projected SB) and divide by the quantity of the stat required to move up one standings point (per Razzball, 9.4 SB to move up one position). So Trout’s 42 SB are worth 4.46 SGPs (42 / 9.4).

For pitchers, wins, saves, and strike outs are also “counting stats” and allow for easy calculation of SGP.

But what about batting average, ERA, and WHIP?

## CALCULATING SGP FOR A PLAYER – RATIO STATS

AVG, ERA, and WHIP are referred to as “ratio stats”. The calculation of SGP for these is a bit more involved. Think about this scenario…

Mike Trout is projected for 619 at bats. He’s projected to hit .297 (184H/619AB).

Troy Tulowitzki is projected for 434 at bats. He’s projected to hit .300 (130H/434AB).

Which player will have a bigger impact on your team’s batting average? Does the fact that Trout will hit .297 over nearly 200 more at bats make him more valuable? Or does Tulowitzki’s .300 average make him the better “batting average contributor”?

Let’s run the numbers. 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

Add Trout’s projections (184 Trout hits + 1,768 other hits) / (619 Trout ABs + 6,617 other ABs) = .26976

Add Tulowitzki’s projections: (130 Tulowitzki hits + 1,768 other hits) / (434 Tulowitzki ABs + 6,617 other ABs) = .26918

So despite his lower batting average, Trout’s impact on the team batting average is greater than Tulowitzki’s, due to the number of at bats. It’s this weighting we have to take into account for “ratio stats”.

To finish the example, if the team batting average with Trout is .26976 and the team batting average without Trout is .267, he increases the team average .00276 (.26976 – .267). Looking above again, Razzball calculates that a .0024 increase in BA equals one point in the rotisserie standings. This makes Trout’s BA worth 1.15 SGP (.00276 / .0024).

Enough concepts. Let’s rank some flippin’ players.

## STEP-BY-STEP INSTRUCTIONS

These instructions will help convert the statistics in our rankings spreadsheet into Standard Gain Points so we can begin to rank players.

- Open your existing rankings spreadsheet (if you don’t have one started, you can download from part 4 here).
- Add five new columns to the “Hitter Ranks” sheet. Do this by typing in column headers beginning in the first empty column to the right of your existing data. Name the new columns RSGP, HRSGP, RBISGP, SBSGP, AVGSGP (as in “Runs Standings Gain Points”, “Home Runs Standings Gain Points”, etc.).Because we have this sheet formatted as an Excel table, as soon as the column header is added, the entire column will be added to the table.
- After you’ve added these five columns, add a sixth column named “TTLSGP”. This will calculate the total SGP across the five hitting categories.
- Add five new columns to the “Pitcher Ranks” sheet. Do this by typing in column headers beginning in the first empty column to the right of your existing data. Name the new columns WSGP, SVSGP, SOSGP, ERASGP, WHIPSGP (as in “Wins Standings Gain Points”, “Saves Standings Gain Points”, etc.).
- After you’ve added these five columns, add a sixth column named “TTLSGP”. This will calculate the total SGP across the five pitching categories.
- Let’s assume a 12-team league and that Razzball’s estimate of the statistics needed to move up one spot are accurate. The formulas to add to the Hitter Ranks columns added above in step 2 are:

Column Excel Formula RSGP =[@R]/24.6 HRSGP =[@HR]/10.4 RBISGP =[@RBI]/24.6 SBSGP =[@SB]/9.4 AVGSGP =(([@H]+1768)/([@AB]+6617)-0.267)/0.0024 TTLSGP =[@RSGP]+[@HRSGP]+[@RBISGP]+[@SBSGP]+[@AVGSGP] - The formulas to add to the Pitcher Ranks columns added above in step 3 are:

Column Excel Formula WSGP =[@W]/3.03 SVSGP =[@SV]/9.95 SOSGP =[@SO]/39.3 ERASGP =((475+[@ER])*9/(1192 + [@IP])-3.59)/-0.076 WHIPSGP* =((1466+[@H]+[@BB])/(1192+[@IP])-1.23)/-0.015 TTLSGP* =[@WSGP]+[@SVSGP]+[@SOSGP]+[@ERASGP]+[@WHIPSGP] - You can now sort both the Hitter Ranks and Pitcher Ranks by the new TTLSGP column to see the “best” players. To sort, click the downward pointing arrow on the TTLSGP column. Then select “Sort Largest to Smallest”. Hit OK to perform the sort.
- As the calculations stand right now (there are some additional changes to be made in Part 6 of the series), the top ten hitters are:

And the top ten pitchers are:

## WRAP UP

The rankings look pretty good, eh? They’re mostly consistent with the consensus rankings you can find anywhere on the web. But they can also unearth some hidden gems. Cliff Lee as the projected #1 pitcher? Pretty interesting when he’s being drafted #35 in ESPN drafts (at the time this article is being written).

In the next part of the series we investigate the theories of “replacement level players” and “position scarcity”. We will adjust our calculations for these theories in an effort to better fine tune the rankings.

I’ve included some more in depth discussion below. It’s not necessary to read, but I feel the need to acknowledge some weaknesses in the SGP approach.

## LINK TO DOWNLOAD FILE: SFBB Rankings – Part 5.xlsx

## DISCLAIMER

I prefaced this SGP discussion by saying this is “my interpretation”. I do this because I’m not a mathematician. And I’m certain that there are mathematical errors or logic flaws in my presentation. But in general, I believe the approach is sound. I am aware that there is widespread dispute in the theory behind standings gain points (some think it makes no mathematical sense). Here are my thoughts on the dispute:

- When I look at what these SGP calculations kick out, they pass the eye test. They look right. They make sense.
- In the article link above, Todd Zola points out that the main flaw in SGP versus more mathematically sound approaches is that stolen bases are undervalued by SGP. Sluggers that steal very little are overvalued by SGP.
- I DO NOT SUGGEST you use SGP as a means of constructing a team. I only use SGP as a vehicle to rank players. Said another way, I don’t build a team thinking I need to draft players that will add up to 12 SGPs in a category. I only use the rankings as a barometer of when I should draft certain players.
- Drafting solely based upon Total SGPs is not wise, as it can lead to an unbalanced team. I prefer to draft with “What it takes to win your league?” in mind. I know that it takes about 200 SB to win the category. So I draft players to reach 200 SB. Not 12 SB SGPs.
- I don’t believe in a purely quantitative and statistical approach to drafting players either. There are a lot of qualitative factors that projections, rankings, SGP, or any other valuation method cannot account for. Age, potential, likelihood of injury, competition for playing time, contract situation, and other factors that need to be taken into account. I create rankings and then adjust those rankings for these multitude of other factors.

With all this in mind. I’m fine with SGP being an imperfect system.Part of being “smart” is knowing when good enough is good enough.

## * Note About Pitching Rate Calculations

My approach to calculating SGPs for pitching rate categories is based on the following assumptions:

- 12-team league * 9 pitching spots = 108 pitchers rostered
- To calculate a baseline for the rate statistics, I perform a rough exercise to approximate the 108 pitchers most likely to be rostered. I include the 108 pitchers with the highest strikeout numbers and with a projected ERA below 4.20.
- The top 108 strike out pitchers with an ERA below 4.20 in the Steamer projections have an average of 149 IP.
- This means an 8 pitcher staff has a total of 1,192 IP
- According to Razzball, the average rotisserie team in a 12-team league had an ERA of 3.59 and WHIP of 1.23
- To have an ERA of 3.59 on 1,192 IP assumes 475 ER allowed
- To have a WHIP of 1.23 on 1,192 IP assumes 1,466 BB and H allowed (BB+H)
- This makes the ERA formula = ((475 ER + pitcher’s projected ER)*9/(1,192 IP + pitcher’s projected IP)-3.59)/-0.076
- This makes the WHIP formula = ((1,466 H and BB + pitcher’s projected BB + pitcher’s projected H)/(1,192 IP + pitcher’s projected IP)-1.23)/-0.015

## IF YOU’VE MADE IT THIS FAR…

You might be interested to know that I’ve recently completed parts 7 through 10 of the “Create Your Own Rankings” series. These additional segments include the calculation of dollar values and incorporate calculations for keeper and in-draft inflation. All ten parts of the book are now available in Kindle format at Amazon. Please click here to read about these additions to the guide and how you can purchase all 10 parts. My hope is that this series is the best step-by-step guide to calculating SGP-based dollar values and inflation is available anywhere.

Please post your questions or suggestions to improve the rankings system in the comments here.

How would you calculate era and whip? And say a specific ratio like k/bb? Thanks for the great work.

The calculations for ERA and WHIP are documented at the very end of the article under the section “* Note About Pitching Rate Calculations”.

K/BB is interesting. Remember there are two things you will need to calculate:

1. The increase in K/BB required to move up one spot in the standings. To calculate that, take the average ratio of the category winner for the last several years and subtract the average ratio of the last place team in the K/BB ratio category for the same period. Then divide that difference by 11 (assuming a 12 team league).

2. You need to weight each player’s K/BB performance and figure out their effect on an average team. I’m wildly speculating because I don’t have data to draw from, but assume the average team in your league had 1,300 Ks and 400 BBs, or a ratio of 3.25 K/BB.

For a 9 pitcher staff that’s 144 K per pitcher and 44 BB. So an 8 pitcher staff would have had 1,152 K (144 * 8) and 352 BB (44 * 8). If the pitcher you are evaluating has 200 K and 60 BB, he would bump the ratio from 3.25 up to 3.28 (1,152 + 200)/(352 + 60).

Then divide this increase by the answer from the first bullet in this comment. (.03 / XX)

This may seem like a rather simple question, but how do you add the formulas so that they automatically calculate the SGP for say wins, saves, etc.? I added the formula in the column, but it didn’t do anything, the column is blank still. Please help.

Tanner,

Also, looking at the Excel chart posted with this page. I cannot find the SGQ ERA based on your ERA formula. Give me an example please of how you end up with a specific SGP for a P.

John, I’m going to e-mail you in order to try to address your questions. I think it will be more effective than using the comments because I need some additional information from you. Thanks.

I have been Commissioner and founder of the Rockland County NY, Roto League since 1981 and have to congratulate you on the most clear and precise explanations of the SGP method. Well done. The average seniority in our league is 24 years and no one has come close to explaining SGP. in fact, I am going to translate our historical stats based upon your method. By the way , we are a 6×6 non keeper ultra league rostering 12 hitters, 9 pitchers and 2 reserve spots for $250. Have you compared SGP with PVM? If so, what’s the variation, if any?

Against, thanks and I look forward to future articles.

Regards,

Don Mallo

Don, thanks for the high praise! I have not done a direct comparison to PVM. But I do want to do that this year before the season starts, so please stay tuned to the site.

How’d you calculate .0024 above for AVG?

Hi John,

I personally track the exact history of my own leagues, but that’s just one league and the people in my league might be fundamentally different than the “average” league. So instead, for this post I just use the numbers that Razzball calculates from their reader leagues. I think they had 48 different leagues they combined and averaged out to get the numbers above (the .0024 BA).

Here’s the link to the Razzball page

For example, one of my leagues last year (you probably want more than one year’s history) the first place team had a .2718 BA. 12th place was .2598. Figure out the total spread in the category (.2718 – .2598 = .012) and divide by the number of teams minus 1 (12 -1 = 11).

.012 / 11 = .0011

That .2718 to win batting average is low. A lot of us were tightly bunched. If you had a .280 to win, the .0011 might come closer to .0024.

Batting average in the league is changing. So that .0024 could be in flux. Hopefully Razzball puts out a similar piece this year.

Thanks, Tanner

Looking forward to your article on PVM. Will be interesting to compare the rankings. Getting back to SGP for a moment. Have you posted an article on translating the SGP scores into dollar values? I have created a sheet using our 16 team 12 category league but am unsure if my method is correct. Our total pool is $4000 (250 x 16) and I have allocated this pool between hitting and pitchers on a .70/.30 ration for simple math. This leaves $2800 for hitters and $1200 for pitchers.

I then calculated the total number of points achievable by league members for the 6 hitting and 6 pitching categories in our 16 team league (1644 total points with 822 for hitters and 822 for pitchers) and divided these results into the appropriate dollar allocation to obtain a dollar value per point. (Our league uses an extra point for 1st place in a category so that the leader gets 17 points and the 2nd place team gets 15).

I then multiplied the dollar value per point by the appropriate SGP number using your methodology to obtain a dollar value.

Would appreciate your insight.

Thanks again for a great and well-presented series.

Don, you have hit on one of the “mathematical flaws” in the SGP approach. Your concept of calculating that there are 1,644 points available is sound (although I’m not sure you would include that bonus point in your calculation). And then calculating a $/point also makes theoretical sense.

But a funny thing happens when you use SGP. If you go and add up all the SGPs for the top 224 hitters and 144 pitchers (assuming 16 teams, 14 hitters, 9 pitchers), you won’t come up with 1,644 points. That’s what drives mathematicians nuts about SGP.

So for calculating your dollar values, you would instead calculate the total SGPs projected for your top 224 hitters. Use that to figure out the dollar value per hitting SGP. Then multiply each hitter’s own SGP by that amount. Then do the same thing for hitters.

I think you need to keep hitters and pitchers separated when you are calculating your $/SGP, because of this phenomenon where the actual projected SGPs are not going to equal the 822 points for hitting and 822 points for pitching.

You also will need to build in a few error checks into your calculations. You need to make sure that your last player is worth $1 and that your top 224 hitters includes 32 C, 48 CI, 48 MI, 80 OF, and 16 other players to fill the UTIL spot. No player in that top 224 should have a negative value.

How do you handle outlier historical data? I’m in a 10 team NL only 4×4 (OBP instead of Avg) and its hard to find reliable values for that setup so this year I’m giving SGPs a shot this time around. Our league has historical data going back to 2001 (the league has actually been around since 1988) so getting the data for the counting stats is very easy. Unfortunately for the rate stats our website has only recorded the final number and not the components (PAs, IP, Hits, etc) that went into those final numbers. As this is not a common league finding a compilation of data like Razzball has on a 12 team 5×5 mixed is a little hard to do.

I think I have found a decent way around this. On the site I can get the player stats for each season and so I pulled that data and came up with a yearly average OBP from the Top 140 players that the site lists (exactly how their rankings are calculated I’m not sure). I’m looking at data from 2009-2013 and for three of those seasons my average OBP is a perfect median number and one of the years its only off by one (four above, 6 below).

However 2009 is super funky. When I calculate the average OBP my result would have place between 7th and 8th which isn’t that close. The interesting thing is that this average is the highest average of the five year period I am looking at, the recorded OBPs for that season were apparently insane. Looking at the data I noticed that season’s AB’s and Hits were about 10% less than the 2010-2013 data (which were all remarkably consistent). I’m having a hard time reconciling how my “average” OBP (once again I’m not certain on the actual results each team had) is so much lower than what the median should be. I know data is data but seeing how the odd this is all seeming I’m thinking about just throwing out 2009 all together (and will therefore have to throw out the 2009 counting stats too).

Also, has anyone given any thoughts to the effect of the Astros moving to the AL is having on historical data in mono leagues? Comparing the 2013 data my regression lines are not as steep but I’m not sure how much that has to do with the Astros based on one year of data. If there is an effect I’m not exactly sure how to quantify and adjust for it.

KG, you ask a number of really good questions. I’ve always played in standard mixed leagues, so I’ve never run into these issues myself before. But these questions have me giving long looks at the other ranking approaches (PVM and z Score), because they’re not so dependent upon league history. They are inherently “forward looking”, whereas SGP is looking at the past and assuming history will repeat itself.

I hope to eventually write up how to do all three approaches. But I can’t say when I’ll have something like that completed.

I have been thinking about if it makes sense to include league history from 5-10 years ago in SGP calculations because the offensive environment has changed so much. I don’t have any science to back me up, but I am thinking it would be best to eliminate anything prior to 2009 from your calculations. I think it will just muddy the water too much and possibly give you inaccurate results.

Unfortunately when i was working through the pitching data my workaround solution went out the window. When I go and pull player stats from previous years, our site (CBS) didn’t lock/archive what players were actually present. I noticed this while going through last year’s pitcher data and saw Fister show up despite being in the AL last year. I was also noticing that my top 90 pitchers also included several middle relievers who were not rostered during the season which was also throwing off the data.

Since I don’t have reliable historical data (I’m going to make a better attempt this season to keep track of the rate stats), I’m going to have to move on from SGP even though my gut tells me that for established leagues it might be the better way to go. I’m not convinced on PVM on my limited study of it so far, it seems like you need to do too much adjusting by guesswork to balance the individual stats.

Apologies if this was covered somewhere and I missed it…seems like a bit of an obvious question. I’m in a 20 team H2H re-draft league and I can’t seem to find the magic place where it shows past stat totals. Would the SGP for a 12 team league be similar, or do I have to somehow obtain that information (which I’m having trouble finding.)

Sorry if that’s a dumb question, never really got into the nitty gritty world of spreadsheets before and I’m not really skilled with excel. Thanks for this guide, it’s really helped a huge amount.

I think the fact that there are 20 teams will affect the SGPs. Being a H2H league also complicates things because it is a legitimate strategy to punt one or more categories in H2H leagues. But I don’t suspect it will affect things too much. The players you establish as “replacement level” will be the biggest difference. What site is your league run from?

Yahoo. Some guys are using z-scores instead and I’m not sure if that’s a preferable method for H2H. I think I’m going to try running with this and see how it works out and also since it’s easier to understand. Would you be able to take an educated guess at the SGP for K/BB?

Thanks.

AT, I can’t give an educated guess. But if you have your historic league standings/results available to you in Yahoo, you can perform a calculation yourself using the tool here. You could just fill it out for the one category you need.

And while I can’t give the SGP calculation, I do discuss an example of how you would calculate it above in this comment.

Tanner,

Just found your site recently and have been enjoying what I’ve seen so far! Nice writeup on SGP, I’m personally a bigger fan of using z-scores (and using historical stats for std devs), but the concepts seem essentially the same.

Question time: I’ve been wrestling with an issue lately that I’ve been personally referring to as the “Hanley Ramirez problem” – certain players, especially elite ones with injury histories, tend to be projected for ~550 PA or less while still managing to be well above replacement level. But are these various methods correctly valuing these players? As you point out in another of your articles, winning teams maximize their opportunities to get more PAs. If Hanley manages to put up 550 PA of elite production, that still leaves you ~100 PA of some other bum rep lvl SS to accumulate more counting stats. Meanwhile Elvis Andrus is projected (Steamer 2014) to put up almost as much value as Hanley, but over a full 650+ PA, so there’s no bonus playing time value to be had.

So, have you come across any methodologies that account for this in some way? Certainly we wouldn’t want to go in the direction of Oliver and try to just normalize every player to the same # of PA’s, but maybe some amount of replacement level performance should be added to a player’s statline, weighted based on something like (650-PA)/650? (Maybe 650 PA would not be the number to go with, but something like avg. PA of above-replacement players at each position)

Hi Ryan, I’ve thought about adding this to my process to see how much it will affect things. I envision it would work similar to how the “Replacement Level” lookup works right now. I think you would have to create some kind of a table that calculates the stat line of the replacement level player ON A PER PLATE APPEARANCE BASIS.

Hanley’s calculation for runs would be:

Hanley’s own baseline calculation for Runs + (650 – 550) * Per PA Runs from the table

Where 650 is the “standard cieling” you adjust everyone to and 550 is Hanley’s actual plate appearances. The difficult part is that i don’t think you can give credit for the full 100 games Hanley misses. Some of those he might not be active, but not on the DL. Some will be normal days of rest, etc. You can’t predict some of that accurately. So maybe multiply the gap by 80% or some other measure.

Great stuff here! Thank you. How would the step by step calculations change for calculating a SGP formula/value for OBP instead of AVG? More variables than just hits and at bats.

I just posted an example OBP calculation here: http://www.smartfantasybaseball.com/2014/02/calculating-standings-gain-points-for-obp/

“I know that it takes about 200 SB to win the category. So I draft players to reach 200 SB. Not 12 SB SGPs”

I would like to know how to compare the SGP of the players you’ve drafted with the SGPs needed to win the league. I feel this would let me know when I’ve over-drafted a stat category and where my needs are to make trades.

For instance, in my fantasy hockey league I calculated the SGPs of the offensive categories for the season thus far.

G P HIT BLK +/-

4.0 11.0 68.7 8.3 5.3

If I total my teams SGPs up I get 65.3 53.6 16.4 59.3 21.4 in those same categories, respectfully. I know I need 49 126 223 121 14 in each to finish just ahead of the 2nd place team. Basically, I’ve got a feeling that my team has overkill in one stat (Hits) while lagging in another (blocks). How can I verify my hypothesis with SGP math? How can I used SGP mid draft to stop drafting a stat I have accumulated enough of and focus on category holes on my team? MUCH THANKS! Feel free to email me.

Hi Sean, for SGP to work well you must have information about the statistics it takes to win a given category. I don’t play fantasy hockey, but let’s just say you know that over the last 5 seasons in your league it has taken an average of 500 hits to win the category. If your team is projected to exceed 500 hits, then you are overkill in the category. There really is no need to overcomplicate things with SGP math.

Your sentence “If I total my teams SGPs up I get…” is worrisome to me because this is exactly what I suggest not to do. It’s much safer to simply know the statistics necessary to finish first in a category and see if your projected stats meet those requirements. When you start evaluating on the basis of SGPs there is a greater room for error and noise in the results.

Maybe I’m just not excel-savvy enough to figure this out, but how could I change things around here to fit the scoring system in my h2h points league? Any help would be great thanks!

Hi Seth. Points leagues do not need to use a system like SGP to rank players. It’s much simpler for a points league. You simply need a set of projections and then multiply those projections by the scoring settings for your league.

For example, I’m in a points league where doubles are 3 points, HR are 9, SB are 3, H are 5, 3B are 5, BB are 3, and AB are -1.

So if a player is projected for 40 2B, 30 HR, 10 SB, 200 H, 5 3B, 80 BB, and 600 ABs, their projected points would be 40*3+30*9+10*3+200*5+5*5+80*3+600*-1 = 1,085 points.

There’s no need to determine SGPs or z Scores or anything like that. You might consider an adjustment for replacement level players though. So if my example player above is an OF and the replacement level OF is projected for 400 points, then I would subtract 400 from every outfielder. The player mentioned above would then have 685 points in my ranking system.

Thanks for the response! Do I just need to make a separate sheet, and do the formula, for example HR * scoring?

Also, how would I figure out a replacement level player? Sorry if these are simple questions, just now getting into the depths of all I can do with fantasy statistics!

I do prefer to do my rankings on a separate tab from the projections, but you don’t have to. I do it on a different tab because it makes it easier to download a new set of projections and drop them into the file without having to redo all the formulas again. But it does take a lot longer to set up initially.

Replacement level is discussed in Part 6, if you haven’t read that yet. But basically you need to know your league size and about how many players will be drafted at each position. If you think 24 SS will be drafted in your league, you can use that 24th SS as replacement level.

Oh duh, that makes perfect sense for replacement level players. Thanks! Love the excel layout!

What would the formula be for k/9 if you calculated the average k/9 was 8.0 for your pitcher pool?

Tanner,

Love the site and your demonstration of SGP. I have a question regarding the example you present in the article. When you mention 14 batter positions, are you counting bench spots? Or just offense position spots?

Thanks again for your work!

Mike

Hi Mike, thanks for the kind words. Are you referring to the calculation of BA SGP? For this calculation, I think it is important to only use the number of starting batter positions you have. If you start 14 hitters, then 14 hitters need to be included in the calculation. The reason for this is that a single player can have a larger effect on smaller starting lineups. The same hitter will have a smaller effect on a large starting lineup.

Awesome. Thanks!!

When calculating the SPG for Batting Average you say “In the Steamer projections, the top 168 major leaguers..” Who are these “top” players? The players with the most ABs? Great site, keep up the good work.

Hi Drew,

This is something I struggled with at first until I figured it out (at least for hitters). Note that I’m using z scores instead of SGPs (I do not have enough historical data for my league setup to do SGPs) I think the method should work just as well.

1) Bring up your entire projection list for hitters and run the calculations for the counting stats (R, RBI, HR, SB) just the same as Tanner has listed above for all of the hitters you have projected.

2) When it’s time to do batting average (or OBP or whatever else you might use), just take the first 168 players on that list, it doesn’t matter what order they are in.

3) Calculate your average ABs and Hits based on those first 168 and apply the calculation to your entire set of players.

4) Calculate your total SGPs for each player.

5) Once you have done that, sort your project list by your SGP totals. This should re-sort the list based on your original averages and give you a new set of 168 to work with.

6) If you setup your formulas so that they update automatically you’ll just need to re-sort your list a few more times until the list stops changing and you should have your 168 (or however many you need with your league setup) hitters. If you’re in a 2 catcher league you may need to add a catcher or two at the bottom of your list.

I tried to do the same thing for pitchers but it hasn’t come out very well, it keeps trying to put a lot of middle relievers in my pitcher set that have a rare chance of getting drafted. I’m trying to find a method that works there but I haven’t been happy with my results so far.

KG, just in case you missed it, there’s a small bullet point at the end of the article about how I approximate who the top 108 pitchers are.

“To calculate a baseline for the rate statistics, I perform a rough exercise to approximate the 108 pitchers most likely to be rostered. I include the 108 pitchers with the highest strikeout numbers and with a projected ERA below 4.20.”

It is an arbitrary starting point, but you could just use this as a starting point and then resort your 108 pitchers and update the calculations for that. Once you have something like that in place it should not allow the relievers ERA and WHIP to weight high enough to get significant SGPs.

I did see that and did something similar when I ranked. I wasn’t particularly happy with it as it’s more subjective but i couldn’t find a formulaic way that I was happy with. I discovered part of the problem was that my spreadsheet was not accounting for at least the minimum amount of innings each team needed to have (our league has a 1000 inning minimum, I’m assuming most leagues have something similar). In my 10 team league that should mean the Top 90 would need to have at least 10,000 innings pitched but when I ran my iterations I only ended up with about 8,300 innings. I’m ok with Excel but coming up with a formula that checks and corrects for this is a little beyond my abilities.

Drew, great question. I just chose the 168 hitters with the most projected ABs. But you made me second guess myself. And upon further review, that’s probably not the best means to identify the top 168 hitters.

The method KG describes is probably the best way to identify the top 168. But I also thought it would be helpful to quantify the difference between the two methods.

Above I mention the formula for BA is “=(([@H]+1768)/([@AB]+6617)-0.267)/0.0024″, where 1,768 represents the average number of hits for a team, and where 6,617 represents the number of at bats the average team hits.

That is based upon the average hitter having 509 ABs and 136 H (for a .267 average).

If I look at the top 168 players after I’ve ranked them (and not just the 168 with the most ABs), the average player is projected for 495 ABs (instead of 509).

A .267 BA on 495 ABs would assume 132.2 H (.267 * 495).

That means the average team would have 1,851 H (14 * 132.2) and 6,930 AB (14 * 495). Adjusting that to the 13 players necessary to calculate one player’s impact is 1,719 H (13 * 132.2) and 6,435 AB (13 * 495)..

Running Trout’s 2013 Steamer projection (184 H, 619 AB) through yields the following:

(184 + 1,719)/(619 + 6,435) = 1,903 / 7,054 = .26977 New Team BA.

.26977 – .267 = .00277

.00277 / .0024 = 1.154

So Trout’s SGP on the top 168 players is 1.154. When I ran it on the 168 with the most ABs, it came out to 1.151. So the difference is negligible. But in a perfect world, you should do an analysis similar to what KG suggests.

Would you adjust the SPG formulas posted above if the league is a 10 person league rather than a 12 person league? I’d imagine it would shift the values some…just not sure if it’s significant enough to need to recalculate. Thanks!

There’s only 9 hitters per team in my 12 teamer. Since I don’t have access to past years’ data, would you expect using your/or other public SGP values to be in the realm of correctness?

I think using the SGP method is still sound. But you need to make an important adjustment in the calculations. You need to adjust replacement level for your specific league.

For example, if you’re in a 10-team league instead of 12-team, you won’t use the 24th catcher as replacement level (assuming a 2 catcher league). It might instead be the 20th catcher.

Or if it’s a 12-team league with 9 hitters, you might use the 12th catcher.

You can use the rough SGP calculations, but you HAVE to adjust replacement level for your own league’s roster sizes.

Once you get some final standings for the league, then you could refine the calculations by calculating the SGP factors.

Tanner, I am in a 10 team, mixed, standard 5×5 league. How can I change the formulas in the SFBB-Rankings-Part-4.xlsx for use with my team in this 10-team league? Thanks. I appreciate how you freely share your information. Love this site. Unfortunately for you, I won’t be sharing this site with my league-mates, but perhaps others who play in different leagues.

Hi Matt. Unfortunately, I don’t have an established history for 10-team leagues to draw from. If you have an established league history where you can access prior season standings, you can calculate these things yourself using the “What It Takes To Win Your League” tool.

But even if you don’t have past standings to draw from, I think you will still get meaningful results from using the same formulas I have listed on the site here.

As I mentioned right above here, the very important adjustment you must make is in determining replacement level for the 10-team league. Use your actual roster composition and the fact that you’re a 10-team league to figure out who the replacement level C, 1B, 2B, etc. are in your league.

Hey my league is a 10-team mixed league but only in our second year. Added new GMs as two didn’t even pay attention to their teams last year. So don’t trust the differences in points. You know a place to find 10-team league SPG numbers?

Ignore my question just saw your reply to March 5 post.

Thx

I’m just wondering if I should use different formulas for Starters and Relievers. I’m in a 10 team league with 5 starters and 3 relievers per team. Our categories are W, L, HR against, ERA, K/9, BB/9, H/9, SV. As you can see there are many ratio stats there, so relievers have more value. After doing this exercise however, the discrepancy is too large (all relievers are worth more than any starter).

So let’s assume all my numbers are without error (doubtful), I still wouldn’t pick Kimbrel ahead of Kershaw, no one would, but if I separated out the RP and SP, I could wait til people start picking relievers and use my RP list a that point.

I could use the IP and ER averages for the top 50 starters, and do the same for the top 30 relievers and make separate ranks. Maybe I’m way off track.

Thoughts?

Maybe not my place, but my way of getting around this issue was simply converting ratio stats into counting stats. My excel formula looks like this: =([@ER]*9-([@IP]*AVERAGE($Q$2:$Q$264)))*-1 where Q is ERA. This works for any stat, take the numerator and multiply by the denominator*the league average for that ratio stat. I went with z-scores over SGP in the end (lack of league history plus I think SGP works better for roto leagues, I only play 20 team H2H) so I am not sure how you would calculate SGP from that.

*subtract the denominator, not multiply, sorry.

You will want to treat those categories like Tanner has treated the other ratio categories. “Does the fact that Trout will hit .297 over nearly 200 more at bats make him more valuable? Or does Tulowitzki’s .300 average make him the better “batting average contributor”?” Think 200+ IP of Kershaws’ K/9 vs 60 IP of a Kimbrel.

Hi Jimmy. If your categories really are W, L, HR against, ERA, K/9, BB/9, H/9, and SV, then I think it makes sense for relievers to have more value than starters. A reliever will have fewer losses, fewer HR against, a lower ERA, better ratio stats, and more saves. The only benefit to having starters is the W category.

I do not think it’s necessary to treat SP and RP as different groups. But you should calculate replacement level separately for the two groups. The calculations will all be the same, but starters will be compared to replacement level starters and relievers compared to replacement level relievers.

If you follow the formulas for weighting the stats, you’ll be fine.

Hey thanks AT and Drew,

AT – Where do you find z-scores? I must have missed something.

Drew – I agree, I’m just thinking from a strategy point of view; with our cats, my numbers say RPs are worth the most, but strategically it doesn’t make sense for me to pick RPs in the 3rd round for e.g. So I’m just looking for relative value between SPs and RPs, I understand the contribution aspect, but I will just use my RP list when guys start drafting RPs.

Z-scores are different from SGP and simpler to integrate. You just standardize all the stat columns your league uses and add them together. For example, my z-scores for K/BB: =STANDARDIZE([@XKBB],AVERAGE($T$2:$T$180),STDEV($T$2:$T$180)) Where T is XKBB, which is K/BB converted to a counting stat. Then you just mash them together. My rankings passed the sniff test, so I’m happy with it. It’s just an alternate to SGP.

My league is switching over from AVG to OBP. Any advice on adjusting ranking calculations for OBP without inflating its overall weight?

PEDex, here’s a link to a discussion of how to calculate SGP for OBP.

Tanner, being a neophyte at ;Excel, I do not know how to do this one thing other than manual. I would like to grab the PlayerID, LN, FN, POS, and TTLSGP columns from both the Hitter Ranks and Pitcher Ranks tables and merge them into one worksheet and table so I can compare the pitcher and hitter Totals at a glance w/o having to toggle back and forth between sheets. How do I do this? I will have enough to do on draft day (two draft day software pkgs. [I might buy a 3rd b4 DD], and at least three spreadsheets besides your SGP sheets). So, I don’t want to be toggling any more than necessary. BTW, just bought the entire 10 chapters so I could read up on the impact of keepers; I am in a keeper league.

Thanks

I’m seeing this article almost two years later, but…

When calculating the SGP value of AVG, for example, what’s the advantage of using the Razzball average AVG (or even the average AVG from one’s own fantasy league) as opposed to using the projected average of those top 168 hitters per the projections? Given the yearly changes in the MLB run-scoring environment, wouldn’t using the projected averages of those players provide a better baseline?

I’m assuming, of course, that projections consider those trends, which they do, b/c they consider the trends in each individual player’s production. If there’s a league-wide decline in AVG, that’s the culmination of individuals’ AVGs declining.

But previous year’s data, taken statically, doesn’t account for that.

Bert, yes. I’m completely in agreement with you. Instead of using the .267 BA, 3.59 ERA, and 1.23 WHIP I pulled from Razzball at the time of this article, I would rather determine what the projected BA is of the top 168 hitters and what the ERA and WHIP are of the top 108 pitchers, and then use that as my baseline.

The other thing this does is it will conform more precisely to your league size. I always calculate things for a 12-team league with 9 pitchers. If your league has more or less teams or more/less roster spots, the ERA/WHIP of those players will surely differ slightly as you are deeper/shallower in the player pool.

Thanks, Tanner. This is all really good stuff, and it’s already been super helpful as I create dollar values and rankings for my leagues.

Anytime. Let me know if you have any more questions.

[…] While this is a fairly standard league, I haven’t played in a similar one. I use the standard points gained (SPG) method for determining player value so any baseline is helpful. NFBC runs similar leagues […]