Welcome Guest
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

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

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)

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

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

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)

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

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

=^.^=

 Page 1 of 1