Microsoft Project Help on S curve
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
Riaz,
U can try this..
Sve ur baseline project as a newfile using save as option...
Now auto update the project keeping the status date as the project finish date..Once u have updated, all the activities in ur project shows 100% completed...
Now. using the reports, create a chart for the progress completed by months...this will be the monthly / cumm. progress planned for ur project...
export the monthly progress % completed values to an excel sheet and compare this with the actually progress % acheived..
Venkat
In short,
You can create a resource R and then allocate the budgeted quantity for the respective activities equal to original duration and then graph the resource R.
This is helpful during early stages of the project, when you are not sure of the quantum of resources and you wanna have S Curve for monitoring.
But, in the later stages S-Curve must be drawn for resources or cost.
Cheers,
Raviraj A Bhedase
What kind of "S" curve do you want. Specifically, what are you trying to graph against (as a function of) what?
An S curve is usually Cumulative Cost or Cumulative Work (Hours) on a vertical axis against time on the horizontal axis.
It could be Cumulative Duration against Time as well, I guess, but this would not mean very much or be very useful.
MSP will allow you to assign Work without necessarily assigning Resources.
It will also allow you to assign Costs as Fixed Costs against Tasks (Cost Table, Fixed Costs).
Then use the Analysis Toolbar to export the data and graph it in EXCEL.
If you do want to graph Cumulative Days against Time, although I am not sure why this would be useful, you could create a Resource called, say, "One Day" and assign it to every Task, then use the Analysis Toolbar and graph the Cumulative "Work" of that faked Resource.