PDA

View Full Version : Pocket Pair - Set Report



woopstash
07-24-2010, 11:00 PM
I couldn't manage to find a custom report that gave some decently detailed stats on sets for pocket pairs so I created one. I'll post the code so that if anyone wants it, they can use it. Also if anyone has any improvements, they can offer them up here.

Set or better = Sets, FH (without trips on board), and Quads

Add the following to customstats.txt in Reports folder (create this file if it doesn't exist)



<Stat GroupName="Default" ColumnName="TopSet" ValueExpressions="sum(case when FLOP.MadeHandValue = 60 then 1 else 0 end) as TopSets" Evaluate="TopSets" ColumnHeader="Top Sets" ColumnFormat="0" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="MiddleSet" ValueExpressions="sum(case when FLOP.MadeHandValue = 61 then 1 else 0 end) as MiddleSets" Evaluate="MiddleSets" ColumnHeader="Middle Sets" ColumnFormat="0" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="BottomSet" ValueExpressions="sum(case when FLOP.MadeHandValue = 62 then 1 else 0 end) as BottomSets" Evaluate="BottomSets" ColumnHeader="Bottom Sets" ColumnFormat="0" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="Quads" ValueExpressions="sum(case when FLOP.MadeHandValue = 140 then 1 else 0 end) as Quads" Evaluate="Quads" ColumnHeader="Quads" ColumnFormat="0" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="FH with PP" ValueExpressions="sum(case when FLOP.MadeHandValue = 120 then 1 else 0 end) as FHwPP" Evaluate="FHwPP" ColumnHeader="FH w PP" ColumnFormat="0" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="Sets" ValueExpressions="sum(case when FLOP.MadeHandValue >=60 and FLOP.MadeHandValue <=62 then 1 else 0 end) as Sets" Evaluate="Sets" ColumnHeader="Total Sets" ColumnFormat="0" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="Pocket Pairs" ValueExpressions="
sum(case when HOLECARDS.HoleCard_ID >=1 and HOLECARDS.HoleCard_ID <=13 then 1 else 0 end) as PPs" Evaluate="PPs" ColumnHeader="PocketPairs" ColumnFormat="0" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="PPSawFlop" ValueExpressions="
sum(case when HOLECARDS.HoleCard_ID >=1 and HOLECARDS.HoleCard_ID <=13 and ph.maxstreetseen >= 1 then 1 else 0 end) as PPSawFlop" Evaluate="PPSawFlop" ColumnHeader="PPs Saw Flop" ColumnFormat="0" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="SetPercentage"
ValueExpressions="
sum(case when HOLECARDS.HoleCard_ID >=1 and HOLECARDS.HoleCard_ID <=13 and ph.maxstreetseen >= 1 then 1 else 0 end) as PPSawFlop;
sum(case when FLOP.MadeHandValue >=60 and FLOP.MadeHandValue <=62 then 1 else 0 end) as Sets"
Evaluate="(Sets/PPSawFlop)*100" ColumnHeader="Set %" ColumnFormat="0.00" ColumnWidth="*" Tooltip=" " />
<Stat GroupName="Default" ColumnName="SetOrBetterPercentage"
ValueExpressions="
sum(case when HOLECARDS.HoleCard_ID >=1 and HOLECARDS.HoleCard_ID <=13 and ph.maxstreetseen >= 1 then 1 else 0 end) as PPSawFlop;
sum(case when FLOP.MadeHandValue IN (60,61,62,120,140) then 1 else 0 end) as SetsOrBetter"
Evaluate="(SetsOrBetter/PPSawFlop)*100" ColumnHeader="Set Or Better %" ColumnFormat="0.00" ColumnWidth="*" Tooltip=" " />

Add this code as a new report file (ie: PocketPair-Sets.Report)

<Report Name="Sets" FilterByExpression="HOLECARDS.HoleCard_ID IN (1,2,3,4,5,6,7,8,9,10,11,12,13)" Version="1.1">
<Groupings><Grouping FieldExpression="HOLECARDS.HoleCard_ID" ColumnName="HoleCard_ID" ColumnHeader="Cards" ColumnFormat="" ColumnWidth="70" ToolTip="Cards"><Ranges><Range MinValue="1" MaxValue="1" RangeName="01)AA" /><Range MinValue="2" MaxValue="2" RangeName="02)KK" /><Range MinValue="3" MaxValue="3" RangeName="03)QQ" /><Range MinValue="4" MaxValue="4" RangeName="04)JJ" /><Range MinValue="5" MaxValue="5" RangeName="05)TT" /><Range MinValue="6" MaxValue="6" RangeName="06)99" /><Range MinValue="7" MaxValue="7" RangeName="07)88" /><Range MinValue="8" MaxValue="8" RangeName="08)77" /><Range MinValue="9" MaxValue="9" RangeName="09)66" /><Range MinValue="10" MaxValue="10" RangeName="10)55" /><Range MinValue="11" MaxValue="11" RangeName="11)44" /><Range MinValue="12" MaxValue="12" RangeName="12)33" /><Range MinValue="13" MaxValue="13" RangeName="13)22" /><Range MinValue="0" MaxValue="1" RangeName="WTF" /></Ranges></Grouping></Groupings>
<Stats>
<Stat StatName="PPSawFlop" />
<Stat StatName="Sets" />
<Stat StatName="FH with PP" />
<Stat StatName="Quads" />
<Stat StatName="SetPercentage" />
<Stat StatName="SetOrBetterPercentage" />
<Stat StatName="TopSet" />
<Stat StatName="MiddleSet" />
<Stat StatName="BottomSet" />
<Stat StatName="Big Bets per 100" />
<Stat StatName="Net Amount Won" />
</Stats></Report>