Storing of production rates in MSP
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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