engineer12345 said:
Hello All,
I cant export "cost A and Cost B " to excell,
(I have 2 different cost rate for each resource )
Would you pls help me?
Regards
engineer12345,
There are a couple of ways to do what you want. Assuming you are
referring to cost rate tables "A" and "B", one way to set it up is to
first use the normal Cost data (Cost rate table "A" is the default) and
use either an export map or the "analyze timescale data in Excel" (for
timescaled data) to export the first cost data. Then go to the Resource
Usage view and insert the Cost Rate Table field as a column. Change the
cost rate table for each assignment row and then repeat the export as
before. Note, you could filter on the Assignment field and use a fill
down to facilitate the conversion between cost rate tables on the
assignment rows.
After you have finish performing the two exports, manipulate the data in
Excel as desired.
The second method is to use a VBA macro to export all the data for both
cost rates at one time. This method is less prone to human error and
saves a lot of time but it of course does require knowledge of Project
VBA.
Hope this helps.
John
Project MVP
