Saturday, April 6, 2013

Do’s and Don’ts: Don’t Use Elapsed Durations with Team Schedules !

There are two types of duration in Project. The Duration field’s values are expressed in working time, so a day is 8 hours by default. This is to accommodate resource assignments and to provide a basis for realistic resource scheduling. The figure below illustrates the idea: One resource working 8 hours per day for 5 days results in 40 hours of effort. (Click on the figure to expand.)

ddt1

Elapsed durations are durations entered with an “e” prefix. For example 2 elapsed days would be entered as “2ed” or “2edays”. An elapsed day is expressed in consecutive calendar time, so 2 elapsed days represents 48 consecutive hours. In the figure below a resource is assigned to a task 5 elapsed days in duration. Notice the amount of work!

ddt 2

It should be obvious that elapsed duration tasks are not designed for human resource assignments. But for intense, machine driven tasks running on a 24 X 7 basis, it is perfect!


If you enjoyed this blog entry, please let me know. If it was informative – then consider training! My training offerings can be found HERE.

I will be presenting a webinar on April 18th entitled “Don’t Do This!” wherein I present 9 common project killing errors I have seen over my years using Microsoft Project.  This blog entry is #7 on my list of mistakes. If you are interested in the webinar, register soon – the seats are going quickly! It’s free! Register HERE.

Sunday, February 24, 2013

Powerful Project 2013 Reporting Tip

If you attended my “What’s New in Project 2013” webinar on February 14th you saw a short preview of Project 2013’s cool new reports. The following tip was presented during the webinar.

Reports in Project now contain charts, tables and user configurable fields. The options seem endless. When used in combination with other Views, the reports become powerful analysis tools.

The figure below is the “Project Overview” report. I have noted for you the near milestones and the completion state of the project’s phases. That’s a great start! But since there is no graphical view of time shown, it is difficult to relate the passage of time between milestones. (Click on the figure to enlarge.)

1

With the report full screen, turn on Project’s Timeline feature so that you can see the relationship of time to the milestones. (See the figure below.) Note that the milestones can now be easily and readily compared.

2

There are many combinations of Reports and Views in MS Project 2013. Explore them! I’m betting you’ll find at least one that makes your job easier.


If you enjoyed this blog entry, please let me know. If it was informative or piqued your interest – then consider training! My training offerings can be found HERE.