WanderingMind
02-08-2009, 09:18 PM
The VPIP reports high due to pre-flop folded hands not being inserted into the playerhands tables.
I did a small sample of seeing 8 hands and importing them.
-------------------------
1 BB (no raises to me so i checked and folded on flop),
1 SB - folded pre-flop, did not complete,
2 other hands I entered,
4 others i folded preflop.
the denominator should have been 8.
the nominator was the 2 hands i entered for a VPIP of 2/8 = 25%
BUT, the importer does not create a line item in playerhandscashkeycolumns for hands folded preflop (fine, it saves space, and i dont need to evaluate preflop folded hands) and only displays the BB hand, SB hand, and 2 hands I entered for a VPIP of 50%.
Selecting sum(1) of playerhandscashkeycolumns for the denominator of the VPIP results in a logic flaw.
I haven't checked the HUD, but I don't imagine you have 2 different stat functions for the same data source.
I did a small sample of seeing 8 hands and importing them.
-------------------------
1 BB (no raises to me so i checked and folded on flop),
1 SB - folded pre-flop, did not complete,
2 other hands I entered,
4 others i folded preflop.
the denominator should have been 8.
the nominator was the 2 hands i entered for a VPIP of 2/8 = 25%
BUT, the importer does not create a line item in playerhandscashkeycolumns for hands folded preflop (fine, it saves space, and i dont need to evaluate preflop folded hands) and only displays the BB hand, SB hand, and 2 hands I entered for a VPIP of 50%.
Selecting sum(1) of playerhandscashkeycolumns for the denominator of the VPIP results in a logic flaw.
I haven't checked the HUD, but I don't imagine you have 2 different stat functions for the same data source.