Win Sum Filter

Win Sum Filter

Postby Joe » Thu Aug 06, 2009 6:16 am

hi stan,

In Win sum filter, I entered the min/max range for a result, When filter the package the Jackpot ticket is missing, I re-checked the ranges again and again but i am having the same problem, please see the picture, the sum displayed is Win sum of tested result, the ranges in columns passed in 9 columns, so my setting was right, but it filtered out the winning ticket too, I really confused, can you guess what could be the problem here?,

thanks
You do not have the required permissions to view the files attached to this post.
Joe
 
Posts: 1227
Joined: Mon Sep 18, 2006 6:51 pm
Location: Petaling Jaya, Malaysia

Postby stan » Sun Aug 09, 2009 12:57 pm

you have 'logical condition - OR' selected. that's why the filter is failing i guess
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Joe » Mon Aug 10, 2009 6:56 am

to make " 9 to 11 columns must be passed " in entered ranges, we have to select "logical Condition OR" only, right?
Joe
 
Posts: 1227
Joined: Mon Sep 18, 2006 6:51 pm
Location: Petaling Jaya, Malaysia

Postby stan » Mon Aug 10, 2009 5:44 pm

i checked the source code and option 'at least x to y must pass' overrides logical and/or settings.

so i don't know why your jackpot ticket got filtered out
maybe you didn't filter the full package? or did you have any other options in the filter window selected? did you have correct winning numbers range selected? correct draw hidden?
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Joe » Mon Aug 10, 2009 7:31 pm

even I couldn't able to find whats wrong in my settings, me too checked it again and again, i couldn't see anything wrong in my settings, still having same problem... :wand: I am using build 1086

pls see the picture,
You do not have the required permissions to view the files attached to this post.
Joe
 
Posts: 1227
Joined: Mon Sep 18, 2006 6:51 pm
Location: Petaling Jaya, Malaysia

Postby stan » Mon Aug 10, 2009 7:40 pm

well, the picture shows that no draw is hidden in your database. so the values in the 'sum' column in the filter window apply to the latest draw in your database. the ticket in the package yields a different set of sum values
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Joe » Tue Aug 11, 2009 3:26 am

[quote=stan]the picture shows that no draw is hidden in your database.[/quote] stan, I skipped two latest draws in the database before apply the filter. see the picture.
You do not have the required permissions to view the files attached to this post.
Joe
 
Posts: 1227
Joined: Mon Sep 18, 2006 6:51 pm
Location: Petaling Jaya, Malaysia

Postby Viking » Tue Aug 11, 2009 10:40 am

Hi Joe,

I assume it is for draw date 17/2007 you filtered out the jackpot ticket with numbers 3-8-17-26-34-43?

Is the sum values for draw date 17/2007 414-781-1149-1571-1934-2304-2795-3232-3643-4068-4433? If it is, you have just 8 of them right when I compare them with the range for min and max sum in your first post above. You have chosen to use at least 9 to 11 columns must pass. Therefore this can be the cause of filtering out the jackpot ticket. Try to use 8 to 11 and see if it helps.

If the above sum values is not the right ones could you be so kind and post a picture of it (WN History/Summary Table/History Only).

Viking
User avatar
Viking
 
Posts: 181
Joined: Wed Mar 04, 2009 12:40 pm

Postby Joe » Tue Aug 11, 2009 10:50 am

[quote=Viking]Is the sum values for draw date 17/2007 414-781-1149-1571-1934-2304-2795-3232-3643-4068-4433? [/quote]
No, its 16/2007 win Sum, you can see the win sums for 17/2007 result at my 1st post in this topic, thanks
Joe
 
Posts: 1227
Joined: Mon Sep 18, 2006 6:51 pm
Location: Petaling Jaya, Malaysia

Postby MartinMan » Tue Aug 11, 2009 4:08 pm

Hello Joe,

I think that Viking is right. Your first post also shows that 3 of your sums are not in range. With your filter set to 9 to 11, you are only getting 8 sum ranges right. If you try it like Viking said with 8 to 11 must pass, then you should pass the filter. Or I am all messed up:)

Regards,
Martin
MartinMan
 
Posts: 141
Joined: Mon Oct 02, 2006 9:38 pm

Postby Joe » Tue Aug 11, 2009 4:15 pm

MartinMan, There are 9 Ranges are passed, only -4 and -9 Columns are failed, pls check ranges in my 1st post,
Joe
 
Posts: 1227
Joined: Mon Sep 18, 2006 6:51 pm
Location: Petaling Jaya, Malaysia

Postby MartinMan » Tue Aug 11, 2009 5:53 pm

Hello Joe,

-2 shows a sum of 1114 a Min of 1125 a Max of 1167.
It looks like you are short of the Min by 11.

Regards,
Martin
MartinMan
 
Posts: 141
Joined: Mon Oct 02, 2006 9:38 pm

Postby Joe » Tue Aug 11, 2009 6:02 pm

Oh how foolish I am..... Really sorry, sorry to waste all your time, thanks Martin
Joe
 
Posts: 1227
Joined: Mon Sep 18, 2006 6:51 pm
Location: Petaling Jaya, Malaysia

Postby MartinMan » Wed Aug 12, 2009 3:52 pm

Hello Joe,

I think maybe you just looked at it to many times :)
Sometimes it's hard to see things when you have looked to long.

Regards,
Martin
MartinMan
 
Posts: 141
Joined: Mon Oct 02, 2006 9:38 pm

Postby Joe » Thu Aug 13, 2009 6:23 pm

[quote=MartinMan:1250085145]Sometimes it's hard to see things when you have looked to long.[/quote] you are right Martin,
Joe
 
Posts: 1227
Joined: Mon Sep 18, 2006 6:51 pm
Location: Petaling Jaya, Malaysia


Return to Winning Numbers History

Who is online

Users browsing this forum: No registered users and 5 guests