Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Resource Curve in Excel

In the Open Standard
Kumar JMember for 25 years 3 months
Created
3
3
0
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
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Wjm014 ·
    #1

    Resource Curve

    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.

    Report
  2. 0
    Shareef Abdul Azeez ·
    #2

    hi Bharat

    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

    Report
  3. 0
    Daniel Limson ·
    #3

    Resource Curve in Excel

    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

     

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?