Filters, and the impact associated with using them.

[sangoma123]

You could setup Excel formulas to calculate the Root and the Digital Root of each combination.

Pab what you want to say? Do not you remember this?

Pab, first, thank you very much for your interest in my doubts.

Though I have a few small notions of excel, I do not handle it often.

Regards

 

[PAB]

Hi sangoma123,

Though I have a few small notions of excel, I do not handle it often.

Yes sorry!
Do you want me to update the WorkBook and upload it for you?

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:

Do not bother. It is not necessary.

Thank you anyhow.

Regards

 

[sangoma123]

Hello Pab:

Do you want me to update the WorkBook and upload it for you?

I have tried to create the formulas and to introduce them in the Excel Spreadsheet,for myself, but I have not could.

It would be great for me if you can update the Workbook and upload to Mediafire. Only for "Root", (not for "Digital Root").


It would be the last time that I ask for this favor to you, because I have enough interest in this topic of the "Root".

Please,forgive this inconveniences.

Thank you and Regards

 

[PAB]

Hi sangoma123,

Here is the updated WorkBook:-

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

Please let me know if it is OK.

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:

Already I have downloaded the file.

It works perfectly (though I have not eliminated -today- any combination with the filter "Root").

Thank you very much, again, you are a GREAT person.

Regards

 

[PAB]

You're welcome sangoma123 ,

Please let me know if you have problems!

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:

How are you?

Regards

 

[PAB]

Hi sangoma123,

I'm good thanks, it's Friday, that's always a good day.
What have you been up to and how is the number crunching going?

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 hope you have a good weekend.

I have uploaded to mediafire a file for you.

When you have downloaded it ,please say it to me.


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


Regards

 

[PAB]

Hi sangoma123,

Thanks, I have downloaded it so you can delete it now.
I will have a look and do some testing 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]

What have you been up to and how is the number crunching going?

The filters of the workbook that you created, remove some bad combinations, but the matter is very difficult.

(I think that this one(lotto) is the challenge more difficultly of our lives).

Regards

 

[PAB]

Hi sangoma123,

Nobody said it was easy .

What do you mean when you say "...using diverse multiple..."?

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]

What do you mean when you say "...using diverse multiple..."?

I know you are charmed with the numbers.

Analyze and you can see that is composed of diverse " multiple numbers ".

(I am sure that you know the multiple numbers).

Example: The multiples of 8 : 8, 16, 24, 32.

The filter its done with a "good mixture" of them.

Regards

 

[PAB]

Hi sangoma123,

Just for your interest, here is the table for ALL the combinations in a C(49, 6) Lotto:-

0 = 12,376 Combinations = 0.0885 Percent
1 = 198,016 Combinations = 1.4160 Percent
2 = 1,180,480 Combinations = 8.4418 Percent
3 = 3,372,800 Combinations = 24.1193 Percent
4 = 4,890,560 Combinations = 34.9730 Percent
5 = 3,423,392 Combinations = 24.4811 Percent
6 = 906,192 Combinations = 6.4803 Percent
Total = 13,983,816 Combinations = 100.0000 Percent

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]

Thanks, Pab. This confirms my information.

Regards.

 

[PAB]

You're welcome sangoma123 .

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 talk with you, again.

I am investigating a bit the filter "gaps" .Example:

combination: 1-9-13-24-29-39

gaps: 07-03-10-04-09

Total:33

The values of this filter seem to be, though I am not sure, about 21 to 42.

Pab, I am sure that your you use this filter.

The problem that I have is -that you know- that I do not handle very well Excel.

Only if in any moment you are not very busy I would be grateful to you that if you could you were adding to your great "Workbook of Excel" this filter, since it looks like a good filter,and please,upload it to Mediafire.(Only in you can do it,if not, there is no problem).

A lot of thanks, friend.

 

[PAB]

Hi sangoma123,

I am investigating a bit the filter "gaps". Example:
combination: 1-9-13-24-29-39
gaps: 07-03-10-04-09
Total: 33

There is a serious flaw in your logic and thinking with regard to Gaps.

The way that you are calculating the Gaps is by taking the Gaps literally and this will NOT work, because if you have combination 01-02-03-04-05-06, using your method, there are NO GAPS.
Now if you were to take say the second number minus the first number, it will always give you an integer (number) value.
This can be calculated quite easily, not only to put into the SpreadSheet as a Filter, but also to calculate the total combinations for each from the 13,983,816 combinations from a C(49,6) Lotto.

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.

 

[Icewynd]

Hi
Now if you were to take say the second number minus the first number, it will always give you an integer (number) value.
This can be calculated quite easily, not only to put into the SpreadSheet as a Filter, but also to calculate the total combinations for each from the 13,983,816 combinations from a C(49,6) Lotto.

Hi Sangoma and PAB,

The analysis you describe is commonly referred to as Deltas -- i.e. the change from the first number to the second, second to third, etc., as we did in the 6/49 Vtracs spreadsheet.

When you do the anlysis, you will find that it is skewed toward the low end, that is, numbers tend to appear in clusters, rather than being spaced widely apart. For example, 5-6-9-19-23-42: the first number,5 is followed by the next number (Delta =1) then by 9 (Delta =9-6=3), then a space between clusters (19-9=Delta 10) then more clustering (23-19=Delta 4) then another gap (42-23=Delta 19). The first Delta is always equal to the lowest drawn number (5 in the example above), allowing you to recreate the drawn numbers by adding the Deltas. Eg. 5, 5+1=6, 6+3=9, etc.

This would seem to be an attribute that would be useful for filtering, where you would want mostly low Deltas (<5) with just one or two higher Deltas.