by Skouperd » Fri Apr 04, 2014 2:05 pm
Ok, finally got her up and running, finished my excel program and finally got the results. The excel spreadsheet is based on a very simple mathematical problem which I could not solve using traditional google methods. The mathematical problem boils down to how the odds for winning a hand in poker changes based on the number of players around the table. I've have simulated a 100 billion poker hands, played on a table 2 to 12 players and finally have the results.
[TABLE="width: 2220"]
[TR]
[TD]Number of players at table[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Hands assessed
[/TD]
[TD]2,597,402,598[/TD]
[TD]3,896,103,897[/TD]
[TD]5,194,805,196[/TD]
[TD]6,493,506,495[/TD]
[TD]7,792,207,794[/TD]
[TD]9,090,909,093[/TD]
[TD]10,389,610,392[/TD]
[TD]11,688,311,691[/TD]
[TD]12,987,012,990[/TD]
[TD]14,285,714,289[/TD]
[TD]15,584,415,588[/TD]
[/TR]
[TR]
[TD]<= Two Pair[/TD]
[TD]74.15%[/TD]
[TD]65.42%[/TD]
[TD]58.02%[/TD]
[TD]51.68%[/TD]
[TD]46.20%[/TD]
[TD]41.37%[/TD]
[TD]37.14%[/TD]
[TD]33.44%[/TD]
[TD]30.21%[/TD]
[TD]27.34%[/TD]
[TD]24.75%[/TD]
[/TR]
[TR]
[TD]<= Three of a kind[/TD]
[TD]81.37%[/TD]
[TD]74.68%[/TD]
[TD]69.03%[/TD]
[TD]64.24%[/TD]
[TD]60.02%[/TD]
[TD]56.27%[/TD]
[TD]52.93%[/TD]
[TD]49.96%[/TD]
[TD]47.35%[/TD]
[TD]44.89%[/TD]
[TD]42.61%[/TD]
[/TR]
[TR]
[TD]<= Straight[/TD]
[TD]89.76%[/TD]
[TD]85.98%[/TD]
[TD]82.70%[/TD]
[TD]79.85%[/TD]
[TD]77.29%[/TD]
[TD]74.92%[/TD]
[TD]72.75%[/TD]
[TD]70.78%[/TD]
[TD]68.94%[/TD]
[TD]67.18%[/TD]
[TD]65.52%[/TD]
[/TR]
[TR]
[TD]<= Flush
[/TD]
[TD]94.93%[/TD]
[TD]92.93%[/TD]
[TD]91.11%[/TD]
[TD]89.48%[/TD]
[TD]87.97%[/TD]
[TD]86.55%[/TD]
[TD]85.26%[/TD]
[TD]84.07%[/TD]
[TD]82.96%[/TD]
[TD]81.86%[/TD]
[TD]80.81%[/TD]
[/TR]
[TR]
[TD]<= Full House[/TD]
[TD]99.63%[/TD]
[TD]99.45%[/TD]
[TD]99.26%[/TD]
[TD]99.09%[/TD]
[TD]98.90%[/TD]
[TD]98.72%[/TD]
[TD]98.54%[/TD]
[TD]98.36%[/TD]
[TD]98.20%[/TD]
[TD]98.03%[/TD]
[TD]97.85%[/TD]
[/TR]
[/TABLE]
Using all the processing power at my disposal on the above mystery build, the program managed to calculate the 100,000,000,000 poker hands in less than 40 minutes.
Should you like to run the excel file, feel free to download it here. It makes a nice benchmarking tool if you enable the timers.
http://downloads.skoups.com/Other/Simulate%20Poker%20Hands_v014%20-%20100%20billion.xlsmPs, unless you have really serious amount of processing power, do not try to calculate a 100 billion poker hands.
Ok, finally got her up and running, finished my excel program and finally got the results. The excel spreadsheet is based on a very simple mathematical problem which I could not solve using traditional google methods. The mathematical problem boils down to how the odds for winning a hand in poker changes based on the number of players around the table. I've have simulated a 100 billion poker hands, played on a table 2 to 12 players and finally have the results.
[TABLE="width: 2220"]
[TR]
[TD]Number of players at table[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Hands assessed
[/TD]
[TD]2,597,402,598[/TD]
[TD]3,896,103,897[/TD]
[TD]5,194,805,196[/TD]
[TD]6,493,506,495[/TD]
[TD]7,792,207,794[/TD]
[TD]9,090,909,093[/TD]
[TD]10,389,610,392[/TD]
[TD]11,688,311,691[/TD]
[TD]12,987,012,990[/TD]
[TD]14,285,714,289[/TD]
[TD]15,584,415,588[/TD]
[/TR]
[TR]
[TD]<= Two Pair[/TD]
[TD]74.15%[/TD]
[TD]65.42%[/TD]
[TD]58.02%[/TD]
[TD]51.68%[/TD]
[TD]46.20%[/TD]
[TD]41.37%[/TD]
[TD]37.14%[/TD]
[TD]33.44%[/TD]
[TD]30.21%[/TD]
[TD]27.34%[/TD]
[TD]24.75%[/TD]
[/TR]
[TR]
[TD]<= Three of a kind[/TD]
[TD]81.37%[/TD]
[TD]74.68%[/TD]
[TD]69.03%[/TD]
[TD]64.24%[/TD]
[TD]60.02%[/TD]
[TD]56.27%[/TD]
[TD]52.93%[/TD]
[TD]49.96%[/TD]
[TD]47.35%[/TD]
[TD]44.89%[/TD]
[TD]42.61%[/TD]
[/TR]
[TR]
[TD]<= Straight[/TD]
[TD]89.76%[/TD]
[TD]85.98%[/TD]
[TD]82.70%[/TD]
[TD]79.85%[/TD]
[TD]77.29%[/TD]
[TD]74.92%[/TD]
[TD]72.75%[/TD]
[TD]70.78%[/TD]
[TD]68.94%[/TD]
[TD]67.18%[/TD]
[TD]65.52%[/TD]
[/TR]
[TR]
[TD]<= Flush
[/TD]
[TD]94.93%[/TD]
[TD]92.93%[/TD]
[TD]91.11%[/TD]
[TD]89.48%[/TD]
[TD]87.97%[/TD]
[TD]86.55%[/TD]
[TD]85.26%[/TD]
[TD]84.07%[/TD]
[TD]82.96%[/TD]
[TD]81.86%[/TD]
[TD]80.81%[/TD]
[/TR]
[TR]
[TD]<= Full House[/TD]
[TD]99.63%[/TD]
[TD]99.45%[/TD]
[TD]99.26%[/TD]
[TD]99.09%[/TD]
[TD]98.90%[/TD]
[TD]98.72%[/TD]
[TD]98.54%[/TD]
[TD]98.36%[/TD]
[TD]98.20%[/TD]
[TD]98.03%[/TD]
[TD]97.85%[/TD]
[/TR]
[/TABLE]
Using all the processing power at my disposal on the above mystery build, the program managed to calculate the 100,000,000,000 poker hands in less than 40 minutes.
Should you like to run the excel file, feel free to download it here. It makes a nice benchmarking tool if you enable the timers.
[url]http://downloads.skoups.com/Other/Simulate%20Poker%20Hands_v014%20-%20100%20billion.xlsm[/url]
Ps, unless you have really serious amount of processing power, do not try to calculate a 100 billion poker hands.