+ Reply to Thread
Results 1 to 3 of 3

Euromillions Number Shuffle Help

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    london
    MS-Off Ver
    Excel 2019
    Posts
    33

    Euromillions Number Shuffle Help

    i need some help with my lottery formulas - which has been a hobby of mine for some time.

    i need to buy 66 tickets (as this is the non-repetitive coverage of all the numbers, so which ever pair of lucky stars come up they are covered with 66 tickets) - although i dont need help with this!!

    each row has a set of numbers that it selects from i.e.

    Row 1 is always between 1 & 20
    Row 2 is always between 4 & 33
    Row 3 is always between 11 & 38
    Row 4 is always between 18 & 45
    Row 5 is always between 30 & 50

    Also there is a distance of circa 20 numbers between rows i.e. if the number from row 1 is 6 the the number from row 2 will be between 7&26 & so on..

    I have tried shuffling all the numbers & using a goal seek but to no avail, although the solution needs to stay true to the attached as all the numbers need to be included but shuffled to suit & if possible factor in the distances.

    if its to complicated to shuffle all rows then maybe just 1 row at a time could be done?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Euromillions Number Shuffle Help

    First question, you say "Also there is a distance of circa 20 numbers between rows i.e. if the number from row 1 is 6 the the number from row 2 will be between 7&26 & so on.." however at the start you say "Row 2 is always between 4 & 33", can you explain what happens here?
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    02-02-2012
    Location
    london
    MS-Off Ver
    Excel 2019
    Posts
    33

    Re: Euromillions Number Shuffle Help

    HI, thanks for your question!
    from my statistical analysis although each row has numerical parameters i.e.

    Row 1 is always between 1 & 20
    Row 2 is always between 4 & 33
    etc..

    When i created a number predictor, which looked at row1, row2, row3 etc..
    & deduced that if i was randomly picking a number for each row between the values i could have my 1st number as 1 & my 2nd number as 33,
    however the predictor deduced that this isn't probable & if number 1 was picked for row 1 then the 2nd number would be no more than 20 numbers above.

    hence if the 1st number was 13, then the 2nd number could be, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32 or 33.
    or if the 1st number was 5, then the 2nd number could be, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24 or 25.
    it wouldn't be above 33 as this is the upper parameter for row 2, but the distance between the 1st & 2nd number etc.. would never be more than 20.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Shuffle array VBA
    By sigit21 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-18-2018, 05:47 AM
  2. i have problem
    By Apintoo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-08-2016, 03:34 PM
  3. New to VBA, Shuffle Words
    By SteelMessiah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2013, 04:32 PM
  4. [SOLVED] Shuffle Right
    By keen2xl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2013, 01:40 AM
  5. Excel 2007 : How to shuffle words in a row?
    By emil9216 in forum Excel General
    Replies: 9
    Last Post: 10-24-2011, 02:16 PM
  6. [SOLVED] Shuffle Array
    By Rik Smith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2005, 12:05 PM
  7. Shuffle the cells!
    By M H in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2005, 04:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1