i will explain duration % complete in this article. other fields and settings will be explained in future articles and we will finally have a complete picture of the whole actual progressing system in primavera p6.<\/p>\n
primavera p6’s 3 types of activity percent complete<\/h2>\n
each activity has three percent complete fields that are calculated all the time:<\/p>\n
- \n
- duration % complete<\/li>\n
- units % complete<\/li>\n
- physical % complete<\/li>\n<\/ol>\n
only one of these values will be selected by the user as the activity\u2019s progress, even though all of them are calculated all the time. i will explain how to choose the appropriate activity percent complete in future articles.<\/p>\n
duration % complete calculations<\/h2>\n
the most common problem with duration % complete is that primavera p6 uses a counterintuitive formula. you may expect it to be something like microsoft project\u2019s formula:<\/p>\n
\n
duration % complete(ms project) = [actual duration] \/ ( [actual duration] + [remaining duration] )<\/p>\n<\/blockquote>\n
but this is not the p6 formula. duration % complete is calculated with this formula:<\/p>\n
\n
duration % complete(p6) = ( [original duration] \u2013 [remaining duration] ) \/ [original duration]<\/p>\n<\/blockquote>\n
this formula uses original duration, which may be different from the current duration. we will check this on the following sample.<\/p>\n
sample: we have an activity with original duration of 20 days. 15 days have passed and we estimate it to finish in 18 days (yes, it\u2019s much longer than we expected initially). \u00a0the original duration does not change automatically after activity\u2019s start.<\/p>\n
original duration: 20d<\/strong>
\nactual duration: 15d<\/strong>
\nremaining duration: 18d<\/strong><\/p>\n[duration % complete] = (20-18)\/20 = 10%<\/strong><\/p>\n
intuitive or msp-like duration % complete = 15\/(15+18) = 45.45%<\/strong><\/p>\n
the following figure shows the initial state of this sample activity (named a1):<\/p>\n
![\"learn](\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/05\/01.jpg\" "\\"learn")
<\/p>\nlet\u2019s say that the activity has started in may 8th<\/strong>. we\u2019ll check the started checkbox and enter the actual start date in its date box.<\/p>\n
![\"learn](\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/05\/02.jpg\" "\\"learn")
learn primavera p6 duration percent complete<\/figcaption><\/figure>\n suppose that it\u2019s currently may 27th<\/strong>; we will reschedule the plan for this data date.<\/p>\n
![\"learn](\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/05\/03.jpg\" "\\"learn")
\nthe actual duration is automatically calculated based on actual start date and the data date, as follows:<\/p>\n\n
[actual duration] = [data date] \u2013 [actual start] (p6 formula for in-progress activities)<\/p>\n<\/blockquote>\n
unfortunately, you cannot change the actual duration field manually.<\/p>\n
now we can enter the remaining duration. in this example, we estimate that a1 requires 18 more days to be completed. \u00a0we\u2019ll enter 18d<\/strong> in remaining duration field. \u00a0by entering a remaining duration, duration % complete will be calculated automatically.<\/p>\n
![\"learn](\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/05\/04.jpg\" "\\"learn")
\nin this case, duration % complete<\/strong> is calculated as 10%<\/strong>.<\/p>\nwe could have entered the duration % complete instead of the remaining duration and p6 would have calculated remaining duration\u00a0automatically .
\nnow, take a look at the gantt chart.<\/p>\n![\"learn](\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/05\/05.jpg\" "\\"learn")
<\/p>\nwhen you look at the gantt chart, you see that about half of the current duration is actualized and you may expect a duration % complete of around 50%. the exact number of the intuitive formula is 45.45%<\/strong> in this example, which is not equal to our duration % complete.<\/p>\n
changing the original duration<\/h2>\n
primavera p6 uses the following equation for original duration is used when an activity is not yet started:<\/p>\n
\n
[original duration] = [early finish] \u2013 [early start]<\/p>\n<\/blockquote>\n
however, after the activity has started, original duration will not be automatically calculated by early start and early finish, and you can change it manually. \u00a0the at completion duration<\/strong> represents our current duration, calculated as:<\/p>\n
\n
[at completion duration] = [actual duration] + [remaining duration]<\/p>\n<\/blockquote>\n
in our example, the at completion duration<\/strong> is calculated to be 33d<\/strong>. \u00a0we will enter the same value for the original duration field and this would be the result:<\/p>\n
![\"learn](\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/05\/06.jpg\" "\\"learn")
<\/p>\nthe activity\u2019s schedule is not changed, but duration % complete is recalculated based on the new original duration; and yes, it\u2019s the intuitive value that we calculated before.
\nwhen original duration is equal to the at completion duration, the duration % complete will have the intuitive value. the following equations show how the p6 formula would become the intuitive formula, when the original duration is equal to the at completion duration:<\/p>\n\n
[duration % complete]* = ( [original duration] \u2013 [remaining duration] ) \/ [original duration]<\/p>\n
= ( [at completion duration] \u2013 [remaining duration] ) \/ [at completion duration]<\/p>\n
= [actual duration] \/ ( [actual duration] + [remaining duration] )
\n* this equation is based on the assumption that original duration is equal to the at completion duration.<\/p>\n<\/blockquote>\nif you would like to have the intuitive duration % complete (for any reason), you can create a global change to set the original durations of in-progress activities. the following figure shows the appropriate global change setup.<\/p>\n
![\"learn](\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2012\/05\/07.jpg\" "\\"learn")
<\/p>\nthis global change checks each activity\u2019s status; if it\u2019s \u201cin progress\u201d, then the at completion duration would be copied to the original duration. \u00a0we will then have the intuitive duration % completes for all activities.<\/p>\n
duration % complete for wbs elements<\/h2>\n
the previous explanation was focused on duration % complete for activities<\/em>. \u00a0duration % complete is also calculated for wbs elements, but i strongly recommend you not to use duration % complete to track a wbs element\u2019s progress. \u00a0thus i have not included an explanation of the calculations here.<\/p>\n
you should always think of duration % complete as an intermediate field and use performance % complete<\/strong> to track activities and wbs element\u2019s actual progresses.<\/p>\n
i will explain the calculation and usage of performance % complete in a future tutorial.<\/p>\n
summary<\/h2>\n
this tutorial has demonstrated the internal calculations of primavera p6’s duration percent complete field.<\/p>\n
the most common problem in this area is that primavera p6 does not use the intuitive formula for duration % complete which confuses some planners and project managers. we explained the primavera p6 calculations and the intuitive formula side by side, to show the differences and create a better understanding of the p6 method. finally, if you absolutely need to use the intuitive formula, try the global change described above.<\/p>\n
remember, duration % complete does not provide a final result; it is used in a system which provides the actual progress. you should use performance % complete to read the actual progresses. \u00a0we’ll cover that in an upcoming tutorial soon.<\/p>\n
![\"new](\"https:\/\/no-cache.hubspot.com\/cta\/default\/297539\/3aeba69a-3395-4c7d-bcf9-21c89d3da072.png\")
<\/a><\/span>