Welcome Guest
Log In | Register )
You last visited December 10, 2016, 2:50 am
All times shown are
Eastern Time (GMT-5:00)

The Wave Matrix - Excel 2007 Addin

Topic closed. 253 replies. Last post 3 years ago by MillionsWanted.

Page 3 of 17
510
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: October 23, 2012, 9:32 am - IP Logged

UWP hint:

You might think there are a lot of lines of code for the Ultimate Wave Predictor.

Nope.

There are only 4 lines of code.

This includes the ' Return ' statement the performs a simple division when returning the predicted value.

As matter of fact, now that we think about it, it could be reduced to 3... hmmm...

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: October 24, 2012, 9:50 am - IP Logged

    UWP hint:

    You might think there are a lot of lines of code for the Ultimate Wave Predictor.

    Nope.

    There are only 4 lines of code.

    This includes the ' Return ' statement the performs a simple division when returning the predicted value.

    As matter of fact, now that we think about it, it could be reduced to 3... hmmm...

    We got it down to 3 lines of code; includes a variable declaration, a For loop, and a Return statement.

    If we have time, we will get to the equation set evolution of the UWP.

    We're finishing the sewing on our Star Trek uniform coat for this weekend's Halloween party.

    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

      MillionsWanted's avatar - 24Qa6LT

      Norway
      Member #9517
      December 10, 2004
      1272 Posts
      Online
      Posted: November 12, 2012, 6:16 pm - IP Logged

      The national lottery company is going to allow players to bet on which number is drawn first from the machine.

      Here's a chance for your addin to show its capabilities.

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

        The national lottery company is going to allow players to bet on which number is drawn first from the machine.

        Here's a chance for your addin to show its capabilities.

        oo-oo, don't break it.


        ggoooodd lluucckk.

         

        Naughty

        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: November 14, 2012, 1:40 pm - IP Logged

          Beeeen tryin' somethin'.

          We're postin' on der perdic'shens bird using this somethin' fir MN Northstar Cash and Gopher 5.

          It's related to ftp://www.jadexcode.com/Excel/CombinatorialIndex.xls and we'll detail somem'er laterrr.

          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

            SergeM's avatar - slow icon.png
            Economy class
            Belgium
            Member #123700
            February 27, 2012
            4035 Posts
            Offline
            Posted: November 14, 2012, 7:59 pm - IP Logged

            Great functions! For Fact() I get in the worksheetfunction.

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

              Beeeen tryin' somethin'.

              We're postin' on der perdic'shens bird using this somethin' fir MN Northstar Cash and Gopher 5.

              It's related to ftp://www.jadexcode.com/Excel/CombinatorialIndex.xls and we'll detail somem'er laterrr.

              ok, here's what we are doing with the above CombinatorialIndex.xls file.

              this addin and the functions in the file are two different things.

              you'll need both to do this.

              we'll use Gopher 5 (31 / 5) as an example.

              download the CombinatorialIndex.xls spread sheet; it has macro functions for generating the Index number of a combination and making a combination from an Index number.

              The Index number is like the following for Gopher 5:

              Index - Combination

              1 - 01 02 03 04 05

              2 - 01 02 03 04 06

              3 - 01 02 03 04 07

              ...

              169909 - 26 27 29 30 31

              169910 - 26 28 29 30 31

              169911 - 27 28 29 30 31

               

              we have some capture software that can download Gopher 5 numbers right from the Lottery Post.

              we loaded the numbers in the spreadsheet and sorted them with oldest draws at the top of the sheet and newest draws at the bottom.

              in our latest posted numbers, we used just this year's draws from Jan-01 to now, Nov-14.

              we'll post just this months combos with the index numbers.

              MonthDayYearComboIndex
              11120121115162023152069
              1122012610131518109847
              113201221321222747936
              114201231219222767495
              11520121821242830168375
              1162012520222528103699
              1172012520272831103794
              118201211417262724647
              1192012617242731115739
              1110201211821242626544
              1111201211417232924631
              11122012610131430109843
              111320125923242796735
              111420123812242761782

              the Index number is generated with the function =Combin2Index(31,5,??:??), where ??:?? is the range for the single combo you are looking for; usually it's the range in the same line as the combo.

              like the last line for Nov-14, 3 8 12 24 27 has an Index number of 61782.

              next we use the Excel Addin to analyze the Index numbers and project the regression, waves, and remainder to the next possible Index number.

              we do this by setting the Regression to Linear, Waves to 12, BMA Iteration to 12, the Wave / BMA ratio to 0.70, the Amp / Freq ratio to 0.25 and using the Quantum setting with a Depth and Level at 25 for the Ultimate Wave Predictor.

              Press the Generate Wave Matrix button and POOF!! There it is.

              next we go to the Quantum Projection line and just after the last column we enter this function:

              =Index2Combin(31,5,INT(MOD(???-1,COMB(31,5)))+1), where ??? is the cell just to the left.

              it's the Data column with the Quantum Projected Index number for the next drawing.

              finally, we copy the entire Quantum Projection line and paste it 49 more times just under the Quantum Projection line.

              this gives us 50 numbers to post, but you can choose how many you'd like to generate.

              this is what it would look like, but keep in mind these combos are different from the ones we posted because they are recalculated each time we do something on the spreadsheet.

              we're just posting the Data and Combo columns. problems with formatting when posting.

              66960.8753103 12 14 16 21
              41374.7596402 08 13 16 25
              81069.9863104 09 14 16 19
              96513.9116805 09 18 25 29
              7943.13601701 04 08 14 26
              72396.0911604 05 08 20 22
              9089.64010201 04 14 18 23
              122903.37307 12 15 19 29
              81069.9863104 09 14 16 19
              121826.067707 11 14 20 30
              110275.574906 10 16 19 31
              16776.6928201 07 28 29 30
              6921.54934301 03 27 28 29
              20563.6312801 10 13 22 26
              123061.704407 12 16 25 31
              137375.448409 10 20 21 24
              44048.8504902 10 12 13 30
              66960.8753103 12 14 16 21
              93958.2531805 08 11 12 24
              86919.2357304 15 17 18 31
              57133.2412503 06 08 19 20
              8807.9769501 04 12 18 30
              73518.5256904 05 14 23 26
              160996.154113 20 26 27 30
              115847.638306 18 20 21 22
              141389.147309 15 17 28 30
              149290.991410 21 23 27 31
              120411.091607 10 12 22 25
              33591.3865802 04 26 28 29
              75379.1285504 06 11 26 29
              10418.2641301 05 07 26 28
              15774.0037101 07 12 22 31
              143719.185510 11 12 23 30
              -21530.777710 17 20 25 30
              43291.463202 09 16 17 27
              80081.3015204 08 19 24 27
              97630.7144205 10 16 20 25
              21429.8265901 11 12 13 22
              101882.507805 15 17 20 21
              17863.3841601 08 14 27 30
              43531.2557502 09 18 24 28
              90683.6123505 06 14 16 18
              7674.36847201 04 07 13 27
              64181.1147403 09 21 25 31
              83530.6424304 11 14 15 25
              156911.004112 16 27 28 31
              90834.4509305 06 15 18 22
              32227.6656302 04 10 21 27
              27886.3474502 03 05 11 26
              98224.3990505 11 12 17 29

              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: November 14, 2012, 9:23 pm - IP Logged

                Great functions! For Fact() I get in the worksheetfunction.

                great.

                be careful with Fact() though.

                it's level of precision is only as good as the level of precision that Excel is capable of handling.

                numbers beyond 20 don't carry out the digits completely in Excel.

                they tend to get dropped at 15 digits followed by only zeros.

                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

                  SergeM's avatar - slow icon.png
                  Economy class
                  Belgium
                  Member #123700
                  February 27, 2012
                  4035 Posts
                  Offline
                  Posted: November 15, 2012, 6:51 am - IP Logged

                  I programed factorial in several ways. The last version was the same than yours.

                  factorial functions

                    lakerben's avatar - spherewall
                    New Mexico
                    United States
                    Member #86099
                    January 29, 2010
                    11119 Posts
                    Offline
                    Posted: November 15, 2012, 10:58 pm - IP Logged

                    Thumbs Up

                    How about them cowboys!

                     

                     

                    US Flag

                      MillionsWanted's avatar - 24Qa6LT

                      Norway
                      Member #9517
                      December 10, 2004
                      1272 Posts
                      Online
                      Posted: November 16, 2012, 3:43 am - IP Logged

                      Thanks.

                       Type I'll see if I can adapt this for the pick-6 and pick-7 lotteries in my country.

                        SergeM's avatar - slow icon.png
                        Economy class
                        Belgium
                        Member #123700
                        February 27, 2012
                        4035 Posts
                        Offline
                        Posted: November 16, 2012, 12:11 pm - IP Logged

                        My sort does it.

                          SergeM's avatar - slow icon.png
                          Economy class
                          Belgium
                          Member #123700
                          February 27, 2012
                          4035 Posts
                          Offline
                          Posted: November 16, 2012, 12:31 pm - IP Logged

                          A bit more sophisticated.

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

                            well, kind of messed that up.

                            was posting Northstar Cash numbers, but put them in the Gopher 5 slot.

                            these are suppose to be the Gopher 5 numbers.

                            19 20 25 28 44
                            03 09 20 27 39
                            14 31 32 34 45
                            07 10 25 30 34
                            13 18 22 27 40
                            07 17 27 41 47
                            10 11 18 32 33
                            09 11 30 43 44
                            14 36 38 43 45
                            20 22 24 29 40
                            05 06 09 20 27
                            11 13 22 23 29
                            10 11 20 41 46
                            14 36 38 43 45
                            12 20 26 41 44
                            12 17 19 28 42
                            02 05 12 27 31
                            01 07 14 21 43
                            02 13 18 23 36
                            12 13 14 23 42
                            02 26 29 33 35
                            11 13 19 46 47
                            08 10 13 27 31
                            04 10 24 31 45
                            09 12 13 27 37
                            04 07 12 15 28
                            08 09 10 35 40
                            25 29 32 36 38
                            03 17 22 26 45
                            04 12 28 31 33
                            17 18 25 31 39
                            08 21 22 34 35
                            19 26 30 36 41
                            02 20 23 31 38
                            20 28 36 37 42
                            03 09 32 37 47
                            02 03 24 35 44
                            11 13 20 39 40
                            09 38 42 45 47
                            10 20 28 38 43
                            10 16 28 35 39
                            06 11 20 29 38
                            12 16 18 28 36
                            13 23 27 39 45
                            13 21 22 38 43
                            09 23 27 32 38
                            08 14 22 23 26
                            14 27 28 32 47
                            13 21 28 30 45
                            04 22 37 39 44

                            oh well, i'll start this cycle over again monday.

                            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: November 18, 2012, 9:08 am - IP Logged

                              posting some numbers for Mega Millions on the predictions board.

                              to have a quick look see, we post 'em below.

                              this is for 2012-11-20

                              08 17 22 25 4741
                              05 09 20 27 3724
                              02 09 22 35 4432
                              02 14 20 32 3643
                              08 15 36 41 4535
                              06 17 35 44 5642
                              12 17 30 38 5225
                              08 13 14 28 3843
                              04 08 14 30 3446
                              05 20 35 39 5242
                              05 11 26 42 5529
                              03 13 28 49 553
                              06 10 11 30 3145
                              07 14 35 37 4039
                              05 17 19 44 4822
                              03 07 15 40 525
                              08 13 21 37 534
                              12 14 35 52 5636
                              07 13 40 42 5328
                              12 15 32 36 5313
                              02 12 17 22 3445
                              04 06 13 18 5331
                              13 20 44 50 514
                              12 24 25 36 5432
                              05 08 14 19 315
                              11 17 25 36 4728
                              03 04 07 11 3433
                              15 16 24 52 5444
                              11 25 30 33 5419
                              07 39 44 51 5232
                              08 11 14 15 2234
                              07 09 29 39 493
                              09 16 31 32 3829
                              16 31 33 36 488
                              14 17 26 29 5243
                              02 06 15 48 5417
                              05 08 14 19 311
                              09 19 25 35 3629
                              07 09 18 34 423
                              22 27 35 55 569
                              01 15 37 51 5224
                              12 15 32 36 5322
                              03 04 09 45 5331
                              07 36 40 50 5535
                              04 09 11 12 1533
                              09 17 20 24 3913
                              01 24 26 31 494
                              07 16 32 51 5536
                              06 09 33 34 5644
                              08 18 21 40 5532

                              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 3 of 17