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

Page 4 of 14
4.817
PrintE-mailLink
amber123's avatar - OpIFNim

United States
Member #164727
March 12, 2015
2529 Posts
Online
Posted: July 6, 2015, 9:53 pm - IP Logged

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

After downloading the the file, you may need to enable macros.

So, if you have macros disabled by default, you'll have to enable it when you open the file.

see below.

 

Thank you for replying, but i don't get that warning, i get the one mentioned earlier by me on this thread. Looks interesting though. I wish I knew what I was doing..lol

    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, 2015, 8:37 am - IP Logged

    Thank you for replying, but i don't get that warning, i get the one mentioned earlier by me on this thread. Looks interesting though. I wish I knew what I was doing..lol

    We will rework it a little bit so you don't have to enter the two previous draws.

    However, keep in mind, this is a Mathematics forum.

    The intent of these Excel files are to demonstrate the mathematical functions by example.

    This allows you to examine the usage in Excel and apply it to other lottery data you may have.

    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
      Horwood NL
      Canada
      Member #70613
      February 6, 2009
      296 Posts
      Offline
      Posted: July 7, 2015, 1:57 pm - IP Logged

      JADELottery

      Just downloaded it again to see if I had an error with the download.

      The programs pick 3 section still hangs up (calculation stays at 0%, stops responding ) as soon as I enter a "0" in any location of the 2 lines for entry of the last 2 draws. It runs ok as long as no "0" is entered.

      GW

        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, 2015, 2:45 pm - IP Logged

        JADELottery

        Just downloaded it again to see if I had an error with the download.

        The programs pick 3 section still hangs up (calculation stays at 0%, stops responding ) as soon as I enter a "0" in any location of the 2 lines for entry of the last 2 draws. It runs ok as long as no "0" is entered.

        GW

        Ok, temporary fix till we can correct the function error.

        On the Daily Pick 3 sheet enter the following line into cell W8:

         

        =IF(ISNUMBER(V8),DisimulateNexus($M$8:$M$17,N$8:N$17,W$3,W$4),"")

         

        Then copy cell W8 to all cells W8 through Y1507

        This should fix the hang.

        Also, on the Daily Pick 4 sheet enter the same line in W8 and then copy to all Cells W8 through Z1507.

        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
          Horwood NL
          Canada
          Member #70613
          February 6, 2009
          296 Posts
          Offline
          Posted: July 7, 2015, 5:28 pm - IP Logged

          Ok, temporary fix till we can correct the function error.

          On the Daily Pick 3 sheet enter the following line into cell W8:

           

          =IF(ISNUMBER(V8),DisimulateNexus($M$8:$M$17,N$8:N$17,W$3,W$4),"")

           

          Then copy cell W8 to all cells W8 through Y1507

          This should fix the hang.

          Also, on the Daily Pick 4 sheet enter the same line in W8 and then copy to all Cells W8 through Z1507.

          Fixed pick 3. Didn't work for pick 4.

          GW

            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, 2015, 6:30 pm - IP Logged

            ok, updated the functions.

            download the 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

             

            you shouldn't have to enter the last two draws now.

            we added a last position function to those cells.

            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
              11119 Posts
              Offline
              Posted: July 7, 2015, 8:00 pm - IP Logged

              ok, updated the functions.

              download the 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

               

              you shouldn't have to enter the last two draws now.

              we added a last position function to those cells.

              Thanks jade!

              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 7, 2015, 9:11 pm - IP Logged

                One moment.

                Please standby.

                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 7, 2015, 9:18 pm - IP Logged

                  Ok, now.

                  We tweaked the Daily Pick 3, 4, 5 sections, see below.

                  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
                    11119 Posts
                    Offline
                    Posted: July 8, 2015, 12:10 pm - IP Logged

                    Ok, now.

                    We tweaked the Daily Pick 3, 4, 5 sections, see below.

                    Cool I'll download the file again.

                     

                    Party

                    How about them cowboys!

                     

                     

                    US Flag

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

                      Hi jade wonder if you could do a 5/35 desimulate say for the Mass cash for us who look for the $100,000 jackpot. thanks

                        frenchie's avatar - Lottery-041.jpg
                        Los Angeles
                        United States
                        Member #75410
                        June 2, 2009
                        479 Posts
                        Offline
                        Posted: July 8, 2015, 11:29 pm - IP Logged

                        Hi Jade,

                        CONGRATULATION and Thank you very much for the file and your incredible work.

                        Can you or someone explain in details how to use the file and where are the numbers to play ?

                        I want to make sure I'm doing it right.

                        Thank you.

                        Frenchie.

                          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, 8:09 am - IP Logged

                          We will look at making a basic template sheet you can copy and plug in whatever draws you have.

                          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

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5387 Posts
                            Offline
                            Posted: July 9, 2015, 10:20 am - IP Logged

                            For those want to use just the Pick 3 program I created Excel files where you can select your state and use Jades Excel file for just the Pick 3.

                            Here is the download link to the zip file:

                            https://app.box.com/s/yj6t1a4utc8nfrua4alpmie630bxezsk

                            The zip file contains 2 Excel files.  Place them in a new folder and name the folder whatever you like. Example: Pick3Jade

                            The Excel file P3StateDrawsLS.xlsm needs to be opened 1st.  This Excel file contains all the Pick 3 drawings for all the states.  When this file opens you will see a message box open to change the date.  Disregard and close the message box.

                             

                            Next open the 2nd Excel file "Pick3Disimulate.xlsm" file.

                            I will create a video on how to use both Excel files.

                            I still need to go through this thread and read how to use the data.

                            Thank you Jade for the programs!!

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Offline
                              Posted: July 9, 2015, 10:51 am - 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.

                                 
                                Page 4 of 14