Welcome Guest
Log In | Register )
You last visited January 17, 2017, 4:16 pm
All times shown are
Eastern Time (GMT-5:00)

Any have a chart... that

Topic closed. 4 replies. Last post 9 years ago by johnph77.

Page 1 of 1
PrintE-mailLink
tntea's avatar - Lottery-059.jpg

United States
Member #5344
June 30, 2004
23641 Posts
Offline
Posted: December 15, 2007, 12:20 pm - IP Logged

contains the sum for all the possible combinations of the white balls in 1-55 range for PB..

I am looking for a chart that would have like Sum

45.. and a list of all possible combinations of the 5 white balls that would add up to 45.. etc...

As I understand the lowest sum is 15 and highest is 290...  Correct me if I am wrong...

     OLD/Vtrac   Lottery Bible         Double Warnings      Thumbs Up TN F34/F44

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5396 Posts
    Offline
    Posted: December 15, 2007, 1:33 pm - IP Logged

    contains the sum for all the possible combinations of the white balls in 1-55 range for PB..

    I am looking for a chart that would have like Sum

    45.. and a list of all possible combinations of the 5 white balls that would add up to 45.. etc...

    As I understand the lowest sum is 15 and highest is 290...  Correct me if I am wrong...

    TN,

    Here is a link to an Excel file that has all the combos for 1-55, Sums of 45 (674 total combos)

    http://www.badongo.com/file/5603901 

    You can change the code to create combos for any sum

     

    Right click the Worksheet Tab select View Code 

    On the left side locate Modules 

    Double click Module1 

    The code will appear on the right side (see below)

    If you want to change the sum locate this line of code below:

    "If A + B + C + D + E = 45 Then"

    Change "45" to the sum you would like combos. 

    Close this window and click the Toolbar in the Worksheet Tab

    This is for 1/55 game.  If you want combos for another lottery game you will need to chage the code below. 

    Code created by a member of the lotto649 forum.  Not my code. 

    ============================================================================ 

    Option Explicit

    Dim A As Integer, B As Integer, C As Integer
    Dim D As Integer, E As Integer
    Dim N As Long

    Sub List_Comb()
    Range("A1").Select
    Application.ScreenUpdating = False
    N = 0
    For A = 1 To 55
    For B = A + 1 To 52
    For C = B + 1 To 53
    For D = C + 1 To 54
    For E = D + 1 To 55

    If A + B + C + D + E = 45 Then     'Change the number "45" Sum to the Sum you want combos

    ActiveCell.Value = A & "-" & B & "-" & C & "-" & D & "-" & E
    ActiveCell.Offset(1, 0).Select
    N = N + 1
    If N = 65001 Then
    N = 0
    ActiveCell.Offset(-65001, 1).Select
    Application.ScreenUpdating = True
    Application.ScreenUpdating = False
    End If
    End If

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

    =======================================================

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5396 Posts
      Offline
      Posted: December 15, 2007, 1:49 pm - IP Logged

      Here is a link with the same program.

      Calculate number of combinations 1-55 Game (No Bonus Balls)

      http://www.badongo.com/file/5604222 

      You can change snippets of the code to change the number based on number of balls drawn.

        Kola's avatar - image
        Blundering Time Traveler

        United States
        Member #28945
        December 25, 2005
        1532 Posts
        Offline
        Posted: December 15, 2007, 1:51 pm - IP Logged

        contains the sum for all the possible combinations of the white balls in 1-55 range for PB..

        I am looking for a chart that would have like Sum

        45.. and a list of all possible combinations of the 5 white balls that would add up to 45.. etc...

        As I understand the lowest sum is 15 and highest is 290...  Correct me if I am wrong...

        This page has the info you want. Its was taken from the Mathematics Forum:
        -
        -
        **Look at johnph77's post on that page. At the bottom of his post, he has a link that directs you to all the possible number of combos for all the lottery games from the highest to the lowest sums. Its a great resource.
        -
          johnph77's avatar - avatar
          CA
          United States
          Member #2987
          December 10, 2003
          832 Posts
          Offline
          Posted: December 15, 2007, 3:32 pm - IP Logged

          contains the sum for all the possible combinations of the white balls in 1-55 range for PB..

          I am looking for a chart that would have like Sum

          45.. and a list of all possible combinations of the 5 white balls that would add up to 45.. etc...

          As I understand the lowest sum is 15 and highest is 290...  Correct me if I am wrong...

          Kola -

          TY for kind words - much appreciated.

          tntea -

          Highest possible sum in 5/55 is 265 (51-52-53-54-55).

          There are 3,478,761 possible combinations in a 5/55 matrix.

          A text file listing of all possible combinations without line numbers or sums would take 18 bytes per line, allowing for number separation and end-of-line character, resulting in a file size of 62,617,698 bytes, or 59.7Mb.

          A text file listing of all possible combinations with line numbers but without sums would take 26 bytes per line, allowing for number separation and end-of-line character, resulting in a file size of 90,447,786 bytes, or 86.3Mb.

          A text file listing of all possible combinations without line numbers but with sums would take 22 bytes per line, allowing for number separation and end-of-line character, resulting in a file size of 76,532,742 bytes, or 73.0Mb.

          A text file listing of all possible combinations with line numbers and sums would take 30 bytes per line, allowing for number separation and end-of-line character, resulting in a file size of 104,362,830 bytes, or 99.5Mb.

          I know of no site on the Internet with the specific information you've requested. The programming above with data output into a text file would allow you to retain this information on your computer for further reference.

          gl

          j

          Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

          Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

           =^.^=