Eliminate up to 18 numbers from 6/49

[PAB]

Hi madam,

Peter Rosendahl's site has some good wheels here...

http://hem.bredband.net/b599956/wheels/wmain.htm

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[jol]

Thanks for this analysis it is top notch.
It fits in nicely with the direction of my own thoughts.
I need help with excel to go further but will request that in the correct place.
In the meantime.
3 6 7 8 9 10 11 12 13 15 16 20 22 24 25 26 27 28 29 31 34 35 36 39 40 41 43 45 47 49.
From my lottery last 7 games.

1 4 6 7 8 10 11 12 14 15 18 19 20 22 24 27 28 30 31 32 34 36 37 38 40 41 43 44 45 46 47 49.
Numbers from some 1300 games previous which I like to get my numbers from.

In both groups 6 7 8 10 11 12 15 20 22 24 27 28 31 34 36 40 41 43 45 47 49.
If it could be tuned so they return a similar number of hits then you could reduce your pool again.
Just thinking.
Jol

 

[PAB]

Hi Jol,

Welcome to the Forum .
If your question is Excel or VBA Macro based then post it in the Excel & Macros section of this Forum.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Icewynd]

Thanks for this analysis it is top notch.
It fits in nicely with the direction of my own thoughts.

Thanks, Jol. And welcome to the lotto forums.

In both groups 6 7 8 10 11 12 15 20 22 24 27 28 31 34 36 40 41 43 45 47 49.
If it could be tuned so they return a similar number of hits then you could reduce your pool again.
Just thinking.
Jol

It seems that you and I think alike, selecting most of our numbers from the more recent games.

I'm not quite sure what you are proposing, however. How would you go about reducing your pool further?

 

[jol]

Pab
Thank you and I will post a request in the Excel section.
Icewynd
Again thank you.
Reduction in pool is done by comparing what has happened and what is current this will take some time to explain and I will start a new thread when I get chance.
Quick answer is both portions that the numbers come from sometimes select the same numbers. If you took that as a basis for start point how many other groups could you find in the history that were similar. Sorry for poor explanation like I said above I need help with taking this further.

 

[Icewynd]

Jol,

I will follow with interest as you develop this idea further.

 

[jol]

Icewynd.
This may explain what I am trying to understand.
Numbers I posted were from my lottery = UK this was drawn tonight.
1st set were from the last 7 games 30 numbers, which you would hope to contain 3 to 5 numbers. Actual hits were 3 plus the bonus. numbers were 6 24 43 and B 11.
2nd set were from >1300 games previous 32 numbers and hit 4 numbers plus the bonus 6 24 38 43 and B11.
3rd set were numbers that were in both previous sets this contained 21 numbers and hit 6 24 43 and B11.
Now I want to still keep 3 or 4 numbers but reduce the pool that means being smarter and or adding another 7 rows of numbers.
Or I could do nothing in the hope that one day both sets contained all six and my small wheel placed them in the correct place Lol.
Hope this helps
Jol

 

[PAB]

hI Jol,

Now I want to still keep 3 or 4 numbers but reduce the pool that means being smarter and or adding another 7 rows of numbers.
Or I could do nothing in the hope that one day both sets contained all six and my small wheel placed them in the correct place.

You will also need to explain this in a bit more detail in the new thread that you have started!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[bloubul]

Hi Icewynd

I came across this topic.. and it's very interesting.
How do one setup a spreadsheet ??

BlouBul

 

[Icewynd]

Hi Bloubul,

I have set up my spreadsheet as follows:
Top Row:
A "Draw Number"
B "Cycle Number"
C "Date"
D-J "N1"-"N6", "B" (drawn numbers 1-6 plus the bonus number)
L "Numbers Remaining"
N-BJ numbers "1"-"49"

Formula for Numbers Remaining =COUNTIF(N3115:BJ3115,0)
Formula for column N =COUNTIF($D3:$J$3,N$2) -- copy across to column Bj (49)

I never automated this, so I just copy columns N-BJ down until numbers remaining=0. At this point the formula in N-BJ will have adjusted for the require number of rows -- for example, in my spreadsheet the first cycle took 41 draws to complete, so the original formula
=COUNTIF($D3:$J$3,N$2)
has become
=COUNTIF($D$3:$J43,1)

This needs to be reset to start the next cycle. In this case the first row of the second cycle is Row 44, so the formula must be reset to
=COUNTIF($D$44:$J44,1)

Then copy across and then copy cells N44-BJ44 down again until there are zero numbers remaining. And repeat.

Good luck!

 

[bloubul]

Hi Sangoma123

How many draws are you using, or do you use all the available draws from draw 1 on wards.

BlouBul

 

[Icewynd]

Yes, I started with draw 1, but I don't think that it is required for this method to have all the draws. Theoretically the outcome should be the same, as long as you have a sufficient sample of draws to give good averages of how many new numbers come out per draw.

Good luck!

 

[bloubul]

Hi Icewynd

I'm a bit confused... with column L and N:BJ.
How must I read column L.. It starts of with "0" till row A42, and than 49 in A43. How must I read columns N:BJ. It starts with "8" till it reached "0" in row A43..

BlouBul