If you create 3 Customzed Fields (Units [Number 1], Units/Hr [Number 2], Hrs [Number 3]), you can copy and "paste special link" the Hrs field to the Work field.
Note:
Tasks must be Fixed Duration.
Customized field "Hrs" must be assigned a Custom formula attribute. In my case, "Units/Units/Hr".
It's a hack at best, and not very robust, but I hope it helps.
Member for
18 years
Member for18 years
Submitted by Rubas M. Kutty on Wed, 2008-05-21 10:07
I too feel that attempting formula based calculations might not be feasible with MS project alone. I presume MS Access could be used as the data storage(Production rates)& then can be suitably imported to MSP. What I wished was for an in-built calculation mode within MSP facilitating a drop down menu or a tab & listing the tasks and subtasks accordingly. That would mean quite a big library of combinations of tasks.
Meanwhile, I would try as per Darrens suggestion.
It’s not something that MS Project handles well, if at all, to be perfectly honest. I know Hard Dollar have a module called BID*BUILD that integrates with MS Project and which might help (but it might be an additional cost that you do not want to support).
Other than that it may be a case of playing around with the Unit % and a combination of Fixed Units / Effort Driven task type.
Let me know how you get on and if you find a solution. It would be good to know for future reference.
Regards,
Darren
Member for
24 years 9 months
Member for24 years9 months
Submitted by Vladimir Liberzon on Wed, 2008-05-21 09:35
It is not possible in MSP because resource assignments in MSP have no special features (like production rates, or unit cost) - they are just intersections of resources and activities. You shall try to calculate activity durations basing on production rates using other software and then export calculated durations into MS Project. Maybe MS Access can do this. I did not try, because in Spider Project which I use these calculations are standard and production rates databases can be created (or imported) in the program.
Member for
11 years 6 monthsIf you create 3 Customzed
If you create 3 Customzed Fields (Units [Number 1], Units/Hr [Number 2], Hrs [Number 3]), you can copy and "paste special link" the Hrs field to the Work field.
Note:
Tasks must be Fixed Duration.
Customized field "Hrs" must be assigned a Custom formula attribute. In my case, "Units/Units/Hr".
It's a hack at best, and not very robust, but I hope it helps.
Member for
18 yearsRE: Storing of production rates in MSP
Thanks Vladimir & Darren,
I too feel that attempting formula based calculations might not be feasible with MS project alone. I presume MS Access could be used as the data storage(Production rates)& then can be suitably imported to MSP. What I wished was for an in-built calculation mode within MSP facilitating a drop down menu or a tab & listing the tasks and subtasks accordingly. That would mean quite a big library of combinations of tasks.
Meanwhile, I would try as per Darrens suggestion.
Kind regards,
Rubas
Member for
17 years 9 monthsRE: Storing of production rates in MSP
Hi Rubas,
It’s not something that MS Project handles well, if at all, to be perfectly honest. I know Hard Dollar have a module called BID*BUILD that integrates with MS Project and which might help (but it might be an additional cost that you do not want to support).
Other than that it may be a case of playing around with the Unit % and a combination of Fixed Units / Effort Driven task type.
Let me know how you get on and if you find a solution. It would be good to know for future reference.
Regards,
Darren
Member for
24 years 9 monthsRE: Storing of production rates in MSP
It is not possible in MSP because resource assignments in MSP have no special features (like production rates, or unit cost) - they are just intersections of resources and activities. You shall try to calculate activity durations basing on production rates using other software and then export calculated durations into MS Project. Maybe MS Access can do this. I did not try, because in Spider Project which I use these calculations are standard and production rates databases can be created (or imported) in the program.
Regards,
Vladimir