The park and league adjustments present some challenges, though. \u00a0First, I was warned not to use the park factors from the park tables. \u00a0This is a huge bummer because it would have saved me a ton of difficult work. \u00a0In fact, I am going to try using the park factors from that table as a starting point, just to be sure it won’t work. \u00a0I am really not looking forward to doing those calcs myself.<\/p>\n
The league adjustments won’t be as big of an issue. I can use the team_affiliations table to determine subleague (i.e. AL vs NL) for each player – or I can ignore it altogether. \u00a0I am thinking of disregarding subleagues because I haven’t noticed much difference between my leagues in game play. \u00a0I never use the DH, so offense isn’t skewed by that. \u00a0I will try it and see how easy it is.<\/p>\n
The formula, per Fangraphs, is: Let’s break this down bit by bit.<\/p>\n I have to do something about identifying subleagues and summing their data before I start coding this formula. \u00a0At this point, I only need runs and PA. \u00a0Since I am eager to keep moving, those are the only stats I’ll create. \u00a0I created a quick table with those summed stats, joining on the team relations table:<\/p>\n OK, before the results, let’s set some initial expectations. \u00a0Fangraphs<\/a>‘ rule of thumb chart is below. \u00a0It suggests, I think, that if I get within 10 points, I can trust that I’m in the right ballpark. \u00a0It won’t be super accurate for precise comparisons between players, but I can probably trust it for general analysis.<\/p>\n And here are the results – randomly selected player years.<\/p>\n At this point, I am not comfortable using this stat as a basis for any decision-making. \u00a0I’m also not ready to dive in and determine the park factors. \u00a0So, at least for the time being, I am going to leave this here and move on to pitching stats.<\/p>\n Here’s the script:<\/p>\n I will be writing this as I work through it, so this may be a little disjointed and have some false starts, but what the heck. wRC+ is similar to wRC and wRAA in that it measures runs created by a batter in a particular league-year context. \u00a0The most significant differences are that wRC+ is… Continue reading Batting Stats 10: wRC+<\/span>
\n((wRAA\/PA + League Runs Per PA) + (League Runs Per PA - (Park Factor*League Runs Per PA) \/ (Subleague wRC\/PA)) ALL x 100\u00a0<\/code><\/p>\n\n
\n
\n
\n
\n
\n
\n
\n
\n
DROP TABLE IF EXISTS sub_league_history_batting;\r\nCREATE TABLE IF NOT EXISTS sub_league_history_batting AS\r\n (SELECT b.year\r\n , b.league_id\r\n , t.sub_league_id\r\n , sum(b.PA) as slg_PA\r\n , sum(b.r) as slg_r\r\n FROM CalcBatting b\r\n INNER JOIN team_relations t ON b.team_id=t.team_id AND b.league_id=t.league_id\r\n INNER JOIN players p ON b.player_id=p.player_id\r\n WHERE p.position<>1\r\n GROUP BY b.year, b.league_id, t.sub_league_id\r\n );<\/code><\/pre>\n![\"\"](\"https:\/\/i0.wp.com\/www.ootp.cavebutter.net\/blog\/wp-content\/uploads\/2018\/03\/fangraphs_wrc.jpg?resize=604%2C151\")
<\/a><\/p>\n![\"\"](\"https:\/\/i0.wp.com\/www.ootp.cavebutter.net\/blog\/wp-content\/uploads\/2018\/03\/wrcplus.jpg?resize=526%2C466\")
<\/a>Pretty ugly, actually. \u00a019 of 30 are in the happy zone. \u00a0Of course, the happy zone is really much bigger than I would like it to be. \u00a08 are borderline, and the remaining 3 are just awful. \u00a0Some are high; some are low.<\/p>\n#Calculated batting stats for OOTP\r\n DROP TABLE IF EXISTS CalcBatting;\r\n CREATE TABLE IF NOT EXISTS CalcBatting AS\r\n\r\n SELECT b.year\r\n , b.league_id\r\n , b.player_id\r\n , b.stint #We can eventually move this down the list\r\n , b.split_id #We can eventually remove\r\n , b.team_id #We can eventually move this down the list\r\n , l.abbr as Lg\r\n , t.abbr as Team\r\n , b.g\r\n , b.ab\r\n , @PA := b.ab+b.bb+b.sh+b.sf+b.hp AS PA\r\n , b.r \r\n , b.h\r\n , b.d\r\n , b.t\r\n , b.hr\r\n , b.rbi\r\n , b.sb\r\n , b.cs\r\n , b.bb\r\n , b.k\r\n , b.ibb\r\n , b.hp\r\n , b.sh\r\n , b.sf\r\n , b.gdp\r\n , b.ci\r\n , @BA := round(b.h\/b.ab,3) AS ba\r\n , round(b.k\/@PA,3) as krate\r\n , round((b.bb)\/@PA,3) as bbrate\r\n , @OBP := round((b.h + b.bb + b.hp)\/(@PA-b.sh-b.ci),3) AS obp\r\n , round(100*(@OBP\/r.woba),0) as OBPplus\r\n , @SLG := round((b.h+b.d+2*b.t+3*b.hr)\/b.ab,3) as slg\r\n , round(@OBP+@SLG,3) as ops\r\n , round(@SLG-@BA,3) as iso\r\n , round((b.h-b.hr)\/(b.ab-b.k-b.hr+b.sf),3) as babip\r\n , @woba := round((r.wobaBB*(b.bb-b.ibb) + r.wobaHB*b.hp + r.woba1B*(b.h-b.d-b.t-b.hr) +\r\n r.woba2B*b.d + r.woba3B*b.t + r.wobaHR*b.hr)\r\n \/(b.ab+b.bb-b.ibb+b.sf+b.hp),3) as woba\r\n , @wRAA := round(((@woba-r.woba)\/r.wOBAscale)*@PA,1) as wRAA\r\n , round((((@woba-r.woba)\/r.wOBAscale)+(lro.totr\/lro.totpa))*@PA,1) as wRC\r\n , ROUND((((@wRAA\/@PA + lro.RperPA) + (lro.RperPA - p.avg*lro.RperPA))\/(slg.slg_r\/slg.slg_pa))*100,0) as 'wRC+'\r\n FROM \r\n players_career_batting_stats b \r\n INNER JOIN leagues l ON b.league_id=l.league_id \r\n INNER JOIN teams t ON b.team_id=t.team_id\r\n INNER JOIN tblRunValues2 r ON b.year=r.year AND b.league_id=r.league_id\r\n INNER JOIN vLeagueRunsPerOut lro ON b.year=lro.year AND b.league_id=lro.league_id\r\n INNER JOIN parks p ON t.park_id=p.park_id\r\n INNER JOIN sub_league_history_batting slg ON t.sub_league_id=slg.sub_league_id AND b.league_id=slg.league_id\r\n WHERE b.ab<>0 AND b.split_id=1\r\n ORDER BY b.player_id, b.year<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"