I need help please - I am new to Ms project latest version. Whenever i update actual start and actual end it automatically updates the start and end date column with similar dates. However i have set baseline start n baseline end. Which helps to track. Now i want to calculate the planned percentage based on baseline start and end date insetead of start and end date column . Can you help please to correct my plan?
Hi, Thanks for reaching out. Starting off with MS Project has its own learning curve. Updating Actual Start automatically updates the Start columns as internally they are the same for MS Project. The best way is to baseline the project and keep a track of project dates. For the planned percentage, do you have a formula defined? You can send it over to smj.tech2020@gmail.com and I will have it looked into
hi iam facing a issue, hope you can help me on that. I have uploaded cost for each of the program line item and also aligned the planned %age. Now i want to multiply the allocated cost to the planned%age to get the planned cost upto the status date.....however, when iam multiplying the "cost column" & "Planned %age" it is showing ERROR (maybe because, cost i sin number format & planned %age is in "text".... can you help me on this.... how can i format my planned %age column into number so that same can be multiplied by allocated cost....!!! any help is highly appreciated. Thanks.
Can you please use status date instead of now, as I want to see planned % of a certain day, eg last week Friday, otherwise your formula only shows you planned % as at the current date (computer date).
Why the wbs summary tabs is not showing the planned percentage? FYI, Please click to use the formula in the summary tab also. Then it will appear that location
You are welcome . The formula shown in the video is applied as per the current date however you can choose the appropriate Field value while creating the formula and apply an IF condition to check if the value is exceeding 100, then you can still show it as 100. I hope this will help you out. You can send me the formula on smj.tech2020@gmail.com with the dates that you are targeting and I can try to help out as well :)
I have a doubt there is resources allocation symbol in right side of activity name .in my pc What is resource over location.can you tell me brief in hindi.as I m not perfect in English language
Resource overallocation ka matlab hai keh aik resource same time duration mein aik se ziyada task perform ker raha hai. Aik wajha aur ho sakti hai keh resource ka overall work 8 hours se ziyada barh raha hai.
So after this part I'm getting stuck. If a task Planned % is 100% and that tasks Actual % is 50% as of today and if that task is going to be further delayed by 5 days and we change the Actual start date the Planned % completion is also getting re-adjusted which should not be the case when you Baseline the project and the Planned % completion column is in sync with Baseline Start and End dates. Pls help
Hi there, this is a very interesting scenario. However, if you use the Baseline Start date in percentage calculation in formula, it should provide the desired results. I will show this in one of my upcoming videos
@@SMJTech2020 when do u plan to show. This dosent work for me. Why is my Planned % changing when my baseline dates are already set but when i change the Start and Finish dates, the Pl% is also changing per those dates.
Can someone please explain how the "total" planned percentage is calculated out to be (like the backend formula of it)? is it the average of planned % of individual activities? Please help!
It's only showing % planned of each activity but what about % planned of overall project.. It should be Project %Planned vs % Complete.( Ex:- Till status date project was planned 60% and actual complete is 25%).
Hi Moiz, If you select roll up in the custom formula dialog box, you will start getting planned percentage on summary tasks as well which includes the overall project summary task. Try it out and feel free to comment in case you need more help. I'll try to cover this in one of the upcoming videos
@@SMJTech2020 Thank You for coming up with the solution..I really appreciate it!👏 It might be working completely but for me I can't able to select roll up in the custom field. I can select only none or use formula. It's my humble request if you get some time make a short video on this.. 🙏 I would be very Grateful to you.!
how to compare planned percent complete and % of complete-- Means 50% is the planned percent and 40% is the actual % complete-- Then 40/50 % = 80% is the Adherence... How to calculate this
You were getting a syntax error on zero as it was included as ''0'' (zero with two single quotes before and after it) instead of "0" (Zero with double quotes before and after it) . It can be tricky to catch as they both look the same however , if you paste this in the notepad, single quotes are shown with a slight distance. The same issue was with "%" .
Hi, just in case you missed the formula, here it is IIf([Status Date][Finish],"100",Int(ProjDateDiff([Start],[Status Date]+1,[Project Calendar])/[Duration]*100))) & "%"
Can you share the formula you are using? (you can send it on smj.tech2020@gmail.com) Do remember we need to put & before "%" in the formula as it concatenates the % sign
I have more better formula Number1: ProjDateDiff([Baseline Start],[Status Date])/480 Number2: [Baseline Duration]/480 Number3: IIf([Number1]=[Number2],100,IIf(([Number1]0),[Number1]/[Number2]*100,0)))