Preparing Progress Curve from Microsoft Project

[@kiranshinde4655]

thats easy method....perfect solution for me. Thank you

[@PrimeProjectControl]

Welcome Kiran, Please subscribe

[@limtaolong2765]

This is very useful yet fastest way to obtain the S curve...Thanks for the tutorial video

[@PrimeProjectControl]

Thank you, please subscribe

[@ronju04]

Learned a lot 😇

[@venkatesans8698]

Will you able to two session class I will pay the money

[@PrimeProjectControl]

I will quickly, send me google invitation link at [e-mail]

[@aikdrw9820]

Hello, thank you for your excellent tutorial, but i have a question, how to generate a progress curve in EXCEL like your video that the x axis is year and month, but the y axis is the progress of every month

[@SufianLau]

Thank you for making this video available. I find the background music very annoying and unnecessary. Less is more. :)

[@trovis8527]

In the excel ssheet you used please advise what type of chart *(as what excel application calls it) was used to create the graphic tracking the 2 series of actual vs estimated progress, thanks

[@daguanghui7895]

Thanks for your training, it is very useful. But could you advise how to add forecast in S curve. Compare baseline VS actual +forecast, it will be more better to see the overall status against baseline

[@venkatesans8698]

Sir, I have seen your video, but last three minutes I m unable to understand. Could u able to teach to me.

[@PrimeProjectControl]

Dear Venkatesan Please update 100 % in Microsoft Project Save as or Export or Copy the data into Excel Use S chart function and generate the curve

[@fafafafafarrr]

Hi. What is the problem if my cumulative % complete in scurve doesnt get 100% at end project? It only reach 90%

[@ravindrankrishnan2964]

Pls put video for cost loading and cash flow generation. Where BOQ is available with Qty and Rates are also available. The Rates are on per Cum, per Sqm basis ( Post Civil works on item Rate contracts )...

[@PrimeProjectControl]

Dear Ravindran Sir, Noted the Cash Flow Generation will be made available soon!

[@ravindrankrishnan2964]

@@PrimeProjectControl Thank you.

[@harristamsi9682]

How to automatically display cumulative % complete with decimal points?like 50.45% instead of 50%?

[@PrimeProjectControl]

which version MSP you are using

[@Jaffanajafdaeddilove]

Hi I have obtained actual work S curve. But how to obtain Planned S curve?

[@PrimeProjectControl]

its very simple, save it as separate file (or baseline), open it and make it 100% complete, then follow as per the video to extract values. To your notice we also have a hot course on Microsoft Project on discount the link is >>>www.udemy.com/course/microsoft-project-2019-course-for-beginners-to-adavnced/?referralCode=F3D0137408624B581FC4

[@Jaffanajafdaeddilove]

@@PrimeProjectControl Thanks

[@ahmadhaziq1411]

May i know the excel formula that you created for s curve? Thank you in advance

[@PrimeProjectControl]

Dear Ahmad, U no need to create any formula in Excel. Step (1) Create a table showing month/Week rows, similar to the setting as shown in Microsoft Project, than copy the Planned Values from MSP and Paste it in the table of excel, and click to generate graph. I hope answered your query please feel free to write me at [e-mail]

[@adampeter2270]

Can u show how to implement project extension of time due to covid in the program and s curve?

[@PrimeProjectControl]

Dear Adam Peter yes, am going prepare the course on it will be released in a months time :) personally if you have a further query kindly write to us at [e-mail]

[@ildefonsooffemaria4587]

Too loud background music..can also reduced next time😊😊

[@fabricemcromeo12]

Hi, Thanks for the video. How do this s-curve with the data dates instead of %? because some actual tasks will start late or even ahead of the planned/baseline dates.

[@PrimeProjectControl]

hi Maxwell, i believe you want to know how to add actual progress S curve ? if that is your requirement - you can create a row below and insert actual %, also can create an early and late curves.

[@hanawafis755]

@@PrimeProjectControl how do you want to show early and late curves?

[@PrimeProjectControl]

@@hanawafis755 Dear Hana, To show early and late curves, firstly once you saved as a baseline changes; change the column for early dates (start & finish) copy the data and paste in excel to generate early curve and the same way do it for late. Thanks :) @hana wafis

[@stannctstantalent3396]

How about cummulative cost? How do i change?

[@PrimeProjectControl]

Once cost loading is done, you can get cumulative cost curve, Please free to contact me at [e-mail] if you have trouble to carry out..

[@PrimeProjectControl]

i can advise based on which version of Microsoft Project you are using!

[@thepresentcoach5327]

great but quite low definition man

[@venkatesans8698]

In excel it was not come

[@PrimeProjectControl]

Did you follow the steps I have explained and you can copy into excel!

[@venkatesans8698]

Sir, will you able to connect 20 minutes online session for me? I have try so many times but it won't come excel where did I mistake I don't know I would like requested to you.

[@PrimeProjectControl]

@@venkatesans8698 Please send google invitation link to the email

[@privatechannel6081]

Background music is very loud and distracting! 🙄