Thanks

Sir JC, is your formula the same as getting the weighted percentage per scope of work with the formula "total cost of the certain scope divided by the total cost of the project?" Thanks in advance for your response!

Hi JC - I have one error in the Baseline Duration Total column at a task which was added after the baseline was set. I am currently on baseline 5. The project currently has 2208 activity lines. Some have been deleted (removed from scope) and this specific one task added - which is showing the error. Baseline Days Completed shows a number (411). The 'Planned Completion Value' column also shows an error - I assume this is due to the error in the 'Baseline Duration Total' column. Can you please help me resolve this, is there a way?

Hi again :) I wanna ask that; Can we show these columns (% planned and % complete) in a S-chart to compare them?

I'm wondering how to get the cumulative planned % complete. Thanks

Hi JC, great video! Will definitely adjust my calculation. But have you ever taken your calculation and added a weighting factor? I need to weight the schedule based on cost as some tasks duration doent justify the overall weighting against the project. PLEASE I require your help

This is just brilliant thank you. I am getting a few errors on summary tasks, any idea why? I have followed your guide step by step. I noticed the summary tasks that display errors are the one which I have added some blank fields underneath them...your help is much appreciated

How do you update notes or daily communication, changes and tasks?

Hi JC. Thanks for the tutorial. I tried to apply this on my project and I encountered an error. MS project doesn't allow me to write the part 0,0.01, which is in formula below. It says "The formula contains a syntax error or contains a reference to an unrecognized field or function name." What else can I use? IIf([Duration]=0,0.01,ProjDateDiff([Baseline Estimated Start],[Baseline Estimated Finish])/60/8)

Hi JC, Thank you so much for sharing this and it is very helpful. I'm taking the planned percentage by updating the baseline program to the status date and then pasting it as text into the updated project file. I've tried to apply your advice, but the manually calculated planned value I derived by updating the baseline program to the status date differs from the calculated value you taught me. For example, my manually calculated percentage is 39%, but when I use the calculation method you provided, it becomes 42%. Do you have any guesses about what might be going wrong?

I am still wondering why you need such complex formulas when you can just add a cost to an activity and use the earned value field to get the plan and actual % 😅😅😅😅😅😅😅😅😅😅😅

can we also use it to create a planned percentage based on late dates?

Thanks JC. for clarity, I saw you sped through the part where you'd have to baseline the newly added tasks. would that baseline activity have to be done every single time a new task is added?

Please upload more videos

Your starting assumption is wrong. % complete in msp means ( % planned complete) and we have to customise formula for % actual complete

We want to share with Companies, Universities and Governments 57 years of successful professional experience in several countries, in Oil and Gas, Petrochemical, Steel, Hydroelectric, Engineering and Construction Projects. Since 1981 we have been developing the Digital Twin, which is the most complete technological tool to optimize all types of Compa-nies, Cities and Countries. kzbin.info/www/bejne/m5LHkoSfgcR0gZI kzbin.info/www/bejne/nInPoWeHgcmKh9U

Export the Azure, Chat GPT, Revit, Plant 3D, Civil 3D, Inventor, ENGI file of the Building or Refinery to Excel, prepare Budget 1 and export it to COBRA. Prepare Budget 2 and export it to Microsoft Project. Solve the problems of Overallocated Resources, Planning Problems, prepare the Budget 3 with which the construction of the Building or the Refinery is going to be quoted.

Faaaaaanks !!

but isnt cost same? , in real world cost per litre of fuel keeps changing right?

Thank you so much you saved my life !!!! I subscribed to your channel . For those who found the problem of the appearance of zero (0) for all values, you must check that you saved baseline of your project.

That activity will be critical than, how to avoid that activity in the critical activity chart?

Hello, thanks for the video. I have one issue that I cannot fix. For example, I have a project manager who is involved in the whole project from start to finish, but it is very difficult to assign to him all the tasks that I have in the project because they overlap, and it is too hard to control from an overallocations point of view. Is there any trick to assign the project manager (PM) to the entire project without causing overallocations?

This is awesome. May I ask how can I contact you? I would like to volunteer in one of your projects!

Hi, can i get some help. Actually i just need to show my target % vs actual % I've been searching 100 videos, and none have done so. is microsoft project unable to do such simple task? im abit frustrated

Thanks so much for sharing. a question for you: is there a way to show this as either an "S-curve" within the report tab, or within task usage?

Great! it solved my problem in a big project!

Very interested.. Can we get the formula that you used

Thank you Kobus! Almost all of my headings and tasks calculates the % planned perfectly except a few Headings that shows ERRORS. Any advice?

Thanks !!!

Hi JC, Thank you for this video. I am facing a challenge here. I followed all the steps but I am getting 100% for all activities including the ones yet to start. What could be the problem?

Kobus... How do I get hold of you to make use of your services?

Please how can have access to the software I'm interested

Hi, thank you for this tutorial. I tried following the steps, but some of the tasks are #ERROR. Is this caused by the duration, as some of my tasks are in weeks and months. Can you help? Thank you.

Thanks JC for sharing this. Am I correct if I say every time you insert delays, you set a new base line? If yes, how we can record lets say 20 different delays on a project? I am asking this because we can set up to 11 baselines on microsoft project.

Awesome vid ! Only problem is that I keep getting a syntax error when using your formula .. I even tried to "retype" the highlighted error but to no avail :( Any advice ?

Thank you. the video was great.

Hey JC, what is the document you presented in the last section called?

Hi! I have a question. Is there any way to change the actual status date? in order to open the project and have the time to create a report with the status of one week ago for example.

Sir nice explained. However formulas used in customised columns could not be seen. Will u provide the formulas

you are the love of my life!! you explained this really easy and slow. I couldn't ask for more. Thank you sooooo much! 🥰

The deeper you get into the subtasks, the less accurate it becomes. Level 1 +- 1%, level 2 from %1 to 2%, level 3 up to 3%. i use the formula set at your link page. did i set something wrong?

is we have column name baseline estimated start and finish date or we have to use baselinestart and finish date

Very interesting use of this tool. The big question is how does actual cost data get entered? If it can pull from the accounting software, this is an exciting way forward for us. If it involves manual entry, not so much.

Wow Thanks JC this really worked, ive been strugling

Hi JC, I am JC as well. I really liked the tutorial on the correct way to show Planned %. I do have a question, does MS Project have Labor Units? I have not seen this

Great thanks

Beautiful

Very nice presentation. 👍👍

Hi, I face an issue we are behind schedule and the summary task shows we are ahead, that incorrect. so I follow the same as you did but I got an error in the summary task. how can I fix that? thanks in advance!

Hello JC; I watched your video about the pROJECT, i want ask you how you make the sheet with dependencies and delayed shecedule,