Results 1 to 6 of 6

Thread: i want to generate S-curve

  1. #1
    Join Date
    Sep 2005
    Posts
    7

    i want to generate S-curve

    This is Project 2003 and am stuck somewhere in between. I want to generate a S-curve but not getting how can I d o the same. I request you guys to please let me know the command for the same.

    Thank you in advance.

  2. #2
    Join Date
    Sep 2004
    Posts
    151
    I don’t think MS Project 2003 can generate S-Curves natively. As per your post, assuming you need to generate S-curves for earned value information, you simply need to export the earned value data to Excel using Analyze Timescaled Data in Excel button on the Analysis toolbar. In excel you can display the task usage view and show the Analysis toolbar. Once done click the Analyze Timescaled Data button and when the wizard runs select the earned value information. Hope this helps.

  3. #3
    Join Date
    Sep 2005
    Posts
    227

    RE: i want to generate S-curve

    You could also export (or copy/paste) data to Excel and do some simple calculations. Not very elegant, but it's doable.

  4. #4
    Join Date
    Jan 2012
    Posts
    1

    Re: i want to generate S-curve

    Quote Originally Posted by Bob C. View Post
    You could also export (or copy/paste) data to Excel and do some simple
    calculations. Not very elegant, but it's doable.
    i want to understand how to use ms project to generate an S-curve

  5. #5
    Join Date
    Aug 2011
    Posts
    700

    Re: i want to generate S-curve

    i want to understand how to use ms project to generate an S-curve
    See if you have basic idea about the MSP 2003 then you won’t have any problem in understanding the process of it, the s-curve is actually generated from the value that is earned by the value analysis and in order to perform the earned value method, just follow the below steps:
    • First just make sure that you are setting the tasks, start date, finish date, cost, resources etc and you are prepared for setting the baseline, so when you are ready with the same then just go in to View > Table > More Tables… > Earned Value, which will be having tasks, BCWS, BCWP, ACWP, SV, CV, etc, so just add the columns that you require
    • After that Go to Project > Project Information and then just change the status to finish date so that you can see all the BCWS after that just click on OK
    • After that just Click the “Analyze Timescaled Data in Excel” button or you can just click anywhere in case you are not able to get the button and then click on “Analysis” and also make sure that you are selecting the “Entire project” and then click on next
    • When you are done with the above steps then just select BCWS, BCWP, and ACWP and after that just click on next again and then enter the start and the finish date and respected time as well, after that click on next and then click in yes and then just import the graph to Excel and the click on “Export Data” and you are done.
    Hope that helps!!

  6. #6
    Join Date
    Dec 2006
    Posts
    489

    Re: i want to generate S-curve

    Quote Originally Posted by kanayo View Post
    i want to understand how to use ms project to generate an S-curve
    You do not mention what version of MS Project. If you are using Project 2007 or 2010, explore some of the visual reports. You also do not note what data you want to chart on the S curve. As Shurod directs, the classic is S-curves for Earned value data.

    A bit more information from you would be helpful.

Similar Threads

  1. Replies: 3
    Last Post: 23-10-2011, 10:55 PM
  2. Replies: 3
    Last Post: 23-10-2011, 05:25 AM
  3. Can we generate exe file in php?
    By amitweb007 in forum Software Development
    Replies: 1
    Last Post: 26-09-2011, 11:38 AM
  4. How to generate content with CSS
    By Eshita The Techie in forum Software Development
    Replies: 5
    Last Post: 08-01-2011, 10:54 AM
  5. How to use the generate() in CPP
    By Gaelic in forum Software Development
    Replies: 5
    Last Post: 15-02-2010, 09:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •