detect the numbers in each draw line.

[jorel]

detect the numbers in each draw line,
* well afterwards we have a great challenge
after having the plain ready, the task is to see empty and full spaces, sequences of lines and columns and left and right diagonals full and empty, to see these patterns, and repeat them for the future, ex = empty space letters bcded with 5,6,7,8,
the objective is to reproduce the same output patterns
* to repeat the same will be a challenge for filters of a lottery, it will be like a map
https://www.excelforum.com/attachmen...1&d=1589546561

[dangelor]

Possibly...

Please Login or Register  to view this content.

[jorel]

OK, DANGELOR, THE 1st PART IS CORRECT,
if you hover the mouse quickly
about the planilia you will see like two helice dna
* genetics, the challenge now is to find
* empty and full spaces and full and empty columns and diagonal lines and try to locate in the carteziano, goal = repeat the pattern design
* for the next draws would be something new in type of filtering, from lotteries by cloud type standards

[dangelor]

Sorry but I don't see any logic in how you are coloring the cells.

[jorel]

ok,DANGELOR done the first part of detecting
* the numbers from 01 to 25 you see, empty and full circles (with concentration of numbers) you see empty and full sequences in the rows of diagonal columns, since the patterns are repeated over time, you should pick up a trap, the mirror of the layuot of the patterns we will say in a range of the last 20 drawings, to repeat the same drawing of the patterns in the next ones

[dangelor]

??? full circles ???
??? diagonal columns ???
??? pick up a trap ???

None of the above conveys any meaning...

Can you explain why you colored in the 3 blue cells?

[jorel]

hello example=https://www.youtube.com/watch?v=4NY_3lhhVv0

[dangelor]

Sorry, but the lack of logic in that video is only surpassed by the ignorance of the presenter. If lotteries wins could be programmed, there wouldn't be any more lotteries. Good luck with your quest.

[jorel]

ok dangelor I agree, but the patterns are repeated in cycles, it will be to play in several draws, it is necessary to have a reference, the repetitions and absences can be a reference

[MrShorty]

I'm with dangelor, unless we have some rigorous evidence that the lottery is not truly random, it's probably not worth a lot of effort.

I have to admit that my first reaction to the video reminded me of this xkcd comic https://xkcd.com/2048/ and this one https://xkcd.com/1725/

After getting past my initial skepticism, what I see happening in the youtube video is basically a "resampling" type of procedure:

0) Given a "2D" scatter set of data consisting of "ball number" on the x axis and "draw number" on the y axis.
1) Take a (random?) sample of n points from the data set (your data set has 2000 draws times 15 balls for about 30000 data points). One would need to choose how many points to include in a sample and I have no idea how to make that choice.
2) Perform the desired regression(s) on the data set and measure goodness of fit.
3) Look at the regression and the goodness of fit score and decide if it is good enough to save. I have no idea what would make a good threshold for the goodness of fit score. It might be preferable to perform this step outside of the loop where you can analyze the goodness of fit from all regressions.
4) Repeat steps 1 to 3 for several different samples (maybe for every possible combination of n data points? -- But that would be a lot of resamples).
5) Additional analysis as required and draw conclusions.

There would still be a lot of details to work out to perform this kind of analysis. If someone decided it was worth the effort to figure out the details and develop the analysis and program that into their favorite programming language, that's a basic overview of what I see happening in the video.

[Marc L]

No worth since I knew how some winners have won the great Lottery prices …

[jorel]

hello, wrshorty, marcl, thanks for viewing the post, well we have to think about the wide range of the 80% gauss bell curve .. in any lottery we have two factors the repetitions and absent, this is it with the patterns too , the problem is finding a reference to be the basis for the correct use of statistics, you can use the draws
* previous (which is our case now) to synchronize the time for the future, like playing on a chessboard, we would have to create trees of decisions, you cannot go against certain patterns in the lotteries

[AliGW]

The only patterns in lottery draws are the ones you imagine are there - like when you see a face in a cloud formation - and in reality, it’s all random.

[jorel]

hello,ALIGW we could create the carteziano
* in excel do well, example
4 letters with 5 numbers, just an example
* results in 20 cells or a 4x5 matrix locating
* this block we can then create several blocks, like that of throwing pebbles more in one block and less in the other, creating blocks with the union of rows and columns
* noa is fi

[jorel]

yes, it is a fleeting cloud of patterns of full and empty blocks, in circles, column and diagonal lines, that we could set up a trap
* to play in various sweepstakes crossing with other strategies and patterns of the wide range of the bell curve, at least as far as mathematically
* get it, then a small part will be random
and not every bet

[jorel]

MRSHORTY can you set this up?
let's divide the 01 to 25 into 5 groups of 5 numbers
with 25 drawings, 25 letters with 25 numbers, we will have 25 blocks, can you build this grid? there the cloud is or is not in a block

[jorel]

make a grid of 25 numbers and 25 letters, we have 25 blocks of 5 by 5
this matrix grid will be used as block filters

[jorel]

hello=https://www.excelforum.com/attachment.php?attachmentid=677911&stc=1&d=1589576679

[MrShorty]

I don't understand what you want to do in these blocks nor how you want to use them as filters.

[jorel]

in carteziano=please mount this 25 x 25 grid
blocks of 5 to 5 have 25 blocks, but with
* cartezian positioning each block has 25
ex positions
* block 1 position b3 .... so every 25 draws
* it is possible to see the grid of positional frequency positions of the numbers

[jorel]

I intend to use each block in the carteziano positioning within each block has 25 positions,
it will be a trap for several repeated games,
* have to do in each of the 25 blocks, the 25 positions, to use the positional carteziano cycle
* is a new type of filters

[jorel]

in reality the trap is for 25 games in a row, play 25 games with the grid, if within the 25 draws
* get some good prize will be in the profit can you make this grid? the hardest part is to see the 25 cartezian crossing positions and then the frequencies of the positions and delay always from the last 25 draws and going up the list in the example of the list this is in the beginning but you have to do it in the last 25
* the statistics always remembering each week has 3 new drawings to update

[jorel]

hello= example= table 1º ching 64 patterns

[MrShorty]

I still don't understand. You talk about determining frequency of a value or values occurring, which should be a COUNTIFS() function. I know that you have used COUNTIFS() in many of your prior projects. Do you remember how to use COUNTIFS() to count how often a value occurs within a block of cells?

[jorel]

but this project is new, the frequency is positiomanento carteziano, as we will have 25 blocks in a vloco example number 17
* in the d4 position of the card holder, he is overdue 4 draws, his will be a hard work but will result in the filters by blocks and position

[Marc L]

Your project looks like the one last century a 'mathematician' & a computer developer engineer asked me to get in …
The idea was to reduce « le champs des possibles » in order even if the great price was not won
the sum of the sub prices may not be under the total amounts invested.
As I could not invest such a lot of money, I just help them for few routines,
just asking a small % in case they win the great price …
They did simulations, every week after the draw they refined their Lottery logic and one day,
they were confident according to the last draw, they will 'jump' the next week.
I told them to wait a little according to their last changes in calculations, just to be sure with the next draws.
The next week they invested a lot and they lost far more than they earned,
looked devasted like if they had lost their home in poker …

Few days later I read in the newspaper how an elder woman won the great Lottery price : she saw her pet
playing with her round plastic board which had holes for each Lottery number with small tiny marbles,
she was amused and just played the numbers filled by the marbles and earned the millions !

More recently a young couple won millions with the barcode of a milk bottle …

Younger when I was a student I worked in a Lottery shop, each week a man was coming with more than
a hundred paper grids (a paper = 10 grids) and with some special grids costing more than normal grids,
so each week he invested more than my month salary, he said he had some winning cabal calculations.
I asked to the shop director if he won and how much and he just answered « not much, very few » …

So the best way to win, apart from luck or providence, is time travel !

[MrShorty]

we will have 25 blocks in a vloco example

I am having a difficult visualizing or understanding these 25 blocks.

in the d4 position of the card holder, he is overdue 4 draws

I don't know where the d4 position is, nor do I understand how you determined that he is overdue by 4 draws.

[jorel]

hello marcl i agree, but you have to think that the example you mentioned was for a single example, my plan is to play 25 draws in a row, and not in a single event. when I get the first numbers and the last
from 01 to 25 then I have a reference
ex = 02 04 05 xxxxxxxxx 21 23 25, this is crossed with the strategy of the positions of the carteziano blocks, because in lotteries we have only this
* pattern in 100% repetitions and absent from the last draw

[jorel]

hello mrshorty thanks for viewing the post,
* well we have two cartezianos, 1st large carteziano
* 25 letters and 25 numbers and 2nd card with 25 blocks, you can see that in 25 draws there are not even one of the 25 blocks with the same design this is good for, filtering from the previous blocks cannot be the same, I repeat is to bet 25 times in a row
on the question is just an example,

[Marc L]

but you have to think that the example you mentioned was for a single example

Nope so you misread or misunderstood …

Whatever the strategy you may use if you win that's just 99% of luck !

[MrShorty]

well we have two cartezianos, 1st large carteziano

I know some French, but no Portugese, so I have no idea what a "carteziano" is.

25 letters and 25 numbers

I see a lot of numbers in your sheet, and I understand that the lottery is picking random numbers from 1 to 25, but I see no letters, and do not understand what letters and numbers you are referring to here.

you can see that in 25 draws there are not even one of the 25 blocks with the same design this is good for,

If I understand, you want to separate the spreadsheet into groups of 25 "draws" (rows in your original spreadsheet). I don't understand how you intend to separate 25 draws/rows into 25 blocks and then analyze the "design" in those blocks.

Assuming this is a fair lottery (the numbers are truly chosen at random), the probability of any number to appear in the next draw will always be the same. What has been drawn previously has no impact on the next draw. At some point, one needs to decide how much effort one wants to put into analyzing for "patterns" in random data.

[jorel]

ok MR SHORTY thanks, for the good work i will see the solution in another forum, thanks for trying