S- Curve Calculation and chart
 

Dear All,
I have to prepare S-curve for the Project with following informarion
Project Duration : 30 Months
Project Cost : 90,000,000
Note : I tried Total Cost / Duration = Monthly work done amount

I need calculation based on S- Curve
Please do the need ful at the earliest.
Wish you all a very happy New year-2010

Answer: S- Curve Calculation and chart
 

Hello! Happy New Year to you too!

To create an S-curve in Excel, you will need to follow these steps:

1. Open a new Excel spreadsheet and create a table with the following columns: Month, Planned Cost, Actual Cost, and % Complete.
   
2. In the Month column, list out all the months of your project duration. In your case, it would be 30 months.
   
3. In the Planned Cost column, enter the total project cost of 90,000,000. This will be the same for every month.
   
4. In the % Complete column, enter the percentage of the project that is expected to be completed in each month. For example, if you expect to complete 10% of the project in the first month, enter 10% in the % Complete column for that month.
   
5. In the Actual Cost column, enter the actual cost of the project for each month. This will be calculated using the Planned Cost and % Complete columns. To calculate the actual cost for a given month, multiply the Planned Cost by the % Complete. For example, if the Planned Cost is 90,000,000 and the % Complete is 10%, the actual cost for that month would be
   Code:

   ---

   9,000,000

   ---

   .
   
6. Once you have entered all the data, you can create a chart by selecting the Month and Actual Cost columns, and then clicking on the Insert tab and selecting the Line chart option. This will create a basic S-curve chart.
   
7. You can customize the chart by adding titles, labels, and formatting options. For example, you may want to add a title that says "Project S-Curve" and label the x-axis as "Months" and the y-axis as "Cost". You can also change the color and style of the chart to make it more visually appealing.
   

That's it! You should now have a complete S-curve chart for your project. Let me know if you have any questions or need further assistance.

S- Curve Calculation and chart
 

Background:
http://www.visitask.com/s-curve.asp

Now, try this:
http://www.ozgrid.com/forum/showthread.php?t=32857

Or this:
http://leeds-faculty.colorado.edu/La...rve/scurve.htm

This may work for you too:
http://farestplanner.wordpress.com/2...urve-in-excel/

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"vmohan1978" wrote:

Dear All,
I have to prepare S-curve for the Project with following informarion
Project Duration : 30 Months
Project Cost : 90,000,000
Note : I tried Total Cost / Duration = Monthly work done amount

I need calculation based on S- Curve
Please do the need ful at the earliest.
Wish you all a very happy New year-2010

S- Curve Calculation and chart
 

Excel 2007
S Curve
With parameter controls and chart.
Mark up and upload for further help.
http://www.mediafire.com/file/jyzgmz2fyql/12_27_09.xlsx
http://c0444202.cdn.cloudfiles.racks.../12_27_09.xlsx

S- Curve Calculation and chart
 

Dear All Thank you for your feed back .
unfortunately i am not getting wht i required it is hsowing differently .


"ryguy7272" wrote:

Background:
http://www.visitask.com/s-curve.asp

Now, try this:
http://www.ozgrid.com/forum/showthread.php?t=32857

Or this:
http://leeds-faculty.colorado.edu/La...rve/scurve.htm

This may work for you too:
http://farestplanner.wordpress.com/2...urve-in-excel/

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"vmohan1978" wrote:

Dear All,
I have to prepare S-curve for the Project with following informarion
Project Duration : 30 Months
Project Cost : 90,000,000
Note : I tried Total Cost / Duration = Monthly work done amount

I need calculation based on S- Curve
Please do the need ful at the earliest.
Wish you all a very happy New year-2010