Material Price Code

[Steve Budzynski]

I know project calculates total costs derived from both material and work
resources. Is there any way to have separate columns for the same task, one
column for material resource cost and one for work resource cost?

I tried to write a custom field but my computer and I do not speak the same
language if you know what I mean! (haha)

Thanks all,


Steve

 

[John]

I know project calculates total costs derived from both material and work
resources. Is there any way to have separate columns for the same task, one
column for material resource cost and one for work resource cost?

I tried to write a custom field but my computer and I do not speak the same
language if you know what I mean! (haha)

Thanks all,


Steve

Steve,
What language is "haha"? Is that the interface language the new Mac has
with that new Japanese camera (as seen on the new Mac ads on TV)?

There are various ways to get what you want and it depends to a certain
degree on how your file is structured. For example, if your plan
separates material related tasks from labor related tasks then you could
set a flag for each and use a formula to capture and add up the values
for each of the flagged tasks.

On the other hand if your plan has tasks with mixed material and labor
costs, it may be possible to create some rather complex formulas to
extract the two types of costs into separate fields but it would be much
easier using VBA.

John
Project MVP

 

[Steve Budzynski]

Steve,
What language is "haha"? Is that the interface language the new Mac has
with that new Japanese camera (as seen on the new Mac ads on TV)?

There are various ways to get what you want and it depends to a certain
degree on how your file is structured. For example, if your plan
separates material related tasks from labor related tasks then you could
set a flag for each and use a formula to capture and add up the values
for each of the flagged tasks.

On the other hand if your plan has tasks with mixed material and labor
costs, it may be possible to create some rather complex formulas to
extract the two types of costs into separate fields but it would be much
easier using VBA.

John
Project MVP

John,

My plan has tasks with mixed material and labor costs that I did want to
separate and I was trying to write the formulas to separate them. You are
correct when you say rather complex! I was afraid it would be easier to use
VBA since I do not speak that language either!

Thanks for your help! I can re-write my plan to separate material and labor
costs by their specific tasks and write a field to calculate them.

If I have any problems I'll be sure to bug you!

Thanks again,

Steve Budzynski

 

[John]

Steve,
What language is "haha"? Is that the interface language the new Mac has
with that new Japanese camera (as seen on the new Mac ads on TV)?

There are various ways to get what you want and it depends to a certain
degree on how your file is structured. For example, if your plan
separates material related tasks from labor related tasks then you could
set a flag for each and use a formula to capture and add up the values
for each of the flagged tasks.

On the other hand if your plan has tasks with mixed material and labor
costs, it may be possible to create some rather complex formulas to
extract the two types of costs into separate fields but it would be much
easier using VBA.

John
Project MVP

John,

My plan has tasks with mixed material and labor costs that I did want to
separate and I was trying to write the formulas to separate them. You are
correct when you say rather complex! I was afraid it would be easier to use
VBA since I do not speak that language either!

Thanks for your help! I can re-write my plan to separate material and labor
costs by their specific tasks and write a field to calculate them.

If I have any problems I'll be sure to bug you!

Thanks again,

Steve Budzynski[/QUOTE]

Steve,
You're welcome and feel free to "bug" us when you have a problem. That's
why we are here.

John
Project MVP