pick3 three possible standards of pick3 The defaults are = Bigger, smaller Equal

[jack]

Hello I need help in Excel 2010 or higher
To see the three possible standards of pick3
The defaults are =
Bigger, smaller
Equal
Represented by 0,1,2
Greater = 2
Minor = 1
Equal = 0
There are 27 possible formations at 100%
0 0 0
0 0 1
0 0 2
0 1 0
0 1 1
1 0 2
0 2 0
1 0 2
0 2 2
1 0 0
1 0 1
1 0 2
1 1 0
1 1 1
1 2 1
1 0 2
1 2 1
1 2 2
2 0 0
1 0 2
2 0 2
1 0 2
1 2 1
2 1 2
2 2 0
2 2 1
2 2 2

 

[jack]

Hello, always the last draw as the basis for the next
I need to see the frequency of a certain number of sweepstakes
Training = 000 is very difficult to probability
126 = base
159 = 022 = next
357
963
015
751
756
954
357
850
426
852
759
364
027
957
967
159
...

 

[jack]

the draw will always be updating sweepstakes, the macro has to automatic nalysis of the frequencies of the 27 formations

 

[jack]

hello need to know friends who can excel
which of the 27 formations are the most frequent
a list of sweepstakes pick3 given
then see the latest formation of the most frequent

 

[Frank]

Jack are you SURE about your 27 possible formations ? There are a lot of duplicates in there, especially of 102.

Should it not be :-

000
001
002
010
011
012
020
021
022
100
101
102
110
111
112
120
121
122
200
201
202
210
211
212
220
221
222


Just one single post is all that is required in your reply, if you don't mind Jack.

 

[jack]

Hello, Frank, see you have to look position by position in the vertical
Why 102, 120, 021 ... etc.
Position has see position based on the position where the last
For the next
1st 2nd 3rd
4 7 8 = base last draw
1 8 8 = 120 becomes last when you next
1 9 4 = 2 1 0 =
You have to look vertically to convert, and 0,1,2 can also be color
Greater Green =
Minor = blue
Equal = yellow
Of = 27 formations make the analysis should go for about 40% of them
Frank you can create a macro, I will put a 2000 (two thousand sweepstakes) goal to see the formations of the 27 more fall probabiliscamente
Example = the forecast is 221 454 last
It means 1st pos = 5,6,8,9 2rd= 0,1,2,3 3rd= 6,7,8,9

 

[jack]

Frank noted that will be a way to reduce by 100% in just 27 formations
Being doing the analysis can be downloaded for a 15.16 formations higher frequency
Example forming means 000 repeats three positions that is repeated three digits sos
Probablisticamente is 99% since the 111 or 222 we have to analyze

 

[Frank]

Forget it Jack, in your TWO posts you have completely lost me, therefore I give up. I've lost interest.

 

[jack]

frank ex=
03/27/16 6 5 2 H O H
03/26/16 2 5 0 L H L
03/25/16 5 0 5 L L H
03/24/16 7 1 2 H L L
03/23/16 2 5 5 O H H
03/22/16 2 4 4 L H O
03/21/16 6 1 4 H L L
03/20/16 4 8 8 H H H
L
O
H=