unique comb of 0123456789

Reply #9

phileight — Fri, 16 Dec 2011 23:10:37 GMT

Carbob

thanks. i gave it a quick test seems to work ok. I'll get deeper later. curious to see total numer of combinations

and how long it takes to run.

Reply #8

CARBOB — Fri, 16 Dec 2011 17:22:26 GMT

phileight,

The code below was written for Excel 03. Needs to be updated to allow for the extra rows columns in Excel 07. Unfortunately, I'm not a VB person. Setup for worksheet

Option Explicit

' PGC Set 2007

' Calculates and writes the Combinations / Permutations with/without repetition

' Assumes the result is written from row 1 down. If the total number of cells in a column

' is less than tha number of results continues in another group of columns to the... [ More ]

Reply #7

garyo1954 — Fri, 16 Dec 2011 15:51:52 GMT

Didn't bother working on it when you didn't reply. Used the old fashioned method.

Post what you have. There are plenty of people who can help.

Reply #6

phileight — Fri, 16 Dec 2011 11:14:05 GMT

Garyo1954

I have never used qbasic64. i have used most other versions of basic. would appreciate the code. with a couple changes it should work in VBA . there are more comb than I expected but still workable I think.

Reply #5

garyo1954 — Fri, 16 Dec 2011 00:31:59 GMT

Using nonrepeating digits........

Using 1 digits: 10 combinations

Using 2 digits: 10*9 = 90 combinations

Using 3 digits: 10*9*8 = 720 combinations

Using 4 digits: 10*9*8*7 = 5040 combinations

Using 5 digits: 10*9*8*7*6 = 30240 combinations

Using 6 digits: 10*9*8*7*6*5 = 151200 combinations

Using 7 digits: 10*9*8*7*6*5*4 = 604800 combinations

Using 8 digits: 10*9*8*7*6*5*4*3 = 1814400 combinations

Using 9 digits: 10*9*8*7*6*5*4*3*2 = 3628800 combinations

Using 10 dig... [ More ]

Reply #4

garyo1954 — Thu, 15 Dec 2011 23:48:41 GMT

Using all ten digits in each combination?

Want it in QBASIC64?

Take maybe 20 minutes tops.

Can you run it

Reply #3

phileight — Thu, 15 Dec 2011 23:43:22 GMT

thanks RJOH and DR San. this is not for a wheel type application.

what i want to do is

0123456789

0123456798

0123456879

0123456897 etc

I have always assumed that there were too many combinations and just created random strings of these digits. doing that I can never say i have the absolute best arrangement. I think there are around 150000 possible combinations, but I'm not sure. can't seem to put 2 lines of code together today.

p8

Reply #2

dr san — Thu, 15 Dec 2011 20:32:56 GMT

Hello, PHI, this type of matrix, until I got the six digit

1 2 3 4 5 6

2 3 1 6 4 5

3 1 2 5 6 4

4 6 5 1 2 3

5 4 6 2 3 1

6 5 4 3 1 2

Reply #1

RJOh — Thu, 15 Dec 2011 19:42:35 GMT

If you're talking about Pick3 and Pick4 games then Maybelle QuickWheel can tell you that when it prints out all the possible combinations without triples or doubles. You can download it from Lotto Logix.

unique comb of 0123456789

phileight — Thu, 15 Dec 2011 16:06:20 GMT

My brain seems to have taken a vacation. using all 10 digits, any digit can be in any position but can only be used once per combination. how many unique combinations are there? do you have program code to generate these unique combinations?

p8