MS Project Planned Percentage Complete Vs Actual Percentage complete - Updated Improved version

preview_player
Показать описание

Tutorial on how to create a customized field like Baseline planned percent complete in Microsoft Project. Revised version of prior video for better screen quality as per subscribers request.
In MS Project there is no default field available to calculate the Planned % complete or the Baseline % completed. In this tutorial I will explain how to create a customized field to capture planned % complete to compare it against the actual % complete.
In this example I have used the Start date, Duration & Status date for the Planned percentage calculations.

So in MS Project duration is stored in minutes and that's
the reason why we have to copy paste the formula and convert into days so this is the formula to convert the duration which is stored natively in minutes into days so that's all what this step is. So copy from website the step two to calculate the elapsed. So insert new column call it elapsed days and copy/paste the 2nd formula. Just paste it and click OK so here I also got the error that the formula has some issue so click OK and what it does is it's not the error in the syntax but for some reason you just have to retype where the error is highlighted so click on that just retype the same thing "d" and click OK. Apply the formula for summary taks, so what it is doing is it is comparing your baseline date and calculating how many days is already over right so today's November first so it's it's stating that we have completed nine days of the project because it's November 1st and it's gonna end on 2nd so as per the plan dates we already consumed nine days so that's what this column is now we are done with if we are done with the second step right so at any point you can go back and say ok let me calculate the elapsed days as off let's say October 23rd it should be only two days right so you click on the status date and you say it's today's October 23rd you see the elapsed days is going back to two days so that's how it is calculating the elapsed tapes based on the status date so just make sure that you are setting the status they tried to have the calculations correctly now going back to website for the final step which is step number three not the final step so here we are actually calculating the planned percentage complete so again the formula is simple number two divided by number one insert a new column called number three just rename it go to custom fields rename planned percentage okay click the formula radio button click formula and say you can copy paste by the way I'm just gonna type number two divided by number one okay and then apply to summary row okay and now you have the planned percentage complete so it saying it's ninety percent complete the actual percentage may not be ninety but this is what we are calculating right if we would have followed the plan baseline dates what person date should the project be in at certain date now the next and last final step is just to format this into a percentage type of field so it has to be a text so I'm gonna click that again coming back to the web site it said text we are calling it as planned percentage complete and then copy paste the formula copy and then go here and then paste it right click custom fields formula and then paste it okay okay again it's showing me an error so you just have to delete that portion and retype the same thing there's nothing wrong with the formula for some reason it doesn't take any copy paste so just retype it and say use formula for summary rows and click OK and there you have it so once you have this you can always rename it what did we call in here as planned percentage complete just copy that and right click custom fields renamed paste okay okay so this is what we were calculating manually right and the the column that is available in Emma's project is the percentage complete so you go back ...

Related Videos
#ProjectManagement #NiksProjects #HowToBecomeAProjectManager
Рекомендации по теме
Комментарии
Автор

Thanks Nik. It was so helpful. please note that you can summarize all the process in just one single step: Step1: insert field text1, and copy the formula "Format(IIf(Duration>0, IIf(ProjDateDiff(Start, [Status Duration], pjDays)), Val(ProjDurConv([Baseline Duration], pjDays)), IIf(DateDiff("d", [Baseline Start], [Status Date])<=0, 0, ProjDateDiff(Start, [Status Date])/480))/Val(ProjDurConv(Duration, pjDays)), IIf([Current Date]>[Baseline Start], 1, 0)), "0%")" into the field formula placeholder. i this way the error from the milestones is also fixed.

homas
Автор

What a genius you are! In a space of 15mins, you unravelled a whole semester topic just like a piece of cake. I'm impressed!!

bbcc
Автор

Sir! I was doing a separate project file just to calculate this. You're help is truly appreciated.

cesarmades
Автор

This video was PERFECTION. Exactly what I needed, very clear, straight to the point, easy to follow. You got my subscription for this one! My question is how to convert the percentage in days

Ajip-vsdp
Автор

Perfect video. Been trying to write something similar myself for ages and never quite got it working, so this has really helped me out a lot!!!! THANK YOU.

DP-xzxr
Автор

This is exactly what I am ought to do and has been giving me a headache til today. I'm gonna try this! Thank you!!!

ma.ruthamores
Автор

Thanks a lot for your help. this was the only place I could find the answer for my question.

AlarSouth
Автор

Excellent video! It was so instructive! All my questions were solved! I encourage you to show more your videos!!! It was really hard to find you!

geckocolado
Автор

This was very informative! Great work! Definitely in-depth and straight forward.

Entheogeneticz
Автор

Your explanation and formulas were so useful ! Thanks!

yelvalycastillo
Автор

thank you so much nik..i had that error and somehow couldnt figure out what is the problem..good to learn in from this video..god bless..

familyacc
Автор

This video was PERFECTION. Exactly what I needed, very clear, straight to the point, easy to follow. You got my subscription for this one! I am sold.

CoralCobra
Автор

Very useful, thanks for putting this together. As far as the error, I can't tell you exactly why, but the quotes in "d" are not being copied the font that Project expects, so it considers it a foreign language.

davidmboko
Автор

Very good informative video. 15 mins well spent..

raajkumard
Автор

Thank you so much Sir Niks for your shared knowledge. Really appreciate and helping me lots. Again, thank you so much.

meisaano
Автор

Hi Nik, Its really helpful. I want to know that every time when i have to update the progress, will i repeat the same procedure everytime???

talhamunir
Автор

That was EMAZING! what will happen if we changed the baseline? Will it take the last one?

ahmadsalem
Автор

Hi Niks,
Thanks for a great video, It is very helpfull.
I just wonder that for example: Actual % complete is 70% and Planned % complete is 60% then we assess the schedule is ahead?
If there are some critical tasks in this case were delayed? and free slack and total slack will not impact on total schedule of project.
Could you please advise in this case?
Thanks a lot.

phamnam
Автор

Excellent video!!! Exactly what I was looking for!!!

rafaelroberto
Автор

Great video...Your video is very practical which is useful for practical applications...I am wondering that how you made the formulas..From India

civilengineering-malayalam