Combination lock how many possible combinations?

Discussion in 'Community Discussion' started by Frisco, Jun 26, 2015.

  1. Frisco macrumors 68020

    Joined:
    Sep 24, 2002
    Location:
    Utopia
    #1
    Combination lock found by my son. He wants to play with it and try different combinations.

    Four rows of numbers 1 through 6.

    I was thinking the possible number of combinations is 4^6=4096. Is that correct?

    Is there a way in excel to see all the possible combinations? I want to give him the list and tell him to try 10 different ones a day and see how many days in takes.

    Thanks!
     
  2. juanm, Jun 26, 2015
    Last edited: Jun 26, 2015

    juanm macrumors 65816

    juanm

    Joined:
    May 1, 2006
    Location:
    Fury 161
    #2
  3. Frisco thread starter macrumors 68020

    Joined:
    Sep 24, 2002
    Location:
    Utopia
    #3
    Thanks, but it's not about having a working lock. It's how to determine the actual combinations.
     
  4. chown33 macrumors 604

    Joined:
    Aug 9, 2009
    #4
    It's counting up in base 6. In short, when a wheel or whatever goes from 6 to 1 (rollover), increment the next higher wheel by 1 (carry out to the next higher digit). Apply the same rule to every wheel, so when the 2nd wheel goes from 6 to 1, increment the 3rd wheel by 1.

    If you want to give him a daily task, have him cycle through 36 trials each day. So the two lowest wheels would go through 36 trials, and the 3rd wheel would increment by 2. If the combination is random, there's a 50% chance of hitting it after 18 days. After 36 days, every combination will have been tried.

    From my own experience as a kid, if he gets through every combination without it opening, then there was some sloppiness in setting the trial or in testing to see if it will open. Mine was 4 wheels with 10 numbers per wheel, so it took a lot longer to go through them all. After getting halfway through the second full cycle I gave up and filed it open. Not usable, but at that point I didn't care.
     
  5. Gutwrench macrumors 65816

    Gutwrench

    Joined:
    Jan 2, 2011
    #5
    I agree with this. 6^4 or 1296.
     
  6. Frisco thread starter macrumors 68020

    Joined:
    Sep 24, 2002
    Location:
    Utopia
    #6
    I managed to get a unique list of 1296 possible combinations, but I had to do it the hard way. I just kept randomly creating numbers 1-6 in 4 columns and then using the remove duplicate features and repeating until there were no more duplicates and only 1296 values remained. Excel has a lot of great functions and the "Remove Duplicate" feature was a welcome addition in either Excel 2007 or 2010. I have 2013 now. However one glaring feature function that is still missing is unique values although I know there is an array formula to count unique values.

    Thanks for getting me started with the 1296 possible combinations!

    Here's the file if you want to add some excitement to your Friday night :)
    https://www.dropbox.com/s/o83k77mqgen0utz/Possible Combinations.xlsx?dl=0
     
  7. triptolemus macrumors 6502

    triptolemus

    Joined:
    Apr 17, 2011
    #7
    +1296/10 = 129.6 -- therefore, it will take between 1 and 130 days to accomplish the given task.

    What a fabulous waste of time!

    Code:
    Sub listofnumbers()
    
    Dim a As Integer
    Dim b As Integer
    Dim c As Integer
    Dim d As Integer
    Dim x As String
    
        For a = 1 To 6
            For b = 1 To 6
                For c = 1 To 6
                    For d = 1 To 6
      
                        x = Str(a & b & c & d)
                        ActiveCell.Value = x
                        ActiveCell.Offset(1, 0).Select
      
                    Next d
                Next c
            Next b
        Next a
    
    End Sub
    
     
  8. juanm macrumors 65816

    juanm

    Joined:
    May 1, 2006
    Location:
    Fury 161
    #8
    It'll be much faster if you attach the lock to something solid (with a piece of string, or something), so that he can keep his hands wrapped around it, move the dials with his thumbs, and pull, instead of moving the dials, changing his hands so the can pull in opposite directions with his hands, then changing his hands again, moving the discs...

    If you want to teach your kid something useful, get him and Arduino starter kit and have him program simple programs.
     
  9. JamesMike macrumors demi-god

    JamesMike

    Joined:
    Nov 3, 2014
    Location:
    Oregon
    #9
    If he can not get it open, he might try using a stethoscope while turning the dials, listening for a distinct different sound, writing down that number, precede to the next number.
     

Share This Page