Unit Sums + Calculation

[stakar]

I wanna know if there is someone that can help me
Im using the Unit Sums to find out all the combinations that giving the more hits in excel.
I dont know how to make an excel programm that is using all the possible combinations of unit sums (the max line combination is 6).
I want to find out in each combination whats its hits in 6,5,4,3,2 and 1.
For example the combination of unit sums 1-2-4-5-8-9 has give 20 hits of 6
40 hits of 5
100 hits of 4
250 hits of 3
500 hits of 2
900 hits of 1
Is there someone that can help me???

 

[GillesD]

Performance of numbers

Using Excel, I have build a file where after entering up to 20 numbers, I immediately get the performance over all lottery draws. It gives the number of times for 0 WN (winning number), 1 WN and up to 6WN. It uses either the 6 numbers with or without the bonus number.

Basically, it uses the COUNTIF function (repeated many times though).

 

[stakar]

replay

Giles D
i have made something like u said, using the countif(), but for now i want something else
I want a loop that can read all of the unit sums combinations and informing me the number of hits per one.
eg
1st combo of unit sum 1-2-3-4-5-6 20hits of 6, 40 hits of 5 ....
2nd combo of unit sum 1-2-3-4-5-7 10hits of 6, 30 hits of 5 ....
3nd combo of unit sum 1-2-3-4-5-7 10hits of 6, 30 hits of 5 ....
.
.
.
.
126th combo of unit sum xxxxxxxxx 10hits of 6, 30 hits of 5 ....
so i can see at a blink which one is the best for me
Is it possible ??

 

[GillesD]

All combinations

Yes everything is possible. The following macro in VBA will go through all possible 13,983,816 combinations.

SUB ALL_COMB
FOR A=1 TO 44
FOR B=A+1 TO 45
FOR C=B+1 TO 46
FOR D=C+1 TO 47
FOR E=D+1 TO 48
FOR F=E+1 TO 49
………
NEXT F
NEXT E
NEXT D
NEXT C
NEXT B
NEXT A
………
END SUB

After the first block of code, enter whatever coding is necessary to calculate what you want and putting it into memory variables. After the second block of code, output into the spreadsheet the data you have calculated. You may not want to output all possibilities as this should overfill a single sheet; remember that 13,983,816 represents a little more than 83% of the cells in a single sheet.

 

[stakar]

VBA

Gilles D

first of all thanks for the quick replays
But the problem is that i dont know anything about VBA code and i dont understand how to do it.
Its hard for u to tell me step by step all the procedure so i can do it?
Thanks in advance Gilles D

 

[stakar]

***Picking numbers using unit sums***

***Picking numbers using unit sums***
As all u know there are 9 unit sums
numbering 1 to 9.
After statistics the most popular combination is to use 5 unit sums , so with about 25 numbers u can hit the jackpot!
Im asking if someone can make an excel sheet that can calculate
1. All the combinations of unit sums according the max combination number the user asks! e.g The user want to see all the combinations using the 6 from 9 unit sums.
2. Each of the above combinations must calculate the hits (according the range of hits that user asks) in list type so the user can see all the hits with a look
3. Each of the above combinations to calculate the delays of the hits (according the range of hits that user asks) in list type eg. The user asks to see in all the above combinations the delay of hitting the 6!
If someone can do this im sure we have a lot of possibilities to hit the jackpot using 25 numbers and in sometimes even less !!!!

 

[Nick Koutras]

Re: ***Picking numbers using unit sums***

***Picking numbers using unit sums***
As all u know there are 9 unit sums
numbering 1 to 9.
After statistics the most popular combination is to use 5 unit sums , so with about 25 numbers u can hit the jackpot!
Im asking if someone can make an excel sheet that can calculate
1. All the combinations of unit sums according the max combination number the user asks! e.g The user want to see all the combinations using the 6 from 9 unit sums.
2. Each of the above combinations must calculate the hits (according the range of hits that user asks) in list type so the user can see all the hits with a look
3. Each of the above combinations to calculate the delays of the hits (according the range of hits that user asks) in list type eg. The user asks to see in all the above combinations the delay of hitting the 6!
If someone can do this im sure we have a lot of possibilities to hit the jackpot using 25 numbers and in sometimes even less !!!!

Partine,
Can you give us an example of what a Unit Sum is?

Let say that the result of a draw was:

01,12,30,37,42,46

What is the Unit Sum of this Draw?

 

[Beaker]

Re: Re: ***Picking numbers using unit sums***

Partine,
Can you give us an example of what a Unit Sum is?

Let say that the result of a draw was:

01,12,30,37,42,46

What is the Unit Sum of this Draw?

Good question

Maybe 1+1+2+3+3+7+4+2+4+6 = 30 = 3+0 = 3

 

[Dennis Bassboss]

Re: Re: Re: ***Picking numbers using unit sums***

Good question

Maybe 1+1+2+3+3+7+4+2+4+6 = 30 = 3+0 = 3

Interesting concept...Reminds me of the split decades by 05....
Could be good when joined to it...

 

[stakar]

Re: Re: ***Picking numbers using unit sums***

Partine,
Can you give us an example of what a Unit Sum is?

Let say that the result of a draw was:

01,12,30,37,42,46

What is the Unit Sum of this Draw?

Unit sum is the sum of the number.
So in the above draw the unit sum is
01=0+1=2
12=1+2=3
30=3+0=3
37=3+7=10=1+0=1
42=4+2=6
46=4+6=10=1+0=1

So the combination is
2 nums in 1
2 nums in 3
1 nums in 2
1 nums in 6

So if we have played only the numbers using the 1-2-3-6 combination (only 23 numbers of the 49) of the unit sums we would have a 6 hit!

1 2 3 4 5 6 7 8 9
10 11 12 13 14 15 16 17 18
19 20 21 22 23 24 25 26 27
28 29 30 31 32 33 34 35 36
37 38 39 40 41 42 43 44 45
46 47 48 49

The above table gives all the 9 combinations (vertically reading) and the numbers that makes each one of them

Nick Koutras im using your excel sheet LottostatisticsXL and u have the source to make it easy! Its like the 'since last appeared'
If u want more details about the unit sums let me know. I am positive that a programm that can calculate them will leads us to the jackpot !!!!

 

[Beaker]

OK, now I know what you are doing.

I looked at this a looooooong time ago but never finished.

This 'Unit Sum' as you call it is the basis for numerology where you break all numbers down to single digits.

Actually, as Dennis said, this is a variation on last digit analysis - you are just recoding all the numbers to 1-9. Of course you will see 1-2-3-4 a few more times because of 46-47-48-49

I'll write some code for this and see if it useful - it may be interesting.

 

[Nick Koutras]

Re: Re: Re: ***Picking numbers using unit sums***

Unit sum is the sum of the number.
So in the above draw the unit sum is
01=0+1=2
12=1+2=3
30=3+0=3
37=3+7=10=1+0=1
42=4+2=6
46=4+6=10=1+0=1

So the combination is
2 nums in 1
2 nums in 3
1 nums in 2
1 nums in 6

So if we have played only the numbers using the 1-2-3-6 combination (only 23 numbers of the 49) of the unit sums we would have a 6 hit!

1 2 3 4 5 6 7 8 9
10 11 12 13 14 15 16 17 18
19 20 21 22 23 24 25 26 27
28 29 30 31 32 33 34 35 36
37 38 39 40 41 42 43 44 45
46 47 48 49

The above table gives all the 9 combinations (vertically reading) and the numbers that makes each one of them

Nick Koutras im using your excel sheet LottostatisticsXL and u have the source to make it easy! Its like the 'since last appeared'
If u want more details about the unit sums let me know. I am positive that a programm that can calculate them will leads us to the jackpot !!!!

Hello Patrine, -since I do not know your name- but you are from Patra.

You are talking about what others call Roots Sum.

This is an other way of generating subsets (Groups) of numbers to use.

Such subsets do not have any effect in
predicting and specially when they are un-even in size
and they make statistical calculations cumbersome.

Generating the results you want is easy,
but I do not see the significance of such subdivision.

If you still need these results just post a request
and I'll provide them for you.


Use your time to Include/Exclude numbers for the next draw with reason!


Nikos

 

[stakar]

Picking numbers using unit sums

Hello Patrine, -since I do not know your name- but you are from Patra.

You are talking about what others call Roots Sum.

This is an other way of generating subsets (Groups) of numbers to use.

Such subsets do not have any effect in
predicting and specially when they are un-even in size
and they make statistical calculations cumbersome.

Generating the results you want is easy,
but I do not see the significance of such subdivision.

If you still need these results just post a request
and I'll provide them for you.

Use your time to Include/Exclude numbers for the next draw with reason!


Nikos

Nikos, my name is Stathis and wishing u a happy and lucky new year
Im sure that using the unit sums u can exclude numbers but as i wrote in other posts i dont have the "special" statististical results.
You wrote "I do not see the significance of such subdivision"
Think that if u can use only 5 unit sums, means that you exclude at least 20 numbers for the next draw. I believe its a major step !

Anyway, tell me the way how to post a request and i ll do it.
Awaiting your answer

Stathis