Solved

Using Excel to Check Password Strength

Posted on 2010-08-16
5
2,159 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
  • 3
5 Comments
 
LVL 11

Expert Comment

by:slemmesmi
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Actually, it did contain information on dictionary word checks!  Should have read more closely the first time.  Thanks!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Ransomware continues to be a growing problem for both personal and business users alike and Antivirus companies are still struggling to find a reliable way to protect you from this dangerous threat.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now