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