How do I create additional Currency Rate fields

[Lee Anderson]

I have a problem by which I would like to display two sets of costs against
named resources within a plan that I have:

External Charge (Using the Standard Rate and existing calculated Cost
fields) Internal Charges (??????)

I have so far tried everything I can think of and as yet I have not come up
with a correct answer - can anyone please help me as it is driving me mad!!!!!

 

[John]

I have a problem by which I would like to display two sets of costs against
named resources within a plan that I have:

External Charge (Using the Standard Rate and existing calculated Cost
fields) Internal Charges (??????)

I have so far tried everything I can think of and as yet I have not come up
with a correct answer - can anyone please help me as it is driving me mad!!!!!

Lee,
This question has often been asked and answered in this newsgroup.
Basically what you need to do is to use separate resource cost rate
tables for each rate type. The normal Std Rate field shown in the
Resource Sheet is actually cost rate table "A". One way to view and
configure cost rate tables "B", "C", "D" and "E" is by selecting a
resource and going to Project/Resource Information/Costs tab.

To calculate costs for different cost rate tables, go to the Resource
Usage view and add the Cost Rate Table field as a column. You can then
select which cost rate table to use for each resource assignment. A
little filtering and fill down makes it easy to switch between cost rate
tables for all resource assignments.

Hope this helps.
John
Project MVP

 

[Lee Anderson]

That's great - Thanks John

Lee,
This question has often been asked and answered in this newsgroup.
Basically what you need to do is to use separate resource cost rate
tables for each rate type. The normal Std Rate field shown in the
Resource Sheet is actually cost rate table "A". One way to view and
configure cost rate tables "B", "C", "D" and "E" is by selecting a
resource and going to Project/Resource Information/Costs tab.

To calculate costs for different cost rate tables, go to the Resource
Usage view and add the Cost Rate Table field as a column. You can then
select which cost rate table to use for each resource assignment. A
little filtering and fill down makes it easy to switch between cost rate
tables for all resource assignments.

Hope this helps.
John
Project MVP

 

[John]

That's great - Thanks John

Lee,
You're welcome and thank for the feedback.
John

 

[Lee Anderson]

John,

Is there anyway that by using the rates I have specified in the Cost Rate
table, calculate an "Internal Cost" in one of the cost custom fields - so
that I can have an Interanla and External Cost per resource, for the work
assigned to them? Would this have to be done using VBA or the like? Do you
know of any example code if so.

Thanks
Lee

 

[John]

John,

Is there anyway that by using the rates I have specified in the Cost Rate
table, calculate an "Internal Cost" in one of the cost custom fields - so
that I can have an Interanla and External Cost per resource, for the work
assigned to them? Would this have to be done using VBA or the like? Do you
know of any example code if so.

Thanks
Lee

Lee,
Is there any way? Of course, there is always a way. In this particular
case however, it will require VBA.

The following code will take the first pay rate of cost rate table "B"
for each resource and put that value in spare resource Cost1. Note:
Resource Cost1 is not the same field as Task Cost1 nor is it the same
field as Assignment Cost1.

Sub extcost()
Dim r As Resource
For Each r In activeproject.Resources
ResRat = r.CostRateTables("B").PayRates(1).StandardRate
Conv = Mid(ResRat, 2, InStr(1, ResRat, "/") - 2)
r.Cost1 = r.Work / 60 * CSng(Conv)
Next r
End Sub

John
Project MVP

 

[Lee Anderson]

That's brilliant - I'll use that example - thanks John!

Lee

 

[John]

That's brilliant - I'll use that example - thanks John!

Lee

Lee,
You're welcome and thanks for the feedback.

John