Master Lottery Software
- Thread starter Moses
- Start date
Hello, moses, you could do a study of a less number of lottery
Example in a game 49 / 6 = result = 05,14,23,34,42,45
The smallest number and the number 05, well can also the largest 45
So moses create pairs with the smallest number in uniting with the largest example
= 05.45 the pair would be the 05 smaller and 45 larger, the other four numbers are within the range
05 to 45, good if you can see distances and other filters in the case of the 4 remaining numbers,
Moses You can see a study of the tips?
Example in a game 49 / 6 = result = 05,14,23,34,42,45
The smallest number and the number 05, well can also the largest 45
So moses create pairs with the smallest number in uniting with the largest example
= 05.45 the pair would be the 05 smaller and 45 larger, the other four numbers are within the range
05 to 45, good if you can see distances and other filters in the case of the 4 remaining numbers,
Moses You can see a study of the tips?
Excel Formula
I do have a database created unique to lotteries with 50 numbers (Euro game) but is only half finished but I will finish it for you if someone provides me a Excel formula as the way I do it is very time consuming which I do not have!
What I am looking for is the formula to increase the seven numbers from cell A by 1 in cell B
Example; if I have the following lottery result in cell A
43 19 22 36 25 11 49 -- increase by 1 in next cell = 44 20 23 37 12 50
For this database the last number is 50 so this number cannot be increased to 51 and should be set at 01 again!
If somebody be kind to provide the formula then I can provide you all the possible databases for all lotteries then we can sit and talk about it!
There is also some other new information available that I think you should have since nobody stepped forward to develop the digital ending program!
Moses
HiFunkyCatSpangky said:Hi Moses,
I have converted your 1/49 number database to 1/50 for use with the euro million
I have searched the latest euro million results with my 1/50 number database and some are quite accurate ...
Yes, I can find the numbers drawn in the 1/50 database but I just have not found a way to predict the winning numbers ...
May I please kindly ask if you have any information that can allow me to predict the next euro million via my 1/50 number database ???
Thanks ...
I do have a database created unique to lotteries with 50 numbers (Euro game) but is only half finished but I will finish it for you if someone provides me a Excel formula as the way I do it is very time consuming which I do not have!
What I am looking for is the formula to increase the seven numbers from cell A by 1 in cell B
Example; if I have the following lottery result in cell A
43 19 22 36 25 11 49 -- increase by 1 in next cell = 44 20 23 37 12 50
For this database the last number is 50 so this number cannot be increased to 51 and should be set at 01 again!
If somebody be kind to provide the formula then I can provide you all the possible databases for all lotteries then we can sit and talk about it!
There is also some other new information available that I think you should have since nobody stepped forward to develop the digital ending program!
Moses
bloubul
Member
Hi Moses
Here is your excel formula for last ending digits no need for a program, from an "ungrateful person with short memory", but it does not include the bonus number.
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="0"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="1"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="2"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="3"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="4"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="5"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="6"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="7"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="8"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="9"))
Just change my cell reference to yours if it is not the same, and copy it all the way down. Your other stuff is also easy, your stuff is from A1---G1,so in column I1 you type, =A1+1,J1=B1+1,etc..etc, untill you have coverd all 7 numbers, so easy, copy it all the way as well.
BlouBul
Here is your excel formula for last ending digits no need for a program, from an "ungrateful person with short memory", but it does not include the bonus number.
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="0"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="1"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="2"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="3"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="4"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="5"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="6"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="7"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="8"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="9"))
Just change my cell reference to yours if it is not the same, and copy it all the way down. Your other stuff is also easy, your stuff is from A1---G1,so in column I1 you type, =A1+1,J1=B1+1,etc..etc, untill you have coverd all 7 numbers, so easy, copy it all the way as well.
BlouBul
Excel Formula
First thanks for your formula but it doesn’t seem to be working as the value in new cell is 0,1,2 etc or maybe I am doing something wrong!
From what I understand, your formula contains 6 cells (C to H) one cell per number but I want the 7 numbers per one cell to increased by 1 so if you just give one formula for the following example then I would know how to readjust it for other cells!
I have 43 19 22 36 25 11 49 in cell (A1) and I want the value for each number to be increased by 1 in Cell (B1) to 44 20 23 37 12 50 The only problem that I can see is the spacing between the numbers and also when it comes to number 50 if increased goes back to 01!
If you can give me the formula for the cell B1 then I would appreciate it!
Thanks again
Moses
Hello bloubulbloubul said:Hi Moses
Here is your excel formula for last ending digits no need for a program, from an "ungrateful person with short memory", but it does not include the bonus number.
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="0"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="1"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="2"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="3"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="4"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="5"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="6"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="7"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="8"))
=SUMPRODUCT(--(RIGHT($C4:$H4,1)="9"))
Just change my cell reference to yours if it is not the same, and copy it all the way down. Your other stuff is also easy, your stuff is from A1---G1,so in column I1 you type, =A1+1,J1=B1+1,etc..etc, untill you have coverd all 7 numbers, so easy, copy it all the way as well.
BlouBul
First thanks for your formula but it doesn’t seem to be working as the value in new cell is 0,1,2 etc or maybe I am doing something wrong!
From what I understand, your formula contains 6 cells (C to H) one cell per number but I want the 7 numbers per one cell to increased by 1 so if you just give one formula for the following example then I would know how to readjust it for other cells!
I have 43 19 22 36 25 11 49 in cell (A1) and I want the value for each number to be increased by 1 in Cell (B1) to 44 20 23 37 12 50 The only problem that I can see is the spacing between the numbers and also when it comes to number 50 if increased goes back to 01!
If you can give me the formula for the cell B1 then I would appreciate it!
Thanks again
Moses
Hello, moses, I need it to see the formula = How many iterations? And where are the seven initial values come from?
Moses, you can give more details of how you want the formula? where the values are imported?
You want a list next to the register? The file is in. Txt file when importing?
Copy paste option have also created a game? The euromilhao has the draw of 5 numbers
Can you give more details, to move on in order to make the macro!
Or maybe it's a file generated in numbers 7. Txt? the wait, thanks
Moses, you can give more details of how you want the formula? where the values are imported?
You want a list next to the register? The file is in. Txt file when importing?
Copy paste option have also created a game? The euromilhao has the draw of 5 numbers
Can you give more details, to move on in order to make the macro!
Or maybe it's a file generated in numbers 7. Txt? the wait, thanks
Excel Formula
There are 50 columns in a sheet, each column has over 8000 entries (results) each entry consist of 7 numbers! You have all that in column A, now what I want to do is to increase all the results in each cell for this column to be increased by 1 in column B, increased by 2 in column C, increased by 3 in column D and so on until all 50 columns are increased by one therefore when you get to the end of 50 columns and if you increase this column by 1 then you would be resetting the whole results to column A or back to beginning again!
I didn’t think this would be that difficult to understand
Moses
jack said:
There are 50 columns in a sheet, each column has over 8000 entries (results) each entry consist of 7 numbers! You have all that in column A, now what I want to do is to increase all the results in each cell for this column to be increased by 1 in column B, increased by 2 in column C, increased by 3 in column D and so on until all 50 columns are increased by one therefore when you get to the end of 50 columns and if you increase this column by 1 then you would be resetting the whole results to column A or back to beginning again!
I didn’t think this would be that difficult to understand
Moses
So my understanding of what you are saying is this. Take the result from the first part and increment each value by 1 across 50 columns with a max of 50 at which point it will reset at 1. So if that is correct, does this do what you want?
Code:
Sub test()
Dim c As Range, t(1 To 3), x As Long, MinX As Long, MaxX As Long
Dim v1 As Long, v2 As Long, lr As Long
lr = Range("A" & Rows.Count).End(xlUp).Row
For Each c In Range("A1:A" & lr)
For x = 1 To 3
t(x) = Val(Mid(c, x, 1))
Next x
MinX = Application.WorksheetFunction.Min(t)
MaxX = Application.WorksheetFunction.Max(t)
v1 = Val(MinX & MaxX)
v2 = Val(MaxX & MinX)
c.Offset(, 1).NumberFormat = "00"
c.Offset(, 1) = IIf(v1 <= v2, v1, v2)
Next
With Range("C1:AZ" & lr)
.Formula = "=MOD(B1,50)+1"
.Value = .Value
End With
End Sub
Code:
Sub test()
Dim c As Range, t(1 To 3), x As Long, MinX As Long, MaxX As Long
Dim v1 As Long, v2 As Long, lr As Long
lr = Range("A" & Rows.Count).End(xlUp).Row
For Each c In Range("A1:A" & lr)
For x = 1 To 3
t(x) = Val(Mid(c, x, 1))
Next x
MinX = Application.WorksheetFunction.Min(t)
MaxX = Application.WorksheetFunction.Max(t)
v1 = Val(MinX & MaxX)
v2 = Val(MaxX & MinX)
c.Offset(, 1).NumberFormat = "00"
c.Offset(, 1) = IIf(v1 <= v2, v1, v2)
Next
With Range("C1:AZ" & lr)
.Formula = "=MOD(B1,50)+1"
.Value = .Value
End With
End Sub
Excel Formula
I wasted a day trying to work your formula but no joy so I need some advanced help or direction please!
I am looking for the formula for cell A and cell B and no more!
I would have thought that Frank is the best person to ask if he is around?
Moses
Hey Jackjack said:
I wasted a day trying to work your formula but no joy so I need some advanced help or direction please!
I am looking for the formula for cell A and cell B and no more!
I would have thought that Frank is the best person to ask if he is around?
Moses