Associate a Field w/ a Resource

[TKS_Mark]

We are trying to establish a "throughput" that is associated with a resource.
For instance, the resouce is capable of installing 100 lbs of steel / hour.
We need to use that "throughput" field on the task to calculate the amount of
work. However, in the task view, the field is different for every task. Is
there a way to tie the field to the resouce?

 

[John]

We are trying to establish a "throughput" that is associated with a resource.
For instance, the resouce is capable of installing 100 lbs of steel / hour.
We need to use that "throughput" field on the task to calculate the amount of
work. However, in the task view, the field is different for every task. Is
there a way to tie the field to the resouce?

TKS_Mark,
First, you need to understand the difference between Project's three
object types. Go to our MVP website at:
http://www.mvps.org/project/faqs.htm, and take a look at FAQ 51 - Data
Types: Task, Resource and Assignments.

From your description it doesn't sound like you are looking for a
schedule as much as you are looking for rates and quantities. Project is
a scheduling application and schedules tasks based on the work equation,
Duration (time) = Work (effort)/Units (resources). However what you have
is, Work (effort) = Quantity (item) / Rate (items/time). For that a
spreadsheet would be more appropriate.

John
Project MVP

 

[TKS_Mark]

Thank you John. We will use this for scheduling. It establishes how much
work the task will take. We will start out with fixed work tasks and use
project to determine the units (number of workers or resources) based on the
duration. Is there a way to use a variable that is not related to either a
task or a resource or an assignment?

 

[John]

Thank you John. We will use this for scheduling. It establishes how much
work the task will take. We will start out with fixed work tasks and use
project to determine the units (number of workers or resources) based on the
duration. Is there a way to use a variable that is not related to either a
task or a resource or an assignment?

TKS_Mark,
You're welcome. Project has multiple spare fields of various types (e.g.
cost, number, text, etc.). Any one of those fields can be customized
with a formula (Tools/Customize/Fields). The normal Project fields (e.g.
Duration, Start, Work, etc.) can NOT be customized with a formula but
they can be manipulated using VBA.

So, given your original post, it would be possible to designate a spare
task text field for the total quantity (e.g. 2000 lbs. steel) for a
given task, and a spare resource text field for the rate (e.g. 100
lbs/hr) but then things get a little more complicated. The rate is
associated with a resource and multiple resources may be involved in
performing any given task. The trick is to then translate the individual
resource rates and apply it to the task quantity and then adjust the
task work content accordingly. For this VBA would be your best bet.

John
Project MVP