Comment #1

hypersoniq — Tue, 01 Oct 2024 00:22:16 GMT

Both seeds lost money... each cost $14 and returned $9 for a net loss of $10 total. Both seeds and the lines generated had 1 $5 hit and 2 $2 hits... And BOTH had 9 of the winning numbers in the lines... Leaves 2 choices... 1. Run the test again, maybe sometime next week... using the $18 won toward the test, which will cost another $10 2. Run the big game tests on both... THAT will get expensive as adding the options brings a MM test to $42 and a PB test to $56... $98?<b... [ More ]

Original Blog Entry: Gearing up for the big PA Match 6 live test

hypersoniq — Mon, 30 Sep 2024 12:21:21 GMT

Having only ever studied the data in sorted order columns, there were some unexpected results when gathering a count of the numbers regardless of position.

The first stand out is that none of the numbers are the same! All 6 are different when counting from the entire grid.

In sorted order, by column, a 1 is the most frequent in column A and a 49 is most frequent in column F. They also appear at double the frequency of the other 4 positions.

When counting the numbers regardless of position, 4 ends up being the most frequent number overall. This makes sense because the numbers are not restricted to a single column. The application of the most frequent numbers to appear by position, the Vertical Horizon script, has no missing entries, some of them have fewer distribution entries though, such as a top 5 rather than a top 20, because of how the script only records non zero entries.

In the by column counts, 1 appears around 455 times and 49 appears almost 460, but the top overall picks have counts above 500.

All of the counting was done in the spreadsheet. There was no need for a script for this task.

For each pick generated by counting, there will be 6 corresponding lines generated by the script. Grand total of 14 tickets (because I am also playing the 2 seed lines) at $2 per.

Counting the free quick pick lines, it will be 42 lines for tonight's game.

For the purpose of this experiment, I am only counting matches on the lines I picked. Which ever one does better will be the one moved forward to the big games for a run.

One winner took home $1,680,000 on the September 25th Match 6 draw, so the jackpot reset to $500,000. It is up to $620,000 for tonight.

So, the counting is super easy in a spreadsheet!

To count the most frequent in a column, simply use the mode function giving the column data range as the argument. You can use any empty cell, I usually pick one below the history rows. For my sheet this was

mode(B2:B3882)

Grab that cell and drag it to the right until the other 5 spaces are filled and you have your most frequent by position! Hint: the last cell should contain

mode(G2:G3882)

Note: I start with row 2 because I use a header row. Now, counting frequency by the whole history is slightly different. Somewhere on the sheet where you have the room, create a column (for arguments sake we will arbitrarily choose column J) and fill it from 1 in J1 to 49 in J49. This is our target list.

Now we make our counting function in K1 to read

countif($B$2:$G$3882;J1)

Note the dollar signs, they turn the default relative references into absolute references. When we fill down, the only thing that will change is the target cell. So do that, drag K1 and auto fill down to K49. Now you have the counts! Let's sort them to find out the top 6...

Open a new sheet in the current workbook. Select the range J1 to K49 and copy.

Go to the new worksheet and use paste special to copy only the values (we don't want the formulas here, just their results.) Into cell A1.

Now select cell B1 (this will be the K1 from the first workbook) here is a shortcut for selecting the entire range that contains data... CTRL+SHIFT+Down Arrow. This should then select B1 through B49. Click the SORT Z-- A (descending). It will ask if you want to extend the selection, click OK. Now you have the list of all 49 numbers, sorted by frequency!

The process will alter slightly for different game matrices, but you get the concept.... [ More ]