Filters, and the impact associated with using them.

[PAB]

Hi sangoma123,

Hello PAB:

Even I have not installed the new version of excel, but I would like to send you some information.

I have tried to send you a private message, but there appears a message that it says that I cannot: (Disabled by the administrator)

Is there any mail where I could order you a private message?

Firstly, you are not allowed to post email addresses on this board as per the rules.
If you use the Contact Us link at the bottom of the page you can email LT who is the administrator and ask him to forward the message to me.

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[PAB]

Hi sangoma123,

I did post this yesterday but unfortunately LT had problems with the site, so I thought I would post it again.
Thanks for your kind words by the way and you are welcome.

Here is an Excel 2007 WorkSheet with the formulas etc for the AC filter.
Just copy and paste the link into your address bar and hit enter.
It is a FREE cloud based storage system that is quite popular on this board.

http://www.mediafire.com/view/?btocx5mgcecddx8

You could also send me the information you wanted to via the same method if you wanted to.

Please let me know how you get on!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Hi Pab:

Thanks for your great work.You are a Excel´s genius.

The cell of excel works perfectly, even the cell 21!.
Only it is necessary (to be perfect)-if is possible- that could stick the drawings in block, and all the AC's results were appearing simultaneously (For example for 30 bets, preferably in this format):

2,6,7,25,31,36
6,11,25,34,36,37
3,14,20,31,36,37
5,6,25,28,29,36

With this, the saving of time to verify bets would be big.

I have sent to MediaFire a link to a page for that I hope that it is useful for you.


http://www.mediafire.com/view/?ozy15d2v00574bd


(There is a lot of interesting information, and filters).

Well, thank you very much again, and I hope that you do not have problems with the link.

Regards

 

[PAB]

Hi sangoma123,

Unfortunately your link is saying Invalid Or Deleted File!
I don't quite understand what you mean when you say:

"...stick the drawings in block, and all the AC's results were appearing simultaneously...".

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[PAB]

Hi sangoma123,

Do you mean something like this, copy and paste this into cell AA2:

=CONCATENATE(B2,", ",C2,", ",D2,", ",E2,", ",F2,", ",G2,", AC Calculations ",I2,", ",J2,", ",K2,", ",L2,", ",M2,", ",N2,", ",O2,", ",P2,", ",Q2,", ",R2,", ",S2,", ",T2,", ",U2,", ",V2,", ",W2,", AC = ",Y2)

All you need to do if you have more combinations is to copy cells I2:AA2 down as far as needed.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Hello Pab:

I leave the link one day and after I removed it.

I put it another day and after I´ll remove again.

http://www.mediafire.com/view/?b9gidzxp7hisgm9



Thanks:finger:

 

[sangoma123]

Hello again Pab:

I have tried to introduce the formula " concatenate " in the spreadsheet that you sent me by "Mediafire", and I cannot introduce it.

In addition, the cells from AA in forward are of black color.

Would it be great to bother that in the spreadsheet that you me sent for Mediafire you were including this addition (to concatenate)? I could download again with this adition,if you want.

It is that something I do in a wrong way and I cannot do it .

Sorry for the possible inconveniences.

(Please,when you download my file from Mediafire,say me it).


Thank you very much.

 

[PAB]

Hi sangoma123,

Firstly, why did you give me the Finger???

I have downloaded your file so you can delete it now.

Here is the new Excel 2007 file with the Concatenate incorporated.

http://www.mediafire.com/view/?btocx5mgcecddx8

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[jack]

Hello, very good job of pab filters, but the big problem, the conflict between
The filter settings, just miss a parameter if was the bet, then first the standards after the filters, but a small number of filters,
How to avoid conflict in the configuration of filters? Thank you

 

[sangoma123]

Pab, I have the impression of you are, angered?.

I do not understand it. The link is to a page with a lot of valuable information about statistics and some filters that are not in your list.

It is the old forum, not the new one, and not wise if you know it.

I think a lot of people dont know it.

I don´t what you know and what you do not know, then it is possible to happen that I offer you information that already you know.

I ´m sorry if you were waiting more of this file.I´ll try give you more useful information that you don´t know.

Thanks a lot.

 

[sangoma123]

Pab,do you know Robert Perkis´ "Leap Frogs".I think you can use these numbers like a filter.

Your excel worksheet works perfect.!!Congratulations¡¡.Thanks a lot

(Like I said you, only one combination,(AC less than 6), in 40 is eliminated,but its good)

Regards

 

[PAB]

Hi sangoma123,

PAB, I have the impression of you are, angered?. I do not understand it.

The thing I didn't understand was the double finger smiley because that means F*** YOU, and I don't know what I had said or posted that made you feel the need to put that???

The link is to a page with a lot of valuable information about statistics and some filters that are not in your list.

Yes this is true, I think this has been covered in posts on this board several times in the past, and yes, it is very interesting.
As I said in my first post I use over 100 filters, but I only posted a small selection for purpose of discussion and to see what filters other members were using and why.

PAB, do you know Robert Perkis "Leap Frogs" .I think you can use these numbers like a filter.

Robert Perkis is a respected member of the Lotto community and his many contributions are well worth reading.

Your excel worksheet works perfect.!!

Brilliant, I am glad.
I am not sure why you could not get the formulas or Concatenate to work without you uploading your WorkBook for me to look at, I am at a loss as to what you are doing wrong otherwise.

Like I said you, only one combination, (AC less than 6), in 40 is eliminated, but its good.

Using the AC filter and the number of combinations potentially rejected will obviously depend on how your combinations are setup and structured. I outlined how mine were initially setup and structured in my first post, and the introduction of the AC filter by Frank is a very welcomed edition to my filters list, thanks again Frank for sharing this with us.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Pab, I am sorry.

There has been a GREAT misunderstanding.

I don´t wise that the smiley was doing that gesture.

I was THINKING THAT THE SMILEY WAS DOING OK with both hands.

On the screen of my monitor I can´t saw that the smiley used THAT fingers.

I sit it indeed. I Never did to you that, when always you have helped me.


Regards and SORRY again

 

[PAB]

No worries sangoma123, I thought that was the case but I just wanted to check.

I am off down the pub for a couple of pints now but will be back on later.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Hello Pab: Looking "old" posts I have "rediscover" this one of the great Gilles D, to see what do you opine, and in this way we encourage a bit your post about filters:

The old post is called:

"Data on Delta",and here is:

"In the Delta theory, the bonus number is not considered and the lowest number of the 6 numbers is part of the group of 6 Deltas (the other being the differences between two consecutive numbers when placed in in order).

Up to now, with 1959 draws, Deltas of 15 and lower represent 90.2% of the 11,754 Deltas. The maximum Delta obtained is 38.

Draws with repeating Deltas represent 67.2%.

But if you combine the two conditions, at least one repeating Delta and no Delta over 15, only 37.8% of the draws pass."

I think it can be interesting if we can use it like a filter,but I do not have much idea how it brings over of the deltas and how apply them to a game 6/49.

Regards

 

[PAB]

Hi sangoma123,

Delta's are really the difference in positional limits. This is one of the filters I use anyway.

A brief description of Delta numbers is as follows, and is based on the drawn numbers being numerically sorted from left to right.

The first Delta number is always the first number.
The second is the second number minus the first number.
The third is the third number minus the second number.
The fourth is the fourth number minus the third number.
The fifth is the fifth number minus the fourth number.
The sixth is the sixth number minus the fifth number.

So for example, the numbers...

01 11 15 26 29 47

...have Delta numbers of...

01 10 04 11 03 18

The interesting thing about this is that if you add up the second Delta number to the sixth Delta number the answer is 46, the same as if you subtract the first number sorted numerically away from the sixth number.

The total Delta numbers range from 5 to 48 and the total combinations for each in a 649 Lotto are:-

05 = 44
06 = 215
07 = 630
08 = 1,435
09 = 2,800
10 = 4,914
11 = 7,980
12 = 12,210
13 = 17,820
14 = 25,025
15 = 34,034
16 = 45,045
17 = 58,240
18 = 73,780
19 = 91,800
20 = 112,404
21 = 135,660
22 = 161,595
23 = 190,190
24 = 221,375
25 = 255,024
26 = 290,950
27 = 328,900
28 = 368,550
29 = 409,500
30 = 451,269
31 = 493,290
32 = 534,905
33 = 575,360
34 = 613,800
35 = 649,264
36 = 680,680
37 = 706,860
38 = 726,495
39 = 738,150
40 = 740,259
41 = 731,120
42 = 708,890
43 = 671,580
44 = 617,050
45 = 543,004
46 = 446,985
47 = 326,370
48 = 178,365

I hope you find this interesting!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Alexafjb]

Use of a filter

Hello, PAB & Everyone

PAB, Ive read thread #1 and of course a few questions start to ping around in my head!

1)When you run your filters, do you run them upon the same number of previous drawings each time?

2)Have you found a specific filter that appears to get you closer to the winning combintaion better then any other filter.

3) Have you, or should I say do you, track what filter/ filters have worked best for each indivdual draw in your database?

All The Best.
Alex.

 

[PAB]

Welcome back Alex,

Firstly, all the filters I use are based on the LOWER & UPPER values for ALL THE DRAWS TO DATE, BUT, what I do is to make small revisions to them to bring them into line with what is currently the ACCEPTED NORM with respect to what has been historically drawn to date. This is because as I said previously you will normally find that the values based on the total combinations drawn to date for the LOWER & UPPER limits are normally few and far between.
These filters parameters are set because if a combination was to be drawn that was outside of my set parameters it would mean that statistically it was generally not the NORM and would be excluded anyway.

1)When you run your filters, do you run them upon the same number of previous drawings each time?

In effect the answer is no, I run them on all the draws to date, so basically the draws that they are based on increases with every draw.

2)Have you found a specific filter that appears to get you closer to the winning combintaion better then any other filter.

Well, because I am not over aggresive with the revision of the ACTUAL LOWER & UPPER values, the many filters I use seem to compliment the whole filter reduction process.
There are obviously filters that if you were to use them individually would give you a varying range of reduction, but being included with other filters makes the whole process a lot tighter and structured in my personal opinion.

3) Have you, or should I say do you, track what filter/ filters have worked best for each indivdual draw in your database?

I don't actually track what filter(s) have worked best for each indivdual draw because I think this is non-productive, and is better suited to a DataBase that has as many draws as possible in order to hopefully get a better determination of what has and what hasn't been drawn before.

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Hello Pab,I am glad to speak with you again .

Wow¡¡¡ .I think in a Excel sheet or a program , where we paste our combinations and put the limits of deltas, for example, value only of 5-20, and we can eliminate thousands (or million combinations), not?

Regards

 

[PAB]

Hi sangoma123,

What I didn't make clear for readers of this thread is that the data I previously posted is for the Sum of Delta numbers EXCLUDING the first Delta number, which is the first number of the combination after the combination has been sorted numerically from left to right. I just wanted to clear that up.

I have also calculated the Sum of Delta numbers INCLUDING the first Delta number which range from 6 to 49 and the total combinations for each in a 649 Lotto are as follows:-

06 = 1
07 = 6
08 = 21
09 = 56
10 = 126
11 = 252
12 = 462
13 = 792
14 = 1,287
15 = 2,002
16 = 3,003
17 = 4,368
18 = 6,188
19 = 8,568
20 = 11,628
21 = 15,504
22 = 20,349
23 = 26,334
24 = 33,649
25 = 42,504
26 = 53,130
27 = 65,780
28 = 80,730
29 = 98,280
30 = 118,755
31 = 142,506
32 = 169,911
33 = 201,376
34 = 237,336
35 = 278,256
36 = 324,632
37 = 376,992
38 = 435,897
39 = 501,942
40 = 575,757
41 = 658,008
42 = 749,398
43 = 850,668
44 = 962,598
45 = 1,086,008
46 = 1,221,759
47 = 1,370,754
48 = 1,533,939
49 = 1,712,304

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.