Populate Cost rate automatically

J

joeabe

We are planning to use the Cost Rate Table to pick up costs for each of
the tasks based on the role that each resource will perform. I have
populated cost rate table (A, B, C....) for each of the resource and
also defined an Enterprise Outline code(named it Task Role) that will
specify the role (BA, PM, Developer etc) that is applicable for each
task. Is it possible to write a rule or macro that will look at this
outline code and prefill the Cost Rate Table for each task? For eg if
Task Role is BA use Cost Rate Table A and so on..

Any help would be greatly appreciated!
 
D

Dale Howard [MVP]

Joeabe --

Yes, it is possible to write a macro to perform this procedure. You can get
an idea of some of the code you will need to write simply by recording a
macro to set the Cost Rate Table for a task assignment. Before recording
the macro, apply the Task Usage view. After you begin recording the macro,
simply double-click the name of a resource assigned to a task, set the Cost
Rate Table value for that resource's task assignment, and click OK. View
the results in the Visual Basic Editor window. Hope this helps.
 
Top