Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Microsoft Project Help on S curve

3 replies [Last post]
Fri, 2007-06-08 07:01
Umer Riaz
User offline. Last seen 18 years 3 days ago. Offline
Joined: 8 Jun 2007
Posts: 3
Groups: Petro-Chem / Oil & Gas
I have Baseline and Task progress which shows how much a task has progressed.I am not putting any resources only task start and finish time is there and progress is there.how I can create an S curve and What I have to do.

Top

Replies

Tue, 2007-06-12 05:18
#1
J Venkatesh PMP P...
User offline. Last seen 12 years 4 weeks ago. Offline
Joined: 7 Aug 2006
Posts: 52
Groups: GPC Qatar
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
Top
Tue, 2007-06-12 03:51
#2
A D
User offline. Last seen 4 years 29 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
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
Top
Mon, 2007-06-11 03:00
#3
Trevor Rabey
User offline. Last seen 2 years 28 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
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.
Top