Welcome Guest
Log In | Register )
You last visited December 3, 2016, 12:35 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 1 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 16, 2012, 8:05 pm - IP Logged

We would like to announce the release of the JADEXCODE Excel 2007 Addin - The Wave Matrix.

As always, it's free.

You can download the install files in two places.

Our regular website:

ZIP File - http://www.jadexcode.com/downloads/jadexcodexcel2007addin/JADEXCODExcel2007AddInSetupFiles.zip

Self Extracting ZIP - http://www.jadexcode.com/downloads/jadexcodexcel2007addin/JADEXCODExcel2007AddInSetupFiles.exe

Or at our FTP site:

ZIP File - ftp://www.jadexcode.com/excel/addins/JADEXCODExcel2007AddInSetupFiles.zip

Self Extracting ZIP - ftp://www.jadexcode.com/excel/addins/JADEXCODExcel2007AddInSetupFiles.exe

We will get to the 'How To..." and the inner workings in a while, but feel free to test it out for now.

Wink

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 16, 2012, 11:26 pm - IP Logged

    First we'll start with a general overview of the Wave Matrix.

    It starts by removing any off set Regression: Linear, Logarithmic, Exponential, or Power.

    This gives data that tends to oscillate around a zero level.

    It uses a process called Bidirectional Mean Averaging that aims to find the best possible set of waves that might be part of any data.

    Bidirectional Mean Averaging smooths the data in to a wave pattern that can be used to project a possible outcome.

    It can be removed from the data by subtracting the Bidirectional Mean Average (BMA) from the oscillating data.

    The left over, or remainder data can be left as is, or it can be fed back in to the BMA process again to find another wave.

    Ideally, it creates a Regression, a set of Waves, and a Remainder.

    The Wave Matrix is an unbounded, analog system.

    This needs to be understood when analyzing data.

    Take for instance a Pick 3 drawing.

    The numbers drawn in a Pick 3 lottery are in a bounded, digital system.

    This means, the numbers that are sampled are limited to 0 to 9 and they do not have values like 1.5 or 7.1828.

    The Wave Matrix currently has no way of knowing it is analyzing for a bounded, digital system.

    However, that does not mean it can't be used.

    When generating the Wave Matrix for something like a Pick 3 lottery, the Ultimate Wave Predictor will produce numbers like -1.9293, 5.0937, or 10.9348.

    The numbers can be handled in one of two ways:

    1. Any numbers less than 0 are 0 and any numbers greater than 9 are 9; round any number that is not an integer.

    The above numbers -1.9293, 5.0937, and 10.9348 would be come 0, 5, and 9.

    2. Do an integer-modulus of the numbers to have them wrap around back to the beginning or the ending.

    The integer-modulus in Excel would look like the following formula, ' =INT(MOD(A1,10)) '.

    If the numbers -1.9293, 5.0937, and 10.9348 were feed in to the formula, it would come out as 8, 5, and 0.

    This also applies to other bounded and/or digital systems; just keep in mind the limits and how to apply a means of adjusting for it.


    continues a little later...

    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 16, 2012, 11:34 pm - IP Logged

      We'll be creating a web page for the downloads to help keep track of any updates.

      We tried to set this up as an automated updating addin, but it was much more difficult than thought.

      Currently if there is an update, we'll post here; you can download from the same links and do the setup again.

      The setup knows how to handle the updating when it comes out.

       

      continues in a bit....

      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 17, 2012, 12:29 am - IP Logged

         

        Here's the Wave Matrix Excel ribbon.

        It's designed left to right, so the last operations are done on the right.

         

         

        Beginning with the Wave Matrix Settings.

         

        Regression is one of 4 types: Linear, Logarithmic, Exponential, and Power.

        Choose a regression that best fits the kind of data you are analyzing.

        Data like stock quotes tend to be Exponential.

        Data like Pick 3 numbers tend to be Linear.

        Waves are the number of waves you'd like to produce.

        It can range from 1 to 32.

        Like the regression, it depends on the kind of data you are looking at.

        Some data can appear to have many waves; some looks like very few waves.

        BMA Iterations the smoothing effect of finding a wave.

        It can range from 1 to 32.

        Higher numbers tend to smooth the wave more.

         

         

        Next are the Wave Find Algorithms.

         

        Waves have both Amplitude and Frequency.

        Selecting Amplitude and Frequency causes the algorithm to do an optimization for both Amplitude and Frequency.

        Amplitude tends to have waves that have a reduced height in the wave.

        Frequency tends to have waves that have a reduced motion in the wave.

        You can also choose to do only one or the other.

         

         

        The Algorithm Settings.

         

        Precision of BMA Degree is related to how detailed the Amplitude and Frequency Optimization is carried out.

        Smaller numbers like 0.1 and 0.01 tend to quicken the optimization, but loose the effect of each optimization.

        Larger numbers like 0.00001 and 0.000001 tend to lengthen the optimization time, but increases the effect of optimization.

        Wave to BMA RMS Ratio is a proportion of a Root Mean Squared value of the data in(non-analyzed data) to data out (analyzed data).

        Typically the data out is made to be smaller than the non-analyzed data.

        Smaller values like 0.25 have waves with lower height in Amplitude.

        Larger values like 0.75 have waves with heights in Amplitude closer to the non-analyzed data.

        Amplitude to Frequency Ratio is the percentage of proportion each of the algorithms effect on the overall wave.

        Lower numbers like 0.20 tend to have little effect from Amplitude and a lot of effect from Frequency.

        High numbers like 0.90 tend to have lots of effect from Amplitude and not so much from Frequency.

         

         

        Ultimate Wave Predictor Settings.

         

        The Quantum and Classic check boxes determine how the Wave Matrix projects the next outcome.

        Quantum is a Random field generation, where Classic is a Static field generation.

        The Quantum values are always different each time and different for each user.

        The Classic values are the same each time and for each user.

        Depth relates to how far back in the wave data set the Ultimate Wave Predictor goes to project values.

        Level relates to an averaging scheme that is combinatorially tied to Ultimate Wave Predictor formulae set.

        Higher Depth and Level numbers produce less varying outcomes.

        Lower Depth and Level numbers produce widely varying outcomes.

         

         

        Analyze and Predict.

         

        This is where the work gets done.

        There are two buttons: Generate Wave Matrix and Quick Projection.

        The Generate Wave Matrix button will analyze based on the previous settings and open a new sheet with the Wave Matrix place in it.

        The Quick Projection will use the same settings, but it will only do a Classic projection and place the value in the ' QP - ' edit box.

        You can select and copy the contents in the ' QP - ' edit box.

        Depending on the selection of Quantum or Classic, the bottom of the sheet will show the Projection line and state what kind of projection it is.

         

         

        Quantum Setting.

         

        The Manual Recalculate button does just that, recalculate the projection at the bottom of the sheet.

        This will produce a different projection each time.

        The Auto Recalculate check box allow you to have the addin do a recalculate on its own.

        The Timer setting is in seconds and can range from 1 to 10 seconds.

         

        continues shortly...

        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 17, 2012, 1:03 am - IP Logged

          Note, when preparing your data.

          Please make sure your data is in proper order.

          The most recent data should be at the bottom of the sheet and older data at the top.

          Right now, there is no way for the Wave Matrix to know what direction the data is in.

           

          You should have at least 10 data samples to do generate a Wave Matrix.

          Also, only select one column of data.

          The addin does not have the ability to handle more than one column at a time.

           

          From a previous thread on this subject, we can show below some simple data selected to analyze.

           

           

          Next, choose your setting, or just leave them as is on the default.

          We setup the defaults to be just about right for many kinds of data.

          If it's not what you'd like to see as an output, experiment.

          For this we left the settings as is.

          Below is the output for the Wave Matrix.

          At the top are the Type of Regression and its A, B values for the Linear equation of  y = A + B · x.

          Listed at the top are the Bidirectional Mean Averaging degrees for each wave.

          The last column is the original data and is actually the sum of the Regression, Waves, and Remainder; just to confirm they add up to the original data.

          At the bottom of the table is the Projection line; it's generated from the Ultimate Wave Predictor and the Quantum randomization.

          The bottom, far right cell in the table is the data projection and is the same sum used to confirm the data column.

          As you can see, it's not an integer value, so we would have to round or drop the decimal point values.

          In this case, it would be either 34 or 35.

           

           

            Type =LinearBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4BMA Degree 5BMA Degree 6BMA Degree 7BMA Degree 8   
            A =20.21.0261.1051.1911.0731.0951.1191.1351.145   
            B =0.106097561                   
            IndexRegressionWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8RemainderData
            120.306097563.6859004740.5075383850.3450888060.2237083710.1576182850.1119938050.0782629270.0546911360.5291002526
            220.412195123.1349619880.075847034-0.015302390.010530623-0.006686465-0.017931992-0.026605773-0.032707181-1.53430096622
            320.518292682.621739056-0.255885953-0.236530042-0.103247778-0.057157808-0.0203316680.0044609690.0197349771.50892556524
            420.624390242.233126706-0.525366794-0.506035318-0.272498342-0.19591364-0.136139985-0.093333044-0.064898681-0.06333114521
            520.73048782.300776441-0.37985085-0.452294371-0.263145514-0.202011807-0.150646088-0.112002773-0.085500779-3.38581206318
            620.836585372.8601824870.3031336140.1325847610.0690754720.0851764310.1131982240.136705370.1534291176.30992915831
            720.942682932.938755430.4649152850.024906525-0.073225876-0.149066746-0.193105533-0.214630643-0.221647805-3.51958356420
            821.048780493.1007350381.0166333220.5386138310.2384792690.1049444270.012700619-0.051401773-0.094475061-5.9150101620
            921.154878052.9191506031.5919736151.4092635180.8523034130.7546448930.6925539290.6367818210.58649042310.4019597441
            1021.260975610.8254930570.1744639790.1128449080.0548894520.026891940.008781667-0.001061418-0.004975776-1.4583034221
            1121.36707317-1.336485264-1.256749721-1.140228581-0.701529151-0.643900283-0.606613577-0.564246426-0.518578314-6.5987418558
            1221.47317073-1.993173245-1.1115957-0.68144903-0.33222561-0.221890455-0.154132248-0.10717923-0.0727605052.20123529119
            1321.57926829-1.989396588-0.575227671-0.0397825560.1121963870.2080604150.2516160250.2595316260.2484704543.94526361624
            1421.68536585-2.043431425-0.455338698-0.0754290510.059257260.1197460220.1347202740.1210590110.093621291-6.63957053713
            1521.79146341-1.743825559-0.1042437540.1420719830.1461161210.213009250.2626660980.2909313640.3037959999.69801508331
            1621.89756098-1.980586289-0.592290555-0.816583672-0.588106968-0.578159117-0.552734932-0.509496067-0.459234721-4.82036865411
            1722.00365854-1.1997162280.146197501-0.382834835-0.391783534-0.47785546-0.516870969-0.518059903-0.498338679-7.1643964311
            1822.10975610.2669587612.0089253061.5546057610.8542364020.6951182720.6020426590.5313524970.4738346465.90316959735
            1922.21585366-0.1643448512.1201512541.7808486351.0208579280.8572384280.7537474030.6670487060.5916150976.15698374236
            2022.32195122-2.7102993390.200854822-0.002140425-0.090469572-0.170302197-0.219250078-0.244017143-0.25352169-6.83280559812
            2122.42804878-4.93102813-1.138273232-0.903790779-0.573139145-0.518807239-0.471154165-0.418423914-0.3654746470.8920424714
            2222.53414634-6.126147268-1.538772031-0.89396592-0.464930497-0.34624153-0.27029473-0.214663471-0.173219571-2.50591132610
            2322.6402439-6.181432968-1.088558466-0.1452944230.0838892420.2092647570.2744091940.2982543750.2978365392.61138784719
            2422.74634146-6.051963089-0.998419641-0.0675490750.1221389670.2217910620.265778370.2748940220.2658605064.22112741421
            2522.85243902-5.832866061-1.357517131-0.737846671-0.385624679-0.336101108-0.322338471-0.314108173-0.304916775-5.2611199558
            2622.95853659-4.41743786-0.70016411-0.322438027-0.181791176-0.180231273-0.185480894-0.184177652-0.176353735-2.61046185814
            2723.06463415-2.4075547620.4424627980.6331672740.3870243750.3423964480.3180769510.3003355630.2869825657.63247464231
            2823.17073171-1.2646719210.5245965660.3751264370.1618581750.06600970.003680101-0.037065843-0.063226776-4.93703814618
            2923.27682927-0.2631379530.6549868060.4107766710.1767172230.0947015320.0489918010.0209082330.002927157-0.42370073924
            3023.382926830.3514310310.5609292160.3643018220.1732814550.1416979010.1382771460.1401688340.1417070943.60527867129
            3123.489024390.395690315-0.066462198-0.258138547-0.205388885-0.197654279-0.176071907-0.151299184-0.128377314-1.70132239321
            3223.595121950.721712043-0.292823652-0.418959293-0.281619772-0.254748737-0.225185396-0.196818317-0.171378242-3.47530058519
            3323.701219511.5521933950.0864159580.0863911850.0740992240.0984431410.1210304110.1333524080.1398319437.00702282433
            3423.807317071.997078392-0.038090454-0.102832173-0.046520693-0.063922568-0.088015942-0.115174333-0.138485058-8.21135424417
            3523.913414632.841496950.3873809450.4515175090.3409668090.3361553320.3260991170.3007394380.2705878516.83164141536
            3624.01951222.958179758-0.058941455-0.0423709350.0299024980.0430938460.0516654720.047556740.03744244-3.08604055924
            3724.125609763.174522286-0.400863095-0.427705012-0.217076573-0.170822952-0.11932089-0.077735545-0.0462540841.15964610927
            3824.231707323.702191912-0.471302775-0.656044245-0.385008478-0.356091937-0.303494271-0.248620586-0.1992492220.68591228526
            3924.337804884.7723395550.056487162-0.352617009-0.215816594-0.269509736-0.277193345-0.26725822-0.251397075-4.53283961623
          Quantum4024.443902446.2595485171.2689011480.7911839490.5301172480.3999348050.3354974260.2884108820.2492013682.43330221737
          Projection ->4124.496951226.8945250131.8149442461.3140163480.8773553530.7133183810.6219876010.5468472540.480006646-3.08604055934.6739115

          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
            11116 Posts
            Online
            Posted: October 17, 2012, 1:52 am - IP Logged

            I got it to work. What is the procedure TO SEE A SINE WAVE ON ANOTHER SCREEN PLOTTING THESE POINTS?

            How about them cowboys!

             

             

            US Flag

              Avatar
              bgonçalves
              Brasil
              Member #92564
              June 9, 2010
              2122 Posts
              Offline
              Posted: October 17, 2012, 8:10 am - IP Logged
              Hello, jade, this version, you can install the Excel 2010 or higher? In seven window?
              You can also predict wave patterns with matrix?
              If there are patterns that come in 80% to 100%, I can not go against them because they will lose, so first in prediction patterns are, the more patterns the better to predict!! You can miss the number but can not escape the standard
                The great advantage of the quantum will predict patterns, so the number is not provided for this or that, here enters the filters and wheels because they (standards) are 80% to 100% of the time, and also serves to be a reference or pivot, not to walk in circles
                An example of pattern, if you split into 4 groups, a lottery 49/6,
                One group will have zero or a number, and another two or more number of draws in 100%
                If the matrix, provide two numbers in groups of zero or one will miss, and if the matrix
              Provide a number where the group also has two vai err, who commands the lottery
                Are the standards, and the more the merrier!
                MillionsWanted's avatar - 24Qa6LT

                Norway
                Member #9517
                December 10, 2004
                1272 Posts
                Offline
                Posted: October 17, 2012, 11:17 am - IP Logged

                Got (almost) good results with Regression set to: Power. Else the settings are like Jadelottery posted above.

                So good I decided to deliver one line five times to the lottery company. Need to test it more, but it looks promising.

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

                  Before continuing on, we'd like to keep this thread focused on three main parts:

                  1. The installation of the Excel 2007 addin.

                  2. The functionality of the addin's controls.

                  3. The Wave Matrix output.

                  We would like to avoid turning this in to an Excel 'How to..' seminar.

                  If you need to know how to use features and functions that are outside the scope of this addin, we recommend doing some online research for Excel or you can buy some good books on Excel at www.amazon.com.

                  We did; that's how we were able to develop this addin.

                  Please keep the topic of discussion about the addin only.

                  Also, we realize there may be other concepts, ideas, methods, etc. about analyzing lottery numbers, however, unless it has some direct relationship to this addin, we may not respond to a post beyond 'that's a good idea'.

                  Sorry, we don't have the time or effort to evaluate, research, or recommend development of any external works that may or may not be related to this addin.

                  Again, please keep any post relative to this addin.

                  Thank you.

                  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
                    11116 Posts
                    Online
                    Posted: October 18, 2012, 2:39 pm - IP Logged

                    Fl p4 for tonight and the next few draws.  I used power,classic, 10 waves, 15 iterations.

                     

                    PowerBMA Degree 1BMA Degree 2BMA Degree 3BMA Degree 4BMA Degree 5BMA Degree 6BMA Degree 7BMA Degree 8BMA Degree 9BMA Degree 10
                    3206.9209740.8916541.59739475.58479274.975691.26807775.50479750505050
                    -0.057609455
                    RegressionWave 1Wave 2Wave 3Wave 4Wave 5Wave 6Wave 7Wave 8Wave 9Wave 10RemainderData
                    3206.920974251.8903699-334.2514695-1305.5598751.3735E-109-2.55659E-462.55659E-46000001819
                    3081.38585357.8242163-242.00829852995.7982321.4451E-77-3.0063E-463.0063E-46000006193
                    3010.24305523.6991452-281.6779628-1397.2642331.17007E-45-3.49497E-46-8.20576E-46000001855
                    2960.764807740.2103197-224.4339704-496.54115615.68434E-14-3.63369E-463.63369E-46000002980
                    2922.947243983.594832758.79552171-1196.3375981.17007E-45-3.33949E-46-8.36124E-46000002769
                    2892.4068961205.20815540.4220444-869.03709011.4451E-77-2.61997E-462.61997E-46000003769
                    2866.8344871340.765702917.67228673032.7275251.3735E-109-1.78483E-461.78483E-46000008158
                    2844.8654821347.226856759.23853843370.6691251.1036E-141-1.08261E-461.08261E-46000008322
                    2825.6272281244.964012169.6262996-3442.2175397.868E-174-5.97524E-475.97524E-4700000798
                    2808.5282891105.027192-243.86047628.304995395.1214E-206-3.05224E-473.05224E-47000003698
                    2793.149572986.8477347-355.2301733-2296.7671343.1015E-238-1.46188E-471.46188E-47000001128
                    2779.183446916.1007072-223.64555462324.3614021.7706E-270-6.63156E-486.63156E-48000005796
                    2766.39753886.1797154-155.1477186355.57047289.6204E-303-2.87251E-482.87251E-48000003853
                    2754.61207886.8527156-82.15755303-3243.3072330-1.19804E-481.19804E-4800000316
                    2743.685204904.9053411111.92401493588.485440-4.90807E-494.90807E-49000007349
                    2733.503043918.8056266139.8762809-985.18495030-2.18697E-492.18697E-49000002807
                    2729.465498922.423003499.20608781-6753.691625-8.9744E-53-1.54713E-491.54803E-4900000-3002.597035

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

                      Looks like a problem with too little data or too many waves.

                      Also, does the data your analyzing look like it's a Power regression?

                      What kind data are you looking at?

                      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
                        11116 Posts
                        Online
                        Posted: October 18, 2012, 3:39 pm - IP Logged

                        The draws at the far right of the sheet.  I'll wait and see if it is close with the results tonight. Right now I'm knee deep in testing,  off the cuff so to speak.   I backtested with some Fl p3 and there was a hit(box) on the next draw. 

                        I'm working on NM at the present time.  This is a backtest from 9 draws back and the 1293 all showed in the next few draws.

                        Type =LinearBMA Degree 1BMA Degree 2
                        A =500.274725353-0.4
                        B =6.496703297
                        IndexRegressionWave 1Wave 2RemainderData
                        1506.7714286161.2285714-4.906E-154.906E-15668
                        2513.2681319162.7318681-5.02076E-155.02076E-15676
                        3519.7648352-247.7648352-5.14695E-15-2.32748E-14272
                        4526.2615385199.7384615-5.22688E-155.22688E-15726
                        5532.7582418-331.7582418-5.26917E-155.26917E-15201
                        6539.2549451-484.2549451-5.26218E-155.26218E-1555
                        7545.7516484252.2483516-5.19211E-15-2.32296E-14798
                        8552.2483516273.7516484-5.02538E-155.02538E-15826
                        9558.7450549123.2549451-4.79676E-154.79676E-15682
                        10565.2417582-89.24175824-4.52391E-15-9.68694E-15476
                        11571.738461511.26153846-4.21483E-154.21483E-15583
                        12578.235164856.76483516-3.90906E-15-3.19637E-15635
                        13584.7318681-275.7318681-3.62982E-153.62982E-15309
                        14591.2285714187.7714286-3.41285E-153.41285E-15779
                        15594.1408867699.1831657-3.3316E-15-5.13503E-151293.324052

                        How about them cowboys!

                         

                         

                        US Flag

                          lakerben's avatar - spherewall
                          New Mexico
                          United States
                          Member #86099
                          January 29, 2010
                          11116 Posts
                          Online
                          Posted: October 18, 2012, 4:04 pm - IP Logged

                          Fl p3 evening.  The 504 hit on October 12th with this data.

                          Type =LinearBMA Degree 1BMA Degree 2
                          A =516.16190480.60.6
                          B =-10.40357143
                          IndexRegressionWave 1Wave 2RemainderData
                          1505.7583333105.683041541.1324597-76.57383451576
                          2495.354761985.1306490536.41357255378.1010165995
                          3484.951190524.924084314.681034297-1.556309081513
                          4474.547619-36.92717826-27.05522009-313.565220797
                          5464.1440476-63.83660072-32.87725595-12.43019095355
                          6453.7404762-70.89239745-27.4771446-70.37093414285
                          7443.3369048-66.44388221-18.44972113260.5566986619
                          8432.9333333-75.3875935-26.26389929-39.28184055292
                          9422.5297619-75.94387966-33.21049162-9.375390624304
                          10412.1261905-57.88268176-30.60883656-323.63467220
                          11401.722619-4.415088124-3.13272448112.82519356407
                          12391.319047647.3443235521.85481255450.4818163911
                          13380.915476259.8907421916.57151879-173.3777372284
                          14370.511904874.3334247716.21898956-176.0643191285
                          15360.108333396.4812829926.5356216287.87476206571
                          16355.2533333104.717095930.6350507529.80021902520.405699

                          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: October 18, 2012, 8:38 pm - IP Logged

                            The draws at the far right of the sheet.  I'll wait and see if it is close with the results tonight. Right now I'm knee deep in testing,  off the cuff so to speak.   I backtested with some Fl p3 and there was a hit(box) on the next draw. 

                            I'm working on NM at the present time.  This is a backtest from 9 draws back and the 1293 all showed in the next few draws.

                            Type =LinearBMA Degree 1BMA Degree 2
                            A =500.274725353-0.4
                            B =6.496703297
                            IndexRegressionWave 1Wave 2RemainderData
                            1506.7714286161.2285714-4.906E-154.906E-15668
                            2513.2681319162.7318681-5.02076E-155.02076E-15676
                            3519.7648352-247.7648352-5.14695E-15-2.32748E-14272
                            4526.2615385199.7384615-5.22688E-155.22688E-15726
                            5532.7582418-331.7582418-5.26917E-155.26917E-15201
                            6539.2549451-484.2549451-5.26218E-155.26218E-1555
                            7545.7516484252.2483516-5.19211E-15-2.32296E-14798
                            8552.2483516273.7516484-5.02538E-155.02538E-15826
                            9558.7450549123.2549451-4.79676E-154.79676E-15682
                            10565.2417582-89.24175824-4.52391E-15-9.68694E-15476
                            11571.738461511.26153846-4.21483E-154.21483E-15583
                            12578.235164856.76483516-3.90906E-15-3.19637E-15635
                            13584.7318681-275.7318681-3.62982E-153.62982E-15309
                            14591.2285714187.7714286-3.41285E-153.41285E-15779
                            15594.1408867699.1831657-3.3316E-15-5.13503E-151293.324052

                            I see you're using the data upside-down.

                            Try:

                            Mon Sep 24 2012779
                            Tue Sep 25 2012309
                            Wed Sep 26 2012635
                            Thu Sep 27 2012583
                            Fri Sep 28 2012476
                            Sat Sep 29 2012682
                            Mon Oct 1 2012826
                            Tue Oct 2 2012798
                            Wed Oct 3 201255
                            Thu Oct 4 2012201
                            Fri Oct 5 2012726
                            Sat Oct 6 2012272
                            Mon Oct 8 2012676
                            Tue Oct 9 2012668

                            Newest draws or data needs to be on the bottom of the sheet.

                             

                              Type =LinearBMA Degree 1BMA Degree 2   
                              A =597.725274751.111.503   
                              B =-6.496703297       
                              IndexRegressionWave 1Wave 2RemainderData
                              1591.2285714187.77142862.26979E-16-2.26979E-16779
                              2584.7318681-275.73186815.6466E-16-5.6466E-16309
                              3578.235164856.764835161.424E-15-1.424E-15635
                              4571.738461511.261538463.14005E-15-3.14005E-15583
                              5565.2417582-89.241758245.46104E-158.74981E-15476
                              6558.7450549123.25494515.26131E-15-5.26131E-15682
                              7552.2483516273.75164846.49076E-15-6.49076E-15826
                              8545.7516484252.24835168.40528E-152.00164E-14798
                              9539.2549451-484.25494513.14061E-15-3.14061E-1555
                              10532.7582418-331.7582418-2.89529E-152.89529E-15201
                              11526.2615385199.7384615-7.87219E-15-2.05495E-14726
                              12519.7648352-247.7648352-5.19942E-155.19942E-15272
                              13513.2681319162.7318681-2.53684E-152.53684E-15676
                            Quantum14506.7714286161.2285714-1.18653E-151.18653E-15668
                            Projection ->15504.48880313.364423739-7.37369E-162.89529E-15507.8532268

                             

                             

                            Also, you can do a integer-modulus for the projection, something like ' =INT(MOD(A1,1000)) ', where A1 is the cell you want to modify to get a proper Pick 3 number.

                            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 18, 2012, 8:54 pm - IP Logged

                              Try a little more draws.

                              Tue, Sep 18, 2012494
                              Wed, Sep 19, 2012165
                              Thu, Sep 20, 2012491
                              Fri, Sep 21, 2012887
                              Sat, Sep 22, 2012462
                              Mon, Sep 24, 2012779
                              Tue, Sep 25, 2012309
                              Wed, Sep 26, 2012635
                              Thu, Sep 27, 2012583
                              Fri, Sep 28, 2012476
                              Sat, Sep 29, 2012682
                              Mon, Oct 1, 2012826
                              Tue, Oct 2, 2012798
                              Wed, Oct 3, 201255
                              Thu, Oct 4, 2012201
                              Fri, Oct 5, 2012726
                              Sat, Oct 6, 2012272
                              Mon, Oct 8, 2012676
                              Tue, Oct 9, 2012668
                              Wed, Oct 10, 2012829
                              Thu, Oct 11, 2012123
                              Fri, Oct 12, 2012294
                              Sat, Oct 13, 2012380
                              Mon, Oct 15, 2012482
                              Tue, Oct 16, 2012481
                              Wed, Oct 17, 2012460

                               

                              I got the following using both Amplitude and Frequency, Wave BMA RMS = 0.70, Amplitude to Frequency = 0.75, everything else default.

                               

                                Type =LinearBMA Degree 1BMA Degree 2     
                                A =564.22769232.4912.579     
                                B =-4.090940171         
                                IndexRegressionWave 1Wave 2RemainderData=INT(MOD(,1000))
                                1560.1367521-125.962615318.6591147541.16674841494 
                                2556.045812-238.3005226-76.7862885-75.95900091165 
                                3551.9548718-48.43109069-4.742200109-7.781580998491 
                                4547.8639316163.174726982.2309872693.73035418887 
                                5543.772991539.66947817-26.44885103-94.9936186462 
                                6539.6820513100.059657845.0595953594.19869558779 
                                7535.5911111-70.69000625-62.39111255-93.50999231309 
                                8531.500170938.1842628317.2722298148.04333642635 
                                9527.409230842.755067373.183558199.652143667583 
                                10523.318290624.85440741-34.21574064-37.95695737476 
                                11519.2273504147.894496813.570178131.3079746682 
                                12515.1364103236.125591662.6032359412.13476217826 
                                13511.0454701136.711396265.6247617184.61837204798 
                                14506.9545299-243.0818648-108.098789-100.773876155 
                                15502.8635897-205.8804218-59.60190517-36.38126275201 
                                16498.772649635.0455199469.2535753122.9282552726 
                                17494.6817094-62.44646143-55.53768147-104.6975665272 
                                18490.5907692115.140331326.9812519243.28764752676 
                                19486.4998291174.224152735.19067403-27.91465581668 
                                20482.4088889167.761075878.81606397100.0139714829 
                                21478.3179487-171.2856026-82.38297403-101.6493721123 
                                22474.2270085-165.1315863-32.7513165817.65589435294 
                                23470.1360684-89.30796708-3.1475813152.319480016380 
                                24466.0451282-11.061290916.1682677510.84789495482 
                                25461.9541889.5843900089.3148633040.146558654481 
                              Quantum26457.86324795.1042852590.339675933-3.307209056460 
                              Projection ->27455.817777880.7360529460.22781148-101.6493721495.1322701495
                                27455.817777880.7360529460.22781148-104.6975665492.0840757492
                                27455.817777880.7360529460.227811489.652143667606.4337859606
                                27455.817777880.7360529460.227811482.319480016599.1011222599
                                27455.817777880.7360529460.22781148-94.9936186501.7880236501
                                27455.817777880.7360529460.2278114894.19869558690.9803378690
                                27455.817777880.7360529460.22781148-93.50999231503.2716499503
                                27455.817777880.7360529460.2278114894.19869558690.9803378690

                              I put the integer-modulus in the last column in line 27.

                              Then I also copied and pasted line 27 several times to get different pick 3 numbers.

                              This is for tonight's draw, 2012-10-18.

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