ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

10-25-2014

StatsLab Help Page
Glossary

AVG - Batting average; H/AB

BABIP - Batting average on balls in play; (H-HR)/(AB-K-HR+SF)

BB/K - Walks per strikeout

BB/9 - Walks allowed per 9 innings pitched

BF - Batters Faced

BS - Blown Saves

CG% - Complete game percentage; CG/GS

DEff - Defensive Efficiency (H-E)/(PA-BB-K-HP-HR)

EBH - Extra base hits; 2B+3B+HR

EqA - Equivalent Average

ERA+ - Adjusted ERA, park adjusted and relative to league average

ERC - Component ERA

GB% - Ground ball percentage; GB/(GB+FB)

GDP - Ground into double play

GF - Games finished

H/9 - Hits allowed per 9 innings pitched

HP - Hit by pitch

HR/9 - Home runs allowed per 9 innings pitched

Inn - Defensive innings played

ISO - Isolated power (TB-H)/AB

K/BB - Strikeouts per walk

K/9 - Strikeouts per 9 innings pitched

OBP - On-base percentage; (H+BB+HP)/(AB+BB+HP+SF)

OPS - On-base plus slugging; OBP+SLG

OPS+ - Adjusted OPS, park adjusted and relative to league average

Outs - Batter generated outs; AB-H+CS+SH+SF

OWS - Offensive Win Shares

PA/HR - Plate appearances per home run hit

Pct - Fielding percentage; (PO+A)/TC

PFhr - Park factor - home runs

PFr - Park factor - runs

PI - Pitches thrown

PS - Pitches seen

PS/PA - Pitches seen per plate appearance

PwrSpd - Power-Speed number; (2*HR*SB)/(HR+SB)

PWS - Pitching Win Shares

QS% - Quality start percentage; QS/GS

R/9 - Runs allowed per 9 innings pitched

Range - Range factor; 9*(PO+A)/Inn

RC - Runs created; ((H+BB-CS+HBP-GDP)*(TB+(.26*(BB-IBB+HBP))+(.52*(SH+SF+SB))))/(AB+BB+HBP+SH+SF)

RC/27 - Runs created per 27 outs

RSTA - Runner steal attempts against

RTO - Runners thrown out

RTO% - Runner thrown out percentage; RTO/RSTA

SB% - Stolen base success rate; SB/(SB+CS)

Sim Score Diff - Similarity Score Difference. On the leaderboards search, this will display the most unique/similar players. Unique players are those with the lowest Similarity Score for their most similar player. The value displayed is 1000 minus the Similarity Score of the most similar player

SLG - Slugging percentage; (1B+2*2B+3*3B+4*HR)/AB

SVO - Save opportunities

SV% - Save percentage; SV/(SV+BS)

TB - Total bases; 1B+2*2B+3*3B+4*HR

TOB - Times on base; H+BB+HP

TTO - Three true outcomes; HR+K+BB

UER - Unearned runs (R-ER)

VORP - Value over replacement player

WHIP - Walks plus hits per innings pitched; (H+BB)/IP

wOBA - Weighted On-Base Average; (0.72*BB+0.75*HP+0.9*(H-2B-3B-HR)+0.92*RBOE+1.24*2B+1.56*3B+1.95*HR)/PA;
Note - OOTP does not provide RBOE data, so 0 RBOE is used

WS - Win Shares

League leading stats that are tracked by OOTP are displayed on the player page with an underline. Any performance that finishes in the top 10 in a league will display at the bottom of the player page. OOTP only tracks league leading stats in years simmed in OOTP. Historical seasons prior to play in OOTP will not display. Stats tracked by OOTP are the following:

Batting Statistics
GS, PA, AB, H, K, TB, 2B, 3B, HR, SB, RBI, R, BB, IBB, HBP, SH, SF, EBH, AVG, OBP, SLG, RC, RC/27, ISO, TAVG, OPS, VORP

Pitching Statistics
G, GS, W, L, Win%, SV, HLD, IP, BF, HRA, BB, K, WP, ERA, BABIP, WHIP, K/BB, RA/9IP, HR/9IP, H/9IP, BB/9IP, K/9IP, VORP, RA, GF, QS, QS%, CG, CG%, SHO, GB%

This test awards points to players based on career numbers. It gives a score of 50 for an average Hall of Famer, with 100 as the intended max. It is used to measure the overall quality of a player's career as opposed to singular brilliance (peak value).

Batting Statistics

  •  
  • One point for each 150 hits above 1500, limit 10.
  • One point for each 100 runs over 900, limit 8.
  • One point for each 100 rbi's over 800, limit 8.
  • One point for each 200 home runs.
  • One point for each 200 extra base hits over 300, limit 5.
  • One point for each 200 walks over 300, limit 5.
  • One point for each 100 stolen bases, limit 5.
  • Additional points based on primary position:
    • 20 - Catcher
    • 16 - Shortstop
    • 14 - Second Base
    • 13 - Third Base
    • 12 - Center Field
    • 6 - Right Field
    • 3 - Left Field
    • 1 - First Base
    • 0 - Designated Hitter

For each of the following a minimum of 300 plate appearances is required before these points are added.

  •  
  • One point for each .005 of batting average above .275, limit 9
  • One point for batting over .300
  • One point for scoring more than .500 runs per game.
  • One point for scoring more than .644 runs per game.
  • One point for driving in more than .500 runs per game.
  • One point for driving in more than .600 runs per game.
  • One point for each .025 of slugging percentage above .300, limit 10
  • One point for each .010 of on-base percentage above .300, limit 10
  • One point if home runs are more than 10% of hits.
  • One point if home runs are more than 20% of hits.

Pitching Statistics

  •  
  • One point for each 10 wins over 100, limit 25.
  • One point for each 20 games over .500, limit 10.
  • One point for each 200 strikeouts over 1000, limit 10.
  • One point for each 1000 innings above 1000, limit 5.
  • One point for each 100 complete games above 200, limit 5. Changed from James's slightly
  • One point for each 30 shutouts, limit 5.

For each of the following a minimum of 100 innings is required before these points are added.

  •  
  • One point for each .013 of winning percentage above .500, limit 15.
  • One point for each .20 of ERA below 4.00, limit 10.
  • One point for each .30 of BB/9IP below 4.00, limit 10.
  • One point for each .30 of H/9IP below 10.00, limit 10.

The Black and Gray Ink Scores award points to player based on leaderboard finishes. Black Ink points are awarded for leading the league in a category, while Gray Ink points are awarded for each top 10 finish. Points are awarded as follows:

Batting Statistics

  •  
  • 4 pts - HR, RBI, AVG
  • 3 pts - R, H, SLG
  • 2 pts - 2B, BB, SB
  • 1 pt - G, AB, 3B

Pitching Statistics

  •  
  • 4 pts - W, ERA, K
  • 3 pts - IP, W/L Pct, SV
  • 2 pts - CG, BB/9, H/9
  • 1 pt - G, GS, SHO

Similarity Scores are designed to compare players based on their statistical accomplishments. Players are compared by starting with a score of 1000, and then subtracting based on statistical differences.

Batters

  •  
  • One point for each difference of 20 games played
  • One point for each difference of 75 at bats
  • One point for each difference of 10 runs scored
  • One point for each difference of 15 hits
  • One point for each difference of 5 doubles
  • One point for each difference of 4 triples
  • One point for each difference of 2 home runs
  • One point for each difference of 10 RBI
  • One point for each difference of 25 walks
  • One point for each difference of 150 strikeouts
  • One point for each difference of 20 stolen bases
  • One point for each difference of .001 in batting average
  • One point for each difference of .002 in slugging percentage

In addition, batters are further differentiated by position. Each position has a value, and twelve times the difference between the two player's positions is subtracted as well. Position values are as follows:

  •  
  • 20 - Catcher
  • 14 - Shortstop
  • 11 - Second Base
  • 7 - Third Base
  • 5 - Center Field
  • 4 - Right Field
  • 3 - Left Field
  • 1 - First Base
  • 0 - Designated Hitter

Pitchers

  •  
  • One point for each difference of 1 win
  • One point for each difference of 2 losses
  • One point for each difference of .002 in winning percentage (max 100 points)
  • One point for each difference of .02 in ERA (max 100 points)
  • One point for each difference of 10 games pitched
  • One point for each difference of 20 games started
  • One point for each difference of 20 complete games
  • One point for each difference of 50 innings pitched
  • One point for each difference of 50 hits allowed
  • One point for each difference of 30 strikeouts
  • One point for each difference of 10 walks
  • One point for each difference of 5 shutouts
  • One point for each difference of 3 saves

In addition, pitchers are assigned a role. A relief pitcher is determined as having more relief appearances than starts and a maximum of 4 innings per appearance.

  •  
  • Subtract 10 points if the pitchers are starters and threw with different hands
  • Subtract 25 points if the pitchers are relievers and threw with different hands
  • For relievers, halve the winning percentage penalty and allow it to go up to 1.5 times the wins and losses penalty

Win Shares attempt to assign players a single value to represent their contribution to their team's success over the course of a season. Win shares are divided up between batting, pitching, and defensive contributions, and each win share represents 1/3 of a team win. For more information on how win shares are calculated, see the book 'Win Shares', by Bill James. Some accomodation has been made in the calculation of Win Shares in StatsLab where OOTP does not provide sufficient detail, however, these are relatively minor.

StatsLab SQL Utilities for OOTP12 v.0.0.1
Saturday, October 25th, 2014