Progress Update
- Created
- 11
- 4
I'am a new user for MS Project.
(1) I created the custom column for calculate the weightage based on duration of each activities.
(2) When updating the task, i calculate the % completion based on quantity achieved vs. total quantity. The % complete will then be multiply by the weightage created.
Example:
Activity A = 60 days
Activity B = 30 days
Activity C = 10 days
Total duration = 60+30+10 = 100 days
Weighatge A = 60/100 = 0.6
Weightage B = 30/100 = 0.3
Weightage C = 10/100 = 0.1
Total weightage = 0.6+0.3+0.1 = 1.0
Progress Update;
Activity A = 100m3/200m3 = 50% x weightage = 50% x 0.6 = 0.3
Activity B = 50m / 150m = 33% x weightage = 33% x 0.3 = 0.1
Activity C = 10 nos / 40 nos = 25% x weightage = 25% x 0.1 = 0.025
Total progress = 0.3+0.1+0.025 = 0.425%
I need some opinion and advice whether the process i update the progress correct or not?
Thank you.
11 replies
Oldest firstLog in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?