ERA+ = 100 * (2 - (ERA\/lgERA) * 1\/ParkFactor)<\/code><\/p>\nNo additional joins are needed for this, so we can just plug it in. \u00a0Let’s do it and check our results.<\/p>\n
![\"\"](\"https:\/\/i0.wp.com\/www.ootp.cavebutter.net\/blog\/wp-content\/uploads\/2018\/03\/ERAplus-v1.jpg?resize=666%2C551\")
<\/a>Awful. \u00a0Just awful. \u00a01\/3 of the result set was hugely off, and only about half was within 5 percent.<\/p>\nWe’ll try the original recipe for this stat and see if we get better luck. \u00a0That one is:<\/p>\n
ERA+ = 100 * (lgERA\/ERA) * ParkFactor<\/code><\/p>\nAnd the results:<\/p>\n
![\"\"](\"https:\/\/i0.wp.com\/www.ootp.cavebutter.net\/blog\/wp-content\/uploads\/2018\/03\/ERAplus-v2.jpg?resize=687%2C549\")
<\/a>Much, much better. \u00a024 within 5 points and only 1 more than 10. \u00a0And that one is also one that was way off on the first try. \u00a0I am good to keep this version and even to use it for evaluative purposes. \u00a0I think the difference between this and the game is probably down to park factors. \u00a0Here’s the CalcPitching table to this point:<\/p>\nDROP TABLE IF EXISTS CalcPitching;\r\nCREATE TABLE IF NOT EXISTS CalcPitching AS\r\n\r\nSELECT\r\n i.player_id\r\n , i.year\r\n , i.stint\r\n , i.team_id\r\n , i.league_id\r\n , r.sub_league_id\r\n , split_id\r\n , i.ip\r\n , i.ab\r\n , i.tb\r\n , i.ha\r\n , i.k\r\n , i.bf\r\n , i.rs\r\n , i.bb\r\n , i.r\r\n , i.er\r\n , i.gb\r\n , i.fb\r\n , i.pi\r\n , i.ipf\r\n , i.g\r\n , i.gs\r\n , i.w\r\n , i.l\r\n , i.s\r\n , i.sa\r\n , i.da\r\n , i.sh\r\n , i.sf\r\n , i.ta\r\n , i.hra\r\n , i.bk\r\n , i.ci\r\n , i.iw\r\n , i.wp\r\n , i.hp\r\n , i.gf\r\n , i.dp\r\n , i.qs\r\n , i.svo\r\n , i.bs\r\n , i.ra\r\n , i.cg\r\n , i.sho\r\n , i.sb\r\n , i.cs\r\n , i.hld\r\n , i.ir\r\n , i.irs\r\n , i.wpa\r\n , i.li\r\n , i.outs\r\n , i.war\r\n , @InnPitch := ((3*ip)+ipf)\/3 AS InnPitch\r\n , round((9*i.k)\/@InnPitch,1) AS 'k9'\r\n , round((9*i.bb)\/@InnPitch,1) AS 'bb9'\r\n , round((9*i.hra)\/@InnPitch,1) AS 'HR9'\r\n , round((i.bb+i.ha)\/@InnPitch,2) AS WHIP\r\n , round(i.k\/i.bb,2) AS 'K\/BB'\r\n , i.gb\/i.fb AS 'gb\/fb'\r\n , round((i.ha-i.hra)\/(i.ab-i.k-i.hra-i.sh+i.sf),3) AS BABIP\r\n , @ERA := round((i.er\/@InnPitch)*9,2) AS ERA\r\n , round(((13*i.hra)+(3*(i.bb+i.hp))-(2*i.k))\/@InnPitch+f.FIPConstant,2) AS FIP \r\n , round(((13*(i.fb*f.hr_fb_pct))+(3*(i.bb+i.hp))-(2*i.k))\/@InnPitch+f.FIPConstant,2) AS xFIP\r\n , round(100*((@ERA + (@ERA - @ERA*(p.avg)))\/slg.slgERA),0) AS ERAminus\r\n , round(100*(slg.slgERA\/@ERA)*p.avg,0) AS ERAplus\r\n \r\n FROM players_career_pitching_stats AS i\r\n INNER JOIN team_relations AS r ON i.team_id=r.team_id AND i.league_id=r.league_id\r\n INNER JOIN FIPConstant AS f ON i.year=f.year AND i.league_id=f.league_id\r\n INNER JOIN sub_league_history_pitching AS slg ON i.year=slg.year AND i.league_id=slg.league_id AND r.sub_league_id=slg.sub_league_id\r\n INNER JOIN teams AS t ON i.team_id=t.team_id\r\n INNER JOIN parks AS p ON t.park_id=p.park_id\r\nWHERE i.split_id=1 AND i.league_id<>0;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"This one may prove to be tricky, if only because there are a couple of ways to calculate it. \u00a0Baseball-Reference says they calculate it one way, Wikipedia says that bb-ref used to calculate it that way, but then they changed. \u00a0So, we may see some variation here. \u00a0Frankly, I’m not even sure why I’d want… Continue reading Pitching Stats 6: ERA+<\/span>
![\"\"](\"https:\/\/i0.wp.com\/www.ootp.cavebutter.net\/blog\/wp-content\/uploads\/2018\/03\/ERAplus-v1.jpg\")
<\/a>Awful. \u00a0Just awful. \u00a01\/3 of the result set was hugely off, and only about half was within 5 percent.<\/p>\n