Page 1 of 1

Match Winning Digits filter

PostPosted: Wed Sep 21, 2016 6:12 pm
by Ralphj
Hello

I have read all the help files but they do not seem to work with this type of game i.e. 15/25

Could someone tell me how this filter works and how I can check it in Excel. Below is the last 10 games of Lotofacil in Brazil. I have been working on the above filter but I am having problems checking the game by game values. At the end of each game below is the value I had to use in the filter to have a winning ticket. I just do not understand how you can check this value. If you look at the first game in the list below there is a 12, this was the actual filter value for a winning ticket

2 3 4 5 6 7 8 9 0 3 6 7 8 1 5 12
5 6 7 9 1 3 5 6 8 9 1 2 3 4 5 14
1 5 6 7 8 9 0 2 3 4 5 6 7 1 3 13
2 3 4 5 6 7 9 0 4 5 6 7 0 1 3 10
1 2 4 6 7 8 1 2 4 6 7 9 2 4 5 10
1 3 5 8 0 1 2 3 4 9 1 2 3 4 5 10
1 2 4 5 6 7 0 2 3 0 1 2 3 4 5 10
2 3 4 5 6 9 1 3 5 9 0 1 2 4 5 11
2 3 4 7 9 0 1 4 5 6 8 9 0 3 4 12
1 2 3 4 8 0 1 3 5 6 8 9 1 2 5 11

Any thoughts on this would be appreciated.

Ralphj

Re: Match Winning Digits filter

PostPosted: Fri Sep 23, 2016 9:26 am
by stan
Match Winning Digits filter works the same way as Match Winning Numbers. The only difference is that it is looking just at the first digits only (e.g. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 for your first ticket) or the last digits only (e.g. 2 3 4 5 6 7 8 9 0 3 6 7 8 1 5 2 for your first ticket below)

Re: Match Winning Digits filter

PostPosted: Fri Sep 23, 2016 9:19 pm
by Ralphj
Hi Stan

The filter values are 5 latest draws, Last, Min 12 Max 12 to have the jackpot ticket in the package. I have used this filter and the filter you mentioned in past but this one does not seem to be calculating correctly.

Thanks Again

Ralphj

Re: Match Winning Digits filter

PostPosted: Sat Sep 24, 2016 9:32 pm
by stan
Ralphj wrote:Hi Stan

The filter values are 5 latest draws, Last, Min 12 Max 12 to have the jackpot ticket in the package. I have used this filter and the filter you mentioned in past but this one does not seem to be calculating correctly.

Thanks Again

Ralphj

Ok, post the filter screen shot and the actual Jackpot ticket and I'll see what you're doing wrong.

Re: Match Winning Digits filter

PostPosted: Mon Sep 26, 2016 11:57 am
by Ralphj
stan wrote:
Ralphj wrote:Hi Stan

The filter values are 5 latest draws, Last, Min 12 Max 12 to have the jackpot ticket in the package. I have used this filter and the filter you mentioned in past but this one does not seem to be calculating correctly.

Thanks Again

Ralphj

Ok, post the filter screen shot and the actual Jackpot ticket and I'll see what you're doing wrong.


The winning ticket is the first one in the list above.

Re: Match Winning Digits filter

PostPosted: Wed Sep 28, 2016 9:59 pm
by stan
In that case your filter settings are wrong. There is no draw preceding the Jackpot one that would match in all 12 last digits. You need to relax that condition a bit to get any results.

Re: Match Winning Digits filter

PostPosted: Fri Sep 30, 2016 11:15 am
by Ralphj
stan wrote:In that case your filter settings are wrong. There is no draw preceding the Jackpot one that would match in all 12 last digits. You need to relax that condition a bit to get any results.


Thanks Stan, I think our communication is a little off, so I will try to find another way to express this. -- Again Thanks