The Quarantine has me back to My Lottery Pursuits. Cricket Lotto Works is up and running again. Most of the Time that I spent working at a paying job is now being spent at my computer, Reading News, LP Posts, watching YouTube, Playing Solitaire and Making Excel Tools for the Lottery.
That Last endeavor has picked up the most from the reassignment. Re-Entry into the Lottery found me going back to Pick 3. Stemming from a contact with TasBob about Florida Pick 3, I dusted off some of my old Files and incorporated Bob’s ideas. Actually, it was a File built from scratch that incorporated parts on my other files with the improved Selection Process that has so far evolved in Fantasy 5 Files. It is a “New” Control Panel that responds to the Filters that are Turned On or Off and the Filter Values that are applied when Filters are On.
I gleaned most of the New File from my old TROELH File. Type-Repeat-ODD Even and Low High. I added Bob’s Idea from his Recent Post looking for Excel help in applying Lists to the Selection Process. Originally the Idea was to Apply Lists of Numbers to be Included or Excluded. That morphed into other Lists. Pairs and Root Sums for each can be Turned On or Off with Pairs, and Root Sums set for Inclusion or Exclusion. The Control Panel Shows up to 40 LMH Box Combinations that pass through the Filters. The Inventory of Passing Combinations reduces rapidly as Filters are activated and their values are set. Inclusion or Exclusion options are dramatic reducers. I Just thought of a new mission statement for Cricket Lotto Works. “We Make Tools that make your system easy to Run into Walls or Windows, results vary”. Hopefully Bob will have some success with his Idea and the Excel Tool will make it easier to do.
Now I am looking at Super Lotto again. This Time I am trying to use a Magic Square or Perfect Square. I found them while looking up Vortex Math on line. I found a website that creates a Magic Squares and generated a 7x7 Square. Magic Squares are so named because the Sum of Every Row or Column and the Diagonals all add up to the same Number. In the case of a 7x7 that Sum = 175. The Following is a link to a Website that calculates Magic Squares. Here you have the option of Specifying any sum Value. This produces a 7x7 Square with a mixture of positive and negative numbers with decimal points. These squares are only “perfect” in that all of the sums are the same. Not sure how to use those, but the Primary Magic Square is hopefully useful. formula n[(n^2+1)/2 where n=the number of rows and columns in the square, hence a 7x7 Square would be 7*(7^2+1)/2=175. https://www.dcode.fr/magic-square is a Web Site that will calculate and fill out a magic square for multiple sizes of grids.
A 3x3 Grid is a “perfect” match to Pick 3 and a 7x7 Grid to Supper Lotto.
Below is the 7 x 7 Perfect Square.
30
|
39
|
48
|
1
|
10
|
19
|
28
|
38
|
47
|
7
|
9
|
18
|
27
|
29
|
46
|
6
|
8
|
17
|
26
|
35
|
37
|
5
|
14
|
16
|
25
|
34
|
36
|
45
|
13
|
15
|
24
|
33
|
42
|
44
|
4
|
21
|
23
|
32
|
41
|
43
|
3
|
12
|
22
|
31
|
40
|
49
|
2
|
11
|
20
|
This Square has all 49 Numbers from the 6/49 Super Lotto Game.
I am making a Tool that will be tracking the Drawn Numbers by their Position in the Magic Square looking for Formulas based on Shifts in Position. Combining the difference between the numbers themselves with the variable of the Shift between same will be calculated through the game history and converted into Ranges that can be used as a Filter.
That should keep me busy while the Quarantine is still Required and Prudent.