Missing dozen comparisons software

[Midnight Player]

Hello, can one of the honorable coders please help me investigate a dozens parameter that I have noticed and see what the maximum is? Basically I want to compare  a particular dozen ie if the last two dozens are D1 and D2 then I want to compare the missing dozen D3 against the D3 of many  short random spins sequences, eg 20 spins long (pre selected). If the random spin against which the latest spin is compared is the same then it is flagged. I have only seen 10 flags in a row to date. The idea behind this is to compare the last spin of the game being played against many random spin selections and when one of the spin selections gets to say 8 flags then one checks the next random selection no and bets that it will not be the same by betting on the other two dozens. By checking against hundreds of short random selections instantly one can speed up the waiting period for 8 flags (same as). I have attached a simple Excel file I set up where I attempted to do this in a simple way.
many thanks
MP

[ophis]

mmmmm. im confused. wont this be the same as "how long dozen can sleep?" because dozen can sleep for 30+ spins....

[Midnight Player]

Ophis, the dozen changes regularly, so its not about following a particular sleeping dozen, but rather comparing a previous spin sample's missing dozen with the current game. When that dozen is the same then a color block appears (flag). I wish to see what is a typical max on this type of tracking. let me know if I am making sense! 

[ophis]

I don't know if this is just me but I just can't understand what are you talking about in first post.

Ps. I did watch today movie on TED about how the brain works and I did understand most of it... so I think something have to be wrong with your post. Does anyone else can understand it? And put in in a bit different words?  

[Midnight Player]

I am sure your brain is just fine    so let me see if I can explain myself a little more clearly.
I want to compare the present spin result of my game against another previous spin result which is either a series of spins set aside  for this or like in the case of my excel spreadsheet I used the previous spins in the same session to compare against. I compare against a prediction ie if dozen 1 and dozen 2 were the last two spins then the prediction is dozen 3. If the present spin is also dozen 3 then I have a match  and hence a flag or in the case of the excel spread sheet I use a colored block. If a comparison is made against many hundreds of different spin samples is done simultaneousness, then a sequence of flags ie. matches will show. If the upper limits of matches are say 10 in a row then when a particular section of spins reach this we can see what to try and bet against using a progression. The idea is to use a software program to speed up the comparisons so that one does not spend hours and days waiting for 8 matches in a row before betting against the matches continuing.

If you look at the excel spread sheet you will see  for example the second column "Record D1 result" at B9 is in red indicating a match with the prediction of the previous spin result at C8 in the column marked "Tgt Doz"

F8 to F11 shows a column of green blocks of 4 matches in a row.

hope this helps

cheers