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..
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
Member for
19 years 11 months
Member for19 years11 months
Submitted by Trevor Rabey on Mon, 2007-06-11 04:00
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.
Member for
19 years 3 monthsRE: Microsoft Project Help on S curve
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
Member for
18 years 5 monthsRE: Microsoft Project Help on S curve
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
Member for
19 years 11 monthsRE: Microsoft Project Help on S curve
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.