Welcome Guest
You last visited December 10, 2016, 11:28 am
All times shown are
Eastern Time (GMT-5:00)

# The combinatorics of a permutation

Topic closed. 30 replies. Last post 11 years ago by JADELottery.

 Page 2 of 3
BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: December 17, 2005, 10:05 pm - IP Logged

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

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: December 18, 2005, 6:59 am - IP Logged

retxx,

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

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: December 20, 2005, 3:53 am - IP Logged

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  A A A B  A B B B  A A B B  A A B C  A B B C  A B C C  A B C D

I've made a slight reorder that is mostly related to logical arguments within certain functions, however, it should be transparent to you.

Updated Order of Basic Form
A A A A  A A A B  A A B B  A B B B  A A B C  A B B C  A B C C  A B C D

Here's a sample of the Excel spreadsheet I've come up with:

 UNSORTED SORTED |---Combinatorial---| |----------Permutational-----------| Base Set Basic Form Set Item Set Form Basic Item Form ISO DATE A B C D W X Y Z Number Number Item Number Form Number Item 2005-12-01 7 8 1 8 1 7 8 8 3 63 178 7 A B C C 5 B C A C 2005-12-02 8 7 4 6 4 6 7 8 4 202 4678 8 A B C D 23 D C A B 2005-12-03 0 7 7 2 0 2 7 7 3 13 027 7 A B C C 3 A C C B 2005-12-04 2 7 4 0 0 2 4 7 4 37 0247 8 A B C D 12 B D C A 2005-12-05 0 2 2 4 0 2 2 4 3 10 024 6 A B B C 1 A B B C 2005-12-06 4 5 3 9 3 4 5 9 4 179 3459 8 A B C D 9 B C A D 2005-12-07 0 8 8 6 0 6 8 8 3 32 068 7 A B C C 3 A C C B 2005-12-08 9 8 1 1 1 1 8 9 3 65 189 5 A A B C 12 C B A A 2005-12-09 8 8 9 3 3 8 8 9 3 10 389 6 A B B C 7 B B C A 2005-12-10 7 0 3 0 0 0 3 7 3 19 037 5 A A B C 11 C A B A 2005-12-11 0 1 8 3 0 1 3 8 4 12 0138 8 A B C D 2 A B D C 2005-12-12 0 1 0 2 0 0 1 2 3 1 012 5 A A B C 3 A B A C 2005-12-13 3 2 1 6 1 2 3 6 4 88 1236 8 A B C D 15 C B A D 2005-12-14 6 2 2 4 2 2 4 6 3 73 246 5 A A B C 10 C A A B 2005-12-15 6 5 4 3 3 4 5 6 4 176 3456 8 A B C D 24 D C B A

Here's the Excel PICK 4 Sorted Combinatorial Set & Permutational Form ---> PICK 4 Sample Excel

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: December 21, 2005, 12:18 pm - IP Logged

Here is a sample from my state's Wisconsin Lottery PICK 3.

 UNSORTED SORTED |---Combinatorial---| |--------Permutational---------| Base Set Basic Form Set Item Set Form Basic Item Form INDEX ISO DATE A B C X Y Z Number Number Item Number Form Number Item 1 2005-12-01 9 3 0 0 3 9 3 21 039 4 A B C 6 C B A 2 2005-12-02 6 7 6 6 6 7 2 40 67 2 A A B 2 A B A 3 2005-12-03 8 1 5 1 5 8 3 57 158 4 A B C 5 C A B 4 2005-12-04 7 8 3 3 7 8 3 98 378 4 A B C 4 B C A 5 2005-12-05 9 1 9 1 9 9 2 17 19 3 A B B 2 B A B 6 2005-12-06 8 6 0 0 6 8 3 32 068 4 A B C 6 C B A 7 2005-12-07 4 9 6 4 6 9 3 107 469 4 A B C 2 A C B 8 2005-12-08 6 1 7 1 6 7 3 59 167 4 A B C 3 B A C 9 2005-12-09 1 5 3 1 3 5 3 45 135 4 A B C 2 A C B 10 2005-12-10 0 4 3 0 3 4 3 16 034 4 A B C 2 A C B 11 2005-12-11 9 2 4 2 4 9 3 75 249 4 A B C 5 C A B 12 2005-12-12 3 0 5 0 3 5 3 17 035 4 A B C 3 B A C 13 2005-12-13 8 1 8 1 8 8 2 16 18 3 A B B 2 B A B 14 2005-12-14 5 0 4 0 4 5 3 22 045 4 A B C 5 C A B 15 2005-12-15 7 7 7 7 7 7 1 8 7 1 A A A 1 A A A

Here is the spreadsheet --->  PICK 3 sample Excel

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: December 21, 2005, 1:51 pm - IP Logged

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

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: December 21, 2005, 2:13 pm - IP Logged

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 the spreadsheet.

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

BOSTON
United States
Member #48
September 9, 2001
3594 Posts
Offline
 Posted: December 21, 2005, 4:17 pm - IP Logged

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.

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: December 21, 2005, 5:35 pm - IP Logged

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.

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: December 22, 2005, 10:19 am - IP Logged

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 Excel

PICK 4 sample Excel

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: December 23, 2005, 4:21 pm - IP Logged

Any of you finding this topic useful?

(I'd like to avoid turning this into an Introduction to Excel Seminar.)

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: December 31, 2005, 3:54 am - IP Logged

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.

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

United States
Member #17834
June 28, 2005
2083 Posts
Offline
 Posted: December 31, 2005, 5:59 am - IP Logged

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.

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 2578 2568 7283 2634 2386 3928 2963 8425 3726 5327 5392 7248 2354 4392 9582 9287 2348 2356 2468 6453 5638 7349 5837 6347 6943 4863 4953 9873 5936 4538 9835 7953 7453 3984 3784 3796 8637 7653 3689 6498 5864 8479 4875 8746 5849 5789 5687 9865 6879

It's made up of only 3's and 8's.

Maybe you can use it.

Thanks for all you do.

Happy New Year to you

PP

Good luck to everyone!!!

The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Offline
 Posted: January 1, 2006, 5:57 pm - IP Logged

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.

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

New Member

United States
Member #7839
October 14, 2004
4 Posts
Offline
 Posted: January 2, 2006, 4:49 pm - IP Logged

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  A A A B  A B B B  A A B B  A A B C  A B B C  A B C C  A B C D

I've made a slight reorder that is mostly related to logical arguments within certain functions, however, it should be transparent to you.

Updated Order of Basic Form
A A A A  A A A B  A A B B  A B B B  A A B C  A B B C  A B C C  A B C D

Here's a sample of the Excel spreadsheet I've come up with:

 UNSORTED SORTED |---Combinatorial---| |----------Permutational-----------| Base Set Basic Form Set Item Set Form Basic Item Form ISO DATE A B C D W X Y Z Number Number Item Number Form Number Item 2005-12-01 7 8 1 8 1 7 8 8 3 63 178 7 A B C C 5 B C A C 2005-12-02 8 7 4 6 4 6 7 8 4 202 4678 8 A B C D 23 D C A B 2005-12-03 0 7 7 2 0 2 7 7 3 13 027 7 A B C C 3 A C C B 2005-12-04 2 7 4 0 0 2 4 7 4 37 0247 8 A B C D 12 B D C A 2005-12-05 0 2 2 4 0 2 2 4 3 10 024 6 A B B C 1 A B B C 2005-12-06 4 5 3 9 3 4 5 9 4 179 3459 8 A B C D 9 B C A D 2005-12-07 0 8 8 6 0 6 8 8 3 32 068 7 A B C C 3 A C C B 2005-12-08 9 8 1 1 1 1 8 9 3 65 189 5 A A B C 12 C B A A 2005-12-09 8 8 9 3 3 8 8 9 3 10 389 6 A B B C 7 B B C A 2005-12-10 7 0 3 0 0 0 3 7 3 19 037 5 A A B C 11 C A B A 2005-12-11 0 1 8 3 0 1 3 8 4 12 0138 8 A B C D 2 A B D C 2005-12-12 0 1 0 2 0 0 1 2 3 1 012 5 A A B C 3 A B A C 2005-12-13 3 2 1 6 1 2 3 6 4 88 1236 8 A B C D 15 C B A D 2005-12-14 6 2 2 4 2 2 4 6 3 73 246 5 A A B C 10 C A A B 2005-12-15 6 5 4 3 3 4 5 6 4 176 3456 8 A B C D 24 D C B A

Here's the Excel PICK 4 Sorted Combinatorial Set & Permutational Form ---> PICK 4 Sample Excel

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

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: January 2, 2006, 5:00 pm - IP Logged

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)

Playing more than one ticket per game is betting against yourself.

 Page 2 of 3