MS Project Planned Percentage Complete Vs Actual Percentage complete

  Рет қаралды 142,356

Niks Projects

Niks Projects

10 жыл бұрын

My Project Management Master Class: www.niksprojectsacademy.com/
Related Videos
• How to get your CSM (S...
• What is Agile? Agile E...
#ProjectManagement #NiksProjects #HowToBecomeAProjectManager
Tutorial on how to create a customized field like Baseline planned percent complete in Microsoft Project.
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. If you want to base your calculations based on the baselined version of the project then please change the Start to [Baseline Start] and Duration to [Baseline Duration].
All the formulas and details on how to create the baseline or planned % complete is available in my blog www.niksprojects.com/blog under Project Management tab.
Main Camera - amzn.to/2uURXO7
Second Camera - amzn.to/2OoqKKK
Overhead Camera - amzn.to/3b4wwuz
Vlog Camera - amzn.to/2GKT4CJ
Action Camera - amzn.to/31iZIJL
Main Microphone - amzn.to/2RRJsg0
Lav Microphone - amzn.to/2Sg4uE1
Vlog Microphone - amzn.to/37RRj2l
Overhead Cam Microphone - amzn.to/2vMUPNH
Uhuru Premium USB Mic - amzn.to/2Gkk9wq
Audio Devices
Audio Mixer - amzn.to/3910oWT
Audio Interface - amzn.to/36O1sff
Audio PreAmp Device - amzn.to/2Sb8sh8
Audio Recorder - amzn.to/2GOmgst
Sound Recorder - amzn.to/2tnyLbv
Main Light - amzn.to/2UkVShO
Dome for Soft light - amzn.to/2RORCWd

Пікірлер: 170
@niksprojects
@niksprojects 2 жыл бұрын
Also check out and pre-order my Project Management Master Class for a 75% discount for Pre-Orders at www.nikscourses.com
@sagorikamazumdar6023
@sagorikamazumdar6023 9 жыл бұрын
Thanks Nick, this is an amazing solution to check where we are today against planned. It worked for me !!
@niksprojects
@niksprojects 10 жыл бұрын
Thanks Jacobus and Michelle. Glad it helped.
@steynify
@steynify 10 жыл бұрын
Thanks. Worked first time and saves me a lot of manual time
@niksprojects
@niksprojects 10 жыл бұрын
Glad I can help.
@yanivganor5747
@yanivganor5747 9 жыл бұрын
Very Nice, really useful for tracking to the project progress
@spyderspyderz
@spyderspyderz 10 жыл бұрын
thanks a lot Niks. You saved my days!
@niksprojects
@niksprojects 5 жыл бұрын
Hi Nizz , I am planning to create a MS project course online. Do you mind if I can use your above comment as a testimony in the website so that users who want to checkout the course has some testimony.
@fcamargo84
@fcamargo84 10 жыл бұрын
Thank you Niks!! Very useful tutorial. I liked so much... :)
@niksprojects
@niksprojects 10 жыл бұрын
Glad I can help.
@niksprojects
@niksprojects 5 жыл бұрын
Hi Fabricio , I am planning to create a MS project course online. Do you mind if I can use your above comment as a testimony in the website so that users who want to checkout the course has some testimony.
@nyankimmie
@nyankimmie 9 жыл бұрын
hi, Can you tell me what does MS project base its planned value for the earned value over time report?
@sandeepparekh3912
@sandeepparekh3912 8 жыл бұрын
hi Niks, It is very useful but i would like to ask you this planned percentage is automatically update by MSP ?, If i will update project after one month the again i have to do this exercise ?, if my project is big and i used all number column our column is few so in this case how we make new column ?
@mikemorris1404
@mikemorris1404 9 жыл бұрын
Hi Nick, Your formula was very helpful with my reporting
@niksprojects
@niksprojects 9 жыл бұрын
Mike Morris Glad it helped.
@tanerulusu5857
@tanerulusu5857 9 жыл бұрын
Thanks for your sharing...
@sanjaymukherjee7622
@sanjaymukherjee7622 8 жыл бұрын
Hi Nikhil, In full view as well - its not readable somehow, perhaps problem on my system. But am able to see clearly other tutorials Regards
@olimpiuandrone7173
@olimpiuandrone7173 10 жыл бұрын
Thanks for sharing :) this trick amazed my teacher!
@niksprojects
@niksprojects 10 жыл бұрын
No problem, it was a learning experience for me as well.
@proyekelyon4436
@proyekelyon4436 5 жыл бұрын
thanks, it works. but how to get all planned summaries like top column of %Column?
@AhmedOHafiz
@AhmedOHafiz 3 жыл бұрын
Hello Nik and thanks for the video, the formula you shared for % planned complete is working well for me, my issue now is that even when i match the % complete to that of the % planned complete for the sub tasks, my overall performance for the task is lagging. is it the right thing to do to compare % complete (manually entered and calculated via (Actual Duration/Duration)*100 Vs % planned complete that is calculated via (Elapsed Duration/Duration)*100
@nehapalan4450
@nehapalan4450 6 жыл бұрын
this works perfectly fine at task level. i do have a big project where i have multiple task summary. This is where the calculation does not match. How do i get the Planned % complete similar to actual % complete for task summary (the task which has multiple indented task)
@sukeerthreddy564
@sukeerthreddy564 10 жыл бұрын
Hi.. The formula for elapsed days in step 2 takes even the weekends into consideration. To exclude weekends and include only the number of working days, you can work around the formula this way below: IIf(DateDiff("d",Start,[Status Date])>=Val(ProjDurConv(Duration,pjDays)),Val(ProjDurConv(Duration,pjDays)),IIf(DateDiff("d",Start,[Status Date])
@mohamedabdelaziz4489
@mohamedabdelaziz4489 9 жыл бұрын
i used your formula but i didn't work can you please explain to me from where u got the no 480 please
@a14266
@a14266 9 жыл бұрын
MOHAMED ABDELAZIZ 480 = minutes in one day ( 8 hrs working x 60 min)
@mohamedabdelaziz4489
@mohamedabdelaziz4489 9 жыл бұрын
a14266 Ok thanks but what should I do to make the formula consider only one off day since my project runs 6 days a week 8 hours per day ... Thanks again for your reply I appreciated
@tbsbidayuh
@tbsbidayuh 6 жыл бұрын
Thank you!!
@TheNorhalim
@TheNorhalim 6 жыл бұрын
thank youuuuuu
@drsheikh
@drsheikh 9 жыл бұрын
Hey Nick, your channel and intention is greatly appreciated. However it would help if we had a zoomed in version of your screen as it is extremely difficult to read whats on your screen. Next it would help if you actually narrate what you are clicking on. Like for example at 3:05 you say "..I have to go here and.." It becomes difficult to follow. Good intentions though.
@s.r.h.9741
@s.r.h.9741 2 жыл бұрын
Thank you for this article
@niksprojects
@niksprojects 2 жыл бұрын
you are welcome!
@terjevelde5914
@terjevelde5914 10 жыл бұрын
Hi Niks! Have experienced problems when applying Planned % Complete to Milstone tasks.Get "Error".Any good explanation?
@1987Petar
@1987Petar 8 жыл бұрын
For me, much easier is to enter a new Number column (named, lets say, Planned Completion) with formula IIf([Status Date]>[Baseline Finish];1;IIf([Baseline Start]>[Status Date];0;([Status Date] - [Baseline Start])/([Baseline Finish] - [Baseline Start]))) and after that add Text column as Nick described, to turn numbers in %. In this was solving problem with the Milestones and also with updating Project.
@betha4599
@betha4599 8 жыл бұрын
+1987Petar This formula produced an error wherever there was a semicolon. Any ideas?
@1987Petar
@1987Petar 8 жыл бұрын
+Beth A You should set a Baseline first.
@jenimiswaludin3021
@jenimiswaludin3021 8 жыл бұрын
Petar can I get your email for sharing??
@1987Petar
@1987Petar 8 жыл бұрын
Just post your e-mail address here, and I will contact you
@nidzamnoori1927
@nidzamnoori1927 7 жыл бұрын
im getting an error message at ......;1;........ tried re type but unsuccessfull... btw im using msproject 2013
@remmy5070
@remmy5070 6 жыл бұрын
Thanks Nik for this formula... I made some experiments to my project, i found out few things. Refer below: 1. IF The actual finish date is earlier than the BL finish date: The plan % Complete for that activity will change to >100% for the activity. (I set the % Complete = 100%). 2. IF The actual finish date is later than the BL finish date: The plan % Complete for that activity will change to
@kingfisheraja
@kingfisheraja 8 жыл бұрын
This formula looks great. However it gives me error when i set up my status date day after the project started. Due to this my planned percent is error as well. How do i fix this? My project started few weeks back. Thanks
@ernesthemingway667
@ernesthemingway667 10 жыл бұрын
I have tried the formulas as stated, and I still have an issue. Duration in Days is equal to the Elapsed Days, even for tasks that are not completed and are past the status date. If I use the Project>Status tab>Update project button I get the correct values. I would like to created the same functionality all my projects in project server 2013.
@wisdomattah8658
@wisdomattah8658 6 жыл бұрын
Hello Please, how do I write a formula to determine the AVERAGE of the Physical % Complete?
@nitinadate2174
@nitinadate2174 7 жыл бұрын
hi Niks, It is very useful i am just looking for that.....
@niksprojects
@niksprojects 7 жыл бұрын
Glad it helped. Thanks for watching and subscribe if you haven't yet to get notified when I post new videos.
@nghanwoon4543
@nghanwoon4543 4 жыл бұрын
Hi. Niks. Could I ask the question that my project is ongoing and overtime from baseline but the % planned project as used the formula from this video is still same with last month? Example: the task should complete on 14-Apr-20 then the % of plan on 31 Mar is 83%. The % of planned also same in 83% on 30 April. is it wrongly setting in baseline? Thank you
@niksprojects
@niksprojects 4 жыл бұрын
I am not sure if I got it correctly but please see if you have set the status date correctly under the project information tab
@dararestumaharani6872
@dararestumaharani6872 8 жыл бұрын
Hi Nik, formula num 2 doesn't work. The value in column of elapsed still "0" or "ERROR". I've tried status day in 3rd day, 7th day, etc. Please help me why it happen?
@hanzreyes2854
@hanzreyes2854 4 жыл бұрын
Hi Niks, Based on your Plan % completed VS Actual % completed, how to show in MsProject equivalent Ahead or delays in Percent(%) and in Days? What is the formula. Thanks.
@niksprojects
@niksprojects 10 жыл бұрын
MS Project tutorial on How to get the Baseline % complete
@amoradjasmadi5156
@amoradjasmadi5156 5 жыл бұрын
Thank Alot!!
@niksprojects
@niksprojects 5 жыл бұрын
You are very welcome
@munfailye2216
@munfailye2216 7 жыл бұрын
Hi Nik, I tried to follow all the steps that you shared in the video, but i found the "Elapsed Day" and "Planned % Complete" are maintain "0" although i have amend on the "status date" within the whole project period. i have sent you an email with an attached MS proj file. Hope to hear from you soon. Thanks
@richardbright3219
@richardbright3219 8 жыл бұрын
The formula for step 2 is different on your blog from the one you have in the video
@AD-ve9hx
@AD-ve9hx 7 жыл бұрын
how can i show %completion work for any number rather than days in ms project ?
@pankajwag
@pankajwag 7 жыл бұрын
Hi Niks Is there any way to calculate Planned %Work Complete ?
@terjevelde5914
@terjevelde5914 10 жыл бұрын
Hi Niks! Get 100% Planned % Complete on Summary task despite that not all sub-tasks are planned to be completed at the tracked/actual date.Any reason why?
@MrPhamsac
@MrPhamsac 7 жыл бұрын
Dear Mr.Niks, I can't access following formula below IIf(DateDiff("d",Start,[Status Date])>=Val(ProjDurConv(Duration,pjDays)),Val(ProjDurConv(Duration,pjDays)),IIf(DateDiff("d",Start,[Status Date])
@rsilvino1
@rsilvino1 8 жыл бұрын
Hey Nick, i can´t access the project fucntions page. Could you send me the second syntax about elapsed days?
@niksprojects
@niksprojects 8 жыл бұрын
+Renato Silvino - sorry about that. I have to restore my blog page. But you can access the site from here - web.archive.org/web/20160110071841/niksprojects.com/blog/
@charlesloo
@charlesloo 9 жыл бұрын
Hi Niks, Thanks for your great formula! But there is one problem arose when I apply your formula to my MS Project. The percentage only shows in the lowest level of tasks and there are no average/accumulate percentage shown in upper tasks. What can I do to show the percentage complete of upper task in order for me to compare the overall ahead/delay of % complete?
@niksprojects
@niksprojects 9 жыл бұрын
Please try to select the "Roll up to Summary task" option on the Customize Field window where we clicked on Formula tab to insert the Formula.
@charlesloo
@charlesloo 9 жыл бұрын
Niks Projects Thanks Niks. It is very useful for my progress presentation.
@niksprojects
@niksprojects 9 жыл бұрын
DarkTrib3 I am glad it helped
@amirrahil5161
@amirrahil5161 10 жыл бұрын
Hi Niks, thanks a lot for your amazing trick, based on your instruction I have Planned percent, but in last column when I used this formula: Format(Number3, “0%”) it gave me an error in Planned % Complete, can you help me in this regards.
@niksprojects
@niksprojects 10 жыл бұрын
I am not sure what is the issue. If you can mail me a sample project to niksprojects@gmail.com I will take a look.
@niksprojects
@niksprojects 10 жыл бұрын
Also if you are getting error on the Format(Number3, "0%") when you copy pasted the above formula from this page, all you have to do is delete everything after Number3, and then retype 0% within double quotes. It will take it.
@DenisFourie
@DenisFourie 6 жыл бұрын
Hi. I can't get this to work. If I use the formula on your blog which is different from the video, then it shows me the planned percentage for a task that was meant to finish 3 days ago should be 10%. If I use the formula on the video and in comments below, then it shows project should be 100% even though the project end date is only 4 months from now? Please help.
@DenisFourie
@DenisFourie 6 жыл бұрын
I use Project Professional 365
@mrcoolconfidence
@mrcoolconfidence 9 жыл бұрын
I am getting error after step 3 inserting the planned percentage column, please help me why I am getting error.
@SilverbackAndHammer
@SilverbackAndHammer 8 жыл бұрын
IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff(“d”,[Baseline Start],[Status Date])
@chinnisree4575
@chinnisree4575 4 жыл бұрын
hi niks elasped formula showing syntax error
@aruncs2002
@aruncs2002 9 жыл бұрын
Hi Nik, Thanks a ton for your tutorial . I followed all your steps meticulously. However I am encountering error in few milestone fields.Please help
@1987Petar
@1987Petar 8 жыл бұрын
+Arun Chandrashekhar For me, much easier is to enter a new Number column (named, lets say, Planned Completion) with formula IIf([Status Date]>[Baseline Finish];1;IIf([Baseline Start]>[Status Date];0;([Status Date] - [Baseline Start])/([Baseline Finish] - [Baseline Start]))) and after that add Text column as described, to turn number in %. In this was solving problem with the Milestones and also with updating Project.
@fayzankhan1781
@fayzankhan1781 6 жыл бұрын
Can i calculate Monthly plannned and actual work %?
@xianph
@xianph 8 жыл бұрын
Tried the Formula and it works. but Problem is when I reschedule the Task the Planned % is a 4 digit Negative Value
@mannbiher
@mannbiher 10 жыл бұрын
Hi Nikhil, Wow new Mac.. :-)
@niksprojects
@niksprojects 10 жыл бұрын
Thanks
@chisholmcc
@chisholmcc 9 жыл бұрын
Nik are you using MS Project on your Mac? It this a Mac application or are you using a Virtual Machine?
@niksprojects
@niksprojects 9 жыл бұрын
christopher chisholm I was using Parallels (VM on Mac).
@personalmind
@personalmind 9 жыл бұрын
Hi Niks, just a point... how do you consider the non-working days? If I've got a task of 10 days as duration starting from 3/11/2014 and finish on 14/11/2014, let suppose to have a status date on 13/11/2014.. with your formula there's a wrong comparison because it will consider the activity with an 100% of schedule % complete which is wrong.. "13/11/2014 - 03/11/2014 = 10 days ; 10 days equal to duration -> elapsed days = 10 -> 100% schedule % complete.." I fpund fantastic your idea (i'm a primavera user), but this calculation doesn't consider the non-working days so i always have a wrong % of schedule complete.... another example... task A 2 DAYS As duration starting on Friday and finish on Mondays, so for example Start 2 April Finish 5 April status date 4 April 4 April - 2 April = 2 days -> Equal to duration -> Elapsed days = 2 -> 100% schedule complete -> FALSE Best regards Nicola
@niksprojects
@niksprojects 9 жыл бұрын
Hi Personalmind, Non-Working days is included in the calculation because the function I used is DateDiff which use the calendar dates including Saturday and Sunday. You can modify the formula to replace DateDiff with ProjDateDiff function. This will calculate only the working days based on your project calendar and it will resolve the issue. I will update my blog with the updated formula please refer www.niksprojects.com/blog - Hope this helps. (Note: ProjDateDiff formula returns the difference in minutes so you have to divide it by 480 (480 minutes in a 8 hr working day) to arrive at ellapsed days) Please refer the formula below. Updated Formula: IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff("d",[Baseline Start],[Status Date])
@Thaisaong
@Thaisaong 6 жыл бұрын
Some thing does not work; when % complete and plan % complete of sub-projects are equal ( means not behind or ahead ), the master project are not equal! while they must be eqaul
@anony449
@anony449 4 жыл бұрын
Hi Nik - At times, I am having an issue with the Elapsed Days, where it does not pick up the re-baselined duration. Can you please help?
@anony449
@anony449 4 жыл бұрын
FYI, I have re-baselined the project with a new set of dates.
@niksprojects
@niksprojects 4 жыл бұрын
Did it work after re-baselining?
@niksprojects
@niksprojects 4 жыл бұрын
Because MS Project saves each baseline and in the formula (2nd step) we are using Baseline dates, I wonder if you could reset the baseline first make the date changes and then baseline and see if that helps
@anony449
@anony449 4 жыл бұрын
​@@niksprojects That's right. I have baselined this schedule multiple times and this time it was using my Baseline9 dates. I went back to my previous version with Baseline8 dates, did the date changes again and baselined the schedule using Baseline9 but the issue persists. The issue is the Actual % is 100 % but the Planned % still shows 81% due to the Elapsed Days. The Elapsed Days is lesser than the task duration and not picking up the duration of the completed task.
@niksprojects
@niksprojects 4 жыл бұрын
Ok I will take a look at it this weekend
@andychurch5457
@andychurch5457 6 жыл бұрын
Hi Nik, I entered all the formulae for a new project and it worked...thanks! However, I have an issue if I insert a new task. The duration in days seems to work correctly but the other two formulae simply return zeros (0's). I've tried to check it's working by inserting a parallel task to one that works (nothing different) and I expect to see the same data in each task...but no...just zeros. Any ideas?
@TLYRIDER
@TLYRIDER 6 жыл бұрын
Andy Church hi (this is my other channel) . Did you try resetting the baseline?
@TLYRIDER
@TLYRIDER 6 жыл бұрын
Andy Church I have to check but I believe I used baseline dates in the formula so when you insert a new task then you will have to rebaseline your project
@andychurch5457
@andychurch5457 6 жыл бұрын
Hi Nik, Many thanks!...it worked! I knew it would be something dumb I was/wasn't doing! :)
@TLYRIDER
@TLYRIDER 6 жыл бұрын
glad to know it worked. you are most welcome
@ThomasWeiPhinYap
@ThomasWeiPhinYap 6 жыл бұрын
How to create a column in MS Project on Baseline Cost % Complete at a known Status Date? The Cost for each activity have been completed and saved in Baseline.
@suvojitdas09
@suvojitdas09 10 жыл бұрын
Niks i was applying this in my project but in step 2 (elapsed days), when i was copying the formula it shown me error even after trying the same as suggested by you in the video.The error message was displaying. Please HELP!!
@niksprojects
@niksprojects 10 жыл бұрын
Did you set the "Status Date" correctly?
@s3b898
@s3b898 8 жыл бұрын
Hi Nik, tried to access your site for your formulas but i can't find the site anymore?
@niksprojects
@niksprojects 8 жыл бұрын
www.niksprojects.com/blog/ - sorry it was a technical glitch with the hosting company. when I upgraded the site to latest version I lost my blogs, so I recreated it here.
@niksprojects
@niksprojects 10 жыл бұрын
Hi Vahan, Microsoft Project is widely used to track and monitor large scale projects which has multiple activities performed over long duration. Based on your description below it looks like you need some thing like an online inventory/service management software rather than Microsoft project which more apt for schedule & budget tracking. You can track your cars and employees using Microsoft excel that would be the less cost effective way. But I would recommend a online tool which can look at the available cars and employees and assign them immediately based on your customer bookings. Also if the software is an online tool then employee can update from anywhere irrespective of office location. Try this link - www.limoanywhere.com
@flightdeckmaster
@flightdeckmaster 8 жыл бұрын
Hi Nik, I tried to follow exact steps shown but still I get 0 value in elapse days., planned percent and planned % compete....any suggestions?
@niksprojects
@niksprojects 8 жыл бұрын
Sorry for the delay in reply. Did you set the project start date and status date as well?
@niksprojects
@niksprojects 8 жыл бұрын
Also make sure that you have set the baseline
@ricartelaoagan1834
@ricartelaoagan1834 4 жыл бұрын
Hi nik how to show planned % completed in Physical % type? what you show in vedio is for Planned % complete base on duration type. Can you make a blog for this?
@niksprojects
@niksprojects 4 жыл бұрын
Sure let me add it to the list of videos to make.
@jpetrocelle2
@jpetrocelle2 8 жыл бұрын
Hi NIK , great tutorial. I have just one doubt. When i Put the project Status date to the end date of my project.the Plannde Percentagem is giving me 99%. Just First task is 99%. the other are right
@niksprojects
@niksprojects 8 жыл бұрын
Hello Joao. Sorry for the delayed response. That's weird, i am not sure what is causing that. I will try to look at my project template and see if there is a way to fix that. Or if you have found a solution please feel free to post it here so that the group here will know if they had similar issue.
@tbsbidayuh
@tbsbidayuh 6 жыл бұрын
I have "#ERROR" displayed inside the Milestone Task field under the Planned % Complete. Actually it means 0/0 = error in ms excel. is there anyway to get rid of the error to avoid confusion to our stakeholders? Thank you.
@deepakshrestha6640
@deepakshrestha6640 6 жыл бұрын
I am having the same problem as your, is there any solutions Nik???
@marzukiabdulmanap3001
@marzukiabdulmanap3001 3 жыл бұрын
@@deepakshrestha6640 ensure not 0...its mean minimum 10 min to get 0.01 days
@laliquepineda3728
@laliquepineda3728 8 жыл бұрын
For those with issues on Step 2... the formula from blog and video are different, just copy as seen on the video, or from here: IIf(DateDiff("d",Start,[Status Date])>=Val(ProjDurConv(Duration,pjDays)),Val(ProjDurConv(Duration,pjDays)),IIf(DateDiff("d",Start,[Status Date])
@angaz19wth
@angaz19wth 7 жыл бұрын
the formula giving me an #ERROR
@niksprojects
@niksprojects 7 жыл бұрын
Try retyping the formula again manually based on what you see on the screen and it will work. For some reason if we copy paste it was throwing error for some users
@angaz19wth
@angaz19wth 7 жыл бұрын
Thanks Nik! i typed it manually and it works, but i do have an issue. Task A - Baseline dates: 4/27 to 4/29 i updated it Status date of 5/3 and giving me a planned % complete of 50%, it should be 100% right? Appreciate your response. Thanks!
@niksprojects
@niksprojects 7 жыл бұрын
angaz that's strange, can you reset the baseline and set back again? And see if the formula then picks up the correct date and calculate correctly
@angaz19wth
@angaz19wth 7 жыл бұрын
Cool! it works. it gives me now 100%. One more thing, and how we roll up the Planned % complete? Can we?
@ramlalpareek3235
@ramlalpareek3235 3 жыл бұрын
Do u have delay analysis and how to add varation to show delay
@niksprojects
@niksprojects 3 жыл бұрын
I have never used delay analysis are you looking for SPI & CPI ? which shows the Schedule variance and the cost variance. If not can you elaborate your problem a little more and I can try what might be best way to solve it
@spudmck
@spudmck 6 жыл бұрын
I cannot get the elapsed days to compute correctly. Regardless of how many days an active task has truly elapsed I get "zero" days. Not sure what I need to do to make this formula work.
@spudmck
@spudmck 6 жыл бұрын
Never mind got it to work, just had to set the baseline. Thanks!
@niksprojects
@niksprojects 6 жыл бұрын
Hi Joe, Did you baselined your project?
@spudmck
@spudmck 6 жыл бұрын
Niks Projects that was the one thing I forgot...afterwards it worked no problems...thanks!
@goldone20
@goldone20 8 жыл бұрын
Hello - any ideas why it would not work for "parent" tasks?
@niksprojects
@niksprojects 8 жыл бұрын
Hello Heather, Did you tried to click on the checkbox which says "Roll the formula to summary tasks" on the formula window?
@ezaitoun
@ezaitoun 10 жыл бұрын
thanks a lot Mr Niks i have another problem how can i get the latest baseline to use it in my calculation
@niksprojects
@niksprojects 10 жыл бұрын
Did you tried setting the baseline again and saving ? Otherwise clear the baseline and set the new baseline and see if that resolves the issue. Let me know either way
@netmarcos1
@netmarcos1 9 жыл бұрын
Essam Zaitoun Under Project Options Advanced - look to the Earned Value sections and select the desired baseline there
@leeriley9782
@leeriley9782 7 жыл бұрын
Hi - I want to compare Actual % work Complete with Should % work Complete using two adjacent columns in the same MSP file. Do you know how to do this?
@niksprojects
@niksprojects 7 жыл бұрын
Lee Riley Hello! When you say Should % that's the planned % right? As per the plan we should have completed this much work?. If so this video is actual about comparing that. The planned vs the actual, where the planned is where we ideally should have been and the actual is where we actually are.
@leeriley9782
@leeriley9782 7 жыл бұрын
Niks Projects good evening and thanks so much for the quick reply. If I understand correctly your video compares duration% , not work%. It's work% I need to compare.
@niksprojects
@niksprojects 7 жыл бұрын
Lee Riley oh got it. I never tried, I think I got similar questions from other subscribers in this channel. Let me try if I can do similar formula for the work and if yes, then I will post a new video on it. Thanks
@gcathyie
@gcathyie 10 жыл бұрын
Hi Niks, Thanks for the info. Btw, does it work for milestones? the value for Number 1 and 2 is 0 while the Number 3 and text 1 columns for each milestone activities becomes error. Is there any solution in this problem?
@1987Petar
@1987Petar 8 жыл бұрын
+gcathyie For me, much easier is to enter a new Number column (named, lets say, Planned Completion) with formula IIf([Status Date]>[Baseline Finish];1;IIf([Baseline Start]>[Status Date];0;([Status Date] - [Baseline Start])/([Baseline Finish] - [Baseline Start]))) and after that add Text column as described, to turn number in %. In this was solving problem with the Milestones and also with updating Project.
@nidzamnoori1927
@nidzamnoori1927 7 жыл бұрын
im getting error message at ....;1;...
@MrPhamsac
@MrPhamsac 7 жыл бұрын
please helf me, modifies if you can
@suhailafakri6080
@suhailafakri6080 8 жыл бұрын
in the cases where both duration and elapsed days are 0, it shows error. Is there any way i can not show this error?
@niksprojects
@niksprojects 8 жыл бұрын
You can try to add one more nested if statement to handle it.
@jeffreydeguzman5974
@jeffreydeguzman5974 7 жыл бұрын
hi nick, thanks for the video. it helps me a lot. what do you mean when you say "add one more nested"? i think i got same issue with Suhaili, mine is about milestone, where duration is zero. thanks in advance for your reply.
@NguyenHuuLinh_
@NguyenHuuLinh_ 8 жыл бұрын
thanks alot, but step 2 for me give an error at the end of fomular "ProjDateDiff",ProjDateDiff at the begining of fomular is ok , i retype ProjDateDiff again but it doesn't work!. can you help me. IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff(“d”,[Baseline Start],[Status Date])
@TLYRIDER
@TLYRIDER 8 жыл бұрын
Have you set up the project start dates and current dat and status date? Those 3 dates have to be set up. You can set up the dates by going under the Project Tab and clicking "Project Information". I guess that should be the issue, if that doesnt resolve the issue then let me know.
@hasifhazimelias
@hasifhazimelias 8 жыл бұрын
hi TYL Rider, I have used the latest formula from the website and it is giving me lots of error. I already set up the project information and it does not solve the issue. And then, I changed to the old formula from this video for step 2 and it does not give me any error but the problem is, it does calculate weekend and the exact planned percentage will not calculated. Any thought in resolving this issue? Thank you
@kristiyager
@kristiyager 10 жыл бұрын
Nik, I'd really like the formulas, but your blog is now unavailable on GoDaddy. Any change you can post them here?
@masayuent6863
@masayuent6863 7 жыл бұрын
i tried to do it by followed your tutorial but i don't know why did at the main task it showed 100% even though there are sub-task that still in 0%
@niksprojects
@niksprojects 7 жыл бұрын
On the windows where you type in formulas there is an option to select "roll up to summary tasks" something like that. Do that for all number fields where you typed in the formula
@masayuent6863
@masayuent6863 7 жыл бұрын
Owh okay, i understand thank you for your help
@wabusamaha
@wabusamaha 7 жыл бұрын
The screen is so wide, details are difficult to see and follow!
@najmiyahabdullah1699
@najmiyahabdullah1699 6 жыл бұрын
can't open ur blog...
@niksprojects
@niksprojects 6 жыл бұрын
najmiyah abdullah - Sorry about that, not sure what happened. Try this niksprojects.wordpress.com
@mitchellmcallister3980
@mitchellmcallister3980 8 жыл бұрын
I am getting #ERROR steps 2,3,4 for MS project 2010
@niksprojects
@niksprojects 8 жыл бұрын
Sorry for a late reply, but can you tell me what error are you getting? is the error highlighting some specific area of the formula or telling you what is not correct?
@speakingnvowels
@speakingnvowels 8 жыл бұрын
MS Project for a Mac? How did that happen? That would be amazing because this PC of mine is utter trash!
@niksprojects
@niksprojects 8 жыл бұрын
+speakingnvowels - I was running virtual Windows machine on Mac using Parallel Desktop software. Once you load windows on your Mac using parallel then you can install MS Project for Windows. Unfortunately we cannot install MS Project directly on a MAC
@speakingnvowels
@speakingnvowels 8 жыл бұрын
ahh! makes sense. thanks!
@rsilvino1
@rsilvino1 8 жыл бұрын
Thank you very much... i did every step but something wrong. In my project, my % planned complete is more than correct, looking the finish date. could you send me your mail adress please
@niksprojects
@niksprojects 8 жыл бұрын
niksprojects@gmail.com
@trecyta
@trecyta 8 жыл бұрын
your blog site is suspended
@niksprojects
@niksprojects 8 жыл бұрын
Try this - www.niksprojects.com/blog/
@CecilDSouza
@CecilDSouza 8 жыл бұрын
Why don't you caret the demo with zooming in and out so that we can actually see what is happening. Right now, all we see is you clicking here and here.
@muhammadabdullahinjustice2585
@muhammadabdullahinjustice2585 8 жыл бұрын
+Cecil D'Souza try hanging the quality to 720p; it'll help
@vidhyagayathrikrishnamoort5858
@vidhyagayathrikrishnamoort5858 5 жыл бұрын
It's quite confusing and using own codes may not be of help to all. It should be explained in layman terms. Lot of words but the content is still not clear.
@niksprojects
@niksprojects 5 жыл бұрын
The screen recording software didnt capture the screen with clarity, so I put those steps on my website. Take a look at the content on this site - niksprojects.com/2016/06/05/ms-project-actual-vs-planned-complete/
The Difference Between "% COMPLETE" and "PHYSICAL % COMPLETE" in Microsoft Project
14:48
마시멜로우로 체감되는 요즘 물가
00:20
진영민yeongmin
Рет қаралды 30 МЛН
Best father #shorts by Secret Vlog
00:18
Secret Vlog
Рет қаралды 22 МЛН
Incredible magic 🤯✨
00:53
America's Got Talent
Рет қаралды 81 МЛН
How Many Balloons Does It Take To Fly?
00:18
MrBeast
Рет қаралды 154 МЛН
Can planned percentage be calculated using Status Date?
8:17
SMJ-Tech
Рет қаралды 1,6 М.
Create S-Curve for Planned Target vs Actual Work from MS Project
8:05
Add Decimal Places to Microsoft Project Percent Complete (% Complete)
8:20
MS Project 2016 Baselines: compare actual and initial plan
3:19
How to calculate Planned Percentage in MS Project
7:12
SMJ-Tech
Рет қаралды 27 М.
Create Planned Target vs Actual S-Curve from MS Project
11:16
Excel Insights
Рет қаралды 16 М.
Я УКРАЛ ТЕЛЕФОН В МИЛАНЕ
9:18
Игорь Линк
Рет қаралды 126 М.
Телефон-електрошокер
0:43
RICARDO 2.0
Рет қаралды 1,3 МЛН
Красиво, но телефон жаль
0:32
Бесполезные Новости
Рет қаралды 1,3 МЛН
PART 52 || DIY Wireless Switch forElectronic Lights - Easy Guide!
1:01
HUBAB__OFFICIAL
Рет қаралды 64 МЛН