Bug Match File Filtre?

Bug Match File Filtre?

Postby Lexus » Tue Nov 10, 2009 2:31 pm

Hi Stan!

In the attached file two test files: one file with a package of combinations which it is necessary to filter and the second file with a set of combinations for filter Match File

When I use filter Match File filtre, my actions such:
1. I open a file.
2. I mark "Allow variable combination size"
3. I mark necessary condition Match 0
4. I mark Remove
5. OK

As a result any combination does not filtered out, the package remains invariable.
Though in a package there is a combination which I specially there have introduced. This combination should be removed!

What do I do incorrectly?
You do not have the required permissions to view the files attached to this post.
Lexus
 
Posts: 42
Joined: Sun Aug 09, 2009 11:02 am

Postby stan » Tue Nov 10, 2009 3:34 pm

the matching file contains the whole range of drawn numbers so there will be always a match in one or more numbers no matter what's in the package.
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Lexus » Tue Nov 10, 2009 4:29 pm

Well.

The first line contains numbers:
2,3,4,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,27,28,29,30,31,33,34,35,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52
Means there are no numbers:
1,5,6,7,8,9,25,26,32,47
That there correspond combinations in a package:
1,5,9,26,32,47

Why even this combination is not filtered?
Lexus
 
Posts: 42
Joined: Sun Aug 09, 2009 11:02 am

Postby stan » Tue Nov 10, 2009 5:00 pm

because there are many other lines in the matching file that do produce a match in one or more numbers - 'no match' is handled differently from other match option (note it has no min/max column). 'no match' is if and only if there is no match with all lines in matching file.
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Lexus » Tue Nov 10, 2009 5:39 pm

Then I cannot understand, why at filtration Match 0, the data from other lines is considered
And at filtration Match 1,2,3,4,5,6 other lines do not influence,

Unless the principle of work of the filter differs from:
1 line, then 2 line and so up to the end is processed?
Lexus
 
Posts: 42
Joined: Sun Aug 09, 2009 11:02 am

Postby stan » Tue Nov 10, 2009 7:57 pm

'no match' applies to all lines in matching file, otherwise it wouldn't be useful very much when comparing ordinary ticket files. there would almost always be at least one ticket with no match
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Lexus » Tue Nov 10, 2009 9:32 pm

http://www.expertlotto.com/en/forum/for ... 59&page=10

In the resulted reference you have answered me:
"an interesting idea but there already is ' match file ' filter where you can select a.csv file with any count of numbers on each line. just the match settings apply to the whole file instead of individual lines"

Therefore I also had this question.
If at me it is impossible to explain words, in the attached drawing all should be clear
You do not have the required permissions to view the files attached to this post.
Lexus
 
Posts: 42
Joined: Sun Aug 09, 2009 11:02 am

Postby stan » Tue Nov 10, 2009 9:43 pm

both 'kopia kopia test2.csv' and 'kopia test2.csv' files have only one line so it's different from your test.rar attachment in the original post.

'kopia kopia test2.csv' does not have numbers 1,5,9 etc so there's 'no match' with the last ticket in the package and it gets filtered out.

'kopia test2.csv' does include numbers from the last package ticket so there is 'some' match for all package tickets and nothing gets filtered out.

if you add another line to 'kopia kopia test2.csv' file, e.g. the same line from 'kopia test2.csv' then the last package ticket will have 'some' match with the second line in the matching file and nothing will get filtered out.
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Lexus » Tue Nov 10, 2009 9:57 pm

Here two opened files in a spreadsheet
As you can see in one file one line, in friend two

The empty line can be necessary between the data?
You do not have the required permissions to view the files attached to this post.
Lexus
 
Posts: 42
Joined: Sun Aug 09, 2009 11:02 am

Postby stan » Tue Nov 10, 2009 10:08 pm

no empty lines are necessary
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Lexus » Wed Nov 11, 2009 12:00 am

Your answer is only the answer to a concrete question.
But does not answer a question why two lines in a file.csv are processed as one?

In the attached file a picture displaying one of possible applications Match 0
In the given example all search of combinations will be removed from a package for numbers:
2,3,5,7,11,12,15,16,23,24,25,29,30,39,40,41,43,46,47,48
And
2,3,5,7,8,9,11,12,15,16,23,24,25,28,29,30,39,40,41,43,46,47,48,51

Here two lines for Match File filtre are ready.

In the left part of drawing you can see 87 latest Draws. For a case in point a maximum quantity nearby standing Draws having "0" losses equally 5.
Here we also receive 87 lines for a filtration.

Also it will be final in a file.csv all set of numbers from 1 to 52.

Why last ticket in the package do not filtered out?
You do not have the required permissions to view the files attached to this post.
Lexus
 
Posts: 42
Joined: Sun Aug 09, 2009 11:02 am

Postby stan » Wed Nov 11, 2009 10:32 am

read again my second post in this thread.
a ticket is filtered with 'no match' option if it doesn't contain any number from any line in matching file. if the file has at least one line with the same number then the ticket doesn't get filtered out.

if you select e.g. 'match 1' option, then the ticket is filtered out if there's at least one line in the matching file that contains one ticket number.
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Lexus » Wed Nov 11, 2009 3:00 pm

It means what to use Match 0 for Match File filtre where is more than 1 line, it is impossible. Truly?

And the second question how it to make by means of EL 4?
Lexus
 
Posts: 42
Joined: Sun Aug 09, 2009 11:02 am

Postby stan » Wed Nov 11, 2009 3:13 pm

[quote=Lexus]
It means what to use Match 0 for Match File filtre where is more than 1 line, it is impossible. Truly?
[/quote]
it is possible, but it will work the way i described above.

And the second question how it to make by means of EL 4?

not sure what you mean here
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Postby Lexus » Wed Nov 11, 2009 6:36 pm

Stan if we cannot understand one another, then here one more my question based on an example:

There are 6 lines in.csv a file - using Match file filtre on an exit we receive 0 filtered out. We have already found out it

If each line separately to drop through Match Namber filtre as a result it is received 377 300 tickets left in the package, 19 981 220 filtered out - and it is is unique true result!

What options ' Match??? ' it is necessary to note to reach - it is unique true result?
At me such results:

Match 0 - 20 358 520 tickets left
Match 1 - 991 584 tickets left
Match 2 - 4 130 123tickets left
Match 3 - 14 454 670 tickets left
Match 4 - 19 622 350 tickets left
Match 5 - 20 315 575 tickets left
Match 6 - 20 357 617 tickets left
You do not have the required permissions to view the files attached to this post.
Lexus
 
Posts: 42
Joined: Sun Aug 09, 2009 11:02 am

Next

Return to Comments, suggestions, features requests

Who is online

Users browsing this forum: No registered users and 2 guests