WNH Differences Filtering

[PadawanLotto]

I normally don't make filter requests but I think I have a good one. While working with WNH Hit & Skip Differences I came across something that I found interesting. In most drawings any one difference is rarely repeated more than 1 time and rarely is there more than 1 repeating difference per draw. Out of the last 200 drawings of the Ohio 5/39 there were 154 drawings where there were 0 to 1 repeating differences. The common difference range for repeat differences is -20 to 20 for the Ohio 5/39.

If we had a differences filter where we could remove combinations that had 3 or more of the same difference and remove combinations that had more than 1 repeating difference, I think that we could all come closer to our goal.

The more I worked with the WNH Hit & Skip Differences the more I questioned the definition of differences as there seems to be two meanings in EL. Differences as distance of sum movement (-20 to 20) and Differences as where the actual drawn numbers come from in the next drawing.

[lottoboy]

Hi, Padawan:

This is a good idea! Could you explain your experience about the use of WNH Hit & Skip Differences in the Differences as where the actual drawn numbers come from in the next drawing in detail? Thanks.

Best,
lb

[PadawanLotto]

[quote=lottoboy]
Hi, Padawan:

This is a good idea! Could you explain your experience about the use of WNH Hit & Skip Differences in the Differences as where the actual drawn numbers come from in the next drawing in detail? Thanks.

Best,
lb
[/quote]I'm not real sure what you are asking but if you mean linking the differences to actual drawn numbers, I'm clueless.

[lottoboy]

[quote=PadawanLotto]
[quote=lottoboy]
Hi, Padawan:

This is a good idea! Could you explain your experience about the use of WNH Hit & Skip Differences in the Differences as where the actual drawn numbers come from in the next drawing in detail? Thanks.

Best,
lb
[/quote]I'm not real sure what you are asking but if you mean linking the differences to actual drawn numbers, I'm clueless.
[/quote]

Hi, Padawan:

My meaning is how about your strategy of using the filter of WNH Hit & Skip Differences?

In addition, could you make summary for your sorted statistics by pdf? Thanks.

Best,
lb

[PadawanLotto]

[quote=lottoboy]
Hi, Padawan:

My meaning is how about your strategy of using the filter of WNH Hit & Skip Differences?
[/quote]I set the lastest to 300 and calculate stats and then remove all differences that have an n/a in the latest column, I do this for all columns 0 to -10.

In addition, could you make summary for your sorted statistics by pdf? Thanks.

Sorted statistics?
What I want to do now is to be able to remove all combinations that have more than 2 of the same differences within the 11 columns and combinations that have 2 or more repeating differences within the 11 columns 0 to -10. Excel filtering takes forever.

[lottoboy]

[quote=PadawanLotto]
[quote=lottoboy]
Hi, Padawan:

My meaning is how about your strategy of using the filter of WNH Hit & Skip Differences?
[/quote]I set the lastest to 300 and calculate stats and then remove all differences that have an n/a in the latest column, I do this for all columns 0 to -10.

In addition, could you make summary for your sorted statistics by pdf? Thanks.

Sorted statistics?
What I want to do now is to be able to remove all combinations that have more than 2 of the same differences within the 11 columns and combinations that have 2 or more repeating differences within the 11 columns 0 to -10. Excel filtering takes forever.
[/quote]

Hi, Padawan:

I see. Thanks.

Best,
lb

[PadawanLotto]

Ohio 6/49 Difference report, 48 out of 61 past drawings had 0 to 1 differences repeat within columns 0 thru -10, latest draw as follows.
05/10/08 Sat 9 32 -5 14 18 -45 19 -38 -8 -2 -8
, 1 difference repeated.

Ohio 5/39 Difference report, 155 out of 200 past drawings had 0 to 1 differences repeat within columns 0 thru -10, latest draw as follows.
05/10/08 Sat -2 -6 -6 26 -14 14 -9 7 -15 8 6
, 1 difference repeated.

The point is that within the combinations that you have left after filtering, a lot of these combinations can contain up to 6 repeat differences making the combinations unlikely canidates for play. We need a new filter. I will make all updates here in this post so, please stay tuned to this channel.

[CARBOB]

[quote=PadawanLotto]
Ohio 6/49 Difference report, 47 out of 60 past drawings had 0 to 1 differences repeat within columns 0 thru -10, latest draw as follows.
05/07/08 Wed -15 12 18 5 -41 -29 0 5 -10 6 2, 1 difference repeated.

Ohio 5/39 Difference report, 154 out of 200 past drawings had 0 to 1 differences repeat within columns 0 thru -10, latest draw as follows.
05/09/08 Fri -10 7 23 5 3 25 -31 -23 17 0 2, 0 differences repeated.

The point is that within the combinations that you have left after filtering, a lot of these combinations can contain up to 6 repeat differences making the combinations unlikely canidates for play. We need a new filter. I will make all updates here in this post so, please stay tuned to this channel.
[/quote]

Padawan, the breakdown on Fla 5/36 for Distinct Diffs in the Package for 5/9/08 was. I don't believe a Package will vary much.

5/13
6/242
7/3190
8/23050
9/85286
10/156342
11/108869

as you can see, a lot of combinations can be eliminated with a click of a mouse unlike filtering in Excel. I think you will need 2 different Distinct Diff's filters.

[PadawanLotto]

[quote=CARBOB]
Padawan, the breakdown on Fla 5/36 for Distinct Diffs in the Package for 5/9/08 was. I don't believe a Package will vary much.

5/13
6/242
7/3190
8/23050
9/85286
10/156342
11/108869

as you can see, a lot of combinations can be eliminated with a click of a mouse unlike filtering in Excel. I think you will need 2 different Distinct Diff's filters.
[/quote]Where did you get that break down and what are we looking at?

[lottoboy]

Hi, Padawan:

I ran your Seg. Combination Filter just now. The test result is as below:

1) Runing time: 2 hours 47 minutes;

2) Leave 393037 tickets and remove 575757-393037=182720;

3) JP has been deleted by the Filter

Questions:

1) How can I find or check out where is the mistake?

2) How can I change the default setting of Seg. from 3/9 to 6/12 in your Filter?

3) If the progress speed should be faster when I use the Filter as last one after Basic Filter and Filter of Occurrence of Distinct HD instead runing it first like tonight?

Thanks for your sincere help again!!!

Best,
lb

[PadawanLotto]

[quote=lottoboy]
Hi, Padawan:

I ran your Seg. Combination Filter just now. The test result is as below:

1) Runing time: 2 hours 47 minutes;

2) Leave 393037 tickets and remove 575757-393037=182720;

3) JP has been deleted by the Filter
[/quote] Which filter did you run? Do not run the filter on a full package, prefilter the full package first.

1) How can I find or check out where is the mistake?

First I need to know what segment filter that you used. Back test each segment group or compound filter that you used as a whole using a latest setting of 10 to save time, see if the last drawing passed or failed. When you find the filter group that failed, click on customize, choose each filter seperately and click modify, then back test using a latest setting of 10 to save time.

2) How can I change the default setting of Seg. from 3/9 to 6/12 in your Filter?

You would have to totally rebuild the filter to work with a default setting of 6/12. When you change the segment default settings you change the way the segments appear in the columns. If you want to change the default setting to 6/12 you would have to do some research to determin what segments hit the most often and in what columns.

3) If the progress speed should be faster when I use the Filter as last one after Basic Filter and Filter of Occurrence of Distinct HD instead runing it first like tonight?

Use segment compound and group filters after you have already reduced the combination package.

[CARBOB]

[quote=PadawanLotto]
[quote=CARBOB]
Padawan, the breakdown on Fla 5/36 for Distinct Diffs in the Package for 5/9/08 was. I don't believe a Package will vary much.

5/13
6/242
7/3190
8/23050
9/85286
10/156342
11/108869

as you can see, a lot of combinations can be eliminated with a click of a mouse unlike filtering in Excel. I think you will need 2 different Distinct Diff's filters.
[/quote]Where did you get that break down and what are we looking at?
[/quote]

In Excel, I counted the number of Distinct Diff's. The 5/36 Package had 156,342 combinations with 10 distinct Diff's. If you thought a combination with 10 distinct Diff's would hit, you start filtering from there.

[PadawanLotto]

[quote=CARBOB]
[quote=PadawanLotto]
[quote=CARBOB]
Padawan, the breakdown on Fla 5/36 for Distinct Diffs in the Package for 5/9/08 was. I don't believe a Package will vary much.

5/13
6/242
7/3190
8/23050
9/85286
10/156342
11/108869

as you can see, a lot of combinations can be eliminated with a click of a mouse unlike filtering in Excel. I think you will need 2 different Distinct Diff's filters.
[/quote]Where did you get that break down and what are we looking at?
[/quote]

In Excel, I counted the number of Distinct Diff's. The 5/36 Package had 156,342 combinations with 10 distinct Diff's. If you thought a combination with 10 distinct Diff's would hit, you start filtering from there.
[/quote]
Are we talking about the same distinct differences here? Joe and stans distinct differences are different from what I'm talking about. I am talking about differences such as -1, -2, -3.

[CARBOB]

[quote=PadawanLotto]
[quote=CARBOB]
[quote=PadawanLotto]
[quote=CARBOB]
Padawan, the breakdown on Fla 5/36 for Distinct Diffs in the Package for 5/9/08 was. I don't believe a Package will vary much.

5/13
6/242
7/3190
8/23050
9/85286
10/156342
11/108869

as you can see, a lot of combinations can be eliminated with a click of a mouse unlike filtering in Excel. I think you will need 2 different Distinct Diff's filters.
[/quote]Where did you get that break down and what are we looking at?
[/quote]

In Excel, I counted the number of Distinct Diff's. The 5/36 Package had 156,342 combinations with 10 distinct Diff's. If you thought a combination with 10 distinct Diff's would hit, you start filtering from there.
[/quote]
Are we talking about the same distinct differences here? Joe and stans distinct differences are different from what I'm talking about. I am talking about differences such as -1, -2, -3.
[/quote]

If you mean History Diff's, we are. The filter you refer too, is for Distinct Diff's for Segments. I don't think it would involve much work to create a filter for Distinct Diff's for History diff's. Distinct Diff's for HD can be max
11.
This formula will count the Distinct Diff's. Change the ranges, It's an Array, Ctrl-Shift-Enter.
=SUM(IF(FREQUENCY(IF(LEN(B18:L18)>0,MATCH(B18:L18,B18:L18,0),""), IF(LEN(B18:L18)>0,MATCH(B18:L18,B18:L18,0),""))>0,1))

[PadawanLotto]

Thanks CARBOB, the formula works great although I'm having problems loading a full package into Excel, I can still use it for pre-filtered packages.