Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Resource Curve in Excel

3 replies [Last post]
Thu, 2010-09-02 04:19
Kumar J
User offline. Last seen 5 years 33 weeks ago. Offline
Joined: 24 Jun 2001
Posts: 21
Groups: Petro-Chem / Oil & Gas
Dear Friends,

In Primavera there are different resource curves available. Similarly is it possible to develop in excel. Like we will have total manhours for the certain duration for each discipline. I like to distribute these manhours for each month either in bell shaped, linear, front / back loaded etc.,. Is there any formula or VBA or any method to do the same in excel.

Or anyone knows the formula or method which Primavera adopts to distribute resources for each period based on the selection of the type of resource curve.

Thanks / Regards,
Bharath Kumar J
Top

Replies

Thu, 2010-09-16 10:14
#1
Daniel Limson
User offline. Last seen 4 years 38 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None

Hi Bharath,

You are right, in P3 there are different progress curves you can assign to each activity and you can even customised it. You can basically adopt the default distribution in P3 represented in perentages, however in excel, this will depend on the duration of the activity and you need to make your own judgement on how you want to distribute the weightings. First you need to judge on what type of progress curve you need to apply for each activity, i.e. linear, bell type, front load, back load, etc. and then you decide on the percentage distribution.

Best regards,

Daniel

 

Top
Wed, 2010-09-15 13:13
#2
Shareef Abdul Azeez
User offline. Last seen 2 years 42 weeks ago. Offline
Joined: 19 Sep 2005
Posts: 183
Groups: Civil Engineering, GPC Qatar

http://en.wikipedia.org/wiki/Gaussian_function

 

This is the equation for a bell shaped curve.

You can use this to get the y coodinates for the curve . this can be used to get the percentage distribution which can then be used to spread your manhour data in excel.

 

Alternatively you could get the percentage used by primavera to spread the data corresponding to each curve and use it in excel.

 

 

 

Best Regards

Shareef

Top
Wed, 2010-09-15 05:22
#3
wjm014
User offline. Last seen 9 years 21 weeks ago. Offline
Joined: 15 Sep 2010
Posts: 15
Groups: None

My understanding is that Primavera distributes the resource or cost at the activity level of detail. I was not aware that distributions were made by time period.

Top