This site uses cookies to improve your browsing experience. By continuing to browse the website, you accept such cookies. For more details and to change your settings, see our Cookie Policy and Privacy Policy. Close

iPoker points custom report for HEM?

    • erptech
      erptech
      Silver
      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,323
      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
      Silver
      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,323
      Yes please let me know if everything works perfectly.

      Good luck on William Hill,
      Hannes