Excel Formulas for Consecutive Numbers
- Thread starter PAB
- Start date
gsobier said:
An ordinary lottery fan may play a few tickets and that's it, mostly dreaming about some sort of a good win. In my opinion even a few or several tens are just a few tickets regarding the odds. That doesn’t mean all players are the ordinary ones. If someone with an overload of money tosses a few thousands of tickets, that will probably be solidly secured with a few hundreds of tickets regarding some "unexpected" draws. I believe this last "unexpected" draw had more 4/6 winners than the previous "expected" one .
In my opinion , from this reason an ordinary lottey fan has a pretty slim chances having quite narrow spaces for any solid backups because of the ticket prices ...
Last edited:
...ever since the price change, either Keno or your Regional game is where you should play... ...6/49 is simply not a good one to play anymore...
...its debatable there were more 4 numbers winne for specific reasons... ...the most elementary way to play is using the 7 numbers from the last draw... ...it was darn close to 5+
... ...don't expect something like this again for a long time...
...its debatable there were more 4 numbers winne for specific reasons... ...the most elementary way to play is using the 7 numbers from the last draw... ...it was darn close to 5+
... ...don't expect something like this again for a long time...tomtom said:
gsobier said:
Well, my regional game has computer generated draws. They say their computer is apsolutelly independent and not connected to any networks. Also draws are checked for true randomness regularly by a qualified outside guys or such, so probably will try it. It is $1/ticket game, which is not that bad.
About Keno....don't know how many possible combinations are there...a zillion?
...Keno is a different kind of "animal" where there is a bit of forgiveness because 20 numbers are drawn... ...you choose how many numbers you intend to select for a match... ...there are some players like Charles2 and Karnac who post how they are doing... ...I think one of the stategies is dealing with repeaters...
tomtom said:
...
Root sum possibilities
PAB
I looked at your question and started with an idea for a macro but soon determined that formulas could be another mean to get the same information.
I started working on it but after passing so much time calcultating for the 6-0-0-0-0-0, I had to work. But it appears you beat me to it.
As far as your question on A2 vs A1, look near the bottom of the macro where I transfer the data in a spreadsheet (the FOR ... NEXT loop). With A1 being selected, I used the ActiveCell.Offset to list the result with the variable I indicating the number of lines to go down for each listing.
PAB
I looked at your question and started with an idea for a macro but soon determined that formulas could be another mean to get the same information.
I started working on it but after passing so much time calcultating for the 6-0-0-0-0-0, I had to work. But it appears you beat me to it.
As far as your question on A2 vs A1, look near the bottom of the macro where I transfer the data in a spreadsheet (the FOR ... NEXT loop). With A1 being selected, I used the ActiveCell.Offset to list the result with the variable I indicating the number of lines to go down for each listing.
gsobier said:...come on down
Well, I'm in lottery waters for a quite few years...and will not be satisfied without seeing a 5 +B check at least. At 50 cents/ticket I would try for a JP at least once monthly..and try doesn't mean a few tickets sometimes.
...of course if that lottery clearly states there aren't any networks and that stuff if it has some computer generated draws...Sometimes I think how those New Zealand and Australian guys are pretty lucky...their economy is probably at same level as here, but they have some 6/40 lotteries or such at $1/ tickets...plus unlimited number of sunny days additionally..
Huh, it went out of topic a bit too much. It's not my fault
. I was just tottaly surprised that even you Gsobier started to say 6/49 is simply not a good one to play anymore. It is about the same type of surprise as if you said you started to prefer MS programs ( and Apple – Mac additionally now ). Well, I have and like both of them but don't think you might trade that IBM stuff of yours...
Last edited:
CMF
Member
Re Australian Lotto
TomTom
Try 55c per play, pick 6 from 45 with 2 Bonus Numbers, Double Up on all prizes except 6 and 5 + Bonus for slightly more, minimum payouts for the lower prizes of around double what I see elsewhere and the most important bit - you win a million it's all yours - no tax at all.
Regards
Colin
TomTom
Try 55c per play, pick 6 from 45 with 2 Bonus Numbers, Double Up on all prizes except 6 and 5 + Bonus for slightly more, minimum payouts for the lower prizes of around double what I see elsewhere and the most important bit - you win a million it's all yours - no tax at all.
Regards
Colin
...off topic, tell me about it... ...I pretty near quit 6/49 when the price changed... ...Ontario 49 is where the action is... ...as for IBM, "from my cold dead hands"...
...
tomtom said:Well, I'm in lottery waters for a quite few years...and will not be satisfied without seeing a 5 +B check at least. At 50 cents/ticket I would try for a JP at least once monthly..and try doesn't mean a few tickets sometimes.
Sometimes I think how those New Zealand and Australian guys are pretty lucky...their economy is probably at same level as here, but they have some 6/40 lotteries or such at $1/ tickets...plus unlimited number of sunny days additionally..
Huh, it went out of topic a bit too much. It's not my fault
gsobier said:...off topic, tell me about it... ...I pretty near quit 6/49 when the price changed... ...Ontario 49 is where the action is... ...as for IBM, "from my cold dead hands"
Well, if I move there one day will ask you which draws you will not play, so then I will have some fair chances to get that one million in full
gsobier said:
No
, I didn't mean that Gsobier...I meant if for some reason you avoid some draws, people will have more chances to get that one million in full...otherwise might gotta share it with you...you seem to be quite good in picking some numbers..BTW, one day I might send you an e-mail if you are interested in sharing some strategies that might work..and might not, though
.....there is someone else I know who is way better... ...next that person, I don't know the first thing... ...if you know my e-Mail, send away.. ...we are not allowed to exchange e-Maill addresses here...
tomtom said:No
BTW, one day I might send you an e-mail if you are interested in sharing some strategies that might work..and might not, though