Win Num History Filter

Win Num History Filter

Postby Red Devil » Sun Jun 04, 2006 11:38 am

Stan,

When using this filter I get a zero pass when trying just to use the "History-1" Index on its own.

Is this a bug?

Using "History0" and "History-2" are OK.

The limits I used are Min 783 and Max 813.

Rgds :vogel:

Norman
Red Devil
 
Posts: 348
Joined: Tue Apr 25, 2006 3:26 pm

Postby Red Devil » Mon Jun 05, 2006 12:35 am

Stan,

Further to my post yesterday, I have another problem using the Win Num Filter. I set Indexes:

0 Min 375, Max 405
-2 Min 1160, Max 1190
-4 Min 1975, Max 2005

Logical condition - Add

This returns no passes.

However, I had previously set the number of rows in the summary table to 1000, exported the Win History and then imported into Excel. Using the auto filter set to the above settings, Excel returned 21 passes. Can you explain this and the previous post, am I doing something wrong?

Rgds

Red Devil
Red Devil
 
Posts: 348
Joined: Tue Apr 25, 2006 3:26 pm

Postby stan » Mon Jun 05, 2006 8:09 pm

[quote=Red Devil]
Further to my post yesterday, I have another problem using the Win Num Filter. I set Indexes:

0 Min 375, Max 405
-2 Min 1160, Max 1190
-4 Min 1975, Max 2005

Logical condition - Add

This returns no passes.

However, I had previously set the number of rows in the summary table to 1000, exported the Win History and then imported into Excel. Using the auto filter set to the above settings, Excel returned 21 passes. Can you explain this and the previous post, am I doing something wrong?
[/quote]
what did you actually export from expert lotto? please remember that the summary table applies to previous draws only while the filter operates on tickets in the package.
so your excel filter may find some matching rows but the wn history filter will look for matches in tickets in the package...
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby stan » Mon Jun 05, 2006 8:12 pm

[quote=Red Devil:1149413905]

When using this filter I get a zero pass when trying just to use the "History-1" Index on its own.

Is this a bug?

Using "History0" and "History-2" are OK.

The limits I used are Min 783 and Max 813.
[/quote]

use button 'lookup min & max ranges' in the filter window. you may find out that the only possible values the tickets in the package can produce are for example 650 to 780
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Red Devil » Mon Jun 05, 2006 11:45 pm

Stan,

Having played more and using the lookup min & max ranges for different dates as you suggested, I know where my mistake lies. I assumed that because I was using the full package, the values I had exported would automatically be included. I know now that the min/max values change after every draw, obvious really but then I am getting on a bit.

Thanks

Red Devil
Red Devil
 
Posts: 348
Joined: Tue Apr 25, 2006 3:26 pm


Return to Winning Numbers History

Who is online

Users browsing this forum: No registered users and 5 guests