iPoker points custom report for HEM?

    • erptech
      erptech
      Gold
      Joined: 15.03.2008 Posts: 659
      does anyone know where can i download custom stats for HEM that calculate how many WH points i made, i'm pretty sure its somewhere on this forum but can't find it.
  • 3 replies
    • HannesZ
      HannesZ
      Headadmin
      Headadmin
      Joined: 30.06.2010 Posts: 16,314
      I hope this is still up to date.

      Best regards,
      Hannes

      code:
      <Stat GroupName="Default" ColumnName="WilliamHill Points contributed" ValueExpressions="
      Sum(
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between   1 and   2 then  0.2   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between   3 and   5 then  0.5   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between   6 and  10 then  0.7   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between  11 and  20 then  1     else 0 end) + 
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between  21 and  50 then  2.5   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between  51 and  75 then  4.5   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between  76 and 100 then  6     else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 101 and 125 then  8     else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 126 and 150 then  9.5   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 151 and 175 then  11    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 176 and 200 then  13    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 201 and 225 then  14.5  else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 226 and 250 then  16    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 251 and 275 then  20    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 276 and 300 then  24    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >=      301         then  32    else 0 end)
      )/1.0
      as WHPoints" Evaluate="WHPoints" ColumnHeader="William Hill Points \n (contributed)" ColumnFormat="0.00" ColumnWidth="*" Tooltip="William Hill Basic Points" />
      
      <Stat GroupName="Default" ColumnName="WilliamHill Points/100 Hands" ValueExpressions="
      Sum(
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between   1 and   2 then  0.2   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between   3 and   5 then  0.5   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between   6 and  10 then  0.7   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between  11 and  20 then  1     else 0 end) + 
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between  21 and  50 then  2.5   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between  51 and  75 then  4.5   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between  76 and 100 then  6     else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 101 and 125 then  8     else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 126 and 150 then  9.5   else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 151 and 175 then  11    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 176 and 200 then  13    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 201 and 225 then  14.5  else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 226 and 250 then  16    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 251 and 275 then  20    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 276 and 300 then  24    else 0 end) +
        (case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >=      301         then  32    else 0 end)
      )/1.0
      as WHPoints100c" Evaluate="WHPoints100c/TotalHands*100.0" ColumnHeader="William Hill Points\n /100 Hands c" ColumnFormat="0.00" ColumnWidth="*" Tooltip="William Hill Basic Points per 100 Hands" />
      
      
    • erptech
      erptech
      Gold
      Joined: 15.03.2008 Posts: 659
      thanks, i got two custom reports, points (contributed) , and points/100

      i'll test it over the next few days to confirm...
    • HannesZ
      HannesZ
      Headadmin
      Headadmin
      Joined: 30.06.2010 Posts: 16,314
      Yes please let me know if everything works perfectly.

      Good luck on William Hill,
      Hannes