Welcome Guest
Log In | Register )
You last visited December 4, 2016, 7:09 am
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 2 days ago by JADELottery.

Page 5 of 14
4.817
PrintE-mailLink
JADELottery's avatar - MeAtWork 03.PNG
The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
Posted: July 9, 2015, 5:40 pm - IP Logged

Youtube video on how to use both Excel files:

https://www.youtube.com/watch?v=Dvk1C_ECKy0

 

You will need either Excel version 2007 or 2010 in order to use.  Not sure about 2013 version.

Very nice presentation.

We're tweaking a few things in programming and sheet layout.

The sheet layout is not changing much.

The programming is a different story; trying to cover it all is a hair pulling task.

The Select→ button picks numbers using the =Disimulate(Number, Distribution) function.

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

    retxx's avatar - mrthumbs
    BOSTON
    United States
    Member #48
    September 9, 2001
    3584 Posts
    Offline
    Posted: July 9, 2015, 8:53 pm - IP Logged

    thanks jade,will wait for you to do the link to use in a 5/35 for Mass cash.

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

      thanks jade,will wait for you to do the link to use in a 5/35 for Mass cash.

      Alright, there is an example Disimulate Pick 5 Excel file out there.

      http://www.jadexcode.com/files/excel/disimulate-pick5-0.xlsm

      or

      ftp://www.jadexcode.com/excel/disimulate-pick5-0.xlsm

      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

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

        ok, tweaked the functions a bit.

        download them using the same links.

        http://www.jadexcode.com/files/excel/disimulate-mm-pb-hb-dp-0.xlsm

        or

        ftp://www.jadexcode.com/excel/disimulate-mm-pb-hb-dp-0.xlsm

        at some point we will have to break these up into separate files.

        the algorithms are processor intense on first open of the files.

        we'll add more later... need sleep.

        Sleep

        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

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

          Alright, we created a Pick 6 file.

          http://www.jadexcode.com/files/excel/Disimulate-Pick6-0.xlsm

          ftp://www.jadexcode.com/excel/Disimulate-Pick6-0.xlsm

           

          Also, we fixed a minor error in the Pick 5 file.

          http://www.jadexcode.com/files/excel/Disimulate-Pick5-0.xlsm

          ftp://www.jadexcode.com/excel/Disimulate-Pick5-0.xlsm

           

          We will be making a Pick 5 + Pick 1 for games like Mega Millions, Powerball and Hot Lotto.

          In addition, Daily Pick 3, 4 and 5 will have separate files.

          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

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

            Thanks jade!

             

            Party

            How about them cowboys!

             

             

            US Flag

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

                We've made, we hope, some final tweaks to the files.

                We will get to the file descriptions later.

                Also, we will post the VBA source code in a text format on our server so you can look it over and possibly adapt to other platforms.

                Wink

                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

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

                  here's the source.

                  http://www.jadexcode.com/files/text/JADExcelNexusModule1.txt

                  http://www.jadexcode.com/files/text/JADExcelNexusModule2.txt

                  http://www.jadexcode.com/files/text/JADExcelNexusModule3.txt

                  http://www.jadexcode.com/files/text/JADExcelNexusModule4.txt

                  http://www.jadexcode.com/files/text/JADExcelNexusModule5.txt

                  you will have to place all modules in separate module files because the coding is very large.

                  Cool

                  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

                    lakerben's avatar - spherewall
                    New Mexico
                    United States
                    Member #86099
                    January 29, 2010
                    11116 Posts
                    Offline
                    Posted: July 11, 2015, 1:30 pm - IP Logged
                      JADELottery's avatar - MeAtWork 03.PNG
                      The Quantum Master
                      West Concord, MN
                      United States
                      Member #21
                      December 7, 2001
                      3675 Posts
                      Offline
                      Posted: July 11, 2015, 8:39 pm - IP Logged

                      Each of the files allow you to enter draws.

                      For Daily Pick 3, Pick 4 and Pick 5 enter each in the Draws section up to 1500 draws.

                            

                       

                      The other games like Pick 5, Pick 6; Mega Millions, Powerball, Hot Lotto that are Pick 5 + Pick 1 you need to set the Pool size.

                         

                       

                      Continues...

                      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

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

                        Each of the files also have a Disimulate and Distribution section.

                        The word Disimulate is derived from Distribution Simulate function or to simulate a distribution.

                        All Disimulate calculations are basically the same for each of the games.

                        The Disimulate function randomly select numbers in each column independently using the current Distribution of the Draws.

                        The function tends to select number based on its own natural frequency.

                        It means high frequency numbers are selected more often and low frequency numbers less; all at random.

                        In the example chart below, the Disimulate calculation is the black line pointed to by the 0.

                        Each Disimulate number is flanked by a +1 and -1 above and below.

                        The +1/-1 numbers wrap around 9 to 0 and 0 to 9 like in column B.

                        To get a new sample of the Disimulate function, press the Select.

                         

                        In the case of this Pick 5 example, you'll see that 14 is selected in column D.

                        Now, that seems weird considering there is a 21 in column C.

                        That's alright because each column is being selected independently of each other.

                        The Disimulate function works to simulate each column.

                         

                        Here's an example of a Mega Millions / Powerball type game.

                        Column A - E are the Pick 5 section and column F is the Pick 1 part.

                        Continues...

                        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

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

                          In this next section we will look at the DisimulateNexus function.

                          The DisimulateNexus is derived from the words Disimulate and Nexus.

                          The Nexus part means to form a connection.

                          In this case, we are connecting: Past, Present and Future in a sum of the three.

                          Part of this is related to the Power Mega Balls with Three Sum Math topic we posted also.

                          The current distribution is passed through the ThreeSum() function to generate a number at random.

                          In this way, the three sum is a reflection of the lottery's own randomness.

                          Below is a Pick 3 example.

                          The last two draws are populated in the upper left from the current draws.

                          Below the last two draws is a samples list of DisimulateNexus selections.

                          To change the number of samples, enter up to 1500 as indicated.

                          Increasing the sample value increases the accuracy, but reduces the precision.

                          Decreasing the sample value decreases the accuracy, but increases the precision.

                          This is consistent with the Uncertainty Principle and is why we call this a Quantum Mechanical Selector.

                          This simulation produces its own distribution and is not like the Draws distribution.

                          It is biased based on the last two draws and the ThreeSum() function.

                          Next to the DisimulateNexus samples is the Standard distribution of the samples.

                          To equalize the differences in frequency in the distribution we Normalized the distribution.

                          The Normalization puts the distribution on a value scale from 0.00 to 1.00 for each column.

                          The highest frequency numbers are near 1 and the low frequency numbers are near 0.

                          The Red Box Threshold highlights those Normalized values that are at the Red Box Threshold or above; valid values are 0.00 to 1.00.

                          In addition to the Normalized distribution, there are Inverted values and a Folded variation of the same distribution.

                          The Inverted values are a mirror of the Normalized values.

                          High frequency numbers are shifted to low and low frequency numbers become high.

                          The Folded values are like what it seems.

                          The low and high frequency numbers are folded to be high frequency and the average frequency numbers are moved to low frequency.

                          Essentially, what most would call Hot and Cold numbers are moved to high frequency.

                          Also, like the Standard, the Folded values can be inverted so the average numbers are the high frequency and the Hot / Cold numbers are low frequency.

                          Continues...

                          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

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

                            This next part looks at the Pick 5, Pick 6 type and the Pick 5 + Pick 1 type games.

                            Below we see the Draw distribution and the DisimulateNexus sample set with its distribution.

                            The DisimulateNexus selects a number at random in each column independently based on the current distribution and the previous two draws.

                            Again, the samples generate a distribution that is not like the Draws distribution.

                            It is biased, but best of all, the DisimulateNexus can fill in the gaps that can appear in the Draws distribution.

                            If you look at number 16 in column A, we see there was no number 16 selected in the draws, but it's starting to show up in the DisimulateNexus.

                            Also, 16 is Red Boxed in column A.

                            The Red Box Threshold is multiplied to the maximum frequency in each column which is displayed at the top of each column.

                            This multiplied threshold and max frequency set the value for the Red Box highlight.

                            Any number equal to or greater is Red Boxed.

                            We are looking at a Normalization for these also, but that will be in a future update.

                               

                             

                            Here we see a Pick 5 + Pick 1 type game.

                               

                            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

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

                              Youtube video on how to use both Excel files:

                              https://www.youtube.com/watch?v=Dvk1C_ECKy0

                               

                              You will need either Excel version 2007 or 2010 in order to use.  Not sure about 2013 version.

                              Let's see if this will embed.

                              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 5 of 14