Go to ...

Troubled Projects

Special Interest Group

Troubled Projects on Google+Troubled Projects on YouTubeTroubled Projects on LinkedInTroubled Projects on TumblrTroubled Projects on PinterestRSS Feed

Project Management Software program – A Comparison With Spreadsheets for Controlling Tasks

Spreadsheets are the king of project management assistance tools for the reason that they are the most easy resource to use and the most often employed resource. How do they review to project management computer software? What are the benefits of each and every and when really should you make the swap to project management computer software? Although only you can make the willpower as to when you really should make the swap, this posting will walk by way of the benefits of each and every and provide some guidelines.

Based on which analysis you rely on, the sector for project management computer software is among $1.five billion and $3.five billion. That is for computer software that is exclusively intended to assistance project management. Most organizations that have designed sizeable endeavours toward productive project management have acknowledged that it is very complicated to control a bigger quantity of jobs and people today, or a greater project, without the assistance of know-how.

But there is no resource for project management that is additional popular or common than the spreadsheet, inspite of the simple fact that spreadsheets are not intended to be project assistance tools. Even in organizations with an proven project management resource, spreadsheets are employed. There are obvious explanations for this. A spreadsheet program is on virtually just about every laptop in just about every corporation, people today are familiar with spreadsheets and how to use them, and people today are pre-disposed to use these “office environment” kinds of computer software tools to resolve troubles. And I am ideal there with them. I appreciate working with spreadsheets to keep track of all varieties of info. It is effortless, easy, and I admit ego-boosting to demonstrate off what I can do in a spreadsheet.

With that in head, let us seem at some of the distinctions among these two distinct kinds of tools. For the applications of this posting, I chosen 6 criteria by which to make the comparison. These have been chosen from the suggestions of clients and potential clients as properly as discovering what is critical for the effective adoption and implementation of project tools inside an corporation.

Data Mining

Data mining is a large component of project management tools. The full reason for having a resource is to acquire info, so that you can seem intelligently at that info, make guaranteed your procedures are performing as marketed, and make excellent decisions. You need to know which jobs and duties are slipping by way of the cracks so that you once more respond. You need to know when you will not have more than enough sources to meet up with demand so that you can allocate them correctly or control the demand. You need to know which challenges are lurking so that you can tackle them now ahead of you lose the favor of a essential customer. And you need to see how your procedures are working so that you can repeatedly increase your procedures.

In modern economy, competitive landscape, and accountability benchmarks you must have the info. Managers are obtaining blindsided for the reason that they do not know what is coming and what is going on. This is exactly where the ideal project management computer software resource shines and spreadsheets fade. A excellent project management resource will be databases-oriented and really should permit for distinct kinds of advert hoc reporting throughout various jobs. This enables the mining of all varieties of info. You simply just cannot do this in a spreadsheet at the same stage. If you truly, truly know what you are undertaking it is feasible to tie spreadsheets jointly and crank out some integrated info. But that is not the same matter. You simply just cannot, on a whim, mine into the info represented in your various spreadsheets. And in modern atmosphere, this is critically critical. Gone are the times when not having the ideal info is satisfactory.

Benefit: Project Management Software program

Relieve of Use

There are project management computer software techniques that are effortless to use. Even so, spreadsheets clearly have an benefit here. Most people today are familiar with how to use spreadsheets they are at ease with them, and even like working with them. A significant reason is for the reason that spreadsheets have no framework. Folks are not generally “pressured” into how to use them. They are cost-free to use them however they want. Of study course, there is a draw back to this. It is very complicated to standardize a system or have any type of standard info framework when there is no framework in the resource by itself. Even so, from a stringent relieve of use standpoint, spreadsheets cannot be defeat.

You can counter this in project management computer software by using excellent, applicable, and periodic schooling, keeping your implementation very simple, and working with can help this kind of as templates. But we’ll give the benefit of this a person to spreadsheets.

Benefit: Spreadsheets

Centralized Obtain

One particular of the factors that organizations are undertaking these days to turn into additional competitive and additional efficient is to provide everybody accessibility to the project details that they need. Marketing organizations are putting all of the details on the internet about each and every client project. Engineering organizations are monitoring all schedules and straight away determining troubles. Government businesses are putting all of the various required info on the internet with their jobs. And on it goes. The value of instant accessibility to details is profound. An engineer can seem at a person technique and straight away find the technical specs he requirements. A client manager can keep track of the standing of his client’s jobs and determine challenges early. A expert services manager can seem up the contract details and scope of perform for a important project ahead of answering a concern.

Productivity indicates yielding outcomes, bringing factors about, or generating factors come about. This type of centralized accessibility enables those people on the entrance strains of yielding outcomes to know which motion to get when.

Task management computer software, in particular on the internet project management computer software, wins this a person hands down. Spreadsheets are not intended for accessibility by various people today from various places. They are intended with a solitary file / solitary consumer state of affairs in head.

Benefit: Project Management Software program

Maintenance and Administration

Time and once more, I chat with organizations that are paying an remarkable quantity of time sustaining spreadsheets. There is so a great deal time used on routines attributable to spreadsheet usage:

  • Monitoring down the ideal spreadsheet
  • Monitoring down the ideal version of the ideal spreadsheet
  • Monitoring down the electronic mail with the ideal version of the ideal spreadsheet
  • Emailing out the ideal spreadsheet to the people today that you should not have it
  • Monitoring down the people today who have the details that is essential to update the spreadsheet
  • Really updating the spreadsheet
  • Sustaining the formulas and formatting of the spreadsheet
  • Updating the standard format of all the spreadsheets to accommodate a “system enhancement”
  • Generating new spreadsheets

And the record goes on. The point is that even though any resource will get time to maintain, spreadsheets get an inordinate quantity of time for the reason that they are solitary-consumer concentrated. Only a person human being can update them at a time. They also get time for the reason that they are file-centered, which means that you have to maintain independent files. Until an corporation is truly excellent with a system to control these files (the exception not the rule), the files tend to be saved in a hodgepodge of places with non-standardized file names and even non-standardized layouts. If you get the time to examine the quantity of time people today get to maintain these spreadsheets, you will be impressed.

On the flip-side, project management computer software also usually takes time to maintain. I cannot say usually. It usually takes time to make guaranteed the info is accurate in the technique, that procedures are staying adopted correctly, and to simply just get details in the technique. One particular of the flip sides of this is that many project management computer software techniques help the entry of details by everybody so that a person human being does not have to both find and enter the details. In this state of affairs, the upkeep is additional definitely upkeep than continual, non-cease info entry.

There are some strategies to minimize the quantity of upkeep and time used on project management computer software techniques, and these are concentrated on the initial setup. If you setup the technique properly, the upkeep time is decreased. Utilizing goods this kind of as templates and pre-setup studies truly enable to minimize the quantity of time used in the resource.

Although both kinds of tools require time, a properly setup project management computer software technique definitely has the edge in excess of spreadsheets.

Benefit: Project Management Software program

Overall flexibility

Overall flexibility in this context refers to the means of the resource to adapt to your procedures. In practicality, this refers to factors this kind of as staying ready to keep track of any type of info peculiar to your organization (i.e. introducing fields), or applying a new project template.

This is a harder attribute to evaluate, in particular with the variation in project management computer software tools. Numerous tools are very rigid, which means what you see is what you get. Some tools have turn into additional adaptable and permit a fantastic offer of adaptability – this kind of as staying ready to adapt screens and info constructions. This has turn into more and more critical.

It is complicated to accomplish a direct comparison for the reason that it truly relies upon on the project management computer software technique that you are analyzing, but in reality many techniques will not be as adaptable as a spreadsheet. In a spreadsheet, you can make a new column or row on a whim or make a brand name new spreadsheet to keep track of new details. Definitely there is a draw back to this versatility, exclusively the problems in standardizing a system. Even so, from a stringent seem at versatility, we have to give spreadsheets the nod. But I warning you to exam your project management computer software technique for versatility and do your individual comparison.

Benefit: Spreadsheets

Resource Allocation and Forecasting

This is related to info mining, but it is so critical that it will get its individual billing. The management of which sources are assigned to which jobs and duties is a essential ingredient of project management and a person of the significant distinctions among spreadsheets and project management computer software.

There are 3 essential pieces to assure excellent useful resource management. These include things like:

  • A excellent perform breakdown framework (breakout of the duties in a project)
  • A excellent estimation of the effort and hard work (not period) to be expended on each and every undertaking (and hence project)
  • A composite watch of this details throughout all jobs

Since of the solitary-file aim of spreadsheets, a excellent project management computer software technique really should acquire this hands down. A excellent technique will provide views and studies with insight into useful resource allocation so that you can watch troubles and do foreseeable future forecasting. That is just not to say that you cannot do this with spreadsheets but it is complicated at most effective and you need to have a very, very excellent setup.

Benefit: Project Management Software program

Last Views

Only you can make a decision the ideal resource for your corporation. Surely working with spreadsheets is improved than working with totally nothing. They do have value, and they may possibly be a excellent healthy for some organizations. Even so, excellent, project management computer software (in particular enterprise-stage) clearly has the benefit for the next kinds of organizations:

  • Companies with additional than a handful of jobs to control
  • Companies with additional than a handful of people today working on or taking care of jobs
  • Companies with massive or advanced jobs

Spreadsheets are principally employed for the reason that of advantage. Even so, advantage is not a fantastic reason to use a resource that supports your essential procedures. Be guaranteed that you pick and use a resource that adds to the performance and productiveness of your people today and procedures, and not the other way about. This will significantly outweigh the benefits of advantage.

Although spreadsheets do have a pair of inherent benefits, this kind of as a all-natural relieve of use and versatility, you can hire most effective techniques to minimize any draw back to project management computer software. For illustration, use templates as a great deal as feasible, simplify screens as a great deal as feasible, doc distinct procedures, aim on those people procedures as a substitute of functions, provide excellent schooling, and make excellent, applicable studies. Combining this with the inherent benefits in project management computer software will enable to make efficiencies, improve productiveness and useful resource utilization, and to turn into additional competitive.


About Editorial Staff

The Editorial Staff are the volunteer members behing the Troubled Projects SIG publication. It is formed by top referent experts globally recognized. The Editorial Staff directs and performs quality control and assurance in all the articles published.