Skip to content

Microsoft Project Help on S curve

Umer RiazMember for 19 years 4 months
Created
3
3
0
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.

3 replies

Oldest first
  1. 0
    Trevor Rabey ·
    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.
  2. 0
    A D ·
    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
  3. 0
    J Venkatesh PMP PSP ACIArb ·
    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

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?