You have to consider that there are several types of curves in a certain schedule. At least: Early Curve; Late Curve (based on planned data) and Actual Curve. The Data Date determines where you are at a certain time. And ideally, all data at the left of the data date should be actuals, and everything on the right shall be planned. Of course your calculations shall be based on cumulative weighted percentage that boils down to 100% whether based or using Quantities or Currencies. Each WBS level should have corresponding weight percent as well, which shall come down to 100% with the sum product of activities under it. And the total of all WBS should also come down to 100% which shall represent the whole project. I hope this clears the confusion.
Member for
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Sun, 2019-01-13 00:10
Where C1 and C2 are the parameters to control both: whether the curve is front or back loaded, and the level of knowledge the executor has about the project's subject.
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 ?
Member for
10 years 5 months
Member for10 years5 months
Submitted by venkatesan kumar on Thu, 2019-01-10 10:40
your calculation period looks like a fiscal year Method, it contains 4 No. Of Quarters in the fiscal year. According to Fiscal year forecast, the assigned period calculation is the achievement of each quarter of the fiscal year. master schedule holds the complete plan of the fiscal year achievement.
It is just linear. For example: X and Y axis or Columns and Rows. Where Columns represent Time or Period (Constants) and Rows represent Scope (or Variables) with corresponding Units, Quantities and Costs (as perhaps you have seen in your BOQ). You simply equate Scope with Time and that's all (period).
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Wed, 2019-01-09 13:52
Member for
16 years 11 monthsexcell
excell functions
norm.dist
stdev.s
gives bell shape curve
Member for
19 years 1 monthYou have to consider that
You have to consider that there are several types of curves in a certain schedule. At least: Early Curve; Late Curve (based on planned data) and Actual Curve. The Data Date determines where you are at a certain time. And ideally, all data at the left of the data date should be actuals, and everything on the right shall be planned. Of course your calculations shall be based on cumulative weighted percentage that boils down to 100% whether based or using Quantities or Currencies. Each WBS level should have corresponding weight percent as well, which shall come down to 100% with the sum product of activities under it. And the total of all WBS should also come down to 100% which shall represent the whole project. I hope this clears the confusion.
Member for
21 years 8 monthsYou can use Curve Fitting
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
Member for
16 yearsWhat about C1 and C2 ?
What about C1 and C2 ?
Member for
17 years 7 monthsYou can use a theoretical S
You can use a theoretical S curve equation like:
Y = X / ( X + Exp(C1-C2*X) )
Where C1 and C2 are the parameters to control both: whether the curve is front or back loaded, and the level of knowledge the executor has about the project's subject.
Member for
16 yearsI know that but i want to
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 ?
Member for
16 years 3 monthsactivity #1 month #1 = 1320
activity #1 month #1 = 1320 hours
activity #2 month #2 = 2750 hours
activity #3 month #3 = 3640 hours
actviity #4 month #4 = 2290 hours
Member for
16 yearsSorry for the confusion, I
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 ?
Member for
10 years 5 monthsHiyour calculation period
Member for
19 years 1 monthIt is just linear. For
It is just linear. For example: X and Y axis or Columns and Rows. Where Columns represent Time or Period (Constants) and Rows represent Scope (or Variables) with corresponding Units, Quantities and Costs (as perhaps you have seen in your BOQ). You simply equate Scope with Time and that's all (period).
Member for
16 years 3 monthspercent progress of what ?
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.
Member for
15 years 11 monthsAs Zoltan says, Cost loaded
As Zoltan says, Cost loaded Schedule will generate the near realistic Forecast and S-Curve.
Otherwise, your Target is Nowhere.
Member for
16 yearsIt's mesured forcast percent
It's mesured forcast percent of progress
Member for
16 years 3 monthsyou have not mentioned what
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 ?