TimePhased Values in Formulas

[Dan]

All,

Is there a way to use Time Phased Values in a custom Field Formula?

For example,
I would like to calc BCWS in hours for a task using Baseline Work TimePhased
Values.

We don't use rates in our projects (Very complex rates constantly
changing)so I can't use Projects Calculated BCWS.

Thanks for any help.

 

[John]

Dan,
The answer is "no" and "yes". No, it cannot be done directly within
Project but yes, it can be done with the help of VBA. My preferred
approach for this type of problem is to develop a custom VBA macro that
gathers the necessary data from Project, manipulates it however
necessary, and then exports it to Excel. In my opinion this is the best
way to customize timescale data. In your case, a user interface or
simple query can be included with the VBA code to utilize the complex
changing rates.

If you are not experienced with VBA we could help you or you could try
the "analyze timescale data in Excel" add-in found on the Analysis
toolbar. It will produce different formats depending on whether it is
run from the Gantt, Task Usage or Resource Usage views and, it will not
export custom field data or most of the other Project static fields.
However a separate export map can be used for static fields not exported
by the add-in. With some manual manipulation of the data once it is in
Excel, you can probably get close to what you want.

Hope this helps.
John