The combinatorics of a permutation

Reply #30

JADELottery — Tue, 03 Jan 2006 06:21:04 GMT

hypersoniq,That would be great if I was restricting myself to Excel.However, I needed a mathematical expression that could also work outside Excel for some other projects.Thank you for the suggestion.

Reply #29

hypersoniq — Mon, 02 Jan 2006 22:00:26 GMT

wouldn't sort of the four digit be easier using the following?col. E... =LARGE(A1:D1, 4)col. F... =LARGE(A1:D1, 3)col. G... =LARGE(A1:D1, 2)col. H... =LARGE(A1:D1, 1

Reply #28

Josephjphs — Mon, 02 Jan 2006 21:49:12 GMT

Hi JADELottery,I have notice your concepts, Now ! is this before or after the primary source

Reply #27

JADELottery — Sun, 01 Jan 2006 22:57:12 GMT

powerplayer,Thank you for the feedback.... good or bad, I need it.At times though, I'm my own worst critic.Interesting concept... I'll check it out.

Reply #26

powerplayer — Sat, 31 Dec 2005 10:59:19 GMT

Hi JADELottery, What do you think of this?3086 3052 2890 9508 3940 4350 3950 1820 0678 4103 0753 9803 9130 0937 2034 0896 7908 8250 3650 0841 0832 8074 1086 3015 6805 0485 7310 0846 4028 0189 0718 0932 3740 2031 2807 6034 5830 0936 3870 0489 8340 8130 0362 0637 6820 0581 2370 0136 0578 1928 8491 4139 7319 3164 1359 1874 3124 3912 4531 7134 2418 2316 8159 1832 1357 1983 1862 7581 5186 1538 3619 8631 1287 6841 1528 1387 7613 8197 5231 6918 1723 4813 1768 6531 1458 9732 3472 2678 9842 9268 2583 257... [ More ]

Reply #25

JADELottery — Sat, 31 Dec 2005 08:54:32 GMT

ok, i'll assume everyone understands and is using the spreadsheet to their advantage.And for you T.F.U. Hacks that could not come up with an original line of code to save your lives, enjoy.

Reply #24

JADELottery — Fri, 23 Dec 2005 21:21:47 GMT

Any of you finding this topic useful?Any questions about the spreadsheets, besided how to use Excel?(I'd like to avoid turning this into an Introduction to Excel Seminar.

Reply #23

JADELottery — Thu, 22 Dec 2005 15:19:24 GMT

I have added an 'UPDATED ->' tag and date to the spreadsheets in the upper left cells, A1 and B1.One of the fucntions in the calculation of the Combinatorial Set Item Number had a finger check error.Also, if there are any additional ideas or concepts I'd like to add, you'll know right away by the 'UPDATED ->' tag.PICK 3 sample ExcelPICK 4 sample Excel

Reply #22

JADELottery — Wed, 21 Dec 2005 22:35:08 GMT

retxx,I recommend you purchase some How to use... or Introduction to... books on Excel or something similar.Also, the full version of Microsoft Office Excel has some tutorials on How to... online.

Reply #21

retxx — Wed, 21 Dec 2005 21:17:17 GMT

question; love your spreadsheet I downloaded it (excel) also replaced yor draw numbers with mine (last 15) and wonder if the chart shows probable hits to play. Having a little difficulty following it. Thnaks for any help. I am a novice at excel.

Reply #20

JADELottery — Wed, 21 Dec 2005 19:13:44 GMT

retxx,Everything in the spreadsheet is changeable, including the PICK 3 and PICK 4 data.This a sample Excel spreadsheet and can be adapted to different states.You may need to do some copy and paste within the spreadsheet to get additional rows filled under certain columns, but that's basic Excel stuff you should know.Click on the links for the PICK 3 or PICK 4 data and save to your computer.Open the PICK 3 or PICK 4 file on your computer with Excel or some other program that can read and edit th... [ More ]

Reply #19

retxx — Wed, 21 Dec 2005 18:51:32 GMT

question;can I replace my states pick 3 in place of yours and get different results/ If so step by step please.

Reply #18

JADELottery — Wed, 21 Dec 2005 17:18:20 GMT

Here is a sample from my state's Wisconsin Lottery PICK 3. UNSORTEDSORTED |---Combinatorial---| |--------Permutational---------| BaseSet Basic Form SetItemSet FormBasicItemFormINDEXISO DATEABC XYZ NumberNumberItem NumberFormNumberItem12005-12-01930 039 321039 4A B C6C B A22005-12-02676 667 24067 2A A B2A B A32005-12-03815 158 357158 4A B C5C A B42005-12-04783 378 398378 4A B C4B C A52005-12-05919 199 21719 3A B B2B A B62005-12-06860 068 332068 4A B C6C B A72005-12-07496 469... [ More ]

Reply #17

JADELottery — Tue, 20 Dec 2005 08:53:19 GMT

Now it's time for the Combinatorial Base Set and Permutational Form Set examples.We have seen how to sort the PICK 4 data in ascending order.The ascending order can be used to find the Combinatorial Base Set and Permutational Form Set of a PICK 4 data set.I had to make a small change in the presentation order of the Permutational Basic Form Set.Previously I had stated that the Permutational Basic Form Set was: Previous Order of Basic From A A A A... [ More ]

Reply #16

JADELottery — Sun, 18 Dec 2005 11:59:15 GMT

retxx,Here is the link to my Excel PICK 4 sort example ---> PICK 4 sort example

Reply #15

retxx — Sun, 18 Dec 2005 03:05:11 GMT

If we could have your excel spreadsheet and can enter our states pick 4 (such as Mass. would it give us the dame results or would we have to do some functions to get it to give plays? thanks

Reply #14

JADELottery — Sat, 17 Dec 2005 20:42:26 GMT

...OK, here we go now.Here's the final simplified, unified, grandiose, latest, and greatest equations/functions you'll need for sorting PICK 4 numbers into ascending order.We'll deal with the functions as they relate to the table listed here, then show the Excel method as it relates to your spreadsheet so you can hopefully copy and paste the function into your spreadsheet.The functions for sorting are listed in ascending order of W, X, Y, and Z.W: =MIN(A,B,C,D)X: =(((SUM(A+1,B+1,C+1,D+1) - MIN(A... [ More ]

Reply #13

JADELottery — Sat, 17 Dec 2005 09:43:27 GMT

...Here's a process view of the X_LOW and X_HIGH functions in an Excel format.Use the following functions to sort W, X, Y, and Z into MIN, X_LOW, X_HIGH, and MAX. MIN: =MIN(W,X,Y,Z) X_LOW: =((SUM(W,X,Y,Z)-MIN(W,X,Y,Z)-MAX(W,X,Y,Z))-SQRT(((SUM(W,X,Y,Z)-MIN(W,X,Y,Z)-MAX(W,X,Y,Z))^2)-4*(PRODUCT(W,X,Y,Z)/(MIN(W,X,Y,Z)*MAX(W,X,Y,Z)))))/2X_HIGH: =((SUM(W,X,Y,Z)-MIN(W,X,Y,Z)-MAX(W,X,Y,Z))+SQRT(((SUM(W,X,Y,Z)-MIN(W,X,Y,Z)-MAX(W,X,Y,Z))^2)-4*(PRODUCT(W,X,Y,Z)/(MIN(W,X,Y,Z)*MAX(W,X,Y,Z)))))/2 MAX: =MAX... [ More ]

Reply #12

JADELottery — Sat, 17 Dec 2005 00:35:35 GMT

...For those of you who don't know or are puzzled by the symbol , it's a square root symbol. means take the square root of.Continues...

Reply #11

JADELottery — Fri, 16 Dec 2005 23:58:14 GMT

...Now, the tricky math part.Using the values of MIN, MAX, SUM, and PRODUCT we can find the values of X_LOW and X_HIGH.Taking the SUM of W, X, Y, and Z, if we subtract the values of MIN and MAX we are left with the sum of the two middle numbers X_LOW and X_HIGH. Sum of X_LOW and X_HIGH: n = SUM - MIN - MAXTaking the PRODUCT of W, X, Y, and Z, if we divide out the values of MIN and MAX we are left with the product of the two middle numbers X_LOW and X_HIGH. Product of X_LOW and X_HIG... [ More ]

Reply #10

JADELottery — Fri, 16 Dec 2005 21:01:42 GMT

...I have to do some errands... I'll update very soon.Continue..

Reply #9

JADELottery — Fri, 16 Dec 2005 20:32:05 GMT

...Now, we need to find the values of MIN, MAX, SUM, and PRODUCT for the values in columns W, X, Y, and Z.These values will be used to find the middle two numbers between MIN and MAX.The middle numbers will be X_LOW and X_HIGH.The sorted numbers will be in ascending order in this column format: MIN X_LOW X_HIGH MAXHere's the MIN, MAX, SUM, and PRODUCT of W, X, Y, and Z: W X Y Z MIN MAX SUM PRODUCTDATE A B C D W=A+1 X=B+1... [ More ]

Reply #8

JADELottery — Fri, 16 Dec 2005 19:52:54 GMT

...Next, let's look at the PICK 4 method of sorting the numbers mathematically.The numbers must be in individual columns (A, B, C, D).Here's a sample from my state's Wisconsin Lottery PICK 4, 2005-12-01 to 2005-12-15.DATE A B C D2005-12-01 7 8 1 82005-12-02 8 7 4 62005-12-03 0 7 7 22005-12-04 2 7 4 02005-12-05 0 2 2 42005-12-06 4 5 3 92005-12-07 0 8 8 62005-12-08 9 8 1 12005-12-09 8 8 9 32005-12-10 7 0 3 02005-12-11 0 1 8 32005-12-12 0 1 0 22005-12-13 3 2 1 62005-12-14 6 2 2... [ More ]

Reply #7

JADELottery — Fri, 16 Dec 2005 19:22:43 GMT

Now that I have some time, I can explain the mathematical way to sort PICK 4 numbers.I'll handle this in an Microsoft Excel format since 'yous' guys and gals like that so much.First, let's look at the PICK 3 method of sorting the numbers mathematically.The numbers must be in individual columns (A, B, C).Here's a sample from my state's Wisconsin Lottery PICK 3, 2005-12-01 to 2005-12-15.DATE A B C2005-12-01 9 3 02005-12-02 6 7 62005-12-03 8 1 52005-12-04 7 8 32005-12-05 9 1... [ More ]

Reply #6

lottaloot — Thu, 15 Dec 2005 20:58:05 GMT

Interesting

Reply #5

JADELottery — Thu, 15 Dec 2005 19:05:01 GMT

After working with this a while, I've found that it may be better to work with PICK 3 and PICK 4 numbers by transforming them into Natural Numbers.Natural Numbers are all the positive integers (1, 2, 3, 4, ...).It is easier to work with the set mathematically because it eliminates the zero.Working with a zero mathematically can sometimes be a disaster when figuring out a quotient that has a result of zero in the denominator.I just have to keep in mind that a result given would have to be less by... [ More ]

Reply #4

JADELottery — Sun, 27 Nov 2005 07:12:08 GMT

Never Mind.... Go Here for the correctly formated page ---> Comb Perm

Reply #3

JADELottery — Sun, 27 Nov 2005 06:43:22 GMT

Game TypePICK3Combinatoric Base 1 2 3Permutational Form AAA AAB ABB ABC Permutational Sets1AAA 1AAB 1ABB 1ABC 2ABA 2BAB 2ACB 3BAA 3BBA 3BAC 4BCA 5CAB 6CBA

Reply #2

JADELottery — Sun, 27 Nov 2005 06:39:05 GMT

Game Type PICK 3 Combinatoric Base 1 2 3 Basic Permutational Form A A A A A B A B B A B C Permutational Sets 1 A A A 1 A A B 1 A B B 1 A B C 2 A B A 2 B A B 2 A C B 3 B A A 3 B B A 3 B A C 4 B C A

Reply #1

JADELottery — Sun, 27 Nov 2005 06:31:35 GMT

Boy I hate the way this editor massages the data... grrrr.

The combinatorics of a permutation

JADELottery — Sun, 27 Nov 2005 06:03:40 GMT

I've been thinking about another topic about the many different forms of PICK 3 PICK 4 numbers.Some of what was covered is related to the permutational aspect, like: singles 0123, doubles 011, etc.After going over many of the possible variations, I began to see a combinatorial aspect of the numbers.I found there are 4 basic forms of PICK 3 and there are 8 basic forms of PICK 4 permutations.PICK 3 Basic Permutational FormsA A A A A B A B B A B CPICK 4 Basic Permutational Forms