User talk:Toryglen1

Hello Editor of “Combinatorial number system”

Under the heading of “National Lottery example in Excel”

You gave an example of how of use EXCEL, to get a position of a particular set of numbers using 6/49 as the Lottery marker. Your calculations are correct for the given set (3,6,15,17,18,35) and the EXCEL functions of; COMBIN(49-3,6), COMBIN(49-6,5), COMBIN(49-15,4), COMBIN(49-17,3), COMBIN(49-18,2), 49−35. The resulting “position” you arrive at is 10,381,232.

3	6	15	17	18	35		 9,366,819 	 962,598 	 46,376 	 4,960 	 465 	 14 		 10,381,232

By my calculations, this is incorrect.

If you substitute the given set (3, 6, 15, 17, 18, 35) with the “first” set of numbers of (1, 2, 3, 4, 5, 6) you get the following result: 1	2	3	4	5	6		 12,271,512 	 1,533,939 	 163,185 	 14,190 	 946 	 43 		 13,983,815 The set of (1, 2, 3, 4, 5, 6) surely is 1.

This stated, the last set of numbers (44, 45, 46, 47, 48, 49) must surely be 13,983,816

If I were to continue to use your EXCEL example to the maximum set, the result is as follows: 44	45	46	47	48	49
 * 1) NUM!	#NUM!	#NUM!	#NUM!	#NUM!	#NUM!		#NUM!

If I ‘step down’ a set of numbers to (43 44, 45, 46, 47, 48) the result is: 43	44	45	46	47	48		 1 	 1 	 1 	 1 	 1 	 1 		 6

I have developed over a numbers of years, using various spreadsheets, a reliable method for 1 and 2 “matrix” sets of lotteries: eg UK National Lottery (1 Matrix) and EuroMillions is (2 Matrix). For both, Numbers to Positions and Positions to Numbers.

Unfortunately, I cannot insert a snapshot of the spreadsheet.

But suffice to say:

Set (1, 2, 3, 4, 5, 6) is position 1

Set (44, 45, 46, 47, 48, 49) is position 13,983,816

Set (3, 6, 15, 17, 18, 35) is position 3,602,584 Position 10,381,232 is set (10, 14, 23, 35, 43, 49)

Set (06, 07, 16, 20, 28, 47): is position 6,991,908 (the half way point)

I do not wish to denounce all your calculations, but your section,

“National Lottery example in Excel” requires to be corrected, somewhat.

What do you think?

I would appreciate any feedback.

Kind Regards

Toryglen1 (talk) 21:46, 8 July 2019 (UTC)