I am looking to create a shared spreadsheet to create a poker game among friends without it being obvious to employers. I’ve attached some data (FYI 14 is an ace, 13 is a king, 12 Queen, and 11 is Jack). I was thinking of doing sampling to generate the flop, turn and river. A few questions for my excel gurus
-
Can you think of an easier method of doing this
-
If using sampling, how can i include represenation of the suit (i.e 10 hearts of a 10 of spades)
-
Is there anyway to condition the sampling not to draw from the numbers already taken. (i.e the flop is 10spades, 9hearts, 7hearts; i want to ensure the turn isn’t any of the given three listed)
I’ve included a spreadsheet for some input. Many thxs
https://docs.google.com/spreadsheet/ccc?key=0Aq5VM8TMq0dudDR5eWh5LTBtWnRFcjU4VXlVU2QxWFE&usp=sharing