Average S-Curve

Z
Zq qz 👤 Member for 23 years 1 month
N
Nicholas Sero 👤 Member for 22 years 10 months

I simply use tabular resource tabular report. This will output FULL RANGE cimulative and per period data with the distribution from early start to late finish



I export this to Excel for graphical presentation

Z
Zq qz 👤 Member for 23 years 1 month

Thank you guys, I think P3 dont have this option to generate the average curve directly. So the best way to do is do it in excel. by exportting data from p3. Going to ff menu. Tools - Tabular report - add - select resource - timescale , go to schedule 3 drop down menu then select average. then save with file extensiion ????. Hope this will help

F
Forum Guest 👤 Member for 17 years 5 months

bell shabe curve is called s curve but this will impact that particular activity only not the total project. it is good to apply in larger activities ( like erection of steels 100s of tons or pouring concrete 1000s of cub.meter) since it is a big activity we are loading the activity gradually more and peak in the middle and gradually reducing.



but, what you need, i understand that s curve for the project. it is not suppose to create. when you load the resources to the activities properly in man hours or mandays, you will get the s curve almost all the projects in construction. it means the project would be started increasing works gradually and peak in the middle time and reducing gradually. when you do it properly you will come to know. as far as i did in my projects i got all s curve. note it it cannot be created. depends upon your programing skill u will get when you check in grapical repory. tools, graphics report, resource and cost, u must mark curve both histogram and cumulative.

L
Lutfullah Atasoy 👤 Member for 22 years 11 months

You are correct! You may select resource usage profiles for each activity such as front-loaded, or normal distributed,..etc but primavera (as far as I know) does not take into account an average S-Curve. Also there is no sense doing that.

Instead ,you may utilize exel to create an average S-Curve and compare your outcomes with it.



The formula is:



y=(3/2)^x.Sin[1/2p.(T-x)/T].Sin[p.x/T].Log[x+1/2T]-2.x^3/T^2+3.x^2/T



Where : p is 3,141516

x : elapsed time percentage

y : cumulative project progress

T : Max. Cumulative Progress

a : Curve climbing parameter.



But frankly speaking all these mathematical formulas are created by the people never been at site...!!



Rgrds



Lutfullah

Forum Sponsor

Top Posters

James Williams
74 posts
pennyu
0 posts
jaasland
0 posts
Doron El
3 posts
Erim INANC
2 posts
gorilpk
0 posts
Ricky
0 posts
pinoyplanner
1 posts
Siddharth Ranadive
1 posts
Aidar Kurmantayev
0 posts