Preparing Progress Curve from Microsoft Project
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- The video teaches about how to start Microsoft Project by cross verifying the project settings and creating a simple project to derive baseline (Planned S Curve). This video majorly teaches you how to extract Physical Progress Curve in easiest way through microsoft project.
The Progress Curves are used to monitor in project management, as the progress curves gives planned progress percentage and actual progress percentage. By knowing the the progress percentage of the project, managers will make key decision to control the project.
Following below sections are discussed in details.
1) Checking and selecting the appropriate project options and settings in Microsoft Project.
2) Create Simple basic schedule
3) Steps in preparing Planned Progress Percentages & extracting the %complete data.
4) Excel format for monitoring the Planned & Actual progress.
5) Deriving the Planned Progress Curve and creation of actual progress data.
This simple approach helps to monitor your project and track the progress.
For further queries and question related to this topic kindly reach to us by email - Info@primeprojectcontrol.com
Like and Subscribe the channel for more latest content in project management.
#planning #projectmanagement #microsoftproject #scurve #progresscurve #projectmonitoring #construction #it #project #scheduling #programmanagement #civilengineering #projectcontrols #tracking #PMO
thats easy method....perfect solution for me. Thank you
Welcome Kiran, Please subscribe
Learned a lot
😇
This is very useful yet fastest way to obtain the S curve...Thanks for the tutorial video
Thank you, please subscribe
Thank you for making this video available. I find the background music very annoying and unnecessary. Less is more. :)
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
Will you able to two session class I will pay the money
I will quickly, send me google invitation link at info@primeprojectcontrol.com
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
great but quite low definition man
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
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 )...
Dear Ravindran Sir, Noted the Cash Flow Generation will be made available soon!
@@PrimeProjectControl Thank you.
Sir, I have seen your video, but last three minutes I m unable to understand. Could u able to teach to me.
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
Hi. What is the problem if my cumulative % complete in scurve doesnt get 100% at end project? It only reach 90%
How to automatically display cumulative % complete with decimal points?like 50.45% instead of 50%?
which version MSP you are using
Can u show how to implement project extension of time due to covid in the program and s curve?
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 info@primeprojectcontrol.com
Too loud background music..can also reduced next time😊😊
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.
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.
@@PrimeProjectControl how do you want to show early and late curves?
@@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
Hi I have obtained actual work S curve. But how to obtain Planned S curve?
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
@@PrimeProjectControl Thanks
How about cummulative cost? How do i change?
Once cost loading is done, you can get cumulative cost curve, Please free to contact me at info@primeprojectcontrol.com if you have trouble to carry out..
i can advise based on which version of Microsoft Project you are using!
May i know the excel formula that you created for s curve? Thank you in advance
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 info@primeprojectcontrol.com
In excel it was not come
Did you follow the steps I have explained and you can copy into excel!
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.
@@venkatesans8698 Please send google invitation link to the email
Background music is very loud and distracting! 🙄