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
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
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).
Formula:
1:21 TH-cam1 th-cam.com/video/UwCPwR4hToA/w-d-xo.html&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 TH-cam2 th-cam.com/video/egWA82E1i1w/w-d-xo.html&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] & "%"
Template for Microsoft Project
github.com/chewyeejian/youtube_materials
Template for Microsoft Project
github.com/chewyeejian/youtube_materials
How can i copy the formula ?
You are a very good teacher ...kindly do a step by step videos
Thank you. This is very informative . I appreciate it very much. More power to you sir
Don't know, but the first formula contains syntax error here "...(Duration>0,IIf(ProjDateDiff..." in the parameter IIF
Very Useful Tip.
Please kindly drop the formula
the formula can be found my my comment =)
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
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?
new Sub here, can i have a copy of the file (office project) sir? just need the TASKS inputs.. thanks
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
What happens next when you change the status date to a future date. How do you calculate the Baseline %
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).