(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.
During my experience in few company, I found a kind of table to draw our s-curve, you can choose a number of period and you have the forcast corresponding of this period, the periode can be (hour, day, week or month), for exemple :
Number of period 4 / period( 1) 13.20% / period( 2) 27.50% / period(3) 36.40% / period(4) 22.90%
With this value you can draw your s-curve, DO you have any information about it ? or the function that you can insert only the number of period and you have the percent that you mus achieve in each period ?
Printer-friendly version
Send to friend
excell functions
norm.dist
stdev.s
gives bell shape curve
You can use Curve Fitting Software to get a formula that fits your scurve shape.
Then using Excel you can make use of the formula to get the numbers.
http://www.mediafire.com/file/vd0at7qvc10cp9z/Scurve_Fitting.xlsx/file
Good Luck
What about C1 and C2 ?
I know that but i want to determinate de fonction that gives me the percent function of the number of period ? to draw the s-curve you see ?
activity #1 month #1 = 1320 hours
activity #2 month #2 = 2750 hours
activity #3 month #3 = 3640 hours
actviity #4 month #4 = 2290 hours
Sorry for the confusion, I will try to explain, for exemple I have to achive a Task in 4 month with a Manhours of 10000 hours,
Number of period 4 / period( 1) 13.20% / period( 2) 27.50% / period(3) 36.40% / period(4) 22.90% it means:
The first month my progress need to be 13.20% or 1320 hours and the second month 27.50% it means 2750 hours in period and 4070 hours cumulative .... you see ?
percent progress of what ? what is your measuing stick ?
so are you saying for example that you have 100 activities and 50 of them are done then you are 50% complete ?
each activity does not have athe same weighted value in terms of dollars, manhours, commodity units or even duration so you can use that.
As Zoltan says, Cost loaded Schedule will generate the near realistic Forecast and S-Curve.
Otherwise, your Target is Nowhere.
It's mesured forcast percent of progress
you have not mentioned what the curved is measuing what is the measuing stick ?
why do that ? why not cost load or manhour load each actvity and let the program draw the curve for you ?
Email: PPadmin@planningplanet.com
Replies