Hi
Alex,
Alexafjb said:
Can a Variable (s) be declared at the start of the Module?
i.e. (“0”-49), (“0”-49), (“0”-49), (“0”-49) “0”= no user input or ignored.
If so… could the module produce the total CSN for the given “Const SumTotal As Integer = (i.e. 270)“
First, then have the declared Variables targeted within the “Total CSN” produced, for the given “Const SumTotal As Integer = (i.e. 270)“
If CSN = Var1, Var2, Var3, Var4 then print, Else; Delete
I think you are talking about an
Array, which could be setup of course.
Alexafjb said:
BTW for test purposes: 150 produces 165,772 and would take the longest to run the possible CSN, 270 produces 26 CSN, and the lowest being ,21,22,278,279 producing only 1 possible CSN.
You are quite correct!
I am in the process of putting the
VBA code and SpreadSheet together for you now.
I have just run what I have so far with the criteria you specified, constant numbers
9, 18, 36, & 41 and
Sum Total = 140 and it took
1 second processing time and produced
16 combinations.
BTW, for information purposes, here is the full list for the
Sum Totals Of ALL Combinations for a
C(49,6) Lotto:-
Sum = 21 = 1 Combinations
Sum = 22 = 1 Combinations
Sum = 23 = 2 Combinations
Sum = 24 = 3 Combinations
Sum = 25 = 5 Combinations
Sum = 26 = 7 Combinations
Sum = 27 = 11 Combinations
Sum = 28 = 14 Combinations
Sum = 29 = 20 Combinations
Sum = 30 = 26 Combinations
Sum = 31 = 35 Combinations
Sum = 32 = 44 Combinations
Sum = 33 = 58 Combinations
Sum = 34 = 71 Combinations
Sum = 35 = 90 Combinations
Sum = 36 = 110 Combinations
Sum = 37 = 136 Combinations
Sum = 38 = 163 Combinations
Sum = 39 = 199 Combinations
Sum = 40 = 235 Combinations
Sum = 41 = 282 Combinations
Sum = 42 = 331 Combinations
Sum = 43 = 391 Combinations
Sum = 44 = 454 Combinations
Sum = 45 = 532 Combinations
Sum = 46 = 612 Combinations
Sum = 47 = 709 Combinations
Sum = 48 = 811 Combinations
Sum = 49 = 931 Combinations
Sum = 50 = 1057 Combinations
Sum = 51 = 1206 Combinations
Sum = 52 = 1360 Combinations
Sum = 53 = 1540 Combinations
Sum = 54 = 1729 Combinations
Sum = 55 = 1945 Combinations
Sum = 56 = 2172 Combinations
Sum = 57 = 2432 Combinations
Sum = 58 = 2702 Combinations
Sum = 59 = 3009 Combinations
Sum = 60 = 3331 Combinations
Sum = 61 = 3692 Combinations
Sum = 62 = 4070 Combinations
Sum = 63 = 4494 Combinations
Sum = 64 = 4935 Combinations
Sum = 65 = 5426 Combinations
Sum = 66 = 5940 Combinations
Sum = 67 = 6506 Combinations
Sum = 68 = 7097 Combinations
Sum = 69 = 7748 Combinations
Sum = 70 = 8423 Combinations
Sum = 71 = 9163 Combinations
Sum = 72 = 9933 Combinations
Sum = 73 = 10769 Combinations
Sum = 74 = 11637 Combinations
Sum = 75 = 12579 Combinations
Sum = 76 = 13552 Combinations
Sum = 77 = 14603 Combinations
Sum = 78 = 15690 Combinations
Sum = 79 = 16856 Combinations
Sum = 80 = 18059 Combinations
Sum = 81 = 19349 Combinations
Sum = 82 = 20673 Combinations
Sum = 83 = 22087 Combinations
Sum = 84 = 23540 Combinations
Sum = 85 = 25082 Combinations
Sum = 86 = 26663 Combinations
Sum = 87 = 28340 Combinations
Sum = 88 = 30051 Combinations
Sum = 89 = 31860 Combinations
Sum = 90 = 33706 Combinations
Sum = 91 = 35648 Combinations
Sum = 92 = 37625 Combinations
Sum = 93 = 39703 Combinations
Sum = 94 = 41809 Combinations
Sum = 95 = 44016 Combinations
Sum = 96 = 46253 Combinations
Sum = 97 = 48586 Combinations
Sum = 98 = 50944 Combinations
Sum = 99 = 53402 Combinations
Sum = 100 = 55875 Combinations
Sum = 101 = 58446 Combinations
Sum = 102 = 61031 Combinations
Sum = 103 = 63706 Combinations
Sum = 104 = 66388 Combinations
Sum = 105 = 69161 Combinations
Sum = 106 = 71928 Combinations
Sum = 107 = 74781 Combinations
Sum = 108 = 77624 Combinations
Sum = 109 = 80542 Combinations
Sum = 110 = 83440 Combinations
Sum = 111 = 86412 Combinations
Sum = 112 = 89348 Combinations
Sum = 113 = 92350 Combinations
Sum = 114 = 95311 Combinations
Sum = 115 = 98324 Combinations
Sum = 116 = 101285 Combinations
Sum = 117 = 104295 Combinations
Sum = 118 = 107235 Combinations
Sum = 119 = 110215 Combinations
Sum = 120 = 113119 Combinations
Sum = 121 = 116048 Combinations
Sum = 122 = 118889 Combinations
Sum = 123 = 121751 Combinations
Sum = 124 = 124507 Combinations
Sum = 125 = 127274 Combinations
Sum = 126 = 129930 Combinations
Sum = 127 = 132581 Combinations
Sum = 128 = 135109 Combinations
Sum = 129 = 137629 Combinations
Sum = 130 = 140008 Combinations
Sum = 131 = 142370 Combinations
Sum = 132 = 144587 Combinations
Sum = 133 = 146771 Combinations
Sum = 134 = 148800 Combinations
Sum = 135 = 150794 Combinations
Sum = 136 = 152617 Combinations
Sum = 137 = 154397 Combinations
Sum = 138 = 156004 Combinations
Sum = 139 = 157554 Combinations
Sum = 140 = 158923 Combinations
Sum = 141 = 160236 Combinations
Sum = 142 = 161354 Combinations
Sum = 143 = 162410 Combinations
Sum = 144 = 163273 Combinations
Sum = 145 = 164062 Combinations
Sum = 146 = 164654 Combinations
Sum = 147 = 165176 Combinations
Sum = 148 = 165490 Combinations
Sum = 149 = 165732 Combinations
Sum = 150 = 165772 Combinations
Sum = 151 = 165732 Combinations
Sum = 152 = 165490 Combinations
Sum = 153 = 165176 Combinations
Sum = 154 = 164654 Combinations
Sum = 155 = 164062 Combinations
Sum = 156 = 163273 Combinations
Sum = 157 = 162410 Combinations
Sum = 158 = 161354 Combinations
Sum = 159 = 160236 Combinations
Sum = 160 = 158923 Combinations
Sum = 161 = 157554 Combinations
Sum = 162 = 156004 Combinations
Sum = 163 = 154397 Combinations
Sum = 164 = 152617 Combinations
Sum = 165 = 150794 Combinations
Sum = 166 = 148800 Combinations
Sum = 167 = 146771 Combinations
Sum = 168 = 144587 Combinations
Sum = 169 = 142370 Combinations
Sum = 170 = 140008 Combinations
Sum = 171 = 137629 Combinations
Sum = 172 = 135109 Combinations
Sum = 173 = 132581 Combinations
Sum = 174 = 129930 Combinations
Sum = 175 = 127274 Combinations
Sum = 176 = 124507 Combinations
Sum = 177 = 121751 Combinations
Sum = 178 = 118889 Combinations
Sum = 179 = 116048 Combinations
Sum = 180 = 113119 Combinations
Sum = 181 = 110215 Combinations
Sum = 182 = 107235 Combinations
Sum = 183 = 104295 Combinations
Sum = 184 = 101285 Combinations
Sum = 185 = 98324 Combinations
Sum = 186 = 95311 Combinations
Sum = 187 = 92350 Combinations
Sum = 188 = 89348 Combinations
Sum = 189 = 86412 Combinations
Sum = 190 = 83440 Combinations
Sum = 191 = 80542 Combinations
Sum = 192 = 77624 Combinations
Sum = 193 = 74781 Combinations
Sum = 194 = 71928 Combinations
Sum = 195 = 69161 Combinations
Sum = 196 = 66388 Combinations
Sum = 197 = 63706 Combinations
Sum = 198 = 61031 Combinations
Sum = 199 = 58446 Combinations
Sum = 200 = 55875 Combinations
Sum = 201 = 53402 Combinations
Sum = 202 = 50944 Combinations
Sum = 203 = 48586 Combinations
Sum = 204 = 46253 Combinations
Sum = 205 = 44016 Combinations
Sum = 206 = 41809 Combinations
Sum = 207 = 39703 Combinations
Sum = 208 = 37625 Combinations
Sum = 209 = 35648 Combinations
Sum = 210 = 33706 Combinations
Sum = 211 = 31860 Combinations
Sum = 212 = 30051 Combinations
Sum = 213 = 28340 Combinations
Sum = 214 = 26663 Combinations
Sum = 215 = 25082 Combinations
Sum = 216 = 23540 Combinations
Sum = 217 = 22087 Combinations
Sum = 218 = 20673 Combinations
Sum = 219 = 19349 Combinations
Sum = 220 = 18059 Combinations
Sum = 221 = 16856 Combinations
Sum = 222 = 15690 Combinations
Sum = 223 = 14603 Combinations
Sum = 224 = 13552 Combinations
Sum = 225 = 12579 Combinations
Sum = 226 = 11637 Combinations
Sum = 227 = 10769 Combinations
Sum = 228 = 9933 Combinations
Sum = 229 = 9163 Combinations
Sum = 230 = 8423 Combinations
Sum = 231 = 7748 Combinations
Sum = 232 = 7097 Combinations
Sum = 233 = 6506 Combinations
Sum = 234 = 5940 Combinations
Sum = 235 = 5426 Combinations
Sum = 236 = 4935 Combinations
Sum = 237 = 4494 Combinations
Sum = 238 = 4070 Combinations
Sum = 239 = 3692 Combinations
Sum = 240 = 3331 Combinations
Sum = 241 = 3009 Combinations
Sum = 242 = 2702 Combinations
Sum = 243 = 2432 Combinations
Sum = 244 = 2172 Combinations
Sum = 245 = 1945 Combinations
Sum = 246 = 1729 Combinations
Sum = 247 = 1540 Combinations
Sum = 248 = 1360 Combinations
Sum = 249 = 1206 Combinations
Sum = 250 = 1057 Combinations
Sum = 251 = 931 Combinations
Sum = 252 = 811 Combinations
Sum = 253 = 709 Combinations
Sum = 254 = 612 Combinations
Sum = 255 = 532 Combinations
Sum = 256 = 454 Combinations
Sum = 257 = 391 Combinations
Sum = 258 = 331 Combinations
Sum = 259 = 282 Combinations
Sum = 260 = 235 Combinations
Sum = 261 = 199 Combinations
Sum = 262 = 163 Combinations
Sum = 263 = 136 Combinations
Sum = 264 = 110 Combinations
Sum = 265 = 90 Combinations
Sum = 266 = 71 Combinations
Sum = 267 = 58 Combinations
Sum = 268 = 44 Combinations
Sum = 269 = 35 Combinations
Sum = 270 = 26 Combinations
Sum = 271 = 20 Combinations
Sum = 272 = 14 Combinations
Sum = 273 = 11 Combinations
Sum = 274 = 7 Combinations
Sum = 275 = 5 Combinations
Sum = 276 = 3 Combinations
Sum = 277 = 2 Combinations
Sum = 278 = 1 Combinations
Sum = 279 = 1 Combinations
I hope this helps!
Alexafjb said:
Just trying to help, hope I'm not turnning into a pain.
Not at all
Alex.
Regards,
PAB
-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.