Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

MS PROJECT UPDATING TASKS

3 replies [Last post]
Fri, 2014-07-04 14:33
Hal Kos
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 4 Jul 2014
Posts: 5
Groups: None

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?

Top

Replies

Sat, 2014-09-06 14:16
#1
jeffrey villanocha
User offline. Last seen 9 years 41 weeks ago. Offline
Joined: 21 Aug 2014
Posts: 3
Groups: None

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.

Top
Fri, 2014-08-29 04:39
#2
jeffrey villanocha
User offline. Last seen 9 years 41 weeks ago. Offline
Joined: 21 Aug 2014
Posts: 3
Groups: None

Sir i am also using MS Project but after i took premavera course it's find more easier than MS Course.Thanks

Top
Mon, 2014-07-07 02:53
#3
Trevor Rabey
User offline. Last seen 1 year 34 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None

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?

Top