As mentioned by Alex, divide Your work in smallest work packages, for each work packge go more in detail up to your control level (is an engineering or construction project or better and EPC).
Load all the activities with man-hours, costs, then use toold graphic function of P3 and make the hystogram of the costs (bar and cumulative) You will have your S-curve, based on cost, good also for further EVA analysis.
If You want to make it in excel use instead tool report, generate the report in csv, so you can easly make the chart.
What You were telling us about percentage at certain time of the project, You can put some milestone in Your project at their achievement. So if You are sure of the logic, see the group of works that is giving your required percentage and then put a milestone at their end, so You can also easily monitor if You will be in delay or ahead.
IMHO the reason why the S-Curve is S shape is due to the nature of the work breakdown sturture (WBS) if you only have one activity per project yes you can use the resource distribution curve to drive your s-curve shape. However, as a planner you have to divid your works into a smaller manageable size of activities and load them with the corresponding % of work load then schedule them into the right time and logic. And that is how you obtain your resource curve. It may vary from project to project but it is a lot accurate than one activity with a res dist. curve.
we have to maintain a certain percenatges when we start to cost load the project
at the first 3 monthes we have to get 12.5% and the 2nd quarter we will get 50% at the following quarter we will get 75% at the end we will get 100 %..
this percenages will lead to a bill or like S-shape curve.
If you consider that a curve is generated by cost(or quantity) values from each individual activity, being distributed between the Early (or Late) dates of an activity, then the "shape" of the curve is dictated by the distribution of such cost(or quantity) values, whatever shape that takes. And enforcing a standard "shape" is, IMHO wholly incorrect.
Member for
23 years 9 monthsRE: S-Curve Shape
Hi,
thank you for your time.
If it is possible to see example of this calculations in excel sheet,would be appreciated.
my email: ahamouda@hotmail.com
Ali Hamouda
==========================================
Member for
21 years 5 monthsRE: S-Curve Shape
ali how are i expexting mail from you
Member for
22 years 3 monthsRE: S-Curve Shape
As mentioned by Alex, divide Your work in smallest work packages, for each work packge go more in detail up to your control level (is an engineering or construction project or better and EPC).
Load all the activities with man-hours, costs, then use toold graphic function of P3 and make the hystogram of the costs (bar and cumulative) You will have your S-curve, based on cost, good also for further EVA analysis.
If You want to make it in excel use instead tool report, generate the report in csv, so you can easly make the chart.
What You were telling us about percentage at certain time of the project, You can put some milestone in Your project at their achievement. So if You are sure of the logic, see the group of works that is giving your required percentage and then put a milestone at their end, so You can also easily monitor if You will be in delay or ahead.
Member for
22 years 8 monthsRE: S-Curve Shape
Amazing how you came up with your s-curve
IMHO the reason why the S-Curve is S shape is due to the nature of the work breakdown sturture (WBS) if you only have one activity per project yes you can use the resource distribution curve to drive your s-curve shape. However, as a planner you have to divid your works into a smaller manageable size of activities and load them with the corresponding % of work load then schedule them into the right time and logic. And that is how you obtain your resource curve. It may vary from project to project but it is a lot accurate than one activity with a res dist. curve.
Member for
16 years 9 monthsRE: S-Curve Shape
This is the wrong way to do it
Member for
16 years 9 monthsRE: S-Curve Shape
For the purpose of Planned Values.
we have to maintain a certain percenatges when we start to cost load the project
at the first 3 monthes we have to get 12.5% and the 2nd quarter we will get 50% at the following quarter we will get 75% at the end we will get 100 %..
this percenages will lead to a bill or like S-shape curve.
any comment will be appreciated
thanks
Ali
#########################################
Member for
16 years 9 monthsRE: S-Curve Shape
If you consider that a curve is generated by cost(or quantity) values from each individual activity, being distributed between the Early (or Late) dates of an activity, then the "shape" of the curve is dictated by the distribution of such cost(or quantity) values, whatever shape that takes. And enforcing a standard "shape" is, IMHO wholly incorrect.
Member for
23 years 8 monthsRE: S-Curve Shape
Consider a bell shape distribution to each item which can be distributed throughout the project.