Cost Rate Table (view all rates)

[Debbie]

My client has a defined Standard Rate as well as four other rates listed in
the cost rate table.

My client would like to see the standard rate as well as all cost rates
listed in the resource table. For instance, we have Cost Rate A (the
standard rate). We have cost rates B - E. The cost rate column can only be
added in the task usage view. Then the rates can only be listed as a, b, c,
d, or e with no numeric value.

In othe words the client would like to see the cost rates listed in a view
similar to a spreadsheet with all of the numeric rates laid out. The client
wants to be able to see all of the cost rates in a numeric value in the
resource sheet.

Is this possible? I don't think so. Any help is appreciated.

 

[Dale Howard [MVP]]

Debbie --

Bad news. The Standard Rate column displays the rate on the Cost Rate Table
A page, but it is not possible to displays the rates from Cost Rate Tables
B-E. If your client wishes to see the Cost Rate Table applied to any
assignment, you can apply either the Task Usage or Resource Usage view and
then insert the Cost Rate Table column. Hope this helps.

 

[Debbie]

Thank you so much for all of your assistance today!
--
dberryhill

Debbie --

Bad news. The Standard Rate column displays the rate on the Cost Rate Table
A page, but it is not possible to displays the rates from Cost Rate Tables
B-E. If your client wishes to see the Cost Rate Table applied to any
assignment, you can apply either the Task Usage or Resource Usage view and
then insert the Cost Rate Table column. Hope this helps.

 

[Dale Howard [MVP]]

Debbie --

You are more than welcome, my friend!

Thank you so much for all of your assistance today!

 

[JulieS]

Hi Debbie & Dale,

Pardon me for jumping in here. If what you wish to do is show the
Resource Rates for each rate table in either the Resource View or the
Resource Usage view you can run the code below:
[Big Fat Disclaimer: This is *very* crude code and I am sure it can be
re-written by folks who know VBA better than I, but it does do what I
*think* you are looking for]
======================================================
Sub PayRatesByResource()
Dim R As Resource

For Each R In ActiveProject.Resources
If Not R Is Nothing Then
R.Text1 = R.CostRateTables("A").PayRates(1).StandardRate
R.Text2 = R.CostRateTables("B").PayRates(1).StandardRate
R.Text3 = R.CostRateTables("C").PayRates(1).StandardRate
R.Text4 = R.CostRateTables("D").PayRates(1).StandardRate
R.Text5 = R.CostRateTables("E").PayRates(1).StandardRate

End If
Next R
CustomFieldRename FieldID:=pjCustomResourceText1,NewName:="Rate A"
CustomFieldRename FieldID:=pjCustomResourceText2, NewName:="Rate B"
CustomFieldRename FieldID:=pjCustomResourceText3, NewName:="Rate C"
CustomFieldRename FieldID:=pjCustomResourceText4, NewName:="Rate D"
CustomFieldRename FieldID:=pjCustomResourceText5, NewName:="Rate E"

End Sub
======================================================
If you insert Text1, Text2, Text3, Text4, and Text5 in either the
Resource Table or the Resource Usage view this should then show you each
Rate from Rate table A (in Text1) , Table B (Text2), Tabel C (Text3),
Table D (Text4), and TableE (Text5)

I hope this helps.

Julie

Thank you so much for all of your assistance today!

 

[Debbie]

Thank you so much! I will give it a look!
--
dberryhill

Hi Debbie & Dale,

Pardon me for jumping in here. If what you wish to do is show the
Resource Rates for each rate table in either the Resource View or the
Resource Usage view you can run the code below:
[Big Fat Disclaimer: This is *very* crude code and I am sure it can be
re-written by folks who know VBA better than I, but it does do what I
*think* you are looking for]
======================================================
Sub PayRatesByResource()
Dim R As Resource

For Each R In ActiveProject.Resources
If Not R Is Nothing Then
R.Text1 = R.CostRateTables("A").PayRates(1).StandardRate
R.Text2 = R.CostRateTables("B").PayRates(1).StandardRate
R.Text3 = R.CostRateTables("C").PayRates(1).StandardRate
R.Text4 = R.CostRateTables("D").PayRates(1).StandardRate
R.Text5 = R.CostRateTables("E").PayRates(1).StandardRate

End If
Next R
CustomFieldRename FieldID:=pjCustomResourceText1,NewName:="Rate A"
CustomFieldRename FieldID:=pjCustomResourceText2, NewName:="Rate B"
CustomFieldRename FieldID:=pjCustomResourceText3, NewName:="Rate C"
CustomFieldRename FieldID:=pjCustomResourceText4, NewName:="Rate D"
CustomFieldRename FieldID:=pjCustomResourceText5, NewName:="Rate E"

End Sub
======================================================
If you insert Text1, Text2, Text3, Text4, and Text5 in either the
Resource Table or the Resource Usage view this should then show you each
Rate from Rate table A (in Text1) , Table B (Text2), Tabel C (Text3),
Table D (Text4), and TableE (Text5)

I hope this helps.

Julie

Thank you so much for all of your assistance today!

 

[JulieS]

You're welcome Debbie and thanks for the feedback. Let us know how you
get along.

Julie

Thank you so much! I will give it a look!
--
dberryhill

Hi Debbie & Dale,

Pardon me for jumping in here. If what you wish to do is show the
Resource Rates for each rate table in either the Resource View or the
Resource Usage view you can run the code below:
[Big Fat Disclaimer: This is *very* crude code and I am sure it can
be
re-written by folks who know VBA better than I, but it does do what I
*think* you are looking for]
======================================================
Sub PayRatesByResource()
Dim R As Resource

For Each R In ActiveProject.Resources
If Not R Is Nothing Then
R.Text1 = R.CostRateTables("A").PayRates(1).StandardRate
R.Text2 = R.CostRateTables("B").PayRates(1).StandardRate
R.Text3 = R.CostRateTables("C").PayRates(1).StandardRate
R.Text4 = R.CostRateTables("D").PayRates(1).StandardRate
R.Text5 = R.CostRateTables("E").PayRates(1).StandardRate

End If
Next R
CustomFieldRename FieldID:=pjCustomResourceText1,NewName:="Rate
A"
CustomFieldRename FieldID:=pjCustomResourceText2, NewName:="Rate
B"
CustomFieldRename FieldID:=pjCustomResourceText3, NewName:="Rate
C"
CustomFieldRename FieldID:=pjCustomResourceText4, NewName:="Rate
D"
CustomFieldRename FieldID:=pjCustomResourceText5, NewName:="Rate
E"

End Sub
======================================================
If you insert Text1, Text2, Text3, Text4, and Text5 in either the
Resource Table or the Resource Usage view this should then show you
each
Rate from Rate table A (in Text1) , Table B (Text2), Tabel C (Text3),
Table D (Text4), and TableE (Text5)

I hope this helps.

Julie

Thank you so much for all of your assistance today!
--
dberryhill



:

Debbie --

Bad news. The Standard Rate column displays the rate on the Cost
Rate Table
A page, but it is not possible to displays the rates from Cost
Rate
Tables
B-E. If your client wishes to see the Cost Rate Table applied to
any
assignment, you can apply either the Task Usage or Resource Usage
view and
then insert the Cost Rate Table column. Hope this helps.




My client has a defined Standard Rate as well as four other
rates
listed
in
the cost rate table.

My client would like to see the standard rate as well as all
cost
rates
listed in the resource table. For instance, we have Cost Rate A
(the
standard rate). We have cost rates B - E. The cost rate column
can only
be
added in the task usage view. Then the rates can only be listed
as
a, b,
c,
d, or e with no numeric value.

In othe words the client would like to see the cost rates listed
in
a view
similar to a spreadsheet with all of the numeric rates laid out.
The
client
wants to be able to see all of the cost rates in a numeric value
in
the
resource sheet.

Is this possible? I don't think so. Any help is appreciated.