Order = maximum 3 letters per decade

[jack]

Order = maximum 3 letters per decade
Order = maximum 3 letters per decade
My lottery 80/5
We have
A = 01 02 03 04 05 06 07 08 09 10
B = 11 12 13 14 ..... 20
C = 21 22 23 .... 30
D = 31 32 33 .... 40
E = 41 42 43 ..... 50
F = 51 52 53 .... 60
G = 61 62 63 ..... 70
H = 71 72 73 ..... 80
Example
Aaabb
Aaacc
Bbcccc
....
Maximum 3 letters and minimum one letter
Go to aahhh

 

[Frank]

Order = maximum 3 letters per decade
Order = maximum 3 letters per decade
My lottery 80/5
We have
A = 01 02 03 04 05 06 07 08 09 10
B = 11 12 13 14 ..... 20
C = 21 22 23 .... 30
D = 31 32 33 .... 40
E = 41 42 43 ..... 50
F = 51 52 53 .... 60
G = 61 62 63 ..... 70
H = 71 72 73 ..... 80
Example
Aaabb
Aaacc
Bbcccc
....
Maximum 3 letters and minimum one letter
Go to aahhh

Jack, if I understand this correctly, there are 728 valid combinations of five decades from eight ending in gghhh. Too many to post here. Have a look at this list and see if it fits the bill.

http://www.mediafire.com/file/gg5e6cjxb4jb643/AtoHcombins.xlsx

 

[jack]

ok, frank, perfect, very good job, conglatulations, when I win a big prize will be rewarded !!
frank, please on the link we have all the raffles of the 80/5
so far, I need to see how many times each lineup was drawn, from the most drawable
the most recent, but only the most drawn

 

[jack]

http://www.mediafire.com/file/my1tp161u6456uu/estudo_da_quina_letters.xlsx

 

[Frank]

ok, frank, perfect, very good job, conglatulations, when I win a big prize will be rewarded !!
frank, please on the link we have all the raffles of the 80/5
so far, I need to see how many times each lineup was drawn, from the most drawable
the most recent, but only the most drawn

Ok Jack, you have your answer.

http://www.mediafire.com/file/zayz6wl0ym8bbo6/estudo_da_quina_letters.xlsx

The filter in column T is useful for finding the best counts of matches.

If the filter is set to number filters>greater than> 0 you get 668 results have one or more of your sequences
if set to 0 you find 3779 results are NOT part of your sequences.

if set to number filters>top 10 but edit the number to top 50 items you get 56 results in the top 50.

Copy the results list (cols S and T) and paste to to sheet 1, you can sort by value (in col B) Largest to smallest to get your answer for the best sequences.

abcff 26
bbdef 26
bbefg 25
aeeff 23
bfghh 23
abdff 22
aabbg 21
aaegg 21
abccd 21
bcceg 21
acddg 21
ccefh 21
ceghh 21
ddeef 20
abbch 20

etc.
Good luck!

 

[jack]

ok frank, great job, the best in excel,
so I can control the pattern of letters and number quantities. thank you frank

 

[jack]

fra[/COLOR]nk, every week, I have to put new sweepstakes (updating raffles) manually, typing the sweepstakes
the macro will automatically do the calculations? thank you

 

[jack]

frank, you can add the 10 positions = explain, each decade has 10 positions
1st 2nd 3rd ..... 10th
01 02 03 ..... 10
11 12 ... 20
21 22 .. 30
.....
71 72 .... 80
objective is to see the positions by each column
now I have the default of letters lack of positions.
example = aaabb
aaa = in positions 3rd 5th 9th bb = in positions 1st 4th
we can see the positions in arrears in a certain number of raffles, crossing with the pattern of the letters will be great

 

[Frank]

frank, you can add the 10 positions = explain, each decade has 10 positions
1st 2nd 3rd ..... 10th
01 02 03 ..... 10
11 12 ... 20
21 22 .. 30
.....
71 72 .... 80
objective is to see the positions by each column
now I have the default of letters lack of positions.
example = aaabb
aaa = in positions 3rd 5th 9th bb = in positions 1st 4th
we can see the positions in arrears in a certain number of raffles, crossing with the pattern of the letters will be great

Jack,
Its just as well you asked me to revisit this as the original spreadsheet had a counting error because I omitted a $ sign in the counting formulas (column X), so the counts were progressively wrong the further down the column you looked.
I have re-designed the sheet to make it look more logical and coloured the areas that never change (the 728 lines of the reference table) to keep them seperate from actual results. The error has been corrected so my comments also needed to change:-

use the filter in column X to choose criteria to count.

If set to number filters>greater than> 0 you get
677 results in your reference table match with actual results.

if set to 0 you find 51 reference sequences are NOT part of your results. Note that 677 +51 =728 the total number of sequences.

if set to number filters>top 10 but edit the number to top 50 items you get 56 results in the top 50.
copy the results list (cols W and X) and paste to to sheet 1, column A you can sort by value (in col B) Largest to smallest to get your answer for the best sequences.

bdfgh 29 (results matching the reference sequence)
abcfg 27
abdfg 27
acegh 25
abceh 23
abefg 23
abefh 23
abfgh 23
bcegh 23
cefgh 23
abceg 22
adfgh 22
abcdf 21
abcdg 21
abcgh 21
abdeg 21
acdfh 21
cdegh 21

You didnt specify how the position of the number in each decade should be displayed, but Ive added this feature anyway which widens the spreadsheet and changes spreadsheet column letters, hence the instructions changed too.

the download link should be the same:-
http://www.mediafire.com/file/zayz6wl0ym8bbo6/estudo_da_quina_letters.xlsx
the old file has been overwritten.

Regarding updating for the future, as always this depends where the latest draw is, at the top of the list or the bottom. If at the bottom, its easy. You copy down all formulas and just add the next draw. If at the top, then a macro would be needed to move everything down to make room for a new draw.

I note that the five people who downloaded version 1 will need to download the corrected version.

 

[jack]

Ok, ah !! forgot to show in an example, sorry the 10 positions =
1º 2ª 3ª 4ª 5ª 6ª 7ª 8ª 9ª 10ª
01ª 02ª 03ª 04ª 05ª 06ª 07ª 0ª 09ª 10ª
11 .................................. 20
21 ... 31
.....
71 .... 80
sometimes in a draw we have two numbers in the same column position

 

[jack]

10ª= error 5 colluns

 

[jack]

Frank, you have put the 10 positions
in that matrix of 8 lines (a to h)
because it filters in the patterns
example
abccf in the positions 1ª 2ª 5ª 7ª 8ª
particulation crossing the two patterns
of the letters with the 10 positions
we can see frequencies of positions and delay

 

[Frank]

Jack, youve completely lost me. I have no idea what is going on in your head. You are going to have to demonstrate on a spreadsheet what on earth you are talking about. I cannot afford to waste any more time on this, I have other things to do.

 

[jack]

[frank, reflect, think, a little.we have the matrix
of the 10x8 lottery we have 8 lines
we have 10 positions or 10 columns each draw has in the worst of hypotheses 5 positions a position each column in the draw.
example was drawn 01 03,25,52,78
are from positions 1ª 3ª 4ª 6ª 7ª
with the lettering pattern aaceh
frank you are confusing the 5 positions of the draw with the 10 positions of the 10 columns of the matrix
what is your doubt?
you can not confuse the 5 positions of the draw with the ten positions
so we are going to filter in the letter-type crosses of letter patterns with the positions

 

[jack]

a 1 2 3 4 5 6 7 8 9 10
b 11 12 13 14 15 16 17 18 19 20
d 31 32 33 34 35 36 37 38 39 40
e 41 42 43 44 45 46 47 48 49 50
f 51 52 53 54 55 56 57 58 59 60
g 61 62 63 64 65 66 67 68 69 70
h 71 72 73 74 75 76 77 78 79 80
1ª 2ª 3ª 4ª 5ª 6ª 7ª 8ª 9ª 10ª positions
exemplo draws= 02,09, 43 , 64, 80 position=2ª 9ª 3ª 4ª 10ª

 

[jack]

lottery 80/5
https://www.google.com.br/url?sa=i&rct=j&q=&esrc=s&source=images&cd=&cad=rja&uact=8&ved=0ahUKEwjK25L_yZPWAhVS-lQKHZSXCwUQjRwIBw&url=http%3A%2F%2Flotomaniaco.com.br%2Fquina.php&psig=AFQjCNHf_v_dQwu2EJGlDgibxOIY4XWnDg&ust=1504891000121029

 

[Frank]

lottery 80/5
https://www.google.com.br/url?sa=i&rct=j&q=&esrc=s&source=images&cd=&cad=rja&uact=8&ved=0ahUKEwjK25L_yZPWAhVS-lQKHZSXCwUQjRwIBw&url=http%3A%2F%2Flotomaniaco.com.br%2Fquina.php&psig=AFQjCNHf_v_dQwu2EJGlDgibxOIY4XWnDg&ust=1504891000121029

Invalid URL

exemplo draws= 02,09, 43 , 64, 80 position=2ª 9ª 3ª 4ª 10ª

Number 80 is an a ??? EXPLAIN. it is in zone h ???
Why are these all a ???????????????

 

[jack]

http://www.mediafire.com/file/p1yq1d7tsoin4h7/10_posi%C3%83%C2%A7oes_80_-5.xlsx

 

[jack]

Frank, it's just an example, look!
Let's suppose that I decide to play this pattern of letters = aadef
And in the positions = 2nd 9th 7th 8th 1st
Then we will have = 02 09 37 48 51
In ascending order but positions are not in ascending order
It is the pattern of the letters that dictates =
Note that there is a cross between the pattern of the letters and those of the position pattern
Practically as Cartesian
Already filtering

 

[Frank]

Having seen your spreadsheet I can see that its not me who is confused. It is you who having defined deccades with the letters a to h decided to go off at a tangent and for some reason you have not yet explained, decide to label positions within a decade, regardless of the decade all with the letter a. What a ridiculous confusing thing to do.
Well I have answered the original question you set, and I am now finished with this topic. I have other things to do.
Good luck, I'm gone.