Strategy needs a formula

JayZ

New Member
Joined
Apr 1, 2011
Messages
8
I have a strategy that I developed playing the table game roulette. I want to test it on large amounts of spins that I've previously recorded to see how it would have faired in the long term. I am hoping someone can understand my post and provide a formula that will help me.

Here goes:

There are 6 dozens of numbers. Let's call them Dozen 1, 2, 3, and A, B, C.

Dozen 1 are the numbers 1 through 12
Dozen 2 are the numbers 13 through 24
Dozen 3 are the numbers 25 through 36
Dozen A are the numbers 1,4,7,10,13,16,19,22,25,28,31 and 34
Dozen B are the numbers 2,5,8,11,14,17,20,23,26,29,32 and 35
Dozen C are the numbers 3,6,9,12,15,18,21,24,27,30,33 and 36

I need a formula that will record the numbers in 2 separate series of 6 in the following fashion:

Example: let's say the number 13 hits. So, every number has a numerical Dozen and an alphabetical number. For 13 it would be

2A (because it appears within Dozen 2 and Dozen A). But, I don't write it this way. The way it would be written is the 2 would be the start of the first series of 6 numbers and the B would be the start of the second series of 6 numbers.

So, it would be:
2
A

Let's say the next number is 26. So, that's a 3B, and it would go into the series as so:

2B
and
A3

The alpha-numeric numbers alternate in the series of 6.

So, if the next 4 numbers were 2,9,21 and 17: The 2 sets of 6 would look like this:

2B1C2B
and
A3B1C2

The next set of 6 would be placed in a grid directly under the first set of 6. So a comparison could be made between the number directly above. it would look like this:

First set of 6 with the second set of 6 (2nd set I just made up)
2B1C2B
1B2A2C

and
A3B1C2
C1B2C2

The numbers that are being used are in a single column. So, there would have to be a way to take those and place them in these 2 6 column grids and run continuously until all numbers in the column containing numbers were used.

I hope that I have explained this good enough for someone to understand.

I am very appreciative for any assistance you can provide.

Thanks very kindly.

JayZ
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Have a look at this, and see if it helps:
Excel Workbook
ABCDEFGHIJKLMN
113First group of 6Second group of 6
2262B1C2BA3B1C2
323B1B3BC3A2B1
49
521
617
730
832
97
1014
1129
128
Sheet
 
Upvote 0

Forum statistics

Threads
1,224,507
Messages
6,179,181
Members
452,893
Latest member
denay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top