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

Power Mega Balls with Three Sum Math

Topic closed. 167 replies. Last post 2 months ago by Sunglasses.

Page 5 of 12
4.713
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: June 11, 2015, 6:27 am - IP Logged

Hi jade!

I downloaded it and even though I enabled macros in both excel and open office I can't get it to work

It shows # # # in all the rundowns

Do you or anyone else know what I could try?

thanks!

Try downloading it again.

We just checked and tested again this morning.

It's working on our Excel 2007; on every page.

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: June 11, 2015, 12:04 pm - IP Logged

    Thanks a million!

    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: June 11, 2015, 12:10 pm - IP Logged

      Thanks a million!

      Party

      Wink

      Remember, that Million is all your's.

       

      Spend wisely.

       

      Good luck.

      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

        RL-RANDOMLOGIC's avatar - usafce

        United States
        Member #59354
        March 13, 2008
        3971 Posts
        Offline
        Posted: June 11, 2015, 7:57 pm - IP Logged

        Jade

        I am getting close, this version predicts the lexie values.  The program allows the user to adjust the

        number of games to run from 2 to 15.  Still need to do a few minor tweaks and then backtest but so

        far it looks interesting.

        RLsums

        Working on my Ph.D.  "University of hard Knocks"

        I will consider the opinion that my winnings are a product of chance if you are willing to consider

        they are not.  Many great discoveries come while searching for something else

        USAF https://en.wikipedia.org/wiki/Prime_Base_Engineer_Emergency_Force

          US Flag Trump / 2016 & 2020  

          kreative1's avatar - flower2
          NE PA
          United States
          Member #127838
          May 10, 2012
          1230 Posts
          Offline
          Posted: June 11, 2015, 10:32 pm - IP Logged

          Try downloading it again.

          We just checked and tested again this morning.

          It's working on our Excel 2007; on every page.

          I found out that my vba thingy wasn't installed

          Now it works great!

          wooohooo!

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

            I found out that my vba thingy wasn't installed

            Now it works great!

            wooohooo!

            Ok, great.

            I tend to forget that one.

            We do it immeadiately when we setup Excel.

            FYI: You can see the code pages by pressing Alt + F11.

            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: June 12, 2015, 7:45 am - IP Logged

              Jade

              I am getting close, this version predicts the lexie values.  The program allows the user to adjust the

              number of games to run from 2 to 15.  Still need to do a few minor tweaks and then backtest but so

              far it looks interesting.

              RLsums

              Looks good.

              Glad to see you're making progress.

              We're still working a genralized solution for any Pick and Pool size.

              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

                RL-RANDOMLOGIC's avatar - usafce

                United States
                Member #59354
                March 13, 2008
                3971 Posts
                Offline
                Posted: June 12, 2015, 8:46 am - IP Logged

                Jade

                This version can handle up to 13 digits and I had to add the ability to adjust the number of games.

                When working with single digits a 3-game sum does not seem to work very well.  Still working on

                adapting your function for use.  Last night I used it for my 5-39 and only hit 2 of the 6 digits. 

                RL

                Working on my Ph.D.  "University of hard Knocks"

                I will consider the opinion that my winnings are a product of chance if you are willing to consider

                they are not.  Many great discoveries come while searching for something else

                USAF https://en.wikipedia.org/wiki/Prime_Base_Engineer_Emergency_Force

                  US Flag Trump / 2016 & 2020  

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

                  What's to be said next is intended for those trained in the Quantum Arts.

                  If you'd like to watch, Great.

                   

                  Those of you that know Quantum Mechanics are aware of the Wave Collapse.

                  Here we will show the Wave Collapse.

                  We ran samples from 1,000,000 to 1.

                  As you can see in the charts below, the High sample chart is smooth like a probability function.

                  When the samples are reduced to 1, we collapse to a single state.

                  Keep in mind we used no Schrödinger equation to do this.

                  1,000,000 Samples

                  100,000 Samples

                  10,000 Samples

                  1,000 Samples

                  100 Samples

                  10 Samples

                  1 Sample

                   

                  Heisenberg Compensator here we come.

                  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: June 16, 2015, 9:58 am - IP Logged

                    Added some color to our tables.

                    The lighter the color, the higher the sampled frequency.

                    The highest frequent numbers are boxed in red.

                    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 1, 2015, 3:56 pm - IP Logged

                      Can you do a sheet for p3?

                      Also, can you do one for a p5 game where the user can change the upper limit to any value: 34,35,36,37 etc?  As a result, it can be used by different states? Thanks for everything!

                       

                      Big Smile

                      testing is underway for a sums function that can handle a pool size 1 to 99 and a pick size 1 to 99.

                      we were able to compress 1,078,336,239,053,809,219,328,449,283,217,656,191,958,500,366,020,094,576,880,090,461,469,964,452,641,827,581,764,055 possible computations down to about 172,000.

                      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 1, 2015, 7:15 pm - IP Logged

                        testing is underway for a sums function that can handle a pool size 1 to 99 and a pick size 1 to 99.

                        we were able to compress 1,078,336,239,053,809,219,328,449,283,217,656,191,958,500,366,020,094,576,880,090,461,469,964,452,641,827,581,764,055 possible computations down to about 172,000.

                        Nice work!

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

                          Nearly there.

                          Few last minute tweaks.

                          listening to this while we're jammin' and programmin': https://soundcloud.com/missmelera/miss-melera-at-fusion-festival-de-26062015

                          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

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

                            Ok, it's out there under a new file.

                            Please be patient when enabling the macros.

                            The new algorithms take a bit longer.

                            You can move through the sheets while it's calculating.

                            Occasionally stop your activity on the sheet and check the lower right corner of Excel for the Calculating update.

                             

                            http://www.jadexcode.com/files/excel/threesums-02.xlsm

                            or

                            ftp://www.jadexcode.com/excel/threesums-02.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 2, 2015, 2:16 am - IP Logged

                              We added a bit to the Daily section.

                               

                              There is an example sheet of extending to other lottery pool and pick sizes.

                               

                              And, just a tweak to the other sheets with the new algorithms.

                              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 12