How to produce time scaled cost table other than total costs

[Arnaud]

I want to use MSproject to produce a budget over time.
However I want to go further than only Total costs. I
customized cost fields to compute other costs. (for
instance "cost by source of funding" or "taxes" or "cost
by type of currency".) I want such costs displayed in a
table similar to the task usage table. However task usage
does not allow the customized fields in the "available
fields" option.
Could the analyze timescaled data in excel be the solution?
Thanks for any help on that.

 

[John]

Arnaud,
Custom fields in Project are "static", that is, they cannot be
configured to calculate or display timescaled data. You could use the
"analyze timescale data in Excel" add-in to transfer timescaled data
fields but you will then have to create formulas in Excel to calculate
and spread the your custom values over time. A much better method, in my
opinion, is to create a custom VBA macro that creates whatever timescale
data you need from the Project data fields and then exports it to Excel.
The same macro can easily format your timescale budget information into
a report. I have successfully used this method many times.

Hope this helps.
John

 

[John]

Arnaud,
You sent me a direct e-mail with additional question. I replied but your
mail server rejected my reply. I have no other way to get ahold of you.

John