Re: How do I create additional Currency Rate fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In article <047C5A8A-7494-48F5-82D9-2FFC45DC25E0@xxxxxxxxxxxxx>,
Lee Anderson <LeeAnderson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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

"John" wrote:

In article <2FE2712C-AB81-4069-ACF7-FD9209735B3C@xxxxxxxxxxxxx>,
Lee Anderson <LeeAnderson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

That's great - Thanks John

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

In article <4CE8946A-E02D-47ED-8132-0915EB96E26E@xxxxxxxxxxxxx>,
Lee Anderson <Lee Anderson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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 *** 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


.

Quantcast