Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2775
  • Last Modified:

Using Excel to Check Password Strength

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.

Help, experts?
0
richdiesal
Asked:
richdiesal
  • 3
1 Solution
 
slemmesmiCommented:
Dear richdiesal,

check out the free Excel based "Lock IT Down" "Generate random password" http://articles.techrepublic.com.com/5100-10878_11-1032050.html which should answer you questions.

Kind regards,
Soren

P.S. There are plenty more on the Internet, just google those.
0
 
richdiesalProfessorAuthor Commented:
Hi slemmesmi -

I don't need a password generator.  I already have a list of passwords and need to quantitatively determine their relative strength to one another.
0
 
rbgCODECommented:
Why dont you write a VBA function that checks the actual password strength?  
http://www.codeforexcelandoutlook.com/excel-vba/password-strength-checker/
0
 
richdiesalProfessorAuthor Commented:
That's much closer!  That addresses most of what I'm looking for - but I still need to check for dictionary words contained within.
0
 
richdiesalProfessorAuthor Commented:
Actually, it did contain information on dictionary word checks!  Should have read more closely the first time.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now