MS Project: Task Type and Effort Driven Scheduling

When assigning multiple work resources to a task, Microsoft Project performs a calculation to effectively schedule tasks and assign resources. This reaction to multiple work resource assignment can catch users by surprise and create confusion.

Work, Duration and Units

The calculation Project performs when multiple resources are assigned to a task depends on the Effort Driven Scheduling and Task Type settings. By default, effort driven scheduling is turned on and the task type is fixed units.

The calculation Project performs is;

Work = Duration * Units

This means that for a task taking 2 days with 1 work resource doing an 8 hour day the calculation is;

16 hours = 2 days * 8 hours

If another resource is assigned at a later time, project will recalculate this. Effort driven scheduling means that the work does not change. And the fixed units task type means that units will not change either. Meaning that the only option left for the formula to continue to work is for duration to decrease.

16 hours = 1 day * 16 hours (2 x 8 hours)

To stop this from happening you can change the task type to fixed duration so that the units decrease instead of the duration (each individual works 50% or 4 hours). Or remove the effort driven scheduling so that the work increases (32 hours for the example above).

Change the Task Type and Effort Driven Scheduling Option

For a Single Task

To change the task type or disable effort driven scheduling for a single task in the project;

  1. From the Gantt Chart, double click on the task name of the task you want to change.
  2. Click the Advanced tab of the Task Information dialog box.
  3. Uncheck the Effort Driven Scheduling box to disable effort driven scheduling, or click the Task Type list arrow and select another type such as Fixed Duration.

Task Information dialog box
Task Information dialog box

Set the Default for all Project Tasks

It may be a better idea to change the default settings for all the tasks in the project. This can be done before entering any tasks into the project. It will not affect any existing tasks, they will need to be changed using the previous method.

  1. Click the File tab on the Ribbon.
  2. Click the Scheduling category from the left.
  3. Uncheck the All tasks are effort driven box to disable effort driven scheduling, or click the Default task type list arrow and select another task type such as Fixed Duration.

Task type and effort driven scheduling settings for the entire project
Task type and effort driven scheduling settings for the entire project

More by this Author

  • Create an Interactive Excel Chart using Option Buttons
    6

    Form controls can be added to an Excel spreadsheet to create interactivity with the user. This article looks at using option button controls to allow a user to choose the data they want to see on a chart. The first...

  • Simulate a Cup Draw using Excel
    0

    Microsoft Excel can do some amazing things. I like to attempt little projects testing what Excel can do. I was asked the other day to simulate a cup draw using Excel and this is the result. This article will give you...

  • Brock Lesnar Nutrition and Workouts
    2

    Brock Lesnar is a phenomenon of a man and an athlete. Brock Lesnar weighs a lean 265 lbs and yet possesses extreme speed, agility and athleticism. How a man carrying so much muscle mass can maintain such high levels of...


Comments

No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working