| || |
Join Date: Aug 2011
Re: i want to generate S-curve
i want to understand how to use ms project to generate an S-curve
See if you have basic idea about the MSP 2003 then you won’t have any problem in understanding the process of it, the s-curve is actually generated from the value that is earned by the value analysis and in order to perform the earned value method, just follow the below steps:
- First just make sure that you are setting the tasks, start date, finish date, cost, resources etc and you are prepared for setting the baseline, so when you are ready with the same then just go in to View > Table > More Tables… > Earned Value, which will be having tasks, BCWS, BCWP, ACWP, SV, CV, etc, so just add the columns that you require
- After that Go to Project > Project Information and then just change the status to finish date so that you can see all the BCWS after that just click on OK
- After that just Click the “Analyze Timescaled Data in Excel” button or you can just click anywhere in case you are not able to get the button and then click on “Analysis” and also make sure that you are selecting the “Entire project” and then click on next
- When you are done with the above steps then just select BCWS, BCWP, and ACWP and after that just click on next again and then enter the start and the finish date and respected time as well, after that click on next and then click in yes and then just import the graph to Excel and the click on “Export Data” and you are done.
Hope that helps!!