Forum Discussion
How Do I update Project Tasks To Reflect Actual Duration But Not Change % Complete or Actual Work
How do I update the tasks of a project to reflect actual duration (time that has passed since the task started) based on the status date, but where work on the task has not progressed from the previo...
John-project Well, I sort of solved for my issue. I was able to create a custom field that calculates Elapsed Duration between the actual start date and the status date using the ProjDateDiff fuction. So, the built in Actual Duration field would reflect the duration based on actual work. Now I'm trying to figure out if there is a way I can measure and evaluate what the % Work Complete should be at a given status date versus the % of Actual Work Complete. I know project has automatic filters built in where I can review slipping/late tasks which should display all tasks that are at risk of not meeting their baseline finish. I guess this could work but I'd still like to see the Planned % Work Complete with the % Work Complete values.
John,
Have you considered just using the earned value metrics already available in Project?
If the task work is linearly spread across the task duration, then the planned % work complete at any point in time is the work divided by the actual duration as of that point in time expressed as a percentage. However, task work isn't always linearly spread (e.g. contoured work loading or multiple resources working different times). In that case, you could use the Cumulative Actual Work and Cumulative Work, both available as timescaled data in either Usage view. Those are not accessible with custom field formulas but they are with VBA.
John
Have you considered just using the earned value metrics already available in Project?
If the task work is linearly spread across the task duration, then the planned % work complete at any point in time is the work divided by the actual duration as of that point in time expressed as a percentage. However, task work isn't always linearly spread (e.g. contoured work loading or multiple resources working different times). In that case, you could use the Cumulative Actual Work and Cumulative Work, both available as timescaled data in either Usage view. Those are not accessible with custom field formulas but they are with VBA.
John
- I do use earned value like SPI AND CPI. Even though we do agile with Jira and EVM isn’t really used in monitoring agile project performance. So I end up using Project and JIRA. The metrics generated from both products are beneficial.