- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 5:54 am
You last visited
May 4, 2024, 4:49 am
All times shown are
Eastern Time (GMT-5:00)
The Wave Matrix - Excel 2007 AddinPrev TopicNext Topic
-
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineWe 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.
The One Over None
I Know... -
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineFirst 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...The One Over None
I Know... -
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineWe'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....
The One Over None
I Know... -
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineHere'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...
The One Over None
I Know... -
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineNote, 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 = Linear BMA Degree 1 BMA Degree 2 BMA Degree 3 BMA Degree 4 BMA Degree 5 BMA Degree 6 BMA Degree 7 BMA Degree 8 A = 20.2 1.026 1.105 1.191 1.073 1.095 1.119 1.135 1.145 B = 0.106097561 Index Regression Wave 1 Wave 2 Wave 3 Wave 4 Wave 5 Wave 6 Wave 7 Wave 8 Remainder Data 1 20.30609756 3.685900474 0.507538385 0.345088806 0.223708371 0.157618285 0.111993805 0.078262927 0.054691136 0.52910025 26 2 20.41219512 3.134961988 0.075847034 -0.01530239 0.010530623 -0.006686465 -0.017931992 -0.026605773 -0.032707181 -1.534300966 22 3 20.51829268 2.621739056 -0.255885953 -0.236530042 -0.103247778 -0.057157808 -0.020331668 0.004460969 0.019734977 1.508925565 24 4 20.62439024 2.233126706 -0.525366794 -0.506035318 -0.272498342 -0.19591364 -0.136139985 -0.093333044 -0.064898681 -0.063331145 21 5 20.7304878 2.300776441 -0.37985085 -0.452294371 -0.263145514 -0.202011807 -0.150646088 -0.112002773 -0.085500779 -3.385812063 18 6 20.83658537 2.860182487 0.303133614 0.132584761 0.069075472 0.085176431 0.113198224 0.13670537 0.153429117 6.309929158 31 7 20.94268293 2.93875543 0.464915285 0.024906525 -0.073225876 -0.149066746 -0.193105533 -0.214630643 -0.221647805 -3.519583564 20 8 21.04878049 3.100735038 1.016633322 0.538613831 0.238479269 0.104944427 0.012700619 -0.051401773 -0.094475061 -5.91501016 20 9 21.15487805 2.919150603 1.591973615 1.409263518 0.852303413 0.754644893 0.692553929 0.636781821 0.586490423 10.40195974 41 10 21.26097561 0.825493057 0.174463979 0.112844908 0.054889452 0.02689194 0.008781667 -0.001061418 -0.004975776 -1.45830342 21 11 21.36707317 -1.336485264 -1.256749721 -1.140228581 -0.701529151 -0.643900283 -0.606613577 -0.564246426 -0.518578314 -6.598741855 8 12 21.47317073 -1.993173245 -1.1115957 -0.68144903 -0.33222561 -0.221890455 -0.154132248 -0.10717923 -0.072760505 2.201235291 19 13 21.57926829 -1.989396588 -0.575227671 -0.039782556 0.112196387 0.208060415 0.251616025 0.259531626 0.248470454 3.945263616 24 14 21.68536585 -2.043431425 -0.455338698 -0.075429051 0.05925726 0.119746022 0.134720274 0.121059011 0.093621291 -6.639570537 13 15 21.79146341 -1.743825559 -0.104243754 0.142071983 0.146116121 0.21300925 0.262666098 0.290931364 0.303795999 9.698015083 31 16 21.89756098 -1.980586289 -0.592290555 -0.816583672 -0.588106968 -0.578159117 -0.552734932 -0.509496067 -0.459234721 -4.820368654 11 17 22.00365854 -1.199716228 0.146197501 -0.382834835 -0.391783534 -0.47785546 -0.516870969 -0.518059903 -0.498338679 -7.16439643 11 18 22.1097561 0.266958761 2.008925306 1.554605761 0.854236402 0.695118272 0.602042659 0.531352497 0.473834646 5.903169597 35 19 22.21585366 -0.164344851 2.120151254 1.780848635 1.020857928 0.857238428 0.753747403 0.667048706 0.591615097 6.156983742 36 20 22.32195122 -2.710299339 0.200854822 -0.002140425 -0.090469572 -0.170302197 -0.219250078 -0.244017143 -0.25352169 -6.832805598 12 21 22.42804878 -4.93102813 -1.138273232 -0.903790779 -0.573139145 -0.518807239 -0.471154165 -0.418423914 -0.365474647 0.89204247 14 22 22.53414634 -6.126147268 -1.538772031 -0.89396592 -0.464930497 -0.34624153 -0.27029473 -0.214663471 -0.173219571 -2.505911326 10 23 22.6402439 -6.181432968 -1.088558466 -0.145294423 0.083889242 0.209264757 0.274409194 0.298254375 0.297836539 2.611387847 19 24 22.74634146 -6.051963089 -0.998419641 -0.067549075 0.122138967 0.221791062 0.26577837 0.274894022 0.265860506 4.221127414 21 25 22.85243902 -5.832866061 -1.357517131 -0.737846671 -0.385624679 -0.336101108 -0.322338471 -0.314108173 -0.304916775 -5.261119955 8 26 22.95853659 -4.41743786 -0.70016411 -0.322438027 -0.181791176 -0.180231273 -0.185480894 -0.184177652 -0.176353735 -2.610461858 14 27 23.06463415 -2.407554762 0.442462798 0.633167274 0.387024375 0.342396448 0.318076951 0.300335563 0.286982565 7.632474642 31 28 23.17073171 -1.264671921 0.524596566 0.375126437 0.161858175 0.0660097 0.003680101 -0.037065843 -0.063226776 -4.937038146 18 29 23.27682927 -0.263137953 0.654986806 0.410776671 0.176717223 0.094701532 0.048991801 0.020908233 0.002927157 -0.423700739 24 30 23.38292683 0.351431031 0.560929216 0.364301822 0.173281455 0.141697901 0.138277146 0.140168834 0.141707094 3.605278671 29 31 23.48902439 0.395690315 -0.066462198 -0.258138547 -0.205388885 -0.197654279 -0.176071907 -0.151299184 -0.128377314 -1.701322393 21 32 23.59512195 0.721712043 -0.292823652 -0.418959293 -0.281619772 -0.254748737 -0.225185396 -0.196818317 -0.171378242 -3.475300585 19 33 23.70121951 1.552193395 0.086415958 0.086391185 0.074099224 0.098443141 0.121030411 0.133352408 0.139831943 7.007022824 33 34 23.80731707 1.997078392 -0.038090454 -0.102832173 -0.046520693 -0.063922568 -0.088015942 -0.115174333 -0.138485058 -8.211354244 17 35 23.91341463 2.84149695 0.387380945 0.451517509 0.340966809 0.336155332 0.326099117 0.300739438 0.270587851 6.831641415 36 36 24.0195122 2.958179758 -0.058941455 -0.042370935 0.029902498 0.043093846 0.051665472 0.04755674 0.03744244 -3.086040559 24 37 24.12560976 3.174522286 -0.400863095 -0.427705012 -0.217076573 -0.170822952 -0.11932089 -0.077735545 -0.046254084 1.159646109 27 38 24.23170732 3.702191912 -0.471302775 -0.656044245 -0.385008478 -0.356091937 -0.303494271 -0.248620586 -0.199249222 0.685912285 26 39 24.33780488 4.772339555 0.056487162 -0.352617009 -0.215816594 -0.269509736 -0.277193345 -0.26725822 -0.251397075 -4.532839616 23 Quantum 40 24.44390244 6.259548517 1.268901148 0.791183949 0.530117248 0.399934805 0.335497426 0.288410882 0.249201368 2.433302217 37 Projection -> 41 24.49695122 6.894525013 1.814944246 1.314016348 0.877355353 0.713318381 0.621987601 0.546847254 0.480006646 -3.086040559 34.6739115 The One Over None
I Know... -
I got it to work. What is the procedure TO SEE A SINE WAVE ON ANOTHER SCREEN PLOTTING THESE POINTS?
Say hey!
-
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! -
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.
-
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineBefore 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.The One Over None
I Know... -
Fl p4 for tonight and the next few draws. I used power,classic, 10 waves, 15 iterations.
Power BMA Degree 1 BMA Degree 2 BMA Degree 3 BMA Degree 4 BMA Degree 5 BMA Degree 6 BMA Degree 7 BMA Degree 8 BMA Degree 9 BMA Degree 10 3206.920974 0.891654 1.597394 75.584792 74.97569 1.268077 75.504797 50 50 50 50 -0.057609455 Regression Wave 1 Wave 2 Wave 3 Wave 4 Wave 5 Wave 6 Wave 7 Wave 8 Wave 9 Wave 10 Remainder Data 3206.920974 251.8903699 -334.2514695 -1305.559875 1.3735E-109 -2.55659E-46 2.55659E-46 0 0 0 0 0 1819 3081.38585 357.8242163 -242.0082985 2995.798232 1.4451E-77 -3.0063E-46 3.0063E-46 0 0 0 0 0 6193 3010.24305 523.6991452 -281.6779628 -1397.264233 1.17007E-45 -3.49497E-46 -8.20576E-46 0 0 0 0 0 1855 2960.764807 740.2103197 -224.4339704 -496.5411561 5.68434E-14 -3.63369E-46 3.63369E-46 0 0 0 0 0 2980 2922.947243 983.5948327 58.79552171 -1196.337598 1.17007E-45 -3.33949E-46 -8.36124E-46 0 0 0 0 0 2769 2892.406896 1205.20815 540.4220444 -869.0370901 1.4451E-77 -2.61997E-46 2.61997E-46 0 0 0 0 0 3769 2866.834487 1340.765702 917.6722867 3032.727525 1.3735E-109 -1.78483E-46 1.78483E-46 0 0 0 0 0 8158 2844.865482 1347.226856 759.2385384 3370.669125 1.1036E-141 -1.08261E-46 1.08261E-46 0 0 0 0 0 8322 2825.627228 1244.964012 169.6262996 -3442.217539 7.868E-174 -5.97524E-47 5.97524E-47 0 0 0 0 0 798 2808.528289 1105.027192 -243.860476 28.30499539 5.1214E-206 -3.05224E-47 3.05224E-47 0 0 0 0 0 3698 2793.149572 986.8477347 -355.2301733 -2296.767134 3.1015E-238 -1.46188E-47 1.46188E-47 0 0 0 0 0 1128 2779.183446 916.1007072 -223.6455546 2324.361402 1.7706E-270 -6.63156E-48 6.63156E-48 0 0 0 0 0 5796 2766.39753 886.1797154 -155.1477186 355.5704728 9.6204E-303 -2.87251E-48 2.87251E-48 0 0 0 0 0 3853 2754.61207 886.8527156 -82.15755303 -3243.307233 0 -1.19804E-48 1.19804E-48 0 0 0 0 0 316 2743.685204 904.9053411 111.9240149 3588.48544 0 -4.90807E-49 4.90807E-49 0 0 0 0 0 7349 2733.503043 918.8056266 139.8762809 -985.1849503 0 -2.18697E-49 2.18697E-49 0 0 0 0 0 2807 2729.465498 922.4230034 99.20608781 -6753.691625 -8.9744E-53 -1.54713E-49 1.54803E-49 0 0 0 0 0 -3002.597035 Say hey!
-
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineLooks 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?
The One Over None
I Know... -
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 = Linear BMA Degree 1 BMA Degree 2 A = 500.2747253 53 -0.4 B = 6.496703297 Index Regression Wave 1 Wave 2 Remainder Data 1 506.7714286 161.2285714 -4.906E-15 4.906E-15 668 2 513.2681319 162.7318681 -5.02076E-15 5.02076E-15 676 3 519.7648352 -247.7648352 -5.14695E-15 -2.32748E-14 272 4 526.2615385 199.7384615 -5.22688E-15 5.22688E-15 726 5 532.7582418 -331.7582418 -5.26917E-15 5.26917E-15 201 6 539.2549451 -484.2549451 -5.26218E-15 5.26218E-15 55 7 545.7516484 252.2483516 -5.19211E-15 -2.32296E-14 798 8 552.2483516 273.7516484 -5.02538E-15 5.02538E-15 826 9 558.7450549 123.2549451 -4.79676E-15 4.79676E-15 682 10 565.2417582 -89.24175824 -4.52391E-15 -9.68694E-15 476 11 571.7384615 11.26153846 -4.21483E-15 4.21483E-15 583 12 578.2351648 56.76483516 -3.90906E-15 -3.19637E-15 635 13 584.7318681 -275.7318681 -3.62982E-15 3.62982E-15 309 14 591.2285714 187.7714286 -3.41285E-15 3.41285E-15 779 15 594.1408867 699.1831657 -3.3316E-15 -5.13503E-15 1293.324052 Say hey!
-
Fl p3 evening. The 504 hit on October 12th with this data.
Type = Linear BMA Degree 1 BMA Degree 2 A = 516.1619048 0.6 0.6 B = -10.40357143 Index Regression Wave 1 Wave 2 Remainder Data 1 505.7583333 105.6830415 41.1324597 -76.57383451 576 2 495.3547619 85.13064905 36.41357255 378.1010165 995 3 484.9511905 24.92408431 4.681034297 -1.556309081 513 4 474.547619 -36.92717826 -27.05522009 -313.5652207 97 5 464.1440476 -63.83660072 -32.87725595 -12.43019095 355 6 453.7404762 -70.89239745 -27.4771446 -70.37093414 285 7 443.3369048 -66.44388221 -18.44972113 260.5566986 619 8 432.9333333 -75.3875935 -26.26389929 -39.28184055 292 9 422.5297619 -75.94387966 -33.21049162 -9.375390624 304 10 412.1261905 -57.88268176 -30.60883656 -323.6346722 0 11 401.722619 -4.415088124 -3.132724481 12.82519356 407 12 391.3190476 47.34432355 21.85481255 450.4818163 911 13 380.9154762 59.89074219 16.57151879 -173.3777372 284 14 370.5119048 74.33342477 16.21898956 -176.0643191 285 15 360.1083333 96.48128299 26.53562162 87.87476206 571 16 355.2533333 104.7170959 30.63505075 29.80021902 520.405699 Say hey!
-
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineQuote: Originally posted by lakerben on Oct 18, 2012
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 = Linear BMA Degree 1 BMA Degree 2 A = 500.2747253 53 -0.4 B = 6.496703297 Index Regression Wave 1 Wave 2 Remainder Data 1 506.7714286 161.2285714 -4.906E-15 4.906E-15 668 2 513.2681319 162.7318681 -5.02076E-15 5.02076E-15 676 3 519.7648352 -247.7648352 -5.14695E-15 -2.32748E-14 272 4 526.2615385 199.7384615 -5.22688E-15 5.22688E-15 726 5 532.7582418 -331.7582418 -5.26917E-15 5.26917E-15 201 6 539.2549451 -484.2549451 -5.26218E-15 5.26218E-15 55 7 545.7516484 252.2483516 -5.19211E-15 -2.32296E-14 798 8 552.2483516 273.7516484 -5.02538E-15 5.02538E-15 826 9 558.7450549 123.2549451 -4.79676E-15 4.79676E-15 682 10 565.2417582 -89.24175824 -4.52391E-15 -9.68694E-15 476 11 571.7384615 11.26153846 -4.21483E-15 4.21483E-15 583 12 578.2351648 56.76483516 -3.90906E-15 -3.19637E-15 635 13 584.7318681 -275.7318681 -3.62982E-15 3.62982E-15 309 14 591.2285714 187.7714286 -3.41285E-15 3.41285E-15 779 15 594.1408867 699.1831657 -3.3316E-15 -5.13503E-15 1293.324052 I see you're using the data upside-down.
Try:
Mon Sep 24 2012 779 Tue Sep 25 2012 309 Wed Sep 26 2012 635 Thu Sep 27 2012 583 Fri Sep 28 2012 476 Sat Sep 29 2012 682 Mon Oct 1 2012 826 Tue Oct 2 2012 798 Wed Oct 3 2012 55 Thu Oct 4 2012 201 Fri Oct 5 2012 726 Sat Oct 6 2012 272 Mon Oct 8 2012 676 Tue Oct 9 2012 668 Newest draws or data needs to be on the bottom of the sheet.
Type = Linear BMA Degree 1 BMA Degree 2 A = 597.7252747 51.11 1.503 B = -6.496703297 Index Regression Wave 1 Wave 2 Remainder Data 1 591.2285714 187.7714286 2.26979E-16 -2.26979E-16 779 2 584.7318681 -275.7318681 5.6466E-16 -5.6466E-16 309 3 578.2351648 56.76483516 1.424E-15 -1.424E-15 635 4 571.7384615 11.26153846 3.14005E-15 -3.14005E-15 583 5 565.2417582 -89.24175824 5.46104E-15 8.74981E-15 476 6 558.7450549 123.2549451 5.26131E-15 -5.26131E-15 682 7 552.2483516 273.7516484 6.49076E-15 -6.49076E-15 826 8 545.7516484 252.2483516 8.40528E-15 2.00164E-14 798 9 539.2549451 -484.2549451 3.14061E-15 -3.14061E-15 55 10 532.7582418 -331.7582418 -2.89529E-15 2.89529E-15 201 11 526.2615385 199.7384615 -7.87219E-15 -2.05495E-14 726 12 519.7648352 -247.7648352 -5.19942E-15 5.19942E-15 272 13 513.2681319 162.7318681 -2.53684E-15 2.53684E-15 676 Quantum 14 506.7714286 161.2285714 -1.18653E-15 1.18653E-15 668 Projection -> 15 504.4888031 3.364423739 -7.37369E-16 2.89529E-15 507.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.
The One Over None
I Know... -
Native American Eagle SunMN
United States
Member #21
December 7, 2001
4,812 Posts
OfflineTry a little more draws.
Tue, Sep 18, 2012 494 Wed, Sep 19, 2012 165 Thu, Sep 20, 2012 491 Fri, Sep 21, 2012 887 Sat, Sep 22, 2012 462 Mon, Sep 24, 2012 779 Tue, Sep 25, 2012 309 Wed, Sep 26, 2012 635 Thu, Sep 27, 2012 583 Fri, Sep 28, 2012 476 Sat, Sep 29, 2012 682 Mon, Oct 1, 2012 826 Tue, Oct 2, 2012 798 Wed, Oct 3, 2012 55 Thu, Oct 4, 2012 201 Fri, Oct 5, 2012 726 Sat, Oct 6, 2012 272 Mon, Oct 8, 2012 676 Tue, Oct 9, 2012 668 Wed, Oct 10, 2012 829 Thu, Oct 11, 2012 123 Fri, Oct 12, 2012 294 Sat, Oct 13, 2012 380 Mon, Oct 15, 2012 482 Tue, Oct 16, 2012 481 Wed, Oct 17, 2012 460 I got the following using both Amplitude and Frequency, Wave BMA RMS = 0.70, Amplitude to Frequency = 0.75, everything else default.
Type = Linear BMA Degree 1 BMA Degree 2 A = 564.2276923 2.491 2.579 B = -4.090940171 Index Regression Wave 1 Wave 2 Remainder Data =INT(MOD(,1000)) 1 560.1367521 -125.9626153 18.65911475 41.16674841 494 2 556.045812 -238.3005226 -76.7862885 -75.95900091 165 3 551.9548718 -48.43109069 -4.742200109 -7.781580998 491 4 547.8639316 163.1747269 82.23098726 93.73035418 887 5 543.7729915 39.66947817 -26.44885103 -94.9936186 462 6 539.6820513 100.0596578 45.05959535 94.19869558 779 7 535.5911111 -70.69000625 -62.39111255 -93.50999231 309 8 531.5001709 38.18426283 17.27222981 48.04333642 635 9 527.4092308 42.75506737 3.18355819 9.652143667 583 10 523.3182906 24.85440741 -34.21574064 -37.95695737 476 11 519.2273504 147.8944968 13.57017813 1.3079746 682 12 515.1364103 236.1255916 62.60323594 12.13476217 826 13 511.0454701 136.7113962 65.62476171 84.61837204 798 14 506.9545299 -243.0818648 -108.098789 -100.7738761 55 15 502.8635897 -205.8804218 -59.60190517 -36.38126275 201 16 498.7726496 35.04551994 69.2535753 122.9282552 726 17 494.6817094 -62.44646143 -55.53768147 -104.6975665 272 18 490.5907692 115.1403313 26.98125192 43.28764752 676 19 486.4998291 174.2241527 35.19067403 -27.91465581 668 20 482.4088889 167.7610758 78.81606397 100.0139714 829 21 478.3179487 -171.2856026 -82.38297403 -101.6493721 123 22 474.2270085 -165.1315863 -32.75131658 17.65589435 294 23 470.1360684 -89.30796708 -3.147581315 2.319480016 380 24 466.0451282 -11.0612909 16.16826775 10.84789495 482 25 461.954188 9.584390008 9.314863304 0.146558654 481 Quantum 26 457.8632479 5.104285259 0.339675933 -3.307209056 460 Projection -> 27 455.8177778 80.73605294 60.22781148 -101.6493721 495.1322701 495 27 455.8177778 80.73605294 60.22781148 -104.6975665 492.0840757 492 27 455.8177778 80.73605294 60.22781148 9.652143667 606.4337859 606 27 455.8177778 80.73605294 60.22781148 2.319480016 599.1011222 599 27 455.8177778 80.73605294 60.22781148 -94.9936186 501.7880236 501 27 455.8177778 80.73605294 60.22781148 94.19869558 690.9803378 690 27 455.8177778 80.73605294 60.22781148 -93.50999231 503.2716499 503 27 455.8177778 80.73605294 60.22781148 94.19869558 690.9803378 690 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.
The One Over None
I Know...