The Wave Matrix - Excel 2007 AddinPrev Topic Next Topic

New Topic New Poll

JADELottery

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 16, 2012, 8:05 pm

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.

The One Over None
I Know...
JADELottery

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 16, 2012, 11:26 pm

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...

The One Over None
I Know...
JADELottery

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 16, 2012, 11:34 pm

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....

The One Over None
I Know...
JADELottery

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 17, 2012, 12:29 am

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...

The One Over None
I Know...

JADELottery

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 17, 2012, 1:03 am

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 =	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...

lakerben

50

New Mexico
United States
Member #86,096
January 29, 2010
24,863 Posts
Offline

Oct 17, 2012, 1:52 am

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

I'm sitting here listening to Merle Haggard sipping some coffee!
dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,780 Posts
Offline

Oct 17, 2012, 8:10 am

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

Norway
Member #9,517
December 10, 2004
1,904 Posts
Offline

Oct 17, 2012, 11:17 am

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

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 17, 2012, 6:48 pm

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.

The One Over None
I Know...

lakerben

New Mexico
United States
Member #86,096
January 29, 2010
24,863 Posts
Offline

Oct 18, 2012, 2:39 pm

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

I'm sitting here listening to Merle Haggard sipping some coffee!

JADELottery

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 18, 2012, 2:54 pm

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?

The One Over None
I Know...

lakerben

New Mexico
United States
Member #86,096
January 29, 2010
24,863 Posts
Offline

Oct 18, 2012, 3:39 pm

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'm sitting here listening to Merle Haggard sipping some coffee!

lakerben

New Mexico
United States
Member #86,096
January 29, 2010
24,863 Posts
Offline

Oct 18, 2012, 4:04 pm

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

I'm sitting here listening to Merle Haggard sipping some coffee!

JADELottery

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 18, 2012, 8:38 pm

Quote: Originally posted by lakerben on Oct 18, 2012

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...

JADELottery

Native American Eagle Sun

MN
United States
Member #21
December 7, 2001
4,811 Posts
Offline

Oct 18, 2012, 8:54 pm

Try 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...

New Topic New Poll

Subscribe to this topic

The Wave Matrix - Excel 2007 AddinPrev TopicNext Topic

The Wave Matrix - Excel 2007 AddinPrev Topic Next Topic