The All New Mega Millions & Power Ball Combos Creator

Reply #49

sammy23 — Sat, 14 Apr 2012 03:05:27 GMT

Hi

can you ADD a Florida 6/53 game...thxx

Reply #48

permanentguest — Wed, 11 Apr 2012 05:14:46 GMT

Thank you so much Steve.

Reply #47

winsumloosesum — Tue, 10 Apr 2012 17:25:39 GMT

Added the following:

Minnesota, Pennsylvania 5/43 and Delaware 5/33

Excel 2002 Version

http://www.box.com/s/93eb485bf07ff34a883d

Excel 2010 Version

http://www.box.com/s/7cdd3ec905c81b3c7973

Reply #46

xaab — Tue, 10 Apr 2012 13:32:06 GMT

This is an excellent share winsumlosesum. Can you add the Minnesota gopher 5

Reply #45

winsumloosesum — Tue, 10 Apr 2012 12:45:25 GMT

Updated with Sans Topu lottery game:

Excel Version 2010 (2007)

http://www.box.com/s/7cdd3ec905c81b3c7973

Excel Version 2002

http://www.box.com/s/93eb485bf07ff34a883d

Reply #44

winsumloosesum — Tue, 10 Apr 2012 12:04:45 GMT

Updated draw histories:

Excel Version 2002:

http://www.box.com/s/93eb485bf07ff34a883d

Excel Version 2010 (Should work for Excel 2007 also) Note: Make sure you click Enable Macros

http://www.box.com/s/7cdd3ec905c81b3c7973

Reply #43

winsumloosesum — Tue, 10 Apr 2012 11:43:17 GMT

That what I have it set up as. 5/35 and cash Ball 1 to 5

Are you using the drop-down arrow in cell B8 in the Tab labeled DrawHistory ? Click the cell B8 the you should see the drop-down arrow to the right. Select your state lottery game. Follow the rest of the instructions I posted in the thread.

Reply #42

CARBOB — Tue, 10 Apr 2012 11:10:49 GMT

reddog,

If you are still having a problem, do this. Alt F11, Edit ,Replace( make sure All shows in the Direction window) .XLS With .XLSM , Current Project

Reply #41

bootleg233 — Tue, 10 Apr 2012 09:08:51 GMT

Hello winsum just wanted ya to know the TN Cash 5 is a 5/35 game

Reply #40

permanentguest — Tue, 10 Apr 2012 05:11:22 GMT

Can you please add the following, too?

Sans Topu (TR)

Draw 5 34

Power Ball 1 14

Thx.

Reply #39

winsumloosesum — Tue, 10 Apr 2012 03:42:53 GMT

GA539 Added

http://www.box.com/s/93eb485bf07ff34a883d

Reply #38

Viper5963 — Tue, 10 Apr 2012 01:33:26 GMT

Please add GA Fantasy 5. Numbers 1-39. thanks

Reply #37

winsumloosesum — Tue, 10 Apr 2012 01:02:23 GMT

Looks like you changed the name of the Excel file to MegaPowerCombosProgram.xls to MegaPowerCombosProgram 3.xls. Change it back to MegaPowerCombosProgram.xls and it should work.

Reply #36

reddog — Mon, 09 Apr 2012 22:39:35 GMT

So then when I press copy to combo creator Tab and I get a runtime error and debug comes up with this.

Reply #35

reddog — Mon, 09 Apr 2012 22:31:48 GMT

This is what mine looks like. Look at Column T. See the #NAME? going down from 1-20 ? When I clicked click to Random Lexis it caused Column AB to do it also.

Reply #34

winsumloosesum — Mon, 09 Apr 2012 00:53:31 GMT

There should NOT be any formulas in column B.

Reply #33

reddog — Sun, 08 Apr 2012 19:23:01 GMT

I am using Excel 2003. Apparently the version I have is too old. When I click the #NAME? it gives a message saying unrecognized formula.

Reply #32

winsumloosesum — Sun, 08 Apr 2012 17:51:14 GMT

Correction column B.

Not sure why your getting Name# in column B. Looks as if the macro is copying the formulas which it should not.

Try downloading the most current Excel file from previous post.

What version of Excel are you using

Reply #31

winsumloosesum — Sun, 08 Apr 2012 17:48:31 GMT

Updated Saturday draws:

http://www.box.com/s/93eb485bf07ff34a883d

Reply #30

winsumloosesum — Sun, 08 Apr 2012 17:20:48 GMT

Lexi or CSN (Combination Sequence Number)

Example: 5/39 Lottery Game

Lexi #:

000001 = 1,2,3,4,5

----------------------------------

575757 = 35,36,37,38,39

The formulas take the previous draws Lexi number and the current draws Lexi number then randomly selects another Lexi # between the 2.

Take the Tennesee 5/39 Lottery game for example.

4/6/12 Draw: 3-8-14-24-34 Lexi = 0104320

4/4/12 Draw: 6-24-25-26-35 Lexi = 025391

Program randomly selects a Lexi Number between 01... [ More ]

Reply #29

tntea — Sun, 08 Apr 2012 17:05:32 GMT

This looks interesting. I cannot get it to open on my computer. What do the LEXI # represent?

and the numbers on Line 12... 7,11,19,27,31

Reply #28

reddog — Sun, 08 Apr 2012 15:45:06 GMT

nothing in column A just column B.

Reply #27

reddog — Sun, 08 Apr 2012 15:42:33 GMT

This is what keeps coming up in Column A no matter what I do.

Reply #26

winsumloosesum — Sat, 07 Apr 2012 21:48:25 GMT

Reddog,

Are there any lexi sets in column A in the Tab labeled ComboCreator

Reply #25

reddog — Sat, 07 Apr 2012 16:45:27 GMT

I tried using it for NC539draws and when I press RUN to create the combos I get a runtime error 13. I pressed debug and it came up with this.

Reply #24

lakerben — Fri, 06 Apr 2012 16:27:48 GMT

Nice I''ll give it a try

Reply #23

winsumloosesum — Fri, 06 Apr 2012 16:20:43 GMT

Added a QuickPicks tab. Create your own Random Sets. Instructions located in the TAB.

http://www.box.com/s/93eb485bf07ff34a883d

Reply #22

lakerben — Fri, 06 Apr 2012 01:17:30 GMT

Thanks for all your hard work it's appreciated

Reply #21

winsumloosesum — Thu, 05 Apr 2012 23:24:10 GMT

Added Maryland 5/39, NY539, FL536, MO339

http://www.box.com/s/93eb485bf07ff34a883d

Reply #20

winsumloosesum — Thu, 05 Apr 2012 22:38:09 GMT

Added HotLotto Draws

http://www.box.com/s/93eb485bf07ff34a883d

Reply #19

winsumloosesum — Thu, 05 Apr 2012 20:30:14 GMT

LP member asked to add the Tennessee Cash 5/35 (1/5) game.

Here is the link to the updated file:

Insructions:

1. Update the draw history (if needed) for Tennessee Cash 5/35 (TNCash5PB), MegaMillionsDraws, or PowerBall Draws lottery games. (1st 3 Tabs)

2. Click the Tab labeled DrawHistory

- Click cell B8. You will see an arrow to the far right of the cell

- Click the drop-down arrow to select your game. (TNCash5PB, MegaMillions, or PowerBall etc.)

- Go to cell N2 and ente... [ More ]

Reply #18

lakerben — Thu, 05 Apr 2012 19:25:29 GMT

Can this be used for p3

Reply #17

lakerben — Thu, 05 Apr 2012 19:23:57 GMT

Nice program. Getting used to the features. Does it save more than one game result in a playlist database? And, can you add the Hot Lotto? Thanks for all your hard work.

Reply #16

winsumloosesum — Wed, 04 Apr 2012 23:52:39 GMT

North Carolina Cash 5 added

http://www.box.com/s/93eb485bf07ff34a883d

Reply #15

lakerben — Wed, 04 Apr 2012 23:15:28 GMT

thanks Steve

Reply #14

Aleon — Wed, 04 Apr 2012 23:04:53 GMT

Please add NC Cash5 (5/39) without a bonus ball.

Thank you in advance.

Reply #13

winsumloosesum — Wed, 04 Apr 2012 22:24:56 GMT

Added NM Roadrunner and Texas 2 Step:

http://www.box.com/s/93eb485bf07ff34a883d

Texas 2 Step Lottery Game - Instructions

4. Click the Tab labeled ComboListing1

- Click the Toolbar labeled Step #1 Clear Old Sets

- Click the Toolbar labeled Step # 2 RUN 4 NUMBER LOTTERIES . Depending on how many tickets you selected in step 2 above, the program will take each Lexi and calculate the corresponding set. This may take a few seconds or minutes depending on how many tickets you entere... [ More ]

Reply #12

lakerben — Wed, 04 Apr 2012 18:41:08 GMT

Can you add NM Roadrunner Cash ? Its 5/37 with no bonus ball. Thanks

Reply #11

winsumloosesum — Wed, 04 Apr 2012 14:04:12 GMT

Tennessee 5/35 + PB (1/5) Picks - Wednesday April 4

Reply #10

winsumloosesum — Wed, 04 Apr 2012 13:59:54 GMT

Pennsylvania - 5/30 Picks - Wednesday Midday April 4 2012

Reply #9

mglsr — Wed, 04 Apr 2012 03:05:46 GMT

Awesome, thanks Steve

Reply #8

winsumloosesum — Wed, 04 Apr 2012 02:09:31 GMT

Updated Excel file.

Added Pennsylvania Cash 5/30 Lottery game

http://www.box.com/s/93eb485bf07ff34a883d

Reply #7

winsumloosesum — Wed, 04 Apr 2012 01:19:28 GMT

LP member asked to add the Tennessee Cash 5/35 (1/5) game.

Here is the link to the updated file:

http://www.box.com/s/93eb485bf07ff34a883d

Updated Insructions:

1. Update the draw history (if needed) for Tennessee Cash 5/35 (TNCash5PB), MegaMillionsDraws, or PowerBall Draws lottery games. (1st 3 Tabs)

2. Click the Tab labeled Draws

- Click cell B8. You will see an arrow to the far right of the cell

- Click the drop-down arrow to select your game. (TNCash5PB, MegaMillions,

Reply #6

winsumloosesum — Tue, 03 Apr 2012 18:48:10 GMT

20 Mega Millions Picks for tonight. After drawing this evening enter the winning picks in cell range C5 through G5. Let's make 12 million.

Reply #5

lakerben — Mon, 02 Apr 2012 21:20:33 GMT

Thanks Steve

Reply #4

winsumloosesum — Mon, 02 Apr 2012 19:01:24 GMT

Here is the update to the Excel file:

http://www.box.com/s/93eb485bf07ff34a883d

Link to the video:

http://www.screencast.com/t/q50ZswFGBtix

Have fun

Reply #3

ducksafloat — Sun, 01 Apr 2012 20:33:55 GMT

Reply #2

lakerben — Sun, 01 Apr 2012 19:07:43 GMT

Thanks

Reply #1

pima54 — Sun, 01 Apr 2012 12:37:36 GMT

Thanks for sharing.

The All New Mega Millions & Power Ball Combos Creator

winsumloosesum — Sun, 01 Apr 2012 10:49:44 GMT

http://www.box.com/s/93eb485bf07ff34a883d

OK, this is just a fun little Excel file where you can create up to 1000 sets using random Lexi Numbers from the previous drawings.

The idea is to take the current Lexi and the previous Lexi then create a random Lexi between the 2.

I'll create a new video on how to use it.

FOR ENTERTAINMENT PURPOSES ONLY