It happens to all of us: we’re asked for an electronic copy of a file that we created, and suddenly the panic sets in!  In order to avoid that sinking feeling in the pit of your stomach, it pays to implement a file-naming system.  Coupling it with a search feature like Windows Desktop Search, you’ll be able to retrieve that file easily.

The file naming system that I use is pretty comprehensive.  Some may call it overkill, but it works for me.  I use this for naming and renaming all file types, from Excel spreadsheets to Emails.  You know the old exercise of asking the Five W’s (Who? What? When? Where?).  I ask the questions When? How? Who? What? to develop file names.

When?

The When? Question is the date the file is created.  I use the format YYYY-MM-DD, starting with the year, followed by the month, and finally the day.  Pretty straightforward.

Example:          2009-01-20

How?

The How? Question is the type of file that is created.  This is where the overkill comments usually come up.  Why put the file type in the file name?  Just to make it easier to search through a list, as “excel” in a file name jumps out more than the .xls extension.

Example:          2009-01-20 email

Example:          2008-07-06 excel

Who?

This is particularly useful for files that originate as emails and are saved as pdf files.  I put the last name of the person who originated the file (for an email, this would be the sender).  If I’ve created the file, I just use my initials.

Example:          2009-01-20 email jones

Example:          2008-07-06 excel cb

What?

The final part of the file name is the What part.  This is what most people would traditionally use as a complete file name.  I try to be as descriptive as possible, which prevents me from having to open the file in order to se if it’s the “right one”, which wastes time.

Example:          2009-01-20 email jones operating budget due date

Example:          2009-07-06 excel cb 2Q overhead rate variance

Now, by utilizing Windows Desktop Search, you can type in any portion of the file name (The When How Who What parts), and easily find the file you’re searching for:

• Standing on the Shoulders of Giants jurvetson I'm the office Excel guru, but I wasn't always comfortable with computers.  When I first starting working, we only had terminals that were hooked to a mainframe.  The only software we used was the mainframe program.  There was one PC, which was located in a small side office. ......
• Excel How-to: A Macro to Hide Blank Rows on a Spreadsheet Today, a coworker asked me how to hide a row on his Excel spreadsheet.  This was a fairly large spreadsheet, with about 150 rows and 30 columns.  After showing him, he started to hide every other row, which would be an incredible waste of time for someone in his salary......
• A Simple Mortgage Amortization Table Kevin over at the No Debt Plan blog recently advised his readers to avoid mortgage accelerator programs like the plague.  He reasoned that you could set up your own mortgage accelerator program by adding 1/12 of a payment as additional principal to each month's payment.  I agree with Kevin. You......

• 5 Ways to Print Folder and Directory Contents in Windows Bookmark this category 5 Ways to Print Folder and Directory Contents in Windows It’s one of those simple tasks that suddenly come upon us and we have no idea how to go about it. I had a whole fat folder filled with ebooks and someone casually asked me to......
• Observations from my tax returns I have been filing with Turbo Tax since the 2001 tax year. The nice thing about the service is that I can see all of my prior year returns anytime. It is kind of interesting to see summary of the information over the years. Incidentally, 2001 is the year......
• UnderAppreciated Listings RSS Feed Update I started my RSS feeds on March 18th...  I thought I would check in on my favorite (Underappreciated Listings)...  There have been 6,364 listings profiled, requesting to borrower $61,781,819 or $9,952.01 per loan on average. Here is the listing status break down... Status Total Amount Number Per Loan Cancelled $3,427,672......