Hi,
I am building an application for contract bridge bidding and hand evaluation training for our bridge club.
What is the most efficient way to code vba to perform a random deal of a full 52 card deck to 4 different positions - 13 cards each. I will need this to be completed as a matrix of the four suits and 2 to Ace (13 each). For this purpose it doesn't need to be truly random i.e. using a cesium clock etc BTW There are 5.36 x 10^28 possible deals.
I have various adjustments and constraints that I need to be able to apply based upon distributions but this may be more easily achieved through procedures applied to analyse the random deal and adjust it after the fact.
I am building an application for contract bridge bidding and hand evaluation training for our bridge club.
What is the most efficient way to code vba to perform a random deal of a full 52 card deck to 4 different positions - 13 cards each. I will need this to be completed as a matrix of the four suits and 2 to Ace (13 each). For this purpose it doesn't need to be truly random i.e. using a cesium clock etc BTW There are 5.36 x 10^28 possible deals.
I have various adjustments and constraints that I need to be able to apply based upon distributions but this may be more easily achieved through procedures applied to analyse the random deal and adjust it after the fact.