Hi everybody, I have a question about MS Project.
I have a task that starts on 16.04.2014 and finishes on 26.06.2014.
Start: 16.04.2014
Finish: 26.06.2014
Progress Data’s:
Actual start: 29.04.2014
Status Date: 29.06.2014
Completion: %60 (Actual Start till Status Date)
So in my opinion, I did %60 in 60 days, so I should work for 40 more days to complete task. The finish date should automatically change to “29.06.2014+40 days”. There should be only one bar in gantt chart that shows completed task between actual-status date and not-completed task for 40 days.
I tried all update tasks procedures but I couldn’t manage.
I just want to make this calculation automatically in MS Project.
What should I do? What are your recommendations?
All datas for the project including holidays ,non-working days that Premavera Software can genarate actual remaining days.It's fun if you try to learn the behavior how will it really help your needs.
Sir i am also using MS Project but after i took premavera course it's find more easier than MS Course.Thanks
The task was planned/scheduled to start on Wednesday 16/04/2014 08:00 and finish on Thursday 26/06/2014 17:00.
That is 52 working days of duration, Saturday and Sunday are nonworking days.
Status Date is Sunday 29/06/2014 17:00, which is later than the scheduled finish date of the task.
But the actual start date is 29/06/2014.
So 29/06/2014 + 52 working days = Wednesday 9/7/2014 17:00, which is later than the status date.
If the task has been continuously in progress since the actual start up to the status date then the actual duration is 44 days and the remaining duration is 8 days, so your task is 44/52 = 85% Complete. % Complete in MSP is actual duration/total duration and total duration = Actual + remaining.
Now you say that the progress of the task itself is "60%". For example you have laid 6000 bricks out of 10000 bricks.
You need your actual duration to be 60% of your total duration, which means that you must re-estimate the remaining duration. If 44 days = 60%, then 100% = (1/0.6) x 44 = 73.33333 days. Let's round that up to 74 days, so the remaining duartion must be 74 - 44 = 30 days. The scheduled finish date should now be Friday 8/8/2014 17:00.
Microsoft Project cannot automatically perform the calculation for the remaining durrtion because it needs your input because that depends on your estimate. This is just the same as when you first estimated the duration to be 52 days. Unless you tell it, how can the software know that you have laid 6000 bricks out of 10000?