Projects Possible

There are a LOT of theories and ideas floating around to help with time management and productivity.  Classes and seminars are offered, books are published, and websites and blogs are posted all to try to help us better manage our lives.  For this author there has been no one method to help with time and productivity management.   In fact before I knew about these methods I was trying to come up with things on my own that many of these methods suggest.

In today’s posting I am going to give some insight on how I manage my projects using Microsoft Outlook, ClearContext’s IMS, Nelson’s Email Organizer (NEO) and Excel.   My goal has been to try to get everything I do that is work related consolidated into a single location and while Outlook is getting pretty close, my work environment requires some additional reporting structures that keep me away from my single trusted system.

For those of you familiar with Getting Things Done (GTD) by David Allen, or Total Workday Control (TWC)by Michael Linenberger it is all about changing the way that we work.  This can be as simple as the little things like grouping like things together and working on them all at the same time to much more complex and time consuming changes like rebuilding your workspace, developing filing systems, etc.   The key for me was to latch on to an idea or two and work with them, integrate them into your life and then add more once I had mastered the ideas I was working on.

When I started managing projects I found rather quickly that the medium that people wanted to use for communication was email.  I quickly went from an email box of 20-30 pieces of significant email every day to 200-300 pieces of email every day.  Combine that with customer face time and limited access to email and I soon found I was not keeping up.  I needed a solution that could help me manage and find things much easier than I had in the past.   The solution I found at the time was Nelson Email Organizer.  This is a great tool and one that I use to this day for email searches and correspondent management right from within Outlook.  NEO It was my first attempt at managing each piece of email in my Inbox, giving it a home, and knowing and being comfortable with the fact that I was going to be able to find it again if needed.   Another KEY feature of NEO for me was the ability to search across multiple mail stores.  Remember that 2GB limit that Outlook used to have?  My solution to that was to create separate Archives and move messages into those archives.   The down side to that is the messages were no longer search-able in Outlook unless I loaded each of the archives one at a time and performed the search.  Because NEO creates its own set of indexes that are super fast, this restriction was removed and I could keep years worth of email and search through 10s of thousands of messages in a matter of seconds.

NEO and Outlook worked well for me for quite awhile but NEO didn’t help me with managing tasks and so I went on the hunt once again for web solutions for project management.  Ultimately I stumbled across GTD (Getting Things Done) and TWC (Total Workday Control).  Take a look at the graphic.  The concept with these systems is that as messages come into your inbox you need to make a decision about them.  Ask yourself if you need to do something with this email… If not you probably just need to file it away as a reference or better yet if it isn’t going to be needed just delete it. (NEO would help me with this so this was nothing new.)  The other side of the equation however is more difficult to deal with.  If I need to do something with it, what is it that needs to be done, who should do it, when should it be done, etc… all start entering into the picture.   As you can see from the graphic there really are 3 choices… I do it now, I delegate it to someone else, or I hold onto it until a future date.  It was something that hit me as being so simple yet almost unbearable to manage.  That is where ClearContext’s IMS product entered the picture for me.  With IMS not only are the non-actionable items manageable but the actionable items become manageable as well and all linked to the appropriate projects and people.  I downloaded it, installed it and I’ve never looked back.  Keep in mind that I don’t claim to be a GTD or TWC guru and I don’t do all of the things that I’m supposed to do nor will I probably ever do them all.  I don’t even use all of the functionality that exists within ClearContext’s IMS product (yet).  That isn’t the point.  The point is I use what works for me and as I fine tune my process I may also find I use more of their concepts or in the case of the software their tools. 

The last tool that I have started using pretty extensively is Excel.  I find that I can use it to keep track of a lot of information in an organized form and have at my fingertips information about each project that I use on a day to day basis.  With Excel I am able to streamline common project tasks information on the items that are repeated for each project that I work on.  The members at Excelforum  have really helped me in this end goal by helping me to create scripts that help me keep track of tasks that are completed, scripts that help me to create new task spreadsheets with limited numbers of key-presses, and most recently with a script that helps me to create Outlook tasks for each and every item  of a project that I need to be tracking.

While my methods are not perfect… the goal is and has always been to increase my productivity and reducing the amount of work that I have to perform.   I’m always looking for great new ideas so if you have any to share please do so.   In the next few weeks I hope to share with you some of the scripts that I use in my Excel workbook.  I also encourage you to read my reviews on ClearContext or better yet go to their website and download the application and give it a try.

By my own admission I am NOT a Microsoft Excel expert.  I know enough about the application to make me dangerous. 

I use Excel pretty extensively in my day to day work activities, and in my continuing effort to streamline my day I decided that I needed to add some functionality to my project management spreadsheet.  This spreadsheet has really become my single point of information for all of the projects that I work on and I wanted to enhance it even further by integrating it with Outlook.

The integration that I had in mind was to read through the TASKs that I have detailed in my Excel worksheet and IF there was a due date to create a task for me in Outlook using this date as the due date and various other information from the spreadsheet as my subject.   I certainly didn’t have the expertise needed to complete this task on my own so I headed out on the Internet to find a solution.

Google is a great thing! Within a matter of minutes I had any number of resources available to me from my search terms about Creating Outlook Tasks from Excel.   Many of them included quoted scripts that gave me a head-start on what I wanted to do but ultimately none of them quite met my specific criteria.  I decided what I should probably do is simply pose the question to the experts in some of the forums that Google was pointing me to.

Now keep in mind that your mileage may vary at these sites.  I’m simply telling you of my experience.  I’m sure with the thousands and thousands of posts that each of these sites have that either would be a good place to get solutions.

I went to http://www.excelforum.com/to start with.    This particular site had helped me a number of months prior with a question I had about populating a cell with a date when I clicked on a check-box.  Within a matter of hours I was up and running with the script that I needed to perform this task.  My Outlook task on the other hand did not get the same type of response.   I was provided with virtually the same code that I had found doing Google searches and when it came to customizing that code my post sat unanswered.

A few weeks later I decided that I would try to reinvigorate the project and again get on my trek to higher productivity.  I Googled again and this time I found a post at http://www.ozgrid.com/forums-  It actually had a few Google hits that led me to believe there were people there that knew exactly what I was wanting to do.  I can tell you that on this site you need to heed the warnings of reading the RULES. And that the rules are Strictly enforced.  You have plenty of opportunity because they are part of the main page, you hear about it in the registration, and even when you are ready to post.

Read more »