+ Reply to Thread
Results 1 to 32 of 32

detect the numbers in each draw line.

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    detect the numbers in each draw line.

    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
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,522

    Re: detect the numbers in each draw line.

    Possibly...
    Please Login or Register  to view this content.
    ____________________________________________________________
    If I've been helpful, let me know. If I haven't, let me know that too.

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,522

    Re: detect the numbers in each draw line.

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

  5. #5
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  6. #6
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,522

    Re: detect the numbers in each draw line.

    ??? 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?

  7. #7
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

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

  8. #8
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,522

    Re: detect the numbers in each draw line.

    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.

  9. #9
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  10. #10
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,561

    Re: detect the numbers in each draw line.

    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.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  11. #11
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Arrow Re: detect the numbers in each draw line.


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

  12. #12
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,495

    Re: detect the numbers in each draw line.

    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.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  14. #14
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  15. #15
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  16. #16
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  17. #17
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  18. #18
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

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

  19. #19
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,561

    Re: detect the numbers in each draw line.

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

  20. #20
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  21. #21
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  22. #22
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  23. #23
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    hello= example= table 1Ί ching 64 patterns

  24. #24
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,561

    Re: detect the numbers in each draw line.

    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?

  25. #25
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  26. #26
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Arrow Re: detect the numbers in each draw line.


    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 !

  27. #27
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,561

    Re: detect the numbers in each draw line.

    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.

  28. #28
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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

  29. #29
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

    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,

  30. #30
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Arrow Re: detect the numbers in each draw line.

    Quote Originally Posted by jorel View Post
    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 !

  31. #31
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,561

    Re: detect the numbers in each draw line.

    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.
    Last edited by MrShorty; 05-16-2020 at 02:31 PM.

  32. #32
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,693

    Re: detect the numbers in each draw line.

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] detect the last digit of each lottery, then add the quantity in each draw line.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2020, 06:24 PM
  2. detect the corresponding sector numbers from 06 to 20 on each draw line
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2019, 08:23 AM
  3. [SOLVED] detect the numbers on each draw line we both sectors and add the amount
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2019, 09:09 AM
  4. [SOLVED] detect the upper (+1) and lower (-1) adjacent of the draw line reference.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2019, 06:27 PM
  5. [SOLVED] Only detect matching complete trios on each draw line.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2019, 05:08 PM
  6. [SOLVED] detect each corresponding number of the draw line.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-24-2019, 11:23 AM
  7. in each draw line * detect the two empty quadruples
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2019, 08:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1