Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



i want to generate S-curve

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-10-2006
Member
 
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.

Reply With Quote
  #2  
Old 28-10-2006
Member
 
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.
Reply With Quote
  #3  
Old 15-06-2009
Member
 
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.
Reply With Quote
  #4  
Old 24-01-2012
Member
 
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
Reply With Quote
  #5  
Old 24-01-2012
Member
 
Join Date: Aug 2011
Posts: 688
Re: i want to generate S-curve

Quote:
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!!
Reply With Quote
  #6  
Old 24-01-2012
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "i want to generate S-curve"
Thread Thread Starter Forum Replies Last Post
Is it possible to use the battery of BlackBerry Curve 3G 9300 in BlackBerry curve 9360 Capulet Portable Devices 3 23-10-2011 10:55 PM
The Comparison between BlackBerry Curve 8520 and BlackBerry Curve 9360 keyboards HangDown Portable Devices 3 23-10-2011 05:25 AM
Can we generate exe file in php? amitweb007 Software Development 1 26-09-2011 11:38 AM
How to generate content with CSS Eshita The Techie Software Development 5 08-01-2011 10:54 AM
How to use the generate() in CPP Gaelic Software Development 5 15-02-2010 09:08 PM


All times are GMT +5.5. The time now is 12:44 PM.