Skip to content

s-curve in ms project

Ammar SamadMember for 19 years 2 months
Created
4
3
0
Good day

hi my fellow planners,

One query here, I have put on all input i.e.resources, work & cost in ms project schedule and intend to derived an s-curve based on ’works’. my question is how to produce s-curve for early & late completion. I’ve tryed use "analyze timescaled data in excel" but the result shows early completion data tabulation only. FYI i am using ms project 2003. any one have an idea?

TQ & best regards.

4 replies

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    Mohammed,
    MS Project is not really efficient to do that!
    You could:
    1. Schedule your project from the end date and then export your data
    2. Display the Task Usage view, then add the Work, Cost, ... and the Early Start/Finish, Late Start/Finish dates, and copu/paste the data into MS Excel
    Alexandre
  2. 0
    Ammar Samad ·
    Tq Alex,

    I have done as your suggestion but I have to arrange the "Work" tabulation MANUALLY. Is that the correct way? Just to confirm..Anyway TQ very much.

    Regards


  3. 0
    Alexandre Faulx-Briole ·
    Mohammed,
    you are right, there is still some work to do to fix the table; a excel macro would help!
    Alexandre
  4. 0
    Mohd Fakry ·
    Mohammed,

    For me to create any s-curve for any type data, I will always use either the Task Usage View / Resource Usage View. I find it really helpful as we can choose which data to show either cost, resource or work. And what I’ll do after that is just simply copy and past into excel and further customize into chart. I hope this will help.




    m.fakry

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?