Solved

Using Excel to Check Password Strength

Posted on 2010-08-16
5
2,397 Views
Last Modified: 2013-11-08
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
Comment
Question by:richdiesal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 11

Expert Comment

by:slemmesmi
ID: 33452307
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
 
LVL 9

Author Comment

by:richdiesal
ID: 33456221
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
 
LVL 6

Accepted Solution

by:
rbgCODE earned 500 total points
ID: 33459298
Why dont you write a VBA function that checks the actual password strength?  
http://www.codeforexcelandoutlook.com/excel-vba/password-strength-checker/
0
 
LVL 9

Author Comment

by:richdiesal
ID: 33459740
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
 
LVL 9

Author Closing Comment

by:richdiesal
ID: 33460258
Actually, it did contain information on dictionary word checks!  Should have read more closely the first time.  Thanks!
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A hard and fast method for reducing Active Directory Administrators members.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question