Using Excel to Check Password Strength
Posted on 2010-08-16
I'm conducting a research project to examine various individual characteristics and their relationship with password strength. I currently have an Excel spreadsheet containing a fairly large list of passwords in Column A. I've managed to put together formulas to do most of what I need, but there are a few tripping me up.
I'd like to be able to add additional columns to assess the following:
B) Does the password in Column A contain any uppercase characters?
C) How many uppercase characters does it contain?
D) Does the password in Column A contain any lowercase characters?
E) How many lowercase characters does it contain?
F) Does the password in Column A contain any numbers?
G) How many numbers does it contain?
H) Does the password in Column A contain any special (non-alphanumeric) characters?
I) How many special characters does it contain?
J) If numbers are used, is Column A simply a dictionary word followed by a number?
and perhaps most tricky -
K) Does the password in Column A contain any dictionary words?
I am also open to using another method to get all of this information into a datafile - I have access to Windows and Linux systems. I thought there might be an automatic checker of some sort (I was led to a program called l0phtcrack?) but haven't found anything that will develop a derivative dataset from a large set of passwords.
Also, if there's any standard way to assess password strength (and produce a number quantifying that strength), that would be super-helpful.