<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" />
|