Planned (Scheduled/Baseline) vs Actual (%)Progress/Complete (Summary Level) Microsoft Project 2021

Refer to the Proposed Section if you had already tried before the previous formula provided from other videos
Formula can be found in the comment Section.
*Note: The automated (formula) to obtain the scheduled (%) provided in the previous videos found - Cannot obtain the correct scheduled (%) on the summary levels.
*A semi-automated way is used to ensure the values.
⬇️ Timestamps:
0:00 → Introduction & Problems
0:53 → KZbin1 & KZbin2 Formula
5:00 → Proposed - Semi-Automated
10:20 → Ahead/Delay
11:25 → Reports / Chart (Planned vs % Complete vs Ahead/Delay)
13:30 → Showing the "%" symbol in the task column
15:00 → Why need Text & Number field?
❗️OTHER USEFUL LINKS
KZbin Video 1
• MS Project Planned Per...
KZbin Video 2
• Microsoft Project Base...
How to find the planned / baseline / scheduled vs real / actual progress
How to find the ahead / delay in percentage (%) comparing the planned / baselines / schedules to the real / actual progress
How to create the graph / chart comparing the planned / baseline / scheduled vs real / actual progress
How to show the percentage (%) symbol in the task list column
#planned #scheduled #baseline #real #actual #progress #ahead #delay #graph #chart #showpercentage #microsoftproject #2021 #thelazychew

[@ahmedmutala8495]

You are a very good teacher ...kindly do a step by step videos

[@kenmercurio9121]

Thank you. This is very informative . I appreciate it very much. More power to you sir

[@thelazychewresearch]

Template for Microsoft Project github.com/chewyeejian/youtube_materials Formula: 1:21 KZbin1 kzbin.info/www/bejne/i6imgaqIac2HpaM&ab_channel=NiksProjects Val(Format(IIf(Duration>0,IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff("d",[Baseline Start],[Status Date])[Baseline Start],1,0)),"0%")) 4:12 KZbin2 kzbin.info/www/bejne/m5i6cmtoepacZ9k&ab_channel=Planners%27Place IIf([Status Date]=[Baseline Finish],1,ProjDateDiff([Baseline Start],[Status Date])/ProjDateDiff([Baseline Start],[Baseline Finish]))) 7:42 Remove the (%) from the % Complete using Text Field Val([% Complete]) 10:30 Ahead/Delay (%) [Number1] - [% Complete] 14:25 Adding (%) symbol [Number1] & "%"

[@thelazychewresearch]

Template for Microsoft Project github.com/chewyeejian/youtube_materials

[@toxidisamv2402]

How can i copy the formula ?

[@Jessicamaryp]

Hi, i just followed step by step, but my Complete % summary still doesnt match all the sublines that are complete, do you have any tips?

[@mylajanemalabanan5218]

Hi Sir. Good Day. I encountered problems with Microsoft project which is Publish Failure (error 23000)I suspect it was corrupted. I am thinking of how am I going to unpublish the workplan since it always fail to publish. Your response will be appreciated. Thankyou

[@oyinkeprebiempere4627]

What happens next when you change the status date to a future date. How do you calculate the Baseline %

[@thelazychewresearch]

In that case, you need to repeat the steps earlier. 6:15 use the mark on track get the new baseline. Paste the new baseline into the scheduled baseline (manually added earlier).

[@dondibart2106]

new Sub here, can i have a copy of the file (office project) sir? just need the TASKS inputs.. thanks

[@thelazychewresearch]

Hi, Apologize for the delay, you may download the attached template or you may just find it directly from the search function in microsoft project. github.com/chewyeejian/youtube_materials