Skip to content
ProjectControls.com
Microsoft Project

Generating Progress S-curve (Plan VS Actual)

In the Open Standard
Chin Fwei YipMember for 19 years
Created
8
7
0
Hi there.

Just wonder if we are able to generate progrss S-curve (plan VS actual) with a resources and material loaded schedule created by MS Project 2003? This is not mentioned in the book I read last week.

Thanks and Regards,
Save Follow Follow forum Report
Reply New topic

8 replies

Oldest first
  1. 0
    Trevor Rabey ·
    #1
    plan vs actual of what?
    Report
  2. 0
    Chin Fwei Yip ·
    #2
    Anything, says plan manhours VS earned manhours to-date, plan manhours VS actual spent to-date, plan cost to-date VS earned cost to-date etc.
    Report
  3. 0
    Trevor Rabey ·
    #3
    Read up on Earned Value in MSP Help.
    See also the Analysis Toolbar, where you can export Cumulative Cost and Cumulative Work, as well as all of the Earned Value numbers to EXCEL, and it draws the graph for you.
    Report
  4. 0
    Chin Fwei Yip ·
    #4
    Been doing this all the time.

    Just wonder is there any ’plug-in’ to let MSP to generate the curve just like Primavera Project Planner...
    Report
  5. 0
    Alexandre Faulx-Briole ·
    #5
    Chin,
    No, you will have to use MS Excel to generate S-Curve for MSP 2003 and before; or upgrade to MSP 2007 and use its Visual Reports
    Alexandre
    Report
  6. 0
    Madeliene Ozaeta ·
    #6
    hi! i also mean to ask the same thing as chin. Simply how t plot planned progress vs actual progress in terms of weighted %.

    Is there also a way of adding a row in the gant chart to show the total cost of the project?

    million thanks po!

    maimai
    Report
  7. 0
    Trevor Rabey ·
    #7
    What about all of the timephased data that you can export to EXCEL (and it draws the graph for you) with the "analyse timescaled data in EXCEL" button on the Analysis Toolbar?
    Report
  8. 0
    Jean-Yves Moine ·
    #8

    you can buy "S curves V2"

     

    you can buy "S curves V2" VBA EXCEL application: http://www.cubixpm-scurves.com/en/

    it allows to :

    • Create 26 S curves (baseline early and late, physical progress) in automatic connection with aMS PROJECT or PRIMAVERA P6 schedule.
    • Spread the weights in a linear or Gaussian way over the tasks of schedule.
    • Create S curves with 3 criteria, on the basis of 5 task codes.
    • Manage a schedule up to 10,000 tasks.

    BR, Jean-Yves Moine.

    Report

Log in or join to reply

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

Log inJoin free

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