Welcome Guest
Log In | Register )
The time is now 5:30 am
You last visited October 25, 2014, 5:24 am
All times shown are
Eastern Time (GMT-5:00)

Creating a Number Scrambler

Topic closed. 2 replies. Last post 6 years ago by Raven62.

Page 1 of 1
PrintE-mailLink
Avatar
New Member

United States
Member #13881
April 16, 2005
3 Posts
Offline
Posted: March 17, 2009, 8:15 am - IP Logged

I'm looking to scramble a set of numbers and can't seem to find how to do it anywhere.

So if I have a set of numbers of say:

1 2 3 4 5 6 7 8 9 10

I would want to scramble them like this randomly:

10 1 5 9 2 6 4 8 3 7

I would need to do it for any set of numbers up to 39.

I want to play 3 sets of 11,12 & 13#'s to cover either 33,36 or all 39 digits.

I'm scrambling the #'s so I can try and get at least 4 digits to come up in one of my 3 groups. I can do it manually but it take up a lot of time and you tend to think too much on how to group them which I don't want to do. I rather scramble them and then back test the results by groups to see how many groups have 4 or more digits in them.

I tried looking for a way to do it in excel but couldn't find anything.

Thanks,

TedK

    Jack-C's avatar - us
    San Diego, CA
    United States
    Member #61467
    May 24, 2008
    28146 Posts
    Offline
    Posted: March 17, 2009, 8:34 am - IP Logged

    Go to random.org.  You will find on the left near the bottom a "list randomizer".  That should do the trick.

      Raven62's avatar - binary
      New Jersey
      United States
      Member #17843
      June 28, 2005
      17937 Posts
      Offline
      Posted: March 17, 2009, 10:20 am - IP Logged

      I'm looking to scramble a set of numbers and can't seem to find how to do it anywhere.

      So if I have a set of numbers of say:

      1 2 3 4 5 6 7 8 9 10

      I would want to scramble them like this randomly:

      10 1 5 9 2 6 4 8 3 7

      I would need to do it for any set of numbers up to 39.

      I want to play 3 sets of 11,12 & 13#'s to cover either 33,36 or all 39 digits.

      I'm scrambling the #'s so I can try and get at least 4 digits to come up in one of my 3 groups. I can do it manually but it take up a lot of time and you tend to think too much on how to group them which I don't want to do. I rather scramble them and then back test the results by groups to see how many groups have 4 or more digits in them.

      I tried looking for a way to do it in excel but couldn't find anything.

      Thanks,

      TedK

      In Excel you may be able to use the Function: Random Between:

      =RANDBETWEEN(1,10)

      Use the Excel Help Function for Additional Information!

      A mind once stretched by a new idea never returns to its original dimensions!