S Curve - To show earned value

[RobSA]

Hi guys,


I am trying to find an excel spreadsheet that when I enter data it will produce an S curve ?


Any help here would be most appreciated ?


Regards

Rob

 

[Mike86]

When you say an "S" curve, do you mean something like Y=X^3 or do you want multiple Y values to be generated by a single X value?

 

[RobSA]

Hi Mike,


Basically it is the spread of costs over time.


As the projects starts the slope will be low (starting at 0) and gradually progress upward.


The curve changes direction once the work tapers of and moves to its end.

 

[Hui]

Robsa


You mean like cumulative normal distribution curve?


When you say "enter data", what data do you have ?

 

[RobSA]

Hi Hui,


Yes- a "simple" progress completion chart. The chart is sometimes used by project managers to plot the progress of a project and at a glance you can see if youre ahead / behind and compare it to other tings like the resources you have or have not.


A draw down chart does a similar thing.


I want to develop this chart for quality purposes and see the influences late interventions by management has on a construction project.


Thanks for your responses.

 

[RobSA]

Hi Hui,


Here is a link for what I am looking at


https://www.dropbox.com/sh/fxha3cu3y2llvm9/xkE8eRGxz1?m


Regards

Rob

 

[Faseeh]

Hi RobSA,


Kindly see this file might it help you??


http://dl.dropbox.com/u/60644346/Project_S_Curve.xlsx


Regards,

Faseeh

 

[RobSA]

Hi Faseeh,


I will have a look at the link.


I appreciate your help.


Regards

Rob