Formulas for every HM Stat! (Updated Nov 12, 2009)

[Rvg72]

I figure the best way to teach people how to make their own stats at this point is to release the definitions for every current stat. So here it is:

<Stat GroupName="Default" ColumnName="bbPer100" ValueExpressions="Sum(ph.NetAmountWon/1.0/GT.BigBlind) as TotalBBs" Evaluate="TotalBBs*100.0/TotalHands" ColumnHeader="bb/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Big Blinds won per 100 hands" />

<Stat GroupName="Default" ColumnName="BBPer100" ValueExpressions="Sum(ph.NetAmountWon/1.0/GT.BigBlind) as TotalBBs" Evaluate="TotalBBs*50.0/TotalHands" ColumnHeader="BB/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Big Bets won per 100 hands" />

<Stat GroupName="Default" ColumnName="NetAmountWon" ValueExpressions="Sum(ph.NetAmountWon)/100.0 as NetAmountWon" Evaluate="NetAmountWon" ColumnHeader="$" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Net Amount Won" />

<Stat GroupName="Default" ColumnName="StdDevbigblind" ValueExpressions="10*stddev(ph.NetAmountWon/GT.BigBlind) as StdDevbigblinds; 1 as DenomOfOne;" Evaluate="StdDevbigblinds/DenomOfOne" ColumnHeader="Std Dev\nbb" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Standard Deviation" />

<Stat GroupName="Default" ColumnName="StdDevbigbet" ValueExpressions="10*stddev(ph.NetAmountWon/2.0/GT.BigBlind) as StdDevbigbets; 1 as DenomOfOne;" Evaluate="StdDevbigbets/DenomOfOne" ColumnHeader="Std Dev\nBB" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Standard Deviation" />

<Stat GroupName="Default" ColumnName="AmountWonwoBlinds" ValueExpressions="Sum(ph.NetAmountWon)/100.0 as NetAmountWon;Sum(phmisc.Postamountpreflop)/100.0 as AmountPosted;" Evaluate="NetAmountWon+AmountPosted" ColumnHeader="$ without\nblinds" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Total amount won with posting of blinds removed" />

<Stat GroupName="Default" ColumnName="VPIP" ValueExpressions="sum(case when didvpip = true then 1 else 0 end) as VPIPHands; sum(case when ph.preflopaction_id <> -1 then 1 else 0 end) as TotalPlayableHands" Evaluate="VPIPHands*100.0/TotalPlayableHands" ColumnHeader="VPIP%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of hands player voluntarily put money in" />

<Stat GroupName="Default" ColumnName="PFR" ValueExpressions="sum(case when didpfr = true then 1 else 0 end) as PFRHands; sum(case when ph.preflopaction_id <> -1 then 1 else 0 end) as TotalPlayableHands" Evaluate="PFRHands*100.0/TotalPlayableHands" ColumnHeader="PFR%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of hands player raised" />

<Stat GroupName="Default" ColumnName="PFR/VPIP" ValueExpressions="sum(case when didpfr = true then 1 else 0 end) as PFRHands;sum(case when didvpip = true then 1 else 0 end) as VPIPHands" Evaluate="PFRHands*100.0/VPIPHands" ColumnHeader="PFR/VPIP\nRatio" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Number of times player raises preflop divided by total hands player voluntarily put in money preflop" />

<Stat GroupName="Default" ColumnName="UO PFR" ValueExpressions="sum(case when didpfr = true and ph.preflopaction_ID=0 then 1 else 0 end) as UOPFRHands;sum(case when ph.preflopaction_ID=0 then 1 else 0 end) as UOHands; " Evaluate="UOPFRHands*100.0/UOHands" ColumnHeader="UO\nPFR%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of hands player raised when nobody has played a hand yet preflop" />

<Stat GroupName="Default" ColumnName="ColdCall" ValueExpressions="sum(case when ph.preflopaction_id = 3 then 1 else 0 end) as CouldColdCall;sum(case when ph.FirstPreflopActionType_ID = 2 and (ph.preflopaction_id = 3) then 1 else 0 end) as DidColdCall;" Evaluate="DidColdCall*100.0/CouldColdCall" ColumnHeader="CC%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player calls vs a raiser with no other callers" />

<Stat GroupName="Default" ColumnName="3Bet" ValueExpressions="sum(case when ph.preflopaction_id = 3 or ph.preflopaction_id = 4 then 1 else 0 end) as CouldThreeBet;sum(case when ph.FirstPreflopActionType_ID = 3 and (ph.preflopaction_id = 3 or ph.preflopaction_id = 4) then 1 else 0 end) as DidThreeBet;" Evaluate="DidThreeBet*100.0/CouldThreeBet" ColumnHeader="3Bet%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player raises preflop when facing a raise" />

<Stat GroupName="Default" ColumnName="Won w/o SD" ValueExpressions="Sum(case when ph.MaxStreetSeen = 4 then 0 else ph.netamountwon end)/100. as TotalWonWOSD" Evaluate="TotalWonWOSD" ColumnHeader="W$woSD" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="$ won w/o showdown" />

<Stat GroupName="Default" ColumnName="Won at SD" ValueExpressions="Sum(case when ph.MaxStreetSeen < 4 then 0 else ph.netamountwon end)/100. as TotalWonatSD" Evaluate="TotalWonatSD" ColumnHeader="W$atSD" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="$ won at showdown" />

<Stat GroupName="Default" ColumnName="Rake $" ValueExpressions="Sum(ph.RakeAmount)/100.0 as RakeAmount" Evaluate="RakeAmount" ColumnHeader="Rake" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Rake Paid" />

<Stat GroupName="Default" ColumnName="Raked Hands" ValueExpressions="Sum(case when ph.RakeAmount > 0 then 1 else 0 end) as RakedHands" Evaluate="RakedHands" ColumnHeader="Raked\nHands" ColumnFormat="0" ColumnWidth="60" Tooltip="Raked Hands" />

<Stat GroupName="Default" ColumnName="Raked Hands $0.25+" ValueExpressions="Sum(case when pkh.RakeAmount >= 25 then 1 else 0 end) as RakedHands25" Evaluate="RakedHands25" ColumnHeader="Raked\nHands\n$0.25+" ColumnFormat="0" ColumnWidth="60" Tooltip="Raked Hands where total rake at least 25 cents" />

<Stat GroupName="Default" ColumnName="Raked Hands $0.40+" ValueExpressions="Sum(case when pkh.RakeAmount >= 40 then 1 else 0 end) as RakedHands40" Evaluate="RakedHands40" ColumnHeader="Raked\nHands\n$0.40+" ColumnFormat="0" ColumnWidth="60" Tooltip="Raked Hands where total rake at least 40 cents" />

<Stat GroupName="Default" ColumnName="Raked Hands $1.00+" ValueExpressions="Sum(case when pkh.RakeAmount >= 100 then 1 else 0 end) as RakedHands100" Evaluate="RakedHands100" ColumnHeader="Raked\nHands\n$1.00+" ColumnFormat="0" ColumnWidth="60" Tooltip="Raked Hands where total rake at least $1" />

<Stat GroupName="Default" ColumnName="Raked Hands $2.00+" ValueExpressions="Sum(case when pkh.RakeAmount >= 200 then 1 else 0 end) as RakedHands200" Evaluate="RakedHands200" ColumnHeader="Raked\nHands\n$2.00+" ColumnFormat="0" ColumnWidth="60" Tooltip="Raked Hands where total rake at least $2" />


Roy

[Rvg72]

<Stat GroupName="3Bet" ColumnName="Squeeze" ValueExpressions="sum(case when ph.preflopaction_id = 4 then 1 else 0 end) as CouldSqueeze;sum(case when ph.FirstPreflopActionType_ID = 3 and ph.preflopaction_id = 4 then 1 else 0 end) as DidSqueeze;" Evaluate="DidSqueeze*100.0/CouldSqueeze" ColumnHeader="Sqz%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player raises preflop when facing a raise and one or more callers" />

<Stat GroupName="3Bet" ColumnName="FoldToThreeBet" ValueExpressions="sum(case when phmisc.threebetresponsetype_id = 1 then 1 else 0 end) as FoldToThreeBet;sum(case when phmisc.threebetresponsetype_id > -1 then 1 else 0 end) as FacingThreeBet;" Evaluate="FoldToThreeBet*100.0/FacingThreeBet" ColumnHeader="vs 3Bet\nFold%" ColumnFormat="0.0" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="3Bet" ColumnName="CalledThreeBet" StatGroups="3Bet" ValueExpressions="sum(case when phmisc.threebetresponsetype_id = 2 then 1 else 0 end) as CallThreeBet;sum(case when phmisc.threebetresponsetype_id > -1 then 1 else 0 end) as FacingThreeBet;" Evaluate="CallThreeBet*100.0/FacingThreeBet" ColumnHeader="vs 3Bet\nCall%" ColumnFormat="0.0" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="3Bet" ColumnName="RaisedThreeBet" StatGroups="3Bet" ValueExpressions="sum(case when phmisc.threebetresponsetype_id = 3 then 1 else 0 end) as RaiseThreeBet;sum(case when phmisc.threebetresponsetype_id > -1 then 1 else 0 end) as FacingThreeBet;" Evaluate="RaiseThreeBet*100.0/FacingThreeBet" ColumnHeader="vs 3Bet\nRaise%" ColumnFormat="0.0" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="3Bet" ColumnName="FourBetRange" StatGroups="3Bet" ValueExpressions="sum(case when phmisc.threebetresponsetype_id = 3 then 1 else 0 end) as RaiseThreeBet;sum(case when phmisc.threebetresponsetype_id > -1 then 1 else 0 end) as FacingThreeBet; sum(case when didpfr = true then 1 else 0 end) as PFRHands; sum(case when ph.preflopaction_id <> -1 then 1 else 0 end) as TotalPlayableHands" Evaluate="(RaiseThreeBet*100.0/FacingThreeBet)*(PFRHands/1.0/TotalPlayableHands)" ColumnHeader="4Bet\nRange" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of hands player 4bets with - based on PFR% x Raise 3Bet%" />

<Stat GroupName="3Bet" ColumnName="FoldToFourBet" ValueExpressions="sum(case when phmisc.Fourbetresponsetype_id = 1 then 1 else 0 end) as FoldToFourBet;sum(case when phmisc.Fourbetresponsetype_id > -1 then 1 else 0 end) as FacingFourBet;" Evaluate="FoldToFourBet*100.0/FacingFourBet" ColumnHeader="vs 4Bet\nFold%" ColumnFormat="0.0" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="3Bet" ColumnName="CalledFourBet" StatGroups="3Bet" ValueExpressions="sum(case when phmisc.Fourbetresponsetype_id = 2 then 1 else 0 end) as CallFourBet;sum(case when phmisc.Fourbetresponsetype_id > -1 then 1 else 0 end) as FacingFourBet;" Evaluate="CallFourBet*100.0/FacingFourBet" ColumnHeader="vs 4Bet\nCall%" ColumnFormat="0.0" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="3Bet" ColumnName="RaisedFourBet" StatGroups="3Bet" ValueExpressions="sum(case when phmisc.Fourbetresponsetype_id = 3 then 1 else 0 end) as RaiseFourBet;sum(case when phmisc.Fourbetresponsetype_id > -1 then 1 else 0 end) as FacingFourBet;" Evaluate="RaiseFourBet*100.0/FacingFourBet" ColumnHeader="vs 4Bet\nRaise%" ColumnFormat="0.0" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="3Bet" ColumnName="RaiseTwoRaisers" ValueExpressions="sum(case when ph.preflopaction_id = 5 then 1 else 0 end) as FacingTwoRaisers;sum(case when ph.FirstPreflopActionType_ID = 3 and ph.preflopaction_id = 5 then 1 else 0 end) as RaisedTwoRaisers;" Evaluate="RaisedTwoRaisers*100.0/FacingTwoRaisers" ColumnHeader="Rse vs\n2PFR's" ColumnFormat="0.0" ColumnWidth="65" Tooltip="% of times player raises preflop when facing two or more raisers" />

<Stat GroupName="3Bet" ColumnName="CallTwoRaisers" ValueExpressions="sum(case when ph.preflopaction_id = 5 then 1 else 0 end) as FacingTwoRaisers;sum(case when ph.FirstPreflopActionType_ID = 2 and ph.preflopaction_id = 5 then 1 else 0 end) as CalledTwoRaisers;" Evaluate="CalledTwoRaisers*100.0/FacingTwoRaisers" ColumnHeader="Call\n2PFR's" ColumnFormat="0.0" ColumnWidth="65" Tooltip="% of times player calls preflop when facing two or more raisers" />

<Stat GroupName="3Bet" ColumnName="OverallRaise3Bet" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and didPFR=true then 1 else 0 end) as OverallRaise;sum(case when ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as OverallRaise3Bet" Evaluate="OverallRaise3Bet*100.0/OverallRaise" ColumnHeader="Overall\nRaise\nwas 3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player is 3bet preflop" />

<Stat GroupName="3Bet" ColumnName="EPRaise3Bet" ValueExpressions="sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID in (0,1,2) and didPFR=true then 1 else 0 end) as EarlyRaise;sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as EarlyRaise3Bet" Evaluate="EarlyRaise3Bet*100.0/EarlyRaise" ColumnHeader="Early Pos\nRaise\nwas 3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player is 3bet when raising from Early Position preflop" />

<Stat GroupName="3Bet" ColumnName="MPRaise3Bet" ValueExpressions="sum(case when ph.PositionType_ID=3 and ph.preflopaction_ID in (0,1,2) and didPFR=true then 1 else 0 end) as MiddleRaise;sum(case when ph.PositionType_ID=3 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as MiddleRaise3Bet" Evaluate="MiddleRaise3Bet*100.0/MiddleRaise" ColumnHeader="Middle Pos\nRaise\nwas 3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player is 3bet when raising from Middle Position preflop" />

<Stat GroupName="3Bet" ColumnName="CORaise3Bet" ValueExpressions="sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID in (0,1,2) and didPFR=true then 1 else 0 end) as CutoffRaise;sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as CutoffRaise3Bet" Evaluate="CutoffRaise3Bet*100.0/CutoffRaise" ColumnHeader="Cutoff\nRaise\nwas 3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player is 3bet when raising from the Cutoff preflop" />

<Stat GroupName="3Bet" ColumnName="BTNRaise3Bet" ValueExpressions="sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID in (0,1,2) and didPFR=true then 1 else 0 end) as ButtonRaise;sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as ButtonRaise3Bet" Evaluate="ButtonRaise3Bet*100.0/ButtonRaise" ColumnHeader="Button\nRaise\nwas 3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player is 3bet when raising from the Button preflop" />

<Stat GroupName="3Bet" ColumnName="SBRaise3Bet" ValueExpressions="sum(case when ph.PositionType_ID=0 and ph.preflopaction_ID in (0,1,2) and didPFR=true then 1 else 0 end) as SmallBlindRaise;sum(case when ph.PositionType_ID=0 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as SmallBlindRaise3Bet" Evaluate="SmallBlindRaise3Bet*100.0/SmallBlindRaise" ColumnHeader="Small Blind\nRaise\nwas 3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player is 3bet when raising from the Small Blind preflop" />

<Stat GroupName="3Bet" ColumnName="EPFold3Bet" ValueExpressions="sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as EarlyRaise3Bet;sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID = 67 then 1 else 0 end) as EarlyRaise3BetFold" Evaluate="EarlyRaise3BetFold*100.0/EarlyRaise3Bet" ColumnHeader="Early Pos\nFold to\n3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds to 3bet when raising from Early Position preflop" />

[Rvg72]

<Stat GroupName="3Bet" ColumnName="MPFold3Bet" ValueExpressions="sum(case when ph.PositionType_ID=3 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as MiddleRaise3Bet;sum(case when ph.PositionType_ID=3 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID = 67 then 1 else 0 end) as MiddleRaise3BetFold" Evaluate="MiddleRaise3BetFold*100.0/MiddleRaise3Bet" ColumnHeader="Middle Pos\nFold to\n3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds to 3bet when raising from Middle Position preflop" />

<Stat GroupName="3Bet" ColumnName="COFold3Bet" ValueExpressions="sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as CutoffRaise3Bet;sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID = 67 then 1 else 0 end) as CutoffRaise3BetFold" Evaluate="CutoffRaise3BetFold*100.0/CutoffRaise3Bet" ColumnHeader="Cutoff\nFold to\n3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds to 3bet when raising from the Cutoff preflop" />

<Stat GroupName="3Bet" ColumnName="BTNFold3Bet" ValueExpressions="sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as ButtonRaise3Bet;sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID = 67 then 1 else 0 end) as ButtonRaise3BetFold" Evaluate="ButtonRaise3BetFold*100.0/ButtonRaise3Bet" ColumnHeader="Button\nFold to\n3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds to 3bet when raising from the Button preflop" />

<Stat GroupName="3Bet" ColumnName="SBFold3Bet" ValueExpressions="sum(case when ph.PositionType_ID=0 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID <> 88 then 1 else 0 end) as SmallBlindRaise3Bet;sum(case when ph.PositionType_ID=0 and ph.preflopaction_ID in (0,1,2) and didPFR=true and ph.PreflopPlayerActionType_ID = 67 then 1 else 0 end) as SmallBlindRaise3BetFold" Evaluate="SmallBlindRaise3BetFold*100.0/SmallBlindRaise3Bet" ColumnHeader="Small Blind\nFold to\n3Bet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds to 3bet when raising from the Small Blind preflop" />

<Stat GroupName="3Bet" ColumnName="3BetSuccessOverall" ValueExpressions="sum(case when ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 then 1 else 0 end) as DidThreeBetFromOverall;sum(case when ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 and ph.PreflopPlayerActionType_ID = 88 and ph.MaxStreetSeen = 0 then 1 else 0 end) as WonThreeBetFromOverall;" Evaluate="WonThreeBetFromOverall*100.0/DidThreeBetFromOverall" ColumnHeader="3Bet\nSuccess %\nOverall" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player 3bets and wins the pot there" />

<Stat GroupName="3Bet" ColumnName="3BetSuccessEP" ValueExpressions="sum(case when ph.PositionType_ID = 2 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 then 1 else 0 end) as DidThreeBetFromEP;sum(case when ph.PositionType_ID = 2 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 and ph.PreflopPlayerActionType_ID = 88 and ph.MaxStreetSeen = 0 then 1 else 0 end) as WonThreeBetFromEP;" Evaluate="WonThreeBetFromEP*100.0/DidThreeBetFromEP" ColumnHeader="3Bet\nSuccess %\nfrom EP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player 3bets from Early Position and wins the pot there" />

<Stat GroupName="3Bet" ColumnName="3BetSuccessMP" ValueExpressions="sum(case when ph.PositionType_ID = 3 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 then 1 else 0 end) as DidThreeBetFromMP;sum(case when ph.PositionType_ID = 3 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 and ph.PreflopPlayerActionType_ID = 88 and ph.MaxStreetSeen = 0 then 1 else 0 end) as WonThreeBetFromMP;" Evaluate="WonThreeBetFromMP*100.0/DidThreeBetFromMP" ColumnHeader="3Bet\nSuccess %\nfrom MP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player 3bets from Middle Position and wins the pot there" />

<Stat GroupName="3Bet" ColumnName="3BetSuccessCO" ValueExpressions="sum(case when ph.PositionType_ID = 4 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 then 1 else 0 end) as DidThreeBetFromCO;sum(case when ph.PositionType_ID = 4 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 and ph.PreflopPlayerActionType_ID = 88 and ph.MaxStreetSeen = 0 then 1 else 0 end) as WonThreeBetFromCO;" Evaluate="WonThreeBetFromCO*100.0/DidThreeBetFromCO" ColumnHeader="3Bet\nSuccess %\nfrom CO" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player 3bets from the Cutoff and wins the pot there" />

<Stat GroupName="3Bet" ColumnName="3BetSuccessBTN" ValueExpressions="sum(case when ph.PositionType_ID = 5 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 then 1 else 0 end) as DidThreeBetFromBTN;sum(case when ph.PositionType_ID = 5 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 and ph.PreflopPlayerActionType_ID = 88 and ph.MaxStreetSeen = 0 then 1 else 0 end) as WonThreeBetFromBTN;" Evaluate="WonThreeBetFromBTN*100.0/DidThreeBetFromBTN" ColumnHeader="3Bet\nSuccess %\nfrom BTN" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player 3bets from the Button and wins the pot there" />

<Stat GroupName="3Bet" ColumnName="3BetSuccessSB" ValueExpressions="sum(case when ph.PositionType_ID = 0 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 then 1 else 0 end) as DidThreeBetFromSB;sum(case when ph.PositionType_ID = 0 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 and ph.PreflopPlayerActionType_ID = 88 and ph.MaxStreetSeen = 0 then 1 else 0 end) as WonThreeBetFromSB;" Evaluate="WonThreeBetFromSB*100.0/DidThreeBetFromSB" ColumnHeader="3Bet\nSuccess %\nfrom SB" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player 3bets from the Small Blind and wins the pot there" />

<Stat GroupName="3Bet" ColumnName="3BetSuccessBB" ValueExpressions="sum(case when ph.PositionType_ID = 1 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 then 1 else 0 end) as DidThreeBetFromBB;sum(case when ph.PositionType_ID = 1 and ph.preflopaction_id in (3,4) and ph.FirstPreflopActionType_ID = 3 and ph.PreflopPlayerActionType_ID = 88 and ph.MaxStreetSeen = 0 then 1 else 0 end) as WonThreeBetFromBB;" Evaluate="WonThreeBetFromBB*100.0/DidThreeBetFromBB" ColumnHeader="3Bet\nSuccess %\nfrom BB" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player 3bets from the Big Blind and wins the pot there" />

<Stat GroupName="Preflop" ColumnName="LimpRaisePct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaise;sum(case when ph.preflopaction_ID in (0,1,2) and ph.preflopplayeractiontype_id between 56 and 65 then 1 else 0 end) as LimpRaise" Evaluate="LimpRaise*100.0/LimpFacingRaise" ColumnHeader="Limp\nReraise" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises after limping in preflop and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpRaiseEPPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 2 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseEP;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 2 and ph.preflopplayeractiontype_id between 56 and 65 then 1 else 0 end) as LimpRaiseEP" Evaluate="LimpRaiseEP*100.0/LimpFacingRaiseEP" ColumnHeader="Limp\nReraise\nEP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises after limping in preflop from early position and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpRaiseMPPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 3 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseMP;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 3 and ph.preflopplayeractiontype_id between 56 and 65 then 1 else 0 end) as LimpRaiseMP" Evaluate="LimpRaiseMP*100.0/LimpFacingRaiseMP" ColumnHeader="Limp\nReraise\nMP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises after limping in preflop from middle position and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpRaiseCOPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 4 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseCO;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 4 and ph.preflopplayeractiontype_id between 56 and 65 then 1 else 0 end) as LimpRaiseCO" Evaluate="LimpRaiseCO*100.0/LimpFacingRaiseCO" ColumnHeader="Limp\nReraise\nCO" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises after limping in preflop from the cutoff and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpRaiseBTNPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 5 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseBTN;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 5 and ph.preflopplayeractiontype_id between 56 and 65 then 1 else 0 end) as LimpRaiseBTN" Evaluate="LimpRaiseBTN*100.0/LimpFacingRaiseBTN" ColumnHeader="Limp\nReraise\nBTN" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises after limping in preflop from the button and facing a raise" />

[Rvg72]

<Stat GroupName="Preflop" ColumnName="LimpRaiseSBPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 0 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseSB;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 0 and ph.preflopplayeractiontype_id between 56 and 65 then 1 else 0 end) as LimpRaiseSB" Evaluate="LimpRaiseSB*100.0/LimpFacingRaiseSB" ColumnHeader="Limp\nReraise\nSB" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises after limping in preflop from the small blind and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpFoldPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaise;sum(case when ph.preflopaction_ID in (0,1,2) and ph.preflopplayeractiontype_id = 45 then 1 else 0 end) as LimpFold" Evaluate="LimpFold*100.0/LimpFacingRaise" ColumnHeader="Limp\nFold" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds after limping in preflop and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpFoldEPPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 2 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseEP;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 2 and ph.preflopplayeractiontype_id = 45 then 1 else 0 end) as LimpFoldEP" Evaluate="LimpFoldEP*100.0/LimpFacingRaiseEP" ColumnHeader="Limp\nFold\nEP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds after limping in preflop from early position and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpFoldMPPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 3 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseMP;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 3 and ph.preflopplayeractiontype_id = 45 then 1 else 0 end) as LimpFoldMP" Evaluate="LimpFoldMP*100.0/LimpFacingRaiseMP" ColumnHeader="Limp\nFold\nMP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds after limping in preflop from middle position and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpFoldCOPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 4 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseCO;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 4 and ph.preflopplayeractiontype_id = 45 then 1 else 0 end) as LimpFoldCO" Evaluate="LimpFoldCO*100.0/LimpFacingRaiseCO" ColumnHeader="Limp\nFold\nCO" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds after limping in preflop from the cutoff and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpFoldBTNPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 5 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseBTN;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 5 and ph.preflopplayeractiontype_id = 45 then 1 else 0 end) as LimpFoldBTN" Evaluate="LimpFoldBTN*100.0/LimpFacingRaiseBTN" ColumnHeader="Limp\nFold\nBTN" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds after limping in preflop from the button and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpFoldSBPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 0 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseSB;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 0 and ph.preflopplayeractiontype_id = 45 then 1 else 0 end) as LimpFoldSB" Evaluate="LimpFoldSB*100.0/LimpFacingRaiseSB" ColumnHeader="Limp\nFold\nSB" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds after limping in preflop from the small blind and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpCallPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaise;sum(case when ph.preflopaction_ID in (0,1,2) and ph.preflopplayeractiontype_id between 46 and 55 then 1 else 0 end) as LimpCall" Evaluate="LimpCall*100.0/LimpFacingRaise" ColumnHeader="Limp\nCall" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player Calls after limping in preflop and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpCallEPPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 2 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseEP;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 2 and ph.preflopplayeractiontype_id between 46 and 55 then 1 else 0 end) as LimpCallEP" Evaluate="LimpCallEP*100.0/LimpFacingRaiseEP" ColumnHeader="Limp\nCall\nEP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player Calls after limping in preflop from early position and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpCallMPPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 3 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseMP;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 3 and ph.preflopplayeractiontype_id between 46 and 55 then 1 else 0 end) as LimpCallMP" Evaluate="LimpCallMP*100.0/LimpFacingRaiseMP" ColumnHeader="Limp\nCall\nMP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player Calls after limping in preflop from middle position and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpCallCOPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 4 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseCO;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 4 and ph.preflopplayeractiontype_id between 46 and 55 then 1 else 0 end) as LimpCallCO" Evaluate="LimpCallCO*100.0/LimpFacingRaiseCO" ColumnHeader="Limp\nCall\nCO" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player Calls after limping in preflop from the cutoff and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpCallBTNPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 5 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseBTN;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 5 and ph.preflopplayeractiontype_id between 46 and 55 then 1 else 0 end) as LimpCallBTN" Evaluate="LimpCallBTN*100.0/LimpFacingRaiseBTN" ColumnHeader="Limp\nCall\nBTN" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player Calls after limping in preflop from the button and facing a raise" />

<Stat GroupName="Preflop" ColumnName="LimpCallSBPct" ValueExpressions="sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 0 and ph.preflopplayeractiontype_id between 45 and 65 then 1 else 0 end) as LimpFacingRaiseSB;sum(case when ph.preflopaction_ID in (0,1,2) and ph.positiontype_id = 0 and ph.preflopplayeractiontype_id between 46 and 55 then 1 else 0 end) as LimpCallSB" Evaluate="LimpCallSB*100.0/LimpFacingRaiseSB" ColumnHeader="Limp\nCall\nSB" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player Calls after limping in preflop from the small blind and facing a raise" />

<Stat GroupName="Preflop" ColumnName="AllInPreflop" ValueExpressions="sum(case when ph.StreetWentAllin = 1 then 1 else 0 end) as AllInPreflop; sum(case when ph.preflopaction_id <> -1 then 1 else 0 end) as TotalPlayableHands" Evaluate="AllInPreflop*100.0/TotalPlayableHands" ColumnHeader="Allin\nPreflop" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player goes allin (either calling or raising) preflop" />

[Rvg72]

<Stat GroupName="Steal" ColumnName="StealLimpedPot" ValueExpressions="sum(case when ph.preflopaction_ID in (1,2) then 1 else 0 end) as FacingLimpers;sum(case when ph.preflopaction_ID in (1,2) and didPFR=true then 1 else 0 end) as StealFromLimpers" Evaluate="StealFromLimpers*100.0/FacingLimpers" ColumnHeader="Steal\nfrom\nLimpers" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises preflop when facing Limpers" />

<Stat GroupName="Steal" ColumnName="COSteal" ValueExpressions="sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID=0 then 1 else 0 end) as CutoffPositionUnopenedHands;sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as CutoffPositionUnopenedPFR" Evaluate="CutoffPositionUnopenedPFR*100.0/CutoffPositionUnopenedHands" ColumnHeader="Steal\nfrom\nCutoff" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises preflop when one off the button with nobody else in the pot" />

<Stat GroupName="Steal" ColumnName="BTNSteal" ValueExpressions="sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID=0 then 1 else 0 end) as ButtonPositionUnopenedHands;sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as ButtonPositionUnopenedPFR" Evaluate="ButtonPositionUnopenedPFR*100.0/ButtonPositionUnopenedHands" ColumnHeader="Steal\nfrom\nButton" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises preflop when on the button with nobody else in the pot" />

<Stat GroupName="Steal" ColumnName="SBSteal" ValueExpressions="sum(case when ph.PositionType_ID=0 and ph.preflopaction_ID=0 then 1 else 0 end) as SmallBlindPositionUnopenedHands;sum(case when ph.PositionType_ID=0 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as SmallBlindPositionUnopenedPFR" Evaluate="SmallBlindPositionUnopenedPFR*100.0/SmallBlindPositionUnopenedHands" ColumnHeader="Steal\nfrom\nSB" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises preflop when in the small blind with nobody else in the pot" />

<Stat GroupName="Steal" ColumnName="StealPct" ValueExpressions="sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 then 1 else 0 end) as StealPositionUnopenedHands;sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as StealPositionUnopenedPFR" Evaluate="StealPositionUnopenedPFR*100.0/StealPositionUnopenedHands" ColumnHeader="Steal\nPct" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises unopened preflop from the cutoff, button or small blind" />

<Stat GroupName="Steal" ColumnName="COStealWin" ValueExpressions="sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as CutoffPositionUnopenedPFR;sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID=0 and didPFR=true and ph.PreflopPlayerActionType_ID = 88 and maxstreetseen = 0 then 1 else 0 end) as CutoffPositionUnopenedPFRWin" Evaluate="CutoffPositionUnopenedPFRWin*100.0/CutoffPositionUnopenedPFR" ColumnHeader="Cutoff\nSteal\nSuccess" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player wins the pot unconteseted when he raises preflop when one off the button with nobody else in the pot" />

<Stat GroupName="Steal" ColumnName="BTNStealWin" ValueExpressions="sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as ButtonPositionUnopenedPFR;sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID=0 and didPFR=true and ph.PreflopPlayerActionType_ID = 88 and maxstreetseen = 0 then 1 else 0 end) as ButtonPositionUnopenedPFRWin" Evaluate="ButtonPositionUnopenedPFRWin*100.0/ButtonPositionUnopenedPFR" ColumnHeader="Button\nSteal\nSuccess" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player wins the pot unconteseted when he raises preflop when on the button with nobody else in the pot" />

<Stat GroupName="Steal" ColumnName="SBStealWin" ValueExpressions="sum(case when ph.PositionType_ID=0 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as SmallBlindPositionUnopenedPFR;sum(case when ph.PositionType_ID=0 and ph.preflopaction_ID=0 and didPFR=true and ph.PreflopPlayerActionType_ID = 88 and maxstreetseen = 0 then 1 else 0 end) as SmallBlindPositionUnopenedPFRWin" Evaluate="SmallBlindPositionUnopenedPFRWin*100.0/SmallBlindPositionUnopenedPFR" ColumnHeader="Small Blind\nSteal\nSuccess" ColumnFormat="0.0" ColumnWidth="72" Tooltip="Pct of time player wins the pot unconteseted when he raises preflop when in small blind with nobody else in the pot" />

<Stat GroupName="Steal" ColumnName="OverallStealWin" ValueExpressions="sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as StealPositionUnopenedPFR;sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and didPFR=true and ph.PreflopPlayerActionType_ID = 88 and maxstreetseen = 0 then 1 else 0 end) as StealPositionUnopenedPFRWin" Evaluate="StealPositionUnopenedPFRWin*100.0/StealPositionUnopenedPFR" ColumnHeader="Overall\nSteal\nSuccess" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player wins the pot unconteseted when he steals preflop" />

<Stat GroupName="Steal" ColumnName="StealPct04" ValueExpressions="sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and phmisc.StackSize/1.0/GT.BigBlind <= 4.0 then 1 else 0 end) as StealPositionUnopenedHands0to4;sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and didPFR=true and phmisc.StackSize/1.0/GT.BigBlind <= 4.0 then 1 else 0 end) as StealPositionUnopenedPFR0to4" Evaluate="StealPositionUnopenedPFR0to4*100.0/StealPositionUnopenedHands0to4" ColumnHeader="Steal Pct\n0-4 bbs" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises unopened preflop from the cutoff, button or small blind when having less than or equal to 4 big blinds left in stack" />

<Stat GroupName="Steal" ColumnName="StealPct46" ValueExpressions="sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and phmisc.StackSize/1.0/GT.BigBlind between 4.0 and 6.0 then 1 else 0 end) as StealPositionUnopenedHands4to6;sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and didPFR=true and phmisc.StackSize/1.0/GT.BigBlind between 4.0 and 6.0 then 1 else 0 end) as StealPositionUnopenedPFR4to6" Evaluate="StealPositionUnopenedPFR4to6*100.0/StealPositionUnopenedHands4to6" ColumnHeader="Steal Pct\n4-6 bbs" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises unopened preflop from the cutoff, button or small blind when having 4 to 6 big blinds left in stack" />

<Stat GroupName="Steal" ColumnName="StealPct68" ValueExpressions="sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and phmisc.StackSize/1.0/GT.BigBlind between 6.0 and 8.0 then 1 else 0 end) as StealPositionUnopenedHands6to8;sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and didPFR=true and phmisc.StackSize/1.0/GT.BigBlind between 6.0 and 8.0 then 1 else 0 end) as StealPositionUnopenedPFR6to8" Evaluate="StealPositionUnopenedPFR6to8*100.0/StealPositionUnopenedHands6to8" ColumnHeader="Steal Pct\n6-8 bbs" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises unopened preflop from the cutoff, button or small blind when having 6 to 8 big blinds left in stack" />

<Stat GroupName="Steal" ColumnName="StealPct810" ValueExpressions="sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and phmisc.StackSize/1.0/GT.BigBlind between 8.0 and 10.0 then 1 else 0 end) as StealPositionUnopenedHands8to10;sum(case when ph.PositionType_ID in (4,5,0) and ph.preflopaction_ID=0 and didPFR=true and phmisc.StackSize/1.0/GT.BigBlind between 8.0 and 10.0 then 1 else 0 end) as StealPositionUnopenedPFR8to10" Evaluate="StealPositionUnopenedPFR6to8*100.0/StealPositionUnopenedHands8to10" ColumnHeader="Steal Pct\n8-10 bbs" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises unopened preflop from the cutoff, button or small blind when having 8 to 10 big blinds left in stack" />

<Stat GroupName="Steal" ColumnName="DefStealSB" ValueExpressions="sum(case when phmisc.sbstealdefended = true then 1 else 0 end) as sbstealdefended;sum(case when phmisc.sbstealattempted = true then 1 else 0 end) as sbstealattempted" Evaluate="sbstealdefended*100.0/sbstealattempted" ColumnHeader="SB\nDefend\nSteal" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player calls or raises when in the small blind and facing a steal attempt from Cutoff or Button" />

[Rvg72]

<Stat GroupName="Steal" ColumnName="RaiseStealSB" ValueExpressions="sum(case when phmisc.sbstealreraised = true then 1 else 0 end) as sbstealreraised;sum(case when phmisc.sbstealattempted = true then 1 else 0 end) as sbstealattempted" Evaluate="sbstealreraised*100.0/sbstealattempted" ColumnHeader="SB\nReraise\nSteal" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises when in the small blind and facing a steal attempt from Cutoff or Button" />

<Stat GroupName="Steal" ColumnName="FoldStealSB" ValueExpressions="sum(case when phmisc.sbstealdefended = true then 1 else 0 end) as sbstealdefended;sum(case when phmisc.sbstealattempted = true then 1 else 0 end) as sbstealattempted" Evaluate="(sbstealattempted-sbstealdefended)*100.0/sbstealattempted" ColumnHeader="SB\nFold to\nSteal" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds when in the small blind and facing a steal attempt from Cutoff or Button" />

<Stat GroupName="Steal" ColumnName="DefStealBB" ValueExpressions="sum(case when phmisc.BBstealdefended = true then 1 else 0 end) as BBstealdefended;sum(case when phmisc.BBstealattempted = true then 1 else 0 end) as BBstealattempted" Evaluate="BBstealdefended*100.0/BBstealattempted" ColumnHeader="BB\nDefend\nSteal" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player calls or raises when in the big blind and facing a steal attempt from Cutoff, Button or Small Blind" />

<Stat GroupName="Steal" ColumnName="RaiseStealBB" ValueExpressions="sum(case when phmisc.BBstealreraised = true then 1 else 0 end) as BBstealreraised;sum(case when phmisc.BBstealattempted = true then 1 else 0 end) as BBstealattempted" Evaluate="BBstealreraised*100.0/BBstealattempted" ColumnHeader="BB\nReraise\nSteal" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises when in the big blind and facing a steal attempt from Cutoff, Button or Small Blind" />

<Stat GroupName="Steal" ColumnName="FoldStealBB" ValueExpressions="sum(case when phmisc.BBstealdefended = true then 1 else 0 end) as BBstealdefended;sum(case when phmisc.BBstealattempted = true then 1 else 0 end) as BBstealattempted" Evaluate="(BBstealattempted-BBstealdefended)*100.0/BBstealattempted" ColumnHeader="BB\nFold to\nSteal" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds when in the Big blind and facing a steal attempt from Cutoff, Button or Small Blind" />

<Stat GroupName="Default" ColumnName="WTSD" ValueExpressions="sum(case when ph.maxstreetseen = 4 then 1 else 0 end) as SawShowdown;sum(case when ph.maxstreetseen >= 1 then 1 else 0 end) as SawFlop;" Evaluate="SawShowdown*100.0/SawFlop" ColumnHeader="WTSD%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player sees a showdown when he sees the flop" />

<Stat GroupName="Turn" ColumnName="WTSDSawTurn" ValueExpressions="sum(case when ph.maxstreetseen = 4 then 1 else 0 end) as SawShowdown;sum(case when ph.maxstreetseen >= 2 then 1 else 0 end) as SawTurn;" Evaluate="SawShowdown*100.0/SawTurn" ColumnHeader="WTSD%\nWhen Saw\nTurn" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player sees a showdown when he sees the turn" />

<Stat GroupName="Turn" ColumnName="SawTurnWhenSawFlop" ValueExpressions="sum(case when ph.maxstreetseen >= 2 then 1 else 0 end) as SawTurn;sum(case when ph.maxstreetseen >= 1 then 1 else 0 end) as SawFlop;" Evaluate="SawTurn*100.0/SawFlop" ColumnHeader="Saw Turn\nWhen Saw\nFlop" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player sees the turn when he sees the flop" />

<Stat GroupName="River" ColumnName="SawRiverWhenSawFlop" ValueExpressions="sum(case when ph.maxstreetseen >= 3 then 1 else 0 end) as SawRiver;sum(case when ph.maxstreetseen >= 1 then 1 else 0 end) as SawFlop;" Evaluate="SawRiver*100.0/SawFlop" ColumnHeader="Saw River\nWhen Saw\nFlop" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player sees the River when he sees the flop" />

<Stat GroupName="River" ColumnName="SawRiverWhenSawTurn" ValueExpressions="sum(case when ph.maxstreetseen >= 3 then 1 else 0 end) as SawRiver;sum(case when ph.maxstreetseen >= 2 then 1 else 0 end) as SawTurn;" Evaluate="SawRiver*100.0/SawTurn" ColumnHeader="Saw River\nWhen Saw\nTurn" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player sees the river when he sees the turn" />

<Stat GroupName="River" ColumnName="WTSDSawRiver" ValueExpressions="sum(case when ph.maxstreetseen = 4 then 1 else 0 end) as SawShowdown;sum(case when ph.maxstreetseen >= 3 then 1 else 0 end) as SawRiver;" Evaluate="SawShowdown*100.0/SawRiver" ColumnHeader="WTSD%\nWhen Saw\nRiver" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of times player sees a showdown when he sees the river" />

<Stat GroupName="Default" ColumnName="WonShowdown" ValueExpressions="sum(case when ph.maxstreetseen = 4 then 1 else 0 end) as SawShowdown;sum(case when ph.netamountwon > 0 and ph.maxstreetseen = 4 then 1 else 0 end) as WonShowdown;" Evaluate="WonShowdown*100.0/SawShowdown" ColumnHeader="W$SD%" ColumnFormat="0.0" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="Default" ColumnName="WonHand" ValueExpressions="sum(case when ph.netamountwon > 0 then 1 else 0 end) as WonHand;" Evaluate="WonHand*100.0/TotalHands" ColumnHeader="Won\nHand%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% Time the hand was won" />

[Rvg72]

<Stat GroupName="Default" ColumnName="WonWhenSawFlop" ValueExpressions="sum(case when ph.maxstreetseen >= 1 then 1 else 0 end) as SawFlop;sum(case when ph.netamountwon > 0 and ph.MaxStreetSeen >= 1 then 1 else 0 end) as WonHandWhenSawFlop;" Evaluate="WonHandWhenSawFlop*100.0/SawFlop" ColumnHeader="W$WSF" ColumnFormat="0.0" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="Default" ColumnName="PostFlopAgg" ValueExpressions="sum(ph.TotalFlopBets) as FlopBets;sum(ph.TotalFlopCalls) as FlopCalls;sum(ph.TotalTurnBets) as TurnBets;sum(ph.TotalTurnCalls) as TurnCalls;sum(ph.TotalRiverBets) as RiverBets;sum(ph.TotalRiverCalls) as RiverCalls;" Evaluate="(FlopBets+TurnBets+RiverBets)/1.0/(FlopCalls+TurnCalls+RiverCalls)" ColumnHeader="Agg" ColumnFormat="0.00" ColumnWidth="61" Tooltip=" " />

<Stat GroupName="Default" ColumnName="FlopAgg" ValueExpressions="sum(ph.TotalFlopBets) as FlopBets;sum(ph.TotalFlopCalls) as FlopCalls;" Evaluate="(FlopBets)/1.0/(FlopCalls)" ColumnHeader="Flop\nAgg" ColumnFormat="0.00" ColumnWidth="61" Tooltip="Flop Aggression (Total Bets / Total Calls) " />

<Stat GroupName="Default" ColumnName="TurnAgg" ValueExpressions="sum(ph.TotalTurnBets) as TurnBets;sum(ph.TotalTurnCalls) as TurnCalls;" Evaluate="(TurnBets)/1.0/(TurnCalls)" ColumnHeader="Turn\nAgg" ColumnFormat="0.00" ColumnWidth="61" Tooltip="Turn Aggression (Total Bets / Total Calls) " />

<Stat GroupName="Default" ColumnName="RiverAgg" ValueExpressions="sum(ph.TotalRiverBets) as RiverBets;sum(ph.TotalRiverCalls) as RiverCalls;" Evaluate="(RiverBets)/1.0/(RiverCalls)" ColumnHeader="River\nAgg" ColumnFormat="0.00" ColumnWidth="61" Tooltip="River Aggression (Total Bets / Total Calls) " />

<Stat GroupName="Default" ColumnName="PostFlopAggPct" ValueExpressions="sum(case when ph.TotalFlopBets > 0 then 1 else 0 end) as BetOnFlop;sum(case when ph.maxstreetseen >= 1 then 1 else 0 end) as SawFlop;sum(case when ph.TotalTurnBets > 0 then 1 else 0 end) as BetOnTurn;sum(case when ph.maxstreetseen >= 2 then 1 else 0 end) as SawTurn;sum(case when ph.TotalRiverBets > 0 then 1 else 0 end) as BetOnRiver;sum(case when ph.maxstreetseen >= 3 then 1 else 0 end) as SawRiver;" Evaluate="(BetOnFlop+BetOnTurn+BetOnRiver)*100.0/(SawFlop+SawTurn+SawRiver)" ColumnHeader="Agg%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Postflop Aggression % is the percent of postflop streets the player makes an aggressive play" />

<Stat GroupName="Default" ColumnName="FlopAggPct" ValueExpressions="sum(case when ph.TotalFlopBets > 0 then 1 else 0 end) as BetOnFlop;sum(case when ph.maxstreetseen >= 1 then 1 else 0 end) as SawFlop;" Evaluate="(BetOnFlop)*100.0/(SawFlop)" ColumnHeader="Flop Agg%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Flop Aggression % is the percent of Flops the player makes an aggressive play" />

<Stat GroupName="Default" ColumnName="TurnAggPct" ValueExpressions="sum(case when ph.TotalTurnBets > 0 then 1 else 0 end) as BetOnTurn;sum(case when ph.maxstreetseen >= 2 then 1 else 0 end) as SawTurn;" Evaluate="(BetOnTurn)*100.0/(SawTurn)" ColumnHeader="Turn Agg%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Turn Aggression % is the percent of Turns the player makes an aggressive play" />

<Stat GroupName="Default" ColumnName="RiverAggPct" ValueExpressions="sum(case when ph.TotalRiverBets > 0 then 1 else 0 end) as BetOnRiver;sum(case when ph.maxstreetseen >= 3 then 1 else 0 end) as SawRiver;" Evaluate="(BetOnRiver)*100.0/(SawRiver)" ColumnHeader="River Agg%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="River Aggression % is the percent of Rivers the player makes an aggressive play" />

<Stat GroupName="Flop" ColumnName="FlopBet" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 23 and 44 then 1 else 0 end) as BetFlop;sum(case when ph.flopplayeractiontype_id between 1 and 22 then 1 else 0 end) as CheckFlop" Evaluate="BetFlop*100.0/(BetFlop+CheckFlop)" ColumnHeader="Bet Flop%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player bets the flop" />

<Stat GroupName="Turn" ColumnName="TurnBet" ValueExpressions="sum(case when ph.Turnplayeractiontype_id between 23 and 44 then 1 else 0 end) as BetTurn;sum(case when ph.Turnplayeractiontype_id between 1 and 22 then 1 else 0 end) as CheckTurn" Evaluate="BetTurn*100.0/(BetTurn+CheckTurn)" ColumnHeader="Bet Turn%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player bets the Turn" />

<Stat GroupName="River" ColumnName="RiverBet" ValueExpressions="sum(case when ph.Riverplayeractiontype_id between 23 and 44 then 1 else 0 end) as BetRiver;sum(case when ph.Riverplayeractiontype_id between 1 and 22 then 1 else 0 end) as CheckRiver" Evaluate="BetRiver*100.0/(BetRiver+CheckRiver)" ColumnHeader="Bet River%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player bets the River" />

<Stat GroupName="Flop" ColumnName="FlopCBet" ValueExpressions="sum(case when ph.flopcbetpossible = true then 1 else 0 end) as FlopCbetPossible;sum(case when ph.flopcbetmade = true then 1 else 0 end) as FlopCbetMade;" Evaluate="FlopCBetMade*100.0/FlopCBetPossible" ColumnHeader="Flop CBet%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player bets the flop after being the preflop raiser" />

<Stat GroupName="Turn" ColumnName="TurnCBet" ValueExpressions="sum(case when ph.Turncbetpossible = true then 1 else 0 end) as TurnCbetPossible;sum(case when ph.Turncbetmade = true then 1 else 0 end) as TurnCbetMade;" Evaluate="TurnCBetMade*100.0/TurnCBetPossible" ColumnHeader="Turn CBet%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player bets the Turn after being the preTurn raiser and CBetting the Flop" />

<Stat GroupName="River" ColumnName="RiverCBet" ValueExpressions="sum(case when ph.Rivercbetpossible = true then 1 else 0 end) as RiverCbetPossible;sum(case when ph.Rivercbetmade = true then 1 else 0 end) as RiverCbetMade;" Evaluate="RiverCBetMade*100.0/RiverCBetPossible" ColumnHeader="River CBet%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player bets the River after being the preRiver raiser and CBetting the Flop and Turn" />

<Stat GroupName="Postflop" ColumnName="OverallCheckRaise" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckFlop;sum(case when ph.turnplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckTurn;sum(case when ph.riverplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckRiver;sum(case when ph.flopplayeractiontype_id between 12 and 21 then 1 else 0 end) as CheckRaiseFlop;sum(case when ph.turnplayeractiontype_id between 12 and 21 then 1 else 0 end) as CheckRaiseTurn;sum(case when ph.riverplayeractiontype_id between 12 and 21 then 1 else 0 end) as CheckRaiseRiver" Evaluate="(CheckRaiseFlop+CheckRaiseTurn+CheckRaiseRiver)*10 0.0/(AfterCheckFlop+AfterCheckTurn+AfterCheckRiver)" ColumnHeader="Check\nRaise" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player check raises after checking the flop, turn or river" />

[Rvg72]

<Stat GroupName="Flop" ColumnName="FlopCheckRaise" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckFlop;sum(case when ph.flopplayeractiontype_id between 12 and 21 then 1 else 0 end) as CheckRaiseFlop" Evaluate="CheckRaiseFlop*100.0/(AfterCheckFlop)" ColumnHeader="Check\nRaise\nFlop%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player check raises after checking the flop" />

<Stat GroupName="Turn" ColumnName="TurnCheckRaise" ValueExpressions="sum(case when ph.Turnplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckTurn;sum(case when ph.Turnplayeractiontype_id between 12 and 21 then 1 else 0 end) as CheckRaiseTurn" Evaluate="CheckRaiseTurn*100.0/(AfterCheckTurn)" ColumnHeader="Check\nRaise\nTurn%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player check raises after checking the Turn" />

<Stat GroupName="River" ColumnName="RiverCheckRaise" ValueExpressions="sum(case when ph.Riverplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckRiver;sum(case when ph.Riverplayeractiontype_id between 12 and 21 then 1 else 0 end) as CheckRaiseRiver" Evaluate="CheckRaiseRiver*100.0/(AfterCheckRiver)" ColumnHeader="Check\nRaise\nRiver%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player check raises after checking the River" />

<Stat GroupName="Flop" ColumnName="FlopCheckFold" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckFlop;sum(case when ph.flopplayeractiontype_id =1 then 1 else 0 end) as CheckFoldFlop" Evaluate="CheckFoldFlop*100.0/(AfterCheckFlop)" ColumnHeader="Check\nFold\nFlop%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player check Folds after checking the flop" />

<Stat GroupName="Turn" ColumnName="TurnCheckFold" ValueExpressions="sum(case when ph.Turnplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckTurn;sum(case when ph.Turnplayeractiontype_id =1 then 1 else 0 end) as CheckFoldTurn" Evaluate="CheckFoldTurn*100.0/(AfterCheckTurn)" ColumnHeader="Check\nFold\nTurn%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player check Folds after checking the Turn" />

<Stat GroupName="River" ColumnName="RiverCheckFold" ValueExpressions="sum(case when ph.Riverplayeractiontype_id between 1 and 21 then 1 else 0 end) as AfterCheckRiver;sum(case when ph.Riverplayeractiontype_id =1 then 1 else 0 end) as CheckFoldRiver" Evaluate="CheckFoldRiver*100.0/(AfterCheckRiver)" ColumnHeader="Check\nFold\nRiver%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player check Folds after checking the River" />

<Stat GroupName="Flop" ColumnName="FlopCBetSuccess" ValueExpressions="sum(case when ph.flopcbetmade = true then 1 else 0 end) as FlopCbetMade; sum(case when ph.flopcbetmade = true and ph.MaxStreetSeen = 1 and ph.FlopPlayerActionType_ID = 44 then 1 else 0 end) as FlopCbetSuccess;" Evaluate="FlopCBetSuccess*100.0/FlopCBetMade" ColumnHeader="Flop CBet%\nSuccess" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the flop" />

<Stat GroupName="Flop" ColumnName="FlopCBetSuccess1" ValueExpressions="sum(case when ph.flopcbetmade = true and pkh.numberofplayerssawflop = 2 then 1 else 0 end) as FlopCbetMadevs1; sum(case when ph.flopcbetmade = true and ph.MaxStreetSeen = 1 and ph.FlopPlayerActionType_ID = 44 and pkh.numberofplayerssawflop = 2 then 1 else 0 end) as FlopCbetSuccessvs1;" Evaluate="FlopCBetSuccessvs1*100.0/FlopCBetMadevs1" ColumnHeader="Flop CBet%\nSuccess vs1" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the flop against 1 player" />

<Stat GroupName="Flop" ColumnName="FlopCBetSuccess2" ValueExpressions="sum(case when ph.flopcbetmade = true and pkh.numberofplayerssawflop = 3 then 1 else 0 end) as FlopCbetMadevs2; sum(case when ph.flopcbetmade = true and ph.MaxStreetSeen = 1 and ph.FlopPlayerActionType_ID = 44 and pkh.numberofplayerssawflop = 3 then 1 else 0 end) as FlopCbetSuccessvs2;" Evaluate="FlopCBetSuccessvs2*100.0/FlopCBetMadevs2" ColumnHeader="Flop CBet%\nSuccess vs2" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the flop against 2 players" />

<Stat GroupName="Flop" ColumnName="FlopCBetSuccess3" ValueExpressions="sum(case when ph.flopcbetmade = true and pkh.numberofplayerssawflop > 3 then 1 else 0 end) as FlopCbetMadevs3; sum(case when ph.flopcbetmade = true and ph.MaxStreetSeen = 1 and ph.FlopPlayerActionType_ID = 44 and pkh.numberofplayerssawflop > 3 then 1 else 0 end) as FlopCbetSuccessvs3;" Evaluate="FlopCBetSuccessvs3*100.0/FlopCBetMadevs3" ColumnHeader="Flop CBet%\nSuccess vs3+" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the flop against 3+ players" />

<Stat GroupName="Turn" ColumnName="TurnCBetSuccess" ValueExpressions="sum(case when ph.Turncbetmade = true then 1 else 0 end) as TurnCbetMade; sum(case when ph.Turncbetmade = true and ph.MaxStreetSeen = 2 and ph.TurnPlayerActionType_ID = 44 then 1 else 0 end) as TurnCbetSuccess;" Evaluate="TurnCBetSuccess*100.0/TurnCBetMade" ColumnHeader="Turn CBet%\nSuccess" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the Turn" />

<Stat GroupName="Turn" ColumnName="TurnCBetSuccess1" ValueExpressions="sum(case when ph.Turncbetmade = true and pkh.numberofplayerssawTurn = 2 then 1 else 0 end) as TurnCbetMadevs1; sum(case when ph.Turncbetmade = true and ph.MaxStreetSeen = 2 and ph.TurnPlayerActionType_ID = 44 and pkh.numberofplayerssawTurn = 2 then 1 else 0 end) as TurnCbetSuccessvs1;" Evaluate="TurnCBetSuccessvs1*100.0/TurnCBetMadevs1" ColumnHeader="Turn CBet%\nSuccess vs1" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the Turn against 1 player" />

<Stat GroupName="Turn" ColumnName="TurnCBetSuccess2" ValueExpressions="sum(case when ph.Turncbetmade = true and pkh.numberofplayerssawTurn = 3 then 1 else 0 end) as TurnCbetMadevs2; sum(case when ph.Turncbetmade = true and ph.MaxStreetSeen = 2 and ph.TurnPlayerActionType_ID = 44 and pkh.numberofplayerssawTurn = 3 then 1 else 0 end) as TurnCbetSuccessvs2;" Evaluate="TurnCBetSuccessvs2*100.0/TurnCBetMadevs2" ColumnHeader="Turn CBet%\nSuccess vs2" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the Turn against 2 players" />

<Stat GroupName="Turn" ColumnName="TurnCBetSuccess3" ValueExpressions="sum(case when ph.Turncbetmade = true and pkh.numberofplayerssawTurn > 3 then 1 else 0 end) as TurnCbetMadevs3; sum(case when ph.Turncbetmade = true and ph.MaxStreetSeen = 2 and ph.TurnPlayerActionType_ID = 44 and pkh.numberofplayerssawTurn > 3 then 1 else 0 end) as TurnCbetSuccessvs3;" Evaluate="TurnCBetSuccessvs3*100.0/TurnCBetMadevs3" ColumnHeader="Turn CBet%\nSuccess vs3+" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the Turn against 3+ players" />

[Rvg72]

<Stat GroupName="River" ColumnName="RiverCBetSuccess" ValueExpressions="sum(case when ph.Rivercbetmade = true then 1 else 0 end) as RiverCbetMade; sum(case when ph.Rivercbetmade = true and ph.MaxStreetSeen = 3 and ph.RiverPlayerActionType_ID = 44 then 1 else 0 end) as RiverCbetSuccess;" Evaluate="RiverCBetSuccess*100.0/RiverCBetMade" ColumnHeader="River CBet%\nSuccess" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the River" />

<Stat GroupName="River" ColumnName="RiverCBetSuccess1" ValueExpressions="sum(case when ph.Rivercbetmade = true and pkh.numberofplayerssawRiver = 2 then 1 else 0 end) as RiverCbetMadevs1; sum(case when ph.Rivercbetmade = true and ph.MaxStreetSeen = 3 and ph.RiverPlayerActionType_ID = 44 and pkh.numberofplayerssawRiver = 2 then 1 else 0 end) as RiverCbetSuccessvs1;" Evaluate="RiverCBetSuccessvs1*100.0/RiverCBetMadevs1" ColumnHeader="River CBet%\nSuccess vs1" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the River against 1 player" />

<Stat GroupName="River" ColumnName="RiverCBetSuccess2" ValueExpressions="sum(case when ph.Rivercbetmade = true and pkh.numberofplayerssawRiver = 3 then 1 else 0 end) as RiverCbetMadevs2; sum(case when ph.Rivercbetmade = true and ph.MaxStreetSeen = 3 and ph.RiverPlayerActionType_ID = 44 and pkh.numberofplayerssawRiver = 3 then 1 else 0 end) as RiverCbetSuccessvs2;" Evaluate="RiverCBetSuccessvs2*100.0/RiverCBetMadevs2" ColumnHeader="River CBet%\nSuccess vs2" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the River against 2 players" />

<Stat GroupName="River" ColumnName="RiverCBetSuccess3" ValueExpressions="sum(case when ph.Rivercbetmade = true and pkh.numberofplayerssawRiver > 3 then 1 else 0 end) as RiverCbetMadevs3; sum(case when ph.Rivercbetmade = true and ph.MaxStreetSeen = 3 and ph.RiverPlayerActionType_ID = 44 and pkh.numberofplayerssawRiver > 3 then 1 else 0 end) as RiverCbetSuccessvs3;" Evaluate="RiverCBetSuccessvs3*100.0/RiverCBetMadevs3" ColumnHeader="River CBet%\nSuccess vs3+" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player takes down the pot when cbetting the River against 3+ players" />

<Stat GroupName="Flop" ColumnName="FlopvsBetRaise" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 0 and 21 or ph.flopplayeractiontype_id between 45 and 88 then 1 else 0 end) as FlopFacingBet;sum(case when ph.flopplayeractiontype_id between 67 and 88 or ph.flopplayeractiontype_id between 12 and 21 then 1 else 0 end) as FlopvsBetRaise" Evaluate="FlopvsBetRaise*100.0/(FlopFacingBet)" ColumnHeader="Flop\nvs Bet\nRaise%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player raises or check raises a bet on the flop" />

<Stat GroupName="Turn" ColumnName="TurnvsBetRaise" ValueExpressions="sum(case when ph.Turnplayeractiontype_id between 0 and 21 or ph.Turnplayeractiontype_id between 45 and 88 then 1 else 0 end) as TurnFacingBet;sum(case when ph.Turnplayeractiontype_id between 67 and 88 or ph.Turnplayeractiontype_id between 12 and 21 then 1 else 0 end) as TurnvsBetRaise" Evaluate="TurnvsBetRaise*100.0/(TurnFacingBet)" ColumnHeader="Turn\nvs Bet\nRaise%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player raises or check raises a bet on the Turn" />

<Stat GroupName="River" ColumnName="RivervsBetRaise" ValueExpressions="sum(case when ph.Riverplayeractiontype_id between 0 and 21 or ph.Riverplayeractiontype_id between 45 and 88 then 1 else 0 end) as RiverFacingBet;sum(case when ph.Riverplayeractiontype_id between 67 and 88 or ph.Riverplayeractiontype_id between 12 and 21 then 1 else 0 end) as RivervsBetRaise" Evaluate="RivervsBetRaise*100.0/(RiverFacingBet)" ColumnHeader="River\nvs Bet\nRaise%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player raises or check raises a bet on the River" />

<Stat GroupName="Flop" ColumnName="FlopvsBetFold" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 0 and 21 or ph.flopplayeractiontype_id between 45 and 88 then 1 else 0 end) as FlopFacingBet;sum(case when ph.flopplayeractiontype_id = 0 or ph.flopplayeractiontype_id = 1 then 1 else 0 end) as FlopvsBetFold" Evaluate="FlopvsBetFold*100.0/(FlopFacingBet)" ColumnHeader="Flop\nvs Bet\nFold%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player folds or check folds vs a bet on the flop" />

<Stat GroupName="Turn" ColumnName="TurnvsBetFold" ValueExpressions="sum(case when ph.Turnplayeractiontype_id between 0 and 21 or ph.Turnplayeractiontype_id between 45 and 88 then 1 else 0 end) as TurnFacingBet;sum(case when ph.Turnplayeractiontype_id = 0 or ph.Turnplayeractiontype_id = 1 then 1 else 0 end) as TurnvsBetFold" Evaluate="TurnvsBetFold*100.0/(TurnFacingBet)" ColumnHeader="Turn\nvs Bet\nFold%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player folds or check folds vs a bet on the Turn" />

<Stat GroupName="River" ColumnName="RivervsBetFold" ValueExpressions="sum(case when ph.Riverplayeractiontype_id between 0 and 21 or ph.Riverplayeractiontype_id between 45 and 88 then 1 else 0 end) as RiverFacingBet;sum(case when ph.Riverplayeractiontype_id = 0 or ph.Riverplayeractiontype_id = 1 then 1 else 0 end) as RivervsBetFold" Evaluate="RivervsBetFold*100.0/(RiverFacingBet)" ColumnHeader="River\nvs Bet\nFold%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player folds or check folds vs a bet on the River" />

<Stat GroupName="Flop" ColumnName="FlopvsRaiseRaise" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 23 and 43 then 1 else 0 end) as FlopFacingRaise;sum(case when ph.flopplayeractiontype_id between 34 and 43 then 1 else 0 end) as FlopvsRaiseRaise" Evaluate="FlopvsRaiseRaise*100.0/(FlopFacingRaise)" ColumnHeader="Flop\nvs Raise\nRaise%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player reraises when his bet is raised on the flop" />

<Stat GroupName="Turn" ColumnName="TurnvsRaiseRaise" ValueExpressions="sum(case when ph.Turnplayeractiontype_id between 23 and 43 then 1 else 0 end) as TurnFacingRaise;sum(case when ph.Turnplayeractiontype_id between 34 and 43 then 1 else 0 end) as TurnvsRaiseRaise" Evaluate="TurnvsRaiseRaise*100.0/(TurnFacingRaise)" ColumnHeader="Turn\nvs Raise\nRaise%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player reraises when his bet is raised on the Turn" />

<Stat GroupName="River" ColumnName="RivervsRaiseRaise" ValueExpressions="sum(case when ph.Riverplayeractiontype_id between 23 and 43 then 1 else 0 end) as RiverFacingRaise;sum(case when ph.Riverplayeractiontype_id between 34 and 43 then 1 else 0 end) as RivervsRaiseRaise" Evaluate="RivervsRaiseRaise*100.0/(RiverFacingRaise)" ColumnHeader="River\nvs Raise\nRaise%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player reraises when his bet is raised on the River" />

<Stat GroupName="Flop" ColumnName="FlopvsRaiseFold" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 23 and 43 then 1 else 0 end) as FlopFacingRaise;sum(case when ph.flopplayeractiontype_id =23 then 1 else 0 end) as FlopvsRaiseFold" Evaluate="FlopvsRaiseFold*100.0/(FlopFacingRaise)" ColumnHeader="Flop\nvs Raise\nFold%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player folds when his bet is raised on the flop" />

<Stat GroupName="Turn" ColumnName="TurnvsRaiseFold" ValueExpressions="sum(case when ph.Turnplayeractiontype_id between 23 and 43 then 1 else 0 end) as TurnFacingRaise;sum(case when ph.Turnplayeractiontype_id =23 then 1 else 0 end) as TurnvsRaiseFold" Evaluate="TurnvsRaiseFold*100.0/(TurnFacingRaise)" ColumnHeader="Turn\nvs Raise\nFold%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player folds when his bet is raised on the Turn" />

<Stat GroupName="River" ColumnName="RivervsRaiseFold" ValueExpressions="sum(case when ph.Riverplayeractiontype_id between 23 and 43 then 1 else 0 end) as RiverFacingRaise;sum(case when ph.Riverplayeractiontype_id =23 then 1 else 0 end) as RivervsRaiseFold" Evaluate="RivervsRaiseFold*100.0/(RiverFacingRaise)" ColumnHeader="River\nvs Raise\nFold%" ColumnFormat="0.0" ColumnWidth="61" Tooltip="% of time player folds when his bet is raised on the River" />

[Rvg72]

<Stat GroupName="Flop" ColumnName="Flop Set%" ValueExpressions="Sum(case when ph.HoleCardValue_ID between 1 and 13 and ph.MaxStreetSeen > 0 then 1 else 0 end) as TotalPocketPairsSeeingFlop;Sum(case when ph.HoleCardValue_ID between 1 and 13 and ph.MaxStreetSeen > 0 and FLOP.MadeHandValue in (60,61,62,120,140) then 1 else 0 end) as TotalFlopSets" Evaluate="TotalFlopSets*100.0/TotalPocketPairsSeeingFlop" ColumnHeader="Set%" ColumnFormat="0.0" ColumnWidth="60" Tooltip="Frequency that a pocket pair flops a set" />

<Stat GroupName="Flop" ColumnName="FoldToFlopCBet" ValueExpressions="sum(case when ph.flopfacingcbet = true then 1 else 0 end) as FacingFlopCBet;sum(case when ph.flopfoldedtocbet = true then 1 else 0 end) as FoldedToFlopCBet;" Evaluate="FoldedToFlopCbet*100.0/FacingFlopCBet" ColumnHeader="Flop\nFold\nvs Cbet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds to a flop continuation bet" />

<Stat GroupName="Flop" ColumnName="RaiseFlopCBet" ValueExpressions="sum(case when ph.flopfacingcbet = true then 1 else 0 end) as FacingFlopCBet;sum(case when ph.flopfacingcbet = true and FLOP.raisedcbet = true then 1 else 0 end) as RaisedFlopCBet;" Evaluate="RaisedFlopCbet*100.0/FacingFlopCBet" ColumnHeader="Flop\nRaise\nCbet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises a flop continuation bet" />

<Stat GroupName="Turn" ColumnName="FoldToTurnCBet" ValueExpressions="sum(case when ph.Turnfacingcbet = true then 1 else 0 end) as FacingTurnCBet;sum(case when ph.Turnfoldedtocbet = true then 1 else 0 end) as FoldedToTurnCBet;" Evaluate="FoldedToTurnCbet*100.0/FacingTurnCBet" ColumnHeader="Turn\nFold\nvs Cbet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds to a Turn continuation bet" />

<Stat GroupName="Turn" ColumnName="RaiseTurnCBet" ValueExpressions="sum(case when ph.Turnfacingcbet = true then 1 else 0 end) as FacingTurnCBet;sum(case when ph.Turnfacingcbet = true and TURN.raisedcbet then 1 else 0 end) as RaisedTurnCBet;" Evaluate="RaisedTurnCbet*100.0/FacingTurnCBet" ColumnHeader="Turn\nRaise\nCbet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises a Turn continuation bet" />

<Stat GroupName="River" ColumnName="FoldToRiverCBet" ValueExpressions="sum(case when ph.Riverfacingcbet = true then 1 else 0 end) as FacingRiverCBet;sum(case when ph.Riverfoldedtocbet = true then 1 else 0 end) as FoldedToRiverCBet;" Evaluate="FoldedToRiverCbet*100.0/FacingRiverCBet" ColumnHeader="River\nFold\nvs Cbet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player folds to a River continuation bet" />

<Stat GroupName="River" ColumnName="RaiseRiverCBet" ValueExpressions="sum(case when ph.Riverfacingcbet = true then 1 else 0 end) as FacingRiverCBet;sum(case when ph.Riverfacingcbet = true and RIVER.raisedcbet then 1 else 0 end) as RaisedRiverCBet;" Evaluate="RaisedRiverCbet*100.0/FacingRiverCBet" ColumnHeader="River\nRaise\nCbet" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises a River continuation bet" />

<Stat GroupName="Preflop by Position" ColumnName="EAUOPFR/BTNUOPFR" ValueExpressions="sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID=0 then 1 else 0 end) as EarlyPositionUnopenedHands;sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as EarlyPositionUnopenedPFR;sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID=0 then 1 else 0 end) as ButtonPositionUnopenedHands;sum(case when ph.PositionType_ID=5 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as ButtonPositionUnopenedPFR" Evaluate="(ButtonPositionUnopenedPFR*100.0/ButtonPositionUnopenedHands)/(EarlyPositionUnopenedPFR*100.0/EarlyPositionUnopenedHands)" ColumnHeader="Preflop\nPositional\nAwareness" ColumnFormat="0.00" ColumnWidth="61" Tooltip="Compares unopened preflop raise % on button and divides it by unopened preflop raise % from early position. A value of 2.5 for example would mean he opens 2.5 times as many hands on the button as he does in early position" />

<Stat GroupName="Preflop by Position" ColumnName="EAUOVPIP" ValueExpressions="sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID=0 then 1 else 0 end) as EarlyPositionUnopenedHands;sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID=0 and didvpip=true then 1 else 0 end) as EarlyPositionUnopenedVPIP" Evaluate="EarlyPositionUnopenedVPIP*100.0/EarlyPositionUnopenedHands" ColumnHeader="Early\nUO\nVPIP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player voluntarily puts in money preflop when in early position with nobody else in the pot" />

<Stat GroupName="Preflop by Position" ColumnName="EAUOPFR" ValueExpressions="sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID=0 then 1 else 0 end) as EarlyPositionUnopenedHands;sum(case when ph.PositionType_ID=2 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as EarlyPositionUnopenedPFR" Evaluate="EarlyPositionUnopenedPFR*100.0/EarlyPositionUnopenedHands" ColumnHeader="Early\nUO\nPFR" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises preflop when in early position with nobody else in the pot" />

<Stat GroupName="Preflop by Position" ColumnName="MDUOVPIP" ValueExpressions="sum(case when ph.PositionType_ID=3 and ph.preflopaction_ID=0 then 1 else 0 end) as MiddlePositionUnopenedHands;sum(case when ph.PositionType_ID=3 and ph.preflopaction_ID=0 and didvpip=true then 1 else 0 end) as MiddlePositionUnopenedVPIP" Evaluate="MiddlePositionUnopenedVPIP*100.0/MiddlePositionUnopenedHands" ColumnHeader="Middle\nUO\nVPIP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player voluntarily puts in money preflop when in middle position with nobody else in the pot" />

<Stat GroupName="Preflop by Position" ColumnName="MDUOPFR" ValueExpressions="sum(case when ph.PositionType_ID=3 and ph.preflopaction_ID=0 then 1 else 0 end) as MiddlePositionUnopenedHands;sum(case when ph.PositionType_ID=3 and ph.preflopaction_ID=0 and didPFR=true then 1 else 0 end) as MiddlePositionUnopenedPFR" Evaluate="MiddlePositionUnopenedPFR*100.0/MiddlePositionUnopenedHands" ColumnHeader="Middle\nUO\nPFR" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player raises preflop when in middle position with nobody else in the pot" />

<Stat GroupName="Preflop by Position" ColumnName="COUOVPIP" ValueExpressions="sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID=0 then 1 else 0 end) as CutoffPositionUnopenedHands;sum(case when ph.PositionType_ID=4 and ph.preflopaction_ID=0 and didvpip=true then 1 else 0 end) as CutoffPositionUnopenedVPIP" Evaluate="CutoffPositionUnopenedVPIP*100.0/CutoffPositionUnopenedHands" ColumnHeader="Cutoff\nUO\nVPIP" ColumnFormat="0.0" ColumnWidth="61" Tooltip="Pct of time player voluntarily puts in money preflop when one of the button with nobody else in the pot" />