Page 4 of 4 FirstFirst ... 2 3 4
Results 46 to 52 of 52
  1. #46
    Join Date
    Aug 2009
    Location
    UK
    Posts
    844
    I have an Excel counting grid that adds one to the previous count of each ball since the cycle started. It also notes how many undrawn balls are drawn so far in the cycle, and how many are still to come. Its important to remember that the cycle start draw has to be reset once the previous cycle is completed, so the grid resets to zero apart from the first seven balls drawn in the new cycle, whose counts become 1 ! That's a manual thing done by me when the bell rings (to warn me the cycle has ended).

  2. #47
    Join Date
    Aug 2013
    Posts
    190
    Are you using formulas or a macro? It would seem you could use a macro as a reset back to zero,

    So, it you have 69 balls you don't reset it back to 0 until ALL have played?

  3. #48
    Join Date
    Aug 2009
    Location
    UK
    Posts
    844
    For the specific analysis of the CURRENT cycle in real time , I use formulas, but I use a macro to play a sound to draw my attention to the end of the cycle. I don't particularly want or need to automatically reset it once every 20 weeks or so.

    The start of the cycle is a named range, so I just go into name manager and change the address of that named range, it takes about 10 seconds.

    Yes, you don't reset (all balls to zero ) until all your 69 balls have been drawn, but this in practice means that the first draw of the new cycle ( which is the draw after the one where the final ball(s) were drawn) will have seven balls with a count of 1, and (69-7) undrawn balls. There is never a situation where the drawn ball count is zero .
    For historical analysis looking back over years of draws, i used a macro and formulas to scan the results and flag up the start of each new cycle and count cycle lengths.

  4. #49
    Join Date
    Aug 2013
    Posts
    190
    Hmmm, this caught my attention lol okay, when you back tested how were the results? Were the beneficial to help you make decisions today?

  5. #50
    Join Date
    Aug 2010
    Location
    Canada & TX endless summer
    Posts
    2,119
    I would say the methodology is helpful. I divides the balls into 2 groups and gives guidelines as to how many hits can reasonably be expected from each group. It is most useful in the middle of the cycle when the groups are most similar in size, and less useful at the beginning and the end of the cycle when you have few numbers in one group or the other.

    BTW, nice to see you again. Its been a while.

    Good Luck!

  6. #51
    Join Date
    Aug 2009
    Location
    UK
    Posts
    844
    I haven't been into cycle analysis that long. I did it out of interest after Icewynd published details of the methodology. I did publish some details of my results earlier in this thread, but the UK Lotto is still in its first cycle of the new matrix after 57 draws (way over average), with just one ball to be drawn to complete the cycle. With the last 20 draws creating newly drawn balls at this rate:-
    2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

    theres not much help coming from this !

  7. #52
    Join Date
    Aug 2013
    Posts
    190
    Thanks ice, lots of personal stuff going on from raising my 2 1/2 year old grandson since age 1 month to a nasty pulled groin muscle injured twice within 3 months ..... I'm getting too old for this stuff lol

    I'll have to play around with excel and perhaps our lotto Texas or two step since there has not been any matrix changes in years. Actually never in the two step.

    I'm not familiar enough with name range like your doing Frank so I'll read up on it

Page 4 of 4 FirstFirst ... 2 3 4

Similar Threads

  1. Eliminate up to 18 numbers from 6/49
    By Icewynd in forum Lotto Tips & Strategies
    Replies: 52
    Last Post: 11-18-2014, 09:35 AM
  2. Random Number Generators (revisited)
    By winhunter in forum Anything Goes
    Replies: 33
    Last Post: 07-01-2005, 07:26 PM
  3. Cycles et permutations!
    By Dennis Bassboss in forum Lotto Tips & Strategies
    Replies: 5
    Last Post: 10-25-2004, 08:00 PM
  4. Winter revisited...
    By Sheba in forum Anything Goes
    Replies: 1
    Last Post: 04-25-2004, 02:51 PM
  5. Quick Pick City revisited
    By Brad in forum Anything Goes
    Replies: 2
    Last Post: 01-15-2004, 01:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •