Bets or Raises with Less Than a Board Reveal

[wallacedavidl]

Getting ready to try that now...

[wallacedavidl]

It took a minute to walk through all the advise probided in this thread. I think I can now better explain the two final things I need to add to some of my custom statistic logic before closing this thread...

1. An expression that reveals when there's 3 Board cards to a Flush, factoring it could test true on the FLOP, TURN, or RIVER.

2. An expression that reveals when there's 3 Board cards to a Straight, factoring it could test true on the FLOP, TURN or RIVER.

Thanks,
David

[Flag_Hippo]

1. An expression that reveals when there's 3 Board cards to a Flush, factoring it could test true on the FLOP, TURN, or RIVER.

Code: Select all

(((((((cash_hand_summary.card_1 > 0 and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13))))))OR (((((cash_hand_summary.card_4 > 0 AND ((cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) = cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13)) OR (cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13))))))))OR (((((cash_hand_summary.card_5 > 0 and ((cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) != cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) != cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) != cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) != cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13) and cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) != cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) != cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) != cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) = cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) = cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) != cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) != cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) = cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13)) OR (cash_hand_summary.card_1 - ((cash_hand_summary.card_1 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_2 - ((cash_hand_summary.card_2 - 1) % 13) != cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) and cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) = cash_hand_summary.card_4 - ((cash_hand_summary.card_4 - 1) % 13) and cash_hand_summary.card_3 - ((cash_hand_summary.card_3 - 1) % 13) = cash_hand_summary.card_5 - ((cash_hand_summary.card_5 - 1) % 13))))))))))

2. An expression that reveals when there's 3 Board cards to a Straight, factoring it could test true on the FLOP, TURN or RIVER.

There isn't a built-in filter for that and it would be an extremely complex filter to build.

[wallacedavidl]

Thanks for the detailed response. What if the complex Straight Filter was broken into 3 pieces, one for the FLOP, TURN and RIVER test conditions?

[wallacedavidl]

Hey Team -

I think I figured it out. Please verify that the following expression tests for when the Boarded TURN card makes a STRAIGHT possible. Thanks...

(((((((cash_hand_summary.card_4 > 0 AND ( ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<0) )>>0 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<1) )>>1 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<2) )>>2 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<3) )>>3 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<4) )>>4 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<5) )>>5 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<6) )>>6 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<7) )>>7 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<8) )>>8 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<9) )>>9 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & ((31<<9)+1)) IN ( 1537, 2561, 3073, 4609, 5121, 6145, 3585, 5633, 6657, 7169 ))))))))))

[Flag_Hippo]

I think I figured it out. Please verify that the following expression tests for when the Boarded TURN card makes a STRAIGHT possible. Thanks...

(((((((cash_hand_summary.card_4 > 0 AND ( ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<0) )>>0 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<1) )>>1 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<2) )>>2 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<3) )>>3 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<4) )>>4 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<5) )>>5 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<6) )>>6 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<7) )>>7 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<8) )>>8 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<9) )>>9 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & ((31<<9)+1)) IN ( 1537, 2561, 3073, 4609, 5121, 6145, 3585, 5633, 6657, 7169 ))))))))))

So for the turn when you say "the Boarded TURN card makes a STRAIGHT possible" that's what you wanted when you said "3 Board cards to a Straight"? It would be helpful if you also mentioned the filters you used in PokerTracker 4. It looks like you just used 'Connectedness on Turn Any Made Straight is Possible' and that's not going to give you what you want. This filter/expression will just give you all turns where a straight is possible regardless whether the turn card itself made it possible or not. You will need to filter for (NOT (Connectedness on Flop Any Made Straight is Possible)) AND (Connectedness on Turn Any Made Straight is Possible) instead.

[wallacedavidl]

Hey, Team -

Thanks for the clarification. Three questions based on your response...

1. If I want to show the RIVER card made a Board Straight Possible, I must use the NOT operator on both the FLOP and TURN to first eliminate those possibilities, correct?

2. If question 1 is correct, I can use that process of elimination for any other board texture I want to reference, correct?

3. Going with the assumption that the answers to both the above questions is yes, I can create custom statistics, which allows me to reference Bet action I take with a specific hand strength when various hands are possible based on the Board Texture. Let's say I create some Hand Columns that represent various Board Textures such as my_flop_made_straight, my_turn_made_straight, etc. Then I could reference those Hand Columns in a Players Column CASE WHEN expression that tests for when I use a specific hand strength when certian Board Textures are present as in the following, correct?

WHEN
(cash_hand_player_combinations.flg_f_1pair
AND
(my_flop_made_straight OR my_flop_made_flush))
OR
(cash_hand_player_combinations.flg_t_1pair
AND
(my_turn_made_straight OR my_turn_made_flush))
OR
(cash_hand_player_combinations.flg_r_1pair
AND
(my_river_made_straight OR my_river_made_flush)
THEN 1

[wallacedavidl]

Following is the TURN Straight Hand Column expression with the NOT operator applied on the FLOP as directed. Is the below correct?

((((NOT ((((cash_hand_summary.card_1 % 13 != cash_hand_summary.card_2 % 13 and cash_hand_summary.card_1 % 13 != cash_hand_summary.card_3 % 13 and cash_hand_summary.card_2 % 13 != cash_hand_summary.card_3 % 13 and (((cash_hand_summary.card_1 % 13 = 0 OR cash_hand_summary.card_2 % 13 = 0 OR cash_hand_summary.card_3 % 13 = 0) AND ((cash_hand_summary.card_1 % 13 BETWEEN 0 and 4 and cash_hand_summary.card_2 % 13 BETWEEN 0 and 4 and cash_hand_summary.card_3 % 13 BETWEEN 0 and 4) OR ((cash_hand_summary.card_1 % 13 IN (0,9,10,11,12)) AND (cash_hand_summary.card_2 % 13 IN (0,9,10,11,12)) AND (cash_hand_summary.card_3 % 13 IN (0,9,10,11,12))) )) OR (cash_hand_summary.card_2 % 13 BETWEEN ((cash_hand_summary.card_1 % 13) + 1) and ((cash_hand_summary.card_1 % 13) + 4) AND cash_hand_summary.card_3 % 13 BETWEEN ((cash_hand_summary.card_1 % 13) + 1) and ((cash_hand_summary.card_1 % 13) + 4)) OR (cash_hand_summary.card_1 % 13 BETWEEN ((cash_hand_summary.card_2 % 13) + 1) and ((cash_hand_summary.card_2 % 13) + 4) AND cash_hand_summary.card_3 % 13 BETWEEN ((cash_hand_summary.card_2 % 13) + 1) and ((cash_hand_summary.card_2 % 13) + 4)) OR (cash_hand_summary.card_2 % 13 BETWEEN ((cash_hand_summary.card_3 % 13) + 1) and ((cash_hand_summary.card_3 % 13) + 4) AND cash_hand_summary.card_1 % 13 BETWEEN ((cash_hand_summary.card_3 % 13) + 1) and ((cash_hand_summary.card_3 % 13) + 4)))))))))AND (((((cash_hand_summary.card_4 > 0 AND ( ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<0) )>>0 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<1) )>>1 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<2) )>>2 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<3) )>>3 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<4) )>>4 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<5) )>>5 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<6) )>>6 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<7) )>>7 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<8) )>>8 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & (31<<9) )>>9 IN ( 7, 11, 13, 14, 19, 21, 22, 25, 26, 28, 15, 23, 27, 29, 30 )) OR ((((1 << (cash_hand_summary.card_1 % 13)) | (1 << (cash_hand_summary.card_2 % 13)) | (1 << (cash_hand_summary.card_3 % 13)) | (1 << (cash_hand_summary.card_4 % 13))) & ((31<<9)+1)) IN ( 1537, 2561, 3073, 4609, 5121, 6145, 3585, 5633, 6657, 7169 ))))))))))

[wallacedavidl]

I think my test shows I can't reference both a Hand Column and Players Column in the expression of another column I want to create...

[Flag_Hippo]

1. If I want to show the RIVER card made a Board Straight Possible, I must use the NOT operator on both the FLOP and TURN to first eliminate those possibilities, correct?

You would only need to do it for the turn. If a straight wasn't possible on the turn then it wouldn't have been possible on the flop either.

Let's say I create some Hand Columns that represent various Board Textures such as my_flop_made_straight, my_turn_made_straight, etc. Then I could reference those Hand Columns in a Players Column CASE WHEN expression that tests for when I use a specific hand strength when certian Board Textures are present as in the following, correct?

You shouldn't be creating 'Hand' columns. You are creating statistics for players so you need to create these as 'Player' columns and test for what you want there.