Total Combination List Using Excel?

Reply #10

ElvisVanZepplin — Tue, 02 Jan 2007 18:03:27 GMT

What other kinds of tests/experiments do you have in mind for carrying it further? Thus far I only play the five draw lotto using CA's Fantasy 5 but if there are other interesting theories where using spreadsheets or a database to raise the odds on the 3 or 4 draw games then I'd be interested in putting it into the machine, or at least putting it on the list of all the other back-testing and coding to do. I had the same question as the original poster of this thread and started working on it a... [ More ]

Reply #9

lottaloot — Mon, 01 Jan 2007 20:17:44 GMT

I once had a way to have excel return combinations the way you are suggesting. You would have to do a search here in discussions under my name. I know that it will be under the subject header of excel .

Reply #8

ElvisVanZepplin — Mon, 01 Jan 2007 20:13:22 GMT

My own version is done entirely in VB6 code; I mentioned Excel so that any interested users could run it on their own or use different numbers, or combos of 4 or 5 since this elgorithm (ElvisVanZepplin's algorithms) will have a wide range of applications in many systems, wheels etc. I use it when testing for 3 numbers repeating from w/in the last of any 1 draw from the last 1 - 10 draws or when I have strong indicators of all 5 numbers repeating from somewhere within the last 5 or 6 draws for... [ More ]

Reply #7

LottoHackJack — Mon, 01 Jan 2007 18:08:58 GMT

...Now this operation sounded really neat! If you're interested in posting the resulting 1140 combos, or maybe the actual Excel spreadsheet you concocted to create them, please do...or private message me if you're interested in pushing this exercise further. I'm sure the original poster is gonna love this.

LottoHackJack

Reply #6

ElvisVanZepplin — Mon, 01 Jan 2007 16:42:50 GMT

Note: I pasted in the SQL all formatted, (everything between the SELECT and ; (semicolon ending the SQL)... the message box took out the cleaned up formatting.

Reply #5

ElvisVanZepplin — Mon, 01 Jan 2007 16:40:10 GMT

One way to do it is with SQL (Structure Query Language) in a database. Create 3 different tables in the DB with one column for the 20 numbers in each of the three tables. Then you make a query of the three tables WITHOUT specifying a JOIN, which gives you a CARTESIAN PRODUCT, which will be all possible combinations; also specify a Not Equal condition in the criteria (WHERE clause) as shown right below: SELECT tblRnd1.Num AS Num1, tblRnd2.Num AS Num2, tblRnd3.Num AS Num3FROM tblRnd1, tblRnd2, tb... [ More ]

Reply #4

for99c — Wed, 27 Dec 2006 21:43:59 GMT

Microsoft Office Assistance Statistical functions

http://office.microsoft.com/en-us/excel/HP052030661033.aspx

Reply #3

LottoHackJack — Wed, 27 Dec 2006 20:33:26 GMT

I suspect that this formula you are using does not include doubles or triples combos, and that order or position of the numbers within the generated combo does not matter.. It probably generates the 20 wheeled numbers into combos of 3 as appearing only once in each possible combo. This will not work out in a pick 3 game, but if your intentions are to use this strategy as a portion of a larger game strategy, it will make some possible food for thought in the 4, 5, 6, 7-ball, and keno lotteries.

Reply #2

binar — Wed, 27 Dec 2006 19:33:32 GMT

The numbers I'm using are being used as examples only to keep everything at a basic level. I don't intend to play Pick 3 game. My main focus is to learn how to make Excel generate all possible combinations as a list. As for the 1,140 value, all I can say is that Excel has calculated that there are 1,140 combinations possible when 3 numbers are picked from a pool of 20 numbers.

Reply #1

SirMetro — Wed, 27 Dec 2006 18:23:02 GMT

Foolish question, but if there is only 1000 total combinations in a Pick3 game, how do you derive 1140 items out of 1000

Total Combination List Using Excel?

binar — Wed, 27 Dec 2006 18:08:24 GMT

Fellow Forum Members,

I have figured out on my own how to use the combin function so that I can get the total number of combinations possible when picking 3 numbers out of a pool of 20 numbers. By using the function =COMBIN(20,3) I'm able to determine that a total of 1,140 combinations is possible. What I'm not able to figure out is how to get EXCEL to generate the actual numbers for all of the 1,140 combinations as a list in a single column with hyphens in between the numbers. Can anyone out... [ More ]