Great Tom. Could you pls clarify the meaning of %complete? It has to do purely with time (e.g. days compared to baselined duration of activity) or means the accomplished earned value of works (money)until the status date? And what is the meaning of %physical completion column?(shown empty in 13:00 next to % compl.)Thanks for your patience!
Hi Mark, percent completion is based on duration eg 60 percent complete of a twenty day activity is 12 days. Physical percent complete looks at what is installed or done 300 blocks of a thousand blocks is 30 percent physical completed even if it is day 6 of 10 days
Thanks, Tom. A question, though... when selecting the earned Value view... I see columns such as Earned Value and Actual Cost generated, but yet, Planned value/BCWS still appears zeros. Any help with this would be greatly appreciated. Thanks again
Hello Dear Tom. recourse on a summary task (PM) is not worked when you tracking the project. I assigned PM on a Summary Task but it is not calculated and still shows in variance column
Hi IG, It should show on the variance but will also include any variances on anything below the summary task. If you want to see the variance on onlt the PM go to the resource sheet and right click on the square icon box in the resource sheet select cost and it will show the variance of each individual resource
Hi Tom, at 12.00 minute mark approx. you talk to manually updating the Duration field in the Tracking Gantt view. Is updating the Duration field, the same as updating the Actual duration field, or should I only use duration field? In my testing if I update Actual Duration field it also updates Duration field, but when I update Duration field it did not update Actual Duration field. Thank you.
It really is a preference thing, i often like to adjust and review before i mark as complete. Also if it crosses the status date i mark on track after extending the duration. Nothing wrong with using actual duration at other times
Hi Tom, thanks a lot for the great tutorials I find them very rich and very helpful. I have a question, I see on your Resource Cost Sheet, ABC Plumbing is showing $0 actual cost but it has been assigned to Rough in Plumbing on item 10, does the actual cost for a cost resource update automatically or you do it differently? Many thanks.
Hi Calvin, It should update when you put it as complete in the tracking Gantt unless you change the cost then the new cost will show. I always say to studenrts true it with a few activities and experiment and see how it behaves eg update check then undo change cost update and check …. Make sure you check in the cost, tracking and resource cost screens. Have a great day!
Hi Tom Can you help, I have been working on my schedule for quite a while now prior to the commencement of the Job it is a full house renovation I had only managed to assign 2/3rds of the resources prior to setting the base line last week, the schedule hasn’t been updated yet after over a week of progress on site, I had continued to assign more resources to the schedule over the weekend ,but have noticed that there is considerable sum of money showing in the variance column ‘ I am assuming that this is a consequence of me adding more resources after setting of the base line ‘ My question is should I set a new base line after I have finished the the full assignment of all the recourses
Hi Paul, you can clear the baseline under the project tab go toset baseline and then select clear baseline now reset the baseline and it includes all the changes resource costs that you made. Then you can update it. Always save a backup file that you can go back to.
Great explanation! Thanks for sharing your knowledge with us.
Excellent video!
Thanks Sanjay very appreciated!
The best Ms Project tuto ever!
Excellent, I’m glad it helped you!
you tutorials are so helpful that i cant express in words sir.
Thanks Manem, I'm glad they are helping you. Have a great day!
Great Tom. Could you pls clarify the meaning of %complete? It has to do purely with time (e.g. days compared to baselined duration of activity) or means the accomplished earned value of works (money)until the status date? And what is the meaning of %physical completion column?(shown empty in 13:00 next to % compl.)Thanks for your patience!
Hi Mark, percent completion is based on duration eg 60 percent complete of a twenty day activity is 12 days. Physical percent complete looks at what is installed or done 300 blocks of a thousand blocks is 30 percent physical completed even if it is day 6 of 10 days
Great explanation sir, really helpful. Thank you. Also wanted to ask that, mark on track only works for status date?
Thanks Ammad yes it updates only to what you put as the status, which you can change as needed
Thanks, Tom. A question, though... when selecting the earned Value view... I see columns such as Earned Value and Actual Cost generated, but yet, Planned value/BCWS still appears zeros. Any help with this would be greatly appreciated. Thanks again
Hi Milner, are your resources that you are monitoring listed as work with an hourly rate?
Hey Tom. No, I had them set for cost resources.
Hello Dear Tom. recourse on a summary task (PM) is not worked when you tracking the project. I assigned PM on a Summary Task but it is not calculated and still shows in variance column
Hi IG,
It should show on the variance but will also include any variances on anything below the summary task. If you want to see the variance on onlt the PM go to the resource sheet and right click on the square icon box in the resource sheet select cost and it will show the variance of each individual resource
@@TomStephensontraining thank you
Hi Tom, at 12.00 minute mark approx. you talk to manually updating the Duration field in the Tracking Gantt view. Is updating the Duration field, the same as updating the Actual duration field, or should I only use duration field? In my testing if I update Actual Duration field it also updates Duration field, but when I update Duration field it did not update Actual Duration field. Thank you.
It really is a preference thing, i often like to adjust and review before i mark as complete. Also if it crosses the status date i mark on track after extending the duration. Nothing wrong with using actual duration at other times
Hi Tom, thanks a lot for the great tutorials I find them very rich and very helpful. I have a question, I see on your Resource Cost Sheet, ABC Plumbing is showing $0 actual cost but it has been assigned to Rough in Plumbing on item 10, does the actual cost for a cost resource update automatically or you do it differently? Many thanks.
Hi Calvin, It should update when you put it as complete in the tracking Gantt unless you change the cost then the new cost will show. I always say to studenrts true it with a few activities and experiment and see how it behaves eg update check then undo change cost update and check …. Make sure you check in the cost, tracking and resource cost screens. Have a great day!
Hi Tom
Can you help, I have been working on my schedule for quite a while now prior to the commencement of the Job it is a full house renovation
I had only managed to assign 2/3rds of the resources prior to setting the base line last week, the schedule hasn’t been updated yet after over a week of progress on site, I had continued to assign more resources to the schedule over the weekend ,but have noticed that there is considerable sum
of money showing in the variance column ‘ I am assuming that this is a consequence of me adding more resources after setting of the base line ‘
My question is should I set a new base line after I have finished the the full assignment of all the recourses
Hi Paul, you can clear the baseline under the project tab go toset baseline and then select clear baseline now reset the baseline and it includes all the changes resource costs that you made. Then you can update it. Always save a backup file that you can go back to.
@@TomStephensontraining
Thanks again Tom that has worked a treat
What about updating a plan with LOE activities please
I have one under my ms project playlist for hammock activities same thing. I plan to do another one though