Poker on Excel

Water Cooler
#1

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

  1. Can you think of an easier method of doing this

  2. If using sampling, how can i include represenation of the suit (i.e 10 hearts of a 10 of spades)

  3. 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