
Jul 03, 2015
One of the hardest aspects of working with Microsoft Project is being able to understand the relationship between the three main units of measurement.
Correctly understanding these three units of measurement and how they interact with the types of tasks that exist is key to ensuring your scheduling works for you instead of you working for it.
In this post, we will identify the information we need to understand in order for our scheduling to be successful.
Duration, Work and Units
- Duration = Work / Units (D = W/U)
- Work = Units * Duration (W=D*U)
- Units = Work / Duration (U=D/W)
Units represent the time spent on an activity. For example, if one person commits to spending all their time on a task and another person commits to half their time, the units for both would be 150% (or 1.5). As another example, if you had 12 tradesman allocated to a task, the units would be 1200% (or 12). Here are some variations on entry of duration, work and units.

Task Type Behaviour

The above table assumes effort driven is not selected.
With effort driven selected, the Project behaves differently when calculating. Rather than recalculating work, it assumes the work will remain the same throughout. This means that for the most part, 2 parts of the scheduling formula (W = D * U) will remain the same. So with Effort Driven selected the following occurs:

So to summarise the changes:

Hopefully, you now have a better understanding of the relationship between the units and types of tasks. Happy scheduling!
How do your Excel skills stack up?
Test NowNext up:
- Planning and configuring Enterprise Content Management in SharePoint 2013
- Display the message “Tasks due shortly” in Project
- Autofill to the Last Row Using VBA
- Staff Retention
- Using conditional formatting to highlight weekend dates in Excel
- Implementing live tiles in a Windows Store App
- Selecting Text in Microsoft Word
- Creating a storage account and container in Windows Azure
- What Sort of Leader are You?
- Recording Screen Action in PowerPoint 2013
Previously
- Planning and configuring Enterprise Content Management in SharePoint 2013
- Skype for Business – The missing “Lync”
- Ineffective goals
- Poodle or terrier – are your systems safe?
- Present a PowerPoint 2013 presentation online
- Code sharing strategies in Windows Universal Apps
- Reuse slides in PowerPoint
- The System Prism
- SharePoint permissions on views using workflows
- Archiving old emails in Outlook