Archive for March, 2009
Looking For Numbers in Boxes – Excel Tips and Tricks
Posted by Chris Busbee in Chart of Accounts Structure, TECHANGES, Tips on March 19th, 2009
The following Excel® tips are widely applicable to reducing time on business projects, whether they are finance- or IT-related. It’s never too late to learn a couple of new tricks, and one of them just might wind up saving you hours of precious time on your next project. I recently had a seasoned IT consultant tell me that one of the maneuvers I’m about to show you was “the best thing he has learned in all his years of consulting.” You may already know some of these, but if not, it might be worth it to bookmark this page, or at least print it out and file it away somewhere.
This article is outlined with the easy tips you might already know up front, and we end with the all too elusive “Go To Special”. If you are working with spreadsheets that contain thousands, or even millions, of rows of data, then the “Go To Special” information will prove to be a helpful tool if you need to change a large or small amount of that data based on any kind of logical behavior. We’ll focus on 7 different tips, none of which involve macros or Visual Basic whatsoever – they are purely ground-level functions and features of Microsoft Excel. >>SHOW ME!!
When Projects Go Sour
Posted by Helene Abrams in Data Quality, News & Articles, TECHANGES, The Changing Enterprise on March 19th, 2009
It’s happened to all of us who have consulted. We start a project with appropriate planning, and then something happens and it seems that nothing is working anymore. Budgets and timelines have gone out the window, the client is upset, and we are in recovery mode. Without pointing fingers, here are some of the reasons that projects go astray.
- The scope is not well-defined. Especially with what are perceived as smaller projects, it is easy just to say, “Create these reports,” or, “Create an interface from this system into that one. “The specific requirements are not written out or reviewed with the user. The user thinks he or she is getting something that looks like A, and the consultant is sure that the requirement is for B. The consultant thinks the requirement is simple, and the user and the consultant don’t communicate very well.
- The scope expands and the change control process has not been considered carefully.
- We didn’t create, monitor, update, or follow the project plan. Project plans are an integral part of a successful project. The more detail in the plan, the better the estimate is. Creating good project plans is a real skill, but there is a lot of art involved too. For those of us experienced in creating project plans, there are red flags in our heads that show up when something is not as we expected from our experience on other projects. These early warning signs are good indicators that it is time to review and update the project plan.
- The scope is well documented, we have followed a strict change control process, and we have a plan, but it is a project that we have not done before, so we grossly underestimated the level of effort and resources required.
Take the case of the project that was estimated at $100,000. The consultant prepared the estimate, submitted it to the client, and the client accepted the proposal. A couple of months into the project, the consultant realized that the project was much more complex than anticipated and would cost 5 to 10 times as much as estimated. Three things tend to happen in that case. The first is that he continues the project, and when the $100K has been spent, nothing works. The client is unhappy but figures that by throwing a little more money to the consultant, everything will be fixed, so the project drags on. The client just keeps throwing good money after the bad. The second thing that happens is that the consultant points a lot of fingers and says that the users didn’t really communicate the requirements clearly or that something has changed. He then fills out a change control form for a huge amount of additional money. Sometimes the client buys into this, but often the entire project is abandoned. In a third scenario, the client decides to engage a different consulting firm. However, when the new consulting firm comes in, the client’s expectation is that they have already spent $100K on the project, so the remaining work is minimal and they don’t want to go back and confess that the first consultant made a mistake. After all, it was the client who signed off on the initial consultant’s proposal in the first place, so maybe it is just as much the client’s fault as it is the consultant’s.
How do you avoid this mess? The secret to a successful project is great documentation.
Documenting the requirements, documenting all assumptions, documenting the discussion items and issues around the requirements, documenting deviations from the scope or the project plan, documenting the basis for each line of the estimate, and documenting each decision that was made and the impact of that decision, along with documenting all the procedures, processes and all aspects of the build or implementation allows you and the client to closely monitor progress and provides early warnings when something is not as expected. With proper documentation it is easy to turn a project around before it is in trouble.
Don’t Walk Away from $15,450,000
Posted by Helene Abrams in News & Articles, Return on Investment Analysis, TECHANGES, Trends & Technology on March 19th, 2009
Yes, the economy is in the tank and will be for some time to come. Yes, the credit market is tight. I am hearing from several customers that all projects in their companies are frozen, even those projects that have a pretty substantial return on investment and a pretty quick cost recovery. There was even one project that was projected to generate annual savings of more than $10 million dollars that has been put off until after 2Q, 2010. The project was to start in January of 2009 and go into production by July of 2009. Let’s break that down a little bit.
The project was to go live in July, 2009, but has been postponed until July 2010. The projected annual savings of $10,000,000 will not begin to show results until the new projected go-live date of January, 2011 (18 months after the originally scheduled go-live date). During the eighteen months, the company could have been recognizing the results of $15,000,000 savings in operations – savings that would have gone straight to the bottom line. Additionally, even with a modest 3% investment, the company would have earned $450,000 on the $15,000,000.
More importantly, that money could have been used for research and development or for marketing activities that would have made the company more competitive. When the economy is down, buyers should think about how to use the money they have so that they get long-term benefits, recognize results quickly, and grow. For some more ideas on how to grow your business during a recession, please see this article.
