Welcome Guest
Log In | Register )
You last visited January 16, 2017, 7:51 am
All times shown are
Eastern Time (GMT-5:00)

What Excel version are you using?

Topic closed. 45 replies. Last post 4 years ago by JADELottery.

Page 2 of 4
4.86
PrintE-mailLink

What Excel version are you using?

2010 [ 17 ]  [50.00%]
2007 [ 12 ]  [35.29%]
2003 [ 4 ]  [11.76%]
'97 or less [ 1 ]  [2.94%]
Total Valid Votes [ 34 ]  
Discarded Votes [ 3 ]  
SergeM's avatar - slow icon.png
Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
Posted: October 1, 2012, 7:27 am - IP Logged

How were the results of the program?

    JADELottery's avatar - Inky Move-01.gif
    The Quantum Master
    West Concord, MN
    United States
    Member #21
    December 7, 2001
    3680 Posts
    Offline
    Posted: October 1, 2012, 7:35 am - IP Logged

    How were the results of the program?

    We posted the link to the program.

    It can be found at a few localtions.

    The first one we posted is http://www.jadexcode.com/downloads/thewavematrix.zip

    another is http://www.jadexcode.com/downloads/thewavematrix.exe that one is a self extracting zip.

    or you can try our ftp site ftp://www.jadexcode.com/Applications/TheWaveMatrix/

    keep this in mind, it's an older VB6 program; limited to only 1500 data samples and 8 wave components.

    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
      bgonçalves
      Brasil
      Member #92564
      June 9, 2010
      2133 Posts
      Offline
      Posted: October 1, 2012, 2:53 pm - IP Logged

      Hello, jade, my lottery is 60/6
      Example = 02,24,28,35,45,59
      How do I put a set of numbers
      Gotta take the draws of 60/6?
      I have to import the file sweepstakes lottery? thank you

        JADELottery's avatar - Inky Move-01.gif
        The Quantum Master
        West Concord, MN
        United States
        Member #21
        December 7, 2001
        3680 Posts
        Offline
        Posted: October 1, 2012, 3:37 pm - IP Logged

        Hello, jade, my lottery is 60/6
        Example = 02,24,28,35,45,59
        How do I put a set of numbers
        Gotta take the draws of 60/6?
        I have to import the file sweepstakes lottery? thank you

        The old program was a test.

        If you are going to put in something, it need to be a value that would be draw to draw.

        Example, you had these draws:

         Column
        IndexABCDE
        1920262846
        21520223135
        31719243346
        41419212333
        51114183640
        61429313539
        71314203031
        846202343
        91112414446
        101018212436
        112381138
        12812194044
        13817242634
        1417131429
        15916314647
        1678112845
        1714113437
        181323354142
        19332364142
        20811124347
        21712142140
        2256102146
        2312192939
        24817213741
        252483146
        26712142230
        27927313344
        28214183031
        29317242632
        301227293345
        31114214446
        3225192047
        331224334247
        341516172747
        35925363842
        36711244044
        371321273044
        38921263335
        39214232642
        402432374247

        You would use only one column at a time to paste into The Wave Matrix program, like column C.

        Shown below is the output table by pasting column C.

        IndexDataRegressionOscillationWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8Wave 9Wave 10Remainder
        12620.30615.69394.288820.866070.289190.127960.06110.030820.015520.007660.003680.001130.00196
        22220.41221.58783.0128-0.4546-0.39347-0.27688-0.15075-0.07757-0.03838-0.01835-0.00849-0.0024-0.0041
        32420.518293.481712.367830.235510.369370.264680.135940.063690.027840.011330.004210.001060.00026
        42120.624390.375611.34752-0.93621-0.190740.003770.042840.039810.028280.017790.01040.003250.00891
        51820.73049-2.730491.40693-1.70614-0.98897-0.65697-0.37269-0.20224-0.10559-0.05353-0.02653-0.00778-0.01696
        63120.8365910.163413.717622.529371.745331.105930.558920.269960.127240.059110.027190.007710.01503
        72020.94268-0.942682.65674-1.63867-1.08612-0.53756-0.2117-0.07994-0.02944-0.01059-0.0037-0.0009-0.0008
        82021.04878-1.048783.71157-1.21111-1.49293-1.02891-0.53206-0.26057-0.12455-0.05878-0.02752-0.00787-0.01604
        94121.1548819.845126.578886.686843.334221.748910.804520.371040.171690.079660.037020.010550.02179
        102121.26098-0.260980.97772-0.18873-0.32934-0.2926-0.18697-0.10979-0.06134-0.03322-0.01763-0.00531-0.01378
        11821.36707-13.3671-4.28101-5.0844-2.30513-1.05247-0.41257-0.15667-0.05617-0.01796-0.0043-0.000690.0043
        121921.47317-2.47317-3.22067-0.468120.448930.415080.218420.095290.035010.009670.00059-0.00036-0.00702
        132421.579272.42073-1.764121.634971.15830.668630.340020.178670.09550.05120.027330.008260.02197
        141321.68537-8.68537-2.49166-1.7128-1.5906-1.29015-0.76262-0.41264-0.21314-0.10731-0.05323-0.0156-0.03561
        153121.791469.20854-0.718283.799192.697661.696230.871960.436810.216320.106490.052230.015240.03468
        161121.89756-10.8976-4.0401-3.73116-1.68321-0.76873-0.33532-0.16133-0.08306-0.04418-0.02371-0.00719-0.01957
        171122.00366-11.0037-2.69905-4.12501-2.33475-1.13461-0.45319-0.17307-0.06226-0.02009-0.005-0.000860.00424
        183522.1097612.890243.878685.310682.140170.951820.377710.148520.056640.020250.006320.0014-0.00194
        193622.2158513.784153.912295.955282.301090.960760.371570.15280.067190.031420.015430.004520.01181
        201222.32195-10.322-3.3665-2.71387-1.92481-1.17109-0.58497-0.28709-0.14022-0.0684-0.03334-0.00971-0.02195
        211422.42805-8.42805-7.02188-2.24867-0.24510.317880.313780.207220.119090.063930.0330.009820.02289
        221022.53415-12.5342-8.19264-2.48365-0.88306-0.45943-0.23988-0.12952-0.06965-0.03692-0.01928-0.00577-0.01434
        231922.64024-3.64024-6.286111.304160.885490.337960.091110.019920.003320.000650.000620.000230.0024
        242122.74634-1.74634-6.038261.71181.289090.70360.323010.147510.066650.029490.012650.003470.00465
        25822.85244-14.8524-8.06489-3.6583-1.70698-0.84328-0.35072-0.1414-0.05549-0.02104-0.00756-0.00187-0.00091
        261422.95854-8.95854-5.51592-1.755-0.81799-0.43518-0.21168-0.10735-0.05566-0.029-0.01504-0.00449-0.01123
        273123.064637.93537-0.748283.849052.269261.320020.648120.312270.149220.071090.033830.009750.02102
        281823.17073-5.17073-0.97935-1.09133-1.23391-0.88976-0.48374-0.24865-0.12437-0.0613-0.02996-0.00873-0.01963
        292423.276830.723170.411860.34853-0.08124-0.043150.007380.022210.020560.014760.009440.003030.0098
        302923.382935.617071.405242.029021.105080.61530.279110.118280.046430.016290.004570.0009-0.00315
        312123.48902-2.48902-0.19164-1.23309-0.61844-0.29359-0.11639-0.04052-0.009880.000920.003610.001450.00854
        321923.59512-4.59512-0.24523-1.93489-1.05088-0.6254-0.33741-0.18407-0.10032-0.0544-0.02931-0.00888-0.02432
        333323.701229.298782.214142.430311.846261.281410.716960.386640.204290.106540.055030.016410.04079
        341723.80732-6.807321.32551-2.71024-2.12505-1.4945-0.84239-0.457-0.24274-0.12709-0.06577-0.01963-0.04842
        353623.9134112.086594.198283.175371.947861.25060.695780.382460.206980.110270.05790.017380.04371
        362424.01951-0.019512.8579-0.66492-0.70746-0.6122-0.38906-0.22809-0.12789-0.06975-0.03732-0.01128-0.02945
        372724.125612.874392.54613-0.312410.162470.19480.123040.070450.03960.022260.012510.003850.01168
        382624.231711.768292.51709-1.10722-0.085890.159040.134010.078620.040220.018970.008370.002330.00276
        392324.3378-1.33783.71575-2.26307-1.35163-0.76164-0.36227-0.17009-0.07904-0.03634-0.0165-0.00463-0.00834
        403724.443912.55617.822682.747621.124240.498030.205720.088050.038680.017230.007710.002280.00385

        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
          bgonçalves
          Brasil
          Member #92564
          June 9, 2010
          2133 Posts
          Offline
          Posted: October 1, 2012, 5:16 pm - IP Logged

          Hello, jade, thank you, good job, the draw should be in order to draw?
          Another example is the lottery I split 60/6 into 4 parts, ie 4 groups of 15 numbers
            And I wanted to look for your mother, by group separate but linked by registration
            The sweepstakes, ie I intend to analyze in 4 separate parts, is this possible?

            JADELottery's avatar - Inky Move-01.gif
            The Quantum Master
            West Concord, MN
            United States
            Member #21
            December 7, 2001
            3680 Posts
            Offline
            Posted: October 1, 2012, 7:41 pm - IP Logged

            The Excel addin we are working on would do some of the same thing.

            Also, we would include the extra ability to project the regression, each of the waves, and the remainder to arrive at some projected value of the original data.

            This where the Ultimate Wave Predictor comes in; which is not a part of the Wave Matrix program.

            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
              bgonçalves
              Brasil
              Member #92564
              June 9, 2010
              2133 Posts
              Offline
              Posted: October 2, 2012, 3:21 pm - IP Logged

              hello, jade, this being made a new array, you can import into a column. txt to analyze?

                JADELottery's avatar - Inky Move-01.gif
                The Quantum Master
                West Concord, MN
                United States
                Member #21
                December 7, 2001
                3680 Posts
                Offline
                Posted: October 2, 2012, 3:26 pm - IP Logged

                hello, jade, this being made a new array, you can import into a column. txt to analyze?

                click copy, then paste to any program like a wordpad, notpad, Excel, etc...  or at least any that will take it.

                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: October 2, 2012, 3:55 pm - IP Logged

                  Are the waves a kind of covariance for a group of numbers?

                    Avatar
                    bgonçalves
                    Brasil
                    Member #92564
                    June 9, 2010
                    2133 Posts
                    Offline
                    Posted: October 2, 2012, 3:59 pm - IP Logged
                    Escreva texto ou o endereço de um Web site ou traduza um documento
                    Exemplo de utilização de “ ”:
                    traduzido automaticamente pela Google

                     

                     
                    Alpha
                    Hello Jade, ok, very good job!!, Thanks
                      Avatar
                      bgonçalves
                      Brasil
                      Member #92564
                      June 9, 2010
                      2133 Posts
                      Offline
                      Posted: October 2, 2012, 4:50 pm - IP Logged

                      Hello, ok jade is now! how best number selection? after wave data?   The waves need to know the limit of the lottery? Example, my number is in the 01-60 After analyzing the column, which forecast to be played in the next draw, column   Analyzed?

                        Avatar
                        bgonçalves
                        Brasil
                        Member #92564
                        June 9, 2010
                        2133 Posts
                        Offline
                        Posted: October 2, 2012, 5:15 pm - IP Logged

                        Hello, jade, we must bear in mind that, either by column or the whole of a lottery
                          There are patterns that occur in 80% to 100% in the draws, we can neglect
                          These patterns of outputs, especially the basic, the matrix can help it
                        Jade, could test whether the size of the column example, a column of 20 numbers
                          Another test with 40 draws a column, or a long column of 200 sweepstakes
                          It seems that short columns, is more accurate?
                        waves can not, fail to see the basic patterns

                          JADELottery's avatar - Inky Move-01.gif
                          The Quantum Master
                          West Concord, MN
                          United States
                          Member #21
                          December 7, 2001
                          3680 Posts
                          Offline
                          Posted: October 2, 2012, 6:18 pm - IP Logged

                          Hello, ok jade is now! how best number selection? after wave data?   The waves need to know the limit of the lottery? Example, my number is in the 01-60 After analyzing the column, which forecast to be played in the next draw, column   Analyzed?

                          You're getting a little ahead of what we have in mind for the Excel addin.

                          The program you are using is a test.

                          When we make the addin for Excel, there will be a few ways the addin can project into just the next draw.

                          You can do some of you own form of projection based on what you can see or analyze for the Wave Matrix program's output.

                          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 - Inky Move-01.gif
                            The Quantum Master
                            West Concord, MN
                            United States
                            Member #21
                            December 7, 2001
                            3680 Posts
                            Offline
                            Posted: October 2, 2012, 6:54 pm - IP Logged

                            Are the waves a kind of covariance for a group of numbers?

                            What we've found is that oscillating random data can have multiple waves.

                            The Wave Matrix is like a frequency filter that can, in general, find a close match to the waves in the oscillating data.

                            If you Sum the Linear Regression, Waves and the Remainder in a single line, you'll see the Sum of those equals the original data.

                            Example, in line 10 of our previous Wave Matrix of Column C, you can see that if each of the components in the Wave Matrix are Summed we get the original data.

                            Below is line 10:

                            IndexDataRegressionOscillationWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8Wave 9Wave 10Remainder
                            102121.26098-0.260980.97772-0.1887-0.3293-0.2926-0.187-0.1098-0.0613-0.0332-0.0176-0.00531-0.01378

                            Highlighted in red are the Wave Matrix components.

                            The sum is 21.26089 + 0.97772 - 0.1887 - 0.3293 - 0.2926 - 0.187 - 0.1098 - 0.0613 - 0.0332 - 0.0176 - 0.00531 - 0.01378 = 20.99999, or rounded to 21.

                            The rounding is needed because the precision of the decimal points don't go out far enough to get to the full 21.0000.

                            If you plot each of the waves, you can see each of the waves oscillate frequently for this data set.

                            Also, the amplitude, or wave height, of each wave decreases as the wave number increases; the remainder should have the smallest amplitude.

                            In other kinds of data, the first few waves are much more smooth and the increasing wave number has an increasing frequency, with a decreasing amplitude.

                            You'll find the Remainder tends to be high frequency, and is fairly erratic.

                            However, it does follow a pattern; when you do a distribution on the Remainder, you'll see that it distributes just like a Normal Distribution.

                            There's more to the Remainder and the Higher Number Waves than just the distribution, but we'll leave that for another thread.

                            This topic was just to find out what Excel version most are using so we know where to target the development of the Excel addin.

                            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
                              bgonçalves
                              Brasil
                              Member #92564
                              June 9, 2010
                              2133 Posts
                              Offline
                              Posted: October 2, 2012, 7:32 pm - IP Logged

                              Hello, jade, how can we detect it? = There are a maximum of 64 patterns of complexity, driving all the events of our size: These patterns are identified graphically and conceptually for the three benchmarks of the equation. But I am beginning to realize that there are repeating patterns. (In the universe everything is energy and frequency, the frequency is defining what we call reality - every object is ephemeral.)
                              The problem is to find this 64 patterns,!!