bacmac
bacmac
  • Threads: 1
  • Posts: 3
Joined: Feb 3, 2020
February 3rd, 2020 at 6:28:16 PM permalink
Hello everyone, is there any one smart and kind enough to set up a simple Baccarat simulator using Excel or whatnot? The shoe simulator should generate 25,000+ shoes at a time, using eight decks, following all the rules, have a cut card beginning and end of shoes and each shoe should have around 75 hands. The result should be random as possible and use each card but doesn't need to show the actual card values in the results. It only needs to have the shoe number and B,P,T for banker, player and tie.

1BPPPPTBPBBPTPBPBP..........
2PPPBBBBPPPBTTPBPBPPT........
3PBBBPBPT........
..........
........
25000PPBBTPTPPB.......

I've already used 250,000 and 100,000 shoes i found online. I wish to have more samples. Thank you.
Ace2
Ace2
  • Threads: 32
  • Posts: 2706
Joined: Oct 2, 2017
February 3rd, 2020 at 6:58:26 PM permalink
What are you trying to count/analyze? Streaks ?
It’s all about making that GTA
Wizard
Administrator
Wizard
  • Threads: 1520
  • Posts: 27096
Joined: Oct 14, 2009
February 4th, 2020 at 5:23:18 AM permalink
One can just use the probabilities of each winning outcome (player, banker, or tie) from my site and map a random number from Excel to get a random outcome.
"For with much wisdom comes much sorrow." -- Ecclesiastes 1:18 (NIV)
bacmac
bacmac
  • Threads: 1
  • Posts: 3
Joined: Feb 3, 2020
February 4th, 2020 at 7:41:55 AM permalink
Can you please walk me thru a little more? I dont really know how to use excel and i want to get a few million shoes for my sample. thank you.
7craps
7craps
  • Threads: 18
  • Posts: 1977
Joined: Jan 23, 2010
February 4th, 2020 at 9:20:35 AM permalink
Quote: bacmac

The result should be random as possible and use each card

"random as possible" should mean, as one is simply shuffling the 8 decks of cards, 1 of the possible shoe orderings
from all 416! possible shoes and not have a duplicate(s).

416! is a very large number (911 digits long)
and with many duplicate value cards one could look at fewer possible shufflings that will produce the BPT sequence.
416! / ((32!)^9 * (128!)) = 377 digits
164944883791287598411943116655903865118824068362
983914007087347084013829196364680846614865667459
022964650355867714652074291682596726831437397546
695056560355540746705637562240501155776567564785
022522219704232111595011221458008894065762070053
057540438153207938737327767112605303189053871399
047436327387252956448398946650681893111055183549
42178373831442020424406884197134050000000

some shoes will produce the very same BPT sequence
(possibly a fun math exercise.
How many possible BPT sequences, following normal rules, are there from 8 deck Bacc shoe?)
and these must be considered as being possible

your request for more samples seems to be a very LARGE waste of time
as you may seem to be trying to solve a problem or many problems that do not require 'sample shoes'.
winsome johnny (not Win some johnny)
bacmac
bacmac
  • Threads: 1
  • Posts: 3
Joined: Feb 3, 2020
February 4th, 2020 at 2:03:22 PM permalink
I don't understand surely what you're saying.. I just want a sample of two million shoes.. I figured it wouldn't be too complicated by using Excel
charliepatrick
charliepatrick
  • Threads: 39
  • Posts: 3014
Joined: Jun 17, 2011
February 4th, 2020 at 4:11:14 PM permalink
Quote: bacmac

...I dont really know how to use excel and i want to get a few million shoes for my sample. thank you.

It may be easier to write a program than use excel. To do it properly you need to good random number generator and the one in excel, certainly in older versions, might not be good enough.

One possible approach is to generate lots of random numbers and use rank to shuffle the deck (e.g. RANK=1-8 = As etc.) Then work your way through the shoe working out each hand. The problem is you need to ensure you don't keep repeating the same shoes as bad RNG's tend to have a cycle. Personally I shuffle the deck by swapping cards rather than creating a new one each time.
  • Jump to: