Need to generate list of all possible combinations 1-10

tannersarms

New Member
Joined
Apr 10, 2005
Messages
16
Hello

I am quite sure this question will have been asked before, but I don't know how I would narrow my search enough to easily spot the exact type of question I am asking.

I have a Keysafe which is bolted to the wall and the combination has either been forgotten or changed by the last person to set it. Rather than spend $30 on buying a new one, not to mention the effort required remove the old one, I'd rather spend a few minutes trying all the possible combinations.

As far as I understand it, the "rules" on the keysafe are that the combination can be anywhere between 1 and 10 characters in length, and that duplication does not count. That is to say if I "set" the code as 1122, I could simply press 12 and unlock and it would open. For practicalities sake though, I only want to get a list of possible combinations with a length of four, and I don't mind if "invalid" combinations (i.e. 2244) appear in that list though it would be nice if possible to not have them appear.

Reading around on the internet suggests that there should be a total possible number of combinations amounting to 1,023, though I'm not sure how this was calculated.

Thanks you for any assistance.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
I'm not too sure what keysafe you are using in the first place.
One thing I'm not sure of:
Range of the numbers for each character (0 - 9?)

Lastly, it's against the rules in this forum to help a person break into a secured program... but then again it's a physical safe which is kinda different???
What's ur say in this, mods?
 
Upvote 0
Yes, the reference range is 0-9. It's a Supra Keysafe. I can take a picture of it from inside my property (and the box with the new one the other half wants me to put up in its place that I want to return to Amazon!)
 
Upvote 0
If it can't be posted,that's OK, I found a site called mathsisfun.com that reckons there are 210 possible 4 digit combinations (assuming repetition isn't used and order isn't important).
 
Upvote 0
Hi, there are more than 1023 combinations.

Since, order matters and there can be 1 - 10 characters to open the lock, there are
P(10, 1) + P(10, 2) + P(10 ,3) + ... + P(10, 10) which is...
9864100 combinations.

Do you really want to go through each one to open your lock?
 
Upvote 0
oops. didn't realize you needed 4-digit strings :P (silly me, it was in your first post1)
Anyways, glad you found your solution.
 
Upvote 0

Forum statistics

Threads
1,224,584
Messages
6,179,691
Members
452,938
Latest member
babeneker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top