TimeScaleData method in MOPS?

[Kevin Slane]

I'm trying to convert an existing mpp file, with its associated macros, into
something that can be done on Project Server. So far, I've managed to create
all the fields that were done via macros into custom fields on the server.
The one thing I'm left with is where the author of this file used the
TimeScaleData method to calculate a custom field for BQWS.

Is it possible to have an enterprise custom field that does this same
calculation? It's essentially the sum of hours between the baseline start
date and the status date.

Kevin

 

[Kevin Slane]

I should note, Andrew helped me a great deal in the "developer" forum on a
very much related topic, but I thought I should post this question here as it
relates strictly to server. My apologies if this is an inappropriate cross
post.

 

[Rod Gill]

I think that's already calculated for you in the BCWS field? Lookup help on
it, it's one of the earned value fields.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

I should note, Andrew helped me a great deal in the "developer" forum on a
very much related topic, but I thought I should post this question here as
it
relates strictly to server. My apologies if this is an inappropriate
cross
post.



__________ Information from ESET Smart Security, version of virus
signature database 5005 (20100406) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5005 (20100406) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Kevin Slane]

BCWS gives me cost data. This field is already in use elsewhere. However,
what she's looking for here is BQWS which is quantity in hours.

Kevin

 

[Rod Gill]

Your only option is if cost is from resource hours only. Divide BCWS by rate
to get number of hours.

For projects where cost data is calculated outside project, set resource
rates to $1/hr then BXWS is number of hours.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

BCWS gives me cost data. This field is already in use elsewhere.
However,
what she's looking for here is BQWS which is quantity in hours.

Kevin



__________ Information from ESET Smart Security, version of virus
signature database 5011 (20100408) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5011 (20100408) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Kevin Slane]

Thanks Rod. I have to admit, in the EVM training I've received, BQWS is not
mentioned anywhere. The macro that is in the mpp file she gave me calculates
BQWS by looping over the results of the TimeScaleData method (for tasks) and
sums the hours for each day between [Baseline Start] and [Status Date].

So, I'm anxious to try your method. It sounds right though. MSP is already
doing the calc for BCWS for me. Dividing by the rate should work. Thanks!

 

[Gary L. Chefetz]

Kevin:

There are many idiosyncrasies in the way Project handles EVA calculations,
which generally map to scheduling idiosyncrasies. If you need to achieve
auditable compliance standards of some sort using this tool, I suggest that
you get available outside help with understanding the exceptions and how to
work around them to meet your requirements.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

Thanks Rod. I have to admit, in the EVM training I've received, BQWS is
not
mentioned anywhere. The macro that is in the mpp file she gave me
calculates
BQWS by looping over the results of the TimeScaleData method (for tasks)
and
sums the hours for each day between [Baseline Start] and [Status Date].

So, I'm anxious to try your method. It sounds right though. MSP is
already
doing the calc for BCWS for me. Dividing by the rate should work.
Thanks!

Your only option is if cost is from resource hours only. Divide BCWS by
rate
to get number of hours.

For projects where cost data is calculated outside project, set resource
rates to $1/hr then BXWS is number of hours.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see:
http://www.projectvbabook.com






__________ Information from ESET Smart Security, version of virus
signature database 5011 (20100408) __________

The message was checked by ESET Smart Security.

http://www.eset.com



.