Batting Stats 8: wRC

Weighted Runs Created (wRC) is a counting stat that sums the weighted total offensive production of a player in terms of runs.  It tells you how many runs a player produced through his offense in a given time period.  It’s based on the same linear weights as wOBA.  In fact, it’s derived completely from wOBA.  Essentially, it takes the difference between the player’s wOBA and the league wOBA divided by the wOBAscale, plus the league runs per PA, and multiplies it by the player’s plate appearances:

round((((@woba-lg_woba)/wOBAscale)+(lg_.totr/lg_.totpa))*PA,1)

The results I got in my testing were pretty good.  This makes some sense as my wOBA results are also pretty good, and this stat is derived from that one.  Still, it’s a bit of a relief.  I decided that my testing threshold for this stat would be 3.5.  Fangraphs suggests that increments of 10 wRC separate the awful from the poor, and the average from the above average.  I figure that by keeping my threshold well below half of that, I can be reasonably confident that my stats will be in the right neighborhood as those the game generates.

I’m really pretty pleased with this.  Note that this particular sample is pretty representative, and doesn’t contain any players that are at the top of the league.  The fringy cases may still be problematic, but I am good to move on.

The script as it stands now:

#Calculated batting stats for OOTP
    DROP TABLE IF EXISTS CalcBatting;
    CREATE TABLE IF NOT EXISTS CalcBatting AS

    SELECT b.year
    , b.league_id
    , b.player_id
    , b.stint #We can eventually move this down the list
    , b.split_id #We can eventually remove
    , b.team_id #We can eventually move this down the list
    , l.abbr as Lg
    , t.abbr as Team
    , b.g
    , b.ab
    , @PA := b.ab+b.bb+b.sh+b.sf+b.hp AS PA
    , b.r 
    , b.h
    , b.d
    , b.t
    , b.hr
    , b.rbi
    , b.sb
    , b.cs
    , b.bb
    , b.k
    , b.ibb
    , b.hp
    , b.sh
    , b.sf
    , b.gdp
    , b.ci
    , @BA := round(b.h/b.ab,3) AS ba
    , round(b.k/@PA,3) as krate
    , round((b.bb)/@PA,3) as bbrate
    , @OBP := round((b.h + b.bb + b.hp)/(@PA-b.sh-b.ci),3) AS obp
    , round(100*(@OBP/r.woba),0) as OBPplus
    , @SLG := round((b.h+b.d+2*b.t+3*b.hr)/b.ab,3) as slg
    , round(@OBP+@SLG,3) as ops
    , round(@SLG-@BA,3) as iso
    , round((b.h-b.hr)/(b.ab-b.k-b.hr+b.sf),3) as babip
    , @woba := round((r.wobaBB*(b.bb-b.ibb) + r.wobaHB*b.hp + r.woba1B*(b.h-b.d-b.t-b.hr) +
       r.woba2B*b.d + r.woba3B*b.t + r.wobaHR*b.hr)
       /(b.ab+b.bb-b.ibb+b.sf+b.hp),3) as woba
    , round((((@woba-r.woba)/r.wOBAscale)+(lro.totr/lro.totpa))*@PA,1) as wRC
    /* NOT yet modified for OOTP and MySQL
    , ((([wRAA]/[PA] + l.RperPA) + (l.RperPA - t.bpf*l.RperPA))/(lb.wRC/lb.PA))*100 AS [wRC+]
    */
    FROM 
      players_career_batting_stats b 
      INNER JOIN leagues l ON b.league_id=l.league_id 
      INNER JOIN teams t ON b.team_id=t.team_id
      INNER JOIN tblRunValues2 r ON b.year=r.year AND b.league_id=r.league_id
      INNER JOIN vLeagueRunsPerOut lro ON b.year=lro.year AND b.league_id=lro.league_id
    WHERE b.ab<>0 AND b.split_id=1
    ORDER BY b.player_id, b.year