The Wave Matrix - Excel 2007 AddinPrev TopicNext Topic

• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Oct 23, 2012, 9:32 am

  ▲▼

  UWP hint:

  You might think there are a lot of lines of code for the Ultimate Wave Predictor.

  Nope.

  There are only 4 lines of code.

  This includes the ' Return ' statement the performs a simple division when returning the predicted value.

  As matter of fact, now that we think about it, it could be reduced to 3... hmmm...

  The One Over None
  I Know...
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Oct 24, 2012, 9:50 am

  ▲▼
  In response to JADELottery

  Quote: Originally posted by JADELottery on Oct 23, 2012

  UWP hint:

  You might think there are a lot of lines of code for the Ultimate Wave Predictor.

  Nope.

  There are only 4 lines of code.

  This includes the ' Return ' statement the performs a simple division when returning the predicted value.

  As matter of fact, now that we think about it, it could be reduced to 3... hmmm...

  We got it down to 3 lines of code; includes a variable declaration, a For loop, and a Return statement.
  
  If we have time, we will get to the equation set evolution of the UWP.
  
  We're finishing the sewing on our Star Trek uniform coat for this weekend's Halloween party.

  The One Over None
  I Know...
• MillionsWanted

  

  Norway
  Member #9,517
  December 10, 2004
  1,904 Posts
  Offline
  Nov 12, 2012, 6:16 pm

  ▲▼

  The national lottery company is going to allow players to bet on which number is drawn first from the machine.

  Here's a chance for your addin to show its capabilities.
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Nov 12, 2012, 6:33 pm

  ▲▼
  In response to MillionsWanted

  Quote: Originally posted by MillionsWanted on Nov 12, 2012

  The national lottery company is going to allow players to bet on which number is drawn first from the machine.

  Here's a chance for your addin to show its capabilities.

  oo-oo, don't break it.

  
  ggoooodd lluucckk.

   

  

  The One Over None
  I Know...
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Nov 14, 2012, 1:40 pm

  ▲▼

  Beeeen tryin' somethin'.

  We're postin' on der perdic'shens bird using this somethin' fir MN Northstar Cash and Gopher 5.

  It's related to ftp://www.jadexcode.com/Excel/CombinatorialIndex.xls and we'll detail somem'er laterrr.

  The One Over None
  I Know...
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Nov 14, 2012, 7:59 pm

  ▲▼

  Great functions! For Fact() I get in the worksheetfunction.
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Nov 14, 2012, 8:40 pm

  ▲▼
  In response to JADELottery

  Quote: Originally posted by JADELottery on Nov 14, 2012

  Beeeen tryin' somethin'.

  We're postin' on der perdic'shens bird using this somethin' fir MN Northstar Cash and Gopher 5.

  It's related to ftp://www.jadexcode.com/Excel/CombinatorialIndex.xls and we'll detail somem'er laterrr.

  ok, here's what we are doing with the above CombinatorialIndex.xls file.

  this addin and the functions in the file are two different things.

  you'll need both to do this.

  we'll use Gopher 5 (31 / 5) as an example.

  download the CombinatorialIndex.xls spread sheet; it has macro functions for generating the Index number of a combination and making a combination from an Index number.

  The Index number is like the following for Gopher 5:

  Index - Combination

  1 - 01 02 03 04 05

  2 - 01 02 03 04 06

  3 - 01 02 03 04 07

  ...

  169909 - 26 27 29 30 31

  169910 - 26 28 29 30 31

  169911 - 27 28 29 30 31

   

  we have some capture software that can download Gopher 5 numbers right from the Lottery Post.

  we loaded the numbers in the spreadsheet and sorted them with oldest draws at the top of the sheet and newest draws at the bottom.

  in our latest posted numbers, we used just this year's draws from Jan-01 to now, Nov-14.

  we'll post just this months combos with the index numbers.

  Month	Day	Year	Combo					Index
  11	1	2012	11	15	16	20	23	152069
  11	2	2012	6	10	13	15	18	109847
  11	3	2012	2	13	21	22	27	47936
  11	4	2012	3	12	19	22	27	67495
  11	5	2012	18	21	24	28	30	168375
  11	6	2012	5	20	22	25	28	103699
  11	7	2012	5	20	27	28	31	103794
  11	8	2012	1	14	17	26	27	24647
  11	9	2012	6	17	24	27	31	115739
  11	10	2012	1	18	21	24	26	26544
  11	11	2012	1	14	17	23	29	24631
  11	12	2012	6	10	13	14	30	109843
  11	13	2012	5	9	23	24	27	96735
  11	14	2012	3	8	12	24	27	61782

  the Index number is generated with the function =Combin2Index(31,5,??:??), where ??:?? is the range for the single combo you are looking for; usually it's the range in the same line as the combo.

  like the last line for Nov-14, 3 8 12 24 27 has an Index number of 61782.

  next we use the Excel Addin to analyze the Index numbers and project the regression, waves, and remainder to the next possible Index number.

  we do this by setting the Regression to Linear, Waves to 12, BMA Iteration to 12, the Wave / BMA ratio to 0.70, the Amp / Freq ratio to 0.25 and using the Quantum setting with a Depth and Level at 25 for the Ultimate Wave Predictor.

  Press the Generate Wave Matrix button and POOF!! There it is.

  next we go to the Quantum Projection line and just after the last column we enter this function:

  =Index2Combin(31,5,INT(MOD(???-1,COMB(31,5)))+1), where ??? is the cell just to the left.

  it's the Data column with the Quantum Projected Index number for the next drawing.

  finally, we copy the entire Quantum Projection line and paste it 49 more times just under the Quantum Projection line.

  this gives us 50 numbers to post, but you can choose how many you'd like to generate.

  this is what it would look like, but keep in mind these combos are different from the ones we posted because they are recalculated each time we do something on the spreadsheet.

  we're just posting the Data and Combo columns. problems with formatting when posting.

  66960.87531	03 12 14 16 21
  41374.75964	02 08 13 16 25
  81069.98631	04 09 14 16 19
  96513.91168	05 09 18 25 29
  7943.136017	01 04 08 14 26
  72396.09116	04 05 08 20 22
  9089.640102	01 04 14 18 23
  122903.373	07 12 15 19 29
  81069.98631	04 09 14 16 19
  121826.0677	07 11 14 20 30
  110275.5749	06 10 16 19 31
  16776.69282	01 07 28 29 30
  6921.549343	01 03 27 28 29
  20563.63128	01 10 13 22 26
  123061.7044	07 12 16 25 31
  137375.4484	09 10 20 21 24
  44048.85049	02 10 12 13 30
  66960.87531	03 12 14 16 21
  93958.25318	05 08 11 12 24
  86919.23573	04 15 17 18 31
  57133.24125	03 06 08 19 20
  8807.97695	01 04 12 18 30
  73518.52569	04 05 14 23 26
  160996.1541	13 20 26 27 30
  115847.6383	06 18 20 21 22
  141389.1473	09 15 17 28 30
  149290.9914	10 21 23 27 31
  120411.0916	07 10 12 22 25
  33591.38658	02 04 26 28 29
  75379.12855	04 06 11 26 29
  10418.26413	01 05 07 26 28
  15774.00371	01 07 12 22 31
  143719.1855	10 11 12 23 30
  -21530.7777	10 17 20 25 30
  43291.4632	02 09 16 17 27
  80081.30152	04 08 19 24 27
  97630.71442	05 10 16 20 25
  21429.82659	01 11 12 13 22
  101882.5078	05 15 17 20 21
  17863.38416	01 08 14 27 30
  43531.25575	02 09 18 24 28
  90683.61235	05 06 14 16 18
  7674.368472	01 04 07 13 27
  64181.11474	03 09 21 25 31
  83530.64243	04 11 14 15 25
  156911.0041	12 16 27 28 31
  90834.45093	05 06 15 18 22
  32227.66563	02 04 10 21 27
  27886.34745	02 03 05 11 26
  98224.39905	05 11 12 17 29

  The One Over None
  I Know...
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Nov 14, 2012, 9:23 pm

  ▲▼
  In response to SergeM

  Quote: Originally posted by SergeM on Nov 14, 2012

  Great functions! For Fact() I get in the worksheetfunction.

  great.
  
  be careful with Fact() though.
  
  it's level of precision is only as good as the level of precision that Excel is capable of handling.
  
  numbers beyond 20 don't carry out the digits completely in Excel.
  
  they tend to get dropped at 15 digits followed by only zeros.

  The One Over None
  I Know...
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Nov 15, 2012, 6:51 am

  ▲▼

  I programed factorial in several ways. The last version was the same than yours.

  

  
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  24,778 Posts
  Offline
  Nov 15, 2012, 10:58 pm

  ▲▼

  

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

   

  
• MillionsWanted

  

  Norway
  Member #9,517
  December 10, 2004
  1,904 Posts
  Offline
  Nov 16, 2012, 3:43 am

  ▲▼

  Thanks.

    I'll see if I can adapt this for the pick-6 and pick-7 lotteries in my country.
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Nov 16, 2012, 12:11 pm

  ▲▼

  

  My sort does it.

  
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Nov 16, 2012, 12:31 pm

  ▲▼

  

  A bit more sophisticated.

  
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Nov 16, 2012, 9:15 pm

  ▲▼

  well, kind of messed that up.

  was posting Northstar Cash numbers, but put them in the Gopher 5 slot.

  these are suppose to be the Gopher 5 numbers.

  19 20 25 28 44
  03 09 20 27 39
  14 31 32 34 45
  07 10 25 30 34
  13 18 22 27 40
  07 17 27 41 47
  10 11 18 32 33
  09 11 30 43 44
  14 36 38 43 45
  20 22 24 29 40
  05 06 09 20 27
  11 13 22 23 29
  10 11 20 41 46
  14 36 38 43 45
  12 20 26 41 44
  12 17 19 28 42
  02 05 12 27 31
  01 07 14 21 43
  02 13 18 23 36
  12 13 14 23 42
  02 26 29 33 35
  11 13 19 46 47
  08 10 13 27 31
  04 10 24 31 45
  09 12 13 27 37
  04 07 12 15 28
  08 09 10 35 40
  25 29 32 36 38
  03 17 22 26 45
  04 12 28 31 33
  17 18 25 31 39
  08 21 22 34 35
  19 26 30 36 41
  02 20 23 31 38
  20 28 36 37 42
  03 09 32 37 47
  02 03 24 35 44
  11 13 20 39 40
  09 38 42 45 47
  10 20 28 38 43
  10 16 28 35 39
  06 11 20 29 38
  12 16 18 28 36
  13 23 27 39 45
  13 21 22 38 43
  09 23 27 32 38
  08 14 22 23 26
  14 27 28 32 47
  13 21 28 30 45
  04 22 37 39 44
  
  

  oh well, i'll start this cycle over again monday.

  The One Over None
  I Know...
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Nov 18, 2012, 9:08 am

  ▲▼

  posting some numbers for Mega Millions on the predictions board.

  to have a quick look see, we post 'em below.

  this is for 2012-11-20

  08 17 22 25 47	41
  05 09 20 27 37	24
  02 09 22 35 44	32
  02 14 20 32 36	43
  08 15 36 41 45	35
  06 17 35 44 56	42
  12 17 30 38 52	25
  08 13 14 28 38	43
  04 08 14 30 34	46
  05 20 35 39 52	42
  05 11 26 42 55	29
  03 13 28 49 55	3
  06 10 11 30 31	45
  07 14 35 37 40	39
  05 17 19 44 48	22
  03 07 15 40 52	5
  08 13 21 37 53	4
  12 14 35 52 56	36
  07 13 40 42 53	28
  12 15 32 36 53	13
  02 12 17 22 34	45
  04 06 13 18 53	31
  13 20 44 50 51	4
  12 24 25 36 54	32
  05 08 14 19 31	5
  11 17 25 36 47	28
  03 04 07 11 34	33
  15 16 24 52 54	44
  11 25 30 33 54	19
  07 39 44 51 52	32
  08 11 14 15 22	34
  07 09 29 39 49	3
  09 16 31 32 38	29
  16 31 33 36 48	8
  14 17 26 29 52	43
  02 06 15 48 54	17
  05 08 14 19 31	1
  09 19 25 35 36	29
  07 09 18 34 42	3
  22 27 35 55 56	9
  01 15 37 51 52	24
  12 15 32 36 53	22
  03 04 09 45 53	31
  07 36 40 50 55	35
  04 09 11 12 15	33
  09 17 20 24 39	13
  01 24 26 31 49	4
  07 16 32 51 55	36
  06 09 33 34 56	44
  08 18 21 40 55	32

  The One Over None
  I Know...