Convert currencies planning costs

[Grigory Bushuev]

I must convert currencies planning costs for all projects. I must multiply
planning costs for all projects by the factor. How can I do it?

 

[John]

I must convert currencies planning costs for all projects. I must multiply
planning costs for all projects by the factor. How can I do it?

Grigory,
Well, what exactly do you mean by "planning costs"? Is that everything
in the Cost field? Is it only those costs associated with certain tasks
or resources? Or what?

If it is a direct factor that needs to be applied to resource pay rates,
that can be done in a couple of ways. It can of course be done manually
or it can be done using a VBA macro that updates the PayRates Property
of the Resources or CostRateTables collections.

On the other hand, if you simply need to apply a factor to one of the
Cost fields, that can be done with a formula in a custom field.

John
Project MVP

 

[Grigory Bushuev]

Hi, John! Thank you for your reply.

Well, what exactly do you mean by "planning costs"? Is that everything
in the Cost field?

It's a bases costs of project, which is sum of base costs of project tasks

Is it only those costs associated with certain tasks

or resources? Or what?

Is it only those costs associated with certain tasks.

On the other hand, if you simply need to apply a factor to one of the
Cost fields, that can be done with a formula in a custom field.

How can i do it by sql update? Or easy way to do it by MS Project client, my
PM don't wan't to do it with each task.