Welcome Guest
Log In | Register )
You last visited January 22, 2017, 11:19 pm
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 13 of 17
510
PrintE-mailLink
JADELottery's avatar - YingYangYong 01.PNG
The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3684 Posts
Offline
Posted: March 9, 2013, 12:11 pm - IP Logged

Now we analyze for the whole number.

We will start with Data Direction set to -Bottom of Sheet for this sample, because the newest data is at the bottom.

Everything else is set to the defaults.

The first 10 lines of the Wave Matrix are shown below.

Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4BMA Degree 5BMA Degree 6BMA Degree 7BMA Degree 8AlgorithmPredictor
A =497.8033156-1.351-1.096-1.058-1.015-1.054-1.02-1.026-1.044Wave / BMA = 0.50Depth = 25
B =5.88688E-05                Amp / Freq = 0.50Level = 25
IndexRegressionWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8RemainderData
1497.803374524.98113757-22.02429006-8.554287736-2.3083573160.4988738161.3655046451.9881811142.14340446734.10645902530
2497.803433325.79202522-21.81376363-8.772849267-2.7681401590.0504663560.8337931331.4650472951.661063954202.7489237697
3497.803492226.7707037-21.52973847-9.020757103-3.317620052-0.4865823550.1914176130.8321784091.0782891493.678616896496
4497.803551127.91802971-21.14733041-9.265340991-3.916883795-1.079116454-0.5245739240.1243035660.425891089-180.3385299310
5497.8036129.23432864-20.63953393-9.470612891-4.521636361-1.690351812-1.272952642-0.619916448-0.261851195268.4389167757
6497.803668830.71890142-19.97951231-9.600027787-5.086572439-2.282524569-2.011367966-1.360748004-0.949689424-195.2521277292
7497.803727732.36978483-19.14136889-9.617262046-5.56605351-2.817492395-2.696801423-2.057728957-1.601683294-259.675122227
8497.803786634.18320249-18.102874-9.489547328-5.918242091-3.259973434-3.289355503-2.673226293-2.184316466170.9305461658
9497.803845436.15321338-16.84705671-9.189537615-6.107259307-3.57929272-3.75415512-3.174183508-2.668023404-85.63755042403
10497.803904338.2715802-15.36253837-8.695554746-6.10316462-3.749488082-4.061180639-3.531889786-3.026984577-354.5446837137



Notice how the BMA Degree changes with increasing wave numbers.

There's point where the BMA Degree is going up in value then steps back down between Waves 4 and 5.

This could be an indication that we are using too many waves to analyze the data.

Since the BMA Degree changes down just after wave 4, we will stop the analysis at wave 4 by changing the Wave in the Wave Matrix Settings from 8 to 4.

Below is the new Wave Matrix for the new setting.

Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4AlgorithmPredictor
A =497.8033156-1.351-1.096-1.058-1.015Wave / BMA = 0.50Depth = 25
B =5.88688E-05        Amp / Freq = 0.50Level = 25
IndexRegressionWave 1Wave 2Wave 3Wave 4RemainderData
1497.803374524.98113757-22.02429006-8.554287736-2.30835731640.10242306530
2497.803433325.79202522-21.81376363-8.772849267-2.768140159206.7592945697
3497.803492226.7707037-21.52973847-9.020757103-3.3176200525.293919712496
4497.803551127.91802971-21.14733041-9.265340991-3.916883795-181.3920256310
5497.8036129.23432864-20.63953393-9.470612891-4.521636361264.5938446757
6497.803668830.71890142-19.97951231-9.600027787-5.086572439-201.8564577292
7497.803727732.36978483-19.14136889-9.617262046-5.56605351-268.8488281227
8497.803786634.18320249-18.102874-9.489547328-5.918242091159.5236744658
9497.803845436.15321338-16.84705671-9.189537615-6.107259307-98.81320517403
10497.803904338.2715802-15.36253837-8.695554746-6.10316462-368.9142268137

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 - YingYangYong 01.PNG
    The Quantum Master
    West Concord, MN
    United States
    Member #21
    December 7, 2001
    3684 Posts
    Offline
    Posted: March 9, 2013, 12:40 pm - IP Logged

    Ideally we would like to see the BMA Degree start negative and become more positive; with Wave 1 and Wave 4 BMA Degrees near equal and opposite.

    To do this, we need to make some setting changes in the Algorithm Settings first and if needed, changes to the Wave Find Algorithm.

    We will start with the 'Amplitude to Frequency Ratio', this will tell us if the waves we need are more or less dependent on Amplitude or Frequency.

    Settings that are closer to 1.00 have the effect of including values with more Amplitude analysis; likewise, settings that are closer to 0.00 have the effect of including values with more Frequency analysis.

    We're looking for a nice middle ground between Amplitude and Frequency.

    You can tell it's achieved by looking at the BMA values.

    In the previous table, we can see the BMA Degree for waves 1 and 4 are not nearly equal and opposite.

    Below we have posted a few tables with changes in the Amplitude to Frequency Ratio.

    Start - Amp / Freq = 0.50

    Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4AlgorithmPredictor
    A =497.8033156-1.351-1.096-1.058-1.015Wave / BMA = 0.50Depth = 25
    B =5.88688E-05        Amp / Freq = 0.50Level = 25
    IndexRegressionWave 1Wave 2Wave 3Wave 4RemainderData
    1497.803374524.98113757-22.02429006-8.554287736-2.30835731640.10242306530
    2497.803433325.79202522-21.81376363-8.772849267-2.768140159206.7592945697
    3497.803492226.7707037-21.52973847-9.020757103-3.3176200525.293919712496
    4497.803551127.91802971-21.14733041-9.265340991-3.916883795-181.3920256310
    5497.8036129.23432864-20.63953393-9.470612891-4.521636361264.5938446757
    6497.803668830.71890142-19.97951231-9.600027787-5.086572439-201.8564577292
    7497.803727732.36978483-19.14136889-9.617262046-5.56605351-268.8488281227
    8497.803786634.18320249-18.102874-9.489547328-5.918242091159.5236744658
    9497.803845436.15321338-16.84705671-9.189537615-6.107259307-98.81320517403
    10497.803904338.2715802-15.36253837-8.695554746-6.10316462-368.9142268137

     

    Next - Amp /Freq = 0.60

    Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4AlgorithmPredictor
    A =497.8033156-0.712-0.335-0.3840.04Wave / BMA = 0.50Depth = 25
    B =5.88688E-05        Amp / Freq = 0.60Level = 25
    IndexRegressionWave 1Wave 2Wave 3Wave 4RemainderData
    1497.80337457.330244344-0.2178934129.5068181416.21656276-0.639106308530
    2497.80343336.987040545-2.935181437.57137507412.82854189174.7447906697
    3497.80349226.620527433-6.5455331035.0169554388.017382107-14.91282409496
    4497.80355116.347124192-10.678652412.0972440162.734102748-188.3033696310
    5497.803616.295591584-14.93538918-0.919871154-2.053064716270.8091235757
    6497.80366886.590570174-18.99850017-3.833975639-5.986146542-183.5756166292
    7497.80372777.357285696-22.51895998-6.426241688-8.096525036-241.1192867227
    8497.80378668.699609276-25.30479464-8.596463787-8.292717918193.6905805658
    9497.803845410.693866-27.34416439-10.37641858-7.573903986-60.20322448403
    10497.803904313.40026685-28.63279818-11.79844538-6.663696613-327.109231137


    Next - Amp / Freq = 0.70

    Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4AlgorithmPredictor
    A =497.8033156-0.0740.3640.410.459Wave / BMA = 0.50Depth = 25
    B =5.88688E-05        Amp / Freq = 0.70Level = 25
    IndexRegressionWave 1Wave 2Wave 3Wave 4RemainderData
    1497.803374515.3535312323.6135498815.178733939.143525358-31.09271487530
    2497.803433311.3676421217.740021711.645816367.02226772151.4208188697
    3497.80349225.894057048.235763435.2280740442.235480627-23.39686736496
    4497.8035511-0.202514768-2.35515828-1.733318137-2.918185295-180.5943746310
    5497.80361-6.00126102-11.65765661-7.206363567-6.619324797290.680996757
    6497.8036688-10.91647042-20.02232381-12.43336612-11.06103809-151.3704704292
    7497.8037277-14.0922454-23.62533614-13.19955873-11.35476761-208.5318198227
    8497.8037866-15.22658292-21.67180234-8.586632289-6.282590309211.9638213658
    9497.8038454-14.68871648-17.49753499-2.3143947070.077347951-60.3805472403
    10497.8039043-12.7706862-12.038566525.1842821768.108711115-349.2876449137

     

    A tweak more - Amp / Freq = 0.65

    Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4AlgorithmPredictor
    A =497.8033156-0.3930.0110.0150.116Wave / BMA = 0.50Depth = 25
    B =5.88688E-05        Amp / Freq = 0.65Level = 25
    IndexRegressionWave 1Wave 2Wave 3Wave 4RemainderData
    1497.80337458.53965594513.6554669313.510709639.955357905-13.46456489530
    2497.80343336.6602193919.2931480910.576402297.370997872165.295799697
    3497.80349224.2478732423.1313626146.4275334453.551553225-19.16181474496
    4497.80355111.63250273-3.8364723841.88897967-0.505098346-186.9834628310
    5497.80361-0.82693352-10.57590116-2.197376158-3.803119736276.5997206757
    6497.8036688-2.826930658-16.57460468-5.520079917-6.187834365-174.6942192292
    7497.8037277-4.046001437-20.82128434-7.234287701-6.433433534-232.2687207227
    8497.8037866-4.281176533-23.09225519-7.260544542-4.428163756199.2583535658
    9497.8038454-3.467079072-24.13669941-6.472577633-1.513196133-59.21429318403
    10497.8039043-1.557621411-24.50082734-5.5082059971.486019254-330.7232688137


    Finally - Amp / Freq = 0.67

    Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4AlgorithmPredictor
    A =497.8033156-0.2660.1530.1770.236Wave / BMA = 0.50Depth = 25
    B =5.88688E-05        Amp / Freq = 0.67Level = 25
    IndexRegressionWave 1Wave 2Wave 3Wave 4RemainderData
    1497.803374510.717307418.1554704614.408520699.391820877-20.4764939530
    2497.80343338.06667394913.1049395911.043492716.804923296160.1765371697
    3497.80349224.5701717045.6792563875.9628519282.626820039-20.64259227496
    4497.80355110.717216201-2.6635255210.442853694-1.833285984-184.4668095310
    5497.80361-2.964227396-10.44430749-4.25512962-5.323528347282.1835829757
    6497.8036688-6.066503876-17.210436-7.994758852-8.038826886-166.4931432292
    7497.8037277-8.124682897-21.24647608-9.112493242-7.944707438-224.375368227
    8497.8037866-8.901038932-22.2252807-7.377528881-4.70564837203.4057103658
    9497.8038454-8.422716416-21.612586-4.454634341-0.316182239-59.99772643403
    10497.8039043-6.724736885-20.26958689-1.2424810984.404521068-336.9716205137

     

    At each step, we moved the Amp / Freq one way then back till we have nearly equal and opposite.

    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 - YingYangYong 01.PNG
      The Quantum Master
      West Concord, MN
      United States
      Member #21
      December 7, 2001
      3684 Posts
      Offline
      Posted: March 9, 2013, 12:54 pm - IP Logged

      If you find that you are moving the Amp / Freq setting all the way to 1.00, then it means you are analyzing only by Amplitude.

      You can help speed the Wave Matrix generation up by selecting 'by Amplitude Only'.

      Also, the same is true for the other end.

      If you are setting the Amp / Freq to a value of 0.00, then it means you are analyzing only by Frequency.

      Selecting the 'by Frequency Only' will only run the frequency analysis.

      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 - YingYangYong 01.PNG
        The Quantum Master
        West Concord, MN
        United States
        Member #21
        December 7, 2001
        3684 Posts
        Offline
        Posted: March 9, 2013, 1:20 pm - IP Logged

        If you find that changing the Amp / Freq Ratio isn't getting the BMA values to come out equal and opposite, then you might need to reset the value to default of 0.50 and start making changes to the 'Wave to BMA RMS Ratio'.

        The Wave to BMA RMS Ratio only affects the way the Amplitude analysis is done.

        Settings that are closer to 0.00 tend to have more smooth wave like patterns and wave heights lower than the original data.

        In addition, the closer to 0.00 the BMA values tend to change little between each BMA value.

        Settings that are closer to 1.00 tend to have more wave variation, erratic, more like the original data and the wave heights are higher; similar to the original data.

        Also, the the BMA values tend to become erratic as well, sometimes flip-flopping between negative and positive, or going up then back down.

        When changing this setting, you are looking for a nice smooth transition between BMA values, generally from negative to positive with increasing wave numbers.

        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 - YingYangYong 01.PNG
          The Quantum Master
          West Concord, MN
          United States
          Member #21
          December 7, 2001
          3684 Posts
          Offline
          Posted: March 9, 2013, 2:17 pm - IP Logged

          There are some data sets where you're not going to get that nice setup of equal and opposite.

          What you should be trying to achieve then is a relatively smooth transition between BMA degrees.

          Increasing waves and/or BMA Iterations might help a bit, but each does what it can to find reasonable waves in the data set.

          Adding more waves may or may not give better insight in to the possible waves need to replicate the observed data.

          Adding more BMA Iterations can help with getting better waves, but it also adds more time in generating the Wave Matrix.

          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 - YingYangYong 01.PNG
            The Quantum Master
            West Concord, MN
            United States
            Member #21
            December 7, 2001
            3684 Posts
            Offline
            Posted: March 9, 2013, 3:25 pm - IP Logged

            Next pick 3 example, Draw Index of a number.

            The Draw Index is a relative value dependent on the number samples.

            For this set we have 4809 draws and each draw has a set of numbers associated with it.

            Likewise, each number has a set of Draw Indices associated with it.

            IndexYearMonthDayABC
            1200011530
            2200012697
            3200013496
            4200014310
            5200015757
            6200016292
            7200017227
            8200018658
            9200019403
            102000110137
            112000111859
            122000112983
            132000113077
            142000114466
            152000115216
            162000116427
            172000117442
            182000118807
            192000119835
            202000120121
            212000121973
            222000122052
            232000123986
            242000124666
            252000125962
            262000126566
            272000127471
            282000128903
            292000129667
            302000130634
            312000131925
            32200021622
            33200022918
            34200023136
            35200024811
            36200025655
            37200026430
            38200027494
            39200028344
            40200029383
            412000210268
            422000211185
            432000212416
            442000213768
            452000214828
            462000215739
            472000216794
            482000217731
            492000218720
            502000219603
            512000220012
            522000221964
            532000222521



            As an example from our draws, the number 5 in Column A occurred at Index 1, 26, 53, and so on.

            The following table shows all the Draw Index for number 5 in Column A.

            Number 5 Draw Index in Column A
            1996197729603931
            261001198529733935
            531003199030003939
            651008200530203941
            811013201130233949
            1031019203930253950
            1121023205830393954
            1291024206130433964
            1561025206930493989
            1601041207330563994
            2051054209130624006
            2281060210630654017
            2311061211430674018
            2391099211731064019
            2551112217331224025
            2571113217431234026
            2621120217731274031
            2701121219631434062
            2741175220231694100
            2821181220831724115
            2851191222131754151
            2871203224431764171
            2901213224831934201
            3021233224931974203
            3061236226532094206
            3191238228732184219
            3371245228932414220
            3421247232432504227
            3461248232732554229
            3491258233632694231
            3661265234032774242
            3671266234632784256
            3761285235732794285
            3801290236032854288
            3841309236932954289
            4051312237333024297
            4151316237833104300
            4221356239333124303
            4241359240533234309
            4321367240633334313
            4381369240933344327
            4511371241033674337
            4891375241633854350
            4961377242733964352
            5101379242834014364
            5141384243534074376
            5161415243834124377
            5171429244034304380
            5281438245034354397
            5431454245134374415
            5511456245534424434
            5621457246234554436
            5671459247134794444
            5711467247534814445
            5761474248634904447
            5771476249135004461
            6091478250835084463
            6141486251335284466
            6201489252035314469
            6291491252635354473
            6501504256335384497
            6521505256835464503
            6541529258735854504
            6611531259435904505
            6671535259535994529
            6681569259836044533
            6791579260236064552
            6951581262936164571
            7081583263136224576
            7111588264936334584
            7481601265636474596
            7641617265936674601
            7671628266436744621
            7681638267436774631
            7721645268036804676
            7811671268436824677
            7881682269236894682
            8111687270436914715
            8201690272136944725
            8231749275237164727
            8471768275737284762
            8741772278037434768
            8771788279538134778
            8901795279838194781
            8911799282238204785
            9101802282438284787
            9171814282638304807
            934182628273837
            937182928413838
            938183328423843
            946184028573851
            948184728763853
            962187628833858
            964188428863859
            965190128963860
            966190829123879
            967192429173893
            974195229193907
            984195629323912
            986196829553915

            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: March 9, 2013, 3:38 pm - IP Logged

              Looks very well done, but honestly, I don't understand what the values stand for.
              I have a good basic background for statistics, but this, I don't know!

                JADELottery's avatar - YingYangYong 01.PNG
                The Quantum Master
                West Concord, MN
                United States
                Member #21
                December 7, 2001
                3684 Posts
                Offline
                Posted: March 9, 2013, 3:47 pm - IP Logged

                Looks very well done, but honestly, I don't understand what the values stand for.
                I have a good basic background for statistics, but this, I don't know!

                Yep, right about that, not standard.

                But this is still early in the explanation.

                We're giving examples right now.

                Later we'll look at Projection.

                That may include what you are more use to, Statistics.

                What you are looking at now are the Dynamics.

                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 - YingYangYong 01.PNG
                  The Quantum Master
                  West Concord, MN
                  United States
                  Member #21
                  December 7, 2001
                  3684 Posts
                  Offline
                  Posted: March 9, 2013, 4:11 pm - IP Logged

                  For the Draw Index example, we made a change only to the Amp / Freq Ratio = 0.90

                  Below is the shortened table.

                    Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4BMA Degree 5BMA Degree 6BMA Degree 7BMA Degree 8AlgorithmPredictor
                    A =28.31013765-2.116-1.24-0.6360.0210.6641.2761.8542.15Wave / BMA = 0.50Depth = 25
                    B =9.734994807                Amp / Freq = 0.90Level = 25
                    IndexRegressionWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8RemainderData
                    138.0451324618.96078997-2.972189035-15.42680224-17.95035921-9.437734464-4.100218602-3.087169942-1.744203738-1.2872451921
                    247.7801272719.04301835-2.307719562-13.96065417-16.18908449-7.641138834-1.3128549940.1646922370.3105322550.11308194126
                    357.5151220719.13351384-1.507855818-12.04163353-13.70737543-5.464881751.3643157252.9126431431.9860298892.81012184453
                    467.2501168819.2316382-0.588967853-9.739760489-10.69988694-3.654542211.9821730322.0334863240.356650928-1.17090787665
                    576.9851116919.33670070.430360604-7.136492352-7.328418185-2.3286784411.4342033591.152472679-0.118765118-1.42649493781
                    686.720106519.447963711.529840761-4.321433457-3.722982844-1.3480096030.3010898990.9790549680.9238932392.490476827103
                    796.455101319.56464862.688026248-1.3890400730.008028417-0.473621949-1.628817981-1.275559989-0.610284575-1.338480003112
                    8106.190096119.685941853.8828835341.5648015563.7708307290.822767004-2.683377635-2.273013659-0.75754737-1.203382118129
                    9115.925090919.811001325.0923529064.44550337.4415186192.806066979-2.276364232-1.9661257160.1016931414.619262766156
                    10125.660085719.93896266.2948987837.16300812610.848880655.329797574-0.950899529-3.357091435-3.20723633-7.720406164160
                   
                    4784681.63765610.555278452.5741873333.9210198865.0172344433.7466187631.0968710210.6047033551.2729804484.5734507544715
                    4794691.3726510.731417063.7213946595.6763388996.378521564.6664731591.176947289-0.3645144370.0981197321.5426517294725
                    4804701.10764510.900926034.8272237447.2906993137.3521406275.2943747981.386985975-2.033136566-2.631658309-6.4952007734727
                    4814710.8426411.063117855.8788446098.7409796467.8967026355.6731983573.4053980992.0618908481.5551693844.8820586064762
                    4824720.57763511.217324336.86428386410.01205667.9805029955.1636954093.8163367242.4810102720.970266953-1.0831119244768
                    4834730.3126311.362901567.77256946811.097938187.6515045613.7056755192.7136167931.9096967050.8208493020.652618334778
                    4844740.04762411.49923468.59381474912.000486567.0243972661.559748870.3735809680.080475108-0.030024711-0.1493377964781
                    4854749.78261911.625742079.31927864412.727674956.265974109-0.684546449-2.005188128-1.687290033-0.8244826040.4802182394785
                    4864759.51761411.741880479.94139154213.290844615.551150063-2.442312448-3.330795136-2.480562951-1.64057902-3.1486311334787
                  Quantum4874769.25260911.8471481810.4537636313.701920885.023690587-3.372776694-2.90555253-0.0083604071.0048372122.0027203314807
                  Projection ->4884778.98760411.8970658710.682415313.871625444.821004732-3.595017432-2.0519283873.0448186324.8511653161.1315586484823.640312

                  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 - YingYangYong 01.PNG
                    The Quantum Master
                    West Concord, MN
                    United States
                    Member #21
                    December 7, 2001
                    3684 Posts
                    Offline
                    Posted: March 9, 2013, 5:20 pm - IP Logged

                    Now for our next set, we will look at my state's lottery Gopher 5.

                    It's a Pick 5 of 47 numbers.

                    Below is a shortened list of draws for the dates from 2005-09-23 to 2013-03-01.

                    IndexYearMonthDayABCDE
                    12005923425274445
                    2200592718152638
                    3200593078123739
                    420051041930313237
                    520051071222274046
                    6200510112026293345
                    720051014213242534
                    8200510181920244143
                    9200510211018253440
                    10200510251618252631
                    998201328512192134
                    99920132111314183038
                    1000201321317343945
                    100120132151114243144
                    100220132182030353945
                    10032013220313172445
                    10042013222214171827
                    100520132252728353638
                    10062013227626384547
                    10072013311026324041

                     

                    First we will analyze the individual column C for this example.

                    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 - YingYangYong 01.PNG
                      The Quantum Master
                      West Concord, MN
                      United States
                      Member #21
                      December 7, 2001
                      3684 Posts
                      Offline
                      Posted: March 9, 2013, 5:33 pm - IP Logged

                      When we play around with the controls, we find that we need only 2 waves to generalize a Wave Matrix.

                      Also, we tweaked the Amp / Freq to 0.60 to get the BMA values near equal and opposite.

                      Below is a shortened table.

                        Type =LinearBMA Degree 1BMA Degree 2AlgorithmPredictor
                        A =24.41198094-0.070.108Wave / BMA = 0.50Depth = 25
                        B =-1.70397E-06    Amp / Freq = 0.60Level = 25
                        IndexRegressionWave 1Wave 2RemainderData
                        124.41197924-0.832644354-0.3633406183.78400573227
                        224.41197754-0.761880194-0.263381292-8.38671605115
                        324.41197583-0.650034918-0.071974973-11.6899659412
                        424.41197413-0.5129881510.1999861226.901027931
                        524.41197242-0.3956382670.4733789182.51028692527
                        624.41197072-0.3347477270.6929492724.22982773429
                        724.41196902-0.3584124880.821516515-0.87507304424
                        824.41196731-0.479587290.848155041-0.78053506424
                        924.41196561-0.704569650.7595391610.53306488125
                        1024.4119639-1.0322056040.5374281571.08281354225
                       
                        99824.410280391.509340657-0.573850577-6.34577046519
                        99924.410278681.809791129-0.501868081-7.71820172918
                        100024.410276982.153416571-0.4144404257.85074687734
                        100124.410275272.531105339-0.318588242-2.62279237124
                        100224.410273572.946569388-0.1833298247.82648686735
                        100324.410271873.3964052090.014440297-10.8211173717
                        100424.410270163.8809329170.320690376-11.6118934617
                        100524.410268464.3682500260.7092078215.51227369635
                        100624.410266754.7956230991.0796582387.7144519138
                      Quantum100724.410265055.1072596741.3485190251.13395625232
                      Projection ->100824.410263355.2291021351.450337056-6.18535144624.90435109

                      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 - YingYangYong 01.PNG
                        The Quantum Master
                        West Concord, MN
                        United States
                        Member #21
                        December 7, 2001
                        3684 Posts
                        Offline
                        Posted: March 9, 2013, 5:56 pm - IP Logged

                        Next example is the Combinatorial Index.

                        The Combinatorial Index is the number assigned to a combination when all possible combinations are sorted with lower ball number combinations first and higher ball number combinations last.

                        Here's the short list of Combinatorial Index for this example of Pick 5 of 47.

                        Combinatorial IndexABCDE
                        112345
                        212346
                        312347
                        412348
                        512349
                        6123410
                        7123411
                        8123412
                        9123413
                        15339304143444547
                        15339314143444647
                        15339324143454647
                        15339334144454647
                        15339344243444546
                        15339354243444547
                        15339364243444647
                        15339374243454647
                        15339384244454647
                        15339394344454647

                        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 - YingYangYong 01.PNG
                          The Quantum Master
                          West Concord, MN
                          United States
                          Member #21
                          December 7, 2001
                          3684 Posts
                          Offline
                          Posted: March 9, 2013, 6:10 pm - IP Logged

                          We can transform the combination to an Index and back to a combination using an Excel file we have created.

                          It contains some functions for going between the two.

                          The file can be found at http://www.jadexcode.com/files/excel/combinatorialindex.xls

                          or at ftp://www.jadexcode.com/excel/combinatorialindex.xls

                          The functions in the file that do the transformation are documented in the sheet tab labeled 'Function Information'.

                          The two used in the transformation are ' =Index2Combin(N, R, Index) ' and ' =Combin2Index(N, R, Range) '.

                          The following is a short list for this example.

                           

                          IndexYearMonthDayABCDECombinatorial Index
                          12005923425274445562881
                          220059271815263875755
                          3200593078123739787082
                          4200510419303132371432604
                          5200510712222740461195495
                          62005101120262933451446315
                          720051014213242534263789
                          82005101819202441431416319
                          92005102110182534401072666
                          102005102516182526311338511
                          998201328512192134627297
                          999201321113141830381210964
                          100020132131734394571479
                          1001201321511142431441114133
                          1002201321820303539451450579
                          10032013220313172445397240
                          10042013222214171827266774
                          1005201322527283536381514275
                          10062013227626384547778471
                          100720133110263240411091575

                          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 - YingYangYong 01.PNG
                            The Quantum Master
                            West Concord, MN
                            United States
                            Member #21
                            December 7, 2001
                            3684 Posts
                            Offline
                            Posted: March 9, 2013, 6:21 pm - IP Logged

                            For this example we find that a setting of 'by Amplitude Only' and Wave to BMA RMS Ratio = 0.12 works well for 8 waves; everything else default.

                            Here's the short list for the Wave Matrix.

                             

                              Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4BMA Degree 5BMA Degree 6BMA Degree 7BMA Degree 8AlgorithmPredictor
                              A =763985.1424-1.343-0.4560.1110.5510.9011.1411.3111.451Wave / BMA = 0.12Depth = 25
                              B =28.86518294                Amp / Freq = 0.50Level = 25
                              IndexRegressionWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8RemainderData
                              1764014.0076-1771.44646227473.96137-56037.41632-119648.8512-112236.5224-66898.2488-28688.49345-3885.466383160559.4761562881
                              2764042.8728-1803.84451633866.58951-28800.48641-78775.0107-82572.21369-65708.5483-56490.09934-54961.00694-353043.252475755
                              3764071.738-1857.43660441717.657338400.847536-13393.69143-7600.8110993715.4279124023.030243-1798.34902-10196.41285787082
                              4764100.6032-1948.84926749687.9587647154.1836652852.4452266044.8604274130.6838671129.5848162444.35164247008.17771432604
                              5764129.4684-2095.5397356421.9700279072.8492996356.1166789538.5628272805.875857278.5875844116.98464-62129.875441195495
                              6764158.3335-2314.54762760834.9533999591.96603114632.490673874.2825228437.478287093.7189033338.685275296667.63911446315
                              7764187.1987-2621.69144162202.05498107013.8755114350.698141523.56541-34456.46096-72371.6703-84657.16143-631381.4085263789
                              8764216.0639-3030.61050960278.54158102802.4198114276.594456846.551424890.156286-9964.877681-3658.8693329663.03011416319
                              9764244.9291-3552.79185655115.6109685802.52193101096.600466073.0031533288.8868222619.4536421606.13312-73628.347311072666
                              10764273.7943-4196.91216747239.5723357386.0081671521.6747957964.7606842986.4544736427.6306532869.29324232038.72361338511
                             
                              998792792.59564145.36769-9072.479442-14424.9960513047.0361225304.639319327.6420810221.916743349.761778-277394.4832627297
                              999792821.460268071.12194-3897.451619-14899.177981537.8728985550.373109-686.1147227-4295.845887-1674.953511368436.71561210964
                              1000792850.325471852.796391794.942106-15858.61368-12598.18376-19836.66208-35345.62339-50412.87449-62626.65476-598340.451771479
                              1001792879.190675457.677628002.224263-14610.12772-15029.47856-4020.02516812637.855825217.0000131627.22984201971.45341114133
                              1002792908.055778852.0917214555.62068-12051.95304-19672.66214-5170.81314824348.5893349728.3056665620.92682461460.83841450579
                              1003792936.920982002.4230421267.07984-8029.68596-29652.6369-41889.29511-42127.08268-40345.51575-41129.12886-295793.0785397240
                              1004792965.786184875.9133227958.92542-96.74586456-25051.80152-45686.11496-55272.19383-58771.92233-60338.60371-393809.2426266774
                              1005792994.651387441.1384434295.252611367.77212-3041.342769-4773.8475285883.56345820302.7121334940.02255534865.07771514275
                              1006793023.516589668.759639777.212922343.0032915581.9986314762.5111113260.269959310.6346234500.056745-223756.9633778471
                            Quantum1007793052.381791532.7819243997.1006830996.8336530498.5801331413.3279124449.7675613609.029154572.9267427452.270591091575
                            Projection ->1008793081.246892373.0074845764.9238134875.3307639732.4261151740.484560277.5895867069.2870978015.94715341172.7451604102.988

                            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 - YingYangYong 01.PNG
                              The Quantum Master
                              West Concord, MN
                              United States
                              Member #21
                              December 7, 2001
                              3684 Posts
                              Offline
                              Posted: March 9, 2013, 6:24 pm - IP Logged

                              time for eats.

                              back in a while.

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