Duration calculation according different parameters
In the Open Standard
Eric EVRARDMember for 19 years 10 months
- Created
- 0
- 1
0
Hello Everybody,
I am asked to automatically adjust the duration of an activity according the values of differents parameters with P6.
The task is composed of several drawings conception whose duration is depending on the number of drawing to emit and the number of draftman assigned to do the job.
I thought of using the global change function but it seems quite complicated as I have to introduce multiple intermediate calculation.
The formula I would like to use is the following
N:quantity of drawings
D:quantity of draftman
Duration for N drawings = 22+[((N-1)*8)/D*2] if D is unpair I keep the natural value of D/2 ie: D=5 -> I use 2
Another solution would be to export an excel file of the planning,do the calculation with excel and import into P6.
Hope someone can help me
Regards
Eric
I am asked to automatically adjust the duration of an activity according the values of differents parameters with P6.
The task is composed of several drawings conception whose duration is depending on the number of drawing to emit and the number of draftman assigned to do the job.
I thought of using the global change function but it seems quite complicated as I have to introduce multiple intermediate calculation.
The formula I would like to use is the following
N:quantity of drawings
D:quantity of draftman
Duration for N drawings = 22+[((N-1)*8)/D*2] if D is unpair I keep the natural value of D/2 ie: D=5 -> I use 2
Another solution would be to export an excel file of the planning,do the calculation with excel and import into P6.
Hope someone can help me
Regards
Eric
Replies
Oldest firstNo replies yet. Be the first to answer.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?