+- First Class Mogul (https://www.firstclassmogul.com)
+-- Forum: General (https://www.firstclassmogul.com/forumdisplay.php?fid=1)
+--- Forum: League News (https://www.firstclassmogul.com/forumdisplay.php?fid=5)
+--- Thread: Comp Formula As Requested (/showthread.php?tid=18462)
Comp Formula As Requested - jhc54 - 03-17-2013
*Group 1: 1B/3B/LF/RF
replace COMPOSITE= ( (pa/37.5) + (avg * 50) + (obp * 66.67) + (hr/2) + (rbi/7.5) ) if p=="1B" | p=="3B" | p=="LF" | p=="RF"
replace GROUP=1 if p=="1B" | p=="3B" | p=="LF" | p=="RF"
drop if GROUP==1 & pa<100
*Group 2: 2B/SS/CF
replace COMPOSITE = ( (pa/40) + (avg * 50) + (obp * 37) + (hr/3.33) + (rbi/8) + ((rng+fld)/15) + (sb/7) ) if p=="2B" | p=="SS" | p=="CF"
replace GROUP=2 if p=="2B" | p=="SS" | p=="CF"
drop if GROUP==2 & pa<100
*Group 3: C
replace COMPOSITE = ( (pa/29.5) + (avg*45) + (obp*48) + (hr/1.9) + (rbi/8.33) + (rto/2.5)) if p=="C"
replace GROUP=3 if p=="C"
drop if GROUP==3 & pa<100
*Group 4: SP
replace COMPOSITE= (((((games-starts)*.5)+starts)/2.33) + (ip/25) + ((w+sv)/1.67) + (20/whip) + (k9*1.37) + (3 / hr9) + (30/era) ) if p=="SP"
replace GROUP=4 if p=="SP"
drop if GROUP==4 & ip<50
*Group 5: RP
replace starts=0 if p=="RP"
replace hr9=.01 if hr9==0 & p=="RP"
replace COMPOSITE= ((((games-starts)+(starts*2))/8) + (ip/10) + ((w+sv)/2.5) + (20/whip) + (k9*1.2) + (3/hr9) + (30/era) ) if p=="RP"
replace GROUP=5 if p=="RP"
drop if GROUP==5 & ip<20