Baccarat system tester (identifying patterns)
Is it possible to find certain patterns in excel?
I have Baccarat shoe data which I import to a spreadsheet. I would like to identify 4 different patterns in the shoe as per attached example.
The top image of the attachment is an example of the data I have.
In the 2nd image I have highlighted the different patterns I am trying to identify. The “P” and “B” does not make a difference to the patterns. PBP makes the same pattern as BPB.
After I have identified the 4 patterns I start over again looking for the same patterns again. The patterns can be in any order and they can overlap. There are certain rules for some of the patterns which either makes it a valid pattern or not. More about the rules if this project is at all possible in excel.
I have 25,000 shoes to check each with about 80 hands.
I would appreciate any feedback or guidance in the right direction.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By dbogey in forum Excel Formulas & Functions
Last Post: 01-08-2016, 02:48 PM
By MarvinP in forum Excel Programming / VBA / Macros
Last Post: 02-25-2015, 10:19 AM
By yellow281 in forum Excel Formulas & Functions
Last Post: 08-29-2012, 12:04 PM
By ChemistB in forum Excel Programming / VBA / Macros
Last Post: 05-13-2011, 12:00 PM
By cescal in forum Excel - New Users/Basics
Last Post: 03-03-2011, 04:06 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1