Looking for Formulas for Earned Value Fields

[Brent99Admin]

I'm working with a client that is tracking Earned value in
terms of labor hours and they would like to track some EV
metrics in a time-phased view (such as the Task Usage).

The fields they are using are custom fields [Number 18-20]
for the labor hours but they are only at a single point in
time. We need to show these fields in a timephased view
and be able to cut/paste or extract to Excel.

Is it possible to easily capture timephased information
for custom fields? Where in the schema is this data
stored and can it be displayed in Project using native
functionality or will this require VBA or special formulas?

Is it possible to get the actual formulas that Microsoft
uses to calculate the BCWS, BCWP, and ACWP fields in the
Project DB? We would like to use the forumlas and apply
them to the clients own custom fields and add additional
qualifiers/constraints.

 

[Jan De Messemaeker]

Hi,

As foyour first question: it is not possible to show any custom foields
timephased, sorry.
HTH

 

[John]

I'm working with a client that is tracking Earned value in
terms of labor hours and they would like to track some EV
metrics in a time-phased view (such as the Task Usage).

The fields they are using are custom fields [Number 18-20]
for the labor hours but they are only at a single point in
time. We need to show these fields in a timephased view
and be able to cut/paste or extract to Excel.

Is it possible to easily capture timephased information
for custom fields? Where in the schema is this data
stored and can it be displayed in Project using native
functionality or will this require VBA or special formulas?

Is it possible to get the actual formulas that Microsoft
uses to calculate the BCWS, BCWP, and ACWP fields in the
Project DB? We would like to use the forumlas and apply
them to the clients own custom fields and add additional
qualifiers/constraints.

Brent,
"Easy" is a relative term. The short of it is that spare fields are not
timescaled by Project. Therefore in order to get timephased data for
these fields, you need to generate it with an algorithm. The algorithm
may need to spread the static data over the task Duration or via some
other means. If resource assignments are not contoured, the relatioship
is linear. If contouring is involved, it gets a little more interesting.

I don't know if the EV formulas are available in the Project DB but
there is nothing magic about them. They are the standard EV definitions.

The bottom line - it can be done but it will require VBA.

Hope this helps.
John
Project MVP

 

[JackD]

As noted. Custom fields are not timephased and can not be made to be
timephased.
You can add tables to a project database, and I believe it is "possible" to
add additional fields to the existing tables (AFTER all the preexisting
fields) so yes, you might be able to develop some sort of solution, but it
would be quite involved and kludgy.

The documentation for EV calcs. is in the project help. Just look for
"Earned Value" and you should be able to find them.

Note: No calculation takes place in the project database. All calculation
takes place in the project application which then writes the results to the
database when the file is saved. The database just stores the data.