Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

S- Curve

2 replies [Last post]
Alexandre Carneiro
User offline. Last seen 16 years 32 weeks ago. Offline
Joined: 4 Jun 2008
Posts: 3
Hello. Good Afternoon. I want to create a S- Curve to control the schedule of the project and to compare planned and real status of an activity. First of all, I would like to know what I have to do to create this curve using excel. Second, when I have a graph that shows in the X axis time and in the Y axis %completed of an activity and I say that this is a 60% S curve it means:
1- After completing 50% of the activity I have 60% of time running or
2- After 50% of time completed, I have 60% of the activiy conmpleted.
Finally, I would like to know, how I can create this 60%- S curve
My thanks in advance
Carneiro, Alexandre

Replies

Daniel Limson
User offline. Last seen 5 years 25 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None
First you need to define your "unit of measure" If you are talking about the whole project, you can either use manhours (time) or cost (Money). You can resource load your programme either using excel or P3 or any other planning tools and then produce a weekly or monthly output (tabular report) depending on the projects requirement.
In P3 you can define what type of curve is suitable to meet your so called 60% curve (linear,front load, back load, bell curve, etc.) or you can manually calculate and adjust the the output to meet your requirement.

I presumed you already know how to create a progress chart in excel. If you have anymore queries, please let us know.

Best regards,
Daniel

Raphael M. Dua
User offline. Last seen 24 weeks 5 hours ago. Offline
Alexandre

Primavera and Micro Planner X-Pert will create S-Curves as part of the EVPM process that is built into these products
Visit www.microplanning.co.uk and download a copy of Micro Planner X-Pert and develop your plan in a proper planning and scheduling tool and not in Excel

Raf