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