Welcome Guest
Log In | Register )
You last visited December 3, 2016, 4:44 pm
All times shown are
Eastern Time (GMT-5:00)

How to simulate a distribution and use the lottery's own randomness against itself.

207 replies. Last post 1 day ago by JADELottery.

Page 13 of 14
4.817
PrintE-mailLink
Sunglasses's avatar - nicebear
Zaperlopopotam
Belgium
Member #173932
March 26, 2016
950 Posts
Offline
Posted: June 19, 2016, 7:09 pm - IP Logged

Windows Panel -> set priority : high for Excel

    Avatar
    Maryland
    United States
    Member #126396
    April 8, 2012
    399 Posts
    Offline
    Posted: June 20, 2016, 5:16 pm - IP Logged

    Sounds good.

    Been tied up with a lot of out door projects lately and not for much anything else.

    Best of luck again.

    Thanks, Jade! Smile

    Don't ever grow up, it's a trap!

      lakerben's avatar - spherewall
      New Mexico
      United States
      Member #86099
      January 29, 2010
      11116 Posts
      Offline
      Posted: June 28, 2016, 7:50 pm - IP Logged

      Thanks, Jade. Hope the same for you :-) Bigger hit!

      I did not have anytime today so I am playing some of the picks from last time from "disimulate" and "metermademoves" of course I changed the mega Ball.. We will see..Smile

      Good luck!

      How about them cowboys!

       

       

      US Flag

        retxx's avatar - mrthumbs
        BOSTON
        United States
        Member #48
        September 9, 2001
        3584 Posts
        Offline
        Posted: June 29, 2016, 8:56 pm - IP Logged

        well jade I opened the desimulate entered the last 2 pick 4 and hit select. Nothing happened. Yes my macros are enbled. What next?Banana

          JADELottery's avatar - MeAtWork 03.PNG
          The Quantum Master
          West Concord, MN
          United States
          Member #21
          December 7, 2001
          3675 Posts
          Offline
          Posted: June 30, 2016, 10:54 am - IP Logged

          well jade I opened the desimulate entered the last 2 pick 4 and hit select. Nothing happened. Yes my macros are enbled. What next?Banana

          Presented 'AS IS' and for Entertainment Purposes Only.
          Any gain or loss is your responsibility.
          Use at your own risk.

          Order is a Subset of Chaos
          Knowledge is Beyond Belief
          Wisdom is Not Censored
          Douglas Paul Smallish
          Jehocifer

            Avatar
            New Member
            ga
            United States
            Member #175056
            May 27, 2016
            1 Posts
            Offline
            Posted: June 30, 2016, 1:54 pm - IP Logged

            i don't understand it

              retxx's avatar - mrthumbs
              BOSTON
              United States
              Member #48
              September 9, 2001
              3584 Posts
              Offline
              Posted: July 1, 2016, 9:20 am - IP Logged

              I corrected it and still nothing when i hit select.

                retxx's avatar - mrthumbs
                BOSTON
                United States
                Member #48
                September 9, 2001
                3584 Posts
                Offline
                Posted: July 1, 2016, 2:44 pm - IP Logged

                How do i make room to add the latest draws to EFGH?thanks

                  JADELottery's avatar - MeAtWork 03.PNG
                  The Quantum Master
                  West Concord, MN
                  United States
                  Member #21
                  December 7, 2001
                  3675 Posts
                  Offline
                  Posted: July 7, 2016, 8:42 am - IP Logged

                  How do i make room to add the latest draws to EFGH?thanks

                  This is setup to work with 1500 draws.

                  Many more than that would take too long to analyze and calculate selections.

                  Also, if we make it with lots of draw analysis, the file gets very large.

                  Trim down to less than 1500.

                  Statistically, you'll only need around 1500 draws.

                  Presented 'AS IS' and for Entertainment Purposes Only.
                  Any gain or loss is your responsibility.
                  Use at your own risk.

                  Order is a Subset of Chaos
                  Knowledge is Beyond Belief
                  Wisdom is Not Censored
                  Douglas Paul Smallish
                  Jehocifer

                    RJOh's avatar - chipmunk
                    mid-Ohio
                    United States
                    Member #9
                    March 24, 2001
                    19816 Posts
                    Offline
                    Posted: July 8, 2016, 1:59 pm - IP Logged

                    This is setup to work with 1500 draws.

                    Many more than that would take too long to analyze and calculate selections.

                    Also, if we make it with lots of draw analysis, the file gets very large.

                    Trim down to less than 1500.

                    Statistically, you'll only need around 1500 draws.

                    "Many more than that would take too long to analyze and calculate selections."

                    Would the speed of a newer computer with an i7 eliminate that drawback?

                     * you don't need to buy more tickets, just buy a winning ticket * 
                       
                                 Evil Looking       

                      JADELottery's avatar - MeAtWork 03.PNG
                      The Quantum Master
                      West Concord, MN
                      United States
                      Member #21
                      December 7, 2001
                      3675 Posts
                      Offline
                      Posted: July 8, 2016, 2:56 pm - IP Logged

                      "Many more than that would take too long to analyze and calculate selections."

                      Would the speed of a newer computer with an i7 eliminate that drawback?

                      Good idea, but we've run this out on our servers, dual processors at 4 cores a piece or 8 cores with much improvement.

                      Unfortunately, since this is going out to the general public, they may not have the level of processing power like that.

                      We'd look at the sheet from left to right and see how it is setup.

                      You can modify it to accommodate a larger draw size with little change to the sheet.

                      Also, this may require an intermediate or better level of Excel knowledge to get it going.

                      You can copy and paste, but there are some things that need to be properly cell oriented to achieve the proper analysis.

                      This is just an example, but, the only cells for the analysis that need to be change are under the 'Distribution' section.

                      The cell contents in the upper right most of the 'Distribution' might be '=FrequencyCount(E$8:E$1507,$M8)'

                      All you have to change is the 1507 in the '=FrequencyCount(E$8:E$1507,$M8)' to some last row beyond the draw data.

                      If your last row of draw data is on row 4789, then change the 1507 to something like 5007.

                      Then copy and paste the modified cell to the other cells in the 'Distribution' section.

                      That would now cover any future draws you put in out to 5000 draws.

                      Presented 'AS IS' and for Entertainment Purposes Only.
                      Any gain or loss is your responsibility.
                      Use at your own risk.

                      Order is a Subset of Chaos
                      Knowledge is Beyond Belief
                      Wisdom is Not Censored
                      Douglas Paul Smallish
                      Jehocifer

                        Avatar
                        Maryland
                        United States
                        Member #126396
                        April 8, 2012
                        399 Posts
                        Offline
                        Posted: July 8, 2016, 5:52 pm - IP Logged

                        Reading your guys conversation I got a question. Is that really matter how many draws we put in? I mean, I thought the concept was more focusing on last 2 draws and how many samples we want to dissimulate?

                        Thanks!

                        Don't ever grow up, it's a trap!

                          lakerben's avatar - spherewall
                          New Mexico
                          United States
                          Member #86099
                          January 29, 2010
                          11116 Posts
                          Offline
                          Posted: July 15, 2016, 7:21 pm - IP Logged

                          Last 59 draws?

                          How about them cowboys!

                           

                           

                          US Flag

                            Sunglasses's avatar - nicebear
                            Zaperlopopotam
                            Belgium
                            Member #173932
                            March 26, 2016
                            950 Posts
                            Offline
                            Posted: July 17, 2016, 8:45 pm - IP Logged

                             Might have a look at this and program it.

                              JADELottery's avatar - MeAtWork 03.PNG
                              The Quantum Master
                              West Concord, MN
                              United States
                              Member #21
                              December 7, 2001
                              3675 Posts
                              Offline
                              Posted: July 19, 2016, 1:28 pm - IP Logged

                              Last 59 draws?

                              ??

                              Presented 'AS IS' and for Entertainment Purposes Only.
                              Any gain or loss is your responsibility.
                              Use at your own risk.

                              Order is a Subset of Chaos
                              Knowledge is Beyond Belief
                              Wisdom is Not Censored
                              Douglas Paul Smallish
                              Jehocifer

                                 
                                Page 13 of 14