Monday, March 22, 2010

Tracking Multiple Estimates with Project

MS Project is a powerful tool. However, it has certain expectations about tasks, and deviating from them can be difficult. For instance, Project presumes tasks have a single work amount and duration.

I prefer multiple estimates. I typically ask developers for a realistic and a pessimistic estimate (i.e., "should be done by, could take as long as"). Then, I also track a weighted estimate somewhere between these, based on my confidence in the given estimates. Finally, I want a projected duration based on how long the work has taken so far (e.g., if a task is half done in a week, the projection should be two weeks).

Since Project expects only one work/duration value, tracking progress and making predictions against multiple estimates is hard. You can create extra columns for them, but these don't integrate well with many features, such as Gantt charts. And, as far as I can tell, the projected duration isn't a built-in option.

To work around these issues, I created a Project 2010 template that lets me track work items with multiple estimates. The key advantages are:

  • Easy pessimistic/optimistic/etc estimates, Gantt charts, and end dates.
  • Projected estimate based on how long tasks have taken so far.
  • Simple steps to track progress, whether reported as percent done or time left.

Here are links to the template and to instructions. I think it's fairly easy to use, but I'm very interested in any feedback. If you give it a try, let me know!


Edit: A commenter requested a Project 2007 version of the template, so I've put one here. However, not having actually used it myself in Project 2007, I can't guarantee how well it'll work.

7 comments:

Prasant said...

Hi,
You definitely should read some good books on estimation. What you described in a variant of delphi wideband estimation(AFAIK). You should do this and something like function point counting and ideally put some metrics in place so you have target to shoot at..

Regards,
PC

Prasant said...

Hi,
Can you post a 2007 compatible template so the rest of us poor folks who don't have 2010 can use what you've made..

PC

Pedro DeRose said...

Hi, Prasant.

Thanks for the pointers. I've added a link to a Project 2007 version above. Good luck!

Cheers,
Pedro

Prasant said...

Pedro,
Can you save it as type 2000-2003 type file and post it. The 2007 file you posted does not open in version 2007.

Kalle said...

Is the template and the instructions still available? Skydrive says they aren't there :-(

ayshwariya said...


Hey, nice site you have here! Keep up the excellent work!

ISO Consulting

Helmut Dempewolf said...


Hi there! This is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a extraordinary job! gmail.com login