Storing of production rates in MSP
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
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.
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
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
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