Sunday, December 13, 2009

Project Management Tool – Spreadsheet

Don’t get surprised, even a simple spreadsheet can become very effective project management tool, due to it’s extensive computational set.

One can easily put up a plan for a 2-3 weeks project in the spreadsheet, if the project is not that complex, if there are not many dependencies and is to be executed with only a couple of resources. Those who are not so familiar with MS Project like tool can use excel to their benefit and achieve the project management goals.

A simple table like this could also be useful:

Task Name Resource Name Estimated effort Start Date End Date Status

End Date column can have a formula to calculate the end date automatically base on the effort column. And if you are really keen on using the spreadsheet only, you can append the above column list with other columns like “actual effort”, “actual start date”, “actual end date” and then put your skill to develop formulae to extract tonnes of information from this table.

I personally never to planning in excel as I find this very primitive. And most of the times I have access to MS Project, which does all the above mentioned things and loads of more like a breeze.

2 comments:

  1. How to make money from a casino (and make money from
    When it comes to betting on sports, this is the top 온카지노 choice. The game 바카라 has หาเงินออนไลน์ its potential to be a big hit.

    ReplyDelete
  2. At casinos licensed 우리카지노 by the Pennsylvania Gaming Control Board, have the ability to|you probably can} deposit through a range of banking options corresponding to card, e-wallet or financial institution switch. WynnBET is known for its in style Las Vegas Wynn Resorts properties. The operator lives as much as} its name with the vary of obtainable games. Luckily, operators were quick to take discover and rectify. Bonuses have been lowered, requirements are greater, and extra restrictions have been put in place.

    ReplyDelete