Welcome Guest
Log In | Register )
You last visited December 7, 2016, 7:22 am
All times shown are
Eastern Time (GMT-5:00)

Combinations by number position

Topic closed. 3 replies. Last post 6 years ago by frenchie.

Page 1 of 1
PrintE-mailLink
frenchie's avatar - Lottery-041.jpg
Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
Posted: July 2, 2010, 11:19 pm - IP Logged

Hello,

      I'd like to know if someone has or can create this very useful excel file of 5/56 combination by number position,with their lexicographic number on front of each combination,there is a total of 260 numbers by position according to the table chart of " WINSUMLOOSESUM " who was kind enough to give to me which is :

 

Don't mind the 45 and circle that was from a previous post.

          It would look like this if someone were to do it.

firstable all columns would be at width : 15.

Details for the file display.

For position 1.

1.  Cell A1 and B1 would be " merge " together with in it : Position  1.

2.  Row 2 would be empty.

3.  Cell A3 and B3 would also be " merge : with the number 1 in it.

4.  Row 4 would be empty.

5.  Cell A5 would have the word :   Lexicographic      in it.

6.  Cell B5 would have the word :    Combinations     in it.

7.  Row 6 would be empty. 

8.  Cell A7 and up would have the lexicographic numbers list from the combinations of the column B.

9.  Cell B7 and up ( column ) would have all the combinations for the number 1 " as position1 ".

 

It should look like this :

       

For all the numbers as " position 1 ".     (1 to 52)

        It will start at columns : A,B with number 1 and will stop at columns : CY,CZ with number : 52.

For all the numbers as " position 2 ".     (2 to 53)

       It will start at columns : DA,DB with number 2 and will stop at columns : GY,GZ with number : 53.

For all the numbers as " position 3 ".     (3 to 54)

       It will start at columns : HA,HB with number 3 and will stop at columns : KY,KZ with number : 54.

For all the numbers as " position 4 ".     (4 to 55)

       It will start at columns : LA,LB with number 4 and will stop at columns : OY,OZ with number : 55.

For all the numbers as " position 5 ".     (5 to 56)

       It will start at columns : PA,PB with number 5 and will stop at columns : SY,SZ with number : 56.

 

              IF I DIDN'T MAKE MISTAKE IT SHOULD BE RIGHT !!!

 

                 If someone can write this Excel file,I would realy appreciate  it, Thank you.        

                                                                            Frenchie.

    frenchie's avatar - Lottery-041.jpg
    Los Angeles
    United States
    Member #75410
    June 2, 2009
    479 Posts
    Offline
    Posted: July 3, 2010, 1:23 am - IP Logged

    I forgot to mention ,I use Excel 07, which would alow one column per number actualy two with the lexicographic number.

                         Thank you.

      frenchie's avatar - Lottery-041.jpg
      Los Angeles
      United States
      Member #75410
      June 2, 2009
      479 Posts
      Offline
      Posted: July 13, 2010, 5:26 pm - IP Logged

      Hi,

      I really need this and hope someone can help ?, I know it's not a easy one.

                                                                                                                                        Thank you.

        frenchie's avatar - Lottery-041.jpg
        Los Angeles
        United States
        Member #75410
        June 2, 2009
        479 Posts
        Offline
        Posted: July 14, 2010, 3:47 pm - IP Logged

        Hi,

        I Hope it help to get the job down ?

        Here is the macro that generate all the 5/56 combinations :

         

        Option Explicit
        Dim A As Integer, B As Integer, C As Integer, D As Integer, E As Integer
        Dim N As Long, nMinA As Integer, nMaxE As Integer

        Sub List_5x56Comb()

        ' Macro to list combinations in an Excel sheet
        Sheets("List556Combos").Select
        Range("A1").Select
        Application.ScreenUpdating = False
        N = 1
        Selection.ColumnWidth = 15
        ActiveCell.Value = "Combinations"

        ' Change minimum value for A or maximum value for F
        ' to cover range of values to be covered
        nMinA = 1
        nMaxE = 56

        ' Start of loops for 5 variables (A-E)
        For A = nMinA To nMaxE - 4
        For B = A + 1 To nMaxE - 3
        For C = B + 1 To nMaxE - 2
        For D = C + 1 To nMaxE - 1
        For E = D + 1 To nMaxE


        ' Verification of number of combinations posted
        ' and move to top of next column if 65,000
        If N = 65001 Then
        Selection.ColumnWidth = 15
        N = 1
        ActiveCell.Offset(-65000, 1).Select
        Application.ScreenUpdating = True
        Application.ScreenUpdating = False
        ActiveCell.Value = "Combinations"
        End If

        ' Copying the combination in the form N1-N2-N3-N4-N5-N6 in a cell
        ActiveCell.Offset(1, 0).Select
        N = N + 1
        ActiveCell.Value = Application.WorksheetFunction.Text(A, "00") & "-" _
        & Application.WorksheetFunction.Text(B, "00") & "-" _
        & Application.WorksheetFunction.Text(C, "00") & "-" _
        & Application.WorksheetFunction.Text(D, "00") & "-" _
        & Application.WorksheetFunction.Text(E, "00")


        Next E
        Next D
        Next C
        Next B
        Next A
        Application.ScreenUpdating = True
        End Sub

        And if you go in : Mathematics Forum.

                                 Combinations count.

                                  in the 7th post down you can find the link to an excel file that count the combinations by position given by " JADELottery " Thanks again JADE.

        Forget about the heading I describe as long as the file show all combinations per position per number with the lexicographic number,I know it's not an easy one that's why I don't have answer so far !!! I'm trying.      ( I work on Excel 2007 )

         

                                                                                  Thank you.     Serge.