I started on it last night and I am already going .
Also thought about the macro idea which I will also try.....This is an area that I am still learning so everything I am doing on excel now is great...gives me a chance to challenge myself and learn something at the same time.
The way I am constructing the formula is by a weight system.
ie the first number will have a higher lex value compared to the 6th number. Then it will look at the 2nd number etc. with the last number representing whats left of the lex value.
The following macro does the job. It just goes through all combinations until it reaches the lex value that is entered in cell A1. It then places the numbers N1 to N6 in cells B1 to G1.
A formula might be faster and more elegant but brute force does the job here while we come up with something.
Listing for the macro LexToNumbers:
Dim A As Integer, B As Integer, C As Integer, D As Integer, E As Integer, F As Integer
Dim nVal As Double, nLex As Double
nVal = Range("A1").Value
nLex = 0
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
nLex = nLex + 1
If nLex = nVal Then
Range("B1").Value = A
Range("C1").Value = B
Range("D1").Value = C
Range("E1").Value = D
Range("F1").Value = E
Range("G1").Value = F
I actually gave up on it. Kept hitting that brick wall.
But did find GillesD little programme works great.
After studying the Lex number I have decided not to use it but still keep it there. It has been put in my lotto junk sheet pile (ie hidden column) with a few others which sound good but dont give any decent stats to go by.
Yes GillesD program is sweet.
I think the Lex Number is useful to know, but as you say, I cannot see any real benefit of it.
It would have been nice to have been able to come up with an Excel Formula to get the Numbers from the Lex though.
What other information have you put in your Lotto Junk Sheet.
Thanks for the Info.
It seems that we all do the same sort of thing. We find something that seems to have a good strategy behind it and is producing better than average results, and then, sods law, it goes off the boil.
It is always worth while keeping the Info though because you never know when it is going to come back in line.